131: -- The previous 'old' created row has not been found. We need
132: -- to error as an internal datetrack problem exists.
133: --
134: Close C_Sel1;
135: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
136: fnd_message.set_token('PROCEDURE', l_proc);
137: fnd_message.set_token('STEP','10');
138: fnd_message.raise_error;
139: End If;
132: -- to error as an internal datetrack problem exists.
133: --
134: Close C_Sel1;
135: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
136: fnd_message.set_token('PROCEDURE', l_proc);
137: fnd_message.set_token('STEP','10');
138: fnd_message.raise_error;
139: End If;
140: Close C_Sel1;
133: --
134: Close C_Sel1;
135: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
136: fnd_message.set_token('PROCEDURE', l_proc);
137: fnd_message.set_token('STEP','10');
138: fnd_message.raise_error;
139: End If;
140: Close C_Sel1;
141: --
134: Close C_Sel1;
135: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
136: fnd_message.set_token('PROCEDURE', l_proc);
137: fnd_message.set_token('STEP','10');
138: fnd_message.raise_error;
139: End If;
140: Close C_Sel1;
141: --
142: --
338: Close C_Sel2;
339: --
340: -- The primary key values are already in use.
341: --
342: fnd_message.set_name('PER','PER_289391_KEY_ALREADY_USED');
343: fnd_message.set_token('TABLE_NAME','irc_interview_details');
344: fnd_message.raise_error;
345: End If;
346: Close C_Sel2;
339: --
340: -- The primary key values are already in use.
341: --
342: fnd_message.set_name('PER','PER_289391_KEY_ALREADY_USED');
343: fnd_message.set_token('TABLE_NAME','irc_interview_details');
344: fnd_message.raise_error;
345: End If;
346: Close C_Sel2;
347: --
340: -- The primary key values are already in use.
341: --
342: fnd_message.set_name('PER','PER_289391_KEY_ALREADY_USED');
343: fnd_message.set_token('TABLE_NAME','irc_interview_details');
344: fnd_message.raise_error;
345: End If;
346: Close C_Sel2;
347: --
348: -- Use registered key values and clear globals