279: close c_dup;
280: --
281: -- raise error as this Payroll criteria already exists for this profile
282: --
283: fnd_message.set_name('BEN', 'BEN_92992_DUPS_ROW');
284: fnd_message.set_token('VAR1','Payroll criteria',TRUE);
285: fnd_message.set_token('VAR2','Variable Rate Profile',TRUE);
286: fnd_message.raise_error;
287: --
280: --
281: -- raise error as this Payroll criteria already exists for this profile
282: --
283: fnd_message.set_name('BEN', 'BEN_92992_DUPS_ROW');
284: fnd_message.set_token('VAR1','Payroll criteria',TRUE);
285: fnd_message.set_token('VAR2','Variable Rate Profile',TRUE);
286: fnd_message.raise_error;
287: --
288: end if;
281: -- raise error as this Payroll criteria already exists for this profile
282: --
283: fnd_message.set_name('BEN', 'BEN_92992_DUPS_ROW');
284: fnd_message.set_token('VAR1','Payroll criteria',TRUE);
285: fnd_message.set_token('VAR2','Variable Rate Profile',TRUE);
286: fnd_message.raise_error;
287: --
288: end if;
289: close c_dup;
282: --
283: fnd_message.set_name('BEN', 'BEN_92992_DUPS_ROW');
284: fnd_message.set_token('VAR1','Payroll criteria',TRUE);
285: fnd_message.set_token('VAR2','Variable Rate Profile',TRUE);
286: fnd_message.raise_error;
287: --
288: end if;
289: close c_dup;
290: --
352: open c1;
353: fetch c1 into l_dummy;
354: --
355: if c1%found then
356: fnd_message.set_name('BEN','BEN_91001_SEQ_NOT_UNIQUE');
357: fnd_message.raise_error;
358: end if;
359: close c1;
360: --
353: fetch c1 into l_dummy;
354: --
355: if c1%found then
356: fnd_message.set_name('BEN','BEN_91001_SEQ_NOT_UNIQUE');
357: fnd_message.raise_error;
358: end if;
359: close c1;
360: --
361: hr_utility.set_location('Leaving:'||l_proc, 15);