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;
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: --
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
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
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: -- ----------------------------------------------------------------------------
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;
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: --
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
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
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: -- ----------------------------------------------------------------------------
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;
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: --
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
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
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;