271: close c_dup;
272: --
273: -- raise error as this Pay Basis criteria already exists for this profile
274: --
275: fnd_message.set_name('BEN', 'BEN_92992_DUPS_ROW');
276: fnd_message.set_token('VAR1','Pay Basis criteria',TRUE);
277: fnd_message.set_token('VAR2','Variable Rate Profile',TRUE);
278: fnd_message.raise_error;
279: --
272: --
273: -- raise error as this Pay Basis criteria already exists for this profile
274: --
275: fnd_message.set_name('BEN', 'BEN_92992_DUPS_ROW');
276: fnd_message.set_token('VAR1','Pay Basis criteria',TRUE);
277: fnd_message.set_token('VAR2','Variable Rate Profile',TRUE);
278: fnd_message.raise_error;
279: --
280: end if;
273: -- raise error as this Pay Basis criteria already exists for this profile
274: --
275: fnd_message.set_name('BEN', 'BEN_92992_DUPS_ROW');
276: fnd_message.set_token('VAR1','Pay Basis criteria',TRUE);
277: fnd_message.set_token('VAR2','Variable Rate Profile',TRUE);
278: fnd_message.raise_error;
279: --
280: end if;
281: close c_dup;
274: --
275: fnd_message.set_name('BEN', 'BEN_92992_DUPS_ROW');
276: fnd_message.set_token('VAR1','Pay Basis criteria',TRUE);
277: fnd_message.set_token('VAR2','Variable Rate Profile',TRUE);
278: fnd_message.raise_error;
279: --
280: end if;
281: close c_dup;
282: --
344: open c1;
345: fetch c1 into l_dummy;
346: --
347: if c1%found then
348: fnd_message.set_name('BEN','BEN_91001_SEQ_NOT_UNIQUE');
349: fnd_message.raise_error;
350: end if;
351: close c1;
352: --
345: fetch c1 into l_dummy;
346: --
347: if c1%found then
348: fnd_message.set_name('BEN','BEN_91001_SEQ_NOT_UNIQUE');
349: fnd_message.raise_error;
350: end if;
351: close c1;
352: --
353: hr_utility.set_location('Leaving:'||l_proc, 15);