APPS.PORCPTWF dependencies on WF_ENGINE

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

1544: -- Setup the organization context for the multi-org environment
1545:
1546: setOrgCtx(x_org_id);
1547:
1548: x_exp_receipt_date := wf_engine.GetItemAttrDate ( itemtype => itemtype,
1549: itemkey => itemkey,
1550: aname => 'DUE_DATE');
1551:
1552: 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 1568: wf_engine.SetItemAttrText ( itemtype => itemtype,

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

2421:
2422: BEGIN
2423:
2424:
2425: x_org_id := wf_engine.GetItemAttrNumber( itemtype => x_item_type,
2426: itemkey => x_item_key,
2427: aname => 'ORG_ID');
2428:
2429: -- Setup the organization context for the multi-org environment

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

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

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

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

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

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

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

2443: begin
2444:
2445: if x_is_int_req = 'Y' then
2446:
2447: x_so_header_id := wf_engine.GetItemAttrNumber( itemtype => x_item_type,
2448: itemkey => x_item_key,
2449: aname => 'SO_HEADER_ID');
2450: -- ash_debug.debug('get_count x_so_header_id ', x_so_header_id);
2451:

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

2477: -- ash_debug.debug('get_count x_so_header_id ', x_count);
2478:
2479: else
2480:
2481: x_po_header_id := wf_engine.GetItemAttrNumber( itemtype => x_item_type,
2482: itemkey => x_item_key,
2483: aname => 'PO_HEADER_ID');
2484:
2485: --

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

2513:
2514: BEGIN
2515: -- Get the activity attribute text. This value would be 'Y' only if called from receive upto
2516: -- amount invoiced notification. Pass the value toto get_count which would get percolated down
2517: x_skip_distribution_updation := wf_engine.GetActivityAttrText(itemtype,
2518: itemkey,
2519: actid,
2520: 'IS_FROM_RCV_UPTO_AMT_INVOICED');
2521:

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

2523:
2524: -- ash_debug.debug('does_item_exist x_count ' , x_count);
2525:
2526: IF x_count = 0 THEN
2527: resultout := wf_engine.eng_completed || ':' || 'N';
2528: x_resultout := 'N';
2529: ELSE /* the reminder should have an updated line count */
2530:
2531: -- ash_debug.debug('does_item_exist x_count 1' , x_count);

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

2529: ELSE /* the reminder should have an updated line count */
2530:
2531: -- ash_debug.debug('does_item_exist x_count 1' , x_count);
2532:
2533: resultout := wf_engine.eng_completed || ':' || 'Y';
2534: x_resultout := 'Y';
2535:
2536: -- ash_debug.debug('does_item_exist resultut ' , resultout);
2537: END IF;

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

2587: BEGIN
2588:
2589: IF ( funmode = 'RUN' ) THEN
2590: --
2591: x_requester_id := wf_engine.GetItemAttrNumber(itemtype => itemtype,
2592: itemkey => itemkey,
2593: aname => 'REQUESTER_ID');
2594:
2595: x_header_id := wf_engine.GetItemAttrNumber(itemtype => itemtype,

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

2591: x_requester_id := wf_engine.GetItemAttrNumber(itemtype => itemtype,
2592: itemkey => itemkey,
2593: aname => 'REQUESTER_ID');
2594:
2595: x_header_id := wf_engine.GetItemAttrNumber(itemtype => itemtype,
2596: itemkey => itemkey,
2597: aname => 'SO_HEADER_ID');
2598:
2599: x_org_id := wf_engine.GetItemAttrNumber(itemtype => itemtype,

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

2595: x_header_id := wf_engine.GetItemAttrNumber(itemtype => itemtype,
2596: itemkey => itemkey,
2597: aname => 'SO_HEADER_ID');
2598:
2599: x_org_id := wf_engine.GetItemAttrNumber(itemtype => itemtype,
2600: itemkey => itemkey,
2601: aname => 'ORG_ID');
2602: setOrgCtx(x_org_id);
2603:

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

2600: itemkey => itemkey,
2601: aname => 'ORG_ID');
2602: setOrgCtx(x_org_id);
2603:
2604: x_exp_receipt_date := wf_engine.GetItemAttrDate ( itemtype => itemtype,
2605: itemkey => itemkey,
2606: aname => 'DUE_DATE');
2607:
2608:

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

2618:
2619: x_Rcv_Order_url := x_Rcv_Order_url || 'porOrderTypeCode=REQ' || '&'
2620: || 'porDestOrgId=' || to_char(x_org_id);
2621:
2622: wf_engine.SetItemAttrText ( itemtype => itemtype,
2623: itemkey => itemkey,
2624: aname => 'RCV_ORDERS_URL',
2625: avalue => x_Rcv_Order_URL );
2626: --

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

2677:
2678:
2679: IF ( funmode = 'RUN' ) THEN
2680:
2681: x_org_id := wf_engine.GetItemAttrNumber(itemtype => itemtype,
2682: itemkey => itemkey,
2683: aname => 'ORG_ID');
2684:
2685: -- Setup the organization context for the multi-org environment

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

2690: is not an active employee then the notification had been sent to the buyer
2691: and in that case get the buyer's manager for time out notification.
2692: */
2693:
2694: x_requester_id := wf_engine.GetItemAttrNumber( itemtype => itemtype,
2695: itemkey => itemkey,
2696: aname => 'REQUESTER_ID');
2697: Begin
2698:

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

2708: x_requester_current := FALSE;
2709: End;
2710:
2711: If (x_requester_current = FALSE) then
2712: x_requester_id := wf_engine.GetItemAttrNumber( itemtype => itemtype,
2713: itemkey => itemkey,
2714: aname => 'BUYER_ID');
2715: Else
2716: x_requester_id := wf_engine.GetItemAttrNumber( itemtype => itemtype,

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

2712: x_requester_id := wf_engine.GetItemAttrNumber( itemtype => itemtype,
2713: itemkey => itemkey,
2714: aname => 'BUYER_ID');
2715: Else
2716: x_requester_id := wf_engine.GetItemAttrNumber( itemtype => itemtype,
2717: itemkey => itemkey,
2718: aname => 'REQUESTER_ID');
2719: End if;
2720:

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

2728: Exception
2729: When no_data_found then null;
2730: End;
2731:
2732: wf_engine.SetItemAttrNumber ( itemtype => ItemType,
2733: itemkey => itemkey,
2734: aname => 'MANAGER_ID',
2735: avalue => x_manager_id );
2736:

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

2739: p_orig_system_id => x_manager_id,
2740: p_name => x_manager_username,
2741: p_display_name => x_manager_disp_name);
2742:
2743: wf_engine.SetItemAttrText ( itemtype => itemtype,
2744: itemkey => itemkey,
2745: aname => 'MANAGER_USERNAME',
2746: avalue => x_manager_username );
2747:

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

2744: itemkey => itemkey,
2745: aname => 'MANAGER_USERNAME',
2746: avalue => x_manager_username );
2747:
2748: wf_engine.SetItemAttrText ( itemtype => itemtype,
2749: itemkey => itemkey,
2750: aname => 'MANAGER_DISP_NAME',
2751: avalue => x_manager_disp_name );
2752:

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

2802:
2803: IF ( funmode = 'RUN' ) THEN
2804: --
2805:
2806: x_header_id := wf_engine.GetItemAttrNumber( itemtype => itemtype,
2807: itemkey => itemkey,
2808: aname => 'SO_HEADER_ID');
2809: -- Setup the organization context for the multi-org environment
2810:

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

2807: itemkey => itemkey,
2808: aname => 'SO_HEADER_ID');
2809: -- Setup the organization context for the multi-org environment
2810:
2811: x_org_id := wf_engine.GetItemAttrNumber( itemtype => itemtype,
2812: itemkey => itemkey,
2813: aname => 'ORG_ID');
2814:
2815: -- Use the requester username to be passed to initialize

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

2812: itemkey => itemkey,
2813: aname => 'ORG_ID');
2814:
2815: -- Use the requester username to be passed to initialize
2816: x_requester_username := wf_engine.GetItemAttrText ( itemtype => itemtype,
2817: itemkey => itemkey,
2818: aname => 'REQUESTER_USERNAME');
2819:
2820: PORCPTWF.initialize(x_requester_username,x_org_id);

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

2822: /** rewrite after initialize **/
2823: x_allow_inv_dest_receipts := FND_PROFILE.value('POR_ALLOW_INV_DEST_RECEIPTS');
2824:
2825:
2826: x_requester_id := wf_engine.GetItemAttrNumber( itemtype => itemtype,
2827: itemkey => itemkey,
2828: aname => 'REQUESTER_ID');
2829:
2830:

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

2827: itemkey => itemkey,
2828: aname => 'REQUESTER_ID');
2829:
2830:
2831: x_exp_receipt_date := wf_engine.GetItemAttrDate ( itemtype => itemtype,
2832: itemkey => itemkey,
2833: aname => 'DUE_DATE');
2834:
2835:

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

2933:
2934: ELSE
2935: get_txn_error_message(x_group_id, x_RCV_txns_rc, x_rcv_trans_status, x_message_token);
2936:
2937: wf_engine.SetItemAttrText ( itemtype => Itemtype,
2938: itemkey => Itemkey,
2939: aname => 'RCV_TRANS_STATUS',
2940: avalue => x_rcv_trans_status );
2941:

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

2938: itemkey => Itemkey,
2939: aname => 'RCV_TRANS_STATUS',
2940: avalue => x_rcv_trans_status );
2941:
2942: wf_engine.SetItemAttrText ( itemtype => Itemtype,
2943: itemkey => Itemkey,
2944: aname => 'RCV_ERR_MSG_TOKEN',
2945: avalue => x_message_token );
2946:

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

3016: x_rcv_trans_status := 'RCV_RCPT_INSERT_FAILED';
3017:
3018: END IF;
3019:
3020: wf_engine.SetItemAttrText ( itemtype => Itemtype,
3021: itemkey => Itemkey,
3022: aname => 'RCV_TRANS_STATUS',
3023: avalue => x_rcv_trans_status );
3024:

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

3063: nl VARCHAR2(1) := fnd_global.newline;
3064: l_base_href VARCHAR(2000) := fnd_profile.value('APPS_FRAMEWORK_AGENT');
3065: BEGIN
3066:
3067: x_is_int_req := wf_engine.GetItemAttrText( itemtype => x_item_type,
3068: itemkey => x_item_key,
3069: aname => 'IS_INT_REQ');
3070:
3071: if x_is_int_req is NULL then

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

3073: end if;
3074:
3075: if x_is_int_req = 'Y' then
3076:
3077: x_number := wf_engine.GetItemAttrText( itemtype => x_item_type,
3078: itemkey => x_item_key,
3079: aname => 'SO_NUMBER');
3080:
3081: else -- Purchase Requisition

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

3080:
3081: else -- Purchase Requisition
3082:
3083:
3084: x_number := wf_engine.GetItemAttrText( itemtype => x_item_type,
3085: itemkey => x_item_key,
3086: aname => 'PO_NUMBER');
3087:
3088: x_buyer_name := wf_engine.GetItemAttrText(itemtype => x_item_type,

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

3084: x_number := wf_engine.GetItemAttrText( itemtype => x_item_type,
3085: itemkey => x_item_key,
3086: aname => 'PO_NUMBER');
3087:
3088: x_buyer_name := wf_engine.GetItemAttrText(itemtype => x_item_type,
3089: itemkey => x_item_key,
3090: aname => 'BUYER_DISP_NAME');
3091:
3092:

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

3089: itemkey => x_item_key,
3090: aname => 'BUYER_DISP_NAME');
3091:
3092:
3093: x_supplier_name := wf_engine.GetItemAttrText( itemtype => x_item_type,
3094: itemkey => x_item_key,
3095: aname => 'SUPPLIER_DISP_NAME');
3096:
3097: end if;

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

