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 89: wf_engine.CreateProcess(itemtype => itemtype,

85: ( req_header_id is NOT NULL ) THEN
86:
87: --Bug 5490243. Removed the commit introduced in Bug 3293852
88:
89: wf_engine.CreateProcess(itemtype => itemtype,
90: itemkey => itemkey,
91: process => workflow_process );
92:
93: x_progress:= '20: start_wf_process: Just after CreateProcess';

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

190: IF (g_po_wf_debug = 'Y') THEN
191: po_wf_debug_pkg.insert_debug(Itemtype,Itemkey,x_progress);
192: END IF;
193:
194: wf_engine.StartProcess(itemtype => itemtype,
195: itemkey => itemkey );
196:
197: END IF;
198:

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

231: itemkey => itemkey,
232: aname => 'AUTOCREATE_DOC');
233:
234: if (x_autocreate_doc = 'Y') then
235: resultout := wf_engine.eng_completed || ':' || 'Y';
236:
237: x_progress:= '10: should_req_be_autocreated: result = Y';
238: IF (g_po_wf_debug = 'Y') THEN
239: po_wf_debug_pkg.insert_debug(itemtype,itemkey,x_progress);

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

239: po_wf_debug_pkg.insert_debug(itemtype,itemkey,x_progress);
240: END IF;
241:
242: else
243: resultout := wf_engine.eng_completed || ':' || 'N';
244:
245: x_progress:= '20: should_req_be_autocreated: result = N';
246: IF (g_po_wf_debug = 'Y') THEN
247: po_wf_debug_pkg.insert_debug(itemtype,itemkey,x_progress);

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

666:
667: end loop;
668: close c2;
669: END IF;
670: resultout := wf_engine.eng_completed || ':' || 'ACTIVITY_PERFORMED';
671:
672: x_progress:= '40:launch_req_line_processing: result = ACTIVITY_PERFORMED';
673: IF (g_po_wf_debug = 'Y') THEN
674: po_wf_debug_pkg.insert_debug(itemtype,itemkey,x_progress);

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

754:
755: END LOOP;
756: CLOSE C_ConsumeReqLines;
757:
758: resultout := wf_engine.eng_completed || ':' || 'ACTIVITY_PERFORMED';
759:
760: x_progress:='40:launch_req_line_processing: result =ACTIVITY_PERFORMED';
761: IF (g_po_wf_debug = 'Y') THEN
762: po_wf_debug_pkg.insert_debug(itemtype,itemkey,x_progress);

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

810:
811: IF (ItemType is NOT NULL ) AND
812: (ItemKey is NOT NULL) AND
813: (req_line_id is NOT NULL ) then
814: wf_engine.CreateProcess(itemtype => itemtype,
815: itemkey => itemkey,
816: process => workflow_process );
817:
818: x_progress := '20: start_wf_line_process: Just after CreateProcess';

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

839:
840:
841: /* Need to set the parent child relationship between processes */
842:
843: wf_engine.SetItemParent (itemtype => itemtype,
844: itemkey => itemkey,
845: parent_itemtype => parent_itemtype,
846: parent_itemkey => parent_itemkey,
847: parent_context => NULL);

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

853: IF (g_po_wf_debug = 'Y') THEN
854: po_wf_debug_pkg.insert_debug(itemtype,itemkey,x_progress);
855: END IF;
856:
857: wf_engine.StartProcess(itemtype => itemtype,
858: itemkey => itemkey );
859:
860: end if;
861:

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

1140: aname => 'IS_CLM_FLOW',
1141: avalue => x_federal_flag);
1142:
1143:
1144: resultout := wf_engine.eng_completed || ':' || 'ACTIVITY_PERFORMED';
1145:
1146: x_progress:= '20: get_req_info: result = ACTIVITY_PERFORMED';
1147: IF (g_po_wf_debug = 'Y') THEN
1148: po_wf_debug_pkg.insert_debug(itemtype,itemkey,x_progress);

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

1206:
1207: if ((x_warn_rfq_required = 'Y') AND
1208: (x_rfq_required_flag = 'Y') AND
1209: ((x_on_rfq_flag is NULL) OR (x_on_rfq_flag = 'N'))) then
1210: resultout := wf_engine.eng_completed || ':' || 'Y';
1211:
1212: x_progress:= '10: rfq_required_check: result = Y';
1213: IF (g_po_wf_debug = 'Y') THEN
1214: po_wf_debug_pkg.insert_debug(itemtype,itemkey,x_progress);

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

1214: po_wf_debug_pkg.insert_debug(itemtype,itemkey,x_progress);
1215: END IF;
1216:
1217: else
1218: resultout := wf_engine.eng_completed || ':' || 'N';
1219:
1220: x_progress:= '20: rfq_required_check: result = N';
1221: IF (g_po_wf_debug = 'Y') THEN
1222: po_wf_debug_pkg.insert_debug(itemtype,itemkey,x_progress);

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

1329:
1330: /* If the vendor is not valid then we exit right here. */
1331:
1332: if (x_valid_vendor ='N') then
1333: resultout := wf_engine.eng_completed || ':' || 'N';
1334:
1335: x_progress:= '10: get_supp_info_for_acrt: result = N ' ||
1336: 'because the supplier id is invalid';
1337: IF (g_po_wf_debug = 'Y') THEN

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

1361:
1362: /* If the vendor is not valid then we exit right here. */
1363:
1364: if (x_valid_vendor ='N') then
1365: resultout := wf_engine.eng_completed || ':' || 'N';
1366:
1367: x_progress:= '20: get_supp_info_for_acrt: result = N ' ||
1368: 'because the supplier is null or invalid';
1369: IF (g_po_wf_debug = 'Y') THEN

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

1409:
1410: /* If the vendor site id is not valid then we exit right here. */
1411:
1412: if (x_valid_vendor_site ='N') then
1413: resultout := wf_engine.eng_completed || ':' || 'N';
1414:
1415: x_progress:= '30: get_supp_info_for_acrt: result = N ' ||
1416: 'becuase the supplier site id is invalid';
1417: IF (g_po_wf_debug = 'Y') THEN

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

1440:
1441: /* If the vendor site is not valid then we exit right here. */
1442:
1443: if (x_valid_vendor_site ='N') then
1444: resultout := wf_engine.eng_completed || ':' || 'N';
1445:
1446: x_progress:= '40: get_supp_info_for_acrt: result = N ' ||
1447: 'becuase the supplier site is null or invalid';
1448: IF (g_po_wf_debug = 'Y') THEN

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

1479: aname => 'SUGGESTED_VENDOR_LOCATION',
1480: avalue => x_vendor_site);
1481: /* Bug 2577940 */
1482:
1483: resultout := wf_engine.eng_completed || ':' || 'Y';
1484:
1485: x_progress:= '50: get_supp_info_for_acrt: result = Y';
1486: IF (g_po_wf_debug = 'Y') THEN
1487: po_wf_debug_pkg.insert_debug(itemtype,itemkey,x_progress);

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

1550:
1551: if ((x_source_doc_type_code is NULL) or
1552: (x_source_doc_po_header_id is NULL) or
1553: (x_source_doc_line_num is NULL)) then
1554: resultout := wf_engine.eng_completed || ':' || 'N';
1555:
1556: x_progress:= '10: is_source_doc_info_ok: result = N';
1557: IF (g_po_wf_debug = 'Y') THEN
1558: po_wf_debug_pkg.insert_debug(itemtype,itemkey,x_progress);

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

1565: --
1566: -- Check if clm requisition is referring a commerical agreement
1567: IF(nvl(x_is_clm_flow, 'N')= 'Y') THEN
1568: IF NOT (is_doc_clm_enabled(x_source_doc_po_header_id)) THEN
1569: resultout := wf_engine.eng_completed || ':' || 'N';
1570: x_progress:= '20: is_source_doc_info_ok: result = N';
1571: return;
1572: END IF;
1573: END IF;

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

1575:
1576: is_ga_still_valid(x_source_doc_po_header_id, l_source_doc_ok);
1577:
1578: IF l_source_doc_ok = 'N' THEN
1579: resultout := wf_engine.eng_completed || ':' || 'N';
1580:
1581: x_progress:= '30: is_source_doc_info_ok: result = N';
1582: ELSE
1583: resultout := wf_engine.eng_completed || ':' || 'Y';

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

1579: resultout := wf_engine.eng_completed || ':' || 'N';
1580:
1581: x_progress:= '30: is_source_doc_info_ok: result = N';
1582: ELSE
1583: resultout := wf_engine.eng_completed || ':' || 'Y';
1584:
1585: x_progress:= '30: is_source_doc_info_ok: result = Y';
1586: END IF;
1587:

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

1591:
1592: --
1593:
1594: else
1595: resultout := wf_engine.eng_completed || ':' || 'Y';
1596:
1597: x_progress:= '40: is_source_doc_info_ok: result = Y';
1598: IF (g_po_wf_debug = 'Y') THEN
1599: po_wf_debug_pkg.insert_debug(itemtype,itemkey,x_progress);

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

1741: aname => 'CURRENCY_CODE');
1742:
1743: if nvl(x_use_contract_flag, 'N') <> 'Y' then
1744:
1745: resultout := wf_engine.eng_completed || ':' || 'N';
1746:
1747: return;
1748:
1749: end if;

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

1865: avalue => NULL);
1866:
1867: --
1868:
1869: resultout := wf_engine.eng_completed || ':' || 'Y';
1870:
1871: else
1872:
1873: resultout := wf_engine.eng_completed || ':' || 'N';

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

1869: resultout := wf_engine.eng_completed || ':' || 'Y';
1870:
1871: else
1872:
1873: resultout := wf_engine.eng_completed || ':' || 'N';
1874:
1875: end if;
1876:
1877: exception

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

1915: aname => 'PCARD_ID');
1916:
1917:
1918: if (x_pcard_id is NULL) then
1919: resultout := wf_engine.eng_completed || ':' || 'N';
1920:
1921: x_progress:= '10: is_req_pcard_line: result = N';
1922: IF (g_po_wf_debug = 'Y') THEN
1923: po_wf_debug_pkg.insert_debug(itemtype,itemkey,x_progress);

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

1925:
1926: purge_expense_lines(itemtype, itemkey); --
1927:
1928: else
1929: resultout := wf_engine.eng_completed || ':' || 'Y';
1930:
1931: x_progress:= '20: is_req_pcard_line: result = Y';
1932: IF (g_po_wf_debug = 'Y') THEN
1933: po_wf_debug_pkg.insert_debug(itemtype,itemkey,x_progress);

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

1976:
1977: if (x_suggested_buyer_id is NULL OR
1978: l_validate_result = FND_API.G_FALSE) then -- bug2821542
1979:
1980: resultout := wf_engine.eng_completed || ':' || 'ACTION_FAILED';
1981:
1982: x_progress:= '10: get_buyer_from_req_line: result = ACTION_FAILED';
1983: IF (g_po_wf_debug = 'Y') THEN
1984: po_wf_debug_pkg.insert_debug(itemtype,itemkey,x_progress);

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

