APPS.CSD_RECEIVE_PVT dependencies on PO_INTERFACE_ERRORS

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

202: 'Checking the errors in interface tables after the receive process'
203: );
204: END IF;
205:
206: --Call Check_Rcv_Errors to check the errors in the PO_INTERFACE_ERRORS table.
207: csd_receive_util.check_rcv_errors
208: (x_return_status => x_return_status,
209: x_rcv_error_msg_tbl => x_rcv_error_msg_tbl,
210: p_request_group_id => l_request_group_id

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

1369: END rcv_req_online;
1370:
1371: /*-----------------------------------------------------------------------------------------------------------*/
1372: /* procedure name: DELETE_INTF_TBLS */
1373: /* description : Deletes records in RCV_HEADERS_INTERFACE, RCV_TRANSACTIONS_INTERFACE., PO_INTERFACE_ERRORS*/
1374: /* MTL_TRANSACTION_LOTS_INTERFACE_TBL, MTL_SERIAL_NUMBERS_INTERFACE_TBL tables. */
1375: /* Called from : receive_item api */
1376: /* Input Parm : */
1377: /* p_request_group_id NUMBER Required */

Line 1422: DELETE FROM po_interface_errors err

1418:
1419: -----------------------------------------------Delete from errors table
1420: FOR l_hdr_rec in cur_headers(p_request_group_id) LOOP
1421: BEGIN
1422: DELETE FROM po_interface_errors err
1423: WHERE err.interface_header_id = l_hdr_Rec.header_interface_id;
1424:
1425: EXCEPTION
1426: WHEN NO_DATA_FOUND

Line 1437: DELETE FROM po_interface_errors err

1433: END LOOP;
1434:
1435: FOR l_txn_rec in cur_transactions(p_request_group_id) LOOP
1436: BEGIN
1437: DELETE FROM po_interface_errors err
1438: WHERE err.interface_transaction_id = l_txn_rec.interface_transaction_id;
1439:
1440: EXCEPTION
1441: WHEN NO_DATA_FOUND