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

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

181: -- The following code is added for disabling of OSS in R12.IGS.A - Bug 4955192
182: igs_ge_gen_003.set_org_id(null);
183:
184: p_prev_acad_cal_type := rtrim (substr (p_prev_acad_adm_cal, 1,10));
185: p_prev_acad_cal_seq_no := IGS_GE_NUMBER.TO_NUM(substr(p_prev_acad_adm_cal, 13,7));
186: p_prev_adm_cal_type := rtrim (substr (p_prev_acad_adm_cal, 23,10));
187: p_prev_adm_cal_seq_no := IGS_GE_NUMBER.TO_NUM (substr (p_prev_acad_adm_cal, 35,7));
188: p_def_acad_cal_type := rtrim (substr (p_def_acad_adm_cal, 1,10));
189: p_def_acad_cal_seq_no := IGS_GE_NUMBER.TO_NUM (substr (p_def_acad_adm_cal, 13,7));

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

183:
184: p_prev_acad_cal_type := rtrim (substr (p_prev_acad_adm_cal, 1,10));
185: p_prev_acad_cal_seq_no := IGS_GE_NUMBER.TO_NUM(substr(p_prev_acad_adm_cal, 13,7));
186: p_prev_adm_cal_type := rtrim (substr (p_prev_acad_adm_cal, 23,10));
187: p_prev_adm_cal_seq_no := IGS_GE_NUMBER.TO_NUM (substr (p_prev_acad_adm_cal, 35,7));
188: p_def_acad_cal_type := rtrim (substr (p_def_acad_adm_cal, 1,10));
189: p_def_acad_cal_seq_no := IGS_GE_NUMBER.TO_NUM (substr (p_def_acad_adm_cal, 13,7));
190: p_def_adm_cal_type := rtrim (substr (p_def_acad_adm_cal, 23,10));
191: p_def_adm_cal_seq_no := IGS_GE_NUMBER.TO_NUM(substr (p_def_acad_adm_cal, 35,7));

Line 189: p_def_acad_cal_seq_no := IGS_GE_NUMBER.TO_NUM (substr (p_def_acad_adm_cal, 13,7));

185: p_prev_acad_cal_seq_no := IGS_GE_NUMBER.TO_NUM(substr(p_prev_acad_adm_cal, 13,7));
186: p_prev_adm_cal_type := rtrim (substr (p_prev_acad_adm_cal, 23,10));
187: p_prev_adm_cal_seq_no := IGS_GE_NUMBER.TO_NUM (substr (p_prev_acad_adm_cal, 35,7));
188: p_def_acad_cal_type := rtrim (substr (p_def_acad_adm_cal, 1,10));
189: p_def_acad_cal_seq_no := IGS_GE_NUMBER.TO_NUM (substr (p_def_acad_adm_cal, 13,7));
190: p_def_adm_cal_type := rtrim (substr (p_def_acad_adm_cal, 23,10));
191: p_def_adm_cal_seq_no := IGS_GE_NUMBER.TO_NUM(substr (p_def_acad_adm_cal, 35,7));
192:
193: -- Cursor for getting the person number --rghosh bug#2767294

Line 191: p_def_adm_cal_seq_no := IGS_GE_NUMBER.TO_NUM(substr (p_def_acad_adm_cal, 35,7));

187: p_prev_adm_cal_seq_no := IGS_GE_NUMBER.TO_NUM (substr (p_prev_acad_adm_cal, 35,7));
188: p_def_acad_cal_type := rtrim (substr (p_def_acad_adm_cal, 1,10));
189: p_def_acad_cal_seq_no := IGS_GE_NUMBER.TO_NUM (substr (p_def_acad_adm_cal, 13,7));
190: p_def_adm_cal_type := rtrim (substr (p_def_acad_adm_cal, 23,10));
191: p_def_adm_cal_seq_no := IGS_GE_NUMBER.TO_NUM(substr (p_def_acad_adm_cal, 35,7));
192:
193: -- Cursor for getting the person number --rghosh bug#2767294
194: OPEN c_pernum_cur;
195: FETCH c_pernum_cur INTO l_person_number;

Line 283: fnd_file.put_line(fnd_file.log,RPAD( ' Person Number',29) || ' : ' || get_person_number(IGS_GE_NUMBER.TO_CANN(c_appl_inst_rec.person_id)));

279: FOR c_appl_inst_rec IN c_appl_inst(c_ref_cur_rec.person_id) LOOP
280:
281: -- UPDATE the log file with application details
282: fnd_file.put_line(fnd_file.log, 'Creating Deferred Application for ' );
283: fnd_file.put_line(fnd_file.log,RPAD( ' Person Number',29) || ' : ' || get_person_number(IGS_GE_NUMBER.TO_CANN(c_appl_inst_rec.person_id)));
284: fnd_file.put_line(fnd_file.log, RPAD(' Admission Application Number',29) || ' : ' || IGS_GE_NUMBER.TO_CANN(c_appl_inst_rec.admission_appl_number));
285: fnd_file.put_line(fnd_file.log, RPAD(' Nominated course Code',29) || ' : ' || c_appl_inst_rec.nominated_course_cd);
286: fnd_file.put_line(fnd_file.log, RPAD(' Sequence Number',29) || ' : ' || IGS_GE_NUMBER.TO_CANN( c_appl_inst_rec.sequence_number ));
287:

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

280:
281: -- UPDATE the log file with application details
282: fnd_file.put_line(fnd_file.log, 'Creating Deferred Application for ' );
283: fnd_file.put_line(fnd_file.log,RPAD( ' Person Number',29) || ' : ' || get_person_number(IGS_GE_NUMBER.TO_CANN(c_appl_inst_rec.person_id)));
284: fnd_file.put_line(fnd_file.log, RPAD(' Admission Application Number',29) || ' : ' || IGS_GE_NUMBER.TO_CANN(c_appl_inst_rec.admission_appl_number));
285: fnd_file.put_line(fnd_file.log, RPAD(' Nominated course Code',29) || ' : ' || c_appl_inst_rec.nominated_course_cd);
286: fnd_file.put_line(fnd_file.log, RPAD(' Sequence Number',29) || ' : ' || IGS_GE_NUMBER.TO_CANN( c_appl_inst_rec.sequence_number ));
287:
288: -- Call cmn_handle_application which will create application, copying child record

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

282: fnd_file.put_line(fnd_file.log, 'Creating Deferred Application for ' );
283: fnd_file.put_line(fnd_file.log,RPAD( ' Person Number',29) || ' : ' || get_person_number(IGS_GE_NUMBER.TO_CANN(c_appl_inst_rec.person_id)));
284: fnd_file.put_line(fnd_file.log, RPAD(' Admission Application Number',29) || ' : ' || IGS_GE_NUMBER.TO_CANN(c_appl_inst_rec.admission_appl_number));
285: fnd_file.put_line(fnd_file.log, RPAD(' Nominated course Code',29) || ' : ' || c_appl_inst_rec.nominated_course_cd);
286: fnd_file.put_line(fnd_file.log, RPAD(' Sequence Number',29) || ' : ' || IGS_GE_NUMBER.TO_CANN( c_appl_inst_rec.sequence_number ));
287:
288: -- Call cmn_handle_application which will create application, copying child record
289: -- changing the entry qualification status , completness status and offer validations and update the same
290:

Line 310: fnd_file.put_line(fnd_file.log, RPAD(' Person Number',29) || ' : ' || get_person_number(IGS_GE_NUMBER.TO_CANN(c_appl_inst_rec.person_id)));

306: -- This case will come into picture if the user has given only Person Id
307: -- Find out NOCOPY the list applications
308: FOR c_appl_inst_rec IN c_appl_inst(p_person_id) LOOP
309: fnd_file.put_line(fnd_file.log, 'Creating Deferred Application for ' );
310: fnd_file.put_line(fnd_file.log, RPAD(' Person Number',29) || ' : ' || get_person_number(IGS_GE_NUMBER.TO_CANN(c_appl_inst_rec.person_id)));
311: fnd_file.put_line(fnd_file.log, RPAD(' Admission Application Number',29) || ' : ' || IGS_GE_NUMBER.TO_CANN(c_appl_inst_rec.admission_appl_number));
312: fnd_file.put_line(fnd_file.log, RPAD(' Nominated course Code',29) || ' : ' || c_appl_inst_rec.nominated_course_cd);
313: fnd_file.put_line(fnd_file.log, RPAD(' Sequence Number',29) || ' : ' || IGS_GE_NUMBER.TO_CANN( c_appl_inst_rec.sequence_number ));
314: -- Call cmn_hanlde_applicaiton which will create application, copying child record

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

