DBA Data[Home] [Help]

APPS.XTR_FPS2_P dependencies on FND_MESSAGE

Line 1393: FND_MESSAGE.SET_NAME('XTR', 'XTR_RESET_DATE_FROM');

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

Line 1394: l_buf := FND_MESSAGE.GET;

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;

Line 1399: FND_MESSAGE.SET_NAME('XTR', 'XTR_RESET_DATE_TO');

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

Line 1400: l_buf := FND_MESSAGE.GET;

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;

Line 1437: FND_MESSAGE.SET_NAME('XTR', 'XTR_UPDATE_BENCH_RATE');

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);

Line 1438: FND_MESSAGE.SET_TOKEN('BENCH_RATE', l_rate);

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);

Line 1439: FND_MESSAGE.SET_TOKEN('DEAL_TYPE', l_deal_type);

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;

Line 1440: FND_MESSAGE.SET_TOKEN('DEAL_NO', l_deal_no);

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);

Line 1441: FND_MESSAGE.SET_TOKEN('TRANS_NO', l_tran_no);

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

Line 1442: FND_MESSAGE.SET_TOKEN('RATE_DATE', l_ratefix_date);

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,

Line 1443: l_buf := FND_MESSAGE.GET;

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,

Line 1452: FND_MESSAGE.SET_NAME('XTR', 'XTR_UPDATE_BENCH_SEQ_RATE');

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);

Line 1453: FND_MESSAGE.SET_TOKEN('BENCH_RATE', l_rate);

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);

Line 1454: FND_MESSAGE.SET_TOKEN('DEAL_TYPE', l_deal_type);

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;

Line 1455: FND_MESSAGE.SET_TOKEN('DEAL_NO', l_deal_no);

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);

Line 1456: FND_MESSAGE.SET_TOKEN('TRANS_NO', l_tran_no);

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;

Line 1457: FND_MESSAGE.SET_TOKEN('RATE_DATE', l_ratefix_date);

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;

Line 1458: l_buf := FND_MESSAGE.GET;

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

Line 1464: FND_MESSAGE.SET_NAME('XTR', 'XTR_NO_BENCH_RATE');

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);

Line 1465: FND_MESSAGE.SET_TOKEN('DEAL_TYPE', l_deal_type);

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;

Line 1466: FND_MESSAGE.SET_TOKEN('DEAL_NO', l_deal_no);

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);

Line 1467: FND_MESSAGE.SET_TOKEN('TRANS_NO', l_tran_no);

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;

Line 1468: FND_MESSAGE.SET_TOKEN('RATE_DATE', l_ratefix_date);

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

Line 1469: l_buf := FND_MESSAGE.GET;

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;

Line 1475: FND_MESSAGE.SET_NAME('XTR', 'XTR_BENCH_SETTLE');

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);

Line 1476: FND_MESSAGE.SET_TOKEN('DEAL_TYPE', l_deal_type);

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;

Line 1477: FND_MESSAGE.SET_TOKEN('DEAL_NO', l_deal_no);

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);

Line 1478: FND_MESSAGE.SET_TOKEN('TRANS_NO', l_tran_no);

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

Line 1479: FND_MESSAGE.SET_TOKEN('RATE_DATE', l_ratefix_date);

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');

Line 1480: l_buf := FND_MESSAGE.GET;

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);

Line 1483: FND_MESSAGE.SET_NAME('XTR', 'XTR_BENCH_ACCRUAL');

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);

Line 1484: FND_MESSAGE.SET_TOKEN('DEAL_TYPE', l_deal_type);

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;

Line 1485: FND_MESSAGE.SET_TOKEN('DEAL_NO', l_deal_no);

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);

Line 1486: FND_MESSAGE.SET_TOKEN('TRANS_NO', l_tran_no);

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

Line 1487: FND_MESSAGE.SET_TOKEN('RATE_DATE', l_ratefix_date);

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');

Line 1488: l_buf := FND_MESSAGE.GET;

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);

Line 1491: FND_MESSAGE.SET_NAME('XTR', 'XTR_BENCH_REVAL');

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);

Line 1492: FND_MESSAGE.SET_TOKEN('DEAL_TYPE', l_deal_type);

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;

Line 1493: FND_MESSAGE.SET_TOKEN('DEAL_NO', l_deal_no);

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);

Line 1494: FND_MESSAGE.SET_TOKEN('TRANS_NO', l_tran_no);

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

Line 1495: FND_MESSAGE.SET_TOKEN('RATE_DATE', l_ratefix_date);

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');

Line 1496: l_buf := FND_MESSAGE.GET;

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);

Line 1499: FND_MESSAGE.SET_NAME('XTR', 'XTR_BENCH_JOURNAL');

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);

Line 1500: FND_MESSAGE.SET_TOKEN('DEAL_TYPE', l_deal_type);

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;

Line 1501: FND_MESSAGE.SET_TOKEN('DEAL_NO', l_deal_no);

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);

Line 1502: FND_MESSAGE.SET_TOKEN('TRANS_NO', l_tran_no);

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;

Line 1503: FND_MESSAGE.SET_TOKEN('RATE_DATE', l_ratefix_date);

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

Line 1504: l_buf := FND_MESSAGE.GET;

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;

Line 1514: FND_MESSAGE.SET_NAME('XTR', 'XTR_NO_ELIGI_BENCH');

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

Line 1515: l_buf := FND_MESSAGE.GET;

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;