Log File Initialized... 1/31/2025 1:29:36 AM
1/31/2025 1:29:36 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)
1/31/2025 1:41:08 AM: The maximum allowed amount is 30000\. You have already Policies amount of 23000\. and adding more 11400\. will result in 34400\. which is greater than 30000\.
ZealERP.ZealFramework.Utils.ZealException: The maximum allowed amount is 30000\. You have already Policies amount of 23000\. and adding more 11400\. will result in 34400\. which is greater than 30000\.
   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__DisplayClass21_0.<Save>b__0(OracleCommand command)
   at ZealERP.ZealFramework.Utils.ZealTransactionHandler.ExecuteTransaction(TransactionBody _TransactionBody)
1/31/2025 1:41:08 AM: The maximum allowed amount is 30000\. You have already Policies amount of 23000\. and adding more 11400\. will result in 34400\. which is greater than 30000\.
ZealERP.ZealFramework.Utils.ZealException: The maximum allowed amount is 30000\. You have already Policies amount of 23000\. and adding more 11400\. will result in 34400\. which is greater than 30000\.
   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__DisplayClass21_0.<Save>b__0(OracleCommand command)
   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.<SaveDataSecure>b__0()
1/31/2025 1:41:21 AM: The maximum allowed amount is 30000\. You have already Policies amount of 23000\. and adding more 11400\. will result in 34400\. which is greater than 30000\.
ZealERP.ZealFramework.Utils.ZealException: The maximum allowed amount is 30000\. You have already Policies amount of 23000\. and adding more 11400\. will result in 34400\. which is greater than 30000\.
   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__DisplayClass21_0.<Save>b__0(OracleCommand command)
   at ZealERP.ZealFramework.Utils.ZealTransactionHandler.ExecuteTransaction(TransactionBody _TransactionBody)
1/31/2025 1:41:21 AM: The maximum allowed amount is 30000\. You have already Policies amount of 23000\. and adding more 11400\. will result in 34400\. which is greater than 30000\.
ZealERP.ZealFramework.Utils.ZealException: The maximum allowed amount is 30000\. You have already Policies amount of 23000\. and adding more 11400\. will result in 34400\. which is greater than 30000\.
   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__DisplayClass21_0.<Save>b__0(OracleCommand command)
   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.<SaveDataSecure>b__0()
1/31/2025 1:43:30 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)
1/31/2025 1:43:57 AM: The maximum allowed amount is 30000\. You have already Policies amount of 23000\. and adding more 11400\. will result in 34400\. which is greater than 30000\.
ZealERP.ZealFramework.Utils.ZealException: The maximum allowed amount is 30000\. You have already Policies amount of 23000\. and adding more 11400\. will result in 34400\. which is greater than 30000\.
   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__DisplayClass21_0.<Save>b__0(OracleCommand command)
   at ZealERP.ZealFramework.Utils.ZealTransactionHandler.ExecuteTransaction(TransactionBody _TransactionBody)
1/31/2025 1:43:57 AM: The maximum allowed amount is 30000\. You have already Policies amount of 23000\. and adding more 11400\. will result in 34400\. which is greater than 30000\.
ZealERP.ZealFramework.Utils.ZealException: The maximum allowed amount is 30000\. You have already Policies amount of 23000\. and adding more 11400\. will result in 34400\. which is greater than 30000\.
   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__DisplayClass21_0.<Save>b__0(OracleCommand command)
   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.<SaveDataSecure>b__0()
1/31/2025 1:47:18 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)
1/31/2025 1:56: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)
1/31/2025 2:08:00 AM: Invalid Credentials
ZealERP.ZealFramework.Utils.ZealException: Invalid Credentials
   at ZealERP.ZealSecurity.Services.NewSecurity.UserService.ValidateUser(User record)
   at ZealERP.ZealSecurity.Services.NewSecurity.UserService.Login(String UserId, String password)
   at ZealERP.ZealTakaful.LoginNew.btnLogin_Click(Object sender, EventArgs e)
1/31/2025 2:08:30 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)
1/31/2025 2:38:23 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)
1/31/2025 2:42:29 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)
1/31/2025 2:50:29 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)
1/31/2025 2:53:24 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)
1/31/2025 2:57: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)
1/31/2025 3:00:26 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)
1/31/2025 3:45:33 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)
1/31/2025 4:25:25 AM: Invalid Credentials
ZealERP.ZealFramework.Utils.ZealException: Invalid Credentials
   at ZealERP.ZealSecurity.Services.NewSecurity.UserService.ValidateUser(User record)
   at ZealERP.ZealSecurity.Services.NewSecurity.UserService.Login(String UserId, String password)
   at ZealERP.ZealTakaful.LoginNew.btnLogin_Click(Object sender, EventArgs e)
