03-11-2022 00:07:51:ShowCBSAcNo(). Log: TranProcess.cs: ShowCBSAcNo() Query: SELECT SUBSTR ('001037000015', 0, brlength) branch, SUBSTR ('001037000015', brlength+1, schlength) linksno, SUBSTR ('001037000015', -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 = 037 AND bran_sno = 001
TranProcess.cs: Linkmain Query Row Count dtTemp: 1
ShowCBS Ac No Proce Executed  HEAD OFFICE|LOAN|000015|HME|1

03-11-2022 00:07:51:Validation Account Proce Executed with out error <------------------------------------------------------------------------------------------------------------------------>
ValidateAcNo CBS A/C No : 001037000015
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) = 'HME' AND loam_no = 000015ValidationAcNo.cs: Closedyn Query Row count1<------------------------------------------------------------------------------------------------------------------------>
Y|HME|000015|1
03-11-2022 00:07:51:TranProcess.cs: Inward_process() UTR ValidationSELECT remit_utr FROM rtgsinwardrequest WHERE Trim(remit_utr) = '527909632'
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, '527909632','JAMUNA','001037000015','DIVAKAR M S', '055101502173','ICIC0SF0002','UTIB0SMCBL1',30305,'123')TranProcess.cs: Inward_process(): 001037000015 527909632  Status : 000

03-11-2022 00:07:51:<------------------------------------------------------------------------------------------------------------------------>
<-----------------------STARTED CONFIRMATION REQUEST PROCESS FOR THE DETAILS : 527909632|001037000015 -------------------------->
<------------------------------------------------------------------------------------------------------------------------>
ConfirmationReq Execution Success with Status 000
<-----------------------END CONFIRMATION REQUEST PROCESS FOR THE DETAILS : 527909632|001037000015 ------------------------------>
<------------------------------------------------------------------------------------------------------------------------>

