174: close c3;
175: --
176: -- raise error as this lgl enty already exists for this profile
177: --
178: fnd_message.set_name('BEN', 'BEN_91349_DUP_ELIG_CRITERIA');
179: fnd_message.raise_error;
180: --
181: end if;
182: --
175: --
176: -- raise error as this lgl enty already exists for this profile
177: --
178: fnd_message.set_name('BEN', 'BEN_91349_DUP_ELIG_CRITERIA');
179: fnd_message.raise_error;
180: --
181: end if;
182: --
183: close c3;
307: open c1;
308: fetch c1 into l_dummy;
309: if c1%found then
310: close c1;
311: fnd_message.set_name('BEN','BEN_91001_SEQ_NOT_UNIQUE');
312: fnd_message.raise_error;
313: end if;
314: close c1;
315: --
308: fetch c1 into l_dummy;
309: if c1%found then
310: close c1;
311: fnd_message.set_name('BEN','BEN_91001_SEQ_NOT_UNIQUE');
312: fnd_message.raise_error;
313: end if;
314: close c1;
315: --
316: hr_utility.set_location('Leaving:'||l_proc, 15);