167: hr_utility.set_location(' Leaving:'||l_proc,30);
168: exception
169: when app_exception.application_exception then
170: if hr_multi_message.exception_add
171: (p_associated_column1 => 'HR_KI_OPTIONS.OPTION_TYPE_ID'
172: )then
173: hr_utility.set_location(' Leaving:'||l_proc, 40);
174: raise;
175: end if;
230:
231: exception
232: when app_exception.application_exception then
233: if hr_multi_message.exception_add
234: (p_associated_column1 => 'HR_KI_OPTIONS.OPTION_LEVEL'
235: )then
236: hr_utility.set_location(' Leaving:'||l_proc, 30);
237: raise;
238: end if;
316: -- Multiple Message List does not already contain an errors
317: -- associated with the OPTION_LEVEL column.
318: --
319: if hr_multi_message.no_exclusive_error
320: (p_check_column1 => 'HR_KI_OPTIONS.OPTION_LEVEL'
321: ,p_associated_column1 => 'HR_KI_OPTIONS.OPTION_LEVEL'
322: ) then
323:
324:
317: -- associated with the OPTION_LEVEL column.
318: --
319: if hr_multi_message.no_exclusive_error
320: (p_check_column1 => 'HR_KI_OPTIONS.OPTION_LEVEL'
321: ,p_associated_column1 => 'HR_KI_OPTIONS.OPTION_LEVEL'
322: ) then
323:
324:
325: --check if level is NOT SITE
489:
490: exception
491: when app_exception.application_exception then
492: if hr_multi_message.exception_add
493: (p_associated_column1 => 'HR_KI_OPTIONS.ENCRYPTED'
494: )then
495: hr_utility.set_location(' Leaving:'||l_proc, 30);
496: raise;
497: end if;
563: hr_utility.set_location(' Leaving:'||l_proc,40);
564: exception
565: when app_exception.application_exception then
566: if hr_multi_message.exception_add
567: (p_associated_column1 => 'HR_KI_OPTIONS.INTEGRATION_ID'
568: )then
569: hr_utility.set_location(' Leaving:'||l_proc, 50);
570: raise;
571: end if;
611: l_found varchar2(1);
612:
613: cursor csr_int_options is
614: select null
615: from hr_ki_options
616: where (option_type_id = p_option_type_id
617: and integration_id = p_integration_id
618: and option_level=p_option_level)
619: and (option_level_id=p_option_level_id
627: -- associated with the OPTION_TYPE_ID,INTEGRATION_ID,OPTION_LEVEL
628: -- OPTION_LEVEL_ID columns.
629: --
630: if hr_multi_message.no_exclusive_error
631: (p_check_column1 => 'HR_KI_OPTIONS.OPTION_TYPE_ID'
632: ,p_associated_column1 => 'HR_KI_OPTIONS.OPTION_TYPE_ID'
633: ,p_check_column2 => 'HR_KI_OPTIONS.INTEGRATION_ID'
634: ,p_associated_column2 => 'HR_KI_OPTIONS.INTEGRATION_ID'
635: ,p_check_column3 => 'HR_KI_OPTIONS.OPTION_LEVEL'
628: -- OPTION_LEVEL_ID columns.
629: --
630: if hr_multi_message.no_exclusive_error
631: (p_check_column1 => 'HR_KI_OPTIONS.OPTION_TYPE_ID'
632: ,p_associated_column1 => 'HR_KI_OPTIONS.OPTION_TYPE_ID'
633: ,p_check_column2 => 'HR_KI_OPTIONS.INTEGRATION_ID'
634: ,p_associated_column2 => 'HR_KI_OPTIONS.INTEGRATION_ID'
635: ,p_check_column3 => 'HR_KI_OPTIONS.OPTION_LEVEL'
636: ,p_associated_column3 => 'HR_KI_OPTIONS.OPTION_LEVEL'
629: --
630: if hr_multi_message.no_exclusive_error
631: (p_check_column1 => 'HR_KI_OPTIONS.OPTION_TYPE_ID'
632: ,p_associated_column1 => 'HR_KI_OPTIONS.OPTION_TYPE_ID'
633: ,p_check_column2 => 'HR_KI_OPTIONS.INTEGRATION_ID'
634: ,p_associated_column2 => 'HR_KI_OPTIONS.INTEGRATION_ID'
635: ,p_check_column3 => 'HR_KI_OPTIONS.OPTION_LEVEL'
636: ,p_associated_column3 => 'HR_KI_OPTIONS.OPTION_LEVEL'
637: ,p_check_column4 => 'HR_KI_OPTIONS.OPTION_LEVEL_ID'
630: if hr_multi_message.no_exclusive_error
631: (p_check_column1 => 'HR_KI_OPTIONS.OPTION_TYPE_ID'
632: ,p_associated_column1 => 'HR_KI_OPTIONS.OPTION_TYPE_ID'
633: ,p_check_column2 => 'HR_KI_OPTIONS.INTEGRATION_ID'
634: ,p_associated_column2 => 'HR_KI_OPTIONS.INTEGRATION_ID'
635: ,p_check_column3 => 'HR_KI_OPTIONS.OPTION_LEVEL'
636: ,p_associated_column3 => 'HR_KI_OPTIONS.OPTION_LEVEL'
637: ,p_check_column4 => 'HR_KI_OPTIONS.OPTION_LEVEL_ID'
638: ,p_associated_column4 => 'HR_KI_OPTIONS.OPTION_LEVEL_ID'
631: (p_check_column1 => 'HR_KI_OPTIONS.OPTION_TYPE_ID'
632: ,p_associated_column1 => 'HR_KI_OPTIONS.OPTION_TYPE_ID'
633: ,p_check_column2 => 'HR_KI_OPTIONS.INTEGRATION_ID'
634: ,p_associated_column2 => 'HR_KI_OPTIONS.INTEGRATION_ID'
635: ,p_check_column3 => 'HR_KI_OPTIONS.OPTION_LEVEL'
636: ,p_associated_column3 => 'HR_KI_OPTIONS.OPTION_LEVEL'
637: ,p_check_column4 => 'HR_KI_OPTIONS.OPTION_LEVEL_ID'
638: ,p_associated_column4 => 'HR_KI_OPTIONS.OPTION_LEVEL_ID'
639: ) then
632: ,p_associated_column1 => 'HR_KI_OPTIONS.OPTION_TYPE_ID'
633: ,p_check_column2 => 'HR_KI_OPTIONS.INTEGRATION_ID'
634: ,p_associated_column2 => 'HR_KI_OPTIONS.INTEGRATION_ID'
635: ,p_check_column3 => 'HR_KI_OPTIONS.OPTION_LEVEL'
636: ,p_associated_column3 => 'HR_KI_OPTIONS.OPTION_LEVEL'
637: ,p_check_column4 => 'HR_KI_OPTIONS.OPTION_LEVEL_ID'
638: ,p_associated_column4 => 'HR_KI_OPTIONS.OPTION_LEVEL_ID'
639: ) then
640:
633: ,p_check_column2 => 'HR_KI_OPTIONS.INTEGRATION_ID'
634: ,p_associated_column2 => 'HR_KI_OPTIONS.INTEGRATION_ID'
635: ,p_check_column3 => 'HR_KI_OPTIONS.OPTION_LEVEL'
636: ,p_associated_column3 => 'HR_KI_OPTIONS.OPTION_LEVEL'
637: ,p_check_column4 => 'HR_KI_OPTIONS.OPTION_LEVEL_ID'
638: ,p_associated_column4 => 'HR_KI_OPTIONS.OPTION_LEVEL_ID'
639: ) then
640:
641: open csr_int_options;
634: ,p_associated_column2 => 'HR_KI_OPTIONS.INTEGRATION_ID'
635: ,p_check_column3 => 'HR_KI_OPTIONS.OPTION_LEVEL'
636: ,p_associated_column3 => 'HR_KI_OPTIONS.OPTION_LEVEL'
637: ,p_check_column4 => 'HR_KI_OPTIONS.OPTION_LEVEL_ID'
638: ,p_associated_column4 => 'HR_KI_OPTIONS.OPTION_LEVEL_ID'
639: ) then
640:
641: open csr_int_options;
642: fetch csr_int_options into l_found;