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.IGF_AP_CALC_IM_EFC dependencies on FND_MESSAGE

Line 103: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');

99: fnd_file.put_line(fnd_file.log,RPAD('-',55,'-'));
100:
101: EXCEPTION
102: WHEN OTHERS THEN
103: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
104: fnd_message.set_token('NAME','IGF_AP_CALC_IM_EFC.LOG_PARAMETERS '||SQLERRM);
105: igs_ge_msg_stack.add;
106: app_exception.raise_exception;
107: END log_parameters;

Line 104: fnd_message.set_token('NAME','IGF_AP_CALC_IM_EFC.LOG_PARAMETERS '||SQLERRM);

100:
101: EXCEPTION
102: WHEN OTHERS THEN
103: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
104: fnd_message.set_token('NAME','IGF_AP_CALC_IM_EFC.LOG_PARAMETERS '||SQLERRM);
105: igs_ge_msg_stack.add;
106: app_exception.raise_exception;
107: END log_parameters;
108:

Line 208: fnd_message.set_name('IGF','IGF_AP_NO_PROF_RECS_EXIST');

204: FETCH c_all_profiles INTO l_profile;
205:
206: IF c_all_profiles%NOTFOUND THEN
207: --log a message
208: fnd_message.set_name('IGF','IGF_AP_NO_PROF_RECS_EXIST');
209: fnd_file.put_line(fnd_file.log,g_tab_2 || fnd_message.get);
210: RETURN;
211: ELSE
212:

Line 209: fnd_file.put_line(fnd_file.log,g_tab_2 || fnd_message.get);

205:
206: IF c_all_profiles%NOTFOUND THEN
207: --log a message
208: fnd_message.set_name('IGF','IGF_AP_NO_PROF_RECS_EXIST');
209: fnd_file.put_line(fnd_file.log,g_tab_2 || fnd_message.get);
210: RETURN;
211: ELSE
212:
213: WHILE c_all_profiles%FOUND

Line 253: fnd_message.set_name('IGF',l_error_msg);

249: );
250:
251: IF NOT lv_success THEN
252: ROLLBACK TO SP_PROFILE_ID;
253: fnd_message.set_name('IGF',l_error_msg);
254: fnd_file.put_line(fnd_file.log,g_tab_2 || fnd_message.get);
255:
256: fnd_message.set_name('IGF','IGF_AP_PROF_EFC_CALC_FAILED');
257: fnd_file.put_line(fnd_file.log,g_tab_2 || fnd_message.get);

Line 254: fnd_file.put_line(fnd_file.log,g_tab_2 || fnd_message.get);

250:
251: IF NOT lv_success THEN
252: ROLLBACK TO SP_PROFILE_ID;
253: fnd_message.set_name('IGF',l_error_msg);
254: fnd_file.put_line(fnd_file.log,g_tab_2 || fnd_message.get);
255:
256: fnd_message.set_name('IGF','IGF_AP_PROF_EFC_CALC_FAILED');
257: fnd_file.put_line(fnd_file.log,g_tab_2 || fnd_message.get);
258: RAISE SKIP_PROFILE_RECORD;

Line 256: fnd_message.set_name('IGF','IGF_AP_PROF_EFC_CALC_FAILED');

252: ROLLBACK TO SP_PROFILE_ID;
253: fnd_message.set_name('IGF',l_error_msg);
254: fnd_file.put_line(fnd_file.log,g_tab_2 || fnd_message.get);
255:
256: fnd_message.set_name('IGF','IGF_AP_PROF_EFC_CALC_FAILED');
257: fnd_file.put_line(fnd_file.log,g_tab_2 || fnd_message.get);
258: RAISE SKIP_PROFILE_RECORD;
259: END IF;
260:

Line 257: fnd_file.put_line(fnd_file.log,g_tab_2 || fnd_message.get);

253: fnd_message.set_name('IGF',l_error_msg);
254: fnd_file.put_line(fnd_file.log,g_tab_2 || fnd_message.get);
255:
256: fnd_message.set_name('IGF','IGF_AP_PROF_EFC_CALC_FAILED');
257: fnd_file.put_line(fnd_file.log,g_tab_2 || fnd_message.get);
258: RAISE SKIP_PROFILE_RECORD;
259: END IF;
260:
261: IF l_profile.row_id <> lv_cssp_rowid OR

Line 265: fnd_message.set_name('IGF','IGF_AP_PROF_UHK_UPDATED_PK');

261: IF l_profile.row_id <> lv_cssp_rowid OR
262: l_profile.cssp_id <> l_cssp_id OR
263: l_profile.base_id <> l_base_id OR
264: (l_fnar_rec_fnd AND (l_fnar.row_id <> lv_fnar_rowid OR l_fnar.fnar_id <> l_fnar_id OR l_fnar.cssp_id <> l_fnar_cssp_id)) THEN
265: fnd_message.set_name('IGF','IGF_AP_PROF_UHK_UPDATED_PK');
266: fnd_file.put_line(fnd_file.log,fnd_message.get);
267: RAISE SKIP_PROFILE_RECORD;
268: END IF;
269:

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

262: l_profile.cssp_id <> l_cssp_id OR
263: l_profile.base_id <> l_base_id OR
264: (l_fnar_rec_fnd AND (l_fnar.row_id <> lv_fnar_rowid OR l_fnar.fnar_id <> l_fnar_id OR l_fnar.cssp_id <> l_fnar_cssp_id)) THEN
265: fnd_message.set_name('IGF','IGF_AP_PROF_UHK_UPDATED_PK');
266: fnd_file.put_line(fnd_file.log,fnd_message.get);
267: RAISE SKIP_PROFILE_RECORD;
268: END IF;
269:
270:

Line 1008: fnd_message.set_name('IGF','IGF_AP_PROF_UPD_FAIL');

1004:
1005: EXCEPTION
1006: WHEN OTHERS THEN
1007: ROLLBACK TO SP_PROFILE_ID;
1008: fnd_message.set_name('IGF','IGF_AP_PROF_UPD_FAIL');
1009: fnd_file.put_line(fnd_file.log,g_tab_2 || fnd_message.get);
1010: RAISE SKIP_PROFILE_RECORD;
1011: END; -- End of PROFILE Update block
1012:

Line 1009: fnd_file.put_line(fnd_file.log,g_tab_2 || fnd_message.get);

1005: EXCEPTION
1006: WHEN OTHERS THEN
1007: ROLLBACK TO SP_PROFILE_ID;
1008: fnd_message.set_name('IGF','IGF_AP_PROF_UPD_FAIL');
1009: fnd_file.put_line(fnd_file.log,g_tab_2 || fnd_message.get);
1010: RAISE SKIP_PROFILE_RECORD;
1011: END; -- End of PROFILE Update block
1012:
1013: fnd_message.set_name('IGF','IGF_AP_PROF_EFC_CALC_SUCCESS');

Line 1013: fnd_message.set_name('IGF','IGF_AP_PROF_EFC_CALC_SUCCESS');

1009: fnd_file.put_line(fnd_file.log,g_tab_2 || fnd_message.get);
1010: RAISE SKIP_PROFILE_RECORD;
1011: END; -- End of PROFILE Update block
1012:
1013: fnd_message.set_name('IGF','IGF_AP_PROF_EFC_CALC_SUCCESS');
1014: fnd_file.put_line(fnd_file.log,g_tab_2 || fnd_message.get);
1015: fnd_file.new_line(fnd_file.log,1);
1016: g_success := g_success + 1;
1017:

Line 1014: fnd_file.put_line(fnd_file.log,g_tab_2 || fnd_message.get);

1010: RAISE SKIP_PROFILE_RECORD;
1011: END; -- End of PROFILE Update block
1012:
1013: fnd_message.set_name('IGF','IGF_AP_PROF_EFC_CALC_SUCCESS');
1014: fnd_file.put_line(fnd_file.log,g_tab_2 || fnd_message.get);
1015: fnd_file.new_line(fnd_file.log,1);
1016: g_success := g_success + 1;
1017:
1018: EXCEPTION

Line 1122: fnd_message.set_name('IGS','IGS_FI_NO_PERS_PGRP');

1118: --Error.Cant have both parameters as not null
1119: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1120: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_calc_im_efc.main.debug','Cant specify both base_id and persid_grp.exiting');
1121: END IF;
1122: fnd_message.set_name('IGS','IGS_FI_NO_PERS_PGRP');
1123: fnd_file.put_line(fnd_file.log,fnd_message.get);
1124: retcode := 2;
1125: RETURN;
1126: END IF;

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

1119: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1120: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_calc_im_efc.main.debug','Cant specify both base_id and persid_grp.exiting');
1121: END IF;
1122: fnd_message.set_name('IGS','IGS_FI_NO_PERS_PGRP');
1123: fnd_file.put_line(fnd_file.log,fnd_message.get);
1124: retcode := 2;
1125: RETURN;
1126: END IF;
1127:

Line 1133: fnd_message.set_name('IGF','IGF_AP_INAS_NOT_ITEGRATED');

1129: --Error.INAS has to be integrated
1130: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1131: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_calc_im_efc.main.debug','INAS not integrated');
1132: END IF;
1133: fnd_message.set_name('IGF','IGF_AP_INAS_NOT_ITEGRATED');
1134: fnd_file.put_line(fnd_file.log,fnd_message.get);
1135: retcode := 2;
1136: RETURN;
1137: END IF;

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

1130: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1131: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_calc_im_efc.main.debug','INAS not integrated');
1132: END IF;
1133: fnd_message.set_name('IGF','IGF_AP_INAS_NOT_ITEGRATED');
1134: fnd_file.put_line(fnd_file.log,fnd_message.get);
1135: retcode := 2;
1136: RETURN;
1137: END IF;
1138:

Line 1190: fnd_message.set_name('IGF','IGF_DB_NO_PER_GRP');

1186:
1187: FETCH lc_base_id INTO lbase;
1188: END LOOP;
1189: ELSE
1190: fnd_message.set_name('IGF','IGF_DB_NO_PER_GRP');
1191: fnd_file.put_line(fnd_file.log,fnd_message.get);
1192: END IF;
1193: ELSIF p_base_id IS NULL AND p_persid_grp IS NULL THEN
1194: --both person id and person id group is null

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

1187: FETCH lc_base_id INTO lbase;
1188: END LOOP;
1189: ELSE
1190: fnd_message.set_name('IGF','IGF_DB_NO_PER_GRP');
1191: fnd_file.put_line(fnd_file.log,fnd_message.get);
1192: END IF;
1193: ELSIF p_base_id IS NULL AND p_persid_grp IS NULL THEN
1194: --both person id and person id group is null
1195: --calculate efc for all persons in the award year

Line 1221: fnd_message.set_name('IGS','IGS_GE_TOTAL_REC_PROCESSED');

1217:
1218: fnd_file.put_line(fnd_file.output,' ');
1219: fnd_file.put_line(fnd_file.output, RPAD('-',50,'-'));
1220: fnd_file.put_line(fnd_file.output,' ');
1221: fnd_message.set_name('IGS','IGS_GE_TOTAL_REC_PROCESSED');
1222: fnd_file.put_line(fnd_file.output,RPAD(fnd_message.get || ' ',40) || g_total);
1223: fnd_message.set_name('IGS','IGS_GE_TOTAL_REC_COMPLETED');
1224: fnd_file.put_line(fnd_file.output,RPAD(fnd_message.get || ' ',40) || g_success);
1225: fnd_message.set_name('IGS','IGS_GE_TOTAL_REC_FAILED');

Line 1222: fnd_file.put_line(fnd_file.output,RPAD(fnd_message.get || ' ',40) || g_total);

1218: fnd_file.put_line(fnd_file.output,' ');
1219: fnd_file.put_line(fnd_file.output, RPAD('-',50,'-'));
1220: fnd_file.put_line(fnd_file.output,' ');
1221: fnd_message.set_name('IGS','IGS_GE_TOTAL_REC_PROCESSED');
1222: fnd_file.put_line(fnd_file.output,RPAD(fnd_message.get || ' ',40) || g_total);
1223: fnd_message.set_name('IGS','IGS_GE_TOTAL_REC_COMPLETED');
1224: fnd_file.put_line(fnd_file.output,RPAD(fnd_message.get || ' ',40) || g_success);
1225: fnd_message.set_name('IGS','IGS_GE_TOTAL_REC_FAILED');
1226: fnd_file.put_line(fnd_file.output,RPAD(fnd_message.get || ' : ',40) || g_error);

Line 1223: fnd_message.set_name('IGS','IGS_GE_TOTAL_REC_COMPLETED');

1219: fnd_file.put_line(fnd_file.output, RPAD('-',50,'-'));
1220: fnd_file.put_line(fnd_file.output,' ');
1221: fnd_message.set_name('IGS','IGS_GE_TOTAL_REC_PROCESSED');
1222: fnd_file.put_line(fnd_file.output,RPAD(fnd_message.get || ' ',40) || g_total);
1223: fnd_message.set_name('IGS','IGS_GE_TOTAL_REC_COMPLETED');
1224: fnd_file.put_line(fnd_file.output,RPAD(fnd_message.get || ' ',40) || g_success);
1225: fnd_message.set_name('IGS','IGS_GE_TOTAL_REC_FAILED');
1226: fnd_file.put_line(fnd_file.output,RPAD(fnd_message.get || ' : ',40) || g_error);
1227: fnd_file.put_line(fnd_file.output,' ');

Line 1224: fnd_file.put_line(fnd_file.output,RPAD(fnd_message.get || ' ',40) || g_success);

1220: fnd_file.put_line(fnd_file.output,' ');
1221: fnd_message.set_name('IGS','IGS_GE_TOTAL_REC_PROCESSED');
1222: fnd_file.put_line(fnd_file.output,RPAD(fnd_message.get || ' ',40) || g_total);
1223: fnd_message.set_name('IGS','IGS_GE_TOTAL_REC_COMPLETED');
1224: fnd_file.put_line(fnd_file.output,RPAD(fnd_message.get || ' ',40) || g_success);
1225: fnd_message.set_name('IGS','IGS_GE_TOTAL_REC_FAILED');
1226: fnd_file.put_line(fnd_file.output,RPAD(fnd_message.get || ' : ',40) || g_error);
1227: fnd_file.put_line(fnd_file.output,' ');
1228: fnd_file.put_line(fnd_file.output, RPAD('-',50,'-'));

Line 1225: fnd_message.set_name('IGS','IGS_GE_TOTAL_REC_FAILED');

1221: fnd_message.set_name('IGS','IGS_GE_TOTAL_REC_PROCESSED');
1222: fnd_file.put_line(fnd_file.output,RPAD(fnd_message.get || ' ',40) || g_total);
1223: fnd_message.set_name('IGS','IGS_GE_TOTAL_REC_COMPLETED');
1224: fnd_file.put_line(fnd_file.output,RPAD(fnd_message.get || ' ',40) || g_success);
1225: fnd_message.set_name('IGS','IGS_GE_TOTAL_REC_FAILED');
1226: fnd_file.put_line(fnd_file.output,RPAD(fnd_message.get || ' : ',40) || g_error);
1227: fnd_file.put_line(fnd_file.output,' ');
1228: fnd_file.put_line(fnd_file.output, RPAD('-',50,'-'));
1229: fnd_file.put_line(fnd_file.output,' ');

Line 1226: fnd_file.put_line(fnd_file.output,RPAD(fnd_message.get || ' : ',40) || g_error);

1222: fnd_file.put_line(fnd_file.output,RPAD(fnd_message.get || ' ',40) || g_total);
1223: fnd_message.set_name('IGS','IGS_GE_TOTAL_REC_COMPLETED');
1224: fnd_file.put_line(fnd_file.output,RPAD(fnd_message.get || ' ',40) || g_success);
1225: fnd_message.set_name('IGS','IGS_GE_TOTAL_REC_FAILED');
1226: fnd_file.put_line(fnd_file.output,RPAD(fnd_message.get || ' : ',40) || g_error);
1227: fnd_file.put_line(fnd_file.output,' ');
1228: fnd_file.put_line(fnd_file.output, RPAD('-',50,'-'));
1229: fnd_file.put_line(fnd_file.output,' ');
1230:

Line 1234: fnd_message.set_name('IGS','IGS_GE_TOTAL_REC_PROCESSED');

1230:
1231: fnd_file.put_line(fnd_file.log,' ');
1232: fnd_file.put_line(fnd_file.log, RPAD('-',50,'-'));
1233: fnd_file.put_line(fnd_file.log,' ');
1234: fnd_message.set_name('IGS','IGS_GE_TOTAL_REC_PROCESSED');
1235: fnd_file.put_line(fnd_file.log,RPAD(fnd_message.get || ' ',40) || g_total);
1236: fnd_message.set_name('IGS','IGS_GE_TOTAL_REC_COMPLETED');
1237: fnd_file.put_line(fnd_file.log,RPAD(fnd_message.get || ' ',40) || g_success);
1238: fnd_message.set_name('IGS','IGS_GE_TOTAL_REC_FAILED');

Line 1235: fnd_file.put_line(fnd_file.log,RPAD(fnd_message.get || ' ',40) || g_total);

1231: fnd_file.put_line(fnd_file.log,' ');
1232: fnd_file.put_line(fnd_file.log, RPAD('-',50,'-'));
1233: fnd_file.put_line(fnd_file.log,' ');
1234: fnd_message.set_name('IGS','IGS_GE_TOTAL_REC_PROCESSED');
1235: fnd_file.put_line(fnd_file.log,RPAD(fnd_message.get || ' ',40) || g_total);
1236: fnd_message.set_name('IGS','IGS_GE_TOTAL_REC_COMPLETED');
1237: fnd_file.put_line(fnd_file.log,RPAD(fnd_message.get || ' ',40) || g_success);
1238: fnd_message.set_name('IGS','IGS_GE_TOTAL_REC_FAILED');
1239: fnd_file.put_line(fnd_file.log,RPAD(fnd_message.get || ' : ',40) || g_error);

Line 1236: fnd_message.set_name('IGS','IGS_GE_TOTAL_REC_COMPLETED');

1232: fnd_file.put_line(fnd_file.log, RPAD('-',50,'-'));
1233: fnd_file.put_line(fnd_file.log,' ');
1234: fnd_message.set_name('IGS','IGS_GE_TOTAL_REC_PROCESSED');
1235: fnd_file.put_line(fnd_file.log,RPAD(fnd_message.get || ' ',40) || g_total);
1236: fnd_message.set_name('IGS','IGS_GE_TOTAL_REC_COMPLETED');
1237: fnd_file.put_line(fnd_file.log,RPAD(fnd_message.get || ' ',40) || g_success);
1238: fnd_message.set_name('IGS','IGS_GE_TOTAL_REC_FAILED');
1239: fnd_file.put_line(fnd_file.log,RPAD(fnd_message.get || ' : ',40) || g_error);
1240: fnd_file.put_line(fnd_file.log,' ');

Line 1237: fnd_file.put_line(fnd_file.log,RPAD(fnd_message.get || ' ',40) || g_success);

