512: --
513: --
514: hr_utility.set_location(' Leaving:'||l_proc, 10);
515: Exception
516: When hr_api.check_integrity_violated Then
517: -- A check constraint has been violated
518: ghr_par_shd.constraint_error
519: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
520: When hr_api.parent_integrity_violated Then
515: Exception
516: When hr_api.check_integrity_violated Then
517: -- A check constraint has been violated
518: ghr_par_shd.constraint_error
519: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
520: When hr_api.parent_integrity_violated Then
521: -- Parent integrity has been violated
522: ghr_par_shd.constraint_error
523: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
516: When hr_api.check_integrity_violated Then
517: -- A check constraint has been violated
518: ghr_par_shd.constraint_error
519: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
520: When hr_api.parent_integrity_violated Then
521: -- Parent integrity has been violated
522: ghr_par_shd.constraint_error
523: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
524: When hr_api.unique_integrity_violated Then
519: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
520: When hr_api.parent_integrity_violated Then
521: -- Parent integrity has been violated
522: ghr_par_shd.constraint_error
523: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
524: When hr_api.unique_integrity_violated Then
525: -- Unique integrity has been violated
526: ghr_par_shd.constraint_error
527: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
520: When hr_api.parent_integrity_violated Then
521: -- Parent integrity has been violated
522: ghr_par_shd.constraint_error
523: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
524: When hr_api.unique_integrity_violated Then
525: -- Unique integrity has been violated
526: ghr_par_shd.constraint_error
527: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
528: When Others Then
523: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
524: When hr_api.unique_integrity_violated Then
525: -- Unique integrity has been violated
526: ghr_par_shd.constraint_error
527: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
528: When Others Then
529: Raise;
530: End insert_dml;
531: --
854: p_mass_action_select_flag => p_rec.mass_action_select_flag,
855: p_mass_action_comments => p_rec.mass_action_comments
856: );
857: exception
858: when hr_api.cannot_find_prog_unit then
859: hr_api.cannot_find_prog_unit_error
860: ( p_module_name => 'GHR_PA_REQUESTS'
861: ,p_hook_type => 'AI'
862: );
855: p_mass_action_comments => p_rec.mass_action_comments
856: );
857: exception
858: when hr_api.cannot_find_prog_unit then
859: hr_api.cannot_find_prog_unit_error
860: ( p_module_name => 'GHR_PA_REQUESTS'
861: ,p_hook_type => 'AI'
862: );
863: end;