161: fnd_message.raise_error;
162: end if;
163: --
164: hr_utility.set_location(' Leaving: '||l_proc, 50);
165: exception when app_exception.application_exception then
166: if hr_multi_message.exception_add
167: (p_associated_column1 => 'HR_QUESTIONNAIRES.NAME'
168: ) then
169: hr_utility.set_location(' Leaving:'|| l_proc, 60);
202: fnd_message.raise_error;
203: end if;
204: --
205: hr_utility.set_location('Leaving: '||l_proc,50);
206: exception when app_exception.application_exception then
207: if hr_multi_message.exception_add
208: (p_associated_column1 => 'HR_QUESTIONNAIRES.TEXT'
209: ) then
210: hr_utility.set_location(' Leaving:'|| l_proc, 60);
265: null;
266: end if;
267: --
268: hr_utility.set_location('Leaving: '||l_proc,50);
269: exception when app_exception.application_exception then
270: if hr_multi_message.exception_add
271: (p_associated_column1 => 'HR_QUESTIONNAIRES.AVAILABLE_FLAG'
272: ) then
273: hr_utility.set_location(' Leaving:'|| l_proc, 60);
314: end if;
315: close csr_chk_child_row;
316: --
317: hr_utility.set_location('Leaving: '||l_proc, 20);
318: exception when app_exception.application_exception then
319: if hr_multi_message.exception_add
320: (p_associated_column1 => 'HR_QUESTIONNAIRES.AVAILABLE_FLAG'
321: ) then
322: hr_utility.set_location(' Leaving:'|| l_proc, 30);