APPS.PO_MODIFY_REQUISITION_PVT dependencies on PO_MOAC_UTILS_PVT

Line 97: l_old_org_id := PO_MOAC_UTILS_PVT.get_current_org_id;

93:
94: --Get the value of current org id. We would set the
95: --org context back to this value before leaving the
96: --program.
97: l_old_org_id := PO_MOAC_UTILS_PVT.get_current_org_id;
98:
99: IF PO_LOG.d_stmt THEN
100: PO_LOG.stmt(d_module_base,d_progress,'l_old_org_id ', l_old_org_id);
101: PO_LOG.stmt(d_module_base,d_progress,'Retrieved the value of current orgId');

Line 165: po_moac_utils_pvt.set_org_context(l_old_org_id);

161: PO_LOG.stmt(d_module_base,d_progress,'Reset the org context to old value');
162: END IF;
163:
164: --Set the org context back to the original org context
165: po_moac_utils_pvt.set_org_context(l_old_org_id);
166:
167: IF PO_LOG.d_stmt THEN
168: PO_LOG.stmt(d_module_base,d_progress,'l_old_org_id',l_old_org_id);
169: END IF;

Line 183: po_moac_utils_pvt.set_org_context(l_old_org_id);

179: EXCEPTION
180: WHEN FND_API.g_exc_error THEN
181: ROLLBACK TO split_requisition_lines_PVT;
182: x_return_status := FND_API.g_ret_sts_error;
183: po_moac_utils_pvt.set_org_context(l_old_org_id);
184: IF (PO_LOG.d_exc)
185: THEN
186: PO_LOG.exc(d_module_base,d_progress, SQLCODE || SQLERRM);
187: PO_LOG.proc_end(d_module_base,'x_return_status', x_return_status);

Line 193: po_moac_utils_pvt.set_org_context(l_old_org_id);

189: PO_LOG.proc_end(d_module_base,'x_msg_data', x_msg_data );
190: END IF;
191: WHEN FND_API.g_exc_unexpected_error THEN
192: ROLLBACK TO split_requisition_lines_PVT;
193: po_moac_utils_pvt.set_org_context(l_old_org_id);
194:
195: po_message_s.sql_error(g_pkg_name, l_module, d_progress, SQLCODE, SQLERRM);
196: FND_MSG_PUB.Add;
197: FND_MESSAGE.set_encoded(encoded_message =>FND_MSG_PUB.GET());

Line 212: po_moac_utils_pvt.set_org_context(l_old_org_id);

208: PO_LOG.proc_end(d_module_base,'x_msg_data', x_msg_data );
209: END IF;
210: WHEN OTHERS THEN
211: ROLLBACK TO split_requisition_lines_PVT;
212: po_moac_utils_pvt.set_org_context(l_old_org_id);
213:
214: BEGIN
215: -- Log a debug message, add the error the the API message list.
216: po_message_s.sql_error(g_pkg_name, l_module, d_progress, SQLCODE, SQLERRM);

Line 234: po_moac_utils_pvt.set_org_context(l_old_org_id);

230: END IF;
231:
232: EXCEPTION
233: WHEN OTHERS THEN
234: po_moac_utils_pvt.set_org_context(l_old_org_id);
235: IF (PO_LOG.d_exc)
236: THEN
237: PO_LOG.exc(d_module_base,d_progress, SQLCODE || SQLERRM);
238: PO_LOG.proc_end(d_module_base,'x_return_status', x_return_status);

Line 337: po_moac_utils_pvt.set_org_context(l_current_org_id);

333: END IF;
334:
335: d_progress := 20;
336: --Set the org context to the org id of the parent req line.
337: po_moac_utils_pvt.set_org_context(l_current_org_id);
338:
339: IF PO_LOG.d_stmt THEN
340: PO_LOG.stmt(d_module_base,d_progress,'l_current_org_id',l_current_org_id);
341: PO_LOG.stmt(d_module_base,d_progress,'Set the org context to the organization in which Requisition was raised.');

Line 786: po_moac_utils_pvt.set_org_context(l_old_org_id);

782: END IF;
783:
784: EXCEPTION
785: WHEN OTHERS THEN
786: po_moac_utils_pvt.set_org_context(l_old_org_id);
787: IF (PO_LOG.d_exc)
788: THEN
789: PO_LOG.exc(d_module_base,d_progress, SQLCODE || SQLERRM);
790: PO_LOG.proc_end(d_module_base,'x_return_status', x_return_status);