24-01-2025 14:02:49:Qury from rtgsinward--->:select REMIT_UTR utrno from rtgsinward where REMIT_UTR='ESFBN52025012405486300' 24-01-2025 14:02:49:Record Count --->:0 24-01-2025 14:02:49: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(170590,TO_date(sysdate,'DD/MM/RRRR'),sysdate,'ESFBN52025012405486300','0','THOMAS','002001000808','CHINNAPPAN SAVARIAPPAN','100018603191','ESFB0001091','YESB0CSB001','',100000,'N','314162438') 24-01-2025 14:02:49:SenderAcno - BY CHINNAPPAN SAVARIAPPAN ESFB0001091 100018603191 24-01-2025 14:02:49:narr - NEFT, BY CHINNAPPAN SAVARIAPPAN ESFB0001091 100018603191 24-01-2025 14:02:49:calling GetInwardAuthLimit 24-01-2025 14:02:49:calling CallNewRtgsBothProc 24-01-2025 14:02:49:proc msg - RTGS TRANSACTION IS SUCCESSFUL 24-01-2025 14:02:49:proc status - Y 24-01-2025 14:02:49:update rtgsinward - UPDATE rtgsinward SET web_status = 'Y', trandate = SYSDATE WHERE voucherno = 170590 24-01-2025 14:02:49:Transaction SMS Alert - Client Code Started 19000 24-01-2025 14:02:49:Transaction SMS Alert - Client Code Completed 19000