DBA Data[Home] [Help]

APPS.PER_VACANCIES_PKG dependencies on HR_UTILITY

Line 111: hr_utility.raise_error;

107: FETCH c_check_references1 into V_name;
108: IF c_check_references1%FOUND THEN
109: CLOSE c_check_references1;
110: fnd_message.set_name('PER','HR_6125_REQS_VACS_DEL_ASSIGN');
111: hr_utility.raise_error;
112: ELSE CLOSE c_check_references1;
113: END IF;
114: --
115: OPEN c_check_ref_2;

Line 121: hr_utility.raise_error;

117: IF c_check_ref_2%FOUND THEN
118: CLOSE c_check_ref_2;
119: fnd_message.set_name('PER','HR_6126_REQS_VACS_DEL_REC_ACTY');
120: fnd_message.set_token('VACANCY_NAME',V_name);
121: hr_utility.raise_error;
122: ELSE CLOSE c_check_ref_2;
123: END IF;
124: --
125: END Check_References;

Line 261: hr_utility.raise_error;

257:
258: if csr_appl_exists%found then
259: close csr_appl_exists;
260: fnd_message.set_name('PER','HR_449819_VACS_APL_ACTS');
261: hr_utility.raise_error;
262: else
263: close csr_appl_exists;
264: end if;
265:

Line 297: hr_utility.raise_error;

293: IF name_exists%found THEN
294: CLOSE name_exists;
295: fnd_message.set_name('PER', 'HR_6638_VACS_UNIQUE_VAC_NAME');
296: fnd_message.set_token('REQ_NAME',v_req_name);
297: hr_utility.raise_error;
298: ELSE CLOSE name_exists;
299: END IF;
300: END Check_Unique_Name;
301: --

Line 332: hr_utility.raise_error;

328: FETCH c_check_in_req_dates into v_dummy;
329: IF c_check_in_req_dates%found THEN
330: CLOSE c_check_in_req_dates;
331: fnd_message.set_name('PER', 'HR_6640_VACS_IN_REQ_DATES');
332: hr_utility.raise_error;
333: ELSE CLOSE c_check_in_req_dates;
334: END IF;
335: END Check_in_req_dates;
336: --

Line 367: hr_utility.raise_error;

363: FETCH c_in_req_dt into v_dummy;
364: IF c_in_req_dt%found THEN
365: CLOSE c_in_req_dt;
366: fnd_message.set_name('PER','HR_6843_VACS_DATE_TO_VAC');
367: hr_utility.raise_error;
368: ELSE CLOSE c_in_req_dt;
369: END IF;
370: END Chk_dt_to_in_req_dates;
371: --

Line 482: hr_utility.raise_error;

478: FETCH c_rec_act_chk into v_dummy;
479: IF c_rec_act_chk%found THEN
480: CLOSE c_rec_act_chk;
481: fnd_message.set_name('PER','HR_6641_VACS_REC_ACTS');
482: hr_utility.raise_error;
483: ELSE CLOSE c_rec_act_chk;
484: END IF;
485: --
486: END D_from_updt_rec_act_chk;

Line 519: hr_utility.raise_error;

515: IF c_org_chk%found THEN
516: CLOSE c_org_chk;
517: fnd_message.set_name('PER','HR_6188_REQS_VACS_DATE_FROM');
518: fnd_message.set_token('PART','organization');
519: hr_utility.raise_error;
520: ELSE CLOSE c_org_chk;
521: END IF;
522: --
523: END D_from_updt_org_chk;

Line 559: hr_utility.raise_error;

555: IF c_org_chk%found THEN
556: CLOSE c_org_chk;
557: fnd_message.set_name('PER',' HR_289199_ORG_VACS_DATE_TO');
558: fnd_message.set_token('DATE',v_date);
559: hr_utility.raise_error;
560: ELSE CLOSE c_org_chk;
561: END IF;
562: --
563: END D_to_updt_org_chk;

Line 596: hr_utility.raise_error;

592: IF c_pos_chk%found THEN
593: CLOSE c_pos_chk;
594: fnd_message.set_name('PER','HR_6188_REQS_VACS_DATE_FROM');
595: fnd_message.set_token('PART','position');
596: hr_utility.raise_error;
597: ELSE CLOSE c_pos_chk;
598: END IF;
599: END D_from_updt_pos_chk;
600: --

Line 632: hr_utility.raise_error;

628: IF c_grp_chk%found THEN
629: CLOSE c_grp_chk;
630: fnd_message.set_name('PER','HR_6188_REQS_VACS_DATE_FROM');
631: fnd_message.set_token('PART','group');
632: hr_utility.raise_error;
633: ELSE CLOSE c_grp_chk;
634: END IF;
635: END D_from_updt_grp_chk;
636: --

Line 668: hr_utility.raise_error;

664: IF c_job_chk%found THEN
665: CLOSE c_job_chk;
666: fnd_message.set_name('PER','HR_6188_REQS_VACS_DATE_FROM');
667: fnd_message.set_token('PART','job');
668: hr_utility.raise_error;
669: ELSE CLOSE c_job_chk;
670: END IF;
671: END D_from_updt_job_chk;
672: --

Line 704: hr_utility.raise_error;

700: IF c_grade_chk%found THEN
701: CLOSE c_grade_chk;
702: fnd_message.set_name('PER','HR_6188_REQS_VACS_DATE_FROM');
703: fnd_message.set_token('PART','grade');
704: hr_utility.raise_error;
705: ELSE CLOSE c_grade_chk;
706: END IF;
707: END D_from_updt_grd_chk;
708: --

Line 739: hr_utility.raise_error;

735: IF c_loc_chk%found THEN
736: CLOSE c_loc_chk;
737: fnd_message.set_name('PER','HR_6188_REQS_VACS_DATE_FROM');
738: fnd_message.set_token('PART','location');
739: hr_utility.raise_error;
740: ELSE CLOSE c_loc_chk;
741: END IF;
742: END D_from_updt_loc_chk;
743: --

Line 778: hr_utility.raise_error;

774: FETCH c_person into v_dummy;
775: IF c_person%notfound THEN
776: CLOSE c_person;
777: fnd_message.set_name('PER','HR_6642_VACS_RECRUITER');
778: hr_utility.raise_error;
779: ELSE CLOSE c_person;
780: END IF;
781: END D_from_updt_person;
782: --

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

953: OPEN C;
954: FETCH C INTO X_Rowid;
955: if (C%NOTFOUND) then
956: CLOSE C;
957: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
958: hr_utility.set_message_token('PROCEDURE',
959: 'per_vacancies_pkg.insert_row');
960: hr_utility.set_message_token('STEP','1');
961: hr_utility.raise_error;

Line 958: hr_utility.set_message_token('PROCEDURE',

954: FETCH C INTO X_Rowid;
955: if (C%NOTFOUND) then
956: CLOSE C;
957: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
958: hr_utility.set_message_token('PROCEDURE',
959: 'per_vacancies_pkg.insert_row');
960: hr_utility.set_message_token('STEP','1');
961: hr_utility.raise_error;
962: end if;

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

956: CLOSE C;
957: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
958: hr_utility.set_message_token('PROCEDURE',
959: 'per_vacancies_pkg.insert_row');
960: hr_utility.set_message_token('STEP','1');
961: hr_utility.raise_error;
962: end if;
963: CLOSE C;
964: --

Line 961: hr_utility.raise_error;

957: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
958: hr_utility.set_message_token('PROCEDURE',
959: 'per_vacancies_pkg.insert_row');
960: hr_utility.set_message_token('STEP','1');
961: hr_utility.raise_error;
962: end if;
963: CLOSE C;
964: --
965: per_applicant_pkg.update_group ( x_people_group_id,

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

1030: OPEN C;
1031: FETCH C INTO g_Recinfo;
1032: if (C%NOTFOUND) then
1033: CLOSE C;
1034: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
1035: hr_utility.set_message_token('PROCEDURE',
1036: 'per_vacancies_pkb.lock_row');
1037: hr_utility.set_message_token('STEP','1');
1038: hr_utility.raise_error;

Line 1035: hr_utility.set_message_token('PROCEDURE',

1031: FETCH C INTO g_Recinfo;
1032: if (C%NOTFOUND) then
1033: CLOSE C;
1034: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
1035: hr_utility.set_message_token('PROCEDURE',
1036: 'per_vacancies_pkb.lock_row');
1037: hr_utility.set_message_token('STEP','1');
1038: hr_utility.raise_error;
1039: end if;

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

1033: CLOSE C;
1034: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
1035: hr_utility.set_message_token('PROCEDURE',
1036: 'per_vacancies_pkb.lock_row');
1037: hr_utility.set_message_token('STEP','1');
1038: hr_utility.raise_error;
1039: end if;
1040: CLOSE C;
1041: --

Line 1038: hr_utility.raise_error;

1034: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
1035: hr_utility.set_message_token('PROCEDURE',
1036: 'per_vacancies_pkb.lock_row');
1037: hr_utility.set_message_token('STEP','1');
1038: hr_utility.raise_error;
1039: end if;
1040: CLOSE C;
1041: --
1042: g_Recinfo.attribute18 := rtrim(g_Recinfo.attribute18);

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

1308: attribute20 = X_Attribute20
1309: WHERE rowid = X_rowid;
1310:
1311: if (SQL%NOTFOUND) then
1312: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
1313: hr_utility.set_message_token('PROCEDURE',
1314: 'per_vacancies_pkb.update_row');
1315: hr_utility.set_message_token('STEP','1');
1316: hr_utility.raise_error;

Line 1313: hr_utility.set_message_token('PROCEDURE',

1309: WHERE rowid = X_rowid;
1310:
1311: if (SQL%NOTFOUND) then
1312: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
1313: hr_utility.set_message_token('PROCEDURE',
1314: 'per_vacancies_pkb.update_row');
1315: hr_utility.set_message_token('STEP','1');
1316: hr_utility.raise_error;
1317: end if;

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

1311: if (SQL%NOTFOUND) then
1312: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
1313: hr_utility.set_message_token('PROCEDURE',
1314: 'per_vacancies_pkb.update_row');
1315: hr_utility.set_message_token('STEP','1');
1316: hr_utility.raise_error;
1317: end if;
1318:
1319:

Line 1316: hr_utility.raise_error;

1312: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
1313: hr_utility.set_message_token('PROCEDURE',
1314: 'per_vacancies_pkb.update_row');
1315: hr_utility.set_message_token('STEP','1');
1316: hr_utility.raise_error;
1317: end if;
1318:
1319:
1320: -- Cascade changes to applicants