DBA Data[Home] [Help]

APPS.FII_AP_INV_ON_HOLD_F_C dependencies on FND_FILE

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

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

Line 774: 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:

Line 775: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Following Section displays records where Conversion Dates are 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:
779: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'FROM CURRENCY TO CURRENCY CONVERSION DATE COLLECTION STATUS');

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

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: */

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

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

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

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

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

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

Line 783: 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');

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

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

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

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

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

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;

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

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;

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

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:

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

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: */

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

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

Line 814: 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');

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

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

Line 817: 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);
820: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');
821: l_msg := NULL;

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

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

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

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

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

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;

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

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;

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

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: