04-07-2025 01:49:56: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 04-07-2025 01:49:56: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 04-07-2025 01:49:56:ValidationRequest(): Log:Validation Request DetailsAXNPM18504219306|001001001413 <------------------------Started ValidationRequest CBS A/C No : 001001001413 ------------------------> <------------------------------------------------------------------------------------------------------------------------> ValidationRequest Execution Success with response : 000 <------------------------------------------------------------------------------------------------------------------------> 04-07-2025 02:03:00: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 04-07-2025 02:03:00: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 04-07-2025 02:03:00:TranProcess.cs: Inward_process() UTR ValidationSELECT remit_utr FROM rtgsinwardrequest WHERE Trim(remit_utr) = 'AXNPM18504219306' 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, 'AXNPM18504219306','SHAMALA S P','001001001413','ONE 97 COMMUNICATIONS LIMITED ESCROW ACCOUNT _01', '924020007330961','UTIB0000022','UTIB0SMCBL1',200,'123')TranProcess.cs: Inward_process(): 001001001413 AXNPM18504219306 Status : 000 04-07-2025 02:03:00:<------------------------------------------------------------------------------------------------------------------------> <-----------------------STARTED CONFIRMATION REQUEST PROCESS FOR THE DETAILS : AXNPM18504219306|001001001413 --------------------------> <------------------------------------------------------------------------------------------------------------------------> ConfirmationReq Execution Success with Status 000 <-----------------------END CONFIRMATION REQUEST PROCESS FOR THE DETAILS : AXNPM18504219306|001001001413 ------------------------------> <------------------------------------------------------------------------------------------------------------------------> 04-07-2025 03:02:54:ShowCBSAcNo(). Log: TranProcess.cs: ShowCBSAcNo() Query: SELECT SUBSTR ('002001000102', 0, brlength) branch, SUBSTR ('002001000102', brlength+1, schlength) linksno, SUBSTR ('002001000102', -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|000102|SB|2 04-07-2025 03:02:54:Validation Account Proce Executed with out error <------------------------------------------------------------------------------------------------------------------------> ValidateAcNo CBS A/C No : 002001000102 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 = 000102ValidationAcNo.cs: Closedyn Query Row count1<------------------------------------------------------------------------------------------------------------------------> Y|SB|000102|2 04-07-2025 03:02:54:ValidationRequest(): Log:Validation Request DetailsAXNPM18506758693|002001000102 <------------------------Started ValidationRequest CBS A/C No : 002001000102 ------------------------> <------------------------------------------------------------------------------------------------------------------------> ValidationRequest Execution Success with response : 000 <------------------------------------------------------------------------------------------------------------------------> 04-07-2025 03:05:08: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 04-07-2025 03:05:08: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 04-07-2025 03:05:08:ValidationRequest(): Log:Validation Request DetailsAXNPM18506811136|001030001102 <------------------------Started ValidationRequest CBS A/C No : 001030001102 ------------------------> <------------------------------------------------------------------------------------------------------------------------> ValidationRequest Execution Success with response : 000 <------------------------------------------------------------------------------------------------------------------------> 04-07-2025 03:32:02:ShowCBSAcNo(). Log: TranProcess.cs: ShowCBSAcNo() Query: SELECT SUBSTR ('002001000102', 0, brlength) branch, SUBSTR ('002001000102', brlength+1, schlength) linksno, SUBSTR ('002001000102', -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|000102|SB|2 04-07-2025 03:32:02:Validation Account Proce Executed with out error <------------------------------------------------------------------------------------------------------------------------> ValidateAcNo CBS A/C No : 002001000102 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 = 000102ValidationAcNo.cs: Closedyn Query Row count1<------------------------------------------------------------------------------------------------------------------------> Y|SB|000102|2 04-07-2025 03:32:02:TranProcess.cs: Inward_process() UTR ValidationSELECT remit_utr FROM rtgsinwardrequest WHERE Trim(remit_utr) = 'AXNPM18506758693' 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, 'AXNPM18506758693','JAYALAKSHMI','002001000102','ONE 97 COMMUNICATIONS LIMITED ESCROW ACCOUNT _01', '924020007330961','UTIB0000022','UTIB0SMCBL1',400,'123')TranProcess.cs: Inward_process(): 002001000102 AXNPM18506758693 Status : 000 04-07-2025 03:32:02:<------------------------------------------------------------------------------------------------------------------------> <-----------------------STARTED CONFIRMATION REQUEST PROCESS FOR THE DETAILS : AXNPM18506758693|002001000102 --------------------------> <------------------------------------------------------------------------------------------------------------------------> ConfirmationReq Execution Success with Status 000 <-----------------------END CONFIRMATION REQUEST PROCESS FOR THE DETAILS : AXNPM18506758693|002001000102 ------------------------------> <------------------------------------------------------------------------------------------------------------------------> 04-07-2025 03:32: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 04-07-2025 03:32: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 04-07-2025 03:32:04:TranProcess.cs: Inward_process() UTR ValidationSELECT remit_utr FROM rtgsinwardrequest WHERE Trim(remit_utr) = 'AXNPM18506811136' 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, 'AXNPM18506811136','SADHANA G V','001030001102','ONE 97 COMMUNICATIONS LIMITED ESCROW ACCOUNT _01', '924020007330961','UTIB0000022','UTIB0SMCBL1',9900,'123')TranProcess.cs: Inward_process(): 001030001102 AXNPM18506811136 Status : 000 04-07-2025 03:32:04:<------------------------------------------------------------------------------------------------------------------------> <-----------------------STARTED CONFIRMATION REQUEST PROCESS FOR THE DETAILS : AXNPM18506811136|001030001102 --------------------------> <------------------------------------------------------------------------------------------------------------------------> ConfirmationReq Execution Success with Status 000 <-----------------------END CONFIRMATION REQUEST PROCESS FOR THE DETAILS : AXNPM18506811136|001030001102 ------------------------------> <------------------------------------------------------------------------------------------------------------------------> 04-07-2025 03:33:37:ShowCBSAcNo(). Log: TranProcess.cs: ShowCBSAcNo() Query: SELECT SUBSTR ('001001002724', 0, brlength) branch, SUBSTR ('001001002724', brlength+1, schlength) linksno, SUBSTR ('001001002724', -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|002724|SB|1 04-07-2025 03:33:37:Validation Account Proce Executed with out error <------------------------------------------------------------------------------------------------------------------------> ValidateAcNo CBS A/C No : 001001002724 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 = 002724ValidationAcNo.cs: Closedyn Query Row count1<------------------------------------------------------------------------------------------------------------------------> Y|SB|002724|1 04-07-2025 03:33:37:ValidationRequest(): Log:Validation Request DetailsAXNPN18507004990|001001002724 <------------------------Started ValidationRequest CBS A/C No : 001001002724 ------------------------> <------------------------------------------------------------------------------------------------------------------------> ValidationRequest Execution Success with response : 000 <------------------------------------------------------------------------------------------------------------------------> 04-07-2025 03:53:34:ShowCBSAcNo(). Log: TranProcess.cs: ShowCBSAcNo() Query: SELECT SUBSTR ('001001003618', 0, brlength) branch, SUBSTR ('001001003618', brlength+1, schlength) linksno, SUBSTR ('001001003618', -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|003618|SB|1 04-07-2025 03:53:34:Validation Account Proce Executed with out error <------------------------------------------------------------------------------------------------------------------------> ValidateAcNo CBS A/C No : 001001003618 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 = 003618ValidationAcNo.cs: Closedyn Query Row count1<------------------------------------------------------------------------------------------------------------------------> Y|SB|003618|1 04-07-2025 03:53:34:ValidationRequest(): Log:Validation Request DetailsYESPH51851415067|001001003618 <------------------------Started ValidationRequest CBS A/C No : 001001003618 ------------------------> <------------------------------------------------------------------------------------------------------------------------> ValidationRequest Execution Success with response : 000 <------------------------------------------------------------------------------------------------------------------------> 04-07-2025 04:02:09:ShowCBSAcNo(). Log: TranProcess.cs: ShowCBSAcNo() Query: SELECT SUBSTR ('001001002724', 0, brlength) branch, SUBSTR ('001001002724', brlength+1, schlength) linksno, SUBSTR ('001001002724', -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|002724|SB|1 04-07-2025 04:02:09:Validation Account Proce Executed with out error <------------------------------------------------------------------------------------------------------------------------> ValidateAcNo CBS A/C No : 001001002724 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 = 002724ValidationAcNo.cs: Closedyn Query Row count1<------------------------------------------------------------------------------------------------------------------------> Y|SB|002724|1 04-07-2025 04:02:09:TranProcess.cs: Inward_process() UTR ValidationSELECT remit_utr FROM rtgsinwardrequest WHERE Trim(remit_utr) = 'AXNPN18507004990' 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, 'AXNPN18507004990','C RAMACHANDRAIAH','001001002724','PHONEPE PRIVATE LIMITED-PAYMENT AGGREGATOR ESCROW ACCOUNT', '922020004688715','UTIB0001506','UTIB0SMCBL1',2432,'123')TranProcess.cs: Inward_process(): 001001002724 AXNPN18507004990 Status : 000 04-07-2025 04:02:09:<------------------------------------------------------------------------------------------------------------------------> <-----------------------STARTED CONFIRMATION REQUEST PROCESS FOR THE DETAILS : AXNPN18507004990|001001002724 --------------------------> <------------------------------------------------------------------------------------------------------------------------> ConfirmationReq Execution Success with Status 000 <-----------------------END CONFIRMATION REQUEST PROCESS FOR THE DETAILS : AXNPN18507004990|001001002724 ------------------------------> <------------------------------------------------------------------------------------------------------------------------> 04-07-2025 04:02:27:ShowCBSAcNo(). Log: TranProcess.cs: ShowCBSAcNo() Query: SELECT SUBSTR ('001001003618', 0, brlength) branch, SUBSTR ('001001003618', brlength+1, schlength) linksno, SUBSTR ('001001003618', -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|003618|SB|1 04-07-2025 04:02:27:Validation Account Proce Executed with out error <------------------------------------------------------------------------------------------------------------------------> ValidateAcNo CBS A/C No : 001001003618 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 = 003618ValidationAcNo.cs: Closedyn Query Row count1<------------------------------------------------------------------------------------------------------------------------> Y|SB|003618|1 04-07-2025 04:02:27:TranProcess.cs: Inward_process() UTR ValidationSELECT remit_utr FROM rtgsinwardrequest WHERE Trim(remit_utr) = 'YESPH51851415067' 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, 'YESPH51851415067','UMESH M K','001001003618','PHONEPE LIMITED PA E FOR PHONEPE PR', '002261100000025','YESB0000001','UTIB0SMCBL1',2436,'123')TranProcess.cs: Inward_process(): 001001003618 YESPH51851415067 Status : 000 04-07-2025 04:02:27:<------------------------------------------------------------------------------------------------------------------------> <-----------------------STARTED CONFIRMATION REQUEST PROCESS FOR THE DETAILS : YESPH51851415067|001001003618 --------------------------> <------------------------------------------------------------------------------------------------------------------------> ConfirmationReq Execution Success with Status 000 <-----------------------END CONFIRMATION REQUEST PROCESS FOR THE DETAILS : YESPH51851415067|001001003618 ------------------------------> <------------------------------------------------------------------------------------------------------------------------> 04-07-2025 05:10:01:ShowCBSAcNo(). Log: TranProcess.cs: ShowCBSAcNo() Query: SELECT SUBSTR ('001002001216', 0, brlength) branch, SUBSTR ('001002001216', brlength+1, schlength) linksno, SUBSTR ('001002001216', -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|001216|CA|1 04-07-2025 05:10:01:Validation Account Proce Executed with out error <------------------------------------------------------------------------------------------------------------------------> ValidateAcNo CBS A/C No : 001002001216 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 = 001216ValidationAcNo.cs: Closedyn Query Row count1<------------------------------------------------------------------------------------------------------------------------> Y|CA|001216|1 04-07-2025 05:10:01:ValidationRequest(): Log:Validation Request DetailsAXNPN18508364053|001002001216 <------------------------Started ValidationRequest CBS A/C No : 001002001216 ------------------------> <------------------------------------------------------------------------------------------------------------------------> ValidationRequest Execution Success with response : 000 <------------------------------------------------------------------------------------------------------------------------> 04-07-2025 05:32:17:ShowCBSAcNo(). Log: TranProcess.cs: ShowCBSAcNo() Query: SELECT SUBSTR ('001002001216', 0, brlength) branch, SUBSTR ('001002001216', brlength+1, schlength) linksno, SUBSTR ('001002001216', -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|001216|CA|1 04-07-2025 05:32:17:Validation Account Proce Executed with out error <------------------------------------------------------------------------------------------------------------------------> ValidateAcNo CBS A/C No : 001002001216 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 = 001216ValidationAcNo.cs: Closedyn Query Row count1<------------------------------------------------------------------------------------------------------------------------> Y|CA|001216|1 04-07-2025 05:32:17:TranProcess.cs: Inward_process() UTR ValidationSELECT remit_utr FROM rtgsinwardrequest WHERE Trim(remit_utr) = 'AXNPN18508364053' 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, 'AXNPN18508364053','SRI LAKSHMI ADINARAYANASAMY TRADERS','001002001216','PHONEPE PRIVATE LIMITED-PAYMENT AGGREGATOR ESCROW ACCOUNT', '922020004688715','UTIB0001506','UTIB0SMCBL1',2550,'123')TranProcess.cs: Inward_process(): 001002001216 AXNPN18508364053 Status : 000 04-07-2025 05:32:17:<------------------------------------------------------------------------------------------------------------------------> <-----------------------STARTED CONFIRMATION REQUEST PROCESS FOR THE DETAILS : AXNPN18508364053|001002001216 --------------------------> <------------------------------------------------------------------------------------------------------------------------> ConfirmationReq Execution Success with Status 000 <-----------------------END CONFIRMATION REQUEST PROCESS FOR THE DETAILS : AXNPN18508364053|001002001216 ------------------------------> <------------------------------------------------------------------------------------------------------------------------> 04-07-2025 07:41:59:ShowCBSAcNo(). Log: TranProcess.cs: ShowCBSAcNo() Query: SELECT SUBSTR ('001001003005', 0, brlength) branch, SUBSTR ('001001003005', brlength+1, schlength) linksno, SUBSTR ('001001003005', -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|003005|SB|1 04-07-2025 07:41:59:Validation Account Proce Executed with out error <------------------------------------------------------------------------------------------------------------------------> ValidateAcNo CBS A/C No : 001001003005 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 = 003005ValidationAcNo.cs: Closedyn Query Row count1<------------------------------------------------------------------------------------------------------------------------> Y|SB|003005|1 04-07-2025 07:41:59:ValidationRequest(): Log:Validation Request DetailsICIN218537873607|001001003005 <------------------------Started ValidationRequest CBS A/C No : 001001003005 ------------------------> <------------------------------------------------------------------------------------------------------------------------> ValidationRequest Execution Success with response : 000 <------------------------------------------------------------------------------------------------------------------------> 04-07-2025 08:01:50:ShowCBSAcNo(). Log: TranProcess.cs: ShowCBSAcNo() Query: SELECT SUBSTR ('001001003005', 0, brlength) branch, SUBSTR ('001001003005', brlength+1, schlength) linksno, SUBSTR ('001001003005', -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|003005|SB|1 04-07-2025 08:01:50:Validation Account Proce Executed with out error <------------------------------------------------------------------------------------------------------------------------> ValidateAcNo CBS A/C No : 001001003005 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 = 003005ValidationAcNo.cs: Closedyn Query Row count1<------------------------------------------------------------------------------------------------------------------------> Y|SB|003005|1 04-07-2025 08:01:50:TranProcess.cs: Inward_process() UTR ValidationSELECT remit_utr FROM rtgsinwardrequest WHERE Trim(remit_utr) = 'ICIN218537873607' 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, 'ICIN218537873607','D V VIJAYAKUMAR GUPTA HUF','001001003005','VENTURA SECURITIES LTD', '0104SLNEFTPL','ICIC0099999','UTIB0SMCBL1',7.78,'123')TranProcess.cs: Inward_process(): 001001003005 ICIN218537873607 Status : 000 04-07-2025 08:01:50:<------------------------------------------------------------------------------------------------------------------------> <-----------------------STARTED CONFIRMATION REQUEST PROCESS FOR THE DETAILS : ICIN218537873607|001001003005 --------------------------> <------------------------------------------------------------------------------------------------------------------------> ConfirmationReq Execution Success with Status 000 <-----------------------END CONFIRMATION REQUEST PROCESS FOR THE DETAILS : ICIN218537873607|001001003005 ------------------------------> <------------------------------------------------------------------------------------------------------------------------> 04-07-2025 10:41:03:ShowCBSAcNo(). Log: TranProcess.cs: ShowCBSAcNo() Query: SELECT SUBSTR ('001002001217', 0, brlength) branch, SUBSTR ('001002001217', brlength+1, schlength) linksno, SUBSTR ('001002001217', -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|001217|CA|1 04-07-2025 10:41:03:Validation Account Proce Executed with out error <------------------------------------------------------------------------------------------------------------------------> ValidateAcNo CBS A/C No : 001002001217 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 = 001217ValidationAcNo.cs: Closedyn Query Row count1<------------------------------------------------------------------------------------------------------------------------> Y|CA|001217|1 04-07-2025 10:41:03:ValidationRequest(): Log:Validation Request Details0704i29396319081|001002001217 <------------------------Started ValidationRequest CBS A/C No : 001002001217 ------------------------> <------------------------------------------------------------------------------------------------------------------------> ValidationRequest Execution Success with response : 000 <------------------------------------------------------------------------------------------------------------------------> 04-07-2025 11:02:15:ShowCBSAcNo(). Log: TranProcess.cs: ShowCBSAcNo() Query: SELECT SUBSTR ('001002001217', 0, brlength) branch, SUBSTR ('001002001217', brlength+1, schlength) linksno, SUBSTR ('001002001217', -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|001217|CA|1 04-07-2025 11:02:15:Validation Account Proce Executed with out error <------------------------------------------------------------------------------------------------------------------------> ValidateAcNo CBS A/C No : 001002001217 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 = 001217ValidationAcNo.cs: Closedyn Query Row count1<------------------------------------------------------------------------------------------------------------------------> Y|CA|001217|1 04-07-2025 11:02:15:TranProcess.cs: Inward_process() UTR ValidationSELECT remit_utr FROM rtgsinwardrequest WHERE Trim(remit_utr) = '0704i29396319081' 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, '0704i29396319081','DIYA ENTERPRISES','001002001217','ESHWAR', '1938102000004459','IBKL0NEFT01','UTIB0SMCBL1',30000,'123')TranProcess.cs: Inward_process(): 001002001217 0704i29396319081 Status : 000 04-07-2025 11:02:15:<------------------------------------------------------------------------------------------------------------------------> <-----------------------STARTED CONFIRMATION REQUEST PROCESS FOR THE DETAILS : 0704i29396319081|001002001217 --------------------------> <------------------------------------------------------------------------------------------------------------------------> ConfirmationReq Execution Success with Status 000 <-----------------------END CONFIRMATION REQUEST PROCESS FOR THE DETAILS : 0704i29396319081|001002001217 ------------------------------> <------------------------------------------------------------------------------------------------------------------------> 04-07-2025 11:57:56:ShowCBSAcNo(). Log: TranProcess.cs: ShowCBSAcNo() Query: SELECT SUBSTR ('001002000202', 0, brlength) branch, SUBSTR ('001002000202', brlength+1, schlength) linksno, SUBSTR ('001002000202', -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|000202|CA|1 04-07-2025 11:57:56:Validation Account Proce Executed with out error <------------------------------------------------------------------------------------------------------------------------> ValidateAcNo CBS A/C No : 001002000202 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 = 000202ValidationAcNo.cs: Closedyn Query Row count1<------------------------------------------------------------------------------------------------------------------------> Y|CA|000202|1 04-07-2025 11:57:56:ValidationRequest(): Log:Validation Request DetailsHDFCH00339918281|001002000202 <------------------------Started ValidationRequest CBS A/C No : 001002000202 ------------------------> <------------------------------------------------------------------------------------------------------------------------> ValidationRequest Execution Success with response : 000 <------------------------------------------------------------------------------------------------------------------------> 04-07-2025 12:03:37:ShowCBSAcNo(). Log: TranProcess.cs: ShowCBSAcNo() Query: SELECT SUBSTR ('001002000202', 0, brlength) branch, SUBSTR ('001002000202', brlength+1, schlength) linksno, SUBSTR ('001002000202', -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|000202|CA|1 04-07-2025 12:03:37:Validation Account Proce Executed with out error <------------------------------------------------------------------------------------------------------------------------> ValidateAcNo CBS A/C No : 001002000202 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 = 000202ValidationAcNo.cs: Closedyn Query Row count1<------------------------------------------------------------------------------------------------------------------------> Y|CA|000202|1 04-07-2025 12:03:38:TranProcess.cs: Inward_process() UTR ValidationSELECT remit_utr FROM rtgsinwardrequest WHERE Trim(remit_utr) = 'HDFCH00339918281' 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, 'HDFCH00339918281','Arya vysya mandali','001002000202','SRI SRINIVASA VARIETY CENTRE', '50200084255940','HDFC0000001','UTIB0SMCBL1',13965,'123')TranProcess.cs: Inward_process(): 001002000202 HDFCH00339918281 Status : 000 04-07-2025 12:03:38:<------------------------------------------------------------------------------------------------------------------------> <-----------------------STARTED CONFIRMATION REQUEST PROCESS FOR THE DETAILS : HDFCH00339918281|001002000202 --------------------------> <------------------------------------------------------------------------------------------------------------------------> ConfirmationReq Execution Success with Status 000 <-----------------------END CONFIRMATION REQUEST PROCESS FOR THE DETAILS : HDFCH00339918281|001002000202 ------------------------------> <------------------------------------------------------------------------------------------------------------------------> 04-07-2025 12:57:53:<------------------------------------------------------------------------------------------------------------------------> <-----------------------STARTED CONFIRMATION REQUEST PROCESS FOR THE DETAILS : 010405000010|10305100002333 --------------------------> <------------------------------------------------------------------------------------------------------------------------> ConfirmationReq Execution Success with Status 111 <-----------------------END CONFIRMATION REQUEST PROCESS FOR THE DETAILS : 010405000010|10305100002333 ------------------------------> <------------------------------------------------------------------------------------------------------------------------> 04-07-2025 12:57:53:<------------------------------------------------------------------------------------------------------------------------> <-----------------------STARTED CONFIRMATION REQUEST PROCESS FOR THE DETAILS : 010405000010|10305100002333 --------------------------> <------------------------------------------------------------------------------------------------------------------------> ConfirmationReq Execution Success with Status 111 <-----------------------END CONFIRMATION REQUEST PROCESS FOR THE DETAILS : 010405000010|10305100002333 ------------------------------> <------------------------------------------------------------------------------------------------------------------------> 04-07-2025 12:57:53:<------------------------------------------------------------------------------------------------------------------------> <-----------------------STARTED CONFIRMATION REQUEST PROCESS FOR THE DETAILS : 010405000010|10305100002333 --------------------------> <------------------------------------------------------------------------------------------------------------------------> ConfirmationReq Execution Success with Status 111 <-----------------------END CONFIRMATION REQUEST PROCESS FOR THE DETAILS : 010405000010|10305100002333 ------------------------------> <------------------------------------------------------------------------------------------------------------------------> 04-07-2025 12:57:53:<------------------------------------------------------------------------------------------------------------------------> <-----------------------STARTED CONFIRMATION REQUEST PROCESS FOR THE DETAILS : 010405000010|10305100002333 --------------------------> <------------------------------------------------------------------------------------------------------------------------> ConfirmationReq Execution Success with Status 111 <-----------------------END CONFIRMATION REQUEST PROCESS FOR THE DETAILS : 010405000010|10305100002333 ------------------------------> <------------------------------------------------------------------------------------------------------------------------> 04-07-2025 12:57:53:<------------------------------------------------------------------------------------------------------------------------> <-----------------------STARTED CONFIRMATION REQUEST PROCESS FOR THE DETAILS : 010405000010|10305100002333 --------------------------> <------------------------------------------------------------------------------------------------------------------------> ConfirmationReq Execution Success with Status 111 <-----------------------END CONFIRMATION REQUEST PROCESS FOR THE DETAILS : 010405000010|10305100002333 ------------------------------> <------------------------------------------------------------------------------------------------------------------------> 04-07-2025 12:57:53:<------------------------------------------------------------------------------------------------------------------------> <-----------------------STARTED CONFIRMATION REQUEST PROCESS FOR THE DETAILS : 010405000010|10305100002333 --------------------------> <------------------------------------------------------------------------------------------------------------------------> ConfirmationReq Execution Success with Status 111 <-----------------------END CONFIRMATION REQUEST PROCESS FOR THE DETAILS : 010405000010|10305100002333 ------------------------------> <------------------------------------------------------------------------------------------------------------------------> 04-07-2025 12:57:53:<------------------------------------------------------------------------------------------------------------------------> <-----------------------STARTED CONFIRMATION REQUEST PROCESS FOR THE DETAILS : 010405000010|10305100002333 --------------------------> <------------------------------------------------------------------------------------------------------------------------> ConfirmationReq Execution Success with Status 111 <-----------------------END CONFIRMATION REQUEST PROCESS FOR THE DETAILS : 010405000010|10305100002333 ------------------------------> <------------------------------------------------------------------------------------------------------------------------> 04-07-2025 12:57:53:<------------------------------------------------------------------------------------------------------------------------> <-----------------------STARTED CONFIRMATION REQUEST PROCESS FOR THE DETAILS : 010405000010|10305100002333 --------------------------> <------------------------------------------------------------------------------------------------------------------------> ConfirmationReq Execution Success with Status 111 <-----------------------END CONFIRMATION REQUEST PROCESS FOR THE DETAILS : 010405000010|10305100002333 ------------------------------> <------------------------------------------------------------------------------------------------------------------------> 04-07-2025 12:57:53:<------------------------------------------------------------------------------------------------------------------------> <-----------------------STARTED CONFIRMATION REQUEST PROCESS FOR THE DETAILS : 010405000010|10305100002333 --------------------------> <------------------------------------------------------------------------------------------------------------------------> ConfirmationReq Execution Success with Status 111 <-----------------------END CONFIRMATION REQUEST PROCESS FOR THE DETAILS : 010405000010|10305100002333 ------------------------------> <------------------------------------------------------------------------------------------------------------------------> 04-07-2025 12:57:53:<------------------------------------------------------------------------------------------------------------------------> <-----------------------STARTED CONFIRMATION REQUEST PROCESS FOR THE DETAILS : 010405000010|10305100002333 --------------------------> <------------------------------------------------------------------------------------------------------------------------> ConfirmationReq Execution Success with Status 111 <-----------------------END CONFIRMATION REQUEST PROCESS FOR THE DETAILS : 010405000010|10305100002333 ------------------------------> <------------------------------------------------------------------------------------------------------------------------> 04-07-2025 12:57:56:<------------------------------------------------------------------------------------------------------------------------> <-----------------------STARTED CONFIRMATION REQUEST PROCESS FOR THE DETAILS : 010405000010|10305100002333 --------------------------> <------------------------------------------------------------------------------------------------------------------------> ConfirmationReq Execution Success with Status 111 <-----------------------END CONFIRMATION REQUEST PROCESS FOR THE DETAILS : 010405000010|10305100002333 ------------------------------> <------------------------------------------------------------------------------------------------------------------------> 04-07-2025 12:57:56:<------------------------------------------------------------------------------------------------------------------------> <-----------------------STARTED CONFIRMATION REQUEST PROCESS FOR THE DETAILS : 010405000010|10305100002333 --------------------------> <------------------------------------------------------------------------------------------------------------------------> ConfirmationReq Execution Success with Status 111 <-----------------------END CONFIRMATION REQUEST PROCESS FOR THE DETAILS : 010405000010|10305100002333 ------------------------------> <------------------------------------------------------------------------------------------------------------------------> 04-07-2025 12:57:56:<------------------------------------------------------------------------------------------------------------------------> <-----------------------STARTED CONFIRMATION REQUEST PROCESS FOR THE DETAILS : 010405000010|10305100002333 --------------------------> <------------------------------------------------------------------------------------------------------------------------> ConfirmationReq Execution Success with Status 111 <-----------------------END CONFIRMATION REQUEST PROCESS FOR THE DETAILS : 010405000010|10305100002333 ------------------------------> <------------------------------------------------------------------------------------------------------------------------> 04-07-2025 12:57:56:<------------------------------------------------------------------------------------------------------------------------> <-----------------------STARTED CONFIRMATION REQUEST PROCESS FOR THE DETAILS : 010405000010|10305100002333 --------------------------> <------------------------------------------------------------------------------------------------------------------------> ConfirmationReq Execution Success with Status 111 <-----------------------END CONFIRMATION REQUEST PROCESS FOR THE DETAILS : 010405000010|10305100002333 ------------------------------> <------------------------------------------------------------------------------------------------------------------------> 04-07-2025 12:57:56:<------------------------------------------------------------------------------------------------------------------------> <-----------------------STARTED CONFIRMATION REQUEST PROCESS FOR THE DETAILS : 010405000010|10305100002333 --------------------------> <------------------------------------------------------------------------------------------------------------------------> ConfirmationReq Execution Success with Status 111 <-----------------------END CONFIRMATION REQUEST PROCESS FOR THE DETAILS : 010405000010|10305100002333 ------------------------------> <------------------------------------------------------------------------------------------------------------------------> 04-07-2025 12:57:56:<------------------------------------------------------------------------------------------------------------------------> <-----------------------STARTED CONFIRMATION REQUEST PROCESS FOR THE DETAILS : 010405000010|10305100002333 --------------------------> <------------------------------------------------------------------------------------------------------------------------> ConfirmationReq Execution Success with Status 111 <-----------------------END CONFIRMATION REQUEST PROCESS FOR THE DETAILS : 010405000010|10305100002333 ------------------------------> <------------------------------------------------------------------------------------------------------------------------> 04-07-2025 12:57:56:<------------------------------------------------------------------------------------------------------------------------> <-----------------------STARTED CONFIRMATION REQUEST PROCESS FOR THE DETAILS : 010405000010|10305100002333 --------------------------> <------------------------------------------------------------------------------------------------------------------------> ConfirmationReq Execution Success with Status 111 <-----------------------END CONFIRMATION REQUEST PROCESS FOR THE DETAILS : 010405000010|10305100002333 ------------------------------> <------------------------------------------------------------------------------------------------------------------------> 04-07-2025 12:57:56:<------------------------------------------------------------------------------------------------------------------------> <-----------------------STARTED CONFIRMATION REQUEST PROCESS FOR THE DETAILS : 010405000010|10305100002333 --------------------------> <------------------------------------------------------------------------------------------------------------------------> ConfirmationReq Execution Success with Status 111 <-----------------------END CONFIRMATION REQUEST PROCESS FOR THE DETAILS : 010405000010|10305100002333 ------------------------------> <------------------------------------------------------------------------------------------------------------------------> 04-07-2025 12:57:56:<------------------------------------------------------------------------------------------------------------------------> <-----------------------STARTED CONFIRMATION REQUEST PROCESS FOR THE DETAILS : 010405000010|10305100002333 --------------------------> <------------------------------------------------------------------------------------------------------------------------> ConfirmationReq Execution Success with Status 111 <-----------------------END CONFIRMATION REQUEST PROCESS FOR THE DETAILS : 010405000010|10305100002333 ------------------------------> <------------------------------------------------------------------------------------------------------------------------> 04-07-2025 12:57:56:<------------------------------------------------------------------------------------------------------------------------> <-----------------------STARTED CONFIRMATION REQUEST PROCESS FOR THE DETAILS : 010405000010|10305100002333 --------------------------> <------------------------------------------------------------------------------------------------------------------------> ConfirmationReq Execution Success with Status 111 <-----------------------END CONFIRMATION REQUEST PROCESS FOR THE DETAILS : 010405000010|10305100002333 ------------------------------> <------------------------------------------------------------------------------------------------------------------------> 04-07-2025 15:48:46:ShowCBSAcNo(). Log: TranProcess.cs: ShowCBSAcNo() Query: SELECT SUBSTR ('001002000894', 0, brlength) branch, SUBSTR ('001002000894', brlength+1, schlength) linksno, SUBSTR ('001002000894', -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|000894|CA|1 04-07-2025 15:48:46:Validation Account Proce Executed with out error <------------------------------------------------------------------------------------------------------------------------> ValidateAcNo CBS A/C No : 001002000894 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 = 000894ValidationAcNo.cs: Closedyn Query Row count1<------------------------------------------------------------------------------------------------------------------------> Y|CA|000894|1 04-07-2025 15:48:46:ValidationRequest(): Log:Validation Request DetailsKARBR52025070400537954|001002000894 <------------------------Started ValidationRequest CBS A/C No : 001002000894 ------------------------> <------------------------------------------------------------------------------------------------------------------------> ValidationRequest Execution Success with response : 000 <------------------------------------------------------------------------------------------------------------------------> 04-07-2025 15:48:53:ShowCBSAcNo(). Log: TranProcess.cs: ShowCBSAcNo() Query: SELECT SUBSTR ('001002000894', 0, brlength) branch, SUBSTR ('001002000894', brlength+1, schlength) linksno, SUBSTR ('001002000894', -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|000894|CA|1 04-07-2025 15:48:53:Validation Account Proce Executed with out error <------------------------------------------------------------------------------------------------------------------------> ValidateAcNo CBS A/C No : 001002000894 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 = 000894ValidationAcNo.cs: Closedyn Query Row count1<------------------------------------------------------------------------------------------------------------------------> Y|CA|000894|1 04-07-2025 15:48:53:TranProcess.cs: Inward_process() UTR ValidationSELECT remit_utr FROM rtgsinwardrequest WHERE Trim(remit_utr) = 'KARBR52025070400537954' 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, 'KARBR52025070400537954','VYSHAK ENTERPRISES','001002000894','VYSHAK ENTERPRISES', '7547000600151101','KARB0000754','UTIB0SMCBL1',900000,'123')TranProcess.cs: Inward_process(): 001002000894 KARBR52025070400537954 Status : 000 04-07-2025 15:48:53:<------------------------------------------------------------------------------------------------------------------------> <-----------------------STARTED CONFIRMATION REQUEST PROCESS FOR THE DETAILS : KARBR52025070400537954|001002000894 --------------------------> <------------------------------------------------------------------------------------------------------------------------> ConfirmationReq Execution Success with Status 000 <-----------------------END CONFIRMATION REQUEST PROCESS FOR THE DETAILS : KARBR52025070400537954|001002000894 ------------------------------> <------------------------------------------------------------------------------------------------------------------------> 04-07-2025 17:52:29:ShowCBSAcNo(). Log: TranProcess.cs: ShowCBSAcNo() Query: SELECT SUBSTR ('001002001217', 0, brlength) branch, SUBSTR ('001002001217', brlength+1, schlength) linksno, SUBSTR ('001002001217', -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|001217|CA|1 04-07-2025 17:52:29:Validation Account Proce Executed with out error <------------------------------------------------------------------------------------------------------------------------> ValidateAcNo CBS A/C No : 001002001217 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 = 001217ValidationAcNo.cs: Closedyn Query Row count1<------------------------------------------------------------------------------------------------------------------------> Y|CA|001217|1 04-07-2025 17:52:29:ValidationRequest(): Log:Validation Request DetailsHDFCH00341209138|001002001217 <------------------------Started ValidationRequest CBS A/C No : 001002001217 ------------------------> <------------------------------------------------------------------------------------------------------------------------> ValidationRequest Execution Success with response : 000 <------------------------------------------------------------------------------------------------------------------------> 04-07-2025 18:05:57:ShowCBSAcNo(). Log: TranProcess.cs: ShowCBSAcNo() Query: SELECT SUBSTR ('001002001217', 0, brlength) branch, SUBSTR ('001002001217', brlength+1, schlength) linksno, SUBSTR ('001002001217', -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|001217|CA|1 04-07-2025 18:05:57:Validation Account Proce Executed with out error <------------------------------------------------------------------------------------------------------------------------> ValidateAcNo CBS A/C No : 001002001217 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 = 001217ValidationAcNo.cs: Closedyn Query Row count1<------------------------------------------------------------------------------------------------------------------------> Y|CA|001217|1 04-07-2025 18:05:57:TranProcess.cs: Inward_process() UTR ValidationSELECT remit_utr FROM rtgsinwardrequest WHERE Trim(remit_utr) = 'HDFCH00341209138' 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, 'HDFCH00341209138','DIYA ENTERPRISES','001002001217','SRI MARUTHI AGENCIES', '50200102348819','HDFC0000001','UTIB0SMCBL1',44600,'123')TranProcess.cs: Inward_process(): 001002001217 HDFCH00341209138 Status : 000 04-07-2025 18:05:57:<------------------------------------------------------------------------------------------------------------------------> <-----------------------STARTED CONFIRMATION REQUEST PROCESS FOR THE DETAILS : HDFCH00341209138|001002001217 --------------------------> <------------------------------------------------------------------------------------------------------------------------> ConfirmationReq Execution Success with Status 000 <-----------------------END CONFIRMATION REQUEST PROCESS FOR THE DETAILS : HDFCH00341209138|001002001217 ------------------------------> <------------------------------------------------------------------------------------------------------------------------> 04-07-2025 21:08:08:<------------------------------------------------------------------------------------------------------------------------> <-----------------------STARTED CONFIRMATION REQUEST PROCESS FOR THE DETAILS : 010405000010|10305100002333 --------------------------> <------------------------------------------------------------------------------------------------------------------------> ConfirmationReq Execution Success with Status 111 <-----------------------END CONFIRMATION REQUEST PROCESS FOR THE DETAILS : 010405000010|10305100002333 ------------------------------> <------------------------------------------------------------------------------------------------------------------------> 04-07-2025 21:08:08:<------------------------------------------------------------------------------------------------------------------------> <-----------------------STARTED CONFIRMATION REQUEST PROCESS FOR THE DETAILS : 010405000010|10305100002333 --------------------------> <------------------------------------------------------------------------------------------------------------------------> ConfirmationReq Execution Success with Status 111 <-----------------------END CONFIRMATION REQUEST PROCESS FOR THE DETAILS : 010405000010|10305100002333 ------------------------------> <------------------------------------------------------------------------------------------------------------------------> 04-07-2025 21:08:08:<------------------------------------------------------------------------------------------------------------------------> <-----------------------STARTED CONFIRMATION REQUEST PROCESS FOR THE DETAILS : 010405000010|10305100002333 --------------------------> <------------------------------------------------------------------------------------------------------------------------> ConfirmationReq Execution Success with Status 111 <-----------------------END CONFIRMATION REQUEST PROCESS FOR THE DETAILS : 010405000010|10305100002333 ------------------------------> <------------------------------------------------------------------------------------------------------------------------> 04-07-2025 21:08:08:<------------------------------------------------------------------------------------------------------------------------> <-----------------------STARTED CONFIRMATION REQUEST PROCESS FOR THE DETAILS : 010405000010|10305100002333 --------------------------> <------------------------------------------------------------------------------------------------------------------------> ConfirmationReq Execution Success with Status 111 <-----------------------END CONFIRMATION REQUEST PROCESS FOR THE DETAILS : 010405000010|10305100002333 ------------------------------> <------------------------------------------------------------------------------------------------------------------------> 04-07-2025 21:08:08:<------------------------------------------------------------------------------------------------------------------------> <-----------------------STARTED CONFIRMATION REQUEST PROCESS FOR THE DETAILS : 010405000010|10305100002333 --------------------------> <------------------------------------------------------------------------------------------------------------------------> ConfirmationReq Execution Success with Status 111 <-----------------------END CONFIRMATION REQUEST PROCESS FOR THE DETAILS : 010405000010|10305100002333 ------------------------------> <------------------------------------------------------------------------------------------------------------------------> 04-07-2025 21:08:08:<------------------------------------------------------------------------------------------------------------------------> <-----------------------STARTED CONFIRMATION REQUEST PROCESS FOR THE DETAILS : 010405000010|10305100002333 --------------------------> <------------------------------------------------------------------------------------------------------------------------> ConfirmationReq Execution Success with Status 111 <-----------------------END CONFIRMATION REQUEST PROCESS FOR THE DETAILS : 010405000010|10305100002333 ------------------------------> <------------------------------------------------------------------------------------------------------------------------> 04-07-2025 21:08:08:<------------------------------------------------------------------------------------------------------------------------> <-----------------------STARTED CONFIRMATION REQUEST PROCESS FOR THE DETAILS : 010405000010|10305100002333 --------------------------> <------------------------------------------------------------------------------------------------------------------------> ConfirmationReq Execution Success with Status 111 <-----------------------END CONFIRMATION REQUEST PROCESS FOR THE DETAILS : 010405000010|10305100002333 ------------------------------> <------------------------------------------------------------------------------------------------------------------------> 04-07-2025 21:08:08:<------------------------------------------------------------------------------------------------------------------------> <-----------------------STARTED CONFIRMATION REQUEST PROCESS FOR THE DETAILS : 010405000010|10305100002333 --------------------------> <------------------------------------------------------------------------------------------------------------------------> ConfirmationReq Execution Success with Status 111 <-----------------------END CONFIRMATION REQUEST PROCESS FOR THE DETAILS : 010405000010|10305100002333 ------------------------------> <------------------------------------------------------------------------------------------------------------------------> 04-07-2025 21:08:08:<------------------------------------------------------------------------------------------------------------------------> <-----------------------STARTED CONFIRMATION REQUEST PROCESS FOR THE DETAILS : 010405000010|10305100002333 --------------------------> <------------------------------------------------------------------------------------------------------------------------> ConfirmationReq Execution Success with Status 111 <-----------------------END CONFIRMATION REQUEST PROCESS FOR THE DETAILS : 010405000010|10305100002333 ------------------------------> <------------------------------------------------------------------------------------------------------------------------> 04-07-2025 21:08:08:<------------------------------------------------------------------------------------------------------------------------> <-----------------------STARTED CONFIRMATION REQUEST PROCESS FOR THE DETAILS : 010405000010|10305100002333 --------------------------> <------------------------------------------------------------------------------------------------------------------------> ConfirmationReq Execution Success with Status 111 <-----------------------END CONFIRMATION REQUEST PROCESS FOR THE DETAILS : 010405000010|10305100002333 ------------------------------> <------------------------------------------------------------------------------------------------------------------------> 04-07-2025 23:15:26:<------------------------------------------------------------------------------------------------------------------------> <-----------------------STARTED CONFIRMATION REQUEST PROCESS FOR THE DETAILS : 010405000010|10305100002333 --------------------------> <------------------------------------------------------------------------------------------------------------------------> ConfirmationReq Execution Success with Status 111 <-----------------------END CONFIRMATION REQUEST PROCESS FOR THE DETAILS : 010405000010|10305100002333 ------------------------------> <------------------------------------------------------------------------------------------------------------------------> 04-07-2025 23:15:26:<------------------------------------------------------------------------------------------------------------------------> <-----------------------STARTED CONFIRMATION REQUEST PROCESS FOR THE DETAILS : 010405000010|10305100002333 --------------------------> <------------------------------------------------------------------------------------------------------------------------> ConfirmationReq Execution Success with Status 111 <-----------------------END CONFIRMATION REQUEST PROCESS FOR THE DETAILS : 010405000010|10305100002333 ------------------------------> <------------------------------------------------------------------------------------------------------------------------> 04-07-2025 23:15:26:<------------------------------------------------------------------------------------------------------------------------> <-----------------------STARTED CONFIRMATION REQUEST PROCESS FOR THE DETAILS : 010405000010|10305100002333 --------------------------> <------------------------------------------------------------------------------------------------------------------------> ConfirmationReq Execution Success with Status 111 <-----------------------END CONFIRMATION REQUEST PROCESS FOR THE DETAILS : 010405000010|10305100002333 ------------------------------> <------------------------------------------------------------------------------------------------------------------------> 04-07-2025 23:15:26:<------------------------------------------------------------------------------------------------------------------------> <-----------------------STARTED CONFIRMATION REQUEST PROCESS FOR THE DETAILS : 010405000010|10305100002333 --------------------------> <------------------------------------------------------------------------------------------------------------------------> ConfirmationReq Execution Success with Status 111 <-----------------------END CONFIRMATION REQUEST PROCESS FOR THE DETAILS : 010405000010|10305100002333 ------------------------------> <------------------------------------------------------------------------------------------------------------------------> 04-07-2025 23:15:26:<------------------------------------------------------------------------------------------------------------------------> <-----------------------STARTED CONFIRMATION REQUEST PROCESS FOR THE DETAILS : 010405000010|10305100002333 --------------------------> <------------------------------------------------------------------------------------------------------------------------> ConfirmationReq Execution Success with Status 111 <-----------------------END CONFIRMATION REQUEST PROCESS FOR THE DETAILS : 010405000010|10305100002333 ------------------------------> <------------------------------------------------------------------------------------------------------------------------> 04-07-2025 23:15:26:<------------------------------------------------------------------------------------------------------------------------> <-----------------------STARTED CONFIRMATION REQUEST PROCESS FOR THE DETAILS : 010405000010|10305100002333 --------------------------> <------------------------------------------------------------------------------------------------------------------------> ConfirmationReq Execution Success with Status 111 <-----------------------END CONFIRMATION REQUEST PROCESS FOR THE DETAILS : 010405000010|10305100002333 ------------------------------> <------------------------------------------------------------------------------------------------------------------------> 04-07-2025 23:15:26:<------------------------------------------------------------------------------------------------------------------------> <-----------------------STARTED CONFIRMATION REQUEST PROCESS FOR THE DETAILS : 010405000010|10305100002333 --------------------------> <------------------------------------------------------------------------------------------------------------------------> ConfirmationReq Execution Success with Status 111 <-----------------------END CONFIRMATION REQUEST PROCESS FOR THE DETAILS : 010405000010|10305100002333 ------------------------------> <------------------------------------------------------------------------------------------------------------------------> 04-07-2025 23:15:26:<------------------------------------------------------------------------------------------------------------------------> <-----------------------STARTED CONFIRMATION REQUEST PROCESS FOR THE DETAILS : 010405000010|10305100002333 --------------------------> <------------------------------------------------------------------------------------------------------------------------> ConfirmationReq Execution Success with Status 111 <-----------------------END CONFIRMATION REQUEST PROCESS FOR THE DETAILS : 010405000010|10305100002333 ------------------------------> <------------------------------------------------------------------------------------------------------------------------> 04-07-2025 23:15:26:<------------------------------------------------------------------------------------------------------------------------> <-----------------------STARTED CONFIRMATION REQUEST PROCESS FOR THE DETAILS : 010405000010|10305100002333 --------------------------> <------------------------------------------------------------------------------------------------------------------------> ConfirmationReq Execution Success with Status 111 <-----------------------END CONFIRMATION REQUEST PROCESS FOR THE DETAILS : 010405000010|10305100002333 ------------------------------> <------------------------------------------------------------------------------------------------------------------------> 04-07-2025 23:15:26:<------------------------------------------------------------------------------------------------------------------------> <-----------------------STARTED CONFIRMATION REQUEST PROCESS FOR THE DETAILS : 010405000010|10305100002333 --------------------------> <------------------------------------------------------------------------------------------------------------------------> ConfirmationReq Execution Success with Status 111 <-----------------------END CONFIRMATION REQUEST PROCESS FOR THE DETAILS : 010405000010|10305100002333 ------------------------------> <------------------------------------------------------------------------------------------------------------------------> 04-07-2025 23:19:55:<------------------------------------------------------------------------------------------------------------------------> <-----------------------STARTED CONFIRMATION REQUEST PROCESS FOR THE DETAILS : 010405000010|10305100002333 --------------------------> <------------------------------------------------------------------------------------------------------------------------> ConfirmationReq Execution Success with Status 111 <-----------------------END CONFIRMATION REQUEST PROCESS FOR THE DETAILS : 010405000010|10305100002333 ------------------------------> <------------------------------------------------------------------------------------------------------------------------> 04-07-2025 23:19:55:<------------------------------------------------------------------------------------------------------------------------> <-----------------------STARTED CONFIRMATION REQUEST PROCESS FOR THE DETAILS : 010405000010|10305100002333 --------------------------> <------------------------------------------------------------------------------------------------------------------------> ConfirmationReq Execution Success with Status 111 <-----------------------END CONFIRMATION REQUEST PROCESS FOR THE DETAILS : 010405000010|10305100002333 ------------------------------> <------------------------------------------------------------------------------------------------------------------------> 04-07-2025 23:19:55:<------------------------------------------------------------------------------------------------------------------------> <-----------------------STARTED CONFIRMATION REQUEST PROCESS FOR THE DETAILS : 010405000010|10305100002333 --------------------------> <------------------------------------------------------------------------------------------------------------------------> ConfirmationReq Execution Success with Status 111 <-----------------------END CONFIRMATION REQUEST PROCESS FOR THE DETAILS : 010405000010|10305100002333 ------------------------------> <------------------------------------------------------------------------------------------------------------------------> 04-07-2025 23:19:55:<------------------------------------------------------------------------------------------------------------------------> <-----------------------STARTED CONFIRMATION REQUEST PROCESS FOR THE DETAILS : 010405000010|10305100002333 --------------------------> <------------------------------------------------------------------------------------------------------------------------> ConfirmationReq Execution Success with Status 111 <-----------------------END CONFIRMATION REQUEST PROCESS FOR THE DETAILS : 010405000010|10305100002333 ------------------------------> <------------------------------------------------------------------------------------------------------------------------> 04-07-2025 23:19:55:<------------------------------------------------------------------------------------------------------------------------> <-----------------------STARTED CONFIRMATION REQUEST PROCESS FOR THE DETAILS : 010405000010|10305100002333 --------------------------> <------------------------------------------------------------------------------------------------------------------------> ConfirmationReq Execution Success with Status 111 <-----------------------END CONFIRMATION REQUEST PROCESS FOR THE DETAILS : 010405000010|10305100002333 ------------------------------> <------------------------------------------------------------------------------------------------------------------------> 04-07-2025 23:19:55:<------------------------------------------------------------------------------------------------------------------------> <-----------------------STARTED CONFIRMATION REQUEST PROCESS FOR THE DETAILS : 010405000010|10305100002333 --------------------------> <------------------------------------------------------------------------------------------------------------------------> ConfirmationReq Execution Success with Status 111 <-----------------------END CONFIRMATION REQUEST PROCESS FOR THE DETAILS : 010405000010|10305100002333 ------------------------------> <------------------------------------------------------------------------------------------------------------------------> 04-07-2025 23:19:55:<------------------------------------------------------------------------------------------------------------------------> <-----------------------STARTED CONFIRMATION REQUEST PROCESS FOR THE DETAILS : 010405000010|10305100002333 --------------------------> <------------------------------------------------------------------------------------------------------------------------> ConfirmationReq Execution Success with Status 111 <-----------------------END CONFIRMATION REQUEST PROCESS FOR THE DETAILS : 010405000010|10305100002333 ------------------------------> <------------------------------------------------------------------------------------------------------------------------> 04-07-2025 23:19:55:<------------------------------------------------------------------------------------------------------------------------> <-----------------------STARTED CONFIRMATION REQUEST PROCESS FOR THE DETAILS : 010405000010|10305100002333 --------------------------> <------------------------------------------------------------------------------------------------------------------------> ConfirmationReq Execution Success with Status 111 <-----------------------END CONFIRMATION REQUEST PROCESS FOR THE DETAILS : 010405000010|10305100002333 ------------------------------> <------------------------------------------------------------------------------------------------------------------------> 04-07-2025 23:19:55:<------------------------------------------------------------------------------------------------------------------------> <-----------------------STARTED CONFIRMATION REQUEST PROCESS FOR THE DETAILS : 010405000010|10305100002333 --------------------------> <------------------------------------------------------------------------------------------------------------------------> ConfirmationReq Execution Success with Status 111 <-----------------------END CONFIRMATION REQUEST PROCESS FOR THE DETAILS : 010405000010|10305100002333 ------------------------------> <------------------------------------------------------------------------------------------------------------------------> 04-07-2025 23:19:55:<------------------------------------------------------------------------------------------------------------------------> <-----------------------STARTED CONFIRMATION REQUEST PROCESS FOR THE DETAILS : 010405000010|10305100002333 --------------------------> <------------------------------------------------------------------------------------------------------------------------> ConfirmationReq Execution Success with Status 111 <-----------------------END CONFIRMATION REQUEST PROCESS FOR THE DETAILS : 010405000010|10305100002333 ------------------------------> <------------------------------------------------------------------------------------------------------------------------>