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 1546: l_error_msg_code fnd_new_messages.message_name%TYPE;

1542:
1543: l_competency_tbl PA_HR_COMPETENCE_UTILS.Competency_Tbl_Typ;
1544: l_min_candidate_score NUMBER;
1545: l_no_of_competencies NUMBER;
1546: l_error_msg_code fnd_new_messages.message_name%TYPE;
1547: l_return_status VARCHAR2(1);
1548: l_msg_data fnd_new_messages.message_text%TYPE;
1549: l_msg_count NUMBER;
1550: l_is_resource_candidate VARCHAR2(1);

Line 1548: l_msg_data fnd_new_messages.message_text%TYPE;

1544: l_min_candidate_score NUMBER;
1545: l_no_of_competencies NUMBER;
1546: l_error_msg_code fnd_new_messages.message_name%TYPE;
1547: l_return_status VARCHAR2(1);
1548: l_msg_data fnd_new_messages.message_text%TYPE;
1549: l_msg_count NUMBER;
1550: l_is_resource_candidate VARCHAR2(1);
1551: l_nomination_comments fnd_new_messages.message_text%TYPE;
1552: l_system_nom_candidate_text fnd_new_messages.message_text%TYPE;

Line 1551: l_nomination_comments fnd_new_messages.message_text%TYPE;

1547: l_return_status VARCHAR2(1);
1548: l_msg_data fnd_new_messages.message_text%TYPE;
1549: l_msg_count NUMBER;
1550: l_is_resource_candidate VARCHAR2(1);
1551: l_nomination_comments fnd_new_messages.message_text%TYPE;
1552: l_system_nom_candidate_text fnd_new_messages.message_text%TYPE;
1553: l_candidates_nom_in_cycle NUMBER := 0;
1554: l_req_enable_auto_cand_nom pa_project_assignments.ENABLE_AUTO_CAND_NOM_FLAG%TYPE;
1555: l_proj_enable_automated_search pa_projects_all.enable_automated_search%TYPE;

Line 1552: l_system_nom_candidate_text fnd_new_messages.message_text%TYPE;

1548: l_msg_data fnd_new_messages.message_text%TYPE;
1549: l_msg_count NUMBER;
1550: l_is_resource_candidate VARCHAR2(1);
1551: l_nomination_comments fnd_new_messages.message_text%TYPE;
1552: l_system_nom_candidate_text fnd_new_messages.message_text%TYPE;
1553: l_candidates_nom_in_cycle NUMBER := 0;
1554: l_req_enable_auto_cand_nom pa_project_assignments.ENABLE_AUTO_CAND_NOM_FLAG%TYPE;
1555: l_proj_enable_automated_search pa_projects_all.enable_automated_search%TYPE;
1556: l_status_code pa_project_statuses.project_status_code%TYPE;

Line 1851: query from fnd_new_messages below */

1847: IF p_debug_mode = 'Y' THEN
1848: fnd_file.put_line(FND_FILE.LOG,'about to get system nominated candidate text');
1849: END IF;
1850: /* 2590651 - Added two conditions for application id and language code for the
1851: query from fnd_new_messages below */
1852:
1853: SELECT message_text INTO l_system_nom_candidate_text
1854: FROM fnd_new_messages
1855: WHERE message_name = 'PA_SYSTEM_NOMINATED_CANDIDATE'

Line 1854: FROM fnd_new_messages

1850: /* 2590651 - Added two conditions for application id and language code for the
1851: query from fnd_new_messages below */
1852:
1853: SELECT message_text INTO l_system_nom_candidate_text
1854: FROM fnd_new_messages
1855: WHERE message_name = 'PA_SYSTEM_NOMINATED_CANDIDATE'
1856: and application_id = 275
1857: and language_code = userenv('LANG');
1858: