eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OE_FLEX_COGS_PUB dependencies on OE_FLEX_COGS_PUB

Line 1: PACKAGE BODY OE_Flex_Cogs_Pub AS

1: PACKAGE BODY OE_Flex_Cogs_Pub AS
2: /* $Header: OEXWCGSB.pls 120.2.12020000.3 2012/09/10 08:17:44 sujithku ship $ */
3:
4: G_PKG_NAME CONSTANT VARCHAR2(30) := 'OE_Flex_Cogs_PUB';
5:

Line 4: G_PKG_NAME CONSTANT VARCHAR2(30) := 'OE_Flex_Cogs_PUB';

1: PACKAGE BODY OE_Flex_Cogs_Pub AS
2: /* $Header: OEXWCGSB.pls 120.2.12020000.3 2012/09/10 08:17:44 sujithku ship $ */
3:
4: G_PKG_NAME CONSTANT VARCHAR2(30) := 'OE_Flex_Cogs_PUB';
5:
6: TYPE Chart_Of_Accounts_Rec_Type IS RECORD
7: ( ship_from_org_id NUMBER := NULL
8: , chart_of_accounts_id NUMBER := NULL

Line 17: -- API name OE_Flex_Cogs_PUB

13:
14: G_Chart_Of_Accounts_Rec Chart_Of_Accounts_Rec_Type;
15: G_Chart_Of_Accounts_Tbl Chart_Of_Accounts_Tbl_Type;
16: -- Start of Comments
17: -- API name OE_Flex_Cogs_PUB
18: -- Type Public
19: -- Version Current version = 1.0
20: -- Initial version = 1.0
21:

Line 106: oe_debug_pub.add('Entering OE_Flex_Cogs_Pub.Start_process : '|| to_char(p_line_id),1);

102: --oe_debug_pub.initialize;
103: g_stmt:='1';
104:
105: IF l_debug_level > 0 THEN
106: oe_debug_pub.add('Entering OE_Flex_Cogs_Pub.Start_process : '|| to_char(p_line_id),1);
107: END IF;
108:
109: IF NOT FND_API.Compatible_API_Call
110: ( l_api_version_number

Line 430: oe_debug_pub.add('Exiting OE_Flex_Cogs_Pub.Start_process : '|| l_return_status, 1); -- 2352606

426: FND_MESSAGE.SET_TOKEN('ERROR_MESSAGE',l_errmsg);
427: OE_MSG_PUB.ADD;
428: RAISE FND_API.G_EXC_ERROR;
429: END IF;
430: oe_debug_pub.add('Exiting OE_Flex_Cogs_Pub.Start_process : '|| l_return_status, 1); -- 2352606
431: RETURN l_return_status;
432: EXCEPTION
433:
434: WHEN NO_DATA_FOUND THEN

Line 447: oe_debug_pub.add('Exiting OE_Flex_Cogs_Pub.Start_process : NDF', 1); -- 2352606 end

443: , p_msg_index => OE_MSG_PUB.G_LAST
444: );
445: OE_MSG_PUB.Reset;
446: END IF;
447: oe_debug_pub.add('Exiting OE_Flex_Cogs_Pub.Start_process : NDF', 1); -- 2352606 end
448:
449: oe_debug_pub.add(SQLERRM||':'||g_stmt);
450: return FND_API.G_RET_STS_ERROR;
451:

Line 461: oe_debug_pub.add('Exiting OE_Flex_Cogs_Pub.Start_process : E', 1); -- 2352606 end

457: , p_msg_index => OE_MSG_PUB.G_LAST
458: );
459: OE_MSG_PUB.Reset;
460: END IF;
461: oe_debug_pub.add('Exiting OE_Flex_Cogs_Pub.Start_process : E', 1); -- 2352606 end
462:
463: oe_debug_pub.add(SQLERRM||':'||g_stmt);
464: return FND_API.G_RET_STS_ERROR;
465:

Line 478: oe_debug_pub.add('Exiting OE_Flex_Cogs_Pub.Start_process : U', 1); -- 2352606 end

474: , p_msg_index => OE_MSG_PUB.G_LAST
475: );
476: OE_MSG_PUB.Reset;
477: END IF;
478: oe_debug_pub.add('Exiting OE_Flex_Cogs_Pub.Start_process : U', 1); -- 2352606 end
479:
480: oe_debug_pub.add(SQLERRM||':'||g_stmt);
481: return FND_API.G_RET_STS_UNEXP_ERROR ;
482:

