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

Line 245: fnd_file.put_line(fnd_file.log,

241: 'IGS_FI_NO_TRX_PROCESSED');
242: fnd_message.set_token('TRX_TYPE',
243: lookup_desc('IGS_FI_SOURCE_TRANSACTION_TYPE',
244: p_trx_type));
245: fnd_file.put_line(fnd_file.log,
246: fnd_message.get);
247: END IF;
248: END update_log_norec;
249:

Line 280: fnd_file.put_line(fnd_file.log,' '||lookup_desc('IGS_FI_LOCKBOX','SOURCE_TRAN_TYPE')||' : '||

276: l_cr_account igs_lookups_view.meaning%TYPE;
277: BEGIN
278:
279: -- Log the Source Transaction Type in one single line
280: fnd_file.put_line(fnd_file.log,' '||lookup_desc('IGS_FI_LOCKBOX','SOURCE_TRAN_TYPE')||' : '||
281: lookup_desc('IGS_FI_SOURCE_TRANSACTION_TYPE',p_src_txn_type));
282:
283: -- Call the procedure for deriving the comments tand the Transaction Number
284: -- This is a common procedure which is also used in the Transfer Posting process

Line 291: fnd_file.put_line(fnd_file.log,

287: p_transaction_number => l_v_txn_num,
288: p_comments => l_v_comments);
289:
290: -- Log the Transaction Number
291: fnd_file.put_line(fnd_file.log,
292: ' '||lookup_desc('IGS_FI_LOCKBOX','TRANSACTION_NUM')||' : '||l_v_txn_num);
293: fnd_file.put_line(fnd_file.log,
294: ' '||lookup_desc('IGS_FI_LOCKBOX','TRANSACTION_DATE')||' : '||to_char(p_txn_date));
295: fnd_file.put_line(fnd_file.log,

Line 293: fnd_file.put_line(fnd_file.log,

289:
290: -- Log the Transaction Number
291: fnd_file.put_line(fnd_file.log,
292: ' '||lookup_desc('IGS_FI_LOCKBOX','TRANSACTION_NUM')||' : '||l_v_txn_num);
293: fnd_file.put_line(fnd_file.log,
294: ' '||lookup_desc('IGS_FI_LOCKBOX','TRANSACTION_DATE')||' : '||to_char(p_txn_date));
295: fnd_file.put_line(fnd_file.log,
296: ' '||lookup_desc('IGS_FI_LOCKBOX','AMOUNT')||' : '||to_char(p_amount));
297:

Line 295: fnd_file.put_line(fnd_file.log,

291: fnd_file.put_line(fnd_file.log,
292: ' '||lookup_desc('IGS_FI_LOCKBOX','TRANSACTION_NUM')||' : '||l_v_txn_num);
293: fnd_file.put_line(fnd_file.log,
294: ' '||lookup_desc('IGS_FI_LOCKBOX','TRANSACTION_DATE')||' : '||to_char(p_txn_date));
295: fnd_file.put_line(fnd_file.log,
296: ' '||lookup_desc('IGS_FI_LOCKBOX','AMOUNT')||' : '||to_char(p_amount));
297:
298:
299: l_dr_account := lookup_desc('IGS_FI_LOCKBOX','DR_ACCOUNT');

Line 302: fnd_file.put_line(fnd_file.log,

298:
299: l_dr_account := lookup_desc('IGS_FI_LOCKBOX','DR_ACCOUNT');
300: l_cr_account := lookup_desc('IGS_FI_LOCKBOX','CR_ACCOUNT');
301:
302: fnd_file.put_line(fnd_file.log,
303: ' '||l_dr_account||' : '||p_dr_acc_code);
304: fnd_file.put_line(fnd_file.log,
305: ' '||l_cr_account||' : '||p_cr_acc_code);
306: -- Put a new line

Line 304: fnd_file.put_line(fnd_file.log,

300: l_cr_account := lookup_desc('IGS_FI_LOCKBOX','CR_ACCOUNT');
301:
302: fnd_file.put_line(fnd_file.log,
303: ' '||l_dr_account||' : '||p_dr_acc_code);
304: fnd_file.put_line(fnd_file.log,
305: ' '||l_cr_account||' : '||p_cr_acc_code);
306: -- Put a new line
307:
308: fnd_file.put_line(fnd_file.log,'----------------------------------------------------------------------------------------------------');

Line 308: fnd_file.put_line(fnd_file.log,'----------------------------------------------------------------------------------------------------');

304: fnd_file.put_line(fnd_file.log,
305: ' '||l_cr_account||' : '||p_cr_acc_code);
306: -- Put a new line
307:
308: fnd_file.put_line(fnd_file.log,'----------------------------------------------------------------------------------------------------');
309: fnd_file.new_line(fnd_file.log);
310: END update_log_file;
311:
312: PROCEDURE transfer_credit_act_txns(

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

305: ' '||l_cr_account||' : '||p_cr_acc_code);
306: -- Put a new line
307:
308: fnd_file.put_line(fnd_file.log,'----------------------------------------------------------------------------------------------------');
309: fnd_file.new_line(fnd_file.log);
310: END update_log_file;
311:
312: PROCEDURE transfer_credit_act_txns(
313: p_d_gl_date_start IN igs_fi_posting_int_all.accounting_date%TYPE,

Line 480: fnd_file.put_line( fnd_file.log, fnd_message.get() || sqlerrm);

476: WHEN OTHERS THEN
477: fnd_message.set_name('IGS', 'IGS_GE_UNHANDLED_EXP');
478: --Unhandled Exception Raised in Procedure NAME
479: fnd_message.set_token('NAME','IGS_FI_POSTING_INTERFACE.TRANSFER_CREDIT_ACT_TXNS');
480: fnd_file.put_line( fnd_file.log, fnd_message.get() || sqlerrm);
481: app_exception.raise_exception;
482: END transfer_credit_act_txns;
483:
484:

Line 646: fnd_file.put_line( fnd_file.log, fnd_message.get() || sqlerrm);

642: WHEN OTHERS THEN
643: fnd_message.set_name('IGS', 'IGS_GE_UNHANDLED_EXP');
644: --Unhandled Exception Raised in Procedure NAME
645: fnd_message.set_token('NAME','IGS_FI_POSTING_INTERFACE.TRANSFER_APPL_TXNS');
646: fnd_file.put_line( fnd_file.log, fnd_message.get() || sqlerrm);
647: app_exception.raise_exception;
648:
649: END transfer_appl_txns;
650:

Line 836: fnd_file.put_line( fnd_file.log, fnd_message.get() || sqlerrm);

832: WHEN OTHERS THEN
833: fnd_message.set_name('IGS', 'IGS_GE_UNHANDLED_EXP');
834: --Unhandled Exception Raised in Procedure NAME
835: fnd_message.set_token('NAME','IGS_FI_POSTING_INTERFACE.TRANSFER_CHGS_TXNS');
836: fnd_file.put_line( fnd_file.log, fnd_message.get() || sqlerrm);
837: app_exception.raise_exception;
838: END transfer_chgs_txns;
839:
840: PROCEDURE transfer_ad_appl_fee_txns(

Line 993: fnd_file.put_line( fnd_file.log, fnd_message.get() || sqlerrm);

989: WHEN OTHERS THEN
990: fnd_message.set_name('IGS', 'IGS_GE_UNHANDLED_EXP');
991: --Unhandled Exception Raised in Procedure NAME
992: fnd_message.set_token('NAME','IGS_FI_POSTING_INTERFACE.TRANSFER_AD_APPL_FEE_TXNS');
993: fnd_file.put_line( fnd_file.log, fnd_message.get() || sqlerrm);
994: app_exception.raise_exception;
995: END transfer_ad_appl_fee_txns;
996:
997:

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

1188: BEGIN
1189:
1190: -- This process has been obsoleted as part of Commercial Receivables TD
1191: fnd_message.set_name('IGS', 'IGS_GE_OBSOLETE_JOB');
1192: fnd_file.put_line( fnd_file.log, fnd_message.get());
1193: retcode := 0;
1194:
1195: EXCEPTION
1196: WHEN OTHERS THEN

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

1244: l_org_id := NULL;
1245: igs_ge_gen_003.set_org_id(l_org_id);
1246: EXCEPTION
1247: WHEN OTHERS THEN
1248: fnd_file.put_line (fnd_file.log, fnd_message.get);
1249: retcode:=2;
1250: RETURN;
1251: END;
1252: retcode:= 0;

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

1257: p_v_message_name => l_v_message_name
1258: );
1259: IF (l_v_manage_acc = 'OTHER') OR (l_v_manage_acc IS NULL) THEN
1260: fnd_message.set_name('IGS',l_v_message_name);
1261: fnd_file.put_line(fnd_file.log,fnd_message.get());
1262: fnd_file.put_line(fnd_file.log,' ');
1263: RAISE l_user_exception;
1264: END IF;
1265:

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

1258: );
1259: IF (l_v_manage_acc = 'OTHER') OR (l_v_manage_acc IS NULL) THEN
1260: fnd_message.set_name('IGS',l_v_message_name);
1261: fnd_file.put_line(fnd_file.log,fnd_message.get());
1262: fnd_file.put_line(fnd_file.log,' ');
1263: RAISE l_user_exception;
1264: END IF;
1265:
1266: -- Get the value of of financials Insalled value defined in System Options form.

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

1267: IF igs_fi_gen_005.finp_get_receivables_inst = 'Y' THEN
1268: --This process is not valid. This process is only valid when using Oracle Financials "NO"
1269: fnd_message.set_name('IGS', 'IGS_FI_INVALID_PROCESS');
1270: fnd_message.set_token('YES_NO', lookup_desc('YES_NO','N'));
1271: fnd_file.put_line(fnd_file.log, fnd_message.get());
1272: RAISE l_user_exception;
1273: END IF;
1274:
1275: -- Convert the varchar2 parameter dates to DATE Datatype if not null else raise insufficient parameter error.

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

1277: IF p_posting_date_low IS NOT NULL THEN
1278: l_d_gl_date_start := igs_ge_date.igsdate(p_posting_date_low);
1279: ELSE
1280: fnd_message.set_name('IGS', 'IGS_GE_INSUFFICIENT_PARAMETER');
1281: fnd_file.put_line(fnd_file.log, fnd_message.get());
1282: RAISE l_user_exception;
1283: END IF;
1284:
1285: IF p_posting_date_high IS NOT NULL THEN

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

1285: IF p_posting_date_high IS NOT NULL THEN
1286: l_d_gl_date_end := igs_ge_date.igsdate(p_posting_date_high);
1287: ELSE
1288: fnd_message.set_name('IGS', 'IGS_GE_INSUFFICIENT_PARAMETER');
1289: fnd_file.put_line(fnd_file.log, fnd_message.get());
1290: RAISE l_user_exception;
1291: END IF;
1292:
1293: IF p_accounting_date IS NOT NULL THEN

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

1293: IF p_accounting_date IS NOT NULL THEN
1294: l_d_gl_posted_date := igs_ge_date.igsdate(p_accounting_date);
1295: ELSE
1296: fnd_message.set_name('IGS', 'IGS_GE_INSUFFICIENT_PARAMETER');
1297: fnd_file.put_line(fnd_file.log, fnd_message.get());
1298: RAISE l_user_exception;
1299: END IF;
1300:
1301:

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

1304:
1305: IF TRUNC(l_d_gl_date_start) > TRUNC(l_d_gl_date_end) THEN
1306: fnd_message.set_name('IGS','IGS_FI_VAL_GL_END_DATE');
1307: fnd_message.set_token('START_DATE',l_d_gl_date_start);
1308: fnd_file.put_line( fnd_file.log, fnd_message.get());
1309: RAISE l_user_exception;
1310: END IF;
1311:
1312: -- Generate the batch posting control - id only once per process run ()..

Line 1317: fnd_file.put_line(fnd_file.log,'----------------------------------------------------------------------------------------------------');

1313: OPEN cur_gen_control_id;
1314: FETCH cur_gen_control_id INTO g_n_posting_control_id;
1315: CLOSE cur_gen_control_id;
1316:
1317: fnd_file.put_line(fnd_file.log,'----------------------------------------------------------------------------------------------------');
1318: fnd_file.put_line(fnd_file.log, get_log_line('SYS_DATE',TO_CHAR(SYSDATE)));
1319: fnd_file.put_line(fnd_file.log, get_log_line('GL_DT_START',TO_CHAR(l_d_gl_date_start)));
1320: fnd_file.put_line(fnd_file.log, get_log_line('GL_DT_END',TO_CHAR(l_d_gl_date_end)));
1321: fnd_file.put_line(fnd_file.log, get_log_line('GL_POSTED_DT',TO_CHAR(l_d_gl_posted_date)));

Line 1318: fnd_file.put_line(fnd_file.log, get_log_line('SYS_DATE',TO_CHAR(SYSDATE)));

1314: FETCH cur_gen_control_id INTO g_n_posting_control_id;
1315: CLOSE cur_gen_control_id;
1316:
1317: fnd_file.put_line(fnd_file.log,'----------------------------------------------------------------------------------------------------');
1318: fnd_file.put_line(fnd_file.log, get_log_line('SYS_DATE',TO_CHAR(SYSDATE)));
1319: fnd_file.put_line(fnd_file.log, get_log_line('GL_DT_START',TO_CHAR(l_d_gl_date_start)));
1320: fnd_file.put_line(fnd_file.log, get_log_line('GL_DT_END',TO_CHAR(l_d_gl_date_end)));
1321: fnd_file.put_line(fnd_file.log, get_log_line('GL_POSTED_DT',TO_CHAR(l_d_gl_posted_date)));
1322: fnd_file.put_line(fnd_file.log, get_log_line('POSTING_CTRL_ID',TO_CHAR(g_n_posting_control_id)));

Line 1319: fnd_file.put_line(fnd_file.log, get_log_line('GL_DT_START',TO_CHAR(l_d_gl_date_start)));

1315: CLOSE cur_gen_control_id;
1316:
1317: fnd_file.put_line(fnd_file.log,'----------------------------------------------------------------------------------------------------');
1318: fnd_file.put_line(fnd_file.log, get_log_line('SYS_DATE',TO_CHAR(SYSDATE)));
1319: fnd_file.put_line(fnd_file.log, get_log_line('GL_DT_START',TO_CHAR(l_d_gl_date_start)));
1320: fnd_file.put_line(fnd_file.log, get_log_line('GL_DT_END',TO_CHAR(l_d_gl_date_end)));
1321: fnd_file.put_line(fnd_file.log, get_log_line('GL_POSTED_DT',TO_CHAR(l_d_gl_posted_date)));
1322: fnd_file.put_line(fnd_file.log, get_log_line('POSTING_CTRL_ID',TO_CHAR(g_n_posting_control_id)));
1323: fnd_file.put_line(fnd_file.log,'----------------------------------------------------------------------------------------------------');

Line 1320: fnd_file.put_line(fnd_file.log, get_log_line('GL_DT_END',TO_CHAR(l_d_gl_date_end)));

1316:
1317: fnd_file.put_line(fnd_file.log,'----------------------------------------------------------------------------------------------------');
1318: fnd_file.put_line(fnd_file.log, get_log_line('SYS_DATE',TO_CHAR(SYSDATE)));
1319: fnd_file.put_line(fnd_file.log, get_log_line('GL_DT_START',TO_CHAR(l_d_gl_date_start)));
1320: fnd_file.put_line(fnd_file.log, get_log_line('GL_DT_END',TO_CHAR(l_d_gl_date_end)));
1321: fnd_file.put_line(fnd_file.log, get_log_line('GL_POSTED_DT',TO_CHAR(l_d_gl_posted_date)));
1322: fnd_file.put_line(fnd_file.log, get_log_line('POSTING_CTRL_ID',TO_CHAR(g_n_posting_control_id)));
1323: fnd_file.put_line(fnd_file.log,'----------------------------------------------------------------------------------------------------');
1324:

Line 1321: fnd_file.put_line(fnd_file.log, get_log_line('GL_POSTED_DT',TO_CHAR(l_d_gl_posted_date)));

1317: fnd_file.put_line(fnd_file.log,'----------------------------------------------------------------------------------------------------');
1318: fnd_file.put_line(fnd_file.log, get_log_line('SYS_DATE',TO_CHAR(SYSDATE)));
1319: fnd_file.put_line(fnd_file.log, get_log_line('GL_DT_START',TO_CHAR(l_d_gl_date_start)));
1320: fnd_file.put_line(fnd_file.log, get_log_line('GL_DT_END',TO_CHAR(l_d_gl_date_end)));
1321: fnd_file.put_line(fnd_file.log, get_log_line('GL_POSTED_DT',TO_CHAR(l_d_gl_posted_date)));
1322: fnd_file.put_line(fnd_file.log, get_log_line('POSTING_CTRL_ID',TO_CHAR(g_n_posting_control_id)));
1323: fnd_file.put_line(fnd_file.log,'----------------------------------------------------------------------------------------------------');
1324:
1325:

Line 1322: fnd_file.put_line(fnd_file.log, get_log_line('POSTING_CTRL_ID',TO_CHAR(g_n_posting_control_id)));

1318: fnd_file.put_line(fnd_file.log, get_log_line('SYS_DATE',TO_CHAR(SYSDATE)));
1319: fnd_file.put_line(fnd_file.log, get_log_line('GL_DT_START',TO_CHAR(l_d_gl_date_start)));
1320: fnd_file.put_line(fnd_file.log, get_log_line('GL_DT_END',TO_CHAR(l_d_gl_date_end)));
1321: fnd_file.put_line(fnd_file.log, get_log_line('GL_POSTED_DT',TO_CHAR(l_d_gl_posted_date)));
1322: fnd_file.put_line(fnd_file.log, get_log_line('POSTING_CTRL_ID',TO_CHAR(g_n_posting_control_id)));
1323: fnd_file.put_line(fnd_file.log,'----------------------------------------------------------------------------------------------------');
1324:
1325:
1326: -- Log the heading for the log file "Summary of Transactions posted to Posting Interface"

Line 1323: fnd_file.put_line(fnd_file.log,'----------------------------------------------------------------------------------------------------');

1319: fnd_file.put_line(fnd_file.log, get_log_line('GL_DT_START',TO_CHAR(l_d_gl_date_start)));
1320: fnd_file.put_line(fnd_file.log, get_log_line('GL_DT_END',TO_CHAR(l_d_gl_date_end)));
1321: fnd_file.put_line(fnd_file.log, get_log_line('GL_POSTED_DT',TO_CHAR(l_d_gl_posted_date)));
1322: fnd_file.put_line(fnd_file.log, get_log_line('POSTING_CTRL_ID',TO_CHAR(g_n_posting_control_id)));
1323: fnd_file.put_line(fnd_file.log,'----------------------------------------------------------------------------------------------------');
1324:
1325:
1326: -- Log the heading for the log file "Summary of Transactions posted to Posting Interface"
1327: fnd_file.new_line(fnd_file.log);

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

1323: fnd_file.put_line(fnd_file.log,'----------------------------------------------------------------------------------------------------');
1324:
1325:
1326: -- Log the heading for the log file "Summary of Transactions posted to Posting Interface"
1327: fnd_file.new_line(fnd_file.log);
1328: fnd_file.put_line(fnd_file.log,'----------------------------------------------------------------------------------------------------');
1329: fnd_message.set_name('IGS','IGS_FI_POST_SUM_TRANS');
1330: fnd_file.put_line( fnd_file.log, fnd_message.get());
1331: fnd_file.put_line(fnd_file.log,'----------------------------------------------------------------------------------------------------');

Line 1328: fnd_file.put_line(fnd_file.log,'----------------------------------------------------------------------------------------------------');

1324:
1325:
1326: -- Log the heading for the log file "Summary of Transactions posted to Posting Interface"
1327: fnd_file.new_line(fnd_file.log);
1328: fnd_file.put_line(fnd_file.log,'----------------------------------------------------------------------------------------------------');
1329: fnd_message.set_name('IGS','IGS_FI_POST_SUM_TRANS');
1330: fnd_file.put_line( fnd_file.log, fnd_message.get());
1331: fnd_file.put_line(fnd_file.log,'----------------------------------------------------------------------------------------------------');
1332:

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

1326: -- Log the heading for the log file "Summary of Transactions posted to Posting Interface"
1327: fnd_file.new_line(fnd_file.log);
1328: fnd_file.put_line(fnd_file.log,'----------------------------------------------------------------------------------------------------');
1329: fnd_message.set_name('IGS','IGS_FI_POST_SUM_TRANS');
1330: fnd_file.put_line( fnd_file.log, fnd_message.get());
1331: fnd_file.put_line(fnd_file.log,'----------------------------------------------------------------------------------------------------');
1332:
1333: -- For both the cases, i.e. when Accounting Method is 'CASH' or 'ACCRUAL' the Credit Activities Transactions, Applications Transactions and Admission Application fees transactions need to be posted.
1334: -- For this invoke the local procedures TRANSFER_CREDIT_ACT_TXNS, TRANSFER_APPL_TXNS and TRANSFER_AD_APPL_FEE_TXNS.

Line 1331: fnd_file.put_line(fnd_file.log,'----------------------------------------------------------------------------------------------------');

1327: fnd_file.new_line(fnd_file.log);
1328: fnd_file.put_line(fnd_file.log,'----------------------------------------------------------------------------------------------------');
1329: fnd_message.set_name('IGS','IGS_FI_POST_SUM_TRANS');
1330: fnd_file.put_line( fnd_file.log, fnd_message.get());
1331: fnd_file.put_line(fnd_file.log,'----------------------------------------------------------------------------------------------------');
1332:
1333: -- For both the cases, i.e. when Accounting Method is 'CASH' or 'ACCRUAL' the Credit Activities Transactions, Applications Transactions and Admission Application fees transactions need to be posted.
1334: -- For this invoke the local procedures TRANSFER_CREDIT_ACT_TXNS, TRANSFER_APPL_TXNS and TRANSFER_AD_APPL_FEE_TXNS.
1335: -- Hence no derivation and checking of accounting method required at this stage.

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

1368: p_d_gl_posted_date => l_d_gl_posted_date);
1369: COMMIT;
1370: END IF;
1371:
1372: fnd_file.new_line(fnd_file.log);
1373: fnd_file.put_line(fnd_file.log,'----------------------------------------------------------------------------------------------------');
1374: fnd_message.set_name('IGS','IGS_GE_TOTAL_REC_PROCESSED');
1375: fnd_file.put_line(fnd_file.log, fnd_message.get()||TO_CHAR(g_n_rec_processed));
1376:

Line 1373: fnd_file.put_line(fnd_file.log,'----------------------------------------------------------------------------------------------------');

1369: COMMIT;
1370: END IF;
1371:
1372: fnd_file.new_line(fnd_file.log);
1373: fnd_file.put_line(fnd_file.log,'----------------------------------------------------------------------------------------------------');
1374: fnd_message.set_name('IGS','IGS_GE_TOTAL_REC_PROCESSED');
1375: fnd_file.put_line(fnd_file.log, fnd_message.get()||TO_CHAR(g_n_rec_processed));
1376:
1377: EXCEPTION

Line 1375: fnd_file.put_line(fnd_file.log, fnd_message.get()||TO_CHAR(g_n_rec_processed));

1371:
1372: fnd_file.new_line(fnd_file.log);
1373: fnd_file.put_line(fnd_file.log,'----------------------------------------------------------------------------------------------------');
1374: fnd_message.set_name('IGS','IGS_GE_TOTAL_REC_PROCESSED');
1375: fnd_file.put_line(fnd_file.log, fnd_message.get()||TO_CHAR(g_n_rec_processed));
1376:
1377: EXCEPTION
1378: WHEN l_user_exception THEN
1379: ROLLBACK;