1482: ,p_effective_date=> p_effective_date);
1483: fetch csr_person_details into per_rec;
1484: if csr_person_details%notfound then
1485: close csr_person_details;
1486: fnd_message.set_name(800,'XXX');
1487: fnd_message.raise_error;
1488: else
1489: close csr_person_details;
1490: end if;
1483: fetch csr_person_details into per_rec;
1484: if csr_person_details%notfound then
1485: close csr_person_details;
1486: fnd_message.set_name(800,'XXX');
1487: fnd_message.raise_error;
1488: else
1489: close csr_person_details;
1490: end if;
1491: --