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 WF_ENGINE

Line 80: l_aname wf_engine.nametabtyp;

76: lx_msg_data VARCHAR2(1000);
77: g_stmt VARCHAR2(500);
78:
79: --3406720
80: l_aname wf_engine.nametabtyp;
81: l_avalue wf_engine.numtabtyp;
82: l_aname2 wf_engine.nametabtyp;
83: l_avaluetext wf_engine.texttabtyp;
84: l_chart_of_accounts_rec Chart_Of_Accounts_Rec_Type;

Line 81: l_avalue wf_engine.numtabtyp;

77: g_stmt VARCHAR2(500);
78:
79: --3406720
80: l_aname wf_engine.nametabtyp;
81: l_avalue wf_engine.numtabtyp;
82: l_aname2 wf_engine.nametabtyp;
83: l_avaluetext wf_engine.texttabtyp;
84: l_chart_of_accounts_rec Chart_Of_Accounts_Rec_Type;
85: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

Line 82: l_aname2 wf_engine.nametabtyp;

78:
79: --3406720
80: l_aname wf_engine.nametabtyp;
81: l_avalue wf_engine.numtabtyp;
82: l_aname2 wf_engine.nametabtyp;
83: l_avaluetext wf_engine.texttabtyp;
84: l_chart_of_accounts_rec Chart_Of_Accounts_Rec_Type;
85: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
86: --Exception Management begin

Line 83: l_avaluetext wf_engine.texttabtyp;

79: --3406720
80: l_aname wf_engine.nametabtyp;
81: l_avalue wf_engine.numtabtyp;
82: l_aname2 wf_engine.nametabtyp;
83: l_avaluetext wf_engine.texttabtyp;
84: l_chart_of_accounts_rec Chart_Of_Accounts_Rec_Type;
85: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
86: --Exception Management begin
87: l_order_source_id NUMBER;

