eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.HR_QUESTIONNAIRE_SWI dependencies on HR_UTILITY

Line 65: hr_utility.set_location(' Entering:' || l_proc,10);

61: -- Other variables
62: l_questionnaire_template_id number;
63: l_proc varchar2(72) := g_package ||'create_questionnaire';
64: Begin
65: hr_utility.set_location(' Entering:' || l_proc,10);
66: --
67: -- Issue a savepoint
68: --
69: savepoint create_questionnaire_swi;

Line 118: hr_utility.set_location(' Leaving:' || l_proc,20);

114: rollback to create_questionnaire_swi;
115: End If;
116: --
117: p_return_status := hr_multi_message.get_return_status_disable;
118: hr_utility.set_location(' Leaving:' || l_proc,20);
119: --
120: exception
121: when hr_multi_message.error_message_exist then
122: --

Line 133: hr_utility.set_location(' Leaving:' || l_proc, 30);

129: -- Reset IN OUT parameters and set OUT parameters
130: --
131: p_object_version_number := null;
132: p_return_status := hr_multi_message.get_return_status_disable;
133: hr_utility.set_location(' Leaving:' || l_proc, 30);
134: when others then
135: --
136: -- When Multiple Message Detection is enabled catch
137: -- any Application specific or other unexpected

Line 144: hr_utility.set_location(' Leaving:' || l_proc,40);

140: -- error.
141: --
142: rollback to create_questionnaire_swi;
143: if hr_multi_message.unexpected_error_add(l_proc) then
144: hr_utility.set_location(' Leaving:' || l_proc,40);
145: raise;
146: end if;
147: --
148: -- Reset IN OUT and set OUT parameters

Line 152: hr_utility.set_location(' Leaving:' || l_proc,50);

148: -- Reset IN OUT and set OUT parameters
149: --
150: p_object_version_number := null;
151: p_return_status := hr_multi_message.get_return_status_disable;
152: hr_utility.set_location(' Leaving:' || l_proc,50);
153: end create_questionnaire;
154:
155: -- ----------------------------------------------------------------------------
156: -- |-----------------------< update_questionnaire >---------------------------|

Line 189: hr_utility.set_location(' Entering:' || l_proc,10);

185: FROM HR_QUESTIONNAIRES
186: WHERE questionnaire_template_id = p_questionnaire_template_id;
187:
188: Begin
189: hr_utility.set_location(' Entering:' || l_proc,10);
190:
191: --
192: -- Issue a savepoint
193: --

Line 212: hr_utility.set_location(' Values :p_available_flag' ||p_available_flag ,11);

208: (p_constant_value => p_validate);
209: --
210: -- Register Surrogate ID or user key values
211: --
212: hr_utility.set_location(' Values :p_available_flag' ||p_available_flag ,11);
213: hr_utility.set_location(' Values :p_object_version_number' ||p_object_version_number ,11);
214: hr_utility.set_location(' Values :p_effective_date' ||p_effective_date ,11);
215: hr_utility.set_location(' Values :p_questionnaire_template_id' ||p_questionnaire_template_id ,11);
216: hr_utility.set_location(' Values :p_quest_type_code' ||p_quest_type_code ,11);

Line 213: hr_utility.set_location(' Values :p_object_version_number' ||p_object_version_number ,11);

209: --
210: -- Register Surrogate ID or user key values
211: --
212: hr_utility.set_location(' Values :p_available_flag' ||p_available_flag ,11);
213: hr_utility.set_location(' Values :p_object_version_number' ||p_object_version_number ,11);
214: hr_utility.set_location(' Values :p_effective_date' ||p_effective_date ,11);
215: hr_utility.set_location(' Values :p_questionnaire_template_id' ||p_questionnaire_template_id ,11);
216: hr_utility.set_location(' Values :p_quest_type_code' ||p_quest_type_code ,11);
217: hr_utility.set_location(' Values :p_html_text' ||p_text ,11);

Line 214: hr_utility.set_location(' Values :p_effective_date' ||p_effective_date ,11);

210: -- Register Surrogate ID or user key values
211: --
212: hr_utility.set_location(' Values :p_available_flag' ||p_available_flag ,11);
213: hr_utility.set_location(' Values :p_object_version_number' ||p_object_version_number ,11);
214: hr_utility.set_location(' Values :p_effective_date' ||p_effective_date ,11);
215: hr_utility.set_location(' Values :p_questionnaire_template_id' ||p_questionnaire_template_id ,11);
216: hr_utility.set_location(' Values :p_quest_type_code' ||p_quest_type_code ,11);
217: hr_utility.set_location(' Values :p_html_text' ||p_text ,11);
218: hr_utility.set_location(' Values :p_business_group_id' ||p_business_group_id ,11);

Line 215: hr_utility.set_location(' Values :p_questionnaire_template_id' ||p_questionnaire_template_id ,11);

211: --
212: hr_utility.set_location(' Values :p_available_flag' ||p_available_flag ,11);
213: hr_utility.set_location(' Values :p_object_version_number' ||p_object_version_number ,11);
214: hr_utility.set_location(' Values :p_effective_date' ||p_effective_date ,11);
215: hr_utility.set_location(' Values :p_questionnaire_template_id' ||p_questionnaire_template_id ,11);
216: hr_utility.set_location(' Values :p_quest_type_code' ||p_quest_type_code ,11);
217: hr_utility.set_location(' Values :p_html_text' ||p_text ,11);
218: hr_utility.set_location(' Values :p_business_group_id' ||p_business_group_id ,11);
219:

