124: open c1;
125: fetch c1 into l_dummy;
126: if c1%found then
127: close c1;
128: fnd_message.set_name('BEN','BEN_91001_SEQ_NOT_UNIQUE');
129: fnd_message.raise_error;
130: end if;
131: --
132: hr_utility.set_location('Leaving:'||l_proc, 15);
125: fetch c1 into l_dummy;
126: if c1%found then
127: close c1;
128: fnd_message.set_name('BEN','BEN_91001_SEQ_NOT_UNIQUE');
129: fnd_message.raise_error;
130: end if;
131: --
132: hr_utility.set_location('Leaving:'||l_proc, 15);
133: End chk_ordr_num_unique;
202: --
203: -- raise an error as this cvg_amt_calc_mthd_id has
204: -- been assigned to rule(s).
205: --
206: fnd_message.set_name('BEN','BEN_91965_BRR_BVR_EXCLU');
207: fnd_message.raise_error;
208: --
209: end if;
210: --
203: -- raise an error as this cvg_amt_calc_mthd_id has
204: -- been assigned to rule(s).
205: --
206: fnd_message.set_name('BEN','BEN_91965_BRR_BVR_EXCLU');
207: fnd_message.raise_error;
208: --
209: end if;
210: --
211: close c1;