DBA Data[Home] [Help]

APPS.PER_JOB_INS dependencies on HR_API

Line 218: When hr_api.check_integrity_violated Then

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));

Line 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

Line 223: When hr_api.parent_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
227: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

Line 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

Line 228: When hr_api.unique_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
232: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

Line 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;

Line 398: when hr_api.cannot_find_prog_unit then

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: );

Line 399: hr_api.cannot_find_prog_unit_error

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;

Line 449: Raise HR_Api.Validate_Enabled;

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

Line 454: When HR_Api.Validate_Enabled Then

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: --