APPS.OTA_OM_TDB_WAITLIST_API dependencies on HR_API

Line 122: and a.booking_id <> nvl(p_booking_id, hr_api.g_number);

118: where a.event_id = p_event_id
119: and a.booking_status_type_id = b.booking_status_type_id
120: and b.type in ('P','A')
121: and a.internal_booking_flag = 'Y'
122: and a.booking_id <> nvl(p_booking_id, hr_api.g_number);
123:
124:
125: l_proc varchar2(72) := g_package||'AUTO_ENROLL_FROM_WAITLIST';
126: l_count number(9) := 1;

Line 165: when hr_api.cannot_find_prog_unit then

161: (p_business_group_id => p_business_group_id
162: ,p_event_id => p_event_id
163: );
164: exception
165: when hr_api.cannot_find_prog_unit then
166: hr_api.cannot_find_prog_unit_error
167: (p_module_name => 'AUTO_ENROLL_FROM_WAITLIST'
168: ,p_hook_type => 'BP'
169: );

Line 166: hr_api.cannot_find_prog_unit_error

162: ,p_event_id => p_event_id
163: );
164: exception
165: when hr_api.cannot_find_prog_unit then
166: hr_api.cannot_find_prog_unit_error
167: (p_module_name => 'AUTO_ENROLL_FROM_WAITLIST'
168: ,p_hook_type => 'BP'
169: );
170: end;

Line 421: when hr_api.cannot_find_prog_unit then

417: (p_business_group_id => p_business_group_id
418: ,p_event_id => p_event_id
419: );
420: exception
421: when hr_api.cannot_find_prog_unit then
422: hr_api.cannot_find_prog_unit_error
423: (p_module_name => 'AUTO_ENROLL_FROM_WAITLIST'
424: ,p_hook_type => 'AP'
425: );

Line 422: hr_api.cannot_find_prog_unit_error

418: ,p_event_id => p_event_id
419: );
420: exception
421: when hr_api.cannot_find_prog_unit then
422: hr_api.cannot_find_prog_unit_error
423: (p_module_name => 'AUTO_ENROLL_FROM_WAITLIST'
424: ,p_hook_type => 'AP'
425: );
426: end;

Line 432: raise hr_api.validate_enabled;

428: --
429: -- When in validation only mode raise the Validate_Enabled exception
430: --
431: if p_validate then
432: raise hr_api.validate_enabled;
433: end if;
434: --
435: hr_utility.set_location(' Leaving:'||l_proc, 70);
436: exception

Line 437: when hr_api.validate_enabled then

433: end if;
434: --
435: hr_utility.set_location(' Leaving:'||l_proc, 70);
436: exception
437: when hr_api.validate_enabled then
438: --
439: -- As the Validate_Enabled exception has been raised
440: -- we must rollback to the savepoint
441: --