168: per_eco_shd.g_api_dml := false; -- Unset the api dml status
169: --
170: hr_utility.set_location(' Leaving:'||l_proc, 10);
171: Exception
172: When hr_api.check_integrity_violated Then
173: hr_utility.set_location(' Leaving:'||l_proc, 11);
174: -- A check constraint has been violated
175: per_eco_shd.g_api_dml := false; -- Unset the api dml status
176: per_eco_shd.constraint_error
173: hr_utility.set_location(' Leaving:'||l_proc, 11);
174: -- A check constraint has been violated
175: per_eco_shd.g_api_dml := false; -- Unset the api dml status
176: per_eco_shd.constraint_error
177: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
178: When hr_api.parent_integrity_violated Then
179: hr_utility.set_location(' Leaving:'||l_proc, 12);
180: -- Parent integrity has been violated
181: per_eco_shd.g_api_dml := false; -- Unset the api dml status
174: -- A check constraint has been violated
175: per_eco_shd.g_api_dml := false; -- Unset the api dml status
176: per_eco_shd.constraint_error
177: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
178: When hr_api.parent_integrity_violated Then
179: hr_utility.set_location(' Leaving:'||l_proc, 12);
180: -- Parent integrity has been violated
181: per_eco_shd.g_api_dml := false; -- Unset the api dml status
182: per_eco_shd.constraint_error
179: hr_utility.set_location(' Leaving:'||l_proc, 12);
180: -- Parent integrity has been violated
181: per_eco_shd.g_api_dml := false; -- Unset the api dml status
182: per_eco_shd.constraint_error
183: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
184: When hr_api.unique_integrity_violated Then
185: hr_utility.set_location(' Leaving:'||l_proc, 13);
186: -- Unique integrity has been violated
187: per_eco_shd.g_api_dml := false; -- Unset the api dml status
180: -- Parent integrity has been violated
181: per_eco_shd.g_api_dml := false; -- Unset the api dml status
182: per_eco_shd.constraint_error
183: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
184: When hr_api.unique_integrity_violated Then
185: hr_utility.set_location(' Leaving:'||l_proc, 13);
186: -- Unique integrity has been violated
187: per_eco_shd.g_api_dml := false; -- Unset the api dml status
188: per_eco_shd.constraint_error
185: hr_utility.set_location(' Leaving:'||l_proc, 13);
186: -- Unique integrity has been violated
187: per_eco_shd.g_api_dml := false; -- Unset the api dml status
188: per_eco_shd.constraint_error
189: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
190: When Others Then
191: hr_utility.set_location(' Leaving:'||l_proc, 14);
192: per_eco_shd.g_api_dml := false; -- Unset the api dml status
193: Raise;
371: );
372: --
373: exception
374: --
375: when hr_api.cannot_find_prog_unit then
376: --
377: hr_api.cannot_find_prog_unit_error
378: (p_module_name => 'PER_ELECTION_CONSTITUENCYS'
379: ,p_hook_type => 'AI');
373: exception
374: --
375: when hr_api.cannot_find_prog_unit then
376: --
377: hr_api.cannot_find_prog_unit_error
378: (p_module_name => 'PER_ELECTION_CONSTITUENCYS'
379: ,p_hook_type => 'AI');
380: --
381: end;
431: --
432: -- If we are validating then raise the Validate_Enabled exception
433: --
434: If p_validate then
435: Raise HR_Api.Validate_Enabled;
436: End If;
437: --
438: hr_utility.set_location(' Leaving:'||l_proc, 10);
439: Exception
436: End If;
437: --
438: hr_utility.set_location(' Leaving:'||l_proc, 10);
439: Exception
440: When HR_Api.Validate_Enabled Then
441: --
442: -- As the Validate_Enabled exception has been raised
443: -- we must rollback to the savepoint
444: --