522: open csr_asg_sec;
523: fetch csr_asg_sec into l_exists;
524: if csr_asg_sec%notfound then
525: close csr_asg_sec;
526: fnd_message.set_name('PER', 'PER_SAL_ASG_NOT_EXIST');
527: fnd_message.raise_error;
528: end if;
529: close csr_asg_sec;
530: hr_utility.set_location(' Leaving:'|| l_proc, 30);
523: fetch csr_asg_sec into l_exists;
524: if csr_asg_sec%notfound then
525: close csr_asg_sec;
526: fnd_message.set_name('PER', 'PER_SAL_ASG_NOT_EXIST');
527: fnd_message.raise_error;
528: end if;
529: close csr_asg_sec;
530: hr_utility.set_location(' Leaving:'|| l_proc, 30);
531: end chk_access;