223: close c_dup;
224: --
225: -- raise error as this Full Time / Part Time criteria already exists for this profile
226: --
227: fnd_message.set_name('BEN', 'BEN_92992_DUPS_ROW');
228: fnd_message.set_token('VAR1','Full Time / Part Time criteria',TRUE);
229: fnd_message.set_token('VAR2','Variable Rate Profile',TRUE);
230: fnd_message.raise_error;
231: --
224: --
225: -- raise error as this Full Time / Part Time criteria already exists for this profile
226: --
227: fnd_message.set_name('BEN', 'BEN_92992_DUPS_ROW');
228: fnd_message.set_token('VAR1','Full Time / Part Time criteria',TRUE);
229: fnd_message.set_token('VAR2','Variable Rate Profile',TRUE);
230: fnd_message.raise_error;
231: --
232: end if;
225: -- raise error as this Full Time / Part Time criteria already exists for this profile
226: --
227: fnd_message.set_name('BEN', 'BEN_92992_DUPS_ROW');
228: fnd_message.set_token('VAR1','Full Time / Part Time criteria',TRUE);
229: fnd_message.set_token('VAR2','Variable Rate Profile',TRUE);
230: fnd_message.raise_error;
231: --
232: end if;
233: close c_dup;
226: --
227: fnd_message.set_name('BEN', 'BEN_92992_DUPS_ROW');
228: fnd_message.set_token('VAR1','Full Time / Part Time criteria',TRUE);
229: fnd_message.set_token('VAR2','Variable Rate Profile',TRUE);
230: fnd_message.raise_error;
231: --
232: end if;
233: close c_dup;
234: --
287: open c1;
288: fetch c1 into l_dummy;
289: --
290: if c1%found then
291: fnd_message.set_name('BEN','BEN_91001_SEQ_NOT_UNIQUE');
292: fnd_message.raise_error;
293: end if;
294: close c1;
295: --
288: fetch c1 into l_dummy;
289: --
290: if c1%found then
291: fnd_message.set_name('BEN','BEN_91001_SEQ_NOT_UNIQUE');
292: fnd_message.raise_error;
293: end if;
294: close c1;
295: --
296: hr_utility.set_location('Leaving:'||l_proc, 15);