222: --
223: --
224: hr_utility.set_location(' Leaving:'||l_proc, 10);
225: Exception
226: When hr_api.check_integrity_violated Then
227: -- A check constraint has been violated
228: --
229: per_pgv_shd.constraint_error
230: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
226: When hr_api.check_integrity_violated Then
227: -- A check constraint has been violated
228: --
229: per_pgv_shd.constraint_error
230: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
231: When hr_api.parent_integrity_violated Then
232: -- Parent integrity has been violated
233: --
234: per_pgv_shd.constraint_error
227: -- A check constraint has been violated
228: --
229: per_pgv_shd.constraint_error
230: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
231: When hr_api.parent_integrity_violated Then
232: -- Parent integrity has been violated
233: --
234: per_pgv_shd.constraint_error
235: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
231: When hr_api.parent_integrity_violated Then
232: -- Parent integrity has been violated
233: --
234: per_pgv_shd.constraint_error
235: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
236: When hr_api.unique_integrity_violated Then
237: -- Unique integrity has been violated
238: --
239: per_pgv_shd.constraint_error
232: -- Parent integrity has been violated
233: --
234: per_pgv_shd.constraint_error
235: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
236: When hr_api.unique_integrity_violated Then
237: -- Unique integrity has been violated
238: --
239: per_pgv_shd.constraint_error
240: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
236: When hr_api.unique_integrity_violated Then
237: -- Unique integrity has been violated
238: --
239: per_pgv_shd.constraint_error
240: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
241: When Others Then
242: --
243: Raise;
244: End insert_dml;
499: );
500: --
501: exception
502: --
503: when hr_api.cannot_find_prog_unit then
504: --
505: hr_api.cannot_find_prog_unit_error
506: (p_module_name => 'PER_GEN_HIERARCHY_VERSIONS'
507: ,p_hook_type => 'AI');
501: exception
502: --
503: when hr_api.cannot_find_prog_unit then
504: --
505: hr_api.cannot_find_prog_unit_error
506: (p_module_name => 'PER_GEN_HIERARCHY_VERSIONS'
507: ,p_hook_type => 'AI');
508: --
509: end;