87: end if;
88: hr_utility.set_location(' Leaving:'||l_proc,30);
89: exception
90: when app_exception.application_exception then
91: if hr_multi_message.exception_add
92: (p_associated_column1 => 'AME_CONFIG_VARS.APPLICATION_ID'
93: ) then
94: hr_utility.set_location(' Leaving:'||l_proc, 40);
95: raise;
154: end if;
155: hr_utility.set_location(' Leaving:'||l_proc,30);
156: exception
157: when app_exception.application_exception then
158: if hr_multi_message.exception_add
159: (p_associated_column1 => 'AME_CONFIG_VARS.APPLICATION_ID'
160: ) then
161: hr_utility.set_location(' Leaving:'||l_proc, 40);
162: raise;
209: fnd_message.raise_error;
210: end if;
211: exception
212: when app_exception.application_exception then
213: if hr_multi_message.exception_add
214: (p_associated_column1 => 'AME_CONFIG_VARS.APPLICATION_ID'
215: ) then
216: hr_utility.set_location(' Leaving:'||l_proc, 40);
217: raise;
276: end if;
277: hr_utility.set_location(' Leaving:'||l_proc,30);
278: exception
279: when app_exception.application_exception then
280: if hr_multi_message.exception_add
281: (p_associated_column1 => 'AME_CONFIG_VARS.VARIABLE_NAME'
282: ) then
283: hr_utility.set_location(' Leaving:'||l_proc, 40);
284: raise;
422: hr_utility.set_location(' Leaving:'||l_proc,30);
423: return true;
424: exception
425: when app_exception.application_exception then
426: if hr_multi_message.exception_add
427: (p_associated_column1 => 'AME_CONFIG_VARS.FORWARDING_BEHAVIOUR'
428: ) then
429: hr_utility.set_location(' Leaving:'||l_proc, 40);
430: raise;
512: hr_utility.set_location(' Leaving:'||l_proc,30);
513: return true;
514: exception
515: when app_exception.application_exception then
516: if hr_multi_message.exception_add
517: (p_associated_column1 => 'AME_CONFIG_VARS.PRIORITY_MODE'
518: ) then
519: hr_utility.set_location(' Leaving:'||l_proc, 40);
520: raise;
572: );
573: --
574: -- Check if the varible value is in appropriate format.
575: --
576: if hr_multi_message.no_all_inclusive_error
577: (p_check_column1 => 'AME_CONFIG_VARS.VARIABLE_NAME') then
578: if(p_variable_name = 'adminApprover') then
579: open csr_role;
580: fetch csr_role into l_key;
657: end if;
658: hr_utility.set_location(' Leaving:'||l_proc,30);
659: exception
660: when app_exception.application_exception then
661: if hr_multi_message.exception_add
662: (p_associated_column1 => 'AME_CONFIG_VARS.VARIABLE_VALUE'
663: ) then
664: hr_utility.set_location(' Leaving:'||l_proc, 40);
665: raise;
714: l_key varchar2(1);
715: --
716: Begin
717: hr_utility.set_location('Entering:'||l_proc,10);
718: if (hr_multi_message.no_all_inclusive_error
719: (p_check_column1 => 'AME_CONFIG_VARS.VARIABLE_NAME')
720: and hr_multi_message.no_all_inclusive_error
721: (p_check_column1 => 'AME_CONFIG_VARS.APPLICATION_ID')) then
722: --
716: Begin
717: hr_utility.set_location('Entering:'||l_proc,10);
718: if (hr_multi_message.no_all_inclusive_error
719: (p_check_column1 => 'AME_CONFIG_VARS.VARIABLE_NAME')
720: and hr_multi_message.no_all_inclusive_error
721: (p_check_column1 => 'AME_CONFIG_VARS.APPLICATION_ID')) then
722: --
723: -- Check if the varible name is already defined for the application.
724: --
760: end if;
761: hr_utility.set_location(' Leaving:'||l_proc,30);
762: exception
763: when app_exception.application_exception then
764: if hr_multi_message.exception_add
765: (p_associated_column1 => 'AME_CONFIG_VARS.APPLICATION_VARIABLE_NAME'
766: ) then
767: hr_utility.set_location(' Leaving:'||l_proc, 40);
768: raise;