1/31/2025 4:25:31 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)
1/31/2025 4:26: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)
1/31/2025 4:26:13 AM: SELECT a.LOADING_VALUE,a.LOADING_CONTRIBUTION_MODAL, CASE WHEN a.LOADING_TYPE = 'RT' THEN 'Extra Mortality' WHEN a.LOADING_TYPE = 'CTRY' THEN 'Residential Class' WHEN a.LOADING_TYPE = 'OC' THEN 'Occupational Class' WHEN a.LOADING_TYPE = 'AL' THEN 'Additional Loading' END LOADING_DESC FROM TK_ILL_POS_LOADING a  where a.ORG_ID='8'  and a.BRANCH_ID='14'  and a.MAIN_PRODUCT_CODE='2'  and a.SUB_PRODUCT_CODE='11'  and a.DOCUMENT_NO='000047'  and a.DOCUMENT_YEAR='2024'  and a.ISSUE_COUNT='1'  and a.APPLICATION_ID='13' 
1/31/2025 4:26:13 AM: select  gen_paramdtl.DESCRIPTION ||' - '||b.DESCRIPTION as DESCRIPTION,COST_CENTER_CODE, nvl(MAX_PARTIAL_SURRENDER,0) MAX_PARTIAL_SURRENDER, nvl(MIN_RESIDUAL_VALUE,0) MIN_RESIDUAL_VALUE  ,nvl(TOPUP_ALLOCATION,0) TOPUP_ALLOCATION  ,AGE_BASIS,nvl(CALCULATION_AGE_TYPE ,'A') CALCULATION_AGE_TYPE  ,nvl(OFFER_SPREAD_RATE,0) OFFER_SPREAD_RATE, TREATY_DETAIL_CODE, nvl(ANF_MONTHS_AFTER_COMM,0) ANF_MONTHS_AFTER_COMM  ,nvl(NON_PAYMENT_STATUS,0) NON_PAYMENT_STATUS  ,nvl(ANF_VALID_MONTHS,0) ANF_VALID_MONTHS  ,nvl(LAPSE_REINSTATE_YEARS,0) LAPSE_REINSTATE_YEARS  ,nvl(LAPSE_CHARGES_MONTHS,0) LAPSE_CHARGES_MONTHS  ,nvl(MAX_MATURITY_AGE,0) MAX_MATURITY_AGE  ,nvl(MIN_CONTRIBUTION,0) MIN_CONTRIBUTION  ,nvl(MAX_CONTRIBUTION_ADHOC,0) MAX_CONTRIBUTION_ADHOC  ,nvl(MIN_CONTRIBUTION_ADHOC,0) MIN_CONTRIBUTION_ADHOC  ,nvl(SURRENDER_PROCESSING_FEE,0) SURRENDER_PROCESSING_FEE  ,nvl(DUPLICATE_PMD_CHARGES,0) DUPLICATE_PMD_CHARGES  ,nvl(BUNDLE_AT_ISSUE,0) BUNDLE_AT_ISSUE  ,nvl(DUPLICATE_BUNDLE,0) DUPLICATE_BUNDLE  ,nvl(DISCOUNTING_FACTOR,0) DISCOUNTING_FACTOR  ,nvl(PAY_TERM,'N') PAY_TERM  ,nvl(ALLOW_REVERSE_CALC,'N') ALLOW_REVERSE_CALC  ,nvl(AUTO_CALCULATION_TAG,'N') AUTO_CALCULATION_TAG  ,nvl(AUTO_UNDERWRITING_TAG,'N') AUTO_UNDERWRITING_TAG  ,nvl(b.ACTIVE,'N') ACTIVE  ,nvl(b.ILLUSTRATION_DETAILS_BASES,'N') ILLUSTRATION_DETAILS_BASES  ,nvl(b.INPUT_BASIS,'N') INPUT_BASIS  ,nvl(b.CONTRIBUTION_TYPE_IL,0) CONTRIBUTION_TYPE_IL  ,nvl(b.TABARRU_CALC_TYPE,'SAR') TABARRU_CALC_TYPE  ,nvl(b.BID_OFFER_PRICE_SAME,'N') BID_OFFER_PRICE_SAME  ,nvl(b.NEED_ANALYSIS_REQD,'N') NEED_ANALYSIS_REQD  ,nvl(b.LAST_AGE_INDEX, 0) LAST_AGE_INDEX  ,nvl(b.CONT_MARGIN, 0) CONT_MARGIN  ,nvl(b.EXPECTED_CLAIM, 0) EXPECTED_CLAIM  ,nvl(b.INVESTMENT_INCOME, 0) INVESTMENT_INCOME  ,nvl(b.WAQALA_FEE, 0) WAQALA_FEE  ,b.MAIN_PRODUCT_CODE,b.PRODUCT_TYPE_IL  from GLAS_SUB_PRODUCT_SETUP_T b  left outer join GEN_PARAM_SETUPHD_T gen_paramhd on gen_paramhd.ORG_ID=b.ORG_ID AND gen_paramhd.APPLICATION_ID=b.APPLICATION_ID and gen_paramhd.SETUP_NAME='MAIN PRODUCT'  left outer join GEN_PARAM_SETUP_DTL_T gen_paramdtl on gen_paramhd.ORG_ID= gen_paramdtl.ORG_ID and  gen_paramhd.SETUP_ID=gen_paramdtl.SETUP_ID AND gen_paramhd.APPLICATION_ID=gen_paramdtl.APPLICATION_ID and gen_paramdtl.ABBREVIATION= to_char(b.MAIN_PRODUCT_CODE)  where b.ORG_ID = :ORG_ID and b.MAIN_PRODUCT_CODE = :MAIN_PRODUCT_CODE and b.SUB_PRODUCT_CODE = :SUB_PRODUCT_CODE params: ORG_ID=8, MAIN_PRODUCT_CODE=2, SUB_PRODUCT_CODE=11
1/31/2025 4:26:13 AM: Error in route [api/CommonParamsGLAS/CalculateContributionOnSA] class: CommonParamsGLASController:
Oracle.ManagedDataAccess.Client.OracleException (0x80004005): ORA-00904: "DUPLICATE_BUNDLE": invalid identifier
   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)
   at ZealERP.ZealFramework.Utils.DB.ExecuteQuery(String query, OracleParameter[] commandParameters, OracleCommand trans)
   at ZealERP.ZealTakaful.Services.GLAS.ProductSetupService.GetProductInfo(Int32 OrgId, Int32 MainProductCode, Int32 SubProductCode, OracleCommand command)
   at ZealERP.ZealTakaful.Services.TakafulTech.IllustrationService.CalculateContributionOnSA(CommonParamsDataModelForPost record)
   at ZealERP.ZealTakaful.Controllers.CommonParamsGLASController.<>c__DisplayClass33_0.<CalculateContributionOnSA>b__0()
   at ZealERP.ZealFramework.Utils.ZealRestApiHandler.GetResponse(ControllerLogic GetDataFromService)
1/31/2025 4:26:13 AM: Error in route [api/Illustration/GetLoadingRateOfProduct] class: IllustrationController:
Oracle.ManagedDataAccess.Client.OracleException (0x80004005): ORA-00904: "A"."LOADING_CONTRIBUTION_MODAL": invalid identifier
   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)
   at ZealERP.ZealFramework.Utils.DB.ExecuteQuery(String query)
   at ZealERP.ZealTakaful.Services.TakafulTech.IllustrationService.GetLoadingRateOfProduct(IllustrationHeaderDataModel model)
   at ZealERP.ZealTakaful.Controllers.TakafulTech.IllustrationController.<>c__DisplayClass35_0.<GetLoadingRateOfProduct>b__0()
   at ZealERP.ZealFramework.Utils.ZealRestApiHandler.GetResponse(ControllerLogic GetDataFromService)
1/31/2025 4:26:17 AM: select  gen_paramdtl.DESCRIPTION ||' - '||b.DESCRIPTION as DESCRIPTION,COST_CENTER_CODE, nvl(MAX_PARTIAL_SURRENDER,0) MAX_PARTIAL_SURRENDER, nvl(MIN_RESIDUAL_VALUE,0) MIN_RESIDUAL_VALUE  ,nvl(TOPUP_ALLOCATION,0) TOPUP_ALLOCATION  ,AGE_BASIS,nvl(CALCULATION_AGE_TYPE ,'A') CALCULATION_AGE_TYPE  ,nvl(OFFER_SPREAD_RATE,0) OFFER_SPREAD_RATE, TREATY_DETAIL_CODE, nvl(ANF_MONTHS_AFTER_COMM,0) ANF_MONTHS_AFTER_COMM  ,nvl(NON_PAYMENT_STATUS,0) NON_PAYMENT_STATUS  ,nvl(ANF_VALID_MONTHS,0) ANF_VALID_MONTHS  ,nvl(LAPSE_REINSTATE_YEARS,0) LAPSE_REINSTATE_YEARS  ,nvl(LAPSE_CHARGES_MONTHS,0) LAPSE_CHARGES_MONTHS  ,nvl(MAX_MATURITY_AGE,0) MAX_MATURITY_AGE  ,nvl(MIN_CONTRIBUTION,0) MIN_CONTRIBUTION  ,nvl(MAX_CONTRIBUTION_ADHOC,0) MAX_CONTRIBUTION_ADHOC  ,nvl(MIN_CONTRIBUTION_ADHOC,0) MIN_CONTRIBUTION_ADHOC  ,nvl(SURRENDER_PROCESSING_FEE,0) SURRENDER_PROCESSING_FEE  ,nvl(DUPLICATE_PMD_CHARGES,0) DUPLICATE_PMD_CHARGES  ,nvl(BUNDLE_AT_ISSUE,0) BUNDLE_AT_ISSUE  ,nvl(DUPLICATE_BUNDLE,0) DUPLICATE_BUNDLE  ,nvl(DISCOUNTING_FACTOR,0) DISCOUNTING_FACTOR  ,nvl(PAY_TERM,'N') PAY_TERM  ,nvl(ALLOW_REVERSE_CALC,'N') ALLOW_REVERSE_CALC  ,nvl(AUTO_CALCULATION_TAG,'N') AUTO_CALCULATION_TAG  ,nvl(AUTO_UNDERWRITING_TAG,'N') AUTO_UNDERWRITING_TAG  ,nvl(b.ACTIVE,'N') ACTIVE  ,nvl(b.ILLUSTRATION_DETAILS_BASES,'N') ILLUSTRATION_DETAILS_BASES  ,nvl(b.INPUT_BASIS,'N') INPUT_BASIS  ,nvl(b.CONTRIBUTION_TYPE_IL,0) CONTRIBUTION_TYPE_IL  ,nvl(b.TABARRU_CALC_TYPE,'SAR') TABARRU_CALC_TYPE  ,nvl(b.BID_OFFER_PRICE_SAME,'N') BID_OFFER_PRICE_SAME  ,nvl(b.NEED_ANALYSIS_REQD,'N') NEED_ANALYSIS_REQD  ,nvl(b.LAST_AGE_INDEX, 0) LAST_AGE_INDEX  ,nvl(b.CONT_MARGIN, 0) CONT_MARGIN  ,nvl(b.EXPECTED_CLAIM, 0) EXPECTED_CLAIM  ,nvl(b.INVESTMENT_INCOME, 0) INVESTMENT_INCOME  ,nvl(b.WAQALA_FEE, 0) WAQALA_FEE  ,b.MAIN_PRODUCT_CODE,b.PRODUCT_TYPE_IL  from GLAS_SUB_PRODUCT_SETUP_T b  left outer join GEN_PARAM_SETUPHD_T gen_paramhd on gen_paramhd.ORG_ID=b.ORG_ID AND gen_paramhd.APPLICATION_ID=b.APPLICATION_ID and gen_paramhd.SETUP_NAME='MAIN PRODUCT'  left outer join GEN_PARAM_SETUP_DTL_T gen_paramdtl on gen_paramhd.ORG_ID= gen_paramdtl.ORG_ID and  gen_paramhd.SETUP_ID=gen_paramdtl.SETUP_ID AND gen_paramhd.APPLICATION_ID=gen_paramdtl.APPLICATION_ID and gen_paramdtl.ABBREVIATION= to_char(b.MAIN_PRODUCT_CODE)  where b.ORG_ID = :ORG_ID and b.MAIN_PRODUCT_CODE = :MAIN_PRODUCT_CODE and b.SUB_PRODUCT_CODE = :SUB_PRODUCT_CODE params: ORG_ID=8, MAIN_PRODUCT_CODE=2, SUB_PRODUCT_CODE=11
1/31/2025 4:26:17 AM: Error in route [api/Illustration/GetIllustrationDetail] class: IllustrationController:
Oracle.ManagedDataAccess.Client.OracleException (0x80004005): ORA-00904: "DUPLICATE_BUNDLE": invalid identifier
   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)
   at ZealERP.ZealFramework.Utils.DB.ExecuteQuery(String query, OracleParameter[] commandParameters, OracleCommand trans)
   at ZealERP.ZealTakaful.Services.GLAS.ProductSetupService.GetProductInfo(Int32 OrgId, Int32 MainProductCode, Int32 SubProductCode, OracleCommand command)
   at ZealERP.ZealTakaful.Services.GLAS.ProductSetupService.GetProductInfo(IllustrationHeaderDataModel model, OracleCommand command)
   at ZealERP.ZealTakaful.Services.TakafulTech.IllustrationService.ValidateNegativeIllustrationValues(IllustrationHeaderDataModel model)
   at ZealERP.ZealTakaful.Services.TakafulTech.IllustrationService.GetIllustrationDetailYearWise(IllustrationHeaderDataModel model)
   at ZealERP.ZealTakaful.Controllers.TakafulTech.IllustrationController.<>c__DisplayClass11_0.<GetIllustrationDetail>b__0()
   at ZealERP.ZealFramework.Utils.ZealRestApiHandler.GetResponse(ControllerLogic GetDataFromService)
1/31/2025 4:26:17 AM: select  gen_paramdtl.DESCRIPTION ||' - '||b.DESCRIPTION as DESCRIPTION,COST_CENTER_CODE, nvl(MAX_PARTIAL_SURRENDER,0) MAX_PARTIAL_SURRENDER, nvl(MIN_RESIDUAL_VALUE,0) MIN_RESIDUAL_VALUE  ,nvl(TOPUP_ALLOCATION,0) TOPUP_ALLOCATION  ,AGE_BASIS,nvl(CALCULATION_AGE_TYPE ,'A') CALCULATION_AGE_TYPE  ,nvl(OFFER_SPREAD_RATE,0) OFFER_SPREAD_RATE, TREATY_DETAIL_CODE, nvl(ANF_MONTHS_AFTER_COMM,0) ANF_MONTHS_AFTER_COMM  ,nvl(NON_PAYMENT_STATUS,0) NON_PAYMENT_STATUS  ,nvl(ANF_VALID_MONTHS,0) ANF_VALID_MONTHS  ,nvl(LAPSE_REINSTATE_YEARS,0) LAPSE_REINSTATE_YEARS  ,nvl(LAPSE_CHARGES_MONTHS,0) LAPSE_CHARGES_MONTHS  ,nvl(MAX_MATURITY_AGE,0) MAX_MATURITY_AGE  ,nvl(MIN_CONTRIBUTION,0) MIN_CONTRIBUTION  ,nvl(MAX_CONTRIBUTION_ADHOC,0) MAX_CONTRIBUTION_ADHOC  ,nvl(MIN_CONTRIBUTION_ADHOC,0) MIN_CONTRIBUTION_ADHOC  ,nvl(SURRENDER_PROCESSING_FEE,0) SURRENDER_PROCESSING_FEE  ,nvl(DUPLICATE_PMD_CHARGES,0) DUPLICATE_PMD_CHARGES  ,nvl(BUNDLE_AT_ISSUE,0) BUNDLE_AT_ISSUE  ,nvl(DUPLICATE_BUNDLE,0) DUPLICATE_BUNDLE  ,nvl(DISCOUNTING_FACTOR,0) DISCOUNTING_FACTOR  ,nvl(PAY_TERM,'N') PAY_TERM  ,nvl(ALLOW_REVERSE_CALC,'N') ALLOW_REVERSE_CALC  ,nvl(AUTO_CALCULATION_TAG,'N') AUTO_CALCULATION_TAG  ,nvl(AUTO_UNDERWRITING_TAG,'N') AUTO_UNDERWRITING_TAG  ,nvl(b.ACTIVE,'N') ACTIVE  ,nvl(b.ILLUSTRATION_DETAILS_BASES,'N') ILLUSTRATION_DETAILS_BASES  ,nvl(b.INPUT_BASIS,'N') INPUT_BASIS  ,nvl(b.CONTRIBUTION_TYPE_IL,0) CONTRIBUTION_TYPE_IL  ,nvl(b.TABARRU_CALC_TYPE,'SAR') TABARRU_CALC_TYPE  ,nvl(b.BID_OFFER_PRICE_SAME,'N') BID_OFFER_PRICE_SAME  ,nvl(b.NEED_ANALYSIS_REQD,'N') NEED_ANALYSIS_REQD  ,nvl(b.LAST_AGE_INDEX, 0) LAST_AGE_INDEX  ,nvl(b.CONT_MARGIN, 0) CONT_MARGIN  ,nvl(b.EXPECTED_CLAIM, 0) EXPECTED_CLAIM  ,nvl(b.INVESTMENT_INCOME, 0) INVESTMENT_INCOME  ,nvl(b.WAQALA_FEE, 0) WAQALA_FEE  ,b.MAIN_PRODUCT_CODE,b.PRODUCT_TYPE_IL  from GLAS_SUB_PRODUCT_SETUP_T b  left outer join GEN_PARAM_SETUPHD_T gen_paramhd on gen_paramhd.ORG_ID=b.ORG_ID AND gen_paramhd.APPLICATION_ID=b.APPLICATION_ID and gen_paramhd.SETUP_NAME='MAIN PRODUCT'  left outer join GEN_PARAM_SETUP_DTL_T gen_paramdtl on gen_paramhd.ORG_ID= gen_paramdtl.ORG_ID and  gen_paramhd.SETUP_ID=gen_paramdtl.SETUP_ID AND gen_paramhd.APPLICATION_ID=gen_paramdtl.APPLICATION_ID and gen_paramdtl.ABBREVIATION= to_char(b.MAIN_PRODUCT_CODE)  where b.ORG_ID = :ORG_ID and b.MAIN_PRODUCT_CODE = :MAIN_PRODUCT_CODE and b.SUB_PRODUCT_CODE = :SUB_PRODUCT_CODE params: ORG_ID=8, MAIN_PRODUCT_CODE=2, SUB_PRODUCT_CODE=11
1/31/2025 4:26:17 AM: Error in route [api/Illustration/GetIllustrationDetail] class: IllustrationController:
Oracle.ManagedDataAccess.Client.OracleException (0x80004005): ORA-00904: "DUPLICATE_BUNDLE": invalid identifier
   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)
   at ZealERP.ZealFramework.Utils.DB.ExecuteQuery(String query, OracleParameter[] commandParameters, OracleCommand trans)
   at ZealERP.ZealTakaful.Services.GLAS.ProductSetupService.GetProductInfo(Int32 OrgId, Int32 MainProductCode, Int32 SubProductCode, OracleCommand command)
   at ZealERP.ZealTakaful.Services.GLAS.ProductSetupService.GetProductInfo(IllustrationHeaderDataModel model, OracleCommand command)
   at ZealERP.ZealTakaful.Services.TakafulTech.IllustrationService.ValidateNegativeIllustrationValues(IllustrationHeaderDataModel model)
   at ZealERP.ZealTakaful.Services.TakafulTech.IllustrationService.GetIllustrationDetailYearWise(IllustrationHeaderDataModel model)
   at ZealERP.ZealTakaful.Controllers.TakafulTech.IllustrationController.<>c__DisplayClass11_0.<GetIllustrationDetail>b__0()
   at ZealERP.ZealFramework.Utils.ZealRestApiHandler.GetResponse(ControllerLogic GetDataFromService)
