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.PA_SEARCH_PVT dependencies on FND_NEW_MESSAGES

Line 1496: l_error_msg_code fnd_new_messages.message_name%TYPE;

1492:
1493: l_competency_tbl PA_HR_COMPETENCE_UTILS.Competency_Tbl_Typ;
1494: l_min_candidate_score NUMBER;
1495: l_no_of_competencies NUMBER;
1496: l_error_msg_code fnd_new_messages.message_name%TYPE;
1497: l_return_status VARCHAR2(1);
1498: l_msg_data fnd_new_messages.message_text%TYPE;
1499: l_msg_count NUMBER;
1500: l_is_resource_candidate VARCHAR2(1);

Line 1498: l_msg_data fnd_new_messages.message_text%TYPE;

1494: l_min_candidate_score NUMBER;
1495: l_no_of_competencies NUMBER;
1496: l_error_msg_code fnd_new_messages.message_name%TYPE;
1497: l_return_status VARCHAR2(1);
1498: l_msg_data fnd_new_messages.message_text%TYPE;
1499: l_msg_count NUMBER;
1500: l_is_resource_candidate VARCHAR2(1);
1501: l_nomination_comments fnd_new_messages.message_text%TYPE;
1502: l_system_nom_candidate_text fnd_new_messages.message_text%TYPE;

Line 1501: l_nomination_comments fnd_new_messages.message_text%TYPE;

1497: l_return_status VARCHAR2(1);
1498: l_msg_data fnd_new_messages.message_text%TYPE;
1499: l_msg_count NUMBER;
1500: l_is_resource_candidate VARCHAR2(1);
1501: l_nomination_comments fnd_new_messages.message_text%TYPE;
1502: l_system_nom_candidate_text fnd_new_messages.message_text%TYPE;
1503: l_candidates_nom_in_cycle NUMBER := 0;
1504: l_req_enable_auto_cand_nom pa_project_assignments.ENABLE_AUTO_CAND_NOM_FLAG%TYPE;
1505: l_proj_enable_automated_search pa_projects_all.enable_automated_search%TYPE;

Line 1502: l_system_nom_candidate_text fnd_new_messages.message_text%TYPE;

1498: l_msg_data fnd_new_messages.message_text%TYPE;
1499: l_msg_count NUMBER;
1500: l_is_resource_candidate VARCHAR2(1);
1501: l_nomination_comments fnd_new_messages.message_text%TYPE;
1502: l_system_nom_candidate_text fnd_new_messages.message_text%TYPE;
1503: l_candidates_nom_in_cycle NUMBER := 0;
1504: l_req_enable_auto_cand_nom pa_project_assignments.ENABLE_AUTO_CAND_NOM_FLAG%TYPE;
1505: l_proj_enable_automated_search pa_projects_all.enable_automated_search%TYPE;
1506: l_status_code pa_project_statuses.project_status_code%TYPE;

Line 1800: query from fnd_new_messages below */

1796: IF p_debug_mode = 'Y' THEN
1797: fnd_file.put_line(FND_FILE.LOG,'about to get system nominated candidate text');
1798: END IF;
1799: /* 2590651 - Added two conditions for application id and language code for the
1800: query from fnd_new_messages below */
1801:
1802: SELECT message_text INTO l_system_nom_candidate_text
1803: FROM fnd_new_messages
1804: WHERE message_name = 'PA_SYSTEM_NOMINATED_CANDIDATE'

Line 1803: FROM fnd_new_messages

1799: /* 2590651 - Added two conditions for application id and language code for the
1800: query from fnd_new_messages below */
1801:
1802: SELECT message_text INTO l_system_nom_candidate_text
1803: FROM fnd_new_messages
1804: WHERE message_name = 'PA_SYSTEM_NOMINATED_CANDIDATE'
1805: and application_id = 275
1806: and language_code = userenv('LANG');
1807: