DBA Data[Home] [Help]

APPS.OE_FLEX_COGS_PUB dependencies on STANDARD

Line 536: OE_STANDARD_WF.Set_Msg_Context(actid);

532:
533: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
534: BEGIN
535: -- start data fix project
536: OE_STANDARD_WF.Set_Msg_Context(actid);
537: -- end data fix project
538: IF l_debug_level > 0 THEN
539: oe_debug_pub.add('Entering OE_Flex_Cogs_Pub.GET_COST_SALE_ITEM_DERIVED');
540: oe_debug_pub.add(' Item Type : '||itemtype,2);

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

661: wf_core.context('OE_FLEX_COGS_PUB','GET_COST_SALE_ITEM_DERIVED',
662: itemtype,itemkey,TO_CHAR(actid),funcmode);
663: result := 'COMPLETE:FAILURE';
664: -- start data fix project
665: OE_STANDARD_WF.Add_Error_Activity_Msg(p_actid => actid,
666: p_itemtype => itemtype,
667: p_itemkey => itemkey);
668: OE_STANDARD_WF.Save_Messages;
669: OE_STANDARD_WF.Clear_Msg_Context;

Line 668: OE_STANDARD_WF.Save_Messages;

664: -- start data fix project
665: OE_STANDARD_WF.Add_Error_Activity_Msg(p_actid => actid,
666: p_itemtype => itemtype,
667: p_itemkey => itemkey);
668: OE_STANDARD_WF.Save_Messages;
669: OE_STANDARD_WF.Clear_Msg_Context;
670: -- end data fix project
671: RAISE;
672: END GET_COST_SALE_ITEM_DERIVED;

Line 669: OE_STANDARD_WF.Clear_Msg_Context;

665: OE_STANDARD_WF.Add_Error_Activity_Msg(p_actid => actid,
666: p_itemtype => itemtype,
667: p_itemkey => itemkey);
668: OE_STANDARD_WF.Save_Messages;
669: OE_STANDARD_WF.Clear_Msg_Context;
670: -- end data fix project
671: RAISE;
672: END GET_COST_SALE_ITEM_DERIVED;
673:

Line 701: OE_STANDARD_WF.Set_Msg_Context(actid);

697:
698: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
699: BEGIN
700: -- start data fix project
701: OE_STANDARD_WF.Set_Msg_Context(actid);
702: -- end data fix project
703: IF l_debug_level > 0 THEN
704: oe_debug_pub.add('Entering OE_Flex_Cogs_Pub.GET_COST_SALE_MODEL_DERIVED');
705:

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

793: wf_core.context('OE_FLEX_COGS_PUB','GET_MODEL_DERIVED',
794: itemtype,itemkey,TO_CHAR(actid),funcmode);
795: result := 'COMPLETE:FAILURE';
796: -- start data fix project
797: OE_STANDARD_WF.Add_Error_Activity_Msg(p_actid => actid,
798: p_itemtype => itemtype,
799: p_itemkey => itemkey);
800: OE_STANDARD_WF.Save_Messages;
801: OE_STANDARD_WF.Clear_Msg_Context;

Line 800: OE_STANDARD_WF.Save_Messages;

796: -- start data fix project
797: OE_STANDARD_WF.Add_Error_Activity_Msg(p_actid => actid,
798: p_itemtype => itemtype,
799: p_itemkey => itemkey);
800: OE_STANDARD_WF.Save_Messages;
801: OE_STANDARD_WF.Clear_Msg_Context;
802: -- end data fix project
803: RAISE;
804: END Get_Model_Derived;

Line 801: OE_STANDARD_WF.Clear_Msg_Context;

797: OE_STANDARD_WF.Add_Error_Activity_Msg(p_actid => actid,
798: p_itemtype => itemtype,
799: p_itemkey => itemkey);
800: OE_STANDARD_WF.Save_Messages;
801: OE_STANDARD_WF.Clear_Msg_Context;
802: -- end data fix project
803: RAISE;
804: END Get_Model_Derived;
805:

Line 828: OE_STANDARD_WF.Set_Msg_Context(actid);

824:
825: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
826: BEGIN
827: -- start data fix project
828: OE_STANDARD_WF.Set_Msg_Context(actid);
829: -- end data fix project
830: IF l_debug_level > 0 THEN
831: oe_debug_pub.add('Entering OE_Flex_Cogs_Pub.GET_ORDER_TYPE_DERIVED');
832: oe_debug_pub.add(' Item Type : '||itemtype,2);

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

899: wf_core.context('OE_FLEX_COGS_PUB','GET_ORDER_TYPE_DERIVED',
900: itemtype,itemkey,TO_CHAR(actid),funcmode);
901: result := 'COMPLETE:FAILURE';
902: -- start data fix project
903: OE_STANDARD_WF.Add_Error_Activity_Msg(p_actid => actid,
904: p_itemtype => itemtype,
905: p_itemkey => itemkey);
906: OE_STANDARD_WF.Save_Messages;
907: OE_STANDARD_WF.Clear_Msg_Context;

Line 906: OE_STANDARD_WF.Save_Messages;

902: -- start data fix project
903: OE_STANDARD_WF.Add_Error_Activity_Msg(p_actid => actid,
904: p_itemtype => itemtype,
905: p_itemkey => itemkey);
906: OE_STANDARD_WF.Save_Messages;
907: OE_STANDARD_WF.Clear_Msg_Context;
908: -- end data fix project
909: RAISE;
910: END Get_Order_Type_Derived;

Line 907: OE_STANDARD_WF.Clear_Msg_Context;

903: OE_STANDARD_WF.Add_Error_Activity_Msg(p_actid => actid,
904: p_itemtype => itemtype,
905: p_itemkey => itemkey);
906: OE_STANDARD_WF.Save_Messages;
907: OE_STANDARD_WF.Clear_Msg_Context;
908: -- end data fix project
909: RAISE;
910: END Get_Order_Type_Derived;
911:

Line 934: OE_STANDARD_WF.Set_Msg_Context(actid);

930: l_error_msg VARCHAR2(240) DEFAULT NULL;
931: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
932: BEGIN
933: -- start data fix project
934: OE_STANDARD_WF.Set_Msg_Context(actid);
935: -- end data fix project
936: IF l_debug_level > 0 THEN
937: oe_debug_pub.add('Entering OE_FLEX_COGS_PUB.GET_SALESREP_REV_DERIVED',1);
938: END IF;

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

1008: wf_core.context('OE_FLEX_COGS_PUB','GET_SALESREP_REV_DERIVED',
1009: itemtype,itemkey,TO_CHAR(actid),funcmode);
1010: result := 'COMPLETE:FAILURE';
1011: -- start data fix project
1012: OE_STANDARD_WF.Add_Error_Activity_Msg(p_actid => actid,
1013: p_itemtype => itemtype,
1014: p_itemkey => itemkey);
1015: OE_STANDARD_WF.Save_Messages;
1016: OE_STANDARD_WF.Clear_Msg_Context;

Line 1015: OE_STANDARD_WF.Save_Messages;

1011: -- start data fix project
1012: OE_STANDARD_WF.Add_Error_Activity_Msg(p_actid => actid,
1013: p_itemtype => itemtype,
1014: p_itemkey => itemkey);
1015: OE_STANDARD_WF.Save_Messages;
1016: OE_STANDARD_WF.Clear_Msg_Context;
1017: -- end data fix project
1018: RAISE;
1019: END Get_Salesrep_Rev_Derived;

Line 1016: OE_STANDARD_WF.Clear_Msg_Context;

1012: OE_STANDARD_WF.Add_Error_Activity_Msg(p_actid => actid,
1013: p_itemtype => itemtype,
1014: p_itemkey => itemkey);
1015: OE_STANDARD_WF.Save_Messages;
1016: OE_STANDARD_WF.Clear_Msg_Context;
1017: -- end data fix project
1018: RAISE;
1019: END Get_Salesrep_Rev_Derived;
1020:

Line 1042: OE_STANDARD_WF.Set_Msg_Context(actid);

1038: l_order_type_id NUMBER; --a.k.a transaction_type_id, line_type_id
1039: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1040: BEGIN
1041: -- start data fix project
1042: OE_STANDARD_WF.Set_Msg_Context(actid);
1043: -- end data fix project
1044: IF l_debug_level > 0 THEN
1045: oe_debug_pub.add('Entering Get_type_from_line',2);
1046: END IF;

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

1096: wf_core.context('OE_FLEX_COGS_PUB','GET_TYPE_FROM_LINE',
1097: itemtype,itemkey,TO_CHAR(actid),funcmode);
1098: result := 'COMPLETE:FAILURE';
1099: -- start data fix project
1100: OE_STANDARD_WF.Add_Error_Activity_Msg(p_actid => actid,
1101: p_itemtype => itemtype,
1102: p_itemkey => itemkey);
1103: OE_STANDARD_WF.Save_Messages;
1104: OE_STANDARD_WF.Clear_Msg_Context;

Line 1103: OE_STANDARD_WF.Save_Messages;

1099: -- start data fix project
1100: OE_STANDARD_WF.Add_Error_Activity_Msg(p_actid => actid,
1101: p_itemtype => itemtype,
1102: p_itemkey => itemkey);
1103: OE_STANDARD_WF.Save_Messages;
1104: OE_STANDARD_WF.Clear_Msg_Context;
1105: -- end data fix project
1106: RAISE;
1107: END Get_Type_From_Line;

Line 1104: OE_STANDARD_WF.Clear_Msg_Context;

1100: OE_STANDARD_WF.Add_Error_Activity_Msg(p_actid => actid,
1101: p_itemtype => itemtype,
1102: p_itemkey => itemkey);
1103: OE_STANDARD_WF.Save_Messages;
1104: OE_STANDARD_WF.Clear_Msg_Context;
1105: -- end data fix project
1106: RAISE;
1107: END Get_Type_From_Line;
1108:

Line 1132: OE_STANDARD_WF.Set_Msg_Context(actid);

1128: l_error_msg VARCHAR2(240) DEFAULT NULL;
1129: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1130: BEGIN
1131: -- start data fix project
1132: OE_STANDARD_WF.Set_Msg_Context(actid);
1133: -- end data fix project
1134: IF l_debug_level > 0 THEN
1135: oe_debug_pub.add('Entering OE_FLEX_COGS_PUB.GET_SALESREP_ID',2);
1136: END IF;

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

1236: wf_core.context('OE_FLEX_COGS_PUB','GET_SALESREP_ID',
1237: itemtype,itemkey,TO_CHAR(actid),funcmode);
1238: result := 'COMPLETE:FAILURE';
1239: -- start data fix project
1240: OE_STANDARD_WF.Add_Error_Activity_Msg(p_actid => actid,
1241: p_itemtype => itemtype,
1242: p_itemkey => itemkey);
1243: OE_STANDARD_WF.Save_Messages;
1244: OE_STANDARD_WF.Clear_Msg_Context;

Line 1243: OE_STANDARD_WF.Save_Messages;

1239: -- start data fix project
1240: OE_STANDARD_WF.Add_Error_Activity_Msg(p_actid => actid,
1241: p_itemtype => itemtype,
1242: p_itemkey => itemkey);
1243: OE_STANDARD_WF.Save_Messages;
1244: OE_STANDARD_WF.Clear_Msg_Context;
1245: -- end data fix project
1246: RAISE;
1247: END Get_Salesrep_Id;

Line 1244: OE_STANDARD_WF.Clear_Msg_Context;

1240: OE_STANDARD_WF.Add_Error_Activity_Msg(p_actid => actid,
1241: p_itemtype => itemtype,
1242: p_itemkey => itemkey);
1243: OE_STANDARD_WF.Save_Messages;
1244: OE_STANDARD_WF.Clear_Msg_Context;
1245: -- end data fix project
1246: RAISE;
1247: END Get_Salesrep_Id;
1248:

Line 1272: OE_STANDARD_WF.Set_Msg_Context(actid);

1268:
1269: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1270: BEGIN
1271: -- start data fix project
1272: OE_STANDARD_WF.Set_Msg_Context(actid);
1273: -- end data fix project
1274: IF l_debug_level > 0 THEN
1275: oe_debug_pub.add('Entering OE_FLEX_COGS_PUB.Get_Invitm_Org_Derived',1);
1276: END IF;

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

1345: wf_core.context('OE_FLEX_COGS_PUB','Get_Invitm_Org_Derived',
1346: itemtype,itemkey,TO_CHAR(actid),funcmode);
1347: result := 'COMPLETE:FAILURE';
1348: -- start data fix project
1349: OE_STANDARD_WF.Add_Error_Activity_Msg(p_actid => actid,
1350: p_itemtype => itemtype,
1351: p_itemkey => itemkey);
1352: OE_STANDARD_WF.Save_Messages;
1353: OE_STANDARD_WF.Clear_Msg_Context;

Line 1352: OE_STANDARD_WF.Save_Messages;

1348: -- start data fix project
1349: OE_STANDARD_WF.Add_Error_Activity_Msg(p_actid => actid,
1350: p_itemtype => itemtype,
1351: p_itemkey => itemkey);
1352: OE_STANDARD_WF.Save_Messages;
1353: OE_STANDARD_WF.Clear_Msg_Context;
1354: -- end data fix project
1355: RAISE;
1356:

Line 1353: OE_STANDARD_WF.Clear_Msg_Context;

1349: OE_STANDARD_WF.Add_Error_Activity_Msg(p_actid => actid,
1350: p_itemtype => itemtype,
1351: p_itemkey => itemkey);
1352: OE_STANDARD_WF.Save_Messages;
1353: OE_STANDARD_WF.Clear_Msg_Context;
1354: -- end data fix project
1355: RAISE;
1356:
1357: END Get_Invitm_Org_Derived;

Line 1374: OE_STANDARD_WF.Set_Msg_Context(actid);

1370: fb_error_msg VARCHAR2(240) DEFAULT NULL;
1371: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1372: BEGIN
1373: -- start data fix project
1374: OE_STANDARD_WF.Set_Msg_Context(actid);
1375: -- end data fix project
1376: IF l_debug_level > 0 THEN
1377: oe_debug_pub.add('Entering OE_FLEX_COGS_PUB.Check_Option',1);
1378: END IF;

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

1403: wf_core.context('OE_FLEX_COGS_PUB','Check_Option',
1404: itemtype,itemkey,TO_CHAR(actid),funcmode);
1405: result := 'COMPLETE:FAILURE';
1406: -- start data fix project
1407: OE_STANDARD_WF.Add_Error_Activity_Msg(p_actid => actid,
1408: p_itemtype => itemtype,
1409: p_itemkey => itemkey);
1410: OE_STANDARD_WF.Save_Messages;
1411: OE_STANDARD_WF.Clear_Msg_Context;

Line 1410: OE_STANDARD_WF.Save_Messages;

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

Line 1411: OE_STANDARD_WF.Clear_Msg_Context;

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

Line 1436: OE_STANDARD_WF.Set_Msg_Context(actid);

1432: l_error_msg VARCHAR2(240) DEFAULT NULL;
1433: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1434: BEGIN
1435: -- start data fix project
1436: OE_STANDARD_WF.Set_Msg_Context(actid);
1437: -- end data fix project
1438: IF l_debug_level > 0 THEN
1439: oe_debug_pub.add('Entering OE_FLEX_COGS_PUB.GET_TRX_TYPE',2);
1440: END IF;

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

1488: wf_core.context('OE_FLEX_COGS_PUB','GET_TRX_TYPE',
1489: itemtype,itemkey,TO_CHAR(actid),funcmode);
1490: result := 'COMPLETE:FAILURE';
1491: -- start data fix project
1492: OE_STANDARD_WF.Add_Error_Activity_Msg(p_actid => actid,
1493: p_itemtype => itemtype,
1494: p_itemkey => itemkey);
1495: OE_STANDARD_WF.Save_Messages;
1496: OE_STANDARD_WF.Clear_Msg_Context;

Line 1495: OE_STANDARD_WF.Save_Messages;

1491: -- start data fix project
1492: OE_STANDARD_WF.Add_Error_Activity_Msg(p_actid => actid,
1493: p_itemtype => itemtype,
1494: p_itemkey => itemkey);
1495: OE_STANDARD_WF.Save_Messages;
1496: OE_STANDARD_WF.Clear_Msg_Context;
1497: -- end data fix project
1498: RAISE;
1499: END Get_Trx_Type;

Line 1496: OE_STANDARD_WF.Clear_Msg_Context;

1492: OE_STANDARD_WF.Add_Error_Activity_Msg(p_actid => actid,
1493: p_itemtype => itemtype,
1494: p_itemkey => itemkey);
1495: OE_STANDARD_WF.Save_Messages;
1496: OE_STANDARD_WF.Clear_Msg_Context;
1497: -- end data fix project
1498: RAISE;
1499: END Get_Trx_Type;
1500:

Line 1569: OE_STANDARD_WF.Set_Msg_Context(actid);

1565: l_fb_error_msg VARCHAR2(240) DEFAULT NULL;
1566: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1567: BEGIN
1568: -- start data fix project
1569: OE_STANDARD_WF.Set_Msg_Context(actid);
1570: -- end data fix project
1571: IF l_debug_level > 0 THEN
1572: oe_debug_pub.add('Entering OE_FLEX_COGS_PUB.BUILD',1);
1573: END IF;

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

1633: WHEN OTHERS THEN
1634: wf_core.context('OE_FLEX_COGS_PUB','UPGRADE_COGS_FLEX',
1635: itemtype,itemkey,TO_CHAR(actid),funcmode);
1636: -- start data fix project
1637: OE_STANDARD_WF.Add_Error_Activity_Msg(p_actid => actid,
1638: p_itemtype => itemtype,
1639: p_itemkey => itemkey);
1640: OE_STANDARD_WF.Save_Messages;
1641: OE_STANDARD_WF.Clear_Msg_Context;

Line 1640: OE_STANDARD_WF.Save_Messages;

1636: -- start data fix project
1637: OE_STANDARD_WF.Add_Error_Activity_Msg(p_actid => actid,
1638: p_itemtype => itemtype,
1639: p_itemkey => itemkey);
1640: OE_STANDARD_WF.Save_Messages;
1641: OE_STANDARD_WF.Clear_Msg_Context;
1642: -- end data fix project
1643: RAISE;
1644: END Upgrade_Cogs_Flex;

Line 1641: OE_STANDARD_WF.Clear_Msg_Context;

1637: OE_STANDARD_WF.Add_Error_Activity_Msg(p_actid => actid,
1638: p_itemtype => itemtype,
1639: p_itemkey => itemkey);
1640: OE_STANDARD_WF.Save_Messages;
1641: OE_STANDARD_WF.Clear_Msg_Context;
1642: -- end data fix project
1643: RAISE;
1644: END Upgrade_Cogs_Flex;
1645: