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

Line 66: hr_utility.set_message(801, 'HR_6113_RAC_EXISTS');

62: OPEN name_exists;
63: FETCH name_exists INTO v_dummy;
64: IF name_exists%found THEN
65: CLOSE name_exists;
66: hr_utility.set_message(801, 'HR_6113_RAC_EXISTS');
67: hr_utility.raise_error;
68: ELSe CLOSE name_exists;
69: END IF;
70: END Check_Unique_Name;

Line 67: hr_utility.raise_error;

63: FETCH name_exists INTO v_dummy;
64: IF name_exists%found THEN
65: CLOSE name_exists;
66: hr_utility.set_message(801, 'HR_6113_RAC_EXISTS');
67: hr_utility.raise_error;
68: ELSe CLOSE name_exists;
69: END IF;
70: END Check_Unique_Name;
71: --

Line 125: hr_utility.set_message(800,'HR_6682_RAC_RECRUIT_ASG_EXIST');

121: P_Business_group_id);
122: FETCH csr_asg into v_dummy_id;
123: IF csr_asg%found then
124: CLOSE csr_asg;
125: hr_utility.set_message(800,'HR_6682_RAC_RECRUIT_ASG_EXIST');
126: hr_utility.raise_error;
127: ELSE
128: CLOSE csr_asg;
129: END IF;

Line 126: hr_utility.raise_error;

122: FETCH csr_asg into v_dummy_id;
123: IF csr_asg%found then
124: CLOSE csr_asg;
125: hr_utility.set_message(800,'HR_6682_RAC_RECRUIT_ASG_EXIST');
126: hr_utility.raise_error;
127: ELSE
128: CLOSE csr_asg;
129: END IF;
130: --

Line 137: hr_utility.set_message(800,'HR_6111_RAC_RECRUIT_SUB_ACTS');

133: P_Business_group_id);
134: FETCH csr_rec_acts into v_dummy_id;
135: IF csr_rec_acts%found then
136: CLOSE csr_rec_acts;
137: hr_utility.set_message(800,'HR_6111_RAC_RECRUIT_SUB_ACTS');
138: hr_utility.raise_error;
139: ELSE
140: CLOSE csr_rec_acts;
141: END IF;

Line 138: hr_utility.raise_error;

134: FETCH csr_rec_acts into v_dummy_id;
135: IF csr_rec_acts%found then
136: CLOSE csr_rec_acts;
137: hr_utility.set_message(800,'HR_6111_RAC_RECRUIT_SUB_ACTS');
138: hr_utility.raise_error;
139: ELSE
140: CLOSE csr_rec_acts;
141: END IF;
142: --

Line 182: hr_utility.set_message(800,'HR_6122_RAC_ORG_NOT_VALID');

178: OPEN csr_org_dates;
179: FETCH csr_org_dates into v_dummy_id;
180: IF csr_org_dates%notfound then
181: CLOSE csr_org_dates;
182: hr_utility.set_message(800,'HR_6122_RAC_ORG_NOT_VALID');
183: hr_utility.raise_error;
184: ELSE
185: CLOSE csr_org_dates;
186: END IF;

Line 183: hr_utility.raise_error;

179: FETCH csr_org_dates into v_dummy_id;
180: IF csr_org_dates%notfound then
181: CLOSE csr_org_dates;
182: hr_utility.set_message(800,'HR_6122_RAC_ORG_NOT_VALID');
183: hr_utility.raise_error;
184: ELSE
185: CLOSE csr_org_dates;
186: END IF;
187: --

Line 228: hr_utility.set_message(800,'HR_7697_RAC_PER_NOT_VALID');

224: OPEN csr_auth_date;
225: FETCH csr_auth_date into v_dummy_id;
226: IF csr_auth_date%notfound then
227: CLOSE csr_auth_date;
228: hr_utility.set_message(800,'HR_7697_RAC_PER_NOT_VALID');
229: hr_utility.raise_error;
230: ELSE
231: CLOSE csr_auth_date;
232: END IF;

Line 229: hr_utility.raise_error;

225: FETCH csr_auth_date into v_dummy_id;
226: IF csr_auth_date%notfound then
227: CLOSE csr_auth_date;
228: hr_utility.set_message(800,'HR_7697_RAC_PER_NOT_VALID');
229: hr_utility.raise_error;
230: ELSE
231: CLOSE csr_auth_date;
232: END IF;
233: --

Line 274: hr_utility.set_message(800,'HR_7696_RAC_PER_NOT_VALID');

270: OPEN csr_int_con_date;
271: FETCH csr_int_con_date into v_dummy_id;
272: IF csr_int_con_date%notfound then
273: CLOSE csr_int_con_date;
274: hr_utility.set_message(800,'HR_7696_RAC_PER_NOT_VALID');
275: hr_utility.raise_error;
276: ELSE
277: CLOSE csr_int_con_date;
278: END IF;

Line 275: hr_utility.raise_error;

