143: --
144: hr_utility.set_location(' Leaving:' || l_proc,40);
145: Exception
146: when app_exception.application_exception then
147: IF hr_multi_message.exception_add
148: (p_associated_column1 => 'HR_KI_HIERARCHIES.HIERARCHY_KEY'
149: )
150: THEN
151: hr_utility.set_location(' Leaving:'|| l_proc,50);
255: hr_utility.set_location(' Leaving:'|| l_proc,60);
256:
257: Exception
258: when app_exception.application_exception then
259: If hr_multi_message.exception_add
260: (p_associated_column1 =>
261: 'HR_KI_HIERARCHIES.PARENT_HIERARCHY_ID'
262: ) THEN
263: hr_utility.set_location(' Leaving:'|| l_proc,70);
318: hr_utility.set_location(' Leaving:' || l_proc,30);
319:
320: Exception
321: when app_exception.application_exception then
322: IF hr_multi_message.exception_add
323: (p_associated_column1 =>'HR_KI_HIERARCHIES.PARENT_HIERARCHY_ID'
324: )THEN
325: hr_utility.set_location(' Leaving:'|| l_proc,40);
326: raise;
400: hr_utility.set_location(' Leaving:' || l_proc,30);
401:
402: Exception
403: when app_exception.application_exception then
404: IF hr_multi_message.exception_add
405: (p_associated_column1 =>'HR_KI_HIERARCHIES.PARENT_HIERARCHY_ID'
406: )THEN
407: hr_utility.set_location(' Leaving:'|| l_proc,40);
408: raise;
506: hr_utility.set_location(' Leaving:' || l_proc,20);
507:
508: Exception
509: when app_exception.application_exception then
510: IF hr_multi_message.exception_add
511: (p_associated_column1 => 'HR_KI_HIERARCHIES.HIERARCHY_ID'
512: )THEN
513: hr_utility.set_location(' Leaving:'|| l_proc,30);
514: raise;