29: l_proc varchar2(72);
30: Begin
31: l_proc := g_package ||'create_au_process_module';
32: --
33: hr_utility.set_location(' Entering:' || l_proc,10);
34: --
35: -- Issue a savepoint
36: --
37: savepoint create_au_process_module_swi;
78: -- messages of any type exist in the Multiple Message List.
79: -- Also disable Multiple Message Detection.
80: --
81: p_return_status := hr_multi_message.get_return_status_disable;
82: hr_utility.set_location(' Leaving:' || l_proc,20);
83: --
84: exception
85: when hr_multi_message.error_message_exist then
86: --
93: -- Reset IN OUT parameters and set OUT parameters
94: --
95: p_object_version_number := null;
96: p_return_status := hr_multi_message.get_return_status_disable;
97: hr_utility.set_location(' Leaving:' || l_proc, 30);
98: when others then
99: --
100: -- When Multiple Message Detection is enabled catch
101: -- any Application specific or other unexpected
104: -- error.
105: --
106: rollback to create_au_process_module_swi;
107: if hr_multi_message.unexpected_error_add(l_proc) then
108: hr_utility.set_location(' Leaving:' || l_proc,40);
109: raise;
110: end if;
111: --
112: -- Reset IN OUT and set OUT parameters
112: -- Reset IN OUT and set OUT parameters
113: --
114: p_object_version_number := null;
115: p_return_status := hr_multi_message.get_return_status_disable;
116: hr_utility.set_location(' Leaving:' || l_proc,50);
117: end create_au_process_module;
118: -- ----------------------------------------------------------------------------
119: -- |-----------------------< delete_au_process_module >-----------------------|
120: -- ----------------------------------------------------------------------------
134: l_proc varchar2(72);
135: Begin
136: l_proc := g_package ||'delete_au_process_module';
137: --
138: hr_utility.set_location(' Entering:' || l_proc,10);
139: --
140: -- Issue a savepoint
141: --
142: savepoint delete_au_process_module_swi;
176: -- messages of any type exist in the Multiple Message List.
177: -- Also disable Multiple Message Detection.
178: --
179: p_return_status := hr_multi_message.get_return_status_disable;
180: hr_utility.set_location(' Leaving:' || l_proc,20);
181: --
182: exception
183: when hr_multi_message.error_message_exist then
184: --
190: --
191: -- Reset IN OUT parameters and set OUT parameters
192: --
193: p_return_status := hr_multi_message.get_return_status_disable;
194: hr_utility.set_location(' Leaving:' || l_proc, 30);
195: when others then
196: --
197: -- When Multiple Message Detection is enabled catch
198: -- any Application specific or other unexpected
201: -- error.
202: --
203: rollback to delete_au_process_module_swi;
204: if hr_multi_message.unexpected_error_add(l_proc) then
205: hr_utility.set_location(' Leaving:' || l_proc,40);
206: raise;
207: end if;
208: --
209: -- Reset IN OUT and set OUT parameters
208: --
209: -- Reset IN OUT and set OUT parameters
210: --
211: p_return_status := hr_multi_message.get_return_status_disable;
212: hr_utility.set_location(' Leaving:' || l_proc,50);
213: end delete_au_process_module;
214: -- ----------------------------------------------------------------------------
215: -- |-----------------------< update_au_process_module >-----------------------|
216: -- ----------------------------------------------------------------------------
235: l_proc varchar2(72);
236: Begin
237: l_proc := g_package ||'update_au_process_module';
238: --
239: hr_utility.set_location(' Entering:' || l_proc,10);
240: --
241: -- Issue a savepoint
242: --
243: savepoint update_au_process_module_swi;
282: -- messages of any type exist in the Multiple Message List.
283: -- Also disable Multiple Message Detection.
284: --
285: p_return_status := hr_multi_message.get_return_status_disable;
286: hr_utility.set_location(' Leaving:' || l_proc,20);
287: --
288: exception
289: when hr_multi_message.error_message_exist then
290: --
297: -- Reset IN OUT parameters and set OUT parameters
298: --
299: p_object_version_number := l_object_version_number;
300: p_return_status := hr_multi_message.get_return_status_disable;
301: hr_utility.set_location(' Leaving:' || l_proc, 30);
302: when others then
303: --
304: -- When Multiple Message Detection is enabled catch
305: -- any Application specific or other unexpected
308: -- error.
309: --
310: rollback to update_au_process_module_swi;
311: if hr_multi_message.unexpected_error_add(l_proc) then
312: hr_utility.set_location(' Leaving:' || l_proc,40);
313: raise;
314: end if;
315: --
316: -- Reset IN OUT and set OUT parameters
316: -- Reset IN OUT and set OUT parameters
317: --
318: p_object_version_number := l_object_version_number;
319: p_return_status := hr_multi_message.get_return_status_disable;
320: hr_utility.set_location(' Leaving:' || l_proc,50);
321: end update_au_process_module;
322: begin
323: g_package := 'pay_au_process_modules_swi.';
324: end pay_au_process_modules_swi;