134: -- The previous 'old' created row has not been found. We need
135: -- to error as an internal datetrack problem exists.
136: --
137: Close C_Sel1;
138: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
139: fnd_message.set_token('PROCEDURE', l_proc);
140: fnd_message.set_token('STEP','10');
141: fnd_message.raise_error;
142: End If;
135: -- to error as an internal datetrack problem exists.
136: --
137: Close C_Sel1;
138: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
139: fnd_message.set_token('PROCEDURE', l_proc);
140: fnd_message.set_token('STEP','10');
141: fnd_message.raise_error;
142: End If;
143: Close C_Sel1;
136: --
137: Close C_Sel1;
138: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
139: fnd_message.set_token('PROCEDURE', l_proc);
140: fnd_message.set_token('STEP','10');
141: fnd_message.raise_error;
142: End If;
143: Close C_Sel1;
144: --
137: Close C_Sel1;
138: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
139: fnd_message.set_token('PROCEDURE', l_proc);
140: fnd_message.set_token('STEP','10');
141: fnd_message.raise_error;
142: End If;
143: Close C_Sel1;
144: --
145: -- Set the AOL updated WHO values
393: Close C_Sel2;
394: --
395: -- The primary key values are already in use.
396: --
397: fnd_message.set_name('PER','PER_289391_KEY_ALREADY_USED');
398: fnd_message.set_token('TABLE_NAME','hr_de_soc_ins_contr_lvls_f');
399: fnd_message.raise_error;
400: End If;
401: Close C_Sel2;
394: --
395: -- The primary key values are already in use.
396: --
397: fnd_message.set_name('PER','PER_289391_KEY_ALREADY_USED');
398: fnd_message.set_token('TABLE_NAME','hr_de_soc_ins_contr_lvls_f');
399: fnd_message.raise_error;
400: End If;
401: Close C_Sel2;
402: --
395: -- The primary key values are already in use.
396: --
397: fnd_message.set_name('PER','PER_289391_KEY_ALREADY_USED');
398: fnd_message.set_token('TABLE_NAME','hr_de_soc_ins_contr_lvls_f');
399: fnd_message.raise_error;
400: End If;
401: Close C_Sel2;
402: --
403: -- Use registered key values and clear globals