DBA Data[Home] [Help]

APPS.XLE_LEGAL_ADDRESS_SWI dependencies on HR_UTILITY

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

70: VALIDATE_ADDRESS_FAIL EXCEPTION;
71: l_proc CONSTANT VARCHAR2(72) := g_package ||'create_legal_address';
72: Begin
73:
74: hr_utility.set_location(' Entering:' || l_proc,10);
75: --
76: -- Issue a savepoint
77: --
78: savepoint xle_legal_address_swi;

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

181: p_object_version_number := l_object_version_number;
182: p_return_status := hr_multi_message.get_return_status_disable;
183:
184:
185: hr_utility.set_location(' Leaving:' || l_proc,20);
186: -- Bug: 8434653
187: IF( p_return_status = 'E') then
188: raise VALIDATE_ADDRESS_FAIL;
189: END IF;

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

201: --
202: p_object_version_number := null;
203: p_location_id := null;
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);

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

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: --
213: -- When Multiple Message Detection is enabled catch

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

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;
224: --
225: -- Reset IN OUT and set OUT parameters

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

226: --
227: p_object_version_number := null;
228: p_location_id := null;
229: p_return_status := hr_multi_message.get_return_status_disable;
230: hr_utility.set_location(' Leaving:' || l_proc,50);
231: end create_legal_address;
232:
233: PROCEDURE update_legal_address
234: (p_validate in number

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

293: p_return_status varchar(1);
294: l_temp_ovn CONSTANT number(9) := p_object_version_number;
295: l_proc CONSTANT varchar2(72) := g_package ||'create_legal_address';
296: Begin
297: hr_utility.set_location(' Entering:' || l_proc,10);
298:
299: l_object_version_number := p_object_version_number;
300: --
301: -- Issue a savepoint

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

408: p_object_version_number := l_object_version_number;
409: p_return_status := hr_multi_message.get_return_status_disable;
410:
411:
412: hr_utility.set_location(' Leaving:' || l_proc,20);
413: --
414: exception
415: when hr_multi_message.error_message_exist then
416: --

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

423: -- Reset IN OUT parameters and set OUT parameters
424: --
425: p_object_version_number := l_temp_ovn;
426: p_return_status := hr_multi_message.get_return_status_disable;
427: hr_utility.set_location(' Leaving:' || l_proc, 30);
428: --raise;
429: when others then
430: --
431: -- When Multiple Message Detection is enabled catch

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

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;
442: --
443: -- Reset IN OUT and set OUT parameters

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

443: -- Reset IN OUT and set OUT parameters
444: --
445: p_object_version_number := l_temp_ovn;
446: p_return_status := hr_multi_message.get_return_status_disable;
447: hr_utility.set_location(' Leaving:' || l_proc,50);
448: --raise;
449: end update_legal_address;
450:
451:

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

473: if( l_legal_address_flag <> 'Y') then
474:
475: Begin
476:
477: hr_utility.set_location(' Entering:' || l_proc,10);
478:
479: l_temp_ovn := l_object_version_number;
480: --
481: -- Issue a savepoint

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

505: --
506:
507: l_return_status := hr_multi_message.get_return_status_disable;
508:
509: hr_utility.set_location(' Leaving:' || l_proc,20);
510:
511: exception
512: when hr_multi_message.error_message_exist then
513:

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

521: -- Reset IN OUT parameters and set OUT parameters
522: --
523: l_object_version_number := l_temp_ovn;
524: l_return_status := hr_multi_message.get_return_status_disable;
525: hr_utility.set_location(' Leaving:' || l_proc, 30);
526: --raise;
527: when others then
528: --
529: -- When Multiple Message Detection is enabled catch

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

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;
540: --
541: -- Reset IN OUT and set OUT parameters

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

541: -- Reset IN OUT and set OUT parameters
542: --
543: l_object_version_number := l_temp_ovn;
544: l_return_status := hr_multi_message.get_return_status_disable;
545: hr_utility.set_location(' Leaving:' || l_proc,50);
546: --raise;
547: end;
548: end if;
549: end enable_legal_address_flag;