271: FETCH csr_int_con_date into v_dummy_id;
272: IF csr_int_con_date%notfound then
273: CLOSE csr_int_con_date;
274: hr_utility.set_message(800,'HR_7696_RAC_PER_NOT_VALID');
275: hr_utility.raise_error;
276: ELSE
277: CLOSE csr_int_con_date;
278: END IF;
279: --

Line 316: hr_utility.set_message(800,'HR_6461_RAC_PARENT_RAC_INVALID');

312: OPEN csr_par_rec_dates;
313: FETCH csr_par_rec_dates into v_dummy_id;
314: IF csr_par_rec_dates%notfound then
315: CLOSE csr_par_rec_dates;
316: hr_utility.set_message(800,'HR_6461_RAC_PARENT_RAC_INVALID');
317: hr_utility.raise_error;
318: ELSE
319: CLOSE csr_par_rec_dates;
320: END IF;

Line 317: hr_utility.raise_error;

313: FETCH csr_par_rec_dates into v_dummy_id;
314: IF csr_par_rec_dates%notfound then
315: CLOSE csr_par_rec_dates;
316: hr_utility.set_message(800,'HR_6461_RAC_PARENT_RAC_INVALID');
317: hr_utility.raise_error;
318: ELSE
319: CLOSE csr_par_rec_dates;
320: END IF;
321: --

Line 359: hr_utility.set_message(800,'HR_6121_RAC_VACANCY_NOT_VALID');

355: OPEN csr_vac_dates;
356: FETCH csr_vac_dates into v_dummy_id;
357: IF csr_vac_dates%found then
358: CLOSE csr_vac_dates;
359: hr_utility.set_message(800,'HR_6121_RAC_VACANCY_NOT_VALID');
360: hr_utility.raise_error;
361: ELSE
362: CLOSE csr_vac_dates;
363: END IF;

Line 360: hr_utility.raise_error;

356: FETCH csr_vac_dates into v_dummy_id;
357: IF csr_vac_dates%found then
358: CLOSE csr_vac_dates;
359: hr_utility.set_message(800,'HR_6121_RAC_VACANCY_NOT_VALID');
360: hr_utility.raise_error;
361: ELSE
362: CLOSE csr_vac_dates;
363: END IF;
364: --

Line 412: hr_utility.set_message(800,'HR_6621_RAC_CHILD_BEFORE_RAC');

408: OPEN csr_child_dates;
409: FETCH csr_child_dates into v_dummy_id;
410: IF csr_child_dates%found then
411: CLOSE csr_child_dates;
412: hr_utility.set_message(800,'HR_6621_RAC_CHILD_BEFORE_RAC');
413: hr_utility.raise_error;
414: ELSE
415: CLOSE csr_child_dates;
416: END IF;

Line 413: hr_utility.raise_error;

409: FETCH csr_child_dates into v_dummy_id;
410: IF csr_child_dates%found then
411: CLOSE csr_child_dates;
412: hr_utility.set_message(800,'HR_6621_RAC_CHILD_BEFORE_RAC');
413: hr_utility.raise_error;
414: ELSE
415: CLOSE csr_child_dates;
416: END IF;
417: END IF;

Line 466: hr_utility.set_message(800,'HR_6622_RAC_CHILD_AFTER_RAC');

462: OPEN csr_child_dates;
463: FETCH csr_child_dates into v_dummy_id;
464: IF csr_child_dates%found then
465: CLOSE csr_child_dates;
466: hr_utility.set_message(800,'HR_6622_RAC_CHILD_AFTER_RAC');
467: hr_utility.raise_error;
468: ELSE
469: CLOSE csr_child_dates;
470: END IF;

Line 467: hr_utility.raise_error;

463: FETCH csr_child_dates into v_dummy_id;
464: IF csr_child_dates%found then
465: CLOSE csr_child_dates;
466: hr_utility.set_message(800,'HR_6622_RAC_CHILD_AFTER_RAC');
467: hr_utility.raise_error;
468: ELSE
469: CLOSE csr_child_dates;
470: END IF;
471: END IF;

Line 658: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');

654: OPEN C;
655: FETCH C INTO X_Rowid;
656: IF (C%NOTFOUND) then
657: CLOSE C;
658: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
659: hr_utility.set_message_token('PROCEDURE',
660: 'per_recruitment_activity_pkg.insert_row');
661: hr_utility.set_message_token('STEP','1');
662: hr_utility.raise_error;

