DBA Data[Home] [Help]

APPS.FII_AP_INV_LINES_F_C dependencies on FND_FILE

Line 1398: /* FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ***Information for Missing Currency Conversion Rates*** ');

1394: --------------------------------------------------------------------
1395: -- Print Records where conversion date is in past
1396: -- Added for Currency Conversion Date Enhancement
1397: ---------------------------------------------------------------------
1398: /* FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ***Information for Missing Currency Conversion Rates*** ');
1399: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');
1400: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Following Section displays records where Conversion Dates are in Past.');
1401: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'To fix the issue , please enter rates for these Conversion Dates and re-collect the fact.');
1402: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');

Line 1399: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');

1395: -- Print Records where conversion date is in past
1396: -- Added for Currency Conversion Date Enhancement
1397: ---------------------------------------------------------------------
1398: /* FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ***Information for Missing Currency Conversion Rates*** ');
1399: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');
1400: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Following Section displays records where Conversion Dates are in Past.');
1401: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'To fix the issue , please enter rates for these Conversion Dates and re-collect the fact.');
1402: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');
1403: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'FROM CURRENCY TO CURRENCY CONVERSION DATE COLLECTION STATUS');

Line 1400: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Following Section displays records where Conversion Dates are in Past.');

1396: -- Added for Currency Conversion Date Enhancement
1397: ---------------------------------------------------------------------
1398: /* FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ***Information for Missing Currency Conversion Rates*** ');
1399: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');
1400: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Following Section displays records where Conversion Dates are in Past.');
1401: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'To fix the issue , please enter rates for these Conversion Dates and re-collect the fact.');
1402: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');
1403: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'FROM CURRENCY TO CURRENCY CONVERSION DATE COLLECTION STATUS');
1404: */

Line 1401: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'To fix the issue , please enter rates for these Conversion Dates and re-collect the fact.');

1397: ---------------------------------------------------------------------
1398: /* FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ***Information for Missing Currency Conversion Rates*** ');
1399: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');
1400: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Following Section displays records where Conversion Dates are in Past.');
1401: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'To fix the issue , please enter rates for these Conversion Dates and re-collect the fact.');
1402: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');
1403: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'FROM CURRENCY TO CURRENCY CONVERSION DATE COLLECTION STATUS');
1404: */
1405:

Line 1402: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');

1398: /* FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ***Information for Missing Currency Conversion Rates*** ');
1399: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');
1400: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Following Section displays records where Conversion Dates are in Past.');
1401: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'To fix the issue , please enter rates for these Conversion Dates and re-collect the fact.');
1402: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');
1403: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'FROM CURRENCY TO CURRENCY CONVERSION DATE COLLECTION STATUS');
1404: */
1405:
1406: FND_MESSAGE.SET_NAME('FII','FII_MISS_CONV_RATES');

Line 1403: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'FROM CURRENCY TO CURRENCY CONVERSION DATE COLLECTION STATUS');

1399: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');
1400: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Following Section displays records where Conversion Dates are in Past.');
1401: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'To fix the issue , please enter rates for these Conversion Dates and re-collect the fact.');
1402: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');
1403: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'FROM CURRENCY TO CURRENCY CONVERSION DATE COLLECTION STATUS');
1404: */
1405:
1406: FND_MESSAGE.SET_NAME('FII','FII_MISS_CONV_RATES');
1407: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ***'||fnd_message.get||'*** ');

Line 1407: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ***'||fnd_message.get||'*** ');

1403: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'FROM CURRENCY TO CURRENCY CONVERSION DATE COLLECTION STATUS');
1404: */
1405:
1406: FND_MESSAGE.SET_NAME('FII','FII_MISS_CONV_RATES');
1407: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ***'||fnd_message.get||'*** ');
1408: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');
1409: FND_MESSAGE.SET_NAME('FII','FII_PAST_CONV_RATES');
1410: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,fnd_message.get);
1411: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');

Line 1408: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');

