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

Line 622: FND_FILE.PUT_LINE(FND_FILE.LOG,'Person ID Group :' || p_person_id_group);

618:
619: OPEN c_get_adm_process_type(l_s_adm_process_typ);
620: FETCH c_get_adm_process_type INTO l_get_adm_process_type;
621: CLOSE c_get_adm_process_type;
622: FND_FILE.PUT_LINE(FND_FILE.LOG,'Person ID Group :' || p_person_id_group);
623:
624: IF (l_acad_alternate_code IS NOT NULL AND l_adm_alternate_code IS NOT NULL) THEN
625: FND_FILE.PUT_LINE(FND_FILE.LOG,'Calendar Details :' || l_acad_alternate_code || '/' || l_adm_alternate_code);
626: ELSE

Line 625: FND_FILE.PUT_LINE(FND_FILE.LOG,'Calendar Details :' || l_acad_alternate_code || '/' || l_adm_alternate_code);

621: CLOSE c_get_adm_process_type;
622: FND_FILE.PUT_LINE(FND_FILE.LOG,'Person ID Group :' || p_person_id_group);
623:
624: IF (l_acad_alternate_code IS NOT NULL AND l_adm_alternate_code IS NOT NULL) THEN
625: FND_FILE.PUT_LINE(FND_FILE.LOG,'Calendar Details :' || l_acad_alternate_code || '/' || l_adm_alternate_code);
626: ELSE
627: FND_FILE.PUT_LINE(FND_FILE.LOG,'Calendar Details :' );
628: END IF;
629:

Line 627: FND_FILE.PUT_LINE(FND_FILE.LOG,'Calendar Details :' );

623:
624: IF (l_acad_alternate_code IS NOT NULL AND l_adm_alternate_code IS NOT NULL) THEN
625: FND_FILE.PUT_LINE(FND_FILE.LOG,'Calendar Details :' || l_acad_alternate_code || '/' || l_adm_alternate_code);
626: ELSE
627: FND_FILE.PUT_LINE(FND_FILE.LOG,'Calendar Details :' );
628: END IF;
629:
630: IF l_get_adm_process_type IS NOT NULL THEN
631: FND_FILE.PUT_LINE(FND_FILE.LOG,'Application Type :' || p_application_type);

Line 631: FND_FILE.PUT_LINE(FND_FILE.LOG,'Application Type :' || p_application_type);

627: FND_FILE.PUT_LINE(FND_FILE.LOG,'Calendar Details :' );
628: END IF;
629:
630: IF l_get_adm_process_type IS NOT NULL THEN
631: FND_FILE.PUT_LINE(FND_FILE.LOG,'Application Type :' || p_application_type);
632: ELSE
633: FND_FILE.PUT_LINE(FND_FILE.LOG,'Application Type :' );
634: END IF;
635:

Line 633: FND_FILE.PUT_LINE(FND_FILE.LOG,'Application Type :' );

629:
630: IF l_get_adm_process_type IS NOT NULL THEN
631: FND_FILE.PUT_LINE(FND_FILE.LOG,'Application Type :' || p_application_type);
632: ELSE
633: FND_FILE.PUT_LINE(FND_FILE.LOG,'Application Type :' );
634: END IF;
635:
636: FND_FILE.PUT_LINE(FND_FILE.LOG,'' );
637: FND_FILE.PUT_LINE(FND_FILE.LOG,'Application Program Information :' );

Line 636: FND_FILE.PUT_LINE(FND_FILE.LOG,'' );

632: ELSE
633: FND_FILE.PUT_LINE(FND_FILE.LOG,'Application Type :' );
634: END IF;
635:
636: FND_FILE.PUT_LINE(FND_FILE.LOG,'' );
637: FND_FILE.PUT_LINE(FND_FILE.LOG,'Application Program Information :' );
638:
639: OPEN c_admission_type(p_application_type);
640: FETCH c_admission_type INTO l_admission_type;

Line 637: FND_FILE.PUT_LINE(FND_FILE.LOG,'Application Program Information :' );

633: FND_FILE.PUT_LINE(FND_FILE.LOG,'Application Type :' );
634: END IF;
635:
636: FND_FILE.PUT_LINE(FND_FILE.LOG,'' );
637: FND_FILE.PUT_LINE(FND_FILE.LOG,'Application Program Information :' );
638:
639: OPEN c_admission_type(p_application_type);
640: FETCH c_admission_type INTO l_admission_type;
641: CLOSE c_admission_type;

Line 704: FND_FILE.PUT_LINE(FND_FILE.LOG,' Person Number: ' || RPAD(get_person_number(l_get_ad_ps_appl_rec.person_id),15,' ') || ' Application ID: ' ||

700: FOR l_get_inst_dtls_rec IN c_get_inst_dtls(l_get_ad_ps_appl_rec.person_id,
701: l_get_ad_ps_appl_rec.admission_appl_number,
702: l_get_ad_ps_appl_rec.nominated_course_cd) LOOP
703:
704: FND_FILE.PUT_LINE(FND_FILE.LOG,' Person Number: ' || RPAD(get_person_number(l_get_ad_ps_appl_rec.person_id),15,' ') || ' Application ID: ' ||
705: RPAD(l_get_application_id,15,' ') || ' Program: ' || RPAD(l_get_ad_ps_appl_rec.nominated_course_cd,6,' ')
706: || 'Sequence Number: ' || RPAD(l_get_inst_dtls_rec.sequence_number,6,' '));
707:
708: l_record_failed := 'N';

Line 889: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Cancel Reconsideration Failed: ' || v_message_name);

885: l_get_inst_dtls_rec.Sequence_Number,
886: 'Y', -- Confirm course indicator.
887: 'Y', -- Perform eligibility check indicator.
888: v_message_name) = FALSE THEN
889: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Cancel Reconsideration Failed: ' || v_message_name);
890: l_record_failed := 'Y';
891: ROLLBACK TO c_create_prog;
892: END IF;
893: ELSIF (igs_ad_gen_008.admp_get_saos(l_get_pending_hist_rec.ADM_OUTCOME_STATUS)) IN ('COND-OFFER', 'OFFER') AND l_apcs = 'Y' THEN

Line 901: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Cancel Reconsideration Failed: ' || v_message_name);

897: l_get_inst_dtls_rec.Sequence_Number,
898: 'N', -- Confirm course indicator.
899: 'N', -- Perform eligibility check indicator.
900: v_message_name) = FALSE THEN
901: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Cancel Reconsideration Failed: ' || v_message_name);
902: l_record_failed := 'Y';
903: ROLLBACK TO c_create_prog;
904: END IF;
905: END IF;

Line 919: FND_FILE.PUT_LINE(FND_FILE.LOG,' Cancelled Reconsideration Request.' );

915: l_get_ad_ps_appl_rec.admission_appl_number,
916: l_get_ad_ps_appl_rec.nominated_course_cd
917: );
918:
919: FND_FILE.PUT_LINE(FND_FILE.LOG,' Cancelled Reconsideration Request.' );
920:
921: END IF;
922:
923: EXCEPTION

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

932: END IF;
933:
934: ROLLBACK TO c_create_prog;
935:
936: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);
937:
938: l_record_errored := 'Y';
939:
940: END;

Line 973: FND_FILE.PUT_LINE(FND_FILE.LOG,' Person Number: ' || RPAD(get_person_number(l_get_fut_appl_inst.PERSON_ID),15,' ') || ' Application ID: ' ||

969: OPEN c_get_application_id(l_get_fut_appl_inst.PERSON_ID,l_get_fut_appl_inst.ADMISSION_APPL_NUMBER);
970: FETCH c_get_application_id INTO l_get_application_id;
971: CLOSE c_get_application_id;
972:
973: FND_FILE.PUT_LINE(FND_FILE.LOG,' Person Number: ' || RPAD(get_person_number(l_get_fut_appl_inst.PERSON_ID),15,' ') || ' Application ID: ' ||
974: RPAD(l_get_application_id,15,' ') || ' Program: ' || RPAD(l_get_fut_appl_inst.NOMINATED_COURSE_CD,6,' ')
975: || 'Sequence Number: ' || RPAD(l_get_fut_appl_inst.SEQUENCE_NUMBER,6,' '));
976: l_get_application_id := NULL;
977: /* End Apadegal - 4747281 */

Line 1112: FND_FILE.PUT_LINE(FND_FILE.LOG,' Cancelled Reconsideration Request.' );

1108: x_appl_inst_status => l_get_fut_appl_inst.appl_inst_status,
1109: x_ais_reason => l_get_fut_appl_inst.ais_reason,
1110: x_decline_ofr_reason => l_get_fut_appl_inst.decline_ofr_reason);
1111:
1112: FND_FILE.PUT_LINE(FND_FILE.LOG,' Cancelled Reconsideration Request.' );
1113:
1114: EXCEPTION
1115: WHEN OTHERS THEN
1116:

Line 1119: FND_FILE.PUT_LINE(FND_FILE.LOG,'Cancel Reconsideration Failed: ' || FND_MESSAGE.GET);

1115: WHEN OTHERS THEN
1116:
1117: ROLLBACK TO c_update_inst;
1118:
1119: FND_FILE.PUT_LINE(FND_FILE.LOG,'Cancel Reconsideration Failed: ' || FND_MESSAGE.GET);
1120:
1121: l_record_errored := 'Y';
1122:
1123: END;

Line 1225: FND_FILE.PUT_LINE(FND_FILE.LOG,' Person Number: ' || RPAD( get_person_number(l_get_ad_ps_appl_rec.person_id),15,' ') || ' Application ID: ' ||

1221: FOR l_get_inst_dtls_rec IN c_get_inst_dtls(c_dyn_pig_check_rec.person_id,
1222: c_dyn_pig_check_rec.admission_appl_number,
1223: c_dyn_pig_check_rec.nominated_course_cd) LOOP
1224:
1225: FND_FILE.PUT_LINE(FND_FILE.LOG,' Person Number: ' || RPAD( get_person_number(l_get_ad_ps_appl_rec.person_id),15,' ') || ' Application ID: ' ||
1226: RPAD(l_get_application_id,15,' ') || ' Program: ' || RPAD(l_get_ad_ps_appl_rec.nominated_course_cd,6,' ')
1227: || 'Sequence Number: ' || RPAD(l_get_inst_dtls_rec.sequence_number,6,' '));
1228:
1229: l_record_failed := 'N';

Line 1410: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Cancel Reconsideration Failed: ' || v_message_name);

1406: l_get_inst_dtls_rec.Sequence_Number,
1407: 'Y', -- Confirm course indicator.
1408: 'Y', -- Perform eligibility check indicator.
1409: v_message_name) = FALSE THEN
1410: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Cancel Reconsideration Failed: ' || v_message_name);
1411: l_record_failed := 'Y';
1412: ROLLBACK TO c_create_prog;
1413: END IF;
1414: END IF;

Line 1425: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Cancel Reconsideration Failed: ' || v_message_name);

1421: l_get_inst_dtls_rec.Sequence_Number,
1422: 'N', -- Confirm course indicator.
1423: 'N', -- Perform eligibility check indicator.
1424: v_message_name) = FALSE THEN
1425: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Cancel Reconsideration Failed: ' || v_message_name);
1426: l_record_failed := 'Y';
1427: ROLLBACK TO c_create_prog;
1428: END IF;
1429: END IF;

Line 1440: FND_FILE.PUT_LINE(FND_FILE.LOG,' Cancelled Reconsideration Request.' );

1436: igs_ad_gen_002.ins_dummy_pend_hist_rec ( c_dyn_pig_check_rec.person_id,
1437: c_dyn_pig_check_rec.admission_appl_number,
1438: c_dyn_pig_check_rec.nominated_course_cd
1439: );
1440: FND_FILE.PUT_LINE(FND_FILE.LOG,' Cancelled Reconsideration Request.' );
1441: END IF;
1442:
1443: EXCEPTION
1444: WHEN OTHERS THEN

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

1451: CLOSE c_get_pending_hist;
1452: END IF;
1453: ROLLBACK TO c_create_prog;
1454:
1455: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);
1456:
1457: l_record_errored := 'Y';
1458:
1459: END;

