Log File Initialized... 12/28/2024 12:20:22 AM 12/28/2024 12:20:22 AM: User email does not match with employee email ZealERP.ZealFramework.Utils.ZealException: User email does not match with employee email at ZealERP.ZealTakaful.Services.LeaveManagement.LeaveRequestService.GetEmployeeId(String orgId) at ZealERP.ZealTakaful.AppSelection.Page_Load(Object sender, EventArgs e) 12/28/2024 1:17:20 AM: User email does not match with employee email ZealERP.ZealFramework.Utils.ZealException: User email does not match with employee email at ZealERP.ZealTakaful.Services.LeaveManagement.LeaveRequestService.GetEmployeeId(String orgId) at ZealERP.ZealTakaful.AppSelection.Page_Load(Object sender, EventArgs e) 12/28/2024 1:29:54 AM: User email does not match with employee email ZealERP.ZealFramework.Utils.ZealException: User email does not match with employee email at ZealERP.ZealTakaful.Services.LeaveManagement.LeaveRequestService.GetEmployeeId(String orgId) at ZealERP.ZealTakaful.AppSelection.Page_Load(Object sender, EventArgs e) 12/28/2024 1:39:39 AM: User email does not match with employee email ZealERP.ZealFramework.Utils.ZealException: User email does not match with employee email at ZealERP.ZealTakaful.Services.LeaveManagement.LeaveRequestService.GetEmployeeId(String orgId) at ZealERP.ZealTakaful.AppSelection.Page_Load(Object sender, EventArgs e) 12/28/2024 1:39:56 AM: User email does not match with employee email ZealERP.ZealFramework.Utils.ZealException: User email does not match with employee email at ZealERP.ZealTakaful.Services.LeaveManagement.LeaveRequestService.GetEmployeeId(String orgId) at ZealERP.ZealTakaful.AppSelection.Page_Load(Object sender, EventArgs e) 12/28/2024 1:42:12 AM: User email does not match with employee email ZealERP.ZealFramework.Utils.ZealException: User email does not match with employee email at ZealERP.ZealTakaful.Services.LeaveManagement.LeaveRequestService.GetEmployeeId(String orgId) at ZealERP.ZealTakaful.AppSelection.Page_Load(Object sender, EventArgs e) 12/28/2024 1:50:53 AM: User email does not match with employee email ZealERP.ZealFramework.Utils.ZealException: User email does not match with employee email at ZealERP.ZealTakaful.Services.LeaveManagement.LeaveRequestService.GetEmployeeId(String orgId) at ZealERP.ZealTakaful.AppSelection.Page_Load(Object sender, EventArgs e) 12/28/2024 2:03:51 AM: User email does not match with employee email ZealERP.ZealFramework.Utils.ZealException: User email does not match with employee email at ZealERP.ZealTakaful.Services.LeaveManagement.LeaveRequestService.GetEmployeeId(String orgId) at ZealERP.ZealTakaful.AppSelection.Page_Load(Object sender, EventArgs e) 12/28/2024 2:05:25 AM: SELECT AGE_FROM,AGE_FROM_TYPE,AGE_TO FROM TRAVEL_PLAN_T WHERE ORG_ID=6 AND TP_ID= AND BRANCH_ID=1 12/28/2024 2:05:25 AM: ORA-00936: missing expression Oracle.ManagedDataAccess.Client.OracleException (0x80004005): ORA-00936: missing expression at OracleInternal.ServiceObjects.OracleConnectionImpl.VerifyExecution(Int32& cursorId, Boolean bThrowArrayBindRelatedErrors, SqlStatementType sqlStatementType, Int32 arrayBindCount, OracleException& exceptionForArrayBindDML, Boolean& hasMoreRowsInDB, Boolean bFirstIterationDone) at OracleInternal.ServiceObjects.OracleCommandImpl.ExecuteReader(String commandText, OracleParameterCollection paramColl, CommandType commandType, OracleConnectionImpl connectionImpl, OracleDataReaderImpl& rdrImpl, Int32 longFetchSize, Int64 clientInitialLOBFS, OracleDependencyImpl orclDependencyImpl, Int64[] scnForExecution, Int64[]& scnFromExecution, OracleParameterCollection& bindByPositionParamColl, Boolean& bBindParamPresent, Int64& internalInitialLOBFS, Int64 internalInitialJSONFS, OracleException& exceptionForArrayBindDML, OracleConnection connection, IEnumerable`1 adrianParsedStmt, Boolean isDescribeOnly, Boolean isFromEF) at Oracle.ManagedDataAccess.Client.OracleCommand.ExecuteReader(Boolean requery, Boolean fillRequest, CommandBehavior behavior) at Oracle.ManagedDataAccess.Client.OracleDataAdapter.Fill(DataTable[] dataTables, Int32 startRecord, Int32 maxRecords, IDbCommand command, CommandBehavior behavior) at System.Data.Common.DbDataAdapter.Fill(DataTable dataTable) at ZealERP.ZealFramework.Utils.DB.ExecuteQuery(String query, OracleParameter[] commandParameters, Boolean ExecuteSp, OracleCommand trans, Boolean PrintLog) 12/28/2024 2:05:25 AM: ORA-00936: missing expression Oracle.ManagedDataAccess.Client.OracleException (0x80004005): ORA-00936: missing expression at ZealERP.ZealFramework.Utils.DB.ExecuteQuery(String query, OracleParameter[] commandParameters, Boolean ExecuteSp, OracleCommand trans, Boolean PrintLog) at ZealERP.ZealFramework.Utils.DB.ExecuteQuery(String query, OracleCommand trans) at ZealERP.ZealTakaful.Services.DBServiceChildTravelPolicy.ValidateAgeForPlan(SaveDataModel record, OracleCommand command) at ZealERP.ZealTakaful.Services.DBServiceChildTravelPolicy.BeforeSave(SaveDataModel record, OracleCommand command) at ZealERP.ZealFramework.Services.DBService.<>c__DisplayClass20_0.b__0(OracleCommand command) at ZealERP.ZealFramework.Utils.ZealTransactionHandler.ExecuteTransaction(TransactionBody _TransactionBody) 12/28/2024 2:05:25 AM: ORA-00936: missing expression Oracle.ManagedDataAccess.Client.OracleException (0x80004005): ORA-00936: missing expression at ZealERP.ZealFramework.Utils.ZealTransactionHandler.ExecuteTransaction(TransactionBody _TransactionBody) at ZealERP.ZealFramework.Services.DBService.Save(SaveDataModel record) at ZealERP.ZealFramework.Services.DBService.SaveSecure(SaveDataModel record) at ZealERP.ZealTakaful.Controllers.DBController.<>c__DisplayClass6_0.b__0() 12/28/2024 2:05:45 AM: SELECT AGE_FROM,AGE_FROM_TYPE,AGE_TO FROM TRAVEL_PLAN_T WHERE ORG_ID=6 AND TP_ID= AND BRANCH_ID=1 12/28/2024 2:05:45 AM: ORA-00936: missing expression Oracle.ManagedDataAccess.Client.OracleException (0x80004005): ORA-00936: missing expression at OracleInternal.ServiceObjects.OracleConnectionImpl.VerifyExecution(Int32& cursorId, Boolean bThrowArrayBindRelatedErrors, SqlStatementType sqlStatementType, Int32 arrayBindCount, OracleException& exceptionForArrayBindDML, Boolean& hasMoreRowsInDB, Boolean bFirstIterationDone) at OracleInternal.ServiceObjects.OracleCommandImpl.ExecuteReader(String commandText, OracleParameterCollection paramColl, CommandType commandType, OracleConnectionImpl connectionImpl, OracleDataReaderImpl& rdrImpl, Int32 longFetchSize, Int64 clientInitialLOBFS, OracleDependencyImpl orclDependencyImpl, Int64[] scnForExecution, Int64[]& scnFromExecution, OracleParameterCollection& bindByPositionParamColl, Boolean& bBindParamPresent, Int64& internalInitialLOBFS, Int64 internalInitialJSONFS, OracleException& exceptionForArrayBindDML, OracleConnection connection, IEnumerable`1 adrianParsedStmt, Boolean isDescribeOnly, Boolean isFromEF) at Oracle.ManagedDataAccess.Client.OracleCommand.ExecuteReader(Boolean requery, Boolean fillRequest, CommandBehavior behavior) at Oracle.ManagedDataAccess.Client.OracleDataAdapter.Fill(DataTable[] dataTables, Int32 startRecord, Int32 maxRecords, IDbCommand command, CommandBehavior behavior) at System.Data.Common.DbDataAdapter.Fill(DataTable dataTable) at ZealERP.ZealFramework.Utils.DB.ExecuteQuery(String query, OracleParameter[] commandParameters, Boolean ExecuteSp, OracleCommand trans, Boolean PrintLog) 12/28/2024 2:05:45 AM: ORA-00936: missing expression Oracle.ManagedDataAccess.Client.OracleException (0x80004005): ORA-00936: missing expression at ZealERP.ZealFramework.Utils.DB.ExecuteQuery(String query, OracleParameter[] commandParameters, Boolean ExecuteSp, OracleCommand trans, Boolean PrintLog) at ZealERP.ZealFramework.Utils.DB.ExecuteQuery(String query, OracleCommand trans) at ZealERP.ZealTakaful.Services.DBServiceChildTravelPolicy.ValidateAgeForPlan(SaveDataModel record, OracleCommand command) at ZealERP.ZealTakaful.Services.DBServiceChildTravelPolicy.BeforeSave(SaveDataModel record, OracleCommand command) at ZealERP.ZealFramework.Services.DBService.<>c__DisplayClass20_0.b__0(OracleCommand command) at ZealERP.ZealFramework.Utils.ZealTransactionHandler.ExecuteTransaction(TransactionBody _TransactionBody) 12/28/2024 2:05:45 AM: ORA-00936: missing expression Oracle.ManagedDataAccess.Client.OracleException (0x80004005): ORA-00936: missing expression at ZealERP.ZealFramework.Utils.ZealTransactionHandler.ExecuteTransaction(TransactionBody _TransactionBody) at ZealERP.ZealFramework.Services.DBService.Save(SaveDataModel record) at ZealERP.ZealFramework.Services.DBService.SaveSecure(SaveDataModel record) at ZealERP.ZealTakaful.Controllers.DBController.<>c__DisplayClass6_0.b__0() 12/28/2024 2:18:22 AM: The maximum allowed amount is 200000\. You have already Policies amount of 198250\. and adding more 1950\. will result in 200200\. which is greater than 200000\. ZealERP.ZealFramework.Utils.ZealException: The maximum allowed amount is 200000\. You have already Policies amount of 198250\. and adding more 1950\. will result in 200200\. which is greater than 200000\. at ZealERP.ZealTakaful.Services.DBServiceChildTravelPolicy.ValidateAmounts(SaveDataModel record, OracleCommand command) at ZealERP.ZealTakaful.Services.DBServiceChildTravelPolicy.BeforeSave(SaveDataModel record, OracleCommand command) at ZealERP.ZealFramework.Services.DBService.<>c__DisplayClass20_0.b__0(OracleCommand command) at ZealERP.ZealFramework.Utils.ZealTransactionHandler.ExecuteTransaction(TransactionBody _TransactionBody) 12/28/2024 2:18:22 AM: Error.. The maximum allowed amount is 200000\. You have already Policies amount of 198250\. and adding more 1950\. will result in 200200\. which is greater than 200000\. ZealERP.ZealFramework.Utils.ZealException: Error.. The maximum allowed amount is 200000\. You have already Policies amount of 198250\. and adding more 1950\. will result in 200200\. which is greater than 200000\. at ZealERP.ZealFramework.Utils.ZealTransactionHandler.ExecuteTransaction(TransactionBody _TransactionBody) at ZealERP.ZealFramework.Services.DBService.Save(SaveDataModel record) at ZealERP.ZealFramework.Services.DBService.SaveSecure(SaveDataModel record) at ZealERP.ZealTakaful.Controllers.DBController.<>c__DisplayClass6_0.b__0() 12/28/2024 2:18:38 AM: The maximum allowed amount is 200000\. You have already Policies amount of 198250\. and adding more 1950\. will result in 200200\. which is greater than 200000\. ZealERP.ZealFramework.Utils.ZealException: The maximum allowed amount is 200000\. You have already Policies amount of 198250\. and adding more 1950\. will result in 200200\. which is greater than 200000\. at ZealERP.ZealTakaful.Services.DBServiceChildTravelPolicy.ValidateAmounts(SaveDataModel record, OracleCommand command) at ZealERP.ZealTakaful.Services.DBServiceChildTravelPolicy.BeforeSave(SaveDataModel record, OracleCommand command) at ZealERP.ZealFramework.Services.DBService.<>c__DisplayClass20_0.b__0(OracleCommand command) at ZealERP.ZealFramework.Utils.ZealTransactionHandler.ExecuteTransaction(TransactionBody _TransactionBody) 12/28/2024 2:18:38 AM: Error.. The maximum allowed amount is 200000\. You have already Policies amount of 198250\. and adding more 1950\. will result in 200200\. which is greater than 200000\. ZealERP.ZealFramework.Utils.ZealException: Error.. The maximum allowed amount is 200000\. You have already Policies amount of 198250\. and adding more 1950\. will result in 200200\. which is greater than 200000\. at ZealERP.ZealFramework.Utils.ZealTransactionHandler.ExecuteTransaction(TransactionBody _TransactionBody) at ZealERP.ZealFramework.Services.DBService.Save(SaveDataModel record) at ZealERP.ZealFramework.Services.DBService.SaveSecure(SaveDataModel record) at ZealERP.ZealTakaful.Controllers.DBController.<>c__DisplayClass6_0.b__0() 12/28/2024 2:19:07 AM: The maximum allowed amount is 200000\. You have already Policies amount of 198250\. and adding more 1950\. will result in 200200\. which is greater than 200000\. ZealERP.ZealFramework.Utils.ZealException: The maximum allowed amount is 200000\. You have already Policies amount of 198250\. and adding more 1950\. will result in 200200\. which is greater than 200000\. at ZealERP.ZealTakaful.Services.DBServiceChildTravelPolicy.ValidateAmounts(SaveDataModel record, OracleCommand command) at ZealERP.ZealTakaful.Services.DBServiceChildTravelPolicy.BeforeSave(SaveDataModel record, OracleCommand command) at ZealERP.ZealFramework.Services.DBService.<>c__DisplayClass20_0.b__0(OracleCommand command) at ZealERP.ZealFramework.Utils.ZealTransactionHandler.ExecuteTransaction(TransactionBody _TransactionBody) 12/28/2024 2:19:07 AM: Error.. The maximum allowed amount is 200000\. You have already Policies amount of 198250\. and adding more 1950\. will result in 200200\. which is greater than 200000\. ZealERP.ZealFramework.Utils.ZealException: Error.. The maximum allowed amount is 200000\. You have already Policies amount of 198250\. and adding more 1950\. will result in 200200\. which is greater than 200000\. at ZealERP.ZealFramework.Utils.ZealTransactionHandler.ExecuteTransaction(TransactionBody _TransactionBody) at ZealERP.ZealFramework.Services.DBService.Save(SaveDataModel record) at ZealERP.ZealFramework.Services.DBService.SaveSecure(SaveDataModel record) at ZealERP.ZealTakaful.Controllers.DBController.<>c__DisplayClass6_0.b__0() 12/28/2024 2:21:46 AM: User email does not match with employee email ZealERP.ZealFramework.Utils.ZealException: User email does not match with employee email at ZealERP.ZealTakaful.Services.LeaveManagement.LeaveRequestService.GetEmployeeId(String orgId) at ZealERP.ZealTakaful.AppSelection.Page_Load(Object sender, EventArgs e) 12/28/2024 2:24:57 AM: User email does not match with employee email ZealERP.ZealFramework.Utils.ZealException: User email does not match with employee email at ZealERP.ZealTakaful.Services.LeaveManagement.LeaveRequestService.GetEmployeeId(String orgId) at ZealERP.ZealTakaful.AppSelection.Page_Load(Object sender, EventArgs e) 12/28/2024 2:39:14 AM: User email does not match with employee email ZealERP.ZealFramework.Utils.ZealException: User email does not match with employee email at ZealERP.ZealTakaful.Services.LeaveManagement.LeaveRequestService.GetEmployeeId(String orgId) at ZealERP.ZealTakaful.AppSelection.Page_Load(Object sender, EventArgs e) 12/28/2024 2:39:50 AM: User email does not match with employee email ZealERP.ZealFramework.Utils.ZealException: User email does not match with employee email at ZealERP.ZealTakaful.Services.LeaveManagement.LeaveRequestService.GetEmployeeId(String orgId) at ZealERP.ZealTakaful.AppSelection.Page_Load(Object sender, EventArgs e) 12/28/2024 2:42:37 AM: User email does not match with employee email ZealERP.ZealFramework.Utils.ZealException: User email does not match with employee email at ZealERP.ZealTakaful.Services.LeaveManagement.LeaveRequestService.GetEmployeeId(String orgId) at ZealERP.ZealTakaful.AppSelection.Page_Load(Object sender, EventArgs e) 12/28/2024 3:17:07 AM: User email does not match with employee email ZealERP.ZealFramework.Utils.ZealException: User email does not match with employee email at ZealERP.ZealTakaful.Services.LeaveManagement.LeaveRequestService.GetEmployeeId(String orgId) at ZealERP.ZealTakaful.AppSelection.Page_Load(Object sender, EventArgs e) 12/28/2024 3:21:04 AM: User email does not match with employee email ZealERP.ZealFramework.Utils.ZealException: User email does not match with employee email at ZealERP.ZealTakaful.Services.LeaveManagement.LeaveRequestService.GetEmployeeId(String orgId) at ZealERP.ZealTakaful.AppSelection.Page_Load(Object sender, EventArgs e) 12/28/2024 4:21:28 AM: User email does not match with employee email ZealERP.ZealFramework.Utils.ZealException: User email does not match with employee email at ZealERP.ZealTakaful.Services.LeaveManagement.LeaveRequestService.GetEmployeeId(String orgId) at ZealERP.ZealTakaful.AppSelection.Page_Load(Object sender, EventArgs e) 12/28/2024 4:46:11 AM: User email does not match with employee email ZealERP.ZealFramework.Utils.ZealException: User email does not match with employee email at ZealERP.ZealTakaful.Services.LeaveManagement.LeaveRequestService.GetEmployeeId(String orgId) at ZealERP.ZealTakaful.AppSelection.Page_Load(Object sender, EventArgs e) 12/28/2024 7:25:12 AM: User email does not match with employee email ZealERP.ZealFramework.Utils.ZealException: User email does not match with employee email at ZealERP.ZealTakaful.Services.LeaveManagement.LeaveRequestService.GetEmployeeId(String orgId) at ZealERP.ZealTakaful.AppSelection.Page_Load(Object sender, EventArgs e) 12/28/2024 5:03:41 PM: User email does not match with employee email ZealERP.ZealFramework.Utils.ZealException: User email does not match with employee email at ZealERP.ZealTakaful.Services.LeaveManagement.LeaveRequestService.GetEmployeeId(String orgId) at ZealERP.ZealTakaful.AppSelection.Page_Load(Object sender, EventArgs e) 12/28/2024 5:05:16 PM: select H.INVOICE_NO,(D.TOTAL_CONTRIBUTION-D.AGENT_AMOUNT)AS PAYABLE_TO_INSURANCE_COMPANY,H.POST_FLAG,H.SETTLED_TAG,a.ORG_ID,a.branch_id ,B.PLAN_NAME,a.CANCEL_STATUS,a.DOCUMENT_NUMBER,a.EMAIL,a.ADDRESS,a.TRAVEL_PURPOSE,a.DESTINATION_COUNTRY,a.DESTINATION_CITY,a.DESTINATION_STATE ,a.CONTRIBUTION_AMOUNT,a.NM_OF_DAYS,a.POLICY_NUMBER ,a.POLICY_STATUS,a.FULL_NAME , a.MOBILE_NO ,a.PLAN,a.PLAN_TYPE,a.DESTINATION,to_char(a.START_DATE,'dd/MM/yyyy') START_DATE, to_char(a.DATE_OF_BIRTH,'dd/MM/yyyy')DATE_OF_BIRTH ,a.FILER , a.CNIC_NO ,to_char(a.CNIC_ISSUE_DATE,'dd/MM/yyyy')CNIC_ISSUE_DATE , a.PASSPORT_NO, a.AGE_AT_ENTRY,NVL(A.AGE_TYPE,'Y') AS AGE_TYPE,NVL(A.OVER_AGE,'N') AS OVER_AGE,NVL(A.ALLOW_OVER_AGE,'N')AS ALLOW_OVER_AGE,a.NO_OF_DEPENDENT, a.SPOUSE_NAME,a.CHILD_NAME_1,a.DESTINATION2, a.CHILD_NAME_2, a.CHILD_NAME_3,a.CREATED_BY,to_char(a.CREATION_DATE,'dd/MM/yyyy')CREATION_DATE from TRAVLE_POLICY_T a left join TRAVEL_PLAN_T b on(a.ORG_ID=b.ORG_ID AND a.PLAN=b.TP_ID and a.branch_id=b.branch_id) LEFT JOIN TRAVEL_INVOICE_DETAIL_T D ON (A.ORG_ID=D.ORG_ID AND A.POLICY_NUMBER=D.POLICY_NUMBER AND A.BRANCH_ID=D.BRANCH_ID) LEFT JOIN travel_invoice_header_t H ON (D.ORG_ID=H.ORG_ID AND D.INVOICE_NO=H.INVOICE_NO AND D.BRANCH_ID=H.BRANCH_ID) WHERE a.org_id=6 and a.BRANCH_ID=1 AND (a.CREATION_DATE>to_date('28/12/2024','dd/MM/yyyy') or to_char(A.CREATION_DATE,'dd/MM/yyyy')='28/12/2024') AND (a.CREATION_DATEc__DisplayClass3_0.b__0() at ZealERP.ZealFramework.Utils.ZealRestApiHandler.GetResponse(ControllerLogic GetDataFromService) 12/28/2024 5:05:24 PM: select H.INVOICE_NO,(D.TOTAL_CONTRIBUTION-D.AGENT_AMOUNT)AS PAYABLE_TO_INSURANCE_COMPANY,H.POST_FLAG,H.SETTLED_TAG,a.ORG_ID,a.branch_id ,B.PLAN_NAME,a.CANCEL_STATUS,a.DOCUMENT_NUMBER,a.EMAIL,a.ADDRESS,a.TRAVEL_PURPOSE,a.DESTINATION_COUNTRY,a.DESTINATION_CITY,a.DESTINATION_STATE ,a.CONTRIBUTION_AMOUNT,a.NM_OF_DAYS,a.POLICY_NUMBER ,a.POLICY_STATUS,a.FULL_NAME , a.MOBILE_NO ,a.PLAN,a.PLAN_TYPE,a.DESTINATION,to_char(a.START_DATE,'dd/MM/yyyy') START_DATE, to_char(a.DATE_OF_BIRTH,'dd/MM/yyyy')DATE_OF_BIRTH ,a.FILER , a.CNIC_NO ,to_char(a.CNIC_ISSUE_DATE,'dd/MM/yyyy')CNIC_ISSUE_DATE , a.PASSPORT_NO, a.AGE_AT_ENTRY,NVL(A.AGE_TYPE,'Y') AS AGE_TYPE,NVL(A.OVER_AGE,'N') AS OVER_AGE,NVL(A.ALLOW_OVER_AGE,'N')AS ALLOW_OVER_AGE,a.NO_OF_DEPENDENT, a.SPOUSE_NAME,a.CHILD_NAME_1,a.DESTINATION2, a.CHILD_NAME_2, a.CHILD_NAME_3,a.CREATED_BY,to_char(a.CREATION_DATE,'dd/MM/yyyy')CREATION_DATE from TRAVLE_POLICY_T a left join TRAVEL_PLAN_T b on(a.ORG_ID=b.ORG_ID AND a.PLAN=b.TP_ID and a.branch_id=b.branch_id) LEFT JOIN TRAVEL_INVOICE_DETAIL_T D ON (A.ORG_ID=D.ORG_ID AND A.POLICY_NUMBER=D.POLICY_NUMBER AND A.BRANCH_ID=D.BRANCH_ID) LEFT JOIN travel_invoice_header_t H ON (D.ORG_ID=H.ORG_ID AND D.INVOICE_NO=H.INVOICE_NO AND D.BRANCH_ID=H.BRANCH_ID) WHERE a.org_id=6 and a.BRANCH_ID=1 AND (a.CREATION_DATE>to_date('28/12/2024','dd/MM/yyyy') or to_char(A.CREATION_DATE,'dd/MM/yyyy')='28/12/2024') AND (a.CREATION_DATEc__DisplayClass3_0.b__0() at ZealERP.ZealFramework.Utils.ZealRestApiHandler.GetResponse(ControllerLogic GetDataFromService)