194:
195: --
196:
197: exception
198: when app_exception.application_exception then
199: if hr_multi_message.exception_add
200: (p_associated_column1 => per_pso_shd.g_tab_nam||'.ORGANIZATION_ID'
201: ) then
202: hr_utility.set_location(' Leaving:'|| l_proc, 40);
230: END IF;
231:
232: --
233: exception
234: when app_exception.application_exception then
235: if hr_multi_message.exception_add
236: (p_associated_column1 => per_pso_shd.g_tab_nam||'.ORGANIZATION_ID'
237: ) then
238: hr_utility.set_location(' Leaving:'|| l_proc, 40);