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 89: hr_utility.set_location('No Data Found Error : ' || g_package||'.'|| l_func ,10);

85: close csrCandidateId;
86: return l_candidateId;
87: exception
88: when no_data_found then
89: hr_utility.set_location('No Data Found Error : ' || g_package||'.'|| l_func ,10);
90: return null;
91: when others then
92: hr_utility.set_location('Error : ' || g_package||'.'|| l_func ,20);
93: hr_utility.set_location('Error Message: ' || sqlerrm, 30);

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

88: when no_data_found then
89: hr_utility.set_location('No Data Found Error : ' || g_package||'.'|| l_func ,10);
90: return null;
91: when others then
92: hr_utility.set_location('Error : ' || g_package||'.'|| l_func ,20);
93: hr_utility.set_location('Error Message: ' || sqlerrm, 30);
94: return null;
95: end getCandidatePersonId;
96: --+

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

89: hr_utility.set_location('No Data Found Error : ' || g_package||'.'|| l_func ,10);
90: return null;
91: when others then
92: hr_utility.set_location('Error : ' || g_package||'.'|| l_func ,20);
93: hr_utility.set_location('Error Message: ' || sqlerrm, 30);
94: return null;
95: end getCandidatePersonId;
96: --+
97: --+

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

118: close csrCandidateAgencyId;
119: return l_candidateAgencyId;
120: exception
121: when no_data_found then
122: hr_utility.set_location('No Data Found Error : ' || g_package||'.'|| l_func ,10);
123: return null;
124: when others then
125: hr_utility.set_location('Error : ' || g_package||'.'|| l_func ,20);
126: hr_utility.set_location('Error Message: ' || sqlerrm, 30);

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

121: when no_data_found then
122: hr_utility.set_location('No Data Found Error : ' || g_package||'.'|| l_func ,10);
123: return null;
124: when others then
125: hr_utility.set_location('Error : ' || g_package||'.'|| l_func ,20);
126: hr_utility.set_location('Error Message: ' || sqlerrm, 30);
127: return null;
128: end getCandidateAgencyId;
129: --+

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

122: hr_utility.set_location('No Data Found Error : ' || g_package||'.'|| l_func ,10);
123: return null;
124: when others then
125: hr_utility.set_location('Error : ' || g_package||'.'|| l_func ,20);
126: hr_utility.set_location('Error Message: ' || sqlerrm, 30);
127: return null;
128: end getCandidateAgencyId;
129: --+
130: --+ getManagerPersonId

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

146: close csrManagerId;
147: return l_managerId;
148: exception
149: when no_data_found then
150: hr_utility.set_location('No Data Found Error : ' || g_package||'.'|| l_func ,10);
151: return null;
152: when others then
153: hr_utility.set_location('Error : ' || g_package||'.'|| l_func ,20);
154: hr_utility.set_location('Error Message: ' || sqlerrm, 30);

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

149: when no_data_found then
150: hr_utility.set_location('No Data Found Error : ' || g_package||'.'|| l_func ,10);
151: return null;
152: when others then
153: hr_utility.set_location('Error : ' || g_package||'.'|| l_func ,20);
154: hr_utility.set_location('Error Message: ' || sqlerrm, 30);
155: return null;
156: end getManagerPersonId;
157: --+

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

150: hr_utility.set_location('No Data Found Error : ' || g_package||'.'|| l_func ,10);
151: return null;
152: when others then
153: hr_utility.set_location('Error : ' || g_package||'.'|| l_func ,20);
154: hr_utility.set_location('Error Message: ' || sqlerrm, 30);
155: return null;
156: end getManagerPersonId;
157: --+
158: --+ getRecruiterPersonId

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

174: close csrRecruiterId;
175: return l_recruiterId;
176: exception
177: when no_data_found then
178: hr_utility.set_location('No Data Found Error : ' || g_package||'.'|| l_func ,10);
179: return null;
180: when others then
181: hr_utility.set_location('Error : ' || g_package||'.'|| l_func ,20);
182: hr_utility.set_location('Error Message: ' || sqlerrm, 30);

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

177: when no_data_found then
178: hr_utility.set_location('No Data Found Error : ' || g_package||'.'|| l_func ,10);
179: return null;
180: when others then
181: hr_utility.set_location('Error : ' || g_package||'.'|| l_func ,20);
182: hr_utility.set_location('Error Message: ' || sqlerrm, 30);
183: return null;
184: end getRecruiterPersonId;
185: --+

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

178: hr_utility.set_location('No Data Found Error : ' || g_package||'.'|| l_func ,10);
179: return null;
180: when others then
181: hr_utility.set_location('Error : ' || g_package||'.'|| l_func ,20);
182: hr_utility.set_location('Error Message: ' || sqlerrm, 30);
183: return null;
184: end getRecruiterPersonId;
185: --+
186: --+ getVacancyDetails

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

229: close csrVacancyDetails;
230: return l_vacancyDetails;
231: exception
232: when no_data_found then
233: hr_utility.set_location('No Data Found Error : ' || g_package||'.'|| l_func ,10);
234: return null;
235: when others then
236: hr_utility.set_location('Error : ' || g_package||'.'|| l_func ,20);
237: hr_utility.set_location('Error Message: ' || sqlerrm, 30);

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

232: when no_data_found then
233: hr_utility.set_location('No Data Found Error : ' || g_package||'.'|| l_func ,10);
234: return null;
235: when others then
236: hr_utility.set_location('Error : ' || g_package||'.'|| l_func ,20);
237: hr_utility.set_location('Error Message: ' || sqlerrm, 30);
238: return null;
239: end getVacancyDetails;
240: --+

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

233: hr_utility.set_location('No Data Found Error : ' || g_package||'.'|| l_func ,10);
234: return null;
235: when others then
236: hr_utility.set_location('Error : ' || g_package||'.'|| l_func ,20);
237: hr_utility.set_location('Error Message: ' || sqlerrm, 30);
238: return null;
239: end getVacancyDetails;
240: --+
241: --+ getCommTopicDetailsFromTopicId

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

287: end if;
288:
289: exception
290: when no_data_found then
291: hr_utility.set_location('No Data Found Error : ' || g_package||'.'|| l_func ,10);
292: return null;
293: when others then
294: hr_utility.set_location('Error : ' || g_package||'.'|| l_func ,20);
295: hr_utility.set_location('Error Message: ' || sqlerrm, 30);

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

290: when no_data_found then
291: hr_utility.set_location('No Data Found Error : ' || g_package||'.'|| l_func ,10);
292: return null;
293: when others then
294: hr_utility.set_location('Error : ' || g_package||'.'|| l_func ,20);
295: hr_utility.set_location('Error Message: ' || sqlerrm, 30);
296: return null;
297: end getCommunicationTopicDetails;
298: --+

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

291: hr_utility.set_location('No Data Found Error : ' || g_package||'.'|| l_func ,10);
292: return null;
293: when others then
294: hr_utility.set_location('Error : ' || g_package||'.'|| l_func ,20);
295: hr_utility.set_location('Error Message: ' || sqlerrm, 30);
296: return null;
297: end getCommunicationTopicDetails;
298: --+
299: --+ getInterviewDetails

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

426: return l_interviewDetails||'IRC_INTVW_LOC_ADDRESS:'|| v_message1||';';
427:
428: exception
429: when no_data_found then
430: hr_utility.set_location('No Data Found Error : ' || g_package||'.'|| l_func ,10);
431: return null;
432: when others then
433: hr_utility.set_location('Error : ' || g_package||'.'|| l_func ,20);
434: hr_utility.set_location('Error Message: ' || sqlerrm, 30);

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

429: when no_data_found then
430: hr_utility.set_location('No Data Found Error : ' || g_package||'.'|| l_func ,10);
431: return null;
432: when others then
433: hr_utility.set_location('Error : ' || g_package||'.'|| l_func ,20);
434: hr_utility.set_location('Error Message: ' || sqlerrm, 30);
435: return null;
436: end getInterviewDetails;
437: --+

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

430: hr_utility.set_location('No Data Found Error : ' || g_package||'.'|| l_func ,10);
431: return null;
432: when others then
433: hr_utility.set_location('Error : ' || g_package||'.'|| l_func ,20);
434: hr_utility.set_location('Error Message: ' || sqlerrm, 30);
435: return null;
436: end getInterviewDetails;
437: --+
438: --+ getPersonDetails

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

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

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

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

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

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

Line 509: hr_utility.set_location('Error : ' || g_package||'.'|| l_func_name ,20);

505: close csrApplicationExternalStatus;
506: return l_applicationExtStatus;
507: exception
508: when others then
509: hr_utility.set_location('Error : ' || g_package||'.'|| l_func_name ,20);
510: hr_utility.set_location('Error Message: ' || sqlerrm, 30);
511: if csrApplicationExternalStatus%ISOPEN then
512: close csrApplicationExternalStatus;
513: end if;

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

506: return l_applicationExtStatus;
507: exception
508: when others then
509: hr_utility.set_location('Error : ' || g_package||'.'|| l_func_name ,20);
510: hr_utility.set_location('Error Message: ' || sqlerrm, 30);
511: if csrApplicationExternalStatus%ISOPEN then
512: close csrApplicationExternalStatus;
513: end if;
514: return null;

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

534: close csrApplicationStatus;
535: return l_applicationStatus;
536: exception
537: when no_data_found then
538: hr_utility.set_location('No Data Found Error : ' || g_package||'.'|| l_func ,10);
539: return null;
540: when others then
541: hr_utility.set_location('Error : ' || g_package||'.'|| l_func ,20);
542: hr_utility.set_location('Error Message: ' || sqlerrm, 30);

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

537: when no_data_found then
538: hr_utility.set_location('No Data Found Error : ' || g_package||'.'|| l_func ,10);
539: return null;
540: when others then
541: hr_utility.set_location('Error : ' || g_package||'.'|| l_func ,20);
542: hr_utility.set_location('Error Message: ' || sqlerrm, 30);
543: return null;
544: end getApplicationStatus;
545: --+

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

538: hr_utility.set_location('No Data Found Error : ' || g_package||'.'|| l_func ,10);
539: return null;
540: when others then
541: hr_utility.set_location('Error : ' || g_package||'.'|| l_func ,20);
542: hr_utility.set_location('Error Message: ' || sqlerrm, 30);
543: return null;
544: end getApplicationStatus;
545: --+
546: --+ getInterviewStatusMeaning

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

564: close csrInterviewStatusMeaning;
565: return l_interviewStatusMeaning;
566: exception
567: when no_data_found then
568: hr_utility.set_location('No Data Found Error : ' || g_package||'.'|| l_func ,10);
569: return null;
570: when others then
571: hr_utility.set_location('Error : ' || g_package||'.'|| l_func ,20);
572: hr_utility.set_location('Error Message: ' || sqlerrm, 30);

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

567: when no_data_found then
568: hr_utility.set_location('No Data Found Error : ' || g_package||'.'|| l_func ,10);
569: return null;
570: when others then
571: hr_utility.set_location('Error : ' || g_package||'.'|| l_func ,20);
572: hr_utility.set_location('Error Message: ' || sqlerrm, 30);
573: return null;
574: end getInterviewStatusMeaning;
575:

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

568: hr_utility.set_location('No Data Found Error : ' || g_package||'.'|| l_func ,10);
569: return null;
570: when others then
571: hr_utility.set_location('Error : ' || g_package||'.'|| l_func ,20);
572: hr_utility.set_location('Error Message: ' || sqlerrm, 30);
573: return null;
574: end getInterviewStatusMeaning;
575:
576: --+

Line 595: hr_utility.set_location('Error : ' || g_package||'.'|| l_func_name ,20);

591: close csrApplicationOldExtStatus;
592: return l_applicationOldExtStatus;
593: exception
594: when others then
595: hr_utility.set_location('Error : ' || g_package||'.'|| l_func_name ,20);
596: hr_utility.set_location('Error Message: ' || sqlerrm, 30);
597: if csrApplicationOldExtStatus%ISOPEN then
598: close csrApplicationOldExtStatus;
599: end if;

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

592: return l_applicationOldExtStatus;
593: exception
594: when others then
595: hr_utility.set_location('Error : ' || g_package||'.'|| l_func_name ,20);
596: hr_utility.set_location('Error Message: ' || sqlerrm, 30);
597: if csrApplicationOldExtStatus%ISOPEN then
598: close csrApplicationOldExtStatus;
599: end if;
600: return null;

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

624: end loop;
625: return 'IRC_INTERVIEWER_NAMES:

' || l_interviewersName || ';';
626: exception
627: when no_data_found then
628: hr_utility.set_location('No Data Found Error : ' || g_package||'.'|| l_func ,10);
629: return null;
630: when others then
631: hr_utility.set_location('Error : ' || g_package||'.'|| l_func ,20);
632: hr_utility.set_location('Error Message: ' || sqlerrm, 30);

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

627: when no_data_found then
628: hr_utility.set_location('No Data Found Error : ' || g_package||'.'|| l_func ,10);
629: return null;
630: when others then
631: hr_utility.set_location('Error : ' || g_package||'.'|| l_func ,20);
632: hr_utility.set_location('Error Message: ' || sqlerrm, 30);
633: return null;
634: end getInterviersNamesHTML;
635: --+

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

628: hr_utility.set_location('No Data Found Error : ' || g_package||'.'|| l_func ,10);
629: return null;
630: when others then
631: hr_utility.set_location('Error : ' || g_package||'.'|| l_func ,20);
632: hr_utility.set_location('Error Message: ' || sqlerrm, 30);
633: return null;
634: end getInterviersNamesHTML;
635: --+
636: --