149: close c_dup;
150: --
151: -- raise error as this People Group criteria already exists for this profile
152: --
153: fnd_message.set_name('BEN', 'BEN_92992_DUPS_ROW');
154: fnd_message.set_token('VAR1','People Group criteria',TRUE);
155: fnd_message.set_token('VAR2','Variable Rate Profile',TRUE);
156: fnd_message.raise_error;
157: --
150: --
151: -- raise error as this People Group criteria already exists for this profile
152: --
153: fnd_message.set_name('BEN', 'BEN_92992_DUPS_ROW');
154: fnd_message.set_token('VAR1','People Group criteria',TRUE);
155: fnd_message.set_token('VAR2','Variable Rate Profile',TRUE);
156: fnd_message.raise_error;
157: --
158: end if;
151: -- raise error as this People Group criteria already exists for this profile
152: --
153: fnd_message.set_name('BEN', 'BEN_92992_DUPS_ROW');
154: fnd_message.set_token('VAR1','People Group criteria',TRUE);
155: fnd_message.set_token('VAR2','Variable Rate Profile',TRUE);
156: fnd_message.raise_error;
157: --
158: end if;
159: close c_dup;
152: --
153: fnd_message.set_name('BEN', 'BEN_92992_DUPS_ROW');
154: fnd_message.set_token('VAR1','People Group criteria',TRUE);
155: fnd_message.set_token('VAR2','Variable Rate Profile',TRUE);
156: fnd_message.raise_error;
157: --
158: end if;
159: close c_dup;
160: --
212: open c1;
213: fetch c1 into l_dummy;
214: --
215: if c1%found then
216: fnd_message.set_name('BEN','BEN_91001_SEQ_NOT_UNIQUE');
217: fnd_message.raise_error;
218: end if;
219: close c1;
220: --
213: fetch c1 into l_dummy;
214: --
215: if c1%found then
216: fnd_message.set_name('BEN','BEN_91001_SEQ_NOT_UNIQUE');
217: fnd_message.raise_error;
218: end if;
219: close c1;
220: --
221: hr_utility.set_location('Leaving:'||l_proc, 15);