31-01-2025 13:04:29:Qury from rtgsinward--->:select REMIT_UTR utrno from rtgsinward where REMIT_UTR='ICICR12025013104303936' 31-01-2025 13:04:29:Record Count --->:0 31-01-2025 13:04:29: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(171162,TO_date(sysdate,'DD/MM/RRRR'),sysdate,'ICICR12025013104303936','0','Prasanna Kumar R','002001001631','EKTA TAMHANE','388701500651','ICIC0003887','YESB0CSB001','',500000,'R','314551099') 31-01-2025 13:04:29:SenderAcno - BY EKTA TAMHANE ICIC0003887 388701500651 31-01-2025 13:04:29:narr - RTGS, BY EKTA TAMHANE ICIC0003887 388701500651 31-01-2025 13:04:29:calling GetInwardAuthLimit 31-01-2025 13:04:29:calling CallNewRtgsBothProc 31-01-2025 13:04:29:proc msg - RTGS TRANSACTION IS SUCCESSFUL 31-01-2025 13:04:29:proc status - Y 31-01-2025 13:04:29:update rtgsinward - UPDATE rtgsinward SET web_status = 'Y', trandate = SYSDATE WHERE voucherno = 171162 31-01-2025 13:04:29:Transaction SMS Alert - Client Code Started 20602 31-01-2025 13:04:29:Transaction SMS Alert - Client Code Completed 20602