DBA Data[Home] [Help]

APPS.OE_OEOL_SCH dependencies on STANDARD

Line 299: OE_STANDARD_WF.Set_Msg_Context(actid);

295: IF l_debug_level > 0 THEN
296: oe_debug_pub.add( 'ITEM KEY IS ' || ITEMKEY ) ;
297: END IF;
298:
299: OE_STANDARD_WF.Set_Msg_Context(actid);
300:
301: SAVEPOINT Before_Lock;
302:
303: -- If it is BULK Mode then no need to query these values from Database

Line 448: OE_STANDARD_WF.Clear_Msg_Context;

444: IF l_debug_level > 0 THEN
445: oe_debug_pub.add('SCHEDULE_LINE: unable to lock the top model line:'||l_top_model_line_id,1);
446: END IF;
447: resultout := 'COMPLETE:INCOMPLETE';
448: OE_STANDARD_WF.Clear_Msg_Context;
449: RETURN;
450: END;
451: END IF;
452: -- 3693569: Lock the child line

Line 466: OE_STANDARD_WF.Clear_Msg_Context;

462: IF l_debug_level > 0 THEN
463: oe_debug_pub.add('SCHEDULE_LINE: unable to lock the line:'||l_child_line_id,1);
464: END IF;
465: resultout := 'COMPLETE:INCOMPLETE';
466: OE_STANDARD_WF.Clear_Msg_Context;
467: RETURN;
468: END;
469: l_line_id := to_number(itemkey);
470:

Line 580: OE_STANDARD_WF.Save_Messages;

576: END IF;
577:
578: resultout := 'COMPLETE:INCOMPLETE';
579:
580: OE_STANDARD_WF.Save_Messages;
581: OE_STANDARD_WF.Clear_Msg_Context;
582:
583: OE_Delayed_Requests_PVT.Clear_Request
584: (x_return_status => l_return_status);

Line 581: OE_STANDARD_WF.Clear_Msg_Context;

577:
578: resultout := 'COMPLETE:INCOMPLETE';
579:
580: OE_STANDARD_WF.Save_Messages;
581: OE_STANDARD_WF.Clear_Msg_Context;
582:
583: OE_Delayed_Requests_PVT.Clear_Request
584: (x_return_status => l_return_status);
585:

Line 592: OE_STANDARD_WF.Save_Messages;

588: END IF;
589:
590: resultout := 'COMPLETE:NOT_ELIGIBLE';
591:
592: OE_STANDARD_WF.Save_Messages;
593: OE_STANDARD_WF.Clear_Msg_Context;
594:
595: OE_Delayed_Requests_PVT.Clear_Request
596: (x_return_status => l_return_status);

Line 593: OE_STANDARD_WF.Clear_Msg_Context;

589:
590: resultout := 'COMPLETE:NOT_ELIGIBLE';
591:
592: OE_STANDARD_WF.Save_Messages;
593: OE_STANDARD_WF.Clear_Msg_Context;
594:
595: OE_Delayed_Requests_PVT.Clear_Request
596: (x_return_status => l_return_status);
597: return;

Line 620: OE_STANDARD_WF.Save_Messages;

616: IF NOT l_scheduled
617: THEN
618: ROLLBACK TO Before_Lock;
619: resultout := 'COMPLETE:INCOMPLETE';
620: OE_STANDARD_WF.Save_Messages;
621: OE_STANDARD_WF.Clear_Msg_Context;
622: --5166476
623: IF OE_SCH_CONC_REQUESTS.g_recorded = 'N' THEN
624: OE_SCH_CONC_REQUESTS.OE_line_status_Tbl(l_line_id) := 'N';

Line 621: OE_STANDARD_WF.Clear_Msg_Context;

617: THEN
618: ROLLBACK TO Before_Lock;
619: resultout := 'COMPLETE:INCOMPLETE';
620: OE_STANDARD_WF.Save_Messages;
621: OE_STANDARD_WF.Clear_Msg_Context;
622: --5166476
623: IF OE_SCH_CONC_REQUESTS.g_recorded = 'N' THEN
624: OE_SCH_CONC_REQUESTS.OE_line_status_Tbl(l_line_id) := 'N';
625: OE_SCH_CONC_REQUESTS.g_recorded :='Y';

Line 635: OE_STANDARD_WF.Save_Messages;

631: END IF;
632: IF Is_Scheduling_Eligible(l_top_model_line_id) THEN -- Bug3083995
633: ROLLBACK TO Before_Lock;
634: resultout := 'COMPLETE:INCOMPLETE';
635: OE_STANDARD_WF.Save_Messages;
636: OE_STANDARD_WF.Clear_Msg_Context;
637: --5166476
638: IF OE_SCH_CONC_REQUESTS.g_recorded = 'N' THEN
639: OE_SCH_CONC_REQUESTS.OE_line_status_Tbl(l_line_id) := 'N';

Line 636: OE_STANDARD_WF.Clear_Msg_Context;

632: IF Is_Scheduling_Eligible(l_top_model_line_id) THEN -- Bug3083995
633: ROLLBACK TO Before_Lock;
634: resultout := 'COMPLETE:INCOMPLETE';
635: OE_STANDARD_WF.Save_Messages;
636: OE_STANDARD_WF.Clear_Msg_Context;
637: --5166476
638: IF OE_SCH_CONC_REQUESTS.g_recorded = 'N' THEN
639: OE_SCH_CONC_REQUESTS.OE_line_status_Tbl(l_line_id) := 'N';
640: OE_SCH_CONC_REQUESTS.g_recorded :='Y';

Line 660: OE_STANDARD_WF.Save_Messages;

656: IF NOT l_scheduled
657: THEN
658: ROLLBACK TO Before_Lock;
659: resultout := 'COMPLETE:INCOMPLETE';
660: OE_STANDARD_WF.Save_Messages;
661: OE_STANDARD_WF.Clear_Msg_Context;
662: --5166476
663: IF OE_SCH_CONC_REQUESTS.g_recorded = 'N' THEN
664: OE_SCH_CONC_REQUESTS.OE_line_status_Tbl(l_line_id) := 'N';

Line 661: OE_STANDARD_WF.Clear_Msg_Context;

657: THEN
658: ROLLBACK TO Before_Lock;
659: resultout := 'COMPLETE:INCOMPLETE';
660: OE_STANDARD_WF.Save_Messages;
661: OE_STANDARD_WF.Clear_Msg_Context;
662: --5166476
663: IF OE_SCH_CONC_REQUESTS.g_recorded = 'N' THEN
664: OE_SCH_CONC_REQUESTS.OE_line_status_Tbl(l_line_id) := 'N';
665: OE_SCH_CONC_REQUESTS.g_recorded :='Y';

Line 681: OE_STANDARD_WF.Save_Messages;

677: OE_SCH_CONC_REQUESTS.OE_line_status_Tbl(l_line_id) := 'N';
678: OE_SCH_CONC_REQUESTS.g_recorded :='Y';
679: END IF;
680:
681: OE_STANDARD_WF.Save_Messages;
682: OE_STANDARD_WF.Clear_Msg_Context;
683:
684: OE_Delayed_Requests_PVT.Clear_Request
685: (x_return_status => l_return_status);

Line 682: OE_STANDARD_WF.Clear_Msg_Context;

678: OE_SCH_CONC_REQUESTS.g_recorded :='Y';
679: END IF;
680:
681: OE_STANDARD_WF.Save_Messages;
682: OE_STANDARD_WF.Clear_Msg_Context;
683:
684: OE_Delayed_Requests_PVT.Clear_Request
685: (x_return_status => l_return_status);
686: return;

Line 700: OE_STANDARD_WF.Save_Messages;

696: IF NOT l_scheduled
697: THEN
698: ROLLBACK TO Before_Lock;
699: resultout := 'COMPLETE:INCOMPLETE';
700: OE_STANDARD_WF.Save_Messages;
701: OE_STANDARD_WF.Clear_Msg_Context;
702: --5166476
703: IF OE_SCH_CONC_REQUESTS.g_recorded = 'N' THEN
704: OE_SCH_CONC_REQUESTS.OE_line_status_Tbl(l_line_id) := 'N';

Line 701: OE_STANDARD_WF.Clear_Msg_Context;

697: THEN
698: ROLLBACK TO Before_Lock;
699: resultout := 'COMPLETE:INCOMPLETE';
700: OE_STANDARD_WF.Save_Messages;
701: OE_STANDARD_WF.Clear_Msg_Context;
702: --5166476
703: IF OE_SCH_CONC_REQUESTS.g_recorded = 'N' THEN
704: OE_SCH_CONC_REQUESTS.OE_line_status_Tbl(l_line_id) := 'N';
705: OE_SCH_CONC_REQUESTS.g_recorded :='Y';

Line 721: OE_STANDARD_WF.Save_Messages;

717: OE_SCH_CONC_REQUESTS.OE_line_status_Tbl(l_line_id) := 'N';
718: OE_SCH_CONC_REQUESTS.g_recorded :='Y';
719: END IF;
720:
721: OE_STANDARD_WF.Save_Messages;
722: OE_STANDARD_WF.Clear_Msg_Context;
723:
724: OE_Delayed_Requests_PVT.Clear_Request
725: (x_return_status => l_return_status);

Line 722: OE_STANDARD_WF.Clear_Msg_Context;

718: OE_SCH_CONC_REQUESTS.g_recorded :='Y';
719: END IF;
720:
721: OE_STANDARD_WF.Save_Messages;
722: OE_STANDARD_WF.Clear_Msg_Context;
723:
724: OE_Delayed_Requests_PVT.Clear_Request
725: (x_return_status => l_return_status);
726: return;

Line 791: OE_STANDARD_WF.Save_Messages;

787: -- End modified for bug 2515791
788: OE_MSG_PUB.Add;
789:
790: resultout := 'COMPLETE:ON_HOLD';
791: OE_STANDARD_WF.Save_Messages;
792: OE_STANDARD_WF.Clear_Msg_Context;
793:
794: OE_Delayed_Requests_PVT.Clear_Request
795: (x_return_status => l_return_status);

Line 792: OE_STANDARD_WF.Clear_Msg_Context;

788: OE_MSG_PUB.Add;
789:
790: resultout := 'COMPLETE:ON_HOLD';
791: OE_STANDARD_WF.Save_Messages;
792: OE_STANDARD_WF.Clear_Msg_Context;
793:
794: OE_Delayed_Requests_PVT.Clear_Request
795: (x_return_status => l_return_status);
796: return;

Line 873: OE_STANDARD_WF.Save_Messages;

869: oe_debug_pub.add( 'SMC :PUSHING LINE TO SCHEDULE ELIGIBLE' , 2 ) ;
870: END IF;
871: ROLLBACK TO Before_Lock;
872: resultout := 'COMPLETE:INCOMPLETE';
873: OE_STANDARD_WF.Save_Messages;
874: OE_STANDARD_WF.Clear_Msg_Context;
875:
876: OE_Delayed_Requests_PVT.Clear_Request
877: (x_return_status => l_return_status);

Line 874: OE_STANDARD_WF.Clear_Msg_Context;

870: END IF;
871: ROLLBACK TO Before_Lock;
872: resultout := 'COMPLETE:INCOMPLETE';
873: OE_STANDARD_WF.Save_Messages;
874: OE_STANDARD_WF.Clear_Msg_Context;
875:
876: OE_Delayed_Requests_PVT.Clear_Request
877: (x_return_status => l_return_status);
878: return;

Line 916: OE_STANDARD_WF.Save_Messages;

912: oe_debug_pub.add( 'ATO: PUSHING LINE TO SCHEDULE ELIGIBLE' , 2 ) ;
913: END IF;
914: ROLLBACK TO Before_Lock;
915: resultout := 'COMPLETE:INCOMPLETE';
916: OE_STANDARD_WF.Save_Messages;
917: OE_STANDARD_WF.Clear_Msg_Context;
918:
919: OE_Delayed_Requests_PVT.Clear_Request
920: (x_return_status => l_return_status);

Line 917: OE_STANDARD_WF.Clear_Msg_Context;

913: END IF;
914: ROLLBACK TO Before_Lock;
915: resultout := 'COMPLETE:INCOMPLETE';
916: OE_STANDARD_WF.Save_Messages;
917: OE_STANDARD_WF.Clear_Msg_Context;
918:
919: OE_Delayed_Requests_PVT.Clear_Request
920: (x_return_status => l_return_status);
921: return;

Line 1025: OE_STANDARD_WF.Save_Messages;

1021: oe_debug_pub.add( 'MRP Rollback result '||l_return_status , 1 ) ;
1022: END IF;
1023: -- moved this line up to for the bug fix 2884452
1024: ROLLBACK TO SAVEPOINT Schedule_line;
1025: OE_STANDARD_WF.Save_Messages;
1026: OE_STANDARD_WF.Clear_Msg_Context;
1027: --commit; /* Added this line to fix the bug 2884452 */
1028: OE_Delayed_Requests_PVT.Clear_Request
1029: (x_return_status => l_return_status);

Line 1026: OE_STANDARD_WF.Clear_Msg_Context;

1022: END IF;
1023: -- moved this line up to for the bug fix 2884452
1024: ROLLBACK TO SAVEPOINT Schedule_line;
1025: OE_STANDARD_WF.Save_Messages;
1026: OE_STANDARD_WF.Clear_Msg_Context;
1027: --commit; /* Added this line to fix the bug 2884452 */
1028: OE_Delayed_Requests_PVT.Clear_Request
1029: (x_return_status => l_return_status);
1030: --5122730

Line 1046: OE_STANDARD_WF.Save_Messages;

1042: END IF;
1043: resultout := 'COMPLETE:INCOMPLETE';
1044: -- moved this line up to for the bug fix 2884452
1045: ROLLBACK TO SAVEPOINT Schedule_line;
1046: OE_STANDARD_WF.Save_Messages;
1047: OE_STANDARD_WF.Clear_Msg_Context;
1048: --commit; /* Added this line to fix the bug 2884452 */
1049: OE_Delayed_Requests_PVT.Clear_Request
1050: (x_return_status => l_return_status);

Line 1047: OE_STANDARD_WF.Clear_Msg_Context;

1043: resultout := 'COMPLETE:INCOMPLETE';
1044: -- moved this line up to for the bug fix 2884452
1045: ROLLBACK TO SAVEPOINT Schedule_line;
1046: OE_STANDARD_WF.Save_Messages;
1047: OE_STANDARD_WF.Clear_Msg_Context;
1048: --commit; /* Added this line to fix the bug 2884452 */
1049: OE_Delayed_Requests_PVT.Clear_Request
1050: (x_return_status => l_return_status);
1051: -- app_exception.raise_exception;

Line 1088: OE_STANDARD_WF.Clear_Msg_Context;

1084: --
1085: --11825106
1086: IF oe_schedule_util.OESCH_SET_SCHEDULING = 'Y' THEN
1087: resultout := 'COMPLETE:COMPLETE';
1088: OE_STANDARD_WF.Clear_Msg_Context;
1089:
1090: Bulk_Mode_Copy_Sch_Attribs
1091: (p_line_rec => l_line_rec);
1092: ELSE

Line 1096: OE_STANDARD_WF.Save_Messages;

1092: ELSE
1093: resultout := 'COMPLETE:INCOMPLETE';
1094: -- moved this line up to for the bug fix 2884452
1095: ROLLBACK TO SAVEPOINT Schedule_line;
1096: OE_STANDARD_WF.Save_Messages;
1097: OE_STANDARD_WF.Clear_Msg_Context;
1098: --commit; /* Added this line to fix the bug 2884452 */
1099: OE_Delayed_Requests_PVT.Clear_Request
1100: (x_return_status => l_return_status);

Line 1097: OE_STANDARD_WF.Clear_Msg_Context;

1093: resultout := 'COMPLETE:INCOMPLETE';
1094: -- moved this line up to for the bug fix 2884452
1095: ROLLBACK TO SAVEPOINT Schedule_line;
1096: OE_STANDARD_WF.Save_Messages;
1097: OE_STANDARD_WF.Clear_Msg_Context;
1098: --commit; /* Added this line to fix the bug 2884452 */
1099: OE_Delayed_Requests_PVT.Clear_Request
1100: (x_return_status => l_return_status);
1101: --oe_schedule_util.OESCH_SET_SCHEDULING :='Y';

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

1115: WHEN OTHERS THEN
1116: wf_core.context('OE_OEOL_SCH', 'Schedule Line',
1117: itemtype, itemkey, to_char(actid), funcmode);
1118: -- start data fix project
1119: OE_STANDARD_WF.Add_Error_Activity_Msg(p_actid => actid,
1120: p_itemtype => itemtype,
1121: p_itemkey => itemkey);
1122: OE_STANDARD_WF.Save_Messages;
1123: OE_STANDARD_WF.Clear_Msg_Context;

Line 1122: OE_STANDARD_WF.Save_Messages;

1118: -- start data fix project
1119: OE_STANDARD_WF.Add_Error_Activity_Msg(p_actid => actid,
1120: p_itemtype => itemtype,
1121: p_itemkey => itemkey);
1122: OE_STANDARD_WF.Save_Messages;
1123: OE_STANDARD_WF.Clear_Msg_Context;
1124: -- end data fix project
1125: raise;
1126: END Schedule_Line;

Line 1123: OE_STANDARD_WF.Clear_Msg_Context;

1119: OE_STANDARD_WF.Add_Error_Activity_Msg(p_actid => actid,
1120: p_itemtype => itemtype,
1121: p_itemkey => itemkey);
1122: OE_STANDARD_WF.Save_Messages;
1123: OE_STANDARD_WF.Clear_Msg_Context;
1124: -- end data fix project
1125: raise;
1126: END Schedule_Line;
1127:

Line 1233: OE_STANDARD_WF.Set_Msg_Context(actid);

