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_EXP_WF dependencies on MSC_EXP_WF

Line 1: PACKAGE BODY msc_exp_wf AS

1: PACKAGE BODY msc_exp_wf AS
2: /*$Header: MSCEXWFB.pls 120.5 2007/12/14 21:41:33 eychen ship $ */
3:
4: CURSOR PLANNER_C( p_plan_id in number, p_inventory_item_id in number,
5: p_organization_id in number, p_instance_id in number) IS

Line 90: 49,msc_exp_wf.substitute_supply_date(exp.plan_id,exp.sr_instance_id,exp.supplier_id),

86: 27, md.using_assembly_demand_date,28, NULL,37, NULL,
87: 24, md.using_assembly_demand_date,
88: 25, md.using_assembly_demand_date,
89: 26, md.using_assembly_demand_date,
90: 49,msc_exp_wf.substitute_supply_date(exp.plan_id,exp.sr_instance_id,exp.supplier_id),
91: exp.DATE1),
92: DECODE(EXP.EXCEPTION_TYPE,1,EXP.DATE1, 2, EXP.DATE1, 3, EXP.DATE1,
93: 6, EXP.DATE1, 7,EXP.DATE1, 17, EXP.DATE1, 18, EXP.DATE1,
94: 20, EXP.DATE1, 28, EXP.DATE1, 37, EXP.DATE1,15, md2.using_assembly_demand_date,16, md2.using_assembly_demand_date,49,msc_exp_wf.demand_order_date(exp.plan_id,exp.sr_instance_id,exp.supplier_id),

Line 94: 20, EXP.DATE1, 28, EXP.DATE1, 37, EXP.DATE1,15, md2.using_assembly_demand_date,16, md2.using_assembly_demand_date,49,msc_exp_wf.demand_order_date(exp.plan_id,exp.sr_instance_id,exp.supplier_id),

90: 49,msc_exp_wf.substitute_supply_date(exp.plan_id,exp.sr_instance_id,exp.supplier_id),
91: exp.DATE1),
92: DECODE(EXP.EXCEPTION_TYPE,1,EXP.DATE1, 2, EXP.DATE1, 3, EXP.DATE1,
93: 6, EXP.DATE1, 7,EXP.DATE1, 17, EXP.DATE1, 18, EXP.DATE1,
94: 20, EXP.DATE1, 28, EXP.DATE1, 37, EXP.DATE1,15, md2.using_assembly_demand_date,16, md2.using_assembly_demand_date,49,msc_exp_wf.demand_order_date(exp.plan_id,exp.sr_instance_id,exp.supplier_id),
95: NULL),
96: DECODE(exp.EXCEPTION_TYPE, 15, msc_exp_wf.demand_order_date(exp.plan_id,exp.sr_instance_id,exp.demand_id),16,msc_exp_wf.demand_order_date(exp.plan_id,exp.sr_instance_id,exp.demand_id),exp.date2),
97: DECODE(exp.EXCEPTION_TYPE, 9, sup.SCHEDULE_COMPRESS_DAYS,NULL),
98: decode(exp.exception_type,

Line 96: DECODE(exp.EXCEPTION_TYPE, 15, msc_exp_wf.demand_order_date(exp.plan_id,exp.sr_instance_id,exp.demand_id),16,msc_exp_wf.demand_order_date(exp.plan_id,exp.sr_instance_id,exp.demand_id),exp.date2),

92: DECODE(EXP.EXCEPTION_TYPE,1,EXP.DATE1, 2, EXP.DATE1, 3, EXP.DATE1,
93: 6, EXP.DATE1, 7,EXP.DATE1, 17, EXP.DATE1, 18, EXP.DATE1,
94: 20, EXP.DATE1, 28, EXP.DATE1, 37, EXP.DATE1,15, md2.using_assembly_demand_date,16, md2.using_assembly_demand_date,49,msc_exp_wf.demand_order_date(exp.plan_id,exp.sr_instance_id,exp.supplier_id),
95: NULL),
96: DECODE(exp.EXCEPTION_TYPE, 15, msc_exp_wf.demand_order_date(exp.plan_id,exp.sr_instance_id,exp.demand_id),16,msc_exp_wf.demand_order_date(exp.plan_id,exp.sr_instance_id,exp.demand_id),exp.date2),
97: DECODE(exp.EXCEPTION_TYPE, 9, sup.SCHEDULE_COMPRESS_DAYS,NULL),
98: decode(exp.exception_type,
99: 37,nvl(exp.number4,0)-nvl(exp.quantity,0),
100: 28,MSC_EXP_WF.SupplierCapacity(p_plan_id,exp.exception_detail_id),

Line 100: 28,MSC_EXP_WF.SupplierCapacity(p_plan_id,exp.exception_detail_id),

96: DECODE(exp.EXCEPTION_TYPE, 15, msc_exp_wf.demand_order_date(exp.plan_id,exp.sr_instance_id,exp.demand_id),16,msc_exp_wf.demand_order_date(exp.plan_id,exp.sr_instance_id,exp.demand_id),exp.date2),
97: DECODE(exp.EXCEPTION_TYPE, 9, sup.SCHEDULE_COMPRESS_DAYS,NULL),
98: decode(exp.exception_type,
99: 37,nvl(exp.number4,0)-nvl(exp.quantity,0),
100: 28,MSC_EXP_WF.SupplierCapacity(p_plan_id,exp.exception_detail_id),
101: 49,msc_get_name.demand_quantity(exp.plan_id,exp.sr_instance_id,
102: exp.supplier_id),
103: exp.quantity),
104: decode(exp.exception_type, 12, sup.lot_number),

Line 156: decode(exp.exception_type, 49, msc_exp_wf.demand_order_type(exp.plan_id,exp.sr_instance_id,exp.supplier_id),sup.order_type),

152: 3, msc_get_name.demand_quantity(exp.plan_id,exp.sr_instance_id,md2.demand_id),null),
153: decode(exp.exception_type, 12, null, 13, null, 14, null,
154: 17, null, 18, null, 24, null, 25, null, 26, null,
155: 27, null, 28, null, 37, exp.number2, exp.number1),
156: decode(exp.exception_type, 49, msc_exp_wf.demand_order_type(exp.plan_id,exp.sr_instance_id,exp.supplier_id),sup.order_type),
157: decode(exp.exception_type, 37, exp.number4,null),
158: exp.number1,
159: exp.number2
160: FROM msc_supplies sup,

Line 263: 49,msc_exp_wf.substitute_supply_date(exp.plan_id,exp.sr_instance_id,exp.supplier_id),

259: 27, md.using_assembly_demand_date,28, NULL,37, NULL,
260: 24, md.using_assembly_demand_date,
261: 25, md.using_assembly_demand_date,
262: 26, md.using_assembly_demand_date,
263: 49,msc_exp_wf.substitute_supply_date(exp.plan_id,exp.sr_instance_id,exp.supplier_id),
264: exp.DATE1),
265: DECODE(EXP.EXCEPTION_TYPE,1,EXP.DATE1, 2, EXP.DATE1, 3, EXP.DATE1,
266: 6, EXP.DATE1, 7,EXP.DATE1, 17, EXP.DATE1, 18, EXP.DATE1,
267: 20, EXP.DATE1, 28, EXP.DATE1, 37, EXP.DATE1,

Line 268: 15, md2.using_assembly_demand_date,16, md2.using_assembly_demand_date,49,msc_exp_wf.demand_order_date(exp.plan_id,exp.sr_instance_id,exp.supplier_id),

264: exp.DATE1),
265: DECODE(EXP.EXCEPTION_TYPE,1,EXP.DATE1, 2, EXP.DATE1, 3, EXP.DATE1,
266: 6, EXP.DATE1, 7,EXP.DATE1, 17, EXP.DATE1, 18, EXP.DATE1,
267: 20, EXP.DATE1, 28, EXP.DATE1, 37, EXP.DATE1,
268: 15, md2.using_assembly_demand_date,16, md2.using_assembly_demand_date,49,msc_exp_wf.demand_order_date(exp.plan_id,exp.sr_instance_id,exp.supplier_id),
269: NULL),
270: DECODE(EXP.EXCEPTION_TYPE,15,msc_exp_wf.demand_order_date(exp.plan_id,exp.sr_instance_id,exp.demand_id),16,msc_exp_wf.demand_order_date(exp.plan_id,exp.sr_instance_id,exp.demand_id),exp.date2),
271: DECODE(exp.EXCEPTION_TYPE, 9, sup.SCHEDULE_COMPRESS_DAYS,NULL),
272: decode(exp.exception_type,

Line 270: DECODE(EXP.EXCEPTION_TYPE,15,msc_exp_wf.demand_order_date(exp.plan_id,exp.sr_instance_id,exp.demand_id),16,msc_exp_wf.demand_order_date(exp.plan_id,exp.sr_instance_id,exp.demand_id),exp.date2),

266: 6, EXP.DATE1, 7,EXP.DATE1, 17, EXP.DATE1, 18, EXP.DATE1,
267: 20, EXP.DATE1, 28, EXP.DATE1, 37, EXP.DATE1,
268: 15, md2.using_assembly_demand_date,16, md2.using_assembly_demand_date,49,msc_exp_wf.demand_order_date(exp.plan_id,exp.sr_instance_id,exp.supplier_id),
269: NULL),
270: DECODE(EXP.EXCEPTION_TYPE,15,msc_exp_wf.demand_order_date(exp.plan_id,exp.sr_instance_id,exp.demand_id),16,msc_exp_wf.demand_order_date(exp.plan_id,exp.sr_instance_id,exp.demand_id),exp.date2),
271: DECODE(exp.EXCEPTION_TYPE, 9, sup.SCHEDULE_COMPRESS_DAYS,NULL),
272: decode(exp.exception_type,
273: 37,nvl(exp.number4,0)-nvl(exp.quantity,0),
274: 28,MSC_EXP_WF.SupplierCapacity(p_plan_id,exp.exception_detail_id),

Line 274: 28,MSC_EXP_WF.SupplierCapacity(p_plan_id,exp.exception_detail_id),

270: DECODE(EXP.EXCEPTION_TYPE,15,msc_exp_wf.demand_order_date(exp.plan_id,exp.sr_instance_id,exp.demand_id),16,msc_exp_wf.demand_order_date(exp.plan_id,exp.sr_instance_id,exp.demand_id),exp.date2),
271: DECODE(exp.EXCEPTION_TYPE, 9, sup.SCHEDULE_COMPRESS_DAYS,NULL),
272: decode(exp.exception_type,
273: 37,nvl(exp.number4,0)-nvl(exp.quantity,0),
274: 28,MSC_EXP_WF.SupplierCapacity(p_plan_id,exp.exception_detail_id),
275: 49,msc_get_name.demand_quantity(exp.plan_id,exp.sr_instance_id,
276: exp.supplier_id),
277: exp.quantity),
278: decode(exp.exception_type, 12, sup.lot_number),

Line 329: decode(exp.exception_type, 49, msc_exp_wf.demand_order_type(exp.plan_id,exp.sr_instance_id,exp.supplier_id),sup.order_type),

325: 3, msc_get_name.demand_quantity(exp.plan_id,exp.sr_instance_id,md2.demand_id),null),
326: decode(exp.exception_type, 12, null, 13, null, 14, null,
327: 17, null, 18, null, 24, null, 25, null, 26, null,
328: 27, null, 28, null, 37, exp.number2, exp.number1),
329: decode(exp.exception_type, 49, msc_exp_wf.demand_order_type(exp.plan_id,exp.sr_instance_id,exp.supplier_id),sup.order_type),
330: decode(exp.exception_type, 37, exp.number4,null),
331: exp.number1,
332: exp.number2
333: FROM msc_supplies sup,

