DBA Data[Home] [Help]

APPS.IGS_FI_PRC_BALANCES dependencies on FND_FILE

Line 421: FND_FILE.Put_Line(FND_FILE.Log,

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;
424:
425: EXCEPTION

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 1272: fnd_file.put_line(FND_FILE.LOG,' ');

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:
1276: END finpl_upd_conv_prc_run_ind;

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 1352: fnd_file.put_line(FND_FILE.LOG,' ');

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:
1356: -- conversion start date should not be greater than sysdate

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 1360: fnd_file.put_line(FND_FILE.LOG,' ');

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:
1364: -- Check if the holds conversion process is not already running

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 1371: fnd_file.put_line(FND_FILE.LOG,' ');

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:
1375: -- indicator = 1 if the process is already running

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 1379: fnd_file.put_line(FND_FILE.LOG,' ');

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
1383: finpl_upd_conv_prc_run_ind(1);

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 1397: fnd_file.put_line(FND_FILE.LOG,' ');

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;
1401: -- 1

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 1411: fnd_file.put_line(FND_FILE.LOG,' ');

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);
1415: RAISE l_validation_exp;

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 1429: fnd_file.put_line(FND_FILE.LOG,' ');

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);
1433: RAISE l_validation_exp;

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

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:
1508: -- 4

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

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

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 1604: fnd_file.put_line(FND_FILE.LOG,' ');

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:
1608: finpl_upd_conv_prc_run_ind(0);

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 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 1677: fnd_file.put_line(FND_FILE.LOG,' ');

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:
1681: -- call the main holds conversion procedure