75: open c1 ;
76: fetch c1 into l_dummy ;
77: if c1%found then
78: close c1 ;
79: hr_utility.set_message ( 801, 'HR_6408_APPS_NO_UPDATE' ) ;
80: hr_utility.set_message_token ( 'TYPE' , 'recruiter or status');
81: hr_utility.raise_error ;
82: end if;
83: close c1 ;
76: fetch c1 into l_dummy ;
77: if c1%found then
78: close c1 ;
79: hr_utility.set_message ( 801, 'HR_6408_APPS_NO_UPDATE' ) ;
80: hr_utility.set_message_token ( 'TYPE' , 'recruiter or status');
81: hr_utility.raise_error ;
82: end if;
83: close c1 ;
84: --
77: if c1%found then
78: close c1 ;
79: hr_utility.set_message ( 801, 'HR_6408_APPS_NO_UPDATE' ) ;
80: hr_utility.set_message_token ( 'TYPE' , 'recruiter or status');
81: hr_utility.raise_error ;
82: end if;
83: close c1 ;
84: --
85: end chk_future_asg_changes ;
120: fetch c1 into l_asg_max_end_date ;
121: close c1 ;
122: --
123: if ( l_asg_max_end_date < hr_general.end_of_time ) then
124: hr_utility.set_message(801, 'HR_6751_APP_TERM_ALREADY');
125: hr_utility.raise_error;
126: end if;
127: --
128: end chk_assignment_current ;
121: close c1 ;
122: --
123: if ( l_asg_max_end_date < hr_general.end_of_time ) then
124: hr_utility.set_message(801, 'HR_6751_APP_TERM_ALREADY');
125: hr_utility.raise_error;
126: end if;
127: --
128: end chk_assignment_current ;
129: --
175: open c1 ;
176: fetch c1 into l_dummy_date ;
177: if ( c1%found ) then
178: close c1 ;
179: hr_utility.set_message(801,'HR_6382_APP_TERM_FUTURE_PPT');
180: hr_utility.set_message_token( 'DATE' , to_char(l_dummy_date));
181: hr_utility.raise_error ;
182: end if;
183: close c1 ;
176: fetch c1 into l_dummy_date ;
177: if ( c1%found ) then
178: close c1 ;
179: hr_utility.set_message(801,'HR_6382_APP_TERM_FUTURE_PPT');
180: hr_utility.set_message_token( 'DATE' , to_char(l_dummy_date));
181: hr_utility.raise_error ;
182: end if;
183: close c1 ;
184: --
177: if ( c1%found ) then
178: close c1 ;
179: hr_utility.set_message(801,'HR_6382_APP_TERM_FUTURE_PPT');
180: hr_utility.set_message_token( 'DATE' , to_char(l_dummy_date));
181: hr_utility.raise_error ;
182: end if;
183: close c1 ;
184: --
185: --