184: open c2;
185: fetch c2 into l_exists;
186: if c2%found then
187: close c2;
188: fnd_message.set_name('PER','PER_289391_KEY_ALREADY_USED');
189: fnd_message.set_token('TABLE_NAME','irc_job_basket_items');
190: fnd_message.raise_error;
191: end if;
192: close c2;
185: fetch c2 into l_exists;
186: if c2%found then
187: close c2;
188: fnd_message.set_name('PER','PER_289391_KEY_ALREADY_USED');
189: fnd_message.set_token('TABLE_NAME','irc_job_basket_items');
190: fnd_message.raise_error;
191: end if;
192: close c2;
193: --
186: if c2%found then
187: close c2;
188: fnd_message.set_name('PER','PER_289391_KEY_ALREADY_USED');
189: fnd_message.set_token('TABLE_NAME','irc_job_basket_items');
190: fnd_message.raise_error;
191: end if;
192: close c2;
193: --
194: -- Use registered key values and clear globals