178: close c3;
179: --
180: -- raise error as this postal zip range already exists for this profile
181: --
182: fnd_message.set_name('BEN', 'BEN_92992_DUPS_ROW');
183: fnd_message.set_token('VAR1','Service Area criteria');
184: fnd_message.set_token('VAR2','Variable Rate Profile');
185: fnd_message.raise_error;
186: --
179: --
180: -- raise error as this postal zip range already exists for this profile
181: --
182: fnd_message.set_name('BEN', 'BEN_92992_DUPS_ROW');
183: fnd_message.set_token('VAR1','Service Area criteria');
184: fnd_message.set_token('VAR2','Variable Rate Profile');
185: fnd_message.raise_error;
186: --
187: end if;
180: -- raise error as this postal zip range already exists for this profile
181: --
182: fnd_message.set_name('BEN', 'BEN_92992_DUPS_ROW');
183: fnd_message.set_token('VAR1','Service Area criteria');
184: fnd_message.set_token('VAR2','Variable Rate Profile');
185: fnd_message.raise_error;
186: --
187: end if;
188: close c3;
181: --
182: fnd_message.set_name('BEN', 'BEN_92992_DUPS_ROW');
183: fnd_message.set_token('VAR1','Service Area criteria');
184: fnd_message.set_token('VAR2','Variable Rate Profile');
185: fnd_message.raise_error;
186: --
187: end if;
188: close c3;
189: --
245: open c1;
246: fetch c1 into l_dummy;
247: --
248: if c1%found then
249: fnd_message.set_name('BEN','BEN_91001_SEQ_NOT_UNIQUE');
250: fnd_message.raise_error;
251: end if;
252: close c1;
253: --
246: fetch c1 into l_dummy;
247: --
248: if c1%found then
249: fnd_message.set_name('BEN','BEN_91001_SEQ_NOT_UNIQUE');
250: fnd_message.raise_error;
251: end if;
252: close c1;
253: --
254: hr_utility.set_location('Leaving:'||l_proc, 15);