32: --
33: -- Other variables
34: l_proc varchar2(72) := g_package ||'create_view_report';
35: Begin
36: hr_utility.set_location(' Entering:' || l_proc,10);
37: --
38: -- Issue a savepoint
39: --
40: savepoint create_view_report_swi;
84: -- messages of any type exist in the Multiple Message List.
85: -- Also disable Multiple Message Detection.
86: --
87: p_return_status := hr_multi_message.get_return_status_disable;
88: hr_utility.set_location(' Leaving:' || l_proc,20);
89: --
90: exception
91: when hr_multi_message.error_message_exist then
92: --
99: -- Reset IN OUT parameters and set OUT parameters
100: --
101: p_object_version_number := null;
102: p_return_status := hr_multi_message.get_return_status_disable;
103: hr_utility.set_location(' Leaving:' || l_proc, 30);
104: when others then
105: --
106: -- When Multiple Message Detection is enabled catch
107: -- any Application specific or other unexpected
110: -- error.
111: --
112: rollback to create_view_report_swi;
113: if hr_multi_message.unexpected_error_add(l_proc) then
114: hr_utility.set_location(' Leaving:' || l_proc,40);
115: raise;
116: end if;
117: --
118: -- Reset IN OUT and set OUT parameters
118: -- Reset IN OUT and set OUT parameters
119: --
120: p_object_version_number := null;
121: p_return_status := hr_multi_message.get_return_status_disable;
122: hr_utility.set_location(' Leaving:' || l_proc,50);
123: end create_view_report;
124: -- ----------------------------------------------------------------------------
125: -- |--------------------------< delete_view_report >--------------------------|
126: -- ----------------------------------------------------------------------------
138: --
139: -- Other variables
140: l_proc varchar2(72) := g_package ||'delete_view_report';
141: Begin
142: hr_utility.set_location(' Entering:' || l_proc,10);
143: --
144: -- Issue a savepoint
145: --
146: savepoint delete_view_report_swi;
180: -- messages of any type exist in the Multiple Message List.
181: -- Also disable Multiple Message Detection.
182: --
183: p_return_status := hr_multi_message.get_return_status_disable;
184: hr_utility.set_location(' Leaving:' || l_proc,20);
185: --
186: exception
187: when hr_multi_message.error_message_exist then
188: --
194: --
195: -- Reset IN OUT parameters and set OUT parameters
196: --
197: p_return_status := hr_multi_message.get_return_status_disable;
198: hr_utility.set_location(' Leaving:' || l_proc, 30);
199: when others then
200: --
201: -- When Multiple Message Detection is enabled catch
202: -- any Application specific or other unexpected
205: -- error.
206: --
207: rollback to delete_view_report_swi;
208: if hr_multi_message.unexpected_error_add(l_proc) then
209: hr_utility.set_location(' Leaving:' || l_proc,40);
210: raise;
211: end if;
212: --
213: -- Reset IN OUT and set OUT parameters
212: --
213: -- Reset IN OUT and set OUT parameters
214: --
215: p_return_status := hr_multi_message.get_return_status_disable;
216: hr_utility.set_location(' Leaving:' || l_proc,50);
217: end delete_view_report;
218: -- ----------------------------------------------------------------------------
219: -- |--------------------------< update_view_report >--------------------------|
220: -- ----------------------------------------------------------------------------
243: --
244: -- Other variables
245: l_proc varchar2(72) := g_package ||'update_view_report';
246: Begin
247: hr_utility.set_location(' Entering:' || l_proc,10);
248: --
249: -- Issue a savepoint
250: --
251: savepoint update_view_report_swi;
296: -- messages of any type exist in the Multiple Message List.
297: -- Also disable Multiple Message Detection.
298: --
299: p_return_status := hr_multi_message.get_return_status_disable;
300: hr_utility.set_location(' Leaving:' || l_proc,20);
301: --
302: exception
303: when hr_multi_message.error_message_exist then
304: --
311: -- Reset IN OUT parameters and set OUT parameters
312: --
313: p_object_version_number := l_object_version_number;
314: p_return_status := hr_multi_message.get_return_status_disable;
315: hr_utility.set_location(' Leaving:' || l_proc, 30);
316: when others then
317: --
318: -- When Multiple Message Detection is enabled catch
319: -- any Application specific or other unexpected
322: -- error.
323: --
324: rollback to update_view_report_swi;
325: if hr_multi_message.unexpected_error_add(l_proc) then
326: hr_utility.set_location(' Leaving:' || l_proc,40);
327: raise;
328: end if;
329: --
330: -- Reset IN OUT and set OUT parameters
330: -- Reset IN OUT and set OUT parameters
331: --
332: p_object_version_number := l_object_version_number;
333: p_return_status := hr_multi_message.get_return_status_disable;
334: hr_utility.set_location(' Leaving:' || l_proc,50);
335: end update_view_report;
336: end per_ri_view_report_swi;