261: open c2;
262: fetch c2 into l_exists;
263: if c2%found then
264: close c2;
265: fnd_message.set_name('PER','PER_289391_KEY_ALREADY_USED');
266: fnd_message.set_token('TABLE_NAME','irc_notification_preferences');
267: fnd_message.raise_error;
268: end if;
269: close c2;
262: fetch c2 into l_exists;
263: if c2%found then
264: close c2;
265: fnd_message.set_name('PER','PER_289391_KEY_ALREADY_USED');
266: fnd_message.set_token('TABLE_NAME','irc_notification_preferences');
267: fnd_message.raise_error;
268: end if;
269: close c2;
270: --
263: if c2%found then
264: close c2;
265: fnd_message.set_name('PER','PER_289391_KEY_ALREADY_USED');
266: fnd_message.set_token('TABLE_NAME','irc_notification_preferences');
267: fnd_message.raise_error;
268: end if;
269: close c2;
270: --
271: -- Use registered key values and clear globals