40: savepoint create_view_report_swi;
41: --
42: -- Initialise Multiple Message Detection
43: --
44: hr_multi_message.enable_message_list;
45: --
46: -- Remember IN OUT parameter IN values
47: --
48: --
83: -- Derive the API return status value based on whether
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
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: --
93: -- Catch the Multiple Message List exception which
94: -- indicates API processing has been aborted because
95: -- at least one message exists in the list.
98: --
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
109: -- Multiple Message List. Otherwise re-raise the
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: --
117: --
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 >--------------------------|
146: savepoint delete_view_report_swi;
147: --
148: -- Initialise Multiple Message Detection
149: --
150: hr_multi_message.enable_message_list;
151: --
152: -- Remember IN OUT parameter IN values
153: --
154: --
179: -- Derive the API return status value based on whether
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
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: --
189: -- Catch the Multiple Message List exception which
190: -- indicates API processing has been aborted because
191: -- at least one message exists in the list.
193: rollback to delete_view_report_swi;
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
204: -- Multiple Message List. Otherwise re-raise the
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: --
211: end if;
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 >--------------------------|
251: savepoint update_view_report_swi;
252: --
253: -- Initialise Multiple Message Detection
254: --
255: hr_multi_message.enable_message_list;
256: --
257: -- Remember IN OUT parameter IN values
258: --
259: l_object_version_number := p_object_version_number;
295: -- Derive the API return status value based on whether
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
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: --
305: -- Catch the Multiple Message List exception which
306: -- indicates API processing has been aborted because
307: -- at least one message exists in the list.
310: --
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
321: -- Multiple Message List. Otherwise re-raise the
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: --
329: --
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;