APPS.PO_MODIFY_REQUISITION_PVT dependencies on PO_MOAC_UTILS_PVT

Line 153: l_old_org_id := PO_MOAC_UTILS_PVT.get_current_org_id;

149:
150: --Get the value of current org id. We would set the
151: --org context back to this value before leaving the
152: --program.
153: l_old_org_id := PO_MOAC_UTILS_PVT.get_current_org_id;
154:
155: IF PO_LOG.d_stmt THEN
156: PO_LOG.stmt(d_module_base,d_progress,'l_old_org_id ', l_old_org_id);
157: PO_LOG.stmt(d_module_base,d_progress,'Retrieved the value of current orgId');

Line 221: po_moac_utils_pvt.set_org_context(l_old_org_id);

217: PO_LOG.stmt(d_module_base,d_progress,'Reset the org context to old value');
218: END IF;
219:
220: --Set the org context back to the original org context
221: po_moac_utils_pvt.set_org_context(l_old_org_id);
222:
223: IF PO_LOG.d_stmt THEN
224: PO_LOG.stmt(d_module_base,d_progress,'l_old_org_id',l_old_org_id);
225: END IF;

Line 239: po_moac_utils_pvt.set_org_context(l_old_org_id);

235: EXCEPTION
236: WHEN FND_API.g_exc_error THEN
237: ROLLBACK TO split_requisition_lines_PVT;
238: x_return_status := FND_API.g_ret_sts_error;
239: po_moac_utils_pvt.set_org_context(l_old_org_id);
240: IF (PO_LOG.d_exc)
241: THEN
242: PO_LOG.exc(d_module_base,d_progress, SQLCODE || SQLERRM);
243: PO_LOG.proc_end(d_module_base,'x_return_status', x_return_status);

Line 249: po_moac_utils_pvt.set_org_context(l_old_org_id);

245: PO_LOG.proc_end(d_module_base,'x_msg_data', x_msg_data );
246: END IF;
247: WHEN FND_API.g_exc_unexpected_error THEN
248: ROLLBACK TO split_requisition_lines_PVT;
249: po_moac_utils_pvt.set_org_context(l_old_org_id);
250:
251: po_message_s.sql_error(g_pkg_name, l_module, d_progress, SQLCODE, SQLERRM);
252: FND_MSG_PUB.Add;
253: FND_MESSAGE.set_encoded(encoded_message =>FND_MSG_PUB.GET());

Line 268: po_moac_utils_pvt.set_org_context(l_old_org_id);

264: PO_LOG.proc_end(d_module_base,'x_msg_data', x_msg_data );
265: END IF;
266: WHEN OTHERS THEN
267: ROLLBACK TO split_requisition_lines_PVT;
268: po_moac_utils_pvt.set_org_context(l_old_org_id);
269:
270: BEGIN
271: -- Log a debug message, add the error the the API message list.
272: po_message_s.sql_error(g_pkg_name, l_module, d_progress, SQLCODE, SQLERRM);

Line 290: po_moac_utils_pvt.set_org_context(l_old_org_id);

286: END IF;
287:
288: EXCEPTION
289: WHEN OTHERS THEN
290: po_moac_utils_pvt.set_org_context(l_old_org_id);
291: IF (PO_LOG.d_exc)
292: THEN
293: PO_LOG.exc(d_module_base,d_progress, SQLCODE || SQLERRM);
294: PO_LOG.proc_end(d_module_base,'x_return_status', x_return_status);

Line 442: po_moac_utils_pvt.set_org_context(l_current_org_id);

438:
439: --***
440: d_progress := 20;
441: --Set the org context to the org id of the parent req line.
442: po_moac_utils_pvt.set_org_context(l_current_org_id);
443:
444: IF PO_LOG.d_stmt THEN
445: PO_LOG.stmt(d_module_base,d_progress,'l_current_org_id',l_current_org_id);
446: PO_LOG.stmt(d_module_base,d_progress,'Set the org context to the organization in which Requisition was raised.');

Line 1227: po_moac_utils_pvt.set_org_context(l_old_org_id);

1223: END IF;
1224:
1225: EXCEPTION
1226: WHEN OTHERS THEN
1227: po_moac_utils_pvt.set_org_context(l_old_org_id);
1228: IF (PO_LOG.d_exc)
1229: THEN
1230: PO_LOG.exc(d_module_base,d_progress, SQLCODE || SQLERRM);
1231: PO_LOG.proc_end(d_module_base,'x_return_status', x_return_status);