143: -- The previous 'old' created row has not been found. We need
144: -- to error as an internal datetrack problem exists.
145: --
146: Close C_Sel1;
147: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
148: fnd_message.set_token('PROCEDURE', l_proc);
149: fnd_message.set_token('STEP','10');
150: fnd_message.raise_error;
151: End If;
144: -- to error as an internal datetrack problem exists.
145: --
146: Close C_Sel1;
147: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
148: fnd_message.set_token('PROCEDURE', l_proc);
149: fnd_message.set_token('STEP','10');
150: fnd_message.raise_error;
151: End If;
152: Close C_Sel1;
145: --
146: Close C_Sel1;
147: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
148: fnd_message.set_token('PROCEDURE', l_proc);
149: fnd_message.set_token('STEP','10');
150: fnd_message.raise_error;
151: End If;
152: Close C_Sel1;
153: --
146: Close C_Sel1;
147: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
148: fnd_message.set_token('PROCEDURE', l_proc);
149: fnd_message.set_token('STEP','10');
150: fnd_message.raise_error;
151: End If;
152: Close C_Sel1;
153: --
154: -- Set the AOL updated WHO values
325: Close C_Sel2;
326: --
327: -- The primary key values are already in use.
328: --
329: fnd_message.set_name('PER','PER_289391_KEY_ALREADY_USED');
330: fnd_message.set_token('TABLE_NAME','irc_assignment_details_f');
331: fnd_message.raise_error;
332: End If;
333: Close C_Sel2;
326: --
327: -- The primary key values are already in use.
328: --
329: fnd_message.set_name('PER','PER_289391_KEY_ALREADY_USED');
330: fnd_message.set_token('TABLE_NAME','irc_assignment_details_f');
331: fnd_message.raise_error;
332: End If;
333: Close C_Sel2;
334: --
327: -- The primary key values are already in use.
328: --
329: fnd_message.set_name('PER','PER_289391_KEY_ALREADY_USED');
330: fnd_message.set_token('TABLE_NAME','irc_assignment_details_f');
331: fnd_message.raise_error;
332: End If;
333: Close C_Sel2;
334: --
335: -- Use registered key values and clear globals