150: close c_dup;
151: --
152: -- raise error as this Eligible for Another Plan criteria already exists for this profile
153: --
154: fnd_message.set_name('BEN', 'BEN_92992_DUPS_ROW');
155: fnd_message.set_token('VAR1','Eligible for Another Plan criteria',TRUE);
156: fnd_message.set_token('VAR2','Variable Rate Profile',TRUE);
157: fnd_message.raise_error;
158: --
151: --
152: -- raise error as this Eligible for Another Plan criteria already exists for this profile
153: --
154: fnd_message.set_name('BEN', 'BEN_92992_DUPS_ROW');
155: fnd_message.set_token('VAR1','Eligible for Another Plan criteria',TRUE);
156: fnd_message.set_token('VAR2','Variable Rate Profile',TRUE);
157: fnd_message.raise_error;
158: --
159: end if;
152: -- raise error as this Eligible for Another Plan criteria already exists for this profile
153: --
154: fnd_message.set_name('BEN', 'BEN_92992_DUPS_ROW');
155: fnd_message.set_token('VAR1','Eligible for Another Plan criteria',TRUE);
156: fnd_message.set_token('VAR2','Variable Rate Profile',TRUE);
157: fnd_message.raise_error;
158: --
159: end if;
160: close c_dup;
153: --
154: fnd_message.set_name('BEN', 'BEN_92992_DUPS_ROW');
155: fnd_message.set_token('VAR1','Eligible for Another Plan criteria',TRUE);
156: fnd_message.set_token('VAR2','Variable Rate Profile',TRUE);
157: fnd_message.raise_error;
158: --
159: end if;
160: close c_dup;
161: --
294: open c1;
295: fetch c1 into l_dummy;
296: --
297: if c1%found then
298: fnd_message.set_name('BEN','BEN_91001_SEQ_NOT_UNIQUE');
299: fnd_message.raise_error;
300: end if;
301: close c1;
302: --
295: fetch c1 into l_dummy;
296: --
297: if c1%found then
298: fnd_message.set_name('BEN','BEN_91001_SEQ_NOT_UNIQUE');
299: fnd_message.raise_error;
300: end if;
301: close c1;
302: --
303: hr_utility.set_location('Leaving:'||l_proc, 15);