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

Line 593: fnd_file.put_line(fnd_file.log,

589: p_desc => l_v_crd_desc);
590: EXCEPTION
591: WHEN OTHERS THEN
592: l_b_exception_flag := TRUE;
593: fnd_file.put_line(fnd_file.log,
594: sqlerrm);
595: END;
596:
597: -- Update the Credit Activity record with the batch identifier generated the posted date.

Line 700: fnd_file.put_line(fnd_file.log,

696: EXCEPTION
697: WHEN OTHERS THEN
698: ROLLBACK TO SP_INV1;
699: l_b_exception_flag := TRUE;
700: fnd_file.put_line(fnd_file.log,
701: sqlerrm);
702: END;
703:
704: IF NOT l_b_exception_flag THEN

Line 841: fnd_file.put_line(fnd_file.log,

837: EXCEPTION
838: WHEN OTHERS THEN
839: ROLLBACK TO SP_APP1;
840: l_b_exception_flag := TRUE;
841: fnd_file.put_line(fnd_file.log,
842: sqlerrm);
843: END;
844:
845: -- If there is no error in creation of the transaction in the GL Interface table,

Line 941: fnd_file.put_line(fnd_file.log,

937: EXCEPTION
938: WHEN OTHERS THEN
939: ROLLBACK TO SP_ADAPP1;
940: l_b_exception_flag := TRUE;
941: fnd_file.put_line(fnd_file.log,
942: sqlerrm);
943: END;
944:
945: -- If there is no error in creating transaction in the GL Interface table,

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

1069: FETCH cur_sob INTO l_v_sob_name;
1070: CLOSE cur_sob;
1071:
1072: -- Log the values for the parameters to the process
1073: fnd_file.put_line(fnd_file.log, ' ');
1074: fnd_message.set_name('IGS',
1075: 'IGS_FI_ANC_LOG_PARM');
1076: fnd_file.put_line(fnd_file.log,
1077: fnd_message.get);

Line 1076: fnd_file.put_line(fnd_file.log,

1072: -- Log the values for the parameters to the process
1073: fnd_file.put_line(fnd_file.log, ' ');
1074: fnd_message.set_name('IGS',
1075: 'IGS_FI_ANC_LOG_PARM');
1076: fnd_file.put_line(fnd_file.log,
1077: fnd_message.get);
1078:
1079: fnd_file.new_line(fnd_file.log);
1080: fnd_file.put_line(fnd_file.log,

Line 1079: fnd_file.new_line(fnd_file.log);

1075: 'IGS_FI_ANC_LOG_PARM');
1076: fnd_file.put_line(fnd_file.log,
1077: fnd_message.get);
1078:
1079: fnd_file.new_line(fnd_file.log);
1080: fnd_file.put_line(fnd_file.log,
1081: get_log_details('SET_OF_BOOKS',l_v_sob_name));
1082: fnd_file.put_line(fnd_file.log,
1083: get_log_details('SYS_DATE', sysdate));

Line 1080: fnd_file.put_line(fnd_file.log,

1076: fnd_file.put_line(fnd_file.log,
1077: fnd_message.get);
1078:
1079: fnd_file.new_line(fnd_file.log);
1080: fnd_file.put_line(fnd_file.log,
1081: get_log_details('SET_OF_BOOKS',l_v_sob_name));
1082: fnd_file.put_line(fnd_file.log,
1083: get_log_details('SYS_DATE', sysdate));
1084: fnd_file.put_line(fnd_file.log,

Line 1082: fnd_file.put_line(fnd_file.log,

1078:
1079: fnd_file.new_line(fnd_file.log);
1080: fnd_file.put_line(fnd_file.log,
1081: get_log_details('SET_OF_BOOKS',l_v_sob_name));
1082: fnd_file.put_line(fnd_file.log,
1083: get_log_details('SYS_DATE', sysdate));
1084: fnd_file.put_line(fnd_file.log,
1085: get_log_details('GL_DT_START',p_d_gl_date_start));
1086: fnd_file.put_line(fnd_file.log,

Line 1084: fnd_file.put_line(fnd_file.log,

1080: fnd_file.put_line(fnd_file.log,
1081: get_log_details('SET_OF_BOOKS',l_v_sob_name));
1082: fnd_file.put_line(fnd_file.log,
1083: get_log_details('SYS_DATE', sysdate));
1084: fnd_file.put_line(fnd_file.log,
1085: get_log_details('GL_DT_START',p_d_gl_date_start));
1086: fnd_file.put_line(fnd_file.log,
1087: get_log_details('GL_DT_END',p_d_gl_date_end));
1088: fnd_file.put_line(fnd_file.log,

Line 1086: fnd_file.put_line(fnd_file.log,

1082: fnd_file.put_line(fnd_file.log,
1083: get_log_details('SYS_DATE', sysdate));
1084: fnd_file.put_line(fnd_file.log,
1085: get_log_details('GL_DT_START',p_d_gl_date_start));
1086: fnd_file.put_line(fnd_file.log,
1087: get_log_details('GL_DT_END',p_d_gl_date_end));
1088: fnd_file.put_line(fnd_file.log,
1089: get_log_details('POSTING_DETAIL',
1090: igs_fi_gen_gl.get_lkp_meaning('IGS_FI_POSTING_DETAIL',

Line 1088: fnd_file.put_line(fnd_file.log,

1084: fnd_file.put_line(fnd_file.log,
1085: get_log_details('GL_DT_START',p_d_gl_date_start));
1086: fnd_file.put_line(fnd_file.log,
1087: get_log_details('GL_DT_END',p_d_gl_date_end));
1088: fnd_file.put_line(fnd_file.log,
1089: get_log_details('POSTING_DETAIL',
1090: igs_fi_gen_gl.get_lkp_meaning('IGS_FI_POSTING_DETAIL',
1091: p_v_post_detail)));
1092: fnd_file.put_line(fnd_file.log,

Line 1092: fnd_file.put_line(fnd_file.log,

1088: fnd_file.put_line(fnd_file.log,
1089: get_log_details('POSTING_DETAIL',
1090: igs_fi_gen_gl.get_lkp_meaning('IGS_FI_POSTING_DETAIL',
1091: p_v_post_detail)));
1092: fnd_file.put_line(fnd_file.log,
1093: get_log_details('GL_POSTED_DT',p_d_gl_date_posted));
1094: fnd_file.put_line(fnd_file.log,
1095: get_log_details('RUN_JNL_IMP',
1096: igs_fi_gen_gl.get_lkp_meaning('YES_NO',

Line 1094: fnd_file.put_line(fnd_file.log,

1090: igs_fi_gen_gl.get_lkp_meaning('IGS_FI_POSTING_DETAIL',
1091: p_v_post_detail)));
1092: fnd_file.put_line(fnd_file.log,
1093: get_log_details('GL_POSTED_DT',p_d_gl_date_posted));
1094: fnd_file.put_line(fnd_file.log,
1095: get_log_details('RUN_JNL_IMP',
1096: igs_fi_gen_gl.get_lkp_meaning('YES_NO',
1097: p_v_jrnl_import)));
1098: fnd_file.put_line(fnd_file.log,

Line 1098: fnd_file.put_line(fnd_file.log,

1094: fnd_file.put_line(fnd_file.log,
1095: get_log_details('RUN_JNL_IMP',
1096: igs_fi_gen_gl.get_lkp_meaning('YES_NO',
1097: p_v_jrnl_import)));
1098: fnd_file.put_line(fnd_file.log,
1099: get_log_details('POSTING_CTRL_ID',g_n_batch_id));
1100:
1101: fnd_file.new_line(fnd_file.log);
1102:

Line 1101: fnd_file.new_line(fnd_file.log);

1097: p_v_jrnl_import)));
1098: fnd_file.put_line(fnd_file.log,
1099: get_log_details('POSTING_CTRL_ID',g_n_batch_id));
1100:
1101: fnd_file.new_line(fnd_file.log);
1102:
1103: -- Added the code here to exit from this procedure if the Receivables is not installed
1104: -- If validations of igs_fi_control fails then log the corresponding message and return.
1105: IF NOT l_b_val_parm THEN

Line 1110: fnd_file.put_line ( fnd_file.LOG, fnd_message.get );

1106: fnd_message.set_name ( 'IGS', l_v_message_name );
1107: IF l_v_message_name = 'IGS_FI_INVALID_PROCESS' THEN
1108: fnd_message.set_token('YES_NO', igs_fi_gen_gl.get_lkp_meaning('YES_NO', 'Y'));
1109: END IF;
1110: fnd_file.put_line ( fnd_file.LOG, fnd_message.get );
1111: RETURN l_b_val_parm;
1112: END IF;
1113:
1114: -- Check the value of Manage Accounts System Option value.

Line 1121: fnd_file.put_line ( fnd_file.LOG, fnd_message.get );

1117: igs_fi_com_rec_interface.chk_manage_account ( p_v_manage_acc => l_v_manage_accounts,
1118: p_v_message_name => l_v_message_name );
1119: IF l_v_manage_accounts IS NULL OR l_v_manage_accounts = 'OTHER' THEN
1120: fnd_message.set_name ( 'IGS', l_v_message_name );
1121: fnd_file.put_line ( fnd_file.LOG, fnd_message.get );
1122: RETURN FALSE;
1123: END IF;
1124:
1125: -- If any of the parameters is NULL, then log the error in the log file

Line 1132: fnd_file.put_line(fnd_file.log,

1128: (p_v_post_detail IS NULL) OR
1129: (p_d_gl_date_posted IS NULL) OR
1130: (p_v_jrnl_import IS NULL)) THEN
1131: fnd_message.set_name('IGS','IGS_FI_PARAMETER_NULL');
1132: fnd_file.put_line(fnd_file.log,
1133: fnd_message.get);
1134: l_b_val_parm := FALSE;
1135: END IF;
1136:

Line 1144: fnd_file.put_line(fnd_file.log,

1140: fnd_message.set_name('IGS',
1141: 'IGS_FI_VAL_GL_END_DATE');
1142: fnd_message.set_token('START_DATE',
1143: TRUNC(p_d_gl_date_start));
1144: fnd_file.put_line(fnd_file.log,
1145: fnd_message.get);
1146: l_b_val_parm := FALSE;
1147: END IF;
1148:

Line 1158: fnd_file.put_line(fnd_file.log,

1154: FETCH cur_glp INTO l_v_period_name, l_d_end_date;
1155: IF cur_glp%NOTFOUND THEN
1156: fnd_message.set_name('IGS',
1157: 'IGS_FI_NO_OPEN_PERIOD');
1158: fnd_file.put_line(fnd_file.log,
1159: fnd_message.get);
1160: l_b_val_parm := FALSE;
1161: END IF;
1162: CLOSE cur_glp;

Line 1172: fnd_file.put_line(fnd_file.log,

1168: p_d_gl_date_start);
1169: fnd_message.set_token('PERIOD',
1170: l_v_period_name);
1171:
1172: fnd_file.put_line(fnd_file.log,
1173: fnd_message.get);
1174: l_b_val_parm := FALSE;
1175: END IF;
1176:

Line 1190: fnd_file.put_line(fnd_file.log,

1186: FETCH cur_glp INTO l_v_period_name, l_d_end_date;
1187: IF cur_glp%NOTFOUND THEN
1188: fnd_message.set_name('IGS',
1189: 'IGS_FI_GL_NO_OPEN_PERIOD');
1190: fnd_file.put_line(fnd_file.log,
1191: fnd_message.get);
1192: l_b_val_parm := FALSE;
1193: END IF;
1194: CLOSE cur_glp;

Line 1208: fnd_file.put_line(fnd_file.log,

1204: p_d_gl_date_start);
1205: fnd_message.set_token('PERIOD',
1206: l_v_period_name);
1207: l_log_line := l_log_line||fnd_message.get;
1208: fnd_file.put_line(fnd_file.log,
1209: l_log_line);
1210: l_b_val_parm := FALSE;
1211: END IF;
1212: END IF;

Line 1221: fnd_file.put_line(fnd_file.log,

1217: IF NOT igs_lookups_view_pkg.get_pk_for_validation('IGS_FI_POSTING_DETAIL',
1218: p_v_post_detail) THEN
1219: fnd_message.set_name('IGS',
1220: 'IGS_FI_INV_POSTING_DETAIL');
1221: fnd_file.put_line(fnd_file.log,
1222: fnd_message.get);
1223: l_b_val_parm := FALSE;
1224: END IF;
1225: END IF;

Line 1233: fnd_file.put_line(fnd_file.log,

1229: IF NOT igs_lookups_view_pkg.get_pk_for_validation('YES_NO',
1230: p_v_jrnl_import) THEN
1231: fnd_message.set_name('IGS',
1232: 'IGS_FI_INV_JNL_IMPORT');
1233: fnd_file.put_line(fnd_file.log,
1234: fnd_message.get);
1235: l_b_val_parm := FALSE;
1236: END IF;
1237: END IF;

Line 1343: fnd_file.new_line(fnd_file.log);

1339: FOR l_n_cntr IN 1..80 LOOP
1340: l_v_line_txt := l_v_line_txt||'-';
1341: END LOOP;
1342:
1343: fnd_file.new_line(fnd_file.log);
1344:
1345: fnd_message.set_name('IGS',
1346: 'IGS_FI_SUM_GL_TRX');
1347: fnd_file.put_line(fnd_file.log,

Line 1347: fnd_file.put_line(fnd_file.log,

1343: fnd_file.new_line(fnd_file.log);
1344:
1345: fnd_message.set_name('IGS',
1346: 'IGS_FI_SUM_GL_TRX');
1347: fnd_file.put_line(fnd_file.log,
1348: fnd_message.get);
1349: fnd_file.put_line(fnd_file.log,
1350: l_v_line_txt);
1351:

Line 1349: fnd_file.put_line(fnd_file.log,

1345: fnd_message.set_name('IGS',
1346: 'IGS_FI_SUM_GL_TRX');
1347: fnd_file.put_line(fnd_file.log,
1348: fnd_message.get);
1349: fnd_file.put_line(fnd_file.log,
1350: l_v_line_txt);
1351:
1352: -- Loop across the GL Interface table
1353: FOR glrec IN cur_glint(g_n_batch_id,

Line 1360: fnd_file.put_line(fnd_file.log,

1356: l_n_dr_amnt := NVL(l_n_dr_amnt,0) + NVL(glrec.dr_amnt,0);
1357: l_n_cr_amnt := NVL(l_n_cr_amnt,0) + NVL(glrec.cr_amnt,0);
1358:
1359: -- Log the debit and the credit amount category wise
1360: fnd_file.put_line(fnd_file.log,
1361: get_log_details('CATEGORY',glrec.user_je_category_name));
1362: fnd_file.put_line(fnd_file.log,
1363: get_log_details('ENT_DEBITS',glrec.dr_amnt));
1364: fnd_file.put_line(fnd_file.log,

Line 1362: fnd_file.put_line(fnd_file.log,

1358:
1359: -- Log the debit and the credit amount category wise
1360: fnd_file.put_line(fnd_file.log,
1361: get_log_details('CATEGORY',glrec.user_je_category_name));
1362: fnd_file.put_line(fnd_file.log,
1363: get_log_details('ENT_DEBITS',glrec.dr_amnt));
1364: fnd_file.put_line(fnd_file.log,
1365: get_log_details('ENT_CREDITS',glrec.cr_amnt));
1366: fnd_file.new_line(fnd_file.log);

Line 1364: fnd_file.put_line(fnd_file.log,

1360: fnd_file.put_line(fnd_file.log,
1361: get_log_details('CATEGORY',glrec.user_je_category_name));
1362: fnd_file.put_line(fnd_file.log,
1363: get_log_details('ENT_DEBITS',glrec.dr_amnt));
1364: fnd_file.put_line(fnd_file.log,
1365: get_log_details('ENT_CREDITS',glrec.cr_amnt));
1366: fnd_file.new_line(fnd_file.log);
1367:
1368: -- Set the value of the global variable g_b_rec_found to TRUE

Line 1366: fnd_file.new_line(fnd_file.log);

1362: fnd_file.put_line(fnd_file.log,
1363: get_log_details('ENT_DEBITS',glrec.dr_amnt));
1364: fnd_file.put_line(fnd_file.log,
1365: get_log_details('ENT_CREDITS',glrec.cr_amnt));
1366: fnd_file.new_line(fnd_file.log);
1367:
1368: -- Set the value of the global variable g_b_rec_found to TRUE
1369: g_b_rec_found := TRUE;
1370: END LOOP;

Line 1372: fnd_file.new_line(fnd_file.log);

1368: -- Set the value of the global variable g_b_rec_found to TRUE
1369: g_b_rec_found := TRUE;
1370: END LOOP;
1371:
1372: fnd_file.new_line(fnd_file.log);
1373:
1374: -- Log the total entered debits and credits. If no data has been
1375: -- created in the GL_INTERFACE table,then log the message NO
1376: -- DATA FOUND

Line 1378: fnd_file.put_line(fnd_file.log,

1374: -- Log the total entered debits and credits. If no data has been
1375: -- created in the GL_INTERFACE table,then log the message NO
1376: -- DATA FOUND
1377: IF g_b_rec_found THEN
1378: fnd_file.put_line(fnd_file.log,
1379: l_v_line_txt);
1380: fnd_file.put_line(fnd_file.log,
1381: get_log_details('TOT_ENT_DEBITS',l_n_dr_amnt));
1382: fnd_file.put_line(fnd_file.log,

Line 1380: fnd_file.put_line(fnd_file.log,

1376: -- DATA FOUND
1377: IF g_b_rec_found THEN
1378: fnd_file.put_line(fnd_file.log,
1379: l_v_line_txt);
1380: fnd_file.put_line(fnd_file.log,
1381: get_log_details('TOT_ENT_DEBITS',l_n_dr_amnt));
1382: fnd_file.put_line(fnd_file.log,
1383: get_log_details('TOT_ENT_CREDITS',l_n_cr_amnt));
1384: ELSE

Line 1382: fnd_file.put_line(fnd_file.log,

1378: fnd_file.put_line(fnd_file.log,
1379: l_v_line_txt);
1380: fnd_file.put_line(fnd_file.log,
1381: get_log_details('TOT_ENT_DEBITS',l_n_dr_amnt));
1382: fnd_file.put_line(fnd_file.log,
1383: get_log_details('TOT_ENT_CREDITS',l_n_cr_amnt));
1384: ELSE
1385: fnd_message.set_name('IGS',
1386: 'IGS_GE_NO_DATA_FOUND');

Line 1387: fnd_file.put_line(fnd_file.log,

1383: get_log_details('TOT_ENT_CREDITS',l_n_cr_amnt));
1384: ELSE
1385: fnd_message.set_name('IGS',
1386: 'IGS_GE_NO_DATA_FOUND');
1387: fnd_file.put_line(fnd_file.log,
1388: fnd_message.get);
1389: END IF;
1390: END generate_log;
1391:

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

1424: l_org_id := NULL;
1425: igs_ge_gen_003.set_org_id(l_org_id);
1426: EXCEPTION
1427: WHEN OTHERS THEN
1428: fnd_file.put_line (fnd_file.log, fnd_message.get);
1429: RETCODE:=2;
1430: RETURN;
1431: END;
1432:

Line 1492: fnd_file.put_line(fnd_file.log,

1488: 'IGS_FI_UNABLE_TO_SUB_GL_IMP');
1489: ELSE
1490:
1491: -- Else log the request identifier
1492: fnd_file.put_line(fnd_file.log,
1493: get_log_details('REQ_ID',l_n_req_id));
1494: END IF;
1495: ELSE
1496:

Line 1501: fnd_file.put_line(fnd_file.log,

1497: -- Else if the run journal import parameter is No, then log a message to indicate that
1498: -- the user should manually run the Journal Import process
1499: fnd_message.set_name('IGS',
1500: 'IGS_FI_RUN_IMP_JNL');
1501: fnd_file.put_line(fnd_file.log,
1502: fnd_message.get);
1503: END IF;
1504: END IF;
1505: EXCEPTION

Line 1511: fnd_file.put_line(fnd_file.log,

1507: retcode := 2;
1508: fnd_message.set_name('IGS',
1509: 'IGS_GE_UNHANDLED_EXCEPTION');
1510: errbuf := fnd_message.get;
1511: fnd_file.put_line(fnd_file.log,
1512: sqlerrm);
1513: igs_ge_msg_stack.conc_exception_hndl;
1514: END transfer;
1515: