DBA Data[Home] [Help]

APPS.IGS_FI_PRC_BALANCES dependencies on FND_MESSAGE

Line 419: FND_MESSAGE.Set_Name('IGS',

415:
416: -- This concurrent job is made obsolete as part of Enh#2562745. If user tried to
417: -- run the program then an error message should be written to the Log file that
418: -- the Concurrent Program is obsolete and this should not be run
419: FND_MESSAGE.Set_Name('IGS',
420: 'IGS_GE_OBSOLETE_JOB');
421: FND_FILE.Put_Line(FND_FILE.Log,
422: FND_MESSAGE.Get);
423: retcode := 0;

Line 422: FND_MESSAGE.Get);

418: -- the Concurrent Program is obsolete and this should not be run
419: FND_MESSAGE.Set_Name('IGS',
420: 'IGS_GE_OBSOLETE_JOB');
421: FND_FILE.Put_Line(FND_FILE.Log,
422: FND_MESSAGE.Get);
423: retcode := 0;
424:
425: EXCEPTION
426: WHEN OTHERS THEN

Line 428: ERRBUF:=FND_MESSAGE.GET_STRING('IGS','IGS_GE_UNHANDLED_EXCEPTION');

424:
425: EXCEPTION
426: WHEN OTHERS THEN
427: RETCODE:=2;
428: ERRBUF:=FND_MESSAGE.GET_STRING('IGS','IGS_GE_UNHANDLED_EXCEPTION');
429: IGS_GE_MSG_STACK.CONC_EXCEPTION_HNDL;
430:
431: END calc_balances ; /* procedure ends here */
432:

Line 1135: p_c_message := FND_MESSAGE.GET;

1131: ) ;
1132: EXCEPTION
1133: WHEN OTHERS THEN
1134: -- log the error message returned by the tbh
1135: p_c_message := FND_MESSAGE.GET;
1136: RETURN FALSE;
1137: END;
1138: ELSIF p_c_balance_type = 'FEE'
1139: THEN

Line 1158: p_c_message := FND_MESSAGE.GET;

1154: ) ;
1155: EXCEPTION
1156: WHEN OTHERS THEN
1157: -- log the error message returned by the tbh
1158: p_c_message := FND_MESSAGE.GET;
1159: RETURN FALSE;
1160: END;
1161: ELSIF p_c_balance_type = 'HOLDS'
1162: THEN

Line 1181: p_c_message := FND_MESSAGE.GET;

1177: ) ;
1178: EXCEPTION
1179: WHEN OTHERS THEN
1180: -- log the error message returned by the tbh
1181: p_c_message := FND_MESSAGE.GET;
1182: RETURN FALSE;
1183: END;
1184: END IF;
1185: END LOOP;

Line 1270: fnd_message.set_name('IGS','IGS_FI_SYSTEM_OPT_SETUP');

1266: );
1267: COMMIT;
1268: CLOSE c_get_data;
1269: ELSE
1270: fnd_message.set_name('IGS','IGS_FI_SYSTEM_OPT_SETUP');
1271: fnd_file.put_line(fnd_file.log,fnd_message.get());
1272: fnd_file.put_line(FND_FILE.LOG,' ');
1273: app_exception.raise_exception;
1274: END IF;

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

1267: COMMIT;
1268: CLOSE c_get_data;
1269: ELSE
1270: fnd_message.set_name('IGS','IGS_FI_SYSTEM_OPT_SETUP');
1271: fnd_file.put_line(fnd_file.log,fnd_message.get());
1272: fnd_file.put_line(FND_FILE.LOG,' ');
1273: app_exception.raise_exception;
1274: END IF;
1275:

Line 1350: fnd_message.set_name('IGS','IGS_GE_INSUFFICIENT_PARAMETER');

1346: BEGIN
1347:
1348: -- if conversion start date is not given, then error out
1349: IF p_conv_st_date IS NULL THEN
1350: fnd_message.set_name('IGS','IGS_GE_INSUFFICIENT_PARAMETER');
1351: fnd_file.put_line(fnd_file.log,fnd_message.get());
1352: fnd_file.put_line(FND_FILE.LOG,' ');
1353: RAISE l_validation_exp;
1354: END IF;

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

1347:
1348: -- if conversion start date is not given, then error out
1349: IF p_conv_st_date IS NULL THEN
1350: fnd_message.set_name('IGS','IGS_GE_INSUFFICIENT_PARAMETER');
1351: fnd_file.put_line(fnd_file.log,fnd_message.get());
1352: fnd_file.put_line(FND_FILE.LOG,' ');
1353: RAISE l_validation_exp;
1354: END IF;
1355:

Line 1358: fnd_message.set_name('IGS','IGS_FI_CONV_GT_SYSDT');

1354: END IF;
1355:
1356: -- conversion start date should not be greater than sysdate
1357: IF TRUNC(p_conv_st_date) > TRUNC(SYSDATE) THEN
1358: fnd_message.set_name('IGS','IGS_FI_CONV_GT_SYSDT');
1359: fnd_file.put_line(fnd_file.log,fnd_message.get());
1360: fnd_file.put_line(FND_FILE.LOG,' ');
1361: RAISE l_validation_exp;
1362: END IF;

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

1355:
1356: -- conversion start date should not be greater than sysdate
1357: IF TRUNC(p_conv_st_date) > TRUNC(SYSDATE) THEN
1358: fnd_message.set_name('IGS','IGS_FI_CONV_GT_SYSDT');
1359: fnd_file.put_line(fnd_file.log,fnd_message.get());
1360: fnd_file.put_line(FND_FILE.LOG,' ');
1361: RAISE l_validation_exp;
1362: END IF;
1363:

Line 1369: fnd_message.set_name('IGS',l_message_name_1);

1365: IGS_FI_GEN_007.finp_get_conv_prc_run_ind( p_n_conv_process_run_ind => l_conv_process_run_ind,
1366: p_v_message_name => l_message_name_1) ;
1367:
1368: IF l_message_name_1 IS NOT NULL THEN
1369: fnd_message.set_name('IGS',l_message_name_1);
1370: fnd_file.put_line(fnd_file.log,fnd_message.get());
1371: fnd_file.put_line(FND_FILE.LOG,' ');
1372: RAISE l_validation_exp;
1373: END IF;

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

1366: p_v_message_name => l_message_name_1) ;
1367:
1368: IF l_message_name_1 IS NOT NULL THEN
1369: fnd_message.set_name('IGS',l_message_name_1);
1370: fnd_file.put_line(fnd_file.log,fnd_message.get());
1371: fnd_file.put_line(FND_FILE.LOG,' ');
1372: RAISE l_validation_exp;
1373: END IF;
1374:

Line 1377: fnd_message.set_name('IGS','IGS_FI_REASS_BAL_PRC_RUN');

1373: END IF;
1374:
1375: -- indicator = 1 if the process is already running
1376: IF l_conv_process_run_ind = 1 THEN
1377: fnd_message.set_name('IGS','IGS_FI_REASS_BAL_PRC_RUN');
1378: fnd_file.put_line(fnd_file.log,fnd_message.get());
1379: fnd_file.put_line(FND_FILE.LOG,' ');
1380: RAISE l_validation_exp;
1381: -- if indicator <> 1, then make it 1 to show that the process will be run now

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

1374:
1375: -- indicator = 1 if the process is already running
1376: IF l_conv_process_run_ind = 1 THEN
1377: fnd_message.set_name('IGS','IGS_FI_REASS_BAL_PRC_RUN');
1378: fnd_file.put_line(fnd_file.log,fnd_message.get());
1379: fnd_file.put_line(FND_FILE.LOG,' ');
1380: RAISE l_validation_exp;
1381: -- if indicator <> 1, then make it 1 to show that the process will be run now
1382: ELSIF l_conv_process_run_ind = 0 THEN

Line 1395: fnd_message.set_name('IGS','IGS_FI_NO_BAL_CONV');

1391: p_n_version_number => l_version_number);
1392: -- 1
1393: IF l_version_number = 0 THEN
1394: -- means no balance rule has been defined, so error out
1395: fnd_message.set_name('IGS','IGS_FI_NO_BAL_CONV');
1396: fnd_file.put_line(fnd_file.log,fnd_message.get());
1397: fnd_file.put_line(FND_FILE.LOG,' ');
1398:
1399: finpl_upd_conv_prc_run_ind(0); -- to update the run indicator back to 0 before erroring out

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

1392: -- 1
1393: IF l_version_number = 0 THEN
1394: -- means no balance rule has been defined, so error out
1395: fnd_message.set_name('IGS','IGS_FI_NO_BAL_CONV');
1396: fnd_file.put_line(fnd_file.log,fnd_message.get());
1397: fnd_file.put_line(FND_FILE.LOG,' ');
1398:
1399: finpl_upd_conv_prc_run_ind(0); -- to update the run indicator back to 0 before erroring out
1400: RAISE l_validation_exp;

Line 1407: fnd_message.set_name('IGS','IGS_FI_PD_LE_INP_DT');

1403:
1404: -- 2
1405: IF ( (l_last_conv_dt IS NOT NULL) AND (TRUNC(p_conv_st_date) > TRUNC(l_last_conv_dt)) ) THEN
1406:
1407: fnd_message.set_name('IGS','IGS_FI_PD_LE_INP_DT');
1408: fnd_message.set_token('DATE1',l_last_conv_dt);
1409: fnd_message.set_token('DATE2',p_conv_st_date);
1410: fnd_file.put_line(fnd_file.log,fnd_message.get());
1411: fnd_file.put_line(FND_FILE.LOG,' ');

Line 1408: fnd_message.set_token('DATE1',l_last_conv_dt);

1404: -- 2
1405: IF ( (l_last_conv_dt IS NOT NULL) AND (TRUNC(p_conv_st_date) > TRUNC(l_last_conv_dt)) ) THEN
1406:
1407: fnd_message.set_name('IGS','IGS_FI_PD_LE_INP_DT');
1408: fnd_message.set_token('DATE1',l_last_conv_dt);
1409: fnd_message.set_token('DATE2',p_conv_st_date);
1410: fnd_file.put_line(fnd_file.log,fnd_message.get());
1411: fnd_file.put_line(FND_FILE.LOG,' ');
1412:

Line 1409: fnd_message.set_token('DATE2',p_conv_st_date);

