247: Close C_Sel2;
248: --
249: -- The primary key values are already in use.
250: --
251: fnd_message.set_name('PER','PER_289391_KEY_ALREADY_USED');
252: fnd_message.set_token('TABLE_NAME','ota_category_usages');
253: fnd_message.raise_error;
254: End If;
255: Close C_Sel2;
248: --
249: -- The primary key values are already in use.
250: --
251: fnd_message.set_name('PER','PER_289391_KEY_ALREADY_USED');
252: fnd_message.set_token('TABLE_NAME','ota_category_usages');
253: fnd_message.raise_error;
254: End If;
255: Close C_Sel2;
256: --
249: -- The primary key values are already in use.
250: --
251: fnd_message.set_name('PER','PER_289391_KEY_ALREADY_USED');
252: fnd_message.set_token('TABLE_NAME','ota_category_usages');
253: fnd_message.raise_error;
254: End If;
255: Close C_Sel2;
256: --
257: -- Use registered key values and clear globals