Line 349: wf_engine.SetItemAttrNumberArray(l_itemtype

345:
346: l_aname(10) := 'INVENTORY_ITEM_ID';
347: l_avalue(10):=l_inventory_item_id;
348:
349: wf_engine.SetItemAttrNumberArray(l_itemtype
350: , l_itemkey
351: , l_aname
352: , l_avalue
353: );

Line 369: wf_engine.SetItemAttrTextArray(itemtype => l_itemtype,

365: l_aname2(2) := 'OPTION_FLAG';
366: l_avaluetext(2):= l_option_flag;
367: g_stmt:='70';
368:
369: wf_engine.SetItemAttrTextArray(itemtype => l_itemtype,
370: itemkey => l_itemkey,
371: aname => l_aname2,
372: avalue => l_avaluetext);
373: IF l_debug_level > 0 THEN

Line 546: l_line_id := wf_engine.GetItemAttrNumber(itemtype,itemkey,'LINE_ID');

542: oe_debug_pub.add(' Activity Id : '||to_char(actid),2);
543: oe_debug_pub.add(' funcmode : '||funcmode,2);
544: END IF;
545: IF (FUNCMODE = 'RUN') THEN
546: l_line_id := wf_engine.GetItemAttrNumber(itemtype,itemkey,'LINE_ID');
547: l_organization_id := wf_engine.GetItemAttrNumber(itemtype,itemkey,'ORGANIZATION_ID');
548: l_inventory_item_id := wf_engine.GetItemAttrNumber(itemtype,itemkey,'INVENTORY_ITEM_ID');
549:
550: SELECT LINK_TO_LINE_ID,

Line 547: l_organization_id := wf_engine.GetItemAttrNumber(itemtype,itemkey,'ORGANIZATION_ID');

543: oe_debug_pub.add(' funcmode : '||funcmode,2);
544: END IF;
545: IF (FUNCMODE = 'RUN') THEN
546: l_line_id := wf_engine.GetItemAttrNumber(itemtype,itemkey,'LINE_ID');
547: l_organization_id := wf_engine.GetItemAttrNumber(itemtype,itemkey,'ORGANIZATION_ID');
548: l_inventory_item_id := wf_engine.GetItemAttrNumber(itemtype,itemkey,'INVENTORY_ITEM_ID');
549:
550: SELECT LINK_TO_LINE_ID,
551: ITEM_TYPE_CODE

Line 548: l_inventory_item_id := wf_engine.GetItemAttrNumber(itemtype,itemkey,'INVENTORY_ITEM_ID');

544: END IF;
545: IF (FUNCMODE = 'RUN') THEN
546: l_line_id := wf_engine.GetItemAttrNumber(itemtype,itemkey,'LINE_ID');
547: l_organization_id := wf_engine.GetItemAttrNumber(itemtype,itemkey,'ORGANIZATION_ID');
548: l_inventory_item_id := wf_engine.GetItemAttrNumber(itemtype,itemkey,'INVENTORY_ITEM_ID');
549:
550: SELECT LINK_TO_LINE_ID,
551: ITEM_TYPE_CODE
552: INTO l_link_to_line_id,

Line 581: wf_engine.setItemAttrText(itemtype,itemkey,'ERROR_MESSAGE',l_error_msg);

577: FND_MESSAGE.SET_TOKEN('VALUE2',l_organization_id);
578: FB_ERROR_MSG := FND_MESSAGE.GET_ENCODED;
579: FND_MESSAGE.SET_ENCODED(fb_error_msg);
580: l_error_msg := FND_MESSAGE.GET;
581: wf_engine.setItemAttrText(itemtype,itemkey,'ERROR_MESSAGE',l_error_msg);
582: result := 'COMPLETE:FAILURE';
583: RETURN;
584: END IF;
585: END;

Line 613: wf_engine.setItemAttrText(itemtype,itemkey,'ERROR_MESSAGE',l_error_msg);

609: FND_MESSAGE.SET_TOKEN('VALUE2',l_organization_id);
610: FB_ERROR_MSG := FND_MESSAGE.GET_ENCODED;
611: FND_MESSAGE.SET_ENCODED(fb_error_msg);
612: l_error_msg := FND_MESSAGE.GET;
613: wf_engine.setItemAttrText(itemtype,itemkey,'ERROR_MESSAGE',l_error_msg);
614: result := 'COMPLETE:FAILURE';
615: RETURN;
616: END;
617:

Line 633: wf_engine.setItemAttrText(itemtype,itemkey,'ERROR_MESSAGE',l_error_msg);

629: fb_error_msg := FND_MESSAGE.GET_ENCODED;
630: FND_MESSAGE.SET_ENCODED(fb_error_msg);
631: l_error_msg := FND_MESSAGE.GET;
632:
633: wf_engine.setItemAttrText(itemtype,itemkey,'ERROR_MESSAGE',l_error_msg);
634: result := 'COMPLETE:FAILURE';
635: RETURN;
636:
637: END IF;

Line 639: wf_engine.setItemAttrNumber(itemtype,itemkey,'GENERATED_CCID',TO_NUMBER(l_cost_sale_item_derived));

635: RETURN;
636:
637: END IF;
638:
639: wf_engine.setItemAttrNumber(itemtype,itemkey,'GENERATED_CCID',TO_NUMBER(l_cost_sale_item_derived));
640: result := 'COMPLETE:SUCCESS';
641: IF l_debug_level > 0 THEN
642: oe_debug_pub.add('Input Paramerers : ');
643: oe_debug_pub.add('Line id :'||to_char(l_line_id));

Line 652: result := wf_engine.eng_completed;

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;
653: RETURN;
654: ELSE
655: result := '';
656: RETURN;

Line 712: l_line_id := wf_engine.GetItemAttrNumber(itemtype,itemkey,'LINE_ID');

708: oe_debug_pub.add(' Activity Id : '||to_char(actid),2);
709: oe_debug_pub.add(' funcmode : '||funcmode,2);
710: END IF;
711: IF (FUNCMODE = 'RUN') THEN
712: l_line_id := wf_engine.GetItemAttrNumber(itemtype,itemkey,'LINE_ID');
713:
714: SELECT TOP_MODEL_LINE_ID,
715: INVENTORY_ITEM_ID,
716: SHIP_FROM_ORG_ID

Line 749: wf_engine.setItemAttrText(itemtype,itemkey,'ERROR_MESSAGE',l_error_msg);

745: FND_MESSAGE.SET_TOKEN('VALUE2',l_organization_id);
746: fb_error_msg := FND_MESSAGE.GET_ENCODED;
747: FND_MESSAGE.SET_ENCODED(fb_error_msg);
748: l_error_msg := FND_MESSAGE.GET;
749: wf_engine.setItemAttrText(itemtype,itemkey,'ERROR_MESSAGE',l_error_msg);
750: result := 'COMPLETE:FAILURE';
751: RETURN;
752: END;
753: END IF;

Line 767: wf_engine.setItemAttrText(itemtype,itemkey,'ERROR_MESSAGE',l_error_msg);

763: fb_error_msg := FND_MESSAGE.GET_ENCODED;
764: FND_MESSAGE.SET_ENCODED(fb_error_msg);
765: l_error_msg := FND_MESSAGE.GET;
766:
767: wf_engine.setItemAttrText(itemtype,itemkey,'ERROR_MESSAGE',l_error_msg);
768: result := 'COMPLETE:FAILURE';
769: RETURN;
770:
771: END IF;

Line 773: wf_engine.setItemAttrNumber(itemtype,itemkey,'GENERATED_CCID',TO_NUMBER(l_cost_sale_model_derived));

769: RETURN;
770:
771: END IF;
772:
773: wf_engine.setItemAttrNumber(itemtype,itemkey,'GENERATED_CCID',TO_NUMBER(l_cost_sale_model_derived));
774: result := 'COMPLETE:SUCCESS';
775: IF l_debug_level > 0 THEN
776: oe_debug_pub.add('Input Paramerers : ');
777: oe_debug_pub.add('Line id :'||to_char(l_line_id));

Line 785: result := wf_engine.eng_completed;

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;
786: RETURN;
787: ELSE
788: result := '';
789: RETURN;

Line 839: l_order_type_id := wf_engine.GetItemAttrNumber(itemtype,itemkey,'ORDER_TYPE_ID');

835: oe_debug_pub.add(' funcmode : '||funcmode,2);
836: END IF;
837:
838: IF (funcmode = 'RUN') THEN
839: l_order_type_id := wf_engine.GetItemAttrNumber(itemtype,itemkey,'ORDER_TYPE_ID');
840: l_order_type_ccid := NULL;
841: IF (l_order_type_id IS NOT NULL) THEN
842: BEGIN
843: SELECT NVL(COST_OF_GOODS_SOLD_ACCOUNT, 0)

Line 857: wf_engine.setItemAttrText(itemtype,itemkey,'ERROR_MESSAGE',l_error_msg);

853: FND_MESSAGE.SET_TOKEN('VALUE2','');
854: fb_error_msg := FND_MESSAGE.GET_ENCODED;
855: FND_MESSAGE.SET_ENCODED(fb_error_msg);
856: l_error_msg := FND_MESSAGE.GET;
857: wf_engine.setItemAttrText(itemtype,itemkey,'ERROR_MESSAGE',l_error_msg);
858: result := 'COMPLETE:FAILURE';
859: RETURN;
860: END;
861: END IF;

Line 875: wf_engine.setItemAttrText(itemtype,itemkey,'ERROR_MESSAGE',l_error_msg);

871: fb_error_msg := FND_MESSAGE.GET_ENCODED;
872: FND_MESSAGE.SET_ENCODED(fb_error_msg);
873: l_error_msg := FND_MESSAGE.GET;
874:
875: wf_engine.setItemAttrText(itemtype,itemkey,'ERROR_MESSAGE',l_error_msg);
876: result := 'COMPLETE:FAILURE';
877: RETURN;
878:
879: END IF;

Line 881: wf_engine.setItemAttrNumber(itemtype,itemkey,'GENERATED_CCID',TO_NUMBER(L_ORDER_TYPE_CCID));

877: RETURN;
878:
879: END IF;
880:
881: wf_engine.setItemAttrNumber(itemtype,itemkey,'GENERATED_CCID',TO_NUMBER(L_ORDER_TYPE_CCID));
882: result := 'COMPLETE:SUCCESS';
883: IF l_debug_level > 0 THEN
884: oe_debug_pub.add('Input Paramerers : ',2);
885: oe_debug_pub.add('Order Type ID :'||to_char(l_order_type_id),2);

Line 891: result := wf_engine.eng_completed;

887: oe_debug_pub.add('Generated CCID :'||l_order_type_ccid,2);
888: END IF;
889: RETURN;
890: ELSIF (funcmode = 'CANCEL') THEN
891: result := wf_engine.eng_completed;
892: RETURN;
893: ELSE
894: result := '';
895: RETURN;

Line 940: l_salesrep_id:= wf_engine.GetItemAttrNumber(itemtype,itemkey,'SALESREP_ID');

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
942: oe_debug_pub.add('Sales rep id : '||to_char(l_salesrep_id),2);
943: END If;
944: l_salesrep_rev_derived := NULL;

Line 966: wf_engine.setItemAttrText(itemtype,itemkey,'ERROR_MESSAGE',l_error_msg);

962: FND_MESSAGE.SET_TOKEN('VALUE2','');
963: fb_error_msg := FND_MESSAGE.GET_ENCODED;
964: FND_MESSAGE.SET_ENCODED(fb_error_msg);
965: l_error_msg := FND_MESSAGE.GET;
966: wf_engine.setItemAttrText(itemtype,itemkey,'ERROR_MESSAGE',l_error_msg);
967: result := 'COMPLETE:FAILURE';
968: RETURN;
969: END;
970: END IF;

Line 984: wf_engine.setItemAttrText(itemtype,itemkey,'ERROR_MESSAGE',l_error_msg);

980: fb_error_msg := FND_MESSAGE.GET_ENCODED;
981: FND_MESSAGE.SET_ENCODED(fb_error_msg);
982: l_error_msg := FND_MESSAGE.GET;
983:
984: wf_engine.setItemAttrText(itemtype,itemkey,'ERROR_MESSAGE',l_error_msg);
985: result := 'COMPLETE:FAILURE';
986: RETURN;
987:
988: END IF;

Line 990: wf_engine.setItemAttrNumber(itemtype,itemkey,'GENERATED_CCID',TO_NUMBER(l_salesrep_rev_derived));

986: RETURN;
987:
988: END IF;
989:
990: wf_engine.setItemAttrNumber(itemtype,itemkey,'GENERATED_CCID',TO_NUMBER(l_salesrep_rev_derived));
991: result := 'COMPLETE:SUCCESS';
992: IF l_debug_level > 0 THEN
993: oe_debug_pub.add('Input Paramerers : ',2);
994: oe_debug_pub.add('Salesrep ID :' || to_char(l_salesrep_id),2);

Line 1000: result := wf_engine.eng_completed;

996: oe_debug_pub.add('Generated CCID :'||l_salesrep_rev_derived,2);
997: END IF;
998: RETURN;
999: ELSIF (funcmode = 'CANCEL') THEN
1000: result := wf_engine.eng_completed;
1001: RETURN;
1002: ELSE
1003: result := '';
1004: RETURN;

Line 1050: l_order_line_id:= wf_engine.GetItemAttrNumber(itemtype,itemkey,'LINE_ID');

1046: END IF;
1047: --DBMS_OUTPUT.PUT_LINE('Entering get_line_from_line');
1048:
1049: IF (FUNCMODE = 'RUN') THEN
1050: l_order_line_id:= wf_engine.GetItemAttrNumber(itemtype,itemkey,'LINE_ID');
1051: IF l_debug_level > 0 THEN
1052: oe_debug_pub.add('Input Paramerers : ',2);
1053: oe_debug_pub.add('Order Line ID :'|| to_char(l_order_line_id),2);
1054: END IF;

Line 1071: wf_engine.setItemAttrText(itemtype,itemkey,'ERROR_MESSAGE','No line type id found in oe_order_lines_all');

1067: --FND_MESSAGE.SET_TOKEN('LINEID',l_order_line_id);
1068: --fb_error_msg := FND_MESSAGE.GET_ENCODED;
1069: --FND_MESSAGE.SET_ENCODED(fb_error_msg);
1070: --l_error_msg := FND_MESSAGE.GET;
1071: wf_engine.setItemAttrText(itemtype,itemkey,'ERROR_MESSAGE','No line type id found in oe_order_lines_all');
1072: result := 'COMPLETE:FAILURE';
1073: RETURN;
1074:
1075: END;

Line 1076: wf_engine.setItemAttrNumber(itemtype,itemkey,'ORDER_TYPE_ID',l_order_type_id);

1072: result := 'COMPLETE:FAILURE';
1073: RETURN;
1074:
1075: END;
1076: wf_engine.setItemAttrNumber(itemtype,itemkey,'ORDER_TYPE_ID',l_order_type_id);
1077: result := 'COMPLETE:SUCCESS';
1078: ELSE
1079: result := 'COMPLETE:FAILURE';
1080: RETURN;

Line 1088: result := wf_engine.eng_completed;

1084: oe_debug_pub.add('Salesrep ID :'|| l_order_type_id,2);
1085: END IF;
1086: RETURN;
1087: ELSIF (funcmode = 'CANCEL') THEN
1088: result := wf_engine.eng_completed;
1089: RETURN;
1090: ELSE
1091: result := '';
1092: RETURN;

Line 1138: l_order_line_id:= wf_engine.GetItemAttrNumber(itemtype,itemkey,'LINE_ID');

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');
1140:
1141: IF l_debug_level > 0 THEN
1142: oe_debug_pub.add('Input Paramerers : ',2);

Line 1139: l_header_id:= wf_engine.GetItemAttrNumber(itemtype,itemkey,'HEADER_ID');

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');
1140:
1141: IF l_debug_level > 0 THEN
1142: oe_debug_pub.add('Input Paramerers : ',2);
1143: oe_debug_pub.add('Order Line ID :'|| to_char(l_order_line_id),2);

Line 1211: wf_engine.setItemAttrText(itemtype,itemkey,'ERROR_MESSAGE',l_error_msg);

1207: FND_MESSAGE.SET_TOKEN('LINEID',l_order_line_id);
1208: fb_error_msg := FND_MESSAGE.GET_ENCODED;
1209: FND_MESSAGE.SET_ENCODED(fb_error_msg);
1210: l_error_msg := FND_MESSAGE.GET;
1211: wf_engine.setItemAttrText(itemtype,itemkey,'ERROR_MESSAGE',l_error_msg);
1212: result := 'COMPLETE:FAILURE';
1213: RETURN;
1214: END;
1215: END;

Line 1216: wf_engine.setItemAttrNumber(itemtype,itemkey,'SALESREP_ID',TO_NUMBER(l_salesrep_id));

1212: result := 'COMPLETE:FAILURE';
1213: RETURN;
1214: END;
1215: END;
1216: wf_engine.setItemAttrNumber(itemtype,itemkey,'SALESREP_ID',TO_NUMBER(l_salesrep_id));
1217: result := 'COMPLETE:SUCCESS';
1218: ELSE
1219: result := 'COMPLETE:FAILURE';
1220: RETURN;

Line 1228: result := wf_engine.eng_completed;

1224: oe_debug_pub.add('Salesrep ID :'|| l_salesrep_id,2);
1225: END IF;
1226: RETURN;
1227: ELSIF (funcmode = 'CANCEL') THEN
1228: result := wf_engine.eng_completed;
1229: RETURN;
1230: ELSE
1231: result := '';
1232: RETURN;

Line 1278: l_inv_item_id := wf_engine.GetItemAttrNumber(itemtype,itemkey,'INVENTORY_ITEM_ID');

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');
1280: IF l_debug_level > 0 THEN
1281: oe_debug_pub.add('Input Paramerers : ',2);
1282: oe_debug_pub.add('Inventory Item ID :'|| to_char(l_inv_item_id),2);

Line 1279: l_ship_from_org_id:= wf_engine.GetItemAttrNumber(itemtype,itemkey,'ORGANIZATION_ID');

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');
1280: IF l_debug_level > 0 THEN
1281: oe_debug_pub.add('Input Paramerers : ',2);
1282: oe_debug_pub.add('Inventory Item ID :'|| to_char(l_inv_item_id),2);
1283: oe_debug_pub.add('Organization ID :'|| to_char(l_ship_from_org_id),2);

Line 1303: wf_engine.setItemAttrText(itemtype,itemkey,'ERROR_MESSAGE',l_error_msg);

1299: FND_MESSAGE.SET_TOKEN('VALUE2',l_ship_from_org_id);
1300: fb_error_msg := FND_MESSAGE.GET_ENCODED;
1301: FND_MESSAGE.SET_ENCODED(fb_error_msg);
1302: l_error_msg := FND_MESSAGE.GET;
1303: wf_engine.setItemAttrText(itemtype,itemkey,'ERROR_MESSAGE',l_error_msg);
1304: result := 'COMPLETE:FAILURE';
1305: RETURN;
1306: END;
1307:

Line 1320: wf_engine.setItemAttrText(itemtype,itemkey,'ERROR_MESSAGE',l_error_msg);

1316: fb_error_msg := FND_MESSAGE.GET_ENCODED;
1317: FND_MESSAGE.SET_ENCODED(fb_error_msg);
1318: l_error_msg := FND_MESSAGE.GET;
1319:
1320: wf_engine.setItemAttrText(itemtype,itemkey,'ERROR_MESSAGE',l_error_msg);
1321: result := 'COMPLETE:FAILURE';
1322: RETURN;
1323:
1324: END IF;

Line 1325: wf_engine.setItemAttrNumber(itemtype,itemkey,'GENERATED_CCID',TO_NUMBER(l_account_derived));

1321: result := 'COMPLETE:FAILURE';
1322: RETURN;
1323:
1324: END IF;
1325: wf_engine.setItemAttrNumber(itemtype,itemkey,'GENERATED_CCID',TO_NUMBER(l_account_derived));
1326: result := 'COMPLETE:SUCCESS';
1327: ELSE
1328: result := 'COMPLETE:FAILURE';
1329: RETURN;

Line 1337: result := wf_engine.eng_completed;

1333: oe_debug_pub.add('Generated CCID :'|| l_account_derived,2);
1334: END IF;
1335: RETURN;
1336: ELSIF (funcmode = 'CANCEL') THEN
1337: result := wf_engine.eng_completed;
1338: RETURN;
1339: ELSE
1340: result := '';
1341: RETURN;

Line 1380: l_option_flag := wf_engine.GetItemAttrText(itemtype,itemkey,'OPTION_FLAG');

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
1382: oe_debug_pub.add('Option Flag :'|| l_option_flag,2);
1383: END IF;
1384: IF l_option_flag = 'Y' THEN

Line 1395: result := wf_engine.eng_completed;

1391:
1392: RETURN;
1393:
1394: ELSIF (funcmode = 'CANCEL') THEN
1395: result := wf_engine.eng_completed;
1396: RETURN;
1397: ELSE
1398: result := '';
1399: RETURN;

Line 1442: l_commitment_id:= wf_engine.GetItemAttrNumber(itemtype,itemkey,'COMMITMENT_ID');

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
1444: oe_debug_pub.add('Input Paramerers : ',2);
1445: oe_debug_pub.add('Commitment ID :'|| to_char(l_commitment_id),2);
1446: END IF;

Line 1464: wf_engine.setItemAttrText(itemtype,itemkey,'ERROR_MESSAGE',l_error_msg);

1460: FND_MESSAGE.SET_TOKEN('COMMITMENTID',l_commitment_id);
1461: fb_error_msg := FND_MESSAGE.GET_ENCODED;
1462: FND_MESSAGE.SET_ENCODED(fb_error_msg);
1463: l_error_msg := FND_MESSAGE.GET;
1464: wf_engine.setItemAttrText(itemtype,itemkey,'ERROR_MESSAGE',l_error_msg);
1465: result := 'COMPLETE:FAILURE';
1466: RETURN;
1467: END;
1468: wf_engine.setItemAttrText(itemtype,itemkey,'TRX_TYPE_DERIVED',l_trx_type);

Line 1468: wf_engine.setItemAttrText(itemtype,itemkey,'TRX_TYPE_DERIVED',l_trx_type);

1464: wf_engine.setItemAttrText(itemtype,itemkey,'ERROR_MESSAGE',l_error_msg);
1465: result := 'COMPLETE:FAILURE';
1466: RETURN;
1467: END;
1468: wf_engine.setItemAttrText(itemtype,itemkey,'TRX_TYPE_DERIVED',l_trx_type);
1469: result := 'COMPLETE:SUCCESS';
1470: ELSE
1471: result := 'COMPLETE:FAILURE';
1472: RETURN;

Line 1480: result := wf_engine.eng_completed;

1476: oe_debug_pub.add('Transaction Type'||l_trx_type,2);
1477: END IF;
1478: RETURN;
1479: ELSIF (funcmode = 'CANCEL') THEN
1480: result := wf_engine.eng_completed;
1481: RETURN;
1482: ELSE
1483: result := '';
1484: RETURN;

Line 1576: l_order_line_id:= wf_engine.GetItemAttrNumber(itemtype,itemkey,'LINE_ID');

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');
1577: l_organization_id:= wf_engine.GetItemAttrNumber(itemtype,itemkey,'ORGANIZATION_ID');
1578: l_commitment_id:= wf_engine.GetItemAttrNumber(itemtype,itemkey,'COMMITMENT_ID');
1579: l_customer_id:= wf_engine.GetItemAttrNumber(itemtype,itemkey,'CUSTOMER_ID');
1580: l_header_id:= wf_engine.GetItemAttrNumber(itemtype,itemkey,'HEADER_ID');

Line 1577: l_organization_id:= wf_engine.GetItemAttrNumber(itemtype,itemkey,'ORGANIZATION_ID');

1573: END IF;
1574: IF (FUNCMODE = 'RUN') THEN
1575:
1576: l_order_line_id:= wf_engine.GetItemAttrNumber(itemtype,itemkey,'LINE_ID');
1577: l_organization_id:= wf_engine.GetItemAttrNumber(itemtype,itemkey,'ORGANIZATION_ID');
1578: l_commitment_id:= wf_engine.GetItemAttrNumber(itemtype,itemkey,'COMMITMENT_ID');
1579: l_customer_id:= wf_engine.GetItemAttrNumber(itemtype,itemkey,'CUSTOMER_ID');
1580: l_header_id:= wf_engine.GetItemAttrNumber(itemtype,itemkey,'HEADER_ID');
1581: l_order_category:= wf_engine.GetItemAttrText(itemtype,itemkey,'ORDER_CATEGORY');

Line 1578: l_commitment_id:= wf_engine.GetItemAttrNumber(itemtype,itemkey,'COMMITMENT_ID');

1574: IF (FUNCMODE = 'RUN') THEN
1575:
1576: l_order_line_id:= wf_engine.GetItemAttrNumber(itemtype,itemkey,'LINE_ID');
1577: l_organization_id:= wf_engine.GetItemAttrNumber(itemtype,itemkey,'ORGANIZATION_ID');
1578: l_commitment_id:= wf_engine.GetItemAttrNumber(itemtype,itemkey,'COMMITMENT_ID');
1579: l_customer_id:= wf_engine.GetItemAttrNumber(itemtype,itemkey,'CUSTOMER_ID');
1580: l_header_id:= wf_engine.GetItemAttrNumber(itemtype,itemkey,'HEADER_ID');
1581: l_order_category:= wf_engine.GetItemAttrText(itemtype,itemkey,'ORDER_CATEGORY');
1582: l_order_type_id:= wf_engine.GetItemAttrNumber(itemtype,itemkey,'ORDER_TYPE_ID');

Line 1579: l_customer_id:= wf_engine.GetItemAttrNumber(itemtype,itemkey,'CUSTOMER_ID');

1575:
1576: l_order_line_id:= wf_engine.GetItemAttrNumber(itemtype,itemkey,'LINE_ID');
1577: l_organization_id:= wf_engine.GetItemAttrNumber(itemtype,itemkey,'ORGANIZATION_ID');
1578: l_commitment_id:= wf_engine.GetItemAttrNumber(itemtype,itemkey,'COMMITMENT_ID');
1579: l_customer_id:= wf_engine.GetItemAttrNumber(itemtype,itemkey,'CUSTOMER_ID');
1580: l_header_id:= wf_engine.GetItemAttrNumber(itemtype,itemkey,'HEADER_ID');
1581: l_order_category:= wf_engine.GetItemAttrText(itemtype,itemkey,'ORDER_CATEGORY');
1582: l_order_type_id:= wf_engine.GetItemAttrNumber(itemtype,itemkey,'ORDER_TYPE_ID');
1583: l_option_flag:= wf_engine.GetItemAttrText(itemtype,itemkey,'OPTION_FLAG');

Line 1580: l_header_id:= wf_engine.GetItemAttrNumber(itemtype,itemkey,'HEADER_ID');

1576: l_order_line_id:= wf_engine.GetItemAttrNumber(itemtype,itemkey,'LINE_ID');
1577: l_organization_id:= wf_engine.GetItemAttrNumber(itemtype,itemkey,'ORGANIZATION_ID');
1578: l_commitment_id:= wf_engine.GetItemAttrNumber(itemtype,itemkey,'COMMITMENT_ID');
1579: l_customer_id:= wf_engine.GetItemAttrNumber(itemtype,itemkey,'CUSTOMER_ID');
1580: l_header_id:= wf_engine.GetItemAttrNumber(itemtype,itemkey,'HEADER_ID');
1581: l_order_category:= wf_engine.GetItemAttrText(itemtype,itemkey,'ORDER_CATEGORY');
1582: l_order_type_id:= wf_engine.GetItemAttrNumber(itemtype,itemkey,'ORDER_TYPE_ID');
1583: l_option_flag:= wf_engine.GetItemAttrText(itemtype,itemkey,'OPTION_FLAG');
1584: l_flex_num:= wf_engine.GetItemAttrNumber(itemtype,itemkey,'CHART_OF_ACCOUNTS_ID');

Line 1581: l_order_category:= wf_engine.GetItemAttrText(itemtype,itemkey,'ORDER_CATEGORY');

1577: l_organization_id:= wf_engine.GetItemAttrNumber(itemtype,itemkey,'ORGANIZATION_ID');
1578: l_commitment_id:= wf_engine.GetItemAttrNumber(itemtype,itemkey,'COMMITMENT_ID');
1579: l_customer_id:= wf_engine.GetItemAttrNumber(itemtype,itemkey,'CUSTOMER_ID');
1580: l_header_id:= wf_engine.GetItemAttrNumber(itemtype,itemkey,'HEADER_ID');
1581: l_order_category:= wf_engine.GetItemAttrText(itemtype,itemkey,'ORDER_CATEGORY');
1582: l_order_type_id:= wf_engine.GetItemAttrNumber(itemtype,itemkey,'ORDER_TYPE_ID');
1583: l_option_flag:= wf_engine.GetItemAttrText(itemtype,itemkey,'OPTION_FLAG');
1584: l_flex_num:= wf_engine.GetItemAttrNumber(itemtype,itemkey,'CHART_OF_ACCOUNTS_ID');
1585:

Line 1582: l_order_type_id:= wf_engine.GetItemAttrNumber(itemtype,itemkey,'ORDER_TYPE_ID');

1578: l_commitment_id:= wf_engine.GetItemAttrNumber(itemtype,itemkey,'COMMITMENT_ID');
1579: l_customer_id:= wf_engine.GetItemAttrNumber(itemtype,itemkey,'CUSTOMER_ID');
1580: l_header_id:= wf_engine.GetItemAttrNumber(itemtype,itemkey,'HEADER_ID');
1581: l_order_category:= wf_engine.GetItemAttrText(itemtype,itemkey,'ORDER_CATEGORY');
1582: l_order_type_id:= wf_engine.GetItemAttrNumber(itemtype,itemkey,'ORDER_TYPE_ID');
1583: l_option_flag:= wf_engine.GetItemAttrText(itemtype,itemkey,'OPTION_FLAG');
1584: l_flex_num:= wf_engine.GetItemAttrNumber(itemtype,itemkey,'CHART_OF_ACCOUNTS_ID');
1585:
1586: IF l_debug_level > 0 THEN

Line 1583: l_option_flag:= wf_engine.GetItemAttrText(itemtype,itemkey,'OPTION_FLAG');

1579: l_customer_id:= wf_engine.GetItemAttrNumber(itemtype,itemkey,'CUSTOMER_ID');
1580: l_header_id:= wf_engine.GetItemAttrNumber(itemtype,itemkey,'HEADER_ID');
1581: l_order_category:= wf_engine.GetItemAttrText(itemtype,itemkey,'ORDER_CATEGORY');
1582: l_order_type_id:= wf_engine.GetItemAttrNumber(itemtype,itemkey,'ORDER_TYPE_ID');
1583: l_option_flag:= wf_engine.GetItemAttrText(itemtype,itemkey,'OPTION_FLAG');
1584: l_flex_num:= wf_engine.GetItemAttrNumber(itemtype,itemkey,'CHART_OF_ACCOUNTS_ID');
1585:
1586: IF l_debug_level > 0 THEN
1587: oe_debug_pub.add('Input Paramerers : ',2);

Line 1584: l_flex_num:= wf_engine.GetItemAttrNumber(itemtype,itemkey,'CHART_OF_ACCOUNTS_ID');

1580: l_header_id:= wf_engine.GetItemAttrNumber(itemtype,itemkey,'HEADER_ID');
1581: l_order_category:= wf_engine.GetItemAttrText(itemtype,itemkey,'ORDER_CATEGORY');
1582: l_order_type_id:= wf_engine.GetItemAttrNumber(itemtype,itemkey,'ORDER_TYPE_ID');
1583: l_option_flag:= wf_engine.GetItemAttrText(itemtype,itemkey,'OPTION_FLAG');
1584: l_flex_num:= wf_engine.GetItemAttrNumber(itemtype,itemkey,'CHART_OF_ACCOUNTS_ID');
1585:
1586: IF l_debug_level > 0 THEN
1587: oe_debug_pub.add('Input Paramerers : ',2);
1588: oe_debug_pub.add('Line id :'||to_char(l_order_line_id),2);

Line 1616: wf_engine.setItemAttrText(itemtype,itemkey,'ERROR_MESSAGE',L_FB_ERROR_MSG);

1612: result := 'COMPLETE:FAILURE';
1613: END IF;
1614:
1615: IF L_FB_ERROR_MSG IS NOT NULL THEN
1616: wf_engine.setItemAttrText(itemtype,itemkey,'ERROR_MESSAGE',L_FB_ERROR_MSG);
1617: END IF;
1618:
1619: FND_FLEX_WORKFLOW.LOAD_CONCATENATED_SEGMENTS(itemtype,
1620: itemkey,

Line 1626: result := wf_engine.eng_completed;

1622: RETURN;
1623:
1624: ELSIF (funcmode = 'CANCEL') THEN
1625:
1626: result := wf_engine.eng_completed;
1627: RETURN;
1628: ELSE
1629: result := '';
1630: RETURN;