109: --
110: --
111: hr_utility.set_location(' Leaving:'||l_proc, 10);
112: Exception
113: When hr_api.check_integrity_violated Then
114: -- A check constraint has been violated
115: --
116: ota_cpr_shd.constraint_error
117: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
113: When hr_api.check_integrity_violated Then
114: -- A check constraint has been violated
115: --
116: ota_cpr_shd.constraint_error
117: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
118: When hr_api.parent_integrity_violated Then
119: -- Parent integrity has been violated
120: --
121: ota_cpr_shd.constraint_error
114: -- A check constraint has been violated
115: --
116: ota_cpr_shd.constraint_error
117: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
118: When hr_api.parent_integrity_violated Then
119: -- Parent integrity has been violated
120: --
121: ota_cpr_shd.constraint_error
122: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
118: When hr_api.parent_integrity_violated Then
119: -- Parent integrity has been violated
120: --
121: ota_cpr_shd.constraint_error
122: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
123: When hr_api.unique_integrity_violated Then
124: -- Unique integrity has been violated
125: --
126: ota_cpr_shd.constraint_error
119: -- Parent integrity has been violated
120: --
121: ota_cpr_shd.constraint_error
122: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
123: When hr_api.unique_integrity_violated Then
124: -- Unique integrity has been violated
125: --
126: ota_cpr_shd.constraint_error
127: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
123: When hr_api.unique_integrity_violated Then
124: -- Unique integrity has been violated
125: --
126: ota_cpr_shd.constraint_error
127: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
128: When Others Then
129: --
130: Raise;
131: End insert_dml;
293: );
294: --
295: exception
296: --
297: when hr_api.cannot_find_prog_unit then
298: --
299: hr_api.cannot_find_prog_unit_error
300: (p_module_name => 'OTA_COURSE_PREREQUISITES'
301: ,p_hook_type => 'AI');
295: exception
296: --
297: when hr_api.cannot_find_prog_unit then
298: --
299: hr_api.cannot_find_prog_unit_error
300: (p_module_name => 'OTA_COURSE_PREREQUISITES'
301: ,p_hook_type => 'AI');
302: --
303: end;