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.MSC_RESOURCE_PKG dependencies on MSC_PHUB_UTIL

Line 9: l_constrained_plan := msc_phub_util.is_plan_constrained(p_plan_id);

5: PROCEDURE populate_details(errbuf out nocopy varchar2, retcode out nocopy varchar2, p_plan_id in number, p_plan_run_id in number) IS
6:
7: BEGIN
8:
9: l_constrained_plan := msc_phub_util.is_plan_constrained(p_plan_id);
10: retcode := 0;
11: errbuf := NULL;
12:
13: insert into msc_resources_f(

Line 300: errbuf := msc_phub_util.get_planning_hub_message('MSC_HUB_DUPLICATE_DATA')||SQLCODE||' -ERROR- '||SQLERRM;

296: populate_summary(errbuf, retcode, p_plan_id, p_plan_run_id);
297:
298: EXCEPTION
299: WHEN DUP_VAL_ON_INDEX THEN
300: errbuf := msc_phub_util.get_planning_hub_message('MSC_HUB_DUPLICATE_DATA')||SQLCODE||' -ERROR- '||SQLERRM;
301: retcode := 2;
302: WHEN OTHERS THEN
303: errbuf := msc_phub_util.get_planning_hub_message('MSC_HUB_POPULATE_ERROR')||SQLCODE||' -ERROR- '||SQLERRM;
304: retcode := 2;

Line 303: errbuf := msc_phub_util.get_planning_hub_message('MSC_HUB_POPULATE_ERROR')||SQLCODE||' -ERROR- '||SQLERRM;

299: WHEN DUP_VAL_ON_INDEX THEN
300: errbuf := msc_phub_util.get_planning_hub_message('MSC_HUB_DUPLICATE_DATA')||SQLCODE||' -ERROR- '||SQLERRM;
301: retcode := 2;
302: WHEN OTHERS THEN
303: errbuf := msc_phub_util.get_planning_hub_message('MSC_HUB_POPULATE_ERROR')||SQLCODE||' -ERROR- '||SQLERRM;
304: retcode := 2;
305: END populate_details;
306:
307: procedure populate_summary(errbuf out nocopy varchar2, retcode out nocopy varchar2,

Line 493: errbuf := msc_phub_util.get_planning_hub_message('MSC_HUB_DUPLICATE_DATA')||

489: commit;
490:
491: exception
492: when dup_val_on_index then
493: errbuf := msc_phub_util.get_planning_hub_message('MSC_HUB_DUPLICATE_DATA')||
494: SQLCODE||' -ERROR- '||SQLERRM;
495: retcode := 2;
496: when others then
497: errbuf := msc_phub_util.get_planning_hub_message('MSC_HUB_POPULATE_ERROR')||

Line 497: errbuf := msc_phub_util.get_planning_hub_message('MSC_HUB_POPULATE_ERROR')||

493: errbuf := msc_phub_util.get_planning_hub_message('MSC_HUB_DUPLICATE_DATA')||
494: SQLCODE||' -ERROR- '||SQLERRM;
495: retcode := 2;
496: when others then
497: errbuf := msc_phub_util.get_planning_hub_message('MSC_HUB_POPULATE_ERROR')||
498: SQLCODE||' -ERROR- '||SQLERRM;
499: retcode := 2;
500:
501: end populate_summary;

Line 517: errbuf := msc_phub_util.get_planning_hub_message('MSC_HUB_PURGE_ERROR')||SQLCODE||' -ERROR- '||SQLERRM;

513: COMMIT;
514:
515: EXCEPTION
516: WHEN OTHERS THEN
517: errbuf := msc_phub_util.get_planning_hub_message('MSC_HUB_PURGE_ERROR')||SQLCODE||' -ERROR- '||SQLERRM;
518: retcode := 2;
519:
520: END purge_details;
521: