218: --
219: --
220: hr_utility.set_location(' Leaving:'||l_proc, 10);
221: Exception
222: When hr_api.check_integrity_violated Then
223: -- A check constraint has been violated
224: --
225: per_pmp_shd.constraint_error
226: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
222: When hr_api.check_integrity_violated Then
223: -- A check constraint has been violated
224: --
225: per_pmp_shd.constraint_error
226: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
227: When hr_api.parent_integrity_violated Then
228: -- Parent integrity has been violated
229: --
230: per_pmp_shd.constraint_error
223: -- A check constraint has been violated
224: --
225: per_pmp_shd.constraint_error
226: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
227: When hr_api.parent_integrity_violated Then
228: -- Parent integrity has been violated
229: --
230: per_pmp_shd.constraint_error
231: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
227: When hr_api.parent_integrity_violated Then
228: -- Parent integrity has been violated
229: --
230: per_pmp_shd.constraint_error
231: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
232: When hr_api.unique_integrity_violated Then
233: -- Unique integrity has been violated
234: --
235: per_pmp_shd.constraint_error
228: -- Parent integrity has been violated
229: --
230: per_pmp_shd.constraint_error
231: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
232: When hr_api.unique_integrity_violated Then
233: -- Unique integrity has been violated
234: --
235: per_pmp_shd.constraint_error
236: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
232: When hr_api.unique_integrity_violated Then
233: -- Unique integrity has been violated
234: --
235: per_pmp_shd.constraint_error
236: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
237: When Others Then
238: --
239: Raise;
240: End insert_dml;
506: );
507: --
508: exception
509: --
510: when hr_api.cannot_find_prog_unit then
511: --
512: hr_api.cannot_find_prog_unit_error
513: (p_module_name => 'PER_PERF_MGMT_PLANS'
514: ,p_hook_type => 'AI');
508: exception
509: --
510: when hr_api.cannot_find_prog_unit then
511: --
512: hr_api.cannot_find_prog_unit_error
513: (p_module_name => 'PER_PERF_MGMT_PLANS'
514: ,p_hook_type => 'AI');
515: --
516: end;