25-03-2025 10:02:50:Qury from rtgsinward--->:select REMIT_UTR utrno  from rtgsinward where REMIT_UTR='HSBCN52025032529852384'
25-03-2025 10:02:50:Record Count --->:0
25-03-2025 10:02:50: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(176147,TO_date(sysdate,'DD/MM/RRRR'),sysdate,'HSBCN52025032529852384','0','HONEY DEW EXOTICA','001002002002','AGODA COMPANY PTE  LTD','054-347471-002','HSBC0110005','YESB0CSB001','',175793.75,'N','316432905')
25-03-2025 10:02:50:SenderAcno - BY AGODA COMPANY PTE  LTD HSBC0110005 054-347471-002
25-03-2025 10:02:50:narr - NEFT, BY AGODA COMPANY PTE  LTD HSBC0110005 054-347471-002
25-03-2025 10:02:50:calling  GetInwardAuthLimit 
25-03-2025 10:02:50:calling  CallNewRtgsBothProc 
25-03-2025 10:02:50:proc msg - RTGS TRANSACTION IS SUCCESSFUL
25-03-2025 10:02:50:proc status - Y
25-03-2025 10:02:50:update rtgsinward - UPDATE rtgsinward SET web_status = 'Y', trandate = SYSDATE WHERE voucherno = 176147