417:
418: WHEN could_not_log_success THEN
419: rollback;
420:
421: BIS_COLLECTION_UTILITIES.PUT_LINE (s_pkg_name || '.' || l_proc_name || ' ' ||
422: '#' || l_stmt_id || ': ' ||
423: 'WIP Completion ETLs Initial load OPI data extraction success could not be logged into log table. Aborting.');
424:
425:
432:
433: WHEN OTHERS THEN
434: rollback;
435:
436: BIS_COLLECTION_UTILITIES.PUT_LINE (s_pkg_name || '.' || l_proc_name || ' ' ||
437: '#' || l_stmt_id || ': ' || SQLERRM);
438:
439: retcode := s_ERROR;
440: errbuf := s_pkg_name || '.' || l_proc_name || ' ' || '#' ||
644:
645: WHEN could_not_log_success THEN
646: rollback;
647:
648: BIS_COLLECTION_UTILITIES.PUT_LINE (s_pkg_name || '.' || l_proc_name || ' ' ||
649: '#' || l_stmt_id || ': ' ||
650: 'WIP Completion ETLs Initial load OPI data extraction success could not be logged into log table. Aborting.');
651:
652:
659:
660: WHEN OTHERS THEN
661: rollback;
662:
663: BIS_COLLECTION_UTILITIES.PUT_LINE (s_pkg_name || '.' || l_proc_name || ' ' ||
664: '#' || l_stmt_id || ': ' || SQLERRM);
665:
666: retcode := s_ERROR;
667: errbuf := s_pkg_name || '.' || l_proc_name || ' ' || '#' ||