817: -- ,p_person_id
818: -- ,p_business_group_id
819: -- ,p_effective_start_date) then
820: -- fnd_message.set_name('PAY','HR_7193_PER_FUT_TYPE_EXISTS');
821: -- app_exception.raise_exception;
822: --end if;
823: --
824: -- Ensure there are no future applicant assignments
825: --
879: -- ,p_effective_start_date) then
880: ,p_session_date) then
881: --changes for bug no 6070935
882: fnd_message.set_name('PAY','HR_7193_PER_FUT_TYPE_EXISTS');
883: app_exception.raise_exception;
884: end if;
885: --
886: if p_s_system_person_type = 'EX_EMP'
887: then
1788: open future_exists;
1789: fetch future_exists into l_dummy;
1790: if future_exists%found then
1791: fnd_message.set_name('PAY','HR_7510_PER_FUT_CHANGE');
1792: app_exception.raise_exception;
1793: end if;
1794: close future_exists;
1795: end;
1796: --
1814: fetch supervisor into l_dummy;
1815: if supervisor%FOUND then
1816: close supervisor;
1817: fnd_message.set_name('PAY','HR_51031_INV_HIRE_CHG_IS_SUPER');
1818: app_exception.raise_exception;
1819: end if;
1820: close supervisor;
1821: end;
1822: --