281: Close C_Sel2;
282: --
283: -- The primary key values are already in use.
284: --
285: fnd_message.set_name('PER','PER_289391_KEY_ALREADY_USED');
286: fnd_message.set_token('TABLE_NAME','per_all_vacancies');
287: fnd_message.raise_error;
288: end if;
289: Close C_Sel2;
282: --
283: -- The primary key values are already in use.
284: --
285: fnd_message.set_name('PER','PER_289391_KEY_ALREADY_USED');
286: fnd_message.set_token('TABLE_NAME','per_all_vacancies');
287: fnd_message.raise_error;
288: end if;
289: Close C_Sel2;
290: --
283: -- The primary key values are already in use.
284: --
285: fnd_message.set_name('PER','PER_289391_KEY_ALREADY_USED');
286: fnd_message.set_token('TABLE_NAME','per_all_vacancies');
287: fnd_message.raise_error;
288: end if;
289: Close C_Sel2;
290: --
291: -- Use registered key values and clear globals