DBA Data[Home] [Help]

APPS.FII_AR_TRX_DIST_F_C dependencies on FND_FILE

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

1573:
1574: --------------------------------------------------------------------
1575: -- Print Records where conversion date is in past
1576: ---------------------------------------------------------------------
1577: /* FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ***Information for Missing Currency Conversion Rates*** ');
1578: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');
1579: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Following Section displays records where Conversion Dates are in Past.');
1580: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'To fix the issue , please enter rates for these Conversion Dates and re-collect the fact.');
1581: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');

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

1574: --------------------------------------------------------------------
1575: -- Print Records where conversion date is in past
1576: ---------------------------------------------------------------------
1577: /* FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ***Information for Missing Currency Conversion Rates*** ');
1578: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');
1579: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Following Section displays records where Conversion Dates are in Past.');
1580: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'To fix the issue , please enter rates for these Conversion Dates and re-collect the fact.');
1581: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');
1582:

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

1575: -- Print Records where conversion date is in past
1576: ---------------------------------------------------------------------
1577: /* FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ***Information for Missing Currency Conversion Rates*** ');
1578: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');
1579: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Following Section displays records where Conversion Dates are in Past.');
1580: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'To fix the issue , please enter rates for these Conversion Dates and re-collect the fact.');
1581: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');
1582:
1583: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'FROM CURRENCY TO CURRENCY CONVERSION DATE COLLECTION STATUS');

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

1576: ---------------------------------------------------------------------
1577: /* FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ***Information for Missing Currency Conversion Rates*** ');
1578: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');
1579: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Following Section displays records where Conversion Dates are in Past.');
1580: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'To fix the issue , please enter rates for these Conversion Dates and re-collect the fact.');
1581: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');
1582:
1583: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'FROM CURRENCY TO CURRENCY CONVERSION DATE COLLECTION STATUS');
1584: */

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

1577: /* FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ***Information for Missing Currency Conversion Rates*** ');
1578: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');
1579: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Following Section displays records where Conversion Dates are in Past.');
1580: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'To fix the issue , please enter rates for these Conversion Dates and re-collect the fact.');
1581: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');
1582:
1583: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'FROM CURRENCY TO CURRENCY CONVERSION DATE COLLECTION STATUS');
1584: */
1585:

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

1579: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Following Section displays records where Conversion Dates are in Past.');
1580: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'To fix the issue , please enter rates for these Conversion Dates and re-collect the fact.');
1581: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');
1582:
1583: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'FROM CURRENCY TO CURRENCY CONVERSION DATE COLLECTION STATUS');
1584: */
1585:
1586: FND_MESSAGE.SET_NAME('FII','FII_MISS_CONV_RATES');
1587: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ***'||fnd_message.get||'*** ');

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

1583: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'FROM CURRENCY TO CURRENCY CONVERSION DATE COLLECTION STATUS');
1584: */
1585:
1586: FND_MESSAGE.SET_NAME('FII','FII_MISS_CONV_RATES');
1587: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ***'||fnd_message.get||'*** ');
1588: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');
1589: FND_MESSAGE.SET_NAME('FII','FII_PAST_CONV_RATES');
1590: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,fnd_message.get);
1591: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');

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

1584: */
1585:
1586: FND_MESSAGE.SET_NAME('FII','FII_MISS_CONV_RATES');
1587: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ***'||fnd_message.get||'*** ');
1588: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');
1589: FND_MESSAGE.SET_NAME('FII','FII_PAST_CONV_RATES');
1590: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,fnd_message.get);
1591: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');
1592: FND_MESSAGE.SET_NAME('FII','FII_FROM_CURRENCY');

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

1586: FND_MESSAGE.SET_NAME('FII','FII_MISS_CONV_RATES');
1587: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ***'||fnd_message.get||'*** ');
1588: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');
1589: FND_MESSAGE.SET_NAME('FII','FII_PAST_CONV_RATES');
1590: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,fnd_message.get);
1591: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');
1592: FND_MESSAGE.SET_NAME('FII','FII_FROM_CURRENCY');
1593: l_msg := l_msg||fnd_message.get||' ';
1594: FND_MESSAGE.SET_NAME('FII','FII_TO_CURRENCY');

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

1587: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ***'||fnd_message.get||'*** ');
1588: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');
1589: FND_MESSAGE.SET_NAME('FII','FII_PAST_CONV_RATES');
1590: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,fnd_message.get);
1591: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');
1592: FND_MESSAGE.SET_NAME('FII','FII_FROM_CURRENCY');
1593: l_msg := l_msg||fnd_message.get||' ';
1594: FND_MESSAGE.SET_NAME('FII','FII_TO_CURRENCY');
1595: l_msg := l_msg||fnd_message.get||' ';

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

1596: FND_MESSAGE.SET_NAME('FII','FII_MISS_CONV_DATES');
1597: l_msg := l_msg||fnd_message.get||' ';
1598: FND_MESSAGE.SET_NAME('FII','FII_COLLECTION_STATUS');
1599: l_msg := l_msg||fnd_message.get;
1600: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_msg);
1601: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '------------- ----------- --------------- -----------------');
1602:
1603: FOR c in miss_curr_past loop
1604: my_payment_currency := c.FROM_CURRENCY;

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

1597: l_msg := l_msg||fnd_message.get||' ';
1598: FND_MESSAGE.SET_NAME('FII','FII_COLLECTION_STATUS');
1599: l_msg := l_msg||fnd_message.get;
1600: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_msg);
1601: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '------------- ----------- --------------- -----------------');
1602:
1603: FOR c in miss_curr_past loop
1604: my_payment_currency := c.FROM_CURRENCY;
1605: my_inv_date := c.CONVERSION_DATE;

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

1604: my_payment_currency := c.FROM_CURRENCY;
1605: my_inv_date := c.CONVERSION_DATE;
1606: my_collection_status := c.COLLECTION_STATUS;
1607:
1608: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, my_payment_currency||
1609: ' '||l_to_currency||' '||my_inv_date||' '||my_collection_status);
1610:
1611: if g_debug_flag = 'Y' then
1612: edw_log.put_line('Inside cursor for loop');

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

1615:
1616: ------------------------------------------------------------------------------
1617: -- Print records where conversion date is in future
1618: -------------------------------------------------------------------------------
1619: /* FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');
1620: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Following Section displays records where Conversion Dates are in Future.');
1621: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');
1622: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'FROM CURRENCY TO CURRENCY CONVERSION DATE COLLECTION STATUS');
1623: */

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

1616: ------------------------------------------------------------------------------
1617: -- Print records where conversion date is in future
1618: -------------------------------------------------------------------------------
1619: /* FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');
1620: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Following Section displays records where Conversion Dates are in Future.');
1621: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');
1622: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'FROM CURRENCY TO CURRENCY CONVERSION DATE COLLECTION STATUS');
1623: */
1624: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');

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

1617: -- Print records where conversion date is in future
1618: -------------------------------------------------------------------------------
1619: /* FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');
1620: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Following Section displays records where Conversion Dates are in Future.');
1621: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');
1622: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'FROM CURRENCY TO CURRENCY CONVERSION DATE COLLECTION STATUS');
1623: */
1624: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');
1625: FND_MESSAGE.SET_NAME('FII','FII_FUTURE_CONV_RATES');

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

1618: -------------------------------------------------------------------------------
1619: /* FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');
1620: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Following Section displays records where Conversion Dates are in Future.');
1621: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');
1622: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'FROM CURRENCY TO CURRENCY CONVERSION DATE COLLECTION STATUS');
1623: */
1624: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');
1625: FND_MESSAGE.SET_NAME('FII','FII_FUTURE_CONV_RATES');
1626: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,fnd_message.get);

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

1620: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Following Section displays records where Conversion Dates are in Future.');
1621: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');
1622: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'FROM CURRENCY TO CURRENCY CONVERSION DATE COLLECTION STATUS');
1623: */
1624: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');
1625: FND_MESSAGE.SET_NAME('FII','FII_FUTURE_CONV_RATES');
1626: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,fnd_message.get);
1627: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');
1628: l_msg := NULL;

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

1622: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'FROM CURRENCY TO CURRENCY CONVERSION DATE COLLECTION STATUS');
1623: */
1624: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');
1625: FND_MESSAGE.SET_NAME('FII','FII_FUTURE_CONV_RATES');
1626: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,fnd_message.get);
1627: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');
1628: l_msg := NULL;
1629: FND_MESSAGE.SET_NAME('FII','FII_FROM_CURRENCY');
1630: l_msg := l_msg||fnd_message.get||' ';

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

1623: */
1624: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');
1625: FND_MESSAGE.SET_NAME('FII','FII_FUTURE_CONV_RATES');
1626: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,fnd_message.get);
1627: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');
1628: l_msg := NULL;
1629: FND_MESSAGE.SET_NAME('FII','FII_FROM_CURRENCY');
1630: l_msg := l_msg||fnd_message.get||' ';
1631: FND_MESSAGE.SET_NAME('FII','FII_TO_CURRENCY');

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

1633: FND_MESSAGE.SET_NAME('FII','FII_MISS_CONV_DATES');
1634: l_msg := l_msg||fnd_message.get||' ';
1635: FND_MESSAGE.SET_NAME('FII','FII_COLLECTION_STATUS');
1636: l_msg := l_msg||fnd_message.get;
1637: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_msg);
1638: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '------------- ----------- --------------- -----------------');
1639:
1640: FOR d in miss_curr_future loop
1641: my_payment_currency := d.FROM_CURRENCY;

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

1634: l_msg := l_msg||fnd_message.get||' ';
1635: FND_MESSAGE.SET_NAME('FII','FII_COLLECTION_STATUS');
1636: l_msg := l_msg||fnd_message.get;
1637: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_msg);
1638: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '------------- ----------- --------------- -----------------');
1639:
1640: FOR d in miss_curr_future loop
1641: my_payment_currency := d.FROM_CURRENCY;
1642: my_inv_date := d.CONVERSION_DATE;

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

1641: my_payment_currency := d.FROM_CURRENCY;
1642: my_inv_date := d.CONVERSION_DATE;
1643: my_collection_status := d.COLLECTION_STATUS;
1644:
1645: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, my_payment_currency||
1646: ' '||l_to_currency||' '||my_inv_date||' '||my_collection_status);
1647:
1648: if g_debug_flag = 'Y' then
1649: edw_log.put_line('Inside cursor for loop1');