APPS.OPI_DBI_WIP_SCRAP_INCR_PKG dependencies on BIS_COLLECTION_UTILITIES

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

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

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

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

Line 263: BIS_COLLECTION_UTILITIES.PUT_LINE

259: EXECUTE IMMEDIATE ('TRUNCATE TABLE ' || s_opi_schema || '.' ||
260: 'OPI_DBI_WIP_SCRAP_STG');
261:
262: l_stmt_id := 90;
263: BIS_COLLECTION_UTILITIES.PUT_LINE
264: ('Scrap Incremental load terminated successfully.');
265: retcode := s_SUCCESS;
266: errbuf := '';
267: return;

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

270:
271: WHEN schema_info_not_found THEN
272: rollback;
273:
274: BIS_COLLECTION_UTILITIES.PUT_LINE (s_pkg_name || '.' ||
275: l_proc_name || ' ' ||
276: '#' || l_stmt_id ||
277: ': ' || SQLERRM);
278:

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

284:
285: WHEN global_setup_missing THEN
286: rollback;
287:
288: BIS_COLLECTION_UTILITIES.PUT_LINE (s_pkg_name || '.' ||
289: l_proc_name || ' ' ||
290: '#' || l_stmt_id ||
291: ': ' || SQLERRM);
292:

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

299:
300: WHEN data_extraction_failed THEN
301: rollback;
302:
303: BIS_COLLECTION_UTILITIES.PUT_LINE (s_pkg_name || '.' ||
304: l_proc_name || ' ' ||
305: '#' || l_stmt_id ||
306: ': ' || SQLERRM);
307:

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

313:
314: WHEN OTHERS THEN
315: rollback;
316:
317: BIS_COLLECTION_UTILITIES.PUT_LINE (s_pkg_name || '.' ||
318: l_proc_name || ' ' ||
319: '#' || l_stmt_id ||
320: ': ' || SQLERRM);
321:

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

536:
537: WHEN could_not_log_success THEN
538: rollback;
539:
540: BIS_COLLECTION_UTILITIES.PUT_LINE (s_pkg_name || '.' ||
541: l_proc_name || ' ' ||
542: '#' || l_stmt_id || ': ' ||
543: 'WIP Scrap ETL Incremental load OPI data extraction success could not be logged into log table. Aborting.');
544:

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

550:
551:
552: WHEN cannot_run_incr_load THEN
553: rollback;
554: BIS_COLLECTION_UTILITIES.PUT_LINE (s_pkg_name || '.' ||
555: l_proc_name || ' ' ||
556: '#' || l_stmt_id || ': ' ||
557: 'WIP Scrap incremental load concurrent program should not be running.
558: 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 570: BIS_COLLECTION_UTILITIES.PUT_LINE (s_pkg_name || '.' ||

566: RAISE; -- propagate exception to wrapper.
567:
568: WHEN run_common_module THEN
569: rollback;
570: BIS_COLLECTION_UTILITIES.PUT_LINE (s_pkg_name || '.' ||
571: l_proc_name || ' ' ||
572: '#' || l_stmt_id || ': ' ||
573: 'WIP Scrap incremental load concurrent program is running out of turn. Please submit the incremental load request set for incremental data collection.');
574:

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

580:
581: WHEN OTHERS THEN
582: rollback;
583:
584: BIS_COLLECTION_UTILITIES.PUT_LINE (s_pkg_name || '.' ||
585: l_proc_name || ' ' ||
586: '#' || l_stmt_id ||
587: ': ' || SQLERRM);
588:

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

721:
722: WHEN OTHERS THEN
723: rollback;
724:
725: BIS_COLLECTION_UTILITIES.PUT_LINE (s_pkg_name || '.' ||
726: l_proc_name || ' ' ||
727: '#' || l_stmt_id ||
728: ': ' || SQLERRM);
729: