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_AD_VAL_ACAI_FTR_OFFER dependencies on IGS_GE_NUMBER

Line 603: p_prev_acad_cal_seq_no := IGS_GE_NUMBER.TO_NUM(substr(p_prev_acad_adm_cal, 13,7));

599: -- The following code is added for disabling of OSS in R12.IGS.A - Bug 4955192
600: igs_ge_gen_003.set_org_id(null);
601:
602: p_prev_acad_cal_type := rtrim (substr (p_prev_acad_adm_cal, 1,10));
603: p_prev_acad_cal_seq_no := IGS_GE_NUMBER.TO_NUM(substr(p_prev_acad_adm_cal, 13,7));
604: p_prev_adm_cal_type := rtrim (substr (p_prev_acad_adm_cal, 23,10));
605: p_prev_adm_cal_seq_no := IGS_GE_NUMBER.TO_NUM (substr (p_prev_acad_adm_cal, 35,7));
606:
607: p_fut_acad_cal_type := rtrim (substr (p_future_acad_adm_cal, 1,10));

Line 605: p_prev_adm_cal_seq_no := IGS_GE_NUMBER.TO_NUM (substr (p_prev_acad_adm_cal, 35,7));

601:
602: p_prev_acad_cal_type := rtrim (substr (p_prev_acad_adm_cal, 1,10));
603: p_prev_acad_cal_seq_no := IGS_GE_NUMBER.TO_NUM(substr(p_prev_acad_adm_cal, 13,7));
604: p_prev_adm_cal_type := rtrim (substr (p_prev_acad_adm_cal, 23,10));
605: p_prev_adm_cal_seq_no := IGS_GE_NUMBER.TO_NUM (substr (p_prev_acad_adm_cal, 35,7));
606:
607: p_fut_acad_cal_type := rtrim (substr (p_future_acad_adm_cal, 1,10));
608: p_fut_acad_cal_seq_no := IGS_GE_NUMBER.TO_NUM (substr (p_future_acad_adm_cal, 13,7));
609: p_fut_adm_cal_type := rtrim (substr (p_future_acad_adm_cal, 23,10));

Line 608: p_fut_acad_cal_seq_no := IGS_GE_NUMBER.TO_NUM (substr (p_future_acad_adm_cal, 13,7));

604: p_prev_adm_cal_type := rtrim (substr (p_prev_acad_adm_cal, 23,10));
605: p_prev_adm_cal_seq_no := IGS_GE_NUMBER.TO_NUM (substr (p_prev_acad_adm_cal, 35,7));
606:
607: p_fut_acad_cal_type := rtrim (substr (p_future_acad_adm_cal, 1,10));
608: p_fut_acad_cal_seq_no := IGS_GE_NUMBER.TO_NUM (substr (p_future_acad_adm_cal, 13,7));
609: p_fut_adm_cal_type := rtrim (substr (p_future_acad_adm_cal, 23,10));
610: p_fut_adm_cal_seq_no := IGS_GE_NUMBER.TO_NUM(substr (p_future_acad_adm_cal, 35,7));
611:
612: -- Added the Log file entries for the passed parameters

Line 610: p_fut_adm_cal_seq_no := IGS_GE_NUMBER.TO_NUM(substr (p_future_acad_adm_cal, 35,7));

606:
607: p_fut_acad_cal_type := rtrim (substr (p_future_acad_adm_cal, 1,10));
608: p_fut_acad_cal_seq_no := IGS_GE_NUMBER.TO_NUM (substr (p_future_acad_adm_cal, 13,7));
609: p_fut_adm_cal_type := rtrim (substr (p_future_acad_adm_cal, 23,10));
610: p_fut_adm_cal_seq_no := IGS_GE_NUMBER.TO_NUM(substr (p_future_acad_adm_cal, 35,7));
611:
612: -- Added the Log file entries for the passed parameters
613: -- By rrengara for Bug 2690354 on 19-DEC-2002
614:

Line 704: fnd_file.put_line(fnd_file.log,RPAD( ' Person Id',29) || ' : ' || IGS_GE_NUMBER.TO_CANN(c_appl_inst_rec.person_id));

700: l_applcreated_flag := FALSE;
701:
702: -- UPDATE the log file with application details
703: fnd_file.put_line(fnd_file.log, 'Creating Future Term Application for ' );
704: fnd_file.put_line(fnd_file.log,RPAD( ' Person Id',29) || ' : ' || IGS_GE_NUMBER.TO_CANN(c_appl_inst_rec.person_id));
705: fnd_file.put_line(fnd_file.log, RPAD(' Admission Application Number',29) || ' : ' || IGS_GE_NUMBER.TO_CANN(c_appl_inst_rec.admission_appl_number));
706: fnd_file.put_line(fnd_file.log, RPAD(' Nominated course Code',29) || ' : ' || c_appl_inst_rec.nominated_course_cd);
707: fnd_file.put_line(fnd_file.log,RPAD(' Sequence Number',29) || ' : ' || IGS_GE_NUMBER.TO_CANN( c_appl_inst_rec.sequence_number ));
708:

Line 705: fnd_file.put_line(fnd_file.log, RPAD(' Admission Application Number',29) || ' : ' || IGS_GE_NUMBER.TO_CANN(c_appl_inst_rec.admission_appl_number));

701:
702: -- UPDATE the log file with application details
703: fnd_file.put_line(fnd_file.log, 'Creating Future Term Application for ' );
704: fnd_file.put_line(fnd_file.log,RPAD( ' Person Id',29) || ' : ' || IGS_GE_NUMBER.TO_CANN(c_appl_inst_rec.person_id));
705: fnd_file.put_line(fnd_file.log, RPAD(' Admission Application Number',29) || ' : ' || IGS_GE_NUMBER.TO_CANN(c_appl_inst_rec.admission_appl_number));
706: fnd_file.put_line(fnd_file.log, RPAD(' Nominated course Code',29) || ' : ' || c_appl_inst_rec.nominated_course_cd);
707: fnd_file.put_line(fnd_file.log,RPAD(' Sequence Number',29) || ' : ' || IGS_GE_NUMBER.TO_CANN( c_appl_inst_rec.sequence_number ));
708:
709: -- Set the save point here

Line 707: fnd_file.put_line(fnd_file.log,RPAD(' Sequence Number',29) || ' : ' || IGS_GE_NUMBER.TO_CANN( c_appl_inst_rec.sequence_number ));

703: fnd_file.put_line(fnd_file.log, 'Creating Future Term Application for ' );
704: fnd_file.put_line(fnd_file.log,RPAD( ' Person Id',29) || ' : ' || IGS_GE_NUMBER.TO_CANN(c_appl_inst_rec.person_id));
705: fnd_file.put_line(fnd_file.log, RPAD(' Admission Application Number',29) || ' : ' || IGS_GE_NUMBER.TO_CANN(c_appl_inst_rec.admission_appl_number));
706: fnd_file.put_line(fnd_file.log, RPAD(' Nominated course Code',29) || ' : ' || c_appl_inst_rec.nominated_course_cd);
707: fnd_file.put_line(fnd_file.log,RPAD(' Sequence Number',29) || ' : ' || IGS_GE_NUMBER.TO_CANN( c_appl_inst_rec.sequence_number ));
708:
709: -- Set the save point here
710: -- Since when the application related transaction fails we need to rollback the transaction for that application
711: -- and it should proceed to the next record in the cursor

Line 824: fnd_file.put_line(fnd_file.log,RPAD(' Person Id' , 29) || ' : ' || IGS_GE_NUMBER.TO_CANN(c_appl_inst_rec.person_id));

820: -- Since when the application related transaction fails we need to rollback the transaction for that application
821: -- and it should proceed to the next record in the cursor
822:
823: fnd_file.put_line(fnd_file.log, 'Creating Future Term Application for ' );
824: fnd_file.put_line(fnd_file.log,RPAD(' Person Id' , 29) || ' : ' || IGS_GE_NUMBER.TO_CANN(c_appl_inst_rec.person_id));
825: fnd_file.put_line(fnd_file.log, RPAD(' Admission Application Number',29) || ' : ' || IGS_GE_NUMBER.TO_CANN(c_appl_inst_rec.admission_appl_number));
826: fnd_file.put_line(fnd_file.log,RPAD(' Nominated course Code',29) || ' : ' || c_appl_inst_rec.nominated_course_cd);
827: fnd_file.put_line(fnd_file.log,RPAD(' Sequence Number',29) || ' : ' || IGS_GE_NUMBER.TO_CANN( c_appl_inst_rec.sequence_number ));
828:

Line 825: fnd_file.put_line(fnd_file.log, RPAD(' Admission Application Number',29) || ' : ' || IGS_GE_NUMBER.TO_CANN(c_appl_inst_rec.admission_appl_number));

821: -- and it should proceed to the next record in the cursor
822:
823: fnd_file.put_line(fnd_file.log, 'Creating Future Term Application for ' );
824: fnd_file.put_line(fnd_file.log,RPAD(' Person Id' , 29) || ' : ' || IGS_GE_NUMBER.TO_CANN(c_appl_inst_rec.person_id));
825: fnd_file.put_line(fnd_file.log, RPAD(' Admission Application Number',29) || ' : ' || IGS_GE_NUMBER.TO_CANN(c_appl_inst_rec.admission_appl_number));
826: fnd_file.put_line(fnd_file.log,RPAD(' Nominated course Code',29) || ' : ' || c_appl_inst_rec.nominated_course_cd);
827: fnd_file.put_line(fnd_file.log,RPAD(' Sequence Number',29) || ' : ' || IGS_GE_NUMBER.TO_CANN( c_appl_inst_rec.sequence_number ));
828:
829: SAVEPOINT sp_save_point2;

Line 827: fnd_file.put_line(fnd_file.log,RPAD(' Sequence Number',29) || ' : ' || IGS_GE_NUMBER.TO_CANN( c_appl_inst_rec.sequence_number ));

823: fnd_file.put_line(fnd_file.log, 'Creating Future Term Application for ' );
824: fnd_file.put_line(fnd_file.log,RPAD(' Person Id' , 29) || ' : ' || IGS_GE_NUMBER.TO_CANN(c_appl_inst_rec.person_id));
825: fnd_file.put_line(fnd_file.log, RPAD(' Admission Application Number',29) || ' : ' || IGS_GE_NUMBER.TO_CANN(c_appl_inst_rec.admission_appl_number));
826: fnd_file.put_line(fnd_file.log,RPAD(' Nominated course Code',29) || ' : ' || c_appl_inst_rec.nominated_course_cd);
827: fnd_file.put_line(fnd_file.log,RPAD(' Sequence Number',29) || ' : ' || IGS_GE_NUMBER.TO_CANN( c_appl_inst_rec.sequence_number ));
828:
829: SAVEPOINT sp_save_point2;
830:
831: -- Call handle application

Line 1164: fnd_message.set_token('ALTCODE',c_appl_inst_rec.acad_cal_type||','||IGS_GE_NUMBER.TO_CANN(c_appl_inst_rec.acad_ci_sequence_number)

1160: IF l_message_name IN ('IGS_AD_NOMINATE_PRG_OFR_ENTRY', 'IGS_AD_NOMINATED_PRG_ENTRYPNT') THEN
1161: l_message_name := 'IGS_AD_CAL_PGM_NOT_OFFER';
1162: fnd_message.set_name('IGS', l_message_name);
1163: fnd_message.set_token('PGM', c_appl_inst_rec.nominated_course_cd);
1164: fnd_message.set_token('ALTCODE',c_appl_inst_rec.acad_cal_type||','||IGS_GE_NUMBER.TO_CANN(c_appl_inst_rec.acad_ci_sequence_number)
1165: ||'/'||c_appl_inst_rec.final_adm_cal_type||','||IGS_GE_NUMBER.TO_CANN(c_appl_inst_rec.final_adm_ci_sequence_number));
1166: fnd_file.put_line(fnd_file.log, fnd_message.get);
1167: ELSE
1168: fnd_message.set_name('IGS', l_message_name);

Line 1165: ||'/'||c_appl_inst_rec.final_adm_cal_type||','||IGS_GE_NUMBER.TO_CANN(c_appl_inst_rec.final_adm_ci_sequence_number));

