12-07-2024 19:00:56:Qury from rtgsinward--->:select REMIT_UTR utrno from rtgsinward where REMIT_UTR='SBINR12024071235396216' 12-07-2024 19:00:56:Record Count --->:0 12-07-2024 19:00:56: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(152065,TO_date(sysdate,'DD/MM/RRRR'),sysdate,'SBINR12024071235396216','0','Basaweswari K','001001010774','mcd ceracon private ltd','37478642157','SBIN0070802','YESB0CSB001','',365805,'R','297105446') 12-07-2024 19:00:56:SenderAcno - BY mcd ceracon private ltd SBIN0070802 37478642157 12-07-2024 19:00:56:narr - RTGS, BY mcd ceracon private ltd SBIN0070802 37478642157 12-07-2024 19:00:56:calling GetInwardAuthLimit 12-07-2024 19:00:56:calling CallNewRtgsBothProc 12-07-2024 19:00:56:proc msg - RTGS TRANSACTION IS SUCCESSFUL 12-07-2024 19:00:56:proc status - Y 12-07-2024 19:00:56:update rtgsinward - UPDATE rtgsinward SET web_status = 'Y', trandate = SYSDATE WHERE voucherno = 152065 12-07-2024 19:00:56:Transaction SMS Alert - Client Code Started 16734 12-07-2024 19:00:56:Transaction SMS Alert - Client Code Completed 16734