3095: aname => 'SUPPLIER_DISP_NAME');
3096:
3097: end if;
3098:
3099: x_note_to_receiver := wf_engine.GetItemAttrText( itemtype => x_item_type,
3100: itemkey => x_item_key,
3101: aname => 'NOTE_TO_RECEIVER');
3102:
3103: x_due_date := wf_engine.GetItemAttrDate( itemtype => x_item_type,

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

3099: x_note_to_receiver := wf_engine.GetItemAttrText( itemtype => x_item_type,
3100: itemkey => x_item_key,
3101: aname => 'NOTE_TO_RECEIVER');
3102:
3103: x_due_date := wf_engine.GetItemAttrDate( itemtype => x_item_type,
3104: itemkey => x_item_key,
3105: aname => 'DUE_DATE');
3106:
3107:

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

3387: l_display_url := substr(l_temp, instr(l_temp, ':') + 1,
3388: length(l_temp) - 2);
3389:
3390:
3391: x_is_int_req := wf_engine.GetItemAttrText( itemtype => l_item_type,
3392: itemkey => l_item_key,
3393: aname => 'IS_INT_REQ');
3394:
3395: -- ash_debug.debug('GET_PO_RCV_NOTIF_MSG value of IS_INT_REQ', x_is_int_req);

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

3395: -- ash_debug.debug('GET_PO_RCV_NOTIF_MSG value of IS_INT_REQ', x_is_int_req);
3396:
3397: if x_is_int_req = 'Y' then
3398:
3399: x_header_id := wf_engine.GetItemAttrNumber( itemtype => l_item_type,
3400: itemkey => l_item_key,
3401: aname => 'SO_HEADER_ID');
3402:
3403: else

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

3410: end if;
3411:
3412: -- ash_debug.debug('GET_PO_RCV_NOTIF_MSG value of header_is', x_header_id);
3413:
3414: x_org_id := wf_engine.GetItemAttrNumber( itemtype => l_item_type,
3415: itemkey => l_item_key,
3416: aname => 'ORG_ID');
3417:
3418: setOrgCtx(x_org_id);

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

3418: setOrgCtx(x_org_id);
3419:
3420: -- ash_debug.debug('GET_PO_RCV_NOTIF_MSG value of org_id', x_org_id);
3421:
3422: x_requester_id := wf_engine.GetItemAttrNumber( itemtype => l_item_type,
3423: itemkey => l_item_key,
3424: aname => 'REQUESTER_ID');
3425:
3426: x_exp_receipt_date := wf_engine.GetItemAttrDate ( itemtype => l_item_type,

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

3422: x_requester_id := wf_engine.GetItemAttrNumber( itemtype => l_item_type,
3423: itemkey => l_item_key,
3424: aname => 'REQUESTER_ID');
3425:
3426: x_exp_receipt_date := wf_engine.GetItemAttrDate ( itemtype => l_item_type,
3427: itemkey => l_item_key,
3428: aname => 'DUE_DATE');
3429:
3430:

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

3432: x_count := get_count(l_item_type,l_item_key);
3433:
3434: -- ash_debug.debug('GET_PO_RCV_NOTIF_MSG value of x_count', x_count);
3435:
3436: l_rcv_items_url := wf_engine.GetItemAttrText (itemtype => l_item_type,
3437: itemkey => l_item_key,
3438: aname => 'RCV_ORDERS_URL');
3439:
3440: l_rcv_items_url := '' ||