[Home] [Help]
1: PACKAGE BODY PO_NEGOTIATIONS4_PVT AS
2: /* $Header: POXVNG4B.pls 120.23.12020000.3 2013/02/10 13:21:13 vegajula 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;
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:
2160: --bug2829163
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
2213: END IF;
2214:
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
2274: WHERE po_header_id=l_document_id;
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
2332: AND poh.vendor_site_id=povs.vendor_site_id;
2333:
2334: EXCEPTION
2335: WHEN OTHERS THEN
2336: x_progress:='PO_NEGOTIATIONS4_PVT.Place_SourcingInfoOnReq: 02.';
2337: RAISE;
2338: END;
2339:
2340:
2375:
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
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';
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;
2488: CLOSE C1;
2489:
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:' ||
2533: /*Bug 7517077, assigning value 'ACTIVITY PERFORMED' to the resultout parameter, since the next activity gets driven based on this*/
2534: resultout := wf_engine.eng_completed || ':' || 'ACTIVITY_PERFORMED';
2535: EXCEPTION
2536: WHEN OTHERS THEN
2537: wf_core.context('PO_NEGOTIATIONS4_PVT','Launch_CreateDocWF',
2538: x_progress);
2539: raise;
2540: END Launch_CreateDocWF;
2541:
3223: END handle_tax_adjustments;
3224:
3225: --
3226:
3227: END PO_NEGOTIATIONS4_PVT;