APPS.RCI_ORG_CERT_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 470: BIS_COLLECTION_UTILITIES.PUT_LINE (err_mesg (SQLERRM, l_proc_name, l_stmnt_id));

466: retcode := C_OK;
467: EXCEPTION
468: WHEN OTHERS THEN
469: retcode := C_ERROR;
470: BIS_COLLECTION_UTILITIES.PUT_LINE (err_mesg (SQLERRM, l_proc_name, l_stmnt_id));
471: ROLLBACK;
472: RAISE;
473: END initial_load;
474:

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

736: retcode := C_ERROR;
737: ----dbms_output.put_line( 'In OTHERS **************' );
738: ----dbms_output.put_line( 'errmsdg: '||substr ((l_proc_name || ' #' ||to_char (l_stmnt_id) || ': ' || SQLERRM),
739: ----- 1, C_ERRBUF_SIZE) );
740: BIS_COLLECTION_UTILITIES.PUT_LINE (err_mesg (SQLERRM, l_proc_name, l_stmnt_id));
741: ROLLBACK;
742: RAISE;
743: END initial_load_obsolete;
744:

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

987: retcode := C_OK;
988: EXCEPTION
989: WHEN OTHERS THEN
990: retcode := C_ERROR;
991: BIS_COLLECTION_UTILITIES.PUT_LINE (err_mesg (SQLERRM || ':' || l_message, l_proc_name, l_stmnt_id));
992: ROLLBACK;
993: RAISE;
994: END incr_load;
995:

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

1238:
1239: EXCEPTION
1240: WHEN OTHERS THEN
1241: retcode := C_ERROR;
1242: BIS_COLLECTION_UTILITIES.PUT_LINE (err_mesg (SQLERRM || ':' || l_message, l_proc_name, l_stmnt_id));
1243: ROLLBACK;
1244: RAISE;
1245: END incr_load_obsolete;
1246: