260: Close C_link_input_value_id;
261: --
262: -- The primary key is invalid
263: --
264: fnd_message.set_name('PAY', 'HR_7220_INVALID_PRIMARY_KEY');
265: fnd_message.raise_error;
266: End if;
267: Close C_link_input_value_id;
268: --
261: --
262: -- The primary key is invalid
263: --
264: fnd_message.set_name('PAY', 'HR_7220_INVALID_PRIMARY_KEY');
265: fnd_message.raise_error;
266: End if;
267: Close C_link_input_value_id;
268: --
269: -- Get the lookup code for the default value
280: --
281: -- Raise error is lookup validation fails.
282: --
283: If l_default_value is null then
284: fnd_message.set_name('PAY', 'PAY_6171_INPVAL_NO_LOOKUP');
285: fnd_message.raise_error;
286: End if;
287: End if;
288: --
281: -- Raise error is lookup validation fails.
282: --
283: If l_default_value is null then
284: fnd_message.set_name('PAY', 'PAY_6171_INPVAL_NO_LOOKUP');
285: fnd_message.raise_error;
286: End if;
287: End if;
288: --
289: -- Call Before Process User Hook
488: -- An error is raised if the datetrack_delete_mode is either 'ZAP' or
489: -- 'DELETE' when this API is executed as a stand alone procedure.
490: --
491: If p_datetrack_delete_mode in ('ZAP','DELETE') then
492: fnd_message.set_name('PAY','HR_7098_INPVAL_NO_CHANGES');
493: fnd_message.raise_error;
494: End if;
495: --
496: -- Process Logic
489: -- 'DELETE' when this API is executed as a stand alone procedure.
490: --
491: If p_datetrack_delete_mode in ('ZAP','DELETE') then
492: fnd_message.set_name('PAY','HR_7098_INPVAL_NO_CHANGES');
493: fnd_message.raise_error;
494: End if;
495: --
496: -- Process Logic
497: --