APPS.OPI_DBI_WIP_COMP_INCR_PKG dependencies on BIS_COLLECTION_UTILITIES

Line 221: BIS_COLLECTION_UTILITIES.PUT_LINE (s_pkg_name || '.' ||

217:
218: -- opi data was not found successfully
219: l_opi_success := false;
220:
221: BIS_COLLECTION_UTILITIES.PUT_LINE (s_pkg_name || '.' ||
222: l_proc_name || ' ' ||
223: '#' || l_stmt_id ||
224: ': ' || SQLERRM);
225: BIS_COLLECTION_UTILITIES.PUT_LINE (s_pkg_name || '.' ||

Line 225: BIS_COLLECTION_UTILITIES.PUT_LINE (s_pkg_name || '.' ||

221: BIS_COLLECTION_UTILITIES.PUT_LINE (s_pkg_name || '.' ||
222: l_proc_name || ' ' ||
223: '#' || l_stmt_id ||
224: ': ' || SQLERRM);
225: BIS_COLLECTION_UTILITIES.PUT_LINE (s_pkg_name || '.' ||
226: l_proc_name || ' ' ||
227: '#' || l_stmt_id || ': ' ||
228: 'Unable to collect OPI WIP completions data in incremental load into staging table.');
229:

Line 253: BIS_COLLECTION_UTILITIES.PUT_LINE (s_pkg_name || '.' ||

249:
250: -- opm data was not found successfully
251: l_opm_success := false;
252:
253: BIS_COLLECTION_UTILITIES.PUT_LINE (s_pkg_name || '.' ||
254: l_proc_name || ' ' ||
255: '#' || l_stmt_id ||
256: ': ' || SQLERRM);
257: BIS_COLLECTION_UTILITIES.PUT_LINE (s_pkg_name || '.' ||

Line 257: BIS_COLLECTION_UTILITIES.PUT_LINE (s_pkg_name || '.' ||

253: BIS_COLLECTION_UTILITIES.PUT_LINE (s_pkg_name || '.' ||
254: l_proc_name || ' ' ||
255: '#' || l_stmt_id ||
256: ': ' || SQLERRM);
257: BIS_COLLECTION_UTILITIES.PUT_LINE (s_pkg_name || '.' ||
258: l_proc_name || ' ' ||
259: '#' || l_stmt_id || ': ' ||
260: 'Unable to collect OPM WIP completions data in incremental load into staging table.');
261:

Line 299: BIS_COLLECTION_UTILITIES.PUT_LINE

295: EXECUTE IMMEDIATE ('TRUNCATE TABLE ' || s_opi_schema || '.' ||
296: 'OPI_DBI_WIP_COMP_STG');
297:
298: l_stmt_id := 110;
299: BIS_COLLECTION_UTILITIES.PUT_LINE
300: ('WIP Completions Incremental load terminated successfully.');
301: retcode := s_SUCCESS;
302: errbuf := '';
303: return;

Line 310: BIS_COLLECTION_UTILITIES.PUT_LINE (s_pkg_name || '.' ||

306:
307: WHEN schema_info_not_found THEN
308: rollback;
309:
310: BIS_COLLECTION_UTILITIES.PUT_LINE (s_pkg_name || '.' ||
311: l_proc_name || ' ' ||
312: '#' || l_stmt_id ||
313: ': ' || SQLERRM);
314:

Line 324: BIS_COLLECTION_UTILITIES.PUT_LINE (s_pkg_name || '.' ||

320:
321: WHEN global_setup_missing THEN
322: rollback;
323:
324: BIS_COLLECTION_UTILITIES.PUT_LINE (s_pkg_name || '.' ||
325: l_proc_name || ' ' ||
326: '#' || l_stmt_id ||
327: ': ' || SQLERRM);
328:

Line 338: BIS_COLLECTION_UTILITIES.PUT_LINE (s_pkg_name || '.' ||

334:
335: WHEN data_extraction_failed THEN
336: rollback;
337:
338: BIS_COLLECTION_UTILITIES.PUT_LINE (s_pkg_name || '.' ||
339: l_proc_name || ' ' ||
340: '#' || l_stmt_id ||
341: ': ' || SQLERRM);
342:

Line 352: BIS_COLLECTION_UTILITIES.PUT_LINE (s_pkg_name || '.' ||

348:
349: WHEN OTHERS THEN
350: rollback;
351:
352: BIS_COLLECTION_UTILITIES.PUT_LINE (s_pkg_name || '.' ||
353: l_proc_name || ' ' ||
354: '#' || l_stmt_id ||
355: ': ' || SQLERRM);
356:

Line 573: BIS_COLLECTION_UTILITIES.PUT_LINE (s_pkg_name || '.' ||

569:
570: WHEN could_not_log_success THEN
571: rollback;
572:
573: BIS_COLLECTION_UTILITIES.PUT_LINE (s_pkg_name || '.' ||
574: l_proc_name || ' ' ||
575: '#' || l_stmt_id || ': ' ||
576: 'WIP Completion ETLs Incremental load OPI data extraction success could not be logged into log table. Aborting.');
577:

Line 587: BIS_COLLECTION_UTILITIES.PUT_LINE (s_pkg_name || '.' ||

583:
584:
585: WHEN cannot_run_incr_load THEN
586: rollback;
587: BIS_COLLECTION_UTILITIES.PUT_LINE (s_pkg_name || '.' ||
588: l_proc_name || ' ' ||
589: '#' || l_stmt_id || ': ' ||
590: 'WIP Completion incremental load concurrent program should not be running.
591: If the initial load request set has already been run successfully, please submit the incremental load request set. If not, please run the initial load request set.');

Line 602: BIS_COLLECTION_UTILITIES.PUT_LINE (s_pkg_name || '.' ||

598: RAISE; -- propagate exception to wrapper.
599:
600: WHEN run_common_module THEN
601: rollback;
602: BIS_COLLECTION_UTILITIES.PUT_LINE (s_pkg_name || '.' ||
603: l_proc_name || ' ' ||
604: '#' || l_stmt_id || ': ' ||
605: 'WIP Completions incremental load concurrent program is running out of turn. Please submit the incremental load request set for incremental data collection.');
606:

Line 617: BIS_COLLECTION_UTILITIES.PUT_LINE (s_pkg_name || '.' ||

613:
614: WHEN OTHERS THEN
615: rollback;
616:
617: BIS_COLLECTION_UTILITIES.PUT_LINE (s_pkg_name || '.' ||
618: l_proc_name || ' ' ||
619: '#' || l_stmt_id ||
620: ': ' || SQLERRM);
621:

Line 758: BIS_COLLECTION_UTILITIES.PUT_LINE (s_pkg_name || '.' ||

754:
755: WHEN OTHERS THEN
756: rollback;
757:
758: BIS_COLLECTION_UTILITIES.PUT_LINE (s_pkg_name || '.' ||
759: l_proc_name || ' ' ||
760: '#' || l_stmt_id ||
761: ': ' || SQLERRM);
762: