DBA Data[Home] [Help]

APPS.IGF_AP_CALC_IM_EFC dependencies on FND_FILE

Line 81: fnd_file.put_line(fnd_file.log,l_param_pass_log);

77:
78: l_persid_grp_name c_person_group%ROWTYPE;
79:
80: BEGIN
81: fnd_file.put_line(fnd_file.log,l_param_pass_log);
82:
83: OPEN c_alternate_code(p_cal_type,p_sequence_number);
84: FETCH c_alternate_code INTO l_alternate_code;
85: CLOSE c_alternate_code;

Line 87: fnd_file.put_line(fnd_file.log,RPAD(l_awd_yr_log,40) || ' : ' || l_alternate_code);

83: OPEN c_alternate_code(p_cal_type,p_sequence_number);
84: FETCH c_alternate_code INTO l_alternate_code;
85: CLOSE c_alternate_code;
86:
87: fnd_file.put_line(fnd_file.log,RPAD(l_awd_yr_log,40) || ' : ' || l_alternate_code);
88:
89: OPEN c_person_number(p_base_id);
90: FETCH c_person_number INTO l_person_number;
91: CLOSE c_person_number;

Line 97: fnd_file.put_line(fnd_file.log,RPAD(l_pers_number_log,40) || ' : ' || l_person_number);

93: OPEN c_person_group(p_persid_grp);
94: FETCH c_person_group INTO l_persid_grp_name;
95: CLOSE c_person_group;
96:
97: fnd_file.put_line(fnd_file.log,RPAD(l_pers_number_log,40) || ' : ' || l_person_number);
98: fnd_file.put_line(fnd_file.log,RPAD(l_pers_id_grp_log,40) || ' : ' || l_persid_grp_name.group_name);
99: fnd_file.put_line(fnd_file.log,RPAD('-',55,'-'));
100:
101: EXCEPTION

Line 98: fnd_file.put_line(fnd_file.log,RPAD(l_pers_id_grp_log,40) || ' : ' || l_persid_grp_name.group_name);

94: FETCH c_person_group INTO l_persid_grp_name;
95: CLOSE c_person_group;
96:
97: fnd_file.put_line(fnd_file.log,RPAD(l_pers_number_log,40) || ' : ' || l_person_number);
98: fnd_file.put_line(fnd_file.log,RPAD(l_pers_id_grp_log,40) || ' : ' || l_persid_grp_name.group_name);
99: fnd_file.put_line(fnd_file.log,RPAD('-',55,'-'));
100:
101: EXCEPTION
102: WHEN OTHERS THEN

Line 99: fnd_file.put_line(fnd_file.log,RPAD('-',55,'-'));

95: CLOSE c_person_group;
96:
97: fnd_file.put_line(fnd_file.log,RPAD(l_pers_number_log,40) || ' : ' || l_person_number);
98: fnd_file.put_line(fnd_file.log,RPAD(l_pers_id_grp_log,40) || ' : ' || l_persid_grp_name.group_name);
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');

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 237: fnd_file.put_line(fnd_file.log,g_tab_1 || l_internal_id_log || l_profile.css_id_number || l_profile.stu_record_type);

233:
234: SAVEPOINT SP_PROFILE_ID;
235:
236: --for each profile
237: fnd_file.put_line(fnd_file.log,g_tab_1 || l_internal_id_log || l_profile.css_id_number || l_profile.stu_record_type);
238:
239: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
240: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_calc_im_efc.calculate_efc.debug','processing internal id '||l_profile.css_id_number || l_profile.stu_record_type);
241: END IF;

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 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 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 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 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 1015: fnd_file.new_line(fnd_file.log,1);

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
1019: WHEN SKIP_PROFILE_RECORD THEN

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 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 1147: fnd_file.put_line(fnd_file.log,l_processing_log || l_pers_number_log || l_person_number);

1143: OPEN c_person_number(p_base_id);
1144: FETCH c_person_number INTO l_person_number;
1145: CLOSE c_person_number;
1146:
1147: fnd_file.put_line(fnd_file.log,l_processing_log || l_pers_number_log || l_person_number);
1148:
1149: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1150: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_calc_im_efc.main.debug','calling calculate_efc with base_id:'||p_base_id);
1151: END IF;

Line 1180: fnd_file.put_line(fnd_file.log,l_processing_log || l_pers_number_log || l_person_number);

1176: OPEN c_person_number(lbase);
1177: FETCH c_person_number INTO l_person_number;
1178: CLOSE c_person_number;
1179:
1180: fnd_file.put_line(fnd_file.log,l_processing_log || l_pers_number_log || l_person_number);
1181: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1182: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_calc_im_efc.main.debug','calling calculate_efc with base_id:'||lbase);
1183: END IF;
1184:

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 1205: fnd_file.put_line(fnd_file.log,l_processing_log || l_pers_number_log || l_person_number);

1201: OPEN c_person_number(l_all_base_id.base_id);
1202: FETCH c_person_number INTO l_person_number;
1203: CLOSE c_person_number;
1204:
1205: fnd_file.put_line(fnd_file.log,l_processing_log || l_pers_number_log || l_person_number);
1206: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1207: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_calc_im_efc.main.debug','calling calculate_efc with base_id:'||l_all_base_id.base_id);
1208: END IF;
1209: --calculate efc

Line 1218: fnd_file.put_line(fnd_file.output,' ');

1214: END IF;
1215:
1216: g_total := g_success + g_error;
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);

Line 1219: fnd_file.put_line(fnd_file.output, RPAD('-',50,'-'));

1215:
1216: g_total := g_success + g_error;
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');

Line 1220: fnd_file.put_line(fnd_file.output,' ');

1216: g_total := g_success + g_error;
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);

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 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 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 1227: fnd_file.put_line(fnd_file.output,' ');

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:
1231: fnd_file.put_line(fnd_file.log,' ');

Line 1228: fnd_file.put_line(fnd_file.output, RPAD('-',50,'-'));

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:
1231: fnd_file.put_line(fnd_file.log,' ');
1232: fnd_file.put_line(fnd_file.log, RPAD('-',50,'-'));

Line 1229: fnd_file.put_line(fnd_file.output,' ');

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

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

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

Line 1232: fnd_file.put_line(fnd_file.log, RPAD('-',50,'-'));

1228: fnd_file.put_line(fnd_file.output, RPAD('-',50,'-'));
1229: fnd_file.put_line(fnd_file.output,' ');
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');

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

1229: fnd_file.put_line(fnd_file.output,' ');
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);

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 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 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 1240: fnd_file.put_line(fnd_file.log,' ');

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:
1244: EXCEPTION

Line 1241: fnd_file.put_line(fnd_file.log, RPAD('-',50,'-'));

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:
1244: EXCEPTION
1245: WHEN OTHERS THEN

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

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:
1244: EXCEPTION
1245: WHEN OTHERS THEN
1246: retcode := 2;