eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CLN_RN_UTILS dependencies on FND_TIMEZONES

Line 29: l_db_timezone := FND_TIMEZONES.GET_SERVER_TIMEZONE_CODE;

25: IF (l_Debug_Level <= 1) THEN
26: cln_debug_pub.Add('Date Entered by the user -->'||p_input_date,1);
27: END IF;
28: -- get the timezone of the db server
29: l_db_timezone := FND_TIMEZONES.GET_SERVER_TIMEZONE_CODE;
30: IF (l_Debug_Level <= 1) THEN
31: cln_debug_pub.Add('TimeZone of the DB server -->'||l_db_timezone,1);
32: END IF;
33: l_rn_timezone := fnd_profile.value('CLN_RN_TIMEZONE');

Line 41: x_utc_date := FND_TIMEZONES_PVT.adjust_datetime(p_input_date,l_db_timezone,l_rn_timezone);

37: IF (l_Debug_Level <= 1) THEN
38: cln_debug_pub.Add('Calling function to convert the datetime to UTC',1);
39: END IF;
40: -- this function converts the datetime from the user entered/db timezone to UTC
41: x_utc_date := FND_TIMEZONES_PVT.adjust_datetime(p_input_date,l_db_timezone,l_rn_timezone);
42: IF (l_Debug_Level <= 1) THEN
43: cln_debug_pub.Add('Date in UTC format -->'||x_utc_date,1);
44: END IF;
45: IF (l_Debug_Level <= 2) THEN

Line 219: l_db_timezone := FND_TIMEZONES.GET_SERVER_TIMEZONE_CODE;

215: IF (l_Debug_Level <= 1) THEN
216: cln_debug_pub.Add('TimeZone of the UTC '||l_rn_timezone,1);
217: END IF;
218: -- get the timezone of the db server
219: l_db_timezone := FND_TIMEZONES.GET_SERVER_TIMEZONE_CODE;
220: IF (l_Debug_Level <= 1) THEN
221: cln_debug_pub.Add('TimeZone of the DB server '||l_db_timezone,1);
222: END IF;
223: IF (l_Debug_Level <= 1) THEN

Line 235: x_db_date := FND_TIMEZONES_PVT.adjust_datetime(l_utc_datetime,l_rn_timezone,l_db_timezone);

231: IF (l_Debug_Level <= 1) THEN
232: cln_debug_pub.Add('Date After Formatting (Date)'||l_utc_datetime,1);
233: END IF;
234: -- this function converts the datetime from the user entered/db timezone to UTC
235: x_db_date := FND_TIMEZONES_PVT.adjust_datetime(l_utc_datetime,l_rn_timezone,l_db_timezone);
236: IF (l_Debug_Level <= 1) THEN
237: cln_debug_pub.Add('Date after conversion '||x_db_date,1);
238: END IF;
239: ELSE

Line 1504: l_db_timezone := FND_TIMEZONES.GET_SERVER_TIMEZONE_CODE;

1500: IF (l_Debug_Level <= 1) THEN
1501: cln_debug_pub.Add('TimeZone of the UTC '||l_rn_timezone,1);
1502: END IF;
1503: -- get the timezone of the db server
1504: l_db_timezone := FND_TIMEZONES.GET_SERVER_TIMEZONE_CODE;
1505: IF (l_Debug_Level <= 1) THEN
1506: cln_debug_pub.Add('TimeZone of the DB server '||l_db_timezone,1);
1507: END IF;
1508: IF (l_Debug_Level <= 1) THEN

Line 1520: x_db_date := FND_TIMEZONES_PVT.adjust_datetime(l_utc_datetime,l_rn_timezone,l_db_timezone);

1516: IF (l_Debug_Level <= 1) THEN
1517: cln_debug_pub.Add('Date After Formatting (Date)'||l_utc_datetime,1);
1518: END IF;
1519: -- this function converts the datetime from the user entered/db timezone to UTC
1520: x_db_date := FND_TIMEZONES_PVT.adjust_datetime(l_utc_datetime,l_rn_timezone,l_db_timezone);
1521: IF (l_Debug_Level <= 1) THEN
1522: cln_debug_pub.Add('Date after conversion '||x_db_date,1);
1523: END IF;
1524: ELSE