542: open csr_valid_person_type;
543: fetch csr_valid_person_type into l_person_type;
544: if csr_valid_person_type%notfound then
545: close csr_valid_person_type;
546: fnd_message.set_name('PER', 'HR_52362_PTU_INV_PER_TYPE_ID');
547: fnd_message.raise_error;
548: end if;
549: close csr_valid_person_type;
550:
543: fetch csr_valid_person_type into l_person_type;
544: if csr_valid_person_type%notfound then
545: close csr_valid_person_type;
546: fnd_message.set_name('PER', 'HR_52362_PTU_INV_PER_TYPE_ID');
547: fnd_message.raise_error;
548: end if;
549: close csr_valid_person_type;
550:
551: hr_utility.set_location('At: '||l_proc,15);
558: (p_effective_date => p_effective_date
559: ,p_lookup_type => 'HR_SYS_PTU'
560: ,p_lookup_code => l_person_type
561: ) then
562: fnd_message.set_name('PER', 'HR_52362_PTU_INV_PER_TYPE_ID');
563: fnd_message.raise_error;
564: end if;
565:
566: hr_utility.set_location('At: '||l_proc,20);
559: ,p_lookup_type => 'HR_SYS_PTU'
560: ,p_lookup_code => l_person_type
561: ) then
562: fnd_message.set_name('PER', 'HR_52362_PTU_INV_PER_TYPE_ID');
563: fnd_message.raise_error;
564: end if;
565:
566: hr_utility.set_location('At: '||l_proc,20);
567:
823: -- (p_effective_date => p_effective_date
824: -- ,p_lookup_type => 'HR_SYS_PTU'
825: -- ,p_lookup_code => l_system_person_type
826: -- ) then
827: -- fnd_message.set_name('PER', 'HR_52658_PTU_INVALID_DELETE');
828: -- fnd_message.raise_error;
829: -- end if;
830: --
831: -- End of PTU Changes
824: -- ,p_lookup_type => 'HR_SYS_PTU'
825: -- ,p_lookup_code => l_system_person_type
826: -- ) then
827: -- fnd_message.set_name('PER', 'HR_52658_PTU_INVALID_DELETE');
828: -- fnd_message.raise_error;
829: -- end if;
830: --
831: -- End of PTU Changes
832: --