194: open c1;
195: fetch c1 into l_dummy;
196: --
197: if c1%found then
198: fnd_message.set_name('BEN','BEN_91001_SEQ_NOT_UNIQUE');
199: fnd_message.raise_error;
200: end if;
201: close c1;
202: --
195: fetch c1 into l_dummy;
196: --
197: if c1%found then
198: fnd_message.set_name('BEN','BEN_91001_SEQ_NOT_UNIQUE');
199: fnd_message.raise_error;
200: end if;
201: close c1;
202: --
203: hr_utility.set_location('Leaving:'||l_proc, 15);
283: close c1;
284: --
285: -- raise error
286: --
287: fnd_message.set_name('BEN','BEN_91007_INVALID_RULE');
288: fnd_message.raise_error;
289: --
290: end if;
291: --
284: --
285: -- raise error
286: --
287: fnd_message.set_name('BEN','BEN_91007_INVALID_RULE');
288: fnd_message.raise_error;
289: --
290: end if;
291: --
292: close c1;
372: close c_dup;
373: --
374: -- raise error as this Rule criteria already exists for this profile
375: --
376: fnd_message.set_name('BEN', 'BEN_92992_DUPS_ROW');
377: fnd_message.set_token('VAR1','Rule',TRUE);
378: fnd_message.set_token('VAR2','Variable Rate Profile',TRUE);
379: fnd_message.raise_error;
380: --
373: --
374: -- raise error as this Rule criteria already exists for this profile
375: --
376: fnd_message.set_name('BEN', 'BEN_92992_DUPS_ROW');
377: fnd_message.set_token('VAR1','Rule',TRUE);
378: fnd_message.set_token('VAR2','Variable Rate Profile',TRUE);
379: fnd_message.raise_error;
380: --
381: end if;
374: -- raise error as this Rule criteria already exists for this profile
375: --
376: fnd_message.set_name('BEN', 'BEN_92992_DUPS_ROW');
377: fnd_message.set_token('VAR1','Rule',TRUE);
378: fnd_message.set_token('VAR2','Variable Rate Profile',TRUE);
379: fnd_message.raise_error;
380: --
381: end if;
382: close c_dup;
375: --
376: fnd_message.set_name('BEN', 'BEN_92992_DUPS_ROW');
377: fnd_message.set_token('VAR1','Rule',TRUE);
378: fnd_message.set_token('VAR2','Variable Rate Profile',TRUE);
379: fnd_message.raise_error;
380: --
381: end if;
382: close c_dup;
383: --