232: --
233: --
234: hr_utility.set_location(' Leaving:'||l_proc, 10);
235: Exception
236: When hr_api.check_integrity_violated Then
237: -- A check constraint has been violated
238: --
239: per_eca_shd.constraint_error
240: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
236: When hr_api.check_integrity_violated Then
237: -- A check constraint has been violated
238: --
239: per_eca_shd.constraint_error
240: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
241: When hr_api.parent_integrity_violated Then
242: -- Parent integrity has been violated
243: --
244: per_eca_shd.constraint_error
237: -- A check constraint has been violated
238: --
239: per_eca_shd.constraint_error
240: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
241: When hr_api.parent_integrity_violated Then
242: -- Parent integrity has been violated
243: --
244: per_eca_shd.constraint_error
245: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
241: When hr_api.parent_integrity_violated Then
242: -- Parent integrity has been violated
243: --
244: per_eca_shd.constraint_error
245: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
246: When hr_api.unique_integrity_violated Then
247: -- Unique integrity has been violated
248: --
249: per_eca_shd.constraint_error
242: -- Parent integrity has been violated
243: --
244: per_eca_shd.constraint_error
245: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
246: When hr_api.unique_integrity_violated Then
247: -- Unique integrity has been violated
248: --
249: per_eca_shd.constraint_error
250: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
246: When hr_api.unique_integrity_violated Then
247: -- Unique integrity has been violated
248: --
249: per_eca_shd.constraint_error
250: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
251: When Others Then
252: --
253: Raise;
254: End insert_dml;
495: );
496: --
497: exception
498: --
499: when hr_api.cannot_find_prog_unit then
500: --
501: hr_api.cannot_find_prog_unit_error
502: (p_module_name => 'PER_ELECTION_CANDIDATES'
503: ,p_hook_type => 'AI');
497: exception
498: --
499: when hr_api.cannot_find_prog_unit then
500: --
501: hr_api.cannot_find_prog_unit_error
502: (p_module_name => 'PER_ELECTION_CANDIDATES'
503: ,p_hook_type => 'AI');
504: --
505: end;
552: --
553: -- If we are validating then raise the Validate_Enabled exception
554: --
555: If p_validate then
556: Raise HR_Api.Validate_Enabled;
557: End If;
558: --
559: hr_utility.set_location('Leaving:'||l_proc, 20);
560: Exception
557: End If;
558: --
559: hr_utility.set_location('Leaving:'||l_proc, 20);
560: Exception
561: When HR_Api.Validate_Enabled Then
562: --
563: -- As the Validate_Enabled exception has been raised
564: -- we must rollback to the savepoint
565: --