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 2006/02/20 23:34:20 akyadav noship $ */
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 2006/02/20 23:34:20 akyadav noship $ */
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 104: oe_debug_pub.add('Entering OE_Flex_Cogs_Pub.Start_process : '|| to_char(p_line_id),1);

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

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

412: FND_MESSAGE.SET_TOKEN('ERROR_MESSAGE',l_errmsg);
413: OE_MSG_PUB.ADD;
414: RAISE FND_API.G_EXC_ERROR;
415: END IF;
416: oe_debug_pub.add('Exiting OE_Flex_Cogs_Pub.Start_process : '|| l_return_status, 1); -- 2352606
417: RETURN l_return_status;
418: EXCEPTION
419:
420: WHEN NO_DATA_FOUND THEN

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

429: , p_msg_index => OE_MSG_PUB.G_LAST
430: );
431: OE_MSG_PUB.Reset;
432: END IF;
433: oe_debug_pub.add('Exiting OE_Flex_Cogs_Pub.Start_process : NDF', 1); -- 2352606 end
434:
435: oe_debug_pub.add(SQLERRM||':'||g_stmt);
436: return FND_API.G_RET_STS_ERROR;
437:

Line 447: oe_debug_pub.add('Exiting OE_Flex_Cogs_Pub.Start_process : E', 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 : E', 1); -- 2352606 end
448:
449: oe_debug_pub.add(SQLERRM||':'||g_stmt);
450: return FND_API.G_RET_STS_ERROR;
451:

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

460: , p_msg_index => OE_MSG_PUB.G_LAST
461: );
462: OE_MSG_PUB.Reset;
463: END IF;
464: oe_debug_pub.add('Exiting OE_Flex_Cogs_Pub.Start_process : U', 1); -- 2352606 end
465:
466: oe_debug_pub.add(SQLERRM||':'||g_stmt);
467: return FND_API.G_RET_STS_UNEXP_ERROR ;
468:

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

487: );
488: OE_MSG_PUB.Reset;
489: END IF;
490:
491: oe_debug_pub.add('Exiting OE_Flex_Cogs_Pub.Start_process : O', 1); -- 2352606 end
492: oe_debug_pub.add(SQLERRM||':'||g_stmt);
493: return FND_API.G_RET_STS_UNEXP_ERROR;
494:
495: END Start_Process; /* START_PROCESS */

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

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

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

630: oe_debug_pub.add('Organization id :'||to_char(l_organization_id));
631: oe_debug_pub.add('Output : ');
632: oe_debug_pub.add('Generated CCID :'||l_cost_sale_item_derived);
633:
634: oe_debug_pub.add('Exiting from OE_Flex_COGS_Pub.Get_Cost_Sale_Item_Derived',1);
635: END IF;
636: RETURN;
637: ELSIF (funcmode = 'CANCEL') THEN
638: result := wf_engine.eng_completed;

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

643: END IF;
644: EXCEPTION
645:
646: WHEN OTHERS THEN
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,

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

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

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

763: oe_debug_pub.add('Line id :'||to_char(l_line_id));
764: oe_debug_pub.add('Output : ');
765: oe_debug_pub.add('Generated CCID :'||l_cost_sale_model_derived);
766:
767: oe_debug_pub.add('Exiting from OE_Flex_COGS_Pub.Get_Model_Derived',1);
768: END IF;
769: RETURN;
770: ELSIF (funcmode = 'CANCEL') THEN
771: result := wf_engine.eng_completed;

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

775: RETURN;
776: END IF;
777: EXCEPTION
778: WHEN OTHERS THEN
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,

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

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

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

881: RETURN;
882: END IF;
883: EXCEPTION
884: WHEN OTHERS THEN
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,

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

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

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

990: RETURN;
991: END IF;
992: EXCEPTION
993: WHEN OTHERS THEN
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,

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

1078: RETURN;
1079: END IF;
1080: EXCEPTION
1081: WHEN OTHERS THEN
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,

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

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

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

1218: RETURN;
1219: END IF;
1220: EXCEPTION
1221: WHEN OTHERS THEN
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,

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

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

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

1327: RETURN;
1328: END IF;
1329: EXCEPTION
1330: WHEN OTHERS THEN
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,

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

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

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

1385: RETURN;
1386: END IF;
1387: EXCEPTION
1388: WHEN OTHERS THEN
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,

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

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

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

1470: RETURN;
1471: END IF;
1472: EXCEPTION
1473: WHEN OTHERS THEN
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,

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

1511: IS
1512: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1513: BEGIN
1514: IF l_debug_level > 0 THEN
1515: oe_debug_pub.add('Entering OE_FLEX_COGS_PUB.BUILD',2);
1516: END IF;
1517: fb_flex_seg := NULL;
1518:
1519: FND_MESSAGE.SET_NAME('FND', 'FLEXWK-UPGRADE FUNC MISSING');

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

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

Line 1583: IF (OE_FLEX_COGS_PUB.Build(

1579: oe_debug_pub.add('Order Type :'||to_char(l_order_type_id),2);
1580: oe_debug_pub.add('Option Flag :'||l_option_flag,2);
1581: oe_debug_pub.add('Structure Number :'|| to_char(l_flex_num),2);
1582: END IF;
1583: IF (OE_FLEX_COGS_PUB.Build(
1584: l_flex_num,
1585: l_commitment_id,
1586: l_customer_id,
1587: l_header_id,

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

1616: RETURN;
1617: END IF;
1618: EXCEPTION
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,

Line 1632: END OE_Flex_Cogs_Pub;

1628: -- end data fix project
1629: RAISE;
1630: END Upgrade_Cogs_Flex;
1631:
1632: END OE_Flex_Cogs_Pub;