220: close c_dup;
221: --
222: -- raise error as this Labour Union Member criteria already exists for this profile
223: --
224: fnd_message.set_name('BEN', 'BEN_92992_DUPS_ROW');
225: fnd_message.set_token('VAR1','Labor Union Member criteria',TRUE);
226: fnd_message.set_token('VAR2','Variable Rate Profile',TRUE);
227: fnd_message.raise_error;
228: --
221: --
222: -- raise error as this Labour Union Member criteria already exists for this profile
223: --
224: fnd_message.set_name('BEN', 'BEN_92992_DUPS_ROW');
225: fnd_message.set_token('VAR1','Labor Union Member criteria',TRUE);
226: fnd_message.set_token('VAR2','Variable Rate Profile',TRUE);
227: fnd_message.raise_error;
228: --
229: end if;
222: -- raise error as this Labour Union Member criteria already exists for this profile
223: --
224: fnd_message.set_name('BEN', 'BEN_92992_DUPS_ROW');
225: fnd_message.set_token('VAR1','Labor Union Member criteria',TRUE);
226: fnd_message.set_token('VAR2','Variable Rate Profile',TRUE);
227: fnd_message.raise_error;
228: --
229: end if;
230: close c_dup;
223: --
224: fnd_message.set_name('BEN', 'BEN_92992_DUPS_ROW');
225: fnd_message.set_token('VAR1','Labor Union Member criteria',TRUE);
226: fnd_message.set_token('VAR2','Variable Rate Profile',TRUE);
227: fnd_message.raise_error;
228: --
229: end if;
230: close c_dup;
231: --
284: open c1;
285: fetch c1 into l_dummy;
286: --
287: if c1%found then
288: fnd_message.set_name('BEN','BEN_91001_SEQ_NOT_UNIQUE');
289: fnd_message.raise_error;
290: end if;
291: close c1;
292: --
285: fetch c1 into l_dummy;
286: --
287: if c1%found then
288: fnd_message.set_name('BEN','BEN_91001_SEQ_NOT_UNIQUE');
289: fnd_message.raise_error;
290: end if;
291: close c1;
292: --
293: hr_utility.set_location('Leaving:'||l_proc, 15);