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_MESSAGE

Line 193: Fnd_Message.Set_Name ('IGS','IGS_EN_STDNT_ENRD');

189: OPEN c_find_person_no;
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;

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 206: l_exp_err := fnd_message.get();

202: EXCEPTION
203: WHEN OTHERS THEN
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);

Line 216: Fnd_Message.Set_Name ('IGS','IGS_EN_STDNT_NOT_ENRD');

212:
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;

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 382: fnd_message.set_name('IGS',p_message_name);

378: igs_ps_ofr_opt_cur_rec.location_cd,
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:

Line 385: fnd_message.get_string ('IGS',p_message_name));

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 ***/
388: END IF;
389:

Line 395: fnd_message.set_name('IGS',p_message_name);

391: IF NOT Igs_En_Val_Sua.enrp_val_coo_mode(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:

Line 398: fnd_message.get_string ('IGS',p_message_name));

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 ***/
401:
402:

Line 981: fnd_message.set_name('IGS',lv_dummy_message);

977: IF ln_message_count > 0 THEN
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;

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 1026: fnd_message.set_name('IGS',lv_dummy_message);

1022: IF ln_message_count > 0 THEN
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;

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 1081: fnd_message.set_name('IGS',lv_dummy_message);

1077: IF lv_dummy_message IS NOT NULL THEN
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

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 1524: Fnd_Message.Set_Name ('IGS','IGS_EN_NO_OF_STDNTS_IN_WLST');

1520: PROCEDURE write_status_to_log
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');

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 1528: Fnd_Message.Set_Name ('IGS','IGS_EN_MAX_ENROLLMENTS');

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));
1530:
1531: --3) actual enrollments
1532: Fnd_Message.Set_Name ('IGS','IGS_EN_ACT_ENROLLMENTS');

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 1532: Fnd_Message.Set_Name ('IGS','IGS_EN_ACT_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));
1534:
1535: --4) max. students per waitlist
1536: Fnd_Message.Set_Name ('IGS','IGS_EN_MAX_STDNTS_PER_WLST');

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 1536: Fnd_Message.Set_Name ('IGS','IGS_EN_MAX_STDNTS_PER_WLST');

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));
1538: END write_status_to_log;
1539:
1540: BEGIN

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 1586: Fnd_Message.Set_Name ('IGS','IGS_EN_BEFORE_ENRMT');

1582: val_success_adm_persons_tab.DELETE;
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:

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 1671: fnd_message.set_name('IGS','IGS_EN_NO_ST_WLST_ADM');

1667:
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

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 1679: Fnd_Message.Set_Name ('IGS','IGS_EN_AFTER_ENRMT');

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;
1683:

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 1812: fnd_message.set_name('IGS','IGS_EN_NO_ENR_WL_NOT_ALWD');

1808: l_waitlist_allowed := 'N';
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)

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 1836: Fnd_Message.Set_name('IGS','IGS_GE_UNHANDLED_EXP');

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;
1840:

Line 1837: FND_MESSAGE.SET_TOKEN('NAME','Igs_En_Enroll_Wlst.Enroll_From_WaitList');

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;
1840:
1841: END Enroll_From_WaitList; -- End of main procedure