162: per_pea_shd.g_api_dml := false; -- Unset the api dml status
163: --
164: hr_utility.set_location(' Leaving:'||l_proc, 10);
165: Exception
166: When hr_api.check_integrity_violated Then
167: -- A check constraint has been violated
168: per_pea_shd.g_api_dml := false; -- Unset the api dml status
169: per_pea_shd.constraint_error
170: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
166: When hr_api.check_integrity_violated Then
167: -- A check constraint has been violated
168: per_pea_shd.g_api_dml := false; -- Unset the api dml status
169: per_pea_shd.constraint_error
170: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
171: When hr_api.parent_integrity_violated Then
172: -- Parent integrity has been violated
173: per_pea_shd.g_api_dml := false; -- Unset the api dml status
174: per_pea_shd.constraint_error
167: -- A check constraint has been violated
168: per_pea_shd.g_api_dml := false; -- Unset the api dml status
169: per_pea_shd.constraint_error
170: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
171: When hr_api.parent_integrity_violated Then
172: -- Parent integrity has been violated
173: per_pea_shd.g_api_dml := false; -- Unset the api dml status
174: per_pea_shd.constraint_error
175: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
171: When hr_api.parent_integrity_violated Then
172: -- Parent integrity has been violated
173: per_pea_shd.g_api_dml := false; -- Unset the api dml status
174: per_pea_shd.constraint_error
175: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
176: When hr_api.unique_integrity_violated Then
177: -- Unique integrity has been violated
178: per_pea_shd.g_api_dml := false; -- Unset the api dml status
179: per_pea_shd.constraint_error
172: -- Parent integrity has been violated
173: per_pea_shd.g_api_dml := false; -- Unset the api dml status
174: per_pea_shd.constraint_error
175: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
176: When hr_api.unique_integrity_violated Then
177: -- Unique integrity has been violated
178: per_pea_shd.g_api_dml := false; -- Unset the api dml status
179: per_pea_shd.constraint_error
180: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
176: When hr_api.unique_integrity_violated Then
177: -- Unique integrity has been violated
178: per_pea_shd.g_api_dml := false; -- Unset the api dml status
179: per_pea_shd.constraint_error
180: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
181: When Others Then
182: per_pea_shd.g_api_dml := false; -- Unset the api dml status
183: Raise;
184: End insert_dml;
396:
397: -- End of BEN LER Check
398:
399: exception
400: when hr_api.cannot_find_prog_unit then
401: hr_api.cannot_find_prog_unit_error
402: (p_module_name => 'PER_PERSON_ANALYSES'
403: ,p_hook_type => 'AI'
404: );
397: -- End of BEN LER Check
398:
399: exception
400: when hr_api.cannot_find_prog_unit then
401: hr_api.cannot_find_prog_unit_error
402: (p_module_name => 'PER_PERSON_ANALYSES'
403: ,p_hook_type => 'AI'
404: );
405: end;
461: --
462: -- If we are validating then raise the Validate_Enabled exception
463: --
464: If p_validate then
465: Raise HR_Api.Validate_Enabled;
466: End If;
467: --
468: hr_utility.set_location(' Leaving:'||l_proc, 10);
469: Exception
466: End If;
467: --
468: hr_utility.set_location(' Leaving:'||l_proc, 10);
469: Exception
470: When HR_Api.Validate_Enabled Then
471: --
472: -- As the Validate_Enabled exception has been raised
473: -- we must rollback to the savepoint
474: --