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_EMAIL_QUERY_PKG dependencies on FND_PROFILE

Line 328: l_client_tz:= fnd_timezones.get_code(fnd_profile.value_specific('CLIENT_TIMEZONE_ID'));

324: l_server_tz VARCHAR2(4000);
325: l_adj_date DATE;
326: BEGIN
327:
328: l_client_tz:= fnd_timezones.get_code(fnd_profile.value_specific('CLIENT_TIMEZONE_ID'));
329: l_server_tz:= fnd_timezones.get_code(fnd_profile.value_specific('SERVER_TIMEZONE_ID'));
330:
331: l_adj_date := fnd_timezones_pvt.adjust_datetime(p_date_time,l_server_tz,l_client_tz);
332:

Line 329: l_server_tz:= fnd_timezones.get_code(fnd_profile.value_specific('SERVER_TIMEZONE_ID'));

325: l_adj_date DATE;
326: BEGIN
327:
328: l_client_tz:= fnd_timezones.get_code(fnd_profile.value_specific('CLIENT_TIMEZONE_ID'));
329: l_server_tz:= fnd_timezones.get_code(fnd_profile.value_specific('SERVER_TIMEZONE_ID'));
330:
331: l_adj_date := fnd_timezones_pvt.adjust_datetime(p_date_time,l_server_tz,l_client_tz);
332:
333: CSM_UTIL_PKG.LOG( 'Client Timezone : ' || l_client_tz ||

Line 488: g_date_format_mask := TO_CHAR(fnd_profile.value_specific('ICX_DATE_FORMAT_MASK')) || ' ' ||g_time_stamp;

484: CSM_UTIL_PKG.LOG('Set Application Context to user_id : ' || g_user_id || ' resp_id :' || l_level_value || ' appl_id :' || l_application_id, g_object_name, FND_LOG.LEVEL_PROCEDURE);
485: fnd_global.apps_initialize(g_user_id, l_level_value, l_application_id);
486: END IF;
487:
488: g_date_format_mask := TO_CHAR(fnd_profile.value_specific('ICX_DATE_FORMAT_MASK')) || ' ' ||g_time_stamp;
489:
490: OPEN c_get_all_vars (l_query_id);
491: FETCH c_get_all_vars BULK COLLECT INTO l_variable_id_lst, l_var_value_char_lst, l_var_value_date_lst, l_default_flag_lst;
492: CLOSE c_get_all_vars;

Line 1046: l_profile_value := TO_NUMBER(fnd_profile.value('CSF_DEFAULT_ACCEPTED_STATUS'));

1042: l_profile_value NUMBER;
1043: BEGIN
1044:
1045: CSM_UTIL_PKG.LOG('Entering ACCEPT_TASK for TASK_NUMBER: ' || p_task_number, g_object_name, FND_LOG.LEVEL_PROCEDURE);
1046: l_profile_value := TO_NUMBER(fnd_profile.value('CSF_DEFAULT_ACCEPTED_STATUS'));
1047:
1048: IF l_profile_value IS NULL THEN
1049: x_return_status := FND_API.G_RET_STS_ERROR;
1050: x_error_message := 'Please set the Profile option CSF_DEFAULT_ACCEPTED_STATUS value.';

Line 1083: l_profile_value := TO_NUMBER(fnd_profile.value('CSF_DEFAULT_TASK_CANCELLED_STATUS'));

1079: l_profile_value NUMBER;
1080: BEGIN
1081:
1082: CSM_UTIL_PKG.LOG('Entering CANCEL_TASK for TASK_NUMBER: ' || p_task_number, g_object_name, FND_LOG.LEVEL_PROCEDURE);
1083: l_profile_value := TO_NUMBER(fnd_profile.value('CSF_DEFAULT_TASK_CANCELLED_STATUS'));
1084:
1085: IF l_profile_value IS NULL THEN
1086: x_return_status := FND_API.G_RET_STS_ERROR;
1087: x_error_message := 'Please set the Profile option CSF_DEFAULT_TASK_CANCELLED_STATUS value.';

Line 1121: l_profile_value := TO_NUMBER(fnd_profile.value('CSF_DFLT_AUTO_CLOSE_TASK_STATUS'));

1117: BEGIN
1118:
1119: CSM_UTIL_PKG.LOG('Entering CLOSE_TASK for TASK_NUMBER: ' || p_task_number, g_object_name, FND_LOG.LEVEL_PROCEDURE);
1120:
1121: l_profile_value := TO_NUMBER(fnd_profile.value('CSF_DFLT_AUTO_CLOSE_TASK_STATUS'));
1122:
1123: IF l_profile_value IS NULL THEN
1124: x_return_status := FND_API.G_RET_STS_ERROR;
1125: x_error_message := 'Please set the Profile option CSF_DFLT_AUTO_CLOSE_TASK_STATUS value.';

Line 1161: l_profile_value := TO_NUMBER(fnd_profile.value('CSF_DEFAULT_TRAVELING_STATUS'));

1157:
1158: BEGIN
1159: CSM_UTIL_PKG.LOG('Entering TRAVELING_TASK for TASK_NUMBER: ' || p_task_number, g_object_name, FND_LOG.LEVEL_PROCEDURE);
1160:
1161: l_profile_value := TO_NUMBER(fnd_profile.value('CSF_DEFAULT_TRAVELING_STATUS'));
1162:
1163: IF l_profile_value IS NULL THEN
1164: x_return_status := FND_API.G_RET_STS_ERROR;
1165: x_error_message := 'Please set the Profile option CSF_DEFAULT_TRAVELING_STATUS value.';

Line 1198: l_profile_value := TO_NUMBER(fnd_profile.value('CSF_DEFAULT_TASK_WORKING_STATUS'));

1194: AS
1195: l_profile_value NUMBER;
1196: BEGIN
1197: CSM_UTIL_PKG.LOG('Entering WORKING_TASK for TASK_NUMBER: ' || p_task_number, g_object_name, FND_LOG.LEVEL_PROCEDURE);
1198: l_profile_value := TO_NUMBER(fnd_profile.value('CSF_DEFAULT_TASK_WORKING_STATUS'));
1199:
1200: IF l_profile_value IS NULL THEN
1201: x_return_status := FND_API.G_RET_STS_ERROR;
1202: x_error_message := 'Please set the Profile option CSF_DEFAULT_TASK_WORKING_STATUS value.';

Line 1247: l_profile_value := TO_NUMBER(fnd_profile.value('CSF_DEFAULT_COMPLETED_STATUS'));

1243:
1244: BEGIN
1245: CSM_UTIL_PKG.LOG('Entering COMPLETED_TASK for TASK_NUMBER: ' || p_task_number, g_object_name, FND_LOG.LEVEL_PROCEDURE);
1246:
1247: l_profile_value := TO_NUMBER(fnd_profile.value('CSF_DEFAULT_COMPLETED_STATUS'));
1248:
1249: IF l_profile_value IS NULL THEN
1250: x_return_status := FND_API.G_RET_STS_ERROR;
1251: x_error_message := 'Please set the Profile option CSF_DEFAULT_COMPLETED_STATUS value.';

Line 1341: l_note_type := fnd_profile.value('JTF_NTS_NOTE_TYPE');

1337: IF l_sig_pos > 0 THEN
1338: l_notes := SUBSTR(l_notes, 1, l_sig_pos - 1);
1339: END IF;
1340:
1341: l_note_type := fnd_profile.value('JTF_NTS_NOTE_TYPE');
1342:
1343: IF LENGTH(l_notes) > 2000 THEN
1344: jtf_notes_pub.create_note
1345: ( p_api_version => 1.0

Line 2058: l_return_stat := fnd_profile.save(p_profile_name, p_profile_value, 'SITE');

2054: BEGIN
2055: CSM_UTIL_PKG.LOG('Entering SET_PROFILE for p_profile_name: ' || p_profile_name, g_object_name, FND_LOG.LEVEL_PROCEDURE);
2056: l_return_flag := 'N';
2057:
2058: l_return_stat := fnd_profile.save(p_profile_name, p_profile_value, 'SITE');
2059: IF l_return_stat THEN
2060: l_return_flag := 'Y';
2061: COMMIT;
2062: END IF;

Line 2233: l_profile_value := TO_NUMBER(fnd_profile.value_specific('CS_INV_VALIDATION_ORG',G_USER_ID,NULL,NULL));

2229:
2230: BEGIN
2231: CSM_UTIL_PKG.LOG('Entering GET_ITEM_DETAILS for Item : ' || p_item, g_object_name, FND_LOG.LEVEL_PROCEDURE);
2232:
2233: l_profile_value := TO_NUMBER(fnd_profile.value_specific('CS_INV_VALIDATION_ORG',G_USER_ID,NULL,NULL));
2234:
2235: --get org name for display
2236: OPEN C_GET_ORG(L_PROFILE_VALUE);
2237: FETCH C_GET_ORG INTO L_ORG_NAME;

Line 2366: l_profile_value := TO_NUMBER(fnd_profile.value_specific('CS_INV_VALIDATION_ORG',G_USER_ID,NULL,NULL));

2362: L_ORG_NAME VARCHAR2(2000);
2363: BEGIN
2364: CSM_UTIL_PKG.LOG('Entering GET_PART_SUB for Item : ' || p_item, g_object_name, FND_LOG.LEVEL_PROCEDURE);
2365:
2366: l_profile_value := TO_NUMBER(fnd_profile.value_specific('CS_INV_VALIDATION_ORG',G_USER_ID,NULL,NULL));
2367:
2368: --get org name for display
2369: OPEN C_GET_ORG(L_PROFILE_VALUE);
2370: FETCH C_GET_ORG INTO L_ORG_NAME;

Line 2525: l_profile_value := TO_NUMBER(fnd_profile.value_specific('CS_INV_VALIDATION_ORG',G_USER_ID,NULL,NULL));

2521:
2522: BEGIN
2523: CSM_UTIL_PKG.LOG('Entering GET_PART_AVAIL for Item : ' || p_item, g_object_name, FND_LOG.LEVEL_PROCEDURE);
2524:
2525: l_profile_value := TO_NUMBER(fnd_profile.value_specific('CS_INV_VALIDATION_ORG',G_USER_ID,NULL,NULL));
2526:
2527: --get org name for display
2528: OPEN C_GET_ORG(L_PROFILE_VALUE);
2529: FETCH C_GET_ORG INTO L_ORG_NAME;

Line 2718: l_profile_value := TO_NUMBER(fnd_profile.value_specific('CS_INV_VALIDATION_ORG',G_USER_ID,NULL,NULL));

2714:
2715: BEGIN
2716: CSM_UTIL_PKG.LOG('Entering GET_PART_RETURN_INFO for Item : ' || p_item, g_object_name, FND_LOG.LEVEL_PROCEDURE);
2717:
2718: l_profile_value := TO_NUMBER(fnd_profile.value_specific('CS_INV_VALIDATION_ORG',G_USER_ID,NULL,NULL));
2719: l_resource_id := GET_RESOURCE_ID( G_USER_ID);
2720: --get org name for display
2721: OPEN C_GET_ORG(L_PROFILE_VALUE);
2722: FETCH C_GET_ORG INTO L_ORG_NAME;