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:
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
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
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
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;
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:
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
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
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;
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:
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
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
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;
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:
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;
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:
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;
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:
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;
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:
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;
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: