Log File Initialized... 10/14/2024 12:12:27 AM 10/14/2024 12:12:27 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) 10/14/2024 1:00: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) 10/14/2024 1:08: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) 10/14/2024 1:28: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) 10/14/2024 1:31: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) 10/14/2024 1:33:25 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) 10/14/2024 1:41: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) 10/14/2024 1:41:38 AM: Thread was being aborted. System.Threading.ThreadAbortException: Thread was being aborted. at System.Threading.Thread.AbortInternal() at System.Threading.Thread.Abort(Object stateInfo) at System.Web.HttpResponse.AbortCurrentThread() at System.Web.HttpResponse.End() at System.Web.HttpResponse.Redirect(String url, Boolean endResponse, Boolean permanent) at System.Web.HttpResponse.Redirect(String url) at ZealERP.ZealTakaful.AppSelection.Page_Load(Object sender, EventArgs e) 10/14/2024 1:47: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) 10/14/2024 1:50: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) 10/14/2024 1:53: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) 10/14/2024 1:58:24 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) 10/14/2024 1:58:24 AM: **************************** Error at Login Request for User ameertrvl@tourism90, Message: Invalid Credentials **************************** 10/14/2024 1:58: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) 10/14/2024 1:59:38 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) 10/14/2024 2:10: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) 10/14/2024 2:16:48 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) 10/14/2024 2:19:30 AM: Face value / Sum Assured cannot be less than Product Setup Main Plan Min SA 290000 ZealERP.ZealFramework.Utils.ZealException: Face value / Sum Assured cannot be less than Product Setup Main Plan Min SA 290000 at ZealERP.ZealTakaful.Services.TakafulTech.IllustrationService.CalculateContributionOnSA(CommonParamsDataModelForPost record) at ZealERP.ZealTakaful.Controllers.CommonParamsGLASController.<>c__DisplayClass32_0.b__0() at ZealERP.ZealFramework.Utils.ZealRestApiHandler.GetResponse(ControllerLogic GetDataFromService) 10/14/2024 2:22: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) 10/14/2024 2: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) 10/14/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) 10/14/2024 2:45: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) 10/14/2024 2:46:52 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) 10/14/2024 2:51: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) 10/14/2024 2:52: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) 10/14/2024 2:56:25 AM: HELP 10/14/2024 2:56:25 AM: OrgId 8 10/14/2024 2:56:25 AM: DateFrom 10/14/2024 2:56:25 AM: ToDate 10/14/2024 2:56:25 AM: IsDocumentNo false 10/14/2024 2:58:41 AM: HELP 10/14/2024 2:58:41 AM: OrgId 8 10/14/2024 2:58:41 AM: DateFrom 10/14/2024 2:58:41 AM: ToDate 10/14/2024 2:58:41 AM: IsDocumentNo false 10/14/2024 3:06: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) 10/14/2024 3:06:49 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) 10/14/2024 3:07:09 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) 10/14/2024 3:21: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) 10/14/2024 3:26:19 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) 10/14/2024 3:27:13 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) 10/14/2024 3:28:48 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) 10/14/2024 3:33:31 AM: Thread was being aborted. System.Threading.ThreadAbortException: Thread was being aborted. at System.Threading.Thread.AbortInternal() at System.Threading.Thread.Abort(Object stateInfo) at System.Web.HttpResponse.AbortCurrentThread() at System.Web.HttpResponse.End() at System.Web.HttpResponse.Redirect(String url, Boolean endResponse, Boolean permanent) at System.Web.HttpResponse.Redirect(String url) at ZealERP.ZealTakaful.AppSelection.Page_Load(Object sender, EventArgs e) 10/14/2024 3:34: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) 10/14/2024 3:34:44 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) 10/14/2024 3:34: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) 10/14/2024 3:34:55 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) 10/14/2024 3:38:43 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) 10/14/2024 3:39:01 AM: SELECT PB.PARTNER_BRANCH_NAME,a.ADVANCE_AMOUNT, a.AGE1, a.AGE2, a.AGENT_ID, a.ALTERATION_TYPE, a.APPLICATION_ID, a.BASE_DOC_NO, a.BASE_DOC_NO_KEY,a.BASIC_CONTRIBUTION, a.BASIC_CONTRIBUTION_MODAL, A.BID_OFFER, a.BRANCH_ID, a.CANCEL_BY, a.CANCEL_TAG, a.CANCELLATION_REMARKS, a.CANCELLATION_TYPE, a.CHANNEL_ID,a.CHARGEABLE_AMOUNT, a.CHARGEABLE_FROM, a.CLIENT_CODE, a.CNIC_NO, a.CONSIGNMENT_NO, a.CONT_MARGIN, a.CONTRIBUTION_INDEX, a.CONVERT_TAG, a.CONVERTED_DOC_NO_KEY,a.CONVERTED_POLICY_NO, a.COVER_MULTIPLE, a.FACE_VALUE_INCREASE_TAG, a.CREATED_BY , a.CURRENCY_CODE, a.DOC_REFERENCE_KEY , a.DOC_REFERENCE_KEY , a.DOC_REFERENCE_NO, a.DOCUMENT_NO,a.DOCUMENT_TYPE, a.DOCUMENT_YEAR, a.ENDORSEMENT_NO, a.EXCHANGE_RATE, a.EXPECTED_CLAIM, a.GENDER1, a.GENDER2, a.GROSS_CONTRIBUTION, a.ILLUSTRATION_REF_NO, a.ILLUSTRATION_REF_NO_KEY,a.INITIAL_TOPUP , a.INVESTMENT_INCOME,a.ISSUE_COUNT, a.ISSUE_COUNT, a.LAST_AGE_INDEX, a.LOADING_OVRD_RATE, a.LOADING_RATE, a.LOADING_RATE, a.LOCK_TAG, a.MAIN_PRODUCT_CODE, a.MEDICAL_AMOUNT,a.MODEL_ID, a.NAME1, a.NAME2, a.NET_CONTRIBUTION, a.NON_FINANCIAL_ACTIVITY, a.NON_FINANCIAL_SUB_ACTIVITY, a.ORG_ID, a.OVERRIDING_RATE, a.PARTNER_ID, a.PAYMENT_MODE, a.PAYMENT_TERM , a.POLICY_FEE, a.POLICY_POSTED,a.POLICY_TERM, a.POSTING_TAG, a.PREMIUM_BASIS, a.PRODUCER_CODE, a.RECORD_TYPE, a.REMARKS, a.REVISED_TAG, a.SECOND_LIFE, a.STANDARD_TREATY , a.SUB_DOCUMENT_NO, a.SUB_PRODUCT_CODE, a.SUB_PRODUCT_CODE, a.SUBMIT_BY, a.SUM_COVERED, a.SUM_COVERED_INDEX, a.SUM_COVERED_MODAL, a.TAKAFUL_TYPE, a.TOPUP_AMOUNT, a.TOTAL_CONTRIBUTION_MODAL, a.UNDERWRITING_IL_CREATE, a.UNDWT_DECISION_REASON, a.UNDWT_NOTES, a.WAKALA_FEE, a.NAME1_OLD, a.NAME1_OLD, a.MIDDLE_NAME1_OLD, a.LAST_NAME1_OLD, a.IL_REVISE_TAG, a.CNIC_NO_OLD, a.GENDER1_OLD, a.POLICY_HOLD_FLAG, a.POLICY_TERM_OLD, a.PAYMENT_TERM_OLD, a.PAYMENT_MODE_OLD, a.SUM_COVERED_OLD, a.SUM_COVERED_MODAL_OLD, a.COVER_MULTIPLE_OLD, a.BASIC_CONTRIBUTION_MODAL_OLD, a.BASIC_CONTRIBUTION_OLD, a.FUND_CHANGE_TAG, a.FUND_SWITCH_CHARGES, TO_CHAR(a.DOB1_OLD, 'dd/MM/yyyy') DOB1_OLD, agent.AGENT_NAME, gen_paramdtl.DESCRIPTION || ' - ' || b.DESCRIPTION AS DESCRIPTION, f.CLIENT_DESC, f.CLIENT_TYPE, fin.ACTIVITY_DESCRIPTION AS NON_FIN_ACTIVITY_DESC , NVL(a.MASTER_REF_NO, a.DOC_REFERENCE_NO) MASTER_REF_NO , NVL(a.PAYER_SAME_TAG, 'Y') PAYER_SAME_TAG, sub.SUB_ACTIVITY_DESCRIPTION AS NON_FIN_SUB_ACTIVITY_DESC , sub.REPORT_PATH , t.DESCRIPTION alteration, t.REPORT_PATH REPORTPATH_ALT, TO_CHAR(a.ALTERATION_DATE, 'dd/MM/yyyy') ALTERATION_DATE, TO_CHAR(a.ALTERATION_ISSUE_DATE, 'dd/MM/yyyy') ALTERATION_ISSUE_DATE, TO_CHAR(a.CANCEL_DATE, 'dd/MM/yyyy') CANCEL_DATE, TO_CHAR(a.CANCELLATION_DATE, 'dd/MM/yyyy') CANCELLATION_DATE, TO_CHAR(a.COMM_DATE, 'dd/MM/yyyy') COMM_DATE, TO_CHAR(a.COMM_DATE, 'dd-Mon-yyyy') COMM_DATE_DISPLAY, TO_CHAR(a.DOB1, 'dd/MM/yyyy') DOB1, TO_CHAR(a.DOB2, 'dd/MM/yyyy') DOB2, TO_CHAR(a.DOC_DISPATCH_DATE, 'dd/MM/yyyy') DOC_DISPATCH_DATE, TO_CHAR(a.DOC_RECEIVE_DATE, 'dd/MM/yyyy') DOC_RECEIVE_DATE, TO_CHAR(a.ISSUE_DATE, 'dd/MM/yyyy') ISSUE_DATE, TO_CHAR(a.ISSUE_DATE, 'dd-Mon-yyyy') ISSUE_DATE_DISPLAY, TO_CHAR(a.LAST_UPDATE_DATE, 'dd-Mon-yyyy') LAST_UPDATE_DATE, TO_CHAR(a.NEXT_DUE_DATE, 'dd/MM/yyyy') NEXT_DUE_DATE, TO_CHAR(a.PROPOSAL_DATE, 'dd/MM/yyyy') PROPOSAL_DATE, TO_CHAR(a.QUOTATION_DATE, 'dd/MM/yyyy') QUOTATION_DATE, TO_CHAR(a.RECEIVE_ACK_DATE, 'dd/MM/yyyy') RECEIVE_ACK_DATE, TO_CHAR(a.SUBMIT_DATE, 'dd-Mon-yyyy') SUBMIT_DATE, c.STATUS_DESC, d.DECISION_DESC, d.DECISION_CODE, a.CONTRIBUTION_INDEX_OLD, a.SUM_COVERED_INDEX_OLD, NVL(a.AUTO_RENEWAL_TOPUP_TAG, 'N') AUTO_RENEWAL_TOPUP_TAG, a.BANK_REPRESENTATIVE_NAME, a.BANK_REPRESENTATIVE_CODE, a.SUBMIT_TAG, a.CONTRIBUTION_TYPE, a.CUSTOMER_PROFILE_COMMENTS, a.REJECTED_TAG, a.PROPOSAL_APPROVED_BY, a.RISK_PROFILE, a.RISK_PROFILE_COMMENTS, a.UNDWT_DECISION, a.UNDWT_OTHER_EXCULUSIONS, a.UNDWT_STATUS, NULL PROCESS_ID, NULL PROCESS_ID_REF, NULL PROCESS_TYPE_ID, a.RETURN_TAG, b.CBC_TAG, NULL PROCESS_TYPE_DESC, NULL REQUESTED_AMOUNT, TO_CHAR(a.CREATION_DATE, 'yyyy-mm-dd hh24:mi:ss') CREATION_DATE, TO_CHAR(a.CREATION_DATE, 'dd/MM/yyyy') CREATION_DATE_DISPLAY, TO_CHAR(a.CREATION_DATE, 'dd') || TO_CHAR(a.CREATION_DATE, 'mm') || TO_CHAR(a.CREATION_DATE, 'yyyy') SORT_ID,TO_CHAR(a.PR_DATE, 'dd/MM/yyyy') PR_DATE,a.PR_AMOUNT,icsst.STATUS_DESC CBC_STATUS ,nvl(a.SUPR_APPROVAL_REQD,'N') SUPR_APPROVAL_REQD,nvl(a.SUPR_FORWARD_TAG,'N') SUPR_FORWARD_TAG,nvl(a.SUPR_ACTION_TAKEN,'N') SUPR_ACTION_TAKEN FROM IL_DOC_HEADER_T a LEFT OUTER JOIN TK_ILL_DOC_CBC_T cbc ON(cbc.ORG_ID = a.ORG_ID AND cbc.BRANCH_ID = a.BRANCH_ID AND cbc.MAIN_PRODUCT_CODE = a.MAIN_PRODUCT_CODE AND cbc.SUB_PRODUCT_CODE = a.SUB_PRODUCT_CODE AND cbc.TAKAFUL_TYPE = a.TAKAFUL_TYPE AND cbc.DOCUMENT_TYPE = a.DOCUMENT_TYPE AND cbc.DOCUMENT_NO = a.DOCUMENT_NO AND cbc.RECORD_TYPE = a.RECORD_TYPE AND cbc.DOCUMENT_YEAR = a.DOCUMENT_YEAR AND cbc.ISSUE_COUNT = a.ISSUE_COUNT AND cbc.ENDORSEMENT_NO = a.ENDORSEMENT_NO AND cbc.APPLICATION_ID = a.APPLICATION_ID) LEFT OUTER JOIN IL_CBC_STATUS_SETUP_T icsst ON cbc.ORG_ID = icsst.ORG_ID AND cbc.CBC_STATUS_CODE = icsst.STATUS_ID LEFT OUTER JOIN AM_PARTNER_BRANCHES_T PB ON (a.ORG_ID = PB.ORG_ID AND a.PARTNER_ID = PB.PARTNER_ID AND a.PARTNER_BRANCH_ID = PB.PARTNER_BRANCH_ID) LEFT OUTER JOIN IL_DOC_STATUS_SETUP_T c ON (a.ORG_ID = c.ORG_ID AND a.UNDWT_STATUS = c.STATUS_CODE) LEFT OUTER JOIN IL_DECISION_SETUP_T d ON (a.ORG_ID = c.ORG_ID AND a.UNDWT_DECISION = d.DECISION_CODE) LEFT OUTER JOIN GLAS_CLIENT_SETUP_T f ON (a.ORG_ID = f.ORG_ID AND a.CLIENT_CODE = f.CLIENT_CODE) LEFT OUTER JOIN GLAS_ALTERATION_TYPE_SETUP_T T ON (T.ORG_ID = a.ORG_ID AND t.ALTERATION_TYPE = a.ALTERATION_TYPE AND t.APPLICATION_ID = a.APPLICATION_ID) LEFT OUTER JOIN NON_FINANCIAL_ACTIVITY_T fin ON (fin.ORG_ID = a.ORG_ID AND fin.ACTIVITY_CODE = a.NON_FINANCIAL_ACTIVITY) LEFT OUTER JOIN NON_FINANCIAL_SUB_ACTIVITY_T sub ON (sub.ORG_ID = a.ORG_ID AND sub.SUB_ACTIVITY_CODE = a.NON_FINANCIAL_SUB_ACTIVITY) LEFT OUTER JOIN AM_AGENT_T agent ON (agent.ORG_ID = a.ORG_ID AND agent.AGENT_ID = a.AGENT_ID), 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 a.ORG_ID = b.ORG_ID AND a.APPLICATION_ID = b.APPLICATION_ID AND a.SUB_PRODUCT_CODE = b.SUB_PRODUCT_CODE AND a.ORG_ID = 8 AND a.DOCUMENT_TYPE = 'Q' AND a.BRANCH_ID = 14 AND a.RECORD_TYPE = 'O' AND a.TAKAFUL_TYPE = 'D' AND a.APPLICATION_ID = 13 AND a.DOC_REFERENCE_KEY IS NOT NULL AND a.LOCK_TAG = 'Y' AND NVL(a.SUBMIT_TAG,'N') = 'N' AND (NVL(a.CBC_REQUIRED_TAG,'N') = 'N' OR EXISTS (SELECT 'x' FROM TK_ILL_DOC_CBC_T cbc inner join IL_CBC_STATUS_SETUP_T cst on cbc.org_id=cst.org_id and cbc.cbc_status_code=cst.status_id where cbc.ORG_ID = a.ORG_ID AND cbc.BRANCH_ID = a.BRANCH_ID AND cbc.MAIN_PRODUCT_CODE = a.MAIN_PRODUCT_CODE AND cbc.SUB_PRODUCT_CODE = a.SUB_PRODUCT_CODE AND cbc.TAKAFUL_TYPE = a.TAKAFUL_TYPE AND cbc.DOCUMENT_TYPE = a.DOCUMENT_TYPE AND cbc.DOCUMENT_NO = a.DOCUMENT_NO AND cbc.RECORD_TYPE = a.RECORD_TYPE AND cbc.DOCUMENT_YEAR = a.DOCUMENT_YEAR AND cbc.ISSUE_COUNT = a.ISSUE_COUNT AND cbc.ENDORSEMENT_NO = a.ENDORSEMENT_NO AND cbc.APPLICATION_ID = a.APPLICATION_ID AND cst.CLOSURE_TAG='Y')) AND a.UNDWT_DECISION_SYSTEM not in (2) AND ((a.TOTAL_SCORE BETWEEN 0 AND 200 and 'Y' = case when nvl(SUPR_APPROVAL_REQD,'N')='N' then 'Y' when nvl(SUPR_FORWARD_TAG,'N')='N' then 'Y' when SUPR_ACTION_TAKEN='Y' then 'Y' else 'N' end) or (a.SUPR_APPROVAL_REQD='Y' and nvl(SUPR_ACTION_TAKEN,'N')='N' and a.AGENT_ID in (SELECT AGDT.AGENT_ID FROM AM_AGENT_DESIGNATION_T AGDT WHERE AGDT.ORG_ID = 8 AND AGDT.PARTNER_ID = 0 AND AGDT.CHANNEL_ID = 0 AND AGDT.MODEL_ID = 0 START WITH AGDT.SUPERVISOR_ID = CONNECT BY PRIOR AGDT.AGENT_ID = AGDT.SUPERVISOR_ID AND PRIOR AGDT.ORG_ID = AGDT.ORG_ID AND PRIOR AGDT.PARTNER_ID = AGDT.PARTNER_ID AND PRIOR AGDT.CHANNEL_ID = AGDT.CHANNEL_ID AND PRIOR AGDT.MODEL_ID = AGDT.MODEL_ID) and 3 <= (SELECT ADT.DESIGNATION_LEVEL FROM AM_AGENT_DESIGNATION_T AGDT INNER JOIN AM_DESIGNATION_T ADT ON AGDT.ORG_ID = ADT.ORG_ID AND AGDT.DESIGNATION_ID = ADT.DESIGNATION_ID WHERE AGDT.ORG_ID = 8 AND AGDT.PARTNER_ID = 0 AND AGDT.CHANNEL_ID = 0 AND AGDT.MODEL_ID = 0 and AGDT.AGENT_ID=))) 10/14/2024 3:39:01 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) 10/14/2024 3:39:01 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) at ZealERP.ZealTakaful.Services.ILAS.ProposalEntryViewerService.GetLookUp(CommonParamsDataModel model) at ZealERP.ZealTakaful.Controllers.ILAS.ProposalEntryViewerController.<>c__DisplayClass2_0.b__0() at ZealERP.ZealFramework.Utils.ZealRestApiHandler.GetResponse(ControllerLogic GetDataFromService) 10/14/2024 3:39:03 AM: SELECT PB.PARTNER_BRANCH_NAME,a.ADVANCE_AMOUNT, a.AGE1, a.AGE2, a.AGENT_ID, a.ALTERATION_TYPE, a.APPLICATION_ID, a.BASE_DOC_NO, a.BASE_DOC_NO_KEY,a.BASIC_CONTRIBUTION, a.BASIC_CONTRIBUTION_MODAL, A.BID_OFFER, a.BRANCH_ID, a.CANCEL_BY, a.CANCEL_TAG, a.CANCELLATION_REMARKS, a.CANCELLATION_TYPE, a.CHANNEL_ID,a.CHARGEABLE_AMOUNT, a.CHARGEABLE_FROM, a.CLIENT_CODE, a.CNIC_NO, a.CONSIGNMENT_NO, a.CONT_MARGIN, a.CONTRIBUTION_INDEX, a.CONVERT_TAG, a.CONVERTED_DOC_NO_KEY,a.CONVERTED_POLICY_NO, a.COVER_MULTIPLE, a.FACE_VALUE_INCREASE_TAG, a.CREATED_BY , a.CURRENCY_CODE, a.DOC_REFERENCE_KEY , a.DOC_REFERENCE_KEY , a.DOC_REFERENCE_NO, a.DOCUMENT_NO,a.DOCUMENT_TYPE, a.DOCUMENT_YEAR, a.ENDORSEMENT_NO, a.EXCHANGE_RATE, a.EXPECTED_CLAIM, a.GENDER1, a.GENDER2, a.GROSS_CONTRIBUTION, a.ILLUSTRATION_REF_NO, a.ILLUSTRATION_REF_NO_KEY,a.INITIAL_TOPUP , a.INVESTMENT_INCOME,a.ISSUE_COUNT, a.ISSUE_COUNT, a.LAST_AGE_INDEX, a.LOADING_OVRD_RATE, a.LOADING_RATE, a.LOADING_RATE, a.LOCK_TAG, a.MAIN_PRODUCT_CODE, a.MEDICAL_AMOUNT,a.MODEL_ID, a.NAME1, a.NAME2, a.NET_CONTRIBUTION, a.NON_FINANCIAL_ACTIVITY, a.NON_FINANCIAL_SUB_ACTIVITY, a.ORG_ID, a.OVERRIDING_RATE, a.PARTNER_ID, a.PAYMENT_MODE, a.PAYMENT_TERM , a.POLICY_FEE, a.POLICY_POSTED,a.POLICY_TERM, a.POSTING_TAG, a.PREMIUM_BASIS, a.PRODUCER_CODE, a.RECORD_TYPE, a.REMARKS, a.REVISED_TAG, a.SECOND_LIFE, a.STANDARD_TREATY , a.SUB_DOCUMENT_NO, a.SUB_PRODUCT_CODE, a.SUB_PRODUCT_CODE, a.SUBMIT_BY, a.SUM_COVERED, a.SUM_COVERED_INDEX, a.SUM_COVERED_MODAL, a.TAKAFUL_TYPE, a.TOPUP_AMOUNT, a.TOTAL_CONTRIBUTION_MODAL, a.UNDERWRITING_IL_CREATE, a.UNDWT_DECISION_REASON, a.UNDWT_NOTES, a.WAKALA_FEE, a.NAME1_OLD, a.NAME1_OLD, a.MIDDLE_NAME1_OLD, a.LAST_NAME1_OLD, a.IL_REVISE_TAG, a.CNIC_NO_OLD, a.GENDER1_OLD, a.POLICY_HOLD_FLAG, a.POLICY_TERM_OLD, a.PAYMENT_TERM_OLD, a.PAYMENT_MODE_OLD, a.SUM_COVERED_OLD, a.SUM_COVERED_MODAL_OLD, a.COVER_MULTIPLE_OLD, a.BASIC_CONTRIBUTION_MODAL_OLD, a.BASIC_CONTRIBUTION_OLD, a.FUND_CHANGE_TAG, a.FUND_SWITCH_CHARGES, TO_CHAR(a.DOB1_OLD, 'dd/MM/yyyy') DOB1_OLD, agent.AGENT_NAME, gen_paramdtl.DESCRIPTION || ' - ' || b.DESCRIPTION AS DESCRIPTION, f.CLIENT_DESC, f.CLIENT_TYPE, fin.ACTIVITY_DESCRIPTION AS NON_FIN_ACTIVITY_DESC , NVL(a.MASTER_REF_NO, a.DOC_REFERENCE_NO) MASTER_REF_NO , NVL(a.PAYER_SAME_TAG, 'Y') PAYER_SAME_TAG, sub.SUB_ACTIVITY_DESCRIPTION AS NON_FIN_SUB_ACTIVITY_DESC , sub.REPORT_PATH , t.DESCRIPTION alteration, t.REPORT_PATH REPORTPATH_ALT, TO_CHAR(a.ALTERATION_DATE, 'dd/MM/yyyy') ALTERATION_DATE, TO_CHAR(a.ALTERATION_ISSUE_DATE, 'dd/MM/yyyy') ALTERATION_ISSUE_DATE, TO_CHAR(a.CANCEL_DATE, 'dd/MM/yyyy') CANCEL_DATE, TO_CHAR(a.CANCELLATION_DATE, 'dd/MM/yyyy') CANCELLATION_DATE, TO_CHAR(a.COMM_DATE, 'dd/MM/yyyy') COMM_DATE, TO_CHAR(a.COMM_DATE, 'dd-Mon-yyyy') COMM_DATE_DISPLAY, TO_CHAR(a.DOB1, 'dd/MM/yyyy') DOB1, TO_CHAR(a.DOB2, 'dd/MM/yyyy') DOB2, TO_CHAR(a.DOC_DISPATCH_DATE, 'dd/MM/yyyy') DOC_DISPATCH_DATE, TO_CHAR(a.DOC_RECEIVE_DATE, 'dd/MM/yyyy') DOC_RECEIVE_DATE, TO_CHAR(a.ISSUE_DATE, 'dd/MM/yyyy') ISSUE_DATE, TO_CHAR(a.ISSUE_DATE, 'dd-Mon-yyyy') ISSUE_DATE_DISPLAY, TO_CHAR(a.LAST_UPDATE_DATE, 'dd-Mon-yyyy') LAST_UPDATE_DATE, TO_CHAR(a.NEXT_DUE_DATE, 'dd/MM/yyyy') NEXT_DUE_DATE, TO_CHAR(a.PROPOSAL_DATE, 'dd/MM/yyyy') PROPOSAL_DATE, TO_CHAR(a.QUOTATION_DATE, 'dd/MM/yyyy') QUOTATION_DATE, TO_CHAR(a.RECEIVE_ACK_DATE, 'dd/MM/yyyy') RECEIVE_ACK_DATE, TO_CHAR(a.SUBMIT_DATE, 'dd-Mon-yyyy') SUBMIT_DATE, c.STATUS_DESC, d.DECISION_DESC, d.DECISION_CODE, a.CONTRIBUTION_INDEX_OLD, a.SUM_COVERED_INDEX_OLD, NVL(a.AUTO_RENEWAL_TOPUP_TAG, 'N') AUTO_RENEWAL_TOPUP_TAG, a.BANK_REPRESENTATIVE_NAME, a.BANK_REPRESENTATIVE_CODE, a.SUBMIT_TAG, a.CONTRIBUTION_TYPE, a.CUSTOMER_PROFILE_COMMENTS, a.REJECTED_TAG, a.PROPOSAL_APPROVED_BY, a.RISK_PROFILE, a.RISK_PROFILE_COMMENTS, a.UNDWT_DECISION, a.UNDWT_OTHER_EXCULUSIONS, a.UNDWT_STATUS, NULL PROCESS_ID, NULL PROCESS_ID_REF, NULL PROCESS_TYPE_ID, a.RETURN_TAG, b.CBC_TAG, NULL PROCESS_TYPE_DESC, NULL REQUESTED_AMOUNT, TO_CHAR(a.CREATION_DATE, 'yyyy-mm-dd hh24:mi:ss') CREATION_DATE, TO_CHAR(a.CREATION_DATE, 'dd/MM/yyyy') CREATION_DATE_DISPLAY, TO_CHAR(a.CREATION_DATE, 'dd') || TO_CHAR(a.CREATION_DATE, 'mm') || TO_CHAR(a.CREATION_DATE, 'yyyy') SORT_ID,TO_CHAR(a.PR_DATE, 'dd/MM/yyyy') PR_DATE,a.PR_AMOUNT,icsst.STATUS_DESC CBC_STATUS ,nvl(a.SUPR_APPROVAL_REQD,'N') SUPR_APPROVAL_REQD,nvl(a.SUPR_FORWARD_TAG,'N') SUPR_FORWARD_TAG,nvl(a.SUPR_ACTION_TAKEN,'N') SUPR_ACTION_TAKEN FROM IL_DOC_HEADER_T a LEFT OUTER JOIN TK_ILL_DOC_CBC_T cbc ON(cbc.ORG_ID = a.ORG_ID AND cbc.BRANCH_ID = a.BRANCH_ID AND cbc.MAIN_PRODUCT_CODE = a.MAIN_PRODUCT_CODE AND cbc.SUB_PRODUCT_CODE = a.SUB_PRODUCT_CODE AND cbc.TAKAFUL_TYPE = a.TAKAFUL_TYPE AND cbc.DOCUMENT_TYPE = a.DOCUMENT_TYPE AND cbc.DOCUMENT_NO = a.DOCUMENT_NO AND cbc.RECORD_TYPE = a.RECORD_TYPE AND cbc.DOCUMENT_YEAR = a.DOCUMENT_YEAR AND cbc.ISSUE_COUNT = a.ISSUE_COUNT AND cbc.ENDORSEMENT_NO = a.ENDORSEMENT_NO AND cbc.APPLICATION_ID = a.APPLICATION_ID) LEFT OUTER JOIN IL_CBC_STATUS_SETUP_T icsst ON cbc.ORG_ID = icsst.ORG_ID AND cbc.CBC_STATUS_CODE = icsst.STATUS_ID LEFT OUTER JOIN AM_PARTNER_BRANCHES_T PB ON (a.ORG_ID = PB.ORG_ID AND a.PARTNER_ID = PB.PARTNER_ID AND a.PARTNER_BRANCH_ID = PB.PARTNER_BRANCH_ID) LEFT OUTER JOIN IL_DOC_STATUS_SETUP_T c ON (a.ORG_ID = c.ORG_ID AND a.UNDWT_STATUS = c.STATUS_CODE) LEFT OUTER JOIN IL_DECISION_SETUP_T d ON (a.ORG_ID = c.ORG_ID AND a.UNDWT_DECISION = d.DECISION_CODE) LEFT OUTER JOIN GLAS_CLIENT_SETUP_T f ON (a.ORG_ID = f.ORG_ID AND a.CLIENT_CODE = f.CLIENT_CODE) LEFT OUTER JOIN GLAS_ALTERATION_TYPE_SETUP_T T ON (T.ORG_ID = a.ORG_ID AND t.ALTERATION_TYPE = a.ALTERATION_TYPE AND t.APPLICATION_ID = a.APPLICATION_ID) LEFT OUTER JOIN NON_FINANCIAL_ACTIVITY_T fin ON (fin.ORG_ID = a.ORG_ID AND fin.ACTIVITY_CODE = a.NON_FINANCIAL_ACTIVITY) LEFT OUTER JOIN NON_FINANCIAL_SUB_ACTIVITY_T sub ON (sub.ORG_ID = a.ORG_ID AND sub.SUB_ACTIVITY_CODE = a.NON_FINANCIAL_SUB_ACTIVITY) LEFT OUTER JOIN AM_AGENT_T agent ON (agent.ORG_ID = a.ORG_ID AND agent.AGENT_ID = a.AGENT_ID), 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 a.ORG_ID = b.ORG_ID AND a.APPLICATION_ID = b.APPLICATION_ID AND a.SUB_PRODUCT_CODE = b.SUB_PRODUCT_CODE AND a.ORG_ID = 8 AND a.DOCUMENT_TYPE = 'Q' AND a.BRANCH_ID = 14 AND a.RECORD_TYPE = 'O' AND a.TAKAFUL_TYPE = 'D' AND a.APPLICATION_ID = 13 AND a.DOC_REFERENCE_KEY IS NOT NULL AND a.LOCK_TAG = 'Y' AND NVL(a.SUBMIT_TAG,'N') = 'N' AND (NVL(a.CBC_REQUIRED_TAG,'N') = 'N' OR EXISTS (SELECT 'x' FROM TK_ILL_DOC_CBC_T cbc inner join IL_CBC_STATUS_SETUP_T cst on cbc.org_id=cst.org_id and cbc.cbc_status_code=cst.status_id where cbc.ORG_ID = a.ORG_ID AND cbc.BRANCH_ID = a.BRANCH_ID AND cbc.MAIN_PRODUCT_CODE = a.MAIN_PRODUCT_CODE AND cbc.SUB_PRODUCT_CODE = a.SUB_PRODUCT_CODE AND cbc.TAKAFUL_TYPE = a.TAKAFUL_TYPE AND cbc.DOCUMENT_TYPE = a.DOCUMENT_TYPE AND cbc.DOCUMENT_NO = a.DOCUMENT_NO AND cbc.RECORD_TYPE = a.RECORD_TYPE AND cbc.DOCUMENT_YEAR = a.DOCUMENT_YEAR AND cbc.ISSUE_COUNT = a.ISSUE_COUNT AND cbc.ENDORSEMENT_NO = a.ENDORSEMENT_NO AND cbc.APPLICATION_ID = a.APPLICATION_ID AND cst.CLOSURE_TAG='Y')) AND a.UNDWT_DECISION_SYSTEM not in (2) AND ((a.TOTAL_SCORE BETWEEN 0 AND 200 and 'Y' = case when nvl(SUPR_APPROVAL_REQD,'N')='N' then 'Y' when nvl(SUPR_FORWARD_TAG,'N')='N' then 'Y' when SUPR_ACTION_TAKEN='Y' then 'Y' else 'N' end) or (a.SUPR_APPROVAL_REQD='Y' and nvl(SUPR_ACTION_TAKEN,'N')='N' and a.AGENT_ID in (SELECT AGDT.AGENT_ID FROM AM_AGENT_DESIGNATION_T AGDT WHERE AGDT.ORG_ID = 8 AND AGDT.PARTNER_ID = 0 AND AGDT.CHANNEL_ID = 0 AND AGDT.MODEL_ID = 0 START WITH AGDT.SUPERVISOR_ID = CONNECT BY PRIOR AGDT.AGENT_ID = AGDT.SUPERVISOR_ID AND PRIOR AGDT.ORG_ID = AGDT.ORG_ID AND PRIOR AGDT.PARTNER_ID = AGDT.PARTNER_ID AND PRIOR AGDT.CHANNEL_ID = AGDT.CHANNEL_ID AND PRIOR AGDT.MODEL_ID = AGDT.MODEL_ID) and 3 <= (SELECT ADT.DESIGNATION_LEVEL FROM AM_AGENT_DESIGNATION_T AGDT INNER JOIN AM_DESIGNATION_T ADT ON AGDT.ORG_ID = ADT.ORG_ID AND AGDT.DESIGNATION_ID = ADT.DESIGNATION_ID WHERE AGDT.ORG_ID = 8 AND AGDT.PARTNER_ID = 0 AND AGDT.CHANNEL_ID = 0 AND AGDT.MODEL_ID = 0 and AGDT.AGENT_ID=))) 10/14/2024 3:39:03 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) 10/14/2024 3:39:03 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) at ZealERP.ZealTakaful.Services.ILAS.ProposalEntryViewerService.GetLookUp(CommonParamsDataModel model) at ZealERP.ZealTakaful.Controllers.ILAS.ProposalEntryViewerController.<>c__DisplayClass2_0.b__0() at ZealERP.ZealFramework.Utils.ZealRestApiHandler.GetResponse(ControllerLogic GetDataFromService) 10/14/2024 4:02:03 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) 10/14/2024 4:07:58 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) 10/14/2024 4:09: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) 10/14/2024 4:13: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) 10/14/2024 4:18:48 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) 10/14/2024 4:24: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) 10/14/2024 4:24: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) 10/14/2024 4:26: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) 10/14/2024 4:26:52 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) 10/14/2024 4:28:43 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) 10/14/2024 4:34: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) 10/14/2024 4:36:17 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) 10/14/2024 4:36:59 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) 10/14/2024 4:37: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) 10/14/2024 4:39:59 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) 10/14/2024 4:50:25 AM: Directory not found, creating directory.. D:\AAK\ZealERP\Uploads\ClientUploads\2024000000024-1 10/14/2024 4:51: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) 10/14/2024 4: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) 10/14/2024 4:57:05 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) 10/14/2024 4:59:01 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) 10/14/2024 5:15: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) 10/14/2024 5:16: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) 10/14/2024 5:19: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) 10/14/2024 5:19:58 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) 10/14/2024 5:30:30 AM: Sum Covered % not found on rider, please re-check ZealERP.ZealFramework.Utils.ZealException: Sum Covered % not found on rider, please re-check at ZealERP.ZealTakaful.Services.TakafulTech.IllustrationService.CalculationProcess(IllustrationCalculationDataModel model, OracleCommand command, Boolean fromPOS) at ZealERP.ZealTakaful.Services.TakafulTech.IllustrationService.<>c__DisplayClass29_0.b__0(OracleCommand command) at ZealERP.ZealFramework.Utils.ZealTransactionHandler.ExecuteTransaction(TransactionBody _TransactionBody) 10/14/2024 5:30:30 AM: Error.. Sum Covered % not found on rider, please re-check ZealERP.ZealFramework.Utils.ZealException: Error.. Sum Covered % not found on rider, please re-check at ZealERP.ZealFramework.Utils.ZealTransactionHandler.ExecuteTransaction(TransactionBody _TransactionBody) at ZealERP.ZealTakaful.Services.TakafulTech.IllustrationService.CalculationProcess(IllustrationCalculationDataModel model, Boolean fromPOS) at ZealERP.ZealTakaful.Controllers.TakafulTech.IllustrationController.<>c__DisplayClass17_0.b__0() at ZealERP.ZealFramework.Utils.ZealRestApiHandler.GetResponse(ControllerLogic GetDataFromService) 10/14/2024 5:31:15 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) 10/14/2024 5:45:43 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) 10/14/2024 6:02: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) 10/14/2024 6:07:10 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) 10/14/2024 6:11:03 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) 10/14/2024 6:12:43 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) 10/14/2024 6:58:05 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) 10/14/2024 7:10:00 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) 10/14/2024 7:12:44 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) 10/14/2024 7:16:38 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) 10/14/2024 7:20: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) 10/14/2024 7:22: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) 10/14/2024 7:55:05 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) 10/14/2024 9:58:02 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) 10/14/2024 9:58: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) 10/14/2024 10:03:35 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) 10/14/2024 10:24: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) 10/14/2024 10:39: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) 10/14/2024 10:49:44 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.AppSelection.btnLogin_Click(Object sender, EventArgs e) 10/14/2024 10:49:44 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.AppSelection.btnLogin_Click(Object sender, EventArgs e) 10/14/2024 10:50: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) 10/14/2024 5:32:34 PM: WITH Endorsement_TABLE AS ( SELECT b.ORG_ID,b.BRANCH_ID,b.SUB_PRODUCT_CODE, b.TAKAFUL_TYPE, b.DOCUMENT_TYPE,b.DOCUMENT_NO, b.RECORD_TYPE, b.DOCUMENT_YEAR,b.ISSUE_COUNT, b.APPLICATION_ID, max(B.ENDORSEMENT_NO) AS End_No FROM TK_DOC_HEADER_T b where b.ORG_ID=5 AND B.DOCUMENT_TYPE ='P' AND B.RECORD_TYPE = CASE WHEN B.ENDORSEMENT_NO =0 THEN 'O' ELSE 'P' END GROUP BY b.ORG_ID,b.BRANCH_ID,b.SUB_PRODUCT_CODE, b.TAKAFUL_TYPE, b.DOCUMENT_TYPE,b.DOCUMENT_NO, b.RECORD_TYPE, b.DOCUMENT_YEAR,b.ISSUE_COUNT, b.APPLICATION_ID ) , CLAIM_INTIMATION AS( SELECT C_INT.ORG_ID,C_INT.BRANCH_ID,C_INT.SUB_PRODUCT_CODE,C_INT.APPLICATION_ID,C_INT.POLICY_HOLDER,C_INT.ENDORSEMENT_NO,C_INT.POLICY_NO, SUM(C_ASS.ASSESSMENT_AMOUNT)AS ASSESSMENT_AMOUNT FROM TK_CLAIM_INTIMATION_T C_INT LEFT OUTER JOIN TK_CLAIM_ASSESSMENT_T C_ASS ON(C_INT.ORG_ID=C_ASS.ORG_ID AND C_INT.BRANCH_ID=C_ASS.BRANCH_ID AND C_INT.SUB_PRODUCT_CODE=C_ASS.SUB_PRODUCT_CODE AND C_INT.APPLICATION_ID=C_ASS.APPLICATION_ID AND C_INT.CLAIM_NO=C_ASS.CLAIM_NO AND C_ASS.ASSESSMENT_STATUS IN ('A')) WHERE C_INT.ORG_ID=5 AND C_INT.BRANCH_ID=14 AND C_INT.SUB_PRODUCT_CODE=1 AND C_INT.APPLICATION_ID=11 GROUP BY(C_INT.ORG_ID,C_INT.BRANCH_ID,C_INT.SUB_PRODUCT_CODE,C_INT.APPLICATION_ID,C_INT.POLICY_HOLDER,C_INT.ENDORSEMENT_NO,C_INT.POLICY_NO)), DOC_INSTALLMENT AS (SELECT TO_CHAR(MAX(DUE_DATE), 'dd-Mon-yyyy')DUE_DATE,ORG_ID,BRANCH_ID,SUB_PRODUCT_CODE,DOCUMENT_TYPE,TAKAFUL_TYPE, RECORD_TYPE,DOCUMENT_YEAR,ISSUE_COUNT,ENDORSEMENT_NO,APPLICATION_ID,DOCUMENT_NO,POSTING_TAG FROM GLAS_DOC_INSTALLMENTS_T WHERE ORG_ID=5 AND BRANCH_ID=14 AND APPLICATION_ID=11 AND SUB_PRODUCT_CODE=1 GROUP BY(ORG_ID,BRANCH_ID,SUB_PRODUCT_CODE,DOCUMENT_TYPE,TAKAFUL_TYPE,RECORD_TYPE, DOCUMENT_TYPE,DOCUMENT_YEAR,ISSUE_COUNT,ENDORSEMENT_NO,APPLICATION_ID,DOCUMENT_NO,POSTING_TAG)), DOC_INSURED AS (SELECT count(*)totalLives,A.ORG_ID,A.BRANCH_ID,A.APPLICATION_ID,A.SUB_PRODUCT_CODE,A.ENDORSEMENT_NO,A.ISSUE_COUNT,A.PPS_PARTY_CODE,A.master_ref_no FROM TK_DOC_HEADER_T a left outer join GLAS_DOC_INSURED_ITEMS_T i ON (a.ORG_ID = i.ORG_ID and a.BRANCH_ID = i.BRANCH_ID and a.product_code = i.product_code AND a.sub_product_code = i.sub_product_code and a.takaful_type = i.takaful_type and a.document_type = i.document_type and a.record_type = i.record_type and a.document_no = i.document_no and a.document_year = i.document_year and a.issue_count = i.issue_count and a.endorsement_no = i.endorsement_no and a.application_id = i.application_id) GROUP BY(A.ORG_ID,A.BRANCH_ID,A.APPLICATION_ID,A.SUB_PRODUCT_CODE,A.ENDORSEMENT_NO,A.ISSUE_COUNT,A.PPS_PARTY_CODE,A.master_ref_no)) SELECT SUM (BR.SUM_INSURED)ReqTakSum, SUM (BR.APPROVED_SA)AppTakSum, BR.ENDORSEMENT_NO, TO_CHAR(HD.POST_DATE,'dd-Mon-yyyy') PolAppDate, com.COMM_PERCENT_SHARE, --BRS.SUM_INSURED, --BRS.APPROVED_SA, --NO OF LIVES, --HD.GDH_DOC_REFERENCE_NO PolicyNo, hd.pps_party_code, hd.master_ref_no PolicyNo, c_intm.assessment_amount, INST.DUE_DATE Renewal, INS.totalLives Live, hd.ENDORSEMENT_NO , hd.ISSUE_COUNT , CASE hd.PAYMENT_MODE WHEN 'M' THEN 'MONTHLY' WHEN 'Q' THEN 'QUATERLY' WHEN 'H' THEN 'HALF_YEARLY' ELSE 'ANUALLY' END AS PaymentMode, CLT.CLIENT_DESC Participant, TO_CHAR(HD.GDH_COMM_DATE,'dd-Mon-yyyy') PolStartDate, TO_CHAR(HD.GDH_EXPIRY_DATE,'dd-Mon-yyyy') PolEndDate, nvl(CLT.VAT_REG_NO,'-') ntnNo, AGT.AGENT_NAME AgentName, AGT.AGENT_ID AgentCode, nvl(HD.BASIC_CONTRIBUTION,0) currentt, nvl(HD.GDH_GROSS_PREMIUM,0) Annualized, HD.NET_CONTRIBUTION, c_intm.assessment_amount ClaimsAmount, ROUND (c_intm.assessment_amount/nvl(HD.GDH_GROSS_PREMIUM,0) * 100,2) AS GrossLoss, ROUND (c_intm.assessment_amount/nvl(HD.NET_CONTRIBUTION,0) * 100,2) AS NetLoss --SELECT * from tk_doc_header_t hd INNER JOIN Endorsement_TABLE ET ON (ET.ORG_ID = hd.ORG_ID AND ET.BRANCH_ID = hd.BRANCH_ID AND ET.SUB_PRODUCT_CODE = hd.SUB_PRODUCT_CODE AND ET.TAKAFUL_TYPE = hd.TAKAFUL_TYPE AND ET.DOCUMENT_TYPE = hd.DOCUMENT_TYPE AND ET.RECORD_TYPE = hd.RECORD_TYPE AND ET.DOCUMENT_YEAR = hd.DOCUMENT_YEAR AND ET.ISSUE_COUNT = hd.ISSUE_COUNT AND ET.APPLICATION_ID = hd.APPLICATION_ID AND ET.DOCUMENT_NO = hd.DOCUMENT_NO AND hd.ENDORSEMENT_NO = ET.End_No ) join claim_intimation c_intm on ( C_INTM.ORG_ID = HD.org_id AND C_INTM.BRANCH_ID = HD.BRANCH_ID AND C_INTM.SUB_PRODUCT_CODE = HD.SUB_PRODUCT_CODE AND C_INTM.APPLICATION_ID =HD.APPLICATION_ID AND C_INTM.POLICY_NO =hd.master_ref_no AND C_INTM.ENDORSEMENT_NO =HD.endorsement_no AND C_INTM.POLICY_HOLDER =HD.pps_party_code) LEFT JOIN DOC_INSTALLMENT INST ON INST.ORG_ID=HD.ORG_ID and INST.BRANCH_ID=HD.BRANCH_ID and INST.SUB_PRODUCT_CODE=HD.SUB_PRODUCT_CODE and INST.TAKAFUL_TYPE=HD.TAKAFUL_TYPE and INST.DOCUMENT_TYPE=HD.DOCUMENT_TYPE and INST.RECORD_TYPE=HD.RECORD_TYPE and INST.DOCUMENT_YEAR=HD.DOCUMENT_YEAR and INST.ISSUE_COUNT=HD.ISSUE_COUNT and INST.ENDORSEMENT_NO=HD.ENDORSEMENT_NO and INST.APPLICATION_ID=HD.APPLICATION_ID and INST.DOCUMENT_NO=HD.DOCUMENT_NO AND nvl(INST.POSTING_TAG, 'N') <> 'Y' LEFT JOIN DOC_INSURED INS ON (INS.ORG_ID=HD.ORG_ID AND INS.BRANCH_ID=HD.BRANCH_ID AND INS.SUB_PRODUCT_CODE=HD.SUB_PRODUCT_CODE AND INS.ENDORSEMENT_NO=HD.ENDORSEMENT_NO AND INS.APPLICATION_ID=HD.APPLICATION_ID AND INS.PPS_PARTY_CODE=HD.PPS_PARTY_CODE AND INS.master_ref_no=HD.MASTER_REF_NO) LEFT OUTER JOIN GLAS_DOC_INSURED_ITEMS_T BR ON (hd.ORG_ID = BR.ORG_ID and hd.BRANCH_ID = BR.BRANCH_ID and hd.product_code = BR.product_code AND hd.sub_product_code = BR.sub_product_code and hd.takaful_type = BR.takaful_type and hd.document_type = BR.document_type and hd.record_type = BR.record_type and hd.document_no = BR.document_no and hd.document_year = BR.document_year and hd.issue_count = BR.issue_count and BR.endorsement_no=hd.endorsement_no and hd.application_id = BR.application_id) LEFT OUTER JOIN GLAS_DOC_INSURED_ITEMS_T BRS ON (hd.ORG_ID = BRS.ORG_ID and hd.BRANCH_ID = BRS.BRANCH_ID and hd.product_code = BRS.product_code AND hd.sub_product_code = BRS.sub_product_code and hd.takaful_type = BRS.takaful_type and hd.document_type = BRS.document_type and hd.record_type = BRS.record_type and hd.document_no = BRS.document_no and hd.document_year = BRS.document_year and hd.issue_count = BRS.issue_count and BRS.endorsement_no=0 and hd.application_id = BRS.application_id) LEFT outer join GLAS_DOC_COMMISSION_CYCLE_T COM ON (hd.ORG_ID = COM.ORG_ID and hd.BRANCH_ID = COM.BRANCH_ID and hd.product_code = COM.product_code AND hd.sub_product_code = COM.sub_product_code and hd.takaful_type = COM.takaful_type and hd.document_type = COM.document_type and hd.record_type = COM.record_type and hd.document_no = COM.document_no and hd.document_year = COM.document_year and hd.issue_count = COM.issue_count and hd.endorsement_no = COM.endorsement_no and hd.application_id = COM.application_id AND COM.AGENCY_TYPE ='P') LEFT OUTER JOIN GLAS_CLIENT_SETUP_T CLT ON (HD.ORG_ID = CLT.ORG_ID AND HD.PPS_PARTY_CODE = CLT.CLIENT_CODE) LEFT OUTER JOIN am_agent_t AGT ON AGT.ORG_ID = HD.ORG_ID AND AGT.AGENT_ID = HD.PRODUCER_CODE WHERE HD.ORG_ID='' and HD.GDH_DOC_REFERENCE_NO IS NOT NULL AND HD.DOCUMENT_TYPE = 'P' AND HD.POSTING_TAG = 'Y' AND HD.ENDORSEMENT_NO = 0 AND HD.GDH_ISSUE_DATE BETWEEN '' AND ''and CHANN.CHANNEL_ID='' AND AGT.AGENT_ID ='' AND HD.GDH_DOC_REFERENCE_NO ='' Group by HD.POST_DATE,com.COMM_PERCENT_SHARE,hd.pps_party_code,hd.master_ref_no,c_intm.assessment_amount,INST.DUE_DATE,INS.totalLives,HD.BASIC_CONTRIBUTION,hd.ENDORSEMENT_NO ,hd.ISSUE_COUNT , hd.PAYMENT_MODE, CLT.CLIENT_DESC,HD.GDH_COMM_DATE,HD.GDH_EXPIRY_DATE,CLT.VAT_REG_NO,AGT.AGENT_NAME,AGT.AGENT_ID,HD.GDH_GROSS_PREMIUM,HD.NET_CONTRIBUTION,c_intm.assessment_amount,c_intm.assessment_amount,HD.GDH_GROSS_PREMIUM,c_intm.assessment_amount,HD.NET_CONTRIBUTION,BR.ENDORSEMENT_NO 10/14/2024 5:32:34 PM: ORA-00904: "CHANN"."CHANNEL_ID": invalid identifier Oracle.ManagedDataAccess.Client.OracleException (0x80004005): ORA-00904: "CHANN"."CHANNEL_ID": 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) 10/14/2024 5:32:34 PM: ORA-00904: "CHANN"."CHANNEL_ID": invalid identifier Oracle.ManagedDataAccess.Client.OracleException (0x80004005): ORA-00904: "CHANN"."CHANNEL_ID": invalid identifier 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.Reports.PolicyActivationReports.PolicyActivationReport.PrepareReport() 10/14/2024 5:32:34 PM: ORA-00904: "CHANN"."CHANNEL_ID": invalid identifier Oracle.ManagedDataAccess.Client.OracleException (0x80004005): ORA-00904: "CHANN"."CHANNEL_ID": invalid identifier 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.Reports.PolicyActivationReports.PolicyActivationReport.PrepareReport() 10/14/2024 9:30:09 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) 10/14/2024 9:38:11 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) 10/14/2024 9:58:02 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) 10/14/2024 10:12:53 PM: Basic Contribution cannot be Less Than Payment Mode wise Min Contribution (1000) ZealERP.ZealFramework.Utils.ZealException: Basic Contribution cannot be Less Than Payment Mode wise Min Contribution (1000) at ZealERP.ZealTakaful.Services.DBServiceChildPOSCreate.CheckMinMaxContribution(SaveDataModel record, OracleCommand command) at ZealERP.ZealTakaful.Services.DBServiceChildPOSCreate.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) 10/14/2024 10:12:53 PM: Error.. Basic Contribution cannot be Less Than Payment Mode wise Min Contribution (1000) ZealERP.ZealFramework.Utils.ZealException: Error.. Basic Contribution cannot be Less Than Payment Mode wise Min Contribution (1000) 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() 10/14/2024 10:13:36 PM: Sum Covered % not found on rider, please re-check ZealERP.ZealFramework.Utils.ZealException: Sum Covered % not found on rider, please re-check at ZealERP.ZealTakaful.Services.TakafulTech.IllustrationService.CalculationProcess(IllustrationCalculationDataModel model, OracleCommand command, Boolean fromPOS) at ZealERP.ZealTakaful.Services.TakafulTech.IllustrationService.<>c__DisplayClass29_0.b__0(OracleCommand command) at ZealERP.ZealFramework.Utils.ZealTransactionHandler.ExecuteTransaction(TransactionBody _TransactionBody) 10/14/2024 10:13:36 PM: Error.. Sum Covered % not found on rider, please re-check ZealERP.ZealFramework.Utils.ZealException: Error.. Sum Covered % not found on rider, please re-check at ZealERP.ZealFramework.Utils.ZealTransactionHandler.ExecuteTransaction(TransactionBody _TransactionBody) at ZealERP.ZealTakaful.Services.TakafulTech.IllustrationService.CalculationProcess(IllustrationCalculationDataModel model, Boolean fromPOS) at ZealERP.ZealTakaful.Controllers.TakafulTech.IllustrationController.<>c__DisplayClass17_0.b__0() at ZealERP.ZealFramework.Utils.ZealRestApiHandler.GetResponse(ControllerLogic GetDataFromService) 10/14/2024 10:13:41 PM: Sum Covered % not found on rider, please re-check ZealERP.ZealFramework.Utils.ZealException: Sum Covered % not found on rider, please re-check at ZealERP.ZealTakaful.Services.TakafulTech.IllustrationService.CalculationProcess(IllustrationCalculationDataModel model, OracleCommand command, Boolean fromPOS) at ZealERP.ZealTakaful.Services.TakafulTech.IllustrationService.<>c__DisplayClass29_0.b__0(OracleCommand command) at ZealERP.ZealFramework.Utils.ZealTransactionHandler.ExecuteTransaction(TransactionBody _TransactionBody) 10/14/2024 10:13:41 PM: Error.. Sum Covered % not found on rider, please re-check ZealERP.ZealFramework.Utils.ZealException: Error.. Sum Covered % not found on rider, please re-check at ZealERP.ZealFramework.Utils.ZealTransactionHandler.ExecuteTransaction(TransactionBody _TransactionBody) at ZealERP.ZealTakaful.Services.TakafulTech.IllustrationService.CalculationProcess(IllustrationCalculationDataModel model, Boolean fromPOS) at ZealERP.ZealTakaful.Controllers.TakafulTech.IllustrationController.<>c__DisplayClass17_0.b__0() at ZealERP.ZealFramework.Utils.ZealRestApiHandler.GetResponse(ControllerLogic GetDataFromService) 10/14/2024 10:32:28 PM: Unable to Save/Update, Guardian Age is less than 18 ZealERP.ZealFramework.Utils.ZealException: Unable to Save/Update, Guardian Age is less than 18 at ZealERP.ZealTakaful.Services.DBServiceChildBeneficiaryChild.CheckForMinorGuardian(SaveDataModel record, OracleCommand command) at ZealERP.ZealTakaful.Services.DBServiceChildBeneficiaryChild.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) 10/14/2024 10:32:28 PM: Error.. Unable to Save/Update, Guardian Age is less than 18 ZealERP.ZealFramework.Utils.ZealException: Error.. Unable to Save/Update, Guardian Age is less than 18 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() 10/14/2024 10:32:35 PM: Unable to Save/Update, Guardian Age is less than 18 ZealERP.ZealFramework.Utils.ZealException: Unable to Save/Update, Guardian Age is less than 18 at ZealERP.ZealTakaful.Services.DBServiceChildBeneficiaryChild.CheckForMinorGuardian(SaveDataModel record, OracleCommand command) at ZealERP.ZealTakaful.Services.DBServiceChildBeneficiaryChild.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) 10/14/2024 10:32:35 PM: Error.. Unable to Save/Update, Guardian Age is less than 18 ZealERP.ZealFramework.Utils.ZealException: Error.. Unable to Save/Update, Guardian Age is less than 18 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() 10/14/2024 10:39:27 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) 10/14/2024 10:59:17 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)