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.OE_WF_UPGRADE_UTIL dependencies on STANDARD

Line 22: OE_STANDARD_WF.Set_Msg_Context(actid);

18: -- RUN mode - normal process execution
19: --
20:
21: -- start data fix project
22: OE_STANDARD_WF.Set_Msg_Context(actid);
23: -- end data fix project
24:
25: if (funcmode = 'RUN') then
26:

Line 27: IF OE_STANDARD_WF.G_UPGRADE_MODE THEN -- Upgrade in progress. Check if Order/Line is already

23: -- end data fix project
24:
25: if (funcmode = 'RUN') then
26:
27: IF OE_STANDARD_WF.G_UPGRADE_MODE THEN -- Upgrade in progress. Check if Order/Line is already
28: -- past custom activity.
29:
30: -- Find out What S column the custom activity is based on ...
31:

Line 93: OE_STANDARD_WF.Add_Error_Activity_Msg(p_actid => actid,

89: -- in the case of an exception.
90: wf_core.context('OE_WF_UPGRADE_UTIL', 'UPGRADE_CUSTOM_ACTIVITY_BLOCK',
91: itemtype, itemkey, to_char(actid), funcmode);
92: -- start data fix project
93: OE_STANDARD_WF.Add_Error_Activity_Msg(p_actid => actid,
94: p_itemtype => itemtype,
95: p_itemkey => itemkey);
96: OE_STANDARD_WF.Save_Messages;
97: OE_STANDARD_WF.Clear_Msg_Context;

Line 96: OE_STANDARD_WF.Save_Messages;

92: -- start data fix project
93: OE_STANDARD_WF.Add_Error_Activity_Msg(p_actid => actid,
94: p_itemtype => itemtype,
95: p_itemkey => itemkey);
96: OE_STANDARD_WF.Save_Messages;
97: OE_STANDARD_WF.Clear_Msg_Context;
98: -- end data fix project
99: raise;
100: END UPGRADE_CUSTOM_ACTIVITY_BLOCK;

Line 97: OE_STANDARD_WF.Clear_Msg_Context;

93: OE_STANDARD_WF.Add_Error_Activity_Msg(p_actid => actid,
94: p_itemtype => itemtype,
95: p_itemkey => itemkey);
96: OE_STANDARD_WF.Save_Messages;
97: OE_STANDARD_WF.Clear_Msg_Context;
98: -- end data fix project
99: raise;
100: END UPGRADE_CUSTOM_ACTIVITY_BLOCK;
101:

Line 120: OE_STANDARD_WF.Set_Msg_Context(actid);

116: l_Scolumn_value NUMBER;
117: BEGIN
118:
119: -- start data fix project
120: OE_STANDARD_WF.Set_Msg_Context(actid);
121: -- end data fix project
122: --
123: -- RUN mode - normal process execution
124: --

Line 128: IF OE_STANDARD_WF.G_UPGRADE_MODE THEN -- Upgrade in progress. Check if Order/Line is already

124: --
125:
126: if (funcmode = 'RUN') then
127:
128: IF OE_STANDARD_WF.G_UPGRADE_MODE THEN -- Upgrade in progress. Check if Order/Line is already
129: -- past approval
130:
131: -- Find out What S column the approval is based on ...
132:

Line 197: OE_STANDARD_WF.Add_Error_Activity_Msg(p_actid => actid,

193: -- in the case of an exception.
194: wf_core.context('OE_WF_UPGRADE_UTIL', 'UPGRADE_PRE_APPROVAL',
195: itemtype, itemkey, to_char(actid), funcmode);
196: -- start data fix project
197: OE_STANDARD_WF.Add_Error_Activity_Msg(p_actid => actid,
198: p_itemtype => itemtype,
199: p_itemkey => itemkey);
200: OE_STANDARD_WF.Save_Messages;
201: OE_STANDARD_WF.Clear_Msg_Context;

Line 200: OE_STANDARD_WF.Save_Messages;

196: -- start data fix project
197: OE_STANDARD_WF.Add_Error_Activity_Msg(p_actid => actid,
198: p_itemtype => itemtype,
199: p_itemkey => itemkey);
200: OE_STANDARD_WF.Save_Messages;
201: OE_STANDARD_WF.Clear_Msg_Context;
202: -- end data fix project
203: raise;
204: END UPGRADE_PRE_APPROVAL;

Line 201: OE_STANDARD_WF.Clear_Msg_Context;

197: OE_STANDARD_WF.Add_Error_Activity_Msg(p_actid => actid,
198: p_itemtype => itemtype,
199: p_itemkey => itemkey);
200: OE_STANDARD_WF.Save_Messages;
201: OE_STANDARD_WF.Clear_Msg_Context;
202: -- end data fix project
203: raise;
204: END UPGRADE_PRE_APPROVAL;
205:

Line 218: OE_STANDARD_WF.Set_Msg_Context(actid);

214: l_booked_status VARCHAR2(01);
215: BEGIN
216:
217: -- start data fix project
218: OE_STANDARD_WF.Set_Msg_Context(actid);
219: -- end data fix project
220: --
221: -- RUN mode - normal process execution
222: --

Line 226: IF OE_STANDARD_WF.G_UPGRADE_MODE THEN -- Upgrade in progress. Check if Order is already booked.

222: --
223:
224: if (funcmode = 'RUN') then
225:
226: IF OE_STANDARD_WF.G_UPGRADE_MODE THEN -- Upgrade in progress. Check if Order is already booked.
227:
228: OE_HEADER_STATUS_PUB.GET_BOOKED_STATUS(to_number(itemkey), l_booked_status);
229:
230: IF (l_booked_status = 'Y') THEN

Line 278: OE_STANDARD_WF.Add_Error_Activity_Msg(p_actid => actid,

274: -- in the case of an exception.
275: wf_core.context('OE_WF_UPGRADE_UTIL', 'IS_ORDER_PAST_BOOKING',
276: itemtype, itemkey, to_char(actid), funcmode);
277: -- start data fix project
278: OE_STANDARD_WF.Add_Error_Activity_Msg(p_actid => actid,
279: p_itemtype => itemtype,
280: p_itemkey => itemkey);
281: OE_STANDARD_WF.Save_Messages;
282: OE_STANDARD_WF.Clear_Msg_Context;

Line 281: OE_STANDARD_WF.Save_Messages;

277: -- start data fix project
278: OE_STANDARD_WF.Add_Error_Activity_Msg(p_actid => actid,
279: p_itemtype => itemtype,
280: p_itemkey => itemkey);
281: OE_STANDARD_WF.Save_Messages;
282: OE_STANDARD_WF.Clear_Msg_Context;
283: -- end data fix project
284: raise;
285: END IS_ORDER_PAST_BOOKING;

Line 282: OE_STANDARD_WF.Clear_Msg_Context;

278: OE_STANDARD_WF.Add_Error_Activity_Msg(p_actid => actid,
279: p_itemtype => itemtype,
280: p_itemkey => itemkey);
281: OE_STANDARD_WF.Save_Messages;
282: OE_STANDARD_WF.Clear_Msg_Context;
283: -- end data fix project
284: raise;
285: END IS_ORDER_PAST_BOOKING;
286:

Line 299: OE_STANDARD_WF.Set_Msg_Context(actid);

295: l_ship_status VARCHAR2(01);
296: BEGIN
297:
298: -- start data fix project
299: OE_STANDARD_WF.Set_Msg_Context(actid);
300: -- end data fix project
301: --
302: -- RUN mode - normal process execution
303: --

Line 307: IF OE_STANDARD_WF.G_UPGRADE_MODE THEN -- Upgrade in progress. Check if Order is already shipped.

303: --
304:
305: if (funcmode = 'RUN') then
306:
307: IF OE_STANDARD_WF.G_UPGRADE_MODE THEN -- Upgrade in progress. Check if Order is already shipped.
308:
309: OE_Line_Status_Pub.Get_Ship_Status(to_number(itemkey), l_ship_status);
310:
311: IF (l_ship_status = 'Y') THEN

Line 366: OE_STANDARD_WF.Add_Error_Activity_Msg(p_actid => actid,

362: -- in the case of an exception.
363: wf_core.context('OE_WF_UPGRADE_UTIL', 'IS_LINE_PAST_SHIPPING',
364: itemtype, itemkey, to_char(actid), funcmode);
365: -- start data fix project
366: OE_STANDARD_WF.Add_Error_Activity_Msg(p_actid => actid,
367: p_itemtype => itemtype,
368: p_itemkey => itemkey);
369: OE_STANDARD_WF.Save_Messages;
370: OE_STANDARD_WF.Clear_Msg_Context;

Line 369: OE_STANDARD_WF.Save_Messages;

365: -- start data fix project
366: OE_STANDARD_WF.Add_Error_Activity_Msg(p_actid => actid,
367: p_itemtype => itemtype,
368: p_itemkey => itemkey);
369: OE_STANDARD_WF.Save_Messages;
370: OE_STANDARD_WF.Clear_Msg_Context;
371: -- end data fix project
372: raise;
373: END IS_LINE_PAST_SHIPPING;

Line 370: OE_STANDARD_WF.Clear_Msg_Context;

366: OE_STANDARD_WF.Add_Error_Activity_Msg(p_actid => actid,
367: p_itemtype => itemtype,
368: p_itemkey => itemkey);
369: OE_STANDARD_WF.Save_Messages;
370: OE_STANDARD_WF.Clear_Msg_Context;
371: -- end data fix project
372: raise;
373: END IS_LINE_PAST_SHIPPING;
374:

Line 389: OE_STANDARD_WF.Set_Msg_Context(actid);

385:
386: BEGIN
387:
388: -- start data fix project
389: OE_STANDARD_WF.Set_Msg_Context(actid);
390: -- end data fix project
391: --
392: -- RUN mode - normal process execution
393: --

Line 444: OE_STANDARD_WF.Add_Error_Activity_Msg(p_actid => actid,

440: -- in the case of an exception.
441: wf_core.context('OE_WF_UPGRADE_UTIL', 'IS_LINE_PAST_SHIPPING',
442: itemtype, itemkey, to_char(actid), funcmode);
443: -- start data fix project
444: OE_STANDARD_WF.Add_Error_Activity_Msg(p_actid => actid,
445: p_itemtype => itemtype,
446: p_itemkey => itemkey);
447: OE_STANDARD_WF.Save_Messages;
448: OE_STANDARD_WF.Clear_Msg_Context;

Line 447: OE_STANDARD_WF.Save_Messages;

443: -- start data fix project
444: OE_STANDARD_WF.Add_Error_Activity_Msg(p_actid => actid,
445: p_itemtype => itemtype,
446: p_itemkey => itemkey);
447: OE_STANDARD_WF.Save_Messages;
448: OE_STANDARD_WF.Clear_Msg_Context;
449: -- end data fix project
450: raise;
451: END IS_LINE_SHIP_ELIGIBLE;

Line 448: OE_STANDARD_WF.Clear_Msg_Context;

444: OE_STANDARD_WF.Add_Error_Activity_Msg(p_actid => actid,
445: p_itemtype => itemtype,
446: p_itemkey => itemkey);
447: OE_STANDARD_WF.Save_Messages;
448: OE_STANDARD_WF.Clear_Msg_Context;
449: -- end data fix project
450: raise;
451: END IS_LINE_SHIP_ELIGIBLE;
452:

Line 465: OE_STANDARD_WF.Set_Msg_Context(actid);

461: l_received_status VARCHAR2(1);
462: BEGIN
463:
464: -- start data fix project
465: OE_STANDARD_WF.Set_Msg_Context(actid);
466: -- end data fix project
467: --
468: -- RUN mode - normal process execution
469: --

Line 473: IF OE_STANDARD_WF.G_UPGRADE_MODE THEN -- Upgrade in progress. Check if return already shipped

469: --
470:
471: if (funcmode = 'RUN') then
472:
473: IF OE_STANDARD_WF.G_UPGRADE_MODE THEN -- Upgrade in progress. Check if return already shipped
474:
475: OE_LINE_STATUS_PUB.GET_RECEIVED_STATUS(to_number(itemkey), l_received_status);
476:
477: IF (l_received_status = 'Y') THEN

Line 532: OE_STANDARD_WF.Add_Error_Activity_Msg(p_actid => actid,

528: -- in the case of an exception.
529: wf_core.context('OE_WF_UPGRADE_UTIL', 'IS_RETURN_RECEIVED',
530: itemtype, itemkey, to_char(actid), funcmode);
531: -- start data fix project
532: OE_STANDARD_WF.Add_Error_Activity_Msg(p_actid => actid,
533: p_itemtype => itemtype,
534: p_itemkey => itemkey);
535: OE_STANDARD_WF.Save_Messages;
536: OE_STANDARD_WF.Clear_Msg_Context;

Line 535: OE_STANDARD_WF.Save_Messages;

531: -- start data fix project
532: OE_STANDARD_WF.Add_Error_Activity_Msg(p_actid => actid,
533: p_itemtype => itemtype,
534: p_itemkey => itemkey);
535: OE_STANDARD_WF.Save_Messages;
536: OE_STANDARD_WF.Clear_Msg_Context;
537: -- end data fix project
538: raise;
539: END IS_RETURN_RECEIVED;

Line 536: OE_STANDARD_WF.Clear_Msg_Context;

532: OE_STANDARD_WF.Add_Error_Activity_Msg(p_actid => actid,
533: p_itemtype => itemtype,
534: p_itemkey => itemkey);
535: OE_STANDARD_WF.Save_Messages;
536: OE_STANDARD_WF.Clear_Msg_Context;
537: -- end data fix project
538: raise;
539: END IS_RETURN_RECEIVED;
540:

Line 554: OE_STANDARD_WF.Set_Msg_Context(actid);

550: l_shipped_quantity NUMBER;
551: BEGIN
552:
553: -- start data fix project
554: OE_STANDARD_WF.Set_Msg_Context(actid);
555: -- end data fix project
556: --
557: -- RUN mode - normal process execution
558: --

Line 562: IF OE_STANDARD_WF.G_UPGRADE_MODE THEN -- Upgrade in progress.

558: --
559:
560: if (funcmode = 'RUN') then
561:
562: IF OE_STANDARD_WF.G_UPGRADE_MODE THEN -- Upgrade in progress.
563:
564: -- Check if return already inspected
565: Select shipped_quantity,fulfilled_quantity
566: into l_shipped_quantity,l_fulfilled_quantity

Line 620: OE_STANDARD_WF.Add_Error_Activity_Msg(p_actid => actid,

616: -- in the case of an exception.
617: wf_core.context('OE_WF_UPGRADE_UTIL', 'IS_RETURN_INSPECTED',
618: itemtype, itemkey, to_char(actid), funcmode);
619: -- start data fix project
620: OE_STANDARD_WF.Add_Error_Activity_Msg(p_actid => actid,
621: p_itemtype => itemtype,
622: p_itemkey => itemkey);
623: OE_STANDARD_WF.Save_Messages;
624: OE_STANDARD_WF.Clear_Msg_Context;

Line 623: OE_STANDARD_WF.Save_Messages;

619: -- start data fix project
620: OE_STANDARD_WF.Add_Error_Activity_Msg(p_actid => actid,
621: p_itemtype => itemtype,
622: p_itemkey => itemkey);
623: OE_STANDARD_WF.Save_Messages;
624: OE_STANDARD_WF.Clear_Msg_Context;
625: -- end data fix project
626: raise;
627: END IS_RETURN_INSPECTED;

Line 624: OE_STANDARD_WF.Clear_Msg_Context;

620: OE_STANDARD_WF.Add_Error_Activity_Msg(p_actid => actid,
621: p_itemtype => itemtype,
622: p_itemkey => itemkey);
623: OE_STANDARD_WF.Save_Messages;
624: OE_STANDARD_WF.Clear_Msg_Context;
625: -- end data fix project
626: raise;
627: END IS_RETURN_INSPECTED;
628:

Line 641: OE_STANDARD_WF.Set_Msg_Context(actid);

637: l_invoice_interface_status VARCHAR2(30);
638: BEGIN
639:
640: -- start data fix project
641: OE_STANDARD_WF.Set_Msg_Context(actid);
642: -- end data fix project
643: --
644: -- RUN mode - normal process execution
645: --

Line 649: IF OE_STANDARD_WF.G_UPGRADE_MODE THEN -- Upgrade in progress. Check if Order Line is already Invoiced.

645: --
646:
647: if (funcmode = 'RUN') then
648:
649: IF OE_STANDARD_WF.G_UPGRADE_MODE THEN -- Upgrade in progress. Check if Order Line is already Invoiced.
650:
651: OE_ORDER_UPGRADE_UTIL.Get_Invoice_Status_Code(to_number(itemkey), l_invoice_interface_status);
652:
653: IF (l_invoice_interface_status = 'COMPLETE') THEN

Line 713: OE_STANDARD_WF.Add_Error_Activity_Msg(p_actid => actid,

709: -- in the case of an exception.
710: wf_core.context('OE_WF_UPGRADE_UTIL', 'IS_LINE_PAST_INVOICING',
711: itemtype, itemkey, to_char(actid), funcmode);
712: -- start data fix project
713: OE_STANDARD_WF.Add_Error_Activity_Msg(p_actid => actid,
714: p_itemtype => itemtype,
715: p_itemkey => itemkey);
716: OE_STANDARD_WF.Save_Messages;
717: OE_STANDARD_WF.Clear_Msg_Context;

Line 716: OE_STANDARD_WF.Save_Messages;

712: -- start data fix project
713: OE_STANDARD_WF.Add_Error_Activity_Msg(p_actid => actid,
714: p_itemtype => itemtype,
715: p_itemkey => itemkey);
716: OE_STANDARD_WF.Save_Messages;
717: OE_STANDARD_WF.Clear_Msg_Context;
718: -- end data fix project
719: raise;
720: END IS_LINE_PAST_INVOICING;

Line 717: OE_STANDARD_WF.Clear_Msg_Context;

713: OE_STANDARD_WF.Add_Error_Activity_Msg(p_actid => actid,
714: p_itemtype => itemtype,
715: p_itemkey => itemkey);
716: OE_STANDARD_WF.Save_Messages;
717: OE_STANDARD_WF.Clear_Msg_Context;
718: -- end data fix project
719: raise;
720: END IS_LINE_PAST_INVOICING;
721:

Line 734: OE_STANDARD_WF.Set_Msg_Context(actid);

730: l_closed_status VARCHAR2(1);
731: BEGIN
732:
733: -- start data fix project
734: OE_STANDARD_WF.Set_Msg_Context(actid);
735: -- end data fix project
736: --
737: -- RUN mode - normal process execution
738: --

Line 742: IF OE_STANDARD_WF.G_UPGRADE_MODE THEN -- Upgrade in progress. Check if Order is already closed.

738: --
739:
740: if (funcmode = 'RUN') then
741:
742: IF OE_STANDARD_WF.G_UPGRADE_MODE THEN -- Upgrade in progress. Check if Order is already closed.
743:
744: OE_HEADER_STATUS_PUB.GET_CLOSED_STATUS(to_number(itemkey), l_closed_status);
745:
746: IF (l_closed_status = 'Y') THEN

Line 794: OE_STANDARD_WF.Add_Error_Activity_Msg(p_actid => actid,

790: -- in the case of an exception.
791: wf_core.context('OE_WF_UPGRADE_UTIL', 'IS_ORDER_CLOSED',
792: itemtype, itemkey, to_char(actid), funcmode);
793: -- start data fix project
794: OE_STANDARD_WF.Add_Error_Activity_Msg(p_actid => actid,
795: p_itemtype => itemtype,
796: p_itemkey => itemkey);
797: OE_STANDARD_WF.Save_Messages;
798: OE_STANDARD_WF.Clear_Msg_Context;

Line 797: OE_STANDARD_WF.Save_Messages;

793: -- start data fix project
794: OE_STANDARD_WF.Add_Error_Activity_Msg(p_actid => actid,
795: p_itemtype => itemtype,
796: p_itemkey => itemkey);
797: OE_STANDARD_WF.Save_Messages;
798: OE_STANDARD_WF.Clear_Msg_Context;
799: -- end data fix project
800: raise;
801: END IS_ORDER_CLOSED;

Line 798: OE_STANDARD_WF.Clear_Msg_Context;

794: OE_STANDARD_WF.Add_Error_Activity_Msg(p_actid => actid,
795: p_itemtype => itemtype,
796: p_itemkey => itemkey);
797: OE_STANDARD_WF.Save_Messages;
798: OE_STANDARD_WF.Clear_Msg_Context;
799: -- end data fix project
800: raise;
801: END IS_ORDER_CLOSED;
802:

Line 815: OE_STANDARD_WF.Set_Msg_Context(actid);

811: l_closed_status VARCHAR2(1);
812: BEGIN
813:
814: -- start data fix project
815: OE_STANDARD_WF.Set_Msg_Context(actid);
816: -- end data fix project
817: --
818: -- RUN mode - normal process execution
819: --

Line 823: IF OE_STANDARD_WF.G_UPGRADE_MODE THEN -- Upgrade in progress. Check if Order Line is already closed.

819: --
820:
821: if (funcmode = 'RUN') then
822:
823: IF OE_STANDARD_WF.G_UPGRADE_MODE THEN -- Upgrade in progress. Check if Order Line is already closed.
824:
825: OE_LINE_STATUS_PUB.GET_CLOSED_STATUS(to_number(itemkey), l_closed_status);
826:
827: IF (l_closed_status = 'Y') THEN

Line 875: OE_STANDARD_WF.Add_Error_Activity_Msg(p_actid => actid,

871: -- in the case of an exception.
872: wf_core.context('OE_WF_UPGRADE_UTIL', 'IS_LINE_CLOSED',
873: itemtype, itemkey, to_char(actid), funcmode);
874: -- start data fix project
875: OE_STANDARD_WF.Add_Error_Activity_Msg(p_actid => actid,
876: p_itemtype => itemtype,
877: p_itemkey => itemkey);
878: OE_STANDARD_WF.Save_Messages;
879: OE_STANDARD_WF.Clear_Msg_Context;

Line 878: OE_STANDARD_WF.Save_Messages;

874: -- start data fix project
875: OE_STANDARD_WF.Add_Error_Activity_Msg(p_actid => actid,
876: p_itemtype => itemtype,
877: p_itemkey => itemkey);
878: OE_STANDARD_WF.Save_Messages;
879: OE_STANDARD_WF.Clear_Msg_Context;
880: -- end data fix project
881: raise;
882: END IS_LINE_CLOSED;

Line 879: OE_STANDARD_WF.Clear_Msg_Context;

875: OE_STANDARD_WF.Add_Error_Activity_Msg(p_actid => actid,
876: p_itemtype => itemtype,
877: p_itemkey => itemkey);
878: OE_STANDARD_WF.Save_Messages;
879: OE_STANDARD_WF.Clear_Msg_Context;
880: -- end data fix project
881: raise;
882: END IS_LINE_CLOSED;
883:

Line 904: OE_STANDARD_WF.Set_Msg_Context(actid);

900: l_schedule_status NUMBER;
901: BEGIN
902:
903: -- start data fix project
904: OE_STANDARD_WF.Set_Msg_Context(actid);
905: -- end data fix project
906: --
907: -- RUN mode - normal process execution
908: --

Line 912: IF OE_STANDARD_WF.G_UPGRADE_MODE

908: --
909:
910: if (funcmode = 'RUN') then
911:
912: IF OE_STANDARD_WF.G_UPGRADE_MODE
913: THEN
914: -- Upgrade in progress. Check if Order Line is already closed.
915:
916: OE_ORDER_UPGRADE_UTIL.GET_DEMAND_INTERFACE_STATUS

Line 969: OE_STANDARD_WF.Add_Error_Activity_Msg(p_actid => actid,

965: -- in the case of an exception.
966: wf_core.context('OE_WF_UPGRADE_UTIL', 'IS_LINE_CLOSED',
967: itemtype, itemkey, to_char(actid), funcmode);
968: -- start data fix project
969: OE_STANDARD_WF.Add_Error_Activity_Msg(p_actid => actid,
970: p_itemtype => itemtype,
971: p_itemkey => itemkey);
972: OE_STANDARD_WF.Save_Messages;
973: OE_STANDARD_WF.Clear_Msg_Context;

Line 972: OE_STANDARD_WF.Save_Messages;

968: -- start data fix project
969: OE_STANDARD_WF.Add_Error_Activity_Msg(p_actid => actid,
970: p_itemtype => itemtype,
971: p_itemkey => itemkey);
972: OE_STANDARD_WF.Save_Messages;
973: OE_STANDARD_WF.Clear_Msg_Context;
974: -- end data fix project
975: raise;
976: END IS_LINE_PAST_DEMAND_IFACE;

Line 973: OE_STANDARD_WF.Clear_Msg_Context;

969: OE_STANDARD_WF.Add_Error_Activity_Msg(p_actid => actid,
970: p_itemtype => itemtype,
971: p_itemkey => itemkey);
972: OE_STANDARD_WF.Save_Messages;
973: OE_STANDARD_WF.Clear_Msg_Context;
974: -- end data fix project
975: raise;
976: END IS_LINE_PAST_DEMAND_IFACE;
977:

Line 1009: OE_STANDARD_WF.Set_Msg_Context(actid);

1005: l_ato_line_id NUMBER;
1006: BEGIN
1007:
1008: -- start data fix project
1009: OE_STANDARD_WF.Set_Msg_Context(actid);
1010: -- end data fix project
1011: --
1012: -- RUN mode - normal process execution
1013: --

Line 1017: IF OE_STANDARD_WF.G_UPGRADE_MODE

1013: --
1014:
1015: if (funcmode = 'RUN') then
1016:
1017: IF OE_STANDARD_WF.G_UPGRADE_MODE
1018: THEN
1019: -- Upgrade in progress. Check if Order Line is already closed.
1020:
1021: OE_ORDER_UPGRADE_UTIL.GET_MFG_RELEASE_STATUS

Line 1094: OE_STANDARD_WF.Add_Error_Activity_Msg(p_actid => actid,

1090: -- in the case of an exception.
1091: wf_core.context('OE_WF_UPGRADE_UTIL', 'IS_LINE_CLOSED',
1092: itemtype, itemkey, to_char(actid), funcmode);
1093: -- start data fix project
1094: OE_STANDARD_WF.Add_Error_Activity_Msg(p_actid => actid,
1095: p_itemtype => itemtype,
1096: p_itemkey => itemkey);
1097: OE_STANDARD_WF.Save_Messages;
1098: OE_STANDARD_WF.Clear_Msg_Context;

Line 1097: OE_STANDARD_WF.Save_Messages;

1093: -- start data fix project
1094: OE_STANDARD_WF.Add_Error_Activity_Msg(p_actid => actid,
1095: p_itemtype => itemtype,
1096: p_itemkey => itemkey);
1097: OE_STANDARD_WF.Save_Messages;
1098: OE_STANDARD_WF.Clear_Msg_Context;
1099: -- end data fix project
1100: raise;
1101: END;

Line 1098: OE_STANDARD_WF.Clear_Msg_Context;

1094: OE_STANDARD_WF.Add_Error_Activity_Msg(p_actid => actid,
1095: p_itemtype => itemtype,
1096: p_itemkey => itemkey);
1097: OE_STANDARD_WF.Save_Messages;
1098: OE_STANDARD_WF.Clear_Msg_Context;
1099: -- end data fix project
1100: raise;
1101: END;
1102:

Line 1140: OE_STANDARD_WF.Set_Msg_Context(actid);

1136: l_shipped_quantity NUMBER;
1137: BEGIN
1138:
1139: -- start data fix project
1140: OE_STANDARD_WF.Set_Msg_Context(actid);
1141: -- end data fix project
1142: --
1143: -- RUN mode - normal process execution
1144: --

Line 1148: IF OE_STANDARD_WF.G_UPGRADE_MODE

1144: --
1145:
1146: if (funcmode = 'RUN') then
1147:
1148: IF OE_STANDARD_WF.G_UPGRADE_MODE
1149: THEN
1150: -- Upgrade in progress. Check if Order Line is already closed.
1151:
1152: OE_ORDER_UPGRADE_UTIL.GET_MFG_RELEASE_STATUS

Line 1237: OE_STANDARD_WF.Add_Error_Activity_Msg(p_actid => actid,

1233: -- in the case of an exception.
1234: wf_core.context('OE_WF_UPGRADE_UTIL', 'IS_LINE_CLOSED',
1235: itemtype, itemkey, to_char(actid), funcmode);
1236: -- start data fix project
1237: OE_STANDARD_WF.Add_Error_Activity_Msg(p_actid => actid,
1238: p_itemtype => itemtype,
1239: p_itemkey => itemkey);
1240: OE_STANDARD_WF.Save_Messages;
1241: OE_STANDARD_WF.Clear_Msg_Context;

Line 1240: OE_STANDARD_WF.Save_Messages;

1236: -- start data fix project
1237: OE_STANDARD_WF.Add_Error_Activity_Msg(p_actid => actid,
1238: p_itemtype => itemtype,
1239: p_itemkey => itemkey);
1240: OE_STANDARD_WF.Save_Messages;
1241: OE_STANDARD_WF.Clear_Msg_Context;
1242: -- end data fix project
1243: raise;
1244: END;

Line 1241: OE_STANDARD_WF.Clear_Msg_Context;

1237: OE_STANDARD_WF.Add_Error_Activity_Msg(p_actid => actid,
1238: p_itemtype => itemtype,
1239: p_itemkey => itemkey);
1240: OE_STANDARD_WF.Save_Messages;
1241: OE_STANDARD_WF.Clear_Msg_Context;
1242: -- end data fix project
1243: raise;
1244: END;
1245:

Line 1269: OE_STANDARD_WF.Set_Msg_Context(actid);

1265: l_item_type_code VARCHAR2(30);
1266: BEGIN
1267:
1268: -- start data fix project
1269: OE_STANDARD_WF.Set_Msg_Context(actid);
1270: -- end data fix project
1271: --
1272: -- RUN mode - normal process execution
1273: --

Line 1327: OE_STANDARD_WF.Add_Error_Activity_Msg(p_actid => actid,

1323: -- in the case of an exception.
1324: wf_core.context('OE_WF_UPGRADE_UTIL', 'IS_LINE_CLOSED',
1325: itemtype, itemkey, to_char(actid), funcmode);
1326: -- start data fix project
1327: OE_STANDARD_WF.Add_Error_Activity_Msg(p_actid => actid,
1328: p_itemtype => itemtype,
1329: p_itemkey => itemkey);
1330: OE_STANDARD_WF.Save_Messages;
1331: OE_STANDARD_WF.Clear_Msg_Context;

Line 1330: OE_STANDARD_WF.Save_Messages;

1326: -- start data fix project
1327: OE_STANDARD_WF.Add_Error_Activity_Msg(p_actid => actid,
1328: p_itemtype => itemtype,
1329: p_itemkey => itemkey);
1330: OE_STANDARD_WF.Save_Messages;
1331: OE_STANDARD_WF.Clear_Msg_Context;
1332: -- end data fix project
1333: raise;
1334: END;

Line 1331: OE_STANDARD_WF.Clear_Msg_Context;

1327: OE_STANDARD_WF.Add_Error_Activity_Msg(p_actid => actid,
1328: p_itemtype => itemtype,
1329: p_itemkey => itemkey);
1330: OE_STANDARD_WF.Save_Messages;
1331: OE_STANDARD_WF.Clear_Msg_Context;
1332: -- end data fix project
1333: raise;
1334: END;
1335:

Line 1339: global OE_STANDARD_WF.G_UPGRADE_MODE is set to TRUE.

1335:
1336: /* --------------------------------------------------------------------
1337: Procedure Name : IS_MODE_UPGRADE
1338: Description : This procedure returns the result of "YES", if the
1339: global OE_STANDARD_WF.G_UPGRADE_MODE is set to TRUE.
1340: We use this for the config item flow.
1341:
1342: ----------------------------------------------------------------------- */
1343:

Line 1357: OE_STANDARD_WF.Set_Msg_Context(actid);

1353: l_item_type_code NUMBER;
1354: BEGIN
1355:
1356: -- start data fix project
1357: OE_STANDARD_WF.Set_Msg_Context(actid);
1358: -- end data fix project
1359: --
1360: -- RUN mode - normal process execution
1361: --

Line 1365: IF OE_STANDARD_WF.G_UPGRADE_MODE

1361: --
1362:
1363: if (funcmode = 'RUN') then
1364:
1365: IF OE_STANDARD_WF.G_UPGRADE_MODE
1366: THEN
1367: resultout := 'COMPLETE:Y';
1368: RETURN;
1369: ELSE

Line 1405: OE_STANDARD_WF.Add_Error_Activity_Msg(p_actid => actid,

1401: -- in the case of an exception.
1402: wf_core.context('OE_WF_UPGRADE_UTIL', 'IS_LINE_CLOSED',
1403: itemtype, itemkey, to_char(actid), funcmode);
1404: -- start data fix project
1405: OE_STANDARD_WF.Add_Error_Activity_Msg(p_actid => actid,
1406: p_itemtype => itemtype,
1407: p_itemkey => itemkey);
1408: OE_STANDARD_WF.Save_Messages;
1409: OE_STANDARD_WF.Clear_Msg_Context;

Line 1408: OE_STANDARD_WF.Save_Messages;

1404: -- start data fix project
1405: OE_STANDARD_WF.Add_Error_Activity_Msg(p_actid => actid,
1406: p_itemtype => itemtype,
1407: p_itemkey => itemkey);
1408: OE_STANDARD_WF.Save_Messages;
1409: OE_STANDARD_WF.Clear_Msg_Context;
1410: -- end data fix project
1411: raise;
1412: END;

Line 1409: OE_STANDARD_WF.Clear_Msg_Context;

1405: OE_STANDARD_WF.Add_Error_Activity_Msg(p_actid => actid,
1406: p_itemtype => itemtype,
1407: p_itemkey => itemkey);
1408: OE_STANDARD_WF.Save_Messages;
1409: OE_STANDARD_WF.Clear_Msg_Context;
1410: -- end data fix project
1411: raise;
1412: END;
1413:

Line 1447: OE_STANDARD_WF.Set_Msg_Context(actid);

1443: l_source_type VARCHAR2(30); ---5247444
1444: BEGIN
1445:
1446: -- start data fix project
1447: OE_STANDARD_WF.Set_Msg_Context(actid);
1448: -- end data fix project
1449: --
1450: -- RUN mode - normal process execution
1451: --

Line 1455: IF OE_STANDARD_WF.G_UPGRADE_MODE

1451: --
1452:
1453: if (funcmode = 'RUN') then
1454:
1455: IF OE_STANDARD_WF.G_UPGRADE_MODE
1456: THEN
1457: -- Upgrade in progress. Check if Order Line is already closed.
1458:
1459: OE_ORDER_UPGRADE_UTIL.Get_Pur_Rel_Status

Line 1530: OE_STANDARD_WF.Add_Error_Activity_Msg(p_actid => actid,

1526: -- in the case of an exception.
1527: wf_core.context('OE_WF_UPGRADE_UTIL', 'IS_LINE_CLOSED',
1528: itemtype, itemkey, to_char(actid), funcmode);
1529: -- start data fix project
1530: OE_STANDARD_WF.Add_Error_Activity_Msg(p_actid => actid,
1531: p_itemtype => itemtype,
1532: p_itemkey => itemkey);
1533: OE_STANDARD_WF.Save_Messages;
1534: OE_STANDARD_WF.Clear_Msg_Context;

Line 1533: OE_STANDARD_WF.Save_Messages;

1529: -- start data fix project
1530: OE_STANDARD_WF.Add_Error_Activity_Msg(p_actid => actid,
1531: p_itemtype => itemtype,
1532: p_itemkey => itemkey);
1533: OE_STANDARD_WF.Save_Messages;
1534: OE_STANDARD_WF.Clear_Msg_Context;
1535: -- end data fix project
1536: raise;
1537: END CHECK_PUR_REL_STATUS;

Line 1534: OE_STANDARD_WF.Clear_Msg_Context;

1530: OE_STANDARD_WF.Add_Error_Activity_Msg(p_actid => actid,
1531: p_itemtype => itemtype,
1532: p_itemkey => itemkey);
1533: OE_STANDARD_WF.Save_Messages;
1534: OE_STANDARD_WF.Clear_Msg_Context;
1535: -- end data fix project
1536: raise;
1537: END CHECK_PUR_REL_STATUS;
1538: