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_GLOBAL

Line 472: l_old_user_id := fnd_global.user_id;

468: CSM_UTIL_PKG.LOG(x_error_message, g_object_name, FND_LOG.LEVEL_PROCEDURE);
469: RETURN;
470: END IF;
471:
472: l_old_user_id := fnd_global.user_id;
473: l_old_resp_id := fnd_global.resp_id;
474: l_old_appl_id := fnd_global.resp_appl_id;
475:
476: OPEN c_get_appl_resp_id;

Line 473: l_old_resp_id := fnd_global.resp_id;

469: RETURN;
470: END IF;
471:
472: l_old_user_id := fnd_global.user_id;
473: l_old_resp_id := fnd_global.resp_id;
474: l_old_appl_id := fnd_global.resp_appl_id;
475:
476: OPEN c_get_appl_resp_id;
477: FETCH c_get_appl_resp_id INTO l_application_id, l_resp_id;

Line 474: l_old_appl_id := fnd_global.resp_appl_id;

470: END IF;
471:
472: l_old_user_id := fnd_global.user_id;
473: l_old_resp_id := fnd_global.resp_id;
474: l_old_appl_id := fnd_global.resp_appl_id;
475:
476: OPEN c_get_appl_resp_id;
477: FETCH c_get_appl_resp_id INTO l_application_id, l_resp_id;
478: CLOSE c_get_appl_resp_id;

Line 482: fnd_global.apps_initialize(g_user_id, l_resp_id, l_application_id);

478: CLOSE c_get_appl_resp_id;
479:
480: IF l_level_id = 10001 THEN
481: CSM_UTIL_PKG.LOG('Set Application Context to user_id : ' || g_user_id || ' resp_id :' || l_resp_id || ' appl_id :' || l_application_id, g_object_name, FND_LOG.LEVEL_PROCEDURE);
482: fnd_global.apps_initialize(g_user_id, l_resp_id, l_application_id);
483: ELSE
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;

Line 485: fnd_global.apps_initialize(g_user_id, l_level_value, l_application_id);

481: CSM_UTIL_PKG.LOG('Set Application Context to user_id : ' || g_user_id || ' resp_id :' || l_resp_id || ' appl_id :' || l_application_id, g_object_name, FND_LOG.LEVEL_PROCEDURE);
482: fnd_global.apps_initialize(g_user_id, l_resp_id, l_application_id);
483: ELSE
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:

Line 559: fnd_global.apps_initialize(l_old_user_id, l_old_resp_id, l_old_appl_id);

555: WHERE instance_id = p_instance_id;
556: COMMIT;
557:
558: CSM_UTIL_PKG.LOG('Reset Application Context to user_id : ' || l_old_user_id || ' resp_id :' || l_old_resp_id || ' appl_id :' || l_old_appl_id, g_object_name, FND_LOG.LEVEL_PROCEDURE);
559: fnd_global.apps_initialize(l_old_user_id, l_old_resp_id, l_old_appl_id);
560:
561: CSM_UTIL_PKG.LOG( 'Leaving EXECUTE_COMMAND for EMAIL_ID : ' || p_email_id ||' and COMMAND_NAME: ' || p_command_name,g_object_name, FND_LOG.LEVEL_PROCEDURE);
562:
563: EXCEPTION

Line 1013: l_msg_data := replace(l_msg_data,fnd_global.local_chr(10), ' ');

1009: );
1010:
1011: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1012: x_return_status := FND_API.G_RET_STS_ERROR;
1013: l_msg_data := replace(l_msg_data,fnd_global.local_chr(10), ' ');
1014: x_error_message := 'Error in UPDATE_TASK :'
1015: || ' ROOT ERROR: csf_task_assignments_pub.update_assignment_status'
1016: || ' for PK : ' || r_task_assignments.task_assignment_id
1017: || ' Details:' || l_msg_data ;

Line 1359: , p_created_by => g_user_id --NVL(p_record.created_by,FND_GLOBAL.USER_ID) --12.1

1355: , p_notes_detail => l_notes
1356: , p_note_status => l_note_status
1357: , p_entered_by => g_user_id
1358: , p_entered_date => SYSDATE
1359: , p_created_by => g_user_id --NVL(p_record.created_by,FND_GLOBAL.USER_ID) --12.1
1360: , p_creation_date => SYSDATE
1361: , p_last_updated_by => g_user_id --NVL(p_record.last_updated_by,FND_GLOBAL.USER_ID) --12.1
1362: , p_last_update_date => SYSDATE
1363: , p_last_update_login => g_user_id

Line 1361: , p_last_updated_by => g_user_id --NVL(p_record.last_updated_by,FND_GLOBAL.USER_ID) --12.1

1357: , p_entered_by => g_user_id
1358: , p_entered_date => SYSDATE
1359: , p_created_by => g_user_id --NVL(p_record.created_by,FND_GLOBAL.USER_ID) --12.1
1360: , p_creation_date => SYSDATE
1361: , p_last_updated_by => g_user_id --NVL(p_record.last_updated_by,FND_GLOBAL.USER_ID) --12.1
1362: , p_last_update_date => SYSDATE
1363: , p_last_update_login => g_user_id
1364: , p_note_type => l_note_type
1365: , x_jtf_note_id => l_jtf_note_id

Line 1383: , p_created_by => g_user_id --NVL(p_record.created_by,FND_GLOBAL.USER_ID) --12.1

1379: , p_notes_detail => NULL
1380: , p_note_status => l_note_status
1381: , p_entered_by => g_user_id
1382: , p_entered_date => SYSDATE
1383: , p_created_by => g_user_id --NVL(p_record.created_by,FND_GLOBAL.USER_ID) --12.1
1384: , p_creation_date => SYSDATE
1385: , p_last_updated_by => g_user_id --NVL(p_record.last_updated_by,FND_GLOBAL.USER_ID) --12.1
1386: , p_last_update_date => SYSDATE
1387: , p_last_update_login => g_user_id

Line 1385: , p_last_updated_by => g_user_id --NVL(p_record.last_updated_by,FND_GLOBAL.USER_ID) --12.1

1381: , p_entered_by => g_user_id
1382: , p_entered_date => SYSDATE
1383: , p_created_by => g_user_id --NVL(p_record.created_by,FND_GLOBAL.USER_ID) --12.1
1384: , p_creation_date => SYSDATE
1385: , p_last_updated_by => g_user_id --NVL(p_record.last_updated_by,FND_GLOBAL.USER_ID) --12.1
1386: , p_last_update_date => SYSDATE
1387: , p_last_update_login => g_user_id
1388: , p_note_type => l_note_type
1389: , x_jtf_note_id => l_jtf_note_id