195: -- The previous 'old' created row has not been found. We need
196: -- to error as an internal datetrack problem exists.
197: --
198: Close C_Sel1;
199: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
200: fnd_message.set_token('PROCEDURE', l_proc);
201: fnd_message.set_token('STEP','10');
202: fnd_message.raise_error;
203: End If;
196: -- to error as an internal datetrack problem exists.
197: --
198: Close C_Sel1;
199: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
200: fnd_message.set_token('PROCEDURE', l_proc);
201: fnd_message.set_token('STEP','10');
202: fnd_message.raise_error;
203: End If;
204: Close C_Sel1;
197: --
198: Close C_Sel1;
199: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
200: fnd_message.set_token('PROCEDURE', l_proc);
201: fnd_message.set_token('STEP','10');
202: fnd_message.raise_error;
203: End If;
204: Close C_Sel1;
205: --
198: Close C_Sel1;
199: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
200: fnd_message.set_token('PROCEDURE', l_proc);
201: fnd_message.set_token('STEP','10');
202: fnd_message.raise_error;
203: End If;
204: Close C_Sel1;
205: --
206: --
408: Close C_Sel2;
409: --
410: -- The primary key values are already in use.
411: --
412: fnd_message.set_name('PER','PER_289391_KEY_ALREADY_USED');
413: fnd_message.set_token('TABLE_NAME','ame_rules');
414: fnd_message.raise_error;
415: End If;
416: Close C_Sel2;
409: --
410: -- The primary key values are already in use.
411: --
412: fnd_message.set_name('PER','PER_289391_KEY_ALREADY_USED');
413: fnd_message.set_token('TABLE_NAME','ame_rules');
414: fnd_message.raise_error;
415: End If;
416: Close C_Sel2;
417: --
410: -- The primary key values are already in use.
411: --
412: fnd_message.set_name('PER','PER_289391_KEY_ALREADY_USED');
413: fnd_message.set_token('TABLE_NAME','ame_rules');
414: fnd_message.raise_error;
415: End If;
416: Close C_Sel2;
417: --
418: -- Use registered key values and clear globals