APPS.WSH_INTERFACE_VALIDATIONS_PKG dependencies on WSH_INTERFACE_ERRORS

Line 962: the resulting message text in WSH_INTERFACE_ERRORS table.

958: This Procedure is called from various procedure whenever an error is detected in
959: the data elements.
960:
961: This Procedure accepts upto 6 different tokens and Values Concatenates and stores
962: the resulting message text in WSH_INTERFACE_ERRORS table.
963: ==============================================================================*/
964:
965: PROCEDURE log_interface_errors (
966: p_interface_errors_rec IN interface_errors_rec_type,

Line 1103: -- Insert error record in WSH_Interface_errors table.

1099:
1100: IF l_debug_on THEN
1101: wsh_debug_sv.log (l_module_name, 'Text: ', l_text);
1102: END IF;
1103: -- Insert error record in WSH_Interface_errors table.
1104: -- We need the check for l_text because the column error_message
1105: -- is a Not_Null column.
1106:
1107: IF (l_text IS NOT NULL) THEN

Line 1110: wsh_debug_sv.log (l_module_name, 'Inserting into wsh_interface_errors');

1106:
1107: IF (l_text IS NOT NULL) THEN
1108: IF l_debug_on THEN
1109: wsh_debug_sv.log (l_module_name, 'Error Message', l_text);
1110: wsh_debug_sv.log (l_module_name, 'Inserting into wsh_interface_errors');
1111: END IF;
1112:
1113: INSERT INTO wsh_interface_errors
1114: (interface_error_id,

Line 1113: INSERT INTO wsh_interface_errors

1109: wsh_debug_sv.log (l_module_name, 'Error Message', l_text);
1110: wsh_debug_sv.log (l_module_name, 'Inserting into wsh_interface_errors');
1111: END IF;
1112:
1113: INSERT INTO wsh_interface_errors
1114: (interface_error_id,
1115: interface_table_name,
1116: interface_id, error_message, creation_date,
1117: created_by, last_update_date, last_updated_by,

Line 1119: VALUES (wsh_interface_errors_s.NEXTVAL,

1115: interface_table_name,
1116: interface_id, error_message, creation_date,
1117: created_by, last_update_date, last_updated_by,
1118: last_update_login,INTERFACE_ACTION_CODE)
1119: VALUES (wsh_interface_errors_s.NEXTVAL,
1120: p_interface_errors_rec.p_interface_table_name,
1121: p_interface_errors_rec.p_interface_id, l_text, SYSDATE,
1122: fnd_global.user_id, SYSDATE, fnd_global.user_id,
1123: fnd_global.user_id,'94X_INBOUND');

Line 1307: INSERT INTO wsh_interface_errors(

1303: IF (l_text_tab.COUNT > 0) THEN --{
1304:
1305: IF (l_text_tab.COUNT > 3) THEN
1306: FORALL i in l_text_tab.FIRST..l_text_tab.LAST
1307: INSERT INTO wsh_interface_errors(
1308: interface_error_id,
1309: interface_table_name,
1310: interface_id,
1311: error_message,

Line 1322: VALUES (wsh_interface_errors_s.NEXTVAL,

1318: program_id,
1319: program_update_date,
1320: request_id,
1321: interface_action_code)
1322: VALUES (wsh_interface_errors_s.NEXTVAL,
1323: l_interface_table_name_tab(i),
1324: l_interface_id_tab(i),
1325: l_text_tab(i),
1326: SYSDATE,

Line 1338: INSERT INTO wsh_interface_errors(

1334: fnd_global.conc_request_id,
1335: p_interface_action_code);
1336: ELSE
1337: FOR i in l_text_tab.FIRST..l_text_tab.LAST LOOP
1338: INSERT INTO wsh_interface_errors(
1339: interface_error_id,
1340: interface_table_name,
1341: interface_id,
1342: error_message,

Line 1353: VALUES (wsh_interface_errors_s.NEXTVAL,

1349: program_id,
1350: program_update_date,
1351: request_id,
1352: interface_action_code)
1353: VALUES (wsh_interface_errors_s.NEXTVAL,
1354: l_interface_table_name_tab(i),
1355: l_interface_id_tab(i),
1356: l_text_tab(i),
1357: SYSDATE,