APPS.PO_REQIMP_VAL_PVT dependencies on PO_INTERFACE_ERRORS

Line 10: * Modifies: PO_INTERFACE_ERRORS, concurrent program log

6:
7: /**
8: * Private Procedure: val_pjm_proj_references
9: * Requires: none
10: * Modifies: PO_INTERFACE_ERRORS, concurrent program log
11: * Parameters:
12: * p_interface_table_code - the interface table to be validated;
13: * if PO_REQIMP_VAL_PVT.G_PO_REQUISITIONS_INTERFACE,
14: use PO_REQUISITIONS_INTERFACE

Line 20: * PO_INTERFACE_ERRORS and any validation warnings to the concurrent

16: use PO_REQ_DIST_INTERFACE
17: * Effects: For all records with the given request ID in the specified
18: * interface table, calls the PJM validation API to validate
19: * project and task information. Writes any validation errors to
20: * PO_INTERFACE_ERRORS and any validation warnings to the concurrent
21: * program log.
22: * Returns:
23: * x_return_status -
24: * FND_API.G_RET_STS_UNEXP_ERROR if an unexpected error occurs

Line 54: PO_INTERFACE_ERRORS.error_message%TYPE

50: l_transaction_id_tbl l_number_tbl_type;
51: l_destination_ou_id_tbl l_number_tbl_type;
52:
53: TYPE l_errors_tbl_type IS TABLE of
54: PO_INTERFACE_ERRORS.error_message%TYPE
55: INDEX BY BINARY_INTEGER;
56: TYPE l_err_transaction_id_tbl_type IS TABLE of
57: PO_INTERFACE_ERRORS.interface_transaction_id%TYPE
58: INDEX BY BINARY_INTEGER;

Line 57: PO_INTERFACE_ERRORS.interface_transaction_id%TYPE

53: TYPE l_errors_tbl_type IS TABLE of
54: PO_INTERFACE_ERRORS.error_message%TYPE
55: INDEX BY BINARY_INTEGER;
56: TYPE l_err_transaction_id_tbl_type IS TABLE of
57: PO_INTERFACE_ERRORS.interface_transaction_id%TYPE
58: INDEX BY BINARY_INTEGER;
59: l_errors_tbl l_errors_tbl_type;
60: l_err_transaction_id_tbl l_err_transaction_id_tbl_type;
61: l_errorI NUMBER := 1;

Line 190: -- Bulk insert all the errors into PO_INTERFACE_ERRORS

186: IF (l_errors_tbl.COUNT = 0) THEN
187: RETURN;
188: END IF;
189:
190: -- Bulk insert all the errors into PO_INTERFACE_ERRORS
191: FORALL i IN l_errors_tbl.FIRST..l_errors_tbl.LAST
192: INSERT INTO po_interface_errors
193: (interface_type,interface_transaction_id,column_name,
194: error_message,

Line 192: INSERT INTO po_interface_errors

188: END IF;
189:
190: -- Bulk insert all the errors into PO_INTERFACE_ERRORS
191: FORALL i IN l_errors_tbl.FIRST..l_errors_tbl.LAST
192: INSERT INTO po_interface_errors
193: (interface_type,interface_transaction_id,column_name,
194: error_message,
195: creation_date,created_by,last_update_date,last_updated_by,
196: last_update_login,request_id,program_application_id,program_id,