152: close c_dup;
153: --
154: -- raise error as this Assignment Set already exists for this profile
155: --
156: fnd_message.set_name('BEN', 'BEN_92992_DUPS_ROW');
157: fnd_message.set_token('VAR1','Assignment Set criteria');
158: fnd_message.set_token('VAR2','Variable Rate Profile');
159: fnd_message.raise_error;
160: --
153: --
154: -- raise error as this Assignment Set already exists for this profile
155: --
156: fnd_message.set_name('BEN', 'BEN_92992_DUPS_ROW');
157: fnd_message.set_token('VAR1','Assignment Set criteria');
158: fnd_message.set_token('VAR2','Variable Rate Profile');
159: fnd_message.raise_error;
160: --
161: end if;
154: -- raise error as this Assignment Set already exists for this profile
155: --
156: fnd_message.set_name('BEN', 'BEN_92992_DUPS_ROW');
157: fnd_message.set_token('VAR1','Assignment Set criteria');
158: fnd_message.set_token('VAR2','Variable Rate Profile');
159: fnd_message.raise_error;
160: --
161: end if;
162: close c_dup;
155: --
156: fnd_message.set_name('BEN', 'BEN_92992_DUPS_ROW');
157: fnd_message.set_token('VAR1','Assignment Set criteria');
158: fnd_message.set_token('VAR2','Variable Rate Profile');
159: fnd_message.raise_error;
160: --
161: end if;
162: close c_dup;
163: --
287: fetch c1 into l_dummy;
288: --
289: if c1%found then
290: --
291: fnd_message.set_name('BEN','BEN_91001_SEQ_NOT_UNIQUE');
292: fnd_message.raise_error;
293: else
294: --fnd_message.set_name('BEN', 'vrbl =' || p_vrbl_rt_prfl_id || 'date=' || p_effective_date || 'bsnsid= ' || p_business_group_id || ' or = ' || p_ordr_num);
295: --fnd_message.raise_error;
288: --
289: if c1%found then
290: --
291: fnd_message.set_name('BEN','BEN_91001_SEQ_NOT_UNIQUE');
292: fnd_message.raise_error;
293: else
294: --fnd_message.set_name('BEN', 'vrbl =' || p_vrbl_rt_prfl_id || 'date=' || p_effective_date || 'bsnsid= ' || p_business_group_id || ' or = ' || p_ordr_num);
295: --fnd_message.raise_error;
296: null;
290: --
291: fnd_message.set_name('BEN','BEN_91001_SEQ_NOT_UNIQUE');
292: fnd_message.raise_error;
293: else
294: --fnd_message.set_name('BEN', 'vrbl =' || p_vrbl_rt_prfl_id || 'date=' || p_effective_date || 'bsnsid= ' || p_business_group_id || ' or = ' || p_ordr_num);
295: --fnd_message.raise_error;
296: null;
297: end if;
298: close c1;
291: fnd_message.set_name('BEN','BEN_91001_SEQ_NOT_UNIQUE');
292: fnd_message.raise_error;
293: else
294: --fnd_message.set_name('BEN', 'vrbl =' || p_vrbl_rt_prfl_id || 'date=' || p_effective_date || 'bsnsid= ' || p_business_group_id || ' or = ' || p_ordr_num);
295: --fnd_message.raise_error;
296: null;
297: end if;
298: close c1;
299: --