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_MESSAGE

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 161: FND_MESSAGE.SET_NAME('IGS', 'IGS_AD_APP_LG_CL_DTLS');

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);
163: FND_FILE.PUT_LINE( FND_FILE.LOG, FND_MESSAGE.GET());
164:
165: -- Write the Admission Process Cagtegory Details to the log file

Line 162: FND_MESSAGE.SET_TOKEN('CLDTLS', p_calendar_details);

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);
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');

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 166: FND_MESSAGE.SET_NAME('IGS', 'IGS_AD_APP_LG_APC');

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);
168: FND_FILE.PUT_LINE( FND_FILE.LOG, FND_MESSAGE.GET());
169:
170: IF p_admission_process_category IS NULL THEN

Line 167: FND_MESSAGE.SET_TOKEN('APC', p_admission_process_category);

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);
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;

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 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 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 191: 'IGS_AD_PERSON_ID'),'20',' ')||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',' '));
195:

Line 193: ||LPAD(FND_MESSAGE.GET_STRING('IGS','IGS_AD_CRS_CD'),'20',' ')||

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',' '));
195:
196:
197: l_cur_statement := NULL;

Line 194: LPAD(FND_MESSAGE.GET_STRING('IGS','IGS_AD_SEQ_NUM'),'20',' '));

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',' '));
195:
196:
197: l_cur_statement := NULL;
198:

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 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 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 485: LPAD(FND_MESSAGE.GET_STRING('IGS','IGS_AD_APPL_NO'),'20',' ')

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:
489: l_cur_statement := NULL;

Line 486: ||LPAD(FND_MESSAGE.GET_STRING('IGS','IGS_AD_CRS_CD'),'20',' ')||

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:
489: l_cur_statement := NULL;
490:

Line 487: LPAD(FND_MESSAGE.GET_STRING('IGS','IGS_AD_SEQ_NUM'),'20',' '));

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:
489: l_cur_statement := NULL;
490:
491: -- Check if there are any include or exclude records for the Group id.

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 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 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 857: LPAD(FND_MESSAGE.GET_STRING('IGS','IGS_AD_APPL_NO'),'20',' ')||

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;
861:

Line 858: LPAD(FND_MESSAGE.GET_STRING('IGS','IGS_AD_CRS_CD'),'20',' ')||

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;
861:
862: -- Check if there are any include or exclude records for the Group id.

Line 859: LPAD(FND_MESSAGE.GET_STRING('IGS','IGS_AD_SEQ_NUM'),'20',' '));

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;
861:
862: -- Check if there are any include or exclude records for the Group id.
863: OPEN c_revgr_addr(c_appl_revprof_revgr_rec.appl_revprof_revgr_id);

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 1225: LPAD(FND_MESSAGE.GET_STRING('IGS','IGS_AD_APPL_GRP_CD_PROC'),'27',' ') ||

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,
1229: LPAD(FND_MESSAGE.GET_STRING('IGS','IGS_AD_PERSON_ID'),'20',' ')||

Line 1229: LPAD(FND_MESSAGE.GET_STRING('IGS','IGS_AD_PERSON_ID'),'20',' ')||

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',' '));
1233:

Line 1230: LPAD(FND_MESSAGE.GET_STRING('IGS','IGS_AD_APPL_NO'),'20',' ')||

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',' '));
1233:
1234: l_cur_statement := NULL;

Line 1231: LPAD(FND_MESSAGE.GET_STRING('IGS','IGS_AD_CRS_CD'),'20',' ')||

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',' '));
1233:
1234: l_cur_statement := NULL;
1235: -- Check if there are any include or exclude records for the Group id.

Line 1232: LPAD(FND_MESSAGE.GET_STRING('IGS','IGS_AD_SEQ_NUM'),'20',' '));

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',' '));
1233:
1234: l_cur_statement := NULL;
1235: -- Check if there are any include or exclude records for the Group id.
1236: OPEN c_revgr_incl_excl(c_appl_revprof_revgr_rec.appl_revprof_revgr_id,

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 1527: LPAD(FND_MESSAGE.GET_STRING('IGS','IGS_AD_APPL_GRP_CD_PROC'),'27',' ')

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,
1531: LPAD(FND_MESSAGE.GET_STRING('IGS','IGS_AD_PERSON_ID'),'20',' ')||

Line 1531: LPAD(FND_MESSAGE.GET_STRING('IGS','IGS_AD_PERSON_ID'),'20',' ')||

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',' '));
1535:

Line 1532: LPAD(FND_MESSAGE.GET_STRING('IGS','IGS_AD_APPL_NO'),'20',' ')||

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',' '));
1535:
1536: l_cur_statement := NULL;

Line 1533: LPAD(FND_MESSAGE.GET_STRING('IGS','IGS_AD_CRS_CD'),'20',' ')||

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',' '));
1535:
1536: l_cur_statement := NULL;
1537:

Line 1534: LPAD(FND_MESSAGE.GET_STRING('IGS','IGS_AD_SEQ_NUM'),'20',' '));

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',' '));
1535:
1536: l_cur_statement := NULL;
1537:
1538: -- Check if there are any include or exclude records for the Group id.

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 1752: LPAD(FND_MESSAGE.GET_STRING('IGS','IGS_AD_APPL_GRP_CD_PROC'),'27',' ') ||

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,
1756: LPAD(FND_MESSAGE.GET_STRING('IGS','IGS_AD_PERSON_ID'),'20',' ')||

Line 1756: LPAD(FND_MESSAGE.GET_STRING('IGS','IGS_AD_PERSON_ID'),'20',' ')||

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',' '));
1760:

Line 1757: LPAD(FND_MESSAGE.GET_STRING('IGS','IGS_AD_APPL_NO'),'20',' ')||

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',' '));
1760:
1761: l_cur_statement := NULL;

Line 1758: LPAD(FND_MESSAGE.GET_STRING('IGS','IGS_AD_CRS_CD'),'20',' ')||

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',' '));
1760:
1761: l_cur_statement := NULL;
1762:

Line 1759: LPAD(FND_MESSAGE.GET_STRING('IGS','IGS_AD_SEQ_NUM'),'20',' '));

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',' '));
1760:
1761: l_cur_statement := NULL;
1762:
1763: -- Check if there are any include or exclude records for the Group id.

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,' ');