1984: po_wf_debug_pkg.insert_debug(itemtype,itemkey,x_progress);
1985: END IF;
1986:
1987: else
1988: resultout := wf_engine.eng_completed || ':' || 'ACTION_SUCCEEDED';
1989:
1990: x_progress:= '20: get_buyer_from_req_line: result = ACTION_SUCCEEDED';
1991: IF (g_po_wf_debug = 'Y') THEN
1992: po_wf_debug_pkg.insert_debug(itemtype,itemkey,x_progress);

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

2075:
2076: if (x_buyer_id is NULL OR
2077: l_validate_result = FND_API.G_FALSE) then -- bug2821542
2078:
2079: resultout := wf_engine.eng_completed || ':' || 'ACTION_FAILED';
2080:
2081: x_progress:='10: get_buyer_from_item: result = ACTION_FAILED';
2082: IF (g_po_wf_debug = 'Y') THEN
2083: po_wf_debug_pkg.insert_debug(itemtype,itemkey,x_progress);

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

2088: itemkey => itemkey,
2089: aname => 'SUGGESTED_BUYER_ID',
2090: avalue => x_buyer_id);
2091:
2092: resultout := wf_engine.eng_completed || ':' || 'ACTION_SUCCEEDED';
2093:
2094: x_progress:='20: get_buyer_from_item: result = ACTION_SUCCEEDED';
2095: IF (g_po_wf_debug = 'Y') THEN
2096: po_wf_debug_pkg.insert_debug(itemtype,itemkey,x_progress);

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

2230:
2231: if (x_agent_id is NULL OR
2232: l_validate_result = FND_API.G_FALSE) then -- bug2821542
2233:
2234: resultout := wf_engine.eng_completed || ':' || 'ACTION_FAILED';
2235:
2236: x_progress := '30:get_buyer_from_category: result = ACTION_FAILED';
2237: IF (g_po_wf_debug = 'Y') THEN
2238: po_wf_debug_pkg.insert_debug(itemtype,itemkey,x_progress);

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

2244: itemkey => itemkey,
2245: aname => 'SUGGESTED_BUYER_ID',
2246: avalue => x_agent_id);
2247:
2248: resultout := wf_engine.eng_completed || ':' || 'ACTION_SUCCEEDED';
2249:
2250: x_progress := '40:get_buyer_from_category: result = ACTION_SUCCEEDED';
2251: IF (g_po_wf_debug = 'Y') THEN
2252: po_wf_debug_pkg.insert_debug(itemtype,itemkey,x_progress);

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

2331:
2332: if (x_agent_id is NULL OR
2333: l_validate_result = FND_API.G_FALSE) then -- bug2821542
2334:
2335: resultout := wf_engine.eng_completed || ':' || 'ACTION_FAILED';
2336:
2337: x_progress := '30:get_buyer_from_source_doc: result = ACTION_FAILED';
2338: IF (g_po_wf_debug = 'Y') THEN
2339: po_wf_debug_pkg.insert_debug(itemtype,itemkey,x_progress);

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

2345: itemkey => itemkey,
2346: aname => 'SUGGESTED_BUYER_ID',
2347: avalue => x_agent_id);
2348:
2349: resultout := wf_engine.eng_completed || ':' || 'ACTION_SUCCEEDED';
2350:
2351: x_progress := '40:get_buyer_from_source_doc: result = ACTION_SUCCEEDED';
2352: IF (g_po_wf_debug = 'Y') THEN
2353: po_wf_debug_pkg.insert_debug(itemtype,itemkey,x_progress);

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

2417:
2418: if (x_agent_id is NULL OR
2419: l_validate_result = FND_API.G_FALSE) then -- bug2821542
2420:
2421: resultout := wf_engine.eng_completed || ':' || 'ACTION_FAILED';
2422:
2423: x_progress := '30:get_buyer_from_source_doc: result = ACTION_FAILED';
2424: IF (g_po_wf_debug = 'Y') THEN
2425: po_wf_debug_pkg.insert_debug(itemtype,itemkey,x_progress);

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

2432: itemkey => itemkey,
2433: aname => 'SUGGESTED_BUYER_ID',
2434: avalue => x_agent_id);
2435:
2436: resultout := wf_engine.eng_completed || ':' || 'ACTION_SUCCEEDED';
2437:
2438: x_progress := '40:get_buyer_from_contract: result = ACTION_SUCCEEDED';
2439: IF (g_po_wf_debug = 'Y') THEN
2440: po_wf_debug_pkg.insert_debug(itemtype,itemkey,x_progress);

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

2487:
2488: /* FPI GA End */
2489: /* draising 2692119 */
2490: if (x_source_doc_type_code is null) then
2491: resultout := wf_engine.eng_completed || ':' || 'NONE';
2492:
2493: x_progress := '10: get_source_doc_type: result = NONE';
2494: IF (g_po_wf_debug = 'Y') THEN
2495: po_wf_debug_pkg.insert_debug(itemtype,itemkey,x_progress);

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

2497:
2498: elsif (x_source_doc_type_code = 'BLANKET') then
2499: if nvl(x_ga_flag,'N') = 'Y' then -- FPI GA
2500: x_progress := '10: get_source_doc_type: result = GLOBAL_PA';
2501: resultout := wf_engine.eng_completed || ':' || 'GLOBAL_PA'; -- FPI GA
2502: else
2503: x_progress := '10: get_source_doc_type: result = BLANKET_PO';
2504: resultout := wf_engine.eng_completed || ':' || 'BLANKET_PO';
2505: end if;

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

2500: x_progress := '10: get_source_doc_type: result = GLOBAL_PA';
2501: resultout := wf_engine.eng_completed || ':' || 'GLOBAL_PA'; -- FPI GA
2502: else
2503: x_progress := '10: get_source_doc_type: result = BLANKET_PO';
2504: resultout := wf_engine.eng_completed || ':' || 'BLANKET_PO';
2505: end if;
2506:
2507: x_progress := '10: get_source_doc_type: result = BLANKET_PO';
2508: IF (g_po_wf_debug = 'Y') THEN

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

2509: po_wf_debug_pkg.insert_debug(itemtype,itemkey,x_progress);
2510: END IF;
2511:
2512: elsif (x_source_doc_type_code = 'CONTRACT') then
2513: resultout := wf_engine.eng_completed || ':' || 'CONTRACT_PO';
2514:
2515: x_progress := '10: get_source_doc_type: result = CONTRACT_PO';
2516: IF (g_po_wf_debug = 'Y') THEN
2517: po_wf_debug_pkg.insert_debug(itemtype,itemkey,x_progress);

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

2518: END IF;
2519:
2520: else
2521: /* Must be QUOTATION */
2522: resultout := wf_engine.eng_completed || ':' || 'QUOTATION';
2523:
2524: x_progress := '10: get_source_doc_type: result = QUOTATION';
2525: IF (g_po_wf_debug = 'Y') THEN
2526: po_wf_debug_pkg.insert_debug(itemtype,itemkey,x_progress);

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

2559:
2560: /* If item_id is null then this is a one-time item. */
2561:
2562: if (x_item_id is NULL) then
2563: resultout := wf_engine.eng_completed || ':' || 'Y';
2564:
2565: x_progress:= '10: one_time_item_check: result = Y';
2566: IF (g_po_wf_debug = 'Y') THEN
2567: po_wf_debug_pkg.insert_debug(itemtype,itemkey,x_progress);

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

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

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

2746: aname => 'REL_GEN_METHOD',
2747: avalue => x_rel_gen_method);
2748:
2749: if (x_rel_gen_method is NULL) then
2750: resultout := wf_engine.eng_completed || ':' || 'NO_METHOD_FOUND';
2751:
2752: x_progress:= '10: get_rel_gen_method: result = NO_METHOD_FOUND';
2753: IF (g_po_wf_debug = 'Y') THEN
2754: po_wf_debug_pkg.insert_debug(itemtype,itemkey,x_progress);

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

2754: po_wf_debug_pkg.insert_debug(itemtype,itemkey,x_progress);
2755: END IF;
2756:
2757: else
2758: resultout := wf_engine.eng_completed || ':' || x_rel_gen_method;
2759:
2760: x_progress:= '20: get_rel_gen_method: ' || 'result = ' || x_rel_gen_method;
2761: IF (g_po_wf_debug = 'Y') THEN
2762: po_wf_debug_pkg.insert_debug(itemtype,itemkey,x_progress);

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

2801: itemkey => itemkey,
2802: aname => 'CONT_WF_FOR_AC_REL_GEN');
2803:
2804: if (x_cont_wf_for_ac_rel_gen = 'Y') then
2805: resultout := wf_engine.eng_completed || ':' || 'Y';
2806:
2807: x_progress:= '10: cont_wf_autocreate_rel_gen: Y';
2808: IF (g_po_wf_debug = 'Y') THEN
2809: po_wf_debug_pkg.insert_debug(itemtype,itemkey,x_progress);

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

2809: po_wf_debug_pkg.insert_debug(itemtype,itemkey,x_progress);
2810: END IF;
2811:
2812: else
2813: resultout := wf_engine.eng_completed || ':' || 'N';
2814:
2815: x_progress:= '20: cont_wf_autocreate_rel_gen: N';
2816: IF (g_po_wf_debug = 'Y') THEN
2817: po_wf_debug_pkg.insert_debug(itemtype,itemkey,x_progress);

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

3035: /* Calling process should do the commit, so comment out here.
3036: * COMMIT;
3037: */
3038:
3039: resultout := wf_engine.eng_completed || ':' || 'ACTIVITY_PERFORMED';
3040:
3041: x_progress:= '20: insert_cand_req_lines_into_tbl: ACTIVITY_PERFORMED';
3042: IF (g_po_wf_debug = 'Y') THEN
3043: po_wf_debug_pkg.insert_debug(itemtype,itemkey,x_progress);

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

4002: /* Calling process should do the commit, so comment out here.
4003: * COMMIT;
4004: */
4005:
4006: resultout := wf_engine.eng_completed || ':' || 'ACTIVITY_PERFORMED';
4007:
4008: x_progress := '60: group_req_lines: result = ACTIVITY_PERFORMED ';
4009: IF (g_po_wf_debug = 'Y') THEN
4010: po_wf_debug_pkg.insert_debug(itemtype,itemkey,x_progress);

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

4887:
4888: end loop;
4889: close c1;
4890:
4891: resultout := wf_engine.eng_completed || ':' || 'ACTIVITY_PERFORMED';
4892:
4893: x_progress := '20: launch_doc_creation_approval: result = ACTIVITY_PERFORMED';
4894: IF (g_po_wf_debug = 'Y') THEN
4895: po_wf_debug_pkg.insert_debug(itemtype,itemkey,x_progress);

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

