146: -- The previous 'old' created row has not been found. We need
147: -- to error as an internal datetrack problem exists.
148: --
149: Close C_Sel1;
150: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
151: fnd_message.set_token('PROCEDURE', l_proc);
152: fnd_message.set_token('STEP','10');
153: fnd_message.raise_error;
154: End If;
147: -- to error as an internal datetrack problem exists.
148: --
149: Close C_Sel1;
150: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
151: fnd_message.set_token('PROCEDURE', l_proc);
152: fnd_message.set_token('STEP','10');
153: fnd_message.raise_error;
154: End If;
155: Close C_Sel1;
148: --
149: Close C_Sel1;
150: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
151: fnd_message.set_token('PROCEDURE', l_proc);
152: fnd_message.set_token('STEP','10');
153: fnd_message.raise_error;
154: End If;
155: Close C_Sel1;
156: --
149: Close C_Sel1;
150: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
151: fnd_message.set_token('PROCEDURE', l_proc);
152: fnd_message.set_token('STEP','10');
153: fnd_message.raise_error;
154: End If;
155: Close C_Sel1;
156: --
157: -- Set the AOL updated WHO values
507: Close C_Sel2;
508: --
509: -- The primary key values are already in use.
510: --
511: fnd_message.set_name('PER','PER_289391_KEY_ALREADY_USED');
512: fnd_message.set_token('TABLE_NAME','ben_eligy_prfl_f');
513: fnd_message.raise_error;
514: End if;
515: Close C_Sel2;
508: --
509: -- The primary key values are already in use.
510: --
511: fnd_message.set_name('PER','PER_289391_KEY_ALREADY_USED');
512: fnd_message.set_token('TABLE_NAME','ben_eligy_prfl_f');
513: fnd_message.raise_error;
514: End if;
515: Close C_Sel2;
516: p_rec.eligy_prfl_id:=ben_elp_ins.g_eligy_prfl_id_i;
509: -- The primary key values are already in use.
510: --
511: fnd_message.set_name('PER','PER_289391_KEY_ALREADY_USED');
512: fnd_message.set_token('TABLE_NAME','ben_eligy_prfl_f');
513: fnd_message.raise_error;
514: End if;
515: Close C_Sel2;
516: p_rec.eligy_prfl_id:=ben_elp_ins.g_eligy_prfl_id_i;
517: ben_elp_ins.g_eligy_prfl_id_i:=null;