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
513: Close C_Sel2;
514: --
515: -- The primary key values are already in use.
516: --
517: fnd_message.set_name('PER','PER_289391_KEY_ALREADY_USED');
518: fnd_message.set_token('TABLE_NAME','pay_element_types_f');
519: fnd_message.raise_error;
520: End If;
521: Close C_Sel2;
514: --
515: -- The primary key values are already in use.
516: --
517: fnd_message.set_name('PER','PER_289391_KEY_ALREADY_USED');
518: fnd_message.set_token('TABLE_NAME','pay_element_types_f');
519: fnd_message.raise_error;
520: End If;
521: Close C_Sel2;
522: --
515: -- The primary key values are already in use.
516: --
517: fnd_message.set_name('PER','PER_289391_KEY_ALREADY_USED');
518: fnd_message.set_token('TABLE_NAME','pay_element_types_f');
519: fnd_message.raise_error;
520: End If;
521: Close C_Sel2;
522: --
523: -- Use registered key values and clear globals