DBA Data[Home] [Help]

APPS.XLE_LEGAL_ADDRESS_SWI dependencies on HR_UTILITY

Line 60: hr_utility.set_location(' Entering:' || l_proc,10);

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;

Line 158: hr_utility.set_location(' Leaving:' || l_proc,20);

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: --

Line 174: hr_utility.set_location(' Leaving:' || l_proc, 30);

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

Line 185: hr_utility.set_location(' Leaving:' || l_proc,40);

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

Line 194: hr_utility.set_location(' Leaving:' || l_proc,50);

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

Line 248: hr_utility.set_location(' Entering:' || l_proc,10);

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

Line 345: hr_utility.set_location(' Leaving:' || l_proc,20);

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: --

Line 360: hr_utility.set_location(' Leaving:' || l_proc, 30);

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

Line 372: hr_utility.set_location(' Leaving:' || l_proc,40);

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

Line 380: hr_utility.set_location(' Leaving:' || l_proc,50);

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.