DBA Data[Home] [Help]

APPS.PO_REQCHANGEREQUESTWF_PVT dependencies on PO_MOAC_UTILS_PVT

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

4773: aname => 'ORG_ID');
4774:
4775: IF l_orgid is NOT NULL THEN
4776:
4777: PO_MOAC_UTILS_PVT.set_org_context(l_orgid) ; --
4778:
4779: END IF;
4780:
4781: open change_request_group_id;

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

4867: aname => 'ORG_ID');
4868:
4869: IF l_orgid is NOT NULL THEN
4870:
4871: PO_MOAC_UTILS_PVT.set_org_context(l_orgid) ; --
4872:
4873: END IF;
4874:
4875: l_change_request_group_id := PO_WF_UTIL_PKG.GetItemAttrNumber (

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

4980: itemkey => itemkey,
4981: aname => 'ORG_ID');
4982:
4983: IF l_orgid is NOT NULL THEN
4984: PO_MOAC_UTILS_PVT.set_org_context(l_orgid) ; --
4985: END IF;
4986:
4987: l_note := PO_WF_UTIL_PKG.GetItemAttrText(itemtype => itemtype,
4988: itemkey => itemkey,

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

5344: aname => 'ORG_ID');
5345:
5346: IF l_orgid is NOT NULL THEN
5347:
5348: PO_MOAC_UTILS_PVT.set_org_context(l_orgid) ; --
5349:
5350: END IF;
5351:
5352: open accepted_change;

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

5580: aname => 'ORG_ID');
5581:
5582: IF l_orgid is NOT NULL THEN
5583:
5584: PO_MOAC_UTILS_PVT.set_org_context(l_orgid) ; --
5585:
5586: END IF;
5587:
5588: open change_request_status ;

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

5775: itemkey => itemkey,
5776: aname => 'ORG_ID');
5777:
5778: IF l_org_id is NOT NULL THEN
5779: PO_MOAC_UTILS_PVT.set_org_context(l_org_id) ; --
5780: END IF;
5781:
5782: SELECT max(sequence_num)
5783: INTO l_sequence_num

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

5930: aname => 'ORG_ID');
5931:
5932: IF l_org_id is NOT NULL THEN
5933:
5934: PO_MOAC_UTILS_PVT.set_org_context(l_org_id) ; --
5935:
5936: END IF;
5937:
5938: l_progress := 'Update_Action_History_Return: 002-'||

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

6060: aname => 'ORG_ID');
6061:
6062: IF l_orgid is NOT NULL THEN
6063:
6064: PO_MOAC_UTILS_PVT.set_org_context(l_orgid) ; --
6065:
6066: END IF;
6067:
6068: l_change_request_group_id := PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => itemtype,

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

6140: aname => 'ORG_ID');
6141:
6142: IF l_orgid is NOT NULL THEN
6143:
6144: PO_MOAC_UTILS_PVT.set_org_context(l_orgid) ; --
6145:
6146: END IF;
6147:
6148: l_change_request_group_id := PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => itemtype,

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

6211: aname => 'ORG_ID');
6212:
6213: IF l_orgid is NOT NULL THEN
6214:
6215: PO_MOAC_UTILS_PVT.set_org_context(l_orgid) ; --
6216:
6217: END IF;
6218:
6219: setNewTotal(itemtype, itemkey);

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

6426: aname => 'ORG_ID');
6427:
6428: IF l_orgid is NOT NULL THEN
6429:
6430: PO_MOAC_UTILS_PVT.set_org_context(l_orgid) ; --
6431:
6432: END IF;
6433:
6434: IF l_doc_type IN ('PO','PA') THEN

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

6524: aname => 'ORG_ID');
6525:
6526: IF l_orgid is NOT NULL THEN
6527:
6528: PO_MOAC_UTILS_PVT.set_org_context(l_orgid) ; --
6529:
6530: END IF;
6531:
6532: IF l_doc_type IN ('PO','PA') THEN

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

6609: aname => 'ORG_ID');
6610:
6611: IF l_orgid is NOT NULL THEN
6612:
6613: PO_MOAC_UTILS_PVT.set_org_context(l_orgid) ; --
6614:
6615: END IF;
6616:
6617: IF l_doc_type IN ('PO','PA') THEN

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

6700: itemkey => itemkey,
6701: aname => 'RESPONSE_REASON');
6702:
6703: IF l_orgid is NOT NULL THEN
6704: PO_MOAC_UTILS_PVT.set_org_context(l_orgid) ; --
6705: END IF;
6706: SetPoRequestStatus(l_change_request_group_id, 'REJECTED', l_response_reason);
6707:
6708: x_progress := 'PO_ReqChangeRequestWF_PVT.Record_Buyer_Rejection: 02';

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

6774: itemkey => itemkey,
6775: aname => 'ORG_ID');
6776:
6777: IF l_orgid is NOT NULL THEN
6778: PO_MOAC_UTILS_PVT.set_org_context(l_orgid) ; --
6779: END IF;
6780: SetPoRequestStatus(l_change_request_group_id, 'BUYER_APP', l_response_reason);
6781:
6782: x_progress := 'PO_ReqChangeRequestWF_PVT.Record_Buyer_Acceptance: 02';

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

