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.IRC_SEEKER_VAC_MATCHING_PKG dependencies on HR_UTILITY

Line 829: /*hr_utility.trace_on('F','REQID');

825: -- log is additionally written out via FND_FILE,
826: -- for visibility from view SRS window.
827: fnd_file.put_line(which => fnd_file.output,
828: buff => 'REQ'||p_message);
829: /*hr_utility.trace_on('F','REQID');
830: hr_utility.trace('FRED');
831: hr_utility.trace_off;
832: */
833: end if;

Line 830: hr_utility.trace('FRED');

826: -- for visibility from view SRS window.
827: fnd_file.put_line(which => fnd_file.output,
828: buff => 'REQ'||p_message);
829: /*hr_utility.trace_on('F','REQID');
830: hr_utility.trace('FRED');
831: hr_utility.trace_off;
832: */
833: end if;
834: END log_message;

Line 831: hr_utility.trace_off;

827: fnd_file.put_line(which => fnd_file.output,
828: buff => 'REQ'||p_message);
829: /*hr_utility.trace_on('F','REQID');
830: hr_utility.trace('FRED');
831: hr_utility.trace_off;
832: */
833: end if;
834: END log_message;
835:

Line 878: hr_utility.set_location('Entering'||l_proc, 10);

874: from fnd_languages_vl
875: where language_code = p_dft_lang;
876:
877: BEGIN
878: hr_utility.set_location('Entering'||l_proc, 10);
879: --
880: -- If the base URL isn't set up, it is futile performing a job search
881: -- as the URL for the seekers to click on won't work.
882: --

Line 885: hr_utility.set_location('base_url is null', 20);

881: -- as the URL for the seekers to click on won't work.
882: --
883: l_base_url := fnd_profile.value('IRC_JOB_NOTIFICATION_URL');
884: IF l_base_url IS NULL THEN
885: hr_utility.set_location('base_url is null', 20);
886: fnd_message.set_name('PER','IRC_412056_NO_EMAIL_JOB_URL');
887: RAISE e_no_base_url;
888: END IF;
889:

Line 1170: hr_utility.set_location('l_dft_lang: ' || l_dft_lang, 15);

1166: open get_nls_lang(userenv('LANG'));
1167: fetch get_nls_lang into l_dft_lang;
1168: close get_nls_lang;
1169: --
1170: hr_utility.set_location('l_dft_lang: ' || l_dft_lang, 15);
1171: if (l_dft_lang is not null) then
1172: l_dft_lang := '"' || l_dft_lang || '"';
1173: end if;
1174: hr_utility.set_location('l_dft_lang: ' || l_dft_lang, 16);

Line 1174: hr_utility.set_location('l_dft_lang: ' || l_dft_lang, 16);

1170: hr_utility.set_location('l_dft_lang: ' || l_dft_lang, 15);
1171: if (l_dft_lang is not null) then
1172: l_dft_lang := '"' || l_dft_lang || '"';
1173: end if;
1174: hr_utility.set_location('l_dft_lang: ' || l_dft_lang, 16);
1175: --
1176: -- ************************************************************
1177: -- Loop through all the job seekers eligible for an email today
1178: -- ************************************************************

Line 1186: hr_utility.set_location('person_id:'

1182: -- Clear the table as now we need to build up a new record for
1183: -- a different (or the first) job seeker
1184: --
1185: begin
1186: hr_utility.set_location('person_id:'
1187: ||seeker_rec.person_id, 20);
1188: hr_utility.set_location('lang_pref:'
1189: ||seeker_rec.lang_pref, 20);
1190:

Line 1188: hr_utility.set_location('lang_pref:'

1184: --
1185: begin
1186: hr_utility.set_location('person_id:'
1187: ||seeker_rec.person_id, 20);
1188: hr_utility.set_location('lang_pref:'
1189: ||seeker_rec.lang_pref, 20);
1190:
1191: l_seeker_lang_pref := seeker_rec.lang_pref;
1192: if (l_seeker_lang_pref is not null ) then

Line 1467: hr_utility.set_location('vacancy_id:'

1463: --
1464: l_posting_details_tab(l_counter)
1465: := seeker_criteria_match_vac_rec;
1466: --
1467: hr_utility.set_location('vacancy_id:'
1468: ||seeker_criteria_match_vac_rec.object_id, 30);
1469:
1470: --dbms_output.put_line(' Person:'||seeker_criteria_rec.object_id||' FOR VAC:'||seeker_criteria_match_vac_rec.object_id||'>'||seeker_criteria_match_vac_rec.name);
1471: END LOOP;

Line 1480: hr_utility.set_location('sending notification:',50);

1476: -- Send an e-mail to the job seeker with suitable jobs
1477: -- ************************************************************
1478: IF l_posting_details_tab.count > 0 THEN
1479: -- Send the notification if any suitable vacancies have been found
1480: hr_utility.set_location('sending notification:',50);
1481: --dbms_output.put_line(' Person:'||seeker_rec.person_id||' Has Matches');
1482: --
1483: l_message_subject := fnd_message.get_string('PER','IRC_EMAIL_SEEKERS_SUBJECT');
1484: l_id :=

Line 1497: hr_utility.set_location('Location:'||l_proc,60);

1493: , p_person_id => seeker_rec.person_id )
1494: );
1495: END IF;
1496: --
1497: hr_utility.set_location('Location:'||l_proc,60);
1498: exception
1499: when others then
1500: -- Catch the exception so that an error doens't cause total failure.
1501: hr_utility.set_location('Problem sending notification to person:'||seeker_rec.person_id,60);

Line 1501: hr_utility.set_location('Problem sending notification to person:'||seeker_rec.person_id,60);

1497: hr_utility.set_location('Location:'||l_proc,60);
1498: exception
1499: when others then
1500: -- Catch the exception so that an error doens't cause total failure.
1501: hr_utility.set_location('Problem sending notification to person:'||seeker_rec.person_id,60);
1502: DBMS_SESSION.SET_NLS('NLS_LANGUAGE',l_dft_lang);
1503: end;
1504: END LOOP;
1505: DBMS_SESSION.SET_NLS('NLS_LANGUAGE',l_dft_lang);

Line 1509: hr_utility.set_location('Leaving'||l_proc, 80);

1505: DBMS_SESSION.SET_NLS('NLS_LANGUAGE',l_dft_lang);
1506: DBMS_SQL.CLOSE_CURSOR (c => l_cursor);--All done, so clean up!
1507:
1508: --
1509: hr_utility.set_location('Leaving'||l_proc, 80);
1510: EXCEPTION
1511: WHEN others THEN
1512: DBMS_SESSION.SET_NLS('NLS_LANGUAGE',l_dft_lang);
1513: ERRBUF := SQLERRM||' '||fnd_message.get;

Line 1557: hr_utility.set_location('Entering'||l_proc, 10);

1553: l_internal_site irc_all_recruiting_sites.internal%type;
1554: l_external_site irc_all_recruiting_sites.external%type;
1555: l_proc VARCHAR2(30) default ' get_suitable_seekers_for_vac';
1556: BEGIN
1557: hr_utility.set_location('Entering'||l_proc, 10);
1558: --
1559: l_matching_flex := fnd_profile.value('IRC_SEARCH_CRITERIA_SM');
1560: --
1561: if (p_candidacy_age>0) then

Line 1828: hr_utility.set_location(l_proc, 20);

1824:
1825:
1826: l_base_url := fnd_profile.value('IRC_SUITABLE_SEEKERS_URL');
1827: IF l_base_url IS NULL THEN
1828: hr_utility.set_location(l_proc, 20);
1829: fnd_message.set_name('PER','IRC_412064_NO_EMAIL_VAC_URL');
1830: RAISE e_no_base_url;
1831: END IF;
1832: --

Line 1839: hr_utility.set_location('search_criteria_id:'

1835: -- ************************************************************--
1836: FOR available_vacancy IN csr_vacancies_needing_seekers
1837: LOOP
1838: begin
1839: hr_utility.set_location('search_criteria_id:'
1840: ||available_vacancy.search_criteria_id, 20);
1841: --
1842: log_message ('Vacancy :'
1843: ||available_vacancy.name

Line 1860: hr_utility.set_location('keywords not null', 30);

1856: l_counter := 0;
1857: -- ************************************************************ --
1858: -- Get a list of all the suitable seekers for the vacancy --
1859: -- ************************************************************ --
1860: hr_utility.set_location('keywords not null', 30);
1861: -- define the posting_content_id column
1862:
1863: -- define the name column
1864: DBMS_SQL.DEFINE_COLUMN (

Line 2042: hr_utility.set_location

2038: position => 2,
2039: value => seeker_details_rec.person_id);
2040:
2041: log_message ('..person_id:'||seeker_details_rec.person_id);
2042: hr_utility.set_location
2043: (' loop: seeker_details_rec.person_id='
2044: || seeker_details_rec.person_id, 35);
2045: --
2046: l_counter := l_counter + 1;

Line 2061: hr_utility.set_location('stuff to send ', 50);

2057: log_message ('.suitable seekers :'
2058: ||l_seeker_details_tab.count);
2059: IF l_seeker_details_tab.count > 0 THEN
2060: -- Send the notification if any suitable candidates have been found
2061: hr_utility.set_location('stuff to send ', 50);
2062: --
2063: l_message_subject := null;
2064:
2065: fnd_message.set_name('PER','IRC_EMAIL_RECRUITER_SUBJECT');

Line 2104: hr_utility.set_location('No recruiter_id ',59);

2100: --
2101: IF ( l_index > 0 ) THEN
2102: -- Maybe have an out parameter that handles these, or put them into
2103: -- the ERRBUF for concurrent processes.
2104: hr_utility.set_location('No recruiter_id ',59);
2105: fnd_message.set_name ('PER','IRC_412070_VACS_NO_OWNERS');
2106: log_message(fnd_message.get);
2107: for i in l_recruiter_problem_tab.first .. l_recruiter_problem_tab.last loop
2108: log_message(l_recruiter_problem_tab(i).vacancy_name);

Line 2109: hr_utility.set_location('Exception ('||i||')', 60);

2105: fnd_message.set_name ('PER','IRC_412070_VACS_NO_OWNERS');
2106: log_message(fnd_message.get);
2107: for i in l_recruiter_problem_tab.first .. l_recruiter_problem_tab.last loop
2108: log_message(l_recruiter_problem_tab(i).vacancy_name);
2109: hr_utility.set_location('Exception ('||i||')', 60);
2110: hr_utility.set_location(' > vacancy_id:' || l_recruiter_problem_tab(i).vacancy_id, 62);
2111: end loop;
2112: END IF;
2113: hr_utility.set_location('Leaving'||l_proc, 80);

Line 2110: hr_utility.set_location(' > vacancy_id:' || l_recruiter_problem_tab(i).vacancy_id, 62);

2106: log_message(fnd_message.get);
2107: for i in l_recruiter_problem_tab.first .. l_recruiter_problem_tab.last loop
2108: log_message(l_recruiter_problem_tab(i).vacancy_name);
2109: hr_utility.set_location('Exception ('||i||')', 60);
2110: hr_utility.set_location(' > vacancy_id:' || l_recruiter_problem_tab(i).vacancy_id, 62);
2111: end loop;
2112: END IF;
2113: hr_utility.set_location('Leaving'||l_proc, 80);
2114: EXCEPTION

Line 2113: hr_utility.set_location('Leaving'||l_proc, 80);

2109: hr_utility.set_location('Exception ('||i||')', 60);
2110: hr_utility.set_location(' > vacancy_id:' || l_recruiter_problem_tab(i).vacancy_id, 62);
2111: end loop;
2112: END IF;
2113: hr_utility.set_location('Leaving'||l_proc, 80);
2114: EXCEPTION
2115: WHEN others THEN
2116: ERRBUF := SQLERRM||' '||fnd_message.get;
2117: RETCODE := 2;

Line 2138: hr_utility.set_location('Entering'||l_proc, 10);

2134: l_general_body_html VARCHAR2(32000);
2135: l_general_body_text VARCHAR2(32000);
2136: l_proc VARCHAR2(30) default '.email_general_notifications';
2137: BEGIN
2138: hr_utility.set_location('Entering'||l_proc, 10);
2139: -- Loop through all the job seekers and send them
2140: -- a general notification.
2141: FOR parties_wanting_it IN csr_seekers_for_notes LOOP
2142: --

Line 2178: hr_utility.set_location('Problem sending notification to person:'||parties_wanting_it.person_id,60);

2174: );
2175: exception
2176: when others then
2177: -- Catch the exception so that an error doens't cause total failure.
2178: hr_utility.set_location('Problem sending notification to person:'||parties_wanting_it.person_id,60);
2179: end;
2180: END LOOP;
2181: hr_utility.set_location('Leaving'||l_proc, 80);
2182: END email_general_notifications;

Line 2181: hr_utility.set_location('Leaving'||l_proc, 80);

2177: -- Catch the exception so that an error doens't cause total failure.
2178: hr_utility.set_location('Problem sending notification to person:'||parties_wanting_it.person_id,60);
2179: end;
2180: END LOOP;
2181: hr_utility.set_location('Leaving'||l_proc, 80);
2182: END email_general_notifications;
2183:
2184: --
2185: FUNCTION get_conclusion_msg(p_message_text varchar2