Line 1533: FND_FILE.PUT_LINE(FND_FILE.LOG,' Person Number: ' || RPAD(get_person_number(c_pend_fut_rec.PERSON_ID),15,' ') || ' Application ID: ' ||

1529: OPEN c_get_application_id(c_pend_fut_rec.PERSON_ID,c_pend_fut_rec.ADMISSION_APPL_NUMBER);
1530: FETCH c_get_application_id INTO l_get_application_id;
1531: CLOSE c_get_application_id;
1532:
1533: FND_FILE.PUT_LINE(FND_FILE.LOG,' Person Number: ' || RPAD(get_person_number(c_pend_fut_rec.PERSON_ID),15,' ') || ' Application ID: ' ||
1534: RPAD(l_get_application_id,15,' ') || ' Program: ' || RPAD(c_pend_fut_rec.NOMINATED_COURSE_CD,6,' ')
1535: || 'Sequence Number: ' || RPAD(c_pend_fut_rec.SEQUENCE_NUMBER,6,' '));
1536: l_get_application_id := NULL;
1537: /* End Apadegal - 4747281 */

Line 1670: FND_FILE.PUT_LINE(FND_FILE.LOG,' Cancelled Reconsideration Request.' ); -- 4747281

1666: x_def_appl_sequence_num => c_pend_fut_rec.def_appl_sequence_num,
1667: x_appl_inst_status => c_pend_fut_rec.appl_inst_status,
1668: x_ais_reason => c_pend_fut_rec.ais_reason,
1669: x_decline_ofr_reason => c_pend_fut_rec.decline_ofr_reason);
1670: FND_FILE.PUT_LINE(FND_FILE.LOG,' Cancelled Reconsideration Request.' ); -- 4747281
1671: EXCEPTION
1672:
1673: WHEN OTHERS THEN
1674:

Line 1677: FND_FILE.PUT_LINE(FND_FILE.LOG,'Cancel Reconsideration Failed: ' || FND_MESSAGE.GET);

1673: WHEN OTHERS THEN
1674:
1675: ROLLBACK TO c_update_inst;
1676:
1677: FND_FILE.PUT_LINE(FND_FILE.LOG,'Cancel Reconsideration Failed: ' || FND_MESSAGE.GET);
1678:
1679: l_record_errored := 'Y';
1680:
1681: END;

Line 1691: FND_FILE.PUT_LINE(FND_FILE.LOG,' No Application Instance Matching The Given Criteria Is Found.' );

1687:
1688: END IF;
1689: -- if none of the application programs are processed then give the appropiate log message
1690: IF l_processing_ind = 'N' THEN
1691: FND_FILE.PUT_LINE(FND_FILE.LOG,' No Application Instance Matching The Given Criteria Is Found.' );
1692: -- if the cancel reconsideration job fails for any of the application programs then give the appropiate log message.
1693: ELSIF l_record_errored = 'Y' THEN
1694: FND_FILE.PUT_LINE(FND_FILE.LOG,' For Some Application Instance Cancel Reconsideration Job Failed.' );
1695: END IF;

Line 1694: FND_FILE.PUT_LINE(FND_FILE.LOG,' For Some Application Instance Cancel Reconsideration Job Failed.' );

1690: IF l_processing_ind = 'N' THEN
1691: FND_FILE.PUT_LINE(FND_FILE.LOG,' No Application Instance Matching The Given Criteria Is Found.' );
1692: -- if the cancel reconsideration job fails for any of the application programs then give the appropiate log message.
1693: ELSIF l_record_errored = 'Y' THEN
1694: FND_FILE.PUT_LINE(FND_FILE.LOG,' For Some Application Instance Cancel Reconsideration Job Failed.' );
1695: END IF;
1696:
1697: EXCEPTION
1698: WHEN OTHERS THEN

Line 1699: FND_FILE.PUT_LINE(FND_FILE.LOG, sqlerrm);

1695: END IF;
1696:
1697: EXCEPTION
1698: WHEN OTHERS THEN
1699: FND_FILE.PUT_LINE(FND_FILE.LOG, sqlerrm);
1700: retcode:=2;
1701: errbuf := FND_MESSAGE.GET_STRING('IGS','IGS_GE_UNHANDLED_EXCEPTION');
1702: igs_ge_msg_stack.conc_exception_hndl;
1703: END cancel_reconsider_appl;