88: --
89: --
90: hr_utility.set_location(' Leaving:'||l_proc, 10);
91: Exception
92: When hr_api.check_integrity_violated Then
93: -- A check constraint has been violated
94: --
95: ota_tcc_shd.constraint_error
96: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
92: When hr_api.check_integrity_violated Then
93: -- A check constraint has been violated
94: --
95: ota_tcc_shd.constraint_error
96: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
97: When hr_api.parent_integrity_violated Then
98: -- Parent integrity has been violated
99: --
100: ota_tcc_shd.constraint_error
93: -- A check constraint has been violated
94: --
95: ota_tcc_shd.constraint_error
96: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
97: When hr_api.parent_integrity_violated Then
98: -- Parent integrity has been violated
99: --
100: ota_tcc_shd.constraint_error
101: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
97: When hr_api.parent_integrity_violated Then
98: -- Parent integrity has been violated
99: --
100: ota_tcc_shd.constraint_error
101: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
102: When hr_api.unique_integrity_violated Then
103: -- Unique integrity has been violated
104: --
105: ota_tcc_shd.constraint_error
98: -- Parent integrity has been violated
99: --
100: ota_tcc_shd.constraint_error
101: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
102: When hr_api.unique_integrity_violated Then
103: -- Unique integrity has been violated
104: --
105: ota_tcc_shd.constraint_error
106: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
102: When hr_api.unique_integrity_violated Then
103: -- Unique integrity has been violated
104: --
105: ota_tcc_shd.constraint_error
106: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
107: When Others Then
108: --
109: Raise;
110: End insert_dml;
231: );
232: --
233: exception
234: --
235: when hr_api.cannot_find_prog_unit then
236: --
237: hr_api.cannot_find_prog_unit_error
238: (p_module_name => 'OTA_CROSS_CHARGES'
239: ,p_hook_type => 'AI');
233: exception
234: --
235: when hr_api.cannot_find_prog_unit then
236: --
237: hr_api.cannot_find_prog_unit_error
238: (p_module_name => 'OTA_CROSS_CHARGES'
239: ,p_hook_type => 'AI');
240: --
241: end;
287: ,p_rec
288: );
289: --
290: If p_validate then
291: Raise HR_Api.Validate_Enabled;
292: End If;
293:
294: hr_utility.set_location('Leaving:'||l_proc, 20);
295: Exception
292: End If;
293:
294: hr_utility.set_location('Leaving:'||l_proc, 20);
295: Exception
296: When HR_Api.Validate_Enabled Then
297: --
298: -- As the Validate_Enabled exception has been raised
299: -- we must rollback to the savepoint
300: --