DBA Data[Home] [Help]

APPS.HR_QUESTIONNAIRE_SWI dependencies on HR_UTILITY

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

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

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

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

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

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

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

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

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

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

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

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

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

234: rollback to update_questionnaire_swi;
235: End If;
236: --
237: p_return_status := hr_multi_message.get_return_status_disable;
238: hr_utility.set_location(' Leaving:' || l_proc,20);
239: --
240: exception
241: when hr_multi_message.error_message_exist then
242: --

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

244: --
245: --
246: p_object_version_number := l_object_version_number;
247: p_return_status := hr_multi_message.get_return_status_disable;
248: hr_utility.set_location(' Leaving:' || l_proc, 30);
249:
250: when others then
251: --
252: rollback to update_questionnaire_swi;

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

251: --
252: rollback to update_questionnaire_swi;
253:
254: if hr_multi_message.unexpected_error_add(l_proc) then
255: hr_utility.set_location(' Leaving:' || l_proc,40);
256: raise;
257: end if;
258: --
259: p_object_version_number := l_object_version_number;

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

257: end if;
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,50);
262:
263: end update_questionnaire;
264:
265: --

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

284: l_proc varchar2(72) := g_package ||'delete_questionnaire';
285:
286: Begin
287:
288: hr_utility.set_location(' Entering:' || l_proc,10);
289: --
290: -- Issue a savepoint
291: --
292: savepoint delete_questionnaire_swi;

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

339: rollback to delete_questionnaire_swi;
340: End If;
341: --
342: p_return_status := hr_multi_message.get_return_status_disable;
343: hr_utility.set_location(' Leaving:' || l_proc,20);
344: --
345: exception
346: when hr_multi_message.error_message_exist then
347: --

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

353: --
354: -- Reset IN OUT parameters and set OUT parameters
355: --
356: p_return_status := hr_multi_message.get_return_status_disable;
357: hr_utility.set_location(' Leaving:' || l_proc, 30);
358: when others then
359: --
360: -- When Multiple Message Detection is enabled catch
361: -- any Application specific or other unexpected

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

364: -- error.
365: --
366: rollback to delete_questionnaire_swi;
367: if hr_multi_message.unexpected_error_add(l_proc) then
368: hr_utility.set_location(' Leaving:' || l_proc,40);
369: raise;
370: end if;
371: --
372: -- Reset IN OUT and set OUT parameters

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

371: --
372: -- Reset IN OUT and set OUT parameters
373: --
374: p_return_status := hr_multi_message.get_return_status_disable;
375: hr_utility.set_location(' Leaving:' || l_proc,50);
376: end delete_questionnaire;
377:
378: Procedure delete_questionnaire_fields
379: (