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