[Home] [Help]
127:
128: hr_utility.set_location(' Leaving:' || l_proc,20);
129: Exception
130: when app_exception.application_exception then
131: IF hr_multi_message.exception_add
132: (p_associated_column1 =>
133: 'HR_KI_HIERARCHY_NODE_MAPS.HIERARCHY_ID'
134: ) THEN
135: hr_utility.set_location(' Leaving:'|| l_proc,30);
203:
204: hr_utility.set_location(' Leaving:' || l_proc,20);
205: Exception
206: when app_exception.application_exception then
207: IF hr_multi_message.exception_add
208: (p_associated_column1 =>
209: 'HR_KI_HIERARCHY_NODE_MAPS.TOPIC_ID'
210: ) THEN
211: hr_utility.set_location(' Leaving:'|| l_proc,30);
280:
281: hr_utility.set_location(' Leaving:' || l_proc,20);
282: Exception
283: when app_exception.application_exception then
284: IF hr_multi_message.exception_add
285: (p_associated_column1 =>
286: 'HR_KI_HIERARCHY_NODE_MAPS.USER_INTERFACE_ID'
287: ) THEN
288: hr_utility.set_location(' Leaving:'|| l_proc,30);
368: hr_utility.set_location(' Leaving:' || l_proc,20);
369:
370: Exception
371: when app_exception.application_exception then
372: IF hr_multi_message.exception_add
373: (p_associated_column1 =>
374: 'HR_KI_HIERARCHY_NODE_MAPS.HIERARCHY_ID',
375: p_associated_column2 =>
376: 'HR_KI_HIERARCHY_NODE_MAPS.TOPIC_ID',
501: -- the following validation needs to be done only if no errors have already
502: -- been detected previously, an inclusive error check needs to be done to
503: -- accomodate errors occuring from the first chk_valid_combination check.
504:
505: if hr_multi_message.no_all_inclusive_error
506: (p_check_column1 =>
507: 'HR_KI_HIERARCHY_NODE_MAPS.HIERARCHY_ID'
508: ,p_check_column2 =>
509: 'HR_KI_HIERARCHY_NODE_MAPS.TOPIC_ID'
573: hr_utility.set_location(' Leaving:' || l_proc,20);
574:
575: Exception
576: when app_exception.application_exception then
577: IF hr_multi_message.exception_add
578: (p_associated_column1 =>
579: 'HR_KI_HIERARCHY_NODE_MAPS.HIERARCHY_ID',
580: p_associated_column2 =>
581: 'HR_KI_HIERARCHY_NODE_MAPS.TOPIC_ID',