eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IGS_EN_ENROLL_WLST dependencies on FND_FILE

Line 194: fnd_file.put_line (fnd_file.LOG, ' '|| fnd_message.get ||': '|| v_person_number);

190: FETCH c_find_person_no INTO v_person_number;
191: CLOSE c_find_person_no;
192:
193: Fnd_Message.Set_Name ('IGS','IGS_EN_STDNT_ENRD');
194: fnd_file.put_line (fnd_file.LOG, ' '|| fnd_message.get ||': '|| v_person_number);
195:
196: /*** Reducing actual waitlist by 1 used for processing only - table updation done by en_sua TBH***/
197: p_waitlist_actual := p_waitlist_actual - 1;
198:

Line 208: fnd_file.put_line (fnd_file.LOG, l_exp_err);

204: p_enrolled_yn := 'N' ;
205: -- Log the exception raised into the log file
206: l_exp_err := fnd_message.get();
207: IF l_exp_err is NOT NULL THEN
208: fnd_file.put_line (fnd_file.LOG, l_exp_err);
209: ELSE
210: fnd_file.put_line (fnd_file.LOG, SQLERRM);
211: END IF;
212:

Line 210: fnd_file.put_line (fnd_file.LOG, SQLERRM);

206: l_exp_err := fnd_message.get();
207: IF l_exp_err is NOT NULL THEN
208: fnd_file.put_line (fnd_file.LOG, l_exp_err);
209: ELSE
210: fnd_file.put_line (fnd_file.LOG, SQLERRM);
211: END IF;
212:
213:
214: p_message_name := 'IGS_EN_STDNT_NOT_ENRD' ;

Line 217: fnd_file.put_line (fnd_file.LOG, ' '||fnd_message.get_string ('IGS','IGS_EN_STDNT_NOT_ENRD') ||' '||

213:
214: p_message_name := 'IGS_EN_STDNT_NOT_ENRD' ;
215: -- to set message that enrolment failed --
216: Fnd_Message.Set_Name ('IGS','IGS_EN_STDNT_NOT_ENRD');
217: fnd_file.put_line (fnd_file.LOG, ' '||fnd_message.get_string ('IGS','IGS_EN_STDNT_NOT_ENRD') ||' '||
218: TO_CHAR(i.person_id));
219: -- to set message that enrolment failed --
220: RETURN;
221:

Line 383: fnd_file.put_line (fnd_file.LOG, ' '||TO_CHAR(igs_ps_ofr_opt_cur_rec.coo_id) || ' ' ||

379: p_message_name) THEN
380:
381: p_deny_warn := 'WARN';
382: fnd_message.set_name('IGS',p_message_name);
383: fnd_file.put_line (fnd_file.LOG, ' '||TO_CHAR(igs_ps_ofr_opt_cur_rec.coo_id) || ' ' ||
384: igs_ps_ofr_opt_cur_rec.location_cd || ' ' ||
385: fnd_message.get_string ('IGS',p_message_name));
386:
387: /**** Not Returning false as it is just a warning ***/

Line 396: fnd_file.put_line (fnd_file.LOG, ' '||TO_CHAR(igs_ps_ofr_opt_cur_rec.coo_id) || ' ' ||

392: p_unit_class,
393: p_message_name) THEN
394: p_deny_warn := 'WARN';
395: fnd_message.set_name('IGS',p_message_name);
396: fnd_file.put_line (fnd_file.LOG, ' '||TO_CHAR(igs_ps_ofr_opt_cur_rec.coo_id) || ' ' ||
397: p_unit_class || ' ' ||
398: fnd_message.get_string ('IGS',p_message_name));
399:
400: /**** Not Returning false as it is just a warning ***/

Line 982: fnd_file.put_line (fnd_file.LOG, ' '|| p_unit_cd || ' ' || v_person_number || ' ' ||fnd_message.get);

978: FOR I IN 1..ln_message_count LOOP
979: lv_dummy_message := Igs_En_Enroll_Wlst.get_message(lv_validate_prog_message,I);
980: IF lv_dummy_message IS NOT NULL THEN
981: fnd_message.set_name('IGS',lv_dummy_message);
982: fnd_file.put_line (fnd_file.LOG, ' '|| p_unit_cd || ' ' || v_person_number || ' ' ||fnd_message.get);
983: ELSE
984: EXIT;
985: END IF;
986: END LOOP;

Line 1027: fnd_file.put_line (fnd_file.LOG, ' '|| p_unit_cd || ' ' || v_person_number || ' ' ||fnd_message.get);

1023: FOR I IN 1..ln_message_count LOOP
1024: lv_dummy_message := Igs_En_Enroll_Wlst.get_message(lv_validate_unit_message,I);
1025: IF lv_dummy_message IS NOT NULL THEN
1026: fnd_message.set_name('IGS',lv_dummy_message);
1027: fnd_file.put_line (fnd_file.LOG, ' '|| p_unit_cd || ' ' || v_person_number || ' ' ||fnd_message.get);
1028: ELSE
1029: EXIT;
1030: END IF;
1031: END LOOP;

Line 1082: fnd_file.put_line (fnd_file.LOG, ' '|| p_unit_cd || ' ' || v_person_number || ' ' ||fnd_message.get);

1078: IF INSTR(lv_dummy_message,'*') > 0 THEN
1079: lv_dummy_message := SUBSTR(lv_dummy_message,1,INSTR(lv_dummy_message,'*')-1) || '_NO_TOKEN' ;
1080: END IF;
1081: fnd_message.set_name('IGS',lv_dummy_message);
1082: fnd_file.put_line (fnd_file.LOG, ' '|| p_unit_cd || ' ' || v_person_number || ' ' ||fnd_message.get);
1083: IF v_temp_message_Str IS NULL THEN
1084: v_temp_message_Str := lv_dummy_message;
1085: ELSE
1086: v_temp_message_Str := v_temp_message_Str || ';' || lv_dummy_message;

Line 1525: fnd_file.put_line (fnd_file.LOG, ' '|| fnd_message.get ||' '|| TO_CHAR(lv_waitlist_actual));

1521: AS
1522: BEGIN
1523: --1) no of students in the waitlist
1524: Fnd_Message.Set_Name ('IGS','IGS_EN_NO_OF_STDNTS_IN_WLST');
1525: fnd_file.put_line (fnd_file.LOG, ' '|| fnd_message.get ||' '|| TO_CHAR(lv_waitlist_actual));
1526:
1527: --2) max. enrollments
1528: Fnd_Message.Set_Name ('IGS','IGS_EN_MAX_ENROLLMENTS');
1529: fnd_file.put_line (fnd_file.LOG, ' '|| fnd_message.get ||' '|| TO_CHAR(lv_max_quota));