307: -- Find out NOCOPY the list applications
308: FOR c_appl_inst_rec IN c_appl_inst(p_person_id) LOOP
309: fnd_file.put_line(fnd_file.log, 'Creating Deferred Application for ' );
310: fnd_file.put_line(fnd_file.log, RPAD(' Person Number',29) || ' : ' || get_person_number(IGS_GE_NUMBER.TO_CANN(c_appl_inst_rec.person_id)));
311: fnd_file.put_line(fnd_file.log, RPAD(' Admission Application Number',29) || ' : ' || IGS_GE_NUMBER.TO_CANN(c_appl_inst_rec.admission_appl_number));
312: fnd_file.put_line(fnd_file.log, RPAD(' Nominated course Code',29) || ' : ' || c_appl_inst_rec.nominated_course_cd);
313: fnd_file.put_line(fnd_file.log, RPAD(' Sequence Number',29) || ' : ' || IGS_GE_NUMBER.TO_CANN( c_appl_inst_rec.sequence_number ));
314: -- Call cmn_hanlde_applicaiton which will create application, copying child record
315: -- changing the entry qualification status , completness status and offer validations and update the same

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

309: fnd_file.put_line(fnd_file.log, 'Creating Deferred Application for ' );
310: fnd_file.put_line(fnd_file.log, RPAD(' Person Number',29) || ' : ' || get_person_number(IGS_GE_NUMBER.TO_CANN(c_appl_inst_rec.person_id)));
311: fnd_file.put_line(fnd_file.log, RPAD(' Admission Application Number',29) || ' : ' || IGS_GE_NUMBER.TO_CANN(c_appl_inst_rec.admission_appl_number));
312: fnd_file.put_line(fnd_file.log, RPAD(' Nominated course Code',29) || ' : ' || c_appl_inst_rec.nominated_course_cd);
313: fnd_file.put_line(fnd_file.log, RPAD(' Sequence Number',29) || ' : ' || IGS_GE_NUMBER.TO_CANN( c_appl_inst_rec.sequence_number ));
314: -- Call cmn_hanlde_applicaiton which will create application, copying child record
315: -- changing the entry qualification status , completness status and offer validations and update the same
316: cmn_handle_application(
317: p_person_id => p_person_id,

Line 726: 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)

722: IF l_message_name IN ('IGS_AD_NOMINATE_PRG_OFR_ENTRY', 'IGS_AD_NOMINATED_PRG_ENTRYPNT') THEN
723: l_message_name := 'IGS_AD_CAL_PGM_NOT_OFFER';
724: fnd_message.set_name('IGS', l_message_name);
725: fnd_message.set_token('PGM', c_appl_inst_rec.nominated_course_cd);
726: 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)
727: || '/' || c_appl_inst_rec.final_adm_cal_type || ',' || IGS_GE_NUMBER.TO_CANN(c_appl_inst_rec.final_adm_ci_sequence_number) );
728: fnd_file.put_line(fnd_file.log, 'Application could not be created');
729: fnd_file.put_line(fnd_file.log, fnd_message.get);
730: ELSE

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

723: l_message_name := 'IGS_AD_CAL_PGM_NOT_OFFER';
724: fnd_message.set_name('IGS', l_message_name);
725: fnd_message.set_token('PGM', c_appl_inst_rec.nominated_course_cd);
726: 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)
727: || '/' || c_appl_inst_rec.final_adm_cal_type || ',' || IGS_GE_NUMBER.TO_CANN(c_appl_inst_rec.final_adm_ci_sequence_number) );
728: fnd_file.put_line(fnd_file.log, 'Application could not be created');
729: fnd_file.put_line(fnd_file.log, fnd_message.get);
730: ELSE
731: fnd_file.put_line(fnd_file.log, 'Application could not be created');

Line 1210: 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)

1206: IF v_message_name IN ('IGS_AD_NOMINATE_PRG_OFR_ENTRY', 'IGS_AD_NOMINATED_PRG_ENTRYPNT') THEN
1207: v_message_name := 'IGS_AD_CAL_PGM_NOT_OFFER';
1208: fnd_message.set_name('IGS', v_message_name);
1209: fnd_message.set_token('PGM', c_appl_offer_rec.nominated_course_cd);
1210: 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)
1211: || '/' || c_appl_offer_rec.final_adm_cal_type || ',' || IGS_GE_NUMBER.TO_CANN(c_appl_offer_rec.final_adm_ci_sequence_number) );
1212: fnd_file.put_line(fnd_file.log, 'Application could not be created');
1213: fnd_file.put_line(fnd_file.log, fnd_message.get);
1214: ELSE

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

