APPS.OPI_DBI_PRE_R12_RES_PKG dependencies on BIS_COLLECTION_UTILITIES

Line 36: bis_collection_utilities.put_line('Enter pre_r12_opm_res_actual() ' ||

32:
33: retcode := 0;
34: g_hr_uom := fnd_profile.value( 'BOM:HOUR_UOM_CODE');
35:
36: bis_collection_utilities.put_line('Enter pre_r12_opm_res_actual() ' ||
37: To_char(Sysdate, 'hh24:mi:ss dd-mon-yyyy'));
38:
39: INSERT /*+ append */ INTO opi_dbi_res_actual_stg (
40: resource_id,

Line 106: bis_collection_utilities.put_line('From Pre R12 Data Model - OPM Resource Actual: ' ||

102:
103:
104: l_rowcount := sql%rowcount;
105:
106: bis_collection_utilities.put_line('From Pre R12 Data Model - OPM Resource Actual: ' ||
107: to_char(l_rowcount) || ' rows initially collected into staging table at '||
108: to_char(Sysdate, 'hh24:mi:ss dd-mon-yyyy'));
109:
110: bis_collection_utilities.put_line('Exit pre_r12_opm_res_actual() ' ||

Line 110: bis_collection_utilities.put_line('Exit pre_r12_opm_res_actual() ' ||

106: bis_collection_utilities.put_line('From Pre R12 Data Model - OPM Resource Actual: ' ||
107: to_char(l_rowcount) || ' rows initially collected into staging table at '||
108: to_char(Sysdate, 'hh24:mi:ss dd-mon-yyyy'));
109:
110: bis_collection_utilities.put_line('Exit pre_r12_opm_res_actual() ' ||
111: To_char(Sysdate, 'hh24:mi:ss dd-mon-yyyy'));
112: EXCEPTION WHEN OTHERS THEN
113: --{
114: errbuf:= Sqlerrm;

Line 119: bis_collection_utilities.put_line('Exception in pre_r12_opm_res_actual ' || errbuf );

115: retcode:= SQLCODE;
116:
117: ROLLBACK;
118:
119: bis_collection_utilities.put_line('Exception in pre_r12_opm_res_actual ' || errbuf );
120: --}
121: END pre_r12_opm_res_actual;
122:
123: