DBA Data[Home] [Help]

APPS.FLM_TIMEZONE dependencies on FND_MSG_PUB

Line 94: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN

90: g_init := TRUE;
91:
92: EXCEPTION
93: WHEN OTHERS THEN
94: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
95: fnd_msg_pub.add_exc_msg(g_pkg_name, 'Init Timezone');
96: END IF;
97: END init_timezone;
98:

Line 95: fnd_msg_pub.add_exc_msg(g_pkg_name, 'Init Timezone');

91:
92: EXCEPTION
93: WHEN OTHERS THEN
94: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
95: fnd_msg_pub.add_exc_msg(g_pkg_name, 'Init Timezone');
96: END IF;
97: END init_timezone;
98:
99: /*fix bug#3827600

Line 134: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN

130:
131: RETURN l_calendar_date;
132: EXCEPTION
133: WHEN e_not_init THEN
134: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
135: fnd_msg_pub.add_exc_msg(g_pkg_name, 'FLM Timezone is not initialized');
136: END IF;
137: RETURN Trunc(p_server_date);
138: WHEN OTHERS THEN

Line 135: fnd_msg_pub.add_exc_msg(g_pkg_name, 'FLM Timezone is not initialized');

131: RETURN l_calendar_date;
132: EXCEPTION
133: WHEN e_not_init THEN
134: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
135: fnd_msg_pub.add_exc_msg(g_pkg_name, 'FLM Timezone is not initialized');
136: END IF;
137: RETURN Trunc(p_server_date);
138: WHEN OTHERS THEN
139: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN

Line 139: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN

135: fnd_msg_pub.add_exc_msg(g_pkg_name, 'FLM Timezone is not initialized');
136: END IF;
137: RETURN Trunc(p_server_date);
138: WHEN OTHERS THEN
139: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
140: fnd_msg_pub.add_exc_msg(g_pkg_name, 'Convert server to CALENDAR Date');
141: END IF;
142: RETURN Trunc(p_server_date);
143: END server_to_calendar;

Line 140: fnd_msg_pub.add_exc_msg(g_pkg_name, 'Convert server to CALENDAR Date');

136: END IF;
137: RETURN Trunc(p_server_date);
138: WHEN OTHERS THEN
139: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
140: fnd_msg_pub.add_exc_msg(g_pkg_name, 'Convert server to CALENDAR Date');
141: END IF;
142: RETURN Trunc(p_server_date);
143: END server_to_calendar;
144:

Line 168: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN

164:
165: RETURN server_to_calendar(l_server_date);
166: EXCEPTION
167: WHEN e_not_init THEN
168: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
169: fnd_msg_pub.add_exc_msg(g_pkg_name, 'FLM Timezone is not initialized');
170: END IF;
171: RETURN Trunc(p_client_date);
172: WHEN OTHERS THEN

Line 169: fnd_msg_pub.add_exc_msg(g_pkg_name, 'FLM Timezone is not initialized');

165: RETURN server_to_calendar(l_server_date);
166: EXCEPTION
167: WHEN e_not_init THEN
168: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
169: fnd_msg_pub.add_exc_msg(g_pkg_name, 'FLM Timezone is not initialized');
170: END IF;
171: RETURN Trunc(p_client_date);
172: WHEN OTHERS THEN
173: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN

Line 173: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN

169: fnd_msg_pub.add_exc_msg(g_pkg_name, 'FLM Timezone is not initialized');
170: END IF;
171: RETURN Trunc(p_client_date);
172: WHEN OTHERS THEN
173: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
174: fnd_msg_pub.add_exc_msg(g_pkg_name, 'Convert client to CALENDAR date');
175: END IF;
176: RETURN Trunc(p_client_date);
177: END client_to_calendar;

Line 174: fnd_msg_pub.add_exc_msg(g_pkg_name, 'Convert client to CALENDAR date');

170: END IF;
171: RETURN Trunc(p_client_date);
172: WHEN OTHERS THEN
173: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
174: fnd_msg_pub.add_exc_msg(g_pkg_name, 'Convert client to CALENDAR date');
175: END IF;
176: RETURN Trunc(p_client_date);
177: END client_to_calendar;
178:

Line 228: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN

224:
225: RETURN l_server_date;
226: EXCEPTION
227: WHEN e_not_init THEN
228: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
229: fnd_msg_pub.add_exc_msg(g_pkg_name, 'FLM Timezone is not initialized');
230: END IF;
231: RETURN Trunc(p_calendar_date);
232: WHEN OTHERS THEN

Line 229: fnd_msg_pub.add_exc_msg(g_pkg_name, 'FLM Timezone is not initialized');

225: RETURN l_server_date;
226: EXCEPTION
227: WHEN e_not_init THEN
228: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
229: fnd_msg_pub.add_exc_msg(g_pkg_name, 'FLM Timezone is not initialized');
230: END IF;
231: RETURN Trunc(p_calendar_date);
232: WHEN OTHERS THEN
233: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN

Line 233: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN

229: fnd_msg_pub.add_exc_msg(g_pkg_name, 'FLM Timezone is not initialized');
230: END IF;
231: RETURN Trunc(p_calendar_date);
232: WHEN OTHERS THEN
233: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
234: fnd_msg_pub.add_exc_msg(g_pkg_name, 'Convert CALENDAR to server date');
235: END IF;
236: RETURN Trunc(p_calendar_date);
237: END calendar_to_server;

Line 234: fnd_msg_pub.add_exc_msg(g_pkg_name, 'Convert CALENDAR to server date');

230: END IF;
231: RETURN Trunc(p_calendar_date);
232: WHEN OTHERS THEN
233: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
234: fnd_msg_pub.add_exc_msg(g_pkg_name, 'Convert CALENDAR to server date');
235: END IF;
236: RETURN Trunc(p_calendar_date);
237: END calendar_to_server;
238:

Line 258: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN

254:
255: RETURN l_client_date;
256: EXCEPTION
257: WHEN OTHERS THEN
258: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
259: fnd_msg_pub.add_exc_msg(g_pkg_name, 'Convert server to client date');
260: END IF;
261: RETURN p_server_date;
262: END server_to_client;

Line 259: fnd_msg_pub.add_exc_msg(g_pkg_name, 'Convert server to client date');

255: RETURN l_client_date;
256: EXCEPTION
257: WHEN OTHERS THEN
258: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
259: fnd_msg_pub.add_exc_msg(g_pkg_name, 'Convert server to client date');
260: END IF;
261: RETURN p_server_date;
262: END server_to_client;
263:

Line 283: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN

279:
280: RETURN l_server_date;
281: EXCEPTION
282: WHEN OTHERS THEN
283: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
284: fnd_msg_pub.add_exc_msg(g_pkg_name, 'Convert client to server');
285: END IF;
286: RETURN p_client_date;
287: END client_to_server;

Line 284: fnd_msg_pub.add_exc_msg(g_pkg_name, 'Convert client to server');

280: RETURN l_server_date;
281: EXCEPTION
282: WHEN OTHERS THEN
283: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
284: fnd_msg_pub.add_exc_msg(g_pkg_name, 'Convert client to server');
285: END IF;
286: RETURN p_client_date;
287: END client_to_server;
288:

Line 308: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN

304:
305: RETURN l_return_date;
306: EXCEPTION
307: WHEN OTHERS THEN
308: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
309: fnd_msg_pub.add_exc_msg(g_pkg_name, 'Get client00 in server');
310: END IF;
311: RETURN p_server_date;
312: END client00_in_server;

Line 309: fnd_msg_pub.add_exc_msg(g_pkg_name, 'Get client00 in server');

305: RETURN l_return_date;
306: EXCEPTION
307: WHEN OTHERS THEN
308: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
309: fnd_msg_pub.add_exc_msg(g_pkg_name, 'Get client00 in server');
310: END IF;
311: RETURN p_server_date;
312: END client00_in_server;
313:

Line 329: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN

325:
326: RETURN l_return_date;
327: EXCEPTION
328: WHEN OTHERS THEN
329: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
330: fnd_msg_pub.add_exc_msg(g_pkg_name, 'Get sysdate00 in server');
331: END IF;
332: RETURN trunc(sysdate);
333: END sysdate00_in_server;

Line 330: fnd_msg_pub.add_exc_msg(g_pkg_name, 'Get sysdate00 in server');

326: RETURN l_return_date;
327: EXCEPTION
328: WHEN OTHERS THEN
329: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
330: fnd_msg_pub.add_exc_msg(g_pkg_name, 'Get sysdate00 in server');
331: END IF;
332: RETURN trunc(sysdate);
333: END sysdate00_in_server;
334: