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.PO_AUTOCREATE_DOC dependencies on WF_ENGINE

Line 83: wf_engine.CreateProcess(itemtype => itemtype,

79: ( req_header_id is NOT NULL ) THEN
80:
81: --Bug 5490243. Removed the commit introduced in Bug 3293852
82:
83: wf_engine.CreateProcess(itemtype => itemtype,
84: itemkey => itemkey,
85: process => workflow_process );
86:
87: x_progress:= '20: start_wf_process: Just after CreateProcess';

Line 178: wf_engine.StartProcess(itemtype => itemtype,

174: IF (g_po_wf_debug = 'Y') THEN
175: po_wf_debug_pkg.insert_debug(Itemtype,Itemkey,x_progress);
176: END IF;
177:
178: wf_engine.StartProcess(itemtype => itemtype,
179: itemkey => itemkey );
180:
181: END IF;
182:

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

215: itemkey => itemkey,
216: aname => 'AUTOCREATE_DOC');
217:
218: if (x_autocreate_doc = 'Y') then
219: resultout := wf_engine.eng_completed || ':' || 'Y';
220:
221: x_progress:= '10: should_req_be_autocreated: result = Y';
222: IF (g_po_wf_debug = 'Y') THEN
223: po_wf_debug_pkg.insert_debug(itemtype,itemkey,x_progress);

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

223: po_wf_debug_pkg.insert_debug(itemtype,itemkey,x_progress);
224: END IF;
225:
226: else
227: resultout := wf_engine.eng_completed || ':' || 'N';
228:
229: x_progress:= '20: should_req_be_autocreated: result = N';
230: IF (g_po_wf_debug = 'Y') THEN
231: po_wf_debug_pkg.insert_debug(itemtype,itemkey,x_progress);

Line 481: resultout := wf_engine.eng_completed || ':' || 'ACTIVITY_PERFORMED';

477:
478: end loop;
479: close c1;
480:
481: resultout := wf_engine.eng_completed || ':' || 'ACTIVITY_PERFORMED';
482:
483: x_progress:= '40:launch_req_line_processing: result = ACTIVITY_PERFORMED';
484: IF (g_po_wf_debug = 'Y') THEN
485: po_wf_debug_pkg.insert_debug(itemtype,itemkey,x_progress);

Line 569: resultout := wf_engine.eng_completed || ':' || 'ACTIVITY_PERFORMED';

565:
566: END LOOP;
567: CLOSE C_ConsumeReqLines;
568:
569: resultout := wf_engine.eng_completed || ':' || 'ACTIVITY_PERFORMED';
570:
571: x_progress:='40:launch_req_line_processing: result =ACTIVITY_PERFORMED';
572: IF (g_po_wf_debug = 'Y') THEN
573: po_wf_debug_pkg.insert_debug(itemtype,itemkey,x_progress);

Line 625: wf_engine.CreateProcess(itemtype => itemtype,

621:
622: IF (ItemType is NOT NULL ) AND
623: (ItemKey is NOT NULL) AND
624: (req_line_id is NOT NULL ) then
625: wf_engine.CreateProcess(itemtype => itemtype,
626: itemkey => itemkey,
627: process => workflow_process );
628:
629: x_progress := '20: start_wf_line_process: Just after CreateProcess';

Line 654: wf_engine.SetItemParent (itemtype => itemtype,

650:
651:
652: /* Need to set the parent child relationship between processes */
653:
654: wf_engine.SetItemParent (itemtype => itemtype,
655: itemkey => itemkey,
656: parent_itemtype => parent_itemtype,
657: parent_itemkey => parent_itemkey,
658: parent_context => NULL);

Line 668: wf_engine.StartProcess(itemtype => itemtype,

664: IF (g_po_wf_debug = 'Y') THEN
665: po_wf_debug_pkg.insert_debug(itemtype,itemkey,x_progress);
666: END IF;
667:
668: wf_engine.StartProcess(itemtype => itemtype,
669: itemkey => itemkey );
670:
671: end if;
672:

Line 943: resultout := wf_engine.eng_completed || ':' || 'ACTIVITY_PERFORMED';

939: aname => 'LABOR_REQ_LINE_ID',
940: avalue => l_labor_req_line_id);
941: --
942:
943: resultout := wf_engine.eng_completed || ':' || 'ACTIVITY_PERFORMED';
944:
945: x_progress:= '20: get_req_info: result = ACTIVITY_PERFORMED';
946: IF (g_po_wf_debug = 'Y') THEN
947: po_wf_debug_pkg.insert_debug(itemtype,itemkey,x_progress);

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

1005:
1006: if ((x_warn_rfq_required = 'Y') AND
1007: (x_rfq_required_flag = 'Y') AND
1008: ((x_on_rfq_flag is NULL) OR (x_on_rfq_flag = 'N'))) then
1009: resultout := wf_engine.eng_completed || ':' || 'Y';
1010:
1011: x_progress:= '10: rfq_required_check: result = Y';
1012: IF (g_po_wf_debug = 'Y') THEN
1013: po_wf_debug_pkg.insert_debug(itemtype,itemkey,x_progress);

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

1013: po_wf_debug_pkg.insert_debug(itemtype,itemkey,x_progress);
1014: END IF;
1015:
1016: else
1017: resultout := wf_engine.eng_completed || ':' || 'N';
1018:
1019: x_progress:= '20: rfq_required_check: result = N';
1020: IF (g_po_wf_debug = 'Y') THEN
1021: po_wf_debug_pkg.insert_debug(itemtype,itemkey,x_progress);

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

1128:
1129: /* If the vendor is not valid then we exit right here. */
1130:
1131: if (x_valid_vendor ='N') then
1132: resultout := wf_engine.eng_completed || ':' || 'N';
1133:
1134: x_progress:= '10: get_supp_info_for_acrt: result = N ' ||
1135: 'because the supplier id is invalid';
1136: IF (g_po_wf_debug = 'Y') THEN

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

1160:
1161: /* If the vendor is not valid then we exit right here. */
1162:
1163: if (x_valid_vendor ='N') then
1164: resultout := wf_engine.eng_completed || ':' || 'N';
1165:
1166: x_progress:= '20: get_supp_info_for_acrt: result = N ' ||
1167: 'because the supplier is null or invalid';
1168: IF (g_po_wf_debug = 'Y') THEN

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

1208:
1209: /* If the vendor site id is not valid then we exit right here. */
1210:
1211: if (x_valid_vendor_site ='N') then
1212: resultout := wf_engine.eng_completed || ':' || 'N';
1213:
1214: x_progress:= '30: get_supp_info_for_acrt: result = N ' ||
1215: 'becuase the supplier site id is invalid';
1216: IF (g_po_wf_debug = 'Y') THEN

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

1239:
1240: /* If the vendor site is not valid then we exit right here. */
1241:
1242: if (x_valid_vendor_site ='N') then
1243: resultout := wf_engine.eng_completed || ':' || 'N';
1244:
1245: x_progress:= '40: get_supp_info_for_acrt: result = N ' ||
1246: 'becuase the supplier site is null or invalid';
1247: IF (g_po_wf_debug = 'Y') THEN

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

1278: aname => 'SUGGESTED_VENDOR_LOCATION',
1279: avalue => x_vendor_site);
1280: /* Bug 2577940 */
1281:
1282: resultout := wf_engine.eng_completed || ':' || 'Y';
1283:
1284: x_progress:= '50: get_supp_info_for_acrt: result = Y';
1285: IF (g_po_wf_debug = 'Y') THEN
1286: po_wf_debug_pkg.insert_debug(itemtype,itemkey,x_progress);

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

1343:
1344: if ((x_source_doc_type_code is NULL) or
1345: (x_source_doc_po_header_id is NULL) or
1346: (x_source_doc_line_num is NULL)) then
1347: resultout := wf_engine.eng_completed || ':' || 'N';
1348:
1349: x_progress:= '10: is_source_doc_info_ok: result = N';
1350: IF (g_po_wf_debug = 'Y') THEN
1351: po_wf_debug_pkg.insert_debug(itemtype,itemkey,x_progress);

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

1358:
1359: is_ga_still_valid(x_source_doc_po_header_id, l_source_doc_ok);
1360:
1361: IF l_source_doc_ok = 'N' THEN
1362: resultout := wf_engine.eng_completed || ':' || 'N';
1363:
1364: x_progress:= '20: is_source_doc_info_ok: result = N';
1365: ELSE
1366: resultout := wf_engine.eng_completed || ':' || 'Y';

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

1362: resultout := wf_engine.eng_completed || ':' || 'N';
1363:
1364: x_progress:= '20: is_source_doc_info_ok: result = N';
1365: ELSE
1366: resultout := wf_engine.eng_completed || ':' || 'Y';
1367:
1368: x_progress:= '20: is_source_doc_info_ok: result = Y';
1369: END IF;
1370:

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

1374:
1375: --
1376:
1377: else
1378: resultout := wf_engine.eng_completed || ':' || 'Y';
1379:
1380: x_progress:= '30: is_source_doc_info_ok: result = Y';
1381: IF (g_po_wf_debug = 'Y') THEN
1382: po_wf_debug_pkg.insert_debug(itemtype,itemkey,x_progress);

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

1524: aname => 'CURRENCY_CODE');
1525:
1526: if nvl(x_use_contract_flag, 'N') <> 'Y' then
1527:
1528: resultout := wf_engine.eng_completed || ':' || 'N';
1529:
1530: return;
1531:
1532: end if;

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

1648: avalue => NULL);
1649:
1650: --
1651:
1652: resultout := wf_engine.eng_completed || ':' || 'Y';
1653:
1654: else
1655:
1656: resultout := wf_engine.eng_completed || ':' || 'N';

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

1652: resultout := wf_engine.eng_completed || ':' || 'Y';
1653:
1654: else
1655:
1656: resultout := wf_engine.eng_completed || ':' || 'N';
1657:
1658: end if;
1659:
1660: exception

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

1698: aname => 'PCARD_ID');
1699:
1700:
1701: if (x_pcard_id is NULL) then
1702: resultout := wf_engine.eng_completed || ':' || 'N';
1703:
1704: x_progress:= '10: is_req_pcard_line: result = N';
1705: IF (g_po_wf_debug = 'Y') THEN
1706: po_wf_debug_pkg.insert_debug(itemtype,itemkey,x_progress);

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

1708:
1709: purge_expense_lines(itemtype, itemkey); --
1710:
1711: else
1712: resultout := wf_engine.eng_completed || ':' || 'Y';
1713:
1714: x_progress:= '20: is_req_pcard_line: result = Y';
1715: IF (g_po_wf_debug = 'Y') THEN
1716: po_wf_debug_pkg.insert_debug(itemtype,itemkey,x_progress);

Line 1763: resultout := wf_engine.eng_completed || ':' || 'ACTION_FAILED';

1759:
1760: if (x_suggested_buyer_id is NULL OR
1761: l_validate_result = FND_API.G_FALSE) then -- bug2821542
1762:
1763: resultout := wf_engine.eng_completed || ':' || 'ACTION_FAILED';
1764:
1765: x_progress:= '10: get_buyer_from_req_line: result = ACTION_FAILED';
1766: IF (g_po_wf_debug = 'Y') THEN
1767: po_wf_debug_pkg.insert_debug(itemtype,itemkey,x_progress);

Line 1771: resultout := wf_engine.eng_completed || ':' || 'ACTION_SUCCEEDED';

1767: po_wf_debug_pkg.insert_debug(itemtype,itemkey,x_progress);
1768: END IF;
1769:
1770: else
1771: resultout := wf_engine.eng_completed || ':' || 'ACTION_SUCCEEDED';
1772:
1773: x_progress:= '20: get_buyer_from_req_line: result = ACTION_SUCCEEDED';
1774: IF (g_po_wf_debug = 'Y') THEN
1775: po_wf_debug_pkg.insert_debug(itemtype,itemkey,x_progress);

Line 1862: resultout := wf_engine.eng_completed || ':' || 'ACTION_FAILED';

1858:
1859: if (x_buyer_id is NULL OR
1860: l_validate_result = FND_API.G_FALSE) then -- bug2821542
1861:
1862: resultout := wf_engine.eng_completed || ':' || 'ACTION_FAILED';
1863:
1864: x_progress:='10: get_buyer_from_item: result = ACTION_FAILED';
1865: IF (g_po_wf_debug = 'Y') THEN
1866: po_wf_debug_pkg.insert_debug(itemtype,itemkey,x_progress);

Line 1875: resultout := wf_engine.eng_completed || ':' || 'ACTION_SUCCEEDED';

1871: itemkey => itemkey,
1872: aname => 'SUGGESTED_BUYER_ID',
1873: avalue => x_buyer_id);
1874:
1875: resultout := wf_engine.eng_completed || ':' || 'ACTION_SUCCEEDED';
1876:
1877: x_progress:='20: get_buyer_from_item: result = ACTION_SUCCEEDED';
1878: IF (g_po_wf_debug = 'Y') THEN
1879: po_wf_debug_pkg.insert_debug(itemtype,itemkey,x_progress);

Line 2015: resultout := wf_engine.eng_completed || ':' || 'ACTION_FAILED';

2011:
2012: if (x_agent_id is NULL OR
2013: l_validate_result = FND_API.G_FALSE) then -- bug2821542
2014:
2015: resultout := wf_engine.eng_completed || ':' || 'ACTION_FAILED';
2016:
2017: x_progress := '30:get_buyer_from_category: result = ACTION_FAILED';
2018: IF (g_po_wf_debug = 'Y') THEN
2019: po_wf_debug_pkg.insert_debug(itemtype,itemkey,x_progress);

Line 2029: resultout := wf_engine.eng_completed || ':' || 'ACTION_SUCCEEDED';

2025: itemkey => itemkey,
2026: aname => 'SUGGESTED_BUYER_ID',
2027: avalue => x_agent_id);
2028:
2029: resultout := wf_engine.eng_completed || ':' || 'ACTION_SUCCEEDED';
2030:
2031: x_progress := '40:get_buyer_from_category: result = ACTION_SUCCEEDED';
2032: IF (g_po_wf_debug = 'Y') THEN
2033: po_wf_debug_pkg.insert_debug(itemtype,itemkey,x_progress);

Line 2116: resultout := wf_engine.eng_completed || ':' || 'ACTION_FAILED';

2112:
2113: if (x_agent_id is NULL OR
2114: l_validate_result = FND_API.G_FALSE) then -- bug2821542
2115:
2116: resultout := wf_engine.eng_completed || ':' || 'ACTION_FAILED';
2117:
2118: x_progress := '30:get_buyer_from_source_doc: result = ACTION_FAILED';
2119: IF (g_po_wf_debug = 'Y') THEN
2120: po_wf_debug_pkg.insert_debug(itemtype,itemkey,x_progress);

Line 2130: resultout := wf_engine.eng_completed || ':' || 'ACTION_SUCCEEDED';

2126: itemkey => itemkey,
2127: aname => 'SUGGESTED_BUYER_ID',
2128: avalue => x_agent_id);
2129:
2130: resultout := wf_engine.eng_completed || ':' || 'ACTION_SUCCEEDED';
2131:
2132: x_progress := '40:get_buyer_from_source_doc: result = ACTION_SUCCEEDED';
2133: IF (g_po_wf_debug = 'Y') THEN
2134: po_wf_debug_pkg.insert_debug(itemtype,itemkey,x_progress);

Line 2202: resultout := wf_engine.eng_completed || ':' || 'ACTION_FAILED';

2198:
2199: if (x_agent_id is NULL OR
2200: l_validate_result = FND_API.G_FALSE) then -- bug2821542
2201:
2202: resultout := wf_engine.eng_completed || ':' || 'ACTION_FAILED';
2203:
2204: x_progress := '30:get_buyer_from_source_doc: result = ACTION_FAILED';
2205: IF (g_po_wf_debug = 'Y') THEN
2206: po_wf_debug_pkg.insert_debug(itemtype,itemkey,x_progress);

Line 2217: resultout := wf_engine.eng_completed || ':' || 'ACTION_SUCCEEDED';

2213: itemkey => itemkey,
2214: aname => 'SUGGESTED_BUYER_ID',
2215: avalue => x_agent_id);
2216:
2217: resultout := wf_engine.eng_completed || ':' || 'ACTION_SUCCEEDED';
2218:
2219: x_progress := '40:get_buyer_from_contract: result = ACTION_SUCCEEDED';
2220: IF (g_po_wf_debug = 'Y') THEN
2221: po_wf_debug_pkg.insert_debug(itemtype,itemkey,x_progress);

Line 2272: resultout := wf_engine.eng_completed || ':' || 'NONE';

2268:
2269: /* FPI GA End */
2270: /* draising 2692119 */
2271: if (x_source_doc_type_code is null) then
2272: resultout := wf_engine.eng_completed || ':' || 'NONE';
2273:
2274: x_progress := '10: get_source_doc_type: result = NONE';
2275: IF (g_po_wf_debug = 'Y') THEN
2276: po_wf_debug_pkg.insert_debug(itemtype,itemkey,x_progress);

Line 2282: resultout := wf_engine.eng_completed || ':' || 'GLOBAL_PA'; -- FPI GA

2278:
2279: elsif (x_source_doc_type_code = 'BLANKET') then
2280: if nvl(x_ga_flag,'N') = 'Y' then -- FPI GA
2281: x_progress := '10: get_source_doc_type: result = GLOBAL_PA';
2282: resultout := wf_engine.eng_completed || ':' || 'GLOBAL_PA'; -- FPI GA
2283: else
2284: x_progress := '10: get_source_doc_type: result = BLANKET_PO';
2285: resultout := wf_engine.eng_completed || ':' || 'BLANKET_PO';
2286: end if;

Line 2285: resultout := wf_engine.eng_completed || ':' || 'BLANKET_PO';

2281: x_progress := '10: get_source_doc_type: result = GLOBAL_PA';
2282: resultout := wf_engine.eng_completed || ':' || 'GLOBAL_PA'; -- FPI GA
2283: else
2284: x_progress := '10: get_source_doc_type: result = BLANKET_PO';
2285: resultout := wf_engine.eng_completed || ':' || 'BLANKET_PO';
2286: end if;
2287:
2288: x_progress := '10: get_source_doc_type: result = BLANKET_PO';
2289: IF (g_po_wf_debug = 'Y') THEN

Line 2294: resultout := wf_engine.eng_completed || ':' || 'CONTRACT_PO';

2290: po_wf_debug_pkg.insert_debug(itemtype,itemkey,x_progress);
2291: END IF;
2292:
2293: elsif (x_source_doc_type_code = 'CONTRACT') then
2294: resultout := wf_engine.eng_completed || ':' || 'CONTRACT_PO';
2295:
2296: x_progress := '10: get_source_doc_type: result = CONTRACT_PO';
2297: IF (g_po_wf_debug = 'Y') THEN
2298: po_wf_debug_pkg.insert_debug(itemtype,itemkey,x_progress);

Line 2303: resultout := wf_engine.eng_completed || ':' || 'QUOTATION';

2299: END IF;
2300:
2301: else
2302: /* Must be QUOTATION */
2303: resultout := wf_engine.eng_completed || ':' || 'QUOTATION';
2304:
2305: x_progress := '10: get_source_doc_type: result = QUOTATION';
2306: IF (g_po_wf_debug = 'Y') THEN
2307: po_wf_debug_pkg.insert_debug(itemtype,itemkey,x_progress);

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

2340:
2341: /* If item_id is null then this is a one-time item. */
2342:
2343: if (x_item_id is NULL) then
2344: resultout := wf_engine.eng_completed || ':' || 'Y';
2345:
2346: x_progress:= '10: one_time_item_check: result = Y';
2347: IF (g_po_wf_debug = 'Y') THEN
2348: po_wf_debug_pkg.insert_debug(itemtype,itemkey,x_progress);

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

2348: po_wf_debug_pkg.insert_debug(itemtype,itemkey,x_progress);
2349: END IF;
2350:
2351: else
2352: resultout := wf_engine.eng_completed || ':' || 'N';
2353:
2354: x_progress:= '10: one_time_item_check: result = N';
2355: IF (g_po_wf_debug = 'Y') THEN
2356: po_wf_debug_pkg.insert_debug(itemtype,itemkey,x_progress);

Line 2507: resultout := wf_engine.eng_completed || ':' || 'NO_METHOD_FOUND';

2503: aname => 'REL_GEN_METHOD',
2504: avalue => x_rel_gen_method);
2505:
2506: if (x_rel_gen_method is NULL) then
2507: resultout := wf_engine.eng_completed || ':' || 'NO_METHOD_FOUND';
2508:
2509: x_progress:= '10: get_rel_gen_method: result = NO_METHOD_FOUND';
2510: IF (g_po_wf_debug = 'Y') THEN
2511: po_wf_debug_pkg.insert_debug(itemtype,itemkey,x_progress);

Line 2515: resultout := wf_engine.eng_completed || ':' || x_rel_gen_method;

2511: po_wf_debug_pkg.insert_debug(itemtype,itemkey,x_progress);
2512: END IF;
2513:
2514: else
2515: resultout := wf_engine.eng_completed || ':' || x_rel_gen_method;
2516:
2517: x_progress:= '20: get_rel_gen_method: ' || 'result = ' || x_rel_gen_method;
2518: IF (g_po_wf_debug = 'Y') THEN
2519: po_wf_debug_pkg.insert_debug(itemtype,itemkey,x_progress);

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

2558: itemkey => itemkey,
2559: aname => 'CONT_WF_FOR_AC_REL_GEN');
2560:
2561: if (x_cont_wf_for_ac_rel_gen = 'Y') then
2562: resultout := wf_engine.eng_completed || ':' || 'Y';
2563:
2564: x_progress:= '10: cont_wf_autocreate_rel_gen: Y';
2565: IF (g_po_wf_debug = 'Y') THEN
2566: po_wf_debug_pkg.insert_debug(itemtype,itemkey,x_progress);

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

2566: po_wf_debug_pkg.insert_debug(itemtype,itemkey,x_progress);
2567: END IF;
2568:
2569: else
2570: resultout := wf_engine.eng_completed || ':' || 'N';
2571:
2572: x_progress:= '20: cont_wf_autocreate_rel_gen: N';
2573: IF (g_po_wf_debug = 'Y') THEN
2574: po_wf_debug_pkg.insert_debug(itemtype,itemkey,x_progress);

Line 2796: resultout := wf_engine.eng_completed || ':' || 'ACTIVITY_PERFORMED';

2792: /* Calling process should do the commit, so comment out here.
2793: * COMMIT;
2794: */
2795:
2796: resultout := wf_engine.eng_completed || ':' || 'ACTIVITY_PERFORMED';
2797:
2798: x_progress:= '20: insert_cand_req_lines_into_tbl: ACTIVITY_PERFORMED';
2799: IF (g_po_wf_debug = 'Y') THEN
2800: po_wf_debug_pkg.insert_debug(itemtype,itemkey,x_progress);

Line 3681: resultout := wf_engine.eng_completed || ':' || 'ACTIVITY_PERFORMED';

3677: /* Calling process should do the commit, so comment out here.
3678: * COMMIT;
3679: */
3680:
3681: resultout := wf_engine.eng_completed || ':' || 'ACTIVITY_PERFORMED';
3682:
3683: x_progress := '60: group_req_lines: result = ACTIVITY_PERFORMED ';
3684: IF (g_po_wf_debug = 'Y') THEN
3685: po_wf_debug_pkg.insert_debug(itemtype,itemkey,x_progress);

Line 4566: resultout := wf_engine.eng_completed || ':' || 'ACTIVITY_PERFORMED';

4562:
4563: end loop;
4564: close c1;
4565:
4566: resultout := wf_engine.eng_completed || ':' || 'ACTIVITY_PERFORMED';
4567:
4568: x_progress := '20: launch_doc_creation_approval: result = ACTIVITY_PERFORMED';
4569: IF (g_po_wf_debug = 'Y') THEN
4570: po_wf_debug_pkg.insert_debug(itemtype,itemkey,x_progress);

Line 4620: wf_engine.CreateProcess(itemtype => itemtype,

4616:
4617: IF (ItemType is NOT NULL ) AND
4618: (ItemKey is NOT NULL) AND
4619: (interface_header_id is NOT NULL ) then
4620: wf_engine.CreateProcess(itemtype => itemtype,
4621: itemkey => itemkey,
4622: process => workflow_process );
4623:
4624: x_progress:= '20. start_wf_create_apprv_process: Just after create process';

Line 4663: wf_engine.SetItemParent (itemtype => itemtype,

4659:
4660:
4661: /* Need to set the parent child relationship between processes */
4662:
4663: wf_engine.SetItemParent (itemtype => itemtype,
4664: itemkey => itemkey,
4665: parent_itemtype => parent_itemtype,
4666: parent_itemkey => parent_itemkey,
4667: parent_context => NULL);

Line 4679: wf_engine.StartProcess(itemtype => itemtype,

4675: IF (g_po_wf_debug = 'Y') THEN
4676: po_wf_debug_pkg.insert_debug(itemtype,itemkey,x_progress);
4677: END IF;
4678:
4679: wf_engine.StartProcess(itemtype => itemtype,
4680: itemkey => itemkey );
4681:
4682: END IF;
4683:

Line 4812: resultout := wf_engine.eng_completed || ':' || 'CREATE_OK';

4808: */
4809:
4810: po_autocreate_doc.setup_notification_data (itemtype, itemkey);
4811:
4812: resultout := wf_engine.eng_completed || ':' || 'CREATE_OK';
4813:
4814: x_progress:= '30: create_doc: result = CREATE_OK';
4815: IF (g_po_wf_debug = 'Y') THEN
4816: po_wf_debug_pkg.insert_debug(itemtype,itemkey,x_progress);

Line 4820: resultout := wf_engine.eng_completed || ':' || 'CREATE_FAILED';

4816: po_wf_debug_pkg.insert_debug(itemtype,itemkey,x_progress);
4817: END IF;
4818:
4819: else
4820: resultout := wf_engine.eng_completed || ':' || 'CREATE_FAILED';
4821:
4822: x_progress:= '40: create_doc: result = CREATE_FAILED';
4823: IF (g_po_wf_debug = 'Y') THEN
4824: po_wf_debug_pkg.insert_debug(itemtype,itemkey,x_progress);

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

5118:
5119: --
5120:
5121: if (x_auto_approve_doc = 'Y' AND l_return_status = FND_API.G_RET_STS_SUCCESS) then --
5122: resultout := wf_engine.eng_completed || ':' || 'Y';
5123:
5124: x_progress:= '10: should_doc_be_approved: result = Y';
5125: IF (g_po_wf_debug = 'Y') THEN
5126: po_wf_debug_pkg.insert_debug(itemtype,itemkey,x_progress);

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

5126: po_wf_debug_pkg.insert_debug(itemtype,itemkey,x_progress);
5127: END IF;
5128:
5129: else
5130: resultout := wf_engine.eng_completed || ':' || 'N';
5131:
5132: x_progress:= '20: should_doc_be_approved: result = N';
5133: IF (g_po_wf_debug = 'Y') THEN
5134: po_wf_debug_pkg.insert_debug(itemtype,itemkey,x_progress);

Line 5460: resultout := wf_engine.eng_completed || ':' || 'ACTIVITY_PERFORMED';

5456: x_faxnum,
5457: x_emailflag,
5458: x_emailaddress);
5459:
5460: resultout := wf_engine.eng_completed || ':' || 'ACTIVITY_PERFORMED';
5461:
5462: x_progress:= '20: launch_po_approval: result = ACTIVITY_PERFORMED';
5463: IF (g_po_wf_debug = 'Y') THEN
5464: po_wf_debug_pkg.insert_debug(itemtype,itemkey,x_progress);

Line 5513: resultout := wf_engine.eng_completed || ':' || 'ACTIVITY_PERFORMED';

5509: /* Calling process should do the commit, so comment out here.
5510: * COMMIT;
5511: */
5512:
5513: resultout := wf_engine.eng_completed || ':' || 'ACTIVITY_PERFORMED';
5514:
5515: x_progress:= '10: purge_rows_from_temp_table: result = ACTIVITY_PERFORMED';
5516: IF (g_po_wf_debug = 'Y') THEN
5517: po_wf_debug_pkg.insert_debug(itemtype,itemkey,x_progress);

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

5554: WHERE requisition_header_id=x_req_header_id;
5555: EXCEPTION
5556: WHEN OTHERS THEN
5557:
5558: resultout := wf_engine.eng_completed || ':' || 'N';
5559: x_progress:= '10: is_this_emergency_req: result = N';
5560: IF (g_po_wf_debug = 'Y') THEN
5561: po_wf_debug_pkg.insert_debug(itemtype,itemkey,x_progress);
5562: END IF;

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

5563:
5564: END;
5565:
5566: IF x_emergency_po_num IS NOT NULL THEN
5567: resultout := wf_engine.eng_completed || ':' || 'Y';
5568: x_progress:= '20: is_this_emergency_req: result = Y';
5569: IF (g_po_wf_debug = 'Y') THEN
5570: po_wf_debug_pkg.insert_debug(itemtype,itemkey,x_progress);
5571: END IF;

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

5570: po_wf_debug_pkg.insert_debug(itemtype,itemkey,x_progress);
5571: END IF;
5572:
5573: ELSE
5574: resultout := wf_engine.eng_completed || ':' || 'N';
5575: x_progress:= '30: is_this_emergency_req: result = N';
5576: IF (g_po_wf_debug = 'Y') THEN
5577: po_wf_debug_pkg.insert_debug(itemtype,itemkey,x_progress);
5578: END IF;

Line 5891: resultout := wf_engine.eng_completed || ':' || 'ACTIVITY_PERFORMED';

5887: end;
5888: end if;
5889:
5890:
5891: resultout := wf_engine.eng_completed || ':' || 'ACTIVITY_PERFORMED';
5892:
5893: x_progress := '40: put_on_one_po: result = ACTIVITY_PERFORMED ';
5894: IF (g_po_wf_debug = 'Y') THEN
5895: po_wf_debug_pkg.insert_debug(itemtype,itemkey,x_progress);

Line 6070: wf_engine.CreateProcess( ItemType => ItemType,

6066:
6067: select to_char(PO_WF_ITEMKEY_S.NEXTVAL) into l_seq from sys.dual;
6068: ItemKey := to_char(p_req_header_id) || '-' || l_seq;
6069:
6070: wf_engine.CreateProcess( ItemType => ItemType,
6071: ItemKey => ItemKey,
6072: process => 'NOTIFY_RETURN_REQ');
6073:
6074: x_progress := 'PO_AUTOCREATE_DOC.send_return_notif: 050 - '||

Line 6176: wf_engine.SetItemAttrNumber ( itemtype => itemtype,

6172: -- the workflow will set a null context.
6173: l_user_id := FND_GLOBAL.user_id;
6174: l_responsibility_id := FND_GLOBAL.resp_id;
6175: l_application_id := FND_GLOBAL.resp_appl_id;
6176: wf_engine.SetItemAttrNumber ( itemtype => itemtype,
6177: itemkey => itemkey,
6178: aname => 'USER_ID',
6179: avalue => l_user_id);
6180:

Line 6181: wf_engine.SetItemAttrNumber ( itemtype => itemtype,

6177: itemkey => itemkey,
6178: aname => 'USER_ID',
6179: avalue => l_user_id);
6180:
6181: wf_engine.SetItemAttrNumber ( itemtype => itemtype,
6182: itemkey => itemkey,
6183: aname => 'APPLICATION_ID',
6184: avalue => l_application_id);
6185:

Line 6186: wf_engine.SetItemAttrNumber ( itemtype => itemtype,

6182: itemkey => itemkey,
6183: aname => 'APPLICATION_ID',
6184: avalue => l_application_id);
6185:
6186: wf_engine.SetItemAttrNumber ( itemtype => itemtype,
6187: itemkey => itemkey,
6188: aname => 'RESPONSIBILITY_ID',
6189: avalue => l_responsibility_id);
6190: -- bug 5657496

Line 6198: wf_engine.StartProcess(itemtype => itemtype,

6194: IF (g_po_wf_debug = 'Y') THEN
6195: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);
6196: END IF;
6197:
6198: wf_engine.StartProcess(itemtype => itemtype,
6199: itemkey => itemkey );
6200:
6201:
6202: EXCEPTION

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

6286: aname => 'CONTRACT_REQUIRED_FLAG');
6287:
6288: if nvl(x_contract_required_flag, 'N') <> 'Y' then
6289:
6290: resultout := wf_engine.eng_completed || ':' || 'N';
6291:
6292: return;
6293: else
6294: resultout:= wf_engine.eng_completed || ':' || 'Y';

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

6290: resultout := wf_engine.eng_completed || ':' || 'N';
6291:
6292: return;
6293: else
6294: resultout:= wf_engine.eng_completed || ':' || 'Y';
6295:
6296: return;
6297:
6298: end if;

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

6329: aname => 'USE_CONTRACT_FLAG');
6330:
6331: if nvl(x_use_contract_flag, 'N') <> 'Y' then
6332:
6333: resultout := wf_engine.eng_completed || ':' || 'N';
6334:
6335: return;
6336: else
6337: resultout:= wf_engine.eng_completed || ':' || 'Y';

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

6333: resultout := wf_engine.eng_completed || ':' || 'N';
6334:
6335: return;
6336: else
6337: resultout:= wf_engine.eng_completed || ':' || 'Y';
6338:
6339: return;
6340:
6341: end if;

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

6374: aname => 'CATALOG_TYPE');
6375:
6376: if nvl(x_catalog_type, 'CATALOG') <> 'NONCATALOG' then
6377:
6378: resultout := wf_engine.eng_completed || ':' || 'N';
6379:
6380: else
6381: resultout := wf_engine.eng_completed || ':' || 'Y';
6382:

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

6377:
6378: resultout := wf_engine.eng_completed || ':' || 'N';
6379:
6380: else
6381: resultout := wf_engine.eng_completed || ':' || 'Y';
6382:
6383: x_progress:= '10: non_catalog_item_check: result = '|| resultout;
6384: IF (g_po_wf_debug = 'Y') THEN
6385: po_wf_debug_pkg.insert_debug(itemtype,itemkey,x_progress);

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

6500: end;
6501:
6502: if (x_contract_id_valid = -1 ) then
6503:
6504: resultout := wf_engine.eng_completed || ':' || 'N';
6505:
6506: elsif (x_contract_id_valid = x_source_doc_po_header_id) then
6507: -- bug 3079146
6508: -- if currency didn't match, don't create po

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

6510: l_base_currency := PO_CORE_S2.get_base_currency;
6511:
6512: if ((x_source_currency_code is not null and x_contract_currency_code = x_source_currency_code) or (x_source_currency_code is null and x_contract_currency_code = l_base_currency)) then
6513:
6514: resultout := wf_engine.eng_completed || ':' || 'Y';
6515:
6516: else
6517: resultout := wf_engine.eng_completed || ':' || 'N';
6518: po_wf_util_pkg.SetItemAttrText (itemtype => itemtype,

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

6513:
6514: resultout := wf_engine.eng_completed || ':' || 'Y';
6515:
6516: else
6517: resultout := wf_engine.eng_completed || ':' || 'N';
6518: po_wf_util_pkg.SetItemAttrText (itemtype => itemtype,
6519: itemkey => itemkey,
6520: aname => 'CONTRACT_REQUIRED_FLAG',
6521: avalue => 'Y');

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

6522: end if;
6523:
6524: else
6525:
6526: resultout := wf_engine.eng_completed || ':' || 'N';
6527:
6528: end if;
6529:
6530: x_progress:= '10: is_source_doc_info_ok: result = ' || resultout;

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

6547: avalue => NULL);
6548:
6549: --
6550: else
6551: resultout := wf_engine.eng_completed || ':' || 'N';
6552:
6553: x_progress:= '20: is_contract_info_ok: result = N';
6554: IF (g_po_wf_debug = 'Y') THEN
6555: po_wf_debug_pkg.insert_debug(itemtype,itemkey,x_progress);

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

6594:
6595:
6596: if nvl(x_incl_non_ctlg_req_flag, 'N') <> 'Y' then
6597:
6598: resultout := wf_engine.eng_completed || ':' || 'N';
6599:
6600: return;
6601: else
6602: resultout:= wf_engine.eng_completed || ':' || 'Y';

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

6598: resultout := wf_engine.eng_completed || ':' || 'N';
6599:
6600: return;
6601: else
6602: resultout:= wf_engine.eng_completed || ':' || 'Y';
6603:
6604: return;
6605:
6606: end if;

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

6710: if nvl(x_ga_flag,'N') = 'Y' and
6711: x_owning_org_id <> x_org_id then
6712:
6713: x_progress := '10: is_src_doc_ga_frm_other_ou: result = Y';
6714: resultout := wf_engine.eng_completed || ':' || 'Y';
6715: else
6716: x_progress := '20: is_src_doc_ga_frm_other_ou: result = N';
6717: resultout := wf_engine.eng_completed || ':' || 'N';
6718: end if;

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

6713: x_progress := '10: is_src_doc_ga_frm_other_ou: result = Y';
6714: resultout := wf_engine.eng_completed || ':' || 'Y';
6715: else
6716: x_progress := '20: is_src_doc_ga_frm_other_ou: result = N';
6717: resultout := wf_engine.eng_completed || ':' || 'N';
6718: end if;
6719:
6720: IF (g_po_wf_debug = 'Y') THEN
6721: po_wf_debug_pkg.insert_debug(Itemtype,Itemkey,x_progress);

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

6855: END IF;
6856:
6857: IF (NVL(hr_general.get_xbg_profile, 'N') = 'Y') THEN
6858: x_progress := '10: buyer_on_src_doc_ok: result = Y';
6859: resultout := wf_engine.eng_completed || ':' || 'Y';
6860: ELSE --cross business group profile is 'N'
6861: x_source_doc_po_header_id := po_wf_util_pkg.GetItemAttrNumber
6862: (itemtype => itemtype,
6863: itemkey => itemkey,

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

6876: IF ((x_source_doc_type_code = 'QUOTATION') OR
6877: (x_source_doc_type_code = 'BLANKET' AND NVL(x_ga_flag, 'N') = 'N')) THEN
6878:
6879: x_progress := '20: buyer_on_src_doc_ok: result = Y';
6880: resultout := wf_engine.eng_completed || ':' || 'Y';
6881:
6882: ELSIF x_source_doc_type_code = 'BLANKET' AND NVL(x_ga_flag, 'N') = 'Y' THEN
6883:
6884: BEGIN

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

6900: END;
6901:
6902: IF l_return_status = 'Y' THEN
6903: x_progress := '30: buyer_on_src_doc_ok: result = Y';
6904: resultout := wf_engine.eng_completed || ':' || 'Y';
6905: ELSE
6906: x_progress := '40: buyer_on_src_doc_ok: result = N';
6907: resultout := wf_engine.eng_completed || ':' || 'N';
6908: END IF;

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

6903: x_progress := '30: buyer_on_src_doc_ok: result = Y';
6904: resultout := wf_engine.eng_completed || ':' || 'Y';
6905: ELSE
6906: x_progress := '40: buyer_on_src_doc_ok: result = N';
6907: resultout := wf_engine.eng_completed || ':' || 'N';
6908: END IF;
6909:
6910: ELSE
6911: x_progress := '50: buyer_on_src_doc_ok: result = N';

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

6908: END IF;
6909:
6910: ELSE
6911: x_progress := '50: buyer_on_src_doc_ok: result = N';
6912: resultout := wf_engine.eng_completed || ':' || 'N';
6913:
6914: END IF; --source doc check
6915: END IF; --check profile option
6916:

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

6985: END IF;
6986:
6987: IF (NVL(hr_general.get_xbg_profile, 'N') = 'Y') THEN
6988: x_progress := '10: buyer_on_contract_ok: result = Y';
6989: resultout := wf_engine.eng_completed || ':' || 'Y';
6990: ELSE -- cross business group profile is 'N'
6991: x_contract_id := po_wf_util_pkg.GetItemAttrNumber
6992: (itemtype => itemtype,
6993: itemkey => itemkey,

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

7011: END;
7012:
7013: IF l_return_status = 'Y' THEN
7014: x_progress := '20: buyer_on_contract_ok: result = Y';
7015: resultout := wf_engine.eng_completed || ':' || 'Y';
7016: ELSE
7017: x_progress := '30: buyer_on_contract_ok: result = N';
7018: resultout := wf_engine.eng_completed || ':' || 'N';
7019:

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

7014: x_progress := '20: buyer_on_contract_ok: result = Y';
7015: resultout := wf_engine.eng_completed || ':' || 'Y';
7016: ELSE
7017: x_progress := '30: buyer_on_contract_ok: result = N';
7018: resultout := wf_engine.eng_completed || ':' || 'N';
7019:
7020: purge_expense_lines(itemtype, itemkey); --
7021:
7022: END IF;

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

7023:
7024: ELSE --contract id is null
7025:
7026: x_progress := '40: buyer_on_contract_ok: result = N';
7027: resultout := wf_engine.eng_completed || ':' || 'N';
7028:
7029: purge_expense_lines(itemtype, itemkey); --
7030:
7031: END IF; --contract_id check

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

7102: aname => 'PURCHASING_ORG_ID');
7103:
7104: IF l_org_id = l_purchasing_org_id THEN
7105: x_progress := '10: purchasing_ou_check: result = N';
7106: resultout := wf_engine.eng_completed || ':' || 'N';
7107: ELSE
7108: x_progress := '20: purchasing_ou_check: result = Y';
7109: resultout := wf_engine.eng_completed || ':' || 'Y';
7110: END IF;

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

7105: x_progress := '10: purchasing_ou_check: result = N';
7106: resultout := wf_engine.eng_completed || ':' || 'N';
7107: ELSE
7108: x_progress := '20: purchasing_ou_check: result = Y';
7109: resultout := wf_engine.eng_completed || ':' || 'Y';
7110: END IF;
7111:
7112: IF (g_po_wf_debug = 'Y') THEN
7113: po_wf_debug_pkg.insert_debug (itemtype, itemkey, x_progress);

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

7273:
7274: IF l_return_status = FND_API.G_RET_STS_SUCCESS
7275: THEN
7276: x_progress := '10:ok_to_create_in_diff_ou: result = Y';
7277: resultout := wf_engine.eng_completed || ':' || 'Y';
7278: ELSE
7279: x_progress := '20: ok_to_create_in_diff_ou: result = N'
7280: || ' error msg: ' || l_error_msg_name;
7281: resultout := wf_engine.eng_completed || ':' || 'N';

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

7277: resultout := wf_engine.eng_completed || ':' || 'Y';
7278: ELSE
7279: x_progress := '20: ok_to_create_in_diff_ou: result = N'
7280: || ' error msg: ' || l_error_msg_name;
7281: resultout := wf_engine.eng_completed || ':' || 'N';
7282: END IF;
7283:
7284: IF (g_po_wf_debug = 'Y')
7285: THEN

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

7442: itemkey => itemkey,
7443: aname => 'LABOR_REQ_LINE_ID');
7444:
7445: IF (l_labor_req_line_id is not null) THEN
7446: resultout := wf_engine.eng_completed || ':' || 'Y';
7447:
7448: l_progress:= '10: is_expense_line: result = Y';
7449:
7450: IF (g_po_wf_debug = 'Y') THEN

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

7453: l_progress);
7454: END IF;
7455:
7456: ELSE
7457: resultout := wf_engine.eng_completed || ':' || 'N';
7458:
7459: l_progress:= '20: is_expense_line: result = N';
7460:
7461: IF (g_po_wf_debug = 'Y') THEN

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

7561: aname => 'CATALOG_TYPE');
7562:
7563: if nvl(x_catalog_type, 'CATALOG') <> 'TEMP_LABOR' then
7564:
7565: resultout := wf_engine.eng_completed || ':' || 'N';
7566:
7567: else
7568: resultout := wf_engine.eng_completed || ':' || 'Y';
7569:

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

7564:
7565: resultout := wf_engine.eng_completed || ':' || 'N';
7566:
7567: else
7568: resultout := wf_engine.eng_completed || ':' || 'Y';
7569:
7570: x_progress:= '10: temp_labor_item_check: result = '|| resultout;
7571: IF (g_po_wf_debug = 'Y') THEN
7572: po_wf_debug_pkg.insert_debug(itemtype,itemkey,x_progress);

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

7608:
7609:
7610: if nvl(x_incl_temp_labor_flag, 'N') <> 'Y' then
7611:
7612: resultout := wf_engine.eng_completed || ':' || 'N';
7613:
7614: return;
7615: else
7616: resultout:= wf_engine.eng_completed || ':' || 'Y';

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

7612: resultout := wf_engine.eng_completed || ':' || 'N';
7613:
7614: return;
7615: else
7616: resultout:= wf_engine.eng_completed || ':' || 'Y';
7617:
7618: return;
7619:
7620: end if;