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_AC_COMP dependencies on FND_FILE

Line 168: FND_FILE.PUT_LINE( FND_FILE.LOG, 'Person Id :'||p_person_id||' Admission Application Number :'||p_admission_appl_number);

164: ) = FALSE
165: THEN
166:
167: -- p_message_name = 'Application completion status cannot be updated to satisfied since the tracking item/s are not yet complete'
168: FND_FILE.PUT_LINE( FND_FILE.LOG, 'Person Id :'||p_person_id||' Admission Application Number :'||p_admission_appl_number);
169: FND_FILE.PUT_LINE( FND_FILE.LOG, 'Course Code :' ||p_course_cd ||' Sequence Number :'||p_sequence_number);
170: FND_MESSAGE.SET_NAME('IGS', 'IGS_AD_APP_TR_ITM_NT_CMPLT');
171: FND_FILE.PUT_LINE( FND_FILE.LOG, FND_MESSAGE.GET());
172:

Line 169: FND_FILE.PUT_LINE( FND_FILE.LOG, 'Course Code :' ||p_course_cd ||' Sequence Number :'||p_sequence_number);

165: THEN
166:
167: -- p_message_name = 'Application completion status cannot be updated to satisfied since the tracking item/s are not yet complete'
168: FND_FILE.PUT_LINE( FND_FILE.LOG, 'Person Id :'||p_person_id||' Admission Application Number :'||p_admission_appl_number);
169: FND_FILE.PUT_LINE( FND_FILE.LOG, 'Course Code :' ||p_course_cd ||' Sequence Number :'||p_sequence_number);
170: FND_MESSAGE.SET_NAME('IGS', 'IGS_AD_APP_TR_ITM_NT_CMPLT');
171: FND_FILE.PUT_LINE( FND_FILE.LOG, FND_MESSAGE.GET());
172:
173: RETURN;

Line 171: FND_FILE.PUT_LINE( FND_FILE.LOG, FND_MESSAGE.GET());

167: -- p_message_name = 'Application completion status cannot be updated to satisfied since the tracking item/s are not yet complete'
168: FND_FILE.PUT_LINE( FND_FILE.LOG, 'Person Id :'||p_person_id||' Admission Application Number :'||p_admission_appl_number);
169: FND_FILE.PUT_LINE( FND_FILE.LOG, 'Course Code :' ||p_course_cd ||' Sequence Number :'||p_sequence_number);
170: FND_MESSAGE.SET_NAME('IGS', 'IGS_AD_APP_TR_ITM_NT_CMPLT');
171: FND_FILE.PUT_LINE( FND_FILE.LOG, FND_MESSAGE.GET());
172:
173: RETURN;
174:
175: ELSE

Line 319: FND_FILE.PUT_LINE( FND_FILE.LOG, 'Person Id :'||p_person_id||' Admission Application Number :'||p_admission_appl_number);

315: END LOOP;
316: END LOOP;
317:
318: -- p_message_name = 'Application completion status for the application updated to SATISFIED';
319: FND_FILE.PUT_LINE( FND_FILE.LOG, 'Person Id :'||p_person_id||' Admission Application Number :'||p_admission_appl_number);
320: FND_FILE.PUT_LINE( FND_FILE.LOG, 'Course Code :' ||p_course_cd ||' Sequence Number :'||p_sequence_number);
321: FND_MESSAGE.SET_NAME('IGS', 'IGS_AD_APP_CMPLT_STAT_UPD');
322: FND_FILE.PUT_LINE( FND_FILE.LOG, FND_MESSAGE.GET());
323:

Line 320: FND_FILE.PUT_LINE( FND_FILE.LOG, 'Course Code :' ||p_course_cd ||' Sequence Number :'||p_sequence_number);

