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