68: --
69: hr_utility.set_location(' Leaving:'||l_proc, 100);
70: --
71: Exception
72: When hr_api.child_integrity_violated then
73: hr_utility.set_location(' Leaving:'||l_proc, 80);
74: -- Child integrity has been violated
75: per_grd_shd.g_api_dml := false; -- Unset the api dml status
76: per_grd_shd.constraint_error
73: hr_utility.set_location(' Leaving:'||l_proc, 80);
74: -- Child integrity has been violated
75: per_grd_shd.g_api_dml := false; -- Unset the api dml status
76: per_grd_shd.constraint_error
77: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
78: When Others Then
79: hr_utility.set_location(' Leaving:'||l_proc, 90);
80: per_grd_shd.g_api_dml := false; -- Unset the api dml status
81: Raise;
277: );
278: --
279: exception
280: --
281: when hr_api.cannot_find_prog_unit then
282: --
283: hr_api.cannot_find_prog_unit_error
284: (p_module_name => 'PER_GRADES'
285: ,p_hook_type => 'AD');
279: exception
280: --
281: when hr_api.cannot_find_prog_unit then
282: --
283: hr_api.cannot_find_prog_unit_error
284: (p_module_name => 'PER_GRADES'
285: ,p_hook_type => 'AD');
286: --
287: end;