APPS.WSMPLBMI dependencies on WSM_INTERFACE_ERRORS

Line 5797: INSERT INTO WSM_INTERFACE_ERRORS (

5793: l_stmt_num := 10;
5794: fnd_file.put_line(fnd_file.log,'Inside copy_WTIE_to_WIE...');
5795:
5796: l_stmt_num := 40;
5797: INSERT INTO WSM_INTERFACE_ERRORS (
5798: HEADER_ID,
5799: TRANSACTION_ID,
5800: MESSAGE,
5801: LAST_UPDATE_DATE,

Line 5892: fnd_file.put_line(fnd_file.log, 'Errors populated in wsm_interface_errors table');

5888: SET status = 3,
5889: ERROR = g_fnd_generic_err_msg
5890: WHERE header_id = p_header_id;
5891:
5892: fnd_file.put_line(fnd_file.log, 'Errors populated in wsm_interface_errors table');
5893: EXCEPTION
5894: WHEN OTHERS THEN
5895: x_error_code := SQLCODE;
5896: x_error_msg := substrb('WSMPLMTI.error_handler' ||'(stmt_num='||l_stmt_num||') : '||sqlerrm, 1,4000);

Line 6600: Enter a warning into the wsm_interface_errors table

6596: WHERE organization_id = l_organization_id;
6597: END IF;
6598:
6599: /* OSP Enhancement Changes Begin
6600: Enter a warning into the wsm_interface_errors table
6601: if there is a Purchase Requistion or Purchase Order linked
6602: to an operation under certain conditions */
6603: l_stmt_num := 100;
6604:

Line 11456: DELETE FROM WSM_INTERFACE_ERRORS WHERE header_id = p_header_id;

11452: END IF;
11453:
11454: l_stmt_num := 10;
11455:
11456: DELETE FROM WSM_INTERFACE_ERRORS WHERE header_id = p_header_id;
11457:
11458: IF (p_transaction_type IN (1, 2)) THEN
11459: DECLARE
11460: l_mti_rows NUMBER;

Line 11946: FROM WSM_INTERFACE_ERRORS

11942: /*
11943: DECLARE
11944: cursor C_WIE IS
11945: SELECT message
11946: FROM WSM_INTERFACE_ERRORS
11947: WHERE transaction_id = l_transaction_id;
11948:
11949: i INTEGER := 0;
11950: BEGIN