125: open c1;
126: fetch c1 into l_dummy;
127: --
128: if c1%found then
129: fnd_message.set_name('BEN','BEN_91001_SEQ_NOT_UNIQUE');
130: fnd_message.raise_error;
131: end if;
132: close c1;
133: --
126: fetch c1 into l_dummy;
127: --
128: if c1%found then
129: fnd_message.set_name('BEN','BEN_91001_SEQ_NOT_UNIQUE');
130: fnd_message.raise_error;
131: end if;
132: close c1;
133: --
134: hr_utility.set_location('Leaving:'||l_proc, 15);
333: close c_dup;
334: --
335: -- raise error as this Age criteria already exists for this profile
336: --
337: fnd_message.set_name('BEN', 'BEN_92992_DUPS_ROW');
338: fnd_message.set_token('VAR1','Age criteria',TRUE);
339: fnd_message.set_token('VAR2','Variable Rate Profile',TRUE);
340: fnd_message.raise_error;
341: --
334: --
335: -- raise error as this Age criteria already exists for this profile
336: --
337: fnd_message.set_name('BEN', 'BEN_92992_DUPS_ROW');
338: fnd_message.set_token('VAR1','Age criteria',TRUE);
339: fnd_message.set_token('VAR2','Variable Rate Profile',TRUE);
340: fnd_message.raise_error;
341: --
342: end if;
335: -- raise error as this Age criteria already exists for this profile
336: --
337: fnd_message.set_name('BEN', 'BEN_92992_DUPS_ROW');
338: fnd_message.set_token('VAR1','Age criteria',TRUE);
339: fnd_message.set_token('VAR2','Variable Rate Profile',TRUE);
340: fnd_message.raise_error;
341: --
342: end if;
343: close c_dup;
336: --
337: fnd_message.set_name('BEN', 'BEN_92992_DUPS_ROW');
338: fnd_message.set_token('VAR1','Age criteria',TRUE);
339: fnd_message.set_token('VAR2','Variable Rate Profile',TRUE);
340: fnd_message.raise_error;
341: --
342: end if;
343: close c_dup;
344: --