Line 216: hr_utility.set_location(' Values :p_quest_type_code' ||p_quest_type_code ,11);

212: hr_utility.set_location(' Values :p_available_flag' ||p_available_flag ,11);
213: hr_utility.set_location(' Values :p_object_version_number' ||p_object_version_number ,11);
214: hr_utility.set_location(' Values :p_effective_date' ||p_effective_date ,11);
215: hr_utility.set_location(' Values :p_questionnaire_template_id' ||p_questionnaire_template_id ,11);
216: hr_utility.set_location(' Values :p_quest_type_code' ||p_quest_type_code ,11);
217: hr_utility.set_location(' Values :p_html_text' ||p_text ,11);
218: hr_utility.set_location(' Values :p_business_group_id' ||p_business_group_id ,11);
219:
220: --

Line 217: hr_utility.set_location(' Values :p_html_text' ||p_text ,11);

213: hr_utility.set_location(' Values :p_object_version_number' ||p_object_version_number ,11);
214: hr_utility.set_location(' Values :p_effective_date' ||p_effective_date ,11);
215: hr_utility.set_location(' Values :p_questionnaire_template_id' ||p_questionnaire_template_id ,11);
216: hr_utility.set_location(' Values :p_quest_type_code' ||p_quest_type_code ,11);
217: hr_utility.set_location(' Values :p_html_text' ||p_text ,11);
218: hr_utility.set_location(' Values :p_business_group_id' ||p_business_group_id ,11);
219:
220: --
221: -- Call API

Line 218: hr_utility.set_location(' Values :p_business_group_id' ||p_business_group_id ,11);

214: hr_utility.set_location(' Values :p_effective_date' ||p_effective_date ,11);
215: hr_utility.set_location(' Values :p_questionnaire_template_id' ||p_questionnaire_template_id ,11);
216: hr_utility.set_location(' Values :p_quest_type_code' ||p_quest_type_code ,11);
217: hr_utility.set_location(' Values :p_html_text' ||p_text ,11);
218: hr_utility.set_location(' Values :p_business_group_id' ||p_business_group_id ,11);
219:
220: --
221: -- Call API
222: -- Before updating the Text, save Original Text in Local Variable.

Line 251: hr_utility.set_location(' Leaving:' || l_proc,20);

247: rollback to update_questionnaire_swi;
248: End If;
249: --
250: p_return_status := hr_multi_message.get_return_status_disable;
251: hr_utility.set_location(' Leaving:' || l_proc,20);
252: --
253: exception
254: when hr_multi_message.error_message_exist then
255: --

Line 261: hr_utility.set_location(' Leaving:' || l_proc, 30);

257: --
258: --
259: p_object_version_number := l_object_version_number;
260: p_return_status := hr_multi_message.get_return_status_disable;
261: hr_utility.set_location(' Leaving:' || l_proc, 30);
262:
263: when others then
264: --
265: rollback to update_questionnaire_swi;

Line 268: hr_utility.set_location(' Leaving:' || l_proc,40);

264: --
265: rollback to update_questionnaire_swi;
266:
267: if hr_multi_message.unexpected_error_add(l_proc) then
268: hr_utility.set_location(' Leaving:' || l_proc,40);
269: raise;
270: end if;
271: --
272: p_object_version_number := l_object_version_number;

Line 274: hr_utility.set_location(' Leaving:' || l_proc,50);

270: end if;
271: --
272: p_object_version_number := l_object_version_number;
273: p_return_status := hr_multi_message.get_return_status_disable;
274: hr_utility.set_location(' Leaving:' || l_proc,50);
275:
276: end update_questionnaire;
277:
278: --

Line 301: hr_utility.set_location(' Entering:' || l_proc,10);

297: l_proc varchar2(72) := g_package ||'delete_questionnaire';
298:
299: Begin
300:
301: hr_utility.set_location(' Entering:' || l_proc,10);
302: --
303: -- Issue a savepoint
304: --
305: savepoint delete_questionnaire_swi;

Line 356: hr_utility.set_location(' Leaving:' || l_proc,20);

352: rollback to delete_questionnaire_swi;
353: End If;
354: --
355: p_return_status := hr_multi_message.get_return_status_disable;
356: hr_utility.set_location(' Leaving:' || l_proc,20);
357: --
358: exception
359: when hr_multi_message.error_message_exist then
360: --

Line 370: hr_utility.set_location(' Leaving:' || l_proc, 30);

366: --
367: -- Reset IN OUT parameters and set OUT parameters
368: --
369: p_return_status := hr_multi_message.get_return_status_disable;
370: hr_utility.set_location(' Leaving:' || l_proc, 30);
371: when others then
372: --
373: -- When Multiple Message Detection is enabled catch
374: -- any Application specific or other unexpected

Line 381: hr_utility.set_location(' Leaving:' || l_proc,40);

377: -- error.
378: --
379: rollback to delete_questionnaire_swi;
380: if hr_multi_message.unexpected_error_add(l_proc) then
381: hr_utility.set_location(' Leaving:' || l_proc,40);
382: raise;
383: end if;
384: --
385: -- Reset IN OUT and set OUT parameters

Line 388: hr_utility.set_location(' Leaving:' || l_proc,50);

384: --
385: -- Reset IN OUT and set OUT parameters
386: --
387: p_return_status := hr_multi_message.get_return_status_disable;
388: hr_utility.set_location(' Leaving:' || l_proc,50);
389: end delete_questionnaire;
390:
391: Procedure delete_questionnaire_fields
392: (