163: --
164: --
165: hr_utility.set_location(' Leaving:'||l_proc, 10);
166: Exception
167: When hr_api.check_integrity_violated Then
168: -- A check constraint has been violated
169: --
170: ota_ctu_shd.constraint_error
171: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
167: When hr_api.check_integrity_violated Then
168: -- A check constraint has been violated
169: --
170: ota_ctu_shd.constraint_error
171: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
172: When hr_api.parent_integrity_violated Then
173: -- Parent integrity has been violated
174: --
175: ota_ctu_shd.constraint_error
168: -- A check constraint has been violated
169: --
170: ota_ctu_shd.constraint_error
171: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
172: When hr_api.parent_integrity_violated Then
173: -- Parent integrity has been violated
174: --
175: ota_ctu_shd.constraint_error
176: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
172: When hr_api.parent_integrity_violated Then
173: -- Parent integrity has been violated
174: --
175: ota_ctu_shd.constraint_error
176: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
177: When hr_api.unique_integrity_violated Then
178: -- Unique integrity has been violated
179: --
180: ota_ctu_shd.constraint_error
173: -- Parent integrity has been violated
174: --
175: ota_ctu_shd.constraint_error
176: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
177: When hr_api.unique_integrity_violated Then
178: -- Unique integrity has been violated
179: --
180: ota_ctu_shd.constraint_error
181: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
177: When hr_api.unique_integrity_violated Then
178: -- Unique integrity has been violated
179: --
180: ota_ctu_shd.constraint_error
181: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
182: When Others Then
183: --
184: Raise;
185: End insert_dml;
390: );
391: --
392: exception
393: --
394: when hr_api.cannot_find_prog_unit then
395: --
396: hr_api.cannot_find_prog_unit_error
397: (p_module_name => 'OTA_CATEGORY_USAGES'
398: ,p_hook_type => 'AI');
392: exception
393: --
394: when hr_api.cannot_find_prog_unit then
395: --
396: hr_api.cannot_find_prog_unit_error
397: (p_module_name => 'OTA_CATEGORY_USAGES'
398: ,p_hook_type => 'AI');
399: --
400: end;