316: END LOOP;
317:
318: -- p_message_name = 'Application completion status for the application updated to SATISFIED';
319: FND_FILE.PUT_LINE( FND_FILE.LOG, 'Person Id :'||p_person_id||' Admission Application Number :'||p_admission_appl_number);
320: FND_FILE.PUT_LINE( FND_FILE.LOG, 'Course Code :' ||p_course_cd ||' Sequence Number :'||p_sequence_number);
321: FND_MESSAGE.SET_NAME('IGS', 'IGS_AD_APP_CMPLT_STAT_UPD');
322: FND_FILE.PUT_LINE( FND_FILE.LOG, FND_MESSAGE.GET());
323:
324: END IF;

Line 322: FND_FILE.PUT_LINE( FND_FILE.LOG, FND_MESSAGE.GET());

318: -- p_message_name = 'Application completion status for the application updated to SATISFIED';
319: FND_FILE.PUT_LINE( FND_FILE.LOG, 'Person Id :'||p_person_id||' Admission Application Number :'||p_admission_appl_number);
320: FND_FILE.PUT_LINE( FND_FILE.LOG, 'Course Code :' ||p_course_cd ||' Sequence Number :'||p_sequence_number);
321: FND_MESSAGE.SET_NAME('IGS', 'IGS_AD_APP_CMPLT_STAT_UPD');
322: FND_FILE.PUT_LINE( FND_FILE.LOG, FND_MESSAGE.GET());
323:
324: END IF;
325:
326: EXCEPTION

