70: close csr_chk_bg_id;
71: --
72: hr_utility.set_location(' Leaving:'||l_proc,20);
73: exception
74: when app_exception.application_exception then
75: if hr_multi_message.exception_add
76: (p_associated_column1 => 'IRC_LOCATION_PREFERENCES.BUSINESS_GROUP_ID'
77: ) then
78: hr_utility.set_location(' Leaving:'|| l_proc, 25);
139: close csr_chk_country_code;
140: --
141: hr_utility.set_location(' Leaving:'||l_proc,20);
142: exception
143: when app_exception.application_exception then
144: if hr_multi_message.exception_add
145: (p_associated_column1 => 'IRC_LOCATION_PREFERENCES.COUNTRY_CODE'
146: ) then
147: hr_utility.set_location(' Leaving:'|| l_proc, 25);
208: close csr_chk_loc_id;
209: --
210: hr_utility.set_location(' Leaving:'||l_proc,20);
211: exception
212: when app_exception.application_exception then
213: if hr_multi_message.exception_add
214: (p_associated_column1 => 'IRC_LOCATION_PREFERENCES.LOCATION_ID'
215: ) then
216: hr_utility.set_location(' Leaving:'|| l_proc, 25);
283: close csr_chk_duplicate_loc_pref;
284: --
285: hr_utility.set_location(' Leaving:'||l_proc,20);
286: exception
287: when app_exception.application_exception then
288: if hr_multi_message.exception_add
289: (p_associated_column1 => 'IRC_LOCATION_PREFERENCES.OBJECT_ID'
290: ,p_associated_column2 => 'IRC_LOCATION_PREFERENCES.OBJECT_TYPE'
291: ) then