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
361: Close C_Sel2;
362: --
363: -- The primary key values are already in use.
364: --
365: fnd_message.set_name('PER','PER_289391_KEY_ALREADY_USED');
366: fnd_message.set_token('TABLE_NAME','pay_event_value_changes_f');
367: fnd_message.raise_error;
368: End If;
369: Close C_Sel2;
362: --
363: -- The primary key values are already in use.
364: --
365: fnd_message.set_name('PER','PER_289391_KEY_ALREADY_USED');
366: fnd_message.set_token('TABLE_NAME','pay_event_value_changes_f');
367: fnd_message.raise_error;
368: End If;
369: Close C_Sel2;
370: --
363: -- The primary key values are already in use.
364: --
365: fnd_message.set_name('PER','PER_289391_KEY_ALREADY_USED');
366: fnd_message.set_token('TABLE_NAME','pay_event_value_changes_f');
367: fnd_message.raise_error;
368: End If;
369: Close C_Sel2;
370: --
371: -- Use registered key values and clear globals