APPS.OTA_OM_TDB_WAITLIST_API dependencies on FND_FILE

Line 192: FND_FILE.PUT_LINE(FND_FILE.LOG,'Error occured in ' || l_proc||

188: --
189: -- As we don't know what status to set the waitlistees to, we can't continue.
190: -- Because of previous checks, this condition should never occur, so we don't take
191: -- any further action here.
192: FND_FILE.PUT_LINE(FND_FILE.LOG,'Error occured in ' || l_proc||
193: ','||'No Default booking status is found');
194:
195: RAISE e_validation_error ;
196: --

Line 207: FND_FILE.PUT_LINE(FND_FILE.LOG,'Auto waitlist processing, Waitlist Sort Criteria :' ||

203: --
204:
205: if fnd_profile.value('OTA_WAITLIST_SORT_CRITERIA') = 'BP' then
206: --
207: FND_FILE.PUT_LINE(FND_FILE.LOG,'Auto waitlist processing, Waitlist Sort Criteria :' ||
208: fnd_profile.value('OTA_WAITLIST_SORT_CRITERIA') );
209: for l_waitlist_entry in c_priority_waitlist loop
210: --
211:

Line 229: FND_FILE.PUT_LINE(FND_FILE.LOG,'Auto waitlist processing, For other Waitlist Sort Criteria');

225: --
226: end loop;
227: --
228: else
229: FND_FILE.PUT_LINE(FND_FILE.LOG,'Auto waitlist processing, For other Waitlist Sort Criteria');
230: --
231: for l_waitlist_entry in c_date_waitlist loop
232: --
233: t_waitlist_table(l_count).number_of_places := l_waitlist_entry.number_of_places;

Line 289: FND_FILE.PUT_LINE(FND_FILE.LOG,l_proc||':'||

285: l_status_type_id);
286:
287: end if;
288: if l_warn = True then
289: FND_FILE.PUT_LINE(FND_FILE.LOG,l_proc||':'||
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:

Line 333: FND_FILE.PUT_LINE(FND_FILE.LOG,l_proc||' '||

329: --
330: -- Check if number of places available is exceeded by number required
331: --
332: if t_waitlist_table(i).number_of_places > (l_max_internal - l_number_taken) then
333: FND_FILE.PUT_LINE(FND_FILE.LOG,l_proc||' '||
334: 'Booking Id :'||t_waitlist_table(i).booking_id||','||
335: 'The maximum number of internal delegates for this event has been exceed by this booking. '||
336: 'Either reduce the number of places for the booking or increase the maximum amount of '||
337: 'internal delegates for the event.');

Line 348: FND_FILE.PUT_LINE(FND_FILE.LOG,'Move Booking id :'||t_waitlist_table(i).booking_id ||

344: if l_enroll = 'Y' then
345: ota_tdb_shd.lck(t_waitlist_table(i).booking_id ,l_booking_ovn);
346: --
347:
348: FND_FILE.PUT_LINE(FND_FILE.LOG,'Move Booking id :'||t_waitlist_table(i).booking_id ||
349: '.. From waitlist..');
350: ota_tdb_api_upd2.update_enrollment(
351: p_booking_id => t_waitlist_table(i).booking_id
352: ,p_object_version_number => l_booking_ovn

Line 380: FND_FILE.PUT_LINE(FND_FILE.LOG,'Error occured in ' || l_proc||

376: -- of these errors, this would be the best place to call the code from.
377: -- At present, there are no notifications, so we take no action,
378: -- other than to proceed onto the next waitlisted booking.
379: --
380: FND_FILE.PUT_LINE(FND_FILE.LOG,'Error occured in ' || l_proc||
381: to_char(t_waitlist_table(i).booking_id)||','||'Error found when try to move a student from waitlisted');
382:
383: p_return_status := 'F';
384: --

Line 396: FND_FILE.PUT_LINE(FND_FILE.LOG,'Error occured in ' || l_proc||' '||

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||' '||
397: 'Booking Id :'||t_waitlist_table(i).booking_id||','||
398: l_error_num||':'||l_error_msg);
399: --
400: -- FND_FILE.PUT_LINE(FND_FILE.LOG,'Exception other error:');

Line 400: -- FND_FILE.PUT_LINE(FND_FILE.LOG,'Exception other error:');

396: FND_FILE.PUT_LINE(FND_FILE.LOG,'Error occured in ' || l_proc||' '||
397: 'Booking Id :'||t_waitlist_table(i).booking_id||','||
398: l_error_num||':'||l_error_msg);
399: --
400: -- FND_FILE.PUT_LINE(FND_FILE.LOG,'Exception other error:');
401:
402: end;
403: --
404: end if;