188: --
189: --
190: hr_utility.set_location(' Leaving:'||l_proc, 10);
191: Exception
192: When hr_api.check_integrity_violated Then
193: -- A check constraint has been violated
194: per_cag_shd.constraint_error
195: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
196: When hr_api.parent_integrity_violated Then
191: Exception
192: When hr_api.check_integrity_violated Then
193: -- A check constraint has been violated
194: per_cag_shd.constraint_error
195: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
196: When hr_api.parent_integrity_violated Then
197: -- Parent integrity has been violated
198: per_cag_shd.constraint_error
199: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
192: When hr_api.check_integrity_violated Then
193: -- A check constraint has been violated
194: per_cag_shd.constraint_error
195: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
196: When hr_api.parent_integrity_violated Then
197: -- Parent integrity has been violated
198: per_cag_shd.constraint_error
199: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
200: When hr_api.unique_integrity_violated Then
195: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
196: When hr_api.parent_integrity_violated Then
197: -- Parent integrity has been violated
198: per_cag_shd.constraint_error
199: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
200: When hr_api.unique_integrity_violated Then
201: -- Unique integrity has been violated
202: per_cag_shd.constraint_error
203: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
196: When hr_api.parent_integrity_violated Then
197: -- Parent integrity has been violated
198: per_cag_shd.constraint_error
199: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
200: When hr_api.unique_integrity_violated Then
201: -- Unique integrity has been violated
202: per_cag_shd.constraint_error
203: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
204: When Others Then
199: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
200: When hr_api.unique_integrity_violated Then
201: -- Unique integrity has been violated
202: per_cag_shd.constraint_error
203: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
204: When Others Then
205: Raise;
206: End insert_dml;
207: --
369: );
370: --
371: exception
372: --
373: when hr_api.cannot_find_prog_unit then
374: --
375: hr_api.cannot_find_prog_unit_error
376: (p_module_name => 'per_collective_agreements'
377: ,p_hook_type => 'AI');
371: exception
372: --
373: when hr_api.cannot_find_prog_unit then
374: --
375: hr_api.cannot_find_prog_unit_error
376: (p_module_name => 'per_collective_agreements'
377: ,p_hook_type => 'AI');
378: --
379: end;