228: close c_dup;
229: --
230: -- raise error as this Hours Worked in Period criteria already exists for this profile
231: --
232: fnd_message.set_name('BEN', 'BEN_92992_DUPS_ROW');
233: fnd_message.set_token('VAR1','Hours Worked in Period criteria',TRUE);
234: fnd_message.set_token('VAR2','Variable Rate Profile',TRUE);
235: fnd_message.raise_error;
236: --
229: --
230: -- raise error as this Hours Worked in Period criteria already exists for this profile
231: --
232: fnd_message.set_name('BEN', 'BEN_92992_DUPS_ROW');
233: fnd_message.set_token('VAR1','Hours Worked in Period criteria',TRUE);
234: fnd_message.set_token('VAR2','Variable Rate Profile',TRUE);
235: fnd_message.raise_error;
236: --
237: end if;
230: -- raise error as this Hours Worked in Period criteria already exists for this profile
231: --
232: fnd_message.set_name('BEN', 'BEN_92992_DUPS_ROW');
233: fnd_message.set_token('VAR1','Hours Worked in Period criteria',TRUE);
234: fnd_message.set_token('VAR2','Variable Rate Profile',TRUE);
235: fnd_message.raise_error;
236: --
237: end if;
238: close c_dup;
231: --
232: fnd_message.set_name('BEN', 'BEN_92992_DUPS_ROW');
233: fnd_message.set_token('VAR1','Hours Worked in Period criteria',TRUE);
234: fnd_message.set_token('VAR2','Variable Rate Profile',TRUE);
235: fnd_message.raise_error;
236: --
237: end if;
238: close c_dup;
239: --
297: open c1;
298: fetch c1 into l_dummy;
299: --
300: if c1%found then
301: fnd_message.set_name('BEN','BEN_91001_SEQ_NOT_UNIQUE');
302: fnd_message.raise_error;
303: end if;
304: close c1;
305: --
298: fetch c1 into l_dummy;
299: --
300: if c1%found then
301: fnd_message.set_name('BEN','BEN_91001_SEQ_NOT_UNIQUE');
302: fnd_message.raise_error;
303: end if;
304: close c1;
305: --
306: hr_utility.set_location('Leaving:'||l_proc, 15);