691: -- If a row is returned then the vacancy is over-subscribed
692: -- set message and warning flag.
693: -- raise exception.
694: --
695: fnd_message.set_name('PER','HR_EMP_VAC_FILLED');
696: fnd_message.set_token('VAC',l_vacancy_name);
697: p_fire_warning := 'Y';
698: raise over_subscribed;
699: end if; -- is asg hired ?
692: -- set message and warning flag.
693: -- raise exception.
694: --
695: fnd_message.set_name('PER','HR_EMP_VAC_FILLED');
696: fnd_message.set_token('VAC',l_vacancy_name);
697: p_fire_warning := 'Y';
698: raise over_subscribed;
699: end if; -- is asg hired ?
700: exception
700: exception
701: when no_data_found then
702: null;
703: when too_many_rows then
704: fnd_message.set_name('PER','HR_EMP_VAC_FILLED');
705: fnd_message.set_token('VAC','Too many rows');
706: app_exception.raise_exception;
707: end;
708: end loop;
701: when no_data_found then
702: null;
703: when too_many_rows then
704: fnd_message.set_name('PER','HR_EMP_VAC_FILLED');
705: fnd_message.set_token('VAC','Too many rows');
706: app_exception.raise_exception;
707: end;
708: end loop;
709: --