03-11-2022 09:02:03:ShowCBSAcNo(). Log: TranProcess.cs: ShowCBSAcNo() Query: SELECT SUBSTR ('001001001410', 0, brlength) branch, SUBSTR ('001001001410', brlength+1, schlength) linksno, SUBSTR ('001001001410', -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|001410|SB|1

03-11-2022 09:02:03:Validation Account Proce Executed with out error <------------------------------------------------------------------------------------------------------------------------>
ValidateAcNo CBS A/C No : 001001001410
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 = 001410ValidationAcNo.cs: Closedyn Query Row count1<------------------------------------------------------------------------------------------------------------------------>
Y|SB|001410|1
03-11-2022 09:02:03:ValidationRequest(): Log:Validation Request Details25-884944441-1|001001001410 
<------------------------Started ValidationRequest CBS A/C No : 001001001410 ------------------------>
<------------------------------------------------------------------------------------------------------------------------>
ValidationRequest Execution Success with response :  000
<------------------------------------------------------------------------------------------------------------------------>

03-11-2022 09:08:11:ShowCBSAcNo(). Log: TranProcess.cs: ShowCBSAcNo() Query: SELECT SUBSTR ('001001001410', 0, brlength) branch, SUBSTR ('001001001410', brlength+1, schlength) linksno, SUBSTR ('001001001410', -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|001410|SB|1

03-11-2022 09:08:11:Validation Account Proce Executed with out error <------------------------------------------------------------------------------------------------------------------------>
ValidateAcNo CBS A/C No : 001001001410
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 = 001410ValidationAcNo.cs: Closedyn Query Row count1<------------------------------------------------------------------------------------------------------------------------>
Y|SB|001410|1
03-11-2022 09:08:11:TranProcess.cs: Inward_process() UTR ValidationSELECT remit_utr FROM rtgsinwardrequest WHERE Trim(remit_utr) = '25-884944441-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-884944441-1','satish','001001001410','S SATHEESH BABU', '333010100057929','','UTIB0SMCBL1',5000,'123')TranProcess.cs: Inward_process(): 001001001410 25-884944441-1  Status : 000

03-11-2022 09:08:11:<------------------------------------------------------------------------------------------------------------------------>
<-----------------------STARTED CONFIRMATION REQUEST PROCESS FOR THE DETAILS : 25-884944441-1|001001001410 -------------------------->
<------------------------------------------------------------------------------------------------------------------------>
ConfirmationReq Execution Success with Status 000
<-----------------------END CONFIRMATION REQUEST PROCESS FOR THE DETAILS : 25-884944441-1|001001001410 ------------------------------>
<------------------------------------------------------------------------------------------------------------------------>

03-11-2022 09:26:30:ShowCBSAcNo(). Log: TranProcess.cs: ShowCBSAcNo() Query: SELECT SUBSTR ('001001001410', 0, brlength) branch, SUBSTR ('001001001410', brlength+1, schlength) linksno, SUBSTR ('001001001410', -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|001410|SB|1

03-11-2022 09:26:30:Validation Account Proce Executed with out error <------------------------------------------------------------------------------------------------------------------------>
ValidateAcNo CBS A/C No : 001001001410
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 = 001410ValidationAcNo.cs: Closedyn Query Row count1<------------------------------------------------------------------------------------------------------------------------>
Y|SB|001410|1
03-11-2022 09:26:30:ValidationRequest(): Log:Validation Request Details25-884999088-1|001001001410 
<------------------------Started ValidationRequest CBS A/C No : 001001001410 ------------------------>
<------------------------------------------------------------------------------------------------------------------------>
ValidationRequest Execution Success with response :  000
<------------------------------------------------------------------------------------------------------------------------>

03-11-2022 09:35:22:ShowCBSAcNo(). Log: TranProcess.cs: ShowCBSAcNo() Query: SELECT SUBSTR ('001001001410', 0, brlength) branch, SUBSTR ('001001001410', brlength+1, schlength) linksno, SUBSTR ('001001001410', -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|001410|SB|1

03-11-2022 09:35:22:Validation Account Proce Executed with out error <------------------------------------------------------------------------------------------------------------------------>
ValidateAcNo CBS A/C No : 001001001410
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 = 001410ValidationAcNo.cs: Closedyn Query Row count1<------------------------------------------------------------------------------------------------------------------------>
Y|SB|001410|1
03-11-2022 09:35:22:TranProcess.cs: Inward_process() UTR ValidationSELECT remit_utr FROM rtgsinwardrequest WHERE Trim(remit_utr) = '25-884999088-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-884999088-1','satish','001001001410','S SATHEESH BABU', '333010100057929','','UTIB0SMCBL1',7000,'123')TranProcess.cs: Inward_process(): 001001001410 25-884999088-1  Status : 000

03-11-2022 09:35:22:<------------------------------------------------------------------------------------------------------------------------>
<-----------------------STARTED CONFIRMATION REQUEST PROCESS FOR THE DETAILS : 25-884999088-1|001001001410 -------------------------->
<------------------------------------------------------------------------------------------------------------------------>
ConfirmationReq Execution Success with Status 000
<-----------------------END CONFIRMATION REQUEST PROCESS FOR THE DETAILS : 25-884999088-1|001001001410 ------------------------------>
<------------------------------------------------------------------------------------------------------------------------>

03-11-2022 14:08:33:ShowCBSAcNo(). Log: TranProcess.cs: ShowCBSAcNo() Query: SELECT SUBSTR ('001002001108', 0, brlength) branch, SUBSTR ('001002001108', brlength+1, schlength) linksno, SUBSTR ('001002001108', -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|001108|CA|1

03-11-2022 14:08:33:Validation Account Proce Executed with out error <------------------------------------------------------------------------------------------------------------------------>
ValidateAcNo CBS A/C No : 001002001108
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 = 001108ValidationAcNo.cs: Closedyn Query Row count1<------------------------------------------------------------------------------------------------------------------------>
Y|CA|001108|1
03-11-2022 14:08:33:ValidationRequest(): Log:Validation Request DetailsP307220200763892|001002001108 
<------------------------Started ValidationRequest CBS A/C No : 001002001108 ------------------------>
<------------------------------------------------------------------------------------------------------------------------>
ValidationRequest Execution Success with response :  000
<------------------------------------------------------------------------------------------------------------------------>

03-11-2022 14:43:59:ShowCBSAcNo(). Log: TranProcess.cs: ShowCBSAcNo() Query: SELECT SUBSTR ('001002001108', 0, brlength) branch, SUBSTR ('001002001108', brlength+1, schlength) linksno, SUBSTR ('001002001108', -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|001108|CA|1

03-11-2022 14:43:59:Validation Account Proce Executed with out error <------------------------------------------------------------------------------------------------------------------------>
ValidateAcNo CBS A/C No : 001002001108
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 = 001108ValidationAcNo.cs: Closedyn Query Row count1<------------------------------------------------------------------------------------------------------------------------>
Y|CA|001108|1
03-11-2022 14:43:59:TranProcess.cs: Inward_process() UTR ValidationSELECT remit_utr FROM rtgsinwardrequest WHERE Trim(remit_utr) = 'P307220200763892'
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, 'P307220200763892','VYSYA COOPERATIVE SOCIETY LTD','001002001108','VYSYA COOPERATIVE SOCIETY LIMITED', '0699101036153','CNRB0000699','UTIB0SMCBL1',100000,'123')TranProcess.cs: Inward_process(): 001002001108 P307220200763892  Status : 000

03-11-2022 14:43:59:<------------------------------------------------------------------------------------------------------------------------>
<-----------------------STARTED CONFIRMATION REQUEST PROCESS FOR THE DETAILS : P307220200763892|001002001108 -------------------------->
<------------------------------------------------------------------------------------------------------------------------>
ConfirmationReq Execution Success with Status 000
<-----------------------END CONFIRMATION REQUEST PROCESS FOR THE DETAILS : P307220200763892|001002001108 ------------------------------>
<------------------------------------------------------------------------------------------------------------------------>

03-11-2022 15:10:15:ShowCBSAcNo(). Log: TranProcess.cs: ShowCBSAcNo() Query: SELECT SUBSTR ('001002000921', 0, brlength) branch, SUBSTR ('001002000921', brlength+1, schlength) linksno, SUBSTR ('001002000921', -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|000921|CA|1

03-11-2022 15:10:15:Validation Account Proce Executed with out error <------------------------------------------------------------------------------------------------------------------------>
ValidateAcNo CBS A/C No : 001002000921
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 = 000921ValidationAcNo.cs: Closedyn Query Row count1<------------------------------------------------------------------------------------------------------------------------>
Y|CA|000921|1
03-11-2022 15:10:15:ValidationRequest(): Log:Validation Request DetailsPKGBH22307842081|001002000921 
<------------------------Started ValidationRequest CBS A/C No : 001002000921 ------------------------>
<------------------------------------------------------------------------------------------------------------------------>
ValidationRequest Execution Success with response :  000
<------------------------------------------------------------------------------------------------------------------------>

03-11-2022 15:26:33:ShowCBSAcNo(). Log: TranProcess.cs: ShowCBSAcNo() Query: SELECT SUBSTR ('001002000921', 0, brlength) branch, SUBSTR ('001002000921', brlength+1, schlength) linksno, SUBSTR ('001002000921', -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|000921|CA|1

03-11-2022 15:26:33:Validation Account Proce Executed with out error <------------------------------------------------------------------------------------------------------------------------>
ValidateAcNo CBS A/C No : 001002000921
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 = 000921ValidationAcNo.cs: Closedyn Query Row count1<------------------------------------------------------------------------------------------------------------------------>
Y|CA|000921|1
03-11-2022 15:26:33:TranProcess.cs: Inward_process() UTR ValidationSELECT remit_utr FROM rtgsinwardrequest WHERE Trim(remit_utr) = 'PKGBH22307842081'
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, 'PKGBH22307842081','ALBUR MARIBOREGOWDA','001002000921','RAJESH  M R', '12218100001038','PKGB0000001','UTIB0SMCBL1',300000,'123')TranProcess.cs: Inward_process(): 001002000921 PKGBH22307842081  Status : 000

03-11-2022 15:26:33:<------------------------------------------------------------------------------------------------------------------------>
<-----------------------STARTED CONFIRMATION REQUEST PROCESS FOR THE DETAILS : PKGBH22307842081|001002000921 -------------------------->
<------------------------------------------------------------------------------------------------------------------------>
ConfirmationReq Execution Success with Status 000
<-----------------------END CONFIRMATION REQUEST PROCESS FOR THE DETAILS : PKGBH22307842081|001002000921 ------------------------------>
<------------------------------------------------------------------------------------------------------------------------>

03-11-2022 16:41:35:ShowCBSAcNo(). Log: TranProcess.cs: ShowCBSAcNo() Query: SELECT SUBSTR ('001002000805', 0, brlength) branch, SUBSTR ('001002000805', brlength+1, schlength) linksno, SUBSTR ('001002000805', -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|000805|CA|1

03-11-2022 16:41:35:Validation Account Proce Executed with out error <------------------------------------------------------------------------------------------------------------------------>
ValidateAcNo CBS A/C No : 001002000805
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 = 000805ValidationAcNo.cs: Closedyn Query Row count1<------------------------------------------------------------------------------------------------------------------------>
Y|CA|000805|1
03-11-2022 16:41:35:ValidationRequest(): Log:Validation Request Details000706002285|001002000805 
<------------------------Started ValidationRequest CBS A/C No : 001002000805 ------------------------>
<------------------------------------------------------------------------------------------------------------------------>
ValidationRequest Execution Success with response :  000
<------------------------------------------------------------------------------------------------------------------------>

03-11-2022 17:36:14:ShowCBSAcNo(). Log: TranProcess.cs: ShowCBSAcNo() Query: SELECT SUBSTR ('001002000805', 0, brlength) branch, SUBSTR ('001002000805', brlength+1, schlength) linksno, SUBSTR ('001002000805', -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|000805|CA|1

03-11-2022 17:36:14:Validation Account Proce Executed with out error <------------------------------------------------------------------------------------------------------------------------>
ValidateAcNo CBS A/C No : 001002000805
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 = 000805ValidationAcNo.cs: Closedyn Query Row count1<------------------------------------------------------------------------------------------------------------------------>
Y|CA|000805|1
03-11-2022 17:36:14:TranProcess.cs: Inward_process() UTR ValidationSELECT remit_utr FROM rtgsinwardrequest WHERE Trim(remit_utr) = '000706002285'
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, '000706002285','SRI SRINIVAS BOOK DEPOT','001002000805','SHREE KSHETHRA DHARMASTHALA RURAL D', '510101007028159','UBIN0907596','UTIB0SMCBL1',50485,'123')TranProcess.cs: Inward_process(): 001002000805 000706002285  Status : 000

03-11-2022 17:36:14:<------------------------------------------------------------------------------------------------------------------------>
<-----------------------STARTED CONFIRMATION REQUEST PROCESS FOR THE DETAILS : 000706002285|001002000805 -------------------------->
<------------------------------------------------------------------------------------------------------------------------>
ConfirmationReq Execution Success with Status 000
<-----------------------END CONFIRMATION REQUEST PROCESS FOR THE DETAILS : 000706002285|001002000805 ------------------------------>
<------------------------------------------------------------------------------------------------------------------------>