121: fnd_message.raise_error;
122: end if;
123: close chk_exist_orig_system ;
124: exception
125: when app_exception.application_exception then
126: if hr_multi_message.exception_add
127: (p_associated_column1 => 'ame_approver_types.orig_system') then
128: raise;
129: end if;
185: close csr_name;
186: --
187: hr_utility.set_location(' Leaving:'||l_proc,30);
188: exception
189: when app_exception.application_exception then
190: if hr_multi_message.exception_add
191: (p_associated_column1 => 'ame_approver_types.UNIQUE'
192: ) then
193: hr_utility.set_location(' Leaving:'||l_proc, 40);
370: end if;
371: close c_sel5;
372: hr_utility.set_location(' Leaving:'||l_proc,30);
373: exception
374: when app_exception.application_exception then
375: if hr_multi_message.exception_add
376: (p_associated_column1 => 'AME_APPROVER_TYPE.DELETE'
377: ) then
378: hr_utility.set_location(' Leaving:'||l_proc, 40);