4773: aname => 'ORG_ID');
4774:
4775: IF l_orgid is NOT NULL THEN
4776:
4777: PO_MOAC_UTILS_PVT.set_org_context(l_orgid) ; --
4779: END IF;
4780:
4781: open change_request_group_id;
4867: aname => 'ORG_ID');
4868:
4869: IF l_orgid is NOT NULL THEN
4870:
4871: PO_MOAC_UTILS_PVT.set_org_context(l_orgid) ; --
4873: END IF;
4874:
4875: l_change_request_group_id := PO_WF_UTIL_PKG.GetItemAttrNumber (
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) ; --
4986:
4987: l_note := PO_WF_UTIL_PKG.GetItemAttrText(itemtype => itemtype,
4988: itemkey => itemkey,
5344: aname => 'ORG_ID');
5345:
5346: IF l_orgid is NOT NULL THEN
5347:
5348: PO_MOAC_UTILS_PVT.set_org_context(l_orgid) ; --
5350: END IF;
5351:
5352: open accepted_change;
5580: aname => 'ORG_ID');
5581:
5582: IF l_orgid is NOT NULL THEN
5583:
5584: PO_MOAC_UTILS_PVT.set_org_context(l_orgid) ; --
5586: END IF;
5587:
5588: open change_request_status ;
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) ; --
5781:
5782: SELECT max(sequence_num)
5783: INTO l_sequence_num
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) ; --
5936: END IF;
5937:
5938: l_progress := 'Update_Action_History_Return: 002-'||
6060: aname => 'ORG_ID');
6061:
6062: IF l_orgid is NOT NULL THEN
6063:
6064: PO_MOAC_UTILS_PVT.set_org_context(l_orgid) ; --
6066: END IF;
6067:
6068: l_change_request_group_id := PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => itemtype,
6140: aname => 'ORG_ID');
6141:
6142: IF l_orgid is NOT NULL THEN
6143:
6144: PO_MOAC_UTILS_PVT.set_org_context(l_orgid) ; --
6146: END IF;
6147:
6148: l_change_request_group_id := PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => itemtype,
6211: aname => 'ORG_ID');
6212:
6213: IF l_orgid is NOT NULL THEN
6214:
6215: PO_MOAC_UTILS_PVT.set_org_context(l_orgid) ; --
6217: END IF;
6218:
6219: setNewTotal(itemtype, itemkey);
6426: aname => 'ORG_ID');
6427:
6428: IF l_orgid is NOT NULL THEN
6429:
6430: PO_MOAC_UTILS_PVT.set_org_context(l_orgid) ; --
6432: END IF;
6433:
6434: IF l_doc_type IN ('PO','PA') THEN
6524: aname => 'ORG_ID');
6525:
6526: IF l_orgid is NOT NULL THEN
6527:
6528: PO_MOAC_UTILS_PVT.set_org_context(l_orgid) ; --
6530: END IF;
6531:
6532: IF l_doc_type IN ('PO','PA') THEN
6609: aname => 'ORG_ID');
6610:
6611: IF l_orgid is NOT NULL THEN
6612:
6613: PO_MOAC_UTILS_PVT.set_org_context(l_orgid) ; --
6615: END IF;
6616:
6617: IF l_doc_type IN ('PO','PA') THEN
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) ; --
6706: SetPoRequestStatus(l_change_request_group_id, 'REJECTED', l_response_reason);
6707:
6708: x_progress := 'PO_ReqChangeRequestWF_PVT.Record_Buyer_Rejection: 02';
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) ; --
6780: SetPoRequestStatus(l_change_request_group_id, 'BUYER_APP', l_response_reason);
6781:
6782: x_progress := 'PO_ReqChangeRequestWF_PVT.Record_Buyer_Acceptance: 02';
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) ; --
6849: Start_ProcessBuyerResponseWF(l_change_request_group_id);
6850:
6851: x_progress := 'PO_ReqChangeRequestWF_PVT.Start_Process_Buy_Response_WF: 02';
6957: aname => 'ORG_ID');
6958:
6959: IF l_orgid is NOT NULL THEN
6960:
6961: PO_MOAC_UTILS_PVT.set_org_context(l_orgid) ; --
6963: END IF;
6964:
6965: IF l_doc_type IN ('PO','PA') THEN
7052: aname => 'ORG_ID');
7053:
7054: IF l_orgid is NOT NULL THEN
7055:
7056: PO_MOAC_UTILS_PVT.set_org_context(l_orgid) ; --
7058: END IF;
7059: ProcessBuyerAction(l_change_request_group_id, 'REJECTION');
7060:
7143: aname => 'ORG_ID');
7144:
7145: IF l_orgid is NOT NULL THEN
7146:
7147: PO_MOAC_UTILS_PVT.set_org_context(l_orgid) ; --
7149: END IF;
7150:
7151: ProcessBuyerAction(l_change_request_group_id, 'CANCELLATION');
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) ; --
7220:
7221: open accepted_change;
7222: fetch accepted_change into l_change_request_id;
7295: aname => 'ORG_ID');
7296:
7297: IF l_orgid is NOT NULL THEN
7298:
7299: PO_MOAC_UTILS_PVT.set_org_context(l_orgid) ; --
7301: END IF;
7302: ProcessBuyerAction(l_change_request_group_id, 'ACCEPTANCE');
7303:
7415: aname => 'ORG_ID');
7416:
7417: IF l_orgid is NOT NULL THEN
7418:
7419: PO_MOAC_UTILS_PVT.set_org_context(l_orgid) ; --
7421: END IF;
7422:
7423: x_progress := 'PO_ReqChangeRequestWF_PVT.Start_Poapprv_WF:01';
7540: aname => 'ORG_ID');
7541:
7542: IF l_orgid is NOT NULL THEN
7543:
7544: PO_MOAC_UTILS_PVT.set_org_context(l_orgid) ; --
7546: END IF;
7547:
7548: open pending_parent_change_csr(l_change_request_group_id);
7612: aname => 'ORG_ID' );
7613:
7614: IF l_orgid is NOT NULL THEN
7615:
7616: PO_MOAC_UTILS_PVT.set_org_context(l_orgid) ; --
7618: END IF;
7619:
7620: l_req_change_request_group_id := PO_WF_UTIL_PKG.GetItemAttrNumber (
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) ; --
7717:
7718: x_progress := 'PO_ReqChangeRequestWF_PVT.Get_Total_Amount_Currency: 02';
7719:
8063: aname => 'ORG_ID');
8064:
8065: IF l_orgid is NOT NULL THEN
8066:
8067: PO_MOAC_UTILS_PVT.set_org_context(l_orgid) ; --
8069: END IF;
8070:
8071: open parent_change(l_change_request_group_id);
8281: aname => 'ORG_ID');
8282:
8283: IF l_orgid is NOT NULL THEN
8284:
8285: PO_MOAC_UTILS_PVT.set_org_context(l_orgid) ; --
8287: END IF;
8288:
8289: open new_change(l_change_request_group_id);
8367: aname => 'ORG_ID');
8368:
8369: IF l_orgid is NOT NULL THEN
8370:
8371: PO_MOAC_UTILS_PVT.set_org_context(l_orgid) ; --
8373: END IF;
8374: SetPoRequestStatus(l_change_request_group_id, 'ACCEPTED');
8375:
8433: aname => 'ORG_ID');
8434:
8435: IF l_orgid is NOT NULL THEN
8436:
8437: PO_MOAC_UTILS_PVT.set_org_context(l_orgid) ; --
8439: END IF;
8440: SetPoRequestStatus(l_change_request_group_id, 'REJECTED');
8441:
8502: aname => 'ORG_ID');
8503:
8504: IF l_orgid is NOT NULL THEN
8505:
8506: PO_MOAC_UTILS_PVT.set_org_context(l_orgid) ; --
8508: END IF;
8509: ValidateChgAgainstNewPO(l_change_request_group_id);
8510:
9603: aname => 'ORG_ID');
9604:
9605: IF l_orgid is NOT NULL THEN
9606:
9607: PO_MOAC_UTILS_PVT.set_org_context(l_orgid) ; --
9609: END IF;
9610:
9611: x_progress := 'PO_ReqChangeRequestWF_PVT.Set_Buyer_Approval_Notfn_Attr: 02';
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) ; --
9862: END IF;
9863:
9864: x_progress := 'PO_ReqChangeRequestWF_PVT.Start_POChange_WF: 04';
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) ; --
11020:
11021: l_progress := 'PO_ReqChangeRequestWF_PVT.Start_Notify_Requester_Process: 03';
11022:
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) ; --
11479:
11480: OPEN req_line_id_chn_csr(l_change_request_group_id);
11481: LOOP
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) ; --
11501:
11502: IF g_debug_stmt THEN
11503: po_debug.debug_var(l_log_head,l_progress,'p_item_key',p_item_key );
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) ; --
11671: --release the OM LINE FROM HOLD call OM_API
11672: x_progress := '020';
11673: OE_Internal_Requisition_Pvt.Release_Hold_for_IReq
11810:
11811: l_progress := '004';
11812:
11813: IF l_orgid is NOT NULL THEN
11814: PO_MOAC_UTILS_PVT.set_org_context(l_orgid) ; --
11816: -- Algorithm : call om api according to action type
11817:
11818: IF (p_action_type = 'MODIFICATION' ) THEN
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) ; --
11877:
11878: IF g_debug_stmt THEN
11879: po_debug.debug_var(l_log_head, l_progress,'returning from OM API ',l_return_status);
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) ; --
11975: --release the OM LINE FROM HOLD call OM_API
11976:
11977: OE_Internal_Requisition_Pvt.Release_Hold_for_IReq
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) ; --
11993:
11994: COMMIT;
11995: l_progress := '015';
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) ; --
12005:
12006: wf_core.context('PO_ReqChangeRequestWF_PVT', 'ConvertIntoSOChange '||l_return_status, l_progress);
12007: ROLLBACK TO convertintosochange_SP;