65: savepoint create_org_account_swi;
66: --
67: -- Initialise Multiple Message Detection
68: --
69: hr_multi_message.enable_message_list;
70: --
71: -- Remember IN OUT parameter IN values
72: --
73: l_object_version_number := p_object_version_number;
142: -- Derive the API return status value based on whether
143: -- messages of any type exist in the Multiple Message List.
144: -- Also disable Multiple Message Detection.
145: --
146: p_return_status := hr_multi_message.get_return_status_disable;
147: hr_utility.set_location(' Leaving:' || l_proc,20);
148: --
149: exception
150: when hr_multi_message.error_message_exist then
146: p_return_status := hr_multi_message.get_return_status_disable;
147: hr_utility.set_location(' Leaving:' || l_proc,20);
148: --
149: exception
150: when hr_multi_message.error_message_exist then
151: --
152: -- Catch the Multiple Message List exception which
153: -- indicates API processing has been aborted because
154: -- at least one message exists in the list.
158: -- Reset IN OUT parameters and set OUT parameters
159: --
160: p_object_version_number := l_object_version_number;
161: p_return_status := null;
162: p_return_status := hr_multi_message.get_return_status_disable;
163: hr_utility.set_location(' Leaving:' || l_proc, 30);
164: when others then
165: --
166: -- When Multiple Message Detection is enabled catch
169: -- Multiple Message List. Otherwise re-raise the
170: -- error.
171: --
172: rollback to create_org_account_swi;
173: if hr_multi_message.unexpected_error_add(l_proc) then
174: hr_utility.set_location(' Leaving:' || l_proc,40);
175: raise;
176: end if;
177: --
178: -- Reset IN OUT and set OUT parameters
179: --
180: p_object_version_number := l_object_version_number;
181: p_return_status := null;
182: p_return_status := hr_multi_message.get_return_status_disable;
183: hr_utility.set_location(' Leaving:' || l_proc,50);
184: end create_organization_account;
185: -- ----------------------------------------------------------------------------
186: -- |----------------------< delete_organization_account >---------------------|
209: savepoint delete_org_account_swi;
210: --
211: -- Initialise Multiple Message Detection
212: --
213: hr_multi_message.enable_message_list;
214: --
215: -- Remember IN OUT parameter IN values
216: --
217: l_object_version_number := p_object_version_number;
251: -- Derive the API return status value based on whether
252: -- messages of any type exist in the Multiple Message List.
253: -- Also disable Multiple Message Detection.
254: --
255: p_return_status := hr_multi_message.get_return_status_disable;
256: hr_utility.set_location(' Leaving:' || l_proc,20);
257: --
258: exception
259: when hr_multi_message.error_message_exist then
255: p_return_status := hr_multi_message.get_return_status_disable;
256: hr_utility.set_location(' Leaving:' || l_proc,20);
257: --
258: exception
259: when hr_multi_message.error_message_exist then
260: --
261: -- Catch the Multiple Message List exception which
262: -- indicates API processing has been aborted because
263: -- at least one message exists in the list.
267: -- Reset IN OUT parameters and set OUT parameters
268: --
269: p_object_version_number := l_object_version_number;
270: p_return_status := null;
271: p_return_status := hr_multi_message.get_return_status_disable;
272: hr_utility.set_location(' Leaving:' || l_proc, 30);
273: when others then
274: --
275: -- When Multiple Message Detection is enabled catch
278: -- Multiple Message List. Otherwise re-raise the
279: -- error.
280: --
281: rollback to delete_org_account_swi;
282: if hr_multi_message.unexpected_error_add(l_proc) then
283: hr_utility.set_location(' Leaving:' || l_proc,40);
284: raise;
285: end if;
286: --
287: -- Reset IN OUT and set OUT parameters
288: --
289: p_object_version_number := l_object_version_number;
290: p_return_status := null;
291: p_return_status := hr_multi_message.get_return_status_disable;
292: hr_utility.set_location(' Leaving:' || l_proc,50);
293: end delete_organization_account;
294: -- ----------------------------------------------------------------------------
295: -- |----------------------< update_organization_account >---------------------|
350: savepoint update_org_account_swi;
351: --
352: -- Initialise Multiple Message Detection
353: --
354: hr_multi_message.enable_message_list;
355: --
356: -- Remember IN OUT parameter IN values
357: --
358: l_object_version_number := p_object_version_number;
424: -- Derive the API return status value based on whether
425: -- messages of any type exist in the Multiple Message List.
426: -- Also disable Multiple Message Detection.
427: --
428: p_return_status := hr_multi_message.get_return_status_disable;
429: hr_utility.set_location(' Leaving:' || l_proc,20);
430: --
431: exception
432: when hr_multi_message.error_message_exist then
428: p_return_status := hr_multi_message.get_return_status_disable;
429: hr_utility.set_location(' Leaving:' || l_proc,20);
430: --
431: exception
432: when hr_multi_message.error_message_exist then
433: --
434: -- Catch the Multiple Message List exception which
435: -- indicates API processing has been aborted because
436: -- at least one message exists in the list.
440: -- Reset IN OUT parameters and set OUT parameters
441: --
442: p_object_version_number := l_object_version_number;
443: p_return_status := null;
444: p_return_status := hr_multi_message.get_return_status_disable;
445: hr_utility.set_location(' Leaving:' || l_proc, 30);
446: when others then
447: --
448: -- When Multiple Message Detection is enabled catch
451: -- Multiple Message List. Otherwise re-raise the
452: -- error.
453: --
454: rollback to update_org_account_swi;
455: if hr_multi_message.unexpected_error_add(l_proc) then
456: hr_utility.set_location(' Leaving:' || l_proc,40);
457: raise;
458: end if;
459: --
460: -- Reset IN OUT and set OUT parameters
461: --
462: p_object_version_number := l_object_version_number;
463: p_return_status := null;
464: p_return_status := hr_multi_message.get_return_status_disable;
465: hr_utility.set_location(' Leaving:' || l_proc,50);
466: end update_organization_account;
467: end psp_organization_accounts_swi;