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