178: --
179: --
180: hr_utility.set_location(' Leaving:'||l_proc, 10);
181: Exception
182: When hr_api.check_integrity_violated Then
183: -- A check constraint has been violated
184: --
185: ota_lme_shd.constraint_error
186: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
182: When hr_api.check_integrity_violated Then
183: -- A check constraint has been violated
184: --
185: ota_lme_shd.constraint_error
186: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
187: When hr_api.parent_integrity_violated Then
188: -- Parent integrity has been violated
189: --
190: ota_lme_shd.constraint_error
183: -- A check constraint has been violated
184: --
185: ota_lme_shd.constraint_error
186: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
187: When hr_api.parent_integrity_violated Then
188: -- Parent integrity has been violated
189: --
190: ota_lme_shd.constraint_error
191: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
187: When hr_api.parent_integrity_violated Then
188: -- Parent integrity has been violated
189: --
190: ota_lme_shd.constraint_error
191: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
192: When hr_api.unique_integrity_violated Then
193: -- Unique integrity has been violated
194: --
195: ota_lme_shd.constraint_error
188: -- Parent integrity has been violated
189: --
190: ota_lme_shd.constraint_error
191: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
192: When hr_api.unique_integrity_violated Then
193: -- Unique integrity has been violated
194: --
195: ota_lme_shd.constraint_error
196: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
192: When hr_api.unique_integrity_violated Then
193: -- Unique integrity has been violated
194: --
195: ota_lme_shd.constraint_error
196: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
197: When Others Then
198: --
199: Raise;
200: End insert_dml;
423: );
424: --
425: exception
426: --
427: when hr_api.cannot_find_prog_unit then
428: --
429: hr_api.cannot_find_prog_unit_error
430: (p_module_name => 'OTA_LP_MEMBER_ENROLLMENTS'
431: ,p_hook_type => 'AI');
425: exception
426: --
427: when hr_api.cannot_find_prog_unit then
428: --
429: hr_api.cannot_find_prog_unit_error
430: (p_module_name => 'OTA_LP_MEMBER_ENROLLMENTS'
431: ,p_hook_type => 'AI');
432: --
433: end;