[Home] [Help]
64: 'po_number = ' || po_number || '/ ' ||
65: 'interface_source_code = ' || interface_source_code;
66:
67: IF (g_po_wf_debug = 'Y') THEN
68: po_wf_debug_pkg.insert_debug(Itemtype,Itemkey,x_progress);
69: END IF;
70:
71:
72: /* If a process is passed then it will be run
85: process => workflow_process );
86:
87: x_progress:= '20: start_wf_process: Just after CreateProcess';
88: IF (g_po_wf_debug = 'Y') THEN
89: po_wf_debug_pkg.insert_debug(Itemtype,Itemkey,x_progress);
90: END IF;
91:
92:
93: /* Initialize workflow item attributes */
171: /* Kick off the process */
172:
173: x_progress := '30: start_wf_process: Kicking off StartProcess ';
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 );
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);
224: END IF;
225:
226: else
227: resultout := wf_engine.eng_completed || ':' || 'N';
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);
232: END IF;
233: end if;
234:
235: exception
422: x_progress:= '10: launch_req_line_processing: Just before opening cursor c1 ' ||
423: 'for req_header_id = ' || to_char(x_req_header_id);
424:
425: IF (g_po_wf_debug = 'Y') THEN
426: po_wf_debug_pkg.insert_debug(itemtype,itemkey,x_progress);
427: END IF;
428:
429: open c1; /* Based on x_req_header_id */
430:
434:
435: x_progress:= '20: launch_req_line_processing: In loop,fetched c1 req_line_id = '||
436: to_char(x_req_line_id);
437: IF (g_po_wf_debug = 'Y') THEN
438: po_wf_debug_pkg.insert_debug(itemtype,itemkey,x_progress);
439: END IF;
440:
441: /* Get the unique sequence to make sure item key will be unique */
442:
462: || '/ ' || 'called_item_key = ' || x_ItemKey || '/ ' ||
463: 'group_id = ' || to_char(x_group_id);
464:
465: IF (g_po_wf_debug = 'Y') THEN
466: po_wf_debug_pkg.insert_debug(itemtype,itemkey,x_progress);
467: END IF;
468:
469: po_autocreate_doc.start_wf_line_process (x_ItemType,
470: x_ItemKey,
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);
486: END IF;
487:
488: --
489: ELSE --if l_consume_req_demand_doc_id is not null
511: || 'for l_consume_req_demand_doc_id='
512: || to_char(l_consume_req_demand_doc_id);
513:
514: IF (g_po_wf_debug = 'Y') THEN
515: po_wf_debug_pkg.insert_debug(itemtype,itemkey,x_progress);
516: END IF;
517:
518: OPEN C_ConsumeReqLines;
519:
524: x_progress:= '20: launch_req_line_processing: In loop,fetched'
525: ||' C_ConsumeReqLines req_line_id = '
526: || to_char(x_req_line_id);
527: IF (g_po_wf_debug = 'Y') THEN
528: po_wf_debug_pkg.insert_debug(itemtype,itemkey,x_progress);
529: END IF;
530:
531: --Get the unique sequence to make sure item key will be unique
532:
550: || x_ItemKey || '/ ' || 'group_id = '
551: || to_char(x_group_id);
552:
553: IF (g_po_wf_debug = 'Y') THEN
554: po_wf_debug_pkg.insert_debug(itemtype,itemkey,x_progress);
555: END IF;
556:
557: po_autocreate_doc.start_wf_line_process (x_ItemType,
558: x_ItemKey,
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);
574: END IF;
575: END IF; --l_consume_req_demand_doc_id is null--
576: --
577:
610:
611: x_progress := '10: start_wf_line_process: Called with item_type = ' || ItemType ||
612: '/ '|| 'item_key = ' || ItemKey;
613: IF (g_po_wf_debug = 'Y') THEN
614: po_wf_debug_pkg.insert_debug(itemtype,itemkey,x_progress);
615: END IF;
616:
617: /* If a process is passed then it will be run
618: * If a process is not passed then the selector function defined in
627: process => workflow_process );
628:
629: x_progress := '20: start_wf_line_process: Just after CreateProcess';
630: IF (g_po_wf_debug = 'Y') THEN
631: po_wf_debug_pkg.insert_debug(itemtype,itemkey,x_progress);
632: END IF;
633:
634: /* Initialize workflow item attributes */
635:
661: /* Kick off the process */
662:
663: x_progress:= '30: start_wf_line_process: Kicking off StartProcess';
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 );
673: exception
674: when others then
675: x_progress:= '40: start_wf_line_process: IN EXCEPTION';
676: IF (g_po_wf_debug = 'Y') THEN
677: po_wf_debug_pkg.insert_debug(itemtype,itemkey,x_progress);
678: END IF;
679: raise;
680: end start_wf_line_process;
681:
792:
793: x_progress:= '10: get_req_info: Just after executing sql stmt with req_line_id ' ||
794: to_char(x_req_line_id);
795: IF (g_po_wf_debug = 'Y') THEN
796: po_wf_debug_pkg.insert_debug(itemtype,itemkey,x_progress);
797: END IF;
798:
799:
800: /* Set the item attributes */
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);
948: END IF;
949:
950: exception
951: when others 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);
1014: END IF;
1015:
1016: else
1017: resultout := wf_engine.eng_completed || ':' || 'N';
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);
1022: END IF;
1023:
1024: end if;
1025:
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
1137: po_wf_debug_pkg.insert_debug(itemtype,itemkey,x_progress);
1138: END IF;
1139:
1140: purge_expense_lines(itemtype, itemkey); --
1141:
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
1169: po_wf_debug_pkg.insert_debug(itemtype,itemkey,x_progress);
1170: END IF;
1171:
1172: purge_expense_lines(itemtype, itemkey); --
1173:
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
1217: po_wf_debug_pkg.insert_debug(itemtype,itemkey,x_progress);
1218: END IF;
1219:
1220: purge_expense_lines(itemtype, itemkey); --
1221:
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
1248: po_wf_debug_pkg.insert_debug(itemtype,itemkey,x_progress);
1249: END IF;
1250:
1251: purge_expense_lines(itemtype, itemkey); --
1252:
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);
1287: END IF;
1288:
1289: exception
1290: when others 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);
1352: END IF;
1353:
1354: --
1355: --Do not create PO if the referenced GA/Blanket is not valid
1368: x_progress:= '20: is_source_doc_info_ok: result = Y';
1369: END IF;
1370:
1371: IF (g_po_wf_debug = 'Y') THEN
1372: po_wf_debug_pkg.insert_debug(itemtype,itemkey,x_progress);
1373: END IF;
1374:
1375: --
1376:
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);
1383: END IF;
1384:
1385: end if;
1386:
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);
1707: END IF;
1708:
1709: purge_expense_lines(itemtype, itemkey); --
1710:
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);
1717: END IF;
1718:
1719: end if;
1720:
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);
1768: END IF;
1769:
1770: else
1771: resultout := wf_engine.eng_completed || ':' || 'ACTION_SUCCEEDED';
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);
1776: END IF;
1777:
1778: end if;
1779:
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);
1867: END IF;
1868:
1869: else
1870: po_wf_util_pkg.SetItemAttrNumber (itemtype => itemtype,
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);
1880: END IF;
1881:
1882: end if;
1883:
1943: x_agent_id := NULL;
1944:
1945: x_progress := '10: get_buyer_from_category: More than 1 buyer for this category ';
1946: IF (g_po_wf_debug = 'Y') THEN
1947: po_wf_debug_pkg.insert_debug(itemtype,itemkey,x_progress);
1948: END IF;
1949:
1950: when NO_DATA_FOUND then
1951:
1952: x_agent_id := NULL;
1953:
1954: x_progress := '20:get_buyer_from_category: No buyer assinged to category';
1955: IF (g_po_wf_debug = 'Y') THEN
1956: po_wf_debug_pkg.insert_debug(itemtype,itemkey,x_progress);
1957: END IF;
1958:
1959: end;
1960:
1986: x_agent_id := NULL;
1987:
1988: x_progress := '10: get_buyer_from_category: More than 1 buyer for this category ';
1989: IF (g_po_wf_debug = 'Y') THEN
1990: po_wf_debug_pkg.insert_debug(itemtype,itemkey,x_progress);
1991: END IF;
1992:
1993: when NO_DATA_FOUND then
1994:
1995: x_agent_id := NULL;
1996:
1997: x_progress := '20:get_buyer_from_category: No buyer assinged to category';
1998: IF (g_po_wf_debug = 'Y') THEN
1999: po_wf_debug_pkg.insert_debug(itemtype,itemkey,x_progress);
2000: END IF;
2001:
2002: end;
2003:
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);
2020: END IF;
2021:
2022:
2023: else
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);
2034: END IF;
2035:
2036: end if;
2037:
2094: when NO_DATA_FOUND then
2095: x_agent_id := NULL;
2096: x_progress := '10:get_buyer_from_source_doc: Source Doc id is wrong';
2097: IF (g_po_wf_debug = 'Y') THEN
2098: po_wf_debug_pkg.insert_debug(itemtype,itemkey,x_progress);
2099: END IF;
2100: end;
2101: else
2102: /* Right now, it's for pcard one-time item po, need to figure out
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);
2121: END IF;
2122:
2123:
2124: else
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);
2135: END IF;
2136:
2137: end if;
2138:
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);
2207: END IF;
2208:
2209: purge_expense_lines(itemtype, itemkey); --
2210:
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);
2222: END IF;
2223:
2224: end if;
2225:
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);
2277: END IF;
2278:
2279: elsif (x_source_doc_type_code = 'BLANKET') then
2280: if nvl(x_ga_flag,'N') = 'Y' then -- FPI GA
2286: end if;
2287:
2288: x_progress := '10: get_source_doc_type: result = BLANKET_PO';
2289: IF (g_po_wf_debug = 'Y') THEN
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';
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);
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);
2308: END IF;
2309:
2310: end if;
2311:
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);
2349: END IF;
2350:
2351: else
2352: resultout := wf_engine.eng_completed || ':' || 'N';
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);
2357: END IF;
2358:
2359: end if;
2360:
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);
2512: END IF;
2513:
2514: else
2515: resultout := wf_engine.eng_completed || ':' || x_rel_gen_method;
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);
2520: END IF;
2521: end if;
2522:
2523: --
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);
2567: END IF;
2568:
2569: else
2570: resultout := wf_engine.eng_completed || ':' || 'N';
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);
2575: END IF;
2576:
2577: -- Remove any associated expense line
2578: purge_expense_lines(itemtype, itemkey); --
2735: x_progress := '10:insert_cand_req_lines_into_tbl: inserting into temp table for ' ||
2736: 'req line = ' || to_char(x_req_line_id);
2737:
2738: IF (g_po_wf_debug = 'Y') THEN
2739: po_wf_debug_pkg.insert_debug(itemtype,itemkey,x_progress);
2740: END IF;
2741:
2742: begin
2743: INSERT INTO po_wf_candidate_req_lines_temp
2783: when others then
2784: x_progress := '15: insert_cand_req_lines_into_tbl: IN EXCEPTION when inserting' ||
2785: 'into po_wf_candidate_req_lines_temp';
2786: IF (g_po_wf_debug = 'Y') THEN
2787: po_wf_debug_pkg.insert_debug(itemtype,itemkey,x_progress);
2788: END IF;
2789: raise;
2790: end;
2791:
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);
2801: END IF;
2802:
2803: exception
2804: when others then
3093: c1_valid_style := TRUE;
3094:
3095: x_progress := '01: group_req_lines : c1_req_line_id = '|| to_char(c1_req_line_id);
3096: IF (g_po_wf_debug = 'Y') THEN
3097: po_wf_debug_pkg.insert_debug(itemtype,itemkey,x_progress);
3098: END IF;
3099:
3100: -- bug 4923134
3101:
3100: -- bug 4923134
3101:
3102: x_progress := '01: group_req_lines : c1_source_doc_id = '|| to_char(c1_source_doc_id);
3103: IF (g_po_wf_debug = 'Y') THEN
3104: po_wf_debug_pkg.insert_debug(itemtype,itemkey,x_progress);
3105: END IF;
3106:
3107: x_progress := '01: group_req_lines : c1_contract_id = '|| to_char(c1_contract_id);
3108: IF (g_po_wf_debug = 'Y') THEN
3105: END IF;
3106:
3107: x_progress := '01: group_req_lines : c1_contract_id = '|| to_char(c1_contract_id);
3108: IF (g_po_wf_debug = 'Y') THEN
3109: po_wf_debug_pkg.insert_debug(itemtype,itemkey,x_progress);
3110: END IF;
3111:
3112:
3113: if (nvl(c1_source_doc_id,c1_contract_id) is not null) then
3115: c1_style_id := PO_DOC_STYLE_PVT.get_doc_style_id(nvl(c1_source_doc_id,c1_contract_id)); -- bug 4923134
3116:
3117: x_progress := '01: group_req_lines : c1_style_id = '|| to_char(c1_style_id);
3118: IF (g_po_wf_debug = 'Y') THEN
3119: po_wf_debug_pkg.insert_debug(itemtype,itemkey,x_progress);
3120: END IF;
3121:
3122: PO_DOC_STYLE_PVT.style_validate_req_attrs(p_api_version => 1.0,
3123: p_init_msg_list => fnd_api.g_true,
3145: if c1_valid_style then --< R12 STYLES PHASE II>
3146:
3147: x_progress := '01: group_req_lines : c1_req_line_id = '|| to_char(c1_req_line_id)||'valid style';
3148: IF (g_po_wf_debug = 'Y') THEN
3149: po_wf_debug_pkg.insert_debug(itemtype,itemkey,x_progress);
3150: END IF;
3151:
3152: /* FPI GA start */
3153: if (c1_source_doc_id is not null) then
3259: --
3260: c2_valid_style := TRUE;
3261: x_progress := '02: group_req_lines : c2_req_line_id = '|| to_char(c2_req_line_id);
3262: IF (g_po_wf_debug = 'Y') THEN
3263: po_wf_debug_pkg.insert_debug(itemtype,itemkey,x_progress);
3264: END IF;
3265:
3266: -- bug 4923134
3267: x_progress := '02: group_req_lines : c2_source_doc_id = '|| to_char(c2_source_doc_id);
3265:
3266: -- bug 4923134
3267: x_progress := '02: group_req_lines : c2_source_doc_id = '|| to_char(c2_source_doc_id);
3268: IF (g_po_wf_debug = 'Y') THEN
3269: po_wf_debug_pkg.insert_debug(itemtype,itemkey,x_progress);
3270: END IF;
3271:
3272: x_progress := '02: group_req_lines : c2_contract_id = '|| to_char(c2_contract_id);
3273: IF (g_po_wf_debug = 'Y') THEN
3270: END IF;
3271:
3272: x_progress := '02: group_req_lines : c2_contract_id = '|| to_char(c2_contract_id);
3273: IF (g_po_wf_debug = 'Y') THEN
3274: po_wf_debug_pkg.insert_debug(itemtype,itemkey,x_progress);
3275: END IF;
3276:
3277: if (nvl(c2_source_doc_id,c2_contract_id) is not null) then
3278:
3279: c2_style_id := PO_DOC_STYLE_PVT.get_doc_style_id(nvl(c2_source_doc_id,c2_contract_id)); -- bug 4923134
3280:
3281: x_progress := '02: group_req_lines : c2_style_id = '|| to_char(c2_style_id);
3282: IF (g_po_wf_debug = 'Y') THEN
3283: po_wf_debug_pkg.insert_debug(itemtype,itemkey,x_progress);
3284: END IF;
3285:
3286: PO_DOC_STYLE_PVT.style_validate_req_attrs(p_api_version => 1.0,
3287: p_init_msg_list => fnd_api.g_true,
3309: if c2_valid_style then --
3310:
3311: x_progress := '02: group_req_lines : c2_req_line_id = '|| to_char(c2_req_line_id)||'valid style';
3312: IF (g_po_wf_debug = 'Y') THEN
3313: po_wf_debug_pkg.insert_debug(itemtype,itemkey,x_progress);
3314: END IF;
3315:
3316: /* FPI GA start */
3317: if (c2_source_doc_id is not null) then
3380: x_suggested_vendor_contact_id := get_contact_id(x_suggested_vendor_contact, c2_suggested_vendor_site_id);
3381: end if;
3382:
3383: IF (g_po_wf_debug = 'Y') THEN
3384: po_wf_debug_pkg.insert_debug(itemtype,itemkey,x_progress);
3385: END IF;
3386:
3387: /* Bug 1362315
3388: When you initiate the create doc workflow from requisition import
3433: THEN
3434:
3435: x_progress := '20: group_req_lines: c1 and c2 match ';
3436: IF (g_po_wf_debug = 'Y') THEN
3437: po_wf_debug_pkg.insert_debug(itemtype,itemkey,x_progress);
3438: END IF;
3439:
3440:
3441: /* Update the process code of the current line in the temp table so
3448: -- Bug# 1721991, where current of c2;
3449:
3450: x_progress:= '30:group_req_lines: Updated process_code ';
3451: IF (g_po_wf_debug = 'Y') THEN
3452: po_wf_debug_pkg.insert_debug(itemtype,itemkey,x_progress);
3453: END IF;
3454:
3455:
3456: if (x_first_time_for_this_comb = 'TRUE') then
3461: -- removed as c2_style_id is always populated after bug5695323
3462:
3463: x_progress:= '30:group_req_lines: is progress payments ';
3464: IF (g_po_wf_debug = 'Y') THEN
3465: po_wf_debug_pkg.insert_debug(itemtype,itemkey,x_progress);
3466: END IF;
3467:
3468: if PO_DOC_STYLE_PVT.is_progress_payments_enabled(c2_style_id) then
3469: l_pcard_id := NULL;
3532:
3533: x_progress := '40: group_req_lines: inserted header'||
3534: ' and line for req line = ' || to_char(c2_req_line_id);
3535: IF (g_po_wf_debug = 'Y') THEN
3536: po_wf_debug_pkg.insert_debug(itemtype,itemkey,x_progress);
3537: END IF;
3538: /* bug 2656323
3539: Added code to update vendor_contact_id when po_headers is inserted for first time. */
3540: if (x_carry_contact_to_po_flag = 'TRUE' and
3545: where interface_header_id = x_interface_header_id;
3546: exception
3547: when others then
3548: IF (g_po_wf_debug = 'Y') THEN
3549: po_wf_debug_pkg.insert_debug(itemtype,itemkey,x_progress);
3550: END IF;
3551: end;
3552: end if;
3553:
3580:
3581: x_progress := '50: group_req_lines: inserted just line for '||
3582: 'req line = ' || to_char(c2_req_line_id);
3583: IF (g_po_wf_debug = 'Y') THEN
3584: po_wf_debug_pkg.insert_debug(itemtype,itemkey,x_progress);
3585: END IF;
3586:
3587: --bug#3586181
3588: if (x_carry_contact_to_po_flag = 'TRUE') then -- SS
3612: */
3613: else
3614: x_progress := '02: group_req_lines : c2_req_line_id = '|| to_char(c2_req_line_id)||'invalid style';
3615: IF (g_po_wf_debug = 'Y') THEN
3616: po_wf_debug_pkg.insert_debug(itemtype,itemkey,x_progress);
3617: END IF;
3618:
3619: end if ; --if c2_valid_style --
3620:
3629: where interface_header_id = x_interface_header_id;
3630: exception
3631: when others then
3632: IF (g_po_wf_debug = 'Y') THEN
3633: po_wf_debug_pkg.insert_debug(itemtype,itemkey,x_progress);
3634: END IF;
3635: end;
3636: end if;
3637: */
3664: /* End 3586181 */
3665: else
3666: x_progress := '01: group_req_lines : c1_req_line_id = '|| to_char(c1_req_line_id)||'invalid style';
3667: IF (g_po_wf_debug = 'Y') THEN
3668: po_wf_debug_pkg.insert_debug(itemtype,itemkey,x_progress);
3669: END IF;
3670: end if; --if c1_valid_style --
3671:
3672:
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);
3686: END IF;
3687:
3688: exception
3689: when others then
3887: x_progress := '30: insert_into_headers_interface: Just about to get doc' ||
3888: 'num from po_unique_identifier_control';
3889:
3890: IF (g_po_wf_debug = 'Y') THEN
3891: po_wf_debug_pkg.insert_debug(itemtype,itemkey,x_progress);
3892: END IF;
3893:
3894: /*
3895: Bug# 1869409
3905:
3906: x_progress := '40: insert_into_headers_interface: Got doc' ||
3907: 'num from po_unique_identifier_control';
3908: IF (g_po_wf_debug = 'Y') THEN
3909: po_wf_debug_pkg.insert_debug(itemtype,itemkey,x_progress);
3910: END IF;
3911:
3912: end if;
3913:
3931:
3932: x_progress := '45: insert_into_headers_interface: document_num is a ' ||
3933: 'duplicate - not going to insert into po_headers_interface';
3934: IF (g_po_wf_debug = 'Y') THEN
3935: po_wf_debug_pkg.insert_debug(itemtype,itemkey,x_progress);
3936: END IF;
3937:
3938: raise;
3939: end;
3993: IF l_pou_default_rate_type IS NULL THEN
3994: IF (g_po_wf_debug = 'Y') THEN
3995: x_progress := '47: insert_into_headers_interface: Purchasing Operating unit' ||
3996: ' has no default rate type, cannot create PO';
3997: po_wf_debug_pkg.insert_debug (itemtype, itemkey, x_progress);
3998: END IF;
3999: return FALSE;
4000: END IF;
4001:
4015: IF l_pou_default_rate_type IS NULL THEN
4016: IF (g_po_wf_debug = 'Y') THEN
4017: x_progress := '47: insert_into_headers_interface: Purchasing Operating unit' ||
4018: ' has no default rate type, cannot create PO';
4019: po_wf_debug_pkg.insert_debug (itemtype, itemkey, x_progress);
4020: END IF;
4021:
4022: return FALSE;
4023: END IF;
4032: THEN
4033: IF (g_po_wf_debug = 'Y') THEN
4034: x_progress := '48: insert_into_headers_interface: No rate defined to' ||
4035: ' convert from Requesting OU currency to PO currency, cannot create PO';
4036: po_wf_debug_pkg.insert_debug (itemtype, itemkey, x_progress);
4037: END IF;
4038: return FALSE;
4039: END IF;
4040: END IF;
4125:
4126: x_progress := '50: insert_into_headers_interface: Just about to insert into ' ||
4127: 'po_headers_interface';
4128: IF (g_po_wf_debug = 'Y') THEN
4129: po_wf_debug_pkg.insert_debug(itemtype,itemkey,x_progress);
4130: END IF;
4131:
4132: x_progress := '11: the doc type to be created ' || x_doc_type_to_create ;
4133:
4131:
4132: x_progress := '11: the doc type to be created ' || x_doc_type_to_create ;
4133:
4134: IF (g_po_wf_debug = 'Y') THEN
4135: po_wf_debug_pkg.insert_debug(itemtype,itemkey,x_progress);
4136: END IF;
4137:
4138: begin
4139: insert into po_headers_interface
4197: when others then
4198: x_progress := '55: insert_into_headers_interface: IN EXCEPTION when '||
4199: 'inserting into po_headers_interface';
4200: IF (g_po_wf_debug = 'Y') THEN
4201: po_wf_debug_pkg.insert_debug(itemtype,itemkey,x_progress);
4202: END IF;
4203:
4204: raise;
4205: end;
4206:
4207: x_progress := '60: insert_into_headers_interface: Inserted into ' ||
4208: 'po_headers_interface';
4209: IF (g_po_wf_debug = 'Y') THEN
4210: po_wf_debug_pkg.insert_debug(itemtype,itemkey,x_progress);
4211: END IF;
4212:
4213: /* The interface_header_id is returned as an out parameter so that
4214: * subsequent lines can be tied to this same header if needed.
4353: x_progress := '10: insert_into_lines_interface: Just about to insert into ' ||
4354: 'po_lines_interface';
4355:
4356: IF (g_po_wf_debug = 'Y') THEN
4357: po_wf_debug_pkg.insert_debug(itemtype,itemkey,x_progress);
4358: END IF;
4359:
4360: x_progress := '11: the doc type to be created ' || x_doc_type_to_create ;
4361:
4359:
4360: x_progress := '11: the doc type to be created ' || x_doc_type_to_create ;
4361:
4362: IF (g_po_wf_debug = 'Y') THEN
4363: po_wf_debug_pkg.insert_debug(itemtype,itemkey,x_progress);
4364: END IF;
4365:
4366: begin
4367: insert into po_lines_interface
4399: when others then
4400: x_progress:= '15: insert_into_lines_interface: IN EXCEPTION when' ||
4401: 'inserting into po_lines_interface';
4402: IF (g_po_wf_debug = 'Y') THEN
4403: po_wf_debug_pkg.insert_debug(itemtype,itemkey,x_progress);
4404: END IF;
4405: raise;
4406: end;
4407:
4407:
4408: x_progress := '20: insert_into_lines_interface: Inserted into ' ||
4409: 'po_lines_interface';
4410: IF (g_po_wf_debug = 'Y') THEN
4411: po_wf_debug_pkg.insert_debug(itemtype,itemkey,x_progress);
4412: END IF;
4413:
4414:
4415: exception
4513: ' x_org_id (from workflow)= '|| to_char(x_org_id) ||
4514: ' l_vendor_site_id (from interface table)='||to_char(l_vendor_site_id);
4515:
4516: IF (g_po_wf_debug = 'Y') THEN
4517: PO_WF_DEBUG_PKG.insert_debug(itemtype => itemtype,
4518: itemkey => itemkey,
4519: x_progress => x_progress);
4520: END IF;
4521:
4543: x_progress:= '10: launch_doc_creation_approval: '||
4544: ' Called start_wf_create_apprv_process with itemkey = '||
4545: x_Itemkey;
4546: IF (g_po_wf_debug = 'Y') THEN
4547: po_wf_debug_pkg.insert_debug(itemtype,itemkey,x_progress);
4548: END IF;
4549:
4550: po_autocreate_doc.start_wf_create_apprv_process (x_ItemType,
4551: x_ItemKey,
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);
4571: END IF;
4572:
4573: exception
4574: when others then
4604: x_progress := '10: start_wf_create_apprv_process: This was called with' ||
4605: 'ItemType = ' || ItemType || '/ ' || 'ItemKey = ' || ItemKey;
4606:
4607: IF (g_po_wf_debug = 'Y') THEN
4608: po_wf_debug_pkg.insert_debug(itemtype,itemkey,x_progress);
4609: END IF;
4610:
4611:
4612: /* If a process is passed then it will be run
4622: process => workflow_process );
4623:
4624: x_progress:= '20. start_wf_create_apprv_process: Just after create process';
4625: IF (g_po_wf_debug = 'Y') THEN
4626: po_wf_debug_pkg.insert_debug(itemtype,itemkey,x_progress);
4627: END IF;
4628:
4629: /* Set the item attributes */
4630:
4672: x_progress:= '30. start_wf_create_apprv_process: Kicking off StartProcess ' ||
4673: 'with item_type = ' || itemtype || '/ ' || 'item_key = ' ||
4674: itemkey;
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 );
4684: exception
4685: when others then
4686: x_progress:= '40. start_wf_create_apprv_process: IN EXCEPTION';
4687: IF (g_po_wf_debug = 'Y') THEN
4688: po_wf_debug_pkg.insert_debug(itemtype,itemkey,x_progress);
4689: END IF;
4690: raise;
4691: end start_wf_create_apprv_process;
4692:
4760:
4761: x_progress:= '10: create_doc: Kicking off backend with' ||
4762: 'interface_header_id = '|| to_char(x_interface_header_id);
4763: IF (g_po_wf_debug = 'Y') THEN
4764: po_wf_debug_pkg.insert_debug(itemtype,itemkey,x_progress);
4765: END IF;
4766:
4767: --
4768: --Call Autocreate Backend to create the document
4787: 'doc_id = ' || to_char(x_autocreated_doc_id) || '/ ' ||
4788: 'num_lines_processed = ' || to_char(x_num_lines_processed);
4789:
4790: IF (g_po_wf_debug = 'Y') THEN
4791: po_wf_debug_pkg.insert_debug(itemtype,itemkey,x_progress);
4792: END IF;
4793:
4794:
4795: /* If at least one req line got processed then we have succeeded in
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);
4817: END IF;
4818:
4819: else
4820: resultout := wf_engine.eng_completed || ':' || 'CREATE_FAILED';
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);
4825: END IF;
4826:
4827: end if;
4828:
5008:
5009: x_progress := '10: setup_notification_data: Got the doc num created.' ||
5010: 'Just before call to get_user_name';
5011: IF (g_po_wf_debug = 'Y') THEN
5012: po_wf_debug_pkg.insert_debug(itemtype,itemkey,x_progress);
5013: END IF;
5014:
5015: po_reqapproval_init1.get_user_name(x_agent_id, x_username, x_user_display_name);
5016:
5022:
5023: x_progress := '20: setup_notification_data: Username = ' || x_username ||
5024: 'End of setup_notification_data';
5025: IF (g_po_wf_debug = 'Y') THEN
5026: po_wf_debug_pkg.insert_debug(itemtype,itemkey,x_progress);
5027: END IF;
5028:
5029: exception
5030: when others then
5111: p_calling_program => 'AUTOCREATED_DOC_WF');
5112:
5113: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
5114: IF (g_po_wf_debug = 'Y') THEN
5115: po_wf_debug_pkg.insert_debug(itemtype,itemkey,'Tax Errored ');
5116: END IF;
5117: END IF;
5118:
5119: --
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);
5127: END IF;
5128:
5129: else
5130: resultout := wf_engine.eng_completed || ':' || 'N';
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);
5135: END IF;
5136:
5137: end if;
5138:
5432: '/ ' || 'doc_type = ' || x_doc_type || '/ ' || 'x_doc_id = ' ||
5433: to_char(x_doc_id);
5434:
5435: IF (g_po_wf_debug = 'Y') THEN
5436: po_wf_debug_pkg.insert_debug(itemtype,itemkey,x_progress);
5437: END IF;
5438:
5439: po_reqapproval_init1.start_wf_process(
5440: x_ItemType,
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);
5465: END IF;
5466:
5467: --
5468: IF x_org_id <> l_purchasing_org_id THEN
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);
5518: END IF;
5519:
5520:
5521:
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;
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;
5572:
5573: ELSE
5574: resultout := wf_engine.eng_completed || ':' || 'N';
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;
5579:
5580: END IF;
5581:
5707:
5708: x_progress := '10: put_on_one_po : group_id '||
5709: to_char(x_group_id);
5710: IF (g_po_wf_debug = 'Y') THEN
5711: po_wf_debug_pkg.insert_debug(itemtype,itemkey,x_progress);
5712: END IF;
5713:
5714:
5715: /* only true for the first line */
5819: x_progress := '20: put_on_one_po: inserted header'||
5820: ' and line for req line = ' ||
5821: to_char(c_req_line_id);
5822: IF (g_po_wf_debug = 'Y') THEN
5823: po_wf_debug_pkg.insert_debug(itemtype,itemkey,x_progress);
5824: END IF;
5825:
5826: x_first_time_for_this_comb := 'FALSE';
5827:
5859:
5860: x_progress := '30: put_on_one_po: inserted just line for '||
5861: 'req line = ' || to_char(c_req_line_id);
5862: IF (g_po_wf_debug = 'Y') THEN
5863: po_wf_debug_pkg.insert_debug(itemtype,itemkey,x_progress);
5864: END IF;
5865:
5866: end if;
5867:
5881:
5882: exception
5883: when others then
5884: IF (g_po_wf_debug = 'Y') THEN
5885: po_wf_debug_pkg.insert_debug(itemtype,itemkey,x_progress);
5886: END IF;
5887: end;
5888: end if;
5889:
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);
5896: END IF;
5897:
5898: exception
5899: when others then
6073:
6074: x_progress := 'PO_AUTOCREATE_DOC.send_return_notif: 050 - '||
6075: 'itemtype: ' || ItemType || 'itemkey: ' || ItemKey;
6076: IF (g_po_wf_debug = 'Y') THEN
6077: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);
6078: END IF;
6079:
6080: -- Set the attributes
6081: po_wf_util_pkg.SetItemAttrText ( itemtype => itemtype,
6191:
6192: -- Start Process
6193: x_progress := 'PO_AUTOCREATE_DOC.send_return_notif: 055';
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 );
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);
6386: END IF;
6387:
6388: end if;
6389:
6528: end if;
6529:
6530: x_progress:= '10: is_source_doc_info_ok: result = ' || resultout;
6531: IF (g_po_wf_debug = 'Y') THEN
6532: po_wf_debug_pkg.insert_debug(itemtype,itemkey,x_progress);
6533: END IF;
6534:
6535: po_wf_util_pkg.SetItemAttrNumber (itemtype => itemtype,
6536: itemkey => itemkey,
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);
6556: END IF;
6557:
6558: end if;
6559:
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);
6722: END IF;
6723:
6724: exception
6725: when others then
6914: END IF; --source doc check
6915: END IF; --check profile option
6916:
6917: IF (g_po_wf_debug = 'Y') THEN
6918: po_wf_debug_pkg.insert_debug (itemtype, itemkey, x_progress);
6919: END IF;
6920:
6921: EXCEPTION
6922: WHEN OTHERS THEN
7031: END IF; --contract_id check
7032: END IF; --check profile option
7033:
7034: IF (g_po_wf_debug = 'Y') THEN
7035: po_wf_debug_pkg.insert_debug (itemtype, itemkey, x_progress);
7036: END IF;
7037:
7038: EXCEPTION
7039: WHEN OTHERS THEN
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);
7114: END IF;
7115:
7116: EXCEPTION
7117:
7282: END IF;
7283:
7284: IF (g_po_wf_debug = 'Y')
7285: THEN
7286: po_wf_debug_pkg.insert_debug (itemtype, itemkey, x_progress);
7287: END IF;
7288: EXCEPTION
7289: WHEN OTHERS
7290: THEN
7447:
7448: l_progress:= '10: is_expense_line: result = Y';
7449:
7450: IF (g_po_wf_debug = 'Y') THEN
7451: po_wf_debug_pkg.insert_debug(itemtype,
7452: itemkey,
7453: l_progress);
7454: END IF;
7455:
7458:
7459: l_progress:= '20: is_expense_line: result = N';
7460:
7461: IF (g_po_wf_debug = 'Y') THEN
7462: po_wf_debug_pkg.insert_debug(itemtype,
7463: itemkey,
7464: l_progress);
7465: END IF;
7466: END IF;
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);
7573: END IF;
7574:
7575: end if;
7576: