DBA Data[Home] [Help]

APPS.HR_CONTACT_EXTRA_INFO_SWI dependencies on HR_UTILITY

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

81: l_proc varchar2(72) := g_package ||'insert';
82:
83: begin
84:
85: hr_utility.set_location(' Entering:' || l_proc,10);
86: --
87: -- Issue a savepoint
88: --
89: savepoint create_contact_extra_info_swi;

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

188: rollback to create_contact_extra_info_swi;
189: End If;
190: --
191: p_return_status := hr_multi_message.get_return_status_disable;
192: hr_utility.set_location(' Leaving:' || l_proc,20);
193: --
194: exception
195: when hr_multi_message.error_message_exist then
196: --

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

205: p_object_version_number := null;
206: p_effective_start_date := null;
207: p_effective_end_date := null;
208: p_return_status := hr_multi_message.get_return_status_disable;
209: hr_utility.set_location(' Leaving:' || l_proc, 30);
210: when others then
211: --
212: -- When Multiple Message Detection is enabled catch
213: -- any Application specific or other unexpected

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

216: -- error.
217: --
218: rollback to create_contact_extra_info_swi;
219: if hr_multi_message.unexpected_error_add(l_proc) then
220: hr_utility.set_location(' Leaving:' || l_proc,40);
221: raise;
222: end if;
223: --
224: -- Reset IN OUT and set OUT parameters

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

226: p_object_version_number := null;
227: p_effective_start_date := null;
228: p_effective_end_date := null;
229: p_return_status := hr_multi_message.get_return_status_disable;
230: hr_utility.set_location(' Leaving:' || l_proc,50);
231:
232: end create_contact_extra_info;
233:
234: ----------------------------------------------------------------------------

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

306:
307: l_proc varchar2(72) := g_package ||' update_contact_extra_info';
308:
309: begin
310: hr_utility.set_location(' Entering:' || l_proc,10);
311: --
312: -- Issue a savepoint
313: --
314: savepoint update_contact_extra_info_swi;

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

395: rollback to update_contact_extra_info_swi;
396: End If;
397: --
398: p_return_status := hr_multi_message.get_return_status_disable;
399: hr_utility.set_location(' Leaving:' || l_proc,20);
400: --
401: exception
402: when hr_multi_message.error_message_exist then
403: --

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

408: p_effective_start_date := null;
409: p_effective_end_date := null;
410:
411: p_return_status := hr_multi_message.get_return_status_disable;
412: hr_utility.set_location(' Leaving:' || l_proc, 30);
413:
414: when others then
415: --
416: rollback to update_contact_extra_info_swi;

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

415: --
416: rollback to update_contact_extra_info_swi;
417:
418: if hr_multi_message.unexpected_error_add(l_proc) then
419: hr_utility.set_location(' Leaving:' || l_proc,40);
420: raise;
421: end if;
422: --
423: p_object_version_number := l_object_version_number;

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

424: p_effective_start_date := null;
425: p_effective_end_date := null;
426:
427: p_return_status := hr_multi_message.get_return_status_disable;
428: hr_utility.set_location(' Leaving:' || l_proc,50);
429:
430: end update_contact_extra_info;
431:
432: ----------------------------------------------------------------------------

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

452: l_proc varchar2(72) := g_package ||'delete_contact_extra_info';
453:
454: begin
455:
456: hr_utility.set_location(' Entering:' || l_proc,10);
457: -- Issue a savepoint
458: savepoint delete_contact_extra_info_swi;
459: -- Initialise Multiple Message Detection
460: hr_multi_message.enable_message_list;

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

475: rollback to delete_contact_extra_info_swi;
476: End If;
477:
478: p_return_status := hr_multi_message.get_return_status_disable;
479: hr_utility.set_location(' Leaving:' || l_proc,20);
480:
481: exception
482: when hr_multi_message.error_message_exist then
483: --

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

492: p_return_status := hr_multi_message.get_return_status_disable;
493: p_effective_start_date := null;
494: p_effective_end_date := null;
495:
496: hr_utility.set_location(' Leaving:' || l_proc, 30);
497: when others then
498: --
499: -- When Multiple Message Detection is enabled catch
500: -- any Application specific or other unexpected

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

503: -- error.
504: --
505: rollback to delete_contact_extra_info_swi;
506: if hr_multi_message.unexpected_error_add(l_proc) then
507: hr_utility.set_location(' Leaving:' || l_proc,40);
508: raise;
509: end if;
510: --
511: -- Reset IN OUT and set OUT parameters

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

513: p_return_status := hr_multi_message.get_return_status_disable;
514: p_effective_start_date := null;
515: p_effective_end_date := null;
516:
517: hr_utility.set_location(' Leaving:' || l_proc,50);
518: end delete_contact_extra_info;
519:
520: end hr_contact_extra_info_swi;