56: p_return_status varchar(1);
57:
58: l_proc CONSTANT VARCHAR2(72) := g_package ||'create_legal_address';
59: Begin
60: hr_utility.set_location(' Entering:' || l_proc,10);
61: --
62: -- Issue a savepoint
63: --
64: savepoint xle_legal_address_swi;
154: p_object_version_number := l_object_version_number;
155: p_return_status := hr_multi_message.get_return_status_disable;
156:
157:
158: hr_utility.set_location(' Leaving:' || l_proc,20);
159: --
160: exception
161: when hr_multi_message.error_message_exist then
162: --
170: --
171: p_object_version_number := null;
172: p_location_id := null;
173: p_return_status := hr_multi_message.get_return_status_disable;
174: hr_utility.set_location(' Leaving:' || l_proc, 30);
175: when others then
176: --
177: -- When Multiple Message Detection is enabled catch
178: -- any Application specific or other unexpected
181: -- error.
182: --
183: rollback to xle_legal_address_swi;
184: if hr_multi_message.unexpected_error_add(l_proc) then
185: hr_utility.set_location(' Leaving:' || l_proc,40);
186: raise;
187: end if;
188: --
189: -- Reset IN OUT and set OUT parameters
190: --
191: p_object_version_number := null;
192: p_location_id := null;
193: p_return_status := hr_multi_message.get_return_status_disable;
194: hr_utility.set_location(' Leaving:' || l_proc,50);
195: end create_legal_address;
196:
197: PROCEDURE update_legal_address
198: (p_validate in number
244: p_return_status varchar(1);
245: l_temp_ovn CONSTANT number(9) := p_object_version_number;
246: l_proc CONSTANT varchar2(72) := g_package ||'create_legal_address';
247: Begin
248: hr_utility.set_location(' Entering:' || l_proc,10);
249:
250: l_object_version_number := p_object_version_number;
251: --
252: -- Issue a savepoint
341: p_object_version_number := l_object_version_number;
342: p_return_status := hr_multi_message.get_return_status_disable;
343:
344:
345: hr_utility.set_location(' Leaving:' || l_proc,20);
346: --
347: exception
348: when hr_multi_message.error_message_exist then
349: --
356: -- Reset IN OUT parameters and set OUT parameters
357: --
358: p_object_version_number := l_temp_ovn;
359: p_return_status := hr_multi_message.get_return_status_disable;
360: hr_utility.set_location(' Leaving:' || l_proc, 30);
361: --raise;
362: when others then
363: --
364: -- When Multiple Message Detection is enabled catch
368: -- error.
369: --
370: rollback to xle_legal_address_swi;
371: if hr_multi_message.unexpected_error_add(l_proc) then
372: hr_utility.set_location(' Leaving:' || l_proc,40);
373: raise;
374: end if;
375: --
376: -- Reset IN OUT and set OUT parameters
376: -- Reset IN OUT and set OUT parameters
377: --
378: p_object_version_number := l_temp_ovn;
379: p_return_status := hr_multi_message.get_return_status_disable;
380: hr_utility.set_location(' Leaving:' || l_proc,50);
381: --raise;
382: end update_legal_address;
383:
384: -- Enter further code below as specified in the Package spec.