APPS.OTA_OM_TDB_WAITLIST_API dependencies on HR_UTILITY

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

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

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

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

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

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

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

175: --
176:
177:
178:
179: hr_utility.set_location(l_proc, 40);
180: --
181: -- Process Logic
182: --
183:

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

264:
265: if t_waitlist_table(i).number_of_places <= l_vacancies or
266: l_vacancies is null then
267: --
268: hr_utility.set_location('UPDATING DETAILS FOR BOOKING #'||to_char(t_waitlist_table(i).booking_id), 41);
269: begin
270: --
271:
272:

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

290: to_char(t_waitlist_table(i).booking_id)||','||'Cannot book the person onto the event as they are
291: already booked onto another event on the same day.');
292:
293:
294: hr_utility.set_location('NEW STATUS = '||to_char(l_status_type_id), 42);
295: else
296:
297: l_booking_ovn := t_waitlist_table(i).object_version_number ;
298: l_finance_ovn := t_waitlist_table(i).tfl_object_version_number;

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

364: end if;
365: --
366: exception
367: when e_validation_error then
368: hr_utility.set_location('ENROLLMENT ERROR BEING HANDLED', 49);
369:
370: --
371: -- This exception handler is executed following any application
372: -- error encountered when attempting to enroll a delegate from

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

388: --
389: -- A validation or unexpected error has occured
390: --
391: --rollback to AUTO_ENROLL_FROM_WAITLIST;
392: hr_utility.set_location(' Leaving:'||l_proc, 80);
393: p_return_status := 'F';
394: l_error_num := SQLCODE;
395: l_error_msg := SUBSTR(SQLERRM, 1, 300);
396: FND_FILE.PUT_LINE(FND_FILE.LOG,'Error occured in ' || l_proc||' '||

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

407: --
408: end if;
409:
410:
411: hr_utility.set_location(l_proc, 50);
412: --
413: -- Call After Process User Hook
414: --
415: begin

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

423: (p_module_name => 'AUTO_ENROLL_FROM_WAITLIST'
424: ,p_hook_type => 'AP'
425: );
426: end;
427: hr_utility.set_location(l_proc, 60);
428: --
429: -- When in validation only mode raise the Validate_Enabled exception
430: --
431: if p_validate then

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

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
437: when hr_api.validate_enabled then
438: --
439: -- As the Validate_Enabled exception has been raised

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

440: -- we must rollback to the savepoint
441: --
442: -- rollback to AUTO_ENROLL_FROM_WAITLIST;
443: --
444: hr_utility.set_location(' Leaving:'||l_proc, 80);
445: when others then
446: --
447: -- A validation or unexpected error has occured
448: --

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

446: --
447: -- A validation or unexpected error has occured
448: --
449: rollback to AUTO_ENROLL_FROM_WAITLIST;
450: hr_utility.set_location(' Leaving:'||l_proc, 90);
451: p_return_status := 'F';
452: raise;
453: end AUTO_ENROLL_FROM_WAITLIST;
454: --