211: per_grd_shd.g_api_dml := false; -- Unset the api dml status
212: --
213: hr_utility.set_location(' Leaving:'||l_proc, 10);
214: Exception
215: When hr_api.check_integrity_violated Then
216: hr_utility.set_location(' Leaving:'||l_proc, 20);
217: -- A check constraint has been violated
218: per_grd_shd.g_api_dml := false; -- Unset the api dml status
219: per_grd_shd.constraint_error
216: hr_utility.set_location(' Leaving:'||l_proc, 20);
217: -- A check constraint has been violated
218: per_grd_shd.g_api_dml := false; -- Unset the api dml status
219: per_grd_shd.constraint_error
220: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
221: When hr_api.parent_integrity_violated Then
222: hr_utility.set_location(' Leaving:'||l_proc, 30);
223: -- Parent integrity has been violated
224: per_grd_shd.g_api_dml := false; -- Unset the api dml status
217: -- A check constraint has been violated
218: per_grd_shd.g_api_dml := false; -- Unset the api dml status
219: per_grd_shd.constraint_error
220: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
221: When hr_api.parent_integrity_violated Then
222: hr_utility.set_location(' Leaving:'||l_proc, 30);
223: -- Parent integrity has been violated
224: per_grd_shd.g_api_dml := false; -- Unset the api dml status
225: per_grd_shd.constraint_error
222: hr_utility.set_location(' Leaving:'||l_proc, 30);
223: -- Parent integrity has been violated
224: per_grd_shd.g_api_dml := false; -- Unset the api dml status
225: per_grd_shd.constraint_error
226: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
227: When hr_api.unique_integrity_violated Then
228: hr_utility.set_location(' Leaving:'||l_proc, 40);
229: -- Unique integrity has been violated
230: per_grd_shd.g_api_dml := false; -- Unset the api dml status
223: -- Parent integrity has been violated
224: per_grd_shd.g_api_dml := false; -- Unset the api dml status
225: per_grd_shd.constraint_error
226: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
227: When hr_api.unique_integrity_violated Then
228: hr_utility.set_location(' Leaving:'||l_proc, 40);
229: -- Unique integrity has been violated
230: per_grd_shd.g_api_dml := false; -- Unset the api dml status
231: per_grd_shd.constraint_error
228: hr_utility.set_location(' Leaving:'||l_proc, 40);
229: -- Unique integrity has been violated
230: per_grd_shd.g_api_dml := false; -- Unset the api dml status
231: per_grd_shd.constraint_error
232: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
233: When Others Then
234: hr_utility.set_location(' Leaving:'||l_proc, 50);
235: per_grd_shd.g_api_dml := false; -- Unset the api dml status
236: Raise;
488: );
489: --
490: exception
491: --
492: when hr_api.cannot_find_prog_unit then
493: --
494: hr_api.cannot_find_prog_unit_error
495: (p_module_name => 'PER_GRADES'
496: ,p_hook_type => 'AI');
490: exception
491: --
492: when hr_api.cannot_find_prog_unit then
493: --
494: hr_api.cannot_find_prog_unit_error
495: (p_module_name => 'PER_GRADES'
496: ,p_hook_type => 'AI');
497: --
498: end;