Line 505: oe_debug_pub.add('Exiting OE_Flex_Cogs_Pub.Start_process : O', 1); -- 2352606 end

501: );
502: OE_MSG_PUB.Reset;
503: END IF;
504:
505: oe_debug_pub.add('Exiting OE_Flex_Cogs_Pub.Start_process : O', 1); -- 2352606 end
506: oe_debug_pub.add(SQLERRM||':'||g_stmt);
507: return FND_API.G_RET_STS_UNEXP_ERROR;
508:
509: END Start_Process; /* START_PROCESS */

Line 539: oe_debug_pub.add('Entering OE_Flex_Cogs_Pub.GET_COST_SALE_ITEM_DERIVED');

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);
541: oe_debug_pub.add(' Item Key : '||itemkey,2);
542: oe_debug_pub.add(' Activity Id : '||to_char(actid),2);
543: oe_debug_pub.add(' funcmode : '||funcmode,2);

Line 648: oe_debug_pub.add('Exiting from OE_Flex_COGS_Pub.Get_Cost_Sale_Item_Derived',1);

644: oe_debug_pub.add('Organization id :'||to_char(l_organization_id));
645: oe_debug_pub.add('Output : ');
646: oe_debug_pub.add('Generated CCID :'||l_cost_sale_item_derived);
647:
648: oe_debug_pub.add('Exiting from OE_Flex_COGS_Pub.Get_Cost_Sale_Item_Derived',1);
649: END IF;
650: RETURN;
651: ELSIF (funcmode = 'CANCEL') THEN
652: result := wf_engine.eng_completed;

