16: ---
17: begin
18: hr_utility.set_location('Entering: '|| 'PER_ASSIGNMENTS_F3_PKG.process_end_status', 5);
19: if p_eff_end_date < p_eot then
20: fnd_message.set_name('PAY', 'HR_6071_APP_ASS_INVALID_END');
21: fnd_message.raise_error;
22: end if;
23: --
24: -- Now check delete referential integrity as it will cause date
17: begin
18: hr_utility.set_location('Entering: '|| 'PER_ASSIGNMENTS_F3_PKG.process_end_status', 5);
19: if p_eff_end_date < p_eot then
20: fnd_message.set_name('PAY', 'HR_6071_APP_ASS_INVALID_END');
21: fnd_message.raise_error;
22: end if;
23: --
24: -- Now check delete referential integrity as it will cause date
25: -- effective delete.
51: hr_utility.set_location('Entering: '|| 'PER_ASSIGNMENTS_F3_PKG.process_term_status' , 5);
52: open term_assign;
53: fetch term_assign into l_dummy;
54: if term_assign%found then
55: fnd_message.set_name('PAY', 'HR_6387_EMP_ASS_INVALID_TERM');
56: close term_assign;
57: fnd_message.raise_error;
58: end if;
59: close term_assign;
53: fetch term_assign into l_dummy;
54: if term_assign%found then
55: fnd_message.set_name('PAY', 'HR_6387_EMP_ASS_INVALID_TERM');
56: close term_assign;
57: fnd_message.raise_error;
58: end if;
59: close term_assign;
60: end process_term_status;
61: -----------------------------------------------------------------------------
837:
838: open sp_point;
839: fetch sp_point into l_null;
840: if sp_point%found then
841: fnd_message.set_name('PAY',
842: 'PER_7935_CEIL_PLACE_HIGH_EXIST');
843: close sp_point;
844: fnd_message.raise_error;
845: end if;
840: if sp_point%found then
841: fnd_message.set_name('PAY',
842: 'PER_7935_CEIL_PLACE_HIGH_EXIST');
843: close sp_point;
844: fnd_message.raise_error;
845: end if;
846: close sp_point;
847: end if;
848: --fix for bug 4612843
853: open get_asg_enddate;
854: fetch get_asg_enddate into l_asg_enddate;
855: if ( l_asg_enddate > l_step_enddate ) then
856: close get_asg_enddate;
857: fnd_message.set_name('PAY','PAY_7589_SYS_STEP_DT_OUTDATE');
858: fnd_message.raise_error;
859: else
860: close get_asg_enddate;
861: end if ;
854: fetch get_asg_enddate into l_asg_enddate;
855: if ( l_asg_enddate > l_step_enddate ) then
856: close get_asg_enddate;
857: fnd_message.set_name('PAY','PAY_7589_SYS_STEP_DT_OUTDATE');
858: fnd_message.raise_error;
859: else
860: close get_asg_enddate;
861: end if ;
862: else