1229: --
1230: -- RUN mode - normal process execution
1231: --
1232: -- start data fix project
1233: OE_STANDARD_WF.Set_Msg_Context(actid);
1234: -- end data fix project
1235:
1236: -- l_line_rec := OE_Line_Util.Query_Row(to_number(itemkey));
1237: /* Changes for performance, the query row is being replaced by a select.

Line 1276: ELSIF (l_item_type_code = OE_GLOBALS.G_ITEM_STANDARD OR

1272: oe_debug_pub.add( 'BRANCH: BUILD '|| L_LINE_ID , 2 ) ;
1273: END IF;
1274: resultout := 'COMPLETE:BUILD';
1275: return;
1276: ELSIF (l_item_type_code = OE_GLOBALS.G_ITEM_STANDARD OR
1277: l_item_type_code = OE_GLOBALS.G_ITEM_OPTION OR
1278: l_item_type_code = OE_GLOBALS.G_ITEM_INCLUDED) --9775352
1279: THEN
1280: IF l_debug_level > 0 THEN

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

1312: WHEN OTHERS THEN
1313: wf_core.context('OE_OEOL_SCH', 'Branch_on_source_type',
1314: itemtype, itemkey, to_char(actid), funcmode);
1315: -- start data fix project
1316: OE_STANDARD_WF.Add_Error_Activity_Msg(p_actid => actid,
1317: p_itemtype => itemtype,
1318: p_itemkey => itemkey);
1319: OE_STANDARD_WF.Save_Messages;
1320: OE_STANDARD_WF.Clear_Msg_Context;

Line 1319: OE_STANDARD_WF.Save_Messages;

1315: -- start data fix project
1316: OE_STANDARD_WF.Add_Error_Activity_Msg(p_actid => actid,
1317: p_itemtype => itemtype,
1318: p_itemkey => itemkey);
1319: OE_STANDARD_WF.Save_Messages;
1320: OE_STANDARD_WF.Clear_Msg_Context;
1321: -- end data fix project
1322: raise;
1323: END Branch_on_source_type;

Line 1320: OE_STANDARD_WF.Clear_Msg_Context;

1316: OE_STANDARD_WF.Add_Error_Activity_Msg(p_actid => actid,
1317: p_itemtype => itemtype,
1318: p_itemkey => itemkey);
1319: OE_STANDARD_WF.Save_Messages;
1320: OE_STANDARD_WF.Clear_Msg_Context;
1321: -- end data fix project
1322: raise;
1323: END Branch_on_source_type;
1324:

Line 1379: OE_STANDARD_WF.Set_Msg_Context(actid);

1375: IF l_debug_level > 0 THEN
1376: oe_debug_pub.add('Entering Release to Purchasing line',1);
1377: END IF;
1378:
1379: OE_STANDARD_WF.Set_Msg_Context(actid);
1380:
1381: OE_Line_Util.Query_Row(p_line_id => to_number(itemkey), x_line_rec => l_line_rec);
1382: OE_Header_Util.Query_Row(p_header_id => l_line_rec.header_id, x_header_rec => l_header_rec);
1383:

Line 1410: OE_STANDARD_WF.Save_Messages;

1406:
1407: FND_MESSAGE.SET_NAME('ONT','OE_DS_WHSE_REQD');
1408: OE_MSG_PUB.Add;
1409: resultout := 'COMPLETE:INCOMPLETE';
1410: OE_STANDARD_WF.Save_Messages;
1411: OE_STANDARD_WF.Clear_Msg_Context;
1412: return;
1413: END IF;
1414:

Line 1411: OE_STANDARD_WF.Clear_Msg_Context;

1407: FND_MESSAGE.SET_NAME('ONT','OE_DS_WHSE_REQD');
1408: OE_MSG_PUB.Add;
1409: resultout := 'COMPLETE:INCOMPLETE';
1410: OE_STANDARD_WF.Save_Messages;
1411: OE_STANDARD_WF.Clear_Msg_Context;
1412: return;
1413: END IF;
1414:
1415: BEGIN

Line 1476: OE_STANDARD_WF.Save_Messages;

1472: END IF;
1473: FND_MESSAGE.SET_NAME('ONT','OE_DS_NO_LOC_LINK');
1474: OE_MSG_PUB.Add;
1475: resultout := 'COMPLETE:INCOMPLETE';
1476: OE_STANDARD_WF.Save_Messages;
1477: OE_STANDARD_WF.Clear_Msg_Context;
1478: return;
1479: END;
1480:

Line 1477: OE_STANDARD_WF.Clear_Msg_Context;

1473: FND_MESSAGE.SET_NAME('ONT','OE_DS_NO_LOC_LINK');
1474: OE_MSG_PUB.Add;
1475: resultout := 'COMPLETE:INCOMPLETE';
1476: OE_STANDARD_WF.Save_Messages;
1477: OE_STANDARD_WF.Clear_Msg_Context;
1478: return;
1479: END;
1480:
1481: EXCEPTION

Line 1498: OE_STANDARD_WF.Clear_Msg_Context;

1494: IF l_debug_level > 0 THEN
1495: oe_debug_pub.add('OEXWSCHB.pls: unable to lock the line:'||l_line_id,1);
1496: END IF;
1497: resultout := 'DEFERRED';
1498: OE_STANDARD_WF.Clear_Msg_Context;
1499: RETURN;
1500: END;
1501:
1502: IF item_asset_flag = 'Y' THEN

Line 1603: OE_STANDARD_WF.Save_Messages;

1599: ELSE
1600: resultout := 'COMPLETE:INCOMPLETE';
1601: END IF;
1602:
1603: OE_STANDARD_WF.Save_Messages;
1604: OE_STANDARD_WF.Clear_Msg_Context;
1605: return;
1606: END IF;
1607:

Line 1604: OE_STANDARD_WF.Clear_Msg_Context;

1600: resultout := 'COMPLETE:INCOMPLETE';
1601: END IF;
1602:
1603: OE_STANDARD_WF.Save_Messages;
1604: OE_STANDARD_WF.Clear_Msg_Context;
1605: return;
1606: END IF;
1607:
1608: resultout := 'COMPLETE:COMPLETE';

Line 1609: OE_STANDARD_WF.Clear_Msg_Context;

1605: return;
1606: END IF;
1607:
1608: resultout := 'COMPLETE:COMPLETE';
1609: OE_STANDARD_WF.Clear_Msg_Context;
1610: return;
1611: end if;
1612:
1613:

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

1620: WHEN OTHERS THEN
1621: wf_core.context('OE_OEOL_SCH', 'Release_to_purchasing',
1622: itemtype, itemkey, to_char(actid), funcmode);
1623: -- start data fix project
1624: OE_STANDARD_WF.Add_Error_Activity_Msg(p_actid => actid,
1625: p_itemtype => itemtype,
1626: p_itemkey => itemkey);
1627: OE_STANDARD_WF.Save_Messages;
1628: OE_STANDARD_WF.Clear_Msg_Context;

Line 1627: OE_STANDARD_WF.Save_Messages;

1623: -- start data fix project
1624: OE_STANDARD_WF.Add_Error_Activity_Msg(p_actid => actid,
1625: p_itemtype => itemtype,
1626: p_itemkey => itemkey);
1627: OE_STANDARD_WF.Save_Messages;
1628: OE_STANDARD_WF.Clear_Msg_Context;
1629: -- end data fix project
1630: raise;
1631: END Release_to_purchasing;

Line 1628: OE_STANDARD_WF.Clear_Msg_Context;

1624: OE_STANDARD_WF.Add_Error_Activity_Msg(p_actid => actid,
1625: p_itemtype => itemtype,
1626: p_itemkey => itemkey);
1627: OE_STANDARD_WF.Save_Messages;
1628: OE_STANDARD_WF.Clear_Msg_Context;
1629: -- end data fix project
1630: raise;
1631: END Release_to_purchasing;
1632:

Line 1671: OE_STANDARD_WF.Set_Msg_Context(actid);

1667: IF l_debug_level > 0 THEN
1668: oe_debug_pub.add( 'ITEM KEY IS ' || ITEMKEY ) ;
1669: END IF;
1670:
1671: OE_STANDARD_WF.Set_Msg_Context(actid);
1672:
1673:
1674: BEGIN
1675: SELECT item_type_code,schedule_status_code ,line_category_code,

Line 1707: OE_STANDARD_WF.Clear_Msg_Context;

1703: END IF;
1704:
1705: -- Line is not scheduled, nor is it a service or return line.
1706: resultout := 'COMPLETE:INCOMPLETE';
1707: OE_STANDARD_WF.Clear_Msg_Context;
1708: return;
1709: end if;
1710:
1711: IF (funcmode = 'CANCEL') THEN

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

1717: WHEN OTHERS THEN
1718: wf_core.context('OE_OEOL_SCH', 'Is_Line_Scheduled',
1719: itemtype, itemkey, to_char(actid), funcmode);
1720: -- start data fix project
1721: OE_STANDARD_WF.Add_Error_Activity_Msg(p_actid => actid,
1722: p_itemtype => itemtype,
1723: p_itemkey => itemkey);
1724: OE_STANDARD_WF.Save_Messages;
1725: OE_STANDARD_WF.Clear_Msg_Context;

Line 1724: OE_STANDARD_WF.Save_Messages;

1720: -- start data fix project
1721: OE_STANDARD_WF.Add_Error_Activity_Msg(p_actid => actid,
1722: p_itemtype => itemtype,
1723: p_itemkey => itemkey);
1724: OE_STANDARD_WF.Save_Messages;
1725: OE_STANDARD_WF.Clear_Msg_Context;
1726: -- end data fix project
1727: raise;
1728: END Is_Line_Scheduled;

Line 1725: OE_STANDARD_WF.Clear_Msg_Context;

1721: OE_STANDARD_WF.Add_Error_Activity_Msg(p_actid => actid,
1722: p_itemtype => itemtype,
1723: p_itemkey => itemkey);
1724: OE_STANDARD_WF.Save_Messages;
1725: OE_STANDARD_WF.Clear_Msg_Context;
1726: -- end data fix project
1727: raise;
1728: END Is_Line_Scheduled;
1729:

Line 1758: OE_STANDARD_WF.Set_Msg_Context(actid);

1754: if (funcmode = 'RUN') then
1755:
1756:
1757: oe_debug_pub.add('Item Key is ' || itemkey );
1758: OE_STANDARD_WF.Set_Msg_Context(actid);
1759:
1760:
1761: BEGIN
1762: --Select all required attributes, listing few attributes here.

Line 1803: OE_STANDARD_WF.Clear_Msg_Context;

1799: END IF;
1800:
1801: -- Line is not firmed.
1802: resultout := 'COMPLETE:INCOMPLETE';
1803: OE_STANDARD_WF.Clear_Msg_Context;
1804: return;
1805: end if;
1806:
1807: IF (funcmode = 'CANCEL') THEN

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

1815: oe_debug_pub.add('Error in Workflow',1);
1816: wf_core.context('OE_OEOL_SCH', 'Is_Line_Firmed',
1817: itemtype, itemkey, to_char(actid), funcmode);
1818: -- start data fix project
1819: OE_STANDARD_WF.Add_Error_Activity_Msg(p_actid => actid,
1820: p_itemtype => itemtype,
1821: p_itemkey => itemkey);
1822: OE_STANDARD_WF.Save_Messages;
1823: OE_STANDARD_WF.Clear_Msg_Context;

Line 1822: OE_STANDARD_WF.Save_Messages;

1818: -- start data fix project
1819: OE_STANDARD_WF.Add_Error_Activity_Msg(p_actid => actid,
1820: p_itemtype => itemtype,
1821: p_itemkey => itemkey);
1822: OE_STANDARD_WF.Save_Messages;
1823: OE_STANDARD_WF.Clear_Msg_Context;
1824: -- end data fix project
1825: raise;
1826: END Is_Line_Firmed;

Line 1823: OE_STANDARD_WF.Clear_Msg_Context;

1819: OE_STANDARD_WF.Add_Error_Activity_Msg(p_actid => actid,
1820: p_itemtype => itemtype,
1821: p_itemkey => itemkey);
1822: OE_STANDARD_WF.Save_Messages;
1823: OE_STANDARD_WF.Clear_Msg_Context;
1824: -- end data fix project
1825: raise;
1826: END Is_Line_Firmed;
1827:

Line 1864: OE_STANDARD_WF.Set_Msg_Context(actid);

1860:
1861: oe_debug_pub.add('Within Firm Demand Workflow cover ',1 );
1862: oe_debug_pub.add('Item Key is ' || itemkey );
1863:
1864: OE_STANDARD_WF.Set_Msg_Context(actid);
1865:
1866: Select firm_demand_flag, top_model_line_id, ato_line_id,
1867: ship_model_complete_flag
1868: Into l_firm_demand_flag, l_top_model_line_id, l_ato_line_id,

Line 1971: OE_STANDARD_WF.Clear_Msg_Context;

1967: oe_debug_pub.add('Line is already firmed' );
1968:
1969: END IF;
1970: resultout := 'COMPLETE:COMPLETE';
1971: OE_STANDARD_WF.Clear_Msg_Context;
1972: return;
1973: END IF;
1974:
1975: IF (funcmode = 'CANCEL') THEN

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

1983: wf_core.context('OE_OEOL_SCH', 'Firm_Demand',
1984: itemtype, itemkey, to_char(actid), funcmode);
1985: oe_debug_pub.add('error in workflow');
1986: -- start data fix project
1987: OE_STANDARD_WF.Add_Error_Activity_Msg(p_actid => actid,
1988: p_itemtype => itemtype,
1989: p_itemkey => itemkey);
1990: OE_STANDARD_WF.Save_Messages;
1991: OE_STANDARD_WF.Clear_Msg_Context;

Line 1990: OE_STANDARD_WF.Save_Messages;

1986: -- start data fix project
1987: OE_STANDARD_WF.Add_Error_Activity_Msg(p_actid => actid,
1988: p_itemtype => itemtype,
1989: p_itemkey => itemkey);
1990: OE_STANDARD_WF.Save_Messages;
1991: OE_STANDARD_WF.Clear_Msg_Context;
1992: -- end data fix project
1993: raise;
1994:

Line 1991: OE_STANDARD_WF.Clear_Msg_Context;

1987: OE_STANDARD_WF.Add_Error_Activity_Msg(p_actid => actid,
1988: p_itemtype => itemtype,
1989: p_itemkey => itemkey);
1990: OE_STANDARD_WF.Save_Messages;
1991: OE_STANDARD_WF.Clear_Msg_Context;
1992: -- end data fix project
1993: raise;
1994:
1995: End Firm_Demand;