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

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

150: FETCH c_appl_revprof_group_cd INTO c_appl_revprof_group_cd_rec;
151: CLOSE c_appl_revprof_group_cd;
152:
153: -- Write the Profile Name to the log file
154: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
155: FND_FILE.PUT_LINE(FND_FILE.LOG,LPAD(FND_MESSAGE.GET_STRING('IGS',
156: 'IGS_AD_APPL_PROF_NAME_PROC'),'27',' ')
157: ||' '|| c_appl_revprof_group_cd_rec.review_profile_name);
158: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');

Line 155: FND_FILE.PUT_LINE(FND_FILE.LOG,LPAD(FND_MESSAGE.GET_STRING('IGS',

151: CLOSE c_appl_revprof_group_cd;
152:
153: -- Write the Profile Name to the log file
154: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
155: FND_FILE.PUT_LINE(FND_FILE.LOG,LPAD(FND_MESSAGE.GET_STRING('IGS',
156: 'IGS_AD_APPL_PROF_NAME_PROC'),'27',' ')
157: ||' '|| c_appl_revprof_group_cd_rec.review_profile_name);
158: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
159:

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

154: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
155: FND_FILE.PUT_LINE(FND_FILE.LOG,LPAD(FND_MESSAGE.GET_STRING('IGS',
156: 'IGS_AD_APPL_PROF_NAME_PROC'),'27',' ')
157: ||' '|| c_appl_revprof_group_cd_rec.review_profile_name);
158: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
159:
160: -- Write the Calander Details to the log file
161: FND_MESSAGE.SET_NAME('IGS', 'IGS_AD_APP_LG_CL_DTLS');
162: FND_MESSAGE.SET_TOKEN('CLDTLS', p_calendar_details);

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

159:
160: -- Write the Calander Details to the log file
161: FND_MESSAGE.SET_NAME('IGS', 'IGS_AD_APP_LG_CL_DTLS');
162: FND_MESSAGE.SET_TOKEN('CLDTLS', p_calendar_details);
163: FND_FILE.PUT_LINE( FND_FILE.LOG, FND_MESSAGE.GET());
164:
165: -- Write the Admission Process Cagtegory Details to the log file
166: FND_MESSAGE.SET_NAME('IGS', 'IGS_AD_APP_LG_APC');
167: FND_MESSAGE.SET_TOKEN('APC', p_admission_process_category);

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

164:
165: -- Write the Admission Process Cagtegory Details to the log file
166: FND_MESSAGE.SET_NAME('IGS', 'IGS_AD_APP_LG_APC');
167: FND_MESSAGE.SET_TOKEN('APC', p_admission_process_category);
168: FND_FILE.PUT_LINE( FND_FILE.LOG, FND_MESSAGE.GET());
169:
170: IF p_admission_process_category IS NULL THEN
171: l_admission_cat := NULL;
172: l_s_admission_process_type := NULL;

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

181: -- particular Review Profile Id
182: FOR c_appl_revprof_revgr_rec IN c_appl_revprof_revgr(p_appl_rev_profile_id) LOOP
183:
184: -- Write the Group Code to the log file
185: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
186: FND_FILE.PUT_LINE(FND_FILE.LOG,LPAD(FND_MESSAGE.GET_STRING('IGS',
187: 'IGS_AD_APPL_GRP_CD_PROC'),'27',' ') ||
188: ' '||c_appl_revprof_revgr_rec.revprof_revgr_name);
189: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');

Line 186: FND_FILE.PUT_LINE(FND_FILE.LOG,LPAD(FND_MESSAGE.GET_STRING('IGS',

182: FOR c_appl_revprof_revgr_rec IN c_appl_revprof_revgr(p_appl_rev_profile_id) LOOP
183:
184: -- Write the Group Code to the log file
185: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
186: FND_FILE.PUT_LINE(FND_FILE.LOG,LPAD(FND_MESSAGE.GET_STRING('IGS',
187: 'IGS_AD_APPL_GRP_CD_PROC'),'27',' ') ||
188: ' '||c_appl_revprof_revgr_rec.revprof_revgr_name);
189: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
190: FND_FILE.PUT_LINE(FND_FILE.LOG,LPAD(FND_MESSAGE.GET_STRING('IGS',

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

185: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
186: FND_FILE.PUT_LINE(FND_FILE.LOG,LPAD(FND_MESSAGE.GET_STRING('IGS',
187: 'IGS_AD_APPL_GRP_CD_PROC'),'27',' ') ||
188: ' '||c_appl_revprof_revgr_rec.revprof_revgr_name);
189: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
190: FND_FILE.PUT_LINE(FND_FILE.LOG,LPAD(FND_MESSAGE.GET_STRING('IGS',
191: 'IGS_AD_PERSON_ID'),'20',' ')||LPAD(FND_MESSAGE.GET_STRING('IGS',
192: 'IGS_AD_APPL_NO'),'20',' ')
193: ||LPAD(FND_MESSAGE.GET_STRING('IGS','IGS_AD_CRS_CD'),'20',' ')||

Line 190: FND_FILE.PUT_LINE(FND_FILE.LOG,LPAD(FND_MESSAGE.GET_STRING('IGS',

186: FND_FILE.PUT_LINE(FND_FILE.LOG,LPAD(FND_MESSAGE.GET_STRING('IGS',
187: 'IGS_AD_APPL_GRP_CD_PROC'),'27',' ') ||
188: ' '||c_appl_revprof_revgr_rec.revprof_revgr_name);
189: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
190: FND_FILE.PUT_LINE(FND_FILE.LOG,LPAD(FND_MESSAGE.GET_STRING('IGS',
191: 'IGS_AD_PERSON_ID'),'20',' ')||LPAD(FND_MESSAGE.GET_STRING('IGS',
192: 'IGS_AD_APPL_NO'),'20',' ')
193: ||LPAD(FND_MESSAGE.GET_STRING('IGS','IGS_AD_CRS_CD'),'20',' ')||
194: LPAD(FND_MESSAGE.GET_STRING('IGS','IGS_AD_SEQ_NUM'),'20',' '));

Line 433: FND_FILE.PUT_LINE(FND_FILE.LOG,LPAD(IGS_GE_NUMBER.TO_CANN(l_person_id),'20',' ')||

429: x_mode => 'R');
430:
431: -- Write the Application Instance which got Assigned to a
432: -- Particular Review Code to the Log file
433: FND_FILE.PUT_LINE(FND_FILE.LOG,LPAD(IGS_GE_NUMBER.TO_CANN(l_person_id),'20',' ')||
434: LPAD(IGS_GE_NUMBER.TO_CANN(l_admission_appl_number),'20',' ')||
435: LPAD(l_nominated_course_cd,'15',' ')||
436: LPAD(IGS_GE_NUMBER.TO_CANN(l_sequence_number),'20',' '));
437: ELSIF c_arp_rec_found_rec.appl_revprof_revgr_id IS NULL THEN

Line 452: FND_FILE.PUT_LINE(FND_FILE.LOG,LPAD(IGS_GE_NUMBER.TO_CANN(c_arp_rec_found_rec.person_id),'20',' ')||

448: x_mode => 'R');
449:
450: -- Write the Application Instance which got Assigned to a
451: --Particular Review Code to the Log file
452: FND_FILE.PUT_LINE(FND_FILE.LOG,LPAD(IGS_GE_NUMBER.TO_CANN(c_arp_rec_found_rec.person_id),'20',' ')||
453: LPAD(IGS_GE_NUMBER.TO_CANN(c_arp_rec_found_rec.admission_appl_number),'20',' ')||
454: LPAD(c_arp_rec_found_rec.nominated_course_cd,'20',' ')||
455: LPAD(IGS_GE_NUMBER.TO_CANN(c_arp_rec_found_rec.sequence_number),'20',' '));
456: END IF;

Line 466: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET_STRING('IGS','IGS_AD_NO_REC_FOUND'));

462:
463: -- No include or exclude Records for this Group Code
464: ELSE
465: CLOSE c_revgr_incl_excl;
466: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET_STRING('IGS','IGS_AD_NO_REC_FOUND'));
467: END IF;
468: -- Loop through the next Review Group Code for the Profile ID
469: END LOOP;
470:

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

476: -- Check if the Review Group Code is Geographical by Insitution Address
477: ELSIF c_appl_revprof_group_cd_rec.appl_rev_profile_gr_cd = 'GEO_BY_INSTITUTION_ADDR' THEN
478: FOR c_appl_revprof_revgr_rec IN c_appl_revprof_revgr(p_appl_rev_profile_id) LOOP
479: -- Write the Group Code to the log file
480: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
481: FND_FILE.PUT_LINE(FND_FILE.LOG,LPAD(FND_MESSAGE.GET_STRING('IGS','IGS_AD_APPL_GRP_CD_PROC'),'27',' ') ||
482: ' ' ||c_appl_revprof_revgr_rec.revprof_revgr_name);
483: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
484: FND_FILE.PUT_LINE(FND_FILE.LOG,LPAD(FND_MESSAGE.GET_STRING('IGS','IGS_AD_PERSON_ID'),'20',' ')||

Line 481: FND_FILE.PUT_LINE(FND_FILE.LOG,LPAD(FND_MESSAGE.GET_STRING('IGS','IGS_AD_APPL_GRP_CD_PROC'),'27',' ') ||

477: ELSIF c_appl_revprof_group_cd_rec.appl_rev_profile_gr_cd = 'GEO_BY_INSTITUTION_ADDR' THEN
478: FOR c_appl_revprof_revgr_rec IN c_appl_revprof_revgr(p_appl_rev_profile_id) LOOP
479: -- Write the Group Code to the log file
480: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
481: FND_FILE.PUT_LINE(FND_FILE.LOG,LPAD(FND_MESSAGE.GET_STRING('IGS','IGS_AD_APPL_GRP_CD_PROC'),'27',' ') ||
482: ' ' ||c_appl_revprof_revgr_rec.revprof_revgr_name);
483: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
484: FND_FILE.PUT_LINE(FND_FILE.LOG,LPAD(FND_MESSAGE.GET_STRING('IGS','IGS_AD_PERSON_ID'),'20',' ')||
485: LPAD(FND_MESSAGE.GET_STRING('IGS','IGS_AD_APPL_NO'),'20',' ')

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

479: -- Write the Group Code to the log file
480: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
481: FND_FILE.PUT_LINE(FND_FILE.LOG,LPAD(FND_MESSAGE.GET_STRING('IGS','IGS_AD_APPL_GRP_CD_PROC'),'27',' ') ||
482: ' ' ||c_appl_revprof_revgr_rec.revprof_revgr_name);
483: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
484: FND_FILE.PUT_LINE(FND_FILE.LOG,LPAD(FND_MESSAGE.GET_STRING('IGS','IGS_AD_PERSON_ID'),'20',' ')||
485: LPAD(FND_MESSAGE.GET_STRING('IGS','IGS_AD_APPL_NO'),'20',' ')
486: ||LPAD(FND_MESSAGE.GET_STRING('IGS','IGS_AD_CRS_CD'),'20',' ')||
487: LPAD(FND_MESSAGE.GET_STRING('IGS','IGS_AD_SEQ_NUM'),'20',' '));

Line 484: FND_FILE.PUT_LINE(FND_FILE.LOG,LPAD(FND_MESSAGE.GET_STRING('IGS','IGS_AD_PERSON_ID'),'20',' ')||

480: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
481: FND_FILE.PUT_LINE(FND_FILE.LOG,LPAD(FND_MESSAGE.GET_STRING('IGS','IGS_AD_APPL_GRP_CD_PROC'),'27',' ') ||
482: ' ' ||c_appl_revprof_revgr_rec.revprof_revgr_name);
483: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
484: FND_FILE.PUT_LINE(FND_FILE.LOG,LPAD(FND_MESSAGE.GET_STRING('IGS','IGS_AD_PERSON_ID'),'20',' ')||
485: LPAD(FND_MESSAGE.GET_STRING('IGS','IGS_AD_APPL_NO'),'20',' ')
486: ||LPAD(FND_MESSAGE.GET_STRING('IGS','IGS_AD_CRS_CD'),'20',' ')||
487: LPAD(FND_MESSAGE.GET_STRING('IGS','IGS_AD_SEQ_NUM'),'20',' '));
488:

Line 804: FND_FILE.PUT_LINE(FND_FILE.LOG,LPAD(IGS_GE_NUMBER.TO_CANN(l_person_id),'20',' ')||

800: x_mode => 'R');
801:
802: -- Write the Application Instance
803: --which got Assigned to a Particular Review Code to the Log file
804: FND_FILE.PUT_LINE(FND_FILE.LOG,LPAD(IGS_GE_NUMBER.TO_CANN(l_person_id),'20',' ')||
805: LPAD(IGS_GE_NUMBER.TO_CANN(l_admission_appl_number),'20',' ')||
806: LPAD(l_nominated_course_cd,'15',' ')||
807: LPAD(IGS_GE_NUMBER.TO_CANN(l_sequence_number),'20',' '));
808:

Line 824: FND_FILE.PUT_LINE(FND_FILE.LOG,LPAD(IGS_GE_NUMBER.TO_CANN(c_arp_rec_found_rec.person_id),'20',' ')||

820: x_mode => 'R');
821:
822: -- Write the Application Instance which got Assigned to a
823: -- Particular Review Code to the Log file
824: FND_FILE.PUT_LINE(FND_FILE.LOG,LPAD(IGS_GE_NUMBER.TO_CANN(c_arp_rec_found_rec.person_id),'20',' ')||
825: LPAD(IGS_GE_NUMBER.TO_CANN(c_arp_rec_found_rec.admission_appl_number),'20',' ')||
826: LPAD(c_arp_rec_found_rec.nominated_course_cd,'20',' ')||
827: LPAD(IGS_GE_NUMBER.TO_CANN(c_arp_rec_found_rec.sequence_number),'20',' '));
828:

Line 837: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET_STRING('IGS','IGS_AD_NO_REC_FOUND'));

833:
834: -- No include or exclude Records for this Group Code
835: ELSE
836: CLOSE c_revgr_addr;
837: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET_STRING('IGS','IGS_AD_NO_REC_FOUND'));
838: END IF;
839: -- Loop through the next Review Group Code for the Profile ID
840: END LOOP;
841:

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

848: -- Check if the Review Group Code is Geographical by Applicant Address
849: ELSIF c_appl_revprof_group_cd_rec.appl_rev_profile_gr_cd = 'GEO_BY_APPLICANT_ADDR' THEN
850: FOR c_appl_revprof_revgr_rec IN c_appl_revprof_revgr(p_appl_rev_profile_id) LOOP
851: -- Write the Group Code to the log file
852: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
853: FND_FILE.PUT_LINE(FND_FILE.LOG,LPAD(FND_MESSAGE.GET_STRING('IGS','IGS_AD_APPL_GRP_CD_PROC'),'27',' ')
854: ||' '||c_appl_revprof_revgr_rec.revprof_revgr_name);
855: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
856: FND_FILE.PUT_LINE(FND_FILE.LOG,LPAD(FND_MESSAGE.GET_STRING('IGS','IGS_AD_PERSON_ID'),'20',' ')||

Line 853: FND_FILE.PUT_LINE(FND_FILE.LOG,LPAD(FND_MESSAGE.GET_STRING('IGS','IGS_AD_APPL_GRP_CD_PROC'),'27',' ')

849: ELSIF c_appl_revprof_group_cd_rec.appl_rev_profile_gr_cd = 'GEO_BY_APPLICANT_ADDR' THEN
850: FOR c_appl_revprof_revgr_rec IN c_appl_revprof_revgr(p_appl_rev_profile_id) LOOP
851: -- Write the Group Code to the log file
852: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
853: FND_FILE.PUT_LINE(FND_FILE.LOG,LPAD(FND_MESSAGE.GET_STRING('IGS','IGS_AD_APPL_GRP_CD_PROC'),'27',' ')
854: ||' '||c_appl_revprof_revgr_rec.revprof_revgr_name);
855: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
856: FND_FILE.PUT_LINE(FND_FILE.LOG,LPAD(FND_MESSAGE.GET_STRING('IGS','IGS_AD_PERSON_ID'),'20',' ')||
857: LPAD(FND_MESSAGE.GET_STRING('IGS','IGS_AD_APPL_NO'),'20',' ')||

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

851: -- Write the Group Code to the log file
852: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
853: FND_FILE.PUT_LINE(FND_FILE.LOG,LPAD(FND_MESSAGE.GET_STRING('IGS','IGS_AD_APPL_GRP_CD_PROC'),'27',' ')
854: ||' '||c_appl_revprof_revgr_rec.revprof_revgr_name);
855: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
856: FND_FILE.PUT_LINE(FND_FILE.LOG,LPAD(FND_MESSAGE.GET_STRING('IGS','IGS_AD_PERSON_ID'),'20',' ')||
857: LPAD(FND_MESSAGE.GET_STRING('IGS','IGS_AD_APPL_NO'),'20',' ')||
858: LPAD(FND_MESSAGE.GET_STRING('IGS','IGS_AD_CRS_CD'),'20',' ')||
859: LPAD(FND_MESSAGE.GET_STRING('IGS','IGS_AD_SEQ_NUM'),'20',' '));

Line 856: FND_FILE.PUT_LINE(FND_FILE.LOG,LPAD(FND_MESSAGE.GET_STRING('IGS','IGS_AD_PERSON_ID'),'20',' ')||

852: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
853: FND_FILE.PUT_LINE(FND_FILE.LOG,LPAD(FND_MESSAGE.GET_STRING('IGS','IGS_AD_APPL_GRP_CD_PROC'),'27',' ')
854: ||' '||c_appl_revprof_revgr_rec.revprof_revgr_name);
855: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
856: FND_FILE.PUT_LINE(FND_FILE.LOG,LPAD(FND_MESSAGE.GET_STRING('IGS','IGS_AD_PERSON_ID'),'20',' ')||
857: LPAD(FND_MESSAGE.GET_STRING('IGS','IGS_AD_APPL_NO'),'20',' ')||
858: LPAD(FND_MESSAGE.GET_STRING('IGS','IGS_AD_CRS_CD'),'20',' ')||
859: LPAD(FND_MESSAGE.GET_STRING('IGS','IGS_AD_SEQ_NUM'),'20',' '));
860: l_cur_statement := NULL;

Line 1176: FND_FILE.PUT_LINE(FND_FILE.LOG,

1172: x_mode => 'R');
1173:
1174: -- Write the Application Instance which got
1175: --Assigned to a Particular Review Code to the Log file
1176: FND_FILE.PUT_LINE(FND_FILE.LOG,
1177: LPAD(IGS_GE_NUMBER.TO_CANN(l_person_id),'20',' ')||
1178: LPAD(IGS_GE_NUMBER.TO_CANN(l_admission_appl_number),'20',' ')||
1179: LPAD(l_nominated_course_cd,'15',' ')||
1180: LPAD(IGS_GE_NUMBER.TO_CANN(l_sequence_number),'20',' '));

Line 1197: FND_FILE.PUT_LINE(FND_FILE.LOG,

1193: x_mode => 'R');
1194:
1195: -- Write the Application Instance which got
1196: --Assigned to a Particular Review Code to the Log file
1197: FND_FILE.PUT_LINE(FND_FILE.LOG,
1198: LPAD(IGS_GE_NUMBER.TO_CANN(c_arp_rec_found_rec.person_id),'20',' ')||
1199: LPAD(IGS_GE_NUMBER.TO_CANN(c_arp_rec_found_rec.admission_appl_number),'20',' ')||
1200: LPAD(c_arp_rec_found_rec.nominated_course_cd,'20',' ')||
1201: LPAD(IGS_GE_NUMBER.TO_CANN(c_arp_rec_found_rec.sequence_number),'20',' '));

Line 1211: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET_STRING('IGS','IGS_AD_NO_REC_FOUND'));

1207:
1208: -- No include or exclude Records for this Group Code
1209: ELSE
1210: CLOSE c_revgr_addr;
1211: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET_STRING('IGS','IGS_AD_NO_REC_FOUND'));
1212: END IF;
1213: END LOOP;
1214:
1215:

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

1219: -- Check if the Review Group Code is Geographical by Market Code
1220: ELSIF c_appl_revprof_group_cd_rec.appl_rev_profile_gr_cd = 'GEO_BY_MARKET_CODE' THEN
1221: FOR c_appl_revprof_revgr_rec IN c_appl_revprof_revgr(p_appl_rev_profile_id) LOOP
1222: -- Write the Group Code to the log file
1223: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
1224: FND_FILE.PUT_LINE(FND_FILE.LOG,
1225: LPAD(FND_MESSAGE.GET_STRING('IGS','IGS_AD_APPL_GRP_CD_PROC'),'27',' ') ||
1226: ' '||c_appl_revprof_revgr_rec.revprof_revgr_name);
1227: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');

Line 1224: FND_FILE.PUT_LINE(FND_FILE.LOG,

1220: ELSIF c_appl_revprof_group_cd_rec.appl_rev_profile_gr_cd = 'GEO_BY_MARKET_CODE' THEN
1221: FOR c_appl_revprof_revgr_rec IN c_appl_revprof_revgr(p_appl_rev_profile_id) LOOP
1222: -- Write the Group Code to the log file
1223: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
1224: FND_FILE.PUT_LINE(FND_FILE.LOG,
1225: LPAD(FND_MESSAGE.GET_STRING('IGS','IGS_AD_APPL_GRP_CD_PROC'),'27',' ') ||
1226: ' '||c_appl_revprof_revgr_rec.revprof_revgr_name);
1227: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
1228: FND_FILE.PUT_LINE(FND_FILE.LOG,

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

1223: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
1224: FND_FILE.PUT_LINE(FND_FILE.LOG,
1225: LPAD(FND_MESSAGE.GET_STRING('IGS','IGS_AD_APPL_GRP_CD_PROC'),'27',' ') ||
1226: ' '||c_appl_revprof_revgr_rec.revprof_revgr_name);
1227: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
1228: FND_FILE.PUT_LINE(FND_FILE.LOG,
1229: LPAD(FND_MESSAGE.GET_STRING('IGS','IGS_AD_PERSON_ID'),'20',' ')||
1230: LPAD(FND_MESSAGE.GET_STRING('IGS','IGS_AD_APPL_NO'),'20',' ')||
1231: LPAD(FND_MESSAGE.GET_STRING('IGS','IGS_AD_CRS_CD'),'20',' ')||

Line 1228: FND_FILE.PUT_LINE(FND_FILE.LOG,

1224: FND_FILE.PUT_LINE(FND_FILE.LOG,
1225: LPAD(FND_MESSAGE.GET_STRING('IGS','IGS_AD_APPL_GRP_CD_PROC'),'27',' ') ||
1226: ' '||c_appl_revprof_revgr_rec.revprof_revgr_name);
1227: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
1228: FND_FILE.PUT_LINE(FND_FILE.LOG,
1229: LPAD(FND_MESSAGE.GET_STRING('IGS','IGS_AD_PERSON_ID'),'20',' ')||
1230: LPAD(FND_MESSAGE.GET_STRING('IGS','IGS_AD_APPL_NO'),'20',' ')||
1231: LPAD(FND_MESSAGE.GET_STRING('IGS','IGS_AD_CRS_CD'),'20',' ')||
1232: LPAD(FND_MESSAGE.GET_STRING('IGS','IGS_AD_SEQ_NUM'),'20',' '));

Line 1477: FND_FILE.PUT_LINE(FND_FILE.LOG,LPAD(IGS_GE_NUMBER.TO_CANN(l_person_id),'20',' ')||

1473: x_mode => 'R');
1474:
1475: -- Write the Application Instance which got
1476: --Assigned to a Particular Review Code to the Log file
1477: FND_FILE.PUT_LINE(FND_FILE.LOG,LPAD(IGS_GE_NUMBER.TO_CANN(l_person_id),'20',' ')||
1478: LPAD(IGS_GE_NUMBER.TO_CANN(l_admission_appl_number),'20',' ')||
1479: LPAD(l_nominated_course_cd,'15',' ')||
1480: LPAD(IGS_GE_NUMBER.TO_CANN(l_sequence_number),'20',' '));
1481:

Line 1497: FND_FILE.PUT_LINE(FND_FILE.LOG,

1493: x_mode => 'R');
1494:
1495: -- Write the Application Instance which got
1496: --Assigned to a Particular Review Code to the Log file
1497: FND_FILE.PUT_LINE(FND_FILE.LOG,
1498: LPAD(IGS_GE_NUMBER.TO_CANN(c_arp_rec_found_rec.person_id),'20',' ')||
1499: LPAD(IGS_GE_NUMBER.TO_CANN(c_arp_rec_found_rec.admission_appl_number),'20',' ')||
1500: LPAD(c_arp_rec_found_rec.nominated_course_cd,'20',' ')||
1501: LPAD(IGS_GE_NUMBER.TO_CANN(c_arp_rec_found_rec.sequence_number),'20',' '));

Line 1512: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET_STRING('IGS','IGS_AD_NO_REC_FOUND'));

1508:
1509: -- No include or exclude Records for this Group Code
1510: ELSE
1511: CLOSE c_revgr_incl_excl;
1512: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET_STRING('IGS','IGS_AD_NO_REC_FOUND'));
1513: END IF;
1514: -- Loop through the next Review Group Code for the Profile ID
1515: END LOOP;
1516:

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

1521: -- Check if the Review Group Code is Program of Study
1522: ELSIF c_appl_revprof_group_cd_rec.appl_rev_profile_gr_cd = 'PROG_OF_STUDY' THEN
1523: FOR c_appl_revprof_revgr_rec IN c_appl_revprof_revgr(p_appl_rev_profile_id) LOOP
1524: -- Write the Group Code to the log file
1525: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
1526: FND_FILE.PUT_LINE(FND_FILE.LOG,
1527: LPAD(FND_MESSAGE.GET_STRING('IGS','IGS_AD_APPL_GRP_CD_PROC'),'27',' ')
1528: ||' '||c_appl_revprof_revgr_rec.revprof_revgr_name);
1529: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');

Line 1526: FND_FILE.PUT_LINE(FND_FILE.LOG,

1522: ELSIF c_appl_revprof_group_cd_rec.appl_rev_profile_gr_cd = 'PROG_OF_STUDY' THEN
1523: FOR c_appl_revprof_revgr_rec IN c_appl_revprof_revgr(p_appl_rev_profile_id) LOOP
1524: -- Write the Group Code to the log file
1525: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
1526: FND_FILE.PUT_LINE(FND_FILE.LOG,
1527: LPAD(FND_MESSAGE.GET_STRING('IGS','IGS_AD_APPL_GRP_CD_PROC'),'27',' ')
1528: ||' '||c_appl_revprof_revgr_rec.revprof_revgr_name);
1529: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
1530: FND_FILE.PUT_LINE(FND_FILE.LOG,

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

1525: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
1526: FND_FILE.PUT_LINE(FND_FILE.LOG,
1527: LPAD(FND_MESSAGE.GET_STRING('IGS','IGS_AD_APPL_GRP_CD_PROC'),'27',' ')
1528: ||' '||c_appl_revprof_revgr_rec.revprof_revgr_name);
1529: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
1530: FND_FILE.PUT_LINE(FND_FILE.LOG,
1531: LPAD(FND_MESSAGE.GET_STRING('IGS','IGS_AD_PERSON_ID'),'20',' ')||
1532: LPAD(FND_MESSAGE.GET_STRING('IGS','IGS_AD_APPL_NO'),'20',' ')||
1533: LPAD(FND_MESSAGE.GET_STRING('IGS','IGS_AD_CRS_CD'),'20',' ')||

Line 1530: FND_FILE.PUT_LINE(FND_FILE.LOG,

1526: FND_FILE.PUT_LINE(FND_FILE.LOG,
1527: LPAD(FND_MESSAGE.GET_STRING('IGS','IGS_AD_APPL_GRP_CD_PROC'),'27',' ')
1528: ||' '||c_appl_revprof_revgr_rec.revprof_revgr_name);
1529: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
1530: FND_FILE.PUT_LINE(FND_FILE.LOG,
1531: LPAD(FND_MESSAGE.GET_STRING('IGS','IGS_AD_PERSON_ID'),'20',' ')||
1532: LPAD(FND_MESSAGE.GET_STRING('IGS','IGS_AD_APPL_NO'),'20',' ')||
1533: LPAD(FND_MESSAGE.GET_STRING('IGS','IGS_AD_CRS_CD'),'20',' ')||
1534: LPAD(FND_MESSAGE.GET_STRING('IGS','IGS_AD_SEQ_NUM'),'20',' '));

Line 1700: FND_FILE.PUT_LINE(FND_FILE.LOG,

1696: x_mode => 'R');
1697:
1698: -- Write the Application Instance which got
1699: -- Assigned to a Particular Review Code to the Log file
1700: FND_FILE.PUT_LINE(FND_FILE.LOG,
1701: LPAD(IGS_GE_NUMBER.TO_CANN(l_person_id),'20',' ')||
1702: LPAD(IGS_GE_NUMBER.TO_CANN(l_admission_appl_number),'20',' ')||
1703: LPAD(l_nominated_course_cd,'15',' ')||
1704: LPAD(IGS_GE_NUMBER.TO_CANN(l_sequence_number),'20',' '));

Line 1721: FND_FILE.PUT_LINE(FND_FILE.LOG,

1717: x_mode => 'R');
1718:
1719: -- Write the Application Instance which got
1720: -- Assigned to a Particular Review Code to the Log file
1721: FND_FILE.PUT_LINE(FND_FILE.LOG,
1722: LPAD(IGS_GE_NUMBER.TO_CANN(c_arp_rec_found_rec.person_id),'20',' ')||
1723: LPAD(IGS_GE_NUMBER.TO_CANN(c_arp_rec_found_rec.admission_appl_number),'20',' ')||
1724: LPAD(c_arp_rec_found_rec.nominated_course_cd,'20',' ')||
1725: LPAD(IGS_GE_NUMBER.TO_CANN(c_arp_rec_found_rec.sequence_number),'20',' '));

Line 1736: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET_STRING('IGS','IGS_AD_NO_REC_FOUND'));

1732:
1733: -- No include or exclude Records for this Group Code
1734: ELSE
1735: CLOSE c_revgr_addr;
1736: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET_STRING('IGS','IGS_AD_NO_REC_FOUND'));
1737: END IF;
1738: -- Loop through the next Review Group Code for the Profile ID
1739: END LOOP;
1740:

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

1746: -- Check if the Review Group Code is Organization
1747: ELSIF c_appl_revprof_group_cd_rec.appl_rev_profile_gr_cd = 'ORGANIZATION' THEN
1748: FOR c_appl_revprof_revgr_rec IN c_appl_revprof_revgr(p_appl_rev_profile_id) LOOP
1749: -- Write the Group Code to the log file
1750: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
1751: FND_FILE.PUT_LINE(FND_FILE.LOG,
1752: LPAD(FND_MESSAGE.GET_STRING('IGS','IGS_AD_APPL_GRP_CD_PROC'),'27',' ') ||
1753: ' '|| c_appl_revprof_revgr_rec.revprof_revgr_name);
1754: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');

Line 1751: FND_FILE.PUT_LINE(FND_FILE.LOG,

1747: ELSIF c_appl_revprof_group_cd_rec.appl_rev_profile_gr_cd = 'ORGANIZATION' THEN
1748: FOR c_appl_revprof_revgr_rec IN c_appl_revprof_revgr(p_appl_rev_profile_id) LOOP
1749: -- Write the Group Code to the log file
1750: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
1751: FND_FILE.PUT_LINE(FND_FILE.LOG,
1752: LPAD(FND_MESSAGE.GET_STRING('IGS','IGS_AD_APPL_GRP_CD_PROC'),'27',' ') ||
1753: ' '|| c_appl_revprof_revgr_rec.revprof_revgr_name);
1754: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
1755: FND_FILE.PUT_LINE(FND_FILE.LOG,

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

1750: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
1751: FND_FILE.PUT_LINE(FND_FILE.LOG,
1752: LPAD(FND_MESSAGE.GET_STRING('IGS','IGS_AD_APPL_GRP_CD_PROC'),'27',' ') ||
1753: ' '|| c_appl_revprof_revgr_rec.revprof_revgr_name);
1754: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
1755: FND_FILE.PUT_LINE(FND_FILE.LOG,
1756: LPAD(FND_MESSAGE.GET_STRING('IGS','IGS_AD_PERSON_ID'),'20',' ')||
1757: LPAD(FND_MESSAGE.GET_STRING('IGS','IGS_AD_APPL_NO'),'20',' ')||
1758: LPAD(FND_MESSAGE.GET_STRING('IGS','IGS_AD_CRS_CD'),'20',' ')||

Line 1755: FND_FILE.PUT_LINE(FND_FILE.LOG,

1751: FND_FILE.PUT_LINE(FND_FILE.LOG,
1752: LPAD(FND_MESSAGE.GET_STRING('IGS','IGS_AD_APPL_GRP_CD_PROC'),'27',' ') ||
1753: ' '|| c_appl_revprof_revgr_rec.revprof_revgr_name);
1754: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
1755: FND_FILE.PUT_LINE(FND_FILE.LOG,
1756: LPAD(FND_MESSAGE.GET_STRING('IGS','IGS_AD_PERSON_ID'),'20',' ')||
1757: LPAD(FND_MESSAGE.GET_STRING('IGS','IGS_AD_APPL_NO'),'20',' ')||
1758: LPAD(FND_MESSAGE.GET_STRING('IGS','IGS_AD_CRS_CD'),'20',' ')||
1759: LPAD(FND_MESSAGE.GET_STRING('IGS','IGS_AD_SEQ_NUM'),'20',' '));

Line 1919: FND_FILE.PUT_LINE(FND_FILE.LOG,

1915: x_mode => 'R');
1916:
1917: -- Write the Application Instance which got
1918: --Assigned to a Particular Review Code to the Log file
1919: FND_FILE.PUT_LINE(FND_FILE.LOG,
1920: LPAD(IGS_GE_NUMBER.TO_CANN(l_person_id),'20',' ')||
1921: LPAD(IGS_GE_NUMBER.TO_CANN(l_admission_appl_number),'20',' ')||
1922: LPAD(l_nominated_course_cd,'15',' ')||
1923: LPAD(IGS_GE_NUMBER.TO_CANN(l_sequence_number),'20',' '));

Line 1940: FND_FILE.PUT_LINE(FND_FILE.LOG,

1936: x_mode => 'R');
1937:
1938: -- Write the Application Instance which got Assigned to a
1939: --Particular Review Code to the Log file
1940: FND_FILE.PUT_LINE(FND_FILE.LOG,
1941: LPAD(IGS_GE_NUMBER.TO_CANN(c_arp_rec_found_rec.person_id),'20',' ')||
1942: LPAD(IGS_GE_NUMBER.TO_CANN(c_arp_rec_found_rec.admission_appl_number),'20',' ')||
1943: LPAD(c_arp_rec_found_rec.nominated_course_cd,'20',' ')||
1944: LPAD(IGS_GE_NUMBER.TO_CANN(c_arp_rec_found_rec.sequence_number),'20',' '));

Line 1955: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET_STRING('IGS','IGS_AD_NO_REC_FOUND'));

1951:
1952: -- No include or exclude Records for this Group Code
1953: ELSE
1954: CLOSE c_revgr_addr;
1955: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET_STRING('IGS','IGS_AD_NO_REC_FOUND'));
1956: END IF;
1957: -- Loop through the next Review Group Code for the Profile ID
1958: END LOOP;
1959: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');

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

1955: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET_STRING('IGS','IGS_AD_NO_REC_FOUND'));
1956: END IF;
1957: -- Loop through the next Review Group Code for the Profile ID
1958: END LOOP;
1959: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
1960: END IF;
1961: EXCEPTION
1962: WHEN OTHERS THEN
1963: retcode := 2;