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.CSM_UTIL_PKG dependencies on FND_PROFILE

Line 36: g_debug_level := FND_PROFILE.VALUE( 'JTM_DEBUG_LEVEL');

32: BEGIN
33: /*** has debug mode already been retrieved ***/
34: IF g_debug_level IS NULL THEN
35: /*** no -> get it from profile ***/
36: g_debug_level := FND_PROFILE.VALUE( 'JTM_DEBUG_LEVEL');
37: END IF;
38: RETURN g_debug_level;
39: END Get_Debug_Level;
40:

Line 252: v_client_timezone := FND_PROFILE.VALUE_SPECIFIC('HZ_CLIENT_TIMEZONE',p_userid,NULL,170);

248: v_server_timezone varchar2(100);
249: client_time date;
250:
251: begin
252: v_client_timezone := FND_PROFILE.VALUE_SPECIFIC('HZ_CLIENT_TIMEZONE',p_userid,NULL,170);
253:
254:
255: v_server_timezone := FND_PROFILE.VALUE_SPECIFIC('HZ_SERVER_TIMEZONE',NULL,NULL,170);
256:

Line 255: v_server_timezone := FND_PROFILE.VALUE_SPECIFIC('HZ_SERVER_TIMEZONE',NULL,NULL,170);

251: begin
252: v_client_timezone := FND_PROFILE.VALUE_SPECIFIC('HZ_CLIENT_TIMEZONE',p_userid,NULL,170);
253:
254:
255: v_server_timezone := FND_PROFILE.VALUE_SPECIFIC('HZ_SERVER_TIMEZONE',NULL,NULL,170);
256:
257:
258: if v_client_timezone is null
259: or v_server_timezone is null

Line 324: v_client_timezone := FND_PROFILE.VALUE_SPECIFIC('HZ_CLIENT_TIMEZONE',l_user_id,NULL,170);

320: OPEN c_user_id(p_user_name);
321: FETCH c_user_id INTO l_user_id;
322: CLOSE c_user_id;
323:
324: v_client_timezone := FND_PROFILE.VALUE_SPECIFIC('HZ_CLIENT_TIMEZONE',l_user_id,NULL,170);
325:
326:
327: v_server_timezone := FND_PROFILE.VALUE_SPECIFIC('HZ_SERVER_TIMEZONE',NULL,NULL,170);
328:

Line 327: v_server_timezone := FND_PROFILE.VALUE_SPECIFIC('HZ_SERVER_TIMEZONE',NULL,NULL,170);

323:
324: v_client_timezone := FND_PROFILE.VALUE_SPECIFIC('HZ_CLIENT_TIMEZONE',l_user_id,NULL,170);
325:
326:
327: v_server_timezone := FND_PROFILE.VALUE_SPECIFIC('HZ_SERVER_TIMEZONE',NULL,NULL,170);
328:
329:
330: if v_client_timezone is null
331: or v_server_timezone is null

Line 1773: l_option_value := fnd_profile.value_specific('JTM_MOB_APPS_ENABLED', null,

1769: OPEN l_get_resp_id;
1770: FETCH l_get_resp_id INTO l_application_id, l_responsibility_id;
1771: CLOSE l_get_resp_id;
1772:
1773: l_option_value := fnd_profile.value_specific('JTM_MOB_APPS_ENABLED', null,
1774: l_responsibility_id, l_application_id);
1775:
1776: -- CSM_UTIL_PKG.LOG('YL: IS_FIELD_SERVICE_PALM_ENABLED = ' || l_option_value);
1777:

Line 2211: l_cur_val:=upper(fnd_profile.value('JTF_TASK_ENABLE_AUDIT'));

2207: l_cur_val VARCHAR2(100);
2208: x boolean;
2209: BEGIN
2210: IF p_new_val='N' THEN
2211: l_cur_val:=upper(fnd_profile.value('JTF_TASK_ENABLE_AUDIT'));
2212: IF NVL(l_cur_val,'Y')='Y' THEN
2213: x:=fnd_profile.save('JTF_TASK_ENABLE_AUDIT','N','SITE');
2214: log('Turning Off Audit as Current Audit Profile Value:'||l_cur_val,'CSM_UTIL_PKG.set_task_audit');
2215: END IF;

Line 2213: x:=fnd_profile.save('JTF_TASK_ENABLE_AUDIT','N','SITE');

2209: BEGIN
2210: IF p_new_val='N' THEN
2211: l_cur_val:=upper(fnd_profile.value('JTF_TASK_ENABLE_AUDIT'));
2212: IF NVL(l_cur_val,'Y')='Y' THEN
2213: x:=fnd_profile.save('JTF_TASK_ENABLE_AUDIT','N','SITE');
2214: log('Turning Off Audit as Current Audit Profile Value:'||l_cur_val,'CSM_UTIL_PKG.set_task_audit');
2215: END IF;
2216: RETURN l_cur_val;
2217: ELSE

Line 2219: x:=fnd_profile.delete('JTF_TASK_ENABLE_AUDIT','SITE');

2215: END IF;
2216: RETURN l_cur_val;
2217: ELSE
2218: IF p_old_val IS NULL THEN
2219: x:=fnd_profile.delete('JTF_TASK_ENABLE_AUDIT','SITE');
2220: log('Deleting Audit profile as it did not exist before','CSM_UTIL_PKG.set_task_audit');
2221: ELSIF p_old_val='Y' THEN
2222: x:=fnd_profile.save('JTF_TASK_ENABLE_AUDIT','Y','SITE');
2223: log('Re-enabling Audit profile','CSM_UTIL_PKG.set_task_audit');

Line 2222: x:=fnd_profile.save('JTF_TASK_ENABLE_AUDIT','Y','SITE');

2218: IF p_old_val IS NULL THEN
2219: x:=fnd_profile.delete('JTF_TASK_ENABLE_AUDIT','SITE');
2220: log('Deleting Audit profile as it did not exist before','CSM_UTIL_PKG.set_task_audit');
2221: ELSIF p_old_val='Y' THEN
2222: x:=fnd_profile.save('JTF_TASK_ENABLE_AUDIT','Y','SITE');
2223: log('Re-enabling Audit profile','CSM_UTIL_PKG.set_task_audit');
2224: END IF;
2225: RETURN p_old_val;
2226: END IF;

Line 2239: FROM FND_PROFILE_OPTION_VALUES val,

2235:
2236: CURSOR c_get_user_value (c_user_id NUMBER)
2237: IS
2238: SELECT lang.LANGUAGE_CODE
2239: FROM FND_PROFILE_OPTION_VALUES val,
2240: FND_PROFILE_OPTIONS prf,
2241: FND_LANGUAGES lang
2242: WHERE prf.PROFILE_OPTION_ID = val.PROFILE_OPTION_ID
2243: AND prf.PROFILE_OPTION_NAME = l_profile_option_name

Line 2240: FND_PROFILE_OPTIONS prf,

2236: CURSOR c_get_user_value (c_user_id NUMBER)
2237: IS
2238: SELECT lang.LANGUAGE_CODE
2239: FROM FND_PROFILE_OPTION_VALUES val,
2240: FND_PROFILE_OPTIONS prf,
2241: FND_LANGUAGES lang
2242: WHERE prf.PROFILE_OPTION_ID = val.PROFILE_OPTION_ID
2243: AND prf.PROFILE_OPTION_NAME = l_profile_option_name
2244: AND LEVEL_ID = 10004

Line 2251: FROM FND_PROFILE_OPTION_VALUES val,

2247:
2248: CURSOR c_get_site_value
2249: IS
2250: SELECT lang.LANGUAGE_CODE
2251: FROM FND_PROFILE_OPTION_VALUES val,
2252: FND_PROFILE_OPTIONS prf,
2253: FND_LANGUAGES lang
2254: WHERE prf.PROFILE_OPTION_ID = val.PROFILE_OPTION_ID
2255: AND prf.PROFILE_OPTION_NAME = l_profile_option_name

Line 2252: FND_PROFILE_OPTIONS prf,

2248: CURSOR c_get_site_value
2249: IS
2250: SELECT lang.LANGUAGE_CODE
2251: FROM FND_PROFILE_OPTION_VALUES val,
2252: FND_PROFILE_OPTIONS prf,
2253: FND_LANGUAGES lang
2254: WHERE prf.PROFILE_OPTION_ID = val.PROFILE_OPTION_ID
2255: AND prf.PROFILE_OPTION_NAME = l_profile_option_name
2256: AND LEVEL_ID = 10001