66: --
67: hr_utility.set_location(' Leaving:'||l_proc, 10);
68: --
69: Exception
70: When hr_api.child_integrity_violated then
71: -- Child integrity has been violated
72: per_qua_shd.g_api_dml := false; -- Unset the api dml status
73: per_qua_shd.constraint_error
74: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
70: When hr_api.child_integrity_violated then
71: -- Child integrity has been violated
72: per_qua_shd.g_api_dml := false; -- Unset the api dml status
73: per_qua_shd.constraint_error
74: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
75: When Others Then
76: per_qua_shd.g_api_dml := false; -- Unset the api dml status
77: Raise;
78: End delete_dml;
237: p_subscription_payment_meth_o => per_qua_shd.g_old_rec.subscription_payment_method,
238: p_party_id_o => per_qua_shd.g_old_rec.party_id
239: );
240: exception
241: when hr_api.cannot_find_prog_unit then
242: hr_api.cannot_find_prog_unit_error
243: (p_module_name => 'PER_QUALIFICATIONS'
244: ,p_hook_type => 'AD'
245: );
238: p_party_id_o => per_qua_shd.g_old_rec.party_id
239: );
240: exception
241: when hr_api.cannot_find_prog_unit then
242: hr_api.cannot_find_prog_unit_error
243: (p_module_name => 'PER_QUALIFICATIONS'
244: ,p_hook_type => 'AD'
245: );
246: end;
307: --
308: -- If we are validating then raise the Validate_Enabled exception
309: --
310: If p_validate then
311: Raise HR_Api.Validate_Enabled;
312: End If;
313: --
314: hr_utility.set_location(' Leaving:'||l_proc, 10);
315: Exception
312: End If;
313: --
314: hr_utility.set_location(' Leaving:'||l_proc, 10);
315: Exception
316: When HR_Api.Validate_Enabled Then
317: --
318: -- As the Validate_Enabled exception has been raised
319: -- we must rollback to the savepoint
320: --