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_MESSAGE

Line 240: fnd_message.set_name('IGS',

236: RETURN;
237: END IF;
238:
239: IF NOT p_flag THEN
240: fnd_message.set_name('IGS',
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));

Line 242: fnd_message.set_token('TRX_TYPE',

238:
239: IF NOT p_flag THEN
240: fnd_message.set_name('IGS',
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);

Line 246: fnd_message.get);

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:
250: PROCEDURE update_log_file(p_txn_date IN igs_fi_posting_int.transaction_date%TYPE,

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

473: END LOOP;
474:
475: EXCEPTION
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;

Line 479: fnd_message.set_token('NAME','IGS_FI_POSTING_INTERFACE.TRANSFER_CREDIT_ACT_TXNS');

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

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 643: fnd_message.set_name('IGS', 'IGS_GE_UNHANDLED_EXP');

639: END LOOP;
640:
641: EXCEPTION
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;

Line 645: fnd_message.set_token('NAME','IGS_FI_POSTING_INTERFACE.TRANSFER_APPL_TXNS');

641: EXCEPTION
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;

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 833: fnd_message.set_name('IGS', 'IGS_GE_UNHANDLED_EXP');

829: END LOOP;
830:
831: EXCEPTION
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;

Line 835: fnd_message.set_token('NAME','IGS_FI_POSTING_INTERFACE.TRANSFER_CHGS_TXNS');

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

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 990: fnd_message.set_name('IGS', 'IGS_GE_UNHANDLED_EXP');

986: END LOOP;
987:
988: EXCEPTION
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;

Line 992: fnd_message.set_token('NAME','IGS_FI_POSTING_INTERFACE.TRANSFER_AD_APPL_FEE_TXNS');

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

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 1191: fnd_message.set_name('IGS', 'IGS_GE_OBSOLETE_JOB');

1187:
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

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 1198: errbuf := fnd_message.get_string('IGS','IGS_GE_UNHANDLED_EXCEPTION')||SQLERRM;

1194:
1195: EXCEPTION
1196: WHEN OTHERS THEN
1197: retcode := 2;
1198: errbuf := fnd_message.get_string('IGS','IGS_GE_UNHANDLED_EXCEPTION')||SQLERRM;
1199: igs_ge_msg_stack.conc_exception_hndl;
1200:
1201: END transfer_posting;
1202:

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 1260: fnd_message.set_name('IGS',l_v_message_name);

1256: igs_fi_com_rec_interface.chk_manage_account( p_v_manage_acc => l_v_manage_acc,
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;

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 1269: fnd_message.set_name('IGS', 'IGS_FI_INVALID_PROCESS');

1265:
1266: -- Get the value of of financials Insalled value defined in System Options form.
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;

Line 1270: fnd_message.set_token('YES_NO', lookup_desc('YES_NO','N'));

1266: -- Get the value of of financials Insalled value defined in System Options form.
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:

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 1280: fnd_message.set_name('IGS', 'IGS_GE_INSUFFICIENT_PARAMETER');

1276:
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:

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 1288: fnd_message.set_name('IGS', 'IGS_GE_INSUFFICIENT_PARAMETER');

1284:
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:

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 1296: fnd_message.set_name('IGS', 'IGS_GE_INSUFFICIENT_PARAMETER');

1292:
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:

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 1306: fnd_message.set_name('IGS','IGS_FI_VAL_GL_END_DATE');

1302: -- Validate if the GL date End is lesser than GL Date start
1303: -- The GL Date End should not be earlier than the GL Date Start 'START_DATE'
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;

Line 1307: fnd_message.set_token('START_DATE',l_d_gl_date_start);

1303: -- The GL Date End should not be earlier than the GL Date Start 'START_DATE'
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:

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 1329: fnd_message.set_name('IGS','IGS_FI_POST_SUM_TRANS');

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:
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.

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 1374: fnd_message.set_name('IGS','IGS_GE_TOTAL_REC_PROCESSED');

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
1378: WHEN l_user_exception THEN

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;

Line 1384: errbuf := fnd_message.get_string('IGS','IGS_GE_UNHANDLED_EXCEPTION')||sqlerrm;

1380: retcode := 2;
1381: WHEN OTHERS THEN
1382: ROLLBACK;
1383: retcode := 2;
1384: errbuf := fnd_message.get_string('IGS','IGS_GE_UNHANDLED_EXCEPTION')||sqlerrm;
1385: igs_ge_msg_stack.conc_exception_hndl;
1386: END posting_interface;
1387:
1388: