DBA Data[Home] [Help]

APPS.PO_REQCHANGEREQUESTWF_PVT dependencies on PO_MOAC_UTILS_PVT

Line 4965: PO_MOAC_UTILS_PVT.set_org_context(l_orgid) ; --

4961: aname => 'ORG_ID');
4962:
4963: IF l_orgid is NOT NULL THEN
4964:
4965: PO_MOAC_UTILS_PVT.set_org_context(l_orgid) ; --
4966:
4967: END IF;
4968:
4969: open change_request_group_id;

Line 5059: PO_MOAC_UTILS_PVT.set_org_context(l_orgid) ; --

5055: aname => 'ORG_ID');
5056:
5057: IF l_orgid is NOT NULL THEN
5058:
5059: PO_MOAC_UTILS_PVT.set_org_context(l_orgid) ; --
5060:
5061: END IF;
5062:
5063: l_change_request_group_id := PO_WF_UTIL_PKG.GetItemAttrNumber (

Line 5172: PO_MOAC_UTILS_PVT.set_org_context(l_orgid) ; --

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) ; --
5173: END IF;
5174:
5175: l_note := PO_WF_UTIL_PKG.GetItemAttrText(itemtype => itemtype,
5176: itemkey => itemkey,

Line 5536: PO_MOAC_UTILS_PVT.set_org_context(l_orgid) ; --

5532: aname => 'ORG_ID');
5533:
5534: IF l_orgid is NOT NULL THEN
5535:
5536: PO_MOAC_UTILS_PVT.set_org_context(l_orgid) ; --
5537:
5538: END IF;
5539:
5540: open accepted_change;

Line 5772: PO_MOAC_UTILS_PVT.set_org_context(l_orgid) ; --

5768: aname => 'ORG_ID');
5769:
5770: IF l_orgid is NOT NULL THEN
5771:
5772: PO_MOAC_UTILS_PVT.set_org_context(l_orgid) ; --
5773:
5774: END IF;
5775:
5776: open change_request_status ;

Line 5967: PO_MOAC_UTILS_PVT.set_org_context(l_org_id) ; --

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) ; --
5968: END IF;
5969:
5970: SELECT max(sequence_num)
5971: INTO l_sequence_num

Line 6122: PO_MOAC_UTILS_PVT.set_org_context(l_org_id) ; --

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) ; --
6123:
6124: END IF;
6125:
6126: l_progress := 'Update_Action_History_Return: 002-'||

Line 6252: PO_MOAC_UTILS_PVT.set_org_context(l_orgid) ; --

6248: aname => 'ORG_ID');
6249:
6250: IF l_orgid is NOT NULL THEN
6251:
6252: PO_MOAC_UTILS_PVT.set_org_context(l_orgid) ; --
6253:
6254: END IF;
6255:
6256: l_change_request_group_id := PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => itemtype,

Line 6332: PO_MOAC_UTILS_PVT.set_org_context(l_orgid) ; --

6328: aname => 'ORG_ID');
6329:
6330: IF l_orgid is NOT NULL THEN
6331:
6332: PO_MOAC_UTILS_PVT.set_org_context(l_orgid) ; --
6333:
6334: END IF;
6335:
6336: l_change_request_group_id := PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => itemtype,

Line 6403: PO_MOAC_UTILS_PVT.set_org_context(l_orgid) ; --

6399: aname => 'ORG_ID');
6400:
6401: IF l_orgid is NOT NULL THEN
6402:
6403: PO_MOAC_UTILS_PVT.set_org_context(l_orgid) ; --
6404:
6405: END IF;
6406:
6407: setNewTotal(itemtype, itemkey);

Line 6663: PO_MOAC_UTILS_PVT.set_org_context(l_orgid) ; --

6659: aname => 'ORG_ID');
6660:
6661: IF l_orgid is NOT NULL THEN
6662:
6663: PO_MOAC_UTILS_PVT.set_org_context(l_orgid) ; --
6664:
6665: END IF;
6666:
6667: IF l_doc_type IN ('PO','PA') THEN

Line 6761: PO_MOAC_UTILS_PVT.set_org_context(l_orgid) ; --

6757: aname => 'ORG_ID');
6758:
6759: IF l_orgid is NOT NULL THEN
6760:
6761: PO_MOAC_UTILS_PVT.set_org_context(l_orgid) ; --
6762:
6763: END IF;
6764:
6765: IF l_doc_type IN ('PO','PA') THEN

Line 6846: PO_MOAC_UTILS_PVT.set_org_context(l_orgid) ; --

6842: aname => 'ORG_ID');
6843:
6844: IF l_orgid is NOT NULL THEN
6845:
6846: PO_MOAC_UTILS_PVT.set_org_context(l_orgid) ; --
6847:
6848: END IF;
6849:
6850: IF l_doc_type IN ('PO','PA') THEN

Line 6937: PO_MOAC_UTILS_PVT.set_org_context(l_orgid) ; --

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) ; --
6938: END IF;
6939: SetPoRequestStatus(l_change_request_group_id, 'REJECTED', l_response_reason);
6940:
6941: x_progress := 'PO_ReqChangeRequestWF_PVT.Record_Buyer_Rejection: 02';

