2083: x_progress := 'PO_NEGOTIATIONS4_PVT.Consume_ReqDemandYesNo: 01';
2084: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);
2085:
2086: -- Do nothing in cancel or timeout mode
2087: if (funcmode <> wf_engine.eng_run) then
2088: resultout := wf_engine.eng_null;
2089: return;
2090: end if;
2091:
2084: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);
2085:
2086: -- Do nothing in cancel or timeout mode
2087: if (funcmode <> wf_engine.eng_run) then
2088: resultout := wf_engine.eng_null;
2089: return;
2090: end if;
2091:
2092:
2130: WHERE po_header_id = l_document_id;
2131:
2132: END IF;
2133:
2134: resultout := wf_engine.eng_completed || ':' || nvl(l_consume_req_demand_flag, 'N');
2135:
2136: x_progress := 'PO_NEGOTIATIONS4_PVT.Consume_ReqDemandYesNo: 02. Result= '
2137: || l_consume_req_demand_flag;
2138: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);
2139:
2140: EXCEPTION
2141: WHEN OTHERS THEN
2142: l_consume_req_demand_flag := 'N';
2143: resultout := wf_engine.eng_completed || ':' || l_consume_req_demand_flag;
2144: END Consume_ReqDemandYesNo;
2145:
2146:
2147: /**
2197: x_progress := 'PO_NEGOTIATIONS4_PVT.Place_SourcingInfoOnReq: 01';
2198: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);
2199:
2200: -- Do nothing in cancel or timeout mode
2201: if (funcmode <> wf_engine.eng_run) then
2202:
2203: resultout := wf_engine.eng_null;
2204: return;
2205:
2199:
2200: -- Do nothing in cancel or timeout mode
2201: if (funcmode <> wf_engine.eng_run) then
2202:
2203: resultout := wf_engine.eng_null;
2204: return;
2205:
2206: end if;
2207:
2292:
2293: END LOOP;
2294:
2295:
2296: resultout:=wf_engine.eng_completed || ':' || 'Y';
2297:
2298: x_progress:='PO_NEGOTIATIONS4_PVT.Place_SourcingInfoOnReq: 02. Result= '||'Y';
2299: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress||sql%rowcount);
2300:
2299: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress||sql%rowcount);
2300:
2301: EXCEPTION
2302: WHEN OTHERS THEN
2303: resultout := wf_engine.eng_completed || ':' || 'N';
2304: END Place_SourcingInfoOnReq;
2305:
2306:
2307: /**
2414: po_wf_debug_pkg.insert_debug(Itemtype,Itemkey,x_progress);
2415:
2416: IF ( l_ItemType is NOT NULL ) AND
2417: ( l_ItemKey is NOT NULL) THEN
2418: wf_engine.CreateProcess
2419: (itemtype => l_itemtype,
2420: itemkey => l_itemkey,
2421: process => l_workflow_process );
2422:
2439:
2440: x_progress := '40: Launch_CreateDocWF: Kicking off StartProcess ';
2441: po_wf_debug_pkg.insert_debug(Itemtype,Itemkey,x_progress);
2442:
2443: wf_engine.StartProcess(itemtype => l_itemtype,
2444: itemkey => l_itemkey );
2445: END IF;
2446: EXCEPTION
2447: WHEN OTHERS THEN