DBA Data[Home] [Help]

APPS.FII_AP_HOLD_DATA_F_C dependencies on FND_FILE

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

807: --------------------------------------------------------------------
808: -- Print Records where conversion date is in past
809: -- Added for Currency Conversion Date Enhancement
810: ---------------------------------------------------------------------
811: /* FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ***Information for Missing Currency Conversion Rates*** ');
812: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');
813: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Following Section displays records where Conversion Dates are in Past.');
814: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'To fix the issue , please enter rates for these Conversion Dates and re-collect the fact.');
815: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');

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

808: -- Print Records where conversion date is in past
809: -- Added for Currency Conversion Date Enhancement
810: ---------------------------------------------------------------------
811: /* FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ***Information for Missing Currency Conversion Rates*** ');
812: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');
813: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Following Section displays records where Conversion Dates are in Past.');
814: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'To fix the issue , please enter rates for these Conversion Dates and re-collect the fact.');
815: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');
816:

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

809: -- Added for Currency Conversion Date Enhancement
810: ---------------------------------------------------------------------
811: /* FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ***Information for Missing Currency Conversion Rates*** ');
812: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');
813: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Following Section displays records where Conversion Dates are in Past.');
814: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'To fix the issue , please enter rates for these Conversion Dates and re-collect the fact.');
815: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');
816:
817: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'FROM CURRENCY TO CURRENCY CONVERSION DATE COLLECTION STATUS');

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

810: ---------------------------------------------------------------------
811: /* FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ***Information for Missing Currency Conversion Rates*** ');
812: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');
813: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Following Section displays records where Conversion Dates are in Past.');
814: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'To fix the issue , please enter rates for these Conversion Dates and re-collect the fact.');
815: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');
816:
817: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'FROM CURRENCY TO CURRENCY CONVERSION DATE COLLECTION STATUS');
818: */

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

811: /* FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ***Information for Missing Currency Conversion Rates*** ');
812: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');
813: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Following Section displays records where Conversion Dates are in Past.');
814: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'To fix the issue , please enter rates for these Conversion Dates and re-collect the fact.');
815: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');
816:
817: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'FROM CURRENCY TO CURRENCY CONVERSION DATE COLLECTION STATUS');
818: */
819: FND_MESSAGE.SET_NAME('FII','FII_MISS_CONV_RATES');

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

813: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Following Section displays records where Conversion Dates are in Past.');
814: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'To fix the issue , please enter rates for these Conversion Dates and re-collect the fact.');
815: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');
816:
817: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'FROM CURRENCY TO CURRENCY CONVERSION DATE COLLECTION STATUS');
818: */
819: FND_MESSAGE.SET_NAME('FII','FII_MISS_CONV_RATES');
820: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ***'||fnd_message.get||'*** ');
821: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');

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

816:
817: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'FROM CURRENCY TO CURRENCY CONVERSION DATE COLLECTION STATUS');
818: */
819: FND_MESSAGE.SET_NAME('FII','FII_MISS_CONV_RATES');
820: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ***'||fnd_message.get||'*** ');
821: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');
822: FND_MESSAGE.SET_NAME('FII','FII_PAST_CONV_RATES');
823: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,fnd_message.get);
824: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');

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

817: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'FROM CURRENCY TO CURRENCY CONVERSION DATE COLLECTION STATUS');
818: */
819: FND_MESSAGE.SET_NAME('FII','FII_MISS_CONV_RATES');
820: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ***'||fnd_message.get||'*** ');
821: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');
822: FND_MESSAGE.SET_NAME('FII','FII_PAST_CONV_RATES');
823: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,fnd_message.get);
824: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');
825: FND_MESSAGE.SET_NAME('FII','FII_FROM_CURRENCY');

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

819: FND_MESSAGE.SET_NAME('FII','FII_MISS_CONV_RATES');
820: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ***'||fnd_message.get||'*** ');
821: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');
822: FND_MESSAGE.SET_NAME('FII','FII_PAST_CONV_RATES');
823: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,fnd_message.get);
824: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');
825: FND_MESSAGE.SET_NAME('FII','FII_FROM_CURRENCY');
826: l_msg := l_msg||fnd_message.get||' ';
827: FND_MESSAGE.SET_NAME('FII','FII_TO_CURRENCY');

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

820: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ***'||fnd_message.get||'*** ');
821: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');
822: FND_MESSAGE.SET_NAME('FII','FII_PAST_CONV_RATES');
823: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,fnd_message.get);
824: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');
825: FND_MESSAGE.SET_NAME('FII','FII_FROM_CURRENCY');
826: l_msg := l_msg||fnd_message.get||' ';
827: FND_MESSAGE.SET_NAME('FII','FII_TO_CURRENCY');
828: l_msg := l_msg||fnd_message.get||' ';

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

829: FND_MESSAGE.SET_NAME('FII','FII_MISS_CONV_DATES');
830: l_msg := l_msg||fnd_message.get||' ';
831: FND_MESSAGE.SET_NAME('FII','FII_COLLECTION_STATUS');
832: l_msg := l_msg||fnd_message.get;
833: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_msg);
834: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '------------- ----------- --------------- -----------------');
835:
836: FOR c in c1 loop
837: my_payment_currency := c.FROM_CURRENCY;

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

830: l_msg := l_msg||fnd_message.get||' ';
831: FND_MESSAGE.SET_NAME('FII','FII_COLLECTION_STATUS');
832: l_msg := l_msg||fnd_message.get;
833: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_msg);
834: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '------------- ----------- --------------- -----------------');
835:
836: FOR c in c1 loop
837: my_payment_currency := c.FROM_CURRENCY;
838: my_inv_date := c.CONVERSION_DATE;

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

837: my_payment_currency := c.FROM_CURRENCY;
838: my_inv_date := c.CONVERSION_DATE;
839: my_collection_status := c.COLLECTION_STATUS;
840:
841: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, my_payment_currency||
842: ' '||l_to_currency||' '||my_inv_date||' '||my_collection_status);
843:
844: end loop;
845:

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

846: ------------------------------------------------------------------------------
847: -- Print records where conversion date is in future
848: -- Added for Currency Conversion Date Enhancement
849: -------------------------------------------------------------------------------
850: /* FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');
851: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Following Section displays records where Conversion Dates are in Future.');
852: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');
853: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'FROM CURRENCY TO CURRENCY CONVERSION DATE COLLECTION STATUS');
854: */

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

847: -- Print records where conversion date is in future
848: -- Added for Currency Conversion Date Enhancement
849: -------------------------------------------------------------------------------
850: /* FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');
851: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Following Section displays records where Conversion Dates are in Future.');
852: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');
853: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'FROM CURRENCY TO CURRENCY CONVERSION DATE COLLECTION STATUS');
854: */
855: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');

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

848: -- Added for Currency Conversion Date Enhancement
849: -------------------------------------------------------------------------------
850: /* FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');
851: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Following Section displays records where Conversion Dates are in Future.');
852: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');
853: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'FROM CURRENCY TO CURRENCY CONVERSION DATE COLLECTION STATUS');
854: */
855: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');
856: FND_MESSAGE.SET_NAME('FII','FII_FUTURE_CONV_RATES');

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

849: -------------------------------------------------------------------------------
850: /* FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');
851: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Following Section displays records where Conversion Dates are in Future.');
852: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');
853: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'FROM CURRENCY TO CURRENCY CONVERSION DATE COLLECTION STATUS');
854: */
855: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');
856: FND_MESSAGE.SET_NAME('FII','FII_FUTURE_CONV_RATES');
857: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,fnd_message.get);

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

851: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Following Section displays records where Conversion Dates are in Future.');
852: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');
853: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'FROM CURRENCY TO CURRENCY CONVERSION DATE COLLECTION STATUS');
854: */
855: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');
856: FND_MESSAGE.SET_NAME('FII','FII_FUTURE_CONV_RATES');
857: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,fnd_message.get);
858: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');
859: l_msg := NULL;

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

853: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'FROM CURRENCY TO CURRENCY CONVERSION DATE COLLECTION STATUS');
854: */
855: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');
856: FND_MESSAGE.SET_NAME('FII','FII_FUTURE_CONV_RATES');
857: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,fnd_message.get);
858: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');
859: l_msg := NULL;
860: FND_MESSAGE.SET_NAME('FII','FII_FROM_CURRENCY');
861: l_msg := l_msg||fnd_message.get||' ';

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

854: */
855: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');
856: FND_MESSAGE.SET_NAME('FII','FII_FUTURE_CONV_RATES');
857: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,fnd_message.get);
858: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');
859: l_msg := NULL;
860: FND_MESSAGE.SET_NAME('FII','FII_FROM_CURRENCY');
861: l_msg := l_msg||fnd_message.get||' ';
862: FND_MESSAGE.SET_NAME('FII','FII_TO_CURRENCY');

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

864: FND_MESSAGE.SET_NAME('FII','FII_MISS_CONV_DATES');
865: l_msg := l_msg||fnd_message.get||' ';
866: FND_MESSAGE.SET_NAME('FII','FII_COLLECTION_STATUS');
867: l_msg := l_msg||fnd_message.get;
868: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_msg);
869: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '------------- ----------- --------------- -----------------');
870:
871: FOR d in c2 loop
872: my_payment_currency := d.FROM_CURRENCY;

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

865: l_msg := l_msg||fnd_message.get||' ';
866: FND_MESSAGE.SET_NAME('FII','FII_COLLECTION_STATUS');
867: l_msg := l_msg||fnd_message.get;
868: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_msg);
869: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '------------- ----------- --------------- -----------------');
870:
871: FOR d in c2 loop
872: my_payment_currency := d.FROM_CURRENCY;
873: my_inv_date := d.CONVERSION_DATE;

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

872: my_payment_currency := d.FROM_CURRENCY;
873: my_inv_date := d.CONVERSION_DATE;
874: my_collection_status := d.COLLECTION_STATUS;
875:
876: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, my_payment_currency||
877: ' '||l_to_currency||' '||my_inv_date||' '||my_collection_status);
878: end loop;
879:
880: