153: EXCEPTION
154:
155: WHEN SCHEMA_INFO_NOT_FOUND THEN
156:
157: BIS_COLLECTION_UTILITIES.PUT_LINE (err_mesg
158: (SCHEMA_INFO_NOT_FOUND_MESG,
159: l_proc_name, l_stmt_id));
160: RAISE GLOBAL_SETUP_MISSING;
161:
162:
163: WHEN OTHERS THEN
164: rollback;
165:
166: BIS_COLLECTION_UTILITIES.PUT_LINE (err_mesg (SQLERRM, l_proc_name,
167: l_stmt_id));
168: RAISE GLOBAL_SETUP_MISSING;
169:
170: END global_setup;
270: l_formatted_message := substr ((C_PKG_NAME || '.' || p_proc_name || ' #' ||
271: to_char (p_stmt_id) || ': ' || 'Done.'),
272: 1, C_ERRBUF_SIZE);
273:
274: BIS_COLLECTION_UTILITIES.PUT_LINE (l_formatted_message);
275:
276: return;
277:
278: EXCEPTION
278: EXCEPTION
279:
280: WHEN OTHERS THEN
281: -- the exception happened in the print function
282: BIS_COLLECTION_UTILITIES.PUT_LINE (err_mesg (SQLERRM, l_proc_name,
283: l_stmt_id));
284:
285: RAISE; -- on to wrapper
286:
328:
329: EXCEPTION
330:
331: WHEN OTHERS THEN
332: BIS_COLLECTION_UTILITIES.PUT_LINE (err_mesg (SQLERRM, l_proc_name,
333: l_stmt_id));
334: RAISE TABLE_SETUP_FAILED;
335:
336: END setup_tables;
490: print_stage_done_mesg (l_proc_name, l_stmt_id);
491:
492: errbuf := '';
493: retcode := C_SUCCESS;
494: BIS_COLLECTION_UTILITIES.PUT_LINE (C_SUCCESS_MESG);
495: return;
496:
497: EXCEPTION
498:
500: rollback;
501: retcode := C_ERROR;
502: errbuf := C_CURR_UTZ_LOAD_ERROR_MESG;
503:
504: BIS_COLLECTION_UTILITIES.PUT_LINE (err_mesg
505: (GLOBAL_SETUP_MISSING_MESG,
506: l_proc_name, l_stmt_id));
507: return;
508:
510: rollback;
511: retcode := C_ERROR;
512: errbuf := C_CURR_UTZ_LOAD_ERROR_MESG;
513:
514: BIS_COLLECTION_UTILITIES.PUT_LINE (err_mesg
515: (TABLE_SETUP_FAILED_MESG,
516: l_proc_name, l_stmt_id));
517: return;
518:
520: rollback;
521: retcode := C_ERROR;
522: errbuf := C_CURR_UTZ_LOAD_ERROR_MESG;
523:
524: BIS_COLLECTION_UTILITIES.PUT_LINE (err_mesg
525: (LOCATOR_CAP_CALC_MESG,
526: l_proc_name, l_stmt_id));
527: return;
528:
530: rollback;
531: retcode := C_WARNING; -- ??? should this be success?
532: errbuf := C_CURR_UTZ_LOAD_WARN_MESG;
533:
534: BIS_COLLECTION_UTILITIES.PUT_LINE (err_mesg
535: (NO_REP_UOMS_DEFINED_MESG,
536: l_proc_name, l_stmt_id));
537: return;
538:
540: rollback;
541: retcode := C_ERROR;
542: errbuf := C_CURR_UTZ_LOAD_WARN_MESG;
543:
544: BIS_COLLECTION_UTILITIES.PUT_LINE (err_mesg
545: (PREMATURE_ABORT_MESG,
546: l_proc_name, l_stmt_id));
547: return;
548:
550: rollback;
551: retcode := C_ERROR;
552: errbuf := C_CURR_UTZ_LOAD_ERROR_MESG;
553:
554: BIS_COLLECTION_UTILITIES.PUT_LINE (err_mesg
555: (ITEM_STOR_CALC_FAILED_MESG,
556: l_proc_name, l_stmt_id));
557: return;
558:
560: rollback;
561: retcode := C_ERROR;
562: errbuf := C_CURR_UTZ_LOAD_ERROR_MESG;
563:
564: BIS_COLLECTION_UTILITIES.PUT_LINE (err_mesg
565: (LOCATOR_ERR_CHECK_FAILED_MESG,
566: l_proc_name, l_stmt_id));
567: return;
568:
570: rollback;
571: retcode := C_ERROR;
572: errbuf := C_CURR_UTZ_LOAD_ERROR_MESG;
573:
574: BIS_COLLECTION_UTILITIES.PUT_LINE (err_mesg
575: (ITEM_ERR_CHECK_FAILED_MESG,
576: l_proc_name, l_stmt_id));
577: return;
578:
580: rollback;
581: retcode := C_ERROR;
582: errbuf := C_CURR_UTZ_LOAD_ERROR_MESG;
583:
584: BIS_COLLECTION_UTILITIES.PUT_LINE (err_mesg (SQLERRM, l_proc_name,
585: l_stmt_id));
586:
587: return;
588:
831: WHEN NO_REP_UOMS_DEFINED THEN
832: RAISE;
833:
834: WHEN OTHERS THEN
835: BIS_COLLECTION_UTILITIES.PUT_LINE (err_mesg (SQLERRM, l_proc_name,
836: l_stmt_id));
837: RAISE LOCATOR_CAP_CALC_FAILED;
838:
839: END extract_locator_capacities;
934:
935: EXCEPTION
936:
937: WHEN OTHERS THEN
938: BIS_COLLECTION_UTILITIES.PUT_LINE (err_mesg (SQLERRM, l_proc_name,
939: l_stmt_id));
940: RAISE SUMMARIZE_CAP_FAILED;
941:
942: END summarize_capacities;
1052:
1053: EXCEPTION
1054:
1055: WHEN OTHERS THEN
1056: BIS_COLLECTION_UTILITIES.PUT_LINE (err_mesg (SQLERRM, l_proc_name,
1057: l_stmt_id));
1058: RAISE LOCATOR_ERR_CHECK_FAILED;
1059:
1060: END check_locator_setup_errors;
1389: WHEN NO_REP_UOMS_DEFINED THEN
1390: RAISE;
1391:
1392: WHEN OTHERS THEN
1393: BIS_COLLECTION_UTILITIES.PUT_LINE (err_mesg (SQLERRM, l_proc_name,
1394: l_stmt_id));
1395: RAISE ITEM_STOR_CALC_FAILED;
1396:
1397: END extract_item_storage;
1513:
1514: EXCEPTION
1515:
1516: WHEN OTHERS THEN
1517: BIS_COLLECTION_UTILITIES.PUT_LINE (err_mesg (SQLERRM, l_proc_name,
1518: l_stmt_id));
1519: RAISE ITEM_ERR_CHECK_FAILED;
1520:
1521: END check_item_setup_errors;