01-06-2026 01:09:14:ShowCBSAcNo(). Log: TranProcess.cs: ShowCBSAcNo() Query: SELECT SUBSTR ('001001003055', 0, brlength) branch, SUBSTR ('001001003055', brlength+1, schlength) linksno, SUBSTR ('001001003055', -aclength) acno FROM (SELECT a.sitp_doublevalue AS iinlenth, a.sitp_longvalue AS iin, b.sitp_doublevalue AS brlength, c.sitp_doublevalue AS schlength, d.sitp_doublevalue AS aclength FROM (SELECT 1 sno, sitp_doublevalue, sitp_longvalue FROM head.siteparameters WHERE sitp_name = 'IIN NUMBER') a, (SELECT 1 sno, sitp_doublevalue FROM head.siteparameters WHERE sitp_name = 'BRANCH CODE') b, (SELECT 1 sno, sitp_doublevalue FROM head.siteparameters WHERE sitp_name = 'SCHEME CODE') c, (SELECT 1 sno, sitp_doublevalue FROM head.siteparameters WHERE sitp_name = 'ACCOUNT NO') d WHERE a.sno = b.sno AND c.sno = a.sno AND d.sno = a.sno) TranProcess.cs: Fetch Query Row Count dtSplitCBSNo: 1 TranProcess.cs: Linkmain Query SELECT link_type, link_abbrev, bran_name, bran_sno FROM linkmain, MASTER.branch WHERE link_sno = 001 AND bran_sno = 001 TranProcess.cs: Linkmain Query Row Count dtTemp: 1 ShowCBS Ac No Proce Executed HEAD OFFICE|DEPOSIT|003055|SB|1 01-06-2026 01:09:14:Validation Account Proce Executed with out error <------------------------------------------------------------------------------------------------------------------------> ValidateAcNo CBS A/C No : 001001003055 ValidationAcNo.cs: Query TO Fetch() SELECT clms_des, clms_sno, NVL (depm_closedyn, 'N') AS closedyn, depm_closedate, depm_smsregyn AS smsreg FROM clientmaster, depositmaster WHERE clms_sno = depm_client AND NVL(depm_closedyn, 'N') = 'N' AND depm_branch = 1 AND TRIM (depm_abbr) = 'SB' AND depm_no = 003055ValidationAcNo.cs: Closedyn Query Row count1<------------------------------------------------------------------------------------------------------------------------> Y|SB|003055|1 01-06-2026 01:09:14:ValidationRequest(): Log:Validation Request DetailsHDFCH01028503375|001001003055 <------------------------Started ValidationRequest CBS A/C No : 001001003055 ------------------------> <------------------------------------------------------------------------------------------------------------------------> ValidationRequest Execution Success with response : 000 <------------------------------------------------------------------------------------------------------------------------> 01-06-2026 01:09:19:ShowCBSAcNo(). Log: TranProcess.cs: ShowCBSAcNo() Query: SELECT SUBSTR ('001001003055', 0, brlength) branch, SUBSTR ('001001003055', brlength+1, schlength) linksno, SUBSTR ('001001003055', -aclength) acno FROM (SELECT a.sitp_doublevalue AS iinlenth, a.sitp_longvalue AS iin, b.sitp_doublevalue AS brlength, c.sitp_doublevalue AS schlength, d.sitp_doublevalue AS aclength FROM (SELECT 1 sno, sitp_doublevalue, sitp_longvalue FROM head.siteparameters WHERE sitp_name = 'IIN NUMBER') a, (SELECT 1 sno, sitp_doublevalue FROM head.siteparameters WHERE sitp_name = 'BRANCH CODE') b, (SELECT 1 sno, sitp_doublevalue FROM head.siteparameters WHERE sitp_name = 'SCHEME CODE') c, (SELECT 1 sno, sitp_doublevalue FROM head.siteparameters WHERE sitp_name = 'ACCOUNT NO') d WHERE a.sno = b.sno AND c.sno = a.sno AND d.sno = a.sno) TranProcess.cs: Fetch Query Row Count dtSplitCBSNo: 1 TranProcess.cs: Linkmain Query SELECT link_type, link_abbrev, bran_name, bran_sno FROM linkmain, MASTER.branch WHERE link_sno = 001 AND bran_sno = 001 TranProcess.cs: Linkmain Query Row Count dtTemp: 1 ShowCBS Ac No Proce Executed HEAD OFFICE|DEPOSIT|003055|SB|1 01-06-2026 01:09:19:Validation Account Proce Executed with out error <------------------------------------------------------------------------------------------------------------------------> ValidateAcNo CBS A/C No : 001001003055 ValidationAcNo.cs: Query TO Fetch() SELECT clms_des, clms_sno, NVL (depm_closedyn, 'N') AS closedyn, depm_closedate, depm_smsregyn AS smsreg FROM clientmaster, depositmaster WHERE clms_sno = depm_client AND NVL(depm_closedyn, 'N') = 'N' AND depm_branch = 1 AND TRIM (depm_abbr) = 'SB' AND depm_no = 003055ValidationAcNo.cs: Closedyn Query Row count1<------------------------------------------------------------------------------------------------------------------------> Y|SB|003055|1 01-06-2026 01:09:19:TranProcess.cs: Inward_process() UTR ValidationSELECT remit_utr FROM rtgsinwardrequest WHERE Trim(remit_utr) = 'HDFCH01028503375' TranProcess.cs: Inward_process() UTR Validation0 TranProcess.cs: Inward_process(): Insert To rtgsinwardrequest: INSERT INTO rtgsinwardrequest (voucherno, voucherdate, trandate, received_datetime, remit_utr, benefi_name, benefi_accno, remit_name, remit_acno, sender_ifsc, benefi_ifsc, amount, file_name) VALUES ( seq_rtgsinward.NEXTVAL,TRUNC(SYSDATE),SYSDATE, SYSDATE, 'HDFCH01028503375','NAGARAJA TN','001001003055','GURUPRASAD T N', '50100652601604','HDFC0000001','UTIB0SMCBL1',50000,'123')TranProcess.cs: Inward_process(): 001001003055 HDFCH01028503375 Status : 000 01-06-2026 01:09:19:<------------------------------------------------------------------------------------------------------------------------> <-----------------------STARTED CONFIRMATION REQUEST PROCESS FOR THE DETAILS : HDFCH01028503375|001001003055 --------------------------> <------------------------------------------------------------------------------------------------------------------------> ConfirmationReq Execution Success with Status 000 <-----------------------END CONFIRMATION REQUEST PROCESS FOR THE DETAILS : HDFCH01028503375|001001003055 ------------------------------> <------------------------------------------------------------------------------------------------------------------------> 01-06-2026 01:45:22:ShowCBSAcNo(). Log: TranProcess.cs: ShowCBSAcNo() Query: SELECT SUBSTR ('001001001413', 0, brlength) branch, SUBSTR ('001001001413', brlength+1, schlength) linksno, SUBSTR ('001001001413', -aclength) acno FROM (SELECT a.sitp_doublevalue AS iinlenth, a.sitp_longvalue AS iin, b.sitp_doublevalue AS brlength, c.sitp_doublevalue AS schlength, d.sitp_doublevalue AS aclength FROM (SELECT 1 sno, sitp_doublevalue, sitp_longvalue FROM head.siteparameters WHERE sitp_name = 'IIN NUMBER') a, (SELECT 1 sno, sitp_doublevalue FROM head.siteparameters WHERE sitp_name = 'BRANCH CODE') b, (SELECT 1 sno, sitp_doublevalue FROM head.siteparameters WHERE sitp_name = 'SCHEME CODE') c, (SELECT 1 sno, sitp_doublevalue FROM head.siteparameters WHERE sitp_name = 'ACCOUNT NO') d WHERE a.sno = b.sno AND c.sno = a.sno AND d.sno = a.sno) TranProcess.cs: Fetch Query Row Count dtSplitCBSNo: 1 TranProcess.cs: Linkmain Query SELECT link_type, link_abbrev, bran_name, bran_sno FROM linkmain, MASTER.branch WHERE link_sno = 001 AND bran_sno = 001 TranProcess.cs: Linkmain Query Row Count dtTemp: 1 ShowCBS Ac No Proce Executed HEAD OFFICE|DEPOSIT|001413|SB|1 01-06-2026 01:45:22:Validation Account Proce Executed with out error <------------------------------------------------------------------------------------------------------------------------> ValidateAcNo CBS A/C No : 001001001413 ValidationAcNo.cs: Query TO Fetch() SELECT clms_des, clms_sno, NVL (depm_closedyn, 'N') AS closedyn, depm_closedate, depm_smsregyn AS smsreg FROM clientmaster, depositmaster WHERE clms_sno = depm_client AND NVL(depm_closedyn, 'N') = 'N' AND depm_branch = 1 AND TRIM (depm_abbr) = 'SB' AND depm_no = 001413ValidationAcNo.cs: Closedyn Query Row count1<------------------------------------------------------------------------------------------------------------------------> Y|SB|001413|1 01-06-2026 01:45:22:ValidationRequest(): Log:Validation Request DetailsAXNPM15207378454|001001001413 <------------------------Started ValidationRequest CBS A/C No : 001001001413 ------------------------> <------------------------------------------------------------------------------------------------------------------------> ValidationRequest Execution Success with response : 000 <------------------------------------------------------------------------------------------------------------------------> 01-06-2026 01:51:15:ShowCBSAcNo(). Log: TranProcess.cs: ShowCBSAcNo() Query: SELECT SUBSTR ('001001001314', 0, brlength) branch, SUBSTR ('001001001314', brlength+1, schlength) linksno, SUBSTR ('001001001314', -aclength) acno FROM (SELECT a.sitp_doublevalue AS iinlenth, a.sitp_longvalue AS iin, b.sitp_doublevalue AS brlength, c.sitp_doublevalue AS schlength, d.sitp_doublevalue AS aclength FROM (SELECT 1 sno, sitp_doublevalue, sitp_longvalue FROM head.siteparameters WHERE sitp_name = 'IIN NUMBER') a, (SELECT 1 sno, sitp_doublevalue FROM head.siteparameters WHERE sitp_name = 'BRANCH CODE') b, (SELECT 1 sno, sitp_doublevalue FROM head.siteparameters WHERE sitp_name = 'SCHEME CODE') c, (SELECT 1 sno, sitp_doublevalue FROM head.siteparameters WHERE sitp_name = 'ACCOUNT NO') d WHERE a.sno = b.sno AND c.sno = a.sno AND d.sno = a.sno) TranProcess.cs: Fetch Query Row Count dtSplitCBSNo: 1 TranProcess.cs: Linkmain Query SELECT link_type, link_abbrev, bran_name, bran_sno FROM linkmain, MASTER.branch WHERE link_sno = 001 AND bran_sno = 001 TranProcess.cs: Linkmain Query Row Count dtTemp: 1 ShowCBS Ac No Proce Executed HEAD OFFICE|DEPOSIT|001314|SB|1 01-06-2026 01:51:15:Validation Account Proce Executed with out error <------------------------------------------------------------------------------------------------------------------------> ValidateAcNo CBS A/C No : 001001001314 ValidationAcNo.cs: Query TO Fetch() SELECT clms_des, clms_sno, NVL (depm_closedyn, 'N') AS closedyn, depm_closedate, depm_smsregyn AS smsreg FROM clientmaster, depositmaster WHERE clms_sno = depm_client AND NVL(depm_closedyn, 'N') = 'N' AND depm_branch = 1 AND TRIM (depm_abbr) = 'SB' AND depm_no = 001314ValidationAcNo.cs: Closedyn Query Row count1<------------------------------------------------------------------------------------------------------------------------> Y|SB|001314|1 01-06-2026 01:51:15:ValidationRequest(): Log:Validation Request DetailsAXNPM15207671807|001001001314 <------------------------Started ValidationRequest CBS A/C No : 001001001314 ------------------------> <------------------------------------------------------------------------------------------------------------------------> ValidationRequest Execution Success with response : 000 <------------------------------------------------------------------------------------------------------------------------> 01-06-2026 01:58:04:ShowCBSAcNo(). Log: TranProcess.cs: ShowCBSAcNo() Query: SELECT SUBSTR ('001001001138', 0, brlength) branch, SUBSTR ('001001001138', brlength+1, schlength) linksno, SUBSTR ('001001001138', -aclength) acno FROM (SELECT a.sitp_doublevalue AS iinlenth, a.sitp_longvalue AS iin, b.sitp_doublevalue AS brlength, c.sitp_doublevalue AS schlength, d.sitp_doublevalue AS aclength FROM (SELECT 1 sno, sitp_doublevalue, sitp_longvalue FROM head.siteparameters WHERE sitp_name = 'IIN NUMBER') a, (SELECT 1 sno, sitp_doublevalue FROM head.siteparameters WHERE sitp_name = 'BRANCH CODE') b, (SELECT 1 sno, sitp_doublevalue FROM head.siteparameters WHERE sitp_name = 'SCHEME CODE') c, (SELECT 1 sno, sitp_doublevalue FROM head.siteparameters WHERE sitp_name = 'ACCOUNT NO') d WHERE a.sno = b.sno AND c.sno = a.sno AND d.sno = a.sno) TranProcess.cs: Fetch Query Row Count dtSplitCBSNo: 1 TranProcess.cs: Linkmain Query SELECT link_type, link_abbrev, bran_name, bran_sno FROM linkmain, MASTER.branch WHERE link_sno = 001 AND bran_sno = 001 TranProcess.cs: Linkmain Query Row Count dtTemp: 1 ShowCBS Ac No Proce Executed HEAD OFFICE|DEPOSIT|001138|SB|1 01-06-2026 01:58:04:Validation Account Proce Executed with out error <------------------------------------------------------------------------------------------------------------------------> ValidateAcNo CBS A/C No : 001001001138 ValidationAcNo.cs: Query TO Fetch() SELECT clms_des, clms_sno, NVL (depm_closedyn, 'N') AS closedyn, depm_closedate, depm_smsregyn AS smsreg FROM clientmaster, depositmaster WHERE clms_sno = depm_client AND NVL(depm_closedyn, 'N') = 'N' AND depm_branch = 1 AND TRIM (depm_abbr) = 'SB' AND depm_no = 001138ValidationAcNo.cs: Closedyn Query Row count1<------------------------------------------------------------------------------------------------------------------------> Y|SB|001138|1 01-06-2026 01:58:04:ValidationRequest(): Log:Validation Request DetailsAXNPM15207984670|001001001138 <------------------------Started ValidationRequest CBS A/C No : 001001001138 ------------------------> <------------------------------------------------------------------------------------------------------------------------> ValidationRequest Execution Success with response : 000 <------------------------------------------------------------------------------------------------------------------------> 01-06-2026 02:02:51:ShowCBSAcNo(). Log: TranProcess.cs: ShowCBSAcNo() Query: SELECT SUBSTR ('001001001413', 0, brlength) branch, SUBSTR ('001001001413', brlength+1, schlength) linksno, SUBSTR ('001001001413', -aclength) acno FROM (SELECT a.sitp_doublevalue AS iinlenth, a.sitp_longvalue AS iin, b.sitp_doublevalue AS brlength, c.sitp_doublevalue AS schlength, d.sitp_doublevalue AS aclength FROM (SELECT 1 sno, sitp_doublevalue, sitp_longvalue FROM head.siteparameters WHERE sitp_name = 'IIN NUMBER') a, (SELECT 1 sno, sitp_doublevalue FROM head.siteparameters WHERE sitp_name = 'BRANCH CODE') b, (SELECT 1 sno, sitp_doublevalue FROM head.siteparameters WHERE sitp_name = 'SCHEME CODE') c, (SELECT 1 sno, sitp_doublevalue FROM head.siteparameters WHERE sitp_name = 'ACCOUNT NO') d WHERE a.sno = b.sno AND c.sno = a.sno AND d.sno = a.sno) TranProcess.cs: Fetch Query Row Count dtSplitCBSNo: 1 TranProcess.cs: Linkmain Query SELECT link_type, link_abbrev, bran_name, bran_sno FROM linkmain, MASTER.branch WHERE link_sno = 001 AND bran_sno = 001 TranProcess.cs: Linkmain Query Row Count dtTemp: 1 ShowCBS Ac No Proce Executed HEAD OFFICE|DEPOSIT|001413|SB|1 01-06-2026 02:02:51:Validation Account Proce Executed with out error <------------------------------------------------------------------------------------------------------------------------> ValidateAcNo CBS A/C No : 001001001413 ValidationAcNo.cs: Query TO Fetch() SELECT clms_des, clms_sno, NVL (depm_closedyn, 'N') AS closedyn, depm_closedate, depm_smsregyn AS smsreg FROM clientmaster, depositmaster WHERE clms_sno = depm_client AND NVL(depm_closedyn, 'N') = 'N' AND depm_branch = 1 AND TRIM (depm_abbr) = 'SB' AND depm_no = 001413ValidationAcNo.cs: Closedyn Query Row count1<------------------------------------------------------------------------------------------------------------------------> Y|SB|001413|1 01-06-2026 02:02:51:TranProcess.cs: Inward_process() UTR ValidationSELECT remit_utr FROM rtgsinwardrequest WHERE Trim(remit_utr) = 'AXNPM15207378454' TranProcess.cs: Inward_process() UTR Validation0 TranProcess.cs: Inward_process(): Insert To rtgsinwardrequest: INSERT INTO rtgsinwardrequest (voucherno, voucherdate, trandate, received_datetime, remit_utr, benefi_name, benefi_accno, remit_name, remit_acno, sender_ifsc, benefi_ifsc, amount, file_name) VALUES ( seq_rtgsinward.NEXTVAL,TRUNC(SYSDATE),SYSDATE, SYSDATE, 'AXNPM15207378454','SHAMALA S P','001001001413','PAYTM PAYMENTS SERVICES LTD-PAYMENT AGGREGATOR ESCROW A/C', '922020004482533','UTIB0000022','UTIB0SMCBL1',425,'123')TranProcess.cs: Inward_process(): 001001001413 AXNPM15207378454 Status : 000 01-06-2026 02:02:51:<------------------------------------------------------------------------------------------------------------------------> <-----------------------STARTED CONFIRMATION REQUEST PROCESS FOR THE DETAILS : AXNPM15207378454|001001001413 --------------------------> <------------------------------------------------------------------------------------------------------------------------> ConfirmationReq Execution Success with Status 000 <-----------------------END CONFIRMATION REQUEST PROCESS FOR THE DETAILS : AXNPM15207378454|001001001413 ------------------------------> <------------------------------------------------------------------------------------------------------------------------> 01-06-2026 02:02:54:ShowCBSAcNo(). Log: TranProcess.cs: ShowCBSAcNo() Query: SELECT SUBSTR ('001001001314', 0, brlength) branch, SUBSTR ('001001001314', brlength+1, schlength) linksno, SUBSTR ('001001001314', -aclength) acno FROM (SELECT a.sitp_doublevalue AS iinlenth, a.sitp_longvalue AS iin, b.sitp_doublevalue AS brlength, c.sitp_doublevalue AS schlength, d.sitp_doublevalue AS aclength FROM (SELECT 1 sno, sitp_doublevalue, sitp_longvalue FROM head.siteparameters WHERE sitp_name = 'IIN NUMBER') a, (SELECT 1 sno, sitp_doublevalue FROM head.siteparameters WHERE sitp_name = 'BRANCH CODE') b, (SELECT 1 sno, sitp_doublevalue FROM head.siteparameters WHERE sitp_name = 'SCHEME CODE') c, (SELECT 1 sno, sitp_doublevalue FROM head.siteparameters WHERE sitp_name = 'ACCOUNT NO') d WHERE a.sno = b.sno AND c.sno = a.sno AND d.sno = a.sno) TranProcess.cs: Fetch Query Row Count dtSplitCBSNo: 1 TranProcess.cs: Linkmain Query SELECT link_type, link_abbrev, bran_name, bran_sno FROM linkmain, MASTER.branch WHERE link_sno = 001 AND bran_sno = 001 TranProcess.cs: Linkmain Query Row Count dtTemp: 1 ShowCBS Ac No Proce Executed HEAD OFFICE|DEPOSIT|001314|SB|1 01-06-2026 02:02:54:Validation Account Proce Executed with out error <------------------------------------------------------------------------------------------------------------------------> ValidateAcNo CBS A/C No : 001001001314 ValidationAcNo.cs: Query TO Fetch() SELECT clms_des, clms_sno, NVL (depm_closedyn, 'N') AS closedyn, depm_closedate, depm_smsregyn AS smsreg FROM clientmaster, depositmaster WHERE clms_sno = depm_client AND NVL(depm_closedyn, 'N') = 'N' AND depm_branch = 1 AND TRIM (depm_abbr) = 'SB' AND depm_no = 001314ValidationAcNo.cs: Closedyn Query Row count1<------------------------------------------------------------------------------------------------------------------------> Y|SB|001314|1 01-06-2026 02:02:54:TranProcess.cs: Inward_process() UTR ValidationSELECT remit_utr FROM rtgsinwardrequest WHERE Trim(remit_utr) = 'AXNPM15207671807' TranProcess.cs: Inward_process() UTR Validation0 TranProcess.cs: Inward_process(): Insert To rtgsinwardrequest: INSERT INTO rtgsinwardrequest (voucherno, voucherdate, trandate, received_datetime, remit_utr, benefi_name, benefi_accno, remit_name, remit_acno, sender_ifsc, benefi_ifsc, amount, file_name) VALUES ( seq_rtgsinward.NEXTVAL,TRUNC(SYSDATE),SYSDATE, SYSDATE, 'AXNPM15207671807','VIJAYA KUMAR S S','001001001314','PAYTM PAYMENTS SERVICES LTD-PAYMENT AGGREGATOR ESCROW A/C', '922020004482533','UTIB0000022','UTIB0SMCBL1',140,'123')TranProcess.cs: Inward_process(): 001001001314 AXNPM15207671807 Status : 000 01-06-2026 02:02:54:<------------------------------------------------------------------------------------------------------------------------> <-----------------------STARTED CONFIRMATION REQUEST PROCESS FOR THE DETAILS : AXNPM15207671807|001001001314 --------------------------> <------------------------------------------------------------------------------------------------------------------------> ConfirmationReq Execution Success with Status 000 <-----------------------END CONFIRMATION REQUEST PROCESS FOR THE DETAILS : AXNPM15207671807|001001001314 ------------------------------> <------------------------------------------------------------------------------------------------------------------------> 01-06-2026 02:02:58:ShowCBSAcNo(). Log: TranProcess.cs: ShowCBSAcNo() Query: SELECT SUBSTR ('001001001138', 0, brlength) branch, SUBSTR ('001001001138', brlength+1, schlength) linksno, SUBSTR ('001001001138', -aclength) acno FROM (SELECT a.sitp_doublevalue AS iinlenth, a.sitp_longvalue AS iin, b.sitp_doublevalue AS brlength, c.sitp_doublevalue AS schlength, d.sitp_doublevalue AS aclength FROM (SELECT 1 sno, sitp_doublevalue, sitp_longvalue FROM head.siteparameters WHERE sitp_name = 'IIN NUMBER') a, (SELECT 1 sno, sitp_doublevalue FROM head.siteparameters WHERE sitp_name = 'BRANCH CODE') b, (SELECT 1 sno, sitp_doublevalue FROM head.siteparameters WHERE sitp_name = 'SCHEME CODE') c, (SELECT 1 sno, sitp_doublevalue FROM head.siteparameters WHERE sitp_name = 'ACCOUNT NO') d WHERE a.sno = b.sno AND c.sno = a.sno AND d.sno = a.sno) TranProcess.cs: Fetch Query Row Count dtSplitCBSNo: 1 TranProcess.cs: Linkmain Query SELECT link_type, link_abbrev, bran_name, bran_sno FROM linkmain, MASTER.branch WHERE link_sno = 001 AND bran_sno = 001 TranProcess.cs: Linkmain Query Row Count dtTemp: 1 ShowCBS Ac No Proce Executed HEAD OFFICE|DEPOSIT|001138|SB|1 01-06-2026 02:02:58:Validation Account Proce Executed with out error <------------------------------------------------------------------------------------------------------------------------> ValidateAcNo CBS A/C No : 001001001138 ValidationAcNo.cs: Query TO Fetch() SELECT clms_des, clms_sno, NVL (depm_closedyn, 'N') AS closedyn, depm_closedate, depm_smsregyn AS smsreg FROM clientmaster, depositmaster WHERE clms_sno = depm_client AND NVL(depm_closedyn, 'N') = 'N' AND depm_branch = 1 AND TRIM (depm_abbr) = 'SB' AND depm_no = 001138ValidationAcNo.cs: Closedyn Query Row count1<------------------------------------------------------------------------------------------------------------------------> Y|SB|001138|1 01-06-2026 02:02:58:TranProcess.cs: Inward_process() UTR ValidationSELECT remit_utr FROM rtgsinwardrequest WHERE Trim(remit_utr) = 'AXNPM15207984670' TranProcess.cs: Inward_process() UTR Validation0 TranProcess.cs: Inward_process(): Insert To rtgsinwardrequest: INSERT INTO rtgsinwardrequest (voucherno, voucherdate, trandate, received_datetime, remit_utr, benefi_name, benefi_accno, remit_name, remit_acno, sender_ifsc, benefi_ifsc, amount, file_name) VALUES ( seq_rtgsinward.NEXTVAL,TRUNC(SYSDATE),SYSDATE, SYSDATE, 'AXNPM15207984670','GIRISH BABU','001001001138','PAYTM PAYMENTS SERVICES LTD-PAYMENT AGGREGATOR ESCROW A/C', '922020004482533','UTIB0000022','UTIB0SMCBL1',3725,'123')TranProcess.cs: Inward_process(): 001001001138 AXNPM15207984670 Status : 000 01-06-2026 02:02:58:<------------------------------------------------------------------------------------------------------------------------> <-----------------------STARTED CONFIRMATION REQUEST PROCESS FOR THE DETAILS : AXNPM15207984670|001001001138 --------------------------> <------------------------------------------------------------------------------------------------------------------------> ConfirmationReq Execution Success with Status 000 <-----------------------END CONFIRMATION REQUEST PROCESS FOR THE DETAILS : AXNPM15207984670|001001001138 ------------------------------> <------------------------------------------------------------------------------------------------------------------------> 01-06-2026 02:32:41:ShowCBSAcNo(). Log: TranProcess.cs: ShowCBSAcNo() Query: SELECT SUBSTR ('001030001125', 0, brlength) branch, SUBSTR ('001030001125', brlength+1, schlength) linksno, SUBSTR ('001030001125', -aclength) acno FROM (SELECT a.sitp_doublevalue AS iinlenth, a.sitp_longvalue AS iin, b.sitp_doublevalue AS brlength, c.sitp_doublevalue AS schlength, d.sitp_doublevalue AS aclength FROM (SELECT 1 sno, sitp_doublevalue, sitp_longvalue FROM head.siteparameters WHERE sitp_name = 'IIN NUMBER') a, (SELECT 1 sno, sitp_doublevalue FROM head.siteparameters WHERE sitp_name = 'BRANCH CODE') b, (SELECT 1 sno, sitp_doublevalue FROM head.siteparameters WHERE sitp_name = 'SCHEME CODE') c, (SELECT 1 sno, sitp_doublevalue FROM head.siteparameters WHERE sitp_name = 'ACCOUNT NO') d WHERE a.sno = b.sno AND c.sno = a.sno AND d.sno = a.sno) TranProcess.cs: Fetch Query Row Count dtSplitCBSNo: 1 TranProcess.cs: Linkmain Query SELECT link_type, link_abbrev, bran_name, bran_sno FROM linkmain, MASTER.branch WHERE link_sno = 030 AND bran_sno = 001 TranProcess.cs: Linkmain Query Row Count dtTemp: 1 ShowCBS Ac No Proce Executed HEAD OFFICE|OD|001125|CHL|1 01-06-2026 02:32:41:Validation Account Proce Executed with out error <------------------------------------------------------------------------------------------------------------------------> ValidateAcNo CBS A/C No : 001030001125 ValidationAcNo.cs: Query TO Fetch() SELECT clms_des, clms_sno, NVL (odmt_closedyn, 'N') AS closedyn, odmt_closedate, odmt_smsregyn AS smsreg FROM clientmaster, odmaster WHERE clms_sno = odmt_client AND NVL(odmt_closedyn, 'N') = 'N' AND odmt_branch = 1 AND TRIM (odmt_abbr) = 'CHL' AND odmt_no = 001125ValidationAcNo.cs: Closedyn Query Row count1<------------------------------------------------------------------------------------------------------------------------> Y|CHL|001125|1 01-06-2026 02:32:41:ValidationRequest(): Log:Validation Request DetailsAXNPN15209078666|001030001125 <------------------------Started ValidationRequest CBS A/C No : 001030001125 ------------------------> <------------------------------------------------------------------------------------------------------------------------> ValidationRequest Execution Success with response : 000 <------------------------------------------------------------------------------------------------------------------------> 01-06-2026 02:39:47:ShowCBSAcNo(). Log: TranProcess.cs: ShowCBSAcNo() Query: SELECT SUBSTR ('001001003750', 0, brlength) branch, SUBSTR ('001001003750', brlength+1, schlength) linksno, SUBSTR ('001001003750', -aclength) acno FROM (SELECT a.sitp_doublevalue AS iinlenth, a.sitp_longvalue AS iin, b.sitp_doublevalue AS brlength, c.sitp_doublevalue AS schlength, d.sitp_doublevalue AS aclength FROM (SELECT 1 sno, sitp_doublevalue, sitp_longvalue FROM head.siteparameters WHERE sitp_name = 'IIN NUMBER') a, (SELECT 1 sno, sitp_doublevalue FROM head.siteparameters WHERE sitp_name = 'BRANCH CODE') b, (SELECT 1 sno, sitp_doublevalue FROM head.siteparameters WHERE sitp_name = 'SCHEME CODE') c, (SELECT 1 sno, sitp_doublevalue FROM head.siteparameters WHERE sitp_name = 'ACCOUNT NO') d WHERE a.sno = b.sno AND c.sno = a.sno AND d.sno = a.sno) TranProcess.cs: Fetch Query Row Count dtSplitCBSNo: 1 TranProcess.cs: Linkmain Query SELECT link_type, link_abbrev, bran_name, bran_sno FROM linkmain, MASTER.branch WHERE link_sno = 001 AND bran_sno = 001 TranProcess.cs: Linkmain Query Row Count dtTemp: 1 ShowCBS Ac No Proce Executed HEAD OFFICE|DEPOSIT|003750|SB|1 01-06-2026 02:39:47:Validation Account Proce Executed with out error <------------------------------------------------------------------------------------------------------------------------> ValidateAcNo CBS A/C No : 001001003750 ValidationAcNo.cs: Query TO Fetch() SELECT clms_des, clms_sno, NVL (depm_closedyn, 'N') AS closedyn, depm_closedate, depm_smsregyn AS smsreg FROM clientmaster, depositmaster WHERE clms_sno = depm_client AND NVL(depm_closedyn, 'N') = 'N' AND depm_branch = 1 AND TRIM (depm_abbr) = 'SB' AND depm_no = 003750ValidationAcNo.cs: Closedyn Query Row count1<------------------------------------------------------------------------------------------------------------------------> Y|SB|003750|1 01-06-2026 02:39:47:ValidationRequest(): Log:Validation Request DetailsAXNPM15209332159|001001003750 <------------------------Started ValidationRequest CBS A/C No : 001001003750 ------------------------> <------------------------------------------------------------------------------------------------------------------------> ValidationRequest Execution Success with response : 000 <------------------------------------------------------------------------------------------------------------------------> 01-06-2026 02:52:26:ShowCBSAcNo(). Log: TranProcess.cs: ShowCBSAcNo() Query: SELECT SUBSTR ('001002001165', 0, brlength) branch, SUBSTR ('001002001165', brlength+1, schlength) linksno, SUBSTR ('001002001165', -aclength) acno FROM (SELECT a.sitp_doublevalue AS iinlenth, a.sitp_longvalue AS iin, b.sitp_doublevalue AS brlength, c.sitp_doublevalue AS schlength, d.sitp_doublevalue AS aclength FROM (SELECT 1 sno, sitp_doublevalue, sitp_longvalue FROM head.siteparameters WHERE sitp_name = 'IIN NUMBER') a, (SELECT 1 sno, sitp_doublevalue FROM head.siteparameters WHERE sitp_name = 'BRANCH CODE') b, (SELECT 1 sno, sitp_doublevalue FROM head.siteparameters WHERE sitp_name = 'SCHEME CODE') c, (SELECT 1 sno, sitp_doublevalue FROM head.siteparameters WHERE sitp_name = 'ACCOUNT NO') d WHERE a.sno = b.sno AND c.sno = a.sno AND d.sno = a.sno) TranProcess.cs: Fetch Query Row Count dtSplitCBSNo: 1 TranProcess.cs: Linkmain Query SELECT link_type, link_abbrev, bran_name, bran_sno FROM linkmain, MASTER.branch WHERE link_sno = 002 AND bran_sno = 001 TranProcess.cs: Linkmain Query Row Count dtTemp: 1 ShowCBS Ac No Proce Executed HEAD OFFICE|DEPOSIT|001165|CA|1 01-06-2026 02:52:26:Validation Account Proce Executed with out error <------------------------------------------------------------------------------------------------------------------------> ValidateAcNo CBS A/C No : 001002001165 ValidationAcNo.cs: Query TO Fetch() SELECT clms_des, clms_sno, NVL (depm_closedyn, 'N') AS closedyn, depm_closedate, depm_smsregyn AS smsreg FROM clientmaster, depositmaster WHERE clms_sno = depm_client AND NVL(depm_closedyn, 'N') = 'N' AND depm_branch = 1 AND TRIM (depm_abbr) = 'CA' AND depm_no = 001165ValidationAcNo.cs: Closedyn Query Row count1<------------------------------------------------------------------------------------------------------------------------> Y|CA|001165|1 01-06-2026 02:52:26:ValidationRequest(): Log:Validation Request DetailsAXNPM15209668579|001002001165 <------------------------Started ValidationRequest CBS A/C No : 001002001165 ------------------------> <------------------------------------------------------------------------------------------------------------------------> ValidationRequest Execution Success with response : 000 <------------------------------------------------------------------------------------------------------------------------> 01-06-2026 02:56:14:ShowCBSAcNo(). Log: TranProcess.cs: ShowCBSAcNo() Query: SELECT SUBSTR ('001002001154', 0, brlength) branch, SUBSTR ('001002001154', brlength+1, schlength) linksno, SUBSTR ('001002001154', -aclength) acno FROM (SELECT a.sitp_doublevalue AS iinlenth, a.sitp_longvalue AS iin, b.sitp_doublevalue AS brlength, c.sitp_doublevalue AS schlength, d.sitp_doublevalue AS aclength FROM (SELECT 1 sno, sitp_doublevalue, sitp_longvalue FROM head.siteparameters WHERE sitp_name = 'IIN NUMBER') a, (SELECT 1 sno, sitp_doublevalue FROM head.siteparameters WHERE sitp_name = 'BRANCH CODE') b, (SELECT 1 sno, sitp_doublevalue FROM head.siteparameters WHERE sitp_name = 'SCHEME CODE') c, (SELECT 1 sno, sitp_doublevalue FROM head.siteparameters WHERE sitp_name = 'ACCOUNT NO') d WHERE a.sno = b.sno AND c.sno = a.sno AND d.sno = a.sno) TranProcess.cs: Fetch Query Row Count dtSplitCBSNo: 1 TranProcess.cs: Linkmain Query SELECT link_type, link_abbrev, bran_name, bran_sno FROM linkmain, MASTER.branch WHERE link_sno = 002 AND bran_sno = 001 TranProcess.cs: Linkmain Query Row Count dtTemp: 1 ShowCBS Ac No Proce Executed HEAD OFFICE|DEPOSIT|001154|CA|1 01-06-2026 02:56:14:Validation Account Proce Executed with out error <------------------------------------------------------------------------------------------------------------------------> ValidateAcNo CBS A/C No : 001002001154 ValidationAcNo.cs: Query TO Fetch() SELECT clms_des, clms_sno, NVL (depm_closedyn, 'N') AS closedyn, depm_closedate, depm_smsregyn AS smsreg FROM clientmaster, depositmaster WHERE clms_sno = depm_client AND NVL(depm_closedyn, 'N') = 'N' AND depm_branch = 1 AND TRIM (depm_abbr) = 'CA' AND depm_no = 001154ValidationAcNo.cs: Closedyn Query Row count1<------------------------------------------------------------------------------------------------------------------------> Y|CA|001154|1 01-06-2026 02:56:14:ValidationRequest(): Log:Validation Request DetailsAXNPN15209765446|001002001154 <------------------------Started ValidationRequest CBS A/C No : 001002001154 ------------------------> <------------------------------------------------------------------------------------------------------------------------> ValidationRequest Execution Success with response : 000 <------------------------------------------------------------------------------------------------------------------------> 01-06-2026 03:02:28:ShowCBSAcNo(). Log: TranProcess.cs: ShowCBSAcNo() Query: SELECT SUBSTR ('001030001125', 0, brlength) branch, SUBSTR ('001030001125', brlength+1, schlength) linksno, SUBSTR ('001030001125', -aclength) acno FROM (SELECT a.sitp_doublevalue AS iinlenth, a.sitp_longvalue AS iin, b.sitp_doublevalue AS brlength, c.sitp_doublevalue AS schlength, d.sitp_doublevalue AS aclength FROM (SELECT 1 sno, sitp_doublevalue, sitp_longvalue FROM head.siteparameters WHERE sitp_name = 'IIN NUMBER') a, (SELECT 1 sno, sitp_doublevalue FROM head.siteparameters WHERE sitp_name = 'BRANCH CODE') b, (SELECT 1 sno, sitp_doublevalue FROM head.siteparameters WHERE sitp_name = 'SCHEME CODE') c, (SELECT 1 sno, sitp_doublevalue FROM head.siteparameters WHERE sitp_name = 'ACCOUNT NO') d WHERE a.sno = b.sno AND c.sno = a.sno AND d.sno = a.sno) TranProcess.cs: Fetch Query Row Count dtSplitCBSNo: 1 TranProcess.cs: Linkmain Query SELECT link_type, link_abbrev, bran_name, bran_sno FROM linkmain, MASTER.branch WHERE link_sno = 030 AND bran_sno = 001 TranProcess.cs: Linkmain Query Row Count dtTemp: 1 ShowCBS Ac No Proce Executed HEAD OFFICE|OD|001125|CHL|1 01-06-2026 03:02:28:Validation Account Proce Executed with out error <------------------------------------------------------------------------------------------------------------------------> ValidateAcNo CBS A/C No : 001030001125 ValidationAcNo.cs: Query TO Fetch() SELECT clms_des, clms_sno, NVL (odmt_closedyn, 'N') AS closedyn, odmt_closedate, odmt_smsregyn AS smsreg FROM clientmaster, odmaster WHERE clms_sno = odmt_client AND NVL(odmt_closedyn, 'N') = 'N' AND odmt_branch = 1 AND TRIM (odmt_abbr) = 'CHL' AND odmt_no = 001125ValidationAcNo.cs: Closedyn Query Row count1<------------------------------------------------------------------------------------------------------------------------> Y|CHL|001125|1 01-06-2026 03:02:28:TranProcess.cs: Inward_process() UTR ValidationSELECT remit_utr FROM rtgsinwardrequest WHERE Trim(remit_utr) = 'AXNPN15209078666' TranProcess.cs: Inward_process() UTR Validation0 TranProcess.cs: Inward_process(): Insert To rtgsinwardrequest: INSERT INTO rtgsinwardrequest (voucherno, voucherdate, trandate, received_datetime, remit_utr, benefi_name, benefi_accno, remit_name, remit_acno, sender_ifsc, benefi_ifsc, amount, file_name) VALUES ( seq_rtgsinward.NEXTVAL,TRUNC(SYSDATE),SYSDATE, SYSDATE, 'AXNPN15209078666','PAVAN KUMAR D','001030001125','PHONEPE LIMITED-PAYMENT AGGREGATOR ESCROW ACCOUNT', '922020004688715','UTIB0001506','UTIB0SMCBL1',4170,'123')TranProcess.cs: Inward_process(): 001030001125 AXNPN15209078666 Status : 000 01-06-2026 03:02:28:<------------------------------------------------------------------------------------------------------------------------> <-----------------------STARTED CONFIRMATION REQUEST PROCESS FOR THE DETAILS : AXNPN15209078666|001030001125 --------------------------> <------------------------------------------------------------------------------------------------------------------------> ConfirmationReq Execution Success with Status 000 <-----------------------END CONFIRMATION REQUEST PROCESS FOR THE DETAILS : AXNPN15209078666|001030001125 ------------------------------> <------------------------------------------------------------------------------------------------------------------------> 01-06-2026 03:02:52:ShowCBSAcNo(). Log: TranProcess.cs: ShowCBSAcNo() Query: SELECT SUBSTR ('001001003750', 0, brlength) branch, SUBSTR ('001001003750', brlength+1, schlength) linksno, SUBSTR ('001001003750', -aclength) acno FROM (SELECT a.sitp_doublevalue AS iinlenth, a.sitp_longvalue AS iin, b.sitp_doublevalue AS brlength, c.sitp_doublevalue AS schlength, d.sitp_doublevalue AS aclength FROM (SELECT 1 sno, sitp_doublevalue, sitp_longvalue FROM head.siteparameters WHERE sitp_name = 'IIN NUMBER') a, (SELECT 1 sno, sitp_doublevalue FROM head.siteparameters WHERE sitp_name = 'BRANCH CODE') b, (SELECT 1 sno, sitp_doublevalue FROM head.siteparameters WHERE sitp_name = 'SCHEME CODE') c, (SELECT 1 sno, sitp_doublevalue FROM head.siteparameters WHERE sitp_name = 'ACCOUNT NO') d WHERE a.sno = b.sno AND c.sno = a.sno AND d.sno = a.sno) TranProcess.cs: Fetch Query Row Count dtSplitCBSNo: 1 TranProcess.cs: Linkmain Query SELECT link_type, link_abbrev, bran_name, bran_sno FROM linkmain, MASTER.branch WHERE link_sno = 001 AND bran_sno = 001 TranProcess.cs: Linkmain Query Row Count dtTemp: 1 ShowCBS Ac No Proce Executed HEAD OFFICE|DEPOSIT|003750|SB|1 01-06-2026 03:02:52:Validation Account Proce Executed with out error <------------------------------------------------------------------------------------------------------------------------> ValidateAcNo CBS A/C No : 001001003750 ValidationAcNo.cs: Query TO Fetch() SELECT clms_des, clms_sno, NVL (depm_closedyn, 'N') AS closedyn, depm_closedate, depm_smsregyn AS smsreg FROM clientmaster, depositmaster WHERE clms_sno = depm_client AND NVL(depm_closedyn, 'N') = 'N' AND depm_branch = 1 AND TRIM (depm_abbr) = 'SB' AND depm_no = 003750ValidationAcNo.cs: Closedyn Query Row count1<------------------------------------------------------------------------------------------------------------------------> Y|SB|003750|1 01-06-2026 03:02:52:TranProcess.cs: Inward_process() UTR ValidationSELECT remit_utr FROM rtgsinwardrequest WHERE Trim(remit_utr) = 'AXNPM15209332159' TranProcess.cs: Inward_process() UTR Validation0 TranProcess.cs: Inward_process(): Insert To rtgsinwardrequest: INSERT INTO rtgsinwardrequest (voucherno, voucherdate, trandate, received_datetime, remit_utr, benefi_name, benefi_accno, remit_name, remit_acno, sender_ifsc, benefi_ifsc, amount, file_name) VALUES ( seq_rtgsinward.NEXTVAL,TRUNC(SYSDATE),SYSDATE, SYSDATE, 'AXNPM15209332159','AMITH K R','001001003750','PAYTM PAYMENTS SERVICES LTD-PAYMENT AGGREGATOR ESCROW A/C', '922020004482533','UTIB0000022','UTIB0SMCBL1',443,'123')TranProcess.cs: Inward_process(): 001001003750 AXNPM15209332159 Status : 000 01-06-2026 03:02:52:<------------------------------------------------------------------------------------------------------------------------> <-----------------------STARTED CONFIRMATION REQUEST PROCESS FOR THE DETAILS : AXNPM15209332159|001001003750 --------------------------> <------------------------------------------------------------------------------------------------------------------------> ConfirmationReq Execution Success with Status 000 <-----------------------END CONFIRMATION REQUEST PROCESS FOR THE DETAILS : AXNPM15209332159|001001003750 ------------------------------> <------------------------------------------------------------------------------------------------------------------------> 01-06-2026 03:03:11:ShowCBSAcNo(). Log: TranProcess.cs: ShowCBSAcNo() Query: SELECT SUBSTR ('001002001165', 0, brlength) branch, SUBSTR ('001002001165', brlength+1, schlength) linksno, SUBSTR ('001002001165', -aclength) acno FROM (SELECT a.sitp_doublevalue AS iinlenth, a.sitp_longvalue AS iin, b.sitp_doublevalue AS brlength, c.sitp_doublevalue AS schlength, d.sitp_doublevalue AS aclength FROM (SELECT 1 sno, sitp_doublevalue, sitp_longvalue FROM head.siteparameters WHERE sitp_name = 'IIN NUMBER') a, (SELECT 1 sno, sitp_doublevalue FROM head.siteparameters WHERE sitp_name = 'BRANCH CODE') b, (SELECT 1 sno, sitp_doublevalue FROM head.siteparameters WHERE sitp_name = 'SCHEME CODE') c, (SELECT 1 sno, sitp_doublevalue FROM head.siteparameters WHERE sitp_name = 'ACCOUNT NO') d WHERE a.sno = b.sno AND c.sno = a.sno AND d.sno = a.sno) TranProcess.cs: Fetch Query Row Count dtSplitCBSNo: 1 TranProcess.cs: Linkmain Query SELECT link_type, link_abbrev, bran_name, bran_sno FROM linkmain, MASTER.branch WHERE link_sno = 002 AND bran_sno = 001 TranProcess.cs: Linkmain Query Row Count dtTemp: 1 ShowCBS Ac No Proce Executed HEAD OFFICE|DEPOSIT|001165|CA|1 01-06-2026 03:03:11:Validation Account Proce Executed with out error <------------------------------------------------------------------------------------------------------------------------> ValidateAcNo CBS A/C No : 001002001165 ValidationAcNo.cs: Query TO Fetch() SELECT clms_des, clms_sno, NVL (depm_closedyn, 'N') AS closedyn, depm_closedate, depm_smsregyn AS smsreg FROM clientmaster, depositmaster WHERE clms_sno = depm_client AND NVL(depm_closedyn, 'N') = 'N' AND depm_branch = 1 AND TRIM (depm_abbr) = 'CA' AND depm_no = 001165ValidationAcNo.cs: Closedyn Query Row count1<------------------------------------------------------------------------------------------------------------------------> Y|CA|001165|1 01-06-2026 03:03:11:TranProcess.cs: Inward_process() UTR ValidationSELECT remit_utr FROM rtgsinwardrequest WHERE Trim(remit_utr) = 'AXNPM15209668579' TranProcess.cs: Inward_process() UTR Validation0 TranProcess.cs: Inward_process(): Insert To rtgsinwardrequest: INSERT INTO rtgsinwardrequest (voucherno, voucherdate, trandate, received_datetime, remit_utr, benefi_name, benefi_accno, remit_name, remit_acno, sender_ifsc, benefi_ifsc, amount, file_name) VALUES ( seq_rtgsinward.NEXTVAL,TRUNC(SYSDATE),SYSDATE, SYSDATE, 'AXNPM15209668579','SANGEETHA TEXTORIUM','001002001165','PAYTM PAYMENTS SERVICES LTD-PAYMENT AGGREGATOR ESCROW A/C', '922020004482533','UTIB0000022','UTIB0SMCBL1',25000,'123')TranProcess.cs: Inward_process(): 001002001165 AXNPM15209668579 Status : 000 01-06-2026 03:03:11:<------------------------------------------------------------------------------------------------------------------------> <-----------------------STARTED CONFIRMATION REQUEST PROCESS FOR THE DETAILS : AXNPM15209668579|001002001165 --------------------------> <------------------------------------------------------------------------------------------------------------------------> ConfirmationReq Execution Success with Status 000 <-----------------------END CONFIRMATION REQUEST PROCESS FOR THE DETAILS : AXNPM15209668579|001002001165 ------------------------------> <------------------------------------------------------------------------------------------------------------------------> 01-06-2026 03:03:13:ShowCBSAcNo(). Log: TranProcess.cs: ShowCBSAcNo() Query: SELECT SUBSTR ('001002001154', 0, brlength) branch, SUBSTR ('001002001154', brlength+1, schlength) linksno, SUBSTR ('001002001154', -aclength) acno FROM (SELECT a.sitp_doublevalue AS iinlenth, a.sitp_longvalue AS iin, b.sitp_doublevalue AS brlength, c.sitp_doublevalue AS schlength, d.sitp_doublevalue AS aclength FROM (SELECT 1 sno, sitp_doublevalue, sitp_longvalue FROM head.siteparameters WHERE sitp_name = 'IIN NUMBER') a, (SELECT 1 sno, sitp_doublevalue FROM head.siteparameters WHERE sitp_name = 'BRANCH CODE') b, (SELECT 1 sno, sitp_doublevalue FROM head.siteparameters WHERE sitp_name = 'SCHEME CODE') c, (SELECT 1 sno, sitp_doublevalue FROM head.siteparameters WHERE sitp_name = 'ACCOUNT NO') d WHERE a.sno = b.sno AND c.sno = a.sno AND d.sno = a.sno) TranProcess.cs: Fetch Query Row Count dtSplitCBSNo: 1 TranProcess.cs: Linkmain Query SELECT link_type, link_abbrev, bran_name, bran_sno FROM linkmain, MASTER.branch WHERE link_sno = 002 AND bran_sno = 001 TranProcess.cs: Linkmain Query Row Count dtTemp: 1 ShowCBS Ac No Proce Executed HEAD OFFICE|DEPOSIT|001154|CA|1 01-06-2026 03:03:13:Validation Account Proce Executed with out error <------------------------------------------------------------------------------------------------------------------------> ValidateAcNo CBS A/C No : 001002001154 ValidationAcNo.cs: Query TO Fetch() SELECT clms_des, clms_sno, NVL (depm_closedyn, 'N') AS closedyn, depm_closedate, depm_smsregyn AS smsreg FROM clientmaster, depositmaster WHERE clms_sno = depm_client AND NVL(depm_closedyn, 'N') = 'N' AND depm_branch = 1 AND TRIM (depm_abbr) = 'CA' AND depm_no = 001154ValidationAcNo.cs: Closedyn Query Row count1<------------------------------------------------------------------------------------------------------------------------> Y|CA|001154|1 01-06-2026 03:03:13:TranProcess.cs: Inward_process() UTR ValidationSELECT remit_utr FROM rtgsinwardrequest WHERE Trim(remit_utr) = 'AXNPN15209765446' TranProcess.cs: Inward_process() UTR Validation0 TranProcess.cs: Inward_process(): Insert To rtgsinwardrequest: INSERT INTO rtgsinwardrequest (voucherno, voucherdate, trandate, received_datetime, remit_utr, benefi_name, benefi_accno, remit_name, remit_acno, sender_ifsc, benefi_ifsc, amount, file_name) VALUES ( seq_rtgsinward.NEXTVAL,TRUNC(SYSDATE),SYSDATE, SYSDATE, 'AXNPN15209765446','BALAJI JEWELS','001002001154','PHONEPE LIMITED-PAYMENT AGGREGATOR ESCROW ACCOUNT', '922020004688715','UTIB0001506','UTIB0SMCBL1',5820,'123')TranProcess.cs: Inward_process(): 001002001154 AXNPN15209765446 Status : 000 01-06-2026 03:03:13:<------------------------------------------------------------------------------------------------------------------------> <-----------------------STARTED CONFIRMATION REQUEST PROCESS FOR THE DETAILS : AXNPN15209765446|001002001154 --------------------------> <------------------------------------------------------------------------------------------------------------------------> ConfirmationReq Execution Success with Status 000 <-----------------------END CONFIRMATION REQUEST PROCESS FOR THE DETAILS : AXNPN15209765446|001002001154 ------------------------------> <------------------------------------------------------------------------------------------------------------------------> 01-06-2026 03:07:04:ShowCBSAcNo(). Log: TranProcess.cs: ShowCBSAcNo() Query: SELECT SUBSTR ('001030001102', 0, brlength) branch, SUBSTR ('001030001102', brlength+1, schlength) linksno, SUBSTR ('001030001102', -aclength) acno FROM (SELECT a.sitp_doublevalue AS iinlenth, a.sitp_longvalue AS iin, b.sitp_doublevalue AS brlength, c.sitp_doublevalue AS schlength, d.sitp_doublevalue AS aclength FROM (SELECT 1 sno, sitp_doublevalue, sitp_longvalue FROM head.siteparameters WHERE sitp_name = 'IIN NUMBER') a, (SELECT 1 sno, sitp_doublevalue FROM head.siteparameters WHERE sitp_name = 'BRANCH CODE') b, (SELECT 1 sno, sitp_doublevalue FROM head.siteparameters WHERE sitp_name = 'SCHEME CODE') c, (SELECT 1 sno, sitp_doublevalue FROM head.siteparameters WHERE sitp_name = 'ACCOUNT NO') d WHERE a.sno = b.sno AND c.sno = a.sno AND d.sno = a.sno) TranProcess.cs: Fetch Query Row Count dtSplitCBSNo: 1 TranProcess.cs: Linkmain Query SELECT link_type, link_abbrev, bran_name, bran_sno FROM linkmain, MASTER.branch WHERE link_sno = 030 AND bran_sno = 001 TranProcess.cs: Linkmain Query Row Count dtTemp: 1 ShowCBS Ac No Proce Executed HEAD OFFICE|OD|001102|CHL|1 01-06-2026 03:07:04:Validation Account Proce Executed with out error <------------------------------------------------------------------------------------------------------------------------> ValidateAcNo CBS A/C No : 001030001102 ValidationAcNo.cs: Query TO Fetch() SELECT clms_des, clms_sno, NVL (odmt_closedyn, 'N') AS closedyn, odmt_closedate, odmt_smsregyn AS smsreg FROM clientmaster, odmaster WHERE clms_sno = odmt_client AND NVL(odmt_closedyn, 'N') = 'N' AND odmt_branch = 1 AND TRIM (odmt_abbr) = 'CHL' AND odmt_no = 001102ValidationAcNo.cs: Closedyn Query Row count1<------------------------------------------------------------------------------------------------------------------------> Y|CHL|001102|1 01-06-2026 03:07:04:ValidationRequest(): Log:Validation Request DetailsAXNPM15209993005|001030001102 <------------------------Started ValidationRequest CBS A/C No : 001030001102 ------------------------> <------------------------------------------------------------------------------------------------------------------------> ValidationRequest Execution Success with response : 000 <------------------------------------------------------------------------------------------------------------------------> 01-06-2026 03:32:24:ShowCBSAcNo(). Log: TranProcess.cs: ShowCBSAcNo() Query: SELECT SUBSTR ('001030001102', 0, brlength) branch, SUBSTR ('001030001102', brlength+1, schlength) linksno, SUBSTR ('001030001102', -aclength) acno FROM (SELECT a.sitp_doublevalue AS iinlenth, a.sitp_longvalue AS iin, b.sitp_doublevalue AS brlength, c.sitp_doublevalue AS schlength, d.sitp_doublevalue AS aclength FROM (SELECT 1 sno, sitp_doublevalue, sitp_longvalue FROM head.siteparameters WHERE sitp_name = 'IIN NUMBER') a, (SELECT 1 sno, sitp_doublevalue FROM head.siteparameters WHERE sitp_name = 'BRANCH CODE') b, (SELECT 1 sno, sitp_doublevalue FROM head.siteparameters WHERE sitp_name = 'SCHEME CODE') c, (SELECT 1 sno, sitp_doublevalue FROM head.siteparameters WHERE sitp_name = 'ACCOUNT NO') d WHERE a.sno = b.sno AND c.sno = a.sno AND d.sno = a.sno) TranProcess.cs: Fetch Query Row Count dtSplitCBSNo: 1 TranProcess.cs: Linkmain Query SELECT link_type, link_abbrev, bran_name, bran_sno FROM linkmain, MASTER.branch WHERE link_sno = 030 AND bran_sno = 001 TranProcess.cs: Linkmain Query Row Count dtTemp: 1 ShowCBS Ac No Proce Executed HEAD OFFICE|OD|001102|CHL|1 01-06-2026 03:32:24:Validation Account Proce Executed with out error <------------------------------------------------------------------------------------------------------------------------> ValidateAcNo CBS A/C No : 001030001102 ValidationAcNo.cs: Query TO Fetch() SELECT clms_des, clms_sno, NVL (odmt_closedyn, 'N') AS closedyn, odmt_closedate, odmt_smsregyn AS smsreg FROM clientmaster, odmaster WHERE clms_sno = odmt_client AND NVL(odmt_closedyn, 'N') = 'N' AND odmt_branch = 1 AND TRIM (odmt_abbr) = 'CHL' AND odmt_no = 001102ValidationAcNo.cs: Closedyn Query Row count1<------------------------------------------------------------------------------------------------------------------------> Y|CHL|001102|1 01-06-2026 03:32:24:TranProcess.cs: Inward_process() UTR ValidationSELECT remit_utr FROM rtgsinwardrequest WHERE Trim(remit_utr) = 'AXNPM15209993005' TranProcess.cs: Inward_process() UTR Validation0 TranProcess.cs: Inward_process(): Insert To rtgsinwardrequest: INSERT INTO rtgsinwardrequest (voucherno, voucherdate, trandate, received_datetime, remit_utr, benefi_name, benefi_accno, remit_name, remit_acno, sender_ifsc, benefi_ifsc, amount, file_name) VALUES ( seq_rtgsinward.NEXTVAL,TRUNC(SYSDATE),SYSDATE, SYSDATE, 'AXNPM15209993005','SADHANA G V','001030001102','PAYTM PAYMENTS SERVICES LTD-PAYMENT AGGREGATOR ESCROW A/C', '922020004482533','UTIB0000022','UTIB0SMCBL1',12620,'123')TranProcess.cs: Inward_process(): 001030001102 AXNPM15209993005 Status : 000 01-06-2026 03:32:24:<------------------------------------------------------------------------------------------------------------------------> <-----------------------STARTED CONFIRMATION REQUEST PROCESS FOR THE DETAILS : AXNPM15209993005|001030001102 --------------------------> <------------------------------------------------------------------------------------------------------------------------> ConfirmationReq Execution Success with Status 000 <-----------------------END CONFIRMATION REQUEST PROCESS FOR THE DETAILS : AXNPM15209993005|001030001102 ------------------------------> <------------------------------------------------------------------------------------------------------------------------> 01-06-2026 03:57:01:ShowCBSAcNo(). Log: TranProcess.cs: ShowCBSAcNo() Query: SELECT SUBSTR ('001001000623', 0, brlength) branch, SUBSTR ('001001000623', brlength+1, schlength) linksno, SUBSTR ('001001000623', -aclength) acno FROM (SELECT a.sitp_doublevalue AS iinlenth, a.sitp_longvalue AS iin, b.sitp_doublevalue AS brlength, c.sitp_doublevalue AS schlength, d.sitp_doublevalue AS aclength FROM (SELECT 1 sno, sitp_doublevalue, sitp_longvalue FROM head.siteparameters WHERE sitp_name = 'IIN NUMBER') a, (SELECT 1 sno, sitp_doublevalue FROM head.siteparameters WHERE sitp_name = 'BRANCH CODE') b, (SELECT 1 sno, sitp_doublevalue FROM head.siteparameters WHERE sitp_name = 'SCHEME CODE') c, (SELECT 1 sno, sitp_doublevalue FROM head.siteparameters WHERE sitp_name = 'ACCOUNT NO') d WHERE a.sno = b.sno AND c.sno = a.sno AND d.sno = a.sno) TranProcess.cs: Fetch Query Row Count dtSplitCBSNo: 1 TranProcess.cs: Linkmain Query SELECT link_type, link_abbrev, bran_name, bran_sno FROM linkmain, MASTER.branch WHERE link_sno = 001 AND bran_sno = 001 TranProcess.cs: Linkmain Query Row Count dtTemp: 1 ShowCBS Ac No Proce Executed HEAD OFFICE|DEPOSIT|000623|SB|1 01-06-2026 03:57:01:Validation Account Proce Executed with out error <------------------------------------------------------------------------------------------------------------------------> ValidateAcNo CBS A/C No : 001001000623 ValidationAcNo.cs: Query TO Fetch() SELECT clms_des, clms_sno, NVL (depm_closedyn, 'N') AS closedyn, depm_closedate, depm_smsregyn AS smsreg FROM clientmaster, depositmaster WHERE clms_sno = depm_client AND NVL(depm_closedyn, 'N') = 'N' AND depm_branch = 1 AND TRIM (depm_abbr) = 'SB' AND depm_no = 000623ValidationAcNo.cs: Closedyn Query Row count1<------------------------------------------------------------------------------------------------------------------------> Y|SB|000623|1 01-06-2026 03:57:01:ValidationRequest(): Log:Validation Request DetailsAXNPN15210839543|001001000623 <------------------------Started ValidationRequest CBS A/C No : 001001000623 ------------------------> <------------------------------------------------------------------------------------------------------------------------> ValidationRequest Execution Success with response : 000 <------------------------------------------------------------------------------------------------------------------------> 01-06-2026 04:02:25:ShowCBSAcNo(). Log: TranProcess.cs: ShowCBSAcNo() Query: SELECT SUBSTR ('001001000623', 0, brlength) branch, SUBSTR ('001001000623', brlength+1, schlength) linksno, SUBSTR ('001001000623', -aclength) acno FROM (SELECT a.sitp_doublevalue AS iinlenth, a.sitp_longvalue AS iin, b.sitp_doublevalue AS brlength, c.sitp_doublevalue AS schlength, d.sitp_doublevalue AS aclength FROM (SELECT 1 sno, sitp_doublevalue, sitp_longvalue FROM head.siteparameters WHERE sitp_name = 'IIN NUMBER') a, (SELECT 1 sno, sitp_doublevalue FROM head.siteparameters WHERE sitp_name = 'BRANCH CODE') b, (SELECT 1 sno, sitp_doublevalue FROM head.siteparameters WHERE sitp_name = 'SCHEME CODE') c, (SELECT 1 sno, sitp_doublevalue FROM head.siteparameters WHERE sitp_name = 'ACCOUNT NO') d WHERE a.sno = b.sno AND c.sno = a.sno AND d.sno = a.sno) TranProcess.cs: Fetch Query Row Count dtSplitCBSNo: 1 TranProcess.cs: Linkmain Query SELECT link_type, link_abbrev, bran_name, bran_sno FROM linkmain, MASTER.branch WHERE link_sno = 001 AND bran_sno = 001 TranProcess.cs: Linkmain Query Row Count dtTemp: 1 ShowCBS Ac No Proce Executed HEAD OFFICE|DEPOSIT|000623|SB|1 01-06-2026 04:02:25:Validation Account Proce Executed with out error <------------------------------------------------------------------------------------------------------------------------> ValidateAcNo CBS A/C No : 001001000623 ValidationAcNo.cs: Query TO Fetch() SELECT clms_des, clms_sno, NVL (depm_closedyn, 'N') AS closedyn, depm_closedate, depm_smsregyn AS smsreg FROM clientmaster, depositmaster WHERE clms_sno = depm_client AND NVL(depm_closedyn, 'N') = 'N' AND depm_branch = 1 AND TRIM (depm_abbr) = 'SB' AND depm_no = 000623ValidationAcNo.cs: Closedyn Query Row count1<------------------------------------------------------------------------------------------------------------------------> Y|SB|000623|1 01-06-2026 04:02:25:TranProcess.cs: Inward_process() UTR ValidationSELECT remit_utr FROM rtgsinwardrequest WHERE Trim(remit_utr) = 'AXNPN15210839543' TranProcess.cs: Inward_process() UTR Validation0 TranProcess.cs: Inward_process(): Insert To rtgsinwardrequest: INSERT INTO rtgsinwardrequest (voucherno, voucherdate, trandate, received_datetime, remit_utr, benefi_name, benefi_accno, remit_name, remit_acno, sender_ifsc, benefi_ifsc, amount, file_name) VALUES ( seq_rtgsinward.NEXTVAL,TRUNC(SYSDATE),SYSDATE, SYSDATE, 'AXNPN15210839543','SHIVASHANKAR','001001000623','PHONEPE LIMITED-PAYMENT AGGREGATOR ESCROW ACCOUNT', '922020004688715','UTIB0001506','UTIB0SMCBL1',14763.16,'123')TranProcess.cs: Inward_process(): 001001000623 AXNPN15210839543 Status : 000 01-06-2026 04:02:25:<------------------------------------------------------------------------------------------------------------------------> <-----------------------STARTED CONFIRMATION REQUEST PROCESS FOR THE DETAILS : AXNPN15210839543|001001000623 --------------------------> <------------------------------------------------------------------------------------------------------------------------> ConfirmationReq Execution Success with Status 000 <-----------------------END CONFIRMATION REQUEST PROCESS FOR THE DETAILS : AXNPN15210839543|001001000623 ------------------------------> <------------------------------------------------------------------------------------------------------------------------> 01-06-2026 04:25:16:ShowCBSAcNo(). Log: TranProcess.cs: ShowCBSAcNo() Query: SELECT SUBSTR ('002001000103', 0, brlength) branch, SUBSTR ('002001000103', brlength+1, schlength) linksno, SUBSTR ('002001000103', -aclength) acno FROM (SELECT a.sitp_doublevalue AS iinlenth, a.sitp_longvalue AS iin, b.sitp_doublevalue AS brlength, c.sitp_doublevalue AS schlength, d.sitp_doublevalue AS aclength FROM (SELECT 1 sno, sitp_doublevalue, sitp_longvalue FROM head.siteparameters WHERE sitp_name = 'IIN NUMBER') a, (SELECT 1 sno, sitp_doublevalue FROM head.siteparameters WHERE sitp_name = 'BRANCH CODE') b, (SELECT 1 sno, sitp_doublevalue FROM head.siteparameters WHERE sitp_name = 'SCHEME CODE') c, (SELECT 1 sno, sitp_doublevalue FROM head.siteparameters WHERE sitp_name = 'ACCOUNT NO') d WHERE a.sno = b.sno AND c.sno = a.sno AND d.sno = a.sno) TranProcess.cs: Fetch Query Row Count dtSplitCBSNo: 1 TranProcess.cs: Linkmain Query SELECT link_type, link_abbrev, bran_name, bran_sno FROM linkmain, MASTER.branch WHERE link_sno = 001 AND bran_sno = 002 TranProcess.cs: Linkmain Query Row Count dtTemp: 1 ShowCBS Ac No Proce Executed VINAYAKANAGAR|DEPOSIT|000103|SB|2 01-06-2026 04:25:16:Validation Account Proce Executed with out error <------------------------------------------------------------------------------------------------------------------------> ValidateAcNo CBS A/C No : 002001000103 ValidationAcNo.cs: Query TO Fetch() SELECT clms_des, clms_sno, NVL (depm_closedyn, 'N') AS closedyn, depm_closedate, depm_smsregyn AS smsreg FROM clientmaster, depositmaster WHERE clms_sno = depm_client AND NVL(depm_closedyn, 'N') = 'N' AND depm_branch = 2 AND TRIM (depm_abbr) = 'SB' AND depm_no = 000103ValidationAcNo.cs: Closedyn Query Row count1<------------------------------------------------------------------------------------------------------------------------> Y|SB|000103|2 01-06-2026 04:25:16:ValidationRequest(): Log:Validation Request DetailsAXNPN15211421191|002001000103 <------------------------Started ValidationRequest CBS A/C No : 002001000103 ------------------------> <------------------------------------------------------------------------------------------------------------------------> ValidationRequest Execution Success with response : 000 <------------------------------------------------------------------------------------------------------------------------> 01-06-2026 04:32:25:ShowCBSAcNo(). Log: TranProcess.cs: ShowCBSAcNo() Query: SELECT SUBSTR ('002001000103', 0, brlength) branch, SUBSTR ('002001000103', brlength+1, schlength) linksno, SUBSTR ('002001000103', -aclength) acno FROM (SELECT a.sitp_doublevalue AS iinlenth, a.sitp_longvalue AS iin, b.sitp_doublevalue AS brlength, c.sitp_doublevalue AS schlength, d.sitp_doublevalue AS aclength FROM (SELECT 1 sno, sitp_doublevalue, sitp_longvalue FROM head.siteparameters WHERE sitp_name = 'IIN NUMBER') a, (SELECT 1 sno, sitp_doublevalue FROM head.siteparameters WHERE sitp_name = 'BRANCH CODE') b, (SELECT 1 sno, sitp_doublevalue FROM head.siteparameters WHERE sitp_name = 'SCHEME CODE') c, (SELECT 1 sno, sitp_doublevalue FROM head.siteparameters WHERE sitp_name = 'ACCOUNT NO') d WHERE a.sno = b.sno AND c.sno = a.sno AND d.sno = a.sno) TranProcess.cs: Fetch Query Row Count dtSplitCBSNo: 1 TranProcess.cs: Linkmain Query SELECT link_type, link_abbrev, bran_name, bran_sno FROM linkmain, MASTER.branch WHERE link_sno = 001 AND bran_sno = 002 TranProcess.cs: Linkmain Query Row Count dtTemp: 1 ShowCBS Ac No Proce Executed VINAYAKANAGAR|DEPOSIT|000103|SB|2 01-06-2026 04:32:25:Validation Account Proce Executed with out error <------------------------------------------------------------------------------------------------------------------------> ValidateAcNo CBS A/C No : 002001000103 ValidationAcNo.cs: Query TO Fetch() SELECT clms_des, clms_sno, NVL (depm_closedyn, 'N') AS closedyn, depm_closedate, depm_smsregyn AS smsreg FROM clientmaster, depositmaster WHERE clms_sno = depm_client AND NVL(depm_closedyn, 'N') = 'N' AND depm_branch = 2 AND TRIM (depm_abbr) = 'SB' AND depm_no = 000103ValidationAcNo.cs: Closedyn Query Row count1<------------------------------------------------------------------------------------------------------------------------> Y|SB|000103|2 01-06-2026 04:32:25:TranProcess.cs: Inward_process() UTR ValidationSELECT remit_utr FROM rtgsinwardrequest WHERE Trim(remit_utr) = 'AXNPN15211421191' TranProcess.cs: Inward_process() UTR Validation0 TranProcess.cs: Inward_process(): Insert To rtgsinwardrequest: INSERT INTO rtgsinwardrequest (voucherno, voucherdate, trandate, received_datetime, remit_utr, benefi_name, benefi_accno, remit_name, remit_acno, sender_ifsc, benefi_ifsc, amount, file_name) VALUES ( seq_rtgsinward.NEXTVAL,TRUNC(SYSDATE),SYSDATE, SYSDATE, 'AXNPN15211421191','MOHAN','002001000103','PHONEPE LIMITED-PAYMENT AGGREGATOR ESCROW ACCOUNT', '922020004688715','UTIB0001506','UTIB0SMCBL1',1820,'123')TranProcess.cs: Inward_process(): 002001000103 AXNPN15211421191 Status : 000 01-06-2026 04:32:25:<------------------------------------------------------------------------------------------------------------------------> <-----------------------STARTED CONFIRMATION REQUEST PROCESS FOR THE DETAILS : AXNPN15211421191|002001000103 --------------------------> <------------------------------------------------------------------------------------------------------------------------> ConfirmationReq Execution Success with Status 000 <-----------------------END CONFIRMATION REQUEST PROCESS FOR THE DETAILS : AXNPN15211421191|002001000103 ------------------------------> <------------------------------------------------------------------------------------------------------------------------> 01-06-2026 10:57:45:ShowCBSAcNo(). Log: TranProcess.cs: ShowCBSAcNo() Query: SELECT SUBSTR ('001002000866', 0, brlength) branch, SUBSTR ('001002000866', brlength+1, schlength) linksno, SUBSTR ('001002000866', -aclength) acno FROM (SELECT a.sitp_doublevalue AS iinlenth, a.sitp_longvalue AS iin, b.sitp_doublevalue AS brlength, c.sitp_doublevalue AS schlength, d.sitp_doublevalue AS aclength FROM (SELECT 1 sno, sitp_doublevalue, sitp_longvalue FROM head.siteparameters WHERE sitp_name = 'IIN NUMBER') a, (SELECT 1 sno, sitp_doublevalue FROM head.siteparameters WHERE sitp_name = 'BRANCH CODE') b, (SELECT 1 sno, sitp_doublevalue FROM head.siteparameters WHERE sitp_name = 'SCHEME CODE') c, (SELECT 1 sno, sitp_doublevalue FROM head.siteparameters WHERE sitp_name = 'ACCOUNT NO') d WHERE a.sno = b.sno AND c.sno = a.sno AND d.sno = a.sno) TranProcess.cs: Fetch Query Row Count dtSplitCBSNo: 1 TranProcess.cs: Linkmain Query SELECT link_type, link_abbrev, bran_name, bran_sno FROM linkmain, MASTER.branch WHERE link_sno = 002 AND bran_sno = 001 TranProcess.cs: Linkmain Query Row Count dtTemp: 1 ShowCBS Ac No Proce Executed HEAD OFFICE|DEPOSIT|000866|CA|1 01-06-2026 10:57:45:Validation Account Proce Executed with out error <------------------------------------------------------------------------------------------------------------------------> ValidateAcNo CBS A/C No : 001002000866 ValidationAcNo.cs: Query TO Fetch() SELECT clms_des, clms_sno, NVL (depm_closedyn, 'N') AS closedyn, depm_closedate, depm_smsregyn AS smsreg FROM clientmaster, depositmaster WHERE clms_sno = depm_client AND NVL(depm_closedyn, 'N') = 'N' AND depm_branch = 1 AND TRIM (depm_abbr) = 'CA' AND depm_no = 000866ValidationAcNo.cs: Closedyn Query Row count1<------------------------------------------------------------------------------------------------------------------------> Y|CA|000866|1 01-06-2026 10:57:45:ValidationRequest(): Log:Validation Request DetailsAXODH15212796553|001002000866 <------------------------Started ValidationRequest CBS A/C No : 001002000866 ------------------------> <------------------------------------------------------------------------------------------------------------------------> ValidationRequest Execution Success with response : 000 <------------------------------------------------------------------------------------------------------------------------> 01-06-2026 11:01:35:ShowCBSAcNo(). Log: TranProcess.cs: ShowCBSAcNo() Query: SELECT SUBSTR ('001002001198', 0, brlength) branch, SUBSTR ('001002001198', brlength+1, schlength) linksno, SUBSTR ('001002001198', -aclength) acno FROM (SELECT a.sitp_doublevalue AS iinlenth, a.sitp_longvalue AS iin, b.sitp_doublevalue AS brlength, c.sitp_doublevalue AS schlength, d.sitp_doublevalue AS aclength FROM (SELECT 1 sno, sitp_doublevalue, sitp_longvalue FROM head.siteparameters WHERE sitp_name = 'IIN NUMBER') a, (SELECT 1 sno, sitp_doublevalue FROM head.siteparameters WHERE sitp_name = 'BRANCH CODE') b, (SELECT 1 sno, sitp_doublevalue FROM head.siteparameters WHERE sitp_name = 'SCHEME CODE') c, (SELECT 1 sno, sitp_doublevalue FROM head.siteparameters WHERE sitp_name = 'ACCOUNT NO') d WHERE a.sno = b.sno AND c.sno = a.sno AND d.sno = a.sno) TranProcess.cs: Fetch Query Row Count dtSplitCBSNo: 1 TranProcess.cs: Linkmain Query SELECT link_type, link_abbrev, bran_name, bran_sno FROM linkmain, MASTER.branch WHERE link_sno = 002 AND bran_sno = 001 TranProcess.cs: Linkmain Query Row Count dtTemp: 1 ShowCBS Ac No Proce Executed HEAD OFFICE|DEPOSIT|001198|CA|1 01-06-2026 11:01:35:Validation Account Proce Executed with out error <------------------------------------------------------------------------------------------------------------------------> ValidateAcNo CBS A/C No : 001002001198 ValidationAcNo.cs: Query TO Fetch() SELECT clms_des, clms_sno, NVL (depm_closedyn, 'N') AS closedyn, depm_closedate, depm_smsregyn AS smsreg FROM clientmaster, depositmaster WHERE clms_sno = depm_client AND NVL(depm_closedyn, 'N') = 'N' AND depm_branch = 1 AND TRIM (depm_abbr) = 'CA' AND depm_no = 001198ValidationAcNo.cs: Closedyn Query Row count1<------------------------------------------------------------------------------------------------------------------------> Y|CA|001198|1 01-06-2026 11:01:35:ValidationRequest(): Log:Validation Request DetailsIOBAR82026060100004945|001002001198 <------------------------Started ValidationRequest CBS A/C No : 001002001198 ------------------------> <------------------------------------------------------------------------------------------------------------------------> ValidationRequest Execution Success with response : 000 <------------------------------------------------------------------------------------------------------------------------> 01-06-2026 11:01:44:ShowCBSAcNo(). Log: TranProcess.cs: ShowCBSAcNo() Query: SELECT SUBSTR ('001002001198', 0, brlength) branch, SUBSTR ('001002001198', brlength+1, schlength) linksno, SUBSTR ('001002001198', -aclength) acno FROM (SELECT a.sitp_doublevalue AS iinlenth, a.sitp_longvalue AS iin, b.sitp_doublevalue AS brlength, c.sitp_doublevalue AS schlength, d.sitp_doublevalue AS aclength FROM (SELECT 1 sno, sitp_doublevalue, sitp_longvalue FROM head.siteparameters WHERE sitp_name = 'IIN NUMBER') a, (SELECT 1 sno, sitp_doublevalue FROM head.siteparameters WHERE sitp_name = 'BRANCH CODE') b, (SELECT 1 sno, sitp_doublevalue FROM head.siteparameters WHERE sitp_name = 'SCHEME CODE') c, (SELECT 1 sno, sitp_doublevalue FROM head.siteparameters WHERE sitp_name = 'ACCOUNT NO') d WHERE a.sno = b.sno AND c.sno = a.sno AND d.sno = a.sno) TranProcess.cs: Fetch Query Row Count dtSplitCBSNo: 1 TranProcess.cs: Linkmain Query SELECT link_type, link_abbrev, bran_name, bran_sno FROM linkmain, MASTER.branch WHERE link_sno = 002 AND bran_sno = 001 TranProcess.cs: Linkmain Query Row Count dtTemp: 1 ShowCBS Ac No Proce Executed HEAD OFFICE|DEPOSIT|001198|CA|1 01-06-2026 11:01:44:Validation Account Proce Executed with out error <------------------------------------------------------------------------------------------------------------------------> ValidateAcNo CBS A/C No : 001002001198 ValidationAcNo.cs: Query TO Fetch() SELECT clms_des, clms_sno, NVL (depm_closedyn, 'N') AS closedyn, depm_closedate, depm_smsregyn AS smsreg FROM clientmaster, depositmaster WHERE clms_sno = depm_client AND NVL(depm_closedyn, 'N') = 'N' AND depm_branch = 1 AND TRIM (depm_abbr) = 'CA' AND depm_no = 001198ValidationAcNo.cs: Closedyn Query Row count1<------------------------------------------------------------------------------------------------------------------------> Y|CA|001198|1 01-06-2026 11:01:44:TranProcess.cs: Inward_process() UTR ValidationSELECT remit_utr FROM rtgsinwardrequest WHERE Trim(remit_utr) = 'IOBAR82026060100004945' TranProcess.cs: Inward_process() UTR Validation0 TranProcess.cs: Inward_process(): Insert To rtgsinwardrequest: INSERT INTO rtgsinwardrequest (voucherno, voucherdate, trandate, received_datetime, remit_utr, benefi_name, benefi_accno, remit_name, remit_acno, sender_ifsc, benefi_ifsc, amount, file_name) VALUES ( seq_rtgsinward.NEXTVAL,TRUNC(SYSDATE),SYSDATE, SYSDATE, 'IOBAR82026060100004945','LARTRADERS','001002001198','SRI KULDEVI TRADERS', '370302000000070','IOBA0003703','UTIB0SMCBL1',300580,'123')TranProcess.cs: Inward_process(): 001002001198 IOBAR82026060100004945 Status : 000 01-06-2026 11:01:44:<------------------------------------------------------------------------------------------------------------------------> <-----------------------STARTED CONFIRMATION REQUEST PROCESS FOR THE DETAILS : IOBAR82026060100004945|001002001198 --------------------------> <------------------------------------------------------------------------------------------------------------------------> ConfirmationReq Execution Success with Status 000 <-----------------------END CONFIRMATION REQUEST PROCESS FOR THE DETAILS : IOBAR82026060100004945|001002001198 ------------------------------> <------------------------------------------------------------------------------------------------------------------------> 01-06-2026 11:03:54:ShowCBSAcNo(). Log: TranProcess.cs: ShowCBSAcNo() Query: SELECT SUBSTR ('001002000866', 0, brlength) branch, SUBSTR ('001002000866', brlength+1, schlength) linksno, SUBSTR ('001002000866', -aclength) acno FROM (SELECT a.sitp_doublevalue AS iinlenth, a.sitp_longvalue AS iin, b.sitp_doublevalue AS brlength, c.sitp_doublevalue AS schlength, d.sitp_doublevalue AS aclength FROM (SELECT 1 sno, sitp_doublevalue, sitp_longvalue FROM head.siteparameters WHERE sitp_name = 'IIN NUMBER') a, (SELECT 1 sno, sitp_doublevalue FROM head.siteparameters WHERE sitp_name = 'BRANCH CODE') b, (SELECT 1 sno, sitp_doublevalue FROM head.siteparameters WHERE sitp_name = 'SCHEME CODE') c, (SELECT 1 sno, sitp_doublevalue FROM head.siteparameters WHERE sitp_name = 'ACCOUNT NO') d WHERE a.sno = b.sno AND c.sno = a.sno AND d.sno = a.sno) TranProcess.cs: Fetch Query Row Count dtSplitCBSNo: 1 TranProcess.cs: Linkmain Query SELECT link_type, link_abbrev, bran_name, bran_sno FROM linkmain, MASTER.branch WHERE link_sno = 002 AND bran_sno = 001 TranProcess.cs: Linkmain Query Row Count dtTemp: 1 ShowCBS Ac No Proce Executed HEAD OFFICE|DEPOSIT|000866|CA|1 01-06-2026 11:03:54:Validation Account Proce Executed with out error <------------------------------------------------------------------------------------------------------------------------> ValidateAcNo CBS A/C No : 001002000866 ValidationAcNo.cs: Query TO Fetch() SELECT clms_des, clms_sno, NVL (depm_closedyn, 'N') AS closedyn, depm_closedate, depm_smsregyn AS smsreg FROM clientmaster, depositmaster WHERE clms_sno = depm_client AND NVL(depm_closedyn, 'N') = 'N' AND depm_branch = 1 AND TRIM (depm_abbr) = 'CA' AND depm_no = 000866ValidationAcNo.cs: Closedyn Query Row count1<------------------------------------------------------------------------------------------------------------------------> Y|CA|000866|1 01-06-2026 11:03:54:TranProcess.cs: Inward_process() UTR ValidationSELECT remit_utr FROM rtgsinwardrequest WHERE Trim(remit_utr) = 'AXODH15212796553' TranProcess.cs: Inward_process() UTR Validation0 TranProcess.cs: Inward_process(): Insert To rtgsinwardrequest: INSERT INTO rtgsinwardrequest (voucherno, voucherdate, trandate, received_datetime, remit_utr, benefi_name, benefi_accno, remit_name, remit_acno, sender_ifsc, benefi_ifsc, amount, file_name) VALUES ( seq_rtgsinward.NEXTVAL,TRUNC(SYSDATE),SYSDATE, SYSDATE, 'AXODH15212796553','T B JAYADEVAPPA SONS','001002000866','THIRUMALA TRADERS', '916030018259174','UTIB0001123','UTIB0SMCBL1',652095,'123')TranProcess.cs: Inward_process(): 001002000866 AXODH15212796553 Status : 000 01-06-2026 11:03:54:<------------------------------------------------------------------------------------------------------------------------> <-----------------------STARTED CONFIRMATION REQUEST PROCESS FOR THE DETAILS : AXODH15212796553|001002000866 --------------------------> <------------------------------------------------------------------------------------------------------------------------> ConfirmationReq Execution Success with Status 000 <-----------------------END CONFIRMATION REQUEST PROCESS FOR THE DETAILS : AXODH15212796553|001002000866 ------------------------------> <------------------------------------------------------------------------------------------------------------------------> 01-06-2026 12:13:30:ShowCBSAcNo(). Log: TranProcess.cs: ShowCBSAcNo() Query: SELECT SUBSTR ('001001001782', 0, brlength) branch, SUBSTR ('001001001782', brlength+1, schlength) linksno, SUBSTR ('001001001782', -aclength) acno FROM (SELECT a.sitp_doublevalue AS iinlenth, a.sitp_longvalue AS iin, b.sitp_doublevalue AS brlength, c.sitp_doublevalue AS schlength, d.sitp_doublevalue AS aclength FROM (SELECT 1 sno, sitp_doublevalue, sitp_longvalue FROM head.siteparameters WHERE sitp_name = 'IIN NUMBER') a, (SELECT 1 sno, sitp_doublevalue FROM head.siteparameters WHERE sitp_name = 'BRANCH CODE') b, (SELECT 1 sno, sitp_doublevalue FROM head.siteparameters WHERE sitp_name = 'SCHEME CODE') c, (SELECT 1 sno, sitp_doublevalue FROM head.siteparameters WHERE sitp_name = 'ACCOUNT NO') d WHERE a.sno = b.sno AND c.sno = a.sno AND d.sno = a.sno) TranProcess.cs: Fetch Query Row Count dtSplitCBSNo: 1 TranProcess.cs: Linkmain Query SELECT link_type, link_abbrev, bran_name, bran_sno FROM linkmain, MASTER.branch WHERE link_sno = 001 AND bran_sno = 001 TranProcess.cs: Linkmain Query Row Count dtTemp: 1 ShowCBS Ac No Proce Executed HEAD OFFICE|DEPOSIT|001782|SB|1 01-06-2026 12:13:30:Validation Account Proce Executed with out error <------------------------------------------------------------------------------------------------------------------------> ValidateAcNo CBS A/C No : 001001001782 ValidationAcNo.cs: Query TO Fetch() SELECT clms_des, clms_sno, NVL (depm_closedyn, 'N') AS closedyn, depm_closedate, depm_smsregyn AS smsreg FROM clientmaster, depositmaster WHERE clms_sno = depm_client AND NVL(depm_closedyn, 'N') = 'N' AND depm_branch = 1 AND TRIM (depm_abbr) = 'SB' AND depm_no = 001782ValidationAcNo.cs: Closedyn Query Row count1<------------------------------------------------------------------------------------------------------------------------> Y|SB|001782|1 01-06-2026 12:13:30:ValidationRequest(): Log:Validation Request DetailsSBIN526152334838|001001001782 <------------------------Started ValidationRequest CBS A/C No : 001001001782 ------------------------> <------------------------------------------------------------------------------------------------------------------------> ValidationRequest Execution Success with response : 000 <------------------------------------------------------------------------------------------------------------------------> 01-06-2026 12:33:47:ShowCBSAcNo(). Log: TranProcess.cs: ShowCBSAcNo() Query: SELECT SUBSTR ('001001001782', 0, brlength) branch, SUBSTR ('001001001782', brlength+1, schlength) linksno, SUBSTR ('001001001782', -aclength) acno FROM (SELECT a.sitp_doublevalue AS iinlenth, a.sitp_longvalue AS iin, b.sitp_doublevalue AS brlength, c.sitp_doublevalue AS schlength, d.sitp_doublevalue AS aclength FROM (SELECT 1 sno, sitp_doublevalue, sitp_longvalue FROM head.siteparameters WHERE sitp_name = 'IIN NUMBER') a, (SELECT 1 sno, sitp_doublevalue FROM head.siteparameters WHERE sitp_name = 'BRANCH CODE') b, (SELECT 1 sno, sitp_doublevalue FROM head.siteparameters WHERE sitp_name = 'SCHEME CODE') c, (SELECT 1 sno, sitp_doublevalue FROM head.siteparameters WHERE sitp_name = 'ACCOUNT NO') d WHERE a.sno = b.sno AND c.sno = a.sno AND d.sno = a.sno) TranProcess.cs: Fetch Query Row Count dtSplitCBSNo: 1 TranProcess.cs: Linkmain Query SELECT link_type, link_abbrev, bran_name, bran_sno FROM linkmain, MASTER.branch WHERE link_sno = 001 AND bran_sno = 001 TranProcess.cs: Linkmain Query Row Count dtTemp: 1 ShowCBS Ac No Proce Executed HEAD OFFICE|DEPOSIT|001782|SB|1 01-06-2026 12:33:47:Validation Account Proce Executed with out error <------------------------------------------------------------------------------------------------------------------------> ValidateAcNo CBS A/C No : 001001001782 ValidationAcNo.cs: Query TO Fetch() SELECT clms_des, clms_sno, NVL (depm_closedyn, 'N') AS closedyn, depm_closedate, depm_smsregyn AS smsreg FROM clientmaster, depositmaster WHERE clms_sno = depm_client AND NVL(depm_closedyn, 'N') = 'N' AND depm_branch = 1 AND TRIM (depm_abbr) = 'SB' AND depm_no = 001782ValidationAcNo.cs: Closedyn Query Row count1<------------------------------------------------------------------------------------------------------------------------> Y|SB|001782|1 01-06-2026 12:33:47:TranProcess.cs: Inward_process() UTR ValidationSELECT remit_utr FROM rtgsinwardrequest WHERE Trim(remit_utr) = 'SBIN526152334838' TranProcess.cs: Inward_process() UTR Validation0 TranProcess.cs: Inward_process(): Insert To rtgsinwardrequest: INSERT INTO rtgsinwardrequest (voucherno, voucherdate, trandate, received_datetime, remit_utr, benefi_name, benefi_accno, remit_name, remit_acno, sender_ifsc, benefi_ifsc, amount, file_name) VALUES ( seq_rtgsinward.NEXTVAL,TRUNC(SYSDATE),SYSDATE, SYSDATE, 'SBIN526152334838','Balaji BV','001001001782','BALAJI V', '00000020038542168','SBIN0010508','UTIB0SMCBL1',1000,'123')TranProcess.cs: Inward_process(): 001001001782 SBIN526152334838 Status : 000 01-06-2026 12:33:47:<------------------------------------------------------------------------------------------------------------------------> <-----------------------STARTED CONFIRMATION REQUEST PROCESS FOR THE DETAILS : SBIN526152334838|001001001782 --------------------------> <------------------------------------------------------------------------------------------------------------------------> ConfirmationReq Execution Success with Status 000 <-----------------------END CONFIRMATION REQUEST PROCESS FOR THE DETAILS : SBIN526152334838|001001001782 ------------------------------> <------------------------------------------------------------------------------------------------------------------------> 01-06-2026 13:15:28:ShowCBSAcNo(). Log: TranProcess.cs: ShowCBSAcNo() Query: SELECT SUBSTR ('001002001227', 0, brlength) branch, SUBSTR ('001002001227', brlength+1, schlength) linksno, SUBSTR ('001002001227', -aclength) acno FROM (SELECT a.sitp_doublevalue AS iinlenth, a.sitp_longvalue AS iin, b.sitp_doublevalue AS brlength, c.sitp_doublevalue AS schlength, d.sitp_doublevalue AS aclength FROM (SELECT 1 sno, sitp_doublevalue, sitp_longvalue FROM head.siteparameters WHERE sitp_name = 'IIN NUMBER') a, (SELECT 1 sno, sitp_doublevalue FROM head.siteparameters WHERE sitp_name = 'BRANCH CODE') b, (SELECT 1 sno, sitp_doublevalue FROM head.siteparameters WHERE sitp_name = 'SCHEME CODE') c, (SELECT 1 sno, sitp_doublevalue FROM head.siteparameters WHERE sitp_name = 'ACCOUNT NO') d WHERE a.sno = b.sno AND c.sno = a.sno AND d.sno = a.sno) TranProcess.cs: Fetch Query Row Count dtSplitCBSNo: 1 TranProcess.cs: Linkmain Query SELECT link_type, link_abbrev, bran_name, bran_sno FROM linkmain, MASTER.branch WHERE link_sno = 002 AND bran_sno = 001 TranProcess.cs: Linkmain Query Row Count dtTemp: 1 ShowCBS Ac No Proce Executed HEAD OFFICE|DEPOSIT|001227|CA|1 01-06-2026 13:15:28:Validation Account Proce Executed with out error <------------------------------------------------------------------------------------------------------------------------> ValidateAcNo CBS A/C No : 001002001227 ValidationAcNo.cs: Query TO Fetch() SELECT clms_des, clms_sno, NVL (depm_closedyn, 'N') AS closedyn, depm_closedate, depm_smsregyn AS smsreg FROM clientmaster, depositmaster WHERE clms_sno = depm_client AND NVL(depm_closedyn, 'N') = 'N' AND depm_branch = 1 AND TRIM (depm_abbr) = 'CA' AND depm_no = 001227ValidationAcNo.cs: Closedyn Query Row count1<------------------------------------------------------------------------------------------------------------------------> Y|CA|001227|1 01-06-2026 13:15:28:ValidationRequest(): Log:Validation Request DetailsAXISCN1361014222|001002001227 <------------------------Started ValidationRequest CBS A/C No : 001002001227 ------------------------> <------------------------------------------------------------------------------------------------------------------------> ValidationRequest Execution Success with response : 000 <------------------------------------------------------------------------------------------------------------------------> 01-06-2026 13:22:50:ShowCBSAcNo(). Log: TranProcess.cs: ShowCBSAcNo() Query: SELECT SUBSTR ('002001000098', 0, brlength) branch, SUBSTR ('002001000098', brlength+1, schlength) linksno, SUBSTR ('002001000098', -aclength) acno FROM (SELECT a.sitp_doublevalue AS iinlenth, a.sitp_longvalue AS iin, b.sitp_doublevalue AS brlength, c.sitp_doublevalue AS schlength, d.sitp_doublevalue AS aclength FROM (SELECT 1 sno, sitp_doublevalue, sitp_longvalue FROM head.siteparameters WHERE sitp_name = 'IIN NUMBER') a, (SELECT 1 sno, sitp_doublevalue FROM head.siteparameters WHERE sitp_name = 'BRANCH CODE') b, (SELECT 1 sno, sitp_doublevalue FROM head.siteparameters WHERE sitp_name = 'SCHEME CODE') c, (SELECT 1 sno, sitp_doublevalue FROM head.siteparameters WHERE sitp_name = 'ACCOUNT NO') d WHERE a.sno = b.sno AND c.sno = a.sno AND d.sno = a.sno) TranProcess.cs: Fetch Query Row Count dtSplitCBSNo: 1 TranProcess.cs: Linkmain Query SELECT link_type, link_abbrev, bran_name, bran_sno FROM linkmain, MASTER.branch WHERE link_sno = 001 AND bran_sno = 002 TranProcess.cs: Linkmain Query Row Count dtTemp: 1 ShowCBS Ac No Proce Executed VINAYAKANAGAR|DEPOSIT|000098|SB|2 01-06-2026 13:22:50:Validation Account Proce Executed with out error <------------------------------------------------------------------------------------------------------------------------> ValidateAcNo CBS A/C No : 002001000098 ValidationAcNo.cs: Query TO Fetch() SELECT clms_des, clms_sno, NVL (depm_closedyn, 'N') AS closedyn, depm_closedate, depm_smsregyn AS smsreg FROM clientmaster, depositmaster WHERE clms_sno = depm_client AND NVL(depm_closedyn, 'N') = 'N' AND depm_branch = 2 AND TRIM (depm_abbr) = 'SB' AND depm_no = 000098ValidationAcNo.cs: Closedyn Query Row count1<------------------------------------------------------------------------------------------------------------------------> Y|SB|000098|2 01-06-2026 13:22:50:ValidationRequest(): Log:Validation Request DetailsHDFCH01029883147|002001000098 <------------------------Started ValidationRequest CBS A/C No : 002001000098 ------------------------> <------------------------------------------------------------------------------------------------------------------------> ValidationRequest Execution Success with response : 000 <------------------------------------------------------------------------------------------------------------------------> 01-06-2026 13:33:39:ShowCBSAcNo(). Log: TranProcess.cs: ShowCBSAcNo() Query: SELECT SUBSTR ('001002001227', 0, brlength) branch, SUBSTR ('001002001227', brlength+1, schlength) linksno, SUBSTR ('001002001227', -aclength) acno FROM (SELECT a.sitp_doublevalue AS iinlenth, a.sitp_longvalue AS iin, b.sitp_doublevalue AS brlength, c.sitp_doublevalue AS schlength, d.sitp_doublevalue AS aclength FROM (SELECT 1 sno, sitp_doublevalue, sitp_longvalue FROM head.siteparameters WHERE sitp_name = 'IIN NUMBER') a, (SELECT 1 sno, sitp_doublevalue FROM head.siteparameters WHERE sitp_name = 'BRANCH CODE') b, (SELECT 1 sno, sitp_doublevalue FROM head.siteparameters WHERE sitp_name = 'SCHEME CODE') c, (SELECT 1 sno, sitp_doublevalue FROM head.siteparameters WHERE sitp_name = 'ACCOUNT NO') d WHERE a.sno = b.sno AND c.sno = a.sno AND d.sno = a.sno) TranProcess.cs: Fetch Query Row Count dtSplitCBSNo: 1 TranProcess.cs: Linkmain Query SELECT link_type, link_abbrev, bran_name, bran_sno FROM linkmain, MASTER.branch WHERE link_sno = 002 AND bran_sno = 001 TranProcess.cs: Linkmain Query Row Count dtTemp: 1 ShowCBS Ac No Proce Executed HEAD OFFICE|DEPOSIT|001227|CA|1 01-06-2026 13:33:39:Validation Account Proce Executed with out error <------------------------------------------------------------------------------------------------------------------------> ValidateAcNo CBS A/C No : 001002001227 ValidationAcNo.cs: Query TO Fetch() SELECT clms_des, clms_sno, NVL (depm_closedyn, 'N') AS closedyn, depm_closedate, depm_smsregyn AS smsreg FROM clientmaster, depositmaster WHERE clms_sno = depm_client AND NVL(depm_closedyn, 'N') = 'N' AND depm_branch = 1 AND TRIM (depm_abbr) = 'CA' AND depm_no = 001227ValidationAcNo.cs: Closedyn Query Row count1<------------------------------------------------------------------------------------------------------------------------> Y|CA|001227|1 01-06-2026 13:33:39:TranProcess.cs: Inward_process() UTR ValidationSELECT remit_utr FROM rtgsinwardrequest WHERE Trim(remit_utr) = 'AXISCN1361014222' TranProcess.cs: Inward_process() UTR Validation0 TranProcess.cs: Inward_process(): Insert To rtgsinwardrequest: INSERT INTO rtgsinwardrequest (voucherno, voucherdate, trandate, received_datetime, remit_utr, benefi_name, benefi_accno, remit_name, remit_acno, sender_ifsc, benefi_ifsc, amount, file_name) VALUES ( seq_rtgsinward.NEXTVAL,TRUNC(SYSDATE),SYSDATE, SYSDATE, 'AXISCN1361014222','EXIM AND CO','001002001227','RAZORPAY PAYMENTS PVT LTD PAYMENT AGGREGATOR ESCROW ACCOUNT.', '917020041206002','UTIB0001506','UTIB0SMCBL1',97.64,'123')TranProcess.cs: Inward_process(): 001002001227 AXISCN1361014222 Status : 000 01-06-2026 13:33:39:<------------------------------------------------------------------------------------------------------------------------> <-----------------------STARTED CONFIRMATION REQUEST PROCESS FOR THE DETAILS : AXISCN1361014222|001002001227 --------------------------> <------------------------------------------------------------------------------------------------------------------------> ConfirmationReq Execution Success with Status 000 <-----------------------END CONFIRMATION REQUEST PROCESS FOR THE DETAILS : AXISCN1361014222|001002001227 ------------------------------> <------------------------------------------------------------------------------------------------------------------------> 01-06-2026 13:34:26:ShowCBSAcNo(). Log: TranProcess.cs: ShowCBSAcNo() Query: SELECT SUBSTR ('002001000098', 0, brlength) branch, SUBSTR ('002001000098', brlength+1, schlength) linksno, SUBSTR ('002001000098', -aclength) acno FROM (SELECT a.sitp_doublevalue AS iinlenth, a.sitp_longvalue AS iin, b.sitp_doublevalue AS brlength, c.sitp_doublevalue AS schlength, d.sitp_doublevalue AS aclength FROM (SELECT 1 sno, sitp_doublevalue, sitp_longvalue FROM head.siteparameters WHERE sitp_name = 'IIN NUMBER') a, (SELECT 1 sno, sitp_doublevalue FROM head.siteparameters WHERE sitp_name = 'BRANCH CODE') b, (SELECT 1 sno, sitp_doublevalue FROM head.siteparameters WHERE sitp_name = 'SCHEME CODE') c, (SELECT 1 sno, sitp_doublevalue FROM head.siteparameters WHERE sitp_name = 'ACCOUNT NO') d WHERE a.sno = b.sno AND c.sno = a.sno AND d.sno = a.sno) TranProcess.cs: Fetch Query Row Count dtSplitCBSNo: 1 TranProcess.cs: Linkmain Query SELECT link_type, link_abbrev, bran_name, bran_sno FROM linkmain, MASTER.branch WHERE link_sno = 001 AND bran_sno = 002 TranProcess.cs: Linkmain Query Row Count dtTemp: 1 ShowCBS Ac No Proce Executed VINAYAKANAGAR|DEPOSIT|000098|SB|2 01-06-2026 13:34:26:Validation Account Proce Executed with out error <------------------------------------------------------------------------------------------------------------------------> ValidateAcNo CBS A/C No : 002001000098 ValidationAcNo.cs: Query TO Fetch() SELECT clms_des, clms_sno, NVL (depm_closedyn, 'N') AS closedyn, depm_closedate, depm_smsregyn AS smsreg FROM clientmaster, depositmaster WHERE clms_sno = depm_client AND NVL(depm_closedyn, 'N') = 'N' AND depm_branch = 2 AND TRIM (depm_abbr) = 'SB' AND depm_no = 000098ValidationAcNo.cs: Closedyn Query Row count1<------------------------------------------------------------------------------------------------------------------------> Y|SB|000098|2 01-06-2026 13:34:26:TranProcess.cs: Inward_process() UTR ValidationSELECT remit_utr FROM rtgsinwardrequest WHERE Trim(remit_utr) = 'HDFCH01029883147' TranProcess.cs: Inward_process() UTR Validation0 TranProcess.cs: Inward_process(): Insert To rtgsinwardrequest: INSERT INTO rtgsinwardrequest (voucherno, voucherdate, trandate, received_datetime, remit_utr, benefi_name, benefi_accno, remit_name, remit_acno, sender_ifsc, benefi_ifsc, amount, file_name) VALUES ( seq_rtgsinward.NEXTVAL,TRUNC(SYSDATE),SYSDATE, SYSDATE, 'HDFCH01029883147','DEEPIKA T N','002001000098','PRASAD SHETTY AND CO', '50200049391500','HDFC0000001','UTIB0SMCBL1',14000,'123')TranProcess.cs: Inward_process(): 002001000098 HDFCH01029883147 Status : 000 01-06-2026 13:34:26:<------------------------------------------------------------------------------------------------------------------------> <-----------------------STARTED CONFIRMATION REQUEST PROCESS FOR THE DETAILS : HDFCH01029883147|002001000098 --------------------------> <------------------------------------------------------------------------------------------------------------------------> ConfirmationReq Execution Success with Status 000 <-----------------------END CONFIRMATION REQUEST PROCESS FOR THE DETAILS : HDFCH01029883147|002001000098 ------------------------------> <------------------------------------------------------------------------------------------------------------------------> 01-06-2026 13:49:06:ShowCBSAcNo(). Log: TranProcess.cs: ShowCBSAcNo() Query: SELECT SUBSTR ('001001002639', 0, brlength) branch, SUBSTR ('001001002639', brlength+1, schlength) linksno, SUBSTR ('001001002639', -aclength) acno FROM (SELECT a.sitp_doublevalue AS iinlenth, a.sitp_longvalue AS iin, b.sitp_doublevalue AS brlength, c.sitp_doublevalue AS schlength, d.sitp_doublevalue AS aclength FROM (SELECT 1 sno, sitp_doublevalue, sitp_longvalue FROM head.siteparameters WHERE sitp_name = 'IIN NUMBER') a, (SELECT 1 sno, sitp_doublevalue FROM head.siteparameters WHERE sitp_name = 'BRANCH CODE') b, (SELECT 1 sno, sitp_doublevalue FROM head.siteparameters WHERE sitp_name = 'SCHEME CODE') c, (SELECT 1 sno, sitp_doublevalue FROM head.siteparameters WHERE sitp_name = 'ACCOUNT NO') d WHERE a.sno = b.sno AND c.sno = a.sno AND d.sno = a.sno) TranProcess.cs: Fetch Query Row Count dtSplitCBSNo: 1 TranProcess.cs: Linkmain Query SELECT link_type, link_abbrev, bran_name, bran_sno FROM linkmain, MASTER.branch WHERE link_sno = 001 AND bran_sno = 001 TranProcess.cs: Linkmain Query Row Count dtTemp: 1 ShowCBS Ac No Proce Executed HEAD OFFICE|DEPOSIT|002639|SB|1 01-06-2026 13:49:06:Validation Account Proce Executed with out error <------------------------------------------------------------------------------------------------------------------------> ValidateAcNo CBS A/C No : 001001002639 ValidationAcNo.cs: Query TO Fetch() SELECT clms_des, clms_sno, NVL (depm_closedyn, 'N') AS closedyn, depm_closedate, depm_smsregyn AS smsreg FROM clientmaster, depositmaster WHERE clms_sno = depm_client AND NVL(depm_closedyn, 'N') = 'N' AND depm_branch = 1 AND TRIM (depm_abbr) = 'SB' AND depm_no = 002639ValidationAcNo.cs: Closedyn Query Row count1<------------------------------------------------------------------------------------------------------------------------> Y|SB|002639|1 01-06-2026 13:49:06:ValidationRequest(): Log:Validation Request DetailsHDFCH01029976672|001001002639 <------------------------Started ValidationRequest CBS A/C No : 001001002639 ------------------------> <------------------------------------------------------------------------------------------------------------------------> ValidationRequest Execution Success with response : 000 <------------------------------------------------------------------------------------------------------------------------> 01-06-2026 14:04:47:ShowCBSAcNo(). Log: TranProcess.cs: ShowCBSAcNo() Query: SELECT SUBSTR ('001001002639', 0, brlength) branch, SUBSTR ('001001002639', brlength+1, schlength) linksno, SUBSTR ('001001002639', -aclength) acno FROM (SELECT a.sitp_doublevalue AS iinlenth, a.sitp_longvalue AS iin, b.sitp_doublevalue AS brlength, c.sitp_doublevalue AS schlength, d.sitp_doublevalue AS aclength FROM (SELECT 1 sno, sitp_doublevalue, sitp_longvalue FROM head.siteparameters WHERE sitp_name = 'IIN NUMBER') a, (SELECT 1 sno, sitp_doublevalue FROM head.siteparameters WHERE sitp_name = 'BRANCH CODE') b, (SELECT 1 sno, sitp_doublevalue FROM head.siteparameters WHERE sitp_name = 'SCHEME CODE') c, (SELECT 1 sno, sitp_doublevalue FROM head.siteparameters WHERE sitp_name = 'ACCOUNT NO') d WHERE a.sno = b.sno AND c.sno = a.sno AND d.sno = a.sno) TranProcess.cs: Fetch Query Row Count dtSplitCBSNo: 1 TranProcess.cs: Linkmain Query SELECT link_type, link_abbrev, bran_name, bran_sno FROM linkmain, MASTER.branch WHERE link_sno = 001 AND bran_sno = 001 TranProcess.cs: Linkmain Query Row Count dtTemp: 1 ShowCBS Ac No Proce Executed HEAD OFFICE|DEPOSIT|002639|SB|1 01-06-2026 14:04:47:Validation Account Proce Executed with out error <------------------------------------------------------------------------------------------------------------------------> ValidateAcNo CBS A/C No : 001001002639 ValidationAcNo.cs: Query TO Fetch() SELECT clms_des, clms_sno, NVL (depm_closedyn, 'N') AS closedyn, depm_closedate, depm_smsregyn AS smsreg FROM clientmaster, depositmaster WHERE clms_sno = depm_client AND NVL(depm_closedyn, 'N') = 'N' AND depm_branch = 1 AND TRIM (depm_abbr) = 'SB' AND depm_no = 002639ValidationAcNo.cs: Closedyn Query Row count1<------------------------------------------------------------------------------------------------------------------------> Y|SB|002639|1 01-06-2026 14:04:47:TranProcess.cs: Inward_process() UTR ValidationSELECT remit_utr FROM rtgsinwardrequest WHERE Trim(remit_utr) = 'HDFCH01029976672' TranProcess.cs: Inward_process() UTR Validation0 TranProcess.cs: Inward_process(): Insert To rtgsinwardrequest: INSERT INTO rtgsinwardrequest (voucherno, voucherdate, trandate, received_datetime, remit_utr, benefi_name, benefi_accno, remit_name, remit_acno, sender_ifsc, benefi_ifsc, amount, file_name) VALUES ( seq_rtgsinward.NEXTVAL,TRUNC(SYSDATE),SYSDATE, SYSDATE, 'HDFCH01029976672','Ramegowda DS','001001002639','GURUPRASAD C S', '23991000001582','HDFC0000001','UTIB0SMCBL1',8000,'123')TranProcess.cs: Inward_process(): 001001002639 HDFCH01029976672 Status : 000 01-06-2026 14:04:47:<------------------------------------------------------------------------------------------------------------------------> <-----------------------STARTED CONFIRMATION REQUEST PROCESS FOR THE DETAILS : HDFCH01029976672|001001002639 --------------------------> <------------------------------------------------------------------------------------------------------------------------> ConfirmationReq Execution Success with Status 000 <-----------------------END CONFIRMATION REQUEST PROCESS FOR THE DETAILS : HDFCH01029976672|001001002639 ------------------------------> <------------------------------------------------------------------------------------------------------------------------> 01-06-2026 14:55:38:ShowCBSAcNo(). Log: TranProcess.cs: ShowCBSAcNo() Query: SELECT SUBSTR ('001030001022', 0, brlength) branch, SUBSTR ('001030001022', brlength+1, schlength) linksno, SUBSTR ('001030001022', -aclength) acno FROM (SELECT a.sitp_doublevalue AS iinlenth, a.sitp_longvalue AS iin, b.sitp_doublevalue AS brlength, c.sitp_doublevalue AS schlength, d.sitp_doublevalue AS aclength FROM (SELECT 1 sno, sitp_doublevalue, sitp_longvalue FROM head.siteparameters WHERE sitp_name = 'IIN NUMBER') a, (SELECT 1 sno, sitp_doublevalue FROM head.siteparameters WHERE sitp_name = 'BRANCH CODE') b, (SELECT 1 sno, sitp_doublevalue FROM head.siteparameters WHERE sitp_name = 'SCHEME CODE') c, (SELECT 1 sno, sitp_doublevalue FROM head.siteparameters WHERE sitp_name = 'ACCOUNT NO') d WHERE a.sno = b.sno AND c.sno = a.sno AND d.sno = a.sno) TranProcess.cs: Fetch Query Row Count dtSplitCBSNo: 1 TranProcess.cs: Linkmain Query SELECT link_type, link_abbrev, bran_name, bran_sno FROM linkmain, MASTER.branch WHERE link_sno = 030 AND bran_sno = 001 TranProcess.cs: Linkmain Query Row Count dtTemp: 1 ShowCBS Ac No Proce Executed HEAD OFFICE|OD|001022|CHL|1 01-06-2026 14:55:38:Validation Account Proce Executed with out error <------------------------------------------------------------------------------------------------------------------------> ValidateAcNo CBS A/C No : 001030001022 ValidationAcNo.cs: Query TO Fetch() SELECT clms_des, clms_sno, NVL (odmt_closedyn, 'N') AS closedyn, odmt_closedate, odmt_smsregyn AS smsreg FROM clientmaster, odmaster WHERE clms_sno = odmt_client AND NVL(odmt_closedyn, 'N') = 'N' AND odmt_branch = 1 AND TRIM (odmt_abbr) = 'CHL' AND odmt_no = 001022ValidationAcNo.cs: Closedyn Query Row count1<------------------------------------------------------------------------------------------------------------------------> Y|CHL|001022|1 01-06-2026 14:55:38:ValidationRequest(): Log:Validation Request DetailsKKBKH26152733550|001030001022 <------------------------Started ValidationRequest CBS A/C No : 001030001022 ------------------------> <------------------------------------------------------------------------------------------------------------------------> ValidationRequest Execution Success with response : 000 <------------------------------------------------------------------------------------------------------------------------> 01-06-2026 15:06:38:ShowCBSAcNo(). Log: TranProcess.cs: ShowCBSAcNo() Query: SELECT SUBSTR ('001030001022', 0, brlength) branch, SUBSTR ('001030001022', brlength+1, schlength) linksno, SUBSTR ('001030001022', -aclength) acno FROM (SELECT a.sitp_doublevalue AS iinlenth, a.sitp_longvalue AS iin, b.sitp_doublevalue AS brlength, c.sitp_doublevalue AS schlength, d.sitp_doublevalue AS aclength FROM (SELECT 1 sno, sitp_doublevalue, sitp_longvalue FROM head.siteparameters WHERE sitp_name = 'IIN NUMBER') a, (SELECT 1 sno, sitp_doublevalue FROM head.siteparameters WHERE sitp_name = 'BRANCH CODE') b, (SELECT 1 sno, sitp_doublevalue FROM head.siteparameters WHERE sitp_name = 'SCHEME CODE') c, (SELECT 1 sno, sitp_doublevalue FROM head.siteparameters WHERE sitp_name = 'ACCOUNT NO') d WHERE a.sno = b.sno AND c.sno = a.sno AND d.sno = a.sno) TranProcess.cs: Fetch Query Row Count dtSplitCBSNo: 1 TranProcess.cs: Linkmain Query SELECT link_type, link_abbrev, bran_name, bran_sno FROM linkmain, MASTER.branch WHERE link_sno = 030 AND bran_sno = 001 TranProcess.cs: Linkmain Query Row Count dtTemp: 1 ShowCBS Ac No Proce Executed HEAD OFFICE|OD|001022|CHL|1 01-06-2026 15:06:38:Validation Account Proce Executed with out error <------------------------------------------------------------------------------------------------------------------------> ValidateAcNo CBS A/C No : 001030001022 ValidationAcNo.cs: Query TO Fetch() SELECT clms_des, clms_sno, NVL (odmt_closedyn, 'N') AS closedyn, odmt_closedate, odmt_smsregyn AS smsreg FROM clientmaster, odmaster WHERE clms_sno = odmt_client AND NVL(odmt_closedyn, 'N') = 'N' AND odmt_branch = 1 AND TRIM (odmt_abbr) = 'CHL' AND odmt_no = 001022ValidationAcNo.cs: Closedyn Query Row count1<------------------------------------------------------------------------------------------------------------------------> Y|CHL|001022|1 01-06-2026 15:06:38:TranProcess.cs: Inward_process() UTR ValidationSELECT remit_utr FROM rtgsinwardrequest WHERE Trim(remit_utr) = 'KKBKH26152733550' TranProcess.cs: Inward_process() UTR Validation0 TranProcess.cs: Inward_process(): Insert To rtgsinwardrequest: INSERT INTO rtgsinwardrequest (voucherno, voucherdate, trandate, received_datetime, remit_utr, benefi_name, benefi_accno, remit_name, remit_acno, sender_ifsc, benefi_ifsc, amount, file_name) VALUES ( seq_rtgsinward.NEXTVAL,TRUNC(SYSDATE),SYSDATE, SYSDATE, 'KKBKH26152733550','PRAKASH GOUTHAM DAD','001030001022','DILIP KUMAR DR', '6312036744','KKBK0000958','UTIB0SMCBL1',4000,'123')TranProcess.cs: Inward_process(): 001030001022 KKBKH26152733550 Status : 000 01-06-2026 15:06:38:<------------------------------------------------------------------------------------------------------------------------> <-----------------------STARTED CONFIRMATION REQUEST PROCESS FOR THE DETAILS : KKBKH26152733550|001030001022 --------------------------> <------------------------------------------------------------------------------------------------------------------------> ConfirmationReq Execution Success with Status 000 <-----------------------END CONFIRMATION REQUEST PROCESS FOR THE DETAILS : KKBKH26152733550|001030001022 ------------------------------> <------------------------------------------------------------------------------------------------------------------------> 01-06-2026 16:51:55:ShowCBSAcNo(). Log: TranProcess.cs: ShowCBSAcNo() Query: SELECT SUBSTR ('001030001080', 0, brlength) branch, SUBSTR ('001030001080', brlength+1, schlength) linksno, SUBSTR ('001030001080', -aclength) acno FROM (SELECT a.sitp_doublevalue AS iinlenth, a.sitp_longvalue AS iin, b.sitp_doublevalue AS brlength, c.sitp_doublevalue AS schlength, d.sitp_doublevalue AS aclength FROM (SELECT 1 sno, sitp_doublevalue, sitp_longvalue FROM head.siteparameters WHERE sitp_name = 'IIN NUMBER') a, (SELECT 1 sno, sitp_doublevalue FROM head.siteparameters WHERE sitp_name = 'BRANCH CODE') b, (SELECT 1 sno, sitp_doublevalue FROM head.siteparameters WHERE sitp_name = 'SCHEME CODE') c, (SELECT 1 sno, sitp_doublevalue FROM head.siteparameters WHERE sitp_name = 'ACCOUNT NO') d WHERE a.sno = b.sno AND c.sno = a.sno AND d.sno = a.sno) TranProcess.cs: Fetch Query Row Count dtSplitCBSNo: 1 TranProcess.cs: Linkmain Query SELECT link_type, link_abbrev, bran_name, bran_sno FROM linkmain, MASTER.branch WHERE link_sno = 030 AND bran_sno = 001 TranProcess.cs: Linkmain Query Row Count dtTemp: 1 ShowCBS Ac No Proce Executed HEAD OFFICE|OD|001080|CHL|1 01-06-2026 16:51:55:Validation Account Proce Executed with out error <------------------------------------------------------------------------------------------------------------------------> ValidateAcNo CBS A/C No : 001030001080 ValidationAcNo.cs: Query TO Fetch() SELECT clms_des, clms_sno, NVL (odmt_closedyn, 'N') AS closedyn, odmt_closedate, odmt_smsregyn AS smsreg FROM clientmaster, odmaster WHERE clms_sno = odmt_client AND NVL(odmt_closedyn, 'N') = 'N' AND odmt_branch = 1 AND TRIM (odmt_abbr) = 'CHL' AND odmt_no = 001080ValidationAcNo.cs: Closedyn Query Row count1<------------------------------------------------------------------------------------------------------------------------> Y|CHL|001080|1 01-06-2026 16:51:55:ValidationRequest(): Log:Validation Request DetailsAXOMB15202167365|001030001080 <------------------------Started ValidationRequest CBS A/C No : 001030001080 ------------------------> <------------------------------------------------------------------------------------------------------------------------> ValidationRequest Execution Success with response : 000 <------------------------------------------------------------------------------------------------------------------------> 01-06-2026 17:07:16:ShowCBSAcNo(). Log: TranProcess.cs: ShowCBSAcNo() Query: SELECT SUBSTR ('001030001080', 0, brlength) branch, SUBSTR ('001030001080', brlength+1, schlength) linksno, SUBSTR ('001030001080', -aclength) acno FROM (SELECT a.sitp_doublevalue AS iinlenth, a.sitp_longvalue AS iin, b.sitp_doublevalue AS brlength, c.sitp_doublevalue AS schlength, d.sitp_doublevalue AS aclength FROM (SELECT 1 sno, sitp_doublevalue, sitp_longvalue FROM head.siteparameters WHERE sitp_name = 'IIN NUMBER') a, (SELECT 1 sno, sitp_doublevalue FROM head.siteparameters WHERE sitp_name = 'BRANCH CODE') b, (SELECT 1 sno, sitp_doublevalue FROM head.siteparameters WHERE sitp_name = 'SCHEME CODE') c, (SELECT 1 sno, sitp_doublevalue FROM head.siteparameters WHERE sitp_name = 'ACCOUNT NO') d WHERE a.sno = b.sno AND c.sno = a.sno AND d.sno = a.sno) TranProcess.cs: Fetch Query Row Count dtSplitCBSNo: 1 TranProcess.cs: Linkmain Query SELECT link_type, link_abbrev, bran_name, bran_sno FROM linkmain, MASTER.branch WHERE link_sno = 030 AND bran_sno = 001 TranProcess.cs: Linkmain Query Row Count dtTemp: 1 ShowCBS Ac No Proce Executed HEAD OFFICE|OD|001080|CHL|1 01-06-2026 17:07:16:Validation Account Proce Executed with out error <------------------------------------------------------------------------------------------------------------------------> ValidateAcNo CBS A/C No : 001030001080 ValidationAcNo.cs: Query TO Fetch() SELECT clms_des, clms_sno, NVL (odmt_closedyn, 'N') AS closedyn, odmt_closedate, odmt_smsregyn AS smsreg FROM clientmaster, odmaster WHERE clms_sno = odmt_client AND NVL(odmt_closedyn, 'N') = 'N' AND odmt_branch = 1 AND TRIM (odmt_abbr) = 'CHL' AND odmt_no = 001080ValidationAcNo.cs: Closedyn Query Row count1<------------------------------------------------------------------------------------------------------------------------> Y|CHL|001080|1 01-06-2026 17:07:16:TranProcess.cs: Inward_process() UTR ValidationSELECT remit_utr FROM rtgsinwardrequest WHERE Trim(remit_utr) = 'AXOMB15202167365' TranProcess.cs: Inward_process() UTR Validation0 TranProcess.cs: Inward_process(): Insert To rtgsinwardrequest: INSERT INTO rtgsinwardrequest (voucherno, voucherdate, trandate, received_datetime, remit_utr, benefi_name, benefi_accno, remit_name, remit_acno, sender_ifsc, benefi_ifsc, amount, file_name) VALUES ( seq_rtgsinward.NEXTVAL,TRUNC(SYSDATE),SYSDATE, SYSDATE, 'AXOMB15202167365','Ramesh Gs','001030001080','G S RAMESH', '913010011710468','UTIB0001123','UTIB0SMCBL1',100000,'123')TranProcess.cs: Inward_process(): 001030001080 AXOMB15202167365 Status : 000 01-06-2026 17:07:16:<------------------------------------------------------------------------------------------------------------------------> <-----------------------STARTED CONFIRMATION REQUEST PROCESS FOR THE DETAILS : AXOMB15202167365|001030001080 --------------------------> <------------------------------------------------------------------------------------------------------------------------> ConfirmationReq Execution Success with Status 000 <-----------------------END CONFIRMATION REQUEST PROCESS FOR THE DETAILS : AXOMB15202167365|001030001080 ------------------------------> <------------------------------------------------------------------------------------------------------------------------> 01-06-2026 18:33:07:ShowCBSAcNo(). Log: TranProcess.cs: ShowCBSAcNo() Query: SELECT SUBSTR ('001002000369', 0, brlength) branch, SUBSTR ('001002000369', brlength+1, schlength) linksno, SUBSTR ('001002000369', -aclength) acno FROM (SELECT a.sitp_doublevalue AS iinlenth, a.sitp_longvalue AS iin, b.sitp_doublevalue AS brlength, c.sitp_doublevalue AS schlength, d.sitp_doublevalue AS aclength FROM (SELECT 1 sno, sitp_doublevalue, sitp_longvalue FROM head.siteparameters WHERE sitp_name = 'IIN NUMBER') a, (SELECT 1 sno, sitp_doublevalue FROM head.siteparameters WHERE sitp_name = 'BRANCH CODE') b, (SELECT 1 sno, sitp_doublevalue FROM head.siteparameters WHERE sitp_name = 'SCHEME CODE') c, (SELECT 1 sno, sitp_doublevalue FROM head.siteparameters WHERE sitp_name = 'ACCOUNT NO') d WHERE a.sno = b.sno AND c.sno = a.sno AND d.sno = a.sno) TranProcess.cs: Fetch Query Row Count dtSplitCBSNo: 1 TranProcess.cs: Linkmain Query SELECT link_type, link_abbrev, bran_name, bran_sno FROM linkmain, MASTER.branch WHERE link_sno = 002 AND bran_sno = 001 TranProcess.cs: Linkmain Query Row Count dtTemp: 1 ShowCBS Ac No Proce Executed HEAD OFFICE|DEPOSIT|000369|CA|1 01-06-2026 18:33:07:Validation Account Proce Executed with out error <------------------------------------------------------------------------------------------------------------------------> ValidateAcNo CBS A/C No : 001002000369 ValidationAcNo.cs: Query TO Fetch() SELECT clms_des, clms_sno, NVL (depm_closedyn, 'N') AS closedyn, depm_closedate, depm_smsregyn AS smsreg FROM clientmaster, depositmaster WHERE clms_sno = depm_client AND NVL(depm_closedyn, 'N') = 'N' AND depm_branch = 1 AND TRIM (depm_abbr) = 'CA' AND depm_no = 000369ValidationAcNo.cs: Closedyn Query Row count1<------------------------------------------------------------------------------------------------------------------------> Y|CA|000369|1 01-06-2026 18:33:07:ValidationRequest(): Log:Validation Request DetailsKARBN26152287267|001002000369 <------------------------Started ValidationRequest CBS A/C No : 001002000369 ------------------------> <------------------------------------------------------------------------------------------------------------------------> ValidationRequest Execution Success with response : 000 <------------------------------------------------------------------------------------------------------------------------> 01-06-2026 19:03:53:ShowCBSAcNo(). Log: TranProcess.cs: ShowCBSAcNo() Query: SELECT SUBSTR ('001002000369', 0, brlength) branch, SUBSTR ('001002000369', brlength+1, schlength) linksno, SUBSTR ('001002000369', -aclength) acno FROM (SELECT a.sitp_doublevalue AS iinlenth, a.sitp_longvalue AS iin, b.sitp_doublevalue AS brlength, c.sitp_doublevalue AS schlength, d.sitp_doublevalue AS aclength FROM (SELECT 1 sno, sitp_doublevalue, sitp_longvalue FROM head.siteparameters WHERE sitp_name = 'IIN NUMBER') a, (SELECT 1 sno, sitp_doublevalue FROM head.siteparameters WHERE sitp_name = 'BRANCH CODE') b, (SELECT 1 sno, sitp_doublevalue FROM head.siteparameters WHERE sitp_name = 'SCHEME CODE') c, (SELECT 1 sno, sitp_doublevalue FROM head.siteparameters WHERE sitp_name = 'ACCOUNT NO') d WHERE a.sno = b.sno AND c.sno = a.sno AND d.sno = a.sno) TranProcess.cs: Fetch Query Row Count dtSplitCBSNo: 1 TranProcess.cs: Linkmain Query SELECT link_type, link_abbrev, bran_name, bran_sno FROM linkmain, MASTER.branch WHERE link_sno = 002 AND bran_sno = 001 TranProcess.cs: Linkmain Query Row Count dtTemp: 1 ShowCBS Ac No Proce Executed HEAD OFFICE|DEPOSIT|000369|CA|1 01-06-2026 19:03:53:Validation Account Proce Executed with out error <------------------------------------------------------------------------------------------------------------------------> ValidateAcNo CBS A/C No : 001002000369 ValidationAcNo.cs: Query TO Fetch() SELECT clms_des, clms_sno, NVL (depm_closedyn, 'N') AS closedyn, depm_closedate, depm_smsregyn AS smsreg FROM clientmaster, depositmaster WHERE clms_sno = depm_client AND NVL(depm_closedyn, 'N') = 'N' AND depm_branch = 1 AND TRIM (depm_abbr) = 'CA' AND depm_no = 000369ValidationAcNo.cs: Closedyn Query Row count1<------------------------------------------------------------------------------------------------------------------------> Y|CA|000369|1 01-06-2026 19:03:53:TranProcess.cs: Inward_process() UTR ValidationSELECT remit_utr FROM rtgsinwardrequest WHERE Trim(remit_utr) = 'KARBN26152287267' TranProcess.cs: Inward_process() UTR Validation0 TranProcess.cs: Inward_process(): Insert To rtgsinwardrequest: INSERT INTO rtgsinwardrequest (voucherno, voucherdate, trandate, received_datetime, remit_utr, benefi_name, benefi_accno, remit_name, remit_acno, sender_ifsc, benefi_ifsc, amount, file_name) VALUES ( seq_rtgsinward.NEXTVAL,TRUNC(SYSDATE),SYSDATE, SYSDATE, 'KARBN26152287267','SRI VENKATESHWARA DISTRIBUTORS','001002000369','SHIVA DRUG HOUSE', '0533202400000601','KARB0000533','UTIB0SMCBL1',9196,'123')TranProcess.cs: Inward_process(): 001002000369 KARBN26152287267 Status : 000 01-06-2026 19:03:53:<------------------------------------------------------------------------------------------------------------------------> <-----------------------STARTED CONFIRMATION REQUEST PROCESS FOR THE DETAILS : KARBN26152287267|001002000369 --------------------------> <------------------------------------------------------------------------------------------------------------------------> ConfirmationReq Execution Success with Status 000 <-----------------------END CONFIRMATION REQUEST PROCESS FOR THE DETAILS : KARBN26152287267|001002000369 ------------------------------> <------------------------------------------------------------------------------------------------------------------------> 01-06-2026 19:39:57:ShowCBSAcNo(). Log: TranProcess.cs: ShowCBSAcNo() Query: SELECT SUBSTR ('001001003325', 0, brlength) branch, SUBSTR ('001001003325', brlength+1, schlength) linksno, SUBSTR ('001001003325', -aclength) acno FROM (SELECT a.sitp_doublevalue AS iinlenth, a.sitp_longvalue AS iin, b.sitp_doublevalue AS brlength, c.sitp_doublevalue AS schlength, d.sitp_doublevalue AS aclength FROM (SELECT 1 sno, sitp_doublevalue, sitp_longvalue FROM head.siteparameters WHERE sitp_name = 'IIN NUMBER') a, (SELECT 1 sno, sitp_doublevalue FROM head.siteparameters WHERE sitp_name = 'BRANCH CODE') b, (SELECT 1 sno, sitp_doublevalue FROM head.siteparameters WHERE sitp_name = 'SCHEME CODE') c, (SELECT 1 sno, sitp_doublevalue FROM head.siteparameters WHERE sitp_name = 'ACCOUNT NO') d WHERE a.sno = b.sno AND c.sno = a.sno AND d.sno = a.sno) TranProcess.cs: Fetch Query Row Count dtSplitCBSNo: 1 TranProcess.cs: Linkmain Query SELECT link_type, link_abbrev, bran_name, bran_sno FROM linkmain, MASTER.branch WHERE link_sno = 001 AND bran_sno = 001 TranProcess.cs: Linkmain Query Row Count dtTemp: 1 ShowCBS Ac No Proce Executed HEAD OFFICE|DEPOSIT|003325|SB|1 01-06-2026 19:39:57:Validation Account Proce Executed with out error <------------------------------------------------------------------------------------------------------------------------> ValidateAcNo CBS A/C No : 001001003325 ValidationAcNo.cs: Query TO Fetch() SELECT clms_des, clms_sno, NVL (depm_closedyn, 'N') AS closedyn, depm_closedate, depm_smsregyn AS smsreg FROM clientmaster, depositmaster WHERE clms_sno = depm_client AND NVL(depm_closedyn, 'N') = 'N' AND depm_branch = 1 AND TRIM (depm_abbr) = 'SB' AND depm_no = 003325ValidationAcNo.cs: Closedyn Query Row count1<------------------------------------------------------------------------------------------------------------------------> Y|SB|003325|1 01-06-2026 19:39:57:ValidationRequest(): Log:Validation Request DetailsIN12615239964013|001001003325 <------------------------Started ValidationRequest CBS A/C No : 001001003325 ------------------------> <------------------------------------------------------------------------------------------------------------------------> ValidationRequest Execution Success with response : 000 <------------------------------------------------------------------------------------------------------------------------> 01-06-2026 20:02:49:ShowCBSAcNo(). Log: TranProcess.cs: ShowCBSAcNo() Query: SELECT SUBSTR ('001001003325', 0, brlength) branch, SUBSTR ('001001003325', brlength+1, schlength) linksno, SUBSTR ('001001003325', -aclength) acno FROM (SELECT a.sitp_doublevalue AS iinlenth, a.sitp_longvalue AS iin, b.sitp_doublevalue AS brlength, c.sitp_doublevalue AS schlength, d.sitp_doublevalue AS aclength FROM (SELECT 1 sno, sitp_doublevalue, sitp_longvalue FROM head.siteparameters WHERE sitp_name = 'IIN NUMBER') a, (SELECT 1 sno, sitp_doublevalue FROM head.siteparameters WHERE sitp_name = 'BRANCH CODE') b, (SELECT 1 sno, sitp_doublevalue FROM head.siteparameters WHERE sitp_name = 'SCHEME CODE') c, (SELECT 1 sno, sitp_doublevalue FROM head.siteparameters WHERE sitp_name = 'ACCOUNT NO') d WHERE a.sno = b.sno AND c.sno = a.sno AND d.sno = a.sno) TranProcess.cs: Fetch Query Row Count dtSplitCBSNo: 1 TranProcess.cs: Linkmain Query SELECT link_type, link_abbrev, bran_name, bran_sno FROM linkmain, MASTER.branch WHERE link_sno = 001 AND bran_sno = 001 TranProcess.cs: Linkmain Query Row Count dtTemp: 1 ShowCBS Ac No Proce Executed HEAD OFFICE|DEPOSIT|003325|SB|1 01-06-2026 20:02:49:Validation Account Proce Executed with out error <------------------------------------------------------------------------------------------------------------------------> ValidateAcNo CBS A/C No : 001001003325 ValidationAcNo.cs: Query TO Fetch() SELECT clms_des, clms_sno, NVL (depm_closedyn, 'N') AS closedyn, depm_closedate, depm_smsregyn AS smsreg FROM clientmaster, depositmaster WHERE clms_sno = depm_client AND NVL(depm_closedyn, 'N') = 'N' AND depm_branch = 1 AND TRIM (depm_abbr) = 'SB' AND depm_no = 003325ValidationAcNo.cs: Closedyn Query Row count1<------------------------------------------------------------------------------------------------------------------------> Y|SB|003325|1 01-06-2026 20:02:49:TranProcess.cs: Inward_process() UTR ValidationSELECT remit_utr FROM rtgsinwardrequest WHERE Trim(remit_utr) = 'IN12615239964013' TranProcess.cs: Inward_process() UTR Validation0 TranProcess.cs: Inward_process(): Insert To rtgsinwardrequest: INSERT INTO rtgsinwardrequest (voucherno, voucherdate, trandate, received_datetime, remit_utr, benefi_name, benefi_accno, remit_name, remit_acno, sender_ifsc, benefi_ifsc, amount, file_name) VALUES ( seq_rtgsinward.NEXTVAL,TRUNC(SYSDATE),SYSDATE, SYSDATE, 'IN12615239964013','Nagaraju kn','001001003325','K N NAGARAJU', '007801550390','ICIC0SF0002','UTIB0SMCBL1',10000,'123')TranProcess.cs: Inward_process(): 001001003325 IN12615239964013 Status : 000 01-06-2026 20:02:49:<------------------------------------------------------------------------------------------------------------------------> <-----------------------STARTED CONFIRMATION REQUEST PROCESS FOR THE DETAILS : IN12615239964013|001001003325 --------------------------> <------------------------------------------------------------------------------------------------------------------------> ConfirmationReq Execution Success with Status 000 <-----------------------END CONFIRMATION REQUEST PROCESS FOR THE DETAILS : IN12615239964013|001001003325 ------------------------------> <------------------------------------------------------------------------------------------------------------------------> 01-06-2026 20:22:50:ShowCBSAcNo(). Log: TranProcess.cs: ShowCBSAcNo() Query: SELECT SUBSTR ('001030001100', 0, brlength) branch, SUBSTR ('001030001100', brlength+1, schlength) linksno, SUBSTR ('001030001100', -aclength) acno FROM (SELECT a.sitp_doublevalue AS iinlenth, a.sitp_longvalue AS iin, b.sitp_doublevalue AS brlength, c.sitp_doublevalue AS schlength, d.sitp_doublevalue AS aclength FROM (SELECT 1 sno, sitp_doublevalue, sitp_longvalue FROM head.siteparameters WHERE sitp_name = 'IIN NUMBER') a, (SELECT 1 sno, sitp_doublevalue FROM head.siteparameters WHERE sitp_name = 'BRANCH CODE') b, (SELECT 1 sno, sitp_doublevalue FROM head.siteparameters WHERE sitp_name = 'SCHEME CODE') c, (SELECT 1 sno, sitp_doublevalue FROM head.siteparameters WHERE sitp_name = 'ACCOUNT NO') d WHERE a.sno = b.sno AND c.sno = a.sno AND d.sno = a.sno) TranProcess.cs: Fetch Query Row Count dtSplitCBSNo: 1 TranProcess.cs: Linkmain Query SELECT link_type, link_abbrev, bran_name, bran_sno FROM linkmain, MASTER.branch WHERE link_sno = 030 AND bran_sno = 001 TranProcess.cs: Linkmain Query Row Count dtTemp: 1 ShowCBS Ac No Proce Executed HEAD OFFICE|OD|001100|CHL|1 01-06-2026 20:22:50:Validation Account Proce Executed with out error <------------------------------------------------------------------------------------------------------------------------> ValidateAcNo CBS A/C No : 001030001100 ValidationAcNo.cs: Query TO Fetch() SELECT clms_des, clms_sno, NVL (odmt_closedyn, 'N') AS closedyn, odmt_closedate, odmt_smsregyn AS smsreg FROM clientmaster, odmaster WHERE clms_sno = odmt_client AND NVL(odmt_closedyn, 'N') = 'N' AND odmt_branch = 1 AND TRIM (odmt_abbr) = 'CHL' AND odmt_no = 001100ValidationAcNo.cs: Closedyn Query Row count1<------------------------------------------------------------------------------------------------------------------------> Y|CHL|001100|1 01-06-2026 20:22:50:ValidationRequest(): Log:Validation Request DetailsSBINR12026060130051903|001030001100 <------------------------Started ValidationRequest CBS A/C No : 001030001100 ------------------------> <------------------------------------------------------------------------------------------------------------------------> ValidationRequest Execution Success with response : 000 <------------------------------------------------------------------------------------------------------------------------> 01-06-2026 20:22:51:ShowCBSAcNo(). Log: TranProcess.cs: ShowCBSAcNo() Query: SELECT SUBSTR ('001030001100', 0, brlength) branch, SUBSTR ('001030001100', brlength+1, schlength) linksno, SUBSTR ('001030001100', -aclength) acno FROM (SELECT a.sitp_doublevalue AS iinlenth, a.sitp_longvalue AS iin, b.sitp_doublevalue AS brlength, c.sitp_doublevalue AS schlength, d.sitp_doublevalue AS aclength FROM (SELECT 1 sno, sitp_doublevalue, sitp_longvalue FROM head.siteparameters WHERE sitp_name = 'IIN NUMBER') a, (SELECT 1 sno, sitp_doublevalue FROM head.siteparameters WHERE sitp_name = 'BRANCH CODE') b, (SELECT 1 sno, sitp_doublevalue FROM head.siteparameters WHERE sitp_name = 'SCHEME CODE') c, (SELECT 1 sno, sitp_doublevalue FROM head.siteparameters WHERE sitp_name = 'ACCOUNT NO') d WHERE a.sno = b.sno AND c.sno = a.sno AND d.sno = a.sno) TranProcess.cs: Fetch Query Row Count dtSplitCBSNo: 1 TranProcess.cs: Linkmain Query SELECT link_type, link_abbrev, bran_name, bran_sno FROM linkmain, MASTER.branch WHERE link_sno = 030 AND bran_sno = 001 TranProcess.cs: Linkmain Query Row Count dtTemp: 1 ShowCBS Ac No Proce Executed HEAD OFFICE|OD|001100|CHL|1 01-06-2026 20:22:51:Validation Account Proce Executed with out error <------------------------------------------------------------------------------------------------------------------------> ValidateAcNo CBS A/C No : 001030001100 ValidationAcNo.cs: Query TO Fetch() SELECT clms_des, clms_sno, NVL (odmt_closedyn, 'N') AS closedyn, odmt_closedate, odmt_smsregyn AS smsreg FROM clientmaster, odmaster WHERE clms_sno = odmt_client AND NVL(odmt_closedyn, 'N') = 'N' AND odmt_branch = 1 AND TRIM (odmt_abbr) = 'CHL' AND odmt_no = 001100ValidationAcNo.cs: Closedyn Query Row count1<------------------------------------------------------------------------------------------------------------------------> Y|CHL|001100|1 01-06-2026 20:22:51:TranProcess.cs: Inward_process() UTR ValidationSELECT remit_utr FROM rtgsinwardrequest WHERE Trim(remit_utr) = 'SBINR12026060130051903' TranProcess.cs: Inward_process() UTR Validation0 TranProcess.cs: Inward_process(): Insert To rtgsinwardrequest: INSERT INTO rtgsinwardrequest (voucherno, voucherdate, trandate, received_datetime, remit_utr, benefi_name, benefi_accno, remit_name, remit_acno, sender_ifsc, benefi_ifsc, amount, file_name) VALUES ( seq_rtgsinward.NEXTVAL,TRUNC(SYSDATE),SYSDATE, SYSDATE, 'SBINR12026060130051903','SHAKUNTHALA H L','001030001100','VIGNESH MOTORS', '64065079402','SBIN0007500','UTIB0SMCBL1',600000,'123')TranProcess.cs: Inward_process(): 001030001100 SBINR12026060130051903 Status : 000 01-06-2026 20:22:51:<------------------------------------------------------------------------------------------------------------------------> <-----------------------STARTED CONFIRMATION REQUEST PROCESS FOR THE DETAILS : SBINR12026060130051903|001030001100 --------------------------> <------------------------------------------------------------------------------------------------------------------------> ConfirmationReq Execution Success with Status 000 <-----------------------END CONFIRMATION REQUEST PROCESS FOR THE DETAILS : SBINR12026060130051903|001030001100 ------------------------------> <------------------------------------------------------------------------------------------------------------------------>