133: -- ******************************************************************
134:
135:
136: -- Get the User's Session ORG_ID
137: l_user_orgid := mo_global.GET_CURRENT_ORG_ID();
138:
139: -- Get the Order's ORG_ID
140: OPEN c_ord(p_order_header_id);
141: FETCH c_ord into l_order_orgid;
153: END IF;
154:
155: -- Set the Session's ORGID to the Order's ORG_ID, before calling the Process_Order() API
156: -- i.e Set the Global Security Context to that of the original Order Creator's ORG_ID
157: mo_global.set_policy_context('S', l_order_orgid);
158:
159: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
160: IBE_UTIL.DEBUG('After ORG_ID Switch to Orders ORG_ID : '|| mo_global.GET_CURRENT_ORG_ID());
161: END IF;
156: -- i.e Set the Global Security Context to that of the original Order Creator's ORG_ID
157: mo_global.set_policy_context('S', l_order_orgid);
158:
159: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
160: IBE_UTIL.DEBUG('After ORG_ID Switch to Orders ORG_ID : '|| mo_global.GET_CURRENT_ORG_ID());
161: END IF;
162:
163: END IF; -- End of (l_order_orgid <> l_user_orgid) condition
164:
256:
257: -- Restore the Logged-In User's Security Context, if switched
258: IF l_order_orgid <> l_user_orgid THEN
259:
260: mo_global.set_policy_context('S', l_user_orgid);
261:
262: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
263: IBE_UTIL.DEBUG('Restored the ORG_ID to the Users ORG_ID: '|| mo_global.GET_CURRENT_ORG_ID());
264: END IF;
259:
260: mo_global.set_policy_context('S', l_user_orgid);
261:
262: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
263: IBE_UTIL.DEBUG('Restored the ORG_ID to the Users ORG_ID: '|| mo_global.GET_CURRENT_ORG_ID());
264: END IF;
265:
266: END IF;
267:
293:
294: -- Restore the Logged-In User's Security Context, if switched
295: IF l_order_orgid <> l_user_orgid THEN
296:
297: mo_global.set_policy_context('S', l_user_orgid);
298:
299: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
300: IBE_UTIL.DEBUG('Restored the ORG_ID to the Users ORG_ID: '|| mo_global.GET_CURRENT_ORG_ID());
301: END IF;
296:
297: mo_global.set_policy_context('S', l_user_orgid);
298:
299: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
300: IBE_UTIL.DEBUG('Restored the ORG_ID to the Users ORG_ID: '|| mo_global.GET_CURRENT_ORG_ID());
301: END IF;
302:
303: END IF;
304:
314: p_data => x_msg_data);
315: -- Restore the Logged-In User's Security Context, if switched
316: IF l_order_orgid <> l_user_orgid THEN
317:
318: mo_global.set_policy_context('S', l_user_orgid);
319:
320: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
321: IBE_UTIL.DEBUG('Restored the ORG_ID to the Users ORG_ID: '|| mo_global.GET_CURRENT_ORG_ID());
322: END IF;
317:
318: mo_global.set_policy_context('S', l_user_orgid);
319:
320: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
321: IBE_UTIL.DEBUG('Restored the ORG_ID to the Users ORG_ID: '|| mo_global.GET_CURRENT_ORG_ID());
322: END IF;
323:
324: END IF;
325:
343:
344: -- Restore the Logged-In User's Security Context, if switched
345: IF l_order_orgid <> l_user_orgid THEN
346:
347: mo_global.set_policy_context('S', l_user_orgid);
348:
349: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
350: IBE_UTIL.DEBUG('Restored the ORG_ID to the Users ORG_ID: '|| mo_global.GET_CURRENT_ORG_ID());
351: END IF;
346:
347: mo_global.set_policy_context('S', l_user_orgid);
348:
349: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
350: IBE_UTIL.DEBUG('Restored the ORG_ID to the Users ORG_ID: '|| mo_global.GET_CURRENT_ORG_ID());
351: END IF;
352:
353: END IF;
354: