12-09-2023 08:45:22:ShowCBSAcNo(). Log: TranProcess.cs: ShowCBSAcNo() Query: SELECT SUBSTR ('001001003175', 0, brlength) branch, SUBSTR ('001001003175', brlength+1, schlength) linksno, SUBSTR ('001001003175', -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|003175|SB|1

12-09-2023 08:45:22:Validation Account Proce Executed with out error <------------------------------------------------------------------------------------------------------------------------>
ValidateAcNo CBS A/C No : 001001003175
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 = 003175ValidationAcNo.cs: Closedyn Query Row count1<------------------------------------------------------------------------------------------------------------------------>
Y|SB|003175|1
12-09-2023 08:45:22:ValidationRequest(): Log:Validation Request DetailsBKIDN23255406973|001001003175 
<------------------------Started ValidationRequest CBS A/C No : 001001003175 ------------------------>
<------------------------------------------------------------------------------------------------------------------------>
ValidationRequest Execution Success with response :  000
<------------------------------------------------------------------------------------------------------------------------>

12-09-2023 09:14:43:ShowCBSAcNo(). Log: TranProcess.cs: ShowCBSAcNo() Query: SELECT SUBSTR ('001001003175', 0, brlength) branch, SUBSTR ('001001003175', brlength+1, schlength) linksno, SUBSTR ('001001003175', -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|003175|SB|1

12-09-2023 09:14:43:Validation Account Proce Executed with out error <------------------------------------------------------------------------------------------------------------------------>
ValidateAcNo CBS A/C No : 001001003175
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 = 003175ValidationAcNo.cs: Closedyn Query Row count1<------------------------------------------------------------------------------------------------------------------------>
Y|SB|003175|1
12-09-2023 09:14:43:TranProcess.cs: Inward_process() UTR ValidationSELECT remit_utr FROM rtgsinwardrequest WHERE Trim(remit_utr) = 'BKIDN23255406973'
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, 'BKIDN23255406973','HARISH','001001003175','HARISHA T M S O MANJUNATH', '846810310000098','BKID0009204','UTIB0SMCBL1',2000,'123')TranProcess.cs: Inward_process(): 001001003175 BKIDN23255406973  Status : 000

12-09-2023 09:14:43:<------------------------------------------------------------------------------------------------------------------------>
<-----------------------STARTED CONFIRMATION REQUEST PROCESS FOR THE DETAILS : BKIDN23255406973|001001003175 -------------------------->
<------------------------------------------------------------------------------------------------------------------------>
ConfirmationReq Execution Success with Status 000
<-----------------------END CONFIRMATION REQUEST PROCESS FOR THE DETAILS : BKIDN23255406973|001001003175 ------------------------------>
<------------------------------------------------------------------------------------------------------------------------>

12-09-2023 10:55:37:ShowCBSAcNo(). Log: TranProcess.cs: ShowCBSAcNo() Query: SELECT SUBSTR ('001001003175', 0, brlength) branch, SUBSTR ('001001003175', brlength+1, schlength) linksno, SUBSTR ('001001003175', -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|003175|SB|1

12-09-2023 10:55:37:Validation Account Proce Executed with out error <------------------------------------------------------------------------------------------------------------------------>
ValidateAcNo CBS A/C No : 001001003175
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 = 003175ValidationAcNo.cs: Closedyn Query Row count1<------------------------------------------------------------------------------------------------------------------------>
Y|SB|003175|1
12-09-2023 10:55:37:ValidationRequest(): Log:Validation Request DetailsBKIDN23255450403|001001003175 
<------------------------Started ValidationRequest CBS A/C No : 001001003175 ------------------------>
<------------------------------------------------------------------------------------------------------------------------>
ValidationRequest Execution Success with response :  000
<------------------------------------------------------------------------------------------------------------------------>

12-09-2023 11:16:29:ShowCBSAcNo(). Log: TranProcess.cs: ShowCBSAcNo() Query: SELECT SUBSTR ('001001003175', 0, brlength) branch, SUBSTR ('001001003175', brlength+1, schlength) linksno, SUBSTR ('001001003175', -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|003175|SB|1

12-09-2023 11:16:29:Validation Account Proce Executed with out error <------------------------------------------------------------------------------------------------------------------------>
ValidateAcNo CBS A/C No : 001001003175
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 = 003175ValidationAcNo.cs: Closedyn Query Row count1<------------------------------------------------------------------------------------------------------------------------>
Y|SB|003175|1
12-09-2023 11:16:29:TranProcess.cs: Inward_process() UTR ValidationSELECT remit_utr FROM rtgsinwardrequest WHERE Trim(remit_utr) = 'BKIDN23255450403'
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, 'BKIDN23255450403','HARISH','001001003175','HARISHA T M S O MANJUNATH', '846810310000098','BKID0000200','UTIB0SMCBL1',1500,'123')TranProcess.cs: Inward_process(): 001001003175 BKIDN23255450403  Status : 000

12-09-2023 11:16:29:<------------------------------------------------------------------------------------------------------------------------>
<-----------------------STARTED CONFIRMATION REQUEST PROCESS FOR THE DETAILS : BKIDN23255450403|001001003175 -------------------------->
<------------------------------------------------------------------------------------------------------------------------>
ConfirmationReq Execution Success with Status 000
<-----------------------END CONFIRMATION REQUEST PROCESS FOR THE DETAILS : BKIDN23255450403|001001003175 ------------------------------>
<------------------------------------------------------------------------------------------------------------------------>

12-09-2023 11:50:05:ShowCBSAcNo(). Log: TranProcess.cs: ShowCBSAcNo() Query: SELECT SUBSTR ('001001001959', 0, brlength) branch, SUBSTR ('001001001959', brlength+1, schlength) linksno, SUBSTR ('001001001959', -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|001959|SB|1

12-09-2023 11:50:05:Validation Account Proce Executed with out error <------------------------------------------------------------------------------------------------------------------------>
ValidateAcNo CBS A/C No : 001001001959
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 = 001959ValidationAcNo.cs: Closedyn Query Row count1<------------------------------------------------------------------------------------------------------------------------>
Y|SB|001959|1
12-09-2023 11:50:05:ValidationRequest(): Log:Validation Request DetailsAXOMB32552815132|001001001959 
<------------------------Started ValidationRequest CBS A/C No : 001001001959 ------------------------>
<------------------------------------------------------------------------------------------------------------------------>
ValidationRequest Execution Success with response :  000
<------------------------------------------------------------------------------------------------------------------------>

12-09-2023 11:56:48:ShowCBSAcNo(). Log: TranProcess.cs: ShowCBSAcNo() Query: SELECT SUBSTR ('001030001080', 0, brlength) branch, SUBSTR ('001030001080', brlength+1, schlength) linksno, SUBSTR ('001030001080', -aclength) acno FROM (SELECT a.sitp_doublevalue AS iinlenth, a.sitp_longvalue AS iin, b.sitp_doublevalue AS brlength, c.sitp_doublevalue AS schlength, d.sitp_doublevalue AS aclength FROM (SELECT 1 sno, sitp_doublevalue, sitp_longvalue FROM head.siteparameters WHERE sitp_name = 'IIN NUMBER') a, (SELECT 1 sno, sitp_doublevalue FROM head.siteparameters WHERE sitp_name = 'BRANCH CODE') b, (SELECT 1 sno, sitp_doublevalue FROM head.siteparameters WHERE sitp_name = 'SCHEME CODE') c, (SELECT 1 sno, sitp_doublevalue FROM head.siteparameters WHERE sitp_name = 'ACCOUNT NO') d WHERE a.sno = b.sno AND c.sno = a.sno AND d.sno = a.sno)
TranProcess.cs: Fetch Query Row Count dtSplitCBSNo: 1
TranProcess.cs: Linkmain Query  SELECT link_type, link_abbrev, bran_name, bran_sno FROM linkmain, MASTER.branch WHERE link_sno = 030 AND bran_sno = 001
TranProcess.cs: Linkmain Query Row Count dtTemp: 1
ShowCBS Ac No Proce Executed  HEAD OFFICE|OD|001080|CHL|1

12-09-2023 11:56:48:Validation Account Proce Executed with out error <------------------------------------------------------------------------------------------------------------------------>
ValidateAcNo CBS A/C No : 001030001080
ValidationAcNo.cs: Query TO Fetch() SELECT clms_des, clms_sno, NVL (odmt_closedyn, 'N') AS closedyn, odmt_closedate, odmt_smsregyn AS smsreg FROM clientmaster, odmaster WHERE clms_sno = odmt_client AND NVL(odmt_closedyn, 'N') = 'N' AND odmt_branch = 1 AND TRIM (odmt_abbr) = 'CHL' AND odmt_no = 001080ValidationAcNo.cs: Closedyn Query Row count1<------------------------------------------------------------------------------------------------------------------------>
Y|CHL|001080|1
12-09-2023 11:56:48:ValidationRequest(): Log:Validation Request DetailsTGMBN23255064016|001030001080 
<------------------------Started ValidationRequest CBS A/C No : 001030001080 ------------------------>
<------------------------------------------------------------------------------------------------------------------------>
ValidationRequest Execution Success with response :  000
<------------------------------------------------------------------------------------------------------------------------>

12-09-2023 12:00:33:ShowCBSAcNo(). Log: TranProcess.cs: ShowCBSAcNo() Query: SELECT SUBSTR ('001017000035', 0, brlength) branch, SUBSTR ('001017000035', brlength+1, schlength) linksno, SUBSTR ('001017000035', -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 = 017 AND bran_sno = 001
TranProcess.cs: Linkmain Query Row Count dtTemp: 1
ShowCBS Ac No Proce Executed  HEAD OFFICE|LOAN|000035|HCL|1

12-09-2023 12:00:33:Validation Account Proce Executed with out error <------------------------------------------------------------------------------------------------------------------------>
ValidateAcNo CBS A/C No : 001017000035
ValidationAcNo.cs: Query TO Fetch() SELECT clms_des, clms_sno, NVL (loam_closedyn, 'N') AS closedyn, loam_closedate, loam_smsregyn AS smsreg FROM clientmaster, loanmaster WHERE clms_sno = loam_client AND NVL(loam_closedyn, 'N') = 'N' AND loam_branch = 1 AND TRIM (loam_abbr) = 'HCL' AND loam_no = 000035ValidationAcNo.cs: Closedyn Query Row count1<------------------------------------------------------------------------------------------------------------------------>
Y|HCL|000035|1
12-09-2023 12:00:33:ValidationRequest(): Log:Validation Request DetailsAXOMB32552819559|001017000035 
<------------------------Started ValidationRequest CBS A/C No : 001017000035 ------------------------>
<------------------------------------------------------------------------------------------------------------------------>
ValidationRequest Execution Success with response :  000
<------------------------------------------------------------------------------------------------------------------------>

12-09-2023 12:14:29:ShowCBSAcNo(). Log: TranProcess.cs: ShowCBSAcNo() Query: SELECT SUBSTR ('001001001959', 0, brlength) branch, SUBSTR ('001001001959', brlength+1, schlength) linksno, SUBSTR ('001001001959', -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|001959|SB|1

12-09-2023 12:14:29:Validation Account Proce Executed with out error <------------------------------------------------------------------------------------------------------------------------>
ValidateAcNo CBS A/C No : 001001001959
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 = 001959ValidationAcNo.cs: Closedyn Query Row count1<------------------------------------------------------------------------------------------------------------------------>
Y|SB|001959|1
12-09-2023 12:14:29:TranProcess.cs: Inward_process() UTR ValidationSELECT remit_utr FROM rtgsinwardrequest WHERE Trim(remit_utr) = 'AXOMB32552815132'
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, 'AXOMB32552815132','ramesh gs','001001001959','S S JEWELLERS', '917020015812389','UTIB0001123','UTIB0SMCBL1',50000,'123')TranProcess.cs: Inward_process(): 001001001959 AXOMB32552815132  Status : 000

12-09-2023 12:14:29:<------------------------------------------------------------------------------------------------------------------------>
<-----------------------STARTED CONFIRMATION REQUEST PROCESS FOR THE DETAILS : AXOMB32552815132|001001001959 -------------------------->
<------------------------------------------------------------------------------------------------------------------------>
ConfirmationReq Execution Success with Status 000
<-----------------------END CONFIRMATION REQUEST PROCESS FOR THE DETAILS : AXOMB32552815132|001001001959 ------------------------------>
<------------------------------------------------------------------------------------------------------------------------>

12-09-2023 12:15:54:ShowCBSAcNo(). Log: TranProcess.cs: ShowCBSAcNo() Query: SELECT SUBSTR ('001030001080', 0, brlength) branch, SUBSTR ('001030001080', brlength+1, schlength) linksno, SUBSTR ('001030001080', -aclength) acno FROM (SELECT a.sitp_doublevalue AS iinlenth, a.sitp_longvalue AS iin, b.sitp_doublevalue AS brlength, c.sitp_doublevalue AS schlength, d.sitp_doublevalue AS aclength FROM (SELECT 1 sno, sitp_doublevalue, sitp_longvalue FROM head.siteparameters WHERE sitp_name = 'IIN NUMBER') a, (SELECT 1 sno, sitp_doublevalue FROM head.siteparameters WHERE sitp_name = 'BRANCH CODE') b, (SELECT 1 sno, sitp_doublevalue FROM head.siteparameters WHERE sitp_name = 'SCHEME CODE') c, (SELECT 1 sno, sitp_doublevalue FROM head.siteparameters WHERE sitp_name = 'ACCOUNT NO') d WHERE a.sno = b.sno AND c.sno = a.sno AND d.sno = a.sno)
TranProcess.cs: Fetch Query Row Count dtSplitCBSNo: 1
TranProcess.cs: Linkmain Query  SELECT link_type, link_abbrev, bran_name, bran_sno FROM linkmain, MASTER.branch WHERE link_sno = 030 AND bran_sno = 001
TranProcess.cs: Linkmain Query Row Count dtTemp: 1
ShowCBS Ac No Proce Executed  HEAD OFFICE|OD|001080|CHL|1

12-09-2023 12:15:54:Validation Account Proce Executed with out error <------------------------------------------------------------------------------------------------------------------------>
ValidateAcNo CBS A/C No : 001030001080
ValidationAcNo.cs: Query TO Fetch() SELECT clms_des, clms_sno, NVL (odmt_closedyn, 'N') AS closedyn, odmt_closedate, odmt_smsregyn AS smsreg FROM clientmaster, odmaster WHERE clms_sno = odmt_client AND NVL(odmt_closedyn, 'N') = 'N' AND odmt_branch = 1 AND TRIM (odmt_abbr) = 'CHL' AND odmt_no = 001080ValidationAcNo.cs: Closedyn Query Row count1<------------------------------------------------------------------------------------------------------------------------>
Y|CHL|001080|1
12-09-2023 12:15:54:TranProcess.cs: Inward_process() UTR ValidationSELECT remit_utr FROM rtgsinwardrequest WHERE Trim(remit_utr) = 'TGMBN23255064016'
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, 'TGMBN23255064016','G S RAMESH','001030001080','GANIGARA SRIRAMA MANDIRA SEVA', '00000030304992791','TGMB0000006','UTIB0SMCBL1',34100,'123')TranProcess.cs: Inward_process(): 001030001080 TGMBN23255064016  Status : 000

12-09-2023 12:15:54:<------------------------------------------------------------------------------------------------------------------------>
<-----------------------STARTED CONFIRMATION REQUEST PROCESS FOR THE DETAILS : TGMBN23255064016|001030001080 -------------------------->
<------------------------------------------------------------------------------------------------------------------------>
ConfirmationReq Execution Success with Status 000
<-----------------------END CONFIRMATION REQUEST PROCESS FOR THE DETAILS : TGMBN23255064016|001030001080 ------------------------------>
<------------------------------------------------------------------------------------------------------------------------>

12-09-2023 12:16:49:ShowCBSAcNo(). Log: TranProcess.cs: ShowCBSAcNo() Query: SELECT SUBSTR ('001017000035', 0, brlength) branch, SUBSTR ('001017000035', brlength+1, schlength) linksno, SUBSTR ('001017000035', -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 = 017 AND bran_sno = 001
TranProcess.cs: Linkmain Query Row Count dtTemp: 1
ShowCBS Ac No Proce Executed  HEAD OFFICE|LOAN|000035|HCL|1

12-09-2023 12:16:49:Validation Account Proce Executed with out error <------------------------------------------------------------------------------------------------------------------------>
ValidateAcNo CBS A/C No : 001017000035
ValidationAcNo.cs: Query TO Fetch() SELECT clms_des, clms_sno, NVL (loam_closedyn, 'N') AS closedyn, loam_closedate, loam_smsregyn AS smsreg FROM clientmaster, loanmaster WHERE clms_sno = loam_client AND NVL(loam_closedyn, 'N') = 'N' AND loam_branch = 1 AND TRIM (loam_abbr) = 'HCL' AND loam_no = 000035ValidationAcNo.cs: Closedyn Query Row count1<------------------------------------------------------------------------------------------------------------------------>
Y|HCL|000035|1
12-09-2023 12:16:49:TranProcess.cs: Inward_process() UTR ValidationSELECT remit_utr FROM rtgsinwardrequest WHERE Trim(remit_utr) = 'AXOMB32552819559'
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, 'AXOMB32552819559','Amma','001017000035','MANJU ENTERPRISES', '921020041225051','UTIB0001123','UTIB0SMCBL1',20000,'123')TranProcess.cs: Inward_process(): 001017000035 AXOMB32552819559  Status : 000

12-09-2023 12:16:49:<------------------------------------------------------------------------------------------------------------------------>
<-----------------------STARTED CONFIRMATION REQUEST PROCESS FOR THE DETAILS : AXOMB32552819559|001017000035 -------------------------->
<------------------------------------------------------------------------------------------------------------------------>
ConfirmationReq Execution Success with Status 000
<-----------------------END CONFIRMATION REQUEST PROCESS FOR THE DETAILS : AXOMB32552819559|001017000035 ------------------------------>
<------------------------------------------------------------------------------------------------------------------------>

12-09-2023 12:34:06:ShowCBSAcNo(). Log: TranProcess.cs: ShowCBSAcNo() Query: SELECT SUBSTR ('001001003175', 0, brlength) branch, SUBSTR ('001001003175', brlength+1, schlength) linksno, SUBSTR ('001001003175', -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|003175|SB|1

12-09-2023 12:34:06:Validation Account Proce Executed with out error <------------------------------------------------------------------------------------------------------------------------>
ValidateAcNo CBS A/C No : 001001003175
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 = 003175ValidationAcNo.cs: Closedyn Query Row count1<------------------------------------------------------------------------------------------------------------------------>
Y|SB|003175|1
12-09-2023 12:34:06:ValidationRequest(): Log:Validation Request DetailsBKIDN23255507198|001001003175 
<------------------------Started ValidationRequest CBS A/C No : 001001003175 ------------------------>
<------------------------------------------------------------------------------------------------------------------------>
ValidationRequest Execution Success with response :  000
<------------------------------------------------------------------------------------------------------------------------>

12-09-2023 12:44:58:ShowCBSAcNo(). Log: TranProcess.cs: ShowCBSAcNo() Query: SELECT SUBSTR ('001001003175', 0, brlength) branch, SUBSTR ('001001003175', brlength+1, schlength) linksno, SUBSTR ('001001003175', -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|003175|SB|1

12-09-2023 12:44:58:Validation Account Proce Executed with out error <------------------------------------------------------------------------------------------------------------------------>
ValidateAcNo CBS A/C No : 001001003175
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 = 003175ValidationAcNo.cs: Closedyn Query Row count1<------------------------------------------------------------------------------------------------------------------------>
Y|SB|003175|1
12-09-2023 12:44:58:TranProcess.cs: Inward_process() UTR ValidationSELECT remit_utr FROM rtgsinwardrequest WHERE Trim(remit_utr) = 'BKIDN23255507198'
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, 'BKIDN23255507198','HARISH','001001003175','HARISHA T M S O MANJUNATH', '846810310000098','BKID0000200','UTIB0SMCBL1',1500,'123')TranProcess.cs: Inward_process(): 001001003175 BKIDN23255507198  Status : 000

12-09-2023 12:44:58:<------------------------------------------------------------------------------------------------------------------------>
<-----------------------STARTED CONFIRMATION REQUEST PROCESS FOR THE DETAILS : BKIDN23255507198|001001003175 -------------------------->
<------------------------------------------------------------------------------------------------------------------------>
ConfirmationReq Execution Success with Status 000
<-----------------------END CONFIRMATION REQUEST PROCESS FOR THE DETAILS : BKIDN23255507198|001001003175 ------------------------------>
<------------------------------------------------------------------------------------------------------------------------>

12-09-2023 12:57:49:ShowCBSAcNo(). Log: TranProcess.cs: ShowCBSAcNo() Query: SELECT SUBSTR ('001001002863', 0, brlength) branch, SUBSTR ('001001002863', brlength+1, schlength) linksno, SUBSTR ('001001002863', -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|002863|SB|1

12-09-2023 12:57:49:Validation Account Proce Executed with out error <------------------------------------------------------------------------------------------------------------------------>
ValidateAcNo CBS A/C No : 001001002863
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 = 002863ValidationAcNo.cs: Closedyn Query Row count1<------------------------------------------------------------------------------------------------------------------------>
Y|SB|002863|1
12-09-2023 12:57:49:ValidationRequest(): Log:Validation Request DetailsKKBKH23255868562|001001002863 
<------------------------Started ValidationRequest CBS A/C No : 001001002863 ------------------------>
<------------------------------------------------------------------------------------------------------------------------>
ValidationRequest Execution Success with response :  000
<------------------------------------------------------------------------------------------------------------------------>

12-09-2023 13:00:11:ShowCBSAcNo(). Log: TranProcess.cs: ShowCBSAcNo() Query: SELECT SUBSTR ('001001002862', 0, brlength) branch, SUBSTR ('001001002862', brlength+1, schlength) linksno, SUBSTR ('001001002862', -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|002862|SB|1

12-09-2023 13:00:11:Validation Account Proce Executed with out error <------------------------------------------------------------------------------------------------------------------------>
ValidateAcNo CBS A/C No : 001001002862
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 = 002862ValidationAcNo.cs: Closedyn Query Row count1<------------------------------------------------------------------------------------------------------------------------>
Y|SB|002862|1
12-09-2023 13:00:11:ValidationRequest(): Log:Validation Request DetailsKKBKH23255869427|001001002862 
<------------------------Started ValidationRequest CBS A/C No : 001001002862 ------------------------>
<------------------------------------------------------------------------------------------------------------------------>
ValidationRequest Execution Success with response :  000
<------------------------------------------------------------------------------------------------------------------------>

12-09-2023 13:02:44:ShowCBSAcNo(). Log: TranProcess.cs: ShowCBSAcNo() Query: SELECT SUBSTR ('001002000866', 0, brlength) branch, SUBSTR ('001002000866', brlength+1, schlength) linksno, SUBSTR ('001002000866', -aclength) acno FROM (SELECT a.sitp_doublevalue AS iinlenth, a.sitp_longvalue AS iin, b.sitp_doublevalue AS brlength, c.sitp_doublevalue AS schlength, d.sitp_doublevalue AS aclength FROM (SELECT 1 sno, sitp_doublevalue, sitp_longvalue FROM head.siteparameters WHERE sitp_name = 'IIN NUMBER') a, (SELECT 1 sno, sitp_doublevalue FROM head.siteparameters WHERE sitp_name = 'BRANCH CODE') b, (SELECT 1 sno, sitp_doublevalue FROM head.siteparameters WHERE sitp_name = 'SCHEME CODE') c, (SELECT 1 sno, sitp_doublevalue FROM head.siteparameters WHERE sitp_name = 'ACCOUNT NO') d WHERE a.sno = b.sno AND c.sno = a.sno AND d.sno = a.sno)
TranProcess.cs: Fetch Query Row Count dtSplitCBSNo: 1
TranProcess.cs: Linkmain Query  SELECT link_type, link_abbrev, bran_name, bran_sno FROM linkmain, MASTER.branch WHERE link_sno = 002 AND bran_sno = 001
TranProcess.cs: Linkmain Query Row Count dtTemp: 1
ShowCBS Ac No Proce Executed  HEAD OFFICE|DEPOSIT|000866|CA|1

12-09-2023 13:02:44:Validation Account Proce Executed with out error <------------------------------------------------------------------------------------------------------------------------>
ValidateAcNo CBS A/C No : 001002000866
ValidationAcNo.cs: Query TO Fetch() SELECT clms_des, clms_sno, NVL (depm_closedyn, 'N') AS closedyn, depm_closedate, depm_smsregyn AS smsreg FROM clientmaster, depositmaster WHERE clms_sno = depm_client AND NVL(depm_closedyn, 'N') = 'N' AND depm_branch = 1 AND TRIM (depm_abbr) = 'CA' AND depm_no = 000866ValidationAcNo.cs: Closedyn Query Row count1<------------------------------------------------------------------------------------------------------------------------>
Y|CA|000866|1
12-09-2023 13:02:44:ValidationRequest(): Log:Validation Request DetailsAXOMB32552847413|001002000866 
<------------------------Started ValidationRequest CBS A/C No : 001002000866 ------------------------>
<------------------------------------------------------------------------------------------------------------------------>
ValidationRequest Execution Success with response :  000
<------------------------------------------------------------------------------------------------------------------------>

12-09-2023 13:14:42:ShowCBSAcNo(). Log: TranProcess.cs: ShowCBSAcNo() Query: SELECT SUBSTR ('001001002863', 0, brlength) branch, SUBSTR ('001001002863', brlength+1, schlength) linksno, SUBSTR ('001001002863', -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|002863|SB|1

12-09-2023 13:14:42:Validation Account Proce Executed with out error <------------------------------------------------------------------------------------------------------------------------>
ValidateAcNo CBS A/C No : 001001002863
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 = 002863ValidationAcNo.cs: Closedyn Query Row count1<------------------------------------------------------------------------------------------------------------------------>
Y|SB|002863|1
12-09-2023 13:14:42:TranProcess.cs: Inward_process() UTR ValidationSELECT remit_utr FROM rtgsinwardrequest WHERE Trim(remit_utr) = 'KKBKH23255868562'
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, 'KKBKH23255868562','P VANIMOHAN','001001002863','P V MOHAN KUMAR', '332010204976','KKBK0000958','UTIB0SMCBL1',500,'123')TranProcess.cs: Inward_process(): 001001002863 KKBKH23255868562  Status : 000

12-09-2023 13:14:42:<------------------------------------------------------------------------------------------------------------------------>
<-----------------------STARTED CONFIRMATION REQUEST PROCESS FOR THE DETAILS : KKBKH23255868562|001001002863 -------------------------->
<------------------------------------------------------------------------------------------------------------------------>
ConfirmationReq Execution Success with Status 000
<-----------------------END CONFIRMATION REQUEST PROCESS FOR THE DETAILS : KKBKH23255868562|001001002863 ------------------------------>
<------------------------------------------------------------------------------------------------------------------------>

12-09-2023 13:15:12:ShowCBSAcNo(). Log: TranProcess.cs: ShowCBSAcNo() Query: SELECT SUBSTR ('001001002862', 0, brlength) branch, SUBSTR ('001001002862', brlength+1, schlength) linksno, SUBSTR ('001001002862', -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|002862|SB|1

12-09-2023 13:15:12:Validation Account Proce Executed with out error <------------------------------------------------------------------------------------------------------------------------>
ValidateAcNo CBS A/C No : 001001002862
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 = 002862ValidationAcNo.cs: Closedyn Query Row count1<------------------------------------------------------------------------------------------------------------------------>
Y|SB|002862|1
12-09-2023 13:15:13:TranProcess.cs: Inward_process() UTR ValidationSELECT remit_utr FROM rtgsinwardrequest WHERE Trim(remit_utr) = 'KKBKH23255869427'
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, 'KKBKH23255869427','MOHANKUMAR P V','001001002862','P V MOHAN KUMAR', '332010204976','KKBK0000958','UTIB0SMCBL1',500,'123')TranProcess.cs: Inward_process(): 001001002862 KKBKH23255869427  Status : 000

12-09-2023 13:15:13:<------------------------------------------------------------------------------------------------------------------------>
<-----------------------STARTED CONFIRMATION REQUEST PROCESS FOR THE DETAILS : KKBKH23255869427|001001002862 -------------------------->
<------------------------------------------------------------------------------------------------------------------------>
ConfirmationReq Execution Success with Status 000
<-----------------------END CONFIRMATION REQUEST PROCESS FOR THE DETAILS : KKBKH23255869427|001001002862 ------------------------------>
<------------------------------------------------------------------------------------------------------------------------>

12-09-2023 13:15:44:ShowCBSAcNo(). Log: TranProcess.cs: ShowCBSAcNo() Query: SELECT SUBSTR ('001002000866', 0, brlength) branch, SUBSTR ('001002000866', brlength+1, schlength) linksno, SUBSTR ('001002000866', -aclength) acno FROM (SELECT a.sitp_doublevalue AS iinlenth, a.sitp_longvalue AS iin, b.sitp_doublevalue AS brlength, c.sitp_doublevalue AS schlength, d.sitp_doublevalue AS aclength FROM (SELECT 1 sno, sitp_doublevalue, sitp_longvalue FROM head.siteparameters WHERE sitp_name = 'IIN NUMBER') a, (SELECT 1 sno, sitp_doublevalue FROM head.siteparameters WHERE sitp_name = 'BRANCH CODE') b, (SELECT 1 sno, sitp_doublevalue FROM head.siteparameters WHERE sitp_name = 'SCHEME CODE') c, (SELECT 1 sno, sitp_doublevalue FROM head.siteparameters WHERE sitp_name = 'ACCOUNT NO') d WHERE a.sno = b.sno AND c.sno = a.sno AND d.sno = a.sno)
TranProcess.cs: Fetch Query Row Count dtSplitCBSNo: 1
TranProcess.cs: Linkmain Query  SELECT link_type, link_abbrev, bran_name, bran_sno FROM linkmain, MASTER.branch WHERE link_sno = 002 AND bran_sno = 001
TranProcess.cs: Linkmain Query Row Count dtTemp: 1
ShowCBS Ac No Proce Executed  HEAD OFFICE|DEPOSIT|000866|CA|1

12-09-2023 13:15:44:Validation Account Proce Executed with out error <------------------------------------------------------------------------------------------------------------------------>
ValidateAcNo CBS A/C No : 001002000866
ValidationAcNo.cs: Query TO Fetch() SELECT clms_des, clms_sno, NVL (depm_closedyn, 'N') AS closedyn, depm_closedate, depm_smsregyn AS smsreg FROM clientmaster, depositmaster WHERE clms_sno = depm_client AND NVL(depm_closedyn, 'N') = 'N' AND depm_branch = 1 AND TRIM (depm_abbr) = 'CA' AND depm_no = 000866ValidationAcNo.cs: Closedyn Query Row count1<------------------------------------------------------------------------------------------------------------------------>
Y|CA|000866|1
12-09-2023 13:15:44:TranProcess.cs: Inward_process() UTR ValidationSELECT remit_utr FROM rtgsinwardrequest WHERE Trim(remit_utr) = 'AXOMB32552847413'
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, 'AXOMB32552847413','T B Jayadevappa','001002000866','THIRUMALA TRADERS', '916030018259174','UTIB0001123','UTIB0SMCBL1',79768,'123')TranProcess.cs: Inward_process(): 001002000866 AXOMB32552847413  Status : 000

12-09-2023 13:15:44:<------------------------------------------------------------------------------------------------------------------------>
<-----------------------STARTED CONFIRMATION REQUEST PROCESS FOR THE DETAILS : AXOMB32552847413|001002000866 -------------------------->
<------------------------------------------------------------------------------------------------------------------------>
ConfirmationReq Execution Success with Status 000
<-----------------------END CONFIRMATION REQUEST PROCESS FOR THE DETAILS : AXOMB32552847413|001002000866 ------------------------------>
<------------------------------------------------------------------------------------------------------------------------>

12-09-2023 16:43:33:ShowCBSAcNo(). Log: TranProcess.cs: ShowCBSAcNo() Query: SELECT SUBSTR ('001030001092', 0, brlength) branch, SUBSTR ('001030001092', brlength+1, schlength) linksno, SUBSTR ('001030001092', -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|001092|CHL|1

12-09-2023 16:43:33:Validation Account Proce Executed with out error <------------------------------------------------------------------------------------------------------------------------>
ValidateAcNo CBS A/C No : 001030001092
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 = 001092ValidationAcNo.cs: Closedyn Query Row count1<------------------------------------------------------------------------------------------------------------------------>
Y|CHL|001092|1
12-09-2023 16:43:33:ValidationRequest(): Log:Validation Request Details33640622111DC|001030001092 
<------------------------Started ValidationRequest CBS A/C No : 001030001092 ------------------------>
<------------------------------------------------------------------------------------------------------------------------>
ValidationRequest Execution Success with response :  000
<------------------------------------------------------------------------------------------------------------------------>

12-09-2023 17:12:35:ShowCBSAcNo(). Log: TranProcess.cs: ShowCBSAcNo() Query: SELECT SUBSTR ('001030001092', 0, brlength) branch, SUBSTR ('001030001092', brlength+1, schlength) linksno, SUBSTR ('001030001092', -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|001092|CHL|1

12-09-2023 17:12:35:Validation Account Proce Executed with out error <------------------------------------------------------------------------------------------------------------------------>
ValidateAcNo CBS A/C No : 001030001092
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 = 001092ValidationAcNo.cs: Closedyn Query Row count1<------------------------------------------------------------------------------------------------------------------------>
Y|CHL|001092|1
12-09-2023 17:12:35:TranProcess.cs: Inward_process() UTR ValidationSELECT remit_utr FROM rtgsinwardrequest WHERE Trim(remit_utr) = '33640622111DC'
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, '33640622111DC','ABHIJITH MCB OD AC','001030001092','VIJAYALAKSHMI FUEL S', '281305006498','ICIC0SF0002','UTIB0SMCBL1',100000,'123')TranProcess.cs: Inward_process(): 001030001092 33640622111DC  Status : 000

12-09-2023 17:12:35:<------------------------------------------------------------------------------------------------------------------------>
<-----------------------STARTED CONFIRMATION REQUEST PROCESS FOR THE DETAILS : 33640622111DC|001030001092 -------------------------->
<------------------------------------------------------------------------------------------------------------------------>
ConfirmationReq Execution Success with Status 000
<-----------------------END CONFIRMATION REQUEST PROCESS FOR THE DETAILS : 33640622111DC|001030001092 ------------------------------>
<------------------------------------------------------------------------------------------------------------------------>