1389: retcode := 0;
1390: -- Modified Bug 4514808
1391: if fnd_date.canonical_to_date(p_rateset_from) > sysdate then
1392: retcode := 2;
1393: FND_MESSAGE.SET_NAME('XTR', 'XTR_RESET_DATE_FROM');
1394: l_buf := FND_MESSAGE.GET;
1395: fnd_file.put_line(fnd_file.log, l_buf);
1396: end if;
1397: if fnd_date.canonical_to_date(p_rateset_to) > sysdate then
1390: -- Modified Bug 4514808
1391: if fnd_date.canonical_to_date(p_rateset_from) > sysdate then
1392: retcode := 2;
1393: FND_MESSAGE.SET_NAME('XTR', 'XTR_RESET_DATE_FROM');
1394: l_buf := FND_MESSAGE.GET;
1395: fnd_file.put_line(fnd_file.log, l_buf);
1396: end if;
1397: if fnd_date.canonical_to_date(p_rateset_to) > sysdate then
1398: retcode := 2;
1395: fnd_file.put_line(fnd_file.log, l_buf);
1396: end if;
1397: if fnd_date.canonical_to_date(p_rateset_to) > sysdate then
1398: retcode := 2;
1399: FND_MESSAGE.SET_NAME('XTR', 'XTR_RESET_DATE_TO');
1400: l_buf := FND_MESSAGE.GET;
1401: fnd_file.put_line(fnd_file.log, l_buf);
1402: end if;
1403: If(retcode = 0)then
1396: end if;
1397: if fnd_date.canonical_to_date(p_rateset_to) > sysdate then
1398: retcode := 2;
1399: FND_MESSAGE.SET_NAME('XTR', 'XTR_RESET_DATE_TO');
1400: l_buf := FND_MESSAGE.GET;
1401: fnd_file.put_line(fnd_file.log, l_buf);
1402: end if;
1403: If(retcode = 0)then
1404: OPEN curr_all_tran;
1433: l_deal_type,
1434: l_start_date,
1435: l_new_rate + (l_margin/100));
1436: l_rate := l_new_rate + (l_margin/100);
1437: FND_MESSAGE.SET_NAME('XTR', 'XTR_UPDATE_BENCH_RATE');
1438: FND_MESSAGE.SET_TOKEN('BENCH_RATE', l_rate);
1439: FND_MESSAGE.SET_TOKEN('DEAL_TYPE', l_deal_type);
1440: FND_MESSAGE.SET_TOKEN('DEAL_NO', l_deal_no);
1441: FND_MESSAGE.SET_TOKEN('TRANS_NO', l_tran_no);
1434: l_start_date,
1435: l_new_rate + (l_margin/100));
1436: l_rate := l_new_rate + (l_margin/100);
1437: FND_MESSAGE.SET_NAME('XTR', 'XTR_UPDATE_BENCH_RATE');
1438: FND_MESSAGE.SET_TOKEN('BENCH_RATE', l_rate);
1439: FND_MESSAGE.SET_TOKEN('DEAL_TYPE', l_deal_type);
1440: FND_MESSAGE.SET_TOKEN('DEAL_NO', l_deal_no);
1441: FND_MESSAGE.SET_TOKEN('TRANS_NO', l_tran_no);
1442: FND_MESSAGE.SET_TOKEN('RATE_DATE', l_ratefix_date);
1435: l_new_rate + (l_margin/100));
1436: l_rate := l_new_rate + (l_margin/100);
1437: FND_MESSAGE.SET_NAME('XTR', 'XTR_UPDATE_BENCH_RATE');
1438: FND_MESSAGE.SET_TOKEN('BENCH_RATE', l_rate);
1439: FND_MESSAGE.SET_TOKEN('DEAL_TYPE', l_deal_type);
1440: FND_MESSAGE.SET_TOKEN('DEAL_NO', l_deal_no);
1441: FND_MESSAGE.SET_TOKEN('TRANS_NO', l_tran_no);
1442: FND_MESSAGE.SET_TOKEN('RATE_DATE', l_ratefix_date);
1443: l_buf := FND_MESSAGE.GET;
1436: l_rate := l_new_rate + (l_margin/100);
1437: FND_MESSAGE.SET_NAME('XTR', 'XTR_UPDATE_BENCH_RATE');
1438: FND_MESSAGE.SET_TOKEN('BENCH_RATE', l_rate);
1439: FND_MESSAGE.SET_TOKEN('DEAL_TYPE', l_deal_type);
1440: FND_MESSAGE.SET_TOKEN('DEAL_NO', l_deal_no);
1441: FND_MESSAGE.SET_TOKEN('TRANS_NO', l_tran_no);
1442: FND_MESSAGE.SET_TOKEN('RATE_DATE', l_ratefix_date);
1443: l_buf := FND_MESSAGE.GET;
1444: fnd_file.put_line(fnd_file.log, l_buf);
1437: FND_MESSAGE.SET_NAME('XTR', 'XTR_UPDATE_BENCH_RATE');
1438: FND_MESSAGE.SET_TOKEN('BENCH_RATE', l_rate);
1439: FND_MESSAGE.SET_TOKEN('DEAL_TYPE', l_deal_type);
1440: FND_MESSAGE.SET_TOKEN('DEAL_NO', l_deal_no);
1441: FND_MESSAGE.SET_TOKEN('TRANS_NO', l_tran_no);
1442: FND_MESSAGE.SET_TOKEN('RATE_DATE', l_ratefix_date);
1443: l_buf := FND_MESSAGE.GET;
1444: fnd_file.put_line(fnd_file.log, l_buf);
1445: else --update current record as well as subsequent transactions
1438: FND_MESSAGE.SET_TOKEN('BENCH_RATE', l_rate);
1439: FND_MESSAGE.SET_TOKEN('DEAL_TYPE', l_deal_type);
1440: FND_MESSAGE.SET_TOKEN('DEAL_NO', l_deal_no);
1441: FND_MESSAGE.SET_TOKEN('TRANS_NO', l_tran_no);
1442: FND_MESSAGE.SET_TOKEN('RATE_DATE', l_ratefix_date);
1443: l_buf := FND_MESSAGE.GET;
1444: fnd_file.put_line(fnd_file.log, l_buf);
1445: else --update current record as well as subsequent transactions
1446: UPDATE_RATE_SEQ_TRANSACTION(l_deal_no,
1439: FND_MESSAGE.SET_TOKEN('DEAL_TYPE', l_deal_type);
1440: FND_MESSAGE.SET_TOKEN('DEAL_NO', l_deal_no);
1441: FND_MESSAGE.SET_TOKEN('TRANS_NO', l_tran_no);
1442: FND_MESSAGE.SET_TOKEN('RATE_DATE', l_ratefix_date);
1443: l_buf := FND_MESSAGE.GET;
1444: fnd_file.put_line(fnd_file.log, l_buf);
1445: else --update current record as well as subsequent transactions
1446: UPDATE_RATE_SEQ_TRANSACTION(l_deal_no,
1447: l_tran_no,
1448: l_deal_type,
1449: l_start_date,
1450: l_new_rate + (l_margin/100));
1451: l_rate := l_new_rate + (l_margin/100) ;
1452: FND_MESSAGE.SET_NAME('XTR', 'XTR_UPDATE_BENCH_SEQ_RATE');
1453: FND_MESSAGE.SET_TOKEN('BENCH_RATE', l_rate);
1454: FND_MESSAGE.SET_TOKEN('DEAL_TYPE', l_deal_type);
1455: FND_MESSAGE.SET_TOKEN('DEAL_NO', l_deal_no);
1456: FND_MESSAGE.SET_TOKEN('TRANS_NO', l_tran_no);
1449: l_start_date,
1450: l_new_rate + (l_margin/100));
1451: l_rate := l_new_rate + (l_margin/100) ;
1452: FND_MESSAGE.SET_NAME('XTR', 'XTR_UPDATE_BENCH_SEQ_RATE');
1453: FND_MESSAGE.SET_TOKEN('BENCH_RATE', l_rate);
1454: FND_MESSAGE.SET_TOKEN('DEAL_TYPE', l_deal_type);
1455: FND_MESSAGE.SET_TOKEN('DEAL_NO', l_deal_no);
1456: FND_MESSAGE.SET_TOKEN('TRANS_NO', l_tran_no);
1457: FND_MESSAGE.SET_TOKEN('RATE_DATE', l_ratefix_date);
1450: l_new_rate + (l_margin/100));
1451: l_rate := l_new_rate + (l_margin/100) ;
1452: FND_MESSAGE.SET_NAME('XTR', 'XTR_UPDATE_BENCH_SEQ_RATE');
1453: FND_MESSAGE.SET_TOKEN('BENCH_RATE', l_rate);
1454: FND_MESSAGE.SET_TOKEN('DEAL_TYPE', l_deal_type);
1455: FND_MESSAGE.SET_TOKEN('DEAL_NO', l_deal_no);
1456: FND_MESSAGE.SET_TOKEN('TRANS_NO', l_tran_no);
1457: FND_MESSAGE.SET_TOKEN('RATE_DATE', l_ratefix_date);
1458: l_buf := FND_MESSAGE.GET;
1451: l_rate := l_new_rate + (l_margin/100) ;
1452: FND_MESSAGE.SET_NAME('XTR', 'XTR_UPDATE_BENCH_SEQ_RATE');
1453: FND_MESSAGE.SET_TOKEN('BENCH_RATE', l_rate);
1454: FND_MESSAGE.SET_TOKEN('DEAL_TYPE', l_deal_type);
1455: FND_MESSAGE.SET_TOKEN('DEAL_NO', l_deal_no);
1456: FND_MESSAGE.SET_TOKEN('TRANS_NO', l_tran_no);
1457: FND_MESSAGE.SET_TOKEN('RATE_DATE', l_ratefix_date);
1458: l_buf := FND_MESSAGE.GET;
1459: fnd_file.put_line(fnd_file.log, l_buf);
1452: FND_MESSAGE.SET_NAME('XTR', 'XTR_UPDATE_BENCH_SEQ_RATE');
1453: FND_MESSAGE.SET_TOKEN('BENCH_RATE', l_rate);
1454: FND_MESSAGE.SET_TOKEN('DEAL_TYPE', l_deal_type);
1455: FND_MESSAGE.SET_TOKEN('DEAL_NO', l_deal_no);
1456: FND_MESSAGE.SET_TOKEN('TRANS_NO', l_tran_no);
1457: FND_MESSAGE.SET_TOKEN('RATE_DATE', l_ratefix_date);
1458: l_buf := FND_MESSAGE.GET;
1459: fnd_file.put_line(fnd_file.log, l_buf);
1460: end if;
1453: FND_MESSAGE.SET_TOKEN('BENCH_RATE', l_rate);
1454: FND_MESSAGE.SET_TOKEN('DEAL_TYPE', l_deal_type);
1455: FND_MESSAGE.SET_TOKEN('DEAL_NO', l_deal_no);
1456: FND_MESSAGE.SET_TOKEN('TRANS_NO', l_tran_no);
1457: FND_MESSAGE.SET_TOKEN('RATE_DATE', l_ratefix_date);
1458: l_buf := FND_MESSAGE.GET;
1459: fnd_file.put_line(fnd_file.log, l_buf);
1460: end if;
1461: close C_ONE_ROW;
1454: FND_MESSAGE.SET_TOKEN('DEAL_TYPE', l_deal_type);
1455: FND_MESSAGE.SET_TOKEN('DEAL_NO', l_deal_no);
1456: FND_MESSAGE.SET_TOKEN('TRANS_NO', l_tran_no);
1457: FND_MESSAGE.SET_TOKEN('RATE_DATE', l_ratefix_date);
1458: l_buf := FND_MESSAGE.GET;
1459: fnd_file.put_line(fnd_file.log, l_buf);
1460: end if;
1461: close C_ONE_ROW;
1462: else
1460: end if;
1461: close C_ONE_ROW;
1462: else
1463: retcode := 1;
1464: FND_MESSAGE.SET_NAME('XTR', 'XTR_NO_BENCH_RATE');
1465: FND_MESSAGE.SET_TOKEN('DEAL_TYPE', l_deal_type);
1466: FND_MESSAGE.SET_TOKEN('DEAL_NO', l_deal_no);
1467: FND_MESSAGE.SET_TOKEN('TRANS_NO', l_tran_no);
1468: FND_MESSAGE.SET_TOKEN('RATE_DATE', l_ratefix_date);
1461: close C_ONE_ROW;
1462: else
1463: retcode := 1;
1464: FND_MESSAGE.SET_NAME('XTR', 'XTR_NO_BENCH_RATE');
1465: FND_MESSAGE.SET_TOKEN('DEAL_TYPE', l_deal_type);
1466: FND_MESSAGE.SET_TOKEN('DEAL_NO', l_deal_no);
1467: FND_MESSAGE.SET_TOKEN('TRANS_NO', l_tran_no);
1468: FND_MESSAGE.SET_TOKEN('RATE_DATE', l_ratefix_date);
1469: l_buf := FND_MESSAGE.GET;
1462: else
1463: retcode := 1;
1464: FND_MESSAGE.SET_NAME('XTR', 'XTR_NO_BENCH_RATE');
1465: FND_MESSAGE.SET_TOKEN('DEAL_TYPE', l_deal_type);
1466: FND_MESSAGE.SET_TOKEN('DEAL_NO', l_deal_no);
1467: FND_MESSAGE.SET_TOKEN('TRANS_NO', l_tran_no);
1468: FND_MESSAGE.SET_TOKEN('RATE_DATE', l_ratefix_date);
1469: l_buf := FND_MESSAGE.GET;
1470: fnd_file.put_line(fnd_file.log, l_buf);
1463: retcode := 1;
1464: FND_MESSAGE.SET_NAME('XTR', 'XTR_NO_BENCH_RATE');
1465: FND_MESSAGE.SET_TOKEN('DEAL_TYPE', l_deal_type);
1466: FND_MESSAGE.SET_TOKEN('DEAL_NO', l_deal_no);
1467: FND_MESSAGE.SET_TOKEN('TRANS_NO', l_tran_no);
1468: FND_MESSAGE.SET_TOKEN('RATE_DATE', l_ratefix_date);
1469: l_buf := FND_MESSAGE.GET;
1470: fnd_file.put_line(fnd_file.log, l_buf);
1471: end if;
1464: FND_MESSAGE.SET_NAME('XTR', 'XTR_NO_BENCH_RATE');
1465: FND_MESSAGE.SET_TOKEN('DEAL_TYPE', l_deal_type);
1466: FND_MESSAGE.SET_TOKEN('DEAL_NO', l_deal_no);
1467: FND_MESSAGE.SET_TOKEN('TRANS_NO', l_tran_no);
1468: FND_MESSAGE.SET_TOKEN('RATE_DATE', l_ratefix_date);
1469: l_buf := FND_MESSAGE.GET;
1470: fnd_file.put_line(fnd_file.log, l_buf);
1471: end if;
1472: else -- do not pass validation. return error message
1465: FND_MESSAGE.SET_TOKEN('DEAL_TYPE', l_deal_type);
1466: FND_MESSAGE.SET_TOKEN('DEAL_NO', l_deal_no);
1467: FND_MESSAGE.SET_TOKEN('TRANS_NO', l_tran_no);
1468: FND_MESSAGE.SET_TOKEN('RATE_DATE', l_ratefix_date);
1469: l_buf := FND_MESSAGE.GET;
1470: fnd_file.put_line(fnd_file.log, l_buf);
1471: end if;
1472: else -- do not pass validation. return error message
1473: retcode := 1;
1471: end if;
1472: else -- do not pass validation. return error message
1473: retcode := 1;
1474: if l_error = 1 then -- deal been settled
1475: FND_MESSAGE.SET_NAME('XTR', 'XTR_BENCH_SETTLE');
1476: FND_MESSAGE.SET_TOKEN('DEAL_TYPE', l_deal_type);
1477: FND_MESSAGE.SET_TOKEN('DEAL_NO', l_deal_no);
1478: FND_MESSAGE.SET_TOKEN('TRANS_NO', l_tran_no);
1479: FND_MESSAGE.SET_TOKEN('RATE_DATE', l_ratefix_date);
1472: else -- do not pass validation. return error message
1473: retcode := 1;
1474: if l_error = 1 then -- deal been settled
1475: FND_MESSAGE.SET_NAME('XTR', 'XTR_BENCH_SETTLE');
1476: FND_MESSAGE.SET_TOKEN('DEAL_TYPE', l_deal_type);
1477: FND_MESSAGE.SET_TOKEN('DEAL_NO', l_deal_no);
1478: FND_MESSAGE.SET_TOKEN('TRANS_NO', l_tran_no);
1479: FND_MESSAGE.SET_TOKEN('RATE_DATE', l_ratefix_date);
1480: l_buf := FND_MESSAGE.GET;
1473: retcode := 1;
1474: if l_error = 1 then -- deal been settled
1475: FND_MESSAGE.SET_NAME('XTR', 'XTR_BENCH_SETTLE');
1476: FND_MESSAGE.SET_TOKEN('DEAL_TYPE', l_deal_type);
1477: FND_MESSAGE.SET_TOKEN('DEAL_NO', l_deal_no);
1478: FND_MESSAGE.SET_TOKEN('TRANS_NO', l_tran_no);
1479: FND_MESSAGE.SET_TOKEN('RATE_DATE', l_ratefix_date);
1480: l_buf := FND_MESSAGE.GET;
1481: fnd_file.put_line(fnd_file.log, l_buf);
1474: if l_error = 1 then -- deal been settled
1475: FND_MESSAGE.SET_NAME('XTR', 'XTR_BENCH_SETTLE');
1476: FND_MESSAGE.SET_TOKEN('DEAL_TYPE', l_deal_type);
1477: FND_MESSAGE.SET_TOKEN('DEAL_NO', l_deal_no);
1478: FND_MESSAGE.SET_TOKEN('TRANS_NO', l_tran_no);
1479: FND_MESSAGE.SET_TOKEN('RATE_DATE', l_ratefix_date);
1480: l_buf := FND_MESSAGE.GET;
1481: fnd_file.put_line(fnd_file.log, l_buf);
1482: elsif l_error = 2 then -- Accrual has been generated
1475: FND_MESSAGE.SET_NAME('XTR', 'XTR_BENCH_SETTLE');
1476: FND_MESSAGE.SET_TOKEN('DEAL_TYPE', l_deal_type);
1477: FND_MESSAGE.SET_TOKEN('DEAL_NO', l_deal_no);
1478: FND_MESSAGE.SET_TOKEN('TRANS_NO', l_tran_no);
1479: FND_MESSAGE.SET_TOKEN('RATE_DATE', l_ratefix_date);
1480: l_buf := FND_MESSAGE.GET;
1481: fnd_file.put_line(fnd_file.log, l_buf);
1482: elsif l_error = 2 then -- Accrual has been generated
1483: FND_MESSAGE.SET_NAME('XTR', 'XTR_BENCH_ACCRUAL');
1476: FND_MESSAGE.SET_TOKEN('DEAL_TYPE', l_deal_type);
1477: FND_MESSAGE.SET_TOKEN('DEAL_NO', l_deal_no);
1478: FND_MESSAGE.SET_TOKEN('TRANS_NO', l_tran_no);
1479: FND_MESSAGE.SET_TOKEN('RATE_DATE', l_ratefix_date);
1480: l_buf := FND_MESSAGE.GET;
1481: fnd_file.put_line(fnd_file.log, l_buf);
1482: elsif l_error = 2 then -- Accrual has been generated
1483: FND_MESSAGE.SET_NAME('XTR', 'XTR_BENCH_ACCRUAL');
1484: FND_MESSAGE.SET_TOKEN('DEAL_TYPE', l_deal_type);
1479: FND_MESSAGE.SET_TOKEN('RATE_DATE', l_ratefix_date);
1480: l_buf := FND_MESSAGE.GET;
1481: fnd_file.put_line(fnd_file.log, l_buf);
1482: elsif l_error = 2 then -- Accrual has been generated
1483: FND_MESSAGE.SET_NAME('XTR', 'XTR_BENCH_ACCRUAL');
1484: FND_MESSAGE.SET_TOKEN('DEAL_TYPE', l_deal_type);
1485: FND_MESSAGE.SET_TOKEN('DEAL_NO', l_deal_no);
1486: FND_MESSAGE.SET_TOKEN('TRANS_NO', l_tran_no);
1487: FND_MESSAGE.SET_TOKEN('RATE_DATE', l_ratefix_date);
1480: l_buf := FND_MESSAGE.GET;
1481: fnd_file.put_line(fnd_file.log, l_buf);
1482: elsif l_error = 2 then -- Accrual has been generated
1483: FND_MESSAGE.SET_NAME('XTR', 'XTR_BENCH_ACCRUAL');
1484: FND_MESSAGE.SET_TOKEN('DEAL_TYPE', l_deal_type);
1485: FND_MESSAGE.SET_TOKEN('DEAL_NO', l_deal_no);
1486: FND_MESSAGE.SET_TOKEN('TRANS_NO', l_tran_no);
1487: FND_MESSAGE.SET_TOKEN('RATE_DATE', l_ratefix_date);
1488: l_buf := FND_MESSAGE.GET;
1481: fnd_file.put_line(fnd_file.log, l_buf);
1482: elsif l_error = 2 then -- Accrual has been generated
1483: FND_MESSAGE.SET_NAME('XTR', 'XTR_BENCH_ACCRUAL');
1484: FND_MESSAGE.SET_TOKEN('DEAL_TYPE', l_deal_type);
1485: FND_MESSAGE.SET_TOKEN('DEAL_NO', l_deal_no);
1486: FND_MESSAGE.SET_TOKEN('TRANS_NO', l_tran_no);
1487: FND_MESSAGE.SET_TOKEN('RATE_DATE', l_ratefix_date);
1488: l_buf := FND_MESSAGE.GET;
1489: fnd_file.put_line(fnd_file.log, l_buf);
1482: elsif l_error = 2 then -- Accrual has been generated
1483: FND_MESSAGE.SET_NAME('XTR', 'XTR_BENCH_ACCRUAL');
1484: FND_MESSAGE.SET_TOKEN('DEAL_TYPE', l_deal_type);
1485: FND_MESSAGE.SET_TOKEN('DEAL_NO', l_deal_no);
1486: FND_MESSAGE.SET_TOKEN('TRANS_NO', l_tran_no);
1487: FND_MESSAGE.SET_TOKEN('RATE_DATE', l_ratefix_date);
1488: l_buf := FND_MESSAGE.GET;
1489: fnd_file.put_line(fnd_file.log, l_buf);
1490: elsif l_error = 3 then -- revalaution has been done
1483: FND_MESSAGE.SET_NAME('XTR', 'XTR_BENCH_ACCRUAL');
1484: FND_MESSAGE.SET_TOKEN('DEAL_TYPE', l_deal_type);
1485: FND_MESSAGE.SET_TOKEN('DEAL_NO', l_deal_no);
1486: FND_MESSAGE.SET_TOKEN('TRANS_NO', l_tran_no);
1487: FND_MESSAGE.SET_TOKEN('RATE_DATE', l_ratefix_date);
1488: l_buf := FND_MESSAGE.GET;
1489: fnd_file.put_line(fnd_file.log, l_buf);
1490: elsif l_error = 3 then -- revalaution has been done
1491: FND_MESSAGE.SET_NAME('XTR', 'XTR_BENCH_REVAL');
1484: FND_MESSAGE.SET_TOKEN('DEAL_TYPE', l_deal_type);
1485: FND_MESSAGE.SET_TOKEN('DEAL_NO', l_deal_no);
1486: FND_MESSAGE.SET_TOKEN('TRANS_NO', l_tran_no);
1487: FND_MESSAGE.SET_TOKEN('RATE_DATE', l_ratefix_date);
1488: l_buf := FND_MESSAGE.GET;
1489: fnd_file.put_line(fnd_file.log, l_buf);
1490: elsif l_error = 3 then -- revalaution has been done
1491: FND_MESSAGE.SET_NAME('XTR', 'XTR_BENCH_REVAL');
1492: FND_MESSAGE.SET_TOKEN('DEAL_TYPE', l_deal_type);
1487: FND_MESSAGE.SET_TOKEN('RATE_DATE', l_ratefix_date);
1488: l_buf := FND_MESSAGE.GET;
1489: fnd_file.put_line(fnd_file.log, l_buf);
1490: elsif l_error = 3 then -- revalaution has been done
1491: FND_MESSAGE.SET_NAME('XTR', 'XTR_BENCH_REVAL');
1492: FND_MESSAGE.SET_TOKEN('DEAL_TYPE', l_deal_type);
1493: FND_MESSAGE.SET_TOKEN('DEAL_NO', l_deal_no);
1494: FND_MESSAGE.SET_TOKEN('TRANS_NO', l_tran_no);
1495: FND_MESSAGE.SET_TOKEN('RATE_DATE', l_ratefix_date);
1488: l_buf := FND_MESSAGE.GET;
1489: fnd_file.put_line(fnd_file.log, l_buf);
1490: elsif l_error = 3 then -- revalaution has been done
1491: FND_MESSAGE.SET_NAME('XTR', 'XTR_BENCH_REVAL');
1492: FND_MESSAGE.SET_TOKEN('DEAL_TYPE', l_deal_type);
1493: FND_MESSAGE.SET_TOKEN('DEAL_NO', l_deal_no);
1494: FND_MESSAGE.SET_TOKEN('TRANS_NO', l_tran_no);
1495: FND_MESSAGE.SET_TOKEN('RATE_DATE', l_ratefix_date);
1496: l_buf := FND_MESSAGE.GET;
1489: fnd_file.put_line(fnd_file.log, l_buf);
1490: elsif l_error = 3 then -- revalaution has been done
1491: FND_MESSAGE.SET_NAME('XTR', 'XTR_BENCH_REVAL');
1492: FND_MESSAGE.SET_TOKEN('DEAL_TYPE', l_deal_type);
1493: FND_MESSAGE.SET_TOKEN('DEAL_NO', l_deal_no);
1494: FND_MESSAGE.SET_TOKEN('TRANS_NO', l_tran_no);
1495: FND_MESSAGE.SET_TOKEN('RATE_DATE', l_ratefix_date);
1496: l_buf := FND_MESSAGE.GET;
1497: fnd_file.put_line(fnd_file.log, l_buf);
1490: elsif l_error = 3 then -- revalaution has been done
1491: FND_MESSAGE.SET_NAME('XTR', 'XTR_BENCH_REVAL');
1492: FND_MESSAGE.SET_TOKEN('DEAL_TYPE', l_deal_type);
1493: FND_MESSAGE.SET_TOKEN('DEAL_NO', l_deal_no);
1494: FND_MESSAGE.SET_TOKEN('TRANS_NO', l_tran_no);
1495: FND_MESSAGE.SET_TOKEN('RATE_DATE', l_ratefix_date);
1496: l_buf := FND_MESSAGE.GET;
1497: fnd_file.put_line(fnd_file.log, l_buf);
1498: elsif l_error = 4 then -- journal has been generated
1491: FND_MESSAGE.SET_NAME('XTR', 'XTR_BENCH_REVAL');
1492: FND_MESSAGE.SET_TOKEN('DEAL_TYPE', l_deal_type);
1493: FND_MESSAGE.SET_TOKEN('DEAL_NO', l_deal_no);
1494: FND_MESSAGE.SET_TOKEN('TRANS_NO', l_tran_no);
1495: FND_MESSAGE.SET_TOKEN('RATE_DATE', l_ratefix_date);
1496: l_buf := FND_MESSAGE.GET;
1497: fnd_file.put_line(fnd_file.log, l_buf);
1498: elsif l_error = 4 then -- journal has been generated
1499: FND_MESSAGE.SET_NAME('XTR', 'XTR_BENCH_JOURNAL');
1492: FND_MESSAGE.SET_TOKEN('DEAL_TYPE', l_deal_type);
1493: FND_MESSAGE.SET_TOKEN('DEAL_NO', l_deal_no);
1494: FND_MESSAGE.SET_TOKEN('TRANS_NO', l_tran_no);
1495: FND_MESSAGE.SET_TOKEN('RATE_DATE', l_ratefix_date);
1496: l_buf := FND_MESSAGE.GET;
1497: fnd_file.put_line(fnd_file.log, l_buf);
1498: elsif l_error = 4 then -- journal has been generated
1499: FND_MESSAGE.SET_NAME('XTR', 'XTR_BENCH_JOURNAL');
1500: FND_MESSAGE.SET_TOKEN('DEAL_TYPE', l_deal_type);
1495: FND_MESSAGE.SET_TOKEN('RATE_DATE', l_ratefix_date);
1496: l_buf := FND_MESSAGE.GET;
1497: fnd_file.put_line(fnd_file.log, l_buf);
1498: elsif l_error = 4 then -- journal has been generated
1499: FND_MESSAGE.SET_NAME('XTR', 'XTR_BENCH_JOURNAL');
1500: FND_MESSAGE.SET_TOKEN('DEAL_TYPE', l_deal_type);
1501: FND_MESSAGE.SET_TOKEN('DEAL_NO', l_deal_no);
1502: FND_MESSAGE.SET_TOKEN('TRANS_NO', l_tran_no);
1503: FND_MESSAGE.SET_TOKEN('RATE_DATE', l_ratefix_date);
1496: l_buf := FND_MESSAGE.GET;
1497: fnd_file.put_line(fnd_file.log, l_buf);
1498: elsif l_error = 4 then -- journal has been generated
1499: FND_MESSAGE.SET_NAME('XTR', 'XTR_BENCH_JOURNAL');
1500: FND_MESSAGE.SET_TOKEN('DEAL_TYPE', l_deal_type);
1501: FND_MESSAGE.SET_TOKEN('DEAL_NO', l_deal_no);
1502: FND_MESSAGE.SET_TOKEN('TRANS_NO', l_tran_no);
1503: FND_MESSAGE.SET_TOKEN('RATE_DATE', l_ratefix_date);
1504: l_buf := FND_MESSAGE.GET;
1497: fnd_file.put_line(fnd_file.log, l_buf);
1498: elsif l_error = 4 then -- journal has been generated
1499: FND_MESSAGE.SET_NAME('XTR', 'XTR_BENCH_JOURNAL');
1500: FND_MESSAGE.SET_TOKEN('DEAL_TYPE', l_deal_type);
1501: FND_MESSAGE.SET_TOKEN('DEAL_NO', l_deal_no);
1502: FND_MESSAGE.SET_TOKEN('TRANS_NO', l_tran_no);
1503: FND_MESSAGE.SET_TOKEN('RATE_DATE', l_ratefix_date);
1504: l_buf := FND_MESSAGE.GET;
1505: fnd_file.put_line(fnd_file.log, l_buf);
1498: elsif l_error = 4 then -- journal has been generated
1499: FND_MESSAGE.SET_NAME('XTR', 'XTR_BENCH_JOURNAL');
1500: FND_MESSAGE.SET_TOKEN('DEAL_TYPE', l_deal_type);
1501: FND_MESSAGE.SET_TOKEN('DEAL_NO', l_deal_no);
1502: FND_MESSAGE.SET_TOKEN('TRANS_NO', l_tran_no);
1503: FND_MESSAGE.SET_TOKEN('RATE_DATE', l_ratefix_date);
1504: l_buf := FND_MESSAGE.GET;
1505: fnd_file.put_line(fnd_file.log, l_buf);
1506: end if;
1499: FND_MESSAGE.SET_NAME('XTR', 'XTR_BENCH_JOURNAL');
1500: FND_MESSAGE.SET_TOKEN('DEAL_TYPE', l_deal_type);
1501: FND_MESSAGE.SET_TOKEN('DEAL_NO', l_deal_no);
1502: FND_MESSAGE.SET_TOKEN('TRANS_NO', l_tran_no);
1503: FND_MESSAGE.SET_TOKEN('RATE_DATE', l_ratefix_date);
1504: l_buf := FND_MESSAGE.GET;
1505: fnd_file.put_line(fnd_file.log, l_buf);
1506: end if;
1507: end if; -- valid OK
1500: FND_MESSAGE.SET_TOKEN('DEAL_TYPE', l_deal_type);
1501: FND_MESSAGE.SET_TOKEN('DEAL_NO', l_deal_no);
1502: FND_MESSAGE.SET_TOKEN('TRANS_NO', l_tran_no);
1503: FND_MESSAGE.SET_TOKEN('RATE_DATE', l_ratefix_date);
1504: l_buf := FND_MESSAGE.GET;
1505: fnd_file.put_line(fnd_file.log, l_buf);
1506: end if;
1507: end if; -- valid OK
1508: END LOOP;
1510:
1511: if l_count = 0 then
1512: retcode := 1;
1513: -- No deals/transactions were found using the specified search criteria.
1514: FND_MESSAGE.SET_NAME('XTR', 'XTR_NO_ELIGI_BENCH');
1515: l_buf := FND_MESSAGE.GET;
1516: fnd_file.put_line(fnd_file.log, l_buf);
1517: end if;
1518: end if; -- Bug 4514808
1511: if l_count = 0 then
1512: retcode := 1;
1513: -- No deals/transactions were found using the specified search criteria.
1514: FND_MESSAGE.SET_NAME('XTR', 'XTR_NO_ELIGI_BENCH');
1515: l_buf := FND_MESSAGE.GET;
1516: fnd_file.put_line(fnd_file.log, l_buf);
1517: end if;
1518: end if; -- Bug 4514808
1519: End RESET_FLOATING_RATES;