1207: v_message_name := 'IGS_AD_CAL_PGM_NOT_OFFER';
1208: fnd_message.set_name('IGS', v_message_name);
1209: fnd_message.set_token('PGM', c_appl_offer_rec.nominated_course_cd);
1210: 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)
1211: || '/' || c_appl_offer_rec.final_adm_cal_type || ',' || IGS_GE_NUMBER.TO_CANN(c_appl_offer_rec.final_adm_ci_sequence_number) );
1212: fnd_file.put_line(fnd_file.log, 'Application could not be created');
1213: fnd_file.put_line(fnd_file.log, fnd_message.get);
1214: ELSE
1215: fnd_file.put_line(fnd_file.log, 'Application could not be created');

Line 1225: fnd_file.put_line(fnd_file.log, 'Person Number : ' || get_person_number(IGS_GE_NUMBER.TO_CANN(p_person_id)));

1221: END LOOP;
1222: RETURN TRUE;
1223: EXCEPTION WHEN OTHERS THEN
1224: fnd_file.put_line(fnd_file.log, 'Error from validate_offer_validations: ' || SQLERRM);
1225: fnd_file.put_line(fnd_file.log, 'Person Number : ' || get_person_number(IGS_GE_NUMBER.TO_CANN(p_person_id)));
1226: fnd_file.put_line(fnd_file.log, 'Admission Appl Number : ' || IGS_GE_NUMBER.TO_CANN(p_admission_appl_number));
1227: fnd_file.put_line(fnd_file.log, 'Nominated Course Code : ' || p_nominated_course_cd);
1228: fnd_file.put_line(fnd_file.log, 'Sequence Number : ' || p_sequence_number);
1229: RETURN FALSE;

Line 1226: fnd_file.put_line(fnd_file.log, 'Admission Appl Number : ' || IGS_GE_NUMBER.TO_CANN(p_admission_appl_number));

1222: RETURN TRUE;
1223: EXCEPTION WHEN OTHERS THEN
1224: fnd_file.put_line(fnd_file.log, 'Error from validate_offer_validations: ' || SQLERRM);
1225: fnd_file.put_line(fnd_file.log, 'Person Number : ' || get_person_number(IGS_GE_NUMBER.TO_CANN(p_person_id)));
1226: fnd_file.put_line(fnd_file.log, 'Admission Appl Number : ' || IGS_GE_NUMBER.TO_CANN(p_admission_appl_number));
1227: fnd_file.put_line(fnd_file.log, 'Nominated Course Code : ' || p_nominated_course_cd);
1228: fnd_file.put_line(fnd_file.log, 'Sequence Number : ' || p_sequence_number);
1229: RETURN FALSE;
1230: END validate_offer_validations;

Line 1517: fnd_file.put_line(fnd_file.log, 'Person Number : ' || get_person_number(IGS_GE_NUMBER.TO_CANN(p_person_id)));

1513: END LOOP;
1514: RETURN TRUE;
1515: EXCEPTION WHEN OTHERS THEN
1516: fnd_file.put_line(fnd_file.log, 'Error from copy_entrycomp_qual_status: ' || SQLERRM);
1517: fnd_file.put_line(fnd_file.log, 'Person Number : ' || get_person_number(IGS_GE_NUMBER.TO_CANN(p_person_id)));
1518: fnd_file.put_line(fnd_file.log, 'Admission Appl Number : ' || IGS_GE_NUMBER.TO_CANN(p_admission_appl_number));
1519: fnd_file.put_line(fnd_file.log, 'Nominated Course Code : ' || p_nominated_course_cd);
1520: fnd_file.put_line(fnd_file.log, 'Sequence Number : ' || p_sequence_number);
1521: RETURN FALSE;

Line 1518: fnd_file.put_line(fnd_file.log, 'Admission Appl Number : ' || IGS_GE_NUMBER.TO_CANN(p_admission_appl_number));

1514: RETURN TRUE;
1515: EXCEPTION WHEN OTHERS THEN
1516: fnd_file.put_line(fnd_file.log, 'Error from copy_entrycomp_qual_status: ' || SQLERRM);
1517: fnd_file.put_line(fnd_file.log, 'Person Number : ' || get_person_number(IGS_GE_NUMBER.TO_CANN(p_person_id)));
1518: fnd_file.put_line(fnd_file.log, 'Admission Appl Number : ' || IGS_GE_NUMBER.TO_CANN(p_admission_appl_number));
1519: fnd_file.put_line(fnd_file.log, 'Nominated Course Code : ' || p_nominated_course_cd);
1520: fnd_file.put_line(fnd_file.log, 'Sequence Number : ' || p_sequence_number);
1521: RETURN FALSE;
1522: END copy_entrycomp_qual_status;