APPS.CSD_RECEIVE_PVT dependencies on PO_INTERFACE_ERRORS

Line 229: --Call Check_Rcv_Errors to check the errors in the PO_INTERFACE_ERRORS table.

225: 'Checking the errors in interface tables after the receive process'
226: );
227: END IF;
228:
229: --Call Check_Rcv_Errors to check the errors in the PO_INTERFACE_ERRORS table.
230: csd_receive_util.check_rcv_errors
231: (x_return_status => x_return_status,
232: x_rcv_error_msg_tbl => x_rcv_error_msg_tbl,
233: p_request_group_id => l_request_group_id

Line 1460: /* description : Deletes records in RCV_HEADERS_INTERFACE, RCV_TRANSACTIONS_INTERFACE., PO_INTERFACE_ERRORS*/

1456: END rcv_req_online;
1457:
1458: /*-----------------------------------------------------------------------------------------------------------*/
1459: /* procedure name: DELETE_INTF_TBLS */
1460: /* description : Deletes records in RCV_HEADERS_INTERFACE, RCV_TRANSACTIONS_INTERFACE., PO_INTERFACE_ERRORS*/
1461: /* MTL_TRANSACTION_LOTS_INTERFACE_TBL, MTL_SERIAL_NUMBERS_INTERFACE_TBL tables. */
1462: /* Called from : receive_item api */
1463: /* Input Parm : */
1464: /* p_request_group_id NUMBER Required */

Line 1509: DELETE FROM po_interface_errors err

1505:
1506: -----------------------------------------------Delete from errors table
1507: FOR l_hdr_rec in cur_headers(p_request_group_id) LOOP
1508: BEGIN
1509: DELETE FROM po_interface_errors err
1510: WHERE err.interface_header_id = l_hdr_Rec.header_interface_id;
1511:
1512: EXCEPTION
1513: WHEN NO_DATA_FOUND

Line 1524: DELETE FROM po_interface_errors err

1520: END LOOP;
1521:
1522: FOR l_txn_rec in cur_transactions(p_request_group_id) LOOP
1523: BEGIN
1524: DELETE FROM po_interface_errors err
1525: WHERE err.interface_transaction_id = l_txn_rec.interface_transaction_id;
1526:
1527: EXCEPTION
1528: WHEN NO_DATA_FOUND