{"store_code":"","client_code":"","source":".Net SqlClient Data Provider","message":"Invalid object name 'cPOS_SALES_DATA..ApiConfiguration'.","method":"","class_name":"16","line_number":"9","time":"2025-09-13 09:57:35","error_code":"208","procedure":"SP_VALIDATE_API_KEY","server":"192.168.0.245,1546","stack_trace":"at BPPI.CPOS.DAL.APIHelper.ValidateAPIKey(Int32 APIId, String APIKey) in E:\\GitProjectWork\\Dava India\\CPOS\\Web_ApiDotNet_WorkOnthis\\ZOTA.CPOS.DAL\\SqlHelperDbSalesData.cs:line 183\r\n at BPPI.CPOS.API.Controllers.StoreController.d__40.MoveNext() in E:\\GitProjectWork\\Dava India\\CPOS\\Web_ApiDotNet_WorkOnthis\\ZOTA.CPOS.API\\Controllers\\StoreController.cs:line 798","priority":"medium","version_no":null,"app_version_no":null,"reccurence_count":1} , {"store_code":"","client_code":"","source":"","message":"Data Not Found. SyncId:40","method":"","class_name":"","line_number":"","time":"2025-09-13 10:02:19","error_code":"","procedure":"","server":"","stack_trace":"","priority":"","version_no":null,"app_version_no":null,"reccurence_count":1} , {"store_code":"","client_code":"","source":".Net SqlClient Data Provider","message":"Invalid object name 'cPOS_SALES_DATA..ApiConfiguration'.","method":"","class_name":"16","line_number":"9","time":"2025-09-13 11:52:15","error_code":"208","procedure":"SP_VALIDATE_API_KEY","server":"192.168.0.245,1546","stack_trace":"at BPPI.CPOS.DAL.APIHelper.ValidateAPIKey(Int32 APIId, String APIKey) in E:\\GitProjectWork\\Dava India\\CPOS\\Web_ApiDotNet_WorkOnthis\\ZOTA.CPOS.DAL\\SqlHelperDbSalesData.cs:line 183\r\n at BPPI.CPOS.API.Controllers.StoreController.d__40.MoveNext() in E:\\GitProjectWork\\Dava India\\CPOS\\Web_ApiDotNet_WorkOnthis\\ZOTA.CPOS.API\\Controllers\\StoreController.cs:line 798","priority":"medium","version_no":null,"app_version_no":null,"reccurence_count":1} , {"store_code":"","client_code":"","source":"","message":"Data Not Found. SyncId:40","method":"","class_name":"","line_number":"","time":"2025-09-13 14:17:22","error_code":"","procedure":"","server":"","stack_trace":"","priority":"","version_no":null,"app_version_no":null,"reccurence_count":1} , {"store_code":"","client_code":"","source":".Net SqlClient Data Provider","message":"Must declare the scalar variable \"@HOCode\".\r\nIncorrect syntax near 'X'.\r\nInvalid object name '##TEMP_PO_DATA_1'.\r\n\r\n\t-----~~~~ START Nishita 08-07-2025\r\n\t;WITH ErrorStatus AS (SELECT \r\n\t\tPo_Id,\r\n\t\tMAX(CONCAT('Retry Count= ',RetryCount,' , ','Error Message= ', ErrorMsg)) AS [Status] \r\n\t\tFROM PoErrorLog\r\n\t\tGROUP BY Po_Id)\r\n\t------~~~ END \r\n\t\tSELECT\tPH.PO_Store_Code AS po_Store_Code,\r\n\t\t\t\tCOUNT(*) AS itemCount,\r\n\t\t\t\t/*~~~~~~~ Nidhi 21/06/2024 GID:837 ~~~~~ */\r\n\t\t\t\tSD.category,\r\n\t\t\t\t/*~~~~~~~ GID:837 ~~~~~ */\r\n\t\t\t\tSD.Store_Name,\r\n\t\t\t\tSD.State AS state,\r\n\t\t\t\t/* GID: #1301\r\n\t\t\t\tDeveloper: Nishita Roy\r\n\t\t\t\tSummary\t : US: CPOS: Display Full Document Number Format in CPOS Reports\r\n\t\t\t\tDate : 22-08-2025*/\r\n\t\t\t\t--PH.PO_NO AS po_No,\r\n\t\t\t\tPO_No_new AS po_No,\r\n\t\t\t\t/* GID: #1301 END */\r\n\t\t\t CAST(PH.Po_No AS VARCHAR(25)) + '_' + ISNULL(CAST(PH.warehouseId AS VARCHAR(25)),1) AS po_No_Split,----~~~ Gid :#1156 Nidhi 04-04-2025\r\n\t\t\t\t--FORMAT(PH.PO_Date,'dd/MM/yyyy') AS po_Date,\r\n\t\t\t\t--ISNULL(CASE WHEN CAST(Po_UpdatedDt AS DATE) = '1900/01/01' THEN NULL ELSE FORMAT(CAST(Po_UpdatedDt AS DATE),'dd/MM/yyyy') END, FORMAT(CAST(Po_CreatedDt AS DATE),'dd/MM/yyyy')) AS approveDate,\r\n\t\t\t\t--ISNULL(CAST(Po_UpdatedDt AS DATE), CAST(Po_CreatedDt AS DATE)) AS approveDate,\r\n\t\t\t\t--ISNULL(CASE WHEN YEAR(Po_UpdatedDt) = 1900 THEN NULL ELSE CAST(Po_UpdatedDt AS DATE) END, CAST(Po_CreatedDt AS DATE)) AS approveDate,\r\n\t\t\t\t--FORMAT(PH.Po_SyncDate,'dd/MM/yyyy') Po_SyncDate,\r\n\t\t\t\t--PH.Po_SyncDate Po_SyncDate,\r\n\t\t\t\t--CASE WHEN ISNULL(CAST(Po_UpdatedDt AS DATE), CAST(Po_CreatedDt AS DATE)) > CAST(PH.Po_SyncDate AS date) THEN ISNULL(CAST(Po_UpdatedDt AS DATE), CAST(Po_CreatedDt AS DATE)) ELSE CAST(PH.Po_SyncDate AS date) END Po_SyncDate,\r\n\t\t\t\tPH.PO_Date AS po_Date,\r\n\t\t\t\t-----~~~~~~~ Start #711 Nidhi 09/04/2024 ~~~~~~~----\r\n\t\t\t\t--DateOfApprovedOrReject AS approveDate,\t\t\t\r\n\t\t\t\t CONVERT(VARCHAR(30), PH.DateOfApprovedOrReject , 120) as DateOfApprovedOrReject,\t\t\t\r\n\t\t\t -- CASE WHEN CAST(DateOfApprovedOrReject AS date) > CAST(PH.Po_SyncDate AS date) THEN CAST(DateOfApprovedOrReject AS date) ELSE CAST(PH.Po_SyncDate AS date) END Po_SyncDate,\r\n\t\t\t\tCASE WHEN CAST(PH.DateOfApprovedOrReject AS date) > CAST(PH.Po_SyncDate AS date) THEN CONVERT(VARCHAR(30), PH.DateOfApprovedOrReject , 120) ELSE CONVERT(VARCHAR(30), PH.Po_SyncDate , 120) END Po_SyncDate,\r\n\t\t\t\t-----~~~~~~~ End #711 Nidhi 09/04/2024 ~~~~~~~----\r\n\t\t\t\tISNULL(PH.Po_TotVal,0) AS TotalAmount,\r\n\t\t\t\tISNULL(G.CreditLimit,0) AS CreditLimit,\r\n\t\t\t\tISNULL(G.Pod_Amount,0) AS OutstandingAmount,\r\n\t\t\t\t--ISNULL(PH.StatusMarkAs,0) AS statusMarkAs,\r\n\t\t\t --\tCASE WHEN ISNULL(PH.statusMarkAs,0) = 0 THEN 'unApproved' WHEN ISNULL(PH.statusMarkAs,0) = 1 THEN 'approved' WHEN ISNULL(PH.statusMarkAs,0) = 2 THEN 'rejected' WHEN ISNULL(PH.statusMarkAs,0) = 3 THEN 'dispatched' WHEN ISNULL(PH.statusMarkAs,0) = 4 THEN 'hold' END statusMarkAs,\r\n\t\t\t\t ISNULL(ST.Status,'') AS statusMarkAs, ----- Gid :#14 Nidhi 30-05-2025\r\n\t\t\t\t--FORMAT(CAST(ISNULL(PH.Po_CreatedDt,PH.Po_UpdatedDt) AS DATE),'dd/MM/yyyy') AS dateOfApprovedOrReject,\r\n\t\t\t\t--CAST(ISNULL(PH.Po_CreatedDt,PH.Po_UpdatedDt) AS DATE) AS dateOfApprovedOrReject,\r\n\t\t\t\t-----~~~~~~~ Start #711 Nidhi 09/04/2024 ~~~~~~~-\r\n\t\t\t\t--CAST(DateOfApprovedOrReject AS date) AS dateOfApprovedOrReject,\r\n\t\t\t\tCAST(PH.DateOfApprovedOrReject AS date) AS dateOfApprovedOrRejectupdate,\r\n\t\t\t\t-----~~~~~~~ End #711 Nidhi 09/04/2024 ~~~~~~~-\r\n\t\t\t\tPH.Po_Sales_Order_No,\r\n\t\t\t\tsd.store_Contact_Person,\r\n\t\t\t\tsd.Mobile_No,\r\n\t\t\t\tSD.email_ID,\r\n\t\t\t\tISNULL(PH.Remark,'') AS Remark,\r\n\t\t\t\t(D.FirstName + ' ' + ISNULL(D.LastName,'')) AS ApprovedBy,\r\n\t\t\t\t--CASE WHEN PH.Po_VendorCode = 'HGJSUR0222' THEN ISNULL(SIHH.Sih_No,0) ELSE ISNULL(SIH.Sih_No,0) END AS sih_No,\r\n\t\t\t\t--CASE WHEN PH.Po_VendorCode = 'HGJSUR0222' THEN ISNULL(SIHH.Sih_refNo,0) ELSE\r\n\t\t\t\tCASE WHEN PH.Po_VendorCode = @HOCode THEN ISNULL(SIHH.Sih_refNo,0) ELSE\r\n\t\t\t\tCASE WHEN ISNULL(SIH.Sih_No_New, '') <> '' THEN SIH.Sih_No_New\r\n\t\t\t\t\t WHEN ISNULL(SIH.Sih_No_New, '') = '' THEN CAST(ISNULL(SIH.Sih_No,0) AS VARCHAR)END \r\n\t\t\t\tEND AS sih_No,---- Nidhi 14-08-2024 GID.: #897\r\n\t\t\t\tPH.Id,\r\n\t\t\t\tP\r\nSELECT *, TotalRecord = COUNT(1) OVER(), SumTotalAmount = CAST(SUM(TotalAmount) OVER() AS DECIMAL)\r\n\t\tFROM ##TEMP_PO_DATA_1 ORDER BY PO_Store_Code\r\n\t\tOFFSET @PageSize * (@PageNumber - 1) ROWS\r\n\t\tFETCH NEXT @PageSize ROWS ONLY;","method":"","class_name":"15","line_number":"58","time":"2025-09-13 15:01:12","error_code":"137","procedure":"","server":"192.168.0.245,1546","stack_trace":"at Ethics.HelperModules.DataContext.SqlDapperHelper.d__17`1.MoveNext()\r\n--- End of stack trace from previous location where exception was thrown ---\r\n at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()\r\n at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)\r\n at System.Runtime.CompilerServices.TaskAwaiter`1.GetResult()\r\n at BPPI.CPOS.BAL.Common.CommonRepositories.d__20.MoveNext() in E:\\GitProjectWork\\Dava India\\CPOS\\Web_ApiDotNet_WorkOnthis\\ZOTA.CPOS.BAL\\Common\\CommonRepositories.cs:line 433\r\n--- End of stack trace from previous location where exception was thrown ---\r\n at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()\r\n at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)\r\n at System.Runtime.CompilerServices.TaskAwaiter`1.GetResult()\r\n at BPPI.CPOS.API.Controllers.CommonController.d__3.MoveNext() in E:\\GitProjectWork\\Dava India\\CPOS\\Web_ApiDotNet_WorkOnthis\\ZOTA.CPOS.API\\Controllers\\CommonController.cs:line 72","priority":"medium","version_no":null,"app_version_no":null,"reccurence_count":1} , {"store_code":"","client_code":"","source":".Net SqlClient Data Provider","message":"Must declare the scalar variable \"@HOCode\".\r\nIncorrect syntax near 'X'.\r\nInvalid object name '##TEMP_PO_DATA_1'.\r\n\r\n\t-----~~~~ START Nishita 08-07-2025\r\n\t;WITH ErrorStatus AS (SELECT \r\n\t\tPo_Id,\r\n\t\tMAX(CONCAT('Retry Count= ',RetryCount,' , ','Error Message= ', ErrorMsg)) AS [Status] \r\n\t\tFROM PoErrorLog\r\n\t\tGROUP BY Po_Id)\r\n\t------~~~ END \r\n\t\tSELECT\tPH.PO_Store_Code AS po_Store_Code,\r\n\t\t\t\tCOUNT(*) AS itemCount,\r\n\t\t\t\t/*~~~~~~~ Nidhi 21/06/2024 GID:837 ~~~~~ */\r\n\t\t\t\tSD.category,\r\n\t\t\t\t/*~~~~~~~ GID:837 ~~~~~ */\r\n\t\t\t\tSD.Store_Name,\r\n\t\t\t\tSD.State AS state,\r\n\t\t\t\t/* GID: #1301\r\n\t\t\t\tDeveloper: Nishita Roy\r\n\t\t\t\tSummary\t : US: CPOS: Display Full Document Number Format in CPOS Reports\r\n\t\t\t\tDate : 22-08-2025*/\r\n\t\t\t\t--PH.PO_NO AS po_No,\r\n\t\t\t\tPO_No_new AS po_No,\r\n\t\t\t\t/* GID: #1301 END */\r\n\t\t\t CAST(PH.Po_No AS VARCHAR(25)) + '_' + ISNULL(CAST(PH.warehouseId AS VARCHAR(25)),1) AS po_No_Split,----~~~ Gid :#1156 Nidhi 04-04-2025\r\n\t\t\t\t--FORMAT(PH.PO_Date,'dd/MM/yyyy') AS po_Date,\r\n\t\t\t\t--ISNULL(CASE WHEN CAST(Po_UpdatedDt AS DATE) = '1900/01/01' THEN NULL ELSE FORMAT(CAST(Po_UpdatedDt AS DATE),'dd/MM/yyyy') END, FORMAT(CAST(Po_CreatedDt AS DATE),'dd/MM/yyyy')) AS approveDate,\r\n\t\t\t\t--ISNULL(CAST(Po_UpdatedDt AS DATE), CAST(Po_CreatedDt AS DATE)) AS approveDate,\r\n\t\t\t\t--ISNULL(CASE WHEN YEAR(Po_UpdatedDt) = 1900 THEN NULL ELSE CAST(Po_UpdatedDt AS DATE) END, CAST(Po_CreatedDt AS DATE)) AS approveDate,\r\n\t\t\t\t--FORMAT(PH.Po_SyncDate,'dd/MM/yyyy') Po_SyncDate,\r\n\t\t\t\t--PH.Po_SyncDate Po_SyncDate,\r\n\t\t\t\t--CASE WHEN ISNULL(CAST(Po_UpdatedDt AS DATE), CAST(Po_CreatedDt AS DATE)) > CAST(PH.Po_SyncDate AS date) THEN ISNULL(CAST(Po_UpdatedDt AS DATE), CAST(Po_CreatedDt AS DATE)) ELSE CAST(PH.Po_SyncDate AS date) END Po_SyncDate,\r\n\t\t\t\tPH.PO_Date AS po_Date,\r\n\t\t\t\t-----~~~~~~~ Start #711 Nidhi 09/04/2024 ~~~~~~~----\r\n\t\t\t\t--DateOfApprovedOrReject AS approveDate,\t\t\t\r\n\t\t\t\t CONVERT(VARCHAR(30), PH.DateOfApprovedOrReject , 120) as DateOfApprovedOrReject,\t\t\t\r\n\t\t\t -- CASE WHEN CAST(DateOfApprovedOrReject AS date) > CAST(PH.Po_SyncDate AS date) THEN CAST(DateOfApprovedOrReject AS date) ELSE CAST(PH.Po_SyncDate AS date) END Po_SyncDate,\r\n\t\t\t\tCASE WHEN CAST(PH.DateOfApprovedOrReject AS date) > CAST(PH.Po_SyncDate AS date) THEN CONVERT(VARCHAR(30), PH.DateOfApprovedOrReject , 120) ELSE CONVERT(VARCHAR(30), PH.Po_SyncDate , 120) END Po_SyncDate,\r\n\t\t\t\t-----~~~~~~~ End #711 Nidhi 09/04/2024 ~~~~~~~----\r\n\t\t\t\tISNULL(PH.Po_TotVal,0) AS TotalAmount,\r\n\t\t\t\tISNULL(G.CreditLimit,0) AS CreditLimit,\r\n\t\t\t\tISNULL(G.Pod_Amount,0) AS OutstandingAmount,\r\n\t\t\t\t--ISNULL(PH.StatusMarkAs,0) AS statusMarkAs,\r\n\t\t\t --\tCASE WHEN ISNULL(PH.statusMarkAs,0) = 0 THEN 'unApproved' WHEN ISNULL(PH.statusMarkAs,0) = 1 THEN 'approved' WHEN ISNULL(PH.statusMarkAs,0) = 2 THEN 'rejected' WHEN ISNULL(PH.statusMarkAs,0) = 3 THEN 'dispatched' WHEN ISNULL(PH.statusMarkAs,0) = 4 THEN 'hold' END statusMarkAs,\r\n\t\t\t\t ISNULL(ST.Status,'') AS statusMarkAs, ----- Gid :#14 Nidhi 30-05-2025\r\n\t\t\t\t--FORMAT(CAST(ISNULL(PH.Po_CreatedDt,PH.Po_UpdatedDt) AS DATE),'dd/MM/yyyy') AS dateOfApprovedOrReject,\r\n\t\t\t\t--CAST(ISNULL(PH.Po_CreatedDt,PH.Po_UpdatedDt) AS DATE) AS dateOfApprovedOrReject,\r\n\t\t\t\t-----~~~~~~~ Start #711 Nidhi 09/04/2024 ~~~~~~~-\r\n\t\t\t\t--CAST(DateOfApprovedOrReject AS date) AS dateOfApprovedOrReject,\r\n\t\t\t\tCAST(PH.DateOfApprovedOrReject AS date) AS dateOfApprovedOrRejectupdate,\r\n\t\t\t\t-----~~~~~~~ End #711 Nidhi 09/04/2024 ~~~~~~~-\r\n\t\t\t\tPH.Po_Sales_Order_No,\r\n\t\t\t\tsd.store_Contact_Person,\r\n\t\t\t\tsd.Mobile_No,\r\n\t\t\t\tSD.email_ID,\r\n\t\t\t\tISNULL(PH.Remark,'') AS Remark,\r\n\t\t\t\t(D.FirstName + ' ' + ISNULL(D.LastName,'')) AS ApprovedBy,\r\n\t\t\t\t--CASE WHEN PH.Po_VendorCode = 'HGJSUR0222' THEN ISNULL(SIHH.Sih_No,0) ELSE ISNULL(SIH.Sih_No,0) END AS sih_No,\r\n\t\t\t\t--CASE WHEN PH.Po_VendorCode = 'HGJSUR0222' THEN ISNULL(SIHH.Sih_refNo,0) ELSE\r\n\t\t\t\tCASE WHEN PH.Po_VendorCode = @HOCode THEN ISNULL(SIHH.Sih_refNo,0) ELSE\r\n\t\t\t\tCASE WHEN ISNULL(SIH.Sih_No_New, '') <> '' THEN SIH.Sih_No_New\r\n\t\t\t\t\t WHEN ISNULL(SIH.Sih_No_New, '') = '' THEN CAST(ISNULL(SIH.Sih_No,0) AS VARCHAR)END \r\n\t\t\t\tEND AS sih_No,---- Nidhi 14-08-2024 GID.: #897\r\n\t\t\t\tPH.Id,\r\n\t\t\t\tP\r\nSELECT *, TotalRecord = COUNT(1) OVER(), SumTotalAmount = CAST(SUM(TotalAmount) OVER() AS DECIMAL)\r\n\t\tFROM ##TEMP_PO_DATA_1 ORDER BY PO_Store_Code\r\n\t\tOFFSET @PageSize * (@PageNumber - 1) ROWS\r\n\t\tFETCH NEXT @PageSize ROWS ONLY;","method":"","class_name":"15","line_number":"58","time":"2025-09-13 15:01:48","error_code":"137","procedure":"","server":"192.168.0.245,1546","stack_trace":"at Ethics.HelperModules.DataContext.SqlDapperHelper.d__17`1.MoveNext()\r\n--- End of stack trace from previous location where exception was thrown ---\r\n at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()\r\n at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)\r\n at System.Runtime.CompilerServices.TaskAwaiter`1.GetResult()\r\n at BPPI.CPOS.BAL.Common.CommonRepositories.d__20.MoveNext() in E:\\GitProjectWork\\Dava India\\CPOS\\Web_ApiDotNet_WorkOnthis\\ZOTA.CPOS.BAL\\Common\\CommonRepositories.cs:line 433\r\n--- End of stack trace from previous location where exception was thrown ---\r\n at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()\r\n at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)\r\n at System.Runtime.CompilerServices.TaskAwaiter`1.GetResult()\r\n at BPPI.CPOS.API.Controllers.CommonController.d__3.MoveNext() in E:\\GitProjectWork\\Dava India\\CPOS\\Web_ApiDotNet_WorkOnthis\\ZOTA.CPOS.API\\Controllers\\CommonController.cs:line 72","priority":"medium","version_no":null,"app_version_no":null,"reccurence_count":1} , {"store_code":"","client_code":"","source":".Net SqlClient Data Provider","message":"Must declare the scalar variable \"@HOCode\".\r\nIncorrect syntax near 'X'.\r\nInvalid object name '##TEMP_PO_DATA_1'.\r\n\r\n\t-----~~~~ START Nishita 08-07-2025\r\n\t;WITH ErrorStatus AS (SELECT \r\n\t\tPo_Id,\r\n\t\tMAX(CONCAT('Retry Count= ',RetryCount,' , ','Error Message= ', ErrorMsg)) AS [Status] \r\n\t\tFROM PoErrorLog\r\n\t\tGROUP BY Po_Id)\r\n\t------~~~ END \r\n\t\tSELECT\tPH.PO_Store_Code AS po_Store_Code,\r\n\t\t\t\tCOUNT(*) AS itemCount,\r\n\t\t\t\t/*~~~~~~~ Nidhi 21/06/2024 GID:837 ~~~~~ */\r\n\t\t\t\tSD.category,\r\n\t\t\t\t/*~~~~~~~ GID:837 ~~~~~ */\r\n\t\t\t\tSD.Store_Name,\r\n\t\t\t\tSD.State AS state,\r\n\t\t\t\t/* GID: #1301\r\n\t\t\t\tDeveloper: Nishita Roy\r\n\t\t\t\tSummary\t : US: CPOS: Display Full Document Number Format in CPOS Reports\r\n\t\t\t\tDate : 22-08-2025*/\r\n\t\t\t\t--PH.PO_NO AS po_No,\r\n\t\t\t\tPO_No_new AS po_No,\r\n\t\t\t\t/* GID: #1301 END */\r\n\t\t\t CAST(PH.Po_No AS VARCHAR(25)) + '_' + ISNULL(CAST(PH.warehouseId AS VARCHAR(25)),1) AS po_No_Split,----~~~ Gid :#1156 Nidhi 04-04-2025\r\n\t\t\t\t--FORMAT(PH.PO_Date,'dd/MM/yyyy') AS po_Date,\r\n\t\t\t\t--ISNULL(CASE WHEN CAST(Po_UpdatedDt AS DATE) = '1900/01/01' THEN NULL ELSE FORMAT(CAST(Po_UpdatedDt AS DATE),'dd/MM/yyyy') END, FORMAT(CAST(Po_CreatedDt AS DATE),'dd/MM/yyyy')) AS approveDate,\r\n\t\t\t\t--ISNULL(CAST(Po_UpdatedDt AS DATE), CAST(Po_CreatedDt AS DATE)) AS approveDate,\r\n\t\t\t\t--ISNULL(CASE WHEN YEAR(Po_UpdatedDt) = 1900 THEN NULL ELSE CAST(Po_UpdatedDt AS DATE) END, CAST(Po_CreatedDt AS DATE)) AS approveDate,\r\n\t\t\t\t--FORMAT(PH.Po_SyncDate,'dd/MM/yyyy') Po_SyncDate,\r\n\t\t\t\t--PH.Po_SyncDate Po_SyncDate,\r\n\t\t\t\t--CASE WHEN ISNULL(CAST(Po_UpdatedDt AS DATE), CAST(Po_CreatedDt AS DATE)) > CAST(PH.Po_SyncDate AS date) THEN ISNULL(CAST(Po_UpdatedDt AS DATE), CAST(Po_CreatedDt AS DATE)) ELSE CAST(PH.Po_SyncDate AS date) END Po_SyncDate,\r\n\t\t\t\tPH.PO_Date AS po_Date,\r\n\t\t\t\t-----~~~~~~~ Start #711 Nidhi 09/04/2024 ~~~~~~~----\r\n\t\t\t\t--DateOfApprovedOrReject AS approveDate,\t\t\t\r\n\t\t\t\t CONVERT(VARCHAR(30), PH.DateOfApprovedOrReject , 120) as DateOfApprovedOrReject,\t\t\t\r\n\t\t\t -- CASE WHEN CAST(DateOfApprovedOrReject AS date) > CAST(PH.Po_SyncDate AS date) THEN CAST(DateOfApprovedOrReject AS date) ELSE CAST(PH.Po_SyncDate AS date) END Po_SyncDate,\r\n\t\t\t\tCASE WHEN CAST(PH.DateOfApprovedOrReject AS date) > CAST(PH.Po_SyncDate AS date) THEN CONVERT(VARCHAR(30), PH.DateOfApprovedOrReject , 120) ELSE CONVERT(VARCHAR(30), PH.Po_SyncDate , 120) END Po_SyncDate,\r\n\t\t\t\t-----~~~~~~~ End #711 Nidhi 09/04/2024 ~~~~~~~----\r\n\t\t\t\tISNULL(PH.Po_TotVal,0) AS TotalAmount,\r\n\t\t\t\tISNULL(G.CreditLimit,0) AS CreditLimit,\r\n\t\t\t\tISNULL(G.Pod_Amount,0) AS OutstandingAmount,\r\n\t\t\t\t--ISNULL(PH.StatusMarkAs,0) AS statusMarkAs,\r\n\t\t\t --\tCASE WHEN ISNULL(PH.statusMarkAs,0) = 0 THEN 'unApproved' WHEN ISNULL(PH.statusMarkAs,0) = 1 THEN 'approved' WHEN ISNULL(PH.statusMarkAs,0) = 2 THEN 'rejected' WHEN ISNULL(PH.statusMarkAs,0) = 3 THEN 'dispatched' WHEN ISNULL(PH.statusMarkAs,0) = 4 THEN 'hold' END statusMarkAs,\r\n\t\t\t\t ISNULL(ST.Status,'') AS statusMarkAs, ----- Gid :#14 Nidhi 30-05-2025\r\n\t\t\t\t--FORMAT(CAST(ISNULL(PH.Po_CreatedDt,PH.Po_UpdatedDt) AS DATE),'dd/MM/yyyy') AS dateOfApprovedOrReject,\r\n\t\t\t\t--CAST(ISNULL(PH.Po_CreatedDt,PH.Po_UpdatedDt) AS DATE) AS dateOfApprovedOrReject,\r\n\t\t\t\t-----~~~~~~~ Start #711 Nidhi 09/04/2024 ~~~~~~~-\r\n\t\t\t\t--CAST(DateOfApprovedOrReject AS date) AS dateOfApprovedOrReject,\r\n\t\t\t\tCAST(PH.DateOfApprovedOrReject AS date) AS dateOfApprovedOrRejectupdate,\r\n\t\t\t\t-----~~~~~~~ End #711 Nidhi 09/04/2024 ~~~~~~~-\r\n\t\t\t\tPH.Po_Sales_Order_No,\r\n\t\t\t\tsd.store_Contact_Person,\r\n\t\t\t\tsd.Mobile_No,\r\n\t\t\t\tSD.email_ID,\r\n\t\t\t\tISNULL(PH.Remark,'') AS Remark,\r\n\t\t\t\t(D.FirstName + ' ' + ISNULL(D.LastName,'')) AS ApprovedBy,\r\n\t\t\t\t--CASE WHEN PH.Po_VendorCode = 'HGJSUR0222' THEN ISNULL(SIHH.Sih_No,0) ELSE ISNULL(SIH.Sih_No,0) END AS sih_No,\r\n\t\t\t\t--CASE WHEN PH.Po_VendorCode = 'HGJSUR0222' THEN ISNULL(SIHH.Sih_refNo,0) ELSE\r\n\t\t\t\tCASE WHEN PH.Po_VendorCode = @HOCode THEN ISNULL(SIHH.Sih_refNo,0) ELSE\r\n\t\t\t\tCASE WHEN ISNULL(SIH.Sih_No_New, '') <> '' THEN SIH.Sih_No_New\r\n\t\t\t\t\t WHEN ISNULL(SIH.Sih_No_New, '') = '' THEN CAST(ISNULL(SIH.Sih_No,0) AS VARCHAR)END \r\n\t\t\t\tEND AS sih_No,---- Nidhi 14-08-2024 GID.: #897\r\n\t\t\t\tPH.Id,\r\n\t\t\t\tP\r\nSELECT *, TotalRecord = COUNT(1) OVER(), SumTotalAmount = CAST(SUM(TotalAmount) OVER() AS DECIMAL)\r\n\t\tFROM ##TEMP_PO_DATA_1 ORDER BY PO_Store_Code\r\n\t\tOFFSET @PageSize * (@PageNumber - 1) ROWS\r\n\t\tFETCH NEXT @PageSize ROWS ONLY;","method":"","class_name":"15","line_number":"58","time":"2025-09-13 15:01:56","error_code":"137","procedure":"","server":"192.168.0.245,1546","stack_trace":"at Ethics.HelperModules.DataContext.SqlDapperHelper.d__17`1.MoveNext()\r\n--- End of stack trace from previous location where exception was thrown ---\r\n at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()\r\n at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)\r\n at System.Runtime.CompilerServices.TaskAwaiter`1.GetResult()\r\n at BPPI.CPOS.BAL.Common.CommonRepositories.d__20.MoveNext() in E:\\GitProjectWork\\Dava India\\CPOS\\Web_ApiDotNet_WorkOnthis\\ZOTA.CPOS.BAL\\Common\\CommonRepositories.cs:line 433\r\n--- End of stack trace from previous location where exception was thrown ---\r\n at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()\r\n at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)\r\n at System.Runtime.CompilerServices.TaskAwaiter`1.GetResult()\r\n at BPPI.CPOS.API.Controllers.CommonController.d__3.MoveNext() in E:\\GitProjectWork\\Dava India\\CPOS\\Web_ApiDotNet_WorkOnthis\\ZOTA.CPOS.API\\Controllers\\CommonController.cs:line 72","priority":"medium","version_no":null,"app_version_no":null,"reccurence_count":1} , {"store_code":"","client_code":"","source":".Net SqlClient Data Provider","message":"Must declare the scalar variable \"@HOCode\".\r\nIncorrect syntax near 'X'.\r\nInvalid object name '##TEMP_PO_DATA_1'.\r\n\r\n\t-----~~~~ START Nishita 08-07-2025\r\n\t;WITH ErrorStatus AS (SELECT \r\n\t\tPo_Id,\r\n\t\tMAX(CONCAT('Retry Count= ',RetryCount,' , ','Error Message= ', ErrorMsg)) AS [Status] \r\n\t\tFROM PoErrorLog\r\n\t\tGROUP BY Po_Id)\r\n\t------~~~ END \r\n\t\tSELECT\tPH.PO_Store_Code AS po_Store_Code,\r\n\t\t\t\tCOUNT(*) AS itemCount,\r\n\t\t\t\t/*~~~~~~~ Nidhi 21/06/2024 GID:837 ~~~~~ */\r\n\t\t\t\tSD.category,\r\n\t\t\t\t/*~~~~~~~ GID:837 ~~~~~ */\r\n\t\t\t\tSD.Store_Name,\r\n\t\t\t\tSD.State AS state,\r\n\t\t\t\t/* GID: #1301\r\n\t\t\t\tDeveloper: Nishita Roy\r\n\t\t\t\tSummary\t : US: CPOS: Display Full Document Number Format in CPOS Reports\r\n\t\t\t\tDate : 22-08-2025*/\r\n\t\t\t\t--PH.PO_NO AS po_No,\r\n\t\t\t\tPO_No_new AS po_No,\r\n\t\t\t\t/* GID: #1301 END */\r\n\t\t\t CAST(PH.Po_No AS VARCHAR(25)) + '_' + ISNULL(CAST(PH.warehouseId AS VARCHAR(25)),1) AS po_No_Split,----~~~ Gid :#1156 Nidhi 04-04-2025\r\n\t\t\t\t--FORMAT(PH.PO_Date,'dd/MM/yyyy') AS po_Date,\r\n\t\t\t\t--ISNULL(CASE WHEN CAST(Po_UpdatedDt AS DATE) = '1900/01/01' THEN NULL ELSE FORMAT(CAST(Po_UpdatedDt AS DATE),'dd/MM/yyyy') END, FORMAT(CAST(Po_CreatedDt AS DATE),'dd/MM/yyyy')) AS approveDate,\r\n\t\t\t\t--ISNULL(CAST(Po_UpdatedDt AS DATE), CAST(Po_CreatedDt AS DATE)) AS approveDate,\r\n\t\t\t\t--ISNULL(CASE WHEN YEAR(Po_UpdatedDt) = 1900 THEN NULL ELSE CAST(Po_UpdatedDt AS DATE) END, CAST(Po_CreatedDt AS DATE)) AS approveDate,\r\n\t\t\t\t--FORMAT(PH.Po_SyncDate,'dd/MM/yyyy') Po_SyncDate,\r\n\t\t\t\t--PH.Po_SyncDate Po_SyncDate,\r\n\t\t\t\t--CASE WHEN ISNULL(CAST(Po_UpdatedDt AS DATE), CAST(Po_CreatedDt AS DATE)) > CAST(PH.Po_SyncDate AS date) THEN ISNULL(CAST(Po_UpdatedDt AS DATE), CAST(Po_CreatedDt AS DATE)) ELSE CAST(PH.Po_SyncDate AS date) END Po_SyncDate,\r\n\t\t\t\tPH.PO_Date AS po_Date,\r\n\t\t\t\t-----~~~~~~~ Start #711 Nidhi 09/04/2024 ~~~~~~~----\r\n\t\t\t\t--DateOfApprovedOrReject AS approveDate,\t\t\t\r\n\t\t\t\t CONVERT(VARCHAR(30), PH.DateOfApprovedOrReject , 120) as DateOfApprovedOrReject,\t\t\t\r\n\t\t\t -- CASE WHEN CAST(DateOfApprovedOrReject AS date) > CAST(PH.Po_SyncDate AS date) THEN CAST(DateOfApprovedOrReject AS date) ELSE CAST(PH.Po_SyncDate AS date) END Po_SyncDate,\r\n\t\t\t\tCASE WHEN CAST(PH.DateOfApprovedOrReject AS date) > CAST(PH.Po_SyncDate AS date) THEN CONVERT(VARCHAR(30), PH.DateOfApprovedOrReject , 120) ELSE CONVERT(VARCHAR(30), PH.Po_SyncDate , 120) END Po_SyncDate,\r\n\t\t\t\t-----~~~~~~~ End #711 Nidhi 09/04/2024 ~~~~~~~----\r\n\t\t\t\tISNULL(PH.Po_TotVal,0) AS TotalAmount,\r\n\t\t\t\tISNULL(G.CreditLimit,0) AS CreditLimit,\r\n\t\t\t\tISNULL(G.Pod_Amount,0) AS OutstandingAmount,\r\n\t\t\t\t--ISNULL(PH.StatusMarkAs,0) AS statusMarkAs,\r\n\t\t\t --\tCASE WHEN ISNULL(PH.statusMarkAs,0) = 0 THEN 'unApproved' WHEN ISNULL(PH.statusMarkAs,0) = 1 THEN 'approved' WHEN ISNULL(PH.statusMarkAs,0) = 2 THEN 'rejected' WHEN ISNULL(PH.statusMarkAs,0) = 3 THEN 'dispatched' WHEN ISNULL(PH.statusMarkAs,0) = 4 THEN 'hold' END statusMarkAs,\r\n\t\t\t\t ISNULL(ST.Status,'') AS statusMarkAs, ----- Gid :#14 Nidhi 30-05-2025\r\n\t\t\t\t--FORMAT(CAST(ISNULL(PH.Po_CreatedDt,PH.Po_UpdatedDt) AS DATE),'dd/MM/yyyy') AS dateOfApprovedOrReject,\r\n\t\t\t\t--CAST(ISNULL(PH.Po_CreatedDt,PH.Po_UpdatedDt) AS DATE) AS dateOfApprovedOrReject,\r\n\t\t\t\t-----~~~~~~~ Start #711 Nidhi 09/04/2024 ~~~~~~~-\r\n\t\t\t\t--CAST(DateOfApprovedOrReject AS date) AS dateOfApprovedOrReject,\r\n\t\t\t\tCAST(PH.DateOfApprovedOrReject AS date) AS dateOfApprovedOrRejectupdate,\r\n\t\t\t\t-----~~~~~~~ End #711 Nidhi 09/04/2024 ~~~~~~~-\r\n\t\t\t\tPH.Po_Sales_Order_No,\r\n\t\t\t\tsd.store_Contact_Person,\r\n\t\t\t\tsd.Mobile_No,\r\n\t\t\t\tSD.email_ID,\r\n\t\t\t\tISNULL(PH.Remark,'') AS Remark,\r\n\t\t\t\t(D.FirstName + ' ' + ISNULL(D.LastName,'')) AS ApprovedBy,\r\n\t\t\t\t--CASE WHEN PH.Po_VendorCode = 'HGJSUR0222' THEN ISNULL(SIHH.Sih_No,0) ELSE ISNULL(SIH.Sih_No,0) END AS sih_No,\r\n\t\t\t\t--CASE WHEN PH.Po_VendorCode = 'HGJSUR0222' THEN ISNULL(SIHH.Sih_refNo,0) ELSE\r\n\t\t\t\tCASE WHEN PH.Po_VendorCode = @HOCode THEN ISNULL(SIHH.Sih_refNo,0) ELSE\r\n\t\t\t\tCASE WHEN ISNULL(SIH.Sih_No_New, '') <> '' THEN SIH.Sih_No_New\r\n\t\t\t\t\t WHEN ISNULL(SIH.Sih_No_New, '') = '' THEN CAST(ISNULL(SIH.Sih_No,0) AS VARCHAR)END \r\n\t\t\t\tEND AS sih_No,---- Nidhi 14-08-2024 GID.: #897\r\n\t\t\t\tPH.Id,\r\n\t\t\t\tP\r\nSELECT *, TotalRecord = COUNT(1) OVER(), SumTotalAmount = CAST(SUM(TotalAmount) OVER() AS DECIMAL)\r\n\t\tFROM ##TEMP_PO_DATA_1 ORDER BY PO_Store_Code\r\n\t\tOFFSET @PageSize * (@PageNumber - 1) ROWS\r\n\t\tFETCH NEXT @PageSize ROWS ONLY;","method":"","class_name":"15","line_number":"58","time":"2025-09-13 15:01:57","error_code":"137","procedure":"","server":"192.168.0.245,1546","stack_trace":"at Ethics.HelperModules.DataContext.SqlDapperHelper.d__17`1.MoveNext()\r\n--- End of stack trace from previous location where exception was thrown ---\r\n at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()\r\n at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)\r\n at System.Runtime.CompilerServices.TaskAwaiter`1.GetResult()\r\n at BPPI.CPOS.BAL.Common.CommonRepositories.d__20.MoveNext() in E:\\GitProjectWork\\Dava India\\CPOS\\Web_ApiDotNet_WorkOnthis\\ZOTA.CPOS.BAL\\Common\\CommonRepositories.cs:line 433\r\n--- End of stack trace from previous location where exception was thrown ---\r\n at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()\r\n at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)\r\n at System.Runtime.CompilerServices.TaskAwaiter`1.GetResult()\r\n at BPPI.CPOS.API.Controllers.CommonController.d__3.MoveNext() in E:\\GitProjectWork\\Dava India\\CPOS\\Web_ApiDotNet_WorkOnthis\\ZOTA.CPOS.API\\Controllers\\CommonController.cs:line 72","priority":"medium","version_no":null,"app_version_no":null,"reccurence_count":1} , {"store_code":"","client_code":"","source":".Net SqlClient Data Provider","message":"Must declare the scalar variable \"@HOCode\".\r\nIncorrect syntax near 'X'.\r\nInvalid object name '##TEMP_PO_DATA_1'.\r\n\r\n\t-----~~~~ START Nishita 08-07-2025\r\n\t;WITH ErrorStatus AS (SELECT \r\n\t\tPo_Id,\r\n\t\tMAX(CONCAT('Retry Count= ',RetryCount,' , ','Error Message= ', ErrorMsg)) AS [Status] \r\n\t\tFROM PoErrorLog\r\n\t\tGROUP BY Po_Id)\r\n\t------~~~ END \r\n\t\tSELECT\tPH.PO_Store_Code AS po_Store_Code,\r\n\t\t\t\tCOUNT(*) AS itemCount,\r\n\t\t\t\t/*~~~~~~~ Nidhi 21/06/2024 GID:837 ~~~~~ */\r\n\t\t\t\tSD.category,\r\n\t\t\t\t/*~~~~~~~ GID:837 ~~~~~ */\r\n\t\t\t\tSD.Store_Name,\r\n\t\t\t\tSD.State AS state,\r\n\t\t\t\t/* GID: #1301\r\n\t\t\t\tDeveloper: Nishita Roy\r\n\t\t\t\tSummary\t : US: CPOS: Display Full Document Number Format in CPOS Reports\r\n\t\t\t\tDate : 22-08-2025*/\r\n\t\t\t\t--PH.PO_NO AS po_No,\r\n\t\t\t\tPO_No_new AS po_No,\r\n\t\t\t\t/* GID: #1301 END */\r\n\t\t\t CAST(PH.Po_No AS VARCHAR(25)) + '_' + ISNULL(CAST(PH.warehouseId AS VARCHAR(25)),1) AS po_No_Split,----~~~ Gid :#1156 Nidhi 04-04-2025\r\n\t\t\t\t--FORMAT(PH.PO_Date,'dd/MM/yyyy') AS po_Date,\r\n\t\t\t\t--ISNULL(CASE WHEN CAST(Po_UpdatedDt AS DATE) = '1900/01/01' THEN NULL ELSE FORMAT(CAST(Po_UpdatedDt AS DATE),'dd/MM/yyyy') END, FORMAT(CAST(Po_CreatedDt AS DATE),'dd/MM/yyyy')) AS approveDate,\r\n\t\t\t\t--ISNULL(CAST(Po_UpdatedDt AS DATE), CAST(Po_CreatedDt AS DATE)) AS approveDate,\r\n\t\t\t\t--ISNULL(CASE WHEN YEAR(Po_UpdatedDt) = 1900 THEN NULL ELSE CAST(Po_UpdatedDt AS DATE) END, CAST(Po_CreatedDt AS DATE)) AS approveDate,\r\n\t\t\t\t--FORMAT(PH.Po_SyncDate,'dd/MM/yyyy') Po_SyncDate,\r\n\t\t\t\t--PH.Po_SyncDate Po_SyncDate,\r\n\t\t\t\t--CASE WHEN ISNULL(CAST(Po_UpdatedDt AS DATE), CAST(Po_CreatedDt AS DATE)) > CAST(PH.Po_SyncDate AS date) THEN ISNULL(CAST(Po_UpdatedDt AS DATE), CAST(Po_CreatedDt AS DATE)) ELSE CAST(PH.Po_SyncDate AS date) END Po_SyncDate,\r\n\t\t\t\tPH.PO_Date AS po_Date,\r\n\t\t\t\t-----~~~~~~~ Start #711 Nidhi 09/04/2024 ~~~~~~~----\r\n\t\t\t\t--DateOfApprovedOrReject AS approveDate,\t\t\t\r\n\t\t\t\t CONVERT(VARCHAR(30), PH.DateOfApprovedOrReject , 120) as DateOfApprovedOrReject,\t\t\t\r\n\t\t\t -- CASE WHEN CAST(DateOfApprovedOrReject AS date) > CAST(PH.Po_SyncDate AS date) THEN CAST(DateOfApprovedOrReject AS date) ELSE CAST(PH.Po_SyncDate AS date) END Po_SyncDate,\r\n\t\t\t\tCASE WHEN CAST(PH.DateOfApprovedOrReject AS date) > CAST(PH.Po_SyncDate AS date) THEN CONVERT(VARCHAR(30), PH.DateOfApprovedOrReject , 120) ELSE CONVERT(VARCHAR(30), PH.Po_SyncDate , 120) END Po_SyncDate,\r\n\t\t\t\t-----~~~~~~~ End #711 Nidhi 09/04/2024 ~~~~~~~----\r\n\t\t\t\tISNULL(PH.Po_TotVal,0) AS TotalAmount,\r\n\t\t\t\tISNULL(G.CreditLimit,0) AS CreditLimit,\r\n\t\t\t\tISNULL(G.Pod_Amount,0) AS OutstandingAmount,\r\n\t\t\t\t--ISNULL(PH.StatusMarkAs,0) AS statusMarkAs,\r\n\t\t\t --\tCASE WHEN ISNULL(PH.statusMarkAs,0) = 0 THEN 'unApproved' WHEN ISNULL(PH.statusMarkAs,0) = 1 THEN 'approved' WHEN ISNULL(PH.statusMarkAs,0) = 2 THEN 'rejected' WHEN ISNULL(PH.statusMarkAs,0) = 3 THEN 'dispatched' WHEN ISNULL(PH.statusMarkAs,0) = 4 THEN 'hold' END statusMarkAs,\r\n\t\t\t\t ISNULL(ST.Status,'') AS statusMarkAs, ----- Gid :#14 Nidhi 30-05-2025\r\n\t\t\t\t--FORMAT(CAST(ISNULL(PH.Po_CreatedDt,PH.Po_UpdatedDt) AS DATE),'dd/MM/yyyy') AS dateOfApprovedOrReject,\r\n\t\t\t\t--CAST(ISNULL(PH.Po_CreatedDt,PH.Po_UpdatedDt) AS DATE) AS dateOfApprovedOrReject,\r\n\t\t\t\t-----~~~~~~~ Start #711 Nidhi 09/04/2024 ~~~~~~~-\r\n\t\t\t\t--CAST(DateOfApprovedOrReject AS date) AS dateOfApprovedOrReject,\r\n\t\t\t\tCAST(PH.DateOfApprovedOrReject AS date) AS dateOfApprovedOrRejectupdate,\r\n\t\t\t\t-----~~~~~~~ End #711 Nidhi 09/04/2024 ~~~~~~~-\r\n\t\t\t\tPH.Po_Sales_Order_No,\r\n\t\t\t\tsd.store_Contact_Person,\r\n\t\t\t\tsd.Mobile_No,\r\n\t\t\t\tSD.email_ID,\r\n\t\t\t\tISNULL(PH.Remark,'') AS Remark,\r\n\t\t\t\t(D.FirstName + ' ' + ISNULL(D.LastName,'')) AS ApprovedBy,\r\n\t\t\t\t--CASE WHEN PH.Po_VendorCode = 'HGJSUR0222' THEN ISNULL(SIHH.Sih_No,0) ELSE ISNULL(SIH.Sih_No,0) END AS sih_No,\r\n\t\t\t\t--CASE WHEN PH.Po_VendorCode = 'HGJSUR0222' THEN ISNULL(SIHH.Sih_refNo,0) ELSE\r\n\t\t\t\tCASE WHEN PH.Po_VendorCode = @HOCode THEN ISNULL(SIHH.Sih_refNo,0) ELSE\r\n\t\t\t\tCASE WHEN ISNULL(SIH.Sih_No_New, '') <> '' THEN SIH.Sih_No_New\r\n\t\t\t\t\t WHEN ISNULL(SIH.Sih_No_New, '') = '' THEN CAST(ISNULL(SIH.Sih_No,0) AS VARCHAR)END \r\n\t\t\t\tEND AS sih_No,---- Nidhi 14-08-2024 GID.: #897\r\n\t\t\t\tPH.Id,\r\n\t\t\t\tP\r\nSELECT *, TotalRecord = COUNT(1) OVER(), SumTotalAmount = CAST(SUM(TotalAmount) OVER() AS DECIMAL)\r\n\t\tFROM ##TEMP_PO_DATA_1 ORDER BY PO_Store_Code\r\n\t\tOFFSET @PageSize * (@PageNumber - 1) ROWS\r\n\t\tFETCH NEXT @PageSize ROWS ONLY;","method":"","class_name":"15","line_number":"58","time":"2025-09-13 15:02:12","error_code":"137","procedure":"","server":"192.168.0.245,1546","stack_trace":"at Ethics.HelperModules.DataContext.SqlDapperHelper.d__17`1.MoveNext()\r\n--- End of stack trace from previous location where exception was thrown ---\r\n at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()\r\n at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)\r\n at System.Runtime.CompilerServices.TaskAwaiter`1.GetResult()\r\n at BPPI.CPOS.BAL.Common.CommonRepositories.d__20.MoveNext() in E:\\GitProjectWork\\Dava India\\CPOS\\Web_ApiDotNet_WorkOnthis\\ZOTA.CPOS.BAL\\Common\\CommonRepositories.cs:line 433\r\n--- End of stack trace from previous location where exception was thrown ---\r\n at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()\r\n at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)\r\n at System.Runtime.CompilerServices.TaskAwaiter`1.GetResult()\r\n at BPPI.CPOS.API.Controllers.CommonController.d__3.MoveNext() in E:\\GitProjectWork\\Dava India\\CPOS\\Web_ApiDotNet_WorkOnthis\\ZOTA.CPOS.API\\Controllers\\CommonController.cs:line 72","priority":"medium","version_no":null,"app_version_no":null,"reccurence_count":1} , {"store_code":"","client_code":"","source":".Net SqlClient Data Provider","message":"Must declare the scalar variable \"@HOCode\".\r\nIncorrect syntax near 'X'.\r\nInvalid object name '##TEMP_PO_DATA_1'.\r\n\r\n\t-----~~~~ START Nishita 08-07-2025\r\n\t;WITH ErrorStatus AS (SELECT \r\n\t\tPo_Id,\r\n\t\tMAX(CONCAT('Retry Count= ',RetryCount,' , ','Error Message= ', ErrorMsg)) AS [Status] \r\n\t\tFROM PoErrorLog\r\n\t\tGROUP BY Po_Id)\r\n\t------~~~ END \r\n\t\tSELECT\tPH.PO_Store_Code AS po_Store_Code,\r\n\t\t\t\tCOUNT(*) AS itemCount,\r\n\t\t\t\t/*~~~~~~~ Nidhi 21/06/2024 GID:837 ~~~~~ */\r\n\t\t\t\tSD.category,\r\n\t\t\t\t/*~~~~~~~ GID:837 ~~~~~ */\r\n\t\t\t\tSD.Store_Name,\r\n\t\t\t\tSD.State AS state,\r\n\t\t\t\t/* GID: #1301\r\n\t\t\t\tDeveloper: Nishita Roy\r\n\t\t\t\tSummary\t : US: CPOS: Display Full Document Number Format in CPOS Reports\r\n\t\t\t\tDate : 22-08-2025*/\r\n\t\t\t\t--PH.PO_NO AS po_No,\r\n\t\t\t\tPO_No_new AS po_No,\r\n\t\t\t\t/* GID: #1301 END */\r\n\t\t\t CAST(PH.Po_No AS VARCHAR(25)) + '_' + ISNULL(CAST(PH.warehouseId AS VARCHAR(25)),1) AS po_No_Split,----~~~ Gid :#1156 Nidhi 04-04-2025\r\n\t\t\t\t--FORMAT(PH.PO_Date,'dd/MM/yyyy') AS po_Date,\r\n\t\t\t\t--ISNULL(CASE WHEN CAST(Po_UpdatedDt AS DATE) = '1900/01/01' THEN NULL ELSE FORMAT(CAST(Po_UpdatedDt AS DATE),'dd/MM/yyyy') END, FORMAT(CAST(Po_CreatedDt AS DATE),'dd/MM/yyyy')) AS approveDate,\r\n\t\t\t\t--ISNULL(CAST(Po_UpdatedDt AS DATE), CAST(Po_CreatedDt AS DATE)) AS approveDate,\r\n\t\t\t\t--ISNULL(CASE WHEN YEAR(Po_UpdatedDt) = 1900 THEN NULL ELSE CAST(Po_UpdatedDt AS DATE) END, CAST(Po_CreatedDt AS DATE)) AS approveDate,\r\n\t\t\t\t--FORMAT(PH.Po_SyncDate,'dd/MM/yyyy') Po_SyncDate,\r\n\t\t\t\t--PH.Po_SyncDate Po_SyncDate,\r\n\t\t\t\t--CASE WHEN ISNULL(CAST(Po_UpdatedDt AS DATE), CAST(Po_CreatedDt AS DATE)) > CAST(PH.Po_SyncDate AS date) THEN ISNULL(CAST(Po_UpdatedDt AS DATE), CAST(Po_CreatedDt AS DATE)) ELSE CAST(PH.Po_SyncDate AS date) END Po_SyncDate,\r\n\t\t\t\tPH.PO_Date AS po_Date,\r\n\t\t\t\t-----~~~~~~~ Start #711 Nidhi 09/04/2024 ~~~~~~~----\r\n\t\t\t\t--DateOfApprovedOrReject AS approveDate,\t\t\t\r\n\t\t\t\t CONVERT(VARCHAR(30), PH.DateOfApprovedOrReject , 120) as DateOfApprovedOrReject,\t\t\t\r\n\t\t\t -- CASE WHEN CAST(DateOfApprovedOrReject AS date) > CAST(PH.Po_SyncDate AS date) THEN CAST(DateOfApprovedOrReject AS date) ELSE CAST(PH.Po_SyncDate AS date) END Po_SyncDate,\r\n\t\t\t\tCASE WHEN CAST(PH.DateOfApprovedOrReject AS date) > CAST(PH.Po_SyncDate AS date) THEN CONVERT(VARCHAR(30), PH.DateOfApprovedOrReject , 120) ELSE CONVERT(VARCHAR(30), PH.Po_SyncDate , 120) END Po_SyncDate,\r\n\t\t\t\t-----~~~~~~~ End #711 Nidhi 09/04/2024 ~~~~~~~----\r\n\t\t\t\tISNULL(PH.Po_TotVal,0) AS TotalAmount,\r\n\t\t\t\tISNULL(G.CreditLimit,0) AS CreditLimit,\r\n\t\t\t\tISNULL(G.Pod_Amount,0) AS OutstandingAmount,\r\n\t\t\t\t--ISNULL(PH.StatusMarkAs,0) AS statusMarkAs,\r\n\t\t\t --\tCASE WHEN ISNULL(PH.statusMarkAs,0) = 0 THEN 'unApproved' WHEN ISNULL(PH.statusMarkAs,0) = 1 THEN 'approved' WHEN ISNULL(PH.statusMarkAs,0) = 2 THEN 'rejected' WHEN ISNULL(PH.statusMarkAs,0) = 3 THEN 'dispatched' WHEN ISNULL(PH.statusMarkAs,0) = 4 THEN 'hold' END statusMarkAs,\r\n\t\t\t\t ISNULL(ST.Status,'') AS statusMarkAs, ----- Gid :#14 Nidhi 30-05-2025\r\n\t\t\t\t--FORMAT(CAST(ISNULL(PH.Po_CreatedDt,PH.Po_UpdatedDt) AS DATE),'dd/MM/yyyy') AS dateOfApprovedOrReject,\r\n\t\t\t\t--CAST(ISNULL(PH.Po_CreatedDt,PH.Po_UpdatedDt) AS DATE) AS dateOfApprovedOrReject,\r\n\t\t\t\t-----~~~~~~~ Start #711 Nidhi 09/04/2024 ~~~~~~~-\r\n\t\t\t\t--CAST(DateOfApprovedOrReject AS date) AS dateOfApprovedOrReject,\r\n\t\t\t\tCAST(PH.DateOfApprovedOrReject AS date) AS dateOfApprovedOrRejectupdate,\r\n\t\t\t\t-----~~~~~~~ End #711 Nidhi 09/04/2024 ~~~~~~~-\r\n\t\t\t\tPH.Po_Sales_Order_No,\r\n\t\t\t\tsd.store_Contact_Person,\r\n\t\t\t\tsd.Mobile_No,\r\n\t\t\t\tSD.email_ID,\r\n\t\t\t\tISNULL(PH.Remark,'') AS Remark,\r\n\t\t\t\t(D.FirstName + ' ' + ISNULL(D.LastName,'')) AS ApprovedBy,\r\n\t\t\t\t--CASE WHEN PH.Po_VendorCode = 'HGJSUR0222' THEN ISNULL(SIHH.Sih_No,0) ELSE ISNULL(SIH.Sih_No,0) END AS sih_No,\r\n\t\t\t\t--CASE WHEN PH.Po_VendorCode = 'HGJSUR0222' THEN ISNULL(SIHH.Sih_refNo,0) ELSE\r\n\t\t\t\tCASE WHEN PH.Po_VendorCode = @HOCode THEN ISNULL(SIHH.Sih_refNo,0) ELSE\r\n\t\t\t\tCASE WHEN ISNULL(SIH.Sih_No_New, '') <> '' THEN SIH.Sih_No_New\r\n\t\t\t\t\t WHEN ISNULL(SIH.Sih_No_New, '') = '' THEN CAST(ISNULL(SIH.Sih_No,0) AS VARCHAR)END \r\n\t\t\t\tEND AS sih_No,---- Nidhi 14-08-2024 GID.: #897\r\n\t\t\t\tPH.Id,\r\n\t\t\t\tP\r\nSELECT *, TotalRecord = COUNT(1) OVER(), SumTotalAmount = CAST(SUM(TotalAmount) OVER() AS DECIMAL)\r\n\t\tFROM ##TEMP_PO_DATA_1 ORDER BY PO_Store_Code\r\n\t\tOFFSET @PageSize * (@PageNumber - 1) ROWS\r\n\t\tFETCH NEXT @PageSize ROWS ONLY;","method":"","class_name":"15","line_number":"58","time":"2025-09-13 15:06:55","error_code":"137","procedure":"","server":"192.168.0.245,1546","stack_trace":"at Ethics.HelperModules.DataContext.SqlDapperHelper.d__17`1.MoveNext()\r\n--- End of stack trace from previous location where exception was thrown ---\r\n at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()\r\n at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)\r\n at System.Runtime.CompilerServices.TaskAwaiter`1.GetResult()\r\n at BPPI.CPOS.BAL.Common.CommonRepositories.d__20.MoveNext() in E:\\GitProjectWork\\Dava India\\CPOS\\Web_ApiDotNet_WorkOnthis\\ZOTA.CPOS.BAL\\Common\\CommonRepositories.cs:line 433\r\n--- End of stack trace from previous location where exception was thrown ---\r\n at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()\r\n at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)\r\n at System.Runtime.CompilerServices.TaskAwaiter`1.GetResult()\r\n at BPPI.CPOS.API.Controllers.CommonController.d__3.MoveNext() in E:\\GitProjectWork\\Dava India\\CPOS\\Web_ApiDotNet_WorkOnthis\\ZOTA.CPOS.API\\Controllers\\CommonController.cs:line 72","priority":"medium","version_no":null,"app_version_no":null,"reccurence_count":1} , {"store_code":"","client_code":"","source":".Net SqlClient Data Provider","message":"Must declare the scalar variable \"@HOCode\".\r\nIncorrect syntax near 'X'.\r\nInvalid object name '##TEMP_PO_DATA_1'.\r\n\r\n\t-----~~~~ START Nishita 08-07-2025\r\n\t;WITH ErrorStatus AS (SELECT \r\n\t\tPo_Id,\r\n\t\tMAX(CONCAT('Retry Count= ',RetryCount,' , ','Error Message= ', ErrorMsg)) AS [Status] \r\n\t\tFROM PoErrorLog\r\n\t\tGROUP BY Po_Id)\r\n\t------~~~ END \r\n\t\tSELECT\tPH.PO_Store_Code AS po_Store_Code,\r\n\t\t\t\tCOUNT(*) AS itemCount,\r\n\t\t\t\t/*~~~~~~~ Nidhi 21/06/2024 GID:837 ~~~~~ */\r\n\t\t\t\tSD.category,\r\n\t\t\t\t/*~~~~~~~ GID:837 ~~~~~ */\r\n\t\t\t\tSD.Store_Name,\r\n\t\t\t\tSD.State AS state,\r\n\t\t\t\t/* GID: #1301\r\n\t\t\t\tDeveloper: Nishita Roy\r\n\t\t\t\tSummary\t : US: CPOS: Display Full Document Number Format in CPOS Reports\r\n\t\t\t\tDate : 22-08-2025*/\r\n\t\t\t\t--PH.PO_NO AS po_No,\r\n\t\t\t\tPO_No_new AS po_No,\r\n\t\t\t\t/* GID: #1301 END */\r\n\t\t\t CAST(PH.Po_No AS VARCHAR(25)) + '_' + ISNULL(CAST(PH.warehouseId AS VARCHAR(25)),1) AS po_No_Split,----~~~ Gid :#1156 Nidhi 04-04-2025\r\n\t\t\t\t--FORMAT(PH.PO_Date,'dd/MM/yyyy') AS po_Date,\r\n\t\t\t\t--ISNULL(CASE WHEN CAST(Po_UpdatedDt AS DATE) = '1900/01/01' THEN NULL ELSE FORMAT(CAST(Po_UpdatedDt AS DATE),'dd/MM/yyyy') END, FORMAT(CAST(Po_CreatedDt AS DATE),'dd/MM/yyyy')) AS approveDate,\r\n\t\t\t\t--ISNULL(CAST(Po_UpdatedDt AS DATE), CAST(Po_CreatedDt AS DATE)) AS approveDate,\r\n\t\t\t\t--ISNULL(CASE WHEN YEAR(Po_UpdatedDt) = 1900 THEN NULL ELSE CAST(Po_UpdatedDt AS DATE) END, CAST(Po_CreatedDt AS DATE)) AS approveDate,\r\n\t\t\t\t--FORMAT(PH.Po_SyncDate,'dd/MM/yyyy') Po_SyncDate,\r\n\t\t\t\t--PH.Po_SyncDate Po_SyncDate,\r\n\t\t\t\t--CASE WHEN ISNULL(CAST(Po_UpdatedDt AS DATE), CAST(Po_CreatedDt AS DATE)) > CAST(PH.Po_SyncDate AS date) THEN ISNULL(CAST(Po_UpdatedDt AS DATE), CAST(Po_CreatedDt AS DATE)) ELSE CAST(PH.Po_SyncDate AS date) END Po_SyncDate,\r\n\t\t\t\tPH.PO_Date AS po_Date,\r\n\t\t\t\t-----~~~~~~~ Start #711 Nidhi 09/04/2024 ~~~~~~~----\r\n\t\t\t\t--DateOfApprovedOrReject AS approveDate,\t\t\t\r\n\t\t\t\t CONVERT(VARCHAR(30), PH.DateOfApprovedOrReject , 120) as DateOfApprovedOrReject,\t\t\t\r\n\t\t\t -- CASE WHEN CAST(DateOfApprovedOrReject AS date) > CAST(PH.Po_SyncDate AS date) THEN CAST(DateOfApprovedOrReject AS date) ELSE CAST(PH.Po_SyncDate AS date) END Po_SyncDate,\r\n\t\t\t\tCASE WHEN CAST(PH.DateOfApprovedOrReject AS date) > CAST(PH.Po_SyncDate AS date) THEN CONVERT(VARCHAR(30), PH.DateOfApprovedOrReject , 120) ELSE CONVERT(VARCHAR(30), PH.Po_SyncDate , 120) END Po_SyncDate,\r\n\t\t\t\t-----~~~~~~~ End #711 Nidhi 09/04/2024 ~~~~~~~----\r\n\t\t\t\tISNULL(PH.Po_TotVal,0) AS TotalAmount,\r\n\t\t\t\tISNULL(G.CreditLimit,0) AS CreditLimit,\r\n\t\t\t\tISNULL(G.Pod_Amount,0) AS OutstandingAmount,\r\n\t\t\t\t--ISNULL(PH.StatusMarkAs,0) AS statusMarkAs,\r\n\t\t\t --\tCASE WHEN ISNULL(PH.statusMarkAs,0) = 0 THEN 'unApproved' WHEN ISNULL(PH.statusMarkAs,0) = 1 THEN 'approved' WHEN ISNULL(PH.statusMarkAs,0) = 2 THEN 'rejected' WHEN ISNULL(PH.statusMarkAs,0) = 3 THEN 'dispatched' WHEN ISNULL(PH.statusMarkAs,0) = 4 THEN 'hold' END statusMarkAs,\r\n\t\t\t\t ISNULL(ST.Status,'') AS statusMarkAs, ----- Gid :#14 Nidhi 30-05-2025\r\n\t\t\t\t--FORMAT(CAST(ISNULL(PH.Po_CreatedDt,PH.Po_UpdatedDt) AS DATE),'dd/MM/yyyy') AS dateOfApprovedOrReject,\r\n\t\t\t\t--CAST(ISNULL(PH.Po_CreatedDt,PH.Po_UpdatedDt) AS DATE) AS dateOfApprovedOrReject,\r\n\t\t\t\t-----~~~~~~~ Start #711 Nidhi 09/04/2024 ~~~~~~~-\r\n\t\t\t\t--CAST(DateOfApprovedOrReject AS date) AS dateOfApprovedOrReject,\r\n\t\t\t\tCAST(PH.DateOfApprovedOrReject AS date) AS dateOfApprovedOrRejectupdate,\r\n\t\t\t\t-----~~~~~~~ End #711 Nidhi 09/04/2024 ~~~~~~~-\r\n\t\t\t\tPH.Po_Sales_Order_No,\r\n\t\t\t\tsd.store_Contact_Person,\r\n\t\t\t\tsd.Mobile_No,\r\n\t\t\t\tSD.email_ID,\r\n\t\t\t\tISNULL(PH.Remark,'') AS Remark,\r\n\t\t\t\t(D.FirstName + ' ' + ISNULL(D.LastName,'')) AS ApprovedBy,\r\n\t\t\t\t--CASE WHEN PH.Po_VendorCode = 'HGJSUR0222' THEN ISNULL(SIHH.Sih_No,0) ELSE ISNULL(SIH.Sih_No,0) END AS sih_No,\r\n\t\t\t\t--CASE WHEN PH.Po_VendorCode = 'HGJSUR0222' THEN ISNULL(SIHH.Sih_refNo,0) ELSE\r\n\t\t\t\tCASE WHEN PH.Po_VendorCode = @HOCode THEN ISNULL(SIHH.Sih_refNo,0) ELSE\r\n\t\t\t\tCASE WHEN ISNULL(SIH.Sih_No_New, '') <> '' THEN SIH.Sih_No_New\r\n\t\t\t\t\t WHEN ISNULL(SIH.Sih_No_New, '') = '' THEN CAST(ISNULL(SIH.Sih_No,0) AS VARCHAR)END \r\n\t\t\t\tEND AS sih_No,---- Nidhi 14-08-2024 GID.: #897\r\n\t\t\t\tPH.Id,\r\n\t\t\t\tP\r\nSELECT *, TotalRecord = COUNT(1) OVER(), SumTotalAmount = CAST(SUM(TotalAmount) OVER() AS DECIMAL)\r\n\t\tFROM ##TEMP_PO_DATA_1 ORDER BY PO_Store_Code\r\n\t\tOFFSET @PageSize * (@PageNumber - 1) ROWS\r\n\t\tFETCH NEXT @PageSize ROWS ONLY;","method":"","class_name":"15","line_number":"58","time":"2025-09-13 15:06:57","error_code":"137","procedure":"","server":"192.168.0.245,1546","stack_trace":"at Ethics.HelperModules.DataContext.SqlDapperHelper.d__17`1.MoveNext()\r\n--- End of stack trace from previous location where exception was thrown ---\r\n at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()\r\n at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)\r\n at System.Runtime.CompilerServices.TaskAwaiter`1.GetResult()\r\n at BPPI.CPOS.BAL.Common.CommonRepositories.d__20.MoveNext() in E:\\GitProjectWork\\Dava India\\CPOS\\Web_ApiDotNet_WorkOnthis\\ZOTA.CPOS.BAL\\Common\\CommonRepositories.cs:line 433\r\n--- End of stack trace from previous location where exception was thrown ---\r\n at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()\r\n at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)\r\n at System.Runtime.CompilerServices.TaskAwaiter`1.GetResult()\r\n at BPPI.CPOS.API.Controllers.CommonController.d__3.MoveNext() in E:\\GitProjectWork\\Dava India\\CPOS\\Web_ApiDotNet_WorkOnthis\\ZOTA.CPOS.API\\Controllers\\CommonController.cs:line 72","priority":"medium","version_no":null,"app_version_no":null,"reccurence_count":1} , {"store_code":"","client_code":"","source":".Net SqlClient Data Provider","message":"Must declare the scalar variable \"@HOCode\".\r\nIncorrect syntax near 'X'.\r\nInvalid object name '##TEMP_PO_DATA_1'.\r\n\r\n\t-----~~~~ START Nishita 08-07-2025\r\n\t;WITH ErrorStatus AS (SELECT \r\n\t\tPo_Id,\r\n\t\tMAX(CONCAT('Retry Count= ',RetryCount,' , ','Error Message= ', ErrorMsg)) AS [Status] \r\n\t\tFROM PoErrorLog\r\n\t\tGROUP BY Po_Id)\r\n\t------~~~ END \r\n\t\tSELECT\tPH.PO_Store_Code AS po_Store_Code,\r\n\t\t\t\tCOUNT(*) AS itemCount,\r\n\t\t\t\t/*~~~~~~~ Nidhi 21/06/2024 GID:837 ~~~~~ */\r\n\t\t\t\tSD.category,\r\n\t\t\t\t/*~~~~~~~ GID:837 ~~~~~ */\r\n\t\t\t\tSD.Store_Name,\r\n\t\t\t\tSD.State AS state,\r\n\t\t\t\t/* GID: #1301\r\n\t\t\t\tDeveloper: Nishita Roy\r\n\t\t\t\tSummary\t : US: CPOS: Display Full Document Number Format in CPOS Reports\r\n\t\t\t\tDate : 22-08-2025*/\r\n\t\t\t\t--PH.PO_NO AS po_No,\r\n\t\t\t\tPO_No_new AS po_No,\r\n\t\t\t\t/* GID: #1301 END */\r\n\t\t\t CAST(PH.Po_No AS VARCHAR(25)) + '_' + ISNULL(CAST(PH.warehouseId AS VARCHAR(25)),1) AS po_No_Split,----~~~ Gid :#1156 Nidhi 04-04-2025\r\n\t\t\t\t--FORMAT(PH.PO_Date,'dd/MM/yyyy') AS po_Date,\r\n\t\t\t\t--ISNULL(CASE WHEN CAST(Po_UpdatedDt AS DATE) = '1900/01/01' THEN NULL ELSE FORMAT(CAST(Po_UpdatedDt AS DATE),'dd/MM/yyyy') END, FORMAT(CAST(Po_CreatedDt AS DATE),'dd/MM/yyyy')) AS approveDate,\r\n\t\t\t\t--ISNULL(CAST(Po_UpdatedDt AS DATE), CAST(Po_CreatedDt AS DATE)) AS approveDate,\r\n\t\t\t\t--ISNULL(CASE WHEN YEAR(Po_UpdatedDt) = 1900 THEN NULL ELSE CAST(Po_UpdatedDt AS DATE) END, CAST(Po_CreatedDt AS DATE)) AS approveDate,\r\n\t\t\t\t--FORMAT(PH.Po_SyncDate,'dd/MM/yyyy') Po_SyncDate,\r\n\t\t\t\t--PH.Po_SyncDate Po_SyncDate,\r\n\t\t\t\t--CASE WHEN ISNULL(CAST(Po_UpdatedDt AS DATE), CAST(Po_CreatedDt AS DATE)) > CAST(PH.Po_SyncDate AS date) THEN ISNULL(CAST(Po_UpdatedDt AS DATE), CAST(Po_CreatedDt AS DATE)) ELSE CAST(PH.Po_SyncDate AS date) END Po_SyncDate,\r\n\t\t\t\tPH.PO_Date AS po_Date,\r\n\t\t\t\t-----~~~~~~~ Start #711 Nidhi 09/04/2024 ~~~~~~~----\r\n\t\t\t\t--DateOfApprovedOrReject AS approveDate,\t\t\t\r\n\t\t\t\t CONVERT(VARCHAR(30), PH.DateOfApprovedOrReject , 120) as DateOfApprovedOrReject,\t\t\t\r\n\t\t\t -- CASE WHEN CAST(DateOfApprovedOrReject AS date) > CAST(PH.Po_SyncDate AS date) THEN CAST(DateOfApprovedOrReject AS date) ELSE CAST(PH.Po_SyncDate AS date) END Po_SyncDate,\r\n\t\t\t\tCASE WHEN CAST(PH.DateOfApprovedOrReject AS date) > CAST(PH.Po_SyncDate AS date) THEN CONVERT(VARCHAR(30), PH.DateOfApprovedOrReject , 120) ELSE CONVERT(VARCHAR(30), PH.Po_SyncDate , 120) END Po_SyncDate,\r\n\t\t\t\t-----~~~~~~~ End #711 Nidhi 09/04/2024 ~~~~~~~----\r\n\t\t\t\tISNULL(PH.Po_TotVal,0) AS TotalAmount,\r\n\t\t\t\tISNULL(G.CreditLimit,0) AS CreditLimit,\r\n\t\t\t\tISNULL(G.Pod_Amount,0) AS OutstandingAmount,\r\n\t\t\t\t--ISNULL(PH.StatusMarkAs,0) AS statusMarkAs,\r\n\t\t\t --\tCASE WHEN ISNULL(PH.statusMarkAs,0) = 0 THEN 'unApproved' WHEN ISNULL(PH.statusMarkAs,0) = 1 THEN 'approved' WHEN ISNULL(PH.statusMarkAs,0) = 2 THEN 'rejected' WHEN ISNULL(PH.statusMarkAs,0) = 3 THEN 'dispatched' WHEN ISNULL(PH.statusMarkAs,0) = 4 THEN 'hold' END statusMarkAs,\r\n\t\t\t\t ISNULL(ST.Status,'') AS statusMarkAs, ----- Gid :#14 Nidhi 30-05-2025\r\n\t\t\t\t--FORMAT(CAST(ISNULL(PH.Po_CreatedDt,PH.Po_UpdatedDt) AS DATE),'dd/MM/yyyy') AS dateOfApprovedOrReject,\r\n\t\t\t\t--CAST(ISNULL(PH.Po_CreatedDt,PH.Po_UpdatedDt) AS DATE) AS dateOfApprovedOrReject,\r\n\t\t\t\t-----~~~~~~~ Start #711 Nidhi 09/04/2024 ~~~~~~~-\r\n\t\t\t\t--CAST(DateOfApprovedOrReject AS date) AS dateOfApprovedOrReject,\r\n\t\t\t\tCAST(PH.DateOfApprovedOrReject AS date) AS dateOfApprovedOrRejectupdate,\r\n\t\t\t\t-----~~~~~~~ End #711 Nidhi 09/04/2024 ~~~~~~~-\r\n\t\t\t\tPH.Po_Sales_Order_No,\r\n\t\t\t\tsd.store_Contact_Person,\r\n\t\t\t\tsd.Mobile_No,\r\n\t\t\t\tSD.email_ID,\r\n\t\t\t\tISNULL(PH.Remark,'') AS Remark,\r\n\t\t\t\t(D.FirstName + ' ' + ISNULL(D.LastName,'')) AS ApprovedBy,\r\n\t\t\t\t--CASE WHEN PH.Po_VendorCode = 'HGJSUR0222' THEN ISNULL(SIHH.Sih_No,0) ELSE ISNULL(SIH.Sih_No,0) END AS sih_No,\r\n\t\t\t\t--CASE WHEN PH.Po_VendorCode = 'HGJSUR0222' THEN ISNULL(SIHH.Sih_refNo,0) ELSE\r\n\t\t\t\tCASE WHEN PH.Po_VendorCode = @HOCode THEN ISNULL(SIHH.Sih_refNo,0) ELSE\r\n\t\t\t\tCASE WHEN ISNULL(SIH.Sih_No_New, '') <> '' THEN SIH.Sih_No_New\r\n\t\t\t\t\t WHEN ISNULL(SIH.Sih_No_New, '') = '' THEN CAST(ISNULL(SIH.Sih_No,0) AS VARCHAR)END \r\n\t\t\t\tEND AS sih_No,---- Nidhi 14-08-2024 GID.: #897\r\n\t\t\t\tPH.Id,\r\n\t\t\t\tP\r\nSELECT *, TotalRecord = COUNT(1) OVER(), SumTotalAmount = CAST(SUM(TotalAmount) OVER() AS DECIMAL)\r\n\t\tFROM ##TEMP_PO_DATA_1 ORDER BY PO_Store_Code\r\n\t\tOFFSET @PageSize * (@PageNumber - 1) ROWS\r\n\t\tFETCH NEXT @PageSize ROWS ONLY;","method":"","class_name":"15","line_number":"58","time":"2025-09-13 15:06:59","error_code":"137","procedure":"","server":"192.168.0.245,1546","stack_trace":"at Ethics.HelperModules.DataContext.SqlDapperHelper.d__17`1.MoveNext()\r\n--- End of stack trace from previous location where exception was thrown ---\r\n at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()\r\n at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)\r\n at System.Runtime.CompilerServices.TaskAwaiter`1.GetResult()\r\n at BPPI.CPOS.BAL.Common.CommonRepositories.d__20.MoveNext() in E:\\GitProjectWork\\Dava India\\CPOS\\Web_ApiDotNet_WorkOnthis\\ZOTA.CPOS.BAL\\Common\\CommonRepositories.cs:line 433\r\n--- End of stack trace from previous location where exception was thrown ---\r\n at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()\r\n at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)\r\n at System.Runtime.CompilerServices.TaskAwaiter`1.GetResult()\r\n at BPPI.CPOS.API.Controllers.CommonController.d__3.MoveNext() in E:\\GitProjectWork\\Dava India\\CPOS\\Web_ApiDotNet_WorkOnthis\\ZOTA.CPOS.API\\Controllers\\CommonController.cs:line 72","priority":"medium","version_no":null,"app_version_no":null,"reccurence_count":1} , {"store_code":"","client_code":"","source":".Net SqlClient Data Provider","message":"Must declare the scalar variable \"@HOCode\".\r\nIncorrect syntax near 'X'.\r\nInvalid object name '##TEMP_PO_DATA_1'.\r\n\r\n\t-----~~~~ START Nishita 08-07-2025\r\n\t;WITH ErrorStatus AS (SELECT \r\n\t\tPo_Id,\r\n\t\tMAX(CONCAT('Retry Count= ',RetryCount,' , ','Error Message= ', ErrorMsg)) AS [Status] \r\n\t\tFROM PoErrorLog\r\n\t\tGROUP BY Po_Id)\r\n\t------~~~ END \r\n\t\tSELECT\tPH.PO_Store_Code AS po_Store_Code,\r\n\t\t\t\tCOUNT(*) AS itemCount,\r\n\t\t\t\t/*~~~~~~~ Nidhi 21/06/2024 GID:837 ~~~~~ */\r\n\t\t\t\tSD.category,\r\n\t\t\t\t/*~~~~~~~ GID:837 ~~~~~ */\r\n\t\t\t\tSD.Store_Name,\r\n\t\t\t\tSD.State AS state,\r\n\t\t\t\t/* GID: #1301\r\n\t\t\t\tDeveloper: Nishita Roy\r\n\t\t\t\tSummary\t : US: CPOS: Display Full Document Number Format in CPOS Reports\r\n\t\t\t\tDate : 22-08-2025*/\r\n\t\t\t\t--PH.PO_NO AS po_No,\r\n\t\t\t\tPO_No_new AS po_No,\r\n\t\t\t\t/* GID: #1301 END */\r\n\t\t\t CAST(PH.Po_No AS VARCHAR(25)) + '_' + ISNULL(CAST(PH.warehouseId AS VARCHAR(25)),1) AS po_No_Split,----~~~ Gid :#1156 Nidhi 04-04-2025\r\n\t\t\t\t--FORMAT(PH.PO_Date,'dd/MM/yyyy') AS po_Date,\r\n\t\t\t\t--ISNULL(CASE WHEN CAST(Po_UpdatedDt AS DATE) = '1900/01/01' THEN NULL ELSE FORMAT(CAST(Po_UpdatedDt AS DATE),'dd/MM/yyyy') END, FORMAT(CAST(Po_CreatedDt AS DATE),'dd/MM/yyyy')) AS approveDate,\r\n\t\t\t\t--ISNULL(CAST(Po_UpdatedDt AS DATE), CAST(Po_CreatedDt AS DATE)) AS approveDate,\r\n\t\t\t\t--ISNULL(CASE WHEN YEAR(Po_UpdatedDt) = 1900 THEN NULL ELSE CAST(Po_UpdatedDt AS DATE) END, CAST(Po_CreatedDt AS DATE)) AS approveDate,\r\n\t\t\t\t--FORMAT(PH.Po_SyncDate,'dd/MM/yyyy') Po_SyncDate,\r\n\t\t\t\t--PH.Po_SyncDate Po_SyncDate,\r\n\t\t\t\t--CASE WHEN ISNULL(CAST(Po_UpdatedDt AS DATE), CAST(Po_CreatedDt AS DATE)) > CAST(PH.Po_SyncDate AS date) THEN ISNULL(CAST(Po_UpdatedDt AS DATE), CAST(Po_CreatedDt AS DATE)) ELSE CAST(PH.Po_SyncDate AS date) END Po_SyncDate,\r\n\t\t\t\tPH.PO_Date AS po_Date,\r\n\t\t\t\t-----~~~~~~~ Start #711 Nidhi 09/04/2024 ~~~~~~~----\r\n\t\t\t\t--DateOfApprovedOrReject AS approveDate,\t\t\t\r\n\t\t\t\t CONVERT(VARCHAR(30), PH.DateOfApprovedOrReject , 120) as DateOfApprovedOrReject,\t\t\t\r\n\t\t\t -- CASE WHEN CAST(DateOfApprovedOrReject AS date) > CAST(PH.Po_SyncDate AS date) THEN CAST(DateOfApprovedOrReject AS date) ELSE CAST(PH.Po_SyncDate AS date) END Po_SyncDate,\r\n\t\t\t\tCASE WHEN CAST(PH.DateOfApprovedOrReject AS date) > CAST(PH.Po_SyncDate AS date) THEN CONVERT(VARCHAR(30), PH.DateOfApprovedOrReject , 120) ELSE CONVERT(VARCHAR(30), PH.Po_SyncDate , 120) END Po_SyncDate,\r\n\t\t\t\t-----~~~~~~~ End #711 Nidhi 09/04/2024 ~~~~~~~----\r\n\t\t\t\tISNULL(PH.Po_TotVal,0) AS TotalAmount,\r\n\t\t\t\tISNULL(G.CreditLimit,0) AS CreditLimit,\r\n\t\t\t\tISNULL(G.Pod_Amount,0) AS OutstandingAmount,\r\n\t\t\t\t--ISNULL(PH.StatusMarkAs,0) AS statusMarkAs,\r\n\t\t\t --\tCASE WHEN ISNULL(PH.statusMarkAs,0) = 0 THEN 'unApproved' WHEN ISNULL(PH.statusMarkAs,0) = 1 THEN 'approved' WHEN ISNULL(PH.statusMarkAs,0) = 2 THEN 'rejected' WHEN ISNULL(PH.statusMarkAs,0) = 3 THEN 'dispatched' WHEN ISNULL(PH.statusMarkAs,0) = 4 THEN 'hold' END statusMarkAs,\r\n\t\t\t\t ISNULL(ST.Status,'') AS statusMarkAs, ----- Gid :#14 Nidhi 30-05-2025\r\n\t\t\t\t--FORMAT(CAST(ISNULL(PH.Po_CreatedDt,PH.Po_UpdatedDt) AS DATE),'dd/MM/yyyy') AS dateOfApprovedOrReject,\r\n\t\t\t\t--CAST(ISNULL(PH.Po_CreatedDt,PH.Po_UpdatedDt) AS DATE) AS dateOfApprovedOrReject,\r\n\t\t\t\t-----~~~~~~~ Start #711 Nidhi 09/04/2024 ~~~~~~~-\r\n\t\t\t\t--CAST(DateOfApprovedOrReject AS date) AS dateOfApprovedOrReject,\r\n\t\t\t\tCAST(PH.DateOfApprovedOrReject AS date) AS dateOfApprovedOrRejectupdate,\r\n\t\t\t\t-----~~~~~~~ End #711 Nidhi 09/04/2024 ~~~~~~~-\r\n\t\t\t\tPH.Po_Sales_Order_No,\r\n\t\t\t\tsd.store_Contact_Person,\r\n\t\t\t\tsd.Mobile_No,\r\n\t\t\t\tSD.email_ID,\r\n\t\t\t\tISNULL(PH.Remark,'') AS Remark,\r\n\t\t\t\t(D.FirstName + ' ' + ISNULL(D.LastName,'')) AS ApprovedBy,\r\n\t\t\t\t--CASE WHEN PH.Po_VendorCode = 'HGJSUR0222' THEN ISNULL(SIHH.Sih_No,0) ELSE ISNULL(SIH.Sih_No,0) END AS sih_No,\r\n\t\t\t\t--CASE WHEN PH.Po_VendorCode = 'HGJSUR0222' THEN ISNULL(SIHH.Sih_refNo,0) ELSE\r\n\t\t\t\tCASE WHEN PH.Po_VendorCode = @HOCode THEN ISNULL(SIHH.Sih_refNo,0) ELSE\r\n\t\t\t\tCASE WHEN ISNULL(SIH.Sih_No_New, '') <> '' THEN SIH.Sih_No_New\r\n\t\t\t\t\t WHEN ISNULL(SIH.Sih_No_New, '') = '' THEN CAST(ISNULL(SIH.Sih_No,0) AS VARCHAR)END \r\n\t\t\t\tEND AS sih_No,---- Nidhi 14-08-2024 GID.: #897\r\n\t\t\t\tPH.Id,\r\n\t\t\t\tP\r\nSELECT *, TotalRecord = COUNT(1) OVER(), SumTotalAmount = CAST(SUM(TotalAmount) OVER() AS DECIMAL)\r\n\t\tFROM ##TEMP_PO_DATA_1 ORDER BY PO_Store_Code\r\n\t\tOFFSET @PageSize * (@PageNumber - 1) ROWS\r\n\t\tFETCH NEXT @PageSize ROWS ONLY;","method":"","class_name":"15","line_number":"58","time":"2025-09-13 15:07:02","error_code":"137","procedure":"","server":"192.168.0.245,1546","stack_trace":"at Ethics.HelperModules.DataContext.SqlDapperHelper.d__17`1.MoveNext()\r\n--- End of stack trace from previous location where exception was thrown ---\r\n at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()\r\n at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)\r\n at System.Runtime.CompilerServices.TaskAwaiter`1.GetResult()\r\n at BPPI.CPOS.BAL.Common.CommonRepositories.d__20.MoveNext() in E:\\GitProjectWork\\Dava India\\CPOS\\Web_ApiDotNet_WorkOnthis\\ZOTA.CPOS.BAL\\Common\\CommonRepositories.cs:line 433\r\n--- End of stack trace from previous location where exception was thrown ---\r\n at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()\r\n at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)\r\n at System.Runtime.CompilerServices.TaskAwaiter`1.GetResult()\r\n at BPPI.CPOS.API.Controllers.CommonController.d__3.MoveNext() in E:\\GitProjectWork\\Dava India\\CPOS\\Web_ApiDotNet_WorkOnthis\\ZOTA.CPOS.API\\Controllers\\CommonController.cs:line 72","priority":"medium","version_no":null,"app_version_no":null,"reccurence_count":1} , {"store_code":"","client_code":"","source":".Net SqlClient Data Provider","message":"Must declare the scalar variable \"@HOCode\".\r\nIncorrect syntax near 'X'.\r\nInvalid object name '##TEMP_PO_DATA_1'.\r\n\r\n\t-----~~~~ START Nishita 08-07-2025\r\n\t;WITH ErrorStatus AS (SELECT \r\n\t\tPo_Id,\r\n\t\tMAX(CONCAT('Retry Count= ',RetryCount,' , ','Error Message= ', ErrorMsg)) AS [Status] \r\n\t\tFROM PoErrorLog\r\n\t\tGROUP BY Po_Id)\r\n\t------~~~ END \r\n\t\tSELECT\tPH.PO_Store_Code AS po_Store_Code,\r\n\t\t\t\tCOUNT(*) AS itemCount,\r\n\t\t\t\t/*~~~~~~~ Nidhi 21/06/2024 GID:837 ~~~~~ */\r\n\t\t\t\tSD.category,\r\n\t\t\t\t/*~~~~~~~ GID:837 ~~~~~ */\r\n\t\t\t\tSD.Store_Name,\r\n\t\t\t\tSD.State AS state,\r\n\t\t\t\t/* GID: #1301\r\n\t\t\t\tDeveloper: Nishita Roy\r\n\t\t\t\tSummary\t : US: CPOS: Display Full Document Number Format in CPOS Reports\r\n\t\t\t\tDate : 22-08-2025*/\r\n\t\t\t\t--PH.PO_NO AS po_No,\r\n\t\t\t\tPO_No_new AS po_No,\r\n\t\t\t\t/* GID: #1301 END */\r\n\t\t\t CAST(PH.Po_No AS VARCHAR(25)) + '_' + ISNULL(CAST(PH.warehouseId AS VARCHAR(25)),1) AS po_No_Split,----~~~ Gid :#1156 Nidhi 04-04-2025\r\n\t\t\t\t--FORMAT(PH.PO_Date,'dd/MM/yyyy') AS po_Date,\r\n\t\t\t\t--ISNULL(CASE WHEN CAST(Po_UpdatedDt AS DATE) = '1900/01/01' THEN NULL ELSE FORMAT(CAST(Po_UpdatedDt AS DATE),'dd/MM/yyyy') END, FORMAT(CAST(Po_CreatedDt AS DATE),'dd/MM/yyyy')) AS approveDate,\r\n\t\t\t\t--ISNULL(CAST(Po_UpdatedDt AS DATE), CAST(Po_CreatedDt AS DATE)) AS approveDate,\r\n\t\t\t\t--ISNULL(CASE WHEN YEAR(Po_UpdatedDt) = 1900 THEN NULL ELSE CAST(Po_UpdatedDt AS DATE) END, CAST(Po_CreatedDt AS DATE)) AS approveDate,\r\n\t\t\t\t--FORMAT(PH.Po_SyncDate,'dd/MM/yyyy') Po_SyncDate,\r\n\t\t\t\t--PH.Po_SyncDate Po_SyncDate,\r\n\t\t\t\t--CASE WHEN ISNULL(CAST(Po_UpdatedDt AS DATE), CAST(Po_CreatedDt AS DATE)) > CAST(PH.Po_SyncDate AS date) THEN ISNULL(CAST(Po_UpdatedDt AS DATE), CAST(Po_CreatedDt AS DATE)) ELSE CAST(PH.Po_SyncDate AS date) END Po_SyncDate,\r\n\t\t\t\tPH.PO_Date AS po_Date,\r\n\t\t\t\t-----~~~~~~~ Start #711 Nidhi 09/04/2024 ~~~~~~~----\r\n\t\t\t\t--DateOfApprovedOrReject AS approveDate,\t\t\t\r\n\t\t\t\t CONVERT(VARCHAR(30), PH.DateOfApprovedOrReject , 120) as DateOfApprovedOrReject,\t\t\t\r\n\t\t\t -- CASE WHEN CAST(DateOfApprovedOrReject AS date) > CAST(PH.Po_SyncDate AS date) THEN CAST(DateOfApprovedOrReject AS date) ELSE CAST(PH.Po_SyncDate AS date) END Po_SyncDate,\r\n\t\t\t\tCASE WHEN CAST(PH.DateOfApprovedOrReject AS date) > CAST(PH.Po_SyncDate AS date) THEN CONVERT(VARCHAR(30), PH.DateOfApprovedOrReject , 120) ELSE CONVERT(VARCHAR(30), PH.Po_SyncDate , 120) END Po_SyncDate,\r\n\t\t\t\t-----~~~~~~~ End #711 Nidhi 09/04/2024 ~~~~~~~----\r\n\t\t\t\tISNULL(PH.Po_TotVal,0) AS TotalAmount,\r\n\t\t\t\tISNULL(G.CreditLimit,0) AS CreditLimit,\r\n\t\t\t\tISNULL(G.Pod_Amount,0) AS OutstandingAmount,\r\n\t\t\t\t--ISNULL(PH.StatusMarkAs,0) AS statusMarkAs,\r\n\t\t\t --\tCASE WHEN ISNULL(PH.statusMarkAs,0) = 0 THEN 'unApproved' WHEN ISNULL(PH.statusMarkAs,0) = 1 THEN 'approved' WHEN ISNULL(PH.statusMarkAs,0) = 2 THEN 'rejected' WHEN ISNULL(PH.statusMarkAs,0) = 3 THEN 'dispatched' WHEN ISNULL(PH.statusMarkAs,0) = 4 THEN 'hold' END statusMarkAs,\r\n\t\t\t\t ISNULL(ST.Status,'') AS statusMarkAs, ----- Gid :#14 Nidhi 30-05-2025\r\n\t\t\t\t--FORMAT(CAST(ISNULL(PH.Po_CreatedDt,PH.Po_UpdatedDt) AS DATE),'dd/MM/yyyy') AS dateOfApprovedOrReject,\r\n\t\t\t\t--CAST(ISNULL(PH.Po_CreatedDt,PH.Po_UpdatedDt) AS DATE) AS dateOfApprovedOrReject,\r\n\t\t\t\t-----~~~~~~~ Start #711 Nidhi 09/04/2024 ~~~~~~~-\r\n\t\t\t\t--CAST(DateOfApprovedOrReject AS date) AS dateOfApprovedOrReject,\r\n\t\t\t\tCAST(PH.DateOfApprovedOrReject AS date) AS dateOfApprovedOrRejectupdate,\r\n\t\t\t\t-----~~~~~~~ End #711 Nidhi 09/04/2024 ~~~~~~~-\r\n\t\t\t\tPH.Po_Sales_Order_No,\r\n\t\t\t\tsd.store_Contact_Person,\r\n\t\t\t\tsd.Mobile_No,\r\n\t\t\t\tSD.email_ID,\r\n\t\t\t\tISNULL(PH.Remark,'') AS Remark,\r\n\t\t\t\t(D.FirstName + ' ' + ISNULL(D.LastName,'')) AS ApprovedBy,\r\n\t\t\t\t--CASE WHEN PH.Po_VendorCode = 'HGJSUR0222' THEN ISNULL(SIHH.Sih_No,0) ELSE ISNULL(SIH.Sih_No,0) END AS sih_No,\r\n\t\t\t\t--CASE WHEN PH.Po_VendorCode = 'HGJSUR0222' THEN ISNULL(SIHH.Sih_refNo,0) ELSE\r\n\t\t\t\tCASE WHEN PH.Po_VendorCode = @HOCode THEN ISNULL(SIHH.Sih_refNo,0) ELSE\r\n\t\t\t\tCASE WHEN ISNULL(SIH.Sih_No_New, '') <> '' THEN SIH.Sih_No_New\r\n\t\t\t\t\t WHEN ISNULL(SIH.Sih_No_New, '') = '' THEN CAST(ISNULL(SIH.Sih_No,0) AS VARCHAR)END \r\n\t\t\t\tEND AS sih_No,---- Nidhi 14-08-2024 GID.: #897\r\n\t\t\t\tPH.Id,\r\n\t\t\t\tP\r\nSELECT *, TotalRecord = COUNT(1) OVER(), SumTotalAmount = CAST(SUM(TotalAmount) OVER() AS DECIMAL)\r\n\t\tFROM ##TEMP_PO_DATA_1 ORDER BY PO_Store_Code\r\n\t\tOFFSET @PageSize * (@PageNumber - 1) ROWS\r\n\t\tFETCH NEXT @PageSize ROWS ONLY;","method":"","class_name":"15","line_number":"58","time":"2025-09-13 15:07:06","error_code":"137","procedure":"","server":"192.168.0.245,1546","stack_trace":"at Ethics.HelperModules.DataContext.SqlDapperHelper.d__17`1.MoveNext()\r\n--- End of stack trace from previous location where exception was thrown ---\r\n at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()\r\n at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)\r\n at System.Runtime.CompilerServices.TaskAwaiter`1.GetResult()\r\n at BPPI.CPOS.BAL.Common.CommonRepositories.d__20.MoveNext() in E:\\GitProjectWork\\Dava India\\CPOS\\Web_ApiDotNet_WorkOnthis\\ZOTA.CPOS.BAL\\Common\\CommonRepositories.cs:line 433\r\n--- End of stack trace from previous location where exception was thrown ---\r\n at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()\r\n at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)\r\n at System.Runtime.CompilerServices.TaskAwaiter`1.GetResult()\r\n at BPPI.CPOS.API.Controllers.CommonController.d__3.MoveNext() in E:\\GitProjectWork\\Dava India\\CPOS\\Web_ApiDotNet_WorkOnthis\\ZOTA.CPOS.API\\Controllers\\CommonController.cs:line 72","priority":"medium","version_no":null,"app_version_no":null,"reccurence_count":1} , {"store_code":"","client_code":"","source":".Net SqlClient Data Provider","message":"Must declare the scalar variable \"@HOCode\".\r\nIncorrect syntax near 'X'.\r\nInvalid object name '##TEMP_PO_DATA_1'.\r\n\r\n\t-----~~~~ START Nishita 08-07-2025\r\n\t;WITH ErrorStatus AS (SELECT \r\n\t\tPo_Id,\r\n\t\tMAX(CONCAT('Retry Count= ',RetryCount,' , ','Error Message= ', ErrorMsg)) AS [Status] \r\n\t\tFROM PoErrorLog\r\n\t\tGROUP BY Po_Id)\r\n\t------~~~ END \r\n\t\tSELECT\tPH.PO_Store_Code AS po_Store_Code,\r\n\t\t\t\tCOUNT(*) AS itemCount,\r\n\t\t\t\t/*~~~~~~~ Nidhi 21/06/2024 GID:837 ~~~~~ */\r\n\t\t\t\tSD.category,\r\n\t\t\t\t/*~~~~~~~ GID:837 ~~~~~ */\r\n\t\t\t\tSD.Store_Name,\r\n\t\t\t\tSD.State AS state,\r\n\t\t\t\t/* GID: #1301\r\n\t\t\t\tDeveloper: Nishita Roy\r\n\t\t\t\tSummary\t : US: CPOS: Display Full Document Number Format in CPOS Reports\r\n\t\t\t\tDate : 22-08-2025*/\r\n\t\t\t\t--PH.PO_NO AS po_No,\r\n\t\t\t\tPO_No_new AS po_No,\r\n\t\t\t\t/* GID: #1301 END */\r\n\t\t\t CAST(PH.Po_No AS VARCHAR(25)) + '_' + ISNULL(CAST(PH.warehouseId AS VARCHAR(25)),1) AS po_No_Split,----~~~ Gid :#1156 Nidhi 04-04-2025\r\n\t\t\t\t--FORMAT(PH.PO_Date,'dd/MM/yyyy') AS po_Date,\r\n\t\t\t\t--ISNULL(CASE WHEN CAST(Po_UpdatedDt AS DATE) = '1900/01/01' THEN NULL ELSE FORMAT(CAST(Po_UpdatedDt AS DATE),'dd/MM/yyyy') END, FORMAT(CAST(Po_CreatedDt AS DATE),'dd/MM/yyyy')) AS approveDate,\r\n\t\t\t\t--ISNULL(CAST(Po_UpdatedDt AS DATE), CAST(Po_CreatedDt AS DATE)) AS approveDate,\r\n\t\t\t\t--ISNULL(CASE WHEN YEAR(Po_UpdatedDt) = 1900 THEN NULL ELSE CAST(Po_UpdatedDt AS DATE) END, CAST(Po_CreatedDt AS DATE)) AS approveDate,\r\n\t\t\t\t--FORMAT(PH.Po_SyncDate,'dd/MM/yyyy') Po_SyncDate,\r\n\t\t\t\t--PH.Po_SyncDate Po_SyncDate,\r\n\t\t\t\t--CASE WHEN ISNULL(CAST(Po_UpdatedDt AS DATE), CAST(Po_CreatedDt AS DATE)) > CAST(PH.Po_SyncDate AS date) THEN ISNULL(CAST(Po_UpdatedDt AS DATE), CAST(Po_CreatedDt AS DATE)) ELSE CAST(PH.Po_SyncDate AS date) END Po_SyncDate,\r\n\t\t\t\tPH.PO_Date AS po_Date,\r\n\t\t\t\t-----~~~~~~~ Start #711 Nidhi 09/04/2024 ~~~~~~~----\r\n\t\t\t\t--DateOfApprovedOrReject AS approveDate,\t\t\t\r\n\t\t\t\t CONVERT(VARCHAR(30), PH.DateOfApprovedOrReject , 120) as DateOfApprovedOrReject,\t\t\t\r\n\t\t\t -- CASE WHEN CAST(DateOfApprovedOrReject AS date) > CAST(PH.Po_SyncDate AS date) THEN CAST(DateOfApprovedOrReject AS date) ELSE CAST(PH.Po_SyncDate AS date) END Po_SyncDate,\r\n\t\t\t\tCASE WHEN CAST(PH.DateOfApprovedOrReject AS date) > CAST(PH.Po_SyncDate AS date) THEN CONVERT(VARCHAR(30), PH.DateOfApprovedOrReject , 120) ELSE CONVERT(VARCHAR(30), PH.Po_SyncDate , 120) END Po_SyncDate,\r\n\t\t\t\t-----~~~~~~~ End #711 Nidhi 09/04/2024 ~~~~~~~----\r\n\t\t\t\tISNULL(PH.Po_TotVal,0) AS TotalAmount,\r\n\t\t\t\tISNULL(G.CreditLimit,0) AS CreditLimit,\r\n\t\t\t\tISNULL(G.Pod_Amount,0) AS OutstandingAmount,\r\n\t\t\t\t--ISNULL(PH.StatusMarkAs,0) AS statusMarkAs,\r\n\t\t\t --\tCASE WHEN ISNULL(PH.statusMarkAs,0) = 0 THEN 'unApproved' WHEN ISNULL(PH.statusMarkAs,0) = 1 THEN 'approved' WHEN ISNULL(PH.statusMarkAs,0) = 2 THEN 'rejected' WHEN ISNULL(PH.statusMarkAs,0) = 3 THEN 'dispatched' WHEN ISNULL(PH.statusMarkAs,0) = 4 THEN 'hold' END statusMarkAs,\r\n\t\t\t\t ISNULL(ST.Status,'') AS statusMarkAs, ----- Gid :#14 Nidhi 30-05-2025\r\n\t\t\t\t--FORMAT(CAST(ISNULL(PH.Po_CreatedDt,PH.Po_UpdatedDt) AS DATE),'dd/MM/yyyy') AS dateOfApprovedOrReject,\r\n\t\t\t\t--CAST(ISNULL(PH.Po_CreatedDt,PH.Po_UpdatedDt) AS DATE) AS dateOfApprovedOrReject,\r\n\t\t\t\t-----~~~~~~~ Start #711 Nidhi 09/04/2024 ~~~~~~~-\r\n\t\t\t\t--CAST(DateOfApprovedOrReject AS date) AS dateOfApprovedOrReject,\r\n\t\t\t\tCAST(PH.DateOfApprovedOrReject AS date) AS dateOfApprovedOrRejectupdate,\r\n\t\t\t\t-----~~~~~~~ End #711 Nidhi 09/04/2024 ~~~~~~~-\r\n\t\t\t\tPH.Po_Sales_Order_No,\r\n\t\t\t\tsd.store_Contact_Person,\r\n\t\t\t\tsd.Mobile_No,\r\n\t\t\t\tSD.email_ID,\r\n\t\t\t\tISNULL(PH.Remark,'') AS Remark,\r\n\t\t\t\t(D.FirstName + ' ' + ISNULL(D.LastName,'')) AS ApprovedBy,\r\n\t\t\t\t--CASE WHEN PH.Po_VendorCode = 'HGJSUR0222' THEN ISNULL(SIHH.Sih_No,0) ELSE ISNULL(SIH.Sih_No,0) END AS sih_No,\r\n\t\t\t\t--CASE WHEN PH.Po_VendorCode = 'HGJSUR0222' THEN ISNULL(SIHH.Sih_refNo,0) ELSE\r\n\t\t\t\tCASE WHEN PH.Po_VendorCode = @HOCode THEN ISNULL(SIHH.Sih_refNo,0) ELSE\r\n\t\t\t\tCASE WHEN ISNULL(SIH.Sih_No_New, '') <> '' THEN SIH.Sih_No_New\r\n\t\t\t\t\t WHEN ISNULL(SIH.Sih_No_New, '') = '' THEN CAST(ISNULL(SIH.Sih_No,0) AS VARCHAR)END \r\n\t\t\t\tEND AS sih_No,---- Nidhi 14-08-2024 GID.: #897\r\n\t\t\t\tPH.Id,\r\n\t\t\t\tP\r\nSELECT *, TotalRecord = COUNT(1) OVER(), SumTotalAmount = CAST(SUM(TotalAmount) OVER() AS DECIMAL)\r\n\t\tFROM ##TEMP_PO_DATA_1 ORDER BY PO_Store_Code\r\n\t\tOFFSET @PageSize * (@PageNumber - 1) ROWS\r\n\t\tFETCH NEXT @PageSize ROWS ONLY;","method":"","class_name":"15","line_number":"58","time":"2025-09-13 15:07:10","error_code":"137","procedure":"","server":"192.168.0.245,1546","stack_trace":"at Ethics.HelperModules.DataContext.SqlDapperHelper.d__17`1.MoveNext()\r\n--- End of stack trace from previous location where exception was thrown ---\r\n at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()\r\n at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)\r\n at System.Runtime.CompilerServices.TaskAwaiter`1.GetResult()\r\n at BPPI.CPOS.BAL.Common.CommonRepositories.d__20.MoveNext() in E:\\GitProjectWork\\Dava India\\CPOS\\Web_ApiDotNet_WorkOnthis\\ZOTA.CPOS.BAL\\Common\\CommonRepositories.cs:line 433\r\n--- End of stack trace from previous location where exception was thrown ---\r\n at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()\r\n at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)\r\n at System.Runtime.CompilerServices.TaskAwaiter`1.GetResult()\r\n at BPPI.CPOS.API.Controllers.CommonController.d__3.MoveNext() in E:\\GitProjectWork\\Dava India\\CPOS\\Web_ApiDotNet_WorkOnthis\\ZOTA.CPOS.API\\Controllers\\CommonController.cs:line 72","priority":"medium","version_no":null,"app_version_no":null,"reccurence_count":1} , {"store_code":"","client_code":"","source":".Net SqlClient Data Provider","message":"Must declare the scalar variable \"@HOCode\".\r\nIncorrect syntax near 'X'.\r\nInvalid object name '##TEMP_PO_DATA_1'.\r\n\r\n\t-----~~~~ START Nishita 08-07-2025\r\n\t;WITH ErrorStatus AS (SELECT \r\n\t\tPo_Id,\r\n\t\tMAX(CONCAT('Retry Count= ',RetryCount,' , ','Error Message= ', ErrorMsg)) AS [Status] \r\n\t\tFROM PoErrorLog\r\n\t\tGROUP BY Po_Id)\r\n\t------~~~ END \r\n\t\tSELECT\tPH.PO_Store_Code AS po_Store_Code,\r\n\t\t\t\tCOUNT(*) AS itemCount,\r\n\t\t\t\t/*~~~~~~~ Nidhi 21/06/2024 GID:837 ~~~~~ */\r\n\t\t\t\tSD.category,\r\n\t\t\t\t/*~~~~~~~ GID:837 ~~~~~ */\r\n\t\t\t\tSD.Store_Name,\r\n\t\t\t\tSD.State AS state,\r\n\t\t\t\t/* GID: #1301\r\n\t\t\t\tDeveloper: Nishita Roy\r\n\t\t\t\tSummary\t : US: CPOS: Display Full Document Number Format in CPOS Reports\r\n\t\t\t\tDate : 22-08-2025*/\r\n\t\t\t\t--PH.PO_NO AS po_No,\r\n\t\t\t\tPO_No_new AS po_No,\r\n\t\t\t\t/* GID: #1301 END */\r\n\t\t\t CAST(PH.Po_No AS VARCHAR(25)) + '_' + ISNULL(CAST(PH.warehouseId AS VARCHAR(25)),1) AS po_No_Split,----~~~ Gid :#1156 Nidhi 04-04-2025\r\n\t\t\t\t--FORMAT(PH.PO_Date,'dd/MM/yyyy') AS po_Date,\r\n\t\t\t\t--ISNULL(CASE WHEN CAST(Po_UpdatedDt AS DATE) = '1900/01/01' THEN NULL ELSE FORMAT(CAST(Po_UpdatedDt AS DATE),'dd/MM/yyyy') END, FORMAT(CAST(Po_CreatedDt AS DATE),'dd/MM/yyyy')) AS approveDate,\r\n\t\t\t\t--ISNULL(CAST(Po_UpdatedDt AS DATE), CAST(Po_CreatedDt AS DATE)) AS approveDate,\r\n\t\t\t\t--ISNULL(CASE WHEN YEAR(Po_UpdatedDt) = 1900 THEN NULL ELSE CAST(Po_UpdatedDt AS DATE) END, CAST(Po_CreatedDt AS DATE)) AS approveDate,\r\n\t\t\t\t--FORMAT(PH.Po_SyncDate,'dd/MM/yyyy') Po_SyncDate,\r\n\t\t\t\t--PH.Po_SyncDate Po_SyncDate,\r\n\t\t\t\t--CASE WHEN ISNULL(CAST(Po_UpdatedDt AS DATE), CAST(Po_CreatedDt AS DATE)) > CAST(PH.Po_SyncDate AS date) THEN ISNULL(CAST(Po_UpdatedDt AS DATE), CAST(Po_CreatedDt AS DATE)) ELSE CAST(PH.Po_SyncDate AS date) END Po_SyncDate,\r\n\t\t\t\tPH.PO_Date AS po_Date,\r\n\t\t\t\t-----~~~~~~~ Start #711 Nidhi 09/04/2024 ~~~~~~~----\r\n\t\t\t\t--DateOfApprovedOrReject AS approveDate,\t\t\t\r\n\t\t\t\t CONVERT(VARCHAR(30), PH.DateOfApprovedOrReject , 120) as DateOfApprovedOrReject,\t\t\t\r\n\t\t\t -- CASE WHEN CAST(DateOfApprovedOrReject AS date) > CAST(PH.Po_SyncDate AS date) THEN CAST(DateOfApprovedOrReject AS date) ELSE CAST(PH.Po_SyncDate AS date) END Po_SyncDate,\r\n\t\t\t\tCASE WHEN CAST(PH.DateOfApprovedOrReject AS date) > CAST(PH.Po_SyncDate AS date) THEN CONVERT(VARCHAR(30), PH.DateOfApprovedOrReject , 120) ELSE CONVERT(VARCHAR(30), PH.Po_SyncDate , 120) END Po_SyncDate,\r\n\t\t\t\t-----~~~~~~~ End #711 Nidhi 09/04/2024 ~~~~~~~----\r\n\t\t\t\tISNULL(PH.Po_TotVal,0) AS TotalAmount,\r\n\t\t\t\tISNULL(G.CreditLimit,0) AS CreditLimit,\r\n\t\t\t\tISNULL(G.Pod_Amount,0) AS OutstandingAmount,\r\n\t\t\t\t--ISNULL(PH.StatusMarkAs,0) AS statusMarkAs,\r\n\t\t\t --\tCASE WHEN ISNULL(PH.statusMarkAs,0) = 0 THEN 'unApproved' WHEN ISNULL(PH.statusMarkAs,0) = 1 THEN 'approved' WHEN ISNULL(PH.statusMarkAs,0) = 2 THEN 'rejected' WHEN ISNULL(PH.statusMarkAs,0) = 3 THEN 'dispatched' WHEN ISNULL(PH.statusMarkAs,0) = 4 THEN 'hold' END statusMarkAs,\r\n\t\t\t\t ISNULL(ST.Status,'') AS statusMarkAs, ----- Gid :#14 Nidhi 30-05-2025\r\n\t\t\t\t--FORMAT(CAST(ISNULL(PH.Po_CreatedDt,PH.Po_UpdatedDt) AS DATE),'dd/MM/yyyy') AS dateOfApprovedOrReject,\r\n\t\t\t\t--CAST(ISNULL(PH.Po_CreatedDt,PH.Po_UpdatedDt) AS DATE) AS dateOfApprovedOrReject,\r\n\t\t\t\t-----~~~~~~~ Start #711 Nidhi 09/04/2024 ~~~~~~~-\r\n\t\t\t\t--CAST(DateOfApprovedOrReject AS date) AS dateOfApprovedOrReject,\r\n\t\t\t\tCAST(PH.DateOfApprovedOrReject AS date) AS dateOfApprovedOrRejectupdate,\r\n\t\t\t\t-----~~~~~~~ End #711 Nidhi 09/04/2024 ~~~~~~~-\r\n\t\t\t\tPH.Po_Sales_Order_No,\r\n\t\t\t\tsd.store_Contact_Person,\r\n\t\t\t\tsd.Mobile_No,\r\n\t\t\t\tSD.email_ID,\r\n\t\t\t\tISNULL(PH.Remark,'') AS Remark,\r\n\t\t\t\t(D.FirstName + ' ' + ISNULL(D.LastName,'')) AS ApprovedBy,\r\n\t\t\t\t--CASE WHEN PH.Po_VendorCode = 'HGJSUR0222' THEN ISNULL(SIHH.Sih_No,0) ELSE ISNULL(SIH.Sih_No,0) END AS sih_No,\r\n\t\t\t\t--CASE WHEN PH.Po_VendorCode = 'HGJSUR0222' THEN ISNULL(SIHH.Sih_refNo,0) ELSE\r\n\t\t\t\tCASE WHEN PH.Po_VendorCode = @HOCode THEN ISNULL(SIHH.Sih_refNo,0) ELSE\r\n\t\t\t\tCASE WHEN ISNULL(SIH.Sih_No_New, '') <> '' THEN SIH.Sih_No_New\r\n\t\t\t\t\t WHEN ISNULL(SIH.Sih_No_New, '') = '' THEN CAST(ISNULL(SIH.Sih_No,0) AS VARCHAR)END \r\n\t\t\t\tEND AS sih_No,---- Nidhi 14-08-2024 GID.: #897\r\n\t\t\t\tPH.Id,\r\n\t\t\t\tP\r\nSELECT *, TotalRecord = COUNT(1) OVER(), SumTotalAmount = CAST(SUM(TotalAmount) OVER() AS DECIMAL)\r\n\t\tFROM ##TEMP_PO_DATA_1 ORDER BY PO_Store_Code\r\n\t\tOFFSET @PageSize * (@PageNumber - 1) ROWS\r\n\t\tFETCH NEXT @PageSize ROWS ONLY;","method":"","class_name":"15","line_number":"58","time":"2025-09-13 15:07:14","error_code":"137","procedure":"","server":"192.168.0.245,1546","stack_trace":"at Ethics.HelperModules.DataContext.SqlDapperHelper.d__17`1.MoveNext()\r\n--- End of stack trace from previous location where exception was thrown ---\r\n at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()\r\n at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)\r\n at System.Runtime.CompilerServices.TaskAwaiter`1.GetResult()\r\n at BPPI.CPOS.BAL.Common.CommonRepositories.d__20.MoveNext() in E:\\GitProjectWork\\Dava India\\CPOS\\Web_ApiDotNet_WorkOnthis\\ZOTA.CPOS.BAL\\Common\\CommonRepositories.cs:line 433\r\n--- End of stack trace from previous location where exception was thrown ---\r\n at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()\r\n at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)\r\n at System.Runtime.CompilerServices.TaskAwaiter`1.GetResult()\r\n at BPPI.CPOS.API.Controllers.CommonController.d__3.MoveNext() in E:\\GitProjectWork\\Dava India\\CPOS\\Web_ApiDotNet_WorkOnthis\\ZOTA.CPOS.API\\Controllers\\CommonController.cs:line 72","priority":"medium","version_no":null,"app_version_no":null,"reccurence_count":1} , {"store_code":"","client_code":"","source":".Net SqlClient Data Provider","message":"Must declare the scalar variable \"@HOCode\".\r\nIncorrect syntax near 'X'.\r\nInvalid object name '##TEMP_PO_DATA_1'.\r\n\r\n\t-----~~~~ START Nishita 08-07-2025\r\n\t;WITH ErrorStatus AS (SELECT \r\n\t\tPo_Id,\r\n\t\tMAX(CONCAT('Retry Count= ',RetryCount,' , ','Error Message= ', ErrorMsg)) AS [Status] \r\n\t\tFROM PoErrorLog\r\n\t\tGROUP BY Po_Id)\r\n\t------~~~ END \r\n\t\tSELECT\tPH.PO_Store_Code AS po_Store_Code,\r\n\t\t\t\tCOUNT(*) AS itemCount,\r\n\t\t\t\t/*~~~~~~~ Nidhi 21/06/2024 GID:837 ~~~~~ */\r\n\t\t\t\tSD.category,\r\n\t\t\t\t/*~~~~~~~ GID:837 ~~~~~ */\r\n\t\t\t\tSD.Store_Name,\r\n\t\t\t\tSD.State AS state,\r\n\t\t\t\t/* GID: #1301\r\n\t\t\t\tDeveloper: Nishita Roy\r\n\t\t\t\tSummary\t : US: CPOS: Display Full Document Number Format in CPOS Reports\r\n\t\t\t\tDate : 22-08-2025*/\r\n\t\t\t\t--PH.PO_NO AS po_No,\r\n\t\t\t\tPO_No_new AS po_No,\r\n\t\t\t\t/* GID: #1301 END */\r\n\t\t\t CAST(PH.Po_No AS VARCHAR(25)) + '_' + ISNULL(CAST(PH.warehouseId AS VARCHAR(25)),1) AS po_No_Split,----~~~ Gid :#1156 Nidhi 04-04-2025\r\n\t\t\t\t--FORMAT(PH.PO_Date,'dd/MM/yyyy') AS po_Date,\r\n\t\t\t\t--ISNULL(CASE WHEN CAST(Po_UpdatedDt AS DATE) = '1900/01/01' THEN NULL ELSE FORMAT(CAST(Po_UpdatedDt AS DATE),'dd/MM/yyyy') END, FORMAT(CAST(Po_CreatedDt AS DATE),'dd/MM/yyyy')) AS approveDate,\r\n\t\t\t\t--ISNULL(CAST(Po_UpdatedDt AS DATE), CAST(Po_CreatedDt AS DATE)) AS approveDate,\r\n\t\t\t\t--ISNULL(CASE WHEN YEAR(Po_UpdatedDt) = 1900 THEN NULL ELSE CAST(Po_UpdatedDt AS DATE) END, CAST(Po_CreatedDt AS DATE)) AS approveDate,\r\n\t\t\t\t--FORMAT(PH.Po_SyncDate,'dd/MM/yyyy') Po_SyncDate,\r\n\t\t\t\t--PH.Po_SyncDate Po_SyncDate,\r\n\t\t\t\t--CASE WHEN ISNULL(CAST(Po_UpdatedDt AS DATE), CAST(Po_CreatedDt AS DATE)) > CAST(PH.Po_SyncDate AS date) THEN ISNULL(CAST(Po_UpdatedDt AS DATE), CAST(Po_CreatedDt AS DATE)) ELSE CAST(PH.Po_SyncDate AS date) END Po_SyncDate,\r\n\t\t\t\tPH.PO_Date AS po_Date,\r\n\t\t\t\t-----~~~~~~~ Start #711 Nidhi 09/04/2024 ~~~~~~~----\r\n\t\t\t\t--DateOfApprovedOrReject AS approveDate,\t\t\t\r\n\t\t\t\t CONVERT(VARCHAR(30), PH.DateOfApprovedOrReject , 120) as DateOfApprovedOrReject,\t\t\t\r\n\t\t\t -- CASE WHEN CAST(DateOfApprovedOrReject AS date) > CAST(PH.Po_SyncDate AS date) THEN CAST(DateOfApprovedOrReject AS date) ELSE CAST(PH.Po_SyncDate AS date) END Po_SyncDate,\r\n\t\t\t\tCASE WHEN CAST(PH.DateOfApprovedOrReject AS date) > CAST(PH.Po_SyncDate AS date) THEN CONVERT(VARCHAR(30), PH.DateOfApprovedOrReject , 120) ELSE CONVERT(VARCHAR(30), PH.Po_SyncDate , 120) END Po_SyncDate,\r\n\t\t\t\t-----~~~~~~~ End #711 Nidhi 09/04/2024 ~~~~~~~----\r\n\t\t\t\tISNULL(PH.Po_TotVal,0) AS TotalAmount,\r\n\t\t\t\tISNULL(G.CreditLimit,0) AS CreditLimit,\r\n\t\t\t\tISNULL(G.Pod_Amount,0) AS OutstandingAmount,\r\n\t\t\t\t--ISNULL(PH.StatusMarkAs,0) AS statusMarkAs,\r\n\t\t\t --\tCASE WHEN ISNULL(PH.statusMarkAs,0) = 0 THEN 'unApproved' WHEN ISNULL(PH.statusMarkAs,0) = 1 THEN 'approved' WHEN ISNULL(PH.statusMarkAs,0) = 2 THEN 'rejected' WHEN ISNULL(PH.statusMarkAs,0) = 3 THEN 'dispatched' WHEN ISNULL(PH.statusMarkAs,0) = 4 THEN 'hold' END statusMarkAs,\r\n\t\t\t\t ISNULL(ST.Status,'') AS statusMarkAs, ----- Gid :#14 Nidhi 30-05-2025\r\n\t\t\t\t--FORMAT(CAST(ISNULL(PH.Po_CreatedDt,PH.Po_UpdatedDt) AS DATE),'dd/MM/yyyy') AS dateOfApprovedOrReject,\r\n\t\t\t\t--CAST(ISNULL(PH.Po_CreatedDt,PH.Po_UpdatedDt) AS DATE) AS dateOfApprovedOrReject,\r\n\t\t\t\t-----~~~~~~~ Start #711 Nidhi 09/04/2024 ~~~~~~~-\r\n\t\t\t\t--CAST(DateOfApprovedOrReject AS date) AS dateOfApprovedOrReject,\r\n\t\t\t\tCAST(PH.DateOfApprovedOrReject AS date) AS dateOfApprovedOrRejectupdate,\r\n\t\t\t\t-----~~~~~~~ End #711 Nidhi 09/04/2024 ~~~~~~~-\r\n\t\t\t\tPH.Po_Sales_Order_No,\r\n\t\t\t\tsd.store_Contact_Person,\r\n\t\t\t\tsd.Mobile_No,\r\n\t\t\t\tSD.email_ID,\r\n\t\t\t\tISNULL(PH.Remark,'') AS Remark,\r\n\t\t\t\t(D.FirstName + ' ' + ISNULL(D.LastName,'')) AS ApprovedBy,\r\n\t\t\t\t--CASE WHEN PH.Po_VendorCode = 'HGJSUR0222' THEN ISNULL(SIHH.Sih_No,0) ELSE ISNULL(SIH.Sih_No,0) END AS sih_No,\r\n\t\t\t\t--CASE WHEN PH.Po_VendorCode = 'HGJSUR0222' THEN ISNULL(SIHH.Sih_refNo,0) ELSE\r\n\t\t\t\tCASE WHEN PH.Po_VendorCode = @HOCode THEN ISNULL(SIHH.Sih_refNo,0) ELSE\r\n\t\t\t\tCASE WHEN ISNULL(SIH.Sih_No_New, '') <> '' THEN SIH.Sih_No_New\r\n\t\t\t\t\t WHEN ISNULL(SIH.Sih_No_New, '') = '' THEN CAST(ISNULL(SIH.Sih_No,0) AS VARCHAR)END \r\n\t\t\t\tEND AS sih_No,---- Nidhi 14-08-2024 GID.: #897\r\n\t\t\t\tPH.Id,\r\n\t\t\t\tP\r\nSELECT *, TotalRecord = COUNT(1) OVER(), SumTotalAmount = CAST(SUM(TotalAmount) OVER() AS DECIMAL)\r\n\t\tFROM ##TEMP_PO_DATA_1 ORDER BY PO_Store_Code\r\n\t\tOFFSET @PageSize * (@PageNumber - 1) ROWS\r\n\t\tFETCH NEXT @PageSize ROWS ONLY;","method":"","class_name":"15","line_number":"58","time":"2025-09-13 15:07:34","error_code":"137","procedure":"","server":"192.168.0.245,1546","stack_trace":"at Ethics.HelperModules.DataContext.SqlDapperHelper.d__17`1.MoveNext()\r\n--- End of stack trace from previous location where exception was thrown ---\r\n at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()\r\n at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)\r\n at System.Runtime.CompilerServices.TaskAwaiter`1.GetResult()\r\n at BPPI.CPOS.BAL.Common.CommonRepositories.d__20.MoveNext() in E:\\GitProjectWork\\Dava India\\CPOS\\Web_ApiDotNet_WorkOnthis\\ZOTA.CPOS.BAL\\Common\\CommonRepositories.cs:line 433\r\n--- End of stack trace from previous location where exception was thrown ---\r\n at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()\r\n at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)\r\n at System.Runtime.CompilerServices.TaskAwaiter`1.GetResult()\r\n at BPPI.CPOS.API.Controllers.CommonController.d__3.MoveNext() in E:\\GitProjectWork\\Dava India\\CPOS\\Web_ApiDotNet_WorkOnthis\\ZOTA.CPOS.API\\Controllers\\CommonController.cs:line 72","priority":"medium","version_no":null,"app_version_no":null,"reccurence_count":1} , {"store_code":"","client_code":"","source":".Net SqlClient Data Provider","message":"Must declare the scalar variable \"@HOCode\".\r\nIncorrect syntax near 'X'.\r\nInvalid object name '##TEMP_PO_DATA_1'.\r\n\r\n\t-----~~~~ START Nishita 08-07-2025\r\n\t;WITH ErrorStatus AS (SELECT \r\n\t\tPo_Id,\r\n\t\tMAX(CONCAT('Retry Count= ',RetryCount,' , ','Error Message= ', ErrorMsg)) AS [Status] \r\n\t\tFROM PoErrorLog\r\n\t\tGROUP BY Po_Id)\r\n\t------~~~ END \r\n\t\tSELECT\tPH.PO_Store_Code AS po_Store_Code,\r\n\t\t\t\tCOUNT(*) AS itemCount,\r\n\t\t\t\t/*~~~~~~~ Nidhi 21/06/2024 GID:837 ~~~~~ */\r\n\t\t\t\tSD.category,\r\n\t\t\t\t/*~~~~~~~ GID:837 ~~~~~ */\r\n\t\t\t\tSD.Store_Name,\r\n\t\t\t\tSD.State AS state,\r\n\t\t\t\t/* GID: #1301\r\n\t\t\t\tDeveloper: Nishita Roy\r\n\t\t\t\tSummary\t : US: CPOS: Display Full Document Number Format in CPOS Reports\r\n\t\t\t\tDate : 22-08-2025*/\r\n\t\t\t\t--PH.PO_NO AS po_No,\r\n\t\t\t\tPO_No_new AS po_No,\r\n\t\t\t\t/* GID: #1301 END */\r\n\t\t\t CAST(PH.Po_No AS VARCHAR(25)) + '_' + ISNULL(CAST(PH.warehouseId AS VARCHAR(25)),1) AS po_No_Split,----~~~ Gid :#1156 Nidhi 04-04-2025\r\n\t\t\t\t--FORMAT(PH.PO_Date,'dd/MM/yyyy') AS po_Date,\r\n\t\t\t\t--ISNULL(CASE WHEN CAST(Po_UpdatedDt AS DATE) = '1900/01/01' THEN NULL ELSE FORMAT(CAST(Po_UpdatedDt AS DATE),'dd/MM/yyyy') END, FORMAT(CAST(Po_CreatedDt AS DATE),'dd/MM/yyyy')) AS approveDate,\r\n\t\t\t\t--ISNULL(CAST(Po_UpdatedDt AS DATE), CAST(Po_CreatedDt AS DATE)) AS approveDate,\r\n\t\t\t\t--ISNULL(CASE WHEN YEAR(Po_UpdatedDt) = 1900 THEN NULL ELSE CAST(Po_UpdatedDt AS DATE) END, CAST(Po_CreatedDt AS DATE)) AS approveDate,\r\n\t\t\t\t--FORMAT(PH.Po_SyncDate,'dd/MM/yyyy') Po_SyncDate,\r\n\t\t\t\t--PH.Po_SyncDate Po_SyncDate,\r\n\t\t\t\t--CASE WHEN ISNULL(CAST(Po_UpdatedDt AS DATE), CAST(Po_CreatedDt AS DATE)) > CAST(PH.Po_SyncDate AS date) THEN ISNULL(CAST(Po_UpdatedDt AS DATE), CAST(Po_CreatedDt AS DATE)) ELSE CAST(PH.Po_SyncDate AS date) END Po_SyncDate,\r\n\t\t\t\tPH.PO_Date AS po_Date,\r\n\t\t\t\t-----~~~~~~~ Start #711 Nidhi 09/04/2024 ~~~~~~~----\r\n\t\t\t\t--DateOfApprovedOrReject AS approveDate,\t\t\t\r\n\t\t\t\t CONVERT(VARCHAR(30), PH.DateOfApprovedOrReject , 120) as DateOfApprovedOrReject,\t\t\t\r\n\t\t\t -- CASE WHEN CAST(DateOfApprovedOrReject AS date) > CAST(PH.Po_SyncDate AS date) THEN CAST(DateOfApprovedOrReject AS date) ELSE CAST(PH.Po_SyncDate AS date) END Po_SyncDate,\r\n\t\t\t\tCASE WHEN CAST(PH.DateOfApprovedOrReject AS date) > CAST(PH.Po_SyncDate AS date) THEN CONVERT(VARCHAR(30), PH.DateOfApprovedOrReject , 120) ELSE CONVERT(VARCHAR(30), PH.Po_SyncDate , 120) END Po_SyncDate,\r\n\t\t\t\t-----~~~~~~~ End #711 Nidhi 09/04/2024 ~~~~~~~----\r\n\t\t\t\tISNULL(PH.Po_TotVal,0) AS TotalAmount,\r\n\t\t\t\tISNULL(G.CreditLimit,0) AS CreditLimit,\r\n\t\t\t\tISNULL(G.Pod_Amount,0) AS OutstandingAmount,\r\n\t\t\t\t--ISNULL(PH.StatusMarkAs,0) AS statusMarkAs,\r\n\t\t\t --\tCASE WHEN ISNULL(PH.statusMarkAs,0) = 0 THEN 'unApproved' WHEN ISNULL(PH.statusMarkAs,0) = 1 THEN 'approved' WHEN ISNULL(PH.statusMarkAs,0) = 2 THEN 'rejected' WHEN ISNULL(PH.statusMarkAs,0) = 3 THEN 'dispatched' WHEN ISNULL(PH.statusMarkAs,0) = 4 THEN 'hold' END statusMarkAs,\r\n\t\t\t\t ISNULL(ST.Status,'') AS statusMarkAs, ----- Gid :#14 Nidhi 30-05-2025\r\n\t\t\t\t--FORMAT(CAST(ISNULL(PH.Po_CreatedDt,PH.Po_UpdatedDt) AS DATE),'dd/MM/yyyy') AS dateOfApprovedOrReject,\r\n\t\t\t\t--CAST(ISNULL(PH.Po_CreatedDt,PH.Po_UpdatedDt) AS DATE) AS dateOfApprovedOrReject,\r\n\t\t\t\t-----~~~~~~~ Start #711 Nidhi 09/04/2024 ~~~~~~~-\r\n\t\t\t\t--CAST(DateOfApprovedOrReject AS date) AS dateOfApprovedOrReject,\r\n\t\t\t\tCAST(PH.DateOfApprovedOrReject AS date) AS dateOfApprovedOrRejectupdate,\r\n\t\t\t\t-----~~~~~~~ End #711 Nidhi 09/04/2024 ~~~~~~~-\r\n\t\t\t\tPH.Po_Sales_Order_No,\r\n\t\t\t\tsd.store_Contact_Person,\r\n\t\t\t\tsd.Mobile_No,\r\n\t\t\t\tSD.email_ID,\r\n\t\t\t\tISNULL(PH.Remark,'') AS Remark,\r\n\t\t\t\t(D.FirstName + ' ' + ISNULL(D.LastName,'')) AS ApprovedBy,\r\n\t\t\t\t--CASE WHEN PH.Po_VendorCode = 'HGJSUR0222' THEN ISNULL(SIHH.Sih_No,0) ELSE ISNULL(SIH.Sih_No,0) END AS sih_No,\r\n\t\t\t\t--CASE WHEN PH.Po_VendorCode = 'HGJSUR0222' THEN ISNULL(SIHH.Sih_refNo,0) ELSE\r\n\t\t\t\tCASE WHEN PH.Po_VendorCode = @HOCode THEN ISNULL(SIHH.Sih_refNo,0) ELSE\r\n\t\t\t\tCASE WHEN ISNULL(SIH.Sih_No_New, '') <> '' THEN SIH.Sih_No_New\r\n\t\t\t\t\t WHEN ISNULL(SIH.Sih_No_New, '') = '' THEN CAST(ISNULL(SIH.Sih_No,0) AS VARCHAR)END \r\n\t\t\t\tEND AS sih_No,---- Nidhi 14-08-2024 GID.: #897\r\n\t\t\t\tPH.Id,\r\n\t\t\t\tP\r\nSELECT *, TotalRecord = COUNT(1) OVER(), SumTotalAmount = CAST(SUM(TotalAmount) OVER() AS DECIMAL)\r\n\t\tFROM ##TEMP_PO_DATA_1 ORDER BY PO_Store_Code\r\n\t\tOFFSET @PageSize * (@PageNumber - 1) ROWS\r\n\t\tFETCH NEXT @PageSize ROWS ONLY;","method":"","class_name":"15","line_number":"58","time":"2025-09-13 15:08:33","error_code":"137","procedure":"","server":"192.168.0.245,1546","stack_trace":"at Ethics.HelperModules.DataContext.SqlDapperHelper.d__17`1.MoveNext()\r\n--- End of stack trace from previous location where exception was thrown ---\r\n at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()\r\n at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)\r\n at System.Runtime.CompilerServices.TaskAwaiter`1.GetResult()\r\n at BPPI.CPOS.BAL.Common.CommonRepositories.d__20.MoveNext() in E:\\GitProjectWork\\Dava India\\CPOS\\Web_ApiDotNet_WorkOnthis\\ZOTA.CPOS.BAL\\Common\\CommonRepositories.cs:line 433\r\n--- End of stack trace from previous location where exception was thrown ---\r\n at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()\r\n at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)\r\n at System.Runtime.CompilerServices.TaskAwaiter`1.GetResult()\r\n at BPPI.CPOS.API.Controllers.CommonController.d__3.MoveNext() in E:\\GitProjectWork\\Dava India\\CPOS\\Web_ApiDotNet_WorkOnthis\\ZOTA.CPOS.API\\Controllers\\CommonController.cs:line 72","priority":"medium","version_no":null,"app_version_no":null,"reccurence_count":1} , {"store_code":"","client_code":"","source":"","message":"Data Not Found. SyncId:40","method":"","class_name":"","line_number":"","time":"2025-09-13 17:16:45","error_code":"","procedure":"","server":"","stack_trace":"","priority":"","version_no":null,"app_version_no":null,"reccurence_count":1} ,