DBA Data[Home] [Help]

APPS.OTA_RESOURCE_BOOKING_SWI dependencies on HR_UTILITY

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

76: l_finance_line_id number;
77: l_finance_line_ovn number;
78: l_proc varchar2(72) := g_package ||'create_resource_booking';
79: Begin
80: hr_utility.set_location(' Entering:' || l_proc,10);
81: --
82: -- Issue a savepoint
83: --
84: savepoint create_resource_booking_swi;

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

186: -- messages of any type exist in the Multiple Message List.
187: -- Also disable Multiple Message Detection.
188: --
189: p_return_status := hr_multi_message.get_return_status_disable;
190: hr_utility.set_location(' Leaving:' || l_proc,20);
191: --
192: exception
193: when hr_multi_message.error_message_exist then
194: --

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

201: -- Reset IN OUT parameters and set OUT parameters
202: --
203: p_object_version_number := null;
204: p_return_status := hr_multi_message.get_return_status_disable;
205: hr_utility.set_location(' Leaving:' || l_proc, 30);
206: when others then
207: --
208: -- When Multiple Message Detection is enabled catch
209: -- any Application specific or other unexpected

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

212: -- error.
213: --
214: rollback to create_resource_booking_swi;
215: if hr_multi_message.unexpected_error_add(l_proc) then
216: hr_utility.set_location(' Leaving:' || l_proc,40);
217: raise;
218: end if;
219: --
220: -- Reset IN OUT and set OUT parameters

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

220: -- Reset IN OUT and set OUT parameters
221: --
222: p_object_version_number := null;
223: p_return_status := hr_multi_message.get_return_status_disable;
224: hr_utility.set_location(' Leaving:' || l_proc,50);
225: end create_resource_booking;
226: -- ----------------------------------------------------------------------------
227: -- |------------------------< delete_resource_booking >-----------------------|
228: -- ----------------------------------------------------------------------------

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

240: --
241: -- Other variables
242: l_proc varchar2(72) := g_package ||'delete_resource_booking';
243: Begin
244: hr_utility.set_location(' Entering:' || l_proc,10);
245: --
246: -- Issue a savepoint
247: --
248: savepoint delete_resource_booking_swi;

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

282: -- messages of any type exist in the Multiple Message List.
283: -- Also disable Multiple Message Detection.
284: --
285: p_return_status := hr_multi_message.get_return_status_disable;
286: hr_utility.set_location(' Leaving:' || l_proc,20);
287: --
288: exception
289: when hr_multi_message.error_message_exist then
290: --

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

296: --
297: -- Reset IN OUT parameters and set OUT parameters
298: --
299: p_return_status := hr_multi_message.get_return_status_disable;
300: hr_utility.set_location(' Leaving:' || l_proc, 30);
301: when others then
302: --
303: -- When Multiple Message Detection is enabled catch
304: -- any Application specific or other unexpected

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

307: -- error.
308: --
309: rollback to delete_resource_booking_swi;
310: if hr_multi_message.unexpected_error_add(l_proc) then
311: hr_utility.set_location(' Leaving:' || l_proc,40);
312: raise;
313: end if;
314: --
315: -- Reset IN OUT and set OUT parameters

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

314: --
315: -- Reset IN OUT and set OUT parameters
316: --
317: p_return_status := hr_multi_message.get_return_status_disable;
318: hr_utility.set_location(' Leaving:' || l_proc,50);
319: end delete_resource_booking;
320: -- ----------------------------------------------------------------------------
321: -- |------------------------< update_resource_booking >-----------------------|
322: -- ----------------------------------------------------------------------------

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

391: --
392: -- Other variables
393: l_proc varchar2(72) := g_package ||'update_resource_booking';
394: Begin
395: hr_utility.set_location(' Entering:' || l_proc,10);
396: --
397: -- Issue a savepoint
398: --
399: savepoint update_resource_booking_swi;

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

469: );
470: --
471:
472:
473: hr_utility.set_location('Entering:'||l_proc, 10);
474: if p_finance_change_flag = 'Y' then
475: if p_finance_line_id is null then
476: if p_money_amount is not null then
477: l_finance_function := 'I';

Line 488: hr_utility.set_location('Entering:'||l_proc, 15);

484: l_finance_function := 'U';
485: end if;
486: end if;
487: --
488: hr_utility.set_location('Entering:'||l_proc, 15);
489: hr_utility.trace('L_FINANCE_FUNCTION = '||l_finance_function);
490: if l_finance_function = 'I' then
491: --
492: ota_finance.maintain_finance_line

Line 489: hr_utility.trace('L_FINANCE_FUNCTION = '||l_finance_function);

485: end if;
486: end if;
487: --
488: hr_utility.set_location('Entering:'||l_proc, 15);
489: hr_utility.trace('L_FINANCE_FUNCTION = '||l_finance_function);
490: if l_finance_function = 'I' then
491: --
492: ota_finance.maintain_finance_line
493: ( p_finance_header_id => p_finance_header_id

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

530: -- messages of any type exist in the Multiple Message List.
531: -- Also disable Multiple Message Detection.
532: --
533: p_return_status := hr_multi_message.get_return_status_disable;
534: hr_utility.set_location(' Leaving:' || l_proc,20);
535: --
536: exception
537: when hr_multi_message.error_message_exist then
538: --

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

545: -- Reset IN OUT parameters and set OUT parameters
546: --
547: p_object_version_number := null;
548: p_return_status := hr_multi_message.get_return_status_disable;
549: hr_utility.set_location(' Leaving:' || l_proc, 30);
550: when others then
551: --
552: -- When Multiple Message Detection is enabled catch
553: -- any Application specific or other unexpected

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

556: -- error.
557: --
558: rollback to update_resource_booking_swi;
559: if hr_multi_message.unexpected_error_add(l_proc) then
560: hr_utility.set_location(' Leaving:' || l_proc,40);
561: raise;
562: end if;
563: --
564: -- Reset IN OUT and set OUT parameters

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

564: -- Reset IN OUT and set OUT parameters
565: --
566: p_object_version_number := null;
567: p_return_status := hr_multi_message.get_return_status_disable;
568: hr_utility.set_location(' Leaving:' || l_proc,50);
569: end update_resource_booking;
570: --
571: -- ----------------------------------------------------------------------------
572: -- |-----------------------< check_trainer_competence >-----------------------|

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

586: l_end_of_time date;
587: --
588: Begin
589: --
590: hr_utility.set_location(' Entering:' || l_proc,10);
591: --
592: l_end_of_time := hr_api.g_eot;
593: --
594: ota_trb_api_procedures.check_trainer_competence

Line 609: hr_utility.set_location(' Entering:' || l_proc,20);

605: else
606: p_warning := 'N';
607: End If;
608: --
609: hr_utility.set_location(' Entering:' || l_proc,20);
610: --
611: End Check_trainer_competence;
612:
613: --

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

632: l_proc varchar2(72) := g_package ||'Check_double_booking';
633: --
634: Begin
635: --
636: hr_utility.set_location(' Entering:' || l_proc,10);
637: --
638: l_warning := ota_trb_api_procedures.check_double_booking
639: (p_supplied_resource_id => p_supplied_resource_id
640: ,p_required_date_from => p_required_date_from

Line 657: hr_utility.set_location(' Entering:' || l_proc,20);

653: --
654: p_warning := 'N';
655: End If;
656: --
657: hr_utility.set_location(' Entering:' || l_proc,20);
658: --
659: End Check_double_booking;
660: --
661: end ota_resource_booking_swi;