151: close c_dup;
152: --
153: -- raise error as this Assignment Status already exists for this profile
154: --
155: fnd_message.set_name('BEN', 'BEN_92992_DUPS_ROW');
156: fnd_message.set_token('VAR1','Assignment Status criteria');
157: fnd_message.set_token('VAR2','Variable Rate Profile');
158: fnd_message.raise_error;
159: --
152: --
153: -- raise error as this Assignment Status already exists for this profile
154: --
155: fnd_message.set_name('BEN', 'BEN_92992_DUPS_ROW');
156: fnd_message.set_token('VAR1','Assignment Status criteria');
157: fnd_message.set_token('VAR2','Variable Rate Profile');
158: fnd_message.raise_error;
159: --
160: end if;
153: -- raise error as this Assignment Status already exists for this profile
154: --
155: fnd_message.set_name('BEN', 'BEN_92992_DUPS_ROW');
156: fnd_message.set_token('VAR1','Assignment Status criteria');
157: fnd_message.set_token('VAR2','Variable Rate Profile');
158: fnd_message.raise_error;
159: --
160: end if;
161: close c_dup;
154: --
155: fnd_message.set_name('BEN', 'BEN_92992_DUPS_ROW');
156: fnd_message.set_token('VAR1','Assignment Status criteria');
157: fnd_message.set_token('VAR2','Variable Rate Profile');
158: fnd_message.raise_error;
159: --
160: end if;
161: close c_dup;
162: --
216: open c1;
217: fetch c1 into l_dummy;
218: --
219: if c1%found then
220: fnd_message.set_name('BEN','BEN_91001_SEQ_NOT_UNIQUE');
221: fnd_message.raise_error;
222: end if;
223: close c1;
224: --
217: fetch c1 into l_dummy;
218: --
219: if c1%found then
220: fnd_message.set_name('BEN','BEN_91001_SEQ_NOT_UNIQUE');
221: fnd_message.raise_error;
222: end if;
223: close c1;
224: --
225: hr_utility.set_location('Leaving:'||l_proc, 15);