222: --
223: hr_utility.set_location(' Leaving:'||l_proc, 15);
224: --
225: Exception
226: When hr_api.check_integrity_violated Then
227: -- A check constraint has been violated
228: per_ptu_shd.constraint_error
229: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
230: When hr_api.unique_integrity_violated Then
225: Exception
226: When hr_api.check_integrity_violated Then
227: -- A check constraint has been violated
228: per_ptu_shd.constraint_error
229: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
230: When hr_api.unique_integrity_violated Then
231: -- Unique integrity has been violated
232: per_ptu_shd.constraint_error
233: (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: per_ptu_shd.constraint_error
229: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
230: When hr_api.unique_integrity_violated Then
231: -- Unique integrity has been violated
232: per_ptu_shd.constraint_error
233: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
234: When Others Then
229: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
230: When hr_api.unique_integrity_violated Then
231: -- Unique integrity has been violated
232: per_ptu_shd.constraint_error
233: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
234: When Others Then
235: Raise;
236: End dt_insert_dml;
237: --
424: ,p_effective_date => p_effective_date
425: ,p_validation_start_date => p_validation_start_date
426: ,p_validation_end_date => p_validation_end_date );
427: exception
428: when hr_api.cannot_find_prog_unit then
429: hr_api.cannot_find_prog_unit_error
430: (p_module_name => 'PER_PERSON_TYPE_USAGES_F'
431: ,p_hook_type => 'AI'
432: );
425: ,p_validation_start_date => p_validation_start_date
426: ,p_validation_end_date => p_validation_end_date );
427: exception
428: when hr_api.cannot_find_prog_unit then
429: hr_api.cannot_find_prog_unit_error
430: (p_module_name => 'PER_PERSON_TYPE_USAGES_F'
431: ,p_hook_type => 'AI'
432: );
433: end;
481: --
482: -- Post Failure:
483: -- The Lck process can fail for:
484: -- 1) When attempting to lock the row the row could already be locked by
485: -- another user. This will raise the HR_Api.Object_Locked exception.
486: -- 2) When attempting to the lock the parent which doesn't exist.
487: -- For the entity to be locked the parent must exist!
488: --
489: -- Developer Implementation Notes: