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