1405: IF ( (l_last_conv_dt IS NOT NULL) AND (TRUNC(p_conv_st_date) > TRUNC(l_last_conv_dt)) ) THEN
1406:
1407: fnd_message.set_name('IGS','IGS_FI_PD_LE_INP_DT');
1408: fnd_message.set_token('DATE1',l_last_conv_dt);
1409: fnd_message.set_token('DATE2',p_conv_st_date);
1410: fnd_file.put_line(fnd_file.log,fnd_message.get());
1411: fnd_file.put_line(FND_FILE.LOG,' ');
1412:
1413: -- update the run indicator back to 0 before erroring out

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

1406:
1407: fnd_message.set_name('IGS','IGS_FI_PD_LE_INP_DT');
1408: fnd_message.set_token('DATE1',l_last_conv_dt);
1409: fnd_message.set_token('DATE2',p_conv_st_date);
1410: fnd_file.put_line(fnd_file.log,fnd_message.get());
1411: fnd_file.put_line(FND_FILE.LOG,' ');
1412:
1413: -- update the run indicator back to 0 before erroring out
1414: finpl_upd_conv_prc_run_ind(0);

Line 1425: fnd_message.set_name('IGS','IGS_FI_EPSD_LE_PRC_DT');

1421: CLOSE c_get_process_dt;
1422: -- 3
1423: IF ( (l_process_start_dt IS NOT NULL) AND (TRUNC(l_process_start_dt) < TRUNC(p_conv_st_date)) ) THEN
1424: -- Check if earliest process start date is earlier than p_conv_st_date
1425: fnd_message.set_name('IGS','IGS_FI_EPSD_LE_PRC_DT');
1426: fnd_message.set_token('DATE1',p_conv_st_date);
1427: fnd_message.set_token('DATE2',l_process_start_dt);
1428: fnd_file.put_line(fnd_file.log,fnd_message.get());
1429: fnd_file.put_line(FND_FILE.LOG,' ');

Line 1426: fnd_message.set_token('DATE1',p_conv_st_date);

1422: -- 3
1423: IF ( (l_process_start_dt IS NOT NULL) AND (TRUNC(l_process_start_dt) < TRUNC(p_conv_st_date)) ) THEN
1424: -- Check if earliest process start date is earlier than p_conv_st_date
1425: fnd_message.set_name('IGS','IGS_FI_EPSD_LE_PRC_DT');
1426: fnd_message.set_token('DATE1',p_conv_st_date);
1427: fnd_message.set_token('DATE2',l_process_start_dt);
1428: fnd_file.put_line(fnd_file.log,fnd_message.get());
1429: fnd_file.put_line(FND_FILE.LOG,' ');
1430:

Line 1427: fnd_message.set_token('DATE2',l_process_start_dt);

1423: IF ( (l_process_start_dt IS NOT NULL) AND (TRUNC(l_process_start_dt) < TRUNC(p_conv_st_date)) ) THEN
1424: -- Check if earliest process start date is earlier than p_conv_st_date
1425: fnd_message.set_name('IGS','IGS_FI_EPSD_LE_PRC_DT');
1426: fnd_message.set_token('DATE1',p_conv_st_date);
1427: fnd_message.set_token('DATE2',l_process_start_dt);
1428: fnd_file.put_line(fnd_file.log,fnd_message.get());
1429: fnd_file.put_line(FND_FILE.LOG,' ');
1430:
1431: -- update the run indicator back to 0 before erroring out

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

1424: -- Check if earliest process start date is earlier than p_conv_st_date
1425: fnd_message.set_name('IGS','IGS_FI_EPSD_LE_PRC_DT');
1426: fnd_message.set_token('DATE1',p_conv_st_date);
1427: fnd_message.set_token('DATE2',l_process_start_dt);
1428: fnd_file.put_line(fnd_file.log,fnd_message.get());
1429: fnd_file.put_line(FND_FILE.LOG,' ');
1430:
1431: -- update the run indicator back to 0 before erroring out
1432: finpl_upd_conv_prc_run_ind(0);

Line 1477: fnd_message.set_name('IGS','IGS_FI_IMP_CHGS_PARAMETER');

1473: -- Bug: 2672837
1474: OPEN cur_person_number(l_rec_get_balances.party_id);
1475: FETCH cur_person_number INTO l_person_number;
1476:
1477: fnd_message.set_name('IGS','IGS_FI_IMP_CHGS_PARAMETER');
1478: fnd_message.set_token('PARM_TYPE', igs_fi_gen_gl.get_lkp_meaning (p_v_lookup_type => 'IGS_FI_LOCKBOX',
1479: p_v_lookup_code => 'PERSON')
1480: );
1481: fnd_message.set_token('PARM_CODE', l_person_number);