Line 661: wf_core.context('OE_FLEX_COGS_PUB','GET_COST_SALE_ITEM_DERIVED',

657: END IF;
658: EXCEPTION
659:
660: WHEN OTHERS THEN
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,

Line 704: oe_debug_pub.add('Entering OE_Flex_Cogs_Pub.GET_COST_SALE_MODEL_DERIVED');

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:
706: oe_debug_pub.add(' Item Type : '||itemtype,2);
707: oe_debug_pub.add(' Item Key : '||itemkey,2);
708: oe_debug_pub.add(' Activity Id : '||to_char(actid),2);

Line 781: oe_debug_pub.add('Exiting from OE_Flex_COGS_Pub.Get_Model_Derived',1);

777: oe_debug_pub.add('Line id :'||to_char(l_line_id));
778: oe_debug_pub.add('Output : ');
779: oe_debug_pub.add('Generated CCID :'||l_cost_sale_model_derived);
780:
781: oe_debug_pub.add('Exiting from OE_Flex_COGS_Pub.Get_Model_Derived',1);
782: END IF;
783: RETURN;
784: ELSIF (funcmode = 'CANCEL') THEN
785: result := wf_engine.eng_completed;

Line 793: wf_core.context('OE_FLEX_COGS_PUB','GET_MODEL_DERIVED',

789: RETURN;
790: END IF;
791: EXCEPTION
792: WHEN OTHERS THEN
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,

Line 831: oe_debug_pub.add('Entering OE_Flex_Cogs_Pub.GET_ORDER_TYPE_DERIVED');

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);
833: oe_debug_pub.add(' Item Key : '||itemkey,2);
834: oe_debug_pub.add(' Activity Id : '||to_char(actid),2);
835: oe_debug_pub.add(' funcmode : '||funcmode,2);

Line 899: wf_core.context('OE_FLEX_COGS_PUB','GET_ORDER_TYPE_DERIVED',

895: RETURN;
896: END IF;
897: EXCEPTION
898: WHEN OTHERS THEN
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,

Line 937: oe_debug_pub.add('Entering OE_FLEX_COGS_PUB.GET_SALESREP_REV_DERIVED',1);

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;
939: IF (FUNCMODE = 'RUN') THEN
940: l_salesrep_id:= wf_engine.GetItemAttrNumber(itemtype,itemkey,'SALESREP_ID');
941: IF l_debug_level > 0 THEN

Line 1008: wf_core.context('OE_FLEX_COGS_PUB','GET_SALESREP_REV_DERIVED',

1004: RETURN;
1005: END IF;
1006: EXCEPTION
1007: WHEN OTHERS THEN
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,

Line 1096: wf_core.context('OE_FLEX_COGS_PUB','GET_TYPE_FROM_LINE',

1092: RETURN;
1093: END IF;
1094: EXCEPTION
1095: WHEN OTHERS THEN
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,

Line 1135: oe_debug_pub.add('Entering OE_FLEX_COGS_PUB.GET_SALESREP_ID',2);

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;
1137: IF (FUNCMODE = 'RUN') THEN
1138: l_order_line_id:= wf_engine.GetItemAttrNumber(itemtype,itemkey,'LINE_ID');
1139: l_header_id:= wf_engine.GetItemAttrNumber(itemtype,itemkey,'HEADER_ID');

Line 1236: wf_core.context('OE_FLEX_COGS_PUB','GET_SALESREP_ID',

1232: RETURN;
1233: END IF;
1234: EXCEPTION
1235: WHEN OTHERS THEN
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,

Line 1275: oe_debug_pub.add('Entering OE_FLEX_COGS_PUB.Get_Invitm_Org_Derived',1);

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;
1277: IF (FUNCMODE = 'RUN') THEN
1278: l_inv_item_id := wf_engine.GetItemAttrNumber(itemtype,itemkey,'INVENTORY_ITEM_ID');
1279: l_ship_from_org_id:= wf_engine.GetItemAttrNumber(itemtype,itemkey,'ORGANIZATION_ID');

Line 1345: wf_core.context('OE_FLEX_COGS_PUB','Get_Invitm_Org_Derived',

1341: RETURN;
1342: END IF;
1343: EXCEPTION
1344: WHEN OTHERS THEN
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,

Line 1377: oe_debug_pub.add('Entering OE_FLEX_COGS_PUB.Check_Option',1);

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;
1379: IF (FUNCMODE = 'RUN') THEN
1380: l_option_flag := wf_engine.GetItemAttrText(itemtype,itemkey,'OPTION_FLAG');
1381: IF l_debug_level > 0 THEN

Line 1403: wf_core.context('OE_FLEX_COGS_PUB','Check_Option',

1399: RETURN;
1400: END IF;
1401: EXCEPTION
1402: WHEN OTHERS THEN
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,

Line 1439: oe_debug_pub.add('Entering OE_FLEX_COGS_PUB.GET_TRX_TYPE',2);

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;
1441: IF (FUNCMODE = 'RUN') THEN
1442: l_commitment_id:= wf_engine.GetItemAttrNumber(itemtype,itemkey,'COMMITMENT_ID');
1443: IF l_debug_level > 0 THEN

Line 1488: wf_core.context('OE_FLEX_COGS_PUB','GET_TRX_TYPE',

1484: RETURN;
1485: END IF;
1486: EXCEPTION
1487: WHEN OTHERS THEN
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,

Line 1529: oe_debug_pub.add('Entering OE_FLEX_COGS_PUB.BUILD',2);

1525: IS
1526: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1527: BEGIN
1528: IF l_debug_level > 0 THEN
1529: oe_debug_pub.add('Entering OE_FLEX_COGS_PUB.BUILD',2);
1530: END IF;
1531: fb_flex_seg := NULL;
1532:
1533: FND_MESSAGE.SET_NAME('FND', 'FLEXWK-UPGRADE FUNC MISSING');

Line 1572: oe_debug_pub.add('Entering OE_FLEX_COGS_PUB.BUILD',1);

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;
1574: IF (FUNCMODE = 'RUN') THEN
1575:
1576: l_order_line_id:= wf_engine.GetItemAttrNumber(itemtype,itemkey,'LINE_ID');

Line 1597: IF (OE_FLEX_COGS_PUB.Build(

1593: oe_debug_pub.add('Order Type :'||to_char(l_order_type_id),2);
1594: oe_debug_pub.add('Option Flag :'||l_option_flag,2);
1595: oe_debug_pub.add('Structure Number :'|| to_char(l_flex_num),2);
1596: END IF;
1597: IF (OE_FLEX_COGS_PUB.Build(
1598: l_flex_num,
1599: l_commitment_id,
1600: l_customer_id,
1601: l_header_id,

Line 1634: wf_core.context('OE_FLEX_COGS_PUB','UPGRADE_COGS_FLEX',

1630: RETURN;
1631: END IF;
1632: EXCEPTION
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,

Line 1646: END OE_Flex_Cogs_Pub;

1642: -- end data fix project
1643: RAISE;
1644: END Upgrade_Cogs_Flex;
1645:
1646: END OE_Flex_Cogs_Pub;