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# 8970502 : Added the following variables

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

676: FROM po_requisition_headers_all
677: WHERE requisition_header_id = l_cur_req_header_id;
678:
679: -- Set Org Context to that of Document
680: PO_MOAC_UTILS_PVT.set_org_context(l_document_org_id) ; --
681:
682: l_progress := '250';
683: PO_REQ_DOCUMENT_UPDATE_GRP.update_requisition (
684: p_api_version => 1.0,

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

700: -- Bug 3292895 END
701:
702: l_progress := '900';
703: -- Set the org context back to the original operating unit.
704: PO_MOAC_UTILS_PVT.set_org_context(l_original_org_id) ; --
705:
706: x_return_status := FND_API.G_RET_STS_SUCCESS;
707:
708: EXCEPTION

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

710: ROLLBACK TO PO_OM_GRP_UPDATE_REQ_PO_SP;
711: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
712: x_return_status := FND_API.G_RET_STS_ERROR;
713: -- Set the org context back to the original operating unit.
714: PO_MOAC_UTILS_PVT.set_org_context(l_original_org_id) ; --
715: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
716: ROLLBACK TO PO_OM_GRP_UPDATE_REQ_PO_SP;
717: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
718: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

716: ROLLBACK TO PO_OM_GRP_UPDATE_REQ_PO_SP;
717: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
718: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
719: -- Set the org context back to the original operating unit.
720: PO_MOAC_UTILS_PVT.set_org_context(l_original_org_id) ; --
721: WHEN OTHERS THEN
722: ROLLBACK TO PO_OM_GRP_UPDATE_REQ_PO_SP;
723: PO_DEBUG.handle_unexp_error ( p_pkg_name => g_pkg_name,
724: p_proc_name => l_api_name,

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

725: p_progress => l_progress );
726: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
727: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
728: -- Set the org context back to the original operating unit.
729: PO_MOAC_UTILS_PVT.set_org_context(l_original_org_id) ; --
730:
731: END update_req_po;
732:
733: -------------------------------------------------------------------------------

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

806: l_doc_type PO_DOCUMENT_TYPES.DOCUMENT_TYPE_CODE%TYPE;
807: l_doc_subtype PO_DOCUMENT_TYPES.DOCUMENT_SUBTYPE%TYPE;
808:
809: -- Bug 3248723 START
810: l_original_org_id NUMBER := PO_MOAC_UTILS_PVT.get_current_org_id ; --
811: l_approved_date PO_LINE_LOCATIONS_ALL.approved_date%TYPE;
812: l_chg PO_CHANGES_REC_TYPE;
813: -- Bug 3248723 END
814: l_document_org_id PO_HEADERS.ORG_ID%TYPE; -- Bug 3362534

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

894: -- Bug 3248723 END
895: l_progress := '035';
896:
897: -- Bug 3362534 Set the org context to the operating unit of the document.
898: PO_MOAC_UTILS_PVT.set_org_context(l_document_org_id) ; --
899:
900: PO_Document_Control_GRP.control_document
901: (p_api_version => 1.0,
902: p_init_msg_list => FND_API.G_FALSE,

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

1031:
1032: x_return_status := FND_API.G_RET_STS_SUCCESS;
1033:
1034: -- Set the org context back to the original operating unit.
1035: PO_MOAC_UTILS_PVT.set_org_context(l_original_org_id) ; --
1036:
1037: EXCEPTION
1038: WHEN FND_API.G_EXC_ERROR THEN
1039: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);

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

1038: WHEN FND_API.G_EXC_ERROR THEN
1039: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1040: x_return_status := FND_API.G_RET_STS_ERROR;
1041: -- Set the org context back to the original operating unit.
1042: PO_MOAC_UTILS_PVT.set_org_context(l_original_org_id) ; --
1043: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1044: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1045: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1046: -- Set the org context back to the original operating unit.

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

1043: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1044: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1045: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1046: -- Set the org context back to the original operating unit.
1047: PO_MOAC_UTILS_PVT.set_org_context(l_original_org_id) ; --
1048: WHEN OTHERS THEN
1049: PO_DEBUG.handle_unexp_error ( p_pkg_name => g_pkg_name,
1050: p_proc_name => l_api_name,
1051: p_progress => l_progress );

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

1051: p_progress => l_progress );
1052: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1053: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1054: -- Set the org context back to the original operating unit.
1055: PO_MOAC_UTILS_PVT.set_org_context(l_original_org_id) ; --
1056:
1057: END cancel_req_po;
1058:
1059: -- Bug 3248723 START

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

1106:
1107: l_progress := '010';
1108:
1109: -- Set Org Context to that of Document
1110: PO_MOAC_UTILS_PVT.set_org_context(l_document_org_id) ; --
1111:
1112: -- If the PO was in Approved status before the change, then perform
1113: -- submission checks and launch the PO Approval workflow to re-approve
1114: -- the PO after making the changes.