DBA Data[Home] [Help]

APPS.PO_NEGOTIATIONS4_PVT dependencies on PO_WF_DEBUG_PKG

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

2161: l_po_revision po_headers.revision_num%type;
2162:
2163: BEGIN
2164: x_progress := 'PO_NEGOTIATIONS4_PVT.Consume_ReqDemandYesNo: 01';
2165: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);
2166:
2167: -- Do nothing in cancel or timeout mode
2168: if (funcmode <> wf_engine.eng_run) then
2169: resultout := wf_engine.eng_null;

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

2215: resultout := wf_engine.eng_completed || ':' || nvl(l_consume_req_demand_flag, 'N');
2216:
2217: x_progress := 'PO_NEGOTIATIONS4_PVT.Consume_ReqDemandYesNo: 02. Result= '
2218: || l_consume_req_demand_flag;
2219: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);
2220:
2221: EXCEPTION
2222: WHEN OTHERS THEN
2223: l_consume_req_demand_flag := 'N';

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

2275:
2276: BEGIN
2277:
2278: x_progress := 'PO_NEGOTIATIONS4_PVT.Place_SourcingInfoOnReq: 01';
2279: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);
2280:
2281: -- Do nothing in cancel or timeout mode
2282: if (funcmode <> wf_engine.eng_run) then
2283:

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

2310: itemkey => itemkey,
2311: aname => 'DOCUMENT_SUBTYPE'
2312: );
2313:
2314: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,'l_document_id'
2315: ||to_char(l_document_id)||'l_document_type='||l_document_type
2316: ||'l_vendor_id='||to_char(l_vendor_id)||'l_supplier='
2317: ||l_vendor_name||'l_vendor_site_id='
2318: ||to_char(l_vendor_site_id));

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

2340:
2341: FOR l_document_lines_index in document_lines_cursor
2342: LOOP
2343:
2344: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,
2345: 'before placing info on req- l_document_id='
2346: ||to_char(l_document_id)||'blanket_po_line_num='
2347: ||to_char(l_document_lines_index.line_num)
2348: ||'auction_header_id='

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

2376:
2377: resultout:=wf_engine.eng_completed || ':' || 'Y';
2378:
2379: x_progress:='PO_NEGOTIATIONS4_PVT.Place_SourcingInfoOnReq: 02. Result= '||'Y';
2380: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress||sql%rowcount);
2381:
2382: EXCEPTION
2383: WHEN OTHERS THEN
2384: resultout := wf_engine.eng_completed || ':' || 'N';

Line 2455: /* 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));

2451: (itemtype => itemtype,
2452: itemkey => itemkey,
2453: aname => 'DOCUMENT_ID');
2454:
2455: /* 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));
2456:
2457: /* Since the call may be started from background engine (new seesion),
2458: * need to ensure the fnd context is correct
2459: */

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

2461: if (l_user_id is not null and
2462: l_resp_id is not null and
2463: l_appl_id is not null )then
2464:
2465: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,'apps_init');
2466: fnd_global.APPS_INITIALIZE(l_user_id, l_resp_id, l_appl_id);
2467: end if;
2468:
2469: IF l_orgid is NOT NULL THEN

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

2466: fnd_global.APPS_INITIALIZE(l_user_id, l_resp_id, l_appl_id);
2467: end if;
2468:
2469: IF l_orgid is NOT NULL THEN
2470: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,'setting org');
2471: PO_MOAC_UTILS_PVT.set_org_context(l_orgid) ; --
2472: END IF;
2473:
2474: x_progress := 'PO_NEGOTIATIONS4_PVT.Launch_CreateDocWF:01';

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

2471: PO_MOAC_UTILS_PVT.set_org_context(l_orgid) ; --
2472: END IF;
2473:
2474: x_progress := 'PO_NEGOTIATIONS4_PVT.Launch_CreateDocWF:01';
2475: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);
2476:
2477: /* Create the ItemKey: Use the PO workflow sequence */
2478: select to_char(PO_WF_ITEMKEY_S.nextval) into l_dummy from sys.dual;
2479:

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

2490: l_ItemKey := to_char(l_document_id) || '-' || l_dummy;
2491:
2492: x_progress := 'PO_NEGOTIATIONS4_PVT.Launch_CreateDocWF:02 ItemType=' ||
2493: l_ItemType || ' ItemKey=' || l_ItemKey;
2494: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);
2495:
2496: x_progress := '30: Launch_CreateDocWF: Called with following parameters:' ||
2497: 'ItemType = ' || l_ItemType || '/ ' ||
2498: 'ItemKey = ' || l_ItemKey || '/ ' ||

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

2497: 'ItemType = ' || l_ItemType || '/ ' ||
2498: 'ItemKey = ' || l_ItemKey || '/ ' ||
2499: 'workflow_process = ' || l_workflow_process;
2500:
2501: po_wf_debug_pkg.insert_debug(Itemtype,Itemkey,x_progress);
2502:
2503: IF ( l_ItemType is NOT NULL ) AND
2504: ( l_ItemKey is NOT NULL) THEN
2505: wf_engine.CreateProcess

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

2507: itemkey => l_itemkey,
2508: process => l_workflow_process );
2509:
2510: x_progress:= '40: Launch_CreateDocWF: Just after CreateProcess';
2511: po_wf_debug_pkg.insert_debug(Itemtype,Itemkey,x_progress);
2512:
2513: PO_WF_UTIL_PKG.SetItemAttrNumber
2514: (itemtype => l_itemtype,
2515: itemkey => l_itemkey,

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

2524:
2525: /* Kick off the process */
2526:
2527: x_progress := '40: Launch_CreateDocWF: Kicking off StartProcess ';
2528: po_wf_debug_pkg.insert_debug(Itemtype,Itemkey,x_progress);
2529:
2530: wf_engine.StartProcess(itemtype => l_itemtype,
2531: itemkey => l_itemkey );
2532: END IF;