Line 1529: fnd_file.put_line (fnd_file.LOG, ' '|| fnd_message.get ||' '|| TO_CHAR(lv_max_quota));

1525: fnd_file.put_line (fnd_file.LOG, ' '|| fnd_message.get ||' '|| TO_CHAR(lv_waitlist_actual));
1526:
1527: --2) max. enrollments
1528: Fnd_Message.Set_Name ('IGS','IGS_EN_MAX_ENROLLMENTS');
1529: fnd_file.put_line (fnd_file.LOG, ' '|| fnd_message.get ||' '|| TO_CHAR(lv_max_quota));
1530:
1531: --3) actual enrollments
1532: Fnd_Message.Set_Name ('IGS','IGS_EN_ACT_ENROLLMENTS');
1533: fnd_file.put_line (fnd_file.LOG, ' '|| fnd_message.get ||' '|| TO_CHAR(lv_enrollment_actual));

Line 1533: fnd_file.put_line (fnd_file.LOG, ' '|| fnd_message.get ||' '|| TO_CHAR(lv_enrollment_actual));

1529: fnd_file.put_line (fnd_file.LOG, ' '|| fnd_message.get ||' '|| TO_CHAR(lv_max_quota));
1530:
1531: --3) actual enrollments
1532: Fnd_Message.Set_Name ('IGS','IGS_EN_ACT_ENROLLMENTS');
1533: fnd_file.put_line (fnd_file.LOG, ' '|| fnd_message.get ||' '|| TO_CHAR(lv_enrollment_actual));
1534:
1535: --4) max. students per waitlist
1536: Fnd_Message.Set_Name ('IGS','IGS_EN_MAX_STDNTS_PER_WLST');
1537: fnd_file.put_line (fnd_file.LOG, ' '|| fnd_message.get ||' '|| TO_CHAR(lv_max_stdnts_per_wlst));

Line 1537: fnd_file.put_line (fnd_file.LOG, ' '|| fnd_message.get ||' '|| TO_CHAR(lv_max_stdnts_per_wlst));

1533: fnd_file.put_line (fnd_file.LOG, ' '|| fnd_message.get ||' '|| TO_CHAR(lv_enrollment_actual));
1534:
1535: --4) max. students per waitlist
1536: Fnd_Message.Set_Name ('IGS','IGS_EN_MAX_STDNTS_PER_WLST');
1537: fnd_file.put_line (fnd_file.LOG, ' '|| fnd_message.get ||' '|| TO_CHAR(lv_max_stdnts_per_wlst));
1538: END write_status_to_log;
1539:
1540: BEGIN
1541: ln_rec_ind_val_success := 0;

