DBA Data[Home] [Help]

APPS.PO_NEGOTIATIONS4_PVT dependencies on PO_WF_DEBUG_PKG

Line 2084: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);

2080: l_po_revision po_headers.revision_num%type;
2081:
2082: BEGIN
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;

Line 2138: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);

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';

Line 2198: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);

2194:
2195: BEGIN
2196:
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:

Line 2233: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,'l_document_id'

2229: itemkey => itemkey,
2230: aname => 'DOCUMENT_SUBTYPE'
2231: );
2232:
2233: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,'l_document_id'
2234: ||to_char(l_document_id)||'l_document_type='||l_document_type
2235: ||'l_vendor_id='||to_char(l_vendor_id)||'l_supplier='
2236: ||l_vendor_name||'l_vendor_site_id='
2237: ||to_char(l_vendor_site_id));

Line 2263: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,

2259:
2260: FOR l_document_lines_index in document_lines_cursor
2261: LOOP
2262:
2263: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,
2264: 'before placing info on req- l_document_id='
2265: ||to_char(l_document_id)||'blanket_po_line_num='
2266: ||to_char(l_document_lines_index.line_num)
2267: ||'auction_header_id='

Line 2299: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress||sql%rowcount);

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:
2301: EXCEPTION
2302: WHEN OTHERS THEN
2303: resultout := wf_engine.eng_completed || ':' || 'N';

Line 2368: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,'l_orgid='||to_char(l_orgid)||'l_user_id='||to_char(l_user_id)||'l_resp_id='||to_char(l_resp_id)||'l_appl_id='||to_char(l_appl_id)||'l_document_id='||to_char(l_document_id));

2364: (itemtype => itemtype,
2365: itemkey => itemkey,
2366: aname => 'DOCUMENT_ID');
2367:
2368: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,'l_orgid='||to_char(l_orgid)||'l_user_id='||to_char(l_user_id)||'l_resp_id='||to_char(l_resp_id)||'l_appl_id='||to_char(l_appl_id)||'l_document_id='||to_char(l_document_id));
2369:
2370: /* Since the call may be started from background engine (new seesion),
2371: * need to ensure the fnd context is correct
2372: */

Line 2378: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,'apps_init');

2374: if (l_user_id is not null and
2375: l_resp_id is not null and
2376: l_appl_id is not null )then
2377:
2378: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,'apps_init');
2379: fnd_global.APPS_INITIALIZE(l_user_id, l_resp_id, l_appl_id);
2380: end if;
2381:
2382: IF l_orgid is NOT NULL THEN

Line 2383: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,'setting org');

2379: fnd_global.APPS_INITIALIZE(l_user_id, l_resp_id, l_appl_id);
2380: end if;
2381:
2382: IF l_orgid is NOT NULL THEN
2383: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,'setting org');
2384: PO_MOAC_UTILS_PVT.set_org_context(l_orgid) ; --
2385: END IF;
2386:
2387: x_progress := 'PO_NEGOTIATIONS4_PVT.Launch_CreateDocWF:01';

Line 2388: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);

2384: PO_MOAC_UTILS_PVT.set_org_context(l_orgid) ; --
2385: END IF;
2386:
2387: x_progress := 'PO_NEGOTIATIONS4_PVT.Launch_CreateDocWF:01';
2388: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);
2389:
2390: /* Create the ItemKey: Use the PO workflow sequence */
2391: select to_char(PO_WF_ITEMKEY_S.nextval) into l_dummy from sys.dual;
2392:

Line 2407: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);

2403: l_ItemKey := to_char(l_document_id) || '-' || l_dummy;
2404:
2405: x_progress := 'PO_NEGOTIATIONS4_PVT.Launch_CreateDocWF:02 ItemType=' ||
2406: l_ItemType || ' ItemKey=' || l_ItemKey;
2407: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);
2408:
2409: x_progress := '30: Launch_CreateDocWF: Called with following parameters:' ||
2410: 'ItemType = ' || l_ItemType || '/ ' ||
2411: 'ItemKey = ' || l_ItemKey || '/ ' ||

Line 2414: po_wf_debug_pkg.insert_debug(Itemtype,Itemkey,x_progress);

2410: 'ItemType = ' || l_ItemType || '/ ' ||
2411: 'ItemKey = ' || l_ItemKey || '/ ' ||
2412: 'workflow_process = ' || l_workflow_process;
2413:
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

Line 2424: po_wf_debug_pkg.insert_debug(Itemtype,Itemkey,x_progress);

2420: itemkey => l_itemkey,
2421: process => l_workflow_process );
2422:
2423: x_progress:= '40: Launch_CreateDocWF: Just after CreateProcess';
2424: po_wf_debug_pkg.insert_debug(Itemtype,Itemkey,x_progress);
2425:
2426: PO_WF_UTIL_PKG.SetItemAttrNumber
2427: (itemtype => l_itemtype,
2428: itemkey => l_itemkey,

Line 2441: po_wf_debug_pkg.insert_debug(Itemtype,Itemkey,x_progress);

2437:
2438: /* Kick off the process */
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;