1/31/2025 4:26:27 AM: select  gen_paramdtl.DESCRIPTION ||' - '||b.DESCRIPTION as DESCRIPTION,COST_CENTER_CODE, nvl(MAX_PARTIAL_SURRENDER,0) MAX_PARTIAL_SURRENDER, nvl(MIN_RESIDUAL_VALUE,0) MIN_RESIDUAL_VALUE  ,nvl(TOPUP_ALLOCATION,0) TOPUP_ALLOCATION  ,AGE_BASIS,nvl(CALCULATION_AGE_TYPE ,'A') CALCULATION_AGE_TYPE  ,nvl(OFFER_SPREAD_RATE,0) OFFER_SPREAD_RATE, TREATY_DETAIL_CODE, nvl(ANF_MONTHS_AFTER_COMM,0) ANF_MONTHS_AFTER_COMM  ,nvl(NON_PAYMENT_STATUS,0) NON_PAYMENT_STATUS  ,nvl(ANF_VALID_MONTHS,0) ANF_VALID_MONTHS  ,nvl(LAPSE_REINSTATE_YEARS,0) LAPSE_REINSTATE_YEARS  ,nvl(LAPSE_CHARGES_MONTHS,0) LAPSE_CHARGES_MONTHS  ,nvl(MAX_MATURITY_AGE,0) MAX_MATURITY_AGE  ,nvl(MIN_CONTRIBUTION,0) MIN_CONTRIBUTION  ,nvl(MAX_CONTRIBUTION_ADHOC,0) MAX_CONTRIBUTION_ADHOC  ,nvl(MIN_CONTRIBUTION_ADHOC,0) MIN_CONTRIBUTION_ADHOC  ,nvl(SURRENDER_PROCESSING_FEE,0) SURRENDER_PROCESSING_FEE  ,nvl(DUPLICATE_PMD_CHARGES,0) DUPLICATE_PMD_CHARGES  ,nvl(BUNDLE_AT_ISSUE,0) BUNDLE_AT_ISSUE  ,nvl(DUPLICATE_BUNDLE,0) DUPLICATE_BUNDLE  ,nvl(DISCOUNTING_FACTOR,0) DISCOUNTING_FACTOR  ,nvl(PAY_TERM,'N') PAY_TERM  ,nvl(ALLOW_REVERSE_CALC,'N') ALLOW_REVERSE_CALC  ,nvl(AUTO_CALCULATION_TAG,'N') AUTO_CALCULATION_TAG  ,nvl(AUTO_UNDERWRITING_TAG,'N') AUTO_UNDERWRITING_TAG  ,nvl(b.ACTIVE,'N') ACTIVE  ,nvl(b.ILLUSTRATION_DETAILS_BASES,'N') ILLUSTRATION_DETAILS_BASES  ,nvl(b.INPUT_BASIS,'N') INPUT_BASIS  ,nvl(b.CONTRIBUTION_TYPE_IL,0) CONTRIBUTION_TYPE_IL  ,nvl(b.TABARRU_CALC_TYPE,'SAR') TABARRU_CALC_TYPE  ,nvl(b.BID_OFFER_PRICE_SAME,'N') BID_OFFER_PRICE_SAME  ,nvl(b.NEED_ANALYSIS_REQD,'N') NEED_ANALYSIS_REQD  ,nvl(b.LAST_AGE_INDEX, 0) LAST_AGE_INDEX  ,nvl(b.CONT_MARGIN, 0) CONT_MARGIN  ,nvl(b.EXPECTED_CLAIM, 0) EXPECTED_CLAIM  ,nvl(b.INVESTMENT_INCOME, 0) INVESTMENT_INCOME  ,nvl(b.WAQALA_FEE, 0) WAQALA_FEE  ,b.MAIN_PRODUCT_CODE,b.PRODUCT_TYPE_IL  from GLAS_SUB_PRODUCT_SETUP_T b  left outer join GEN_PARAM_SETUPHD_T gen_paramhd on gen_paramhd.ORG_ID=b.ORG_ID AND gen_paramhd.APPLICATION_ID=b.APPLICATION_ID and gen_paramhd.SETUP_NAME='MAIN PRODUCT'  left outer join GEN_PARAM_SETUP_DTL_T gen_paramdtl on gen_paramhd.ORG_ID= gen_paramdtl.ORG_ID and  gen_paramhd.SETUP_ID=gen_paramdtl.SETUP_ID AND gen_paramhd.APPLICATION_ID=gen_paramdtl.APPLICATION_ID and gen_paramdtl.ABBREVIATION= to_char(b.MAIN_PRODUCT_CODE)  where b.ORG_ID = :ORG_ID and b.MAIN_PRODUCT_CODE = :MAIN_PRODUCT_CODE and b.SUB_PRODUCT_CODE = :SUB_PRODUCT_CODE params: ORG_ID=8, MAIN_PRODUCT_CODE=2, SUB_PRODUCT_CODE=11
1/31/2025 4:26:27 AM: Error in route [api/Illustration/GetIllustrationDetail] class: IllustrationController:
Oracle.ManagedDataAccess.Client.OracleException (0x80004005): ORA-00904: "DUPLICATE_BUNDLE": invalid identifier
   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)
   at ZealERP.ZealFramework.Utils.DB.ExecuteQuery(String query, OracleParameter[] commandParameters, OracleCommand trans)
   at ZealERP.ZealTakaful.Services.GLAS.ProductSetupService.GetProductInfo(Int32 OrgId, Int32 MainProductCode, Int32 SubProductCode, OracleCommand command)
   at ZealERP.ZealTakaful.Services.GLAS.ProductSetupService.GetProductInfo(IllustrationHeaderDataModel model, OracleCommand command)
   at ZealERP.ZealTakaful.Services.TakafulTech.IllustrationService.ValidateNegativeIllustrationValues(IllustrationHeaderDataModel model)
   at ZealERP.ZealTakaful.Services.TakafulTech.IllustrationService.GetIllustrationDetailYearWise(IllustrationHeaderDataModel model)
   at ZealERP.ZealTakaful.Controllers.TakafulTech.IllustrationController.<>c__DisplayClass11_0.<GetIllustrationDetail>b__0()
   at ZealERP.ZealFramework.Utils.ZealRestApiHandler.GetResponse(ControllerLogic GetDataFromService)