1161: l_message_name := 'IGS_AD_CAL_PGM_NOT_OFFER';
1162: fnd_message.set_name('IGS', l_message_name);
1163: fnd_message.set_token('PGM', c_appl_inst_rec.nominated_course_cd);
1164: fnd_message.set_token('ALTCODE',c_appl_inst_rec.acad_cal_type||','||IGS_GE_NUMBER.TO_CANN(c_appl_inst_rec.acad_ci_sequence_number)
1165: ||'/'||c_appl_inst_rec.final_adm_cal_type||','||IGS_GE_NUMBER.TO_CANN(c_appl_inst_rec.final_adm_ci_sequence_number));
1166: fnd_file.put_line(fnd_file.log, fnd_message.get);
1167: ELSE
1168: fnd_message.set_name('IGS', l_message_name);
1169: fnd_file.put_line(fnd_file.log, fnd_message.get);

Line 2494: fnd_message.set_token('ALTCODE',c_appl_offer_rec.acad_cal_type||','||IGS_GE_NUMBER.TO_CANN(c_appl_offer_rec.acad_ci_sequence_number)

2490: IF v_message_name IN ('IGS_AD_NOMINATE_PRG_OFR_ENTRY', 'IGS_AD_NOMINATED_PRG_ENTRYPNT') THEN
2491: v_message_name := 'IGS_AD_CAL_PGM_NOT_OFFER';
2492: fnd_message.set_name('IGS', v_message_name);
2493: fnd_message.set_token('PGM', c_appl_offer_rec.nominated_course_cd);
2494: fnd_message.set_token('ALTCODE',c_appl_offer_rec.acad_cal_type||','||IGS_GE_NUMBER.TO_CANN(c_appl_offer_rec.acad_ci_sequence_number)
2495: ||'/'||c_appl_offer_rec.final_adm_cal_type||','||IGS_GE_NUMBER.TO_CANN(c_appl_offer_rec.final_adm_ci_sequence_number));
2496: fnd_file.put_line(fnd_file.log, fnd_message.get);
2497: ELSE
2498: fnd_message.set_name('IGS', v_message_name);

Line 2495: ||'/'||c_appl_offer_rec.final_adm_cal_type||','||IGS_GE_NUMBER.TO_CANN(c_appl_offer_rec.final_adm_ci_sequence_number));

2491: v_message_name := 'IGS_AD_CAL_PGM_NOT_OFFER';
2492: fnd_message.set_name('IGS', v_message_name);
2493: fnd_message.set_token('PGM', c_appl_offer_rec.nominated_course_cd);
2494: fnd_message.set_token('ALTCODE',c_appl_offer_rec.acad_cal_type||','||IGS_GE_NUMBER.TO_CANN(c_appl_offer_rec.acad_ci_sequence_number)
2495: ||'/'||c_appl_offer_rec.final_adm_cal_type||','||IGS_GE_NUMBER.TO_CANN(c_appl_offer_rec.final_adm_ci_sequence_number));
2496: fnd_file.put_line(fnd_file.log, fnd_message.get);
2497: ELSE
2498: fnd_message.set_name('IGS', v_message_name);
2499: fnd_file.put_line(fnd_file.log, fnd_message.get);