APPS.OTA_OM_TDB_WAITLIST_API dependencies on FND_FILE

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

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

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

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

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

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

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

292: l_status_type_id);
293:
294: end if;
295: if l_warn = True then
296: FND_FILE.PUT_LINE(FND_FILE.LOG,l_proc||':'||
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:

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

336: --
337: -- Check if number of places available is exceeded by number required
338: --
339: if t_waitlist_table(i).number_of_places > (l_max_internal - l_number_taken) then
340: FND_FILE.PUT_LINE(FND_FILE.LOG,l_proc||' '||
341: 'Booking Id :'||t_waitlist_table(i).booking_id||','||
342: 'The maximum number of internal delegates for this event has been exceed by this booking. '||
343: 'Either reduce the number of places for the booking or increase the maximum amount of '||
344: 'internal delegates for the event.');

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

351: if l_enroll = 'Y' then
352: ota_tdb_shd.lck(t_waitlist_table(i).booking_id ,l_booking_ovn);
353: --
354:
355: FND_FILE.PUT_LINE(FND_FILE.LOG,'Move Booking id :'||t_waitlist_table(i).booking_id ||
356: '.. From waitlist..');
357: ota_tdb_api_upd2.update_enrollment(
358: p_booking_id => t_waitlist_table(i).booking_id
359: ,p_object_version_number => l_booking_ovn

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

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

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

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||' '||
404: 'Booking Id :'||t_waitlist_table(i).booking_id||','||
405: l_error_num||':'||l_error_msg);
406: --
407: -- FND_FILE.PUT_LINE(FND_FILE.LOG,'Exception other error:');

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

403: FND_FILE.PUT_LINE(FND_FILE.LOG,'Error occured in ' || l_proc||' '||
404: 'Booking Id :'||t_waitlist_table(i).booking_id||','||
405: l_error_num||':'||l_error_msg);
406: --
407: -- FND_FILE.PUT_LINE(FND_FILE.LOG,'Exception other error:');
408:
409: end;
410: --
411: end if;