20-01-2025 17:34:46:Qury from rtgsinward--->:select REMIT_UTR utrno from rtgsinward where REMIT_UTR='CIUBN52025012020043828' 20-01-2025 17:34:46:Record Count --->:0 20-01-2025 17:34:46:quiery Insert into rtgsinward : Insert into rtgsinward(VOUCHERNO,VOUCHERDATE,RECEIVED_DATETIME,REMIT_UTR,AGENT_BANKACNO,BENEFI_NAME,BENEFI_ACCNO,REMIT_NAME,REMIT_ACNO,SENDER_IFSC,BENEFI_IFSC,STATUS,AMOUNT,TRANMODE,FILE_NAME)VALUES(170235,TO_date(sysdate,'DD/MM/RRRR'),sysdate,'CIUBN52025012020043828','0','THULASI S','001001008998','LIC INDIA D061','00510909010267418','CIUB0000032','YESB0CSB001','',120500,'N','313890318') 20-01-2025 17:34:46:SenderAcno - BY LIC INDIA D061 CIUB0000032 00510909010267418 20-01-2025 17:34:46:narr - NEFT, BY LIC INDIA D061 CIUB0000032 00510909010267418 20-01-2025 17:34:46:calling GetInwardAuthLimit 20-01-2025 17:34:46:calling CallNewRtgsBothProc 20-01-2025 17:34:47:proc msg - RTGS TRANSACTION IS SUCCESSFUL 20-01-2025 17:34:47:proc status - Y 20-01-2025 17:34:47:update rtgsinward - UPDATE rtgsinward SET web_status = 'Y', trandate = SYSDATE WHERE voucherno = 170235 20-01-2025 17:34:47:Transaction SMS Alert - Client Code Started 8783 20-01-2025 17:34:47:Transaction SMS Alert - Client Code Completed 8783