4961: aname => 'ORG_ID');
4962:
4963: IF l_orgid is NOT NULL THEN
4964:
4965: PO_MOAC_UTILS_PVT.set_org_context(l_orgid) ; --
4967: END IF;
4968:
4969: open change_request_group_id;
5055: aname => 'ORG_ID');
5056:
5057: IF l_orgid is NOT NULL THEN
5058:
5059: PO_MOAC_UTILS_PVT.set_org_context(l_orgid) ; --
5061: END IF;
5062:
5063: l_change_request_group_id := PO_WF_UTIL_PKG.GetItemAttrNumber (
5168: itemkey => itemkey,
5169: aname => 'ORG_ID');
5170:
5171: IF l_orgid is NOT NULL THEN
5172: PO_MOAC_UTILS_PVT.set_org_context(l_orgid) ; --
5174:
5175: l_note := PO_WF_UTIL_PKG.GetItemAttrText(itemtype => itemtype,
5176: itemkey => itemkey,
5532: aname => 'ORG_ID');
5533:
5534: IF l_orgid is NOT NULL THEN
5535:
5536: PO_MOAC_UTILS_PVT.set_org_context(l_orgid) ; --
5538: END IF;
5539:
5540: open accepted_change;
5768: aname => 'ORG_ID');
5769:
5770: IF l_orgid is NOT NULL THEN
5771:
5772: PO_MOAC_UTILS_PVT.set_org_context(l_orgid) ; --
5774: END IF;
5775:
5776: open change_request_status ;
5963: itemkey => itemkey,
5964: aname => 'ORG_ID');
5965:
5966: IF l_org_id is NOT NULL THEN
5967: PO_MOAC_UTILS_PVT.set_org_context(l_org_id) ; --
5969:
5970: SELECT max(sequence_num)
5971: INTO l_sequence_num
6118: aname => 'ORG_ID');
6119:
6120: IF l_org_id is NOT NULL THEN
6121:
6122: PO_MOAC_UTILS_PVT.set_org_context(l_org_id) ; --
6124: END IF;
6125:
6126: l_progress := 'Update_Action_History_Return: 002-'||
6248: aname => 'ORG_ID');
6249:
6250: IF l_orgid is NOT NULL THEN
6251:
6252: PO_MOAC_UTILS_PVT.set_org_context(l_orgid) ; --
6254: END IF;
6255:
6256: l_change_request_group_id := PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => itemtype,
6328: aname => 'ORG_ID');
6329:
6330: IF l_orgid is NOT NULL THEN
6331:
6332: PO_MOAC_UTILS_PVT.set_org_context(l_orgid) ; --
6334: END IF;
6335:
6336: l_change_request_group_id := PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => itemtype,
6399: aname => 'ORG_ID');
6400:
6401: IF l_orgid is NOT NULL THEN
6402:
6403: PO_MOAC_UTILS_PVT.set_org_context(l_orgid) ; --
6405: END IF;
6406:
6407: setNewTotal(itemtype, itemkey);
6659: aname => 'ORG_ID');
6660:
6661: IF l_orgid is NOT NULL THEN
6662:
6663: PO_MOAC_UTILS_PVT.set_org_context(l_orgid) ; --
6665: END IF;
6666:
6667: IF l_doc_type IN ('PO','PA') THEN
6757: aname => 'ORG_ID');
6758:
6759: IF l_orgid is NOT NULL THEN
6760:
6761: PO_MOAC_UTILS_PVT.set_org_context(l_orgid) ; --
6763: END IF;
6764:
6765: IF l_doc_type IN ('PO','PA') THEN
6842: aname => 'ORG_ID');
6843:
6844: IF l_orgid is NOT NULL THEN
6845:
6846: PO_MOAC_UTILS_PVT.set_org_context(l_orgid) ; --
6848: END IF;
6849:
6850: IF l_doc_type IN ('PO','PA') THEN
6933: itemkey => itemkey,
6934: aname => 'RESPONSE_REASON');
6935:
6936: IF l_orgid is NOT NULL THEN
6937: PO_MOAC_UTILS_PVT.set_org_context(l_orgid) ; --
6939: SetPoRequestStatus(l_change_request_group_id, 'REJECTED', l_response_reason);
6940:
6941: x_progress := 'PO_ReqChangeRequestWF_PVT.Record_Buyer_Rejection: 02';
7007: itemkey => itemkey,
7008: aname => 'ORG_ID');
7009:
7010: IF l_orgid is NOT NULL THEN
7011: PO_MOAC_UTILS_PVT.set_org_context(l_orgid) ; --
7013: SetPoRequestStatus(l_change_request_group_id, 'BUYER_APP', l_response_reason);
7014:
7015: x_progress := 'PO_ReqChangeRequestWF_PVT.Record_Buyer_Acceptance: 02';
7076: itemkey => itemkey,
7077: aname => 'ORG_ID');
7078:
7079: IF l_orgid is NOT NULL THEN
7080: PO_MOAC_UTILS_PVT.set_org_context(l_orgid) ; --
7082: Start_ProcessBuyerResponseWF(l_change_request_group_id);
7083:
7084: x_progress := 'PO_ReqChangeRequestWF_PVT.Start_Process_Buy_Response_WF: 02';
7190: aname => 'ORG_ID');
7191:
7192: IF l_orgid is NOT NULL THEN
7193:
7194: PO_MOAC_UTILS_PVT.set_org_context(l_orgid) ; --
7196: END IF;
7197:
7198: IF l_doc_type IN ('PO','PA') THEN
7289: aname => 'ORG_ID');
7290:
7291: IF l_orgid is NOT NULL THEN
7292:
7293: PO_MOAC_UTILS_PVT.set_org_context(l_orgid) ; --
7295: END IF;
7296: ProcessBuyerAction(l_change_request_group_id, 'REJECTION');
7297:
7380: aname => 'ORG_ID');
7381:
7382: IF l_orgid is NOT NULL THEN
7383:
7384: PO_MOAC_UTILS_PVT.set_org_context(l_orgid) ; --
7386: END IF;
7387:
7388: ProcessBuyerAction(l_change_request_group_id, 'CANCELLATION');
7451: itemkey => itemkey,
7452: aname => 'ORG_ID');
7453:
7454: IF l_orgid is NOT NULL THEN
7455: PO_MOAC_UTILS_PVT.set_org_context(l_orgid) ; --
7457:
7458: open accepted_change;
7459: fetch accepted_change into l_change_request_id;
7532: aname => 'ORG_ID');
7533:
7534: IF l_orgid is NOT NULL THEN
7535:
7536: PO_MOAC_UTILS_PVT.set_org_context(l_orgid) ; --
7538: END IF;
7539: ProcessBuyerAction(l_change_request_group_id, 'ACCEPTANCE');
7540:
7652: aname => 'ORG_ID');
7653:
7654: IF l_orgid is NOT NULL THEN
7655:
7656: PO_MOAC_UTILS_PVT.set_org_context(l_orgid) ; --
7658: END IF;
7659:
7660: x_progress := 'PO_ReqChangeRequestWF_PVT.Start_Poapprv_WF:01';
7777: aname => 'ORG_ID');
7778:
7779: IF l_orgid is NOT NULL THEN
7780:
7781: PO_MOAC_UTILS_PVT.set_org_context(l_orgid) ; --
7783: END IF;
7784:
7785: open pending_parent_change_csr(l_change_request_group_id);
7849: aname => 'ORG_ID' );
7850:
7851: IF l_orgid is NOT NULL THEN
7852:
7853: PO_MOAC_UTILS_PVT.set_org_context(l_orgid) ; --
7855: END IF;
7856:
7857: l_req_change_request_group_id := PO_WF_UTIL_PKG.GetItemAttrNumber (
7955: itemkey => itemkey,
7956: aname => 'ORG_ID');
7957:
7958: IF l_orgid is NOT NULL THEN
7959: PO_MOAC_UTILS_PVT.set_org_context(l_orgid) ; --
7961:
7962: x_progress := 'PO_ReqChangeRequestWF_PVT.Get_Total_Amount_Currency: 02';
7963:
8379: aname => 'ORG_ID');
8380:
8381: IF l_orgid is NOT NULL THEN
8382:
8383: PO_MOAC_UTILS_PVT.set_org_context(l_orgid) ; --
8385: END IF;
8386:
8387: open parent_change(l_change_request_group_id);
8668: aname => 'ORG_ID');
8669:
8670: IF l_orgid is NOT NULL THEN
8671:
8672: PO_MOAC_UTILS_PVT.set_org_context(l_orgid) ; --
8674: END IF;
8675:
8676: open new_change(l_change_request_group_id);
8754: aname => 'ORG_ID');
8755:
8756: IF l_orgid is NOT NULL THEN
8757:
8758: PO_MOAC_UTILS_PVT.set_org_context(l_orgid) ; --
8760: END IF;
8761: SetPoRequestStatus(l_change_request_group_id, 'ACCEPTED');
8762:
8820: aname => 'ORG_ID');
8821:
8822: IF l_orgid is NOT NULL THEN
8823:
8824: PO_MOAC_UTILS_PVT.set_org_context(l_orgid) ; --
8826: END IF;
8827: SetPoRequestStatus(l_change_request_group_id, 'REJECTED');
8828:
8889: aname => 'ORG_ID');
8890:
8891: IF l_orgid is NOT NULL THEN
8892:
8893: PO_MOAC_UTILS_PVT.set_org_context(l_orgid) ; --
8895: END IF;
8896: ValidateChgAgainstNewPO(l_change_request_group_id);
8897:
9990: aname => 'ORG_ID');
9991:
9992: IF l_orgid is NOT NULL THEN
9993:
9994: PO_MOAC_UTILS_PVT.set_org_context(l_orgid) ; --
9996: END IF;
9997:
9998: x_progress := 'PO_ReqChangeRequestWF_PVT.Set_Buyer_Approval_Notfn_Attr: 02';
10243: x_progress := 'PO_ReqChangeRequestWF_PVT.Start_POChange_WF: 03';
10244:
10245: IF l_orgid is NOT NULL THEN
10246:
10247: PO_MOAC_UTILS_PVT.set_org_context(l_orgid) ; --
10249: END IF;
10250:
10251: x_progress := 'PO_ReqChangeRequestWF_PVT.Start_POChange_WF: 04';
11408:
11409: l_progress := 'PO_ReqChangeRequestWF_PVT.Start_Notify_Requester_Process: 02';
11410:
11411: IF l_orgid is NOT NULL THEN
11412: PO_MOAC_UTILS_PVT.set_org_context(l_orgid) ; --
11414:
11415: l_progress := 'PO_ReqChangeRequestWF_PVT.Start_Notify_Requester_Process: 03';
11416:
11888: END IF;
11889:
11890:
11891: IF l_orgid is NOT NULL THEN
11892: PO_MOAC_UTILS_PVT.set_org_context(l_orgid) ; --
11894:
11895: OE_Internal_Requisition_Pvt.Apply_Hold_for_IReq -- Specification definition
11896: ( P_API_Version => 1.0
11908: po_debug.debug_var(l_log_head, l_progress, 'Requisition l_orgid', l_orgid);
11909: END IF;
11910:
11911: IF l_orgid is NOT NULL THEN
11912: PO_MOAC_UTILS_PVT.set_org_context(l_orgid) ; --
11914:
11915: IF g_debug_stmt THEN
11916: po_debug.debug_var(l_log_head,l_progress,'p_item_key',p_item_key );
12051: END IF;
12052:
12053:
12054: IF l_orgid is NOT NULL THEN
12055: PO_MOAC_UTILS_PVT.set_org_context(l_orgid) ; --
12057: --release the OM LINE FROM HOLD call OM_API
12058: x_progress := '020';
12059: OE_Internal_Requisition_Pvt.Release_Hold_for_IReq
12069: po_debug.debug_var(l_log_head, x_progress, 'Requisition l_orgid', l_orgid);
12070: END IF;
12071:
12072: IF l_orgid is NOT NULL THEN
12073: PO_MOAC_UTILS_PVT.set_org_context(l_orgid) ; --
12075:
12076: END IF;
12077: END LOOP;
12242: po_debug.debug_var(l_log_head, l_progress, 'Sales order l_orgid', l_orgid);
12243: END IF;
12244:
12245: IF l_orgid is NOT NULL AND p_mode <> 'REQ_RESCHEDULE' THEN
12246: PO_MOAC_UTILS_PVT.set_org_context(l_orgid) ; --
12248: --release the OM LINE FROM HOLD call OM_API
12249: -- release the hold from SO before calling process order api bug 8299243
12250:
12264: po_debug.debug_var(l_log_head, l_progress, 'Sales order l_orgid', l_orgid);
12265: END IF;
12266:
12267: IF l_orgid is NOT NULL THEN
12268: PO_MOAC_UTILS_PVT.set_org_context(l_orgid) ; --
12270: -- Algorithm : call om api according to action type
12271:
12272: IF (p_action_type = 'MODIFICATION' ) THEN
12329: po_debug.debug_var(l_log_head, l_progress,'returning from OM API ',l_return_status);
12330: END IF;
12331:
12332: IF l_orgid is NOT NULL THEN
12333: PO_MOAC_UTILS_PVT.set_org_context(l_orgid) ; --
12335:
12336:
12337:
12426: po_debug.debug_var(l_log_head, l_progress, 'Requisition l_orgid', l_orgid);
12427: END IF;
12428:
12429: IF l_orgid is NOT NULL THEN
12430: PO_MOAC_UTILS_PVT.set_org_context(l_orgid) ; --
12432:
12433: COMMIT;
12434: l_progress := '015';
12438: l_orgid := get_requisition_org( p_req_line_id => p_document_line_id);
12439: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
12440:
12441: IF l_orgid is NOT NULL THEN
12442: PO_MOAC_UTILS_PVT.set_org_context(l_orgid) ; --
12444:
12445: wf_core.context('PO_ReqChangeRequestWF_PVT', 'ConvertIntoSOChange '||l_return_status, l_progress);
12446: ROLLBACK TO convertintosochange_SP;