APPS.PO_OM_INTEGRATION_GRP dependencies on PO_MOAC_UTILS_PVT

Line 140: l_original_org_id NUMBER := PO_MOAC_UTILS_PVT.get_current_org_id ; -- added

136: -- Bug 3292895 END
137:
138: l_quantity_ordered PO_TBL_NUMBER := p_quantity;
139:
140: l_original_org_id NUMBER := PO_MOAC_UTILS_PVT.get_current_org_id ; -- added
141: l_document_org_id PO_HEADERS.ORG_ID%TYPE;
142: l_count NUMBER;
143:
144: --Bug# 4640038 Start, Added the following variable

Line 554: PO_MOAC_UTILS_PVT.set_org_context(l_document_org_id) ; --

550: FROM po_requisition_headers_all
551: WHERE requisition_header_id = l_cur_req_header_id;
552:
553: -- Set Org Context to that of Document
554: PO_MOAC_UTILS_PVT.set_org_context(l_document_org_id) ; --
555:
556: l_progress := '250';
557: PO_REQ_DOCUMENT_UPDATE_GRP.update_requisition (
558: p_api_version => 1.0,

Line 578: PO_MOAC_UTILS_PVT.set_org_context(l_original_org_id) ; --

574: -- Bug 3292895 END
575:
576: l_progress := '900';
577: -- Set the org context back to the original operating unit.
578: PO_MOAC_UTILS_PVT.set_org_context(l_original_org_id) ; --
579:
580: x_return_status := FND_API.G_RET_STS_SUCCESS;
581:
582: EXCEPTION

Line 588: PO_MOAC_UTILS_PVT.set_org_context(l_original_org_id) ; --

584: ROLLBACK TO PO_OM_GRP_UPDATE_REQ_PO_SP;
585: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
586: x_return_status := FND_API.G_RET_STS_ERROR;
587: -- Set the org context back to the original operating unit.
588: PO_MOAC_UTILS_PVT.set_org_context(l_original_org_id) ; --
589: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
590: ROLLBACK TO PO_OM_GRP_UPDATE_REQ_PO_SP;
591: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
592: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 594: PO_MOAC_UTILS_PVT.set_org_context(l_original_org_id) ; --

590: ROLLBACK TO PO_OM_GRP_UPDATE_REQ_PO_SP;
591: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
592: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
593: -- Set the org context back to the original operating unit.
594: PO_MOAC_UTILS_PVT.set_org_context(l_original_org_id) ; --
595: WHEN OTHERS THEN
596: ROLLBACK TO PO_OM_GRP_UPDATE_REQ_PO_SP;
597: PO_DEBUG.handle_unexp_error ( p_pkg_name => g_pkg_name,
598: p_proc_name => l_api_name,

Line 603: PO_MOAC_UTILS_PVT.set_org_context(l_original_org_id) ; --

599: p_progress => l_progress );
600: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
601: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
602: -- Set the org context back to the original operating unit.
603: PO_MOAC_UTILS_PVT.set_org_context(l_original_org_id) ; --
604:
605: END update_req_po;
606:
607: -------------------------------------------------------------------------------

Line 684: l_original_org_id NUMBER := PO_MOAC_UTILS_PVT.get_current_org_id ; --

680: l_doc_type PO_DOCUMENT_TYPES.DOCUMENT_TYPE_CODE%TYPE;
681: l_doc_subtype PO_DOCUMENT_TYPES.DOCUMENT_SUBTYPE%TYPE;
682:
683: -- Bug 3248723 START
684: l_original_org_id NUMBER := PO_MOAC_UTILS_PVT.get_current_org_id ; --
685: l_approved_date PO_LINE_LOCATIONS_ALL.approved_date%TYPE;
686: l_chg PO_CHANGES_REC_TYPE;
687: -- Bug 3248723 END
688: l_document_org_id PO_HEADERS.ORG_ID%TYPE; -- Bug 3362534

Line 772: PO_MOAC_UTILS_PVT.set_org_context(l_document_org_id) ; --

768: -- Bug 3248723 END
769: l_progress := '035';
770:
771: -- Bug 3362534 Set the org context to the operating unit of the document.
772: PO_MOAC_UTILS_PVT.set_org_context(l_document_org_id) ; --
773:
774: PO_Document_Control_GRP.control_document
775: (p_api_version => 1.0,
776: p_init_msg_list => FND_API.G_FALSE,

Line 909: PO_MOAC_UTILS_PVT.set_org_context(l_original_org_id) ; --

905:
906: x_return_status := FND_API.G_RET_STS_SUCCESS;
907:
908: -- Set the org context back to the original operating unit.
909: PO_MOAC_UTILS_PVT.set_org_context(l_original_org_id) ; --
910:
911: EXCEPTION
912: WHEN FND_API.G_EXC_ERROR THEN
913: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);

Line 916: PO_MOAC_UTILS_PVT.set_org_context(l_original_org_id) ; --

912: WHEN FND_API.G_EXC_ERROR THEN
913: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
914: x_return_status := FND_API.G_RET_STS_ERROR;
915: -- Set the org context back to the original operating unit.
916: PO_MOAC_UTILS_PVT.set_org_context(l_original_org_id) ; --
917: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
918: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
919: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
920: -- Set the org context back to the original operating unit.

Line 921: PO_MOAC_UTILS_PVT.set_org_context(l_original_org_id) ; --

917: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
918: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
919: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
920: -- Set the org context back to the original operating unit.
921: PO_MOAC_UTILS_PVT.set_org_context(l_original_org_id) ; --
922: WHEN OTHERS THEN
923: PO_DEBUG.handle_unexp_error ( p_pkg_name => g_pkg_name,
924: p_proc_name => l_api_name,
925: p_progress => l_progress );

Line 929: PO_MOAC_UTILS_PVT.set_org_context(l_original_org_id) ; --

925: p_progress => l_progress );
926: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
927: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
928: -- Set the org context back to the original operating unit.
929: PO_MOAC_UTILS_PVT.set_org_context(l_original_org_id) ; --
930:
931: END cancel_req_po;
932:
933: -- Bug 3248723 START

Line 984: PO_MOAC_UTILS_PVT.set_org_context(l_document_org_id) ; --

980:
981: l_progress := '010';
982:
983: -- Set Org Context to that of Document
984: PO_MOAC_UTILS_PVT.set_org_context(l_document_org_id) ; --
985:
986: -- If the PO was in Approved status before the change, then perform
987: -- submission checks and launch the PO Approval workflow to re-approve
988: -- the PO after making the changes.