114: OPEN c_check_references1;
115: FETCH c_check_references1 into V_name;
116: IF c_check_references1%FOUND THEN
117: CLOSE c_check_references1;
118: fnd_message.set_name('PER','HR_6125_REQS_VACS_DEL_ASSIGN');
119: hr_utility.raise_error;
120: ELSE CLOSE c_check_references1;
121: END IF;
122: --
123: OPEN c_check_ref_2;
124: FETCH c_check_ref_2 into V_name;
125: IF c_check_ref_2%FOUND THEN
126: CLOSE c_check_ref_2;
127: fnd_message.set_name('PER','HR_6126_REQS_VACS_DEL_REC_ACTY');
128: fnd_message.set_token('VACANCY_NAME',V_name);
129: hr_utility.raise_error;
130: ELSE CLOSE c_check_ref_2;
131: END IF;
124: FETCH c_check_ref_2 into V_name;
125: IF c_check_ref_2%FOUND THEN
126: CLOSE c_check_ref_2;
127: fnd_message.set_name('PER','HR_6126_REQS_VACS_DEL_REC_ACTY');
128: fnd_message.set_token('VACANCY_NAME',V_name);
129: hr_utility.raise_error;
130: ELSE CLOSE c_check_ref_2;
131: END IF;
132: --
264: fetch csr_appl_exists into l_flag;
265:
266: if csr_appl_exists%found then
267: close csr_appl_exists;
268: fnd_message.set_name('PER','HR_449819_VACS_APL_ACTS');
269: hr_utility.raise_error;
270: else
271: close csr_appl_exists;
272: end if;
299: OPEN name_exists;
300: FETCH name_exists into v_req_name;
301: IF name_exists%found THEN
302: CLOSE name_exists;
303: fnd_message.set_name('PER', 'HR_6638_VACS_UNIQUE_VAC_NAME');
304: fnd_message.set_token('REQ_NAME',v_req_name);
305: hr_utility.raise_error;
306: ELSE CLOSE name_exists;
307: END IF;
300: FETCH name_exists into v_req_name;
301: IF name_exists%found THEN
302: CLOSE name_exists;
303: fnd_message.set_name('PER', 'HR_6638_VACS_UNIQUE_VAC_NAME');
304: fnd_message.set_token('REQ_NAME',v_req_name);
305: hr_utility.raise_error;
306: ELSE CLOSE name_exists;
307: END IF;
308: END Check_Unique_Name;
335: OPEN c_check_in_req_dates;
336: FETCH c_check_in_req_dates into v_dummy;
337: IF c_check_in_req_dates%found THEN
338: CLOSE c_check_in_req_dates;
339: fnd_message.set_name('PER', 'HR_6640_VACS_IN_REQ_DATES');
340: hr_utility.raise_error;
341: ELSE CLOSE c_check_in_req_dates;
342: END IF;
343: END Check_in_req_dates;
370: OPEN c_in_req_dt;
371: FETCH c_in_req_dt into v_dummy;
372: IF c_in_req_dt%found THEN
373: CLOSE c_in_req_dt;
374: fnd_message.set_name('PER','HR_6843_VACS_DATE_TO_VAC');
375: hr_utility.raise_error;
376: ELSE CLOSE c_in_req_dt;
377: END IF;
378: END Chk_dt_to_in_req_dates;
488: OPEN c_rec_act_chk;
489: FETCH c_rec_act_chk into v_dummy;
490: IF c_rec_act_chk%found THEN
491: CLOSE c_rec_act_chk;
492: fnd_message.set_name('PER','HR_6641_VACS_REC_ACTS');
493: hr_utility.raise_error;
494: ELSE CLOSE c_rec_act_chk;
495: END IF;
496: */
526: OPEN c_org_chk;
527: FETCH c_org_chk into v_dummy;
528: IF c_org_chk%found THEN
529: CLOSE c_org_chk;
530: fnd_message.set_name('PER','HR_6188_REQS_VACS_DATE_FROM');
531: fnd_message.set_token('PART','organization');
532: hr_utility.raise_error;
533: ELSE CLOSE c_org_chk;
534: END IF;
527: FETCH c_org_chk into v_dummy;
528: IF c_org_chk%found THEN
529: CLOSE c_org_chk;
530: fnd_message.set_name('PER','HR_6188_REQS_VACS_DATE_FROM');
531: fnd_message.set_token('PART','organization');
532: hr_utility.raise_error;
533: ELSE CLOSE c_org_chk;
534: END IF;
535: --
566: FETCH c_org_chk into v_date;
567:
568: IF c_org_chk%found THEN
569: CLOSE c_org_chk;
570: fnd_message.set_name('PER',' HR_289199_ORG_VACS_DATE_TO');
571: fnd_message.set_token('DATE',v_date);
572: hr_utility.raise_error;
573: ELSE CLOSE c_org_chk;
574: END IF;
567:
568: IF c_org_chk%found THEN
569: CLOSE c_org_chk;
570: fnd_message.set_name('PER',' HR_289199_ORG_VACS_DATE_TO');
571: fnd_message.set_token('DATE',v_date);
572: hr_utility.raise_error;
573: ELSE CLOSE c_org_chk;
574: END IF;
575: --
603: OPEN c_pos_chk;
604: FETCH c_pos_chk into v_dummy;
605: IF c_pos_chk%found THEN
606: CLOSE c_pos_chk;
607: fnd_message.set_name('PER','HR_6188_REQS_VACS_DATE_FROM');
608: fnd_message.set_token('PART','position');
609: hr_utility.raise_error;
610: ELSE CLOSE c_pos_chk;
611: END IF;
604: FETCH c_pos_chk into v_dummy;
605: IF c_pos_chk%found THEN
606: CLOSE c_pos_chk;
607: fnd_message.set_name('PER','HR_6188_REQS_VACS_DATE_FROM');
608: fnd_message.set_token('PART','position');
609: hr_utility.raise_error;
610: ELSE CLOSE c_pos_chk;
611: END IF;
612: END D_from_updt_pos_chk;
639: OPEN c_grp_chk;
640: FETCH c_grp_chk into v_dummy;
641: IF c_grp_chk%found THEN
642: CLOSE c_grp_chk;
643: fnd_message.set_name('PER','HR_6188_REQS_VACS_DATE_FROM');
644: fnd_message.set_token('PART','group');
645: hr_utility.raise_error;
646: ELSE CLOSE c_grp_chk;
647: END IF;
640: FETCH c_grp_chk into v_dummy;
641: IF c_grp_chk%found THEN
642: CLOSE c_grp_chk;
643: fnd_message.set_name('PER','HR_6188_REQS_VACS_DATE_FROM');
644: fnd_message.set_token('PART','group');
645: hr_utility.raise_error;
646: ELSE CLOSE c_grp_chk;
647: END IF;
648: END D_from_updt_grp_chk;
675: OPEN c_job_chk;
676: FETCH c_job_chk into v_dummy;
677: IF c_job_chk%found THEN
678: CLOSE c_job_chk;
679: fnd_message.set_name('PER','HR_6188_REQS_VACS_DATE_FROM');
680: fnd_message.set_token('PART','job');
681: hr_utility.raise_error;
682: ELSE CLOSE c_job_chk;
683: END IF;
676: FETCH c_job_chk into v_dummy;
677: IF c_job_chk%found THEN
678: CLOSE c_job_chk;
679: fnd_message.set_name('PER','HR_6188_REQS_VACS_DATE_FROM');
680: fnd_message.set_token('PART','job');
681: hr_utility.raise_error;
682: ELSE CLOSE c_job_chk;
683: END IF;
684: END D_from_updt_job_chk;
711: OPEN c_grade_chk;
712: FETCH c_grade_chk into v_dummy;
713: IF c_grade_chk%found THEN
714: CLOSE c_grade_chk;
715: fnd_message.set_name('PER','HR_6188_REQS_VACS_DATE_FROM');
716: fnd_message.set_token('PART','grade');
717: hr_utility.raise_error;
718: ELSE CLOSE c_grade_chk;
719: END IF;
712: FETCH c_grade_chk into v_dummy;
713: IF c_grade_chk%found THEN
714: CLOSE c_grade_chk;
715: fnd_message.set_name('PER','HR_6188_REQS_VACS_DATE_FROM');
716: fnd_message.set_token('PART','grade');
717: hr_utility.raise_error;
718: ELSE CLOSE c_grade_chk;
719: END IF;
720: END D_from_updt_grd_chk;
746: OPEN c_loc_chk;
747: FETCH c_loc_chk into v_dummy;
748: IF c_loc_chk%found THEN
749: CLOSE c_loc_chk;
750: fnd_message.set_name('PER','HR_6188_REQS_VACS_DATE_FROM');
751: fnd_message.set_token('PART','location');
752: hr_utility.raise_error;
753: ELSE CLOSE c_loc_chk;
754: END IF;
747: FETCH c_loc_chk into v_dummy;
748: IF c_loc_chk%found THEN
749: CLOSE c_loc_chk;
750: fnd_message.set_name('PER','HR_6188_REQS_VACS_DATE_FROM');
751: fnd_message.set_token('PART','location');
752: hr_utility.raise_error;
753: ELSE CLOSE c_loc_chk;
754: END IF;
755: END D_from_updt_loc_chk;
786: OPEN c_person;
787: FETCH c_person into v_dummy;
788: IF c_person%notfound THEN
789: CLOSE c_person;
790: fnd_message.set_name('PER','HR_6642_VACS_RECRUITER');
791: hr_utility.raise_error;
792: ELSE CLOSE c_person;
793: END IF;
794: END D_from_updt_person;
1207: AND (X_Attribute20 IS NULL)))
1208: ) then
1209: return;
1210: else
1211: FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_CHANGED');
1212: APP_EXCEPTION.RAISE_EXCEPTION;
1213: end if;
1214: END Lock_Row;
1215: --