126: -- The previous 'old' created row has not been found. We need
127: -- to error as an internal datetrack problem exists.
128: --
129: Close C_Sel1;
130: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
131: fnd_message.set_token('PROCEDURE', l_proc);
132: fnd_message.set_token('STEP','10');
133: fnd_message.raise_error;
134: End If;
127: -- to error as an internal datetrack problem exists.
128: --
129: Close C_Sel1;
130: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
131: fnd_message.set_token('PROCEDURE', l_proc);
132: fnd_message.set_token('STEP','10');
133: fnd_message.raise_error;
134: End If;
135: Close C_Sel1;
128: --
129: Close C_Sel1;
130: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
131: fnd_message.set_token('PROCEDURE', l_proc);
132: fnd_message.set_token('STEP','10');
133: fnd_message.raise_error;
134: End If;
135: Close C_Sel1;
136: --
129: Close C_Sel1;
130: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
131: fnd_message.set_token('PROCEDURE', l_proc);
132: fnd_message.set_token('STEP','10');
133: fnd_message.raise_error;
134: End If;
135: Close C_Sel1;
136: --
137: -- Set the AOL updated WHO values
359: Close C_Sel2;
360: --
361: -- The primary key values are already in use.
362: --
363: fnd_message.set_name('PER','PER_289391_KEY_ALREADY_USED');
364: fnd_message.set_token('TABLE_NAME','ben_elig_org_unit_prte_f');
365: fnd_message.raise_error;
366: End If;
367: Close C_Sel2;
360: --
361: -- The primary key values are already in use.
362: --
363: fnd_message.set_name('PER','PER_289391_KEY_ALREADY_USED');
364: fnd_message.set_token('TABLE_NAME','ben_elig_org_unit_prte_f');
365: fnd_message.raise_error;
366: End If;
367: Close C_Sel2;
368: --
361: -- The primary key values are already in use.
362: --
363: fnd_message.set_name('PER','PER_289391_KEY_ALREADY_USED');
364: fnd_message.set_token('TABLE_NAME','ben_elig_org_unit_prte_f');
365: fnd_message.raise_error;
366: End If;
367: Close C_Sel2;
368: --
369: -- Use registered key values and clear globals