140: -- The previous 'old' created row has not been found. We need
141: -- to error as an internal datetrack problem exists.
142: --
143: Close C_Sel1;
144: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
145: fnd_message.set_token('PROCEDURE', l_proc);
146: fnd_message.set_token('STEP','10');
147: fnd_message.raise_error;
148: End If;
141: -- to error as an internal datetrack problem exists.
142: --
143: Close C_Sel1;
144: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
145: fnd_message.set_token('PROCEDURE', l_proc);
146: fnd_message.set_token('STEP','10');
147: fnd_message.raise_error;
148: End If;
149: Close C_Sel1;
142: --
143: Close C_Sel1;
144: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
145: fnd_message.set_token('PROCEDURE', l_proc);
146: fnd_message.set_token('STEP','10');
147: fnd_message.raise_error;
148: End If;
149: Close C_Sel1;
150: --
143: Close C_Sel1;
144: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
145: fnd_message.set_token('PROCEDURE', l_proc);
146: fnd_message.set_token('STEP','10');
147: fnd_message.raise_error;
148: End If;
149: Close C_Sel1;
150: --
151: Open C_Sel2;
346: Close C_Sel2;
347: --
348: -- The primary key values are already in use.
349: --
350: fnd_message.set_name('PER','PER_289391_KEY_ALREADY_USED');
351: fnd_message.set_token('TABLE_NAME','ame_approver_types');
352: fnd_message.raise_error;
353: End If;
354: Close C_Sel2;
347: --
348: -- The primary key values are already in use.
349: --
350: fnd_message.set_name('PER','PER_289391_KEY_ALREADY_USED');
351: fnd_message.set_token('TABLE_NAME','ame_approver_types');
352: fnd_message.raise_error;
353: End If;
354: Close C_Sel2;
355: --
348: -- The primary key values are already in use.
349: --
350: fnd_message.set_name('PER','PER_289391_KEY_ALREADY_USED');
351: fnd_message.set_token('TABLE_NAME','ame_approver_types');
352: fnd_message.raise_error;
353: End If;
354: Close C_Sel2;
355: --
356: -- Use registered key values and clear globals