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);
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;
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;
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:
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:
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;
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;
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:
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);
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;
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;
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:
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;
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;
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;
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:
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;
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;
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;
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:
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;
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;
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;
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:
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;
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;
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:
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;
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;
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;
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;
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:
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;
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;
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;
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:
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;
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;
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;
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: