APPS.OTA_OM_TDB_WAITLIST_API dependencies on HR_UTILITY

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

147: pragma exception_init(e_validation_error, -20002);
148:
149: begin
150:
151: hr_utility.set_location('Entering:'|| l_proc, 10);
152: p_return_status := 'T';
153: --
154: -- Issue a savepoint
155: --

Line 157: hr_utility.set_location(l_proc, 20);

153: --
154: -- Issue a savepoint
155: --
156: savepoint AUTO_ENROLL_FROM_WAITLIST;
157: hr_utility.set_location(l_proc, 20);
158:
159: --
160: -- Call Before Process User Hook
161: --

Line 175: hr_utility.set_location(l_proc, 30);

171: ,p_hook_type => 'BP'
172: );
173: end;
174:
175: hr_utility.set_location(l_proc, 30);
176: --
177: -- Validation in addition to Row Handlers
178: --
179:

Line 182: hr_utility.set_location(l_proc, 40);

178: --
179:
180:
181:
182: hr_utility.set_location(l_proc, 40);
183: --
184: -- Process Logic
185: --
186:

Line 275: hr_utility.set_location('UPDATING DETAILS FOR BOOKING #'||to_char(t_waitlist_table(i).booking_id), 41);

271:
272: if t_waitlist_table(i).number_of_places <= l_vacancies or
273: l_vacancies is null then
274: --
275: hr_utility.set_location('UPDATING DETAILS FOR BOOKING #'||to_char(t_waitlist_table(i).booking_id), 41);
276: begin
277: --
278:
279:

Line 301: hr_utility.set_location('NEW STATUS = '||to_char(l_status_type_id), 42);

297: to_char(t_waitlist_table(i).booking_id)||','||'Cannot book the person onto the event as they are
298: already booked onto another event on the same day.');
299:
300:
301: hr_utility.set_location('NEW STATUS = '||to_char(l_status_type_id), 42);
302: else
303:
304: l_booking_ovn := t_waitlist_table(i).object_version_number ;
305: l_finance_ovn := t_waitlist_table(i).tfl_object_version_number;

Line 375: hr_utility.set_location('ENROLLMENT ERROR BEING HANDLED', 49);

371: end if;
372: --
373: exception
374: when e_validation_error then
375: hr_utility.set_location('ENROLLMENT ERROR BEING HANDLED', 49);
376:
377: --
378: -- This exception handler is executed following any application
379: -- error encountered when attempting to enroll a delegate from

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

395: --
396: -- A validation or unexpected error has occured
397: --
398: --rollback to AUTO_ENROLL_FROM_WAITLIST;
399: hr_utility.set_location(' Leaving:'||l_proc, 80);
400: p_return_status := 'F';
401: l_error_num := SQLCODE;
402: l_error_msg := SUBSTR(SQLERRM, 1, 300);
403: FND_FILE.PUT_LINE(FND_FILE.LOG,'Error occured in ' || l_proc||' '||

Line 418: hr_utility.set_location(l_proc, 50);

414: --
415: end if;
416:
417:
418: hr_utility.set_location(l_proc, 50);
419: --
420: -- Call After Process User Hook
421: --
422: begin

Line 434: hr_utility.set_location(l_proc, 60);

430: (p_module_name => 'AUTO_ENROLL_FROM_WAITLIST'
431: ,p_hook_type => 'AP'
432: );
433: end;
434: hr_utility.set_location(l_proc, 60);
435: --
436: -- When in validation only mode raise the Validate_Enabled exception
437: --
438: if p_validate then

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

438: if p_validate then
439: raise hr_api.validate_enabled;
440: end if;
441: --
442: hr_utility.set_location(' Leaving:'||l_proc, 70);
443: exception
444: when hr_api.validate_enabled then
445: --
446: -- As the Validate_Enabled exception has been raised

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

447: -- we must rollback to the savepoint
448: --
449: -- rollback to AUTO_ENROLL_FROM_WAITLIST;
450: --
451: hr_utility.set_location(' Leaving:'||l_proc, 80);
452: when others then
453: --
454: -- A validation or unexpected error has occured
455: --

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

453: --
454: -- A validation or unexpected error has occured
455: --
456: rollback to AUTO_ENROLL_FROM_WAITLIST;
457: hr_utility.set_location(' Leaving:'||l_proc, 90);
458: p_return_status := 'F';
459: raise;
460: end AUTO_ENROLL_FROM_WAITLIST;
461: --