769: --------------------------------------------------------------------
770: -- Print Records where conversion date is in past
771: -- Added for Currency Conversion Date Enhancement
772: ---------------------------------------------------------------------
773: /* FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ***Information for Missing Currency Conversion Rates*** ');
774: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');
775: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Following Section displays records where Conversion Dates are in Past.');
776: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'To fix the issue , please enter rates for these Conversion Dates and re-collect the fact.');
777: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');
770: -- Print Records where conversion date is in past
771: -- Added for Currency Conversion Date Enhancement
772: ---------------------------------------------------------------------
773: /* FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ***Information for Missing Currency Conversion Rates*** ');
774: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');
775: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Following Section displays records where Conversion Dates are in Past.');
776: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'To fix the issue , please enter rates for these Conversion Dates and re-collect the fact.');
777: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');
778:
771: -- Added for Currency Conversion Date Enhancement
772: ---------------------------------------------------------------------
773: /* FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ***Information for Missing Currency Conversion Rates*** ');
774: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');
775: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Following Section displays records where Conversion Dates are in Past.');
776: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'To fix the issue , please enter rates for these Conversion Dates and re-collect the fact.');
777: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');
778:
779: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'FROM CURRENCY TO CURRENCY CONVERSION DATE COLLECTION STATUS');
772: ---------------------------------------------------------------------
773: /* FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ***Information for Missing Currency Conversion Rates*** ');
774: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');
775: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Following Section displays records where Conversion Dates are in Past.');
776: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'To fix the issue , please enter rates for these Conversion Dates and re-collect the fact.');
777: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');
778:
779: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'FROM CURRENCY TO CURRENCY CONVERSION DATE COLLECTION STATUS');
780: */
773: /* FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ***Information for Missing Currency Conversion Rates*** ');
774: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');
775: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Following Section displays records where Conversion Dates are in Past.');
776: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'To fix the issue , please enter rates for these Conversion Dates and re-collect the fact.');
777: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');
778:
779: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'FROM CURRENCY TO CURRENCY CONVERSION DATE COLLECTION STATUS');
780: */
781: FND_MESSAGE.SET_NAME('FII','FII_MISS_CONV_RATES');
775: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Following Section displays records where Conversion Dates are in Past.');
776: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'To fix the issue , please enter rates for these Conversion Dates and re-collect the fact.');
777: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');
778:
779: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'FROM CURRENCY TO CURRENCY CONVERSION DATE COLLECTION STATUS');
780: */
781: FND_MESSAGE.SET_NAME('FII','FII_MISS_CONV_RATES');
782: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ***'||fnd_message.get||'*** ');
783: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');
778:
779: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'FROM CURRENCY TO CURRENCY CONVERSION DATE COLLECTION STATUS');
780: */
781: FND_MESSAGE.SET_NAME('FII','FII_MISS_CONV_RATES');
782: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ***'||fnd_message.get||'*** ');
783: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');
784: FND_MESSAGE.SET_NAME('FII','FII_PAST_CONV_RATES');
785: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,fnd_message.get);
786: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');
779: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'FROM CURRENCY TO CURRENCY CONVERSION DATE COLLECTION STATUS');
780: */
781: FND_MESSAGE.SET_NAME('FII','FII_MISS_CONV_RATES');
782: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ***'||fnd_message.get||'*** ');
783: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');
784: FND_MESSAGE.SET_NAME('FII','FII_PAST_CONV_RATES');
785: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,fnd_message.get);
786: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');
787: FND_MESSAGE.SET_NAME('FII','FII_FROM_CURRENCY');
781: FND_MESSAGE.SET_NAME('FII','FII_MISS_CONV_RATES');
782: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ***'||fnd_message.get||'*** ');
783: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');
784: FND_MESSAGE.SET_NAME('FII','FII_PAST_CONV_RATES');
785: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,fnd_message.get);
786: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');
787: FND_MESSAGE.SET_NAME('FII','FII_FROM_CURRENCY');
788: l_msg := l_msg||fnd_message.get||' ';
789: FND_MESSAGE.SET_NAME('FII','FII_TO_CURRENCY');
782: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ***'||fnd_message.get||'*** ');
783: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');
784: FND_MESSAGE.SET_NAME('FII','FII_PAST_CONV_RATES');
785: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,fnd_message.get);
786: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');
787: FND_MESSAGE.SET_NAME('FII','FII_FROM_CURRENCY');
788: l_msg := l_msg||fnd_message.get||' ';
789: FND_MESSAGE.SET_NAME('FII','FII_TO_CURRENCY');
790: l_msg := l_msg||fnd_message.get||' ';
791: FND_MESSAGE.SET_NAME('FII','FII_MISS_CONV_DATES');
792: l_msg := l_msg||fnd_message.get||' ';
793: FND_MESSAGE.SET_NAME('FII','FII_COLLECTION_STATUS');
794: l_msg := l_msg||fnd_message.get;
795: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_msg);
796: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '------------- ----------- --------------- -----------------');
797:
798: FOR c in c1 loop
799: my_payment_currency := c.FROM_CURRENCY;
792: l_msg := l_msg||fnd_message.get||' ';
793: FND_MESSAGE.SET_NAME('FII','FII_COLLECTION_STATUS');
794: l_msg := l_msg||fnd_message.get;
795: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_msg);
796: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '------------- ----------- --------------- -----------------');
797:
798: FOR c in c1 loop
799: my_payment_currency := c.FROM_CURRENCY;
800: my_inv_date := c.CONVERSION_DATE;
799: my_payment_currency := c.FROM_CURRENCY;
800: my_inv_date := c.CONVERSION_DATE;
801: my_collection_status := c.COLLECTION_STATUS;
802:
803: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, my_payment_currency||
804: ' '||l_to_currency||' '||my_inv_date||' '||my_collection_status);
805:
806: end loop;
807:
808: ------------------------------------------------------------------------------
809: -- Print records where conversion date is in future
810: -- Added for Currency Conversion Date Enhancement
811: -------------------------------------------------------------------------------
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 Future.');
814: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');
815: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'FROM CURRENCY TO CURRENCY CONVERSION DATE COLLECTION STATUS');
816: */
809: -- Print records where conversion date is in future
810: -- Added for Currency Conversion Date Enhancement
811: -------------------------------------------------------------------------------
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 Future.');
814: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');
815: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'FROM CURRENCY TO CURRENCY CONVERSION DATE COLLECTION STATUS');
816: */
817: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');
810: -- Added for Currency Conversion Date Enhancement
811: -------------------------------------------------------------------------------
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 Future.');
814: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');
815: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'FROM CURRENCY TO CURRENCY CONVERSION DATE COLLECTION STATUS');
816: */
817: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');
818: FND_MESSAGE.SET_NAME('FII','FII_FUTURE_CONV_RATES');
811: -------------------------------------------------------------------------------
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 Future.');
814: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');
815: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'FROM CURRENCY TO CURRENCY CONVERSION DATE COLLECTION STATUS');
816: */
817: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');
818: FND_MESSAGE.SET_NAME('FII','FII_FUTURE_CONV_RATES');
819: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,fnd_message.get);
813: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Following Section displays records where Conversion Dates are in Future.');
814: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');
815: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'FROM CURRENCY TO CURRENCY CONVERSION DATE COLLECTION STATUS');
816: */
817: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');
818: FND_MESSAGE.SET_NAME('FII','FII_FUTURE_CONV_RATES');
819: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,fnd_message.get);
820: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');
821: l_msg := NULL;
815: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'FROM CURRENCY TO CURRENCY CONVERSION DATE COLLECTION STATUS');
816: */
817: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');
818: FND_MESSAGE.SET_NAME('FII','FII_FUTURE_CONV_RATES');
819: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,fnd_message.get);
820: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');
821: l_msg := NULL;
822: FND_MESSAGE.SET_NAME('FII','FII_FROM_CURRENCY');
823: l_msg := l_msg||fnd_message.get||' ';
816: */
817: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');
818: FND_MESSAGE.SET_NAME('FII','FII_FUTURE_CONV_RATES');
819: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,fnd_message.get);
820: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');
821: l_msg := NULL;
822: FND_MESSAGE.SET_NAME('FII','FII_FROM_CURRENCY');
823: l_msg := l_msg||fnd_message.get||' ';
824: FND_MESSAGE.SET_NAME('FII','FII_TO_CURRENCY');
826: FND_MESSAGE.SET_NAME('FII','FII_MISS_CONV_DATES');
827: l_msg := l_msg||fnd_message.get||' ';
828: FND_MESSAGE.SET_NAME('FII','FII_COLLECTION_STATUS');
829: l_msg := l_msg||fnd_message.get;
830: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_msg);
831: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '------------- ----------- --------------- -----------------');
832:
833: FOR d in c2 loop
834: my_payment_currency := d.FROM_CURRENCY;
827: l_msg := l_msg||fnd_message.get||' ';
828: FND_MESSAGE.SET_NAME('FII','FII_COLLECTION_STATUS');
829: l_msg := l_msg||fnd_message.get;
830: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_msg);
831: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '------------- ----------- --------------- -----------------');
832:
833: FOR d in c2 loop
834: my_payment_currency := d.FROM_CURRENCY;
835: my_inv_date := d.CONVERSION_DATE;
834: my_payment_currency := d.FROM_CURRENCY;
835: my_inv_date := d.CONVERSION_DATE;
836: my_collection_status := d.COLLECTION_STATUS;
837:
838: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, my_payment_currency||
839: ' '||l_to_currency||' '||my_inv_date||' '||my_collection_status);
840:
841: end loop;
842: