DBA Data[Home] [Help]

APPS.OE_FLEX_COGS_PUB dependencies on OE_STANDARD_WF

Line 522: OE_STANDARD_WF.Set_Msg_Context(actid);

518:
519: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
520: BEGIN
521: -- start data fix project
522: OE_STANDARD_WF.Set_Msg_Context(actid);
523: -- end data fix project
524: IF l_debug_level > 0 THEN
525: oe_debug_pub.add('Entering OE_Flex_Cogs_Pub.GET_COST_SALE_ITEM_DERIVED');
526: oe_debug_pub.add(' Item Type : '||itemtype,2);

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

647: wf_core.context('OE_FLEX_COGS_PUB','GET_COST_SALE_ITEM_DERIVED',
648: itemtype,itemkey,TO_CHAR(actid),funcmode);
649: result := 'COMPLETE:FAILURE';
650: -- start data fix project
651: OE_STANDARD_WF.Add_Error_Activity_Msg(p_actid => actid,
652: p_itemtype => itemtype,
653: p_itemkey => itemkey);
654: OE_STANDARD_WF.Save_Messages;
655: OE_STANDARD_WF.Clear_Msg_Context;

Line 654: OE_STANDARD_WF.Save_Messages;

650: -- start data fix project
651: OE_STANDARD_WF.Add_Error_Activity_Msg(p_actid => actid,
652: p_itemtype => itemtype,
653: p_itemkey => itemkey);
654: OE_STANDARD_WF.Save_Messages;
655: OE_STANDARD_WF.Clear_Msg_Context;
656: -- end data fix project
657: RAISE;
658: END GET_COST_SALE_ITEM_DERIVED;

Line 655: OE_STANDARD_WF.Clear_Msg_Context;

651: OE_STANDARD_WF.Add_Error_Activity_Msg(p_actid => actid,
652: p_itemtype => itemtype,
653: p_itemkey => itemkey);
654: OE_STANDARD_WF.Save_Messages;
655: OE_STANDARD_WF.Clear_Msg_Context;
656: -- end data fix project
657: RAISE;
658: END GET_COST_SALE_ITEM_DERIVED;
659:

Line 687: OE_STANDARD_WF.Set_Msg_Context(actid);

683:
684: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
685: BEGIN
686: -- start data fix project
687: OE_STANDARD_WF.Set_Msg_Context(actid);
688: -- end data fix project
689: IF l_debug_level > 0 THEN
690: oe_debug_pub.add('Entering OE_Flex_Cogs_Pub.GET_COST_SALE_MODEL_DERIVED');
691:

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

779: wf_core.context('OE_FLEX_COGS_PUB','GET_MODEL_DERIVED',
780: itemtype,itemkey,TO_CHAR(actid),funcmode);
781: result := 'COMPLETE:FAILURE';
782: -- start data fix project
783: OE_STANDARD_WF.Add_Error_Activity_Msg(p_actid => actid,
784: p_itemtype => itemtype,
785: p_itemkey => itemkey);
786: OE_STANDARD_WF.Save_Messages;
787: OE_STANDARD_WF.Clear_Msg_Context;

Line 786: OE_STANDARD_WF.Save_Messages;

782: -- start data fix project
783: OE_STANDARD_WF.Add_Error_Activity_Msg(p_actid => actid,
784: p_itemtype => itemtype,
785: p_itemkey => itemkey);
786: OE_STANDARD_WF.Save_Messages;
787: OE_STANDARD_WF.Clear_Msg_Context;
788: -- end data fix project
789: RAISE;
790: END Get_Model_Derived;

Line 787: OE_STANDARD_WF.Clear_Msg_Context;

783: OE_STANDARD_WF.Add_Error_Activity_Msg(p_actid => actid,
784: p_itemtype => itemtype,
785: p_itemkey => itemkey);
786: OE_STANDARD_WF.Save_Messages;
787: OE_STANDARD_WF.Clear_Msg_Context;
788: -- end data fix project
789: RAISE;
790: END Get_Model_Derived;
791:

Line 814: OE_STANDARD_WF.Set_Msg_Context(actid);

810:
811: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
812: BEGIN
813: -- start data fix project
814: OE_STANDARD_WF.Set_Msg_Context(actid);
815: -- end data fix project
816: IF l_debug_level > 0 THEN
817: oe_debug_pub.add('Entering OE_Flex_Cogs_Pub.GET_ORDER_TYPE_DERIVED');
818: oe_debug_pub.add(' Item Type : '||itemtype,2);

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

885: wf_core.context('OE_FLEX_COGS_PUB','GET_ORDER_TYPE_DERIVED',
886: itemtype,itemkey,TO_CHAR(actid),funcmode);
887: result := 'COMPLETE:FAILURE';
888: -- start data fix project
889: OE_STANDARD_WF.Add_Error_Activity_Msg(p_actid => actid,
890: p_itemtype => itemtype,
891: p_itemkey => itemkey);
892: OE_STANDARD_WF.Save_Messages;
893: OE_STANDARD_WF.Clear_Msg_Context;

Line 892: OE_STANDARD_WF.Save_Messages;

888: -- start data fix project
889: OE_STANDARD_WF.Add_Error_Activity_Msg(p_actid => actid,
890: p_itemtype => itemtype,
891: p_itemkey => itemkey);
892: OE_STANDARD_WF.Save_Messages;
893: OE_STANDARD_WF.Clear_Msg_Context;
894: -- end data fix project
895: RAISE;
896: END Get_Order_Type_Derived;

Line 893: OE_STANDARD_WF.Clear_Msg_Context;

889: OE_STANDARD_WF.Add_Error_Activity_Msg(p_actid => actid,
890: p_itemtype => itemtype,
891: p_itemkey => itemkey);
892: OE_STANDARD_WF.Save_Messages;
893: OE_STANDARD_WF.Clear_Msg_Context;
894: -- end data fix project
895: RAISE;
896: END Get_Order_Type_Derived;
897:

Line 920: OE_STANDARD_WF.Set_Msg_Context(actid);

916: l_error_msg VARCHAR2(240) DEFAULT NULL;
917: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
918: BEGIN
919: -- start data fix project
920: OE_STANDARD_WF.Set_Msg_Context(actid);
921: -- end data fix project
922: IF l_debug_level > 0 THEN
923: oe_debug_pub.add('Entering OE_FLEX_COGS_PUB.GET_SALESREP_REV_DERIVED',1);
924: END IF;

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

994: wf_core.context('OE_FLEX_COGS_PUB','GET_SALESREP_REV_DERIVED',
995: itemtype,itemkey,TO_CHAR(actid),funcmode);
996: result := 'COMPLETE:FAILURE';
997: -- start data fix project
998: OE_STANDARD_WF.Add_Error_Activity_Msg(p_actid => actid,
999: p_itemtype => itemtype,
1000: p_itemkey => itemkey);
1001: OE_STANDARD_WF.Save_Messages;
1002: OE_STANDARD_WF.Clear_Msg_Context;

Line 1001: OE_STANDARD_WF.Save_Messages;

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

Line 1002: OE_STANDARD_WF.Clear_Msg_Context;

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

Line 1028: OE_STANDARD_WF.Set_Msg_Context(actid);

1024: l_order_type_id NUMBER; --a.k.a transaction_type_id, line_type_id
1025: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1026: BEGIN
1027: -- start data fix project
1028: OE_STANDARD_WF.Set_Msg_Context(actid);
1029: -- end data fix project
1030: IF l_debug_level > 0 THEN
1031: oe_debug_pub.add('Entering Get_type_from_line',2);
1032: END IF;

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

1082: wf_core.context('OE_FLEX_COGS_PUB','GET_TYPE_FROM_LINE',
1083: itemtype,itemkey,TO_CHAR(actid),funcmode);
1084: result := 'COMPLETE:FAILURE';
1085: -- start data fix project
1086: OE_STANDARD_WF.Add_Error_Activity_Msg(p_actid => actid,
1087: p_itemtype => itemtype,
1088: p_itemkey => itemkey);
1089: OE_STANDARD_WF.Save_Messages;
1090: OE_STANDARD_WF.Clear_Msg_Context;

Line 1089: OE_STANDARD_WF.Save_Messages;

1085: -- start data fix project
1086: OE_STANDARD_WF.Add_Error_Activity_Msg(p_actid => actid,
1087: p_itemtype => itemtype,
1088: p_itemkey => itemkey);
1089: OE_STANDARD_WF.Save_Messages;
1090: OE_STANDARD_WF.Clear_Msg_Context;
1091: -- end data fix project
1092: RAISE;
1093: END Get_Type_From_Line;

Line 1090: OE_STANDARD_WF.Clear_Msg_Context;

1086: OE_STANDARD_WF.Add_Error_Activity_Msg(p_actid => actid,
1087: p_itemtype => itemtype,
1088: p_itemkey => itemkey);
1089: OE_STANDARD_WF.Save_Messages;
1090: OE_STANDARD_WF.Clear_Msg_Context;
1091: -- end data fix project
1092: RAISE;
1093: END Get_Type_From_Line;
1094:

Line 1118: OE_STANDARD_WF.Set_Msg_Context(actid);

1114: l_error_msg VARCHAR2(240) DEFAULT NULL;
1115: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1116: BEGIN
1117: -- start data fix project
1118: OE_STANDARD_WF.Set_Msg_Context(actid);
1119: -- end data fix project
1120: IF l_debug_level > 0 THEN
1121: oe_debug_pub.add('Entering OE_FLEX_COGS_PUB.GET_SALESREP_ID',2);
1122: END IF;

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

1222: wf_core.context('OE_FLEX_COGS_PUB','GET_SALESREP_ID',
1223: itemtype,itemkey,TO_CHAR(actid),funcmode);
1224: result := 'COMPLETE:FAILURE';
1225: -- start data fix project
1226: OE_STANDARD_WF.Add_Error_Activity_Msg(p_actid => actid,
1227: p_itemtype => itemtype,
1228: p_itemkey => itemkey);
1229: OE_STANDARD_WF.Save_Messages;
1230: OE_STANDARD_WF.Clear_Msg_Context;

Line 1229: OE_STANDARD_WF.Save_Messages;

1225: -- start data fix project
1226: OE_STANDARD_WF.Add_Error_Activity_Msg(p_actid => actid,
1227: p_itemtype => itemtype,
1228: p_itemkey => itemkey);
1229: OE_STANDARD_WF.Save_Messages;
1230: OE_STANDARD_WF.Clear_Msg_Context;
1231: -- end data fix project
1232: RAISE;
1233: END Get_Salesrep_Id;

Line 1230: OE_STANDARD_WF.Clear_Msg_Context;

1226: OE_STANDARD_WF.Add_Error_Activity_Msg(p_actid => actid,
1227: p_itemtype => itemtype,
1228: p_itemkey => itemkey);
1229: OE_STANDARD_WF.Save_Messages;
1230: OE_STANDARD_WF.Clear_Msg_Context;
1231: -- end data fix project
1232: RAISE;
1233: END Get_Salesrep_Id;
1234:

Line 1258: OE_STANDARD_WF.Set_Msg_Context(actid);

1254:
1255: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1256: BEGIN
1257: -- start data fix project
1258: OE_STANDARD_WF.Set_Msg_Context(actid);
1259: -- end data fix project
1260: IF l_debug_level > 0 THEN
1261: oe_debug_pub.add('Entering OE_FLEX_COGS_PUB.Get_Invitm_Org_Derived',1);
1262: END IF;

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

1331: wf_core.context('OE_FLEX_COGS_PUB','Get_Invitm_Org_Derived',
1332: itemtype,itemkey,TO_CHAR(actid),funcmode);
1333: result := 'COMPLETE:FAILURE';
1334: -- start data fix project
1335: OE_STANDARD_WF.Add_Error_Activity_Msg(p_actid => actid,
1336: p_itemtype => itemtype,
1337: p_itemkey => itemkey);
1338: OE_STANDARD_WF.Save_Messages;
1339: OE_STANDARD_WF.Clear_Msg_Context;

Line 1338: OE_STANDARD_WF.Save_Messages;

1334: -- start data fix project
1335: OE_STANDARD_WF.Add_Error_Activity_Msg(p_actid => actid,
1336: p_itemtype => itemtype,
1337: p_itemkey => itemkey);
1338: OE_STANDARD_WF.Save_Messages;
1339: OE_STANDARD_WF.Clear_Msg_Context;
1340: -- end data fix project
1341: RAISE;
1342:

Line 1339: OE_STANDARD_WF.Clear_Msg_Context;

1335: OE_STANDARD_WF.Add_Error_Activity_Msg(p_actid => actid,
1336: p_itemtype => itemtype,
1337: p_itemkey => itemkey);
1338: OE_STANDARD_WF.Save_Messages;
1339: OE_STANDARD_WF.Clear_Msg_Context;
1340: -- end data fix project
1341: RAISE;
1342:
1343: END Get_Invitm_Org_Derived;

Line 1360: OE_STANDARD_WF.Set_Msg_Context(actid);

1356: fb_error_msg VARCHAR2(240) DEFAULT NULL;
1357: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1358: BEGIN
1359: -- start data fix project
1360: OE_STANDARD_WF.Set_Msg_Context(actid);
1361: -- end data fix project
1362: IF l_debug_level > 0 THEN
1363: oe_debug_pub.add('Entering OE_FLEX_COGS_PUB.Check_Option',1);
1364: END IF;

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

1389: wf_core.context('OE_FLEX_COGS_PUB','Check_Option',
1390: itemtype,itemkey,TO_CHAR(actid),funcmode);
1391: result := 'COMPLETE:FAILURE';
1392: -- start data fix project
1393: OE_STANDARD_WF.Add_Error_Activity_Msg(p_actid => actid,
1394: p_itemtype => itemtype,
1395: p_itemkey => itemkey);
1396: OE_STANDARD_WF.Save_Messages;
1397: OE_STANDARD_WF.Clear_Msg_Context;

Line 1396: OE_STANDARD_WF.Save_Messages;

1392: -- start data fix project
1393: OE_STANDARD_WF.Add_Error_Activity_Msg(p_actid => actid,
1394: p_itemtype => itemtype,
1395: p_itemkey => itemkey);
1396: OE_STANDARD_WF.Save_Messages;
1397: OE_STANDARD_WF.Clear_Msg_Context;
1398: -- end data fix project
1399: RAISE;
1400: END Check_Option;

Line 1397: OE_STANDARD_WF.Clear_Msg_Context;

1393: OE_STANDARD_WF.Add_Error_Activity_Msg(p_actid => actid,
1394: p_itemtype => itemtype,
1395: p_itemkey => itemkey);
1396: OE_STANDARD_WF.Save_Messages;
1397: OE_STANDARD_WF.Clear_Msg_Context;
1398: -- end data fix project
1399: RAISE;
1400: END Check_Option;
1401:

Line 1422: OE_STANDARD_WF.Set_Msg_Context(actid);

1418: l_error_msg VARCHAR2(240) DEFAULT NULL;
1419: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1420: BEGIN
1421: -- start data fix project
1422: OE_STANDARD_WF.Set_Msg_Context(actid);
1423: -- end data fix project
1424: IF l_debug_level > 0 THEN
1425: oe_debug_pub.add('Entering OE_FLEX_COGS_PUB.GET_TRX_TYPE',2);
1426: END IF;

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

1474: wf_core.context('OE_FLEX_COGS_PUB','GET_TRX_TYPE',
1475: itemtype,itemkey,TO_CHAR(actid),funcmode);
1476: result := 'COMPLETE:FAILURE';
1477: -- start data fix project
1478: OE_STANDARD_WF.Add_Error_Activity_Msg(p_actid => actid,
1479: p_itemtype => itemtype,
1480: p_itemkey => itemkey);
1481: OE_STANDARD_WF.Save_Messages;
1482: OE_STANDARD_WF.Clear_Msg_Context;

Line 1481: OE_STANDARD_WF.Save_Messages;

1477: -- start data fix project
1478: OE_STANDARD_WF.Add_Error_Activity_Msg(p_actid => actid,
1479: p_itemtype => itemtype,
1480: p_itemkey => itemkey);
1481: OE_STANDARD_WF.Save_Messages;
1482: OE_STANDARD_WF.Clear_Msg_Context;
1483: -- end data fix project
1484: RAISE;
1485: END Get_Trx_Type;

Line 1482: OE_STANDARD_WF.Clear_Msg_Context;

1478: OE_STANDARD_WF.Add_Error_Activity_Msg(p_actid => actid,
1479: p_itemtype => itemtype,
1480: p_itemkey => itemkey);
1481: OE_STANDARD_WF.Save_Messages;
1482: OE_STANDARD_WF.Clear_Msg_Context;
1483: -- end data fix project
1484: RAISE;
1485: END Get_Trx_Type;
1486:

Line 1555: OE_STANDARD_WF.Set_Msg_Context(actid);

1551: l_fb_error_msg VARCHAR2(240) DEFAULT NULL;
1552: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1553: BEGIN
1554: -- start data fix project
1555: OE_STANDARD_WF.Set_Msg_Context(actid);
1556: -- end data fix project
1557: IF l_debug_level > 0 THEN
1558: oe_debug_pub.add('Entering OE_FLEX_COGS_PUB.BUILD',1);
1559: END IF;

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

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

Line 1626: OE_STANDARD_WF.Save_Messages;

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

Line 1627: OE_STANDARD_WF.Clear_Msg_Context;

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