APPS.RCI_PROC_DETAIL_ETL_PKG dependencies on BIS_COLLECTION_UTILITIES

Line 65: BIS_COLLECTION_UTILITIES.PUT_LINE (err_mesg (INITIALIZATION_ERROR_MESG || ':' || l_message,l_proc_name, l_stmt_id));

61: RAISE INITIALIZATION_ERROR;
62: END IF;
63: EXCEPTION
64: WHEN INITIALIZATION_ERROR THEN
65: BIS_COLLECTION_UTILITIES.PUT_LINE (err_mesg (INITIALIZATION_ERROR_MESG || ':' || l_message,l_proc_name, l_stmt_id));
66: WHEN OTHERS THEN
67: BIS_COLLECTION_UTILITIES.PUT_LINE (err_mesg (SQLERRM, l_proc_name,l_stmt_id));
68: RAISE;
69: END check_initial_load_setup;

Line 67: BIS_COLLECTION_UTILITIES.PUT_LINE (err_mesg (SQLERRM, l_proc_name,l_stmt_id));

63: EXCEPTION
64: WHEN INITIALIZATION_ERROR THEN
65: BIS_COLLECTION_UTILITIES.PUT_LINE (err_mesg (INITIALIZATION_ERROR_MESG || ':' || l_message,l_proc_name, l_stmt_id));
66: WHEN OTHERS THEN
67: BIS_COLLECTION_UTILITIES.PUT_LINE (err_mesg (SQLERRM, l_proc_name,l_stmt_id));
68: RAISE;
69: END check_initial_load_setup;
70:
71: -- check_incr_load_setup

Line 96: BIS_COLLECTION_UTILITIES.PUT_LINE (err_mesg ('Please launch the Initial Load Request Set for the RCI Organization Certifications Summary page.'

92:
93: RETURN l_last_run_date;
94: EXCEPTION
95: WHEN NO_DATA_FOUND THEN
96: BIS_COLLECTION_UTILITIES.PUT_LINE (err_mesg ('Please launch the Initial Load Request Set for the RCI Organization Certifications Summary page.'
97: ,l_func_name,l_stmt_id));
98: RAISE ;
99: WHEN OTHERS THEN
100: BIS_COLLECTION_UTILITIES.PUT_LINE (err_mesg (SQLERRM, l_func_name,l_stmt_id));

Line 100: BIS_COLLECTION_UTILITIES.PUT_LINE (err_mesg (SQLERRM, l_func_name,l_stmt_id));

96: BIS_COLLECTION_UTILITIES.PUT_LINE (err_mesg ('Please launch the Initial Load Request Set for the RCI Organization Certifications Summary page.'
97: ,l_func_name,l_stmt_id));
98: RAISE ;
99: WHEN OTHERS THEN
100: BIS_COLLECTION_UTILITIES.PUT_LINE (err_mesg (SQLERRM, l_func_name,l_stmt_id));
101: RAISE ;
102: END get_last_run_date;
103:
104:

Line 191: BIS_COLLECTION_UTILITIES.PUT_LINE (err_mesg (SQLERRM || l_err_msg ));

187:
188: EXCEPTION
189:
190: WHEN MISSING_INV_VALIDATION_ORG THEN
191: BIS_COLLECTION_UTILITIES.PUT_LINE (err_mesg (SQLERRM || l_err_msg ));
192:
193: WHEN OTHERS THEN
194: BIS_COLLECTION_UTILITIES.PUT_LINE (err_mesg (SQLERRM, l_func_name,l_stmt_id));
195: RAISE ;

Line 194: BIS_COLLECTION_UTILITIES.PUT_LINE (err_mesg (SQLERRM, l_func_name,l_stmt_id));

190: WHEN MISSING_INV_VALIDATION_ORG THEN
191: BIS_COLLECTION_UTILITIES.PUT_LINE (err_mesg (SQLERRM || l_err_msg ));
192:
193: WHEN OTHERS THEN
194: BIS_COLLECTION_UTILITIES.PUT_LINE (err_mesg (SQLERRM, l_func_name,l_stmt_id));
195: RAISE ;
196:
197: END get_master_organization_id;
198: ***/

Line 403: BIS_COLLECTION_UTILITIES.PUT_LINE (err_mesg (SQLERRM, l_proc_name, l_stmnt_id));

399: retcode := C_OK;
400: EXCEPTION
401: WHEN OTHERS THEN
402: retcode := C_ERROR;
403: BIS_COLLECTION_UTILITIES.PUT_LINE (err_mesg (SQLERRM, l_proc_name, l_stmnt_id));
404: ROLLBACK;
405: RAISE;
406: END initial_load;
407:

Line 604: BIS_COLLECTION_UTILITIES.PUT_LINE (err_mesg (SQLERRM, l_proc_name, l_stmnt_id));

600: retcode := C_OK;
601: EXCEPTION
602: WHEN OTHERS THEN
603: retcode := C_ERROR;
604: BIS_COLLECTION_UTILITIES.PUT_LINE (err_mesg (SQLERRM, l_proc_name, l_stmnt_id));
605: ROLLBACK;
606: RAISE;
607: END initial_load_obsolete;
608:

Line 800: BIS_COLLECTION_UTILITIES.PUT_LINE (err_mesg (SQLERRM || ':' || l_message, l_proc_name, l_stmnt_id));

796:
797: EXCEPTION
798: WHEN OTHERS THEN
799: retcode := C_ERROR;
800: BIS_COLLECTION_UTILITIES.PUT_LINE (err_mesg (SQLERRM || ':' || l_message, l_proc_name, l_stmnt_id));
801: ROLLBACK;
802: RAISE;
803: END incr_load;
804:

Line 983: BIS_COLLECTION_UTILITIES.PUT_LINE (err_mesg (SQLERRM || ':' || l_message, l_proc_name, l_stmnt_id));

979:
980: EXCEPTION
981: WHEN OTHERS THEN
982: retcode := C_ERROR;
983: BIS_COLLECTION_UTILITIES.PUT_LINE (err_mesg (SQLERRM || ':' || l_message, l_proc_name, l_stmnt_id));
984: ROLLBACK;
985: RAISE;
986: END incr_load_obsolete;
987: