321: Close C_Sel2;
322: --
323: -- The primary key values are already in use.
324: --
325: fnd_message.set_name('PER','PER_289391_KEY_ALREADY_USED');
326: fnd_message.set_token('TABLE_NAME','pqh_role_extra_info');
327: fnd_message.raise_error;
328: End If;
329: Close C_Sel2;
322: --
323: -- The primary key values are already in use.
324: --
325: fnd_message.set_name('PER','PER_289391_KEY_ALREADY_USED');
326: fnd_message.set_token('TABLE_NAME','pqh_role_extra_info');
327: fnd_message.raise_error;
328: End If;
329: Close C_Sel2;
330: --
323: -- The primary key values are already in use.
324: --
325: fnd_message.set_name('PER','PER_289391_KEY_ALREADY_USED');
326: fnd_message.set_token('TABLE_NAME','pqh_role_extra_info');
327: fnd_message.raise_error;
328: End If;
329: Close C_Sel2;
330: --
331: -- Use registered key values and clear globals