Line 337: fnd_file.put_line( fnd_file.log, 'Error occured while processing the Application instance with Person Id: '||p_person_id||', Admission Application Number: '||p_admission_appl_number||

333: igs_ge_msg_stack.get(l_sc_msg_count, 'T', l_sc_encoded_text, l_sc_msg_index);
334: fnd_message.parse_encoded(l_sc_encoded_text, l_sc_app_short_name, l_sc_message_name);
335: IF l_sc_message_name = 'IGS_SC_POLICY_EXCEPTION' OR l_sc_message_name = 'IGS_SC_POLICY_UPD_DEL_EXCEP' THEN
336: --print the the security exception in log file and return.
337: fnd_file.put_line( fnd_file.log, 'Error occured while processing the Application instance with Person Id: '||p_person_id||', Admission Application Number: '||p_admission_appl_number||
338: ', Course Code: ' ||p_course_cd ||' and Sequence Number: '||p_sequence_number);
339: fnd_message.set_encoded(l_sc_encoded_text);
340: fnd_file.put_line( fnd_file.log, fnd_message.get());
341: fnd_file.put_line( fnd_file.log, ' ');

Line 340: fnd_file.put_line( fnd_file.log, fnd_message.get());

336: --print the the security exception in log file and return.
337: fnd_file.put_line( fnd_file.log, 'Error occured while processing the Application instance with Person Id: '||p_person_id||', Admission Application Number: '||p_admission_appl_number||
338: ', Course Code: ' ||p_course_cd ||' and Sequence Number: '||p_sequence_number);
339: fnd_message.set_encoded(l_sc_encoded_text);
340: fnd_file.put_line( fnd_file.log, fnd_message.get());
341: fnd_file.put_line( fnd_file.log, ' ');
342: RETURN;
343: END IF;
344: l_sc_msg_count := l_sc_msg_count - 1;

Line 341: fnd_file.put_line( fnd_file.log, ' ');

337: fnd_file.put_line( fnd_file.log, 'Error occured while processing the Application instance with Person Id: '||p_person_id||', Admission Application Number: '||p_admission_appl_number||
338: ', Course Code: ' ||p_course_cd ||' and Sequence Number: '||p_sequence_number);
339: fnd_message.set_encoded(l_sc_encoded_text);
340: fnd_file.put_line( fnd_file.log, fnd_message.get());
341: fnd_file.put_line( fnd_file.log, ' ');
342: RETURN;
343: END IF;
344: l_sc_msg_count := l_sc_msg_count - 1;
345: END LOOP;

Line 477: FND_FILE.PUT_LINE( FND_FILE.LOG, FND_MESSAGE.GET());

473: lv_status := 'S'; /*Defaulted to 'S' and the function will return 'F' in case of failure */
474: lv_sql_stmt := igs_pe_dynamic_persid_group.get_dynamic_sql(p_person_id_group,lv_status,lv_group_type);
475: -- Log the Initial parameters into the LOG file.
476: FND_MESSAGE.SET_NAME('IGS', 'IGS_AD_APP_COM_PRMS');
477: FND_FILE.PUT_LINE( FND_FILE.LOG, FND_MESSAGE.GET());
478:
479: FND_MESSAGE.SET_NAME('IGS', 'IGS_AD_APP_LG_PID');
480: FND_MESSAGE.SET_TOKEN('PID', p_person_id);
481: FND_FILE.PUT_LINE( FND_FILE.LOG, FND_MESSAGE.GET());

Line 481: FND_FILE.PUT_LINE( FND_FILE.LOG, FND_MESSAGE.GET());

477: FND_FILE.PUT_LINE( FND_FILE.LOG, FND_MESSAGE.GET());
478:
479: FND_MESSAGE.SET_NAME('IGS', 'IGS_AD_APP_LG_PID');
480: FND_MESSAGE.SET_TOKEN('PID', p_person_id);
481: FND_FILE.PUT_LINE( FND_FILE.LOG, FND_MESSAGE.GET());
482:
483: FND_MESSAGE.SET_NAME('IGS', 'IGS_AD_APP_LG_PID_GRP');
484: FND_MESSAGE.SET_TOKEN('PGPID', p_person_id_group);
485: FND_FILE.PUT_LINE( FND_FILE.LOG, FND_MESSAGE.GET());

Line 485: FND_FILE.PUT_LINE( FND_FILE.LOG, FND_MESSAGE.GET());

481: FND_FILE.PUT_LINE( FND_FILE.LOG, FND_MESSAGE.GET());
482:
483: FND_MESSAGE.SET_NAME('IGS', 'IGS_AD_APP_LG_PID_GRP');
484: FND_MESSAGE.SET_TOKEN('PGPID', p_person_id_group);
485: FND_FILE.PUT_LINE( FND_FILE.LOG, FND_MESSAGE.GET());
486:
487: FND_MESSAGE.SET_NAME('IGS', 'IGS_AD_APP_LG_ADM_APLNO');
488: FND_MESSAGE.SET_TOKEN('APLNO', p_admission_appl_number);
489: FND_FILE.PUT_LINE( FND_FILE.LOG, FND_MESSAGE.GET());

Line 489: FND_FILE.PUT_LINE( FND_FILE.LOG, FND_MESSAGE.GET());

485: FND_FILE.PUT_LINE( FND_FILE.LOG, FND_MESSAGE.GET());
486:
487: FND_MESSAGE.SET_NAME('IGS', 'IGS_AD_APP_LG_ADM_APLNO');
488: FND_MESSAGE.SET_TOKEN('APLNO', p_admission_appl_number);
489: FND_FILE.PUT_LINE( FND_FILE.LOG, FND_MESSAGE.GET());
490:
491: FND_MESSAGE.SET_NAME('IGS', 'IGS_AD_APP_LG_CRCD');
492: FND_MESSAGE.SET_TOKEN('CRCD', p_course_cd);
493: FND_FILE.PUT_LINE( FND_FILE.LOG, FND_MESSAGE.GET());

Line 493: FND_FILE.PUT_LINE( FND_FILE.LOG, FND_MESSAGE.GET());

489: FND_FILE.PUT_LINE( FND_FILE.LOG, FND_MESSAGE.GET());
490:
491: FND_MESSAGE.SET_NAME('IGS', 'IGS_AD_APP_LG_CRCD');
492: FND_MESSAGE.SET_TOKEN('CRCD', p_course_cd);
493: FND_FILE.PUT_LINE( FND_FILE.LOG, FND_MESSAGE.GET());
494:
495: FND_MESSAGE.SET_NAME('IGS', 'IGS_AD_APP_LG_APP_SEQNO');
496: FND_MESSAGE.SET_TOKEN('SEQNO', p_sequence_number);
497: FND_FILE.PUT_LINE( FND_FILE.LOG, FND_MESSAGE.GET());

Line 497: FND_FILE.PUT_LINE( FND_FILE.LOG, FND_MESSAGE.GET());

493: FND_FILE.PUT_LINE( FND_FILE.LOG, FND_MESSAGE.GET());
494:
495: FND_MESSAGE.SET_NAME('IGS', 'IGS_AD_APP_LG_APP_SEQNO');
496: FND_MESSAGE.SET_TOKEN('SEQNO', p_sequence_number);
497: FND_FILE.PUT_LINE( FND_FILE.LOG, FND_MESSAGE.GET());
498:
499: FND_MESSAGE.SET_NAME('IGS', 'IGS_AD_APP_LG_CL_DTLS');
500: FND_MESSAGE.SET_TOKEN('CLDTLS', p_calendar_details);
501: FND_FILE.PUT_LINE( FND_FILE.LOG, FND_MESSAGE.GET());

Line 501: FND_FILE.PUT_LINE( FND_FILE.LOG, FND_MESSAGE.GET());

497: FND_FILE.PUT_LINE( FND_FILE.LOG, FND_MESSAGE.GET());
498:
499: FND_MESSAGE.SET_NAME('IGS', 'IGS_AD_APP_LG_CL_DTLS');
500: FND_MESSAGE.SET_TOKEN('CLDTLS', p_calendar_details);
501: FND_FILE.PUT_LINE( FND_FILE.LOG, FND_MESSAGE.GET());
502:
503: FND_MESSAGE.SET_NAME('IGS', 'IGS_AD_APP_LG_APC');
504: FND_MESSAGE.SET_TOKEN('APC', p_admission_process_category);
505: FND_FILE.PUT_LINE( FND_FILE.LOG, FND_MESSAGE.GET());

Line 505: FND_FILE.PUT_LINE( FND_FILE.LOG, FND_MESSAGE.GET());

501: FND_FILE.PUT_LINE( FND_FILE.LOG, FND_MESSAGE.GET());
502:
503: FND_MESSAGE.SET_NAME('IGS', 'IGS_AD_APP_LG_APC');
504: FND_MESSAGE.SET_TOKEN('APC', p_admission_process_category);
505: FND_FILE.PUT_LINE( FND_FILE.LOG, FND_MESSAGE.GET());
506:
507: -- CASE 1 :
508: -- If the parameters p_person_id, p_admission_appl_number, p_course_cd and p_sequence_number are entered
509: IF p_person_id IS NOT NULL AND

Line 539: FND_FILE.PUT_LINE( FND_FILE.LOG, FND_MESSAGE.GET());

535: IF l_records_not_found THEN
536: -- Tracking steps cannot be completed for applications not having application completion status of pending
537: -- and application outcome status of pending or conditional offer
538: FND_MESSAGE.SET_NAME('IGS', 'IGS_AD_APP_PEND_STAT');
539: FND_FILE.PUT_LINE( FND_FILE.LOG, FND_MESSAGE.GET());
540:
541: -- Abort the process and raise error
542: RETURN;
543:

Line 577: FND_FILE.PUT_LINE( FND_FILE.LOG, FND_MESSAGE.GET());

573: IF l_records_not_found THEN
574: -- Tracking steps cannot be completed for applications not having application completion status of pending
575: -- and application outcome status of pending or conditional offer
576: FND_MESSAGE.SET_NAME('IGS', 'IGS_AD_APP_PEND_STAT');
577: FND_FILE.PUT_LINE( FND_FILE.LOG, FND_MESSAGE.GET());
578:
579: -- Abort the process and raise error
580: RETURN;
581:

Line 676: FND_FILE.PUT_LINE( FND_FILE.LOG, FND_MESSAGE.GET());

672: IF l_records_not_found THEN
673: -- Tracking steps cannot be completed for applications not having application completion status of pending
674: -- and application outcome status of pending or conditional offer
675: FND_MESSAGE.SET_NAME('IGS', 'IGS_AD_APP_PEND_STAT');
676: FND_FILE.PUT_LINE( FND_FILE.LOG, FND_MESSAGE.GET());
677:
678: -- Abort the process and raise error
679: RETURN;
680: END IF;

Line 686: FND_FILE.PUT_LINE (FND_FILE.LOG,FND_MESSAGE.GET);

682: END IF;
683: EXCEPTION
684: WHEN OTHERS THEN
685: FND_MESSAGE.SET_NAME ('IGF','IGF_AP_INVALID_QUERY');
686: FND_FILE.PUT_LINE (FND_FILE.LOG,FND_MESSAGE.GET);
687: FND_FILE.PUT_LINE (FND_FILE.LOG,lv_sql_stmt);
688: END;
689:
690: ELSE

Line 687: FND_FILE.PUT_LINE (FND_FILE.LOG,lv_sql_stmt);

683: EXCEPTION
684: WHEN OTHERS THEN
685: FND_MESSAGE.SET_NAME ('IGF','IGF_AP_INVALID_QUERY');
686: FND_FILE.PUT_LINE (FND_FILE.LOG,FND_MESSAGE.GET);
687: FND_FILE.PUT_LINE (FND_FILE.LOG,lv_sql_stmt);
688: END;
689:
690: ELSE
691: FND_MESSAGE.SET_NAME ('IGS',' IGS_AZ_DYN_PERS_ID_GRP_ERR');

Line 692: FND_FILE.PUT_LINE (FND_FILE.LOG,FND_MESSAGE.GET);

688: END;
689:
690: ELSE
691: FND_MESSAGE.SET_NAME ('IGS',' IGS_AZ_DYN_PERS_ID_GRP_ERR');
692: FND_FILE.PUT_LINE (FND_FILE.LOG,FND_MESSAGE.GET);
693: END IF;
694:
695: -- CASE 4 :
696: -- In case the academic calendar, admission process category and admission calendar are

Line 740: FND_FILE.PUT_LINE( FND_FILE.LOG, FND_MESSAGE.GET());

736: IF l_records_not_found THEN
737: -- Tracking steps cannot be completed for applications not having application completion status of pending
738: -- and application outcome status of pending or conditional offer
739: FND_MESSAGE.SET_NAME('IGS', 'IGS_AD_APP_PEND_STAT');
740: FND_FILE.PUT_LINE( FND_FILE.LOG, FND_MESSAGE.GET());
741:
742: -- Abort the process and raise error
743: RETURN;
744:

Line 760: FND_FILE.PUT_LINE( FND_FILE.LOG, FND_MESSAGE.GET());

756: THEN
757:
758: -- Message ( 'All the parameters are null. The process cannot be run')
759: FND_MESSAGE.SET_NAME('IGS', 'IGS_AD_APP_ALL_PRM_NULL');
760: FND_FILE.PUT_LINE( FND_FILE.LOG, FND_MESSAGE.GET());
761: RETURN;
762:
763: -- CASE 6 :
764: -- In case if the parameters are not in proper combination.

Line 770: FND_FILE.PUT_LINE( FND_FILE.LOG, FND_MESSAGE.GET());

766: ELSE
767: -- 'Invalid parameters entered. Valid combinations for parameters to be entered is Person ID OR Person Group ID OR Person ID,
768: -- Admission Application Number, Program Code, Sequence Number OR Academic Calendar, Admission Calendar, Admission Process Category'
769: FND_MESSAGE.SET_NAME('IGS', 'IGS_AD_APP_INV_PRM_COMB');
770: FND_FILE.PUT_LINE( FND_FILE.LOG, FND_MESSAGE.GET());
771: RETURN;
772:
773: END IF;
774: