116: fnd_message.raise_error;
117: end if;
118: close c_sel1;
119: exception
120: when app_exception.application_exception then
121: if hr_multi_message.exception_add
122: (p_associated_column1 => 'ACTION_TYPE_ID') then
123: hr_utility.set_location(' Leaving:'|| l_proc, 50);
124: raise;
200: end if;
201: end if;
202: close c_sel1;
203: exception
204: when app_exception.application_exception then
205: if hr_multi_message.exception_add
206: (p_associated_column1 => 'APPROVER_TYPE_ID') then
207: hr_utility.set_location(' Leaving:'|| l_proc, 50);
208: raise;
261: fnd_message.raise_error;
262: end if;
263: close c_sel1;
264: exception
265: when app_exception.application_exception then
266: if hr_multi_message.exception_add
267: (p_associated_column1 => 'ACTION_TYPE_ID') then
268: hr_utility.set_location(' Leaving:'|| l_proc, 50);
269: raise;