214: per_job_shd.g_api_dml := false; -- Unset the api dml status
215: --
216: hr_utility.set_location(' Leaving:'||l_proc, 10);
217: Exception
218: When hr_api.check_integrity_violated Then
219: -- A check constraint has been violated
220: per_job_shd.g_api_dml := false; -- Unset the api dml status
221: per_job_shd.constraint_error
222: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
218: When hr_api.check_integrity_violated Then
219: -- A check constraint has been violated
220: per_job_shd.g_api_dml := false; -- Unset the api dml status
221: per_job_shd.constraint_error
222: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
223: When hr_api.parent_integrity_violated Then
224: -- Parent integrity has been violated
225: per_job_shd.g_api_dml := false; -- Unset the api dml status
226: per_job_shd.constraint_error
219: -- A check constraint has been violated
220: per_job_shd.g_api_dml := false; -- Unset the api dml status
221: per_job_shd.constraint_error
222: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
223: When hr_api.parent_integrity_violated Then
224: -- Parent integrity has been violated
225: per_job_shd.g_api_dml := false; -- Unset the api dml status
226: per_job_shd.constraint_error
227: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
223: When hr_api.parent_integrity_violated Then
224: -- Parent integrity has been violated
225: per_job_shd.g_api_dml := false; -- Unset the api dml status
226: per_job_shd.constraint_error
227: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
228: When hr_api.unique_integrity_violated Then
229: -- Unique integrity has been violated
230: per_job_shd.g_api_dml := false; -- Unset the api dml status
231: per_job_shd.constraint_error
224: -- Parent integrity has been violated
225: per_job_shd.g_api_dml := false; -- Unset the api dml status
226: per_job_shd.constraint_error
227: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
228: When hr_api.unique_integrity_violated Then
229: -- Unique integrity has been violated
230: per_job_shd.g_api_dml := false; -- Unset the api dml status
231: per_job_shd.constraint_error
232: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
228: When hr_api.unique_integrity_violated Then
229: -- Unique integrity has been violated
230: per_job_shd.g_api_dml := false; -- Unset the api dml status
231: per_job_shd.constraint_error
232: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
233: When Others Then
234: per_job_shd.g_api_dml := false; -- Unset the api dml status
235: Raise;
236: End insert_dml;
394: p_job_group_id => p_rec.job_group_id,
395: p_object_version_number => p_rec.object_version_number
396: );
397: exception
398: when hr_api.cannot_find_prog_unit then
399: hr_api.cannot_find_prog_unit_error
400: (p_module_name => 'PER_JOBS'
401: ,p_hook_type => 'AI'
402: );
395: p_object_version_number => p_rec.object_version_number
396: );
397: exception
398: when hr_api.cannot_find_prog_unit then
399: hr_api.cannot_find_prog_unit_error
400: (p_module_name => 'PER_JOBS'
401: ,p_hook_type => 'AI'
402: );
403: end;
445: --
446: -- If we are validating then raise the Validate_Enabled exception
447: --
448: If p_validate then
449: Raise HR_Api.Validate_Enabled;
450: End If;
451: --
452: hr_utility.set_location(' Leaving:'||l_proc, 10);
453: Exception
450: End If;
451: --
452: hr_utility.set_location(' Leaving:'||l_proc, 10);
453: Exception
454: When HR_Api.Validate_Enabled Then
455: --
456: -- As the Validate_Enabled exception has been raised
457: -- we must rollback to the savepoint
458: --