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