4941:
4942: IF (ItemType is NOT NULL ) AND
4943: (ItemKey is NOT NULL) AND
4944: (interface_header_id is NOT NULL ) then
4945: wf_engine.CreateProcess(itemtype => itemtype,
4946: itemkey => itemkey,
4947: process => workflow_process );
4948:
4949: x_progress:= '20. start_wf_create_apprv_process: Just after create process';

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

4984:
4985:
4986: /* Need to set the parent child relationship between processes */
4987:
4988: wf_engine.SetItemParent (itemtype => itemtype,
4989: itemkey => itemkey,
4990: parent_itemtype => parent_itemtype,
4991: parent_itemkey => parent_itemkey,
4992: parent_context => NULL);

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

5000: IF (g_po_wf_debug = 'Y') THEN
5001: po_wf_debug_pkg.insert_debug(itemtype,itemkey,x_progress);
5002: END IF;
5003:
5004: wf_engine.StartProcess(itemtype => itemtype,
5005: itemkey => itemkey );
5006:
5007: END IF;
5008:

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

5146: */
5147:
5148: po_autocreate_doc.setup_notification_data (itemtype, itemkey);
5149:
5150: resultout := wf_engine.eng_completed || ':' || 'CREATE_OK';
5151:
5152: x_progress:= '30: create_doc: result = CREATE_OK';
5153: IF (g_po_wf_debug = 'Y') THEN
5154: po_wf_debug_pkg.insert_debug(itemtype,itemkey,x_progress);

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

5154: po_wf_debug_pkg.insert_debug(itemtype,itemkey,x_progress);
5155: END IF;
5156:
5157: else
5158: resultout := wf_engine.eng_completed || ':' || 'CREATE_FAILED';
5159:
5160: x_progress:= '40: create_doc: result = CREATE_FAILED';
5161: IF (g_po_wf_debug = 'Y') THEN
5162: po_wf_debug_pkg.insert_debug(itemtype,itemkey,x_progress);

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

5481: x_fax_number => l_fax_number,
5482: x_document_num => l_document_number);
5483:
5484: IF l_default_method = 'EMAIL' AND (l_emailaddress IS NULL OR l_emailaddress='') THEN
5485: resultout := wf_engine.eng_completed || ':' || 'N';
5486:
5487: x_progress:= '0: should_doc_be_approved: result = N';
5488: IF (g_po_wf_debug = 'Y') THEN
5489: po_wf_debug_pkg.insert_debug(itemtype,itemkey,x_progress);

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

5489: po_wf_debug_pkg.insert_debug(itemtype,itemkey,x_progress);
5490: END IF;
5491:
5492: ELSIF l_default_method = 'FAX' AND (l_fax_number IS NULL OR l_fax_number='') THEN
5493: resultout := wf_engine.eng_completed || ':' || 'N';
5494:
5495: x_progress:= '1: should_doc_be_approved: result = N';
5496: IF (g_po_wf_debug = 'Y') THEN
5497: po_wf_debug_pkg.insert_debug(itemtype,itemkey,x_progress);

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

5496: IF (g_po_wf_debug = 'Y') THEN
5497: po_wf_debug_pkg.insert_debug(itemtype,itemkey,x_progress);
5498: END IF;
5499: ELSE
5500: resultout := wf_engine.eng_completed || ':' || 'Y';
5501:
5502: x_progress:= '10: should_doc_be_approved: result = Y';
5503: IF (g_po_wf_debug = 'Y') THEN
5504: po_wf_debug_pkg.insert_debug(itemtype,itemkey,x_progress);

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

5506: END IF;
5507: --END of code changes for the bug 14243104 fix
5508:
5509: else
5510: resultout := wf_engine.eng_completed || ':' || 'N';
5511:
5512: x_progress:= '20: should_doc_be_approved: result = N';
5513: IF (g_po_wf_debug = 'Y') THEN
5514: po_wf_debug_pkg.insert_debug(itemtype,itemkey,x_progress);

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

5837: x_faxnum,
5838: x_emailflag,
5839: x_emailaddress);
5840:
5841: resultout := wf_engine.eng_completed || ':' || 'ACTIVITY_PERFORMED';
5842:
5843: x_progress:= '20: launch_po_approval: result = ACTIVITY_PERFORMED';
5844: IF (g_po_wf_debug = 'Y') THEN
5845: po_wf_debug_pkg.insert_debug(itemtype,itemkey,x_progress);

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

5890: /* Calling process should do the commit, so comment out here.
5891: * COMMIT;
5892: */
5893:
5894: resultout := wf_engine.eng_completed || ':' || 'ACTIVITY_PERFORMED';
5895:
5896: x_progress:= '10: purge_rows_from_temp_table: result = ACTIVITY_PERFORMED';
5897: IF (g_po_wf_debug = 'Y') THEN
5898: po_wf_debug_pkg.insert_debug(itemtype,itemkey,x_progress);

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

5935: WHERE requisition_header_id=x_req_header_id;
5936: EXCEPTION
5937: WHEN OTHERS THEN
5938:
5939: resultout := wf_engine.eng_completed || ':' || 'N';
5940: x_progress:= '10: is_this_emergency_req: result = N';
5941: IF (g_po_wf_debug = 'Y') THEN
5942: po_wf_debug_pkg.insert_debug(itemtype,itemkey,x_progress);
5943: END IF;

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

5944:
5945: END;
5946:
5947: IF x_emergency_po_num IS NOT NULL THEN
5948: resultout := wf_engine.eng_completed || ':' || 'Y';
5949: x_progress:= '20: is_this_emergency_req: result = Y';
5950: IF (g_po_wf_debug = 'Y') THEN
5951: po_wf_debug_pkg.insert_debug(itemtype,itemkey,x_progress);
5952: END IF;

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

5951: po_wf_debug_pkg.insert_debug(itemtype,itemkey,x_progress);
5952: END IF;
5953:
5954: ELSE
5955: resultout := wf_engine.eng_completed || ':' || 'N';
5956: x_progress:= '30: is_this_emergency_req: result = N';
5957: IF (g_po_wf_debug = 'Y') THEN
5958: po_wf_debug_pkg.insert_debug(itemtype,itemkey,x_progress);
5959: END IF;

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

6305: end;
6306: end if;
6307:
6308:
6309: resultout := wf_engine.eng_completed || ':' || 'ACTIVITY_PERFORMED';
6310:
6311: x_progress := '40: put_on_one_po: result = ACTIVITY_PERFORMED ';
6312: IF (g_po_wf_debug = 'Y') THEN
6313: po_wf_debug_pkg.insert_debug(itemtype,itemkey,x_progress);

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

6493:
6494: select to_char(PO_WF_ITEMKEY_S.NEXTVAL) into l_seq from sys.dual;
6495: ItemKey := to_char(p_req_header_id) || '-' || l_seq;
6496:
6497: wf_engine.CreateProcess( ItemType => ItemType,
6498: ItemKey => ItemKey,
6499: process => 'NOTIFY_RETURN_REQ');
6500:
6501: x_progress := 'PO_AUTOCREATE_DOC.send_return_notif: 050 - '||

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

6608: -- the workflow will set a null context.
6609: l_user_id := FND_GLOBAL.user_id;
6610: l_responsibility_id := FND_GLOBAL.resp_id;
6611: l_application_id := FND_GLOBAL.resp_appl_id;
6612: wf_engine.SetItemAttrNumber ( itemtype => itemtype,
6613: itemkey => itemkey,
6614: aname => 'USER_ID',
6615: avalue => l_user_id);
6616:

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

6613: itemkey => itemkey,
6614: aname => 'USER_ID',
6615: avalue => l_user_id);
6616:
6617: wf_engine.SetItemAttrNumber ( itemtype => itemtype,
6618: itemkey => itemkey,
6619: aname => 'APPLICATION_ID',
6620: avalue => l_application_id);
6621:

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

6618: itemkey => itemkey,
6619: aname => 'APPLICATION_ID',
6620: avalue => l_application_id);
6621:
6622: wf_engine.SetItemAttrNumber ( itemtype => itemtype,
6623: itemkey => itemkey,
6624: aname => 'RESPONSIBILITY_ID',
6625: avalue => l_responsibility_id);
6626: -- bug 5657496

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

6630: IF (g_po_wf_debug = 'Y') THEN
6631: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);
6632: END IF;
6633:
6634: wf_engine.StartProcess(itemtype => itemtype,
6635: itemkey => itemkey );
6636:
6637:
6638: EXCEPTION

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

6722: aname => 'CONTRACT_REQUIRED_FLAG');
6723:
6724: if nvl(x_contract_required_flag, 'N') <> 'Y' then
6725:
6726: resultout := wf_engine.eng_completed || ':' || 'N';
6727:
6728: return;
6729: else
6730: resultout:= wf_engine.eng_completed || ':' || 'Y';

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

6726: resultout := wf_engine.eng_completed || ':' || 'N';
6727:
6728: return;
6729: else
6730: resultout:= wf_engine.eng_completed || ':' || 'Y';
6731:
6732: return;
6733:
6734: end if;

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

6765: aname => 'USE_CONTRACT_FLAG');
6766:
6767: if nvl(x_use_contract_flag, 'N') <> 'Y' then
6768:
6769: resultout := wf_engine.eng_completed || ':' || 'N';
6770:
6771: return;
6772: else
6773: resultout:= wf_engine.eng_completed || ':' || 'Y';

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

6769: resultout := wf_engine.eng_completed || ':' || 'N';
6770:
6771: return;
6772: else
6773: resultout:= wf_engine.eng_completed || ':' || 'Y';
6774:
6775: return;
6776:
6777: end if;

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

6810: aname => 'CATALOG_TYPE');
6811:
6812: if nvl(x_catalog_type, 'CATALOG') <> 'NONCATALOG' then
6813:
6814: resultout := wf_engine.eng_completed || ':' || 'N';
6815:
6816: else
6817: resultout := wf_engine.eng_completed || ':' || 'Y';
6818:

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

6813:
6814: resultout := wf_engine.eng_completed || ':' || 'N';
6815:
6816: else
6817: resultout := wf_engine.eng_completed || ':' || 'Y';
6818:
6819: x_progress:= '10: non_catalog_item_check: result = '|| resultout;
6820: IF (g_po_wf_debug = 'Y') THEN
6821: po_wf_debug_pkg.insert_debug(itemtype,itemkey,x_progress);

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

6902: --
6903: --Check if CLM req is referring a commercial contract
6904: IF (NVL(x_is_clm_flow,'N')= 'Y') THEN
6905: IF NOT (is_doc_clm_enabled(x_source_doc_po_header_id)) THEN
6906: resultout := wf_engine.eng_completed || ':' || 'N';
6907: return;
6908: END IF;
6909: END IF;
6910: --

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

6952: end;
6953:
6954: if (x_contract_id_valid = -1 ) then
6955:
6956: resultout := wf_engine.eng_completed || ':' || 'N';
6957:
6958: elsif (x_contract_id_valid = x_source_doc_po_header_id) then
6959: -- bug 3079146
6960: -- if currency didn't match, don't create po

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

6962: l_base_currency := PO_CORE_S2.get_base_currency;
6963:
6964: 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
6965:
6966: resultout := wf_engine.eng_completed || ':' || 'Y';
6967:
6968: else
6969: resultout := wf_engine.eng_completed || ':' || 'N';
6970: po_wf_util_pkg.SetItemAttrText (itemtype => itemtype,

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

6965:
6966: resultout := wf_engine.eng_completed || ':' || 'Y';
6967:
6968: else
6969: resultout := wf_engine.eng_completed || ':' || 'N';
6970: po_wf_util_pkg.SetItemAttrText (itemtype => itemtype,
6971: itemkey => itemkey,
6972: aname => 'CONTRACT_REQUIRED_FLAG',
6973: avalue => 'Y');

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

6974: end if;
6975:
6976: else
6977:
6978: resultout := wf_engine.eng_completed || ':' || 'N';
6979:
6980: end if;
6981:
6982: x_progress:= '10: is_source_doc_info_ok: result = ' || resultout;

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

6999: avalue => NULL);
7000:
7001: --
7002: else
7003: resultout := wf_engine.eng_completed || ':' || 'N';
7004:
7005: x_progress:= '20: is_contract_info_ok: result = N';
7006: IF (g_po_wf_debug = 'Y') THEN
7007: po_wf_debug_pkg.insert_debug(itemtype,itemkey,x_progress);

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

7046:
7047:
7048: if nvl(x_incl_non_ctlg_req_flag, 'N') <> 'Y' then
7049:
7050: resultout := wf_engine.eng_completed || ':' || 'N';
7051:
7052: return;
7053: else
7054: resultout:= wf_engine.eng_completed || ':' || 'Y';

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

7050: resultout := wf_engine.eng_completed || ':' || 'N';
7051:
7052: return;
7053: else
7054: resultout:= wf_engine.eng_completed || ':' || 'Y';
7055:
7056: return;
7057:
7058: end if;

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

7162: if nvl(x_ga_flag,'N') = 'Y' and
7163: x_owning_org_id <> x_org_id then
7164:
7165: x_progress := '10: is_src_doc_ga_frm_other_ou: result = Y';
7166: resultout := wf_engine.eng_completed || ':' || 'Y';
7167: else
7168: x_progress := '20: is_src_doc_ga_frm_other_ou: result = N';
7169: resultout := wf_engine.eng_completed || ':' || 'N';
7170: end if;

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

7165: x_progress := '10: is_src_doc_ga_frm_other_ou: result = Y';
7166: resultout := wf_engine.eng_completed || ':' || 'Y';
7167: else
7168: x_progress := '20: is_src_doc_ga_frm_other_ou: result = N';
7169: resultout := wf_engine.eng_completed || ':' || 'N';
7170: end if;
7171:
7172: IF (g_po_wf_debug = 'Y') THEN
7173: po_wf_debug_pkg.insert_debug(Itemtype,Itemkey,x_progress);

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

7307: END IF;
7308:
7309: IF (NVL(hr_general.get_xbg_profile, 'N') = 'Y') THEN
7310: x_progress := '10: buyer_on_src_doc_ok: result = Y';
7311: resultout := wf_engine.eng_completed || ':' || 'Y';
7312: ELSE --cross business group profile is 'N'
7313: x_source_doc_po_header_id := po_wf_util_pkg.GetItemAttrNumber
7314: (itemtype => itemtype,
7315: itemkey => itemkey,

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

7328: IF ((x_source_doc_type_code = 'QUOTATION') OR
7329: (x_source_doc_type_code = 'BLANKET' AND NVL(x_ga_flag, 'N') = 'N')) THEN
7330:
7331: x_progress := '20: buyer_on_src_doc_ok: result = Y';
7332: resultout := wf_engine.eng_completed || ':' || 'Y';
7333:
7334: ELSIF x_source_doc_type_code = 'BLANKET' AND NVL(x_ga_flag, 'N') = 'Y' THEN
7335:
7336: BEGIN

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

7352: END;
7353:
7354: IF l_return_status = 'Y' THEN
7355: x_progress := '30: buyer_on_src_doc_ok: result = Y';
7356: resultout := wf_engine.eng_completed || ':' || 'Y';
7357: ELSE
7358: x_progress := '40: buyer_on_src_doc_ok: result = N';
7359: resultout := wf_engine.eng_completed || ':' || 'N';
7360: END IF;

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

7355: x_progress := '30: buyer_on_src_doc_ok: result = Y';
7356: resultout := wf_engine.eng_completed || ':' || 'Y';
7357: ELSE
7358: x_progress := '40: buyer_on_src_doc_ok: result = N';
7359: resultout := wf_engine.eng_completed || ':' || 'N';
7360: END IF;
7361:
7362: ELSE
7363: x_progress := '50: buyer_on_src_doc_ok: result = N';

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

7360: END IF;
7361:
7362: ELSE
7363: x_progress := '50: buyer_on_src_doc_ok: result = N';
7364: resultout := wf_engine.eng_completed || ':' || 'N';
7365:
7366: END IF; --source doc check
7367: END IF; --check profile option
7368:

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

7437: END IF;
7438:
7439: IF (NVL(hr_general.get_xbg_profile, 'N') = 'Y') THEN
7440: x_progress := '10: buyer_on_contract_ok: result = Y';
7441: resultout := wf_engine.eng_completed || ':' || 'Y';
7442: ELSE -- cross business group profile is 'N'
7443: x_contract_id := po_wf_util_pkg.GetItemAttrNumber
7444: (itemtype => itemtype,
7445: itemkey => itemkey,

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

7464: END;
7465:
7466: IF l_return_status = 'Y' THEN
7467: x_progress := '20: buyer_on_contract_ok: result = Y';
7468: resultout := wf_engine.eng_completed || ':' || 'Y';
7469: ELSE
7470: x_progress := '30: buyer_on_contract_ok: result = N';
7471: resultout := wf_engine.eng_completed || ':' || 'N';
7472:

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

7467: x_progress := '20: buyer_on_contract_ok: result = Y';
7468: resultout := wf_engine.eng_completed || ':' || 'Y';
7469: ELSE
7470: x_progress := '30: buyer_on_contract_ok: result = N';
7471: resultout := wf_engine.eng_completed || ':' || 'N';
7472:
7473: purge_expense_lines(itemtype, itemkey); --
7474:
7475: END IF;

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

7476:
7477: ELSE --contract id is null
7478:
7479: x_progress := '40: buyer_on_contract_ok: result = N';
7480: resultout := wf_engine.eng_completed || ':' || 'N';
7481:
7482: purge_expense_lines(itemtype, itemkey); --
7483:
7484: END IF; --contract_id check

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

7555: aname => 'PURCHASING_ORG_ID');
7556:
7557: IF l_org_id = l_purchasing_org_id THEN
7558: x_progress := '10: purchasing_ou_check: result = N';
7559: resultout := wf_engine.eng_completed || ':' || 'N';
7560: ELSE
7561: x_progress := '20: purchasing_ou_check: result = Y';
7562: resultout := wf_engine.eng_completed || ':' || 'Y';
7563: END IF;

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

7558: x_progress := '10: purchasing_ou_check: result = N';
7559: resultout := wf_engine.eng_completed || ':' || 'N';
7560: ELSE
7561: x_progress := '20: purchasing_ou_check: result = Y';
7562: resultout := wf_engine.eng_completed || ':' || 'Y';
7563: END IF;
7564:
7565: IF (g_po_wf_debug = 'Y') THEN
7566: po_wf_debug_pkg.insert_debug (itemtype, itemkey, x_progress);

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

7726:
7727: IF l_return_status = FND_API.G_RET_STS_SUCCESS
7728: THEN
7729: x_progress := '10:ok_to_create_in_diff_ou: result = Y';
7730: resultout := wf_engine.eng_completed || ':' || 'Y';
7731: ELSE
7732: x_progress := '20: ok_to_create_in_diff_ou: result = N'
7733: || ' error msg: ' || l_error_msg_name;
7734: resultout := wf_engine.eng_completed || ':' || 'N';

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

7730: resultout := wf_engine.eng_completed || ':' || 'Y';
7731: ELSE
7732: x_progress := '20: ok_to_create_in_diff_ou: result = N'
7733: || ' error msg: ' || l_error_msg_name;
7734: resultout := wf_engine.eng_completed || ':' || 'N';
7735: END IF;
7736:
7737: IF (g_po_wf_debug = 'Y')
7738: THEN

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

7895: itemkey => itemkey,
7896: aname => 'LABOR_REQ_LINE_ID');
7897:
7898: IF (l_labor_req_line_id is not null) THEN
7899: resultout := wf_engine.eng_completed || ':' || 'Y';
7900:
7901: l_progress:= '10: is_expense_line: result = Y';
7902:
7903: IF (g_po_wf_debug = 'Y') THEN

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

7906: l_progress);
7907: END IF;
7908:
7909: ELSE
7910: resultout := wf_engine.eng_completed || ':' || 'N';
7911:
7912: l_progress:= '20: is_expense_line: result = N';
7913:
7914: IF (g_po_wf_debug = 'Y') THEN

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

8014: aname => 'CATALOG_TYPE');
8015:
8016: if nvl(x_catalog_type, 'CATALOG') <> 'TEMP_LABOR' then
8017:
8018: resultout := wf_engine.eng_completed || ':' || 'N';
8019:
8020: else
8021: resultout := wf_engine.eng_completed || ':' || 'Y';
8022:

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

8017:
8018: resultout := wf_engine.eng_completed || ':' || 'N';
8019:
8020: else
8021: resultout := wf_engine.eng_completed || ':' || 'Y';
8022:
8023: x_progress:= '10: temp_labor_item_check: result = '|| resultout;
8024: IF (g_po_wf_debug = 'Y') THEN
8025: po_wf_debug_pkg.insert_debug(itemtype,itemkey,x_progress);

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

8061:
8062:
8063: if nvl(x_incl_temp_labor_flag, 'N') <> 'Y' then
8064:
8065: resultout := wf_engine.eng_completed || ':' || 'N';
8066:
8067: return;
8068: else
8069: resultout:= wf_engine.eng_completed || ':' || 'Y';

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

8065: resultout := wf_engine.eng_completed || ':' || 'N';
8066:
8067: return;
8068: else
8069: resultout:= wf_engine.eng_completed || ':' || 'Y';
8070:
8071: return;
8072:
8073: end if;