302:
303: fnd_message.set_name('IGS','IGS_UC_UPD_APP_PID_REC');
304: fnd_message.set_token('APP_NO', TO_CHAR(applicant_rec.app_no));
305: fnd_message.set_token('OSS_PID',TO_CHAR(applicant_rec.pe_person_id));
306: fnd_file.put_line(fnd_file.log, fnd_message.get);
307:
308: END LOOP;
309:
310: fnd_file.put_line(fnd_file.log, ' ');
306: fnd_file.put_line(fnd_file.log, fnd_message.get);
307:
308: END LOOP;
309:
310: fnd_file.put_line(fnd_file.log, ' ');
311: fnd_message.set_name('IGS','IGS_UC_APP_COUNT');
312: fnd_message.set_token('APP_COUNT', TO_CHAR(l_app_count));
313: fnd_file.put_line(fnd_file.log, fnd_message.get);
314:
309:
310: fnd_file.put_line(fnd_file.log, ' ');
311: fnd_message.set_name('IGS','IGS_UC_APP_COUNT');
312: fnd_message.set_token('APP_COUNT', TO_CHAR(l_app_count));
313: fnd_file.put_line(fnd_file.log, fnd_message.get);
314:
315: EXCEPTION
316: WHEN OTHERS THEN
317: ROLLBACK;