Line 1478: fnd_message.set_token('PARM_TYPE', igs_fi_gen_gl.get_lkp_meaning (p_v_lookup_type => 'IGS_FI_LOCKBOX',

1474: OPEN cur_person_number(l_rec_get_balances.party_id);
1475: FETCH cur_person_number INTO l_person_number;
1476:
1477: fnd_message.set_name('IGS','IGS_FI_IMP_CHGS_PARAMETER');
1478: fnd_message.set_token('PARM_TYPE', igs_fi_gen_gl.get_lkp_meaning (p_v_lookup_type => 'IGS_FI_LOCKBOX',
1479: p_v_lookup_code => 'PERSON')
1480: );
1481: fnd_message.set_token('PARM_CODE', l_person_number);
1482: fnd_file.put_line(fnd_file.log, fnd_message.get);

Line 1481: fnd_message.set_token('PARM_CODE', l_person_number);

1477: fnd_message.set_name('IGS','IGS_FI_IMP_CHGS_PARAMETER');
1478: fnd_message.set_token('PARM_TYPE', igs_fi_gen_gl.get_lkp_meaning (p_v_lookup_type => 'IGS_FI_LOCKBOX',
1479: p_v_lookup_code => 'PERSON')
1480: );
1481: fnd_message.set_token('PARM_CODE', l_person_number);
1482: fnd_file.put_line(fnd_file.log, fnd_message.get);
1483:
1484: fnd_message.set_name('IGS', 'IGS_FI_IMP_CHGS_PARAMETER');
1485: fnd_message.set_token('PARM_TYPE', igs_fi_gen_gl.get_lkp_meaning (p_v_lookup_type => 'IGS_FI_LOCKBOX',

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

1478: fnd_message.set_token('PARM_TYPE', igs_fi_gen_gl.get_lkp_meaning (p_v_lookup_type => 'IGS_FI_LOCKBOX',
1479: p_v_lookup_code => 'PERSON')
1480: );
1481: fnd_message.set_token('PARM_CODE', l_person_number);
1482: fnd_file.put_line(fnd_file.log, fnd_message.get);
1483:
1484: fnd_message.set_name('IGS', 'IGS_FI_IMP_CHGS_PARAMETER');
1485: fnd_message.set_token('PARM_TYPE', igs_fi_gen_gl.get_lkp_meaning (p_v_lookup_type => 'IGS_FI_LOCKBOX',
1486: p_v_lookup_code => 'BALANCE_DATE')

Line 1484: fnd_message.set_name('IGS', 'IGS_FI_IMP_CHGS_PARAMETER');

1480: );
1481: fnd_message.set_token('PARM_CODE', l_person_number);
1482: fnd_file.put_line(fnd_file.log, fnd_message.get);
1483:
1484: fnd_message.set_name('IGS', 'IGS_FI_IMP_CHGS_PARAMETER');
1485: fnd_message.set_token('PARM_TYPE', igs_fi_gen_gl.get_lkp_meaning (p_v_lookup_type => 'IGS_FI_LOCKBOX',
1486: p_v_lookup_code => 'BALANCE_DATE')
1487: );
1488: fnd_message.set_token('PARM_CODE', l_rec_get_balances.balance_date);

Line 1485: fnd_message.set_token('PARM_TYPE', igs_fi_gen_gl.get_lkp_meaning (p_v_lookup_type => 'IGS_FI_LOCKBOX',

1481: fnd_message.set_token('PARM_CODE', l_person_number);
1482: fnd_file.put_line(fnd_file.log, fnd_message.get);
1483:
1484: fnd_message.set_name('IGS', 'IGS_FI_IMP_CHGS_PARAMETER');
1485: fnd_message.set_token('PARM_TYPE', igs_fi_gen_gl.get_lkp_meaning (p_v_lookup_type => 'IGS_FI_LOCKBOX',
1486: p_v_lookup_code => 'BALANCE_DATE')
1487: );
1488: fnd_message.set_token('PARM_CODE', l_rec_get_balances.balance_date);
1489: fnd_file.put_line(fnd_file.log, fnd_message.get);

Line 1488: fnd_message.set_token('PARM_CODE', l_rec_get_balances.balance_date);

1484: fnd_message.set_name('IGS', 'IGS_FI_IMP_CHGS_PARAMETER');
1485: fnd_message.set_token('PARM_TYPE', igs_fi_gen_gl.get_lkp_meaning (p_v_lookup_type => 'IGS_FI_LOCKBOX',
1486: p_v_lookup_code => 'BALANCE_DATE')
1487: );
1488: fnd_message.set_token('PARM_CODE', l_rec_get_balances.balance_date);
1489: fnd_file.put_line(fnd_file.log, fnd_message.get);
1490:
1491: fnd_message.set_name('IGS', 'IGS_FI_IMP_CHGS_PARAMETER');
1492: fnd_message.set_token('PARM_TYPE', igs_fi_gen_gl.get_lkp_meaning (p_v_lookup_type => 'IGS_FI_LOCKBOX',

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

1485: fnd_message.set_token('PARM_TYPE', igs_fi_gen_gl.get_lkp_meaning (p_v_lookup_type => 'IGS_FI_LOCKBOX',
1486: p_v_lookup_code => 'BALANCE_DATE')
1487: );
1488: fnd_message.set_token('PARM_CODE', l_rec_get_balances.balance_date);
1489: fnd_file.put_line(fnd_file.log, fnd_message.get);
1490:
1491: fnd_message.set_name('IGS', 'IGS_FI_IMP_CHGS_PARAMETER');
1492: fnd_message.set_token('PARM_TYPE', igs_fi_gen_gl.get_lkp_meaning (p_v_lookup_type => 'IGS_FI_LOCKBOX',
1493: p_v_lookup_code => 'BALANCE_RULE_VERSION')

Line 1491: fnd_message.set_name('IGS', 'IGS_FI_IMP_CHGS_PARAMETER');

1487: );
1488: fnd_message.set_token('PARM_CODE', l_rec_get_balances.balance_date);
1489: fnd_file.put_line(fnd_file.log, fnd_message.get);
1490:
1491: fnd_message.set_name('IGS', 'IGS_FI_IMP_CHGS_PARAMETER');
1492: fnd_message.set_token('PARM_TYPE', igs_fi_gen_gl.get_lkp_meaning (p_v_lookup_type => 'IGS_FI_LOCKBOX',
1493: p_v_lookup_code => 'BALANCE_RULE_VERSION')
1494: );
1495: fnd_message.set_token('PARM_CODE', l_version_number);

Line 1492: fnd_message.set_token('PARM_TYPE', igs_fi_gen_gl.get_lkp_meaning (p_v_lookup_type => 'IGS_FI_LOCKBOX',

1488: fnd_message.set_token('PARM_CODE', l_rec_get_balances.balance_date);
1489: fnd_file.put_line(fnd_file.log, fnd_message.get);
1490:
1491: fnd_message.set_name('IGS', 'IGS_FI_IMP_CHGS_PARAMETER');
1492: fnd_message.set_token('PARM_TYPE', igs_fi_gen_gl.get_lkp_meaning (p_v_lookup_type => 'IGS_FI_LOCKBOX',
1493: p_v_lookup_code => 'BALANCE_RULE_VERSION')
1494: );
1495: fnd_message.set_token('PARM_CODE', l_version_number);
1496: fnd_file.put_line(fnd_file.log, fnd_message.get);

Line 1495: fnd_message.set_token('PARM_CODE', l_version_number);

1491: fnd_message.set_name('IGS', 'IGS_FI_IMP_CHGS_PARAMETER');
1492: fnd_message.set_token('PARM_TYPE', igs_fi_gen_gl.get_lkp_meaning (p_v_lookup_type => 'IGS_FI_LOCKBOX',
1493: p_v_lookup_code => 'BALANCE_RULE_VERSION')
1494: );
1495: fnd_message.set_token('PARM_CODE', l_version_number);
1496: fnd_file.put_line(fnd_file.log, fnd_message.get);
1497:
1498: fnd_message.set_name('IGS', 'IGS_FI_IMP_CHGS_PARAMETER');
1499: fnd_message.set_token('PARM_TYPE', igs_fi_gen_gl.get_lkp_meaning (p_v_lookup_type => 'IGS_FI_LOCKBOX',

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

1492: fnd_message.set_token('PARM_TYPE', igs_fi_gen_gl.get_lkp_meaning (p_v_lookup_type => 'IGS_FI_LOCKBOX',
1493: p_v_lookup_code => 'BALANCE_RULE_VERSION')
1494: );
1495: fnd_message.set_token('PARM_CODE', l_version_number);
1496: fnd_file.put_line(fnd_file.log, fnd_message.get);
1497:
1498: fnd_message.set_name('IGS', 'IGS_FI_IMP_CHGS_PARAMETER');
1499: fnd_message.set_token('PARM_TYPE', igs_fi_gen_gl.get_lkp_meaning (p_v_lookup_type => 'IGS_FI_LOCKBOX',
1500: p_v_lookup_code => 'BALANCE_AMOUNT')

Line 1498: fnd_message.set_name('IGS', 'IGS_FI_IMP_CHGS_PARAMETER');

1494: );
1495: fnd_message.set_token('PARM_CODE', l_version_number);
1496: fnd_file.put_line(fnd_file.log, fnd_message.get);
1497:
1498: fnd_message.set_name('IGS', 'IGS_FI_IMP_CHGS_PARAMETER');
1499: fnd_message.set_token('PARM_TYPE', igs_fi_gen_gl.get_lkp_meaning (p_v_lookup_type => 'IGS_FI_LOCKBOX',
1500: p_v_lookup_code => 'BALANCE_AMOUNT')
1501: );
1502: fnd_message.set_token('PARM_CODE',igs_fi_gen_gl.get_formatted_amount(l_balance_sum));

Line 1499: fnd_message.set_token('PARM_TYPE', igs_fi_gen_gl.get_lkp_meaning (p_v_lookup_type => 'IGS_FI_LOCKBOX',

1495: fnd_message.set_token('PARM_CODE', l_version_number);
1496: fnd_file.put_line(fnd_file.log, fnd_message.get);
1497:
1498: fnd_message.set_name('IGS', 'IGS_FI_IMP_CHGS_PARAMETER');
1499: fnd_message.set_token('PARM_TYPE', igs_fi_gen_gl.get_lkp_meaning (p_v_lookup_type => 'IGS_FI_LOCKBOX',
1500: p_v_lookup_code => 'BALANCE_AMOUNT')
1501: );
1502: fnd_message.set_token('PARM_CODE',igs_fi_gen_gl.get_formatted_amount(l_balance_sum));
1503: fnd_file.put_line(fnd_file.log,fnd_message.get);

Line 1502: fnd_message.set_token('PARM_CODE',igs_fi_gen_gl.get_formatted_amount(l_balance_sum));

1498: fnd_message.set_name('IGS', 'IGS_FI_IMP_CHGS_PARAMETER');
1499: fnd_message.set_token('PARM_TYPE', igs_fi_gen_gl.get_lkp_meaning (p_v_lookup_type => 'IGS_FI_LOCKBOX',
1500: p_v_lookup_code => 'BALANCE_AMOUNT')
1501: );
1502: fnd_message.set_token('PARM_CODE',igs_fi_gen_gl.get_formatted_amount(l_balance_sum));
1503: fnd_file.put_line(fnd_file.log,fnd_message.get);
1504: fnd_file.new_line(fnd_file.log);
1505:
1506: CLOSE cur_person_number;

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

1499: fnd_message.set_token('PARM_TYPE', igs_fi_gen_gl.get_lkp_meaning (p_v_lookup_type => 'IGS_FI_LOCKBOX',
1500: p_v_lookup_code => 'BALANCE_AMOUNT')
1501: );
1502: fnd_message.set_token('PARM_CODE',igs_fi_gen_gl.get_formatted_amount(l_balance_sum));
1503: fnd_file.put_line(fnd_file.log,fnd_message.get);
1504: fnd_file.new_line(fnd_file.log);
1505:
1506: CLOSE cur_person_number;
1507:

Line 1545: fnd_message.set_name('IGS','IGS_FI_IMP_CHGS_PARAMETER');

1541: -- Update the log file
1542: -- (pathipat) Log file format changed from tabular format to multiline format
1543: -- Used generic function to get the description, and not the local func lookup_Desc
1544: -- Bug: 2672837
1545: fnd_message.set_name('IGS','IGS_FI_IMP_CHGS_PARAMETER');
1546: fnd_message.set_token('PARM_TYPE', igs_fi_gen_gl.get_lkp_meaning (p_v_lookup_type => 'IGS_FI_LOCKBOX',
1547: p_v_lookup_code => 'PERSON')
1548: );
1549: fnd_message.set_token('PARM_CODE', l_person_number);

Line 1546: fnd_message.set_token('PARM_TYPE', igs_fi_gen_gl.get_lkp_meaning (p_v_lookup_type => 'IGS_FI_LOCKBOX',

1542: -- (pathipat) Log file format changed from tabular format to multiline format
1543: -- Used generic function to get the description, and not the local func lookup_Desc
1544: -- Bug: 2672837
1545: fnd_message.set_name('IGS','IGS_FI_IMP_CHGS_PARAMETER');
1546: fnd_message.set_token('PARM_TYPE', igs_fi_gen_gl.get_lkp_meaning (p_v_lookup_type => 'IGS_FI_LOCKBOX',
1547: p_v_lookup_code => 'PERSON')
1548: );
1549: fnd_message.set_token('PARM_CODE', l_person_number);
1550: fnd_file.put_line(fnd_file.log, fnd_message.get);

Line 1549: fnd_message.set_token('PARM_CODE', l_person_number);

1545: fnd_message.set_name('IGS','IGS_FI_IMP_CHGS_PARAMETER');
1546: fnd_message.set_token('PARM_TYPE', igs_fi_gen_gl.get_lkp_meaning (p_v_lookup_type => 'IGS_FI_LOCKBOX',
1547: p_v_lookup_code => 'PERSON')
1548: );
1549: fnd_message.set_token('PARM_CODE', l_person_number);
1550: fnd_file.put_line(fnd_file.log, fnd_message.get);
1551:
1552: fnd_message.set_name('IGS', 'IGS_FI_IMP_CHGS_PARAMETER');
1553: fnd_message.set_token('PARM_TYPE', igs_fi_gen_gl.get_lkp_meaning (p_v_lookup_type => 'IGS_FI_LOCKBOX',

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

1546: fnd_message.set_token('PARM_TYPE', igs_fi_gen_gl.get_lkp_meaning (p_v_lookup_type => 'IGS_FI_LOCKBOX',
1547: p_v_lookup_code => 'PERSON')
1548: );
1549: fnd_message.set_token('PARM_CODE', l_person_number);
1550: fnd_file.put_line(fnd_file.log, fnd_message.get);
1551:
1552: fnd_message.set_name('IGS', 'IGS_FI_IMP_CHGS_PARAMETER');
1553: fnd_message.set_token('PARM_TYPE', igs_fi_gen_gl.get_lkp_meaning (p_v_lookup_type => 'IGS_FI_LOCKBOX',
1554: p_v_lookup_code => 'BALANCE_DATE')

Line 1552: fnd_message.set_name('IGS', 'IGS_FI_IMP_CHGS_PARAMETER');

1548: );
1549: fnd_message.set_token('PARM_CODE', l_person_number);
1550: fnd_file.put_line(fnd_file.log, fnd_message.get);
1551:
1552: fnd_message.set_name('IGS', 'IGS_FI_IMP_CHGS_PARAMETER');
1553: fnd_message.set_token('PARM_TYPE', igs_fi_gen_gl.get_lkp_meaning (p_v_lookup_type => 'IGS_FI_LOCKBOX',
1554: p_v_lookup_code => 'BALANCE_DATE')
1555: );
1556: fnd_message.set_token('PARM_CODE', l_rec_get_balances.balance_date);

Line 1553: fnd_message.set_token('PARM_TYPE', igs_fi_gen_gl.get_lkp_meaning (p_v_lookup_type => 'IGS_FI_LOCKBOX',

1549: fnd_message.set_token('PARM_CODE', l_person_number);
1550: fnd_file.put_line(fnd_file.log, fnd_message.get);
1551:
1552: fnd_message.set_name('IGS', 'IGS_FI_IMP_CHGS_PARAMETER');
1553: fnd_message.set_token('PARM_TYPE', igs_fi_gen_gl.get_lkp_meaning (p_v_lookup_type => 'IGS_FI_LOCKBOX',
1554: p_v_lookup_code => 'BALANCE_DATE')
1555: );
1556: fnd_message.set_token('PARM_CODE', l_rec_get_balances.balance_date);
1557: fnd_file.put_line(fnd_file.log, fnd_message.get);

Line 1556: fnd_message.set_token('PARM_CODE', l_rec_get_balances.balance_date);

1552: fnd_message.set_name('IGS', 'IGS_FI_IMP_CHGS_PARAMETER');
1553: fnd_message.set_token('PARM_TYPE', igs_fi_gen_gl.get_lkp_meaning (p_v_lookup_type => 'IGS_FI_LOCKBOX',
1554: p_v_lookup_code => 'BALANCE_DATE')
1555: );
1556: fnd_message.set_token('PARM_CODE', l_rec_get_balances.balance_date);
1557: fnd_file.put_line(fnd_file.log, fnd_message.get);
1558:
1559: fnd_message.set_name('IGS', 'IGS_FI_IMP_CHGS_PARAMETER');
1560: fnd_message.set_token('PARM_TYPE', igs_fi_gen_gl.get_lkp_meaning (p_v_lookup_type => 'IGS_FI_LOCKBOX',

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

1553: fnd_message.set_token('PARM_TYPE', igs_fi_gen_gl.get_lkp_meaning (p_v_lookup_type => 'IGS_FI_LOCKBOX',
1554: p_v_lookup_code => 'BALANCE_DATE')
1555: );
1556: fnd_message.set_token('PARM_CODE', l_rec_get_balances.balance_date);
1557: fnd_file.put_line(fnd_file.log, fnd_message.get);
1558:
1559: fnd_message.set_name('IGS', 'IGS_FI_IMP_CHGS_PARAMETER');
1560: fnd_message.set_token('PARM_TYPE', igs_fi_gen_gl.get_lkp_meaning (p_v_lookup_type => 'IGS_FI_LOCKBOX',
1561: p_v_lookup_code => 'BALANCE_RULE_VERSION')

Line 1559: fnd_message.set_name('IGS', 'IGS_FI_IMP_CHGS_PARAMETER');

1555: );
1556: fnd_message.set_token('PARM_CODE', l_rec_get_balances.balance_date);
1557: fnd_file.put_line(fnd_file.log, fnd_message.get);
1558:
1559: fnd_message.set_name('IGS', 'IGS_FI_IMP_CHGS_PARAMETER');
1560: fnd_message.set_token('PARM_TYPE', igs_fi_gen_gl.get_lkp_meaning (p_v_lookup_type => 'IGS_FI_LOCKBOX',
1561: p_v_lookup_code => 'BALANCE_RULE_VERSION')
1562: );
1563: fnd_message.set_token('PARM_CODE', l_version_number);

Line 1560: fnd_message.set_token('PARM_TYPE', igs_fi_gen_gl.get_lkp_meaning (p_v_lookup_type => 'IGS_FI_LOCKBOX',

1556: fnd_message.set_token('PARM_CODE', l_rec_get_balances.balance_date);
1557: fnd_file.put_line(fnd_file.log, fnd_message.get);
1558:
1559: fnd_message.set_name('IGS', 'IGS_FI_IMP_CHGS_PARAMETER');
1560: fnd_message.set_token('PARM_TYPE', igs_fi_gen_gl.get_lkp_meaning (p_v_lookup_type => 'IGS_FI_LOCKBOX',
1561: p_v_lookup_code => 'BALANCE_RULE_VERSION')
1562: );
1563: fnd_message.set_token('PARM_CODE', l_version_number);
1564: fnd_file.put_line(fnd_file.log, fnd_message.get);

Line 1563: fnd_message.set_token('PARM_CODE', l_version_number);

1559: fnd_message.set_name('IGS', 'IGS_FI_IMP_CHGS_PARAMETER');
1560: fnd_message.set_token('PARM_TYPE', igs_fi_gen_gl.get_lkp_meaning (p_v_lookup_type => 'IGS_FI_LOCKBOX',
1561: p_v_lookup_code => 'BALANCE_RULE_VERSION')
1562: );
1563: fnd_message.set_token('PARM_CODE', l_version_number);
1564: fnd_file.put_line(fnd_file.log, fnd_message.get);
1565:
1566: fnd_message.set_name('IGS', 'IGS_FI_IMP_CHGS_PARAMETER');
1567: fnd_message.set_token('PARM_TYPE', igs_fi_gen_gl.get_lkp_meaning (p_v_lookup_type => 'IGS_FI_LOCKBOX',

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

1560: fnd_message.set_token('PARM_TYPE', igs_fi_gen_gl.get_lkp_meaning (p_v_lookup_type => 'IGS_FI_LOCKBOX',
1561: p_v_lookup_code => 'BALANCE_RULE_VERSION')
1562: );
1563: fnd_message.set_token('PARM_CODE', l_version_number);
1564: fnd_file.put_line(fnd_file.log, fnd_message.get);
1565:
1566: fnd_message.set_name('IGS', 'IGS_FI_IMP_CHGS_PARAMETER');
1567: fnd_message.set_token('PARM_TYPE', igs_fi_gen_gl.get_lkp_meaning (p_v_lookup_type => 'IGS_FI_LOCKBOX',
1568: p_v_lookup_code => 'BALANCE_AMOUNT')

Line 1566: fnd_message.set_name('IGS', 'IGS_FI_IMP_CHGS_PARAMETER');

1562: );
1563: fnd_message.set_token('PARM_CODE', l_version_number);
1564: fnd_file.put_line(fnd_file.log, fnd_message.get);
1565:
1566: fnd_message.set_name('IGS', 'IGS_FI_IMP_CHGS_PARAMETER');
1567: fnd_message.set_token('PARM_TYPE', igs_fi_gen_gl.get_lkp_meaning (p_v_lookup_type => 'IGS_FI_LOCKBOX',
1568: p_v_lookup_code => 'BALANCE_AMOUNT')
1569: );
1570: fnd_message.set_token('PARM_CODE',igs_fi_gen_gl.get_formatted_amount(l_balance_sum));

Line 1567: fnd_message.set_token('PARM_TYPE', igs_fi_gen_gl.get_lkp_meaning (p_v_lookup_type => 'IGS_FI_LOCKBOX',

1563: fnd_message.set_token('PARM_CODE', l_version_number);
1564: fnd_file.put_line(fnd_file.log, fnd_message.get);
1565:
1566: fnd_message.set_name('IGS', 'IGS_FI_IMP_CHGS_PARAMETER');
1567: fnd_message.set_token('PARM_TYPE', igs_fi_gen_gl.get_lkp_meaning (p_v_lookup_type => 'IGS_FI_LOCKBOX',
1568: p_v_lookup_code => 'BALANCE_AMOUNT')
1569: );
1570: fnd_message.set_token('PARM_CODE',igs_fi_gen_gl.get_formatted_amount(l_balance_sum));
1571: fnd_file.put_line(fnd_file.log,fnd_message.get);

Line 1570: fnd_message.set_token('PARM_CODE',igs_fi_gen_gl.get_formatted_amount(l_balance_sum));

1566: fnd_message.set_name('IGS', 'IGS_FI_IMP_CHGS_PARAMETER');
1567: fnd_message.set_token('PARM_TYPE', igs_fi_gen_gl.get_lkp_meaning (p_v_lookup_type => 'IGS_FI_LOCKBOX',
1568: p_v_lookup_code => 'BALANCE_AMOUNT')
1569: );
1570: fnd_message.set_token('PARM_CODE',igs_fi_gen_gl.get_formatted_amount(l_balance_sum));
1571: fnd_file.put_line(fnd_file.log,fnd_message.get);
1572: fnd_file.new_line(fnd_file.log);
1573:
1574: -- 4

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

1567: fnd_message.set_token('PARM_TYPE', igs_fi_gen_gl.get_lkp_meaning (p_v_lookup_type => 'IGS_FI_LOCKBOX',
1568: p_v_lookup_code => 'BALANCE_AMOUNT')
1569: );
1570: fnd_message.set_token('PARM_CODE',igs_fi_gen_gl.get_formatted_amount(l_balance_sum));
1571: fnd_file.put_line(fnd_file.log,fnd_message.get);
1572: fnd_file.new_line(fnd_file.log);
1573:
1574: -- 4
1575: END IF;

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

1599:
1600: EXCEPTION
1601: WHEN OTHERS THEN
1602: finpl_upd_conv_prc_run_ind(0);
1603: fnd_file.put_line(fnd_file.log,fnd_message.get());
1604: fnd_file.put_line(FND_FILE.LOG,' ');
1605: ROLLBACK TO SAVEPOINT A;
1606: END;
1607:

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

1660: l_org_id := NULL;
1661: igs_ge_gen_003.set_org_id(l_org_id);
1662: EXCEPTION
1663: WHEN OTHERS THEN
1664: fnd_file.put_line (fnd_file.log, fnd_message.get);
1665: RETCODE:=2;
1666: RETURN;
1667: END;
1668:

Line 1675: fnd_message.set_name('IGS',l_v_message_name);

1671: igs_fi_com_rec_interface.chk_manage_account( p_v_manage_acc => l_v_manage_acc,
1672: p_v_message_name => l_v_message_name
1673: );
1674: IF (l_v_manage_acc = 'OTHER') OR (l_v_manage_acc IS NULL) THEN
1675: fnd_message.set_name('IGS',l_v_message_name);
1676: fnd_file.put_line(fnd_file.log,fnd_message.get());
1677: fnd_file.put_line(FND_FILE.LOG,' ');
1678: RAISE l_validation_exp;
1679: END IF;

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

1672: p_v_message_name => l_v_message_name
1673: );
1674: IF (l_v_manage_acc = 'OTHER') OR (l_v_manage_acc IS NULL) THEN
1675: fnd_message.set_name('IGS',l_v_message_name);
1676: fnd_file.put_line(fnd_file.log,fnd_message.get());
1677: fnd_file.put_line(FND_FILE.LOG,' ');
1678: RAISE l_validation_exp;
1679: END IF;
1680:

Line 1691: errbuf := fnd_message.get_string('IGS','IGS_GE_UNHANDLED_EXCEPTION') || ': ' || SQLERRM;

1687: retcode := 2;
1688: WHEN OTHERS THEN
1689: ROLLBACK;
1690: retcode := 2;
1691: errbuf := fnd_message.get_string('IGS','IGS_GE_UNHANDLED_EXCEPTION') || ': ' || SQLERRM;
1692: igs_ge_msg_stack.add;
1693: IGS_GE_MSG_STACK.CONC_EXCEPTION_HNDL;
1694: END conv_balances;
1695: