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');
1124:
1125: COMMIT;
1126:
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');
1124:
1125: COMMIT;
1126:
1127: ELSE
1323: l_interface_table_name_tab(i),
1324: l_interface_id_tab(i),
1325: l_text_tab(i),
1326: SYSDATE,
1327: fnd_global.user_id,
1328: SYSDATE,
1329: fnd_global.user_id,
1330: fnd_global.user_id,
1331: fnd_global.prog_appl_id,
1325: l_text_tab(i),
1326: SYSDATE,
1327: fnd_global.user_id,
1328: SYSDATE,
1329: fnd_global.user_id,
1330: fnd_global.user_id,
1331: fnd_global.prog_appl_id,
1332: fnd_global.conc_program_id,
1333: SYSDATE,
1326: SYSDATE,
1327: fnd_global.user_id,
1328: SYSDATE,
1329: fnd_global.user_id,
1330: fnd_global.user_id,
1331: fnd_global.prog_appl_id,
1332: fnd_global.conc_program_id,
1333: SYSDATE,
1334: fnd_global.conc_request_id,
1327: fnd_global.user_id,
1328: SYSDATE,
1329: fnd_global.user_id,
1330: fnd_global.user_id,
1331: fnd_global.prog_appl_id,
1332: fnd_global.conc_program_id,
1333: SYSDATE,
1334: fnd_global.conc_request_id,
1335: p_interface_action_code);
1328: SYSDATE,
1329: fnd_global.user_id,
1330: fnd_global.user_id,
1331: fnd_global.prog_appl_id,
1332: fnd_global.conc_program_id,
1333: SYSDATE,
1334: fnd_global.conc_request_id,
1335: p_interface_action_code);
1336: ELSE
1330: fnd_global.user_id,
1331: fnd_global.prog_appl_id,
1332: fnd_global.conc_program_id,
1333: SYSDATE,
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(
1354: l_interface_table_name_tab(i),
1355: l_interface_id_tab(i),
1356: l_text_tab(i),
1357: SYSDATE,
1358: fnd_global.user_id,
1359: SYSDATE,
1360: fnd_global.user_id,
1361: fnd_global.user_id,
1362: fnd_global.prog_appl_id,
1356: l_text_tab(i),
1357: SYSDATE,
1358: fnd_global.user_id,
1359: SYSDATE,
1360: fnd_global.user_id,
1361: fnd_global.user_id,
1362: fnd_global.prog_appl_id,
1363: fnd_global.conc_program_id,
1364: SYSDATE,
1357: SYSDATE,
1358: fnd_global.user_id,
1359: SYSDATE,
1360: fnd_global.user_id,
1361: fnd_global.user_id,
1362: fnd_global.prog_appl_id,
1363: fnd_global.conc_program_id,
1364: SYSDATE,
1365: fnd_global.conc_request_id,
1358: fnd_global.user_id,
1359: SYSDATE,
1360: fnd_global.user_id,
1361: fnd_global.user_id,
1362: fnd_global.prog_appl_id,
1363: fnd_global.conc_program_id,
1364: SYSDATE,
1365: fnd_global.conc_request_id,
1366: p_interface_action_code);
1359: SYSDATE,
1360: fnd_global.user_id,
1361: fnd_global.user_id,
1362: fnd_global.prog_appl_id,
1363: fnd_global.conc_program_id,
1364: SYSDATE,
1365: fnd_global.conc_request_id,
1366: p_interface_action_code);
1367: END LOOP;
1361: fnd_global.user_id,
1362: fnd_global.prog_appl_id,
1363: fnd_global.conc_program_id,
1364: SYSDATE,
1365: fnd_global.conc_request_id,
1366: p_interface_action_code);
1367: END LOOP;
1368: END IF;
1369: