eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AHL_OSP_PO_REQ_PVT dependencies on PO_INTERFACE_ERRORS

Line 382: DELETE FROM po_interface_errors

378: -- Insert Rows into PO_REQUISITIONS_INTERFACE_ALL
379:
380: -- Purge Error records from prior submission (if any)
381: IF (l_status = G_OSP_REQ_SUB_FAILED_STATUS) THEN
382: DELETE FROM po_interface_errors
383: WHERE INTERFACE_TRANSACTION_ID in
384: (SELECT transaction_id
385: FROM po_requisitions_interface_all
386: WHERE INTERFACE_SOURCE_CODE = AHL_GLOBAL.AHL_APP_SHORT_NAME

Line 394: DELETE FROM PO_INTERFACE_ERRORS WHERE

390: AND INTERFACE_SOURCE_LINE_ID = l_po_req_header.OSP_ORDER_ID;
391:
392: ELSIF(l_status = G_OSP_SUB_FAILED_STATUS and l_old_intf_header_id IS NOT NULL) THEN
393: -- Earlier, User tried to create a PO (not a requisition) and that failed.
394: DELETE FROM PO_INTERFACE_ERRORS WHERE
395: INTERFACE_HEADER_ID = l_old_intf_header_id;
396: DELETE FROM PO_HEADERS_INTERFACE WHERE
397: INTERFACE_HEADER_ID = l_old_intf_header_id;
398: DELETE FROM PO_LINES_INTERFACE WHERE