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_NOTIFICATION_DATA_PKG dependencies on HR_UTILITY

Line 24: hr_utility.set_location('Error : ' || g_package||'.'|| l_proc ,10);

20: ,l_leftIndex + 1
21: ,l_rightIndex-1-l_leftIndex);
22: exception
23: when others then
24: hr_utility.set_location('Error : ' || g_package||'.'|| l_proc ,10);
25: hr_utility.set_location('Error Message: ' || sqlerrm, 20);
26: return null;
27: end getParamValue;
28: --+

Line 25: hr_utility.set_location('Error Message: ' || sqlerrm, 20);

21: ,l_rightIndex-1-l_leftIndex);
22: exception
23: when others then
24: hr_utility.set_location('Error : ' || g_package||'.'|| l_proc ,10);
25: hr_utility.set_location('Error Message: ' || sqlerrm, 20);
26: return null;
27: end getParamValue;
28: --+
29: --+ getVacancyId

Line 49: hr_utility.set_location('No Data Found Error : ' || g_package||'.'|| l_func ,10);

45: close csrVacancyId;
46: return l_vacancyId;
47: exception
48: when no_data_found then
49: hr_utility.set_location('No Data Found Error : ' || g_package||'.'|| l_func ,10);
50: return null;
51: when others then
52: hr_utility.set_location('Error : ' || g_package||'.'|| l_func ,20);
53: hr_utility.set_location('Error Message: ' || sqlerrm, 30);

Line 52: hr_utility.set_location('Error : ' || g_package||'.'|| l_func ,20);

48: when no_data_found then
49: hr_utility.set_location('No Data Found Error : ' || g_package||'.'|| l_func ,10);
50: return null;
51: when others then
52: hr_utility.set_location('Error : ' || g_package||'.'|| l_func ,20);
53: hr_utility.set_location('Error Message: ' || sqlerrm, 30);
54: return null;
55: end getVacancyId;
56: --+

Line 53: hr_utility.set_location('Error Message: ' || sqlerrm, 30);

49: hr_utility.set_location('No Data Found Error : ' || g_package||'.'|| l_func ,10);
50: return null;
51: when others then
52: hr_utility.set_location('Error : ' || g_package||'.'|| l_func ,20);
53: hr_utility.set_location('Error Message: ' || sqlerrm, 30);
54: return null;
55: end getVacancyId;
56: --+
57: --+ getCandidatePersonId

Line 77: hr_utility.set_location('No Data Found Error : ' || g_package||'.'|| l_func ,10);

73: close csrCandidateId;
74: return l_candidateId;
75: exception
76: when no_data_found then
77: hr_utility.set_location('No Data Found Error : ' || g_package||'.'|| l_func ,10);
78: return null;
79: when others then
80: hr_utility.set_location('Error : ' || g_package||'.'|| l_func ,20);
81: hr_utility.set_location('Error Message: ' || sqlerrm, 30);

Line 80: hr_utility.set_location('Error : ' || g_package||'.'|| l_func ,20);

76: when no_data_found then
77: hr_utility.set_location('No Data Found Error : ' || g_package||'.'|| l_func ,10);
78: return null;
79: when others then
80: hr_utility.set_location('Error : ' || g_package||'.'|| l_func ,20);
81: hr_utility.set_location('Error Message: ' || sqlerrm, 30);
82: return null;
83: end getCandidatePersonId;
84: --+

Line 81: hr_utility.set_location('Error Message: ' || sqlerrm, 30);

77: hr_utility.set_location('No Data Found Error : ' || g_package||'.'|| l_func ,10);
78: return null;
79: when others then
80: hr_utility.set_location('Error : ' || g_package||'.'|| l_func ,20);
81: hr_utility.set_location('Error Message: ' || sqlerrm, 30);
82: return null;
83: end getCandidatePersonId;
84: --+
85: --+

Line 110: hr_utility.set_location('No Data Found Error : ' || g_package||'.'|| l_func ,10);

106: close csrCandidateAgencyId;
107: return l_candidateAgencyId;
108: exception
109: when no_data_found then
110: hr_utility.set_location('No Data Found Error : ' || g_package||'.'|| l_func ,10);
111: return null;
112: when others then
113: hr_utility.set_location('Error : ' || g_package||'.'|| l_func ,20);
114: hr_utility.set_location('Error Message: ' || sqlerrm, 30);

Line 113: hr_utility.set_location('Error : ' || g_package||'.'|| l_func ,20);

109: when no_data_found then
110: hr_utility.set_location('No Data Found Error : ' || g_package||'.'|| l_func ,10);
111: return null;
112: when others then
113: hr_utility.set_location('Error : ' || g_package||'.'|| l_func ,20);
114: hr_utility.set_location('Error Message: ' || sqlerrm, 30);
115: return null;
116: end getCandidateAgencyId;
117: --+

Line 114: hr_utility.set_location('Error Message: ' || sqlerrm, 30);

110: hr_utility.set_location('No Data Found Error : ' || g_package||'.'|| l_func ,10);
111: return null;
112: when others then
113: hr_utility.set_location('Error : ' || g_package||'.'|| l_func ,20);
114: hr_utility.set_location('Error Message: ' || sqlerrm, 30);
115: return null;
116: end getCandidateAgencyId;
117: --+
118: --+ getManagerPersonId

Line 138: hr_utility.set_location('No Data Found Error : ' || g_package||'.'|| l_func ,10);

134: close csrManagerId;
135: return l_managerId;
136: exception
137: when no_data_found then
138: hr_utility.set_location('No Data Found Error : ' || g_package||'.'|| l_func ,10);
139: return null;
140: when others then
141: hr_utility.set_location('Error : ' || g_package||'.'|| l_func ,20);
142: hr_utility.set_location('Error Message: ' || sqlerrm, 30);

Line 141: hr_utility.set_location('Error : ' || g_package||'.'|| l_func ,20);

137: when no_data_found then
138: hr_utility.set_location('No Data Found Error : ' || g_package||'.'|| l_func ,10);
139: return null;
140: when others then
141: hr_utility.set_location('Error : ' || g_package||'.'|| l_func ,20);
142: hr_utility.set_location('Error Message: ' || sqlerrm, 30);
143: return null;
144: end getManagerPersonId;
145: --+

Line 142: hr_utility.set_location('Error Message: ' || sqlerrm, 30);

138: hr_utility.set_location('No Data Found Error : ' || g_package||'.'|| l_func ,10);
139: return null;
140: when others then
141: hr_utility.set_location('Error : ' || g_package||'.'|| l_func ,20);
142: hr_utility.set_location('Error Message: ' || sqlerrm, 30);
143: return null;
144: end getManagerPersonId;
145: --+
146: --+ getRecruiterPersonId

Line 166: hr_utility.set_location('No Data Found Error : ' || g_package||'.'|| l_func ,10);

162: close csrRecruiterId;
163: return l_recruiterId;
164: exception
165: when no_data_found then
166: hr_utility.set_location('No Data Found Error : ' || g_package||'.'|| l_func ,10);
167: return null;
168: when others then
169: hr_utility.set_location('Error : ' || g_package||'.'|| l_func ,20);
170: hr_utility.set_location('Error Message: ' || sqlerrm, 30);

Line 169: hr_utility.set_location('Error : ' || g_package||'.'|| l_func ,20);

165: when no_data_found then
166: hr_utility.set_location('No Data Found Error : ' || g_package||'.'|| l_func ,10);
167: return null;
168: when others then
169: hr_utility.set_location('Error : ' || g_package||'.'|| l_func ,20);
170: hr_utility.set_location('Error Message: ' || sqlerrm, 30);
171: return null;
172: end getRecruiterPersonId;
173: --+

Line 170: hr_utility.set_location('Error Message: ' || sqlerrm, 30);

166: hr_utility.set_location('No Data Found Error : ' || g_package||'.'|| l_func ,10);
167: return null;
168: when others then
169: hr_utility.set_location('Error : ' || g_package||'.'|| l_func ,20);
170: hr_utility.set_location('Error Message: ' || sqlerrm, 30);
171: return null;
172: end getRecruiterPersonId;
173: --+
174: --+ getVacancyDetails

Line 221: hr_utility.set_location('No Data Found Error : ' || g_package||'.'|| l_func ,10);

217: close csrVacancyDetails;
218: return l_vacancyDetails;
219: exception
220: when no_data_found then
221: hr_utility.set_location('No Data Found Error : ' || g_package||'.'|| l_func ,10);
222: return null;
223: when others then
224: hr_utility.set_location('Error : ' || g_package||'.'|| l_func ,20);
225: hr_utility.set_location('Error Message: ' || sqlerrm, 30);

Line 224: hr_utility.set_location('Error : ' || g_package||'.'|| l_func ,20);

220: when no_data_found then
221: hr_utility.set_location('No Data Found Error : ' || g_package||'.'|| l_func ,10);
222: return null;
223: when others then
224: hr_utility.set_location('Error : ' || g_package||'.'|| l_func ,20);
225: hr_utility.set_location('Error Message: ' || sqlerrm, 30);
226: return null;
227: end getVacancyDetails;
228: --+

Line 225: hr_utility.set_location('Error Message: ' || sqlerrm, 30);

221: hr_utility.set_location('No Data Found Error : ' || g_package||'.'|| l_func ,10);
222: return null;
223: when others then
224: hr_utility.set_location('Error : ' || g_package||'.'|| l_func ,20);
225: hr_utility.set_location('Error Message: ' || sqlerrm, 30);
226: return null;
227: end getVacancyDetails;
228: --+
229: --+ getCommTopicDetailsFromTopicId

Line 260: hr_utility.set_location('No Data Found Error : ' || g_package||'.'|| l_func ,10);

256: close csrCommunicationTopicDetails;
257: return l_communicationTopicDetails;
258: exception
259: when no_data_found then
260: hr_utility.set_location('No Data Found Error : ' || g_package||'.'|| l_func ,10);
261: return null;
262: when others then
263: hr_utility.set_location('Error : ' || g_package||'.'|| l_func ,20);
264: hr_utility.set_location('Error Message: ' || sqlerrm, 30);

Line 263: hr_utility.set_location('Error : ' || g_package||'.'|| l_func ,20);

259: when no_data_found then
260: hr_utility.set_location('No Data Found Error : ' || g_package||'.'|| l_func ,10);
261: return null;
262: when others then
263: hr_utility.set_location('Error : ' || g_package||'.'|| l_func ,20);
264: hr_utility.set_location('Error Message: ' || sqlerrm, 30);
265: return null;
266: end getCommunicationTopicDetails;
267: --+

Line 264: hr_utility.set_location('Error Message: ' || sqlerrm, 30);

260: hr_utility.set_location('No Data Found Error : ' || g_package||'.'|| l_func ,10);
261: return null;
262: when others then
263: hr_utility.set_location('Error : ' || g_package||'.'|| l_func ,20);
264: hr_utility.set_location('Error Message: ' || sqlerrm, 30);
265: return null;
266: end getCommunicationTopicDetails;
267: --+
268: --+ getInterviewDetails

Line 339: hr_utility.set_location('No Data Found Error : ' || g_package||'.'|| l_func ,10);

335: close csrInterviewDetails;
336: return l_interviewDetails;
337: exception
338: when no_data_found then
339: hr_utility.set_location('No Data Found Error : ' || g_package||'.'|| l_func ,10);
340: return null;
341: when others then
342: hr_utility.set_location('Error : ' || g_package||'.'|| l_func ,20);
343: hr_utility.set_location('Error Message: ' || sqlerrm, 30);

Line 342: hr_utility.set_location('Error : ' || g_package||'.'|| l_func ,20);

338: when no_data_found then
339: hr_utility.set_location('No Data Found Error : ' || g_package||'.'|| l_func ,10);
340: return null;
341: when others then
342: hr_utility.set_location('Error : ' || g_package||'.'|| l_func ,20);
343: hr_utility.set_location('Error Message: ' || sqlerrm, 30);
344: return null;
345: end getInterviewDetails;
346: --+

Line 343: hr_utility.set_location('Error Message: ' || sqlerrm, 30);

339: hr_utility.set_location('No Data Found Error : ' || g_package||'.'|| l_func ,10);
340: return null;
341: when others then
342: hr_utility.set_location('Error : ' || g_package||'.'|| l_func ,20);
343: hr_utility.set_location('Error Message: ' || sqlerrm, 30);
344: return null;
345: end getInterviewDetails;
346: --+
347: --+ getPersonDetails

Line 389: hr_utility.set_location('No Data Found Error : ' || g_package||'.'|| l_func ,10);

385: close csrPersonDetails;
386: return l_personDetails;
387: exception
388: when no_data_found then
389: hr_utility.set_location('No Data Found Error : ' || g_package||'.'|| l_func ,10);
390: return null;
391: when others then
392: hr_utility.set_location('Error : ' || g_package||'.'|| l_func ,20);
393: hr_utility.set_location('Error Message: ' || sqlerrm, 30);

Line 392: hr_utility.set_location('Error : ' || g_package||'.'|| l_func ,20);

388: when no_data_found then
389: hr_utility.set_location('No Data Found Error : ' || g_package||'.'|| l_func ,10);
390: return null;
391: when others then
392: hr_utility.set_location('Error : ' || g_package||'.'|| l_func ,20);
393: hr_utility.set_location('Error Message: ' || sqlerrm, 30);
394: return null;
395: end getPersonDetails;
396: --+

Line 393: hr_utility.set_location('Error Message: ' || sqlerrm, 30);

389: hr_utility.set_location('No Data Found Error : ' || g_package||'.'|| l_func ,10);
390: return null;
391: when others then
392: hr_utility.set_location('Error : ' || g_package||'.'|| l_func ,20);
393: hr_utility.set_location('Error Message: ' || sqlerrm, 30);
394: return null;
395: end getPersonDetails;
396: --+
397: --+ getApplicationStatus

