eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OPI_DBI_RES_OPM_PKG dependencies on BIS_COLLECTION_UTILITIES

Line 64: BIS_COLLECTION_UTILITIES.PUT_LINE('There are missing date in Time Dimension.');

60: */
61: IF l_missing_day_flag THEN
62: retcode := 2;
63: errbuf := 'Please check log file for details. ';
64: BIS_COLLECTION_UTILITIES.PUT_LINE('There are missing date in Time Dimension.');
65:
66: BIS_COLLECTION_UTILITIES.PUT_LINE('The range is from ' || l_min_miss_date
67: ||' to ' || l_max_miss_date );
68: END IF;

Line 66: BIS_COLLECTION_UTILITIES.PUT_LINE('The range is from ' || l_min_miss_date

62: retcode := 2;
63: errbuf := 'Please check log file for details. ';
64: BIS_COLLECTION_UTILITIES.PUT_LINE('There are missing date in Time Dimension.');
65:
66: BIS_COLLECTION_UTILITIES.PUT_LINE('The range is from ' || l_min_miss_date
67: ||' to ' || l_max_miss_date );
68: END IF;
69: ELSE
70: retcode := 2;

Line 72: BIS_COLLECTION_UTILITIES.PUT_LINE('Global Parameters are not setup.');

68: END IF;
69: ELSE
70: retcode := 2;
71: errbuf := 'Please check log file for details. ';
72: BIS_COLLECTION_UTILITIES.PUT_LINE('Global Parameters are not setup.');
73:
74: BIS_COLLECTION_UTILITIES.put_line('Please check that the profile options: BIS_PRIMARY_CURRENCY_CODE and BIS_GLOBAL_START_DATE are setup.');
75:
76: END IF;

Line 74: BIS_COLLECTION_UTILITIES.put_line('Please check that the profile options: BIS_PRIMARY_CURRENCY_CODE and BIS_GLOBAL_START_DATE are setup.');

70: retcode := 2;
71: errbuf := 'Please check log file for details. ';
72: BIS_COLLECTION_UTILITIES.PUT_LINE('Global Parameters are not setup.');
73:
74: BIS_COLLECTION_UTILITIES.put_line('Please check that the profile options: BIS_PRIMARY_CURRENCY_CODE and BIS_GLOBAL_START_DATE are setup.');
75:
76: END IF;
77:
78: g_hr_uom := fnd_profile.value('SY$UOM_HOURS');

Line 86: BIS_COLLECTION_UTILITIES.PUT_LINE('Error Number: ' || retcode);

82: retcode := SQLCODE;
83: errbuf := 'ERROR in OPI_DBI_RES_PKG.CHECK_SETUP_GLOBALS '
84: || substr(SQLERRM, 1,200);
85:
86: BIS_COLLECTION_UTILITIES.PUT_LINE('Error Number: ' || retcode);
87: BIS_COLLECTION_UTILITIES.PUT_LINE('Error Message: ' || errbuf);
88:
89: --dbms_output.put_line('check_setup_globals ' || errbuf);
90:

Line 87: BIS_COLLECTION_UTILITIES.PUT_LINE('Error Message: ' || errbuf);

83: errbuf := 'ERROR in OPI_DBI_RES_PKG.CHECK_SETUP_GLOBALS '
84: || substr(SQLERRM, 1,200);
85:
86: BIS_COLLECTION_UTILITIES.PUT_LINE('Error Number: ' || retcode);
87: BIS_COLLECTION_UTILITIES.PUT_LINE('Error Message: ' || errbuf);
88:
89: --dbms_output.put_line('check_setup_globals ' || errbuf);
90:
91: END check_setup_globals;

Line 217: BIS_COLLECTION_UTILITIES.put_line('OPM Resource Availability: ' ||

213: l_rowcount := sql%rowcount;
214:
215: COMMIT;
216:
217: BIS_COLLECTION_UTILITIES.put_line('OPM Resource Availability: ' ||
218: to_char(l_rowcount) || ' rows initially collected into staging table at '||
219: to_char(Sysdate, 'hh24:mi:ss dd-mon-yyyy'));
220:
221: EXCEPTION WHEN OTHERS THEN

Line 228: BIS_COLLECTION_UTILITIES.PUT_LINE('Exception in initial_opm_res_avail ' || errbuf );

224: Retcode:= SQLCODE;
225:
226: ROLLBACK;
227:
228: BIS_COLLECTION_UTILITIES.PUT_LINE('Exception in initial_opm_res_avail ' || errbuf );
229:
230: --dbms_output.put_line('initial_opm_res_avail ' || errbuf);
231: END initial_opm_res_avail;
232:

Line 370: BIS_COLLECTION_UTILITIES.put_line('OPM resource actuals: ' ||

366: l_rowcount := sql%rowcount;
367:
368: COMMIT;
369:
370: BIS_COLLECTION_UTILITIES.put_line('OPM resource actuals: ' ||
371: TO_CHAR(l_rowcount) || ' rows initially collected into staging table at ' ||
372: To_char(Sysdate, 'hh24:mi:ss dd-mon-yyyy'));
373:
374: EXCEPTION WHEN OTHERS THEN

Line 381: BIS_COLLECTION_UTILITIES.PUT_LINE('Exception in initial_opm_res_actual ' || errbuf );

377: Retcode:= SQLCODE;
378:
379: ROLLBACK;
380:
381: BIS_COLLECTION_UTILITIES.PUT_LINE('Exception in initial_opm_res_actual ' || errbuf );
382:
383: --dbms_output.put_line('initial_opm_res_actual ' || errbuf);
384:
385: END initial_opm_res_actual;

Line 589: BIS_COLLECTION_UTILITIES.put_line('OPM resource std: ' ||

585: AND source = 2;
586:
587: COMMIT;
588:
589: BIS_COLLECTION_UTILITIES.put_line('OPM resource std: ' ||
590: TO_CHAR(l_rowcount) || ' rows initially collected into staging table at ' ||
591: To_char(Sysdate, 'hh24:mi:ss dd-mon-yyyy'));
592:
593: EXCEPTION WHEN OTHERS THEN

Line 599: bis_collection_utilities.wrapup(p_status => FALSE,

595: Errbuf:= Sqlerrm;
596: Retcode:= SQLCODE;
597:
598: ROLLBACK;
599: bis_collection_utilities.wrapup(p_status => FALSE,
600: p_count => 0,
601: p_message => 'failed in complete_refresh_margin.'
602: );
603:

Line 747: BIS_COLLECTION_UTILITIES.put_line('OPM resource availability: ' ||

743: l_rowcount := sql%rowcount;
744:
745: COMMIT;
746:
747: BIS_COLLECTION_UTILITIES.put_line('OPM resource availability: ' ||
748: TO_CHAR(l_rowcount) || ' rows incrementally collected into staging table at ' ||
749: To_char(Sysdate, 'hh24:mi:ss dd-mon-yyyy'));
750:
751: EXCEPTION WHEN OTHERS THEN

Line 758: BIS_COLLECTION_UTILITIES.PUT_LINE('Exception in incremental_opm_res_avail ' || errbuf );

754: Retcode:= SQLCODE;
755:
756: ROLLBACK;
757:
758: BIS_COLLECTION_UTILITIES.PUT_LINE('Exception in incremental_opm_res_avail ' || errbuf );
759:
760: --dbms_output.put_line('incremental_opm_res_avail ' || errbuf);
761: END incremental_opm_res_avail;
762:

Line 900: BIS_COLLECTION_UTILITIES.put_line('OPM resource actuals: ' ||

896: l_rowcount := sql%rowcount;
897:
898: COMMIT;
899:
900: BIS_COLLECTION_UTILITIES.put_line('OPM resource actuals: ' ||
901: TO_CHAR(l_rowcount) || ' rows incrementally collected into staging table at ' ||
902: To_char(Sysdate, 'hh24:mi:ss dd-mon-yyyy'));
903:
904: EXCEPTION WHEN OTHERS THEN

Line 911: BIS_COLLECTION_UTILITIES.PUT_LINE('Exception in incremental_opm_res_actual ' || errbuf );

907: Retcode:= SQLCODE;
908:
909: ROLLBACK;
910:
911: BIS_COLLECTION_UTILITIES.PUT_LINE('Exception in incremental_opm_res_actual ' || errbuf );
912:
913: --dbms_output.put_line('incremental_opm_res_actual ' || errbuf);
914:
915: END incremental_opm_res_actual;

Line 1125: BIS_COLLECTION_UTILITIES.put_line('OPM resource std: ' ||

1121: last_update_login = g_login_id
1122: WHERE std_res_flag = 1
1123: AND source = 2;
1124:
1125: BIS_COLLECTION_UTILITIES.put_line('OPM resource std: ' ||
1126: TO_CHAR(l_rowcount) || ' rows incrementally collected into staging table at ' ||
1127: To_char(Sysdate, 'hh24:mi:ss dd-mon-yyyy'));
1128:
1129: EXCEPTION WHEN OTHERS THEN

Line 1135: bis_collection_utilities.wrapup(p_status => FALSE,

1131: Errbuf:= Sqlerrm;
1132: Retcode:= SQLCODE;
1133:
1134: ROLLBACK;
1135: bis_collection_utilities.wrapup(p_status => FALSE,
1136: p_count => 0,
1137: p_message => 'failed in complete_refresh_margin.'
1138: );
1139: