[Home] [Help]
816: -- if hr_person.chk_future_person_type(p_s_system_person_type
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
878: --changes for bug no 6070935
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'
993: if hr_person.chk_future_person_type(p_s_system_person_type
994: ,p_person_id
995: ,p_business_group_id
996: ,p_effective_start_date) then
997: fnd_message.set_name('PAY','HR_7193_PER_FUT_TYPE_EXISTS');
998: hr_utility.raise_error;
999: end if;
1000: --
1001: -- Ensure there are no future applicant assignments
1197: if p_update_primary = 'Y'
1198: and future_pactid_exists(p_person_id, p_effective_start_date)
1199: then
1200: hr_utility.set_location('PER_PEOPLE12_PKG.update_row1',246);
1201: fnd_message.set_name('PAY','HR_6591_ASS_ACTIONS_EXIST');
1202: hr_utility.raise_error;
1203: end if;
1204: -- end bug fix 2824664
1205: --
1787: begin
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;
1813: open supervisor;
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;