Line 659: hr_utility.set_message_token('PROCEDURE',

655: FETCH C INTO X_Rowid;
656: IF (C%NOTFOUND) then
657: CLOSE C;
658: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
659: hr_utility.set_message_token('PROCEDURE',
660: 'per_recruitment_activity_pkg.insert_row');
661: hr_utility.set_message_token('STEP','1');
662: hr_utility.raise_error;
663: end IF;

Line 661: hr_utility.set_message_token('STEP','1');

657: CLOSE C;
658: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
659: hr_utility.set_message_token('PROCEDURE',
660: 'per_recruitment_activity_pkg.insert_row');
661: hr_utility.set_message_token('STEP','1');
662: hr_utility.raise_error;
663: end IF;
664: CLOSE C;
665:

Line 662: hr_utility.raise_error;

658: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
659: hr_utility.set_message_token('PROCEDURE',
660: 'per_recruitment_activity_pkg.insert_row');
661: hr_utility.set_message_token('STEP','1');
662: hr_utility.raise_error;
663: end IF;
664: CLOSE C;
665:
666: END Insert_Row;

Line 732: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');

728: OPEN C;
729: FETCH C INTO Recinfo;
730: IF (C%NOTFOUND) then
731: CLOSE C;
732: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
733: hr_utility.set_message_token('PROCEDURE',
734: 'per_recruitment_activity_pkg.lock_row');
735: hr_utility.set_message_token('STEP','1');
736: hr_utility.raise_error;

Line 733: hr_utility.set_message_token('PROCEDURE',

729: FETCH C INTO Recinfo;
730: IF (C%NOTFOUND) then
731: CLOSE C;
732: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
733: hr_utility.set_message_token('PROCEDURE',
734: 'per_recruitment_activity_pkg.lock_row');
735: hr_utility.set_message_token('STEP','1');
736: hr_utility.raise_error;
737: end IF;

Line 735: hr_utility.set_message_token('STEP','1');

731: CLOSE C;
732: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
733: hr_utility.set_message_token('PROCEDURE',
734: 'per_recruitment_activity_pkg.lock_row');
735: hr_utility.set_message_token('STEP','1');
736: hr_utility.raise_error;
737: end IF;
738: CLOSE C;
739: --

Line 736: hr_utility.raise_error;

732: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
733: hr_utility.set_message_token('PROCEDURE',
734: 'per_recruitment_activity_pkg.lock_row');
735: hr_utility.set_message_token('STEP','1');
736: hr_utility.raise_error;
737: end IF;
738: CLOSE C;
739: --
740: -- Change needed to remove trailing spaces.

Line 994: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');

990: attribute20 = X_Attribute20
991: WHERE rowid = X_rowid;
992:
993: IF (SQL%NOTFOUND) then
994: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
995: hr_utility.set_message_token('PROCEDURE',
996: 'per_recruitment_activities_pkg.update_row');
997: hr_utility.set_message_token('STEP','1');
998: hr_utility.raise_error;

Line 995: hr_utility.set_message_token('PROCEDURE',

991: WHERE rowid = X_rowid;
992:
993: IF (SQL%NOTFOUND) then
994: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
995: hr_utility.set_message_token('PROCEDURE',
996: 'per_recruitment_activities_pkg.update_row');
997: hr_utility.set_message_token('STEP','1');
998: hr_utility.raise_error;
999: end IF;

Line 997: hr_utility.set_message_token('STEP','1');

993: IF (SQL%NOTFOUND) then
994: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
995: hr_utility.set_message_token('PROCEDURE',
996: 'per_recruitment_activities_pkg.update_row');
997: hr_utility.set_message_token('STEP','1');
998: hr_utility.raise_error;
999: end IF;
1000:
1001: END Update_Row;

Line 998: hr_utility.raise_error;

994: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
995: hr_utility.set_message_token('PROCEDURE',
996: 'per_recruitment_activities_pkg.update_row');
997: hr_utility.set_message_token('STEP','1');
998: hr_utility.raise_error;
999: end IF;
1000:
1001: END Update_Row;
1002: --

Line 1021: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');

1017: DELETE FROM PER_RECRUITMENT_ACTIVITIES
1018: WHERE rowid = X_Rowid;
1019:
1020: IF (SQL%NOTFOUND) then
1021: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
1022: hr_utility.set_message_token('PROCEDURE',
1023: 'per_recruitment_activites_pkg.delete_row');
1024: hr_utility.set_message_token('STEP','1');
1025: hr_utility.raise_error;

Line 1022: hr_utility.set_message_token('PROCEDURE',

1018: WHERE rowid = X_Rowid;
1019:
1020: IF (SQL%NOTFOUND) then
1021: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
1022: hr_utility.set_message_token('PROCEDURE',
1023: 'per_recruitment_activites_pkg.delete_row');
1024: hr_utility.set_message_token('STEP','1');
1025: hr_utility.raise_error;
1026: end IF;

Line 1024: hr_utility.set_message_token('STEP','1');

1020: IF (SQL%NOTFOUND) then
1021: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
1022: hr_utility.set_message_token('PROCEDURE',
1023: 'per_recruitment_activites_pkg.delete_row');
1024: hr_utility.set_message_token('STEP','1');
1025: hr_utility.raise_error;
1026: end IF;
1027: END Delete_Row;
1028:

Line 1025: hr_utility.raise_error;

1021: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
1022: hr_utility.set_message_token('PROCEDURE',
1023: 'per_recruitment_activites_pkg.delete_row');
1024: hr_utility.set_message_token('STEP','1');
1025: hr_utility.raise_error;
1026: end IF;
1027: END Delete_Row;
1028:
1029: END PER_RECRUITMENT_ACTIVITIES_PKG;