137: -- The previous 'old' created row has not been found. We need
138: -- to error as an internal datetrack problem exists.
139: --
140: Close C_Sel1;
141: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
142: fnd_message.set_token('PROCEDURE', l_proc);
143: fnd_message.set_token('STEP','10');
144: fnd_message.raise_error;
145: End If;
138: -- to error as an internal datetrack problem exists.
139: --
140: Close C_Sel1;
141: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
142: fnd_message.set_token('PROCEDURE', l_proc);
143: fnd_message.set_token('STEP','10');
144: fnd_message.raise_error;
145: End If;
146: Close C_Sel1;
139: --
140: Close C_Sel1;
141: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
142: fnd_message.set_token('PROCEDURE', l_proc);
143: fnd_message.set_token('STEP','10');
144: fnd_message.raise_error;
145: End If;
146: Close C_Sel1;
147: --
140: Close C_Sel1;
141: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
142: fnd_message.set_token('PROCEDURE', l_proc);
143: fnd_message.set_token('STEP','10');
144: fnd_message.raise_error;
145: End If;
146: Close C_Sel1;
147: --
148: -- Set the AOL updated WHO values
336: Close C_Sel2;
337: --
338: -- The primary key values are already in use.
339: --
340: fnd_message.set_name('PER','PER_289391_KEY_ALREADY_USED');
341: fnd_message.set_token('TABLE_NAME','pay_grade_rules_f');
342: fnd_message.raise_error;
343: End If;
344: Close C_Sel2;
337: --
338: -- The primary key values are already in use.
339: --
340: fnd_message.set_name('PER','PER_289391_KEY_ALREADY_USED');
341: fnd_message.set_token('TABLE_NAME','pay_grade_rules_f');
342: fnd_message.raise_error;
343: End If;
344: Close C_Sel2;
345: --
338: -- The primary key values are already in use.
339: --
340: fnd_message.set_name('PER','PER_289391_KEY_ALREADY_USED');
341: fnd_message.set_token('TABLE_NAME','pay_grade_rules_f');
342: fnd_message.raise_error;
343: End If;
344: Close C_Sel2;
345: --
346: -- Use registered key values and clear globals