APPS.XLE_LEGAL_ADDRESS_SWI dependencies on XLE_LEGAL_ADDRESS_SWI

Line 1: PACKAGE BODY XLE_LEGAL_ADDRESS_SWI AS

1: PACKAGE BODY XLE_LEGAL_ADDRESS_SWI AS
2: /* $Header: xleaddrb.pls 120.10 2011/05/20 09:19:42 srsampat ship $ */
3:
4: g_package CONSTANT VARCHAR2(33) := 'xle_legal_address_swi.';
5:

Line 4: g_package CONSTANT VARCHAR2(33) := 'xle_legal_address_swi.';

1: PACKAGE BODY XLE_LEGAL_ADDRESS_SWI AS
2: /* $Header: xleaddrb.pls 120.10 2011/05/20 09:19:42 srsampat ship $ */
3:
4: g_package CONSTANT VARCHAR2(33) := 'xle_legal_address_swi.';
5:
6: PROCEDURE create_legal_address
7: (p_validate in number
8: ,p_effective_date in date

Line 78: savepoint xle_legal_address_swi;

74: hr_utility.set_location(' Entering:' || l_proc,10);
75: --
76: -- Issue a savepoint
77: --
78: savepoint xle_legal_address_swi;
79: --
80: -- Initialise Multiple Message Detection
81: --
82: hr_multi_message.enable_message_list;

Line 198: rollback to xle_legal_address_swi;

194: -- Catch the Multiple Message List exception which
195: -- indicates API processing has been aborted because
196: -- at least one message exists in the list.
197: --
198: rollback to xle_legal_address_swi;
199: --
200: -- Reset IN OUT parameters and set OUT parameters
201: --
202: p_object_version_number := null;

Line 208: rollback to xle_legal_address_swi;

204: p_return_status := hr_multi_message.get_return_status_disable;
205: hr_utility.set_location(' Leaving:' || l_proc, 30);
206: when VALIDATE_ADDRESS_FAIL then
207:
208: rollback to xle_legal_address_swi;
209: hr_utility.set_location(' Leaving:' || l_proc, 30);
210:
211: when others then
212: --

Line 219: rollback to xle_legal_address_swi;

215: -- exceptions. Adding appropriate details to the
216: -- Multiple Message List. Otherwise re-raise the
217: -- error.
218: --
219: rollback to xle_legal_address_swi;
220: if hr_multi_message.unexpected_error_add(l_proc) then
221: hr_utility.set_location(' Leaving:' || l_proc,40);
222: raise;
223: end if;

Line 303: savepoint xle_legal_address_swi;

299: l_object_version_number := p_object_version_number;
300: --
301: -- Issue a savepoint
302: --
303: savepoint xle_legal_address_swi;
304: --
305: -- Initialise Multiple Message Detection
306: --
307: hr_multi_message.enable_message_list;

Line 421: rollback to xle_legal_address_swi;

417: -- Catch the Multiple Message List exception which
418: -- indicates API processing has been aborted because
419: -- at least one message exists in the list.
420: --
421: rollback to xle_legal_address_swi;
422: --
423: -- Reset IN OUT parameters and set OUT parameters
424: --
425: p_object_version_number := l_temp_ovn;

Line 437: rollback to xle_legal_address_swi;

433: -- exceptions. Adding appropriate details to the
434: -- Multiple Message List. Otherwise re-raise the
435: -- error.
436: --
437: rollback to xle_legal_address_swi;
438: if hr_multi_message.unexpected_error_add(l_proc) then
439: hr_utility.set_location(' Leaving:' || l_proc,40);
440: raise;
441: end if;

Line 483: savepoint xle_legal_address_swi;

479: l_temp_ovn := l_object_version_number;
480: --
481: -- Issue a savepoint
482: --
483: savepoint xle_legal_address_swi;
484: --
485: -- Initialise Multiple Message Detection
486: --
487: hr_multi_message.enable_message_list;

Line 519: rollback to xle_legal_address_swi;

515: -- Catch the Multiple Message List exception which
516: -- indicates API processing has been aborted because
517: -- at least one message exists in the list.
518: --
519: rollback to xle_legal_address_swi;
520: --
521: -- Reset IN OUT parameters and set OUT parameters
522: --
523: l_object_version_number := l_temp_ovn;

Line 535: rollback to xle_legal_address_swi;

531: -- exceptions. Adding appropriate details to the
532: -- Multiple Message List. Otherwise re-raise the
533: -- error.
534: --
535: rollback to xle_legal_address_swi;
536: if hr_multi_message.unexpected_error_add(l_proc) then
537: hr_utility.set_location(' Leaving:' || l_proc,40);
538: raise;
539: end if;