140: open csr_asg_sec;
141: fetch csr_asg_sec into l_exists;
142: if csr_asg_sec%notfound then
143: close csr_asg_sec;
144: fnd_message.set_name('PER', 'PER_SAL_ASG_NOT_EXIST');
145: fnd_message.raise_error;
146: end if;
147: close csr_asg_sec;
148: hr_utility.set_location(' Leaving:'|| l_proc, 30);
141: fetch csr_asg_sec into l_exists;
142: if csr_asg_sec%notfound then
143: close csr_asg_sec;
144: fnd_message.set_name('PER', 'PER_SAL_ASG_NOT_EXIST');
145: fnd_message.raise_error;
146: end if;
147: close csr_asg_sec;
148: hr_utility.set_location(' Leaving:'|| l_proc, 30);
149: end chk_access;