20: --
21: -- Other variables
22: l_proc varchar2(72) := g_package ||'delete_validation_event';
23: Begin
24: hr_utility.set_location(' Entering:' || l_proc,10);
25: --
26: -- Issue a savepoint
27: --
28: savepoint delete_validation_event_swi;
58: -- messages of any type exist in the Multiple Message List.
59: -- Also disable Multiple Message Detection.
60: --
61: p_return_status := hr_multi_message.get_return_status_disable;
62: hr_utility.set_location(' Leaving:' || l_proc,20);
63: --
64: exception
65: when hr_multi_message.error_message_exist then
66: --
72: --
73: -- Reset IN OUT parameters and set OUT parameters
74: --
75: p_return_status := hr_multi_message.get_return_status_disable;
76: hr_utility.set_location(' Leaving:' || l_proc, 30);
77: when others then
78: --
79: -- When Multiple Message Detection is enabled catch
80: -- any Application specific or other unexpected
83: -- error.
84: --
85: rollback to delete_validation_event_swi;
86: if hr_multi_message.unexpected_error_add(l_proc) then
87: hr_utility.set_location(' Leaving:' || l_proc,40);
88: raise;
89: end if;
90: --
91: -- Reset IN OUT and set OUT parameters
90: --
91: -- Reset IN OUT and set OUT parameters
92: --
93: p_return_status := hr_multi_message.get_return_status_disable;
94: hr_utility.set_location(' Leaving:' || l_proc,50);
95: end delete_validation_event;
96: -- ----------------------------------------------------------------------------
97: -- |------------------------< insert_validation_event >-----------------------|
98: -- ----------------------------------------------------------------------------
115: --
116: -- Other variables
117: l_proc varchar2(72) := g_package ||'insert_validation_event';
118: Begin
119: hr_utility.set_location(' Entering:' || l_proc,10);
120: --
121: -- Issue a savepoint
122: --
123: savepoint insert_validation_event_swi;
163: -- messages of any type exist in the Multiple Message List.
164: -- Also disable Multiple Message Detection.
165: --
166: p_return_status := hr_multi_message.get_return_status_disable;
167: hr_utility.set_location(' Leaving:' || l_proc,20);
168: --
169: exception
170: when hr_multi_message.error_message_exist then
171: --
179: --
180: p_validation_event_id := null;
181: p_object_version_number := null;
182: p_return_status := hr_multi_message.get_return_status_disable;
183: hr_utility.set_location(' Leaving:' || l_proc, 30);
184: when others then
185: --
186: -- When Multiple Message Detection is enabled catch
187: -- any Application specific or other unexpected
190: -- error.
191: --
192: rollback to insert_validation_event_swi;
193: if hr_multi_message.unexpected_error_add(l_proc) then
194: hr_utility.set_location(' Leaving:' || l_proc,40);
195: raise;
196: end if;
197: --
198: -- Reset IN OUT and set OUT parameters
199: --
200: p_validation_event_id := null;
201: p_object_version_number := null;
202: p_return_status := hr_multi_message.get_return_status_disable;
203: hr_utility.set_location(' Leaving:' || l_proc,50);
204: end insert_validation_event;
205: -- ----------------------------------------------------------------------------
206: -- |------------------------< update_validation_event >-----------------------|
207: -- ----------------------------------------------------------------------------
225: --
226: -- Other variables
227: l_proc varchar2(72) := g_package ||'update_validation_event';
228: Begin
229: hr_utility.set_location(' Entering:' || l_proc,10);
230: --
231: -- Issue a savepoint
232: --
233: savepoint update_validation_event_swi;
271: -- messages of any type exist in the Multiple Message List.
272: -- Also disable Multiple Message Detection.
273: --
274: p_return_status := hr_multi_message.get_return_status_disable;
275: hr_utility.set_location(' Leaving:' || l_proc,20);
276: --
277: exception
278: when hr_multi_message.error_message_exist then
279: --
286: -- Reset IN OUT parameters and set OUT parameters
287: --
288: p_object_version_number := l_object_version_number;
289: p_return_status := hr_multi_message.get_return_status_disable;
290: hr_utility.set_location(' Leaving:' || l_proc, 30);
291: when others then
292: --
293: -- When Multiple Message Detection is enabled catch
294: -- any Application specific or other unexpected
297: -- error.
298: --
299: rollback to update_validation_event_swi;
300: if hr_multi_message.unexpected_error_add(l_proc) then
301: hr_utility.set_location(' Leaving:' || l_proc,40);
302: raise;
303: end if;
304: --
305: -- Reset IN OUT and set OUT parameters
305: -- Reset IN OUT and set OUT parameters
306: --
307: p_object_version_number := l_object_version_number;
308: p_return_status := hr_multi_message.get_return_status_disable;
309: hr_utility.set_location(' Leaving:' || l_proc,50);
310: end update_validation_event;
311: end pqh_fr_validation_events_swi;