Line 417: hr_utility.set_location('No Data Found Error : ' || g_package||'.'|| l_func ,10);

413: close csrApplicationStatus;
414: return l_applicationStatus;
415: exception
416: when no_data_found then
417: hr_utility.set_location('No Data Found Error : ' || g_package||'.'|| l_func ,10);
418: return null;
419: when others then
420: hr_utility.set_location('Error : ' || g_package||'.'|| l_func ,20);
421: hr_utility.set_location('Error Message: ' || sqlerrm, 30);

Line 420: hr_utility.set_location('Error : ' || g_package||'.'|| l_func ,20);

416: when no_data_found then
417: hr_utility.set_location('No Data Found Error : ' || g_package||'.'|| l_func ,10);
418: return null;
419: when others then
420: hr_utility.set_location('Error : ' || g_package||'.'|| l_func ,20);
421: hr_utility.set_location('Error Message: ' || sqlerrm, 30);
422: return null;
423: end getApplicationStatus;
424: --+

Line 421: hr_utility.set_location('Error Message: ' || sqlerrm, 30);

417: hr_utility.set_location('No Data Found Error : ' || g_package||'.'|| l_func ,10);
418: return null;
419: when others then
420: hr_utility.set_location('Error : ' || g_package||'.'|| l_func ,20);
421: hr_utility.set_location('Error Message: ' || sqlerrm, 30);
422: return null;
423: end getApplicationStatus;
424: --+
425: --+ getInterviewStatusMeaning

Line 447: hr_utility.set_location('No Data Found Error : ' || g_package||'.'|| l_func ,10);

443: close csrInterviewStatusMeaning;
444: return l_interviewStatusMeaning;
445: exception
446: when no_data_found then
447: hr_utility.set_location('No Data Found Error : ' || g_package||'.'|| l_func ,10);
448: return null;
449: when others then
450: hr_utility.set_location('Error : ' || g_package||'.'|| l_func ,20);
451: hr_utility.set_location('Error Message: ' || sqlerrm, 30);

Line 450: hr_utility.set_location('Error : ' || g_package||'.'|| l_func ,20);

446: when no_data_found then
447: hr_utility.set_location('No Data Found Error : ' || g_package||'.'|| l_func ,10);
448: return null;
449: when others then
450: hr_utility.set_location('Error : ' || g_package||'.'|| l_func ,20);
451: hr_utility.set_location('Error Message: ' || sqlerrm, 30);
452: return null;
453: end getInterviewStatusMeaning;
454: --+

Line 451: hr_utility.set_location('Error Message: ' || sqlerrm, 30);

447: hr_utility.set_location('No Data Found Error : ' || g_package||'.'|| l_func ,10);
448: return null;
449: when others then
450: hr_utility.set_location('Error : ' || g_package||'.'|| l_func ,20);
451: hr_utility.set_location('Error Message: ' || sqlerrm, 30);
452: return null;
453: end getInterviewStatusMeaning;
454: --+
455: --+ getInterviersNamesHTML

Line 479: hr_utility.set_location('No Data Found Error : ' || g_package||'.'|| l_func ,10);

475: end loop;
476: return 'IRC_INTERVIEWER_NAMES:

' || l_interviewersName || ';';
477: exception
478: when no_data_found then
479: hr_utility.set_location('No Data Found Error : ' || g_package||'.'|| l_func ,10);
480: return null;
481: when others then
482: hr_utility.set_location('Error : ' || g_package||'.'|| l_func ,20);
483: hr_utility.set_location('Error Message: ' || sqlerrm, 30);

Line 482: hr_utility.set_location('Error : ' || g_package||'.'|| l_func ,20);

478: when no_data_found then
479: hr_utility.set_location('No Data Found Error : ' || g_package||'.'|| l_func ,10);
480: return null;
481: when others then
482: hr_utility.set_location('Error : ' || g_package||'.'|| l_func ,20);
483: hr_utility.set_location('Error Message: ' || sqlerrm, 30);
484: return null;
485: end getInterviersNamesHTML;
486: --+

Line 483: hr_utility.set_location('Error Message: ' || sqlerrm, 30);

479: hr_utility.set_location('No Data Found Error : ' || g_package||'.'|| l_func ,10);
480: return null;
481: when others then
482: hr_utility.set_location('Error : ' || g_package||'.'|| l_func ,20);
483: hr_utility.set_location('Error Message: ' || sqlerrm, 30);
484: return null;
485: end getInterviersNamesHTML;
486: --+
487: end IRC_NOTIFICATION_DATA_PKG;