11-08-2022 01:48:38:Validation Account Proce Executed with out error <------------------------------------------------------------------------------------------------------------------------> ValidateAcNo CBS A/C No : 913010055723558 <------------------------------------------------------------------------------------------------------------------------> N 11-08-2022 01:48:40:ValidationRequest(): Log:Validation Request Details28971838801DC|913010055723558 <------------------------Started ValidationRequest CBS A/C No : 913010055723558 ------------------------> <------------------------------------------------------------------------------------------------------------------------> ValidationRequest Execution Success with response : 111 <------------------------------------------------------------------------------------------------------------------------> 11-08-2022 01:49:05:Validation Account Proce Executed with out error <------------------------------------------------------------------------------------------------------------------------> ValidateAcNo CBS A/C No : 913010055723558 <------------------------------------------------------------------------------------------------------------------------> N 11-08-2022 01:49:06:ValidationRequest(): Log:Validation Request Details28971838801DC|913010055723558 <------------------------Started ValidationRequest CBS A/C No : 913010055723558 ------------------------> <------------------------------------------------------------------------------------------------------------------------> ValidationRequest Execution Success with response : 111 <------------------------------------------------------------------------------------------------------------------------> 11-08-2022 01:50:35:Validation Account Proce Executed with out error <------------------------------------------------------------------------------------------------------------------------> ValidateAcNo CBS A/C No : 913010055723558 <------------------------------------------------------------------------------------------------------------------------> N 11-08-2022 01:50:35:ValidationRequest(): Log:Validation Request Details28971838801DC|913010055723558 <------------------------Started ValidationRequest CBS A/C No : 913010055723558 ------------------------> <------------------------------------------------------------------------------------------------------------------------> ValidationRequest Execution Success with response : 111 <------------------------------------------------------------------------------------------------------------------------> 11-08-2022 01:51:04:Validation Account Proce Executed with out error <------------------------------------------------------------------------------------------------------------------------> ValidateAcNo CBS A/C No : 913010055723558 <------------------------------------------------------------------------------------------------------------------------> N 11-08-2022 01:51:05:ValidationRequest(): Log:Validation Request Details28971838801DC|913010055723558 <------------------------Started ValidationRequest CBS A/C No : 913010055723558 ------------------------> <------------------------------------------------------------------------------------------------------------------------> ValidationRequest Execution Success with response : 111 <------------------------------------------------------------------------------------------------------------------------> 11-08-2022 01:54:07:Validation Account Proce Executed with out error <------------------------------------------------------------------------------------------------------------------------> ValidateAcNo CBS A/C No : 913010055723558 <------------------------------------------------------------------------------------------------------------------------> N 11-08-2022 01:54:07:ValidationRequest(): Log:Validation Request Details28971838801DC|913010055723558 <------------------------Started ValidationRequest CBS A/C No : 913010055723558 ------------------------> <------------------------------------------------------------------------------------------------------------------------> ValidationRequest Execution Success with response : 111 <------------------------------------------------------------------------------------------------------------------------> 11-08-2022 01:54:45:Validation Account Proce Executed with out error <------------------------------------------------------------------------------------------------------------------------> ValidateAcNo CBS A/C No : 913010055723558 <------------------------------------------------------------------------------------------------------------------------> N 11-08-2022 01:54:46:ValidationRequest(): Log:Validation Request Details28971838801DC|913010055723558 <------------------------Started ValidationRequest CBS A/C No : 913010055723558 ------------------------> <------------------------------------------------------------------------------------------------------------------------> ValidationRequest Execution Success with response : 111 <------------------------------------------------------------------------------------------------------------------------> 11-08-2022 01:57:43:Validation Account Proce Executed with out error <------------------------------------------------------------------------------------------------------------------------> ValidateAcNo CBS A/C No : 913010055723558 <------------------------------------------------------------------------------------------------------------------------> N 11-08-2022 01:57:43:ValidationRequest(): Log:Validation Request Details28971838801DC|913010055723558 <------------------------Started ValidationRequest CBS A/C No : 913010055723558 ------------------------> <------------------------------------------------------------------------------------------------------------------------> ValidationRequest Execution Success with response : 111 <------------------------------------------------------------------------------------------------------------------------> 11-08-2022 01:57:54:Validation Account Proce Executed with out error <------------------------------------------------------------------------------------------------------------------------> ValidateAcNo CBS A/C No : 913010055723558 <------------------------------------------------------------------------------------------------------------------------> N 11-08-2022 01:57:54:ValidationRequest(): Log:Validation Request Details28971838801DC|913010055723558 <------------------------Started ValidationRequest CBS A/C No : 913010055723558 ------------------------> <------------------------------------------------------------------------------------------------------------------------> ValidationRequest Execution Success with response : 111 <------------------------------------------------------------------------------------------------------------------------> 11-08-2022 02:01:17:Validation Account Proce Executed with out error <------------------------------------------------------------------------------------------------------------------------> ValidateAcNo CBS A/C No : 913010055723558 <------------------------------------------------------------------------------------------------------------------------> N 11-08-2022 02:01:17:ValidationRequest(): Log:Validation Request Details28971838801DC|913010055723558 <------------------------Started ValidationRequest CBS A/C No : 913010055723558 ------------------------> <------------------------------------------------------------------------------------------------------------------------> ValidationRequest Execution Success with response : 111 <------------------------------------------------------------------------------------------------------------------------> 11-08-2022 02:01:44:Validation Account Proce Executed with out error <------------------------------------------------------------------------------------------------------------------------> ValidateAcNo CBS A/C No : 913010055723558 <------------------------------------------------------------------------------------------------------------------------> N 11-08-2022 02:01:44:ValidationRequest(): Log:Validation Request Details28971838801DC|913010055723558 <------------------------Started ValidationRequest CBS A/C No : 913010055723558 ------------------------> <------------------------------------------------------------------------------------------------------------------------> ValidationRequest Execution Success with response : 111 <------------------------------------------------------------------------------------------------------------------------> 11-08-2022 02:07:24:Validation Account Proce Executed with out error <------------------------------------------------------------------------------------------------------------------------> ValidateAcNo CBS A/C No : 913010055723558 <------------------------------------------------------------------------------------------------------------------------> N 11-08-2022 02:07:24:ValidationRequest(): Log:Validation Request Details28971838801DC|913010055723558 <------------------------Started ValidationRequest CBS A/C No : 913010055723558 ------------------------> <------------------------------------------------------------------------------------------------------------------------> ValidationRequest Execution Success with response : 111 <------------------------------------------------------------------------------------------------------------------------> 11-08-2022 13:30:25:ShowCBSAcNo(). Log: TranProcess.cs: ShowCBSAcNo() Query: SELECT SUBSTR ('001002001172', 0, brlength) branch, SUBSTR ('001002001172', brlength+1, schlength) linksno, SUBSTR ('001002001172', -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|001172|CA|1 11-08-2022 13:30:25:Validation Account Proce Executed with out error <------------------------------------------------------------------------------------------------------------------------> ValidateAcNo CBS A/C No : 001002001172 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 = 001172ValidationAcNo.cs: Closedyn Query Row count1<------------------------------------------------------------------------------------------------------------------------> Y|CA|001172|1 11-08-2022 13:30:25:ValidationRequest(): Log:Validation Request Details28975403041DC|001002001172 <------------------------Started ValidationRequest CBS A/C No : 001002001172 ------------------------> <------------------------------------------------------------------------------------------------------------------------> ValidationRequest Execution Success with response : 000 <------------------------------------------------------------------------------------------------------------------------> 11-08-2022 13:31:57:ShowCBSAcNo(). Log: TranProcess.cs: ShowCBSAcNo() Query: SELECT SUBSTR ('001002001148', 0, brlength) branch, SUBSTR ('001002001148', brlength+1, schlength) linksno, SUBSTR ('001002001148', -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|001148|CA|1 11-08-2022 13:31:57:Validation Account Proce Executed with out error <------------------------------------------------------------------------------------------------------------------------> ValidateAcNo CBS A/C No : 001002001148 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 = 001148ValidationAcNo.cs: Closedyn Query Row count1<------------------------------------------------------------------------------------------------------------------------> Y|CA|001148|1 11-08-2022 13:31:57:ValidationRequest(): Log:Validation Request Details25-722314610-1|001002001148 <------------------------Started ValidationRequest CBS A/C No : 001002001148 ------------------------> <------------------------------------------------------------------------------------------------------------------------> ValidationRequest Execution Success with response : 000 <------------------------------------------------------------------------------------------------------------------------> 11-08-2022 13:35:11:ShowCBSAcNo(). Log: TranProcess.cs: ShowCBSAcNo() Query: SELECT SUBSTR ('001002001148', 0, brlength) branch, SUBSTR ('001002001148', brlength+1, schlength) linksno, SUBSTR ('001002001148', -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|001148|CA|1 11-08-2022 13:35:11:Validation Account Proce Executed with out error <------------------------------------------------------------------------------------------------------------------------> ValidateAcNo CBS A/C No : 001002001148 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 = 001148ValidationAcNo.cs: Closedyn Query Row count1<------------------------------------------------------------------------------------------------------------------------> Y|CA|001148|1 11-08-2022 13:35:11:TranProcess.cs: Inward_process() UTR ValidationSELECT remit_utr FROM rtgsinwardrequest WHERE Trim(remit_utr) = '25-722314610-1' 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, '25-722314610-1','Geethesh babu S M','001002001148','SKANDA COCO PRODUCTS', '921020041897780','','UTIB0SMCBL1',6000,'123')TranProcess.cs: Inward_process(): 001002001148 25-722314610-1 Status : 000 11-08-2022 13:35:11:<------------------------------------------------------------------------------------------------------------------------> <-----------------------STARTED CONFIRMATION REQUEST PROCESS FOR THE DETAILS : 25-722314610-1|001002001148 --------------------------> <------------------------------------------------------------------------------------------------------------------------> ConfirmationReq Execution Success with Status 000 <-----------------------END CONFIRMATION REQUEST PROCESS FOR THE DETAILS : 25-722314610-1|001002001148 ------------------------------> <------------------------------------------------------------------------------------------------------------------------> 11-08-2022 13:42:30:ShowCBSAcNo(). Log: TranProcess.cs: ShowCBSAcNo() Query: SELECT SUBSTR ('001001002130', 0, brlength) branch, SUBSTR ('001001002130', brlength+1, schlength) linksno, SUBSTR ('001001002130', -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|002130|SB|1 11-08-2022 13:42:30:Validation Account Proce Executed with out error <------------------------------------------------------------------------------------------------------------------------> ValidateAcNo CBS A/C No : 001001002130 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 = 002130ValidationAcNo.cs: Closedyn Query Row count1<------------------------------------------------------------------------------------------------------------------------> Y|SB|002130|1 11-08-2022 13:42:30:ValidationRequest(): Log:Validation Request DetailsCIUBL22223017360|001001002130 <------------------------Started ValidationRequest CBS A/C No : 001001002130 ------------------------> <------------------------------------------------------------------------------------------------------------------------> ValidationRequest Execution Success with response : 000 <------------------------------------------------------------------------------------------------------------------------> 11-08-2022 13:54:52:ShowCBSAcNo(). Log: TranProcess.cs: ShowCBSAcNo() Query: SELECT SUBSTR ('001001002130', 0, brlength) branch, SUBSTR ('001001002130', brlength+1, schlength) linksno, SUBSTR ('001001002130', -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|002130|SB|1 11-08-2022 13:54:52:Validation Account Proce Executed with out error <------------------------------------------------------------------------------------------------------------------------> ValidateAcNo CBS A/C No : 001001002130 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 = 002130ValidationAcNo.cs: Closedyn Query Row count1<------------------------------------------------------------------------------------------------------------------------> Y|SB|002130|1 11-08-2022 13:54:53:TranProcess.cs: Inward_process() UTR ValidationSELECT remit_utr FROM rtgsinwardrequest WHERE Trim(remit_utr) = 'CIUBL22223017360' 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, 'CIUBL22223017360','B K PADMINI','001001002130','LIC INDIA D061', '510909010047430','CIUB0000132','UTIB0SMCBL1',285990,'123')TranProcess.cs: Inward_process(): 001001002130 CIUBL22223017360 Status : 000 11-08-2022 13:54:53:<------------------------------------------------------------------------------------------------------------------------> <-----------------------STARTED CONFIRMATION REQUEST PROCESS FOR THE DETAILS : CIUBL22223017360|001001002130 --------------------------> <------------------------------------------------------------------------------------------------------------------------> ConfirmationReq Execution Success with Status 000 <-----------------------END CONFIRMATION REQUEST PROCESS FOR THE DETAILS : CIUBL22223017360|001001002130 ------------------------------> <------------------------------------------------------------------------------------------------------------------------> 11-08-2022 13:55:40:ShowCBSAcNo(). Log: TranProcess.cs: ShowCBSAcNo() Query: SELECT SUBSTR ('001002001172', 0, brlength) branch, SUBSTR ('001002001172', brlength+1, schlength) linksno, SUBSTR ('001002001172', -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|001172|CA|1 11-08-2022 13:55:40:Validation Account Proce Executed with out error <------------------------------------------------------------------------------------------------------------------------> ValidateAcNo CBS A/C No : 001002001172 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 = 001172ValidationAcNo.cs: Closedyn Query Row count1<------------------------------------------------------------------------------------------------------------------------> Y|CA|001172|1 11-08-2022 13:55:41:TranProcess.cs: Inward_process() UTR ValidationSELECT remit_utr FROM rtgsinwardrequest WHERE Trim(remit_utr) = '28975403041DC' 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, '28975403041DC','FISHERMEN AGRO','001002001172','FISHERMEN AGRO', '777405500025','ICIC0SF0002','UTIB0SMCBL1',185000,'123')TranProcess.cs: Inward_process(): 001002001172 28975403041DC Status : 000 11-08-2022 13:55:41:<------------------------------------------------------------------------------------------------------------------------> <-----------------------STARTED CONFIRMATION REQUEST PROCESS FOR THE DETAILS : 28975403041DC|001002001172 --------------------------> <------------------------------------------------------------------------------------------------------------------------> ConfirmationReq Execution Success with Status 000 <-----------------------END CONFIRMATION REQUEST PROCESS FOR THE DETAILS : 28975403041DC|001002001172 ------------------------------> <------------------------------------------------------------------------------------------------------------------------> 11-08-2022 14:09:11:ShowCBSAcNo(). Log: TranProcess.cs: ShowCBSAcNo() Query: SELECT SUBSTR ('001002001149', 0, brlength) branch, SUBSTR ('001002001149', brlength+1, schlength) linksno, SUBSTR ('001002001149', -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|001149|CA|1 11-08-2022 14:09:11:Validation Account Proce Executed with out error <------------------------------------------------------------------------------------------------------------------------> ValidateAcNo CBS A/C No : 001002001149 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 = 001149ValidationAcNo.cs: Closedyn Query Row count1<------------------------------------------------------------------------------------------------------------------------> Y|CA|001149|1 11-08-2022 14:09:11:ValidationRequest(): Log:Validation Request DetailsAXSK222230005166|001002001149 <------------------------Started ValidationRequest CBS A/C No : 001002001149 ------------------------> <------------------------------------------------------------------------------------------------------------------------> ValidationRequest Execution Success with response : 000 <------------------------------------------------------------------------------------------------------------------------> 11-08-2022 14:24:03:ShowCBSAcNo(). Log: TranProcess.cs: ShowCBSAcNo() Query: SELECT SUBSTR ('001002000519', 0, brlength) branch, SUBSTR ('001002000519', brlength+1, schlength) linksno, SUBSTR ('001002000519', -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|000519|CA|1 11-08-2022 14:24:03:Validation Account Proce Executed with out error <------------------------------------------------------------------------------------------------------------------------> ValidateAcNo CBS A/C No : 001002000519 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 = 000519ValidationAcNo.cs: Closedyn Query Row count1<------------------------------------------------------------------------------------------------------------------------> Y|CA|000519|1 11-08-2022 14:24:03:ValidationRequest(): Log:Validation Request DetailsCIUBH22223316781|001002000519 <------------------------Started ValidationRequest CBS A/C No : 001002000519 ------------------------> <------------------------------------------------------------------------------------------------------------------------> ValidationRequest Execution Success with response : 000 <------------------------------------------------------------------------------------------------------------------------> 11-08-2022 14:28:14:ShowCBSAcNo(). Log: TranProcess.cs: ShowCBSAcNo() Query: SELECT SUBSTR ('001002000519', 0, brlength) branch, SUBSTR ('001002000519', brlength+1, schlength) linksno, SUBSTR ('001002000519', -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|000519|CA|1 11-08-2022 14:28:14:Validation Account Proce Executed with out error <------------------------------------------------------------------------------------------------------------------------> ValidateAcNo CBS A/C No : 001002000519 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 = 000519ValidationAcNo.cs: Closedyn Query Row count1<------------------------------------------------------------------------------------------------------------------------> Y|CA|000519|1 11-08-2022 14:28:14:TranProcess.cs: Inward_process() UTR ValidationSELECT remit_utr FROM rtgsinwardrequest WHERE Trim(remit_utr) = 'CIUBH22223316781' 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, 'CIUBH22223316781','BRAMARAMBA T G','001002000519','SRI GURU TRADERS', '512120020028491','CIUB0000082','UTIB0SMCBL1',500000,'123')TranProcess.cs: Inward_process(): 001002000519 CIUBH22223316781 Status : 000 11-08-2022 14:28:14:<------------------------------------------------------------------------------------------------------------------------> <-----------------------STARTED CONFIRMATION REQUEST PROCESS FOR THE DETAILS : CIUBH22223316781|001002000519 --------------------------> <------------------------------------------------------------------------------------------------------------------------> ConfirmationReq Execution Success with Status 000 <-----------------------END CONFIRMATION REQUEST PROCESS FOR THE DETAILS : CIUBH22223316781|001002000519 ------------------------------> <------------------------------------------------------------------------------------------------------------------------> 11-08-2022 14:45:38:ShowCBSAcNo(). Log: TranProcess.cs: ShowCBSAcNo() Query: SELECT SUBSTR ('001002001149', 0, brlength) branch, SUBSTR ('001002001149', brlength+1, schlength) linksno, SUBSTR ('001002001149', -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|001149|CA|1 11-08-2022 14:45:38:Validation Account Proce Executed with out error <------------------------------------------------------------------------------------------------------------------------> ValidateAcNo CBS A/C No : 001002001149 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 = 001149ValidationAcNo.cs: Closedyn Query Row count1<------------------------------------------------------------------------------------------------------------------------> Y|CA|001149|1 11-08-2022 14:45:38:TranProcess.cs: Inward_process() UTR ValidationSELECT remit_utr FROM rtgsinwardrequest WHERE Trim(remit_utr) = 'AXSK222230005166' 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, 'AXSK222230005166','SUDARSHAN GAS HOME APPLIANCES','001002001149','ANANTHAPADMANABHA COCONUT INDUSTRY', '921020007688599','UTIB0001123','UTIB0SMCBL1',11250,'123')TranProcess.cs: Inward_process(): 001002001149 AXSK222230005166 Status : 000 11-08-2022 14:45:38:<------------------------------------------------------------------------------------------------------------------------> <-----------------------STARTED CONFIRMATION REQUEST PROCESS FOR THE DETAILS : AXSK222230005166|001002001149 --------------------------> <------------------------------------------------------------------------------------------------------------------------> ConfirmationReq Execution Success with Status 000 <-----------------------END CONFIRMATION REQUEST PROCESS FOR THE DETAILS : AXSK222230005166|001002001149 ------------------------------> <------------------------------------------------------------------------------------------------------------------------> 11-08-2022 16:24:31:ShowCBSAcNo(). Log: TranProcess.cs: ShowCBSAcNo() Query: SELECT SUBSTR ('001002000409', 0, brlength) branch, SUBSTR ('001002000409', brlength+1, schlength) linksno, SUBSTR ('001002000409', -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|000409|CA|1 11-08-2022 16:24:31:Validation Account Proce Executed with out error <------------------------------------------------------------------------------------------------------------------------> ValidateAcNo CBS A/C No : 001002000409 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 = 000409ValidationAcNo.cs: Closedyn Query Row count1<------------------------------------------------------------------------------------------------------------------------> Y|CA|000409|1 11-08-2022 16:24:31:ValidationRequest(): Log:Validation Request DetailsBARBR22223992976|001002000409 <------------------------Started ValidationRequest CBS A/C No : 001002000409 ------------------------> <------------------------------------------------------------------------------------------------------------------------> ValidationRequest Execution Success with response : 000 <------------------------------------------------------------------------------------------------------------------------> 11-08-2022 17:16:56:ShowCBSAcNo(). Log: TranProcess.cs: ShowCBSAcNo() Query: SELECT SUBSTR ('001002000409', 0, brlength) branch, SUBSTR ('001002000409', brlength+1, schlength) linksno, SUBSTR ('001002000409', -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|000409|CA|1 11-08-2022 17:16:56:Validation Account Proce Executed with out error <------------------------------------------------------------------------------------------------------------------------> ValidateAcNo CBS A/C No : 001002000409 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 = 000409ValidationAcNo.cs: Closedyn Query Row count1<------------------------------------------------------------------------------------------------------------------------> Y|CA|000409|1 11-08-2022 17:16:56:TranProcess.cs: Inward_process() UTR ValidationSELECT remit_utr FROM rtgsinwardrequest WHERE Trim(remit_utr) = 'BARBR22223992976' 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, 'BARBR22223992976','P RAVI','001002000409','BOB', '50060021211001','BARB0TIPTUR','UTIB0SMCBL1',15572,'123')TranProcess.cs: Inward_process(): 001002000409 BARBR22223992976 Status : 000 11-08-2022 17:16:56:<------------------------------------------------------------------------------------------------------------------------> <-----------------------STARTED CONFIRMATION REQUEST PROCESS FOR THE DETAILS : BARBR22223992976|001002000409 --------------------------> <------------------------------------------------------------------------------------------------------------------------> ConfirmationReq Execution Success with Status 000 <-----------------------END CONFIRMATION REQUEST PROCESS FOR THE DETAILS : BARBR22223992976|001002000409 ------------------------------> <------------------------------------------------------------------------------------------------------------------------> 11-08-2022 19:44:17:ShowCBSAcNo(). Log: TranProcess.cs: ShowCBSAcNo() Query: SELECT SUBSTR ('001030001072', 0, brlength) branch, SUBSTR ('001030001072', brlength+1, schlength) linksno, SUBSTR ('001030001072', -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|001072|CHL|1 11-08-2022 19:44:17:Validation Account Proce Executed with out error <------------------------------------------------------------------------------------------------------------------------> ValidateAcNo CBS A/C No : 001030001072 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 = 001072ValidationAcNo.cs: Closedyn Query Row count1<------------------------------------------------------------------------------------------------------------------------> Y|CHL|001072|1 11-08-2022 19:44:17:ValidationRequest(): Log:Validation Request DetailsSBIN322223002926|001030001072 <------------------------Started ValidationRequest CBS A/C No : 001030001072 ------------------------> <------------------------------------------------------------------------------------------------------------------------> ValidationRequest Execution Success with response : 000 <------------------------------------------------------------------------------------------------------------------------> 11-08-2022 19:47:27:ShowCBSAcNo(). Log: TranProcess.cs: ShowCBSAcNo() Query: SELECT SUBSTR ('001030001072', 0, brlength) branch, SUBSTR ('001030001072', brlength+1, schlength) linksno, SUBSTR ('001030001072', -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|001072|CHL|1 11-08-2022 19:47:27:Validation Account Proce Executed with out error <------------------------------------------------------------------------------------------------------------------------> ValidateAcNo CBS A/C No : 001030001072 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 = 001072ValidationAcNo.cs: Closedyn Query Row count1<------------------------------------------------------------------------------------------------------------------------> Y|CHL|001072|1 11-08-2022 19:47:27:ValidationRequest(): Log:Validation Request DetailsSBIN322223002112|001030001072 <------------------------Started ValidationRequest CBS A/C No : 001030001072 ------------------------> <------------------------------------------------------------------------------------------------------------------------> ValidationRequest Execution Success with response : 000 <------------------------------------------------------------------------------------------------------------------------> 11-08-2022 20:03:37:ShowCBSAcNo(). Log: TranProcess.cs: ShowCBSAcNo() Query: SELECT SUBSTR ('001030001072', 0, brlength) branch, SUBSTR ('001030001072', brlength+1, schlength) linksno, SUBSTR ('001030001072', -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|001072|CHL|1 11-08-2022 20:03:37:Validation Account Proce Executed with out error <------------------------------------------------------------------------------------------------------------------------> ValidateAcNo CBS A/C No : 001030001072 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 = 001072ValidationAcNo.cs: Closedyn Query Row count1<------------------------------------------------------------------------------------------------------------------------> Y|CHL|001072|1 11-08-2022 20:03:37:TranProcess.cs: Inward_process() UTR ValidationSELECT remit_utr FROM rtgsinwardrequest WHERE Trim(remit_utr) = 'SBIN322223002926' 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, 'SBIN322223002926','SURENDRA J','001030001072','VIGNESH MOTORS', '00000064065079402','SBIN0007500','UTIB0SMCBL1',1000000,'123')TranProcess.cs: Inward_process(): 001030001072 SBIN322223002926 Status : 000 11-08-2022 20:03:37:<------------------------------------------------------------------------------------------------------------------------> <-----------------------STARTED CONFIRMATION REQUEST PROCESS FOR THE DETAILS : SBIN322223002926|001030001072 --------------------------> <------------------------------------------------------------------------------------------------------------------------> ConfirmationReq Execution Success with Status 000 <-----------------------END CONFIRMATION REQUEST PROCESS FOR THE DETAILS : SBIN322223002926|001030001072 ------------------------------> <------------------------------------------------------------------------------------------------------------------------> 11-08-2022 20:06:59:ShowCBSAcNo(). Log: TranProcess.cs: ShowCBSAcNo() Query: SELECT SUBSTR ('001030001072', 0, brlength) branch, SUBSTR ('001030001072', brlength+1, schlength) linksno, SUBSTR ('001030001072', -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|001072|CHL|1 11-08-2022 20:06:59:Validation Account Proce Executed with out error <------------------------------------------------------------------------------------------------------------------------> ValidateAcNo CBS A/C No : 001030001072 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 = 001072ValidationAcNo.cs: Closedyn Query Row count1<------------------------------------------------------------------------------------------------------------------------> Y|CHL|001072|1 11-08-2022 20:06:59:TranProcess.cs: Inward_process() UTR ValidationSELECT remit_utr FROM rtgsinwardrequest WHERE Trim(remit_utr) = 'SBIN322223002112' 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, 'SBIN322223002112','SURENDRA J','001030001072','VIGNESH MOTORS', '00000064065079402','SBIN0007500','UTIB0SMCBL1',635000,'123')TranProcess.cs: Inward_process(): 001030001072 SBIN322223002112 Status : 000 11-08-2022 20:06:59:<------------------------------------------------------------------------------------------------------------------------> <-----------------------STARTED CONFIRMATION REQUEST PROCESS FOR THE DETAILS : SBIN322223002112|001030001072 --------------------------> <------------------------------------------------------------------------------------------------------------------------> ConfirmationReq Execution Success with Status 000 <-----------------------END CONFIRMATION REQUEST PROCESS FOR THE DETAILS : SBIN322223002112|001030001072 ------------------------------> <------------------------------------------------------------------------------------------------------------------------>