276: Close C_Sel2;
277: --
278: -- The primary key values are already in use.
279: --
280: fnd_message.set_name('PER','PER_289391_KEY_ALREADY_USED');
281: fnd_message.set_token('TABLE_NAME','irc_all_recruiting_sites');
282: fnd_message.raise_error;
283: End If;
284: Close C_Sel2;
277: --
278: -- The primary key values are already in use.
279: --
280: fnd_message.set_name('PER','PER_289391_KEY_ALREADY_USED');
281: fnd_message.set_token('TABLE_NAME','irc_all_recruiting_sites');
282: fnd_message.raise_error;
283: End If;
284: Close C_Sel2;
285: --
278: -- The primary key values are already in use.
279: --
280: fnd_message.set_name('PER','PER_289391_KEY_ALREADY_USED');
281: fnd_message.set_token('TABLE_NAME','irc_all_recruiting_sites');
282: fnd_message.raise_error;
283: End If;
284: Close C_Sel2;
285: --
286: -- Use registered key values and clear globals