238: fnd_message.raise_error;
239: End If;
240: Close c_case_group_NUMBER;
241: Exception
242: when app_exception.application_exception then
243: if hr_multi_message.exception_add
244: (p_associated_column1 => 'PQH_DE_case_groupS.ADVANCEMENT_TO'
245: ) then
246: hr_utility.set_location(' Leaving:'||l_proc,60);
273: hr_utility.raise_error;
274: End If;
275: Close Del;
276: Exception
277: when app_exception.application_exception then
278: if hr_multi_message.exception_add
279: (p_associated_column1 => 'PQH_DE_CASE_GROUPS.CASE_GROUP_NUMBER'
280: ) then
281: hr_utility.set_location(' Leaving:'||l_proc,60);
307: fnd_message.raise_error;
308: End If;
309: Close c_case_group_NUMBER;
310: Exception
311: when app_exception.application_exception then
312: if hr_multi_message.exception_add
313: (p_associated_column1 => 'PQH_DE_case_groupS.case_group_NUMBER'
314: ) then
315: hr_utility.set_location(' Leaving:'||l_proc,60);