Line 7011: PO_MOAC_UTILS_PVT.set_org_context(l_orgid) ; --

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) ; --
7012: END IF;
7013: SetPoRequestStatus(l_change_request_group_id, 'BUYER_APP', l_response_reason);
7014:
7015: x_progress := 'PO_ReqChangeRequestWF_PVT.Record_Buyer_Acceptance: 02';

Line 7080: PO_MOAC_UTILS_PVT.set_org_context(l_orgid) ; --

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) ; --
7081: END IF;
7082: Start_ProcessBuyerResponseWF(l_change_request_group_id);
7083:
7084: x_progress := 'PO_ReqChangeRequestWF_PVT.Start_Process_Buy_Response_WF: 02';

Line 7194: PO_MOAC_UTILS_PVT.set_org_context(l_orgid) ; --

7190: aname => 'ORG_ID');
7191:
7192: IF l_orgid is NOT NULL THEN
7193:
7194: PO_MOAC_UTILS_PVT.set_org_context(l_orgid) ; --
7195:
7196: END IF;
7197:
7198: IF l_doc_type IN ('PO','PA') THEN

Line 7293: PO_MOAC_UTILS_PVT.set_org_context(l_orgid) ; --

7289: aname => 'ORG_ID');
7290:
7291: IF l_orgid is NOT NULL THEN
7292:
7293: PO_MOAC_UTILS_PVT.set_org_context(l_orgid) ; --
7294:
7295: END IF;
7296: ProcessBuyerAction(l_change_request_group_id, 'REJECTION');
7297:

Line 7384: PO_MOAC_UTILS_PVT.set_org_context(l_orgid) ; --

7380: aname => 'ORG_ID');
7381:
7382: IF l_orgid is NOT NULL THEN
7383:
7384: PO_MOAC_UTILS_PVT.set_org_context(l_orgid) ; --
7385:
7386: END IF;
7387:
7388: ProcessBuyerAction(l_change_request_group_id, 'CANCELLATION');

Line 7455: PO_MOAC_UTILS_PVT.set_org_context(l_orgid) ; --

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) ; --
7456: END IF;
7457:
7458: open accepted_change;
7459: fetch accepted_change into l_change_request_id;

Line 7536: PO_MOAC_UTILS_PVT.set_org_context(l_orgid) ; --

7532: aname => 'ORG_ID');
7533:
7534: IF l_orgid is NOT NULL THEN
7535:
7536: PO_MOAC_UTILS_PVT.set_org_context(l_orgid) ; --
7537:
7538: END IF;
7539: ProcessBuyerAction(l_change_request_group_id, 'ACCEPTANCE');
7540:

Line 7656: PO_MOAC_UTILS_PVT.set_org_context(l_orgid) ; --

7652: aname => 'ORG_ID');
7653:
7654: IF l_orgid is NOT NULL THEN
7655:
7656: PO_MOAC_UTILS_PVT.set_org_context(l_orgid) ; --
7657:
7658: END IF;
7659:
7660: x_progress := 'PO_ReqChangeRequestWF_PVT.Start_Poapprv_WF:01';

Line 7781: PO_MOAC_UTILS_PVT.set_org_context(l_orgid) ; --

7777: aname => 'ORG_ID');
7778:
7779: IF l_orgid is NOT NULL THEN
7780:
7781: PO_MOAC_UTILS_PVT.set_org_context(l_orgid) ; --
7782:
7783: END IF;
7784:
7785: open pending_parent_change_csr(l_change_request_group_id);

Line 7853: PO_MOAC_UTILS_PVT.set_org_context(l_orgid) ; --

7849: aname => 'ORG_ID' );
7850:
7851: IF l_orgid is NOT NULL THEN
7852:
7853: PO_MOAC_UTILS_PVT.set_org_context(l_orgid) ; --
7854:
7855: END IF;
7856:
7857: l_req_change_request_group_id := PO_WF_UTIL_PKG.GetItemAttrNumber (

Line 7959: PO_MOAC_UTILS_PVT.set_org_context(l_orgid) ; --

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) ; --
7960: END IF;
7961:
7962: x_progress := 'PO_ReqChangeRequestWF_PVT.Get_Total_Amount_Currency: 02';
7963:

Line 8383: PO_MOAC_UTILS_PVT.set_org_context(l_orgid) ; --

8379: aname => 'ORG_ID');
8380:
8381: IF l_orgid is NOT NULL THEN
8382:
8383: PO_MOAC_UTILS_PVT.set_org_context(l_orgid) ; --
8384:
8385: END IF;
8386:
8387: open parent_change(l_change_request_group_id);

Line 8672: PO_MOAC_UTILS_PVT.set_org_context(l_orgid) ; --

8668: aname => 'ORG_ID');
8669:
8670: IF l_orgid is NOT NULL THEN
8671:
8672: PO_MOAC_UTILS_PVT.set_org_context(l_orgid) ; --
8673:
8674: END IF;
8675:
8676: open new_change(l_change_request_group_id);

Line 8758: PO_MOAC_UTILS_PVT.set_org_context(l_orgid) ; --

8754: aname => 'ORG_ID');
8755:
8756: IF l_orgid is NOT NULL THEN
8757:
8758: PO_MOAC_UTILS_PVT.set_org_context(l_orgid) ; --
8759:
8760: END IF;
8761: SetPoRequestStatus(l_change_request_group_id, 'ACCEPTED');
8762:

Line 8824: PO_MOAC_UTILS_PVT.set_org_context(l_orgid) ; --

8820: aname => 'ORG_ID');
8821:
8822: IF l_orgid is NOT NULL THEN
8823:
8824: PO_MOAC_UTILS_PVT.set_org_context(l_orgid) ; --
8825:
8826: END IF;
8827: SetPoRequestStatus(l_change_request_group_id, 'REJECTED');
8828:

Line 8893: PO_MOAC_UTILS_PVT.set_org_context(l_orgid) ; --

8889: aname => 'ORG_ID');
8890:
8891: IF l_orgid is NOT NULL THEN
8892:
8893: PO_MOAC_UTILS_PVT.set_org_context(l_orgid) ; --
8894:
8895: END IF;
8896: ValidateChgAgainstNewPO(l_change_request_group_id);
8897:

Line 9994: PO_MOAC_UTILS_PVT.set_org_context(l_orgid) ; --

9990: aname => 'ORG_ID');
9991:
9992: IF l_orgid is NOT NULL THEN
9993:
9994: PO_MOAC_UTILS_PVT.set_org_context(l_orgid) ; --
9995:
9996: END IF;
9997:
9998: x_progress := 'PO_ReqChangeRequestWF_PVT.Set_Buyer_Approval_Notfn_Attr: 02';

Line 10247: PO_MOAC_UTILS_PVT.set_org_context(l_orgid) ; --

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) ; --
10248:
10249: END IF;
10250:
10251: x_progress := 'PO_ReqChangeRequestWF_PVT.Start_POChange_WF: 04';

Line 11412: PO_MOAC_UTILS_PVT.set_org_context(l_orgid) ; --

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) ; --
11413: END IF;
11414:
11415: l_progress := 'PO_ReqChangeRequestWF_PVT.Start_Notify_Requester_Process: 03';
11416:

Line 11892: PO_MOAC_UTILS_PVT.set_org_context(l_orgid) ; --

11888: END IF;
11889:
11890:
11891: IF l_orgid is NOT NULL THEN
11892: PO_MOAC_UTILS_PVT.set_org_context(l_orgid) ; --
11893: END IF;
11894:
11895: OE_Internal_Requisition_Pvt.Apply_Hold_for_IReq -- Specification definition
11896: ( P_API_Version => 1.0

Line 11912: PO_MOAC_UTILS_PVT.set_org_context(l_orgid) ; --

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) ; --
11913: END IF;
11914:
11915: IF g_debug_stmt THEN
11916: po_debug.debug_var(l_log_head,l_progress,'p_item_key',p_item_key );

Line 12055: PO_MOAC_UTILS_PVT.set_org_context(l_orgid) ; --

12051: END IF;
12052:
12053:
12054: IF l_orgid is NOT NULL THEN
12055: PO_MOAC_UTILS_PVT.set_org_context(l_orgid) ; --
12056:
12057: --release the OM LINE FROM HOLD call OM_API
12058: x_progress := '020';
12059: OE_Internal_Requisition_Pvt.Release_Hold_for_IReq

Line 12073: PO_MOAC_UTILS_PVT.set_org_context(l_orgid) ; --

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) ; --
12074: END IF;
12075:
12076: END IF;
12077: END LOOP;

Line 12246: PO_MOAC_UTILS_PVT.set_org_context(l_orgid) ; --

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) ; --
12247:
12248: --release the OM LINE FROM HOLD call OM_API
12249: -- release the hold from SO before calling process order api bug 8299243
12250:

Line 12268: PO_MOAC_UTILS_PVT.set_org_context(l_orgid) ; --

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) ; --
12269:
12270: -- Algorithm : call om api according to action type
12271:
12272: IF (p_action_type = 'MODIFICATION' ) THEN

Line 12333: PO_MOAC_UTILS_PVT.set_org_context(l_orgid) ; --

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) ; --
12334: END IF;
12335:
12336:
12337:

Line 12430: PO_MOAC_UTILS_PVT.set_org_context(l_orgid) ; --

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) ; --
12431: END IF;
12432:
12433: COMMIT;
12434: l_progress := '015';

Line 12442: PO_MOAC_UTILS_PVT.set_org_context(l_orgid) ; --

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) ; --
12443: END IF;
12444:
12445: wf_core.context('PO_ReqChangeRequestWF_PVT', 'ConvertIntoSOChange '||l_return_status, l_progress);
12446: ROLLBACK TO convertintosochange_SP;