179: open c2;
180: fetch c2 into l_exists;
181: if c2%found then
182: close c2;
183: fnd_message.set_name('PER','PER_289391_KEY_ALREADY_USED');
184: fnd_message.set_token('TABLE_NAME','irc_vacancy_considerations');
185: fnd_message.raise_error;
186: end if;
187: close c2;
180: fetch c2 into l_exists;
181: if c2%found then
182: close c2;
183: fnd_message.set_name('PER','PER_289391_KEY_ALREADY_USED');
184: fnd_message.set_token('TABLE_NAME','irc_vacancy_considerations');
185: fnd_message.raise_error;
186: end if;
187: close c2;
188: --
181: if c2%found then
182: close c2;
183: fnd_message.set_name('PER','PER_289391_KEY_ALREADY_USED');
184: fnd_message.set_token('TABLE_NAME','irc_vacancy_considerations');
185: fnd_message.raise_error;
186: end if;
187: close c2;
188: --
189: -- Use registered key values and clear globals