DBA Data[Home] [Help]

APPS.OE_OEOL_SCH dependencies on OE_STANDARD_WF

Line 285: OE_STANDARD_WF.Set_Msg_Context(actid);

281: IF l_debug_level > 0 THEN
282: oe_debug_pub.add( 'ITEM KEY IS ' || ITEMKEY ) ;
283: END IF;
284:
285: OE_STANDARD_WF.Set_Msg_Context(actid);
286:
287: SAVEPOINT Before_Lock;
288:
289: -- If it is BULK Mode then no need to query these values from Database

Line 539: OE_STANDARD_WF.Save_Messages;

535: END IF;
536:
537: resultout := 'COMPLETE:INCOMPLETE';
538:
539: OE_STANDARD_WF.Save_Messages;
540: OE_STANDARD_WF.Clear_Msg_Context;
541:
542: OE_Delayed_Requests_PVT.Clear_Request
543: (x_return_status => l_return_status);

Line 540: OE_STANDARD_WF.Clear_Msg_Context;

536:
537: resultout := 'COMPLETE:INCOMPLETE';
538:
539: OE_STANDARD_WF.Save_Messages;
540: OE_STANDARD_WF.Clear_Msg_Context;
541:
542: OE_Delayed_Requests_PVT.Clear_Request
543: (x_return_status => l_return_status);
544:

Line 551: OE_STANDARD_WF.Save_Messages;

547: END IF;
548:
549: resultout := 'COMPLETE:NOT_ELIGIBLE';
550:
551: OE_STANDARD_WF.Save_Messages;
552: OE_STANDARD_WF.Clear_Msg_Context;
553:
554: OE_Delayed_Requests_PVT.Clear_Request
555: (x_return_status => l_return_status);

Line 552: OE_STANDARD_WF.Clear_Msg_Context;

548:
549: resultout := 'COMPLETE:NOT_ELIGIBLE';
550:
551: OE_STANDARD_WF.Save_Messages;
552: OE_STANDARD_WF.Clear_Msg_Context;
553:
554: OE_Delayed_Requests_PVT.Clear_Request
555: (x_return_status => l_return_status);
556: return;

Line 576: OE_STANDARD_WF.Save_Messages;

572: IF NOT l_scheduled
573: THEN
574: ROLLBACK TO Before_Lock;
575: resultout := 'COMPLETE:INCOMPLETE';
576: OE_STANDARD_WF.Save_Messages;
577: OE_STANDARD_WF.Clear_Msg_Context;
578: --5166476
579: IF OE_SCH_CONC_REQUESTS.g_recorded = 'N' THEN
580: OE_SCH_CONC_REQUESTS.OE_line_status_Tbl(l_line_id) := 'N';

Line 577: OE_STANDARD_WF.Clear_Msg_Context;

573: THEN
574: ROLLBACK TO Before_Lock;
575: resultout := 'COMPLETE:INCOMPLETE';
576: OE_STANDARD_WF.Save_Messages;
577: OE_STANDARD_WF.Clear_Msg_Context;
578: --5166476
579: IF OE_SCH_CONC_REQUESTS.g_recorded = 'N' THEN
580: OE_SCH_CONC_REQUESTS.OE_line_status_Tbl(l_line_id) := 'N';
581: OE_SCH_CONC_REQUESTS.g_recorded :='Y';

Line 591: OE_STANDARD_WF.Save_Messages;

587: END IF;
588: IF Is_Scheduling_Eligible(l_top_model_line_id) THEN -- Bug3083995
589: ROLLBACK TO Before_Lock;
590: resultout := 'COMPLETE:INCOMPLETE';
591: OE_STANDARD_WF.Save_Messages;
592: OE_STANDARD_WF.Clear_Msg_Context;
593: --5166476
594: IF OE_SCH_CONC_REQUESTS.g_recorded = 'N' THEN
595: OE_SCH_CONC_REQUESTS.OE_line_status_Tbl(l_line_id) := 'N';

Line 592: OE_STANDARD_WF.Clear_Msg_Context;

588: IF Is_Scheduling_Eligible(l_top_model_line_id) THEN -- Bug3083995
589: ROLLBACK TO Before_Lock;
590: resultout := 'COMPLETE:INCOMPLETE';
591: OE_STANDARD_WF.Save_Messages;
592: OE_STANDARD_WF.Clear_Msg_Context;
593: --5166476
594: IF OE_SCH_CONC_REQUESTS.g_recorded = 'N' THEN
595: OE_SCH_CONC_REQUESTS.OE_line_status_Tbl(l_line_id) := 'N';
596: OE_SCH_CONC_REQUESTS.g_recorded :='Y';

Line 613: OE_STANDARD_WF.Save_Messages;

609: IF NOT l_scheduled
610: THEN
611: ROLLBACK TO Before_Lock;
612: resultout := 'COMPLETE:INCOMPLETE';
613: OE_STANDARD_WF.Save_Messages;
614: OE_STANDARD_WF.Clear_Msg_Context;
615: --5166476
616: IF OE_SCH_CONC_REQUESTS.g_recorded = 'N' THEN
617: OE_SCH_CONC_REQUESTS.OE_line_status_Tbl(l_line_id) := 'N';

Line 614: OE_STANDARD_WF.Clear_Msg_Context;

610: THEN
611: ROLLBACK TO Before_Lock;
612: resultout := 'COMPLETE:INCOMPLETE';
613: OE_STANDARD_WF.Save_Messages;
614: OE_STANDARD_WF.Clear_Msg_Context;
615: --5166476
616: IF OE_SCH_CONC_REQUESTS.g_recorded = 'N' THEN
617: OE_SCH_CONC_REQUESTS.OE_line_status_Tbl(l_line_id) := 'N';
618: OE_SCH_CONC_REQUESTS.g_recorded :='Y';

Line 634: OE_STANDARD_WF.Save_Messages;

630: OE_SCH_CONC_REQUESTS.OE_line_status_Tbl(l_line_id) := 'N';
631: OE_SCH_CONC_REQUESTS.g_recorded :='Y';
632: END IF;
633:
634: OE_STANDARD_WF.Save_Messages;
635: OE_STANDARD_WF.Clear_Msg_Context;
636:
637: OE_Delayed_Requests_PVT.Clear_Request
638: (x_return_status => l_return_status);

Line 635: OE_STANDARD_WF.Clear_Msg_Context;

631: OE_SCH_CONC_REQUESTS.g_recorded :='Y';
632: END IF;
633:
634: OE_STANDARD_WF.Save_Messages;
635: OE_STANDARD_WF.Clear_Msg_Context;
636:
637: OE_Delayed_Requests_PVT.Clear_Request
638: (x_return_status => l_return_status);
639: return;

Line 649: OE_STANDARD_WF.Save_Messages;

645: IF NOT l_scheduled
646: THEN
647: ROLLBACK TO Before_Lock;
648: resultout := 'COMPLETE:INCOMPLETE';
649: OE_STANDARD_WF.Save_Messages;
650: OE_STANDARD_WF.Clear_Msg_Context;
651: --5166476
652: IF OE_SCH_CONC_REQUESTS.g_recorded = 'N' THEN
653: OE_SCH_CONC_REQUESTS.OE_line_status_Tbl(l_line_id) := 'N';

Line 650: OE_STANDARD_WF.Clear_Msg_Context;

646: THEN
647: ROLLBACK TO Before_Lock;
648: resultout := 'COMPLETE:INCOMPLETE';
649: OE_STANDARD_WF.Save_Messages;
650: OE_STANDARD_WF.Clear_Msg_Context;
651: --5166476
652: IF OE_SCH_CONC_REQUESTS.g_recorded = 'N' THEN
653: OE_SCH_CONC_REQUESTS.OE_line_status_Tbl(l_line_id) := 'N';
654: OE_SCH_CONC_REQUESTS.g_recorded :='Y';

Line 670: OE_STANDARD_WF.Save_Messages;

666: OE_SCH_CONC_REQUESTS.OE_line_status_Tbl(l_line_id) := 'N';
667: OE_SCH_CONC_REQUESTS.g_recorded :='Y';
668: END IF;
669:
670: OE_STANDARD_WF.Save_Messages;
671: OE_STANDARD_WF.Clear_Msg_Context;
672:
673: OE_Delayed_Requests_PVT.Clear_Request
674: (x_return_status => l_return_status);

Line 671: OE_STANDARD_WF.Clear_Msg_Context;

667: OE_SCH_CONC_REQUESTS.g_recorded :='Y';
668: END IF;
669:
670: OE_STANDARD_WF.Save_Messages;
671: OE_STANDARD_WF.Clear_Msg_Context;
672:
673: OE_Delayed_Requests_PVT.Clear_Request
674: (x_return_status => l_return_status);
675: return;

Line 734: OE_STANDARD_WF.Save_Messages;

730: -- End modified for bug 2515791
731: OE_MSG_PUB.Add;
732:
733: resultout := 'COMPLETE:ON_HOLD';
734: OE_STANDARD_WF.Save_Messages;
735: OE_STANDARD_WF.Clear_Msg_Context;
736:
737: OE_Delayed_Requests_PVT.Clear_Request
738: (x_return_status => l_return_status);

Line 735: OE_STANDARD_WF.Clear_Msg_Context;

731: OE_MSG_PUB.Add;
732:
733: resultout := 'COMPLETE:ON_HOLD';
734: OE_STANDARD_WF.Save_Messages;
735: OE_STANDARD_WF.Clear_Msg_Context;
736:
737: OE_Delayed_Requests_PVT.Clear_Request
738: (x_return_status => l_return_status);
739: return;

Line 816: OE_STANDARD_WF.Save_Messages;

812: oe_debug_pub.add( 'SMC :PUSHING LINE TO SCHEDULE ELIGIBLE' , 2 ) ;
813: END IF;
814: ROLLBACK TO Before_Lock;
815: resultout := 'COMPLETE:INCOMPLETE';
816: OE_STANDARD_WF.Save_Messages;
817: OE_STANDARD_WF.Clear_Msg_Context;
818:
819: OE_Delayed_Requests_PVT.Clear_Request
820: (x_return_status => l_return_status);

Line 817: OE_STANDARD_WF.Clear_Msg_Context;

813: END IF;
814: ROLLBACK TO Before_Lock;
815: resultout := 'COMPLETE:INCOMPLETE';
816: OE_STANDARD_WF.Save_Messages;
817: OE_STANDARD_WF.Clear_Msg_Context;
818:
819: OE_Delayed_Requests_PVT.Clear_Request
820: (x_return_status => l_return_status);
821: return;

Line 859: OE_STANDARD_WF.Save_Messages;

855: oe_debug_pub.add( 'ATO: PUSHING LINE TO SCHEDULE ELIGIBLE' , 2 ) ;
856: END IF;
857: ROLLBACK TO Before_Lock;
858: resultout := 'COMPLETE:INCOMPLETE';
859: OE_STANDARD_WF.Save_Messages;
860: OE_STANDARD_WF.Clear_Msg_Context;
861:
862: OE_Delayed_Requests_PVT.Clear_Request
863: (x_return_status => l_return_status);

Line 860: OE_STANDARD_WF.Clear_Msg_Context;

856: END IF;
857: ROLLBACK TO Before_Lock;
858: resultout := 'COMPLETE:INCOMPLETE';
859: OE_STANDARD_WF.Save_Messages;
860: OE_STANDARD_WF.Clear_Msg_Context;
861:
862: OE_Delayed_Requests_PVT.Clear_Request
863: (x_return_status => l_return_status);
864: return;

Line 920: OE_STANDARD_WF.Save_Messages;

916: END IF;
917: resultout := 'COMPLETE:INCOMPLETE';
918: -- moved this line up to for the bug fix 2884452
919: ROLLBACK TO SAVEPOINT Schedule_line;
920: OE_STANDARD_WF.Save_Messages;
921: OE_STANDARD_WF.Clear_Msg_Context;
922: --commit; /* Added this line to fix the bug 2884452 */
923: OE_Delayed_Requests_PVT.Clear_Request
924: (x_return_status => l_return_status);

Line 921: OE_STANDARD_WF.Clear_Msg_Context;

917: resultout := 'COMPLETE:INCOMPLETE';
918: -- moved this line up to for the bug fix 2884452
919: ROLLBACK TO SAVEPOINT Schedule_line;
920: OE_STANDARD_WF.Save_Messages;
921: OE_STANDARD_WF.Clear_Msg_Context;
922: --commit; /* Added this line to fix the bug 2884452 */
923: OE_Delayed_Requests_PVT.Clear_Request
924: (x_return_status => l_return_status);
925: --5122730

Line 941: OE_STANDARD_WF.Save_Messages;

937: END IF;
938: resultout := 'COMPLETE:INCOMPLETE';
939: -- moved this line up to for the bug fix 2884452
940: ROLLBACK TO SAVEPOINT Schedule_line;
941: OE_STANDARD_WF.Save_Messages;
942: OE_STANDARD_WF.Clear_Msg_Context;
943: --commit; /* Added this line to fix the bug 2884452 */
944: OE_Delayed_Requests_PVT.Clear_Request
945: (x_return_status => l_return_status);

Line 942: OE_STANDARD_WF.Clear_Msg_Context;

938: resultout := 'COMPLETE:INCOMPLETE';
939: -- moved this line up to for the bug fix 2884452
940: ROLLBACK TO SAVEPOINT Schedule_line;
941: OE_STANDARD_WF.Save_Messages;
942: OE_STANDARD_WF.Clear_Msg_Context;
943: --commit; /* Added this line to fix the bug 2884452 */
944: OE_Delayed_Requests_PVT.Clear_Request
945: (x_return_status => l_return_status);
946: -- app_exception.raise_exception;

Line 981: OE_STANDARD_WF.Clear_Msg_Context;

977: END IF;
978: --
979:
980: resultout := 'COMPLETE:COMPLETE';
981: OE_STANDARD_WF.Clear_Msg_Context;
982:
983: Bulk_Mode_Copy_Sch_Attribs
984: (p_line_rec => l_line_rec);
985:

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

995: WHEN OTHERS THEN
996: wf_core.context('OE_OEOL_SCH', 'Schedule Line',
997: itemtype, itemkey, to_char(actid), funcmode);
998: -- start data fix project
999: OE_STANDARD_WF.Add_Error_Activity_Msg(p_actid => actid,
1000: p_itemtype => itemtype,
1001: p_itemkey => itemkey);
1002: OE_STANDARD_WF.Save_Messages;
1003: OE_STANDARD_WF.Clear_Msg_Context;

Line 1002: OE_STANDARD_WF.Save_Messages;

998: -- start data fix project
999: OE_STANDARD_WF.Add_Error_Activity_Msg(p_actid => actid,
1000: p_itemtype => itemtype,
1001: p_itemkey => itemkey);
1002: OE_STANDARD_WF.Save_Messages;
1003: OE_STANDARD_WF.Clear_Msg_Context;
1004: -- end data fix project
1005: raise;
1006: END Schedule_Line;

Line 1003: OE_STANDARD_WF.Clear_Msg_Context;

999: OE_STANDARD_WF.Add_Error_Activity_Msg(p_actid => actid,
1000: p_itemtype => itemtype,
1001: p_itemkey => itemkey);
1002: OE_STANDARD_WF.Save_Messages;
1003: OE_STANDARD_WF.Clear_Msg_Context;
1004: -- end data fix project
1005: raise;
1006: END Schedule_Line;
1007:

Line 1113: OE_STANDARD_WF.Set_Msg_Context(actid);

1109: --
1110: -- RUN mode - normal process execution
1111: --
1112: -- start data fix project
1113: OE_STANDARD_WF.Set_Msg_Context(actid);
1114: -- end data fix project
1115:
1116: -- l_line_rec := OE_Line_Util.Query_Row(to_number(itemkey));
1117: /* Changes for performance, the query row is being replaced by a select.

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

1191: WHEN OTHERS THEN
1192: wf_core.context('OE_OEOL_SCH', 'Branch_on_source_type',
1193: itemtype, itemkey, to_char(actid), funcmode);
1194: -- start data fix project
1195: OE_STANDARD_WF.Add_Error_Activity_Msg(p_actid => actid,
1196: p_itemtype => itemtype,
1197: p_itemkey => itemkey);
1198: OE_STANDARD_WF.Save_Messages;
1199: OE_STANDARD_WF.Clear_Msg_Context;

Line 1198: OE_STANDARD_WF.Save_Messages;

1194: -- start data fix project
1195: OE_STANDARD_WF.Add_Error_Activity_Msg(p_actid => actid,
1196: p_itemtype => itemtype,
1197: p_itemkey => itemkey);
1198: OE_STANDARD_WF.Save_Messages;
1199: OE_STANDARD_WF.Clear_Msg_Context;
1200: -- end data fix project
1201: raise;
1202: END Branch_on_source_type;

Line 1199: OE_STANDARD_WF.Clear_Msg_Context;

1195: OE_STANDARD_WF.Add_Error_Activity_Msg(p_actid => actid,
1196: p_itemtype => itemtype,
1197: p_itemkey => itemkey);
1198: OE_STANDARD_WF.Save_Messages;
1199: OE_STANDARD_WF.Clear_Msg_Context;
1200: -- end data fix project
1201: raise;
1202: END Branch_on_source_type;
1203:

Line 1258: OE_STANDARD_WF.Set_Msg_Context(actid);

1254: IF l_debug_level > 0 THEN
1255: oe_debug_pub.add('Entering Release to Purchasing line',1);
1256: END IF;
1257:
1258: OE_STANDARD_WF.Set_Msg_Context(actid);
1259:
1260: OE_Line_Util.Query_Row(p_line_id => to_number(itemkey), x_line_rec => l_line_rec);
1261: OE_Header_Util.Query_Row(p_header_id => l_line_rec.header_id, x_header_rec => l_header_rec);
1262:

Line 1289: OE_STANDARD_WF.Save_Messages;

1285:
1286: FND_MESSAGE.SET_NAME('ONT','OE_DS_WHSE_REQD');
1287: OE_MSG_PUB.Add;
1288: resultout := 'COMPLETE:INCOMPLETE';
1289: OE_STANDARD_WF.Save_Messages;
1290: OE_STANDARD_WF.Clear_Msg_Context;
1291: return;
1292: END IF;
1293:

Line 1290: OE_STANDARD_WF.Clear_Msg_Context;

1286: FND_MESSAGE.SET_NAME('ONT','OE_DS_WHSE_REQD');
1287: OE_MSG_PUB.Add;
1288: resultout := 'COMPLETE:INCOMPLETE';
1289: OE_STANDARD_WF.Save_Messages;
1290: OE_STANDARD_WF.Clear_Msg_Context;
1291: return;
1292: END IF;
1293:
1294: BEGIN

Line 1355: OE_STANDARD_WF.Save_Messages;

1351: END IF;
1352: FND_MESSAGE.SET_NAME('ONT','OE_DS_NO_LOC_LINK');
1353: OE_MSG_PUB.Add;
1354: resultout := 'COMPLETE:INCOMPLETE';
1355: OE_STANDARD_WF.Save_Messages;
1356: OE_STANDARD_WF.Clear_Msg_Context;
1357: return;
1358: END;
1359:

Line 1356: OE_STANDARD_WF.Clear_Msg_Context;

1352: FND_MESSAGE.SET_NAME('ONT','OE_DS_NO_LOC_LINK');
1353: OE_MSG_PUB.Add;
1354: resultout := 'COMPLETE:INCOMPLETE';
1355: OE_STANDARD_WF.Save_Messages;
1356: OE_STANDARD_WF.Clear_Msg_Context;
1357: return;
1358: END;
1359:
1360: EXCEPTION

Line 1377: OE_STANDARD_WF.Clear_Msg_Context;

1373: IF l_debug_level > 0 THEN
1374: oe_debug_pub.add('OEXWSCHB.pls: unable to lock the line:'||l_line_id,1);
1375: END IF;
1376: resultout := 'DEFERRED';
1377: OE_STANDARD_WF.Clear_Msg_Context;
1378: RETURN;
1379: END;
1380:
1381: IF item_asset_flag = 'Y' THEN

Line 1482: OE_STANDARD_WF.Save_Messages;

1478: ELSE
1479: resultout := 'COMPLETE:INCOMPLETE';
1480: END IF;
1481:
1482: OE_STANDARD_WF.Save_Messages;
1483: OE_STANDARD_WF.Clear_Msg_Context;
1484: return;
1485: END IF;
1486:

Line 1483: OE_STANDARD_WF.Clear_Msg_Context;

1479: resultout := 'COMPLETE:INCOMPLETE';
1480: END IF;
1481:
1482: OE_STANDARD_WF.Save_Messages;
1483: OE_STANDARD_WF.Clear_Msg_Context;
1484: return;
1485: END IF;
1486:
1487: resultout := 'COMPLETE:COMPLETE';

Line 1488: OE_STANDARD_WF.Clear_Msg_Context;

1484: return;
1485: END IF;
1486:
1487: resultout := 'COMPLETE:COMPLETE';
1488: OE_STANDARD_WF.Clear_Msg_Context;
1489: return;
1490: end if;
1491:
1492:

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

1499: WHEN OTHERS THEN
1500: wf_core.context('OE_OEOL_SCH', 'Release_to_purchasing',
1501: itemtype, itemkey, to_char(actid), funcmode);
1502: -- start data fix project
1503: OE_STANDARD_WF.Add_Error_Activity_Msg(p_actid => actid,
1504: p_itemtype => itemtype,
1505: p_itemkey => itemkey);
1506: OE_STANDARD_WF.Save_Messages;
1507: OE_STANDARD_WF.Clear_Msg_Context;

Line 1506: OE_STANDARD_WF.Save_Messages;

1502: -- start data fix project
1503: OE_STANDARD_WF.Add_Error_Activity_Msg(p_actid => actid,
1504: p_itemtype => itemtype,
1505: p_itemkey => itemkey);
1506: OE_STANDARD_WF.Save_Messages;
1507: OE_STANDARD_WF.Clear_Msg_Context;
1508: -- end data fix project
1509: raise;
1510: END Release_to_purchasing;

Line 1507: OE_STANDARD_WF.Clear_Msg_Context;

1503: OE_STANDARD_WF.Add_Error_Activity_Msg(p_actid => actid,
1504: p_itemtype => itemtype,
1505: p_itemkey => itemkey);
1506: OE_STANDARD_WF.Save_Messages;
1507: OE_STANDARD_WF.Clear_Msg_Context;
1508: -- end data fix project
1509: raise;
1510: END Release_to_purchasing;
1511:

Line 1549: OE_STANDARD_WF.Set_Msg_Context(actid);

1545: IF l_debug_level > 0 THEN
1546: oe_debug_pub.add( 'ITEM KEY IS ' || ITEMKEY ) ;
1547: END IF;
1548:
1549: OE_STANDARD_WF.Set_Msg_Context(actid);
1550:
1551:
1552: BEGIN
1553: SELECT item_type_code,schedule_status_code ,line_category_code

Line 1581: OE_STANDARD_WF.Clear_Msg_Context;

1577: END IF;
1578:
1579: -- Line is not scheduled, nor is it a service or return line.
1580: resultout := 'COMPLETE:INCOMPLETE';
1581: OE_STANDARD_WF.Clear_Msg_Context;
1582: return;
1583: end if;
1584:
1585: IF (funcmode = 'CANCEL') THEN

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

1591: WHEN OTHERS THEN
1592: wf_core.context('OE_OEOL_SCH', 'Is_Line_Scheduled',
1593: itemtype, itemkey, to_char(actid), funcmode);
1594: -- start data fix project
1595: OE_STANDARD_WF.Add_Error_Activity_Msg(p_actid => actid,
1596: p_itemtype => itemtype,
1597: p_itemkey => itemkey);
1598: OE_STANDARD_WF.Save_Messages;
1599: OE_STANDARD_WF.Clear_Msg_Context;

Line 1598: OE_STANDARD_WF.Save_Messages;

1594: -- start data fix project
1595: OE_STANDARD_WF.Add_Error_Activity_Msg(p_actid => actid,
1596: p_itemtype => itemtype,
1597: p_itemkey => itemkey);
1598: OE_STANDARD_WF.Save_Messages;
1599: OE_STANDARD_WF.Clear_Msg_Context;
1600: -- end data fix project
1601: raise;
1602: END Is_Line_Scheduled;

Line 1599: OE_STANDARD_WF.Clear_Msg_Context;

1595: OE_STANDARD_WF.Add_Error_Activity_Msg(p_actid => actid,
1596: p_itemtype => itemtype,
1597: p_itemkey => itemkey);
1598: OE_STANDARD_WF.Save_Messages;
1599: OE_STANDARD_WF.Clear_Msg_Context;
1600: -- end data fix project
1601: raise;
1602: END Is_Line_Scheduled;
1603:

Line 1631: OE_STANDARD_WF.Set_Msg_Context(actid);

1627: if (funcmode = 'RUN') then
1628:
1629:
1630: oe_debug_pub.add('Item Key is ' || itemkey );
1631: OE_STANDARD_WF.Set_Msg_Context(actid);
1632:
1633:
1634: BEGIN
1635: --Select all required attributes, listing few attributes here.

Line 1672: OE_STANDARD_WF.Clear_Msg_Context;

1668: END IF;
1669:
1670: -- Line is not firmed.
1671: resultout := 'COMPLETE:INCOMPLETE';
1672: OE_STANDARD_WF.Clear_Msg_Context;
1673: return;
1674: end if;
1675:
1676: IF (funcmode = 'CANCEL') THEN

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

1684: oe_debug_pub.add('Error in Workflow',1);
1685: wf_core.context('OE_OEOL_SCH', 'Is_Line_Firmed',
1686: itemtype, itemkey, to_char(actid), funcmode);
1687: -- start data fix project
1688: OE_STANDARD_WF.Add_Error_Activity_Msg(p_actid => actid,
1689: p_itemtype => itemtype,
1690: p_itemkey => itemkey);
1691: OE_STANDARD_WF.Save_Messages;
1692: OE_STANDARD_WF.Clear_Msg_Context;

Line 1691: OE_STANDARD_WF.Save_Messages;

1687: -- start data fix project
1688: OE_STANDARD_WF.Add_Error_Activity_Msg(p_actid => actid,
1689: p_itemtype => itemtype,
1690: p_itemkey => itemkey);
1691: OE_STANDARD_WF.Save_Messages;
1692: OE_STANDARD_WF.Clear_Msg_Context;
1693: -- end data fix project
1694: raise;
1695: END Is_Line_Firmed;

Line 1692: OE_STANDARD_WF.Clear_Msg_Context;

1688: OE_STANDARD_WF.Add_Error_Activity_Msg(p_actid => actid,
1689: p_itemtype => itemtype,
1690: p_itemkey => itemkey);
1691: OE_STANDARD_WF.Save_Messages;
1692: OE_STANDARD_WF.Clear_Msg_Context;
1693: -- end data fix project
1694: raise;
1695: END Is_Line_Firmed;
1696:

Line 1733: OE_STANDARD_WF.Set_Msg_Context(actid);

1729:
1730: oe_debug_pub.add('Within Firm Demand Workflow cover ',1 );
1731: oe_debug_pub.add('Item Key is ' || itemkey );
1732:
1733: OE_STANDARD_WF.Set_Msg_Context(actid);
1734:
1735: Select firm_demand_flag, top_model_line_id, ato_line_id,
1736: ship_model_complete_flag
1737: Into l_firm_demand_flag, l_top_model_line_id, l_ato_line_id,

Line 1826: OE_STANDARD_WF.Clear_Msg_Context;

1822: oe_debug_pub.add('Line is already firmed' );
1823:
1824: END IF;
1825: resultout := 'COMPLETE:COMPLETE';
1826: OE_STANDARD_WF.Clear_Msg_Context;
1827: return;
1828: END IF;
1829:
1830: IF (funcmode = 'CANCEL') THEN

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

1838: wf_core.context('OE_OEOL_SCH', 'Firm_Demand',
1839: itemtype, itemkey, to_char(actid), funcmode);
1840: oe_debug_pub.add('error in workflow');
1841: -- start data fix project
1842: OE_STANDARD_WF.Add_Error_Activity_Msg(p_actid => actid,
1843: p_itemtype => itemtype,
1844: p_itemkey => itemkey);
1845: OE_STANDARD_WF.Save_Messages;
1846: OE_STANDARD_WF.Clear_Msg_Context;

Line 1845: OE_STANDARD_WF.Save_Messages;

1841: -- start data fix project
1842: OE_STANDARD_WF.Add_Error_Activity_Msg(p_actid => actid,
1843: p_itemtype => itemtype,
1844: p_itemkey => itemkey);
1845: OE_STANDARD_WF.Save_Messages;
1846: OE_STANDARD_WF.Clear_Msg_Context;
1847: -- end data fix project
1848: raise;
1849:

Line 1846: OE_STANDARD_WF.Clear_Msg_Context;

1842: OE_STANDARD_WF.Add_Error_Activity_Msg(p_actid => actid,
1843: p_itemtype => itemtype,
1844: p_itemkey => itemkey);
1845: OE_STANDARD_WF.Save_Messages;
1846: OE_STANDARD_WF.Clear_Msg_Context;
1847: -- end data fix project
1848: raise;
1849:
1850: End Firm_Demand;