73: fetch cur_chk_abs_atte_id into l_exists;
74: close cur_chk_abs_atte_id;
75: if l_exists is null then
76:
77: fnd_message.set_name('PER', 'HR_NL_INVALID_ABSENCE_ID');
78: fnd_message.raise_error;
79:
80: end if;
81:
74: close cur_chk_abs_atte_id;
75: if l_exists is null then
76:
77: fnd_message.set_name('PER', 'HR_NL_INVALID_ABSENCE_ID');
78: fnd_message.raise_error;
79:
80: end if;
81:
82: hr_utility.set_location(' Leaving:'|| l_proc, 20);
139: fetch cur_chk_abs_cat_user_tables into l_exists;
140: close cur_chk_abs_cat_user_tables;
141: if l_exists is null then
142:
143: fnd_message.set_name('PER', 'HR_NL_ACTION_MISSING_SETUP');
144: fnd_message.raise_error;
145:
146: end if;
147:
140: close cur_chk_abs_cat_user_tables;
141: if l_exists is null then
142:
143: fnd_message.set_name('PER', 'HR_NL_ACTION_MISSING_SETUP');
144: fnd_message.raise_error;
145:
146: end if;
147:
148: hr_utility.set_location(' Leaving:'|| l_proc, 20);
215: fetch cur_chk_expected_date into l_absence_date;
216: close cur_chk_expected_date;
217: --
218: if p_expected_date < l_absence_date then
219: fnd_message.set_name('PER', 'HR_NL_INVALID_ACTION_EXP_DATE');
220: fnd_message.raise_error;
221: end if;
222: -- end changes as per bug 2637189
223: --
216: close cur_chk_expected_date;
217: --
218: if p_expected_date < l_absence_date then
219: fnd_message.set_name('PER', 'HR_NL_INVALID_ACTION_EXP_DATE');
220: fnd_message.raise_error;
221: end if;
222: -- end changes as per bug 2637189
223: --
224: hr_utility.set_location(' Leaving:'|| l_proc, 20);
322: --
323: if p_actual_start_date is not null and
324: p_actual_end_date is not null then
325: if p_actual_start_date > p_actual_end_date then
326: fnd_message.set_name('PER', 'HR_NL_INVALID_ABS_ACTION_DATES');
327: fnd_message.raise_error;
328: end if;
329: end if;
330: --
323: if p_actual_start_date is not null and
324: p_actual_end_date is not null then
325: if p_actual_start_date > p_actual_end_date then
326: fnd_message.set_name('PER', 'HR_NL_INVALID_ABS_ACTION_DATES');
327: fnd_message.raise_error;
328: end if;
329: end if;
330: --
331: hr_utility.set_location(' Leaving:'|| l_proc, 20);
391: close cur_chk_abs_act_id;
392: --
393: if l_obj_num is null then
394:
395: fnd_message.set_name('PAY', 'HR_7220_INVALID_PRIMARY_KEY');
396: fnd_message.raise_error;
397: elsif l_obj_num <> p_object_version_number then
398:
399: fnd_message.set_name('PAY', 'HR_7155_OBJECT_INVALID');
392: --
393: if l_obj_num is null then
394:
395: fnd_message.set_name('PAY', 'HR_7220_INVALID_PRIMARY_KEY');
396: fnd_message.raise_error;
397: elsif l_obj_num <> p_object_version_number then
398:
399: fnd_message.set_name('PAY', 'HR_7155_OBJECT_INVALID');
400: fnd_message.raise_error;
395: fnd_message.set_name('PAY', 'HR_7220_INVALID_PRIMARY_KEY');
396: fnd_message.raise_error;
397: elsif l_obj_num <> p_object_version_number then
398:
399: fnd_message.set_name('PAY', 'HR_7155_OBJECT_INVALID');
400: fnd_message.raise_error;
401: end if;
402:
403: hr_utility.set_location(' Leaving:'|| l_proc, 20);
396: fnd_message.raise_error;
397: elsif l_obj_num <> p_object_version_number then
398:
399: fnd_message.set_name('PAY', 'HR_7155_OBJECT_INVALID');
400: fnd_message.raise_error;
401: end if;
402:
403: hr_utility.set_location(' Leaving:'|| l_proc, 20);
404:
448: close csr_sec_grp;
449: --
450: -- The primary key is invalid therefore we must error
451: --
452: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
453: fnd_message.raise_error;
454: end if;
455: --
456: -- Set the security_group_id in CLIENT_INFO
449: --
450: -- The primary key is invalid therefore we must error
451: --
452: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
453: fnd_message.raise_error;
454: end if;
455: --
456: -- Set the security_group_id in CLIENT_INFO
457: --
522: --
523: -- The primary key is invalid therefore we must error
524: --
525: close csr_leg_code;
526: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
527: fnd_message.raise_error;
528: end if;
529: hr_utility.set_location(l_proc,30);
530: --
523: -- The primary key is invalid therefore we must error
524: --
525: close csr_leg_code;
526: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
527: fnd_message.raise_error;
528: end if;
529: hr_utility.set_location(l_proc,30);
530: --
531: -- Set the global variables so the values are
581: (p_absence_action_id => p_rec.absence_action_id
582: ,p_absence_attendance_id => p_rec.absence_attendance_id
583: ,p_object_version_number => p_rec.object_version_number
584: ) THEN
585: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
586: fnd_message.set_token('PROCEDURE ', l_proc);
587: fnd_message.set_token('STEP ', '5');
588: fnd_message.raise_error;
589: END IF;
582: ,p_absence_attendance_id => p_rec.absence_attendance_id
583: ,p_object_version_number => p_rec.object_version_number
584: ) THEN
585: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
586: fnd_message.set_token('PROCEDURE ', l_proc);
587: fnd_message.set_token('STEP ', '5');
588: fnd_message.raise_error;
589: END IF;
590: --
583: ,p_object_version_number => p_rec.object_version_number
584: ) THEN
585: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
586: fnd_message.set_token('PROCEDURE ', l_proc);
587: fnd_message.set_token('STEP ', '5');
588: fnd_message.raise_error;
589: END IF;
590: --
591: --
584: ) THEN
585: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
586: fnd_message.set_token('PROCEDURE ', l_proc);
587: fnd_message.set_token('STEP ', '5');
588: fnd_message.raise_error;
589: END IF;
590: --
591: --
592: End chk_non_updateable_args;