DBA Data[Home] [Help]

APPS.XLA_ENVIRONMENT_PKG dependencies on XLA_ENVIRONMENT_PKG

Line 1: PACKAGE BODY xla_environment_pkg AS

1: PACKAGE BODY xla_environment_pkg AS
2: /* $Header: xlacmenv.pkb 120.5 2005/05/27 07:02:57 ksvenkat ship $ */
3: /*======================================================================+
4: | Copyright (c) 2000-2002 Oracle Corporation |
5: | Redwood Shores, CA, USA |

Line 9: | xla_environment_pkg |

5: | Redwood Shores, CA, USA |
6: | All rights reserved. |
7: +=======================================================================+
8: | PACKAGE NAME |
9: | xla_environment_pkg |
10: | |
11: | DESCRIPTION |
12: | XLA Environment Package |
13: | |

Line 59: xla_utility_pkg.trace('> Package xla_environment_pkg .get_login_info' , 20);

55:
56: IS
57:
58: BEGIN
59: xla_utility_pkg.trace('> Package xla_environment_pkg .get_login_info' , 20);
60:
61: g_Login_Id := fnd_global.login_id;
62: g_Prog_Appl_Id := fnd_global.prog_appl_id;
63: g_Prog_Id := fnd_global.conc_program_id;

Line 73: xla_utility_pkg.trace('< Package xla_environment_pkg .login_info' , 20);

69: xla_utility_pkg.trace('Prog id = '||TO_CHAR(g_Prog_Id) , 30);
70: xla_utility_pkg.trace('Request id = '||TO_CHAR(g_Req_Id) , 30);
71: xla_utility_pkg.trace('User id = '||TO_CHAR(g_Usr_Id) , 30);
72:
73: xla_utility_pkg.trace('< Package xla_environment_pkg .login_info' , 20);
74:
75: EXCEPTION
76: WHEN xla_exceptions_pkg.application_exception THEN
77: RAISE;

Line 80: (p_location => 'xla_environment_pkg .get_login_info');

76: WHEN xla_exceptions_pkg.application_exception THEN
77: RAISE;
78: WHEN OTHERS THEN
79: xla_exceptions_pkg.raise_message
80: (p_location => 'xla_environment_pkg .get_login_info');
81: END set_login_info;
82:
83:
84: /*======================================================================+

Line 98: xla_utility_pkg.trace('> Package xla_environment_pkg .set_release_info' , 20);

94:
95: IS
96:
97: BEGIN
98: xla_utility_pkg.trace('> Package xla_environment_pkg .set_release_info' , 20);
99:
100: SELECT SUBSTR(release_name,1,4)
101: INTO g_release_name
102: FROM fnd_product_groups

Line 107: xla_utility_pkg.trace('> Package xla_environment_pkg .set_release_info' , 20);

103: ;
104:
105: xla_utility_pkg.trace('Release = '||g_release_name , 30);
106:
107: xla_utility_pkg.trace('> Package xla_environment_pkg .set_release_info' , 20);
108:
109: EXCEPTION
110: WHEN xla_exceptions_pkg.application_exception THEN
111: RAISE;

Line 114: (p_location => 'xla_environment_pkg .set_release_info');

110: WHEN xla_exceptions_pkg.application_exception THEN
111: RAISE;
112: WHEN OTHERS THEN
113: xla_exceptions_pkg.raise_message
114: (p_location => 'xla_environment_pkg .set_release_info');
115: END set_release_info;
116:
117:
118: /*======================================================================+

Line 134: xla_utility_pkg.trace('> Package xla_environment_pkg .get_mapps_info' , 10);

130:
131: l_count INTEGER;
132:
133: BEGIN
134: xla_utility_pkg.trace('> Package xla_environment_pkg .get_mapps_info' , 10);
135:
136: SELECT COUNT(*)
137: INTO l_count
138: FROM fnd_data_groups

Line 150: xla_utility_pkg.trace('< Package xla_environment_pkg .get_mapps_info' , 10);

146: ELSE
147: g_mapps_flag := FALSE;
148: END IF;
149:
150: xla_utility_pkg.trace('< Package xla_environment_pkg .get_mapps_info' , 10);
151:
152: EXCEPTION
153: WHEN xla_exceptions_pkg.application_exception THEN
154: RAISE;

Line 157: (p_location => 'xla_environment_pkg .get_login_info');

153: WHEN xla_exceptions_pkg.application_exception THEN
154: RAISE;
155: WHEN OTHERS THEN
156: xla_exceptions_pkg.raise_message
157: (p_location => 'xla_environment_pkg .get_login_info');
158: END set_mapps_info;
159:
160:
161: /*======================================================================+

Line 175: xla_utility_pkg.trace('> Package xla_environment_pkg .set_session_info' , 10);

171:
172: IS
173:
174: BEGIN
175: xla_utility_pkg.trace('> Package xla_environment_pkg .set_session_info' , 10);
176:
177: SELECT pr.spid
178: ,se.sid
179: ,se.program

Line 192: xla_utility_pkg.trace('< Package xla_environment_pkg .set_session_info' , 10);

188: AND se.paddr = pr.addr;
189:
190: g_session_name := dbms_pipe.unique_session_name;
191:
192: xla_utility_pkg.trace('< Package xla_environment_pkg .set_session_info' , 10);
193:
194: EXCEPTION
195:
196: WHEN xla_exceptions_pkg.application_exception THEN

Line 200: (p_location => 'xla_environment_pkg .set_session_info');

196: WHEN xla_exceptions_pkg.application_exception THEN
197: RAISE;
198: WHEN OTHERS THEN
199: xla_exceptions_pkg.raise_message
200: (p_location => 'xla_environment_pkg .set_session_info');
201: END set_session_info;
202:
203:
204:

Line 245: xla_utility_pkg.trace('> Package xla_environment_pkg .Refresh' , 20);

241:
242: IS
243:
244: BEGIN
245: xla_utility_pkg.trace('> Package xla_environment_pkg .Refresh' , 20);
246:
247: IF NOT g_Init_flag THEN
248: set_login_info;
249: set_release_info;

Line 258: xla_utility_pkg.trace('< Package xla_environment_pkg .Refresh' , 20);

254: END IF;
255:
256: g_Init_flag := TRUE;
257:
258: xla_utility_pkg.trace('< Package xla_environment_pkg .Refresh' , 20);
259:
260: EXCEPTION
261: WHEN xla_exceptions_pkg.application_exception THEN
262: RAISE;

Line 265: (p_location => 'xla_environment_pkg .get_login_info');

261: WHEN xla_exceptions_pkg.application_exception THEN
262: RAISE;
263: WHEN OTHERS THEN
264: xla_exceptions_pkg.raise_message
265: (p_location => 'xla_environment_pkg .get_login_info');
266: END Refresh;
267:
268:
269: /*======================================================================+

Line 296: END xla_environment_pkg;

292:
293: BEGIN
294: refresh;
295:
296: END xla_environment_pkg;