1/31/2025 4:29:03 AM: User Profile is Inactive
ZealERP.ZealFramework.Utils.ZealException: User Profile is Inactive
   at ZealERP.ZealSecurity.Services.NewSecurity.UserService.ValidateUser(User record)
   at ZealERP.ZealSecurity.Services.NewSecurity.UserService.Login(String UserId, String password)
   at ZealERP.ZealTakaful.LoginNew.btnLogin_Click(Object sender, EventArgs e)
1/31/2025 4:35:06 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)
1/31/2025 4:38:47 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)
1/31/2025 4:40:13 AM: Invalid Credentials
ZealERP.ZealFramework.Utils.ZealException: Invalid Credentials
   at ZealERP.ZealSecurity.Services.NewSecurity.UserService.ValidateUser(User record)
   at ZealERP.ZealSecurity.Services.NewSecurity.UserService.Login(String UserId, String password)
   at ZealERP.ZealTakaful.LoginNew.btnLogin_Click(Object sender, EventArgs e)
1/31/2025 4:40:34 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)
1/31/2025 4:43:42 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)
1/31/2025 5:04: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)
1/31/2025 6:15:08 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)
1/31/2025 7:30:17 AM: Object reference not set to an instance of an object.
System.NullReferenceException: Object reference not set to an instance of an object.
   at ZealERP.ZealTakaful.ZealUtil.ZealReportRDLC.ExecuteReport(String ReportPath, NameValueCollection Form, ReportViewer ReportViewer1, HttpResponse Response)