1233: fnd_file.put_line(fnd_file.log,' ');
1234: fnd_message.set_name('IGS','IGS_GE_TOTAL_REC_PROCESSED');
1235: fnd_file.put_line(fnd_file.log,RPAD(fnd_message.get || ' ',40) || g_total);
1236: fnd_message.set_name('IGS','IGS_GE_TOTAL_REC_COMPLETED');
1237: fnd_file.put_line(fnd_file.log,RPAD(fnd_message.get || ' ',40) || g_success);
1238: fnd_message.set_name('IGS','IGS_GE_TOTAL_REC_FAILED');
1239: fnd_file.put_line(fnd_file.log,RPAD(fnd_message.get || ' : ',40) || g_error);
1240: fnd_file.put_line(fnd_file.log,' ');
1241: fnd_file.put_line(fnd_file.log, RPAD('-',50,'-'));

Line 1238: fnd_message.set_name('IGS','IGS_GE_TOTAL_REC_FAILED');

1234: fnd_message.set_name('IGS','IGS_GE_TOTAL_REC_PROCESSED');
1235: fnd_file.put_line(fnd_file.log,RPAD(fnd_message.get || ' ',40) || g_total);
1236: fnd_message.set_name('IGS','IGS_GE_TOTAL_REC_COMPLETED');
1237: fnd_file.put_line(fnd_file.log,RPAD(fnd_message.get || ' ',40) || g_success);
1238: fnd_message.set_name('IGS','IGS_GE_TOTAL_REC_FAILED');
1239: fnd_file.put_line(fnd_file.log,RPAD(fnd_message.get || ' : ',40) || g_error);
1240: fnd_file.put_line(fnd_file.log,' ');
1241: fnd_file.put_line(fnd_file.log, RPAD('-',50,'-'));
1242: fnd_file.put_line(fnd_file.log,' ');

Line 1239: fnd_file.put_line(fnd_file.log,RPAD(fnd_message.get || ' : ',40) || g_error);

1235: fnd_file.put_line(fnd_file.log,RPAD(fnd_message.get || ' ',40) || g_total);
1236: fnd_message.set_name('IGS','IGS_GE_TOTAL_REC_COMPLETED');
1237: fnd_file.put_line(fnd_file.log,RPAD(fnd_message.get || ' ',40) || g_success);
1238: fnd_message.set_name('IGS','IGS_GE_TOTAL_REC_FAILED');
1239: fnd_file.put_line(fnd_file.log,RPAD(fnd_message.get || ' : ',40) || g_error);
1240: fnd_file.put_line(fnd_file.log,' ');
1241: fnd_file.put_line(fnd_file.log, RPAD('-',50,'-'));
1242: fnd_file.put_line(fnd_file.log,' ');
1243:

Line 1247: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');

1243:
1244: EXCEPTION
1245: WHEN OTHERS THEN
1246: retcode := 2;
1247: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
1248: fnd_message.set_token('NAME','IGF_AP_CALC_IM_EFC.MAIN '||SQLERRM);
1249: errbuf := fnd_message.get;
1250: igs_ge_msg_stack.conc_exception_hndl;
1251: END main;

Line 1248: fnd_message.set_token('NAME','IGF_AP_CALC_IM_EFC.MAIN '||SQLERRM);

1244: EXCEPTION
1245: WHEN OTHERS THEN
1246: retcode := 2;
1247: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
1248: fnd_message.set_token('NAME','IGF_AP_CALC_IM_EFC.MAIN '||SQLERRM);
1249: errbuf := fnd_message.get;
1250: igs_ge_msg_stack.conc_exception_hndl;
1251: END main;
1252:

Line 1249: errbuf := fnd_message.get;

1245: WHEN OTHERS THEN
1246: retcode := 2;
1247: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
1248: fnd_message.set_token('NAME','IGF_AP_CALC_IM_EFC.MAIN '||SQLERRM);
1249: errbuf := fnd_message.get;
1250: igs_ge_msg_stack.conc_exception_hndl;
1251: END main;
1252:
1253: END igf_ap_calc_im_efc;