APPS.PORCPTWF dependencies on WF_ENGINE

Line 942: wf_engine.createProcess ( ItemType => l_ItemType,

938: -- ash_debug.debug('Start_Rcpt_Process','0');
939:
940:
941:
942: wf_engine.createProcess ( ItemType => l_ItemType,
943: ItemKey => l_ItemKey,
944: process => 'PO_CONFIRM_RECEIPT' );
945:
946: -- ash_debug.debug('Start_Rcpt_Process','1');

Line 962: wf_engine.SetItemAttrNumber ( itemtype => l_ItemType,

958: -- ash_debug.debug('Start_Rcpt_Process int req',x_is_int_req);
959:
960: if x_is_int_req = 'Y' then
961:
962: wf_engine.SetItemAttrNumber ( itemtype => l_ItemType,
963: itemkey => l_itemkey,
964: aname => 'SO_HEADER_ID',
965: avalue => x_header_id );
966:

Line 967: wf_engine.SetItemAttrNumber ( itemtype => l_ItemType,

963: itemkey => l_itemkey,
964: aname => 'SO_HEADER_ID',
965: avalue => x_header_id );
966:
967: wf_engine.SetItemAttrNumber ( itemtype => l_ItemType,
968: itemkey => l_itemkey,
969: aname => 'REQ_HEADER_ID',
970: avalue => x_req_header_id);
971:

Line 974: wf_engine.SetItemAttrNumber (itemtype => l_ItemType,

970: avalue => x_req_header_id);
971:
972: else --x_is_int_req = 'N'
973:
974: wf_engine.SetItemAttrNumber (itemtype => l_ItemType,
975: itemkey => l_itemkey,
976: aname => 'PO_HEADER_ID',
977: avalue => x_header_id );
978:

Line 986: wf_engine.SetItemAttrNumber ( itemtype => l_ItemType,

982: avalue => x_po_num_rel_num );
983:
984: end if;
985:
986: wf_engine.SetItemAttrNumber ( itemtype => l_ItemType,
987: itemkey => l_itemkey,
988: aname => 'REQUESTER_ID',
989: avalue => x_requester_id );
990:

Line 991: wf_engine.SetItemAttrText ( itemtype => l_itemtype,

987: itemkey => l_itemkey,
988: aname => 'REQUESTER_ID',
989: avalue => x_requester_id );
990:
991: wf_engine.SetItemAttrText ( itemtype => l_itemtype,
992: itemkey => l_itemkey,
993: aname => 'IS_INT_REQ',
994: avalue => x_is_int_req );
995:

Line 996: wf_engine.SetItemAttrText ( itemtype => l_itemtype,

992: itemkey => l_itemkey,
993: aname => 'IS_INT_REQ',
994: avalue => x_is_int_req );
995:
996: wf_engine.SetItemAttrText ( itemtype => l_itemtype,
997: itemkey => l_itemkey,
998: aname => 'ORG_ID',
999: avalue => x_org_id );
1000:

Line 1002: wf_engine.SetItemAttrDate ( itemtype => l_ItemType,

998: aname => 'ORG_ID',
999: avalue => x_org_id );
1000:
1001:
1002: wf_engine.SetItemAttrDate ( itemtype => l_ItemType,
1003: itemkey => l_itemkey,
1004: aname => 'DUE_DATE',
1005: avalue => x_exp_receipt_date );
1006:

Line 1062: wf_engine.SetItemAttrText ( itemtype => l_itemtype,

1058:
1059: end if;
1060:
1061:
1062: wf_engine.SetItemAttrText ( itemtype => l_itemtype,
1063: itemkey => l_itemkey,
1064: aname => 'REQUESTER_USERNAME',
1065: avalue => x_requester_username );
1066:

Line 1067: wf_engine.SetItemAttrText ( itemtype => l_itemtype,

1063: itemkey => l_itemkey,
1064: aname => 'REQUESTER_USERNAME',
1065: avalue => x_requester_username );
1066:
1067: wf_engine.SetItemAttrText ( itemtype => l_itemtype,
1068: itemkey => l_itemkey,
1069: aname => 'REQUESTER_DISP_NAME',
1070: avalue => x_requester_disp_name );
1071:

Line 1074: wf_engine.SetItemAttrNumber ( itemtype => l_itemtype,

1070: avalue => x_requester_disp_name );
1071:
1072: if x_is_int_req = 'N' then
1073:
1074: wf_engine.SetItemAttrNumber ( itemtype => l_itemtype,
1075: itemkey => l_itemkey,
1076: aname => 'PO_REVISION_NUM',
1077: avalue => x_revision_num );
1078: end if;

Line 1082: wf_engine.StartProcess ( ItemType => l_ItemType,

1078: end if;
1079:
1080: -- ash_debug.debug('Start_Rcpt_Process int req','7');
1081:
1082: wf_engine.StartProcess ( ItemType => l_ItemType,
1083: ItemKey => l_ItemKey );
1084:
1085: -- ash_debug.debug('Start_Rcpt_Process int req','8');
1086:

Line 1157: x_po_header_id := wf_engine.GetItemAttrNumber( itemtype => itemtype,

1153:
1154: IF ( funmode = 'RUN' ) THEN
1155: --
1156: --
1157: x_po_header_id := wf_engine.GetItemAttrNumber( itemtype => itemtype,
1158: itemkey => itemkey,
1159: aname => 'PO_HEADER_ID');
1160:
1161: x_org_id := wf_engine.GetItemAttrNumber( itemtype => itemtype,

Line 1161: x_org_id := wf_engine.GetItemAttrNumber( itemtype => itemtype,

1157: x_po_header_id := wf_engine.GetItemAttrNumber( itemtype => itemtype,
1158: itemkey => itemkey,
1159: aname => 'PO_HEADER_ID');
1160:
1161: x_org_id := wf_engine.GetItemAttrNumber( itemtype => itemtype,
1162: itemkey => itemkey,
1163: aname => 'ORG_ID');
1164: setOrgCtx(x_org_id);
1165:

Line 1167: x_requester_id := wf_engine.GetItemAttrNumber( itemtype => itemtype,

1163: aname => 'ORG_ID');
1164: setOrgCtx(x_org_id);
1165:
1166:
1167: x_requester_id := wf_engine.GetItemAttrNumber( itemtype => itemtype,
1168: itemkey => itemkey,
1169: aname => 'REQUESTER_ID');
1170:
1171: x_exp_receipt_date := wf_engine.GetItemAttrDate ( itemtype => itemtype,

Line 1171: x_exp_receipt_date := wf_engine.GetItemAttrDate ( itemtype => itemtype,

1167: x_requester_id := wf_engine.GetItemAttrNumber( itemtype => itemtype,
1168: itemkey => itemkey,
1169: aname => 'REQUESTER_ID');
1170:
1171: x_exp_receipt_date := wf_engine.GetItemAttrDate ( itemtype => itemtype,
1172: itemkey => itemkey,
1173: aname => 'DUE_DATE');
1174:
1175:

Line 1197: wf_engine.SetItemAttrText ( itemtype => Itemtype,

1193:
1194: -- Retrieve buyer username and display name.
1195: -- Store them to the workflow process
1196:
1197: wf_engine.SetItemAttrText ( itemtype => Itemtype,
1198: itemkey => Itemkey,
1199: aname => 'PO_NUMBER',
1200: avalue => x_po_number );
1201:

Line 1202: wf_engine.SetItemAttrNumber ( itemtype => ItemType,

1198: itemkey => Itemkey,
1199: aname => 'PO_NUMBER',
1200: avalue => x_po_number );
1201:
1202: wf_engine.SetItemAttrNumber ( itemtype => ItemType,
1203: itemkey => Itemkey,
1204: aname => 'BUYER_ID',
1205: avalue => x_buyer_id );
1206:

Line 1212: wf_engine.SetItemAttrText ( itemtype => Itemtype,

1208: p_orig_system_id => x_buyer_id,
1209: p_name => x_buyer_username,
1210: p_display_name => x_buyer_disp_name);
1211:
1212: wf_engine.SetItemAttrText ( itemtype => Itemtype,
1213: itemkey => Itemkey,
1214: aname => 'BUYER_USERNAME',
1215: avalue => x_buyer_username );
1216:

Line 1217: wf_engine.SetItemAttrText ( itemtype => Itemtype,

1213: itemkey => Itemkey,
1214: aname => 'BUYER_USERNAME',
1215: avalue => x_buyer_username );
1216:
1217: wf_engine.SetItemAttrText ( itemtype => Itemtype,
1218: itemkey => Itemkey,
1219: aname => 'BUYER_DISP_NAME',
1220: avalue => x_buyer_disp_name );
1221:

Line 1223: wf_engine.SetItemAttrText ( itemtype => Itemtype,

1219: aname => 'BUYER_DISP_NAME',
1220: avalue => x_buyer_disp_name );
1221:
1222:
1223: wf_engine.SetItemAttrText ( itemtype => Itemtype,
1224: itemkey => Itemkey,
1225: aname => 'SUPPLIER_DISP_NAME',
1226: avalue => x_supplier_name );
1227:

Line 1229: wf_engine.SetItemAttrText ( itemtype => Itemtype,

1225: aname => 'SUPPLIER_DISP_NAME',
1226: avalue => x_supplier_name );
1227:
1228:
1229: wf_engine.SetItemAttrText ( itemtype => Itemtype,
1230: itemkey => Itemkey,
1231: aname => 'NOTE_TO_RECEIVER',
1232: avalue => x_note_to_receiver );
1233:

Line 1295: x_is_int_req := wf_engine.GetItemAttrText(itemtype,itemkey,'IS_INT_REQ');

1291: begin
1292:
1293: --ash_debug.debug('Is_Internal_Req','1');
1294:
1295: x_is_int_req := wf_engine.GetItemAttrText(itemtype,itemkey,'IS_INT_REQ');
1296: -- ash_debug.debug('Is_Internal_Req value of int req ',x_is_int_req);
1297:
1298:
1299: if x_is_int_req = 'Y' then

Line 1351: x_so_header_id := wf_engine.GetItemAttrNumber( itemtype => itemtype,

1347:
1348: IF ( funmode = 'RUN' ) THEN
1349: --
1350: --
1351: x_so_header_id := wf_engine.GetItemAttrNumber( itemtype => itemtype,
1352: itemkey => itemkey,
1353: aname => 'SO_HEADER_ID');
1354:
1355: x_org_id := wf_engine.GetItemAttrNumber( itemtype => itemtype,

Line 1355: x_org_id := wf_engine.GetItemAttrNumber( itemtype => itemtype,

1351: x_so_header_id := wf_engine.GetItemAttrNumber( itemtype => itemtype,
1352: itemkey => itemkey,
1353: aname => 'SO_HEADER_ID');
1354:
1355: x_org_id := wf_engine.GetItemAttrNumber( itemtype => itemtype,
1356: itemkey => itemkey,
1357: aname => 'ORG_ID');
1358: setOrgCtx(x_org_id);
1359:

Line 1360: x_requester_id := wf_engine.GetItemAttrNumber( itemtype => itemtype,

1356: itemkey => itemkey,
1357: aname => 'ORG_ID');
1358: setOrgCtx(x_org_id);
1359:
1360: x_requester_id := wf_engine.GetItemAttrNumber( itemtype => itemtype,
1361: itemkey => itemkey,
1362: aname => 'REQUESTER_ID');
1363:
1364: x_exp_receipt_date := wf_engine.GetItemAttrDate ( itemtype => itemtype,

Line 1364: x_exp_receipt_date := wf_engine.GetItemAttrDate ( itemtype => itemtype,

1360: x_requester_id := wf_engine.GetItemAttrNumber( itemtype => itemtype,
1361: itemkey => itemkey,
1362: aname => 'REQUESTER_ID');
1363:
1364: x_exp_receipt_date := wf_engine.GetItemAttrDate ( itemtype => itemtype,
1365: itemkey => itemkey,
1366: aname => 'DUE_DATE');
1367:
1368:

Line 1381: wf_engine.SetItemAttrText ( itemtype => Itemtype,

1377:
1378: -- Retrieve buyer username and display name.
1379: -- Store them to the workflow process
1380:
1381: wf_engine.SetItemAttrText ( itemtype => Itemtype,
1382: itemkey => Itemkey,
1383: aname => 'SO_NUMBER',
1384: avalue => x_so_number );
1385:

Line 1454: x_requester_id := wf_engine.GetItemAttrNumber(itemtype => itemtype,

1450: BEGIN
1451:
1452: IF ( funmode = 'RUN' ) THEN
1453: --
1454: x_requester_id := wf_engine.GetItemAttrNumber(itemtype => itemtype,
1455: itemkey => itemkey,
1456: aname => 'REQUESTER_ID');
1457:
1458: x_po_header_id := wf_engine.GetItemAttrNumber(itemtype => itemtype,

Line 1458: x_po_header_id := wf_engine.GetItemAttrNumber(itemtype => itemtype,

1454: x_requester_id := wf_engine.GetItemAttrNumber(itemtype => itemtype,
1455: itemkey => itemkey,
1456: aname => 'REQUESTER_ID');
1457:
1458: x_po_header_id := wf_engine.GetItemAttrNumber(itemtype => itemtype,
1459: itemkey => itemkey,
1460: aname => 'PO_HEADER_ID');
1461:
1462: x_org_id := wf_engine.GetItemAttrNumber(itemtype => itemtype,

Line 1462: x_org_id := wf_engine.GetItemAttrNumber(itemtype => itemtype,

1458: x_po_header_id := wf_engine.GetItemAttrNumber(itemtype => itemtype,
1459: itemkey => itemkey,
1460: aname => 'PO_HEADER_ID');
1461:
1462: x_org_id := wf_engine.GetItemAttrNumber(itemtype => itemtype,
1463: itemkey => itemkey,
1464: aname => 'ORG_ID');
1465:
1466: setOrgCtx(x_org_id);

Line 1468: x_exp_receipt_date := wf_engine.GetItemAttrDate ( itemtype => itemtype,

1464: aname => 'ORG_ID');
1465:
1466: setOrgCtx(x_org_id);
1467:
1468: x_exp_receipt_date := wf_engine.GetItemAttrDate ( itemtype => itemtype,
1469: itemkey => itemkey,
1470: aname => 'DUE_DATE');
1471:
1472:

Line 1487: wf_engine.SetItemAttrText ( itemtype => itemtype,

1483: x_Rcv_Order_url := x_Rcv_Order_url || 'porOrderTypeCode=PO' || '&'
1484: || 'porDestOrgId=' || to_char(x_org_id)||'&'||'NtfId=-'||'&'||'#NID-';
1485:
1486: --
1487: wf_engine.SetItemAttrText ( itemtype => itemtype,
1488: itemkey => itemkey,
1489: aname => 'RCV_ORDERS_URL',
1490: avalue => x_Rcv_Order_URL );
1491: --

Line 1529: x_requester_id := wf_engine.GetItemAttrNumber(itemtype => itemtype,

1525: BEGIN
1526:
1527: IF ( funmode = 'RUN' ) THEN
1528: --
1529: x_requester_id := wf_engine.GetItemAttrNumber(itemtype => itemtype,
1530: itemkey => itemkey,
1531: aname => 'REQUESTER_ID');
1532:
1533: x_so_header_id := wf_engine.GetItemAttrNumber(itemtype => itemtype,

Line 1533: x_so_header_id := wf_engine.GetItemAttrNumber(itemtype => itemtype,

1529: x_requester_id := wf_engine.GetItemAttrNumber(itemtype => itemtype,
1530: itemkey => itemkey,
1531: aname => 'REQUESTER_ID');
1532:
1533: x_so_header_id := wf_engine.GetItemAttrNumber(itemtype => itemtype,
1534: itemkey => itemkey,
1535: aname => 'SO_HEADER_ID');
1536:
1537: x_req_header_id := wf_engine.GetItemAttrNumber(itemtype => itemtype,

Line 1537: x_req_header_id := wf_engine.GetItemAttrNumber(itemtype => itemtype,

1533: x_so_header_id := wf_engine.GetItemAttrNumber(itemtype => itemtype,
1534: itemkey => itemkey,
1535: aname => 'SO_HEADER_ID');
1536:
1537: x_req_header_id := wf_engine.GetItemAttrNumber(itemtype => itemtype,
1538: itemkey => itemkey,
1539: aname => 'REQ_HEADER_ID');
1540:
1541: x_org_id := wf_engine.GetItemAttrNumber(itemtype => itemtype,

Line 1541: x_org_id := wf_engine.GetItemAttrNumber(itemtype => itemtype,

1537: x_req_header_id := wf_engine.GetItemAttrNumber(itemtype => itemtype,
1538: itemkey => itemkey,
1539: aname => 'REQ_HEADER_ID');
1540:
1541: x_org_id := wf_engine.GetItemAttrNumber(itemtype => itemtype,
1542: itemkey => itemkey,
1543: aname => 'ORG_ID');
1544:
1545:

Line 1550: x_exp_receipt_date := wf_engine.GetItemAttrDate ( itemtype => itemtype,

1546: -- Setup the organization context for the multi-org environment
1547:
1548: setOrgCtx(x_org_id);
1549:
1550: x_exp_receipt_date := wf_engine.GetItemAttrDate ( itemtype => itemtype,
1551: itemkey => itemkey,
1552: aname => 'DUE_DATE');
1553:
1554: x_Rcv_Order_url := l_base_href || '/OA_HTML/OA.jsp?OAFunc=ICX_POR_LAUNCH_IP' || '&' || 'porOrderHeaderId=' || to_char(x_so_header_id) || '&' || 'porMode=confirmReceipt' ;

Line 1570: wf_engine.SetItemAttrText ( itemtype => itemtype,

1566:
1567: -- ash_debug.debug('Get_Rcv_Int_Order_URL org id',x_org_id);
1568: -- ash_debug.debug('Get_Rcv_Int_Order_URL org id',x_Rcv_Order_url);
1569: --
1570: wf_engine.SetItemAttrText ( itemtype => itemtype,
1571: itemkey => itemkey,
1572: aname => 'RCV_ORDERS_URL',
1573: avalue => x_Rcv_Order_URL );
1574: --

Line 1777: x_po_header_id := wf_engine.GetItemAttrNumber( itemtype => itemtype,

1773: BEGIN
1774:
1775: IF ( funmode = 'RUN' ) THEN
1776: --
1777: x_po_header_id := wf_engine.GetItemAttrNumber( itemtype => itemtype,
1778: itemkey => itemkey,
1779: aname => 'PO_HEADER_ID');
1780:
1781: -- Setup the organization context for the multi-org environment

Line 1783: x_org_id := wf_engine.GetItemAttrNumber(itemtype => itemtype,

1779: aname => 'PO_HEADER_ID');
1780:
1781: -- Setup the organization context for the multi-org environment
1782:
1783: x_org_id := wf_engine.GetItemAttrNumber(itemtype => itemtype,
1784: itemkey => itemkey,
1785: aname => 'ORG_ID');
1786:
1787: -- Setup the organization context for the multi-org environment

Line 1792: x_requester_username := wf_engine.GetItemAttrText ( itemtype => itemtype,

1788:
1789: setOrgCtx(x_org_id);
1790:
1791: --Use the requester username to be passed to the initalize api
1792: x_requester_username := wf_engine.GetItemAttrText ( itemtype => itemtype,
1793: itemkey => itemkey,
1794: aname => 'REQUESTER_USERNAME');
1795: initialize(x_requester_username,x_org_id);
1796:

Line 1800: x_requester_id := wf_engine.GetItemAttrNumber( itemtype => itemtype,

1796:
1797: /** rewrite after initialize **/
1798: x_allow_inv_dest_receipts := FND_PROFILE.value('POR_ALLOW_INV_DEST_RECEIPTS');
1799:
1800: x_requester_id := wf_engine.GetItemAttrNumber( itemtype => itemtype,
1801: itemkey => itemkey,
1802: aname => 'REQUESTER_ID');
1803:
1804:

Line 1805: x_exp_receipt_date := wf_engine.GetItemAttrDate ( itemtype => itemtype,

1801: itemkey => itemkey,
1802: aname => 'REQUESTER_ID');
1803:
1804:
1805: x_exp_receipt_date := wf_engine.GetItemAttrDate ( itemtype => itemtype,
1806: itemkey => itemkey,
1807: aname => 'DUE_DATE');
1808:
1809: --

Line 1948: wf_engine.SetItemAttrText ( itemtype => Itemtype,

1944:
1945: ELSE
1946: get_txn_error_message(x_group_id, x_RCV_txns_rc, x_rcv_trans_status, x_message_token);
1947:
1948: wf_engine.SetItemAttrText ( itemtype => Itemtype,
1949: itemkey => Itemkey,
1950: aname => 'RCV_TRANS_STATUS',
1951: avalue => x_rcv_trans_status );
1952:

Line 1953: wf_engine.SetItemAttrText ( itemtype => Itemtype,

1949: itemkey => Itemkey,
1950: aname => 'RCV_TRANS_STATUS',
1951: avalue => x_rcv_trans_status );
1952:
1953: wf_engine.SetItemAttrText ( itemtype => Itemtype,
1954: itemkey => Itemkey,
1955: aname => 'RCV_ERR_MSG_TOKEN',
1956: avalue => x_message_token );
1957:

Line 2053: wf_engine.SetItemAttrText ( itemtype => Itemtype,

2049: -- Insert to Receiving Transaction Interface failed
2050: x_rcv_trans_status := 'RCV_RCPT_INSERT_FAILED';
2051: END IF;
2052:
2053: wf_engine.SetItemAttrText ( itemtype => Itemtype,
2054: itemkey => Itemkey,
2055: aname => 'RCV_TRANS_STATUS',
2056: avalue => x_rcv_trans_status );
2057:

Line 2224: old_rev_num := wf_engine.GetItemAttrNumber ( itemtype => x_wf_itemtype,

2220: x_item_exists varchar2(1) := 'Y';
2221: begin
2222: begin
2223: /** get the attribute for that notification.**/
2224: old_rev_num := wf_engine.GetItemAttrNumber ( itemtype => x_wf_itemtype,
2225: itemkey => x_wf_itemkey,
2226: aname => 'PO_REVISION_NUM');
2227: x_item_exists := 'Y';
2228: exception

Line 2428: x_org_id := wf_engine.GetItemAttrNumber( itemtype => x_item_type,

2424: x_progress VARCHAR2(1000):= '001';
2425: BEGIN
2426:
2427:
2428: x_org_id := wf_engine.GetItemAttrNumber( itemtype => x_item_type,
2429: itemkey => x_item_key,
2430: aname => 'ORG_ID');
2431:
2432: -- Setup the organization context for the multi-org environment

Line 2435: x_requester_id := wf_engine.GetItemAttrNumber( itemtype => x_item_type,

2431:
2432: -- Setup the organization context for the multi-org environment
2433: setOrgCtx(x_org_id);
2434:
2435: x_requester_id := wf_engine.GetItemAttrNumber( itemtype => x_item_type,
2436: itemkey => x_item_key,
2437: aname => 'REQUESTER_ID');
2438:
2439: x_exp_receipt_date := wf_engine.GetItemAttrDate ( itemtype => x_item_type,

Line 2439: x_exp_receipt_date := wf_engine.GetItemAttrDate ( itemtype => x_item_type,

2435: x_requester_id := wf_engine.GetItemAttrNumber( itemtype => x_item_type,
2436: itemkey => x_item_key,
2437: aname => 'REQUESTER_ID');
2438:
2439: x_exp_receipt_date := wf_engine.GetItemAttrDate ( itemtype => x_item_type,
2440: itemkey => x_item_key,
2441: aname => 'DUE_DATE');
2442:
2443: x_is_int_req := wf_engine.GetItemAttrText ( itemtype => x_item_type,

Line 2443: x_is_int_req := wf_engine.GetItemAttrText ( itemtype => x_item_type,

2439: x_exp_receipt_date := wf_engine.GetItemAttrDate ( itemtype => x_item_type,
2440: itemkey => x_item_key,
2441: aname => 'DUE_DATE');
2442:
2443: x_is_int_req := wf_engine.GetItemAttrText ( itemtype => x_item_type,
2444: itemkey => x_item_key,
2445: aname => 'IS_INT_REQ');
2446: begin
2447: x_progress := '002 x_is_int_req is ' || x_is_int_req || 'x_allow_inv_dest_receipts: '|| x_allow_inv_dest_receipts;

Line 2453: x_so_header_id := wf_engine.GetItemAttrNumber( itemtype => x_item_type,

2449: po_wf_debug_pkg.insert_debug(x_item_type, x_item_key, x_progress);
2450: END IF;
2451: if x_is_int_req = 'Y' then
2452:
2453: x_so_header_id := wf_engine.GetItemAttrNumber( itemtype => x_item_type,
2454: itemkey => x_item_key,
2455: aname => 'SO_HEADER_ID');
2456: -- ash_debug.debug('get_count x_so_header_id ', x_so_header_id);
2457:

Line 2487: x_po_header_id := wf_engine.GetItemAttrNumber( itemtype => x_item_type,

2483: -- ash_debug.debug('get_count x_so_header_id ', x_count);
2484:
2485: else
2486:
2487: x_po_header_id := wf_engine.GetItemAttrNumber( itemtype => x_item_type,
2488: itemkey => x_item_key,
2489: aname => 'PO_HEADER_ID');
2490:
2491: --

Line 2533: x_skip_distribution_updation := wf_engine.GetActivityAttrText(itemtype,

2529: x_progress VARCHAR2(1000):= '001';
2530: BEGIN
2531: -- Get the activity attribute text. This value would be 'Y' only if called from receive upto
2532: -- amount invoiced notification. Pass the value toto get_count which would get percolated down
2533: x_skip_distribution_updation := wf_engine.GetActivityAttrText(itemtype,
2534: itemkey,
2535: actid,
2536: 'IS_FROM_RCV_UPTO_AMT_INVOICED');
2537:

Line 2546: resultout := wf_engine.eng_completed || ':' || 'N';

2542: END IF;
2543: -- ash_debug.debug('does_item_exist x_count ' , x_count);
2544:
2545: IF x_count = 0 THEN
2546: resultout := wf_engine.eng_completed || ':' || 'N';
2547: x_resultout := 'N';
2548: ELSE /* the reminder should have an updated line count */
2549:
2550: -- ash_debug.debug('does_item_exist x_count 1' , x_count);

Line 2552: resultout := wf_engine.eng_completed || ':' || 'Y';

2548: ELSE /* the reminder should have an updated line count */
2549:
2550: -- ash_debug.debug('does_item_exist x_count 1' , x_count);
2551:
2552: resultout := wf_engine.eng_completed || ':' || 'Y';
2553: x_resultout := 'Y';
2554:
2555: -- ash_debug.debug('does_item_exist resultut ' , resultout);
2556: END IF;

Line 2575: l_po_header_id := wf_engine.GetItemAttrNumber(

2571: IS
2572: l_expDate DATE;
2573: l_po_header_id NUMBER;
2574: begin
2575: l_po_header_id := wf_engine.GetItemAttrNumber(
2576: itemtype => itemtype,
2577: itemkey => itemkey,
2578: aname => 'PO_HEADER_ID');
2579:

Line 2585: resultout := wf_engine.eng_completed || ':' || 'Y';

2581: into l_expDate from POR_RCV_ALL_ITEMS_V1 where po_header_id= l_po_header_id;
2582: If (l_expDate is NULL
2583: or trunc(l_expDate + 1) <= trunc(SYSDATE))
2584: then
2585: resultout := wf_engine.eng_completed || ':' || 'Y';
2586: else
2587: resultout := wf_engine.eng_completed || ':' || 'N';
2588: end if;
2589:

Line 2587: resultout := wf_engine.eng_completed || ':' || 'N';

2583: or trunc(l_expDate + 1) <= trunc(SYSDATE))
2584: then
2585: resultout := wf_engine.eng_completed || ':' || 'Y';
2586: else
2587: resultout := wf_engine.eng_completed || ':' || 'N';
2588: end if;
2589:
2590: END is_expDate_valid;
2591:

Line 2636: x_requester_id := wf_engine.GetItemAttrNumber(itemtype => itemtype,

2632: BEGIN
2633:
2634: IF ( funmode = 'RUN' ) THEN
2635: --
2636: x_requester_id := wf_engine.GetItemAttrNumber(itemtype => itemtype,
2637: itemkey => itemkey,
2638: aname => 'REQUESTER_ID');
2639:
2640: x_header_id := wf_engine.GetItemAttrNumber(itemtype => itemtype,

Line 2640: x_header_id := wf_engine.GetItemAttrNumber(itemtype => itemtype,

2636: x_requester_id := wf_engine.GetItemAttrNumber(itemtype => itemtype,
2637: itemkey => itemkey,
2638: aname => 'REQUESTER_ID');
2639:
2640: x_header_id := wf_engine.GetItemAttrNumber(itemtype => itemtype,
2641: itemkey => itemkey,
2642: aname => 'SO_HEADER_ID');
2643:
2644: x_org_id := wf_engine.GetItemAttrNumber(itemtype => itemtype,

Line 2644: x_org_id := wf_engine.GetItemAttrNumber(itemtype => itemtype,

2640: x_header_id := wf_engine.GetItemAttrNumber(itemtype => itemtype,
2641: itemkey => itemkey,
2642: aname => 'SO_HEADER_ID');
2643:
2644: x_org_id := wf_engine.GetItemAttrNumber(itemtype => itemtype,
2645: itemkey => itemkey,
2646: aname => 'ORG_ID');
2647: setOrgCtx(x_org_id);
2648:

Line 2649: x_exp_receipt_date := wf_engine.GetItemAttrDate ( itemtype => itemtype,

2645: itemkey => itemkey,
2646: aname => 'ORG_ID');
2647: setOrgCtx(x_org_id);
2648:
2649: x_exp_receipt_date := wf_engine.GetItemAttrDate ( itemtype => itemtype,
2650: itemkey => itemkey,
2651: aname => 'DUE_DATE');
2652:
2653:

Line 2667: wf_engine.SetItemAttrText ( itemtype => itemtype,

2663:
2664: x_Rcv_Order_url := x_Rcv_Order_url || 'porOrderTypeCode=REQ' || '&'
2665: || 'porDestOrgId=' || to_char(x_org_id);
2666:
2667: wf_engine.SetItemAttrText ( itemtype => itemtype,
2668: itemkey => itemkey,
2669: aname => 'RCV_ORDERS_URL',
2670: avalue => x_Rcv_Order_URL );
2671: --

Line 2726: x_org_id := wf_engine.GetItemAttrNumber(itemtype => itemtype,

2722:
2723:
2724: IF ( funmode = 'RUN' ) THEN
2725:
2726: x_org_id := wf_engine.GetItemAttrNumber(itemtype => itemtype,
2727: itemkey => itemkey,
2728: aname => 'ORG_ID');
2729:
2730: -- Setup the organization context for the multi-org environment

Line 2739: x_requester_id := wf_engine.GetItemAttrNumber( itemtype => itemtype,

2735: is not an active employee then the notification had been sent to the buyer
2736: and in that case get the buyer's manager for time out notification.
2737: */
2738:
2739: x_requester_id := wf_engine.GetItemAttrNumber( itemtype => itemtype,
2740: itemkey => itemkey,
2741: aname => 'REQUESTER_ID');
2742: Begin
2743:

Line 2757: x_requester_id := wf_engine.GetItemAttrNumber( itemtype => itemtype,

2753: x_requester_current := FALSE;
2754: End;
2755:
2756: If (x_requester_current = FALSE) then
2757: x_requester_id := wf_engine.GetItemAttrNumber( itemtype => itemtype,
2758: itemkey => itemkey,
2759: aname => 'BUYER_ID');
2760: Else
2761: x_requester_id := wf_engine.GetItemAttrNumber( itemtype => itemtype,

Line 2761: x_requester_id := wf_engine.GetItemAttrNumber( itemtype => itemtype,

2757: x_requester_id := wf_engine.GetItemAttrNumber( itemtype => itemtype,
2758: itemkey => itemkey,
2759: aname => 'BUYER_ID');
2760: Else
2761: x_requester_id := wf_engine.GetItemAttrNumber( itemtype => itemtype,
2762: itemkey => itemkey,
2763: aname => 'REQUESTER_ID');
2764: End if;
2765:

Line 2777: wf_engine.SetItemAttrNumber ( itemtype => ItemType,

2773: Exception
2774: When no_data_found then null;
2775: End;
2776:
2777: wf_engine.SetItemAttrNumber ( itemtype => ItemType,
2778: itemkey => itemkey,
2779: aname => 'MANAGER_ID',
2780: avalue => x_manager_id );
2781:

Line 2788: wf_engine.SetItemAttrText ( itemtype => itemtype,

2784: p_orig_system_id => x_manager_id,
2785: p_name => x_manager_username,
2786: p_display_name => x_manager_disp_name);
2787:
2788: wf_engine.SetItemAttrText ( itemtype => itemtype,
2789: itemkey => itemkey,
2790: aname => 'MANAGER_USERNAME',
2791: avalue => x_manager_username );
2792:

Line 2793: wf_engine.SetItemAttrText ( itemtype => itemtype,

2789: itemkey => itemkey,
2790: aname => 'MANAGER_USERNAME',
2791: avalue => x_manager_username );
2792:
2793: wf_engine.SetItemAttrText ( itemtype => itemtype,
2794: itemkey => itemkey,
2795: aname => 'MANAGER_DISP_NAME',
2796: avalue => x_manager_disp_name );
2797:

Line 2851: x_header_id := wf_engine.GetItemAttrNumber( itemtype => itemtype,

2847:
2848: IF ( funmode = 'RUN' ) THEN
2849: --
2850:
2851: x_header_id := wf_engine.GetItemAttrNumber( itemtype => itemtype,
2852: itemkey => itemkey,
2853: aname => 'SO_HEADER_ID');
2854: -- Setup the organization context for the multi-org environment
2855:

Line 2856: x_org_id := wf_engine.GetItemAttrNumber( itemtype => itemtype,

2852: itemkey => itemkey,
2853: aname => 'SO_HEADER_ID');
2854: -- Setup the organization context for the multi-org environment
2855:
2856: x_org_id := wf_engine.GetItemAttrNumber( itemtype => itemtype,
2857: itemkey => itemkey,
2858: aname => 'ORG_ID');
2859:
2860: -- Use the requester username to be passed to initialize

Line 2861: x_requester_username := wf_engine.GetItemAttrText ( itemtype => itemtype,

2857: itemkey => itemkey,
2858: aname => 'ORG_ID');
2859:
2860: -- Use the requester username to be passed to initialize
2861: x_requester_username := wf_engine.GetItemAttrText ( itemtype => itemtype,
2862: itemkey => itemkey,
2863: aname => 'REQUESTER_USERNAME');
2864:
2865: PORCPTWF.initialize(x_requester_username,x_org_id);

Line 2871: x_requester_id := wf_engine.GetItemAttrNumber( itemtype => itemtype,

2867: /** rewrite after initialize **/
2868: x_allow_inv_dest_receipts := FND_PROFILE.value('POR_ALLOW_INV_DEST_RECEIPTS');
2869:
2870:
2871: x_requester_id := wf_engine.GetItemAttrNumber( itemtype => itemtype,
2872: itemkey => itemkey,
2873: aname => 'REQUESTER_ID');
2874:
2875:

Line 2876: x_exp_receipt_date := wf_engine.GetItemAttrDate ( itemtype => itemtype,

2872: itemkey => itemkey,
2873: aname => 'REQUESTER_ID');
2874:
2875:
2876: x_exp_receipt_date := wf_engine.GetItemAttrDate ( itemtype => itemtype,
2877: itemkey => itemkey,
2878: aname => 'DUE_DATE');
2879:
2880:

Line 2982: wf_engine.SetItemAttrText ( itemtype => Itemtype,

2978:
2979: ELSE
2980: get_txn_error_message(x_group_id, x_RCV_txns_rc, x_rcv_trans_status, x_message_token);
2981:
2982: wf_engine.SetItemAttrText ( itemtype => Itemtype,
2983: itemkey => Itemkey,
2984: aname => 'RCV_TRANS_STATUS',
2985: avalue => x_rcv_trans_status );
2986:

Line 2987: wf_engine.SetItemAttrText ( itemtype => Itemtype,

2983: itemkey => Itemkey,
2984: aname => 'RCV_TRANS_STATUS',
2985: avalue => x_rcv_trans_status );
2986:
2987: wf_engine.SetItemAttrText ( itemtype => Itemtype,
2988: itemkey => Itemkey,
2989: aname => 'RCV_ERR_MSG_TOKEN',
2990: avalue => x_message_token );
2991:

Line 3065: wf_engine.SetItemAttrText ( itemtype => Itemtype,

3061: x_rcv_trans_status := 'RCV_RCPT_INSERT_FAILED';
3062:
3063: END IF;
3064:
3065: wf_engine.SetItemAttrText ( itemtype => Itemtype,
3066: itemkey => Itemkey,
3067: aname => 'RCV_TRANS_STATUS',
3068: avalue => x_rcv_trans_status );
3069:

Line 3112: x_is_int_req := wf_engine.GetItemAttrText( itemtype => x_item_type,

3108: nl VARCHAR2(1) := fnd_global.newline;
3109: l_base_href VARCHAR(2000) := fnd_profile.value('APPS_FRAMEWORK_AGENT');
3110: BEGIN
3111:
3112: x_is_int_req := wf_engine.GetItemAttrText( itemtype => x_item_type,
3113: itemkey => x_item_key,
3114: aname => 'IS_INT_REQ');
3115:
3116: if x_is_int_req is NULL then

Line 3122: x_number := wf_engine.GetItemAttrText( itemtype => x_item_type,

3118: end if;
3119:
3120: if x_is_int_req = 'Y' then
3121:
3122: x_number := wf_engine.GetItemAttrText( itemtype => x_item_type,
3123: itemkey => x_item_key,
3124: aname => 'SO_NUMBER');
3125:
3126: else -- Purchase Requisition

Line 3129: x_number := wf_engine.GetItemAttrText( itemtype => x_item_type,

3125:
3126: else -- Purchase Requisition
3127:
3128:
3129: x_number := wf_engine.GetItemAttrText( itemtype => x_item_type,
3130: itemkey => x_item_key,
3131: aname => 'PO_NUMBER');
3132:
3133: x_buyer_name := wf_engine.GetItemAttrText(itemtype => x_item_type,

Line 3133: x_buyer_name := wf_engine.GetItemAttrText(itemtype => x_item_type,

3129: x_number := wf_engine.GetItemAttrText( itemtype => x_item_type,
3130: itemkey => x_item_key,
3131: aname => 'PO_NUMBER');
3132:
3133: x_buyer_name := wf_engine.GetItemAttrText(itemtype => x_item_type,
3134: itemkey => x_item_key,
3135: aname => 'BUYER_DISP_NAME');
3136:
3137:

Line 3138: x_supplier_name := wf_engine.GetItemAttrText( itemtype => x_item_type,

3134: itemkey => x_item_key,
3135: aname => 'BUYER_DISP_NAME');
3136:
3137:
3138: x_supplier_name := wf_engine.GetItemAttrText( itemtype => x_item_type,
3139: itemkey => x_item_key,
3140: aname => 'SUPPLIER_DISP_NAME');
3141:
3142: end if;

Line 3144: x_note_to_receiver := wf_engine.GetItemAttrText( itemtype => x_item_type,

3140: aname => 'SUPPLIER_DISP_NAME');
3141:
3142: end if;
3143:
3144: x_note_to_receiver := wf_engine.GetItemAttrText( itemtype => x_item_type,
3145: itemkey => x_item_key,
3146: aname => 'NOTE_TO_RECEIVER');
3147:
3148: x_due_date := wf_engine.GetItemAttrDate( itemtype => x_item_type,

Line 3148: x_due_date := wf_engine.GetItemAttrDate( itemtype => x_item_type,

3144: x_note_to_receiver := wf_engine.GetItemAttrText( itemtype => x_item_type,
3145: itemkey => x_item_key,
3146: aname => 'NOTE_TO_RECEIVER');
3147:
3148: x_due_date := wf_engine.GetItemAttrDate( itemtype => x_item_type,
3149: itemkey => x_item_key,
3150: aname => 'DUE_DATE');
3151:
3152:

Line 3436: x_is_int_req := wf_engine.GetItemAttrText( itemtype => l_item_type,

3432: l_display_url := substr(l_temp, instr(l_temp, ':') + 1,
3433: length(l_temp) - 2);
3434:
3435:
3436: x_is_int_req := wf_engine.GetItemAttrText( itemtype => l_item_type,
3437: itemkey => l_item_key,
3438: aname => 'IS_INT_REQ');
3439:
3440: -- ash_debug.debug('GET_PO_RCV_NOTIF_MSG value of IS_INT_REQ', x_is_int_req);

Line 3444: x_header_id := wf_engine.GetItemAttrNumber( itemtype => l_item_type,

3440: -- ash_debug.debug('GET_PO_RCV_NOTIF_MSG value of IS_INT_REQ', x_is_int_req);
3441:
3442: if x_is_int_req = 'Y' then
3443:
3444: x_header_id := wf_engine.GetItemAttrNumber( itemtype => l_item_type,
3445: itemkey => l_item_key,
3446: aname => 'SO_HEADER_ID');
3447:
3448: else

Line 3459: x_org_id := wf_engine.GetItemAttrNumber( itemtype => l_item_type,

3455: end if;
3456:
3457: -- ash_debug.debug('GET_PO_RCV_NOTIF_MSG value of header_is', x_header_id);
3458:
3459: x_org_id := wf_engine.GetItemAttrNumber( itemtype => l_item_type,
3460: itemkey => l_item_key,
3461: aname => 'ORG_ID');
3462:
3463: setOrgCtx(x_org_id);

Line 3467: x_requester_id := wf_engine.GetItemAttrNumber( itemtype => l_item_type,

3463: setOrgCtx(x_org_id);
3464:
3465: -- ash_debug.debug('GET_PO_RCV_NOTIF_MSG value of org_id', x_org_id);
3466:
3467: x_requester_id := wf_engine.GetItemAttrNumber( itemtype => l_item_type,
3468: itemkey => l_item_key,
3469: aname => 'REQUESTER_ID');
3470:
3471: x_exp_receipt_date := wf_engine.GetItemAttrDate ( itemtype => l_item_type,

Line 3471: x_exp_receipt_date := wf_engine.GetItemAttrDate ( itemtype => l_item_type,

3467: x_requester_id := wf_engine.GetItemAttrNumber( itemtype => l_item_type,
3468: itemkey => l_item_key,
3469: aname => 'REQUESTER_ID');
3470:
3471: x_exp_receipt_date := wf_engine.GetItemAttrDate ( itemtype => l_item_type,
3472: itemkey => l_item_key,
3473: aname => 'DUE_DATE');
3474:
3475:

Line 3481: l_rcv_items_url := wf_engine.GetItemAttrText (itemtype => l_item_type,

3477: x_count := get_count(l_item_type,l_item_key);
3478:
3479: -- ash_debug.debug('GET_PO_RCV_NOTIF_MSG value of x_count', x_count);
3480:
3481: l_rcv_items_url := wf_engine.GetItemAttrText (itemtype => l_item_type,
3482: itemkey => l_item_key,
3483: aname => 'RCV_ORDERS_URL');
3484:
3485: l_rcv_items_url := '' ||