173: per_suc_shd.g_api_dml := false; -- Unset the api dml status
174: --
175: hr_utility.set_location(' Leaving:'||l_proc, 10);
176: Exception
177: When hr_api.check_integrity_violated Then
178: -- A check constraint has been violated
179: per_suc_shd.g_api_dml := false; -- Unset the api dml status
180: per_suc_shd.constraint_error
181: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
177: When hr_api.check_integrity_violated Then
178: -- A check constraint has been violated
179: per_suc_shd.g_api_dml := false; -- Unset the api dml status
180: per_suc_shd.constraint_error
181: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
182: When hr_api.parent_integrity_violated Then
183: -- Parent integrity has been violated
184: per_suc_shd.g_api_dml := false; -- Unset the api dml status
185: per_suc_shd.constraint_error
178: -- A check constraint has been violated
179: per_suc_shd.g_api_dml := false; -- Unset the api dml status
180: per_suc_shd.constraint_error
181: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
182: When hr_api.parent_integrity_violated Then
183: -- Parent integrity has been violated
184: per_suc_shd.g_api_dml := false; -- Unset the api dml status
185: per_suc_shd.constraint_error
186: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
182: When hr_api.parent_integrity_violated Then
183: -- Parent integrity has been violated
184: per_suc_shd.g_api_dml := false; -- Unset the api dml status
185: per_suc_shd.constraint_error
186: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
187: When hr_api.unique_integrity_violated Then
188: -- Unique integrity has been violated
189: per_suc_shd.g_api_dml := false; -- Unset the api dml status
190: per_suc_shd.constraint_error
183: -- Parent integrity has been violated
184: per_suc_shd.g_api_dml := false; -- Unset the api dml status
185: per_suc_shd.constraint_error
186: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
187: When hr_api.unique_integrity_violated Then
188: -- Unique integrity has been violated
189: per_suc_shd.g_api_dml := false; -- Unset the api dml status
190: per_suc_shd.constraint_error
191: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
187: When hr_api.unique_integrity_violated Then
188: -- Unique integrity has been violated
189: per_suc_shd.g_api_dml := false; -- Unset the api dml status
190: per_suc_shd.constraint_error
191: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
192: When Others Then
193: per_suc_shd.g_api_dml := false; -- Unset the api dml status
194: Raise;
195: End insert_dml;
337: p_job_id => p_rec.job_id,
338: p_successee_person_id => p_rec.successee_person_id
339: );
340: exception
341: when hr_api.cannot_find_prog_unit then
342: hr_api.cannot_find_prog_unit_error
343: (p_module_name => 'PER_SUCCESSION_PLANNING'
344: ,p_hook_type => 'AI'
345: );
338: p_successee_person_id => p_rec.successee_person_id
339: );
340: exception
341: when hr_api.cannot_find_prog_unit then
342: hr_api.cannot_find_prog_unit_error
343: (p_module_name => 'PER_SUCCESSION_PLANNING'
344: ,p_hook_type => 'AI'
345: );
346: end;