1/31/2025 7:30:17 AM: Object reference not set to an instance of an object.
System.NullReferenceException: Object reference not set to an instance of an object.
   at ZealERP.ZealTakaful.ZealUtil.ZealReportRDLC.ExecuteReport(String ReportPath, NameValueCollection Form, ReportViewer ReportViewer1, HttpResponse Response)
1/31/2025 10:26:53 AM: Object reference not set to an instance of an object.
System.NullReferenceException: Object reference not set to an instance of an object.
   at ZealERP.ZealTakaful.Reports.InvestigationSettlementLetter.InvestigationSettlementLetter.PrepareReport()
1/31/2025 10:26:53 AM: Object reference not set to an instance of an object.
System.NullReferenceException: Object reference not set to an instance of an object.
   at ZealERP.ZealTakaful.Reports.InvestigationSettlementLetter.InvestigationSettlementLetter.PrepareReport()
1/31/2025 11:17:31 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)
1/31/2025 11:50:59 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)
1/31/2025 11:54:43 PM: insert into TRAVEL_INVOICE_DETAIL_T ( SERIAL_NO ,ORG_ID ,BRANCH_ID ,INVOICE_NO ,CREATED_BY ,CREATION_DATE ,POLICY_NUMBER ,TOTAL_CONTRIBUTION ,AGENT_COMMISSION ,AGENT_AMOUNT ,AGENT ,TOTAL_PAYABLE ) values (  '1'  ,'6'  ,'1'  ,'495'  ,'global.tips'  ,sysdate,'SIL/P/2025/3/23/Doc-005987'  ,'3000'  ,'40'  ,'1200'  ,'696'  ,'0'  )
1/31/2025 11:54:43 PM: insert into TRAVEL_INVOICE_DETAIL_T ( SERIAL_NO ,ORG_ID ,BRANCH_ID ,INVOICE_NO ,CREATED_BY ,CREATION_DATE ,POLICY_NUMBER ,TOTAL_CONTRIBUTION ,AGENT_COMMISSION ,AGENT_AMOUNT ,AGENT ,TOTAL_PAYABLE ) values (  '1'  ,'6'  ,'1'  ,'495'  ,'global.tips'  ,sysdate,'SIL/P/2025/3/23/Doc-005987'  ,'3000'  ,'40'  ,'1200'  ,'696'  ,'0'  )
1/31/2025 11:54:43 PM: insert into TRAVEL_INVOICE_DETAIL_T ( SERIAL_NO ,ORG_ID ,BRANCH_ID ,INVOICE_NO ,CREATED_BY ,CREATION_DATE ,POLICY_NUMBER ,TOTAL_CONTRIBUTION ,AGENT_COMMISSION ,AGENT_AMOUNT ,AGENT ,TOTAL_PAYABLE ) values (  '3'  ,'6'  ,'1'  ,'495'  ,'global.tips'  ,sysdate,'SIL/P/2025/3/23/Doc-005987'  ,'3000'  ,'40'  ,'1200'  ,'696'  ,'0'  )
1/31/2025 11:54:43 PM: Error in route [api/TravelPolicy/SaveTravelInvoiceDetail] class: TravelPolicyController:
Oracle.ManagedDataAccess.Client.OracleException (0x80004005): ORA-00001: unique constraint (ZEAL_ERP.PK_TRAVEL_INVOICE_DTL) violated
   at OracleInternal.ServiceObjects.OracleConnectionImpl.VerifyExecution(Int32& cursorId, Boolean bThrowArrayBindRelatedErrors, SqlStatementType sqlStatementType, Int32 arrayBindCount, OracleException& exceptionForArrayBindDML, Boolean& hasMoreRowsInDB, Boolean bFirstIterationDone)
   at OracleInternal.ServiceObjects.OracleCommandImpl.ExecuteNonQuery(String commandText, OracleParameterCollection paramColl, CommandType commandType, OracleConnectionImpl connectionImpl, Int32 longFetchSize, Int64 clientInitialLOBFS, OracleDependencyImpl orclDependencyImpl, Int64[]& scnFromExecution, OracleParameterCollection& bindByPositionParamColl, Boolean& bBindParamPresent, OracleException& exceptionForArrayBindDML, OracleConnection connection, Boolean isFromEF)
   at Oracle.ManagedDataAccess.Client.OracleCommand.ExecuteNonQuery()
   at ZealERP.ZealFramework.Utils.DB.ExecuteDML(String query, OracleParameter[] commandParameters, Boolean ExecuteSp, OracleCommand trans)
   at ZealERP.ZealFramework.Utils.DB.ExecuteDML(String query, OracleCommand command)
   at ZealERP.ZealTakaful.Services.Travel.TravelPolicyService.<>c__DisplayClass17_0.<SaveTravelInvoiceDetail>b__0(OracleCommand command)
   at ZealERP.ZealFramework.Utils.ZealTransactionHandler.ExecuteTransaction(TransactionBody _TransactionBody)
   at ZealERP.ZealTakaful.Services.Travel.TravelPolicyService.SaveTravelInvoiceDetail(TravelModel record)
   at ZealERP.ZealTakaful.Controllers.TravelPolicy.TravelPolicyController.<>c__DisplayClass18_0.<SaveTravelInvoiceDetail>b__0()
   at ZealERP.ZealFramework.Utils.ZealRestApiHandler.GetResponse(ControllerLogic GetDataFromService)
1/31/2025 11:54:43 PM: Error in route [api/TravelPolicy/SaveTravelInvoiceDetail] class: TravelPolicyController:
Oracle.ManagedDataAccess.Client.OracleException (0x80004005): ORA-00001: unique constraint (ZEAL_ERP.PK_TRAVEL_INVOICE_DTL) violated
   at OracleInternal.ServiceObjects.OracleConnectionImpl.VerifyExecution(Int32& cursorId, Boolean bThrowArrayBindRelatedErrors, SqlStatementType sqlStatementType, Int32 arrayBindCount, OracleException& exceptionForArrayBindDML, Boolean& hasMoreRowsInDB, Boolean bFirstIterationDone)
   at OracleInternal.ServiceObjects.OracleCommandImpl.ExecuteNonQuery(String commandText, OracleParameterCollection paramColl, CommandType commandType, OracleConnectionImpl connectionImpl, Int32 longFetchSize, Int64 clientInitialLOBFS, OracleDependencyImpl orclDependencyImpl, Int64[]& scnFromExecution, OracleParameterCollection& bindByPositionParamColl, Boolean& bBindParamPresent, OracleException& exceptionForArrayBindDML, OracleConnection connection, Boolean isFromEF)
   at Oracle.ManagedDataAccess.Client.OracleCommand.ExecuteNonQuery()
   at ZealERP.ZealFramework.Utils.DB.ExecuteDML(String query, OracleParameter[] commandParameters, Boolean ExecuteSp, OracleCommand trans)
   at ZealERP.ZealFramework.Utils.DB.ExecuteDML(String query, OracleCommand command)
   at ZealERP.ZealTakaful.Services.Travel.TravelPolicyService.<>c__DisplayClass17_0.<SaveTravelInvoiceDetail>b__0(OracleCommand command)
   at ZealERP.ZealFramework.Utils.ZealTransactionHandler.ExecuteTransaction(TransactionBody _TransactionBody)
   at ZealERP.ZealTakaful.Services.Travel.TravelPolicyService.SaveTravelInvoiceDetail(TravelModel record)
   at ZealERP.ZealTakaful.Controllers.TravelPolicy.TravelPolicyController.<>c__DisplayClass18_0.<SaveTravelInvoiceDetail>b__0()
   at ZealERP.ZealFramework.Utils.ZealRestApiHandler.GetResponse(ControllerLogic GetDataFromService)
1/31/2025 11:54:43 PM: Error in route [api/TravelPolicy/SaveTravelInvoiceDetail] class: TravelPolicyController:
Oracle.ManagedDataAccess.Client.OracleException (0x80004005): ORA-00001: unique constraint (ZEAL_ERP.PK_TRAVEL_INVOICE_DTL) violated
   at OracleInternal.ServiceObjects.OracleConnectionImpl.VerifyExecution(Int32& cursorId, Boolean bThrowArrayBindRelatedErrors, SqlStatementType sqlStatementType, Int32 arrayBindCount, OracleException& exceptionForArrayBindDML, Boolean& hasMoreRowsInDB, Boolean bFirstIterationDone)
   at OracleInternal.ServiceObjects.OracleCommandImpl.ExecuteNonQuery(String commandText, OracleParameterCollection paramColl, CommandType commandType, OracleConnectionImpl connectionImpl, Int32 longFetchSize, Int64 clientInitialLOBFS, OracleDependencyImpl orclDependencyImpl, Int64[]& scnFromExecution, OracleParameterCollection& bindByPositionParamColl, Boolean& bBindParamPresent, OracleException& exceptionForArrayBindDML, OracleConnection connection, Boolean isFromEF)
   at Oracle.ManagedDataAccess.Client.OracleCommand.ExecuteNonQuery()
   at ZealERP.ZealFramework.Utils.DB.ExecuteDML(String query, OracleParameter[] commandParameters, Boolean ExecuteSp, OracleCommand trans)
   at ZealERP.ZealFramework.Utils.DB.ExecuteDML(String query, OracleCommand command)
   at ZealERP.ZealTakaful.Services.Travel.TravelPolicyService.<>c__DisplayClass17_0.<SaveTravelInvoiceDetail>b__0(OracleCommand command)
   at ZealERP.ZealFramework.Utils.ZealTransactionHandler.ExecuteTransaction(TransactionBody _TransactionBody)
   at ZealERP.ZealTakaful.Services.Travel.TravelPolicyService.SaveTravelInvoiceDetail(TravelModel record)
   at ZealERP.ZealTakaful.Controllers.TravelPolicy.TravelPolicyController.<>c__DisplayClass18_0.<SaveTravelInvoiceDetail>b__0()
   at ZealERP.ZealFramework.Utils.ZealRestApiHandler.GetResponse(ControllerLogic GetDataFromService)
1/31/2025 11:56:21 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)