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 335: wf_engine.SetItemAttrNumberArray(l_itemtype

331:
332: l_aname(10) := 'INVENTORY_ITEM_ID';
333: l_avalue(10):=l_inventory_item_id;
334:
335: wf_engine.SetItemAttrNumberArray(l_itemtype
336: , l_itemkey
337: , l_aname
338: , l_avalue
339: );

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

351: l_aname2(2) := 'OPTION_FLAG';
352: l_avaluetext(2):= l_option_flag;
353: g_stmt:='70';
354:
355: wf_engine.SetItemAttrTextArray(itemtype => l_itemtype,
356: itemkey => l_itemkey,
357: aname => l_aname2,
358: avalue => l_avaluetext);
359: IF l_debug_level > 0 THEN

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

528: oe_debug_pub.add(' Activity Id : '||to_char(actid),2);
529: oe_debug_pub.add(' funcmode : '||funcmode,2);
530: END IF;
531: IF (FUNCMODE = 'RUN') THEN
532: l_line_id := wf_engine.GetItemAttrNumber(itemtype,itemkey,'LINE_ID');
533: l_organization_id := wf_engine.GetItemAttrNumber(itemtype,itemkey,'ORGANIZATION_ID');
534: l_inventory_item_id := wf_engine.GetItemAttrNumber(itemtype,itemkey,'INVENTORY_ITEM_ID');
535:
536: SELECT LINK_TO_LINE_ID,

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

529: oe_debug_pub.add(' funcmode : '||funcmode,2);
530: END IF;
531: IF (FUNCMODE = 'RUN') THEN
532: l_line_id := wf_engine.GetItemAttrNumber(itemtype,itemkey,'LINE_ID');
533: l_organization_id := wf_engine.GetItemAttrNumber(itemtype,itemkey,'ORGANIZATION_ID');
534: l_inventory_item_id := wf_engine.GetItemAttrNumber(itemtype,itemkey,'INVENTORY_ITEM_ID');
535:
536: SELECT LINK_TO_LINE_ID,
537: ITEM_TYPE_CODE

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

530: END IF;
531: IF (FUNCMODE = 'RUN') THEN
532: l_line_id := wf_engine.GetItemAttrNumber(itemtype,itemkey,'LINE_ID');
533: l_organization_id := wf_engine.GetItemAttrNumber(itemtype,itemkey,'ORGANIZATION_ID');
534: l_inventory_item_id := wf_engine.GetItemAttrNumber(itemtype,itemkey,'INVENTORY_ITEM_ID');
535:
536: SELECT LINK_TO_LINE_ID,
537: ITEM_TYPE_CODE
538: INTO l_link_to_line_id,

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

563: FND_MESSAGE.SET_TOKEN('VALUE2',l_organization_id);
564: FB_ERROR_MSG := FND_MESSAGE.GET_ENCODED;
565: FND_MESSAGE.SET_ENCODED(fb_error_msg);
566: l_error_msg := FND_MESSAGE.GET;
567: wf_engine.setItemAttrText(itemtype,itemkey,'ERROR_MESSAGE',l_error_msg);
568: result := 'COMPLETE:FAILURE';
569: RETURN;
570: END IF;
571: END;

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

595: FND_MESSAGE.SET_TOKEN('VALUE2',l_organization_id);
596: FB_ERROR_MSG := FND_MESSAGE.GET_ENCODED;
597: FND_MESSAGE.SET_ENCODED(fb_error_msg);
598: l_error_msg := FND_MESSAGE.GET;
599: wf_engine.setItemAttrText(itemtype,itemkey,'ERROR_MESSAGE',l_error_msg);
600: result := 'COMPLETE:FAILURE';
601: RETURN;
602: END;
603:

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

615: fb_error_msg := FND_MESSAGE.GET_ENCODED;
616: FND_MESSAGE.SET_ENCODED(fb_error_msg);
617: l_error_msg := FND_MESSAGE.GET;
618:
619: wf_engine.setItemAttrText(itemtype,itemkey,'ERROR_MESSAGE',l_error_msg);
620: result := 'COMPLETE:FAILURE';
621: RETURN;
622:
623: END IF;

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

621: RETURN;
622:
623: END IF;
624:
625: wf_engine.setItemAttrNumber(itemtype,itemkey,'GENERATED_CCID',TO_NUMBER(l_cost_sale_item_derived));
626: result := 'COMPLETE:SUCCESS';
627: IF l_debug_level > 0 THEN
628: oe_debug_pub.add('Input Paramerers : ');
629: oe_debug_pub.add('Line id :'||to_char(l_line_id));

Line 638: result := wf_engine.eng_completed;

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;
639: RETURN;
640: ELSE
641: result := '';
642: RETURN;

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

694: oe_debug_pub.add(' Activity Id : '||to_char(actid),2);
695: oe_debug_pub.add(' funcmode : '||funcmode,2);
696: END IF;
697: IF (FUNCMODE = 'RUN') THEN
698: l_line_id := wf_engine.GetItemAttrNumber(itemtype,itemkey,'LINE_ID');
699:
700: SELECT TOP_MODEL_LINE_ID,
701: INVENTORY_ITEM_ID,
702: SHIP_FROM_ORG_ID

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

731: FND_MESSAGE.SET_TOKEN('VALUE2',l_organization_id);
732: fb_error_msg := FND_MESSAGE.GET_ENCODED;
733: FND_MESSAGE.SET_ENCODED(fb_error_msg);
734: l_error_msg := FND_MESSAGE.GET;
735: wf_engine.setItemAttrText(itemtype,itemkey,'ERROR_MESSAGE',l_error_msg);
736: result := 'COMPLETE:FAILURE';
737: RETURN;
738: END;
739: END IF;

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

749: fb_error_msg := FND_MESSAGE.GET_ENCODED;
750: FND_MESSAGE.SET_ENCODED(fb_error_msg);
751: l_error_msg := FND_MESSAGE.GET;
752:
753: wf_engine.setItemAttrText(itemtype,itemkey,'ERROR_MESSAGE',l_error_msg);
754: result := 'COMPLETE:FAILURE';
755: RETURN;
756:
757: END IF;

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

755: RETURN;
756:
757: END IF;
758:
759: wf_engine.setItemAttrNumber(itemtype,itemkey,'GENERATED_CCID',TO_NUMBER(l_cost_sale_model_derived));
760: result := 'COMPLETE:SUCCESS';
761: IF l_debug_level > 0 THEN
762: oe_debug_pub.add('Input Paramerers : ');
763: oe_debug_pub.add('Line id :'||to_char(l_line_id));

Line 771: result := wf_engine.eng_completed;

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;
772: RETURN;
773: ELSE
774: result := '';
775: RETURN;

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

821: oe_debug_pub.add(' funcmode : '||funcmode,2);
822: END IF;
823:
824: IF (funcmode = 'RUN') THEN
825: l_order_type_id := wf_engine.GetItemAttrNumber(itemtype,itemkey,'ORDER_TYPE_ID');
826: l_order_type_ccid := NULL;
827: IF (l_order_type_id IS NOT NULL) THEN
828: BEGIN
829: SELECT NVL(COST_OF_GOODS_SOLD_ACCOUNT, 0)

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

839: FND_MESSAGE.SET_TOKEN('VALUE2','');
840: fb_error_msg := FND_MESSAGE.GET_ENCODED;
841: FND_MESSAGE.SET_ENCODED(fb_error_msg);
842: l_error_msg := FND_MESSAGE.GET;
843: wf_engine.setItemAttrText(itemtype,itemkey,'ERROR_MESSAGE',l_error_msg);
844: result := 'COMPLETE:FAILURE';
845: RETURN;
846: END;
847: END IF;

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

857: fb_error_msg := FND_MESSAGE.GET_ENCODED;
858: FND_MESSAGE.SET_ENCODED(fb_error_msg);
859: l_error_msg := FND_MESSAGE.GET;
860:
861: wf_engine.setItemAttrText(itemtype,itemkey,'ERROR_MESSAGE',l_error_msg);
862: result := 'COMPLETE:FAILURE';
863: RETURN;
864:
865: END IF;

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

863: RETURN;
864:
865: END IF;
866:
867: wf_engine.setItemAttrNumber(itemtype,itemkey,'GENERATED_CCID',TO_NUMBER(L_ORDER_TYPE_CCID));
868: result := 'COMPLETE:SUCCESS';
869: IF l_debug_level > 0 THEN
870: oe_debug_pub.add('Input Paramerers : ',2);
871: oe_debug_pub.add('Order Type ID :'||to_char(l_order_type_id),2);

Line 877: result := wf_engine.eng_completed;

873: oe_debug_pub.add('Generated CCID :'||l_order_type_ccid,2);
874: END IF;
875: RETURN;
876: ELSIF (funcmode = 'CANCEL') THEN
877: result := wf_engine.eng_completed;
878: RETURN;
879: ELSE
880: result := '';
881: RETURN;

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

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

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

948: FND_MESSAGE.SET_TOKEN('VALUE2','');
949: fb_error_msg := FND_MESSAGE.GET_ENCODED;
950: FND_MESSAGE.SET_ENCODED(fb_error_msg);
951: l_error_msg := FND_MESSAGE.GET;
952: wf_engine.setItemAttrText(itemtype,itemkey,'ERROR_MESSAGE',l_error_msg);
953: result := 'COMPLETE:FAILURE';
954: RETURN;
955: END;
956: END IF;

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

966: fb_error_msg := FND_MESSAGE.GET_ENCODED;
967: FND_MESSAGE.SET_ENCODED(fb_error_msg);
968: l_error_msg := FND_MESSAGE.GET;
969:
970: wf_engine.setItemAttrText(itemtype,itemkey,'ERROR_MESSAGE',l_error_msg);
971: result := 'COMPLETE:FAILURE';
972: RETURN;
973:
974: END IF;

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

972: RETURN;
973:
974: END IF;
975:
976: wf_engine.setItemAttrNumber(itemtype,itemkey,'GENERATED_CCID',TO_NUMBER(l_salesrep_rev_derived));
977: result := 'COMPLETE:SUCCESS';
978: IF l_debug_level > 0 THEN
979: oe_debug_pub.add('Input Paramerers : ',2);
980: oe_debug_pub.add('Salesrep ID :' || to_char(l_salesrep_id),2);

Line 986: result := wf_engine.eng_completed;

982: oe_debug_pub.add('Generated CCID :'||l_salesrep_rev_derived,2);
983: END IF;
984: RETURN;
985: ELSIF (funcmode = 'CANCEL') THEN
986: result := wf_engine.eng_completed;
987: RETURN;
988: ELSE
989: result := '';
990: RETURN;

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

1032: END IF;
1033: --DBMS_OUTPUT.PUT_LINE('Entering get_line_from_line');
1034:
1035: IF (FUNCMODE = 'RUN') THEN
1036: l_order_line_id:= wf_engine.GetItemAttrNumber(itemtype,itemkey,'LINE_ID');
1037: IF l_debug_level > 0 THEN
1038: oe_debug_pub.add('Input Paramerers : ',2);
1039: oe_debug_pub.add('Order Line ID :'|| to_char(l_order_line_id),2);
1040: END IF;

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

1053: --FND_MESSAGE.SET_TOKEN('LINEID',l_order_line_id);
1054: --fb_error_msg := FND_MESSAGE.GET_ENCODED;
1055: --FND_MESSAGE.SET_ENCODED(fb_error_msg);
1056: --l_error_msg := FND_MESSAGE.GET;
1057: wf_engine.setItemAttrText(itemtype,itemkey,'ERROR_MESSAGE','No line type id found in oe_order_lines_all');
1058: result := 'COMPLETE:FAILURE';
1059: RETURN;
1060:
1061: END;

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

1058: result := 'COMPLETE:FAILURE';
1059: RETURN;
1060:
1061: END;
1062: wf_engine.setItemAttrNumber(itemtype,itemkey,'ORDER_TYPE_ID',l_order_type_id);
1063: result := 'COMPLETE:SUCCESS';
1064: ELSE
1065: result := 'COMPLETE:FAILURE';
1066: RETURN;

Line 1074: result := wf_engine.eng_completed;

1070: oe_debug_pub.add('Salesrep ID :'|| l_order_type_id,2);
1071: END IF;
1072: RETURN;
1073: ELSIF (funcmode = 'CANCEL') THEN
1074: result := wf_engine.eng_completed;
1075: RETURN;
1076: ELSE
1077: result := '';
1078: RETURN;

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

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

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

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');
1126:
1127: IF l_debug_level > 0 THEN
1128: oe_debug_pub.add('Input Paramerers : ',2);
1129: oe_debug_pub.add('Order Line ID :'|| to_char(l_order_line_id),2);

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

1193: FND_MESSAGE.SET_TOKEN('LINEID',l_order_line_id);
1194: fb_error_msg := FND_MESSAGE.GET_ENCODED;
1195: FND_MESSAGE.SET_ENCODED(fb_error_msg);
1196: l_error_msg := FND_MESSAGE.GET;
1197: wf_engine.setItemAttrText(itemtype,itemkey,'ERROR_MESSAGE',l_error_msg);
1198: result := 'COMPLETE:FAILURE';
1199: RETURN;
1200: END;
1201: END;

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

1198: result := 'COMPLETE:FAILURE';
1199: RETURN;
1200: END;
1201: END;
1202: wf_engine.setItemAttrNumber(itemtype,itemkey,'SALESREP_ID',TO_NUMBER(l_salesrep_id));
1203: result := 'COMPLETE:SUCCESS';
1204: ELSE
1205: result := 'COMPLETE:FAILURE';
1206: RETURN;

Line 1214: result := wf_engine.eng_completed;

1210: oe_debug_pub.add('Salesrep ID :'|| l_salesrep_id,2);
1211: END IF;
1212: RETURN;
1213: ELSIF (funcmode = 'CANCEL') THEN
1214: result := wf_engine.eng_completed;
1215: RETURN;
1216: ELSE
1217: result := '';
1218: RETURN;

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

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

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

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');
1266: IF l_debug_level > 0 THEN
1267: oe_debug_pub.add('Input Paramerers : ',2);
1268: oe_debug_pub.add('Inventory Item ID :'|| to_char(l_inv_item_id),2);
1269: oe_debug_pub.add('Organization ID :'|| to_char(l_ship_from_org_id),2);

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

1285: FND_MESSAGE.SET_TOKEN('VALUE2',l_ship_from_org_id);
1286: fb_error_msg := FND_MESSAGE.GET_ENCODED;
1287: FND_MESSAGE.SET_ENCODED(fb_error_msg);
1288: l_error_msg := FND_MESSAGE.GET;
1289: wf_engine.setItemAttrText(itemtype,itemkey,'ERROR_MESSAGE',l_error_msg);
1290: result := 'COMPLETE:FAILURE';
1291: RETURN;
1292: END;
1293:

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

1302: fb_error_msg := FND_MESSAGE.GET_ENCODED;
1303: FND_MESSAGE.SET_ENCODED(fb_error_msg);
1304: l_error_msg := FND_MESSAGE.GET;
1305:
1306: wf_engine.setItemAttrText(itemtype,itemkey,'ERROR_MESSAGE',l_error_msg);
1307: result := 'COMPLETE:FAILURE';
1308: RETURN;
1309:
1310: END IF;

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

1307: result := 'COMPLETE:FAILURE';
1308: RETURN;
1309:
1310: END IF;
1311: wf_engine.setItemAttrNumber(itemtype,itemkey,'GENERATED_CCID',TO_NUMBER(l_account_derived));
1312: result := 'COMPLETE:SUCCESS';
1313: ELSE
1314: result := 'COMPLETE:FAILURE';
1315: RETURN;

Line 1323: result := wf_engine.eng_completed;

1319: oe_debug_pub.add('Generated CCID :'|| l_account_derived,2);
1320: END IF;
1321: RETURN;
1322: ELSIF (funcmode = 'CANCEL') THEN
1323: result := wf_engine.eng_completed;
1324: RETURN;
1325: ELSE
1326: result := '';
1327: RETURN;

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

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

Line 1381: result := wf_engine.eng_completed;

1377:
1378: RETURN;
1379:
1380: ELSIF (funcmode = 'CANCEL') THEN
1381: result := wf_engine.eng_completed;
1382: RETURN;
1383: ELSE
1384: result := '';
1385: RETURN;

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

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

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

1446: FND_MESSAGE.SET_TOKEN('COMMITMENTID',l_commitment_id);
1447: fb_error_msg := FND_MESSAGE.GET_ENCODED;
1448: FND_MESSAGE.SET_ENCODED(fb_error_msg);
1449: l_error_msg := FND_MESSAGE.GET;
1450: wf_engine.setItemAttrText(itemtype,itemkey,'ERROR_MESSAGE',l_error_msg);
1451: result := 'COMPLETE:FAILURE';
1452: RETURN;
1453: END;
1454: wf_engine.setItemAttrText(itemtype,itemkey,'TRX_TYPE_DERIVED',l_trx_type);

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

1450: wf_engine.setItemAttrText(itemtype,itemkey,'ERROR_MESSAGE',l_error_msg);
1451: result := 'COMPLETE:FAILURE';
1452: RETURN;
1453: END;
1454: wf_engine.setItemAttrText(itemtype,itemkey,'TRX_TYPE_DERIVED',l_trx_type);
1455: result := 'COMPLETE:SUCCESS';
1456: ELSE
1457: result := 'COMPLETE:FAILURE';
1458: RETURN;

Line 1466: result := wf_engine.eng_completed;

1462: oe_debug_pub.add('Transaction Type'||l_trx_type,2);
1463: END IF;
1464: RETURN;
1465: ELSIF (funcmode = 'CANCEL') THEN
1466: result := wf_engine.eng_completed;
1467: RETURN;
1468: ELSE
1469: result := '';
1470: RETURN;

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

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');
1563: l_organization_id:= wf_engine.GetItemAttrNumber(itemtype,itemkey,'ORGANIZATION_ID');
1564: l_commitment_id:= wf_engine.GetItemAttrNumber(itemtype,itemkey,'COMMITMENT_ID');
1565: l_customer_id:= wf_engine.GetItemAttrNumber(itemtype,itemkey,'CUSTOMER_ID');
1566: l_header_id:= wf_engine.GetItemAttrNumber(itemtype,itemkey,'HEADER_ID');

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

1559: END IF;
1560: IF (FUNCMODE = 'RUN') THEN
1561:
1562: l_order_line_id:= wf_engine.GetItemAttrNumber(itemtype,itemkey,'LINE_ID');
1563: l_organization_id:= wf_engine.GetItemAttrNumber(itemtype,itemkey,'ORGANIZATION_ID');
1564: l_commitment_id:= wf_engine.GetItemAttrNumber(itemtype,itemkey,'COMMITMENT_ID');
1565: l_customer_id:= wf_engine.GetItemAttrNumber(itemtype,itemkey,'CUSTOMER_ID');
1566: l_header_id:= wf_engine.GetItemAttrNumber(itemtype,itemkey,'HEADER_ID');
1567: l_order_category:= wf_engine.GetItemAttrText(itemtype,itemkey,'ORDER_CATEGORY');

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

1560: IF (FUNCMODE = 'RUN') THEN
1561:
1562: l_order_line_id:= wf_engine.GetItemAttrNumber(itemtype,itemkey,'LINE_ID');
1563: l_organization_id:= wf_engine.GetItemAttrNumber(itemtype,itemkey,'ORGANIZATION_ID');
1564: l_commitment_id:= wf_engine.GetItemAttrNumber(itemtype,itemkey,'COMMITMENT_ID');
1565: l_customer_id:= wf_engine.GetItemAttrNumber(itemtype,itemkey,'CUSTOMER_ID');
1566: l_header_id:= wf_engine.GetItemAttrNumber(itemtype,itemkey,'HEADER_ID');
1567: l_order_category:= wf_engine.GetItemAttrText(itemtype,itemkey,'ORDER_CATEGORY');
1568: l_order_type_id:= wf_engine.GetItemAttrNumber(itemtype,itemkey,'ORDER_TYPE_ID');

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

1561:
1562: l_order_line_id:= wf_engine.GetItemAttrNumber(itemtype,itemkey,'LINE_ID');
1563: l_organization_id:= wf_engine.GetItemAttrNumber(itemtype,itemkey,'ORGANIZATION_ID');
1564: l_commitment_id:= wf_engine.GetItemAttrNumber(itemtype,itemkey,'COMMITMENT_ID');
1565: l_customer_id:= wf_engine.GetItemAttrNumber(itemtype,itemkey,'CUSTOMER_ID');
1566: l_header_id:= wf_engine.GetItemAttrNumber(itemtype,itemkey,'HEADER_ID');
1567: l_order_category:= wf_engine.GetItemAttrText(itemtype,itemkey,'ORDER_CATEGORY');
1568: l_order_type_id:= wf_engine.GetItemAttrNumber(itemtype,itemkey,'ORDER_TYPE_ID');
1569: l_option_flag:= wf_engine.GetItemAttrText(itemtype,itemkey,'OPTION_FLAG');

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

1562: l_order_line_id:= wf_engine.GetItemAttrNumber(itemtype,itemkey,'LINE_ID');
1563: l_organization_id:= wf_engine.GetItemAttrNumber(itemtype,itemkey,'ORGANIZATION_ID');
1564: l_commitment_id:= wf_engine.GetItemAttrNumber(itemtype,itemkey,'COMMITMENT_ID');
1565: l_customer_id:= wf_engine.GetItemAttrNumber(itemtype,itemkey,'CUSTOMER_ID');
1566: l_header_id:= wf_engine.GetItemAttrNumber(itemtype,itemkey,'HEADER_ID');
1567: l_order_category:= wf_engine.GetItemAttrText(itemtype,itemkey,'ORDER_CATEGORY');
1568: l_order_type_id:= wf_engine.GetItemAttrNumber(itemtype,itemkey,'ORDER_TYPE_ID');
1569: l_option_flag:= wf_engine.GetItemAttrText(itemtype,itemkey,'OPTION_FLAG');
1570: l_flex_num:= wf_engine.GetItemAttrNumber(itemtype,itemkey,'CHART_OF_ACCOUNTS_ID');

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

1563: l_organization_id:= wf_engine.GetItemAttrNumber(itemtype,itemkey,'ORGANIZATION_ID');
1564: l_commitment_id:= wf_engine.GetItemAttrNumber(itemtype,itemkey,'COMMITMENT_ID');
1565: l_customer_id:= wf_engine.GetItemAttrNumber(itemtype,itemkey,'CUSTOMER_ID');
1566: l_header_id:= wf_engine.GetItemAttrNumber(itemtype,itemkey,'HEADER_ID');
1567: l_order_category:= wf_engine.GetItemAttrText(itemtype,itemkey,'ORDER_CATEGORY');
1568: l_order_type_id:= wf_engine.GetItemAttrNumber(itemtype,itemkey,'ORDER_TYPE_ID');
1569: l_option_flag:= wf_engine.GetItemAttrText(itemtype,itemkey,'OPTION_FLAG');
1570: l_flex_num:= wf_engine.GetItemAttrNumber(itemtype,itemkey,'CHART_OF_ACCOUNTS_ID');
1571:

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

1564: l_commitment_id:= wf_engine.GetItemAttrNumber(itemtype,itemkey,'COMMITMENT_ID');
1565: l_customer_id:= wf_engine.GetItemAttrNumber(itemtype,itemkey,'CUSTOMER_ID');
1566: l_header_id:= wf_engine.GetItemAttrNumber(itemtype,itemkey,'HEADER_ID');
1567: l_order_category:= wf_engine.GetItemAttrText(itemtype,itemkey,'ORDER_CATEGORY');
1568: l_order_type_id:= wf_engine.GetItemAttrNumber(itemtype,itemkey,'ORDER_TYPE_ID');
1569: l_option_flag:= wf_engine.GetItemAttrText(itemtype,itemkey,'OPTION_FLAG');
1570: l_flex_num:= wf_engine.GetItemAttrNumber(itemtype,itemkey,'CHART_OF_ACCOUNTS_ID');
1571:
1572: IF l_debug_level > 0 THEN

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

1565: l_customer_id:= wf_engine.GetItemAttrNumber(itemtype,itemkey,'CUSTOMER_ID');
1566: l_header_id:= wf_engine.GetItemAttrNumber(itemtype,itemkey,'HEADER_ID');
1567: l_order_category:= wf_engine.GetItemAttrText(itemtype,itemkey,'ORDER_CATEGORY');
1568: l_order_type_id:= wf_engine.GetItemAttrNumber(itemtype,itemkey,'ORDER_TYPE_ID');
1569: l_option_flag:= wf_engine.GetItemAttrText(itemtype,itemkey,'OPTION_FLAG');
1570: l_flex_num:= wf_engine.GetItemAttrNumber(itemtype,itemkey,'CHART_OF_ACCOUNTS_ID');
1571:
1572: IF l_debug_level > 0 THEN
1573: oe_debug_pub.add('Input Paramerers : ',2);

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

1566: l_header_id:= wf_engine.GetItemAttrNumber(itemtype,itemkey,'HEADER_ID');
1567: l_order_category:= wf_engine.GetItemAttrText(itemtype,itemkey,'ORDER_CATEGORY');
1568: l_order_type_id:= wf_engine.GetItemAttrNumber(itemtype,itemkey,'ORDER_TYPE_ID');
1569: l_option_flag:= wf_engine.GetItemAttrText(itemtype,itemkey,'OPTION_FLAG');
1570: l_flex_num:= wf_engine.GetItemAttrNumber(itemtype,itemkey,'CHART_OF_ACCOUNTS_ID');
1571:
1572: IF l_debug_level > 0 THEN
1573: oe_debug_pub.add('Input Paramerers : ',2);
1574: oe_debug_pub.add('Line id :'||to_char(l_order_line_id),2);

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

1598: result := 'COMPLETE:FAILURE';
1599: END IF;
1600:
1601: IF L_FB_ERROR_MSG IS NOT NULL THEN
1602: wf_engine.setItemAttrText(itemtype,itemkey,'ERROR_MESSAGE',L_FB_ERROR_MSG);
1603: END IF;
1604:
1605: FND_FLEX_WORKFLOW.LOAD_CONCATENATED_SEGMENTS(itemtype,
1606: itemkey,

Line 1612: result := wf_engine.eng_completed;

1608: RETURN;
1609:
1610: ELSIF (funcmode = 'CANCEL') THEN
1611:
1612: result := wf_engine.eng_completed;
1613: RETURN;
1614: ELSE
1615: result := '';
1616: RETURN;