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_EXCEPTION_PKG dependencies on MSC_PHUB_UTIL

Line 222: 23,md.using_requirement_quantity * msc_phub_util.get_list_price

218: 15,med.quantity *nvl(msi.list_price,0) * (1-(nvl(msi.average_discount,0)/100)),
219: 16,med.quantity *nvl(msi.list_price,0) * (1-(nvl(msi.average_discount,0)/100)),
220: 17, abs(med.quantity) *msi.standard_cost,
221: 18, med.quantity *msi.standard_cost,
222: 23,md.using_requirement_quantity * msc_phub_util.get_list_price
223: (med.plan_id,med.sr_instance_id,med.organization_id,md.inventory_item_id),
224: 24,abs(med.quantity) *nvl(msi.list_price,0) * (1-(nvl(msi.average_discount,0)/100)),
225: 25,abs(med.quantity) *nvl(msi.list_price,0) * (1-(nvl(msi.average_discount,0)/100)),
226: 26,abs(med.quantity) *nvl(msi.list_price,0) * (1-(nvl(msi.average_discount,0)/100)),

Line 239: 53,ms.new_order_quantity * msc_phub_util.get_list_price

235: 47,med.quantity *nvl(msi.list_price,0) * (1-(nvl(msi.average_discount,0)/100)),
236: 48,med.quantity *nvl(msi.list_price,0) * (1-(nvl(msi.average_discount,0)/100)),
237: 49,msc_get_name.demand_quantity(med.plan_id,med.sr_instance_id,
238: med.supplier_id)*nvl(msi.list_price,0) * (1-(nvl(msi.average_discount,0)/100)),
239: 53,ms.new_order_quantity * msc_phub_util.get_list_price
240: (med.plan_id,med.sr_instance_id,med.organization_id,ms.inventory_item_id),
241: 54,ms.new_order_quantity*nvl(msi.list_price,0) * (1-(nvl(msi.average_discount,0)/100)),
242: 55,ms.new_order_quantity*nvl(msi.list_price,0) * (1-(nvl(msi.average_discount,0)/100)),
243: 56,ms.new_order_quantity*nvl(msi.list_price,0) * (1-(nvl(msi.average_discount,0)/100)),

Line 245: 58,ms.new_order_quantity*msc_phub_util.get_list_price

241: 54,ms.new_order_quantity*nvl(msi.list_price,0) * (1-(nvl(msi.average_discount,0)/100)),
242: 55,ms.new_order_quantity*nvl(msi.list_price,0) * (1-(nvl(msi.average_discount,0)/100)),
243: 56,ms.new_order_quantity*nvl(msi.list_price,0) * (1-(nvl(msi.average_discount,0)/100)),
244: 57,ms.new_order_quantity*nvl(msi.list_price,0) * (1-(nvl(msi.average_discount,0)/100)),
245: 58,ms.new_order_quantity*msc_phub_util.get_list_price
246: (med.plan_id,med.sr_instance_id,med.organization_id,ms.inventory_item_id),
247: 59,ms.new_order_quantity*nvl(msi.list_price,0) * (1-(nvl(msi.average_discount,0)/100)),
248: 60,ms.new_order_quantity*msc_phub_util.get_list_price
249: (med.plan_id,med.sr_instance_id,med.organization_id,ms.inventory_item_id),

Line 248: 60,ms.new_order_quantity*msc_phub_util.get_list_price

244: 57,ms.new_order_quantity*nvl(msi.list_price,0) * (1-(nvl(msi.average_discount,0)/100)),
245: 58,ms.new_order_quantity*msc_phub_util.get_list_price
246: (med.plan_id,med.sr_instance_id,med.organization_id,ms.inventory_item_id),
247: 59,ms.new_order_quantity*nvl(msi.list_price,0) * (1-(nvl(msi.average_discount,0)/100)),
248: 60,ms.new_order_quantity*msc_phub_util.get_list_price
249: (med.plan_id,med.sr_instance_id,med.organization_id,ms.inventory_item_id),
250: 62,ms.new_order_quantity*nvl(msi.list_price,0) * (1-(nvl(msi.average_discount,0)/100)),
251: 63,ms.new_order_quantity*nvl(msi.list_price,0) * (1-(nvl(msi.average_discount,0)/100)),
252: 64,ms.new_order_quantity*nvl(msi.list_price,0) * (1-(nvl(msi.average_discount,0)/100)),

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

608:
609: EXCEPTION
610: WHEN DUP_VAL_ON_INDEX THEN
611: --dbms_output.put_line('exception '||SQLCODE||', '||SQLERRM);
612: errbuf := msc_phub_util.get_planning_hub_message('MSC_HUB_DUPLICATE_DATA')||SQLCODE||' -ERROR- '||SQLERRM;
613: retcode := 2;
614: WHEN OTHERS THEN
615: --dbms_output.put_line('exception '||SQLCODE||', '||SQLERRM);
616: errbuf := msc_phub_util.get_planning_hub_message('MSC_HUB_POPULATE_ERROR')||SQLCODE||' -ERROR- '||SQLERRM;

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

612: errbuf := msc_phub_util.get_planning_hub_message('MSC_HUB_DUPLICATE_DATA')||SQLCODE||' -ERROR- '||SQLERRM;
613: retcode := 2;
614: WHEN OTHERS THEN
615: --dbms_output.put_line('exception '||SQLCODE||', '||SQLERRM);
616: errbuf := msc_phub_util.get_planning_hub_message('MSC_HUB_POPULATE_ERROR')||SQLCODE||' -ERROR- '||SQLERRM;
617: retcode := 2;
618: END populate_details;
619:
620: procedure populate_summary(errbuf out nocopy varchar2, retcode out nocopy varchar2,

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

765: commit;
766:
767: exception
768: when dup_val_on_index then
769: errbuf := msc_phub_util.get_planning_hub_message('MSC_HUB_DUPLICATE_DATA')||
770: SQLCODE||' -ERROR- '||SQLERRM;
771: retcode := 2;
772: when others then
773: errbuf := msc_phub_util.get_planning_hub_message('MSC_HUB_POPULATE_ERROR')||

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

769: errbuf := msc_phub_util.get_planning_hub_message('MSC_HUB_DUPLICATE_DATA')||
770: SQLCODE||' -ERROR- '||SQLERRM;
771: retcode := 2;
772: when others then
773: errbuf := msc_phub_util.get_planning_hub_message('MSC_HUB_POPULATE_ERROR')||
774: SQLCODE||' -ERROR- '||SQLERRM;
775: retcode := 2;
776:
777: end populate_summary;

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

788: COMMIT;
789:
790: EXCEPTION
791: WHEN OTHERS THEN
792: errbuf := msc_phub_util.get_planning_hub_message('MSC_HUB_PURGE_ERROR')||SQLCODE||' -ERROR- '||SQLERRM;
793: retcode := 2;
794: END purge_details;
795:
796: END MSC_EXCEPTION_PKG;