Line 438: 49,msc_exp_wf.substitute_supply_date(exp.plan_id,exp.sr_instance_id,exp.supplier_id),

434: 27, md.using_assembly_demand_date,28, NULL,37, NULL,
435: 24, md.using_assembly_demand_date,
436: 25, md.using_assembly_demand_date,
437: 26, md.using_assembly_demand_date,
438: 49,msc_exp_wf.substitute_supply_date(exp.plan_id,exp.sr_instance_id,exp.supplier_id),
439: exp.DATE1),
440: DECODE(EXP.EXCEPTION_TYPE,1,EXP.DATE1, 2, EXP.DATE1, 3, EXP.DATE1,
441: 6, EXP.DATE1, 7,EXP.DATE1, 17, EXP.DATE1, 18, EXP.DATE1,
442: 20, EXP.DATE1, 28, EXP.DATE1, 37, EXP.DATE1,

Line 443: 15, md2.using_assembly_demand_date,16, md2.using_assembly_demand_date,49,msc_exp_wf.demand_order_date(exp.plan_id,exp.sr_instance_id,exp.supplier_id),

439: exp.DATE1),
440: DECODE(EXP.EXCEPTION_TYPE,1,EXP.DATE1, 2, EXP.DATE1, 3, EXP.DATE1,
441: 6, EXP.DATE1, 7,EXP.DATE1, 17, EXP.DATE1, 18, EXP.DATE1,
442: 20, EXP.DATE1, 28, EXP.DATE1, 37, EXP.DATE1,
443: 15, md2.using_assembly_demand_date,16, md2.using_assembly_demand_date,49,msc_exp_wf.demand_order_date(exp.plan_id,exp.sr_instance_id,exp.supplier_id),
444: NULL),
445: DECODE(EXP.EXCEPTION_TYPE,15,msc_exp_wf.demand_order_date(exp.plan_id,exp.sr_instance_id,exp.demand_id),16,msc_exp_wf.demand_order_date(exp.plan_id,exp.sr_instance_id,exp.demand_id),exp.date2),
446: DECODE(exp.EXCEPTION_TYPE, 9, sup.SCHEDULE_COMPRESS_DAYS,NULL),
447: decode(exp.exception_type,

Line 445: DECODE(EXP.EXCEPTION_TYPE,15,msc_exp_wf.demand_order_date(exp.plan_id,exp.sr_instance_id,exp.demand_id),16,msc_exp_wf.demand_order_date(exp.plan_id,exp.sr_instance_id,exp.demand_id),exp.date2),

441: 6, EXP.DATE1, 7,EXP.DATE1, 17, EXP.DATE1, 18, EXP.DATE1,
442: 20, EXP.DATE1, 28, EXP.DATE1, 37, EXP.DATE1,
443: 15, md2.using_assembly_demand_date,16, md2.using_assembly_demand_date,49,msc_exp_wf.demand_order_date(exp.plan_id,exp.sr_instance_id,exp.supplier_id),
444: NULL),
445: DECODE(EXP.EXCEPTION_TYPE,15,msc_exp_wf.demand_order_date(exp.plan_id,exp.sr_instance_id,exp.demand_id),16,msc_exp_wf.demand_order_date(exp.plan_id,exp.sr_instance_id,exp.demand_id),exp.date2),
446: DECODE(exp.EXCEPTION_TYPE, 9, sup.SCHEDULE_COMPRESS_DAYS,NULL),
447: decode(exp.exception_type,
448: 37,nvl(exp.number4,0)-nvl(exp.quantity,0),
449: 28,MSC_EXP_WF.SupplierCapacity(p_plan_id,exp.exception_detail_id),

Line 449: 28,MSC_EXP_WF.SupplierCapacity(p_plan_id,exp.exception_detail_id),

445: DECODE(EXP.EXCEPTION_TYPE,15,msc_exp_wf.demand_order_date(exp.plan_id,exp.sr_instance_id,exp.demand_id),16,msc_exp_wf.demand_order_date(exp.plan_id,exp.sr_instance_id,exp.demand_id),exp.date2),
446: DECODE(exp.EXCEPTION_TYPE, 9, sup.SCHEDULE_COMPRESS_DAYS,NULL),
447: decode(exp.exception_type,
448: 37,nvl(exp.number4,0)-nvl(exp.quantity,0),
449: 28,MSC_EXP_WF.SupplierCapacity(p_plan_id,exp.exception_detail_id),
450: 49,msc_get_name.demand_quantity(exp.plan_id,exp.sr_instance_id,
451: exp.supplier_id),
452: exp.quantity),
453: decode(exp.exception_type, 12, sup.lot_number),

Line 504: decode(exp.exception_type, 49, msc_exp_wf.demand_order_type(exp.plan_id,exp.sr_instance_id,exp.supplier_id),sup.order_type),

500: 3, msc_get_name.demand_quantity(exp.plan_id,exp.sr_instance_id,md2.demand_id),null),
501: decode(exp.exception_type, 12, null, 13, null, 14, null,
502: 17, null, 18, null, 24, null, 25, null, 26, null,
503: 27, null, 28, null, 37, exp.number2, exp.number1),
504: decode(exp.exception_type, 49, msc_exp_wf.demand_order_type(exp.plan_id,exp.sr_instance_id,exp.supplier_id),sup.order_type),
505: decode(exp.exception_type, 37, exp.number4,null),
506: exp.number1,
507: exp.number2
508: FROM msc_supplies sup,

Line 655: msc_util.msc_debug(' Start of Program MSC_EXP_WF');

651:
652: BEGIN
653: -- Cancel notifications from previous plan run and force completion of
654: -- workflows.
655: msc_util.msc_debug('****** Start of Program MSC_EXP_WF******');
656: msc_util.msc_debug('PlanId: ' || to_char(p_plan_id));
657: msc_util.msc_debug('ExceptionId: ' || to_char(p_exception_id));
658:
659: DeleteActivities(p_plan_id);

Line 950: errbuf := 'Error in msc_exp_wf.launch_workflow function' ||

946: null;
947:
948: WHEN OTHERS THEN
949: msc_util.msc_debug('Error in launch wkflow:'|| sqlerrm);
950: errbuf := 'Error in msc_exp_wf.launch_workflow function' ||
951: ' Cursor: ' || l_cursor || ' Exception ID: '
952: || l_exception_id ||
953: ' SQL error: ' || sqlerrm;
954: retcode := 2;

Line 1574: wf_core.context('MSC_EXP_WF', 'StartWFProcess', item_key, to_char(p_plan_id),

1570:
1571: EXCEPTION
1572:
1573: when others then
1574: wf_core.context('MSC_EXP_WF', 'StartWFProcess', item_key, to_char(p_plan_id),
1575: organization_code, item_segments, to_char(exception_type));
1576: raise;
1577:
1578: END StartWFProcess;

Line 1692: wf_core.context('MSC_EXP_WF', 'SelectPlanner', itemtype, itemkey, actid, funcmode);

1688:
1689: EXCEPTION
1690:
1691: when others then
1692: wf_core.context('MSC_EXP_WF', 'SelectPlanner', itemtype, itemkey, actid, funcmode);
1693: raise;
1694:
1695: END SelectPlanner;
1696:

Line 1835: wf_core.context('MSC_EXP_WF', 'GetPlannerMsgName', to_char(p_exception_type), to_char(p_order_type));

1831:
1832: EXCEPTION
1833:
1834: when others then
1835: wf_core.context('MSC_EXP_WF', 'GetPlannerMsgName', to_char(p_exception_type), to_char(p_order_type));
1836: raise;
1837:
1838: END GetPlannerMsgName;
1839:

Line 1905: wf_core.context('MSC_EXP_WF', 'DetermineOrderType', itemtype, itemkey, actid, funcmode);

1901:
1902: EXCEPTION
1903:
1904: when others then
1905: wf_core.context('MSC_EXP_WF', 'DetermineOrderType', itemtype, itemkey, actid, funcmode);
1906: raise;
1907:
1908: END DetermineOrderType;
1909:

Line 1985: wf_core.context('MSC_EXP_WF', 'Reschedule', itemtype, itemkey, actid, funcmode);

1981: end if;
1982:
1983: EXCEPTION
1984: when others then
1985: wf_core.context('MSC_EXP_WF', 'Reschedule', itemtype, itemkey, actid, funcmode);
1986: resultout := 'COMPLETE:0';
1987: raise;
1988:
1989: end Reschedule;

Line 2180: 'begin mrp_msc_exp_wf.deleteActivities'||l_db_link||

2176:
2177: if l_db_link <> ' ' then -- purge wf in the source
2178:
2179: sql_stmt :=
2180: 'begin mrp_msc_exp_wf.deleteActivities'||l_db_link||
2181: '(:arg_plan_id); end;';
2182:
2183: EXECUTE IMMEDIATE sql_stmt USING arg_plan_id;
2184:

Line 2446: wf_core.context('MSC_EXP_WF', 'IsCallback', itemtype, itemkey, actid, funcmode);

2442:
2443: EXCEPTION
2444:
2445: when others then
2446: wf_core.context('MSC_EXP_WF', 'IsCallback', itemtype, itemkey, actid, funcmode);
2447: raise;
2448:
2449: END IsCallback;
2450:

Line 2754: wf_core.context('MSC_EXP_WF', 'IsCallback', itemtype, itemkey, actid, funcmode);

2750:
2751: EXCEPTION
2752:
2753: when others then
2754: wf_core.context('MSC_EXP_WF', 'IsCallback', itemtype, itemkey, actid, funcmode);
2755: raise;
2756:
2757: END SelectSrUsers;
2758:

Line 3579: wf_core.context('MSC_EXP_WF', 'StartSrWF', itemtype, itemkey, actid, funcmode);

3575: RETURN;
3576: END IF;
3577: EXCEPTION
3578: when others then
3579: wf_core.context('MSC_EXP_WF', 'StartSrWF', itemtype, itemkey, actid, funcmode);
3580: raise;
3581: END StartSrWF;
3582:
3583: Procedure launch_background_program(p_planner in varchar2,

Line 3700: END msc_exp_wf;

3696: CLOSE dmd_cur;
3697: return p_supply_date;
3698: END substitute_supply_date;
3699:
3700: END msc_exp_wf;