250: CLOSE C_Sel2;
251: --
252: -- The primary key values are already IN use.
253: --
254: fnd_message.set_name('PER','PER_289391_KEY_ALREADY_USED');
255: fnd_message.set_token('TABLE_NAME','pay_rates');
256: fnd_message.raise_error;
257: END IF;
258: CLOSE C_Sel2;
251: --
252: -- The primary key values are already IN use.
253: --
254: fnd_message.set_name('PER','PER_289391_KEY_ALREADY_USED');
255: fnd_message.set_token('TABLE_NAME','pay_rates');
256: fnd_message.raise_error;
257: END IF;
258: CLOSE C_Sel2;
259: --
252: -- The primary key values are already IN use.
253: --
254: fnd_message.set_name('PER','PER_289391_KEY_ALREADY_USED');
255: fnd_message.set_token('TABLE_NAME','pay_rates');
256: fnd_message.raise_error;
257: END IF;
258: CLOSE C_Sel2;
259: --
260: -- Use registered key values AND clear globals