Line 1587: fnd_file.put_line (fnd_file.LOG, ' '|| fnd_message.get ||'->');

1583: ln_rec_ind_val_success :=NVL(val_success_adm_persons_tab.FIRST,0);
1584:
1585: -- Before Enrollment
1586: Fnd_Message.Set_Name ('IGS','IGS_EN_BEFORE_ENRMT');
1587: fnd_file.put_line (fnd_file.LOG, ' '|| fnd_message.get ||'->');
1588: write_status_to_log;
1589: fnd_file.put_line (fnd_file.LOG, ' ');
1590:
1591: FOR v_adm_prf_cur IN c_adm_prf_cur LOOP

Line 1589: fnd_file.put_line (fnd_file.LOG, ' ');

1585: -- Before Enrollment
1586: Fnd_Message.Set_Name ('IGS','IGS_EN_BEFORE_ENRMT');
1587: fnd_file.put_line (fnd_file.LOG, ' '|| fnd_message.get ||'->');
1588: write_status_to_log;
1589: fnd_file.put_line (fnd_file.LOG, ' ');
1590:
1591: FOR v_adm_prf_cur IN c_adm_prf_cur LOOP
1592: /* Call to finalize_unit to validate the units */
1593:

Line 1672: fnd_file.put_line (fnd_file.LOG, ' '|| fnd_message.get || ' ' || TO_CHAR(p_uoo_id));

1668: /* Log Message if Students with ADMIN Preferences dont exist */
1669:
1670: IF (NVL(ln_rec_ind_val_success,0) = 0 AND NVL(ln_tab_fail_mail_ind,0) = 0) THEN
1671: fnd_message.set_name('IGS','IGS_EN_NO_ST_WLST_ADM');
1672: fnd_file.put_line (fnd_file.LOG, ' '|| fnd_message.get || ' ' || TO_CHAR(p_uoo_id));
1673:
1674: END IF;
1675: -- After Enrollment
1676: IF NVL(val_success_adm_persons_tab.COUNT,0) > 0 THEN

Line 1678: fnd_file.put_line (fnd_file.LOG, ' ');

1674: END IF;
1675: -- After Enrollment
1676: IF NVL(val_success_adm_persons_tab.COUNT,0) > 0 THEN
1677:
1678: fnd_file.put_line (fnd_file.LOG, ' ');
1679: Fnd_Message.Set_Name ('IGS','IGS_EN_AFTER_ENRMT');
1680: fnd_file.put_line (fnd_file.LOG, ' '|| fnd_message.get ||'->');
1681: write_status_to_log;
1682: END IF;

Line 1680: fnd_file.put_line (fnd_file.LOG, ' '|| fnd_message.get ||'->');

1676: IF NVL(val_success_adm_persons_tab.COUNT,0) > 0 THEN
1677:
1678: fnd_file.put_line (fnd_file.LOG, ' ');
1679: Fnd_Message.Set_Name ('IGS','IGS_EN_AFTER_ENRMT');
1680: fnd_file.put_line (fnd_file.LOG, ' '|| fnd_message.get ||'->');
1681: write_status_to_log;
1682: END IF;
1683:
1684:

Line 1813: fnd_file.put_line (fnd_file.LOG, ' '|| fnd_message.get || ' ');

1809: END IF;
1810:
1811: IF l_waitlist_allowed = 'N' THEN
1812: fnd_message.set_name('IGS','IGS_EN_NO_ENR_WL_NOT_ALWD');
1813: fnd_file.put_line (fnd_file.LOG, ' '|| fnd_message.get || ' ');
1814: ELSE
1815: -- Call enroll_student_nonreserved to process waitlisted students if waitlisting is allowed at
1816: -- institution level and not restricted at term calendar level. Bug# 3052426 (ptandon)
1817: enroll_student_nonreserved (p_tab_succ_mail => lv_tab_succ_mail

Line 1835: fnd_file.put_line(fnd_file.LOG,SQLERRM);

1831: EXCEPTION
1832: WHEN OTHERS THEN
1833:
1834: retcode:=2;
1835: fnd_file.put_line(fnd_file.LOG,SQLERRM);
1836: Fnd_Message.Set_name('IGS','IGS_GE_UNHANDLED_EXP');
1837: FND_MESSAGE.SET_TOKEN('NAME','Igs_En_Enroll_Wlst.Enroll_From_WaitList');
1838: IGS_GE_MSG_STACK.ADD;
1839: igs_ge_msg_stack.conc_exception_hndl;