DBA Data[Home] [Help]

APPS.PSP_REPORT_TEMPLATE_SWI dependencies on HR_UTILITY

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

45: -- Other variables
46: l_template_id number;
47: l_proc varchar2(72) := g_package ||'create_report_template';
48: Begin
49: hr_utility.set_location(' Entering:' || l_proc,10);
50: --
51: -- Issue a savepoint
52: --
53: savepoint create_report_template_swi;

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

114: -- messages of any type exist in the Multiple Message List.
115: -- Also disable Multiple Message Detection.
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 134: hr_utility.set_location(' Leaving:' || l_proc, 30);

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

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

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

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

150: --
151: p_object_version_number := null;
152: p_return_status := null;
153: p_return_status := hr_multi_message.get_return_status_disable;
154: hr_utility.set_location(' Leaving:' || l_proc,50);
155: end create_report_template;
156: -- ----------------------------------------------------------------------------
157: -- |------------------------< update_report_template >------------------------|
158: -- ----------------------------------------------------------------------------

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

193: --
194: -- Other variables
195: l_proc varchar2(72) := g_package ||'update_report_template';
196: Begin
197: hr_utility.set_location(' Entering:' || l_proc,10);
198: --
199: -- Issue a savepoint
200: --
201: savepoint update_report_template_swi;

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

260: -- messages of any type exist in the Multiple Message List.
261: -- Also disable Multiple Message Detection.
262: --
263: p_return_status := hr_multi_message.get_return_status_disable;
264: hr_utility.set_location(' Leaving:' || l_proc,20);
265: --
266: exception
267: when hr_multi_message.error_message_exist then
268: --

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

276: --
277: p_object_version_number := l_object_version_number;
278: p_return_status := null;
279: p_return_status := hr_multi_message.get_return_status_disable;
280: hr_utility.set_location(' Leaving:' || l_proc, 30);
281: when others then
282: --
283: -- When Multiple Message Detection is enabled catch
284: -- any Application specific or other unexpected

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

287: -- error.
288: --
289: rollback to update_report_template_swi;
290: if hr_multi_message.unexpected_error_add(l_proc) then
291: hr_utility.set_location(' Leaving:' || l_proc,40);
292: raise;
293: end if;
294: --
295: -- Reset IN OUT and set OUT parameters

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

296: --
297: p_object_version_number := l_object_version_number;
298: p_return_status := null;
299: p_return_status := hr_multi_message.get_return_status_disable;
300: hr_utility.set_location(' Leaving:' || l_proc,50);
301: end update_report_template;
302: -- ----------------------------------------------------------------------------
303: -- |------------------------< delete_report_template >------------------------|
304: -- ----------------------------------------------------------------------------

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

318: --
319: -- Other variables
320: l_proc varchar2(72) := g_package ||'delete_report_template';
321: Begin
322: hr_utility.set_location(' Entering:' || l_proc,10);
323: --
324: -- Issue a savepoint
325: --
326: savepoint delete_report_template_swi;

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

362: -- messages of any type exist in the Multiple Message List.
363: -- Also disable Multiple Message Detection.
364: --
365: p_return_status := hr_multi_message.get_return_status_disable;
366: hr_utility.set_location(' Leaving:' || l_proc,20);
367: --
368: exception
369: when hr_multi_message.error_message_exist then
370: --

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

377: -- Reset IN OUT parameters and set OUT parameters
378: --
379: p_object_version_number := l_object_version_number;
380: p_return_status := hr_multi_message.get_return_status_disable;
381: hr_utility.set_location(' Leaving:' || l_proc, 30);
382: when others then
383: --
384: -- When Multiple Message Detection is enabled catch
385: -- any Application specific or other unexpected

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

388: -- error.
389: --
390: rollback to delete_report_template_swi;
391: if hr_multi_message.unexpected_error_add(l_proc) then
392: hr_utility.set_location(' Leaving:' || l_proc,40);
393: raise;
394: end if;
395: --
396: -- Reset IN OUT and set OUT parameters

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

396: -- Reset IN OUT and set OUT parameters
397: --
398: p_object_version_number := l_object_version_number;
399: p_return_status := hr_multi_message.get_return_status_disable;
400: hr_utility.set_location(' Leaving:' || l_proc,50);
401: end delete_report_template;
402: end psp_report_template_swi;