DBA Data[Home] [Help]

APPS.OTA_RESOURCE_BOOKING_API dependencies on HR_UTILITY

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

76: osr.resource_type ='T'
77: and osr.supplied_resource_id = p_supplied_resource_id;
78:
79: begin
80: hr_utility.set_location('Entering:'|| l_proc, 10);
81: --
82: -- Issue a savepoint
83: --
84: savepoint create_resource_booking;

Line 306: hr_utility.set_location(' Leaving:'||l_proc, 70);

302: p_event_fired => 'INSTRUCTOR_BOOK');
303:
304: end if;
305: --
306: hr_utility.set_location(' Leaving:'||l_proc, 70);
307: exception
308: when hr_api.validate_enabled then
309: --
310: -- As the Validate_Enabled exception has been raised

Line 320: hr_utility.set_location(' Leaving:'||l_proc, 80);

316: -- (Any key or derived arguments must be set to null
317: -- when validation only mode is being used.)
318: --
319: p_object_version_number := null;
320: hr_utility.set_location(' Leaving:'||l_proc, 80);
321: when others then
322: --
323: -- A validation or unexpected error has occured
324: --

Line 327: hr_utility.set_location(' Leaving:'||l_proc, 90);

323: -- A validation or unexpected error has occured
324: --
325: rollback to create_resource_booking;
326: p_object_version_number := null;
327: hr_utility.set_location(' Leaving:'||l_proc, 90);
328: raise;
329: end create_resource_booking ;
330: -- ----------------------------------------------------------------------------
331: -- |-------------------------< update_resource_booking >-----------------------|

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

410:
411: l_notify_days_before number(9) := fnd_profile.value('OTA_INST_REMIND_NTF_DAYS');
412:
413: begin
414: hr_utility.set_location('Entering:'|| l_proc, 10);
415: --
416: -- Issue a savepoint
417: --
418: savepoint update_resource_booking ;

Line 661: hr_utility.set_location(' Leaving:'||l_proc, 70);

657: end if;
658:
659: end if;
660: --
661: hr_utility.set_location(' Leaving:'||l_proc, 70);
662: exception
663: when hr_api.validate_enabled then
664: --
665: -- As the Validate_Enabled exception has been raised

Line 675: hr_utility.set_location(' Leaving:'||l_proc, 80);

671: -- (Any key or derived arguments must be set to null
672: -- when validation only mode is being used.)
673: --
674: p_object_version_number := null;
675: hr_utility.set_location(' Leaving:'||l_proc, 80);
676: when others then
677: --
678: -- A validation or unexpected error has occured
679: --

Line 681: hr_utility.set_location(' Leaving:'||l_proc, 90);

677: --
678: -- A validation or unexpected error has occured
679: --
680: rollback to update_resource_booking ;
681: hr_utility.set_location(' Leaving:'||l_proc, 90);
682: p_object_version_number := l_object_version_number;
683: raise;
684: end update_resource_booking ;
685:

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

723: l_person_id per_people_f.person_id%type;
724: --
725: --
726: begin
727: hr_utility.set_location('Entering:'|| l_proc, 10);
728: --
729: -- Issue a savepoint
730: --
731: savepoint delete_resource_booking ;

Line 793: hr_utility.trace ('before wf ' ||20);

789: end if;
790: -- Set all output arguments
791: if l_person_id is not null and l_event_id is not null then
792:
793: hr_utility.trace ('before wf ' ||20);
794: -- call to instructor notification process
795: OTA_INITIALIZATION_WF.initialize_instructor_wf(
796: p_item_type => 'OTWF',
797: p_eventid => l_event_id,

Line 806: hr_utility.trace ('after wf ' ||20);

802: p_end_time => l_end_time,
803: p_status => l_status,
804: p_person_id => l_person_id,
805: p_event_fired => 'INSTRUCTOR_CANCEL');
806: hr_utility.trace ('after wf ' ||20);
807:
808: end if;
809: --
810: -- Set all output arguments

Line 813: hr_utility.set_location(' Leaving:'||l_proc, 170);

809: --
810: -- Set all output arguments
811: --
812: --
813: hr_utility.set_location(' Leaving:'||l_proc, 170);
814: exception
815: when hr_api.validate_enabled then
816: --
817: -- As the Validate_Enabled exception has been raised

Line 826: hr_utility.set_location(' Leaving:'||l_proc, 180);

822: -- Only set output warning arguments
823: -- (Any key or derived arguments must be set to null
824: -- when validation only mode is being used.)
825: --
826: hr_utility.set_location(' Leaving:'||l_proc, 180);
827: when others then
828: --
829: -- A validation or unexpected error has occured
830: --

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

828: --
829: -- A validation or unexpected error has occured
830: --
831: rollback to delete_resource_booking ;
832: hr_utility.set_location(' Leaving:'||l_proc, 190);
833: raise;
834: end delete_resource_booking;
835: --
836: end ota_resource_booking_api;