139: end if;
140: --
141: hr_utility.set_location('Leaving: '||l_proc,50);
142:
143: exception when app_exception.application_exception then
144: if hr_multi_message.exception_add
145: (p_associated_column1 => 'HR_QUEST_FIELDS.QUESTIONNAIRE_TEMPLATE_ID'
146: ) then
147: hr_utility.set_location(' Leaving:'|| l_proc, 60);
173: end if;
174: --
175: hr_utility.set_location('Leaving: '||l_proc,20);
176:
177: exception when app_exception.application_exception then
178: if hr_multi_message.exception_add
179: (p_associated_column1 => 'HR_QUEST_FIELDS.NAME'
180: ) then
181: hr_utility.set_location(' Leaving:'|| l_proc, 30);
216: end if;
217: --
218: hr_utility.set_location('Leaving: '||l_proc,20);
219:
220: exception when app_exception.application_exception then
221: if hr_multi_message.exception_add
222: (p_associated_column1 => 'HR_QUEST_FIELDS.TYPE'
223: ) then
224: hr_utility.set_location(' Leaving:'|| l_proc, 30);
259: end if;
260: --
261: hr_utility.set_location('Leaving: '||l_proc,20);
262:
263: exception when app_exception.application_exception then
264: if hr_multi_message.exception_add
265: (p_associated_column1 => 'HR_QUEST_FIELDS.HTML_TEXT'
266: ) then
267: hr_utility.set_location(' Leaving:'|| l_proc, 30);
303: end if;
304: --
305: hr_utility.set_location('Leaving: '||l_proc,20);
306:
307: exception when app_exception.application_exception then
308: if hr_multi_message.exception_add
309: (p_associated_column1 => 'HR_QUEST_FIELDS.SQL_REQUIRED_FLAG'
310: ) then
311: hr_utility.set_location(' Leaving:'|| l_proc, 30);