1404: */
1405:
1406: FND_MESSAGE.SET_NAME('FII','FII_MISS_CONV_RATES');
1407: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ***'||fnd_message.get||'*** ');
1408: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');
1409: FND_MESSAGE.SET_NAME('FII','FII_PAST_CONV_RATES');
1410: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,fnd_message.get);
1411: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');
1412: FND_MESSAGE.SET_NAME('FII','FII_FROM_CURRENCY');

Line 1410: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,fnd_message.get);

1406: FND_MESSAGE.SET_NAME('FII','FII_MISS_CONV_RATES');
1407: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ***'||fnd_message.get||'*** ');
1408: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');
1409: FND_MESSAGE.SET_NAME('FII','FII_PAST_CONV_RATES');
1410: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,fnd_message.get);
1411: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');
1412: FND_MESSAGE.SET_NAME('FII','FII_FROM_CURRENCY');
1413: l_msg := l_msg||fnd_message.get||' ';
1414: FND_MESSAGE.SET_NAME('FII','FII_TO_CURRENCY');

Line 1411: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');

1407: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ***'||fnd_message.get||'*** ');
1408: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');
1409: FND_MESSAGE.SET_NAME('FII','FII_PAST_CONV_RATES');
1410: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,fnd_message.get);
1411: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');
1412: FND_MESSAGE.SET_NAME('FII','FII_FROM_CURRENCY');
1413: l_msg := l_msg||fnd_message.get||' ';
1414: FND_MESSAGE.SET_NAME('FII','FII_TO_CURRENCY');
1415: l_msg := l_msg||fnd_message.get||' ';

Line 1420: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_msg);

1416: FND_MESSAGE.SET_NAME('FII','FII_MISS_CONV_DATES');
1417: l_msg := l_msg||fnd_message.get||' ';
1418: FND_MESSAGE.SET_NAME('FII','FII_COLLECTION_STATUS');
1419: l_msg := l_msg||fnd_message.get;
1420: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_msg);
1421: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '------------- ----------- --------------- -----------------');
1422:
1423: FOR c in c1 loop
1424: my_payment_currency := c.FROM_CURRENCY;

Line 1421: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '------------- ----------- --------------- -----------------');

1417: l_msg := l_msg||fnd_message.get||' ';
1418: FND_MESSAGE.SET_NAME('FII','FII_COLLECTION_STATUS');
1419: l_msg := l_msg||fnd_message.get;
1420: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_msg);
1421: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '------------- ----------- --------------- -----------------');
1422:
1423: FOR c in c1 loop
1424: my_payment_currency := c.FROM_CURRENCY;
1425: my_inv_date := c.CONVERSION_DATE;

Line 1428: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, my_payment_currency||

1424: my_payment_currency := c.FROM_CURRENCY;
1425: my_inv_date := c.CONVERSION_DATE;
1426: my_collection_status := c.COLLECTION_STATUS;
1427:
1428: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, my_payment_currency||
1429: ' '||l_to_currency||' '||my_inv_date||' '||my_collection_status);
1430:
1431: end loop;
1432:

Line 1437: /* FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');

1433: ------------------------------------------------------------------------------
1434: -- Print records where conversion date is in future
1435: -- Added for Currency Conversion Date Enhancement
1436: -------------------------------------------------------------------------------
1437: /* FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');
1438: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Following Section displays records where Conversion Dates are in Future.');
1439: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');
1440: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'FROM CURRENCY TO CURRENCY CONVERSION DATE COLLECTION STATUS');
1441: */

Line 1438: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Following Section displays records where Conversion Dates are in Future.');

1434: -- Print records where conversion date is in future
1435: -- Added for Currency Conversion Date Enhancement
1436: -------------------------------------------------------------------------------
1437: /* FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');
1438: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Following Section displays records where Conversion Dates are in Future.');
1439: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');
1440: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'FROM CURRENCY TO CURRENCY CONVERSION DATE COLLECTION STATUS');
1441: */
1442: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');

Line 1439: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');

1435: -- Added for Currency Conversion Date Enhancement
1436: -------------------------------------------------------------------------------
1437: /* FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');
1438: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Following Section displays records where Conversion Dates are in Future.');
1439: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');
1440: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'FROM CURRENCY TO CURRENCY CONVERSION DATE COLLECTION STATUS');
1441: */
1442: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');
1443: FND_MESSAGE.SET_NAME('FII','FII_FUTURE_CONV_RATES');

Line 1440: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'FROM CURRENCY TO CURRENCY CONVERSION DATE COLLECTION STATUS');

1436: -------------------------------------------------------------------------------
1437: /* FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');
1438: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Following Section displays records where Conversion Dates are in Future.');
1439: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');
1440: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'FROM CURRENCY TO CURRENCY CONVERSION DATE COLLECTION STATUS');
1441: */
1442: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');
1443: FND_MESSAGE.SET_NAME('FII','FII_FUTURE_CONV_RATES');
1444: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,fnd_message.get);

Line 1442: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');

1438: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Following Section displays records where Conversion Dates are in Future.');
1439: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');
1440: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'FROM CURRENCY TO CURRENCY CONVERSION DATE COLLECTION STATUS');
1441: */
1442: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');
1443: FND_MESSAGE.SET_NAME('FII','FII_FUTURE_CONV_RATES');
1444: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,fnd_message.get);
1445: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');
1446: l_msg := NULL;

Line 1444: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,fnd_message.get);

1440: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'FROM CURRENCY TO CURRENCY CONVERSION DATE COLLECTION STATUS');
1441: */
1442: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');
1443: FND_MESSAGE.SET_NAME('FII','FII_FUTURE_CONV_RATES');
1444: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,fnd_message.get);
1445: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');
1446: l_msg := NULL;
1447: FND_MESSAGE.SET_NAME('FII','FII_FROM_CURRENCY');
1448: l_msg := l_msg||fnd_message.get||' ';

Line 1445: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');

1441: */
1442: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');
1443: FND_MESSAGE.SET_NAME('FII','FII_FUTURE_CONV_RATES');
1444: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,fnd_message.get);
1445: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');
1446: l_msg := NULL;
1447: FND_MESSAGE.SET_NAME('FII','FII_FROM_CURRENCY');
1448: l_msg := l_msg||fnd_message.get||' ';
1449: FND_MESSAGE.SET_NAME('FII','FII_TO_CURRENCY');

Line 1455: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_msg);

1451: FND_MESSAGE.SET_NAME('FII','FII_MISS_CONV_DATES');
1452: l_msg := l_msg||fnd_message.get||' ';
1453: FND_MESSAGE.SET_NAME('FII','FII_COLLECTION_STATUS');
1454: l_msg := l_msg||fnd_message.get;
1455: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_msg);
1456: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '------------- ----------- --------------- -----------------');
1457:
1458: FOR d in c2 loop
1459: my_payment_currency := d.FROM_CURRENCY;

Line 1456: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '------------- ----------- --------------- -----------------');

1452: l_msg := l_msg||fnd_message.get||' ';
1453: FND_MESSAGE.SET_NAME('FII','FII_COLLECTION_STATUS');
1454: l_msg := l_msg||fnd_message.get;
1455: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_msg);
1456: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '------------- ----------- --------------- -----------------');
1457:
1458: FOR d in c2 loop
1459: my_payment_currency := d.FROM_CURRENCY;
1460: my_inv_date := d.CONVERSION_DATE;

Line 1463: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, my_payment_currency||

1459: my_payment_currency := d.FROM_CURRENCY;
1460: my_inv_date := d.CONVERSION_DATE;
1461: my_collection_status := d.COLLECTION_STATUS;
1462:
1463: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, my_payment_currency||
1464: ' '||l_to_currency||' '||my_inv_date||' '||my_collection_status);
1465:
1466: end loop;
1467: end if;