6843: itemkey => itemkey,
6844: aname => 'ORG_ID');
6845:
6846: IF l_orgid is NOT NULL THEN
6847: PO_MOAC_UTILS_PVT.set_org_context(l_orgid) ; --
6848: END IF;
6849: Start_ProcessBuyerResponseWF(l_change_request_group_id);
6850:
6851: x_progress := 'PO_ReqChangeRequestWF_PVT.Start_Process_Buy_Response_WF: 02';

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

6957: aname => 'ORG_ID');
6958:
6959: IF l_orgid is NOT NULL THEN
6960:
6961: PO_MOAC_UTILS_PVT.set_org_context(l_orgid) ; --
6962:
6963: END IF;
6964:
6965: IF l_doc_type IN ('PO','PA') THEN

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

7052: aname => 'ORG_ID');
7053:
7054: IF l_orgid is NOT NULL THEN
7055:
7056: PO_MOAC_UTILS_PVT.set_org_context(l_orgid) ; --
7057:
7058: END IF;
7059: ProcessBuyerAction(l_change_request_group_id, 'REJECTION');
7060:

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

7143: aname => 'ORG_ID');
7144:
7145: IF l_orgid is NOT NULL THEN
7146:
7147: PO_MOAC_UTILS_PVT.set_org_context(l_orgid) ; --
7148:
7149: END IF;
7150:
7151: ProcessBuyerAction(l_change_request_group_id, 'CANCELLATION');

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

7214: itemkey => itemkey,
7215: aname => 'ORG_ID');
7216:
7217: IF l_orgid is NOT NULL THEN
7218: PO_MOAC_UTILS_PVT.set_org_context(l_orgid) ; --
7219: END IF;
7220:
7221: open accepted_change;
7222: fetch accepted_change into l_change_request_id;

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

7295: aname => 'ORG_ID');
7296:
7297: IF l_orgid is NOT NULL THEN
7298:
7299: PO_MOAC_UTILS_PVT.set_org_context(l_orgid) ; --
7300:
7301: END IF;
7302: ProcessBuyerAction(l_change_request_group_id, 'ACCEPTANCE');
7303:

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

7415: aname => 'ORG_ID');
7416:
7417: IF l_orgid is NOT NULL THEN
7418:
7419: PO_MOAC_UTILS_PVT.set_org_context(l_orgid) ; --
7420:
7421: END IF;
7422:
7423: x_progress := 'PO_ReqChangeRequestWF_PVT.Start_Poapprv_WF:01';

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

7540: aname => 'ORG_ID');
7541:
7542: IF l_orgid is NOT NULL THEN
7543:
7544: PO_MOAC_UTILS_PVT.set_org_context(l_orgid) ; --
7545:
7546: END IF;
7547:
7548: open pending_parent_change_csr(l_change_request_group_id);

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

7612: aname => 'ORG_ID' );
7613:
7614: IF l_orgid is NOT NULL THEN
7615:
7616: PO_MOAC_UTILS_PVT.set_org_context(l_orgid) ; --
7617:
7618: END IF;
7619:
7620: l_req_change_request_group_id := PO_WF_UTIL_PKG.GetItemAttrNumber (

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

7711: itemkey => itemkey,
7712: aname => 'ORG_ID');
7713:
7714: IF l_orgid is NOT NULL THEN
7715: PO_MOAC_UTILS_PVT.set_org_context(l_orgid) ; --
7716: END IF;
7717:
7718: x_progress := 'PO_ReqChangeRequestWF_PVT.Get_Total_Amount_Currency: 02';
7719:

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

8063: aname => 'ORG_ID');
8064:
8065: IF l_orgid is NOT NULL THEN
8066:
8067: PO_MOAC_UTILS_PVT.set_org_context(l_orgid) ; --
8068:
8069: END IF;
8070:
8071: open parent_change(l_change_request_group_id);

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

8281: aname => 'ORG_ID');
8282:
8283: IF l_orgid is NOT NULL THEN
8284:
8285: PO_MOAC_UTILS_PVT.set_org_context(l_orgid) ; --
8286:
8287: END IF;
8288:
8289: open new_change(l_change_request_group_id);

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

8367: aname => 'ORG_ID');
8368:
8369: IF l_orgid is NOT NULL THEN
8370:
8371: PO_MOAC_UTILS_PVT.set_org_context(l_orgid) ; --
8372:
8373: END IF;
8374: SetPoRequestStatus(l_change_request_group_id, 'ACCEPTED');
8375:

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

8433: aname => 'ORG_ID');
8434:
8435: IF l_orgid is NOT NULL THEN
8436:
8437: PO_MOAC_UTILS_PVT.set_org_context(l_orgid) ; --
8438:
8439: END IF;
8440: SetPoRequestStatus(l_change_request_group_id, 'REJECTED');
8441:

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

8502: aname => 'ORG_ID');
8503:
8504: IF l_orgid is NOT NULL THEN
8505:
8506: PO_MOAC_UTILS_PVT.set_org_context(l_orgid) ; --
8507:
8508: END IF;
8509: ValidateChgAgainstNewPO(l_change_request_group_id);
8510:

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

9603: aname => 'ORG_ID');
9604:
9605: IF l_orgid is NOT NULL THEN
9606:
9607: PO_MOAC_UTILS_PVT.set_org_context(l_orgid) ; --
9608:
9609: END IF;
9610:
9611: x_progress := 'PO_ReqChangeRequestWF_PVT.Set_Buyer_Approval_Notfn_Attr: 02';

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

9856: x_progress := 'PO_ReqChangeRequestWF_PVT.Start_POChange_WF: 03';
9857:
9858: IF l_orgid is NOT NULL THEN
9859:
9860: PO_MOAC_UTILS_PVT.set_org_context(l_orgid) ; --
9861:
9862: END IF;
9863:
9864: x_progress := 'PO_ReqChangeRequestWF_PVT.Start_POChange_WF: 04';

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

11014:
11015: l_progress := 'PO_ReqChangeRequestWF_PVT.Start_Notify_Requester_Process: 02';
11016:
11017: IF l_orgid is NOT NULL THEN
11018: PO_MOAC_UTILS_PVT.set_org_context(l_orgid) ; --
11019: END IF;
11020:
11021: l_progress := 'PO_ReqChangeRequestWF_PVT.Start_Notify_Requester_Process: 03';
11022:

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

11473: -- need to appli req line level hold
11474: l_orgid := get_sales_order_org(p_req_hdr_id => p_req_header_id);
11475:
11476: IF l_orgid is NOT NULL THEN
11477: PO_MOAC_UTILS_PVT.set_org_context(l_orgid) ; --
11478: END IF;
11479:
11480: OPEN req_line_id_chn_csr(l_change_request_group_id);
11481: LOOP

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

11495:
11496: l_orgid := get_requisition_org( p_req_hdr_id => p_req_header_id);
11497:
11498: IF l_orgid is NOT NULL THEN
11499: PO_MOAC_UTILS_PVT.set_org_context(l_orgid) ; --
11500: END IF;
11501:
11502: IF g_debug_stmt THEN
11503: po_debug.debug_var(l_log_head,l_progress,'p_item_key',p_item_key );

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

11665: l_orgid := get_sales_order_org(p_req_hdr_id => l_document_header_id);
11666:
11667:
11668: IF l_orgid is NOT NULL AND itemtype <> 'REQ_RESCHEDULE' THEN
11669: PO_MOAC_UTILS_PVT.set_org_context(l_orgid) ; --
11670:
11671: --release the OM LINE FROM HOLD call OM_API
11672: x_progress := '020';
11673: OE_Internal_Requisition_Pvt.Release_Hold_for_IReq

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

11810:
11811: l_progress := '004';
11812:
11813: IF l_orgid is NOT NULL THEN
11814: PO_MOAC_UTILS_PVT.set_org_context(l_orgid) ; --
11815:
11816: -- Algorithm : call om api according to action type
11817:
11818: IF (p_action_type = 'MODIFICATION' ) THEN

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

11871:
11872: l_orgid := get_requisition_org( p_req_hdr_id => l_document_header_id);
11873:
11874: IF l_orgid is NOT NULL THEN
11875: PO_MOAC_UTILS_PVT.set_org_context(l_orgid) ; --
11876: END IF;
11877:
11878: IF g_debug_stmt THEN
11879: po_debug.debug_var(l_log_head, l_progress,'returning from OM API ',l_return_status);

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

11969: --release the OM LINE FROM HOLD call OM_API
11970: l_orgid := get_sales_order_org(p_req_hdr_id => l_document_header_id);
11971:
11972: IF l_orgid is NOT NULL AND p_mode <> 'REQ_RESCHEDULE' THEN
11973: PO_MOAC_UTILS_PVT.set_org_context(l_orgid) ; --
11974:
11975: --release the OM LINE FROM HOLD call OM_API
11976:
11977: OE_Internal_Requisition_Pvt.Release_Hold_for_IReq

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

11987:
11988: l_orgid := get_requisition_org( p_req_hdr_id => l_document_header_id);
11989:
11990: IF l_orgid is NOT NULL THEN
11991: PO_MOAC_UTILS_PVT.set_org_context(l_orgid) ; --
11992: END IF;
11993:
11994: COMMIT;
11995: l_progress := '015';

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

11999: l_orgid := get_requisition_org( p_req_hdr_id => l_document_header_id);
12000: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
12001:
12002: IF l_orgid is NOT NULL THEN
12003: PO_MOAC_UTILS_PVT.set_org_context(l_orgid) ; --
12004: END IF;
12005:
12006: wf_core.context('PO_ReqChangeRequestWF_PVT', 'ConvertIntoSOChange '||l_return_status, l_progress);
12007: ROLLBACK TO convertintosochange_SP;