DBA Data[Home] [Help]

APPS.RCI_ORG_DFCY_ETL_PKG dependencies on BIS_COLLECTION_UTILITIES

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

66: RAISE INITIALIZATION_ERROR;
67: END IF;
68: EXCEPTION
69: WHEN INITIALIZATION_ERROR THEN
70: BIS_COLLECTION_UTILITIES.PUT_LINE (err_mesg (INITIALIZATION_ERROR_MESG || ':' || l_message,l_proc_name, l_stmt_id));
71: WHEN OTHERS THEN
72: BIS_COLLECTION_UTILITIES.PUT_LINE (err_mesg (SQLERRM, l_proc_name,l_stmt_id));
73: RAISE;
74: END check_initial_load_setup;

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

68: EXCEPTION
69: WHEN INITIALIZATION_ERROR THEN
70: BIS_COLLECTION_UTILITIES.PUT_LINE (err_mesg (INITIALIZATION_ERROR_MESG || ':' || l_message,l_proc_name, l_stmt_id));
71: WHEN OTHERS THEN
72: BIS_COLLECTION_UTILITIES.PUT_LINE (err_mesg (SQLERRM, l_proc_name,l_stmt_id));
73: RAISE;
74: END check_initial_load_setup;
75:
76: -- check_incr_load_setup

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

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

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

101: BIS_COLLECTION_UTILITIES.PUT_LINE (err_mesg ('Please launch the Initial Load Request Set for the RCI Organization Certifications Summary page.'
102: ,l_func_name,l_stmt_id));
103: RAISE ;
104: WHEN OTHERS THEN
105: BIS_COLLECTION_UTILITIES.PUT_LINE (err_mesg (SQLERRM, l_func_name,l_stmt_id));
106: RAISE ;
107: END get_last_run_date;
108:
109:

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

478: retcode := C_OK;
479: EXCEPTION
480: WHEN OTHERS THEN
481: retcode := C_ERROR;
482: BIS_COLLECTION_UTILITIES.PUT_LINE (err_mesg (SQLERRM, l_proc_name, l_stmnt_id));
483: ROLLBACK;
484: RAISE;
485: END initial_load;
486:

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

740: retcode := C_OK;
741: EXCEPTION
742: WHEN OTHERS THEN
743: retcode := C_ERROR;
744: BIS_COLLECTION_UTILITIES.PUT_LINE (err_mesg (SQLERRM, l_proc_name, l_stmnt_id));
745: ROLLBACK;
746: RAISE;
747: END initial_load_obsolete;
748:

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

1006: retcode := C_OK;
1007: EXCEPTION
1008: WHEN OTHERS THEN
1009: retcode := C_ERROR;
1010: BIS_COLLECTION_UTILITIES.PUT_LINE (err_mesg (SQLERRM || ':' || l_message, l_proc_name, l_stmnt_id));
1011: ROLLBACK;
1012: RAISE;
1013: END incr_load;
1014:

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

1245: retcode := C_OK;
1246: EXCEPTION
1247: WHEN OTHERS THEN
1248: retcode := C_ERROR;
1249: BIS_COLLECTION_UTILITIES.PUT_LINE (err_mesg (SQLERRM || ':' || l_message, l_proc_name, l_stmnt_id));
1250: ROLLBACK;
1251: RAISE;
1252: END incr_load_obsolete;
1253: