APPS.PO_NEGOTIATIONS4_PVT dependencies on PO_NEGOTIATIONS4_PVT

Line 1: PACKAGE BODY PO_NEGOTIATIONS4_PVT AS

1: PACKAGE BODY PO_NEGOTIATIONS4_PVT AS
2: /* $Header: POXVNG4B.pls 120.12.12000000.2 2007/05/04 00:05:37 lswamy ship $ */
3:
4: TYPE auction_header_id_tbl_type is TABLE OF
5: po_req_split_lines_gt.auction_header_id%type INDEX BY BINARY_INTEGER;

Line 41: G_PKG_NAME CONSTANT varchar2(30) := 'PO_NEGOTIATIONS4_PVT';

37: financials_system_parameters.req_encumbrance_flag%type
38: INDEX BY BINARY_INTEGER;
39: -- Bug 4723367 END
40:
41: G_PKG_NAME CONSTANT varchar2(30) := 'PO_NEGOTIATIONS4_PVT';
42: G_MODULE_PREFIX CONSTANT VARCHAR2(60) := 'po.plsql.' || G_PKG_NAME || '.';
43: G_FND_DEBUG VARCHAR2(1) := NVL(FND_PROFILE.VALUE('AFLOG_ENABLED'),'N');
44: G_FND_DEBUG_LEVEL VARCHAR2(1) := NVL(FND_PROFILE.VALUE('AFLOG_LEVEL'),'0');
45:

Line 2083: x_progress := 'PO_NEGOTIATIONS4_PVT.Consume_ReqDemandYesNo: 01';

2079: --bug2829163
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

Line 2136: x_progress := 'PO_NEGOTIATIONS4_PVT.Consume_ReqDemandYesNo: 02. Result= '

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

Line 2197: x_progress := 'PO_NEGOTIATIONS4_PVT.Place_SourcingInfoOnReq: 01';

2193: WHERE po_header_id=l_document_id;
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

Line 2255: x_progress:='PO_NEGOTIATIONS4_PVT.Place_SourcingInfoOnReq: 02.';

2251: AND poh.vendor_site_id=povs.vendor_site_id;
2252:
2253: EXCEPTION
2254: WHEN OTHERS THEN
2255: x_progress:='PO_NEGOTIATIONS4_PVT.Place_SourcingInfoOnReq: 02.';
2256: RAISE;
2257: END;
2258:
2259:

Line 2298: x_progress:='PO_NEGOTIATIONS4_PVT.Place_SourcingInfoOnReq: 02. Result= '||'Y';

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:
2301: EXCEPTION
2302: WHEN OTHERS THEN

Line 2387: x_progress := 'PO_NEGOTIATIONS4_PVT.Launch_CreateDocWF:01';

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

Line 2405: x_progress := 'PO_NEGOTIATIONS4_PVT.Launch_CreateDocWF:02 ItemType=' ||

2401: CLOSE C1;
2402:
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:' ||

Line 2448: wf_core.context('PO_NEGOTIATIONS4_PVT','Launch_CreateDocWF',

2444: itemkey => l_itemkey );
2445: END IF;
2446: EXCEPTION
2447: WHEN OTHERS THEN
2448: wf_core.context('PO_NEGOTIATIONS4_PVT','Launch_CreateDocWF',
2449: x_progress);
2450: raise;
2451: END Launch_CreateDocWF;
2452:

Line 3137: END PO_NEGOTIATIONS4_PVT;

3133: END handle_tax_adjustments;
3134:
3135: --
3136:
3137: END PO_NEGOTIATIONS4_PVT;