210: close c_dup;
211: --
212: -- raise error as this Legal Entity criteria already exists for this profile
213: --
214: fnd_message.set_name('BEN', 'BEN_92992_DUPS_ROW');
215: fnd_message.set_token('VAR1','Legal Entity criteria',TRUE);
216: fnd_message.set_token('VAR2','Variable Rate Profile',TRUE);
217: fnd_message.raise_error;
218: --
211: --
212: -- raise error as this Legal Entity criteria already exists for this profile
213: --
214: fnd_message.set_name('BEN', 'BEN_92992_DUPS_ROW');
215: fnd_message.set_token('VAR1','Legal Entity criteria',TRUE);
216: fnd_message.set_token('VAR2','Variable Rate Profile',TRUE);
217: fnd_message.raise_error;
218: --
219: end if;
212: -- raise error as this Legal Entity criteria already exists for this profile
213: --
214: fnd_message.set_name('BEN', 'BEN_92992_DUPS_ROW');
215: fnd_message.set_token('VAR1','Legal Entity criteria',TRUE);
216: fnd_message.set_token('VAR2','Variable Rate Profile',TRUE);
217: fnd_message.raise_error;
218: --
219: end if;
220: close c_dup;
213: --
214: fnd_message.set_name('BEN', 'BEN_92992_DUPS_ROW');
215: fnd_message.set_token('VAR1','Legal Entity criteria',TRUE);
216: fnd_message.set_token('VAR2','Variable Rate Profile',TRUE);
217: fnd_message.raise_error;
218: --
219: end if;
220: close c_dup;
221: --
274: open c1;
275: fetch c1 into l_dummy;
276: --
277: if c1%found then
278: fnd_message.set_name('BEN','BEN_91001_SEQ_NOT_UNIQUE');
279: fnd_message.raise_error;
280: end if;
281: close c1;
282: --
275: fetch c1 into l_dummy;
276: --
277: if c1%found then
278: fnd_message.set_name('BEN','BEN_91001_SEQ_NOT_UNIQUE');
279: fnd_message.raise_error;
280: end if;
281: close c1;
282: --
283: hr_utility.set_location('Leaving:'||l_proc, 15);