DBA Data[Home] [Help]

APPS.OPI_DBI_REP_UOM_STD_CONV_PKG dependencies on BIS_COLLECTION_UTILITIES

Line 138: BIS_COLLECTION_UTILITIES.PUT_LINE (err_mesg

134: EXCEPTION
135:
136: WHEN SCHEMA_INFO_NOT_FOUND THEN
137:
138: BIS_COLLECTION_UTILITIES.PUT_LINE (err_mesg
139: (SCHEMA_INFO_NOT_FOUND_MESG,
140: l_proc_name, l_stmt_id));
141: RAISE GLOBAL_SETUP_MISSING;
142:

Line 146: BIS_COLLECTION_UTILITIES.PUT_LINE (err_mesg

142:
143:
144: WHEN GLOBAL_START_DATE_NULL THEN
145:
146: BIS_COLLECTION_UTILITIES.PUT_LINE (err_mesg
147: (GLOBAL_START_DATE_NULL_MESG,
148: l_proc_name, l_stmt_id));
149: RAISE GLOBAL_SETUP_MISSING;
150:

Line 156: BIS_COLLECTION_UTILITIES.PUT_LINE (err_mesg (SQLERRM, l_proc_name,

152:
153: WHEN OTHERS THEN
154: rollback;
155:
156: BIS_COLLECTION_UTILITIES.PUT_LINE (err_mesg (SQLERRM, l_proc_name,
157: l_stmt_id));
158: RAISE GLOBAL_SETUP_MISSING;
159:
160: END global_setup;

Line 262: BIS_COLLECTION_UTILITIES.PUT_LINE (l_formatted_message);

258: l_formatted_message := substr ((C_PKG_NAME || '.' || p_proc_name || ' #' ||
259: to_char (p_stmt_id) || ': ' || 'Done.'),
260: 1, C_ERRBUF_SIZE);
261:
262: BIS_COLLECTION_UTILITIES.PUT_LINE (l_formatted_message);
263:
264: return;
265:
266: EXCEPTION

Line 270: BIS_COLLECTION_UTILITIES.PUT_LINE (err_mesg (SQLERRM, l_proc_name,

266: EXCEPTION
267:
268: WHEN OTHERS THEN
269: -- the exception happened in the print function
270: BIS_COLLECTION_UTILITIES.PUT_LINE (err_mesg (SQLERRM, l_proc_name,
271: l_stmt_id));
272:
273: RAISE; -- on to wrapper
274:

Line 360: BIS_COLLECTION_UTILITIES.PUT_LINE (err_mesg (SQLERRM, l_proc_name,

356: EXCEPTION
357:
358: WHEN OTHERS THEN
359:
360: BIS_COLLECTION_UTILITIES.PUT_LINE (err_mesg (SQLERRM, l_proc_name,
361: l_stmt_id));
362: RAISE INTRA_STD_CONV_FAILED;
363:
364:

Line 476: BIS_COLLECTION_UTILITIES.PUT_LINE (err_mesg (SQLERRM, l_proc_name,

472: EXCEPTION
473:
474: WHEN OTHERS THEN
475:
476: BIS_COLLECTION_UTILITIES.PUT_LINE (err_mesg (SQLERRM, l_proc_name,
477: l_stmt_id));
478: RAISE INTER_STD_CONV_FAILED;
479:
480:

Line 531: BIS_COLLECTION_UTILITIES.PUT_LINE (err_mesg (SQLERRM, l_proc_name,

527: EXCEPTION
528:
529: WHEN OTHERS THEN
530:
531: BIS_COLLECTION_UTILITIES.PUT_LINE (err_mesg (SQLERRM, l_proc_name,
532: l_stmt_id));
533: RAISE LOG_UPDATE_FAILED;
534:
535: END update_log;

Line 629: BIS_COLLECTION_UTILITIES.PUT_LINE (err_mesg (SQLERRM, l_proc_name,

625:
626: EXCEPTION
627:
628: WHEN OTHERS THEN
629: BIS_COLLECTION_UTILITIES.PUT_LINE (err_mesg (SQLERRM, l_proc_name,
630: l_stmt_id));
631: RAISE TABLE_INIT_SETUP_FAILED;
632:
633: END setup_tables_init;

Line 716: BIS_COLLECTION_UTILITIES.PUT_LINE (err_mesg (SQLERRM, l_proc_name,

712: EXCEPTION
713:
714: WHEN OTHERS THEN
715:
716: BIS_COLLECTION_UTILITIES.PUT_LINE (err_mesg (SQLERRM, l_proc_name,
717: l_stmt_id));
718: RAISE INSERT_NEW_RATES_FAILED;
719:
720:

Line 807: BIS_COLLECTION_UTILITIES.PUT_LINE (C_SUCCESS_MESG);

803: print_stage_done_mesg (l_proc_name, l_stmt_id);
804:
805: errbuf := '';
806: retcode := C_SUCCESS;
807: BIS_COLLECTION_UTILITIES.PUT_LINE (C_SUCCESS_MESG);
808: return;
809:
810: EXCEPTION
811:

Line 817: BIS_COLLECTION_UTILITIES.PUT_LINE (err_mesg

813: rollback;
814: retcode := C_ERROR;
815: errbuf := C_INIT_LOAD_ERROR_MESG;
816:
817: BIS_COLLECTION_UTILITIES.PUT_LINE (err_mesg
818: (GLOBAL_START_DATE_NULL_MESG,
819: l_proc_name, l_stmt_id));
820: return;
821:

Line 827: BIS_COLLECTION_UTILITIES.PUT_LINE (err_mesg

823: rollback;
824: retcode := C_ERROR;
825: errbuf := C_INIT_LOAD_ERROR_MESG;
826:
827: BIS_COLLECTION_UTILITIES.PUT_LINE (err_mesg
828: (TABLE_INIT_SETUP_FAILED_MESG,
829: l_proc_name, l_stmt_id));
830: return;
831:

Line 837: BIS_COLLECTION_UTILITIES.PUT_LINE (err_mesg

833: rollback;
834: retcode := C_ERROR;
835: errbuf := C_INIT_LOAD_ERROR_MESG;
836:
837: BIS_COLLECTION_UTILITIES.PUT_LINE (err_mesg
838: (MEASURE_LIST_SETUP_FAILED_MESG,
839: l_proc_name, l_stmt_id));
840: return;
841:

Line 847: BIS_COLLECTION_UTILITIES.PUT_LINE (err_mesg

843: rollback;
844: retcode := C_ERROR;
845: errbuf := C_INIT_LOAD_ERROR_MESG;
846:
847: BIS_COLLECTION_UTILITIES.PUT_LINE (err_mesg
848: (INTRA_STD_CONV_FAILED_MESG,
849: l_proc_name, l_stmt_id));
850: return;
851:

Line 857: BIS_COLLECTION_UTILITIES.PUT_LINE (err_mesg

853: rollback;
854: retcode := C_ERROR;
855: errbuf := C_INIT_LOAD_ERROR_MESG;
856:
857: BIS_COLLECTION_UTILITIES.PUT_LINE (err_mesg
858: (INTER_STD_CONV_FAILED_MESG,
859: l_proc_name, l_stmt_id));
860: return;
861:

Line 867: BIS_COLLECTION_UTILITIES.PUT_LINE (err_mesg

863: rollback;
864: retcode := C_ERROR;
865: errbuf := C_INIT_LOAD_ERROR_MESG;
866:
867: BIS_COLLECTION_UTILITIES.PUT_LINE (err_mesg
868: (INSERT_NEW_RATES_FAILED_MESG,
869: l_proc_name, l_stmt_id));
870: return;
871:

Line 877: BIS_COLLECTION_UTILITIES.PUT_LINE (err_mesg

873: rollback;
874: retcode := C_ERROR;
875: errbuf := C_INIT_LOAD_ERROR_MESG;
876:
877: BIS_COLLECTION_UTILITIES.PUT_LINE (err_mesg
878: (LOG_UPDATE_FAILED_MESG,
879: l_proc_name, l_stmt_id));
880: return;
881:

Line 887: BIS_COLLECTION_UTILITIES.PUT_LINE (err_mesg (SQLERRM, l_proc_name,

883: rollback;
884: retcode := C_ERROR;
885: errbuf := C_INIT_LOAD_ERROR_MESG;
886:
887: BIS_COLLECTION_UTILITIES.PUT_LINE (err_mesg (SQLERRM, l_proc_name,
888: l_stmt_id));
889:
890: return;
891:

Line 950: BIS_COLLECTION_UTILITIES.PUT_LINE (err_mesg

946:
947: EXCEPTION
948:
949: WHEN LAST_RUN_RECORD_MISSING THEN
950: BIS_COLLECTION_UTILITIES.PUT_LINE (err_mesg
951: (LAST_RUN_RECORD_MISSING_MESG,
952: l_proc_name, l_stmt_id));
953: RAISE TABLE_INIT_SETUP_FAILED;
954:

Line 957: BIS_COLLECTION_UTILITIES.PUT_LINE (err_mesg (SQLERRM, l_proc_name,

953: RAISE TABLE_INIT_SETUP_FAILED;
954:
955:
956: WHEN OTHERS THEN
957: BIS_COLLECTION_UTILITIES.PUT_LINE (err_mesg (SQLERRM, l_proc_name,
958: l_stmt_id));
959: RAISE TABLE_INIT_SETUP_FAILED;
960:
961: END setup_tables_incr;

Line 1101: BIS_COLLECTION_UTILITIES.PUT_LINE (err_mesg (SQLERRM, l_proc_name,

1097: EXCEPTION
1098:
1099: WHEN OTHERS THEN
1100:
1101: BIS_COLLECTION_UTILITIES.PUT_LINE (err_mesg (SQLERRM, l_proc_name,
1102: l_stmt_id));
1103: RAISE MERGE_STD_RATES_FAILED;
1104:
1105: END merge_std_rates_incr;

Line 1196: BIS_COLLECTION_UTILITIES.PUT_LINE (C_SUCCESS_MESG);

1192: print_stage_done_mesg (l_proc_name, l_stmt_id);
1193:
1194: errbuf := '';
1195: retcode := C_SUCCESS;
1196: BIS_COLLECTION_UTILITIES.PUT_LINE (C_SUCCESS_MESG);
1197: return;
1198:
1199: EXCEPTION
1200:

Line 1206: BIS_COLLECTION_UTILITIES.PUT_LINE (err_mesg

1202: rollback;
1203: retcode := C_ERROR;
1204: errbuf := C_INCR_LOAD_ERROR_MESG;
1205:
1206: BIS_COLLECTION_UTILITIES.PUT_LINE (err_mesg
1207: (GLOBAL_START_DATE_NULL_MESG,
1208: l_proc_name, l_stmt_id));
1209: return;
1210:

Line 1216: BIS_COLLECTION_UTILITIES.PUT_LINE (err_mesg

1212: rollback;
1213: retcode := C_ERROR;
1214: errbuf := C_INCR_LOAD_ERROR_MESG;
1215:
1216: BIS_COLLECTION_UTILITIES.PUT_LINE (err_mesg
1217: (TABLE_INIT_SETUP_FAILED_MESG,
1218: l_proc_name, l_stmt_id));
1219: return;
1220:

Line 1226: BIS_COLLECTION_UTILITIES.PUT_LINE (err_mesg

1222: rollback;
1223: retcode := C_ERROR;
1224: errbuf := C_INCR_LOAD_ERROR_MESG;
1225:
1226: BIS_COLLECTION_UTILITIES.PUT_LINE (err_mesg
1227: (INTRA_STD_CONV_FAILED_MESG,
1228: l_proc_name, l_stmt_id));
1229: return;
1230:

Line 1236: BIS_COLLECTION_UTILITIES.PUT_LINE (err_mesg

1232: rollback;
1233: retcode := C_ERROR;
1234: errbuf := C_INCR_LOAD_ERROR_MESG;
1235:
1236: BIS_COLLECTION_UTILITIES.PUT_LINE (err_mesg
1237: (INTER_STD_CONV_FAILED_MESG,
1238: l_proc_name, l_stmt_id));
1239: return;
1240:

Line 1246: BIS_COLLECTION_UTILITIES.PUT_LINE (err_mesg

1242: rollback;
1243: retcode := C_ERROR;
1244: errbuf := C_INCR_LOAD_ERROR_MESG;
1245:
1246: BIS_COLLECTION_UTILITIES.PUT_LINE (err_mesg
1247: (MERGE_STD_RATES_FAILED_MESG,
1248: l_proc_name, l_stmt_id));
1249: return;
1250:

Line 1256: BIS_COLLECTION_UTILITIES.PUT_LINE (err_mesg

1252: rollback;
1253: retcode := C_ERROR;
1254: errbuf := C_INCR_LOAD_ERROR_MESG;
1255:
1256: BIS_COLLECTION_UTILITIES.PUT_LINE (err_mesg
1257: (LOG_UPDATE_FAILED_MESG,
1258: l_proc_name, l_stmt_id));
1259: return;
1260:

Line 1268: BIS_COLLECTION_UTILITIES.PUT_LINE (err_mesg (SQLERRM, l_proc_name,

1264:
1265: retcode := C_ERROR;
1266: errbuf := C_INCR_LOAD_ERROR_MESG;
1267:
1268: BIS_COLLECTION_UTILITIES.PUT_LINE (err_mesg (SQLERRM, l_proc_name,
1269: l_stmt_id));
1270:
1271: return;
1272: