DBA Data[Home] [Help]

APPS.PO_MOAC_UTILS_PVT dependencies on PO_MOAC_UTILS_PVT

Line 1: PACKAGE BODY PO_MOAC_UTILS_PVT AS

1: PACKAGE BODY PO_MOAC_UTILS_PVT AS
2: /*$Header: POXVMOUB.pls 120.8.12010000.2 2008/08/04 08:34:07 rramasam ship $*/
3:
4: -----------------------------------------------------------------------------
5: -- Declare private package variables.

Line 8: := 'PO_MOAC_UTILS_PVT';

4: -----------------------------------------------------------------------------
5: -- Declare private package variables.
6: -----------------------------------------------------------------------------
7: g_pkg_name CONSTANT VARCHAR2(30)
8: := 'PO_MOAC_UTILS_PVT';
9:
10: D_PACKAGE_BASE CONSTANT VARCHAR2(100) := PO_LOG.get_package_base(g_pkg_name);
11:
12:

Line 68: PO_MOAC_UTILS_PVT.initialize;

64:
65: l_is_mo_init_done := MO_GLOBAL.is_mo_init_done;
66:
67: IF (l_is_mo_init_done <> 'Y') THEN
68: PO_MOAC_UTILS_PVT.initialize;
69: END IF;
70:
71: l_progress := '020';
72:

Line 79: l_current_org_id := PO_MOAC_UTILS_PVT.get_current_org_id;

75: l_access_mode := MO_GLOBAL.get_access_mode;
76:
77: IF ( l_access_mode = 'S') THEN
78:
79: l_current_org_id := PO_MOAC_UTILS_PVT.get_current_org_id;
80:
81: -- If access mode is already single, then we need to call
82: -- set_policy_context only if the org is different from current org
83: IF ( l_current_org_id IS NULL OR

Line 87: PO_MOAC_UTILS_PVT.set_policy_context('S', p_org_id);

83: IF ( l_current_org_id IS NULL OR
84: l_current_org_id <> p_org_id) THEN
85:
86: l_progress := '030';
87: PO_MOAC_UTILS_PVT.set_policy_context('S', p_org_id);
88: END IF;
89: ELSE
90: l_progress := '040';
91: PO_MOAC_UTILS_PVT.set_policy_context('S', p_org_id);

Line 91: PO_MOAC_UTILS_PVT.set_policy_context('S', p_org_id);

87: PO_MOAC_UTILS_PVT.set_policy_context('S', p_org_id);
88: END IF;
89: ELSE
90: l_progress := '040';
91: PO_MOAC_UTILS_PVT.set_policy_context('S', p_org_id);
92:
93: END IF;
94:
95: ELSE

Line 97: l_ou_count := PO_MOAC_UTILS_PVT.get_ou_count;

93: END IF;
94:
95: ELSE
96:
97: l_ou_count := PO_MOAC_UTILS_PVT.get_ou_count;
98:
99: IF (l_ou_count > 1) THEN
100: PO_MOAC_UTILS_PVT.set_policy_context ('M', NULL);
101: END IF;

Line 100: PO_MOAC_UTILS_PVT.set_policy_context ('M', NULL);

96:
97: l_ou_count := PO_MOAC_UTILS_PVT.get_ou_count;
98:
99: IF (l_ou_count > 1) THEN
100: PO_MOAC_UTILS_PVT.set_policy_context ('M', NULL);
101: END IF;
102:
103: END IF;
104:

Line 109: po_message_s.sql_error('po_moac_utils_pvt.set_org_context', l_progress, sqlcode);

105:
106: --
107: EXCEPTION
108: WHEN OTHERS THEN
109: po_message_s.sql_error('po_moac_utils_pvt.set_org_context', l_progress, sqlcode);
110: RAISE;
111: END set_org_context;
112:
113: -------------------------------------------------------------------------------

Line 160: po_message_s.sql_error('po_moac_utils_pvt.mo_init', l_progress, sqlcode);

156: END IF;
157: SET_ORG_CONTEXT(l_org_id);
158: EXCEPTION
159: WHEN OTHERS THEN
160: po_message_s.sql_error('po_moac_utils_pvt.mo_init', l_progress, sqlcode);
161: RAISE;
162: END MO_INIT;
163:
164: -------------------------------------------------------------------------------

Line 203: po_message_s.sql_error('po_moac_utils_pvt.get_current_org_id', l_progress, sqlcode);

199: l_progress := '010';
200: RETURN MO_GLOBAL.GET_CURRENT_ORG_ID();
201: EXCEPTION
202: WHEN OTHERS THEN
203: po_message_s.sql_error('po_moac_utils_pvt.get_current_org_id', l_progress, sqlcode);
204: RAISE;
205: END GET_CURRENT_ORG_ID;
206:
207: -------------------------------------------------------------------------------

Line 275: po_message_s.sql_error('po_moac_utils_pvt.get_ou_name', l_progress, sqlcode);

271: RETURN l_ou_name;
272:
273: EXCEPTION
274: WHEN OTHERS THEN
275: po_message_s.sql_error('po_moac_utils_pvt.get_ou_name', l_progress, sqlcode);
276: RAISE;
277: END GET_OU_NAME;
278:
279: -------------------------------------------------------------------------------

Line 315: po_message_s.sql_error('po_moac_utils_pvt.get_ou_count', l_progress, sqlcode);

311: l_progress := '010';
312: RETURN MO_GLOBAL.GET_OU_COUNT ();
313: EXCEPTION
314: WHEN OTHERS THEN
315: po_message_s.sql_error('po_moac_utils_pvt.get_ou_count', l_progress, sqlcode);
316: RAISE;
317: END GET_OU_COUNT;
318:
319: -------------------------------------------------------------------------------

Line 364: po_message_s.sql_error('po_moac_utils_pvt.get_default_ou', l_progress, sqlcode);

360: x_ou_count
361: );
362: EXCEPTION
363: WHEN OTHERS THEN
364: po_message_s.sql_error('po_moac_utils_pvt.get_default_ou', l_progress, sqlcode);
365: RAISE;
366: END GET_DEFAULT_OU;
367:
368: -------------------------------------------------------------------------------

Line 413: po_message_s.sql_error('po_moac_utils_pvt.get_valid_org', l_progress, sqlcode);

409: l_progress := '010';
410: RETURN MO_GLOBAL.GET_VALID_ORG(p_org_id);
411: EXCEPTION
412: WHEN OTHERS THEN
413: po_message_s.sql_error('po_moac_utils_pvt.get_valid_org', l_progress, sqlcode);
414: RAISE;
415: END GET_VALID_ORG;
416:
417: -------------------------------------------------------------------------------

Line 451: po_message_s.sql_error('po_moac_utils_pvt.initialize', l_progress, sqlcode);

447: l_progress := '010';
448: MO_GLOBAL.INIT('PO');
449: EXCEPTION
450: WHEN OTHERS THEN
451: po_message_s.sql_error('po_moac_utils_pvt.initialize', l_progress, sqlcode);
452: RAISE;
453: END INITIALIZE;
454:
455: -------------------------------------------------------------------------------

Line 498: po_message_s.sql_error('po_moac_utils_pvt.set_policy_context', l_progress, sqlcode);

494: l_progress := '010';
495: MO_GLOBAL.SET_POLICY_CONTEXT(p_access_mode,p_org_id);
496: EXCEPTION
497: WHEN OTHERS THEN
498: po_message_s.sql_error('po_moac_utils_pvt.set_policy_context', l_progress, sqlcode);
499: RAISE;
500: END SET_POLICY_CONTEXT;
501:
502: -------------------------------------------------------------------------------

Line 550: po_message_s.sql_error('po_moac_utils_pvt.check_access', l_progress, sqlcode);

546: END IF;
547: RETURN l_retval;*/
548: EXCEPTION
549: WHEN OTHERS THEN
550: po_message_s.sql_error('po_moac_utils_pvt.check_access', l_progress, sqlcode);
551: RAISE;
552: END CHECK_ACCESS;
553:
554: -------------------------------------------------------------------------------

Line 649: po_message_s.sql_error('po_moac_utils_pvt.set_request_context', l_progress, sqlcode);

645: fnd_request.set_org_id(p_org_id);
646:
647: EXCEPTION
648: WHEN OTHERS THEN
649: po_message_s.sql_error('po_moac_utils_pvt.set_request_context', l_progress, sqlcode);
650: RAISE;
651: END;
652:
653:

Line 860: END PO_MOAC_UTILS_PVT;

856: END IF;
857: RAISE;
858: END validate_orgid_pub_api;
859: --
860: END PO_MOAC_UTILS_PVT;