DBA Data[Home] [Help]

APPS.FII_AP_INV_PAYMTS_F_C dependencies on FND_FILE

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

956: --------------------------------------------------------------------
957: -- Print Records where conversion date is in past
958: -- Added for Currency Conversion Date Enhancement
959: ---------------------------------------------------------------------
960: /* FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ***Information for Missing Currency Conversion Rates*** ');
961: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');
962: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Following Section displays records where Conversion Dates are in Past.');
963: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'To fix the issue , please enter rates for these Conversion Dates and re-collect the fact.');
964: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');

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

957: -- Print Records where conversion date is in past
958: -- Added for Currency Conversion Date Enhancement
959: ---------------------------------------------------------------------
960: /* FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ***Information for Missing Currency Conversion Rates*** ');
961: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');
962: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Following Section displays records where Conversion Dates are in Past.');
963: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'To fix the issue , please enter rates for these Conversion Dates and re-collect the fact.');
964: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');
965: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'FROM CURRENCY TO CURRENCY CONVERSION DATE COLLECTION STATUS');

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

958: -- Added for Currency Conversion Date Enhancement
959: ---------------------------------------------------------------------
960: /* FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ***Information for Missing Currency Conversion Rates*** ');
961: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');
962: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Following Section displays records where Conversion Dates are in Past.');
963: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'To fix the issue , please enter rates for these Conversion Dates and re-collect the fact.');
964: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');
965: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'FROM CURRENCY TO CURRENCY CONVERSION DATE COLLECTION STATUS');
966: */

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

959: ---------------------------------------------------------------------
960: /* FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ***Information for Missing Currency Conversion Rates*** ');
961: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');
962: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Following Section displays records where Conversion Dates are in Past.');
963: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'To fix the issue , please enter rates for these Conversion Dates and re-collect the fact.');
964: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');
965: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'FROM CURRENCY TO CURRENCY CONVERSION DATE COLLECTION STATUS');
966: */
967: FND_MESSAGE.SET_NAME('FII','FII_MISS_CONV_RATES');

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

960: /* FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ***Information for Missing Currency Conversion Rates*** ');
961: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');
962: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Following Section displays records where Conversion Dates are in Past.');
963: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'To fix the issue , please enter rates for these Conversion Dates and re-collect the fact.');
964: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');
965: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'FROM CURRENCY TO CURRENCY CONVERSION DATE COLLECTION STATUS');
966: */
967: FND_MESSAGE.SET_NAME('FII','FII_MISS_CONV_RATES');
968: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ***'||fnd_message.get||'*** ');

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

961: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');
962: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Following Section displays records where Conversion Dates are in Past.');
963: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'To fix the issue , please enter rates for these Conversion Dates and re-collect the fact.');
964: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');
965: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'FROM CURRENCY TO CURRENCY CONVERSION DATE COLLECTION STATUS');
966: */
967: FND_MESSAGE.SET_NAME('FII','FII_MISS_CONV_RATES');
968: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ***'||fnd_message.get||'*** ');
969: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');

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

964: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');
965: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'FROM CURRENCY TO CURRENCY CONVERSION DATE COLLECTION STATUS');
966: */
967: FND_MESSAGE.SET_NAME('FII','FII_MISS_CONV_RATES');
968: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ***'||fnd_message.get||'*** ');
969: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');
970: FND_MESSAGE.SET_NAME('FII','FII_PAST_CONV_RATES');
971: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,fnd_message.get);
972: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');

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

965: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'FROM CURRENCY TO CURRENCY CONVERSION DATE COLLECTION STATUS');
966: */
967: FND_MESSAGE.SET_NAME('FII','FII_MISS_CONV_RATES');
968: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ***'||fnd_message.get||'*** ');
969: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');
970: FND_MESSAGE.SET_NAME('FII','FII_PAST_CONV_RATES');
971: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,fnd_message.get);
972: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');
973: FND_MESSAGE.SET_NAME('FII','FII_FROM_CURRENCY');

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

967: FND_MESSAGE.SET_NAME('FII','FII_MISS_CONV_RATES');
968: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ***'||fnd_message.get||'*** ');
969: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');
970: FND_MESSAGE.SET_NAME('FII','FII_PAST_CONV_RATES');
971: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,fnd_message.get);
972: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');
973: FND_MESSAGE.SET_NAME('FII','FII_FROM_CURRENCY');
974: l_msg := l_msg||fnd_message.get||' ';
975: FND_MESSAGE.SET_NAME('FII','FII_TO_CURRENCY');

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

968: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ***'||fnd_message.get||'*** ');
969: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');
970: FND_MESSAGE.SET_NAME('FII','FII_PAST_CONV_RATES');
971: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,fnd_message.get);
972: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');
973: FND_MESSAGE.SET_NAME('FII','FII_FROM_CURRENCY');
974: l_msg := l_msg||fnd_message.get||' ';
975: FND_MESSAGE.SET_NAME('FII','FII_TO_CURRENCY');
976: l_msg := l_msg||fnd_message.get||' ';

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

977: FND_MESSAGE.SET_NAME('FII','FII_MISS_CONV_DATES');
978: l_msg := l_msg||fnd_message.get||' ';
979: FND_MESSAGE.SET_NAME('FII','FII_COLLECTION_STATUS');
980: l_msg := l_msg||fnd_message.get;
981: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_msg);
982: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '------------- ----------- --------------- -----------------');
983:
984: FOR c in c1 loop
985: my_payment_currency := c.FROM_CURRENCY;

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

978: l_msg := l_msg||fnd_message.get||' ';
979: FND_MESSAGE.SET_NAME('FII','FII_COLLECTION_STATUS');
980: l_msg := l_msg||fnd_message.get;
981: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_msg);
982: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '------------- ----------- --------------- -----------------');
983:
984: FOR c in c1 loop
985: my_payment_currency := c.FROM_CURRENCY;
986: my_inv_date := c.CONVERSION_DATE;

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

985: my_payment_currency := c.FROM_CURRENCY;
986: my_inv_date := c.CONVERSION_DATE;
987: my_collection_status := c.COLLECTION_STATUS;
988:
989: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, my_payment_currency||
990: ' '||l_to_currency||' '||my_inv_date||' '||my_collection_status);
991:
992: end loop;
993:

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

994: ------------------------------------------------------------------------------
995: -- Print records where conversion date is in future
996: -- Added for Currency Conversion Date Enhancement
997: -------------------------------------------------------------------------------
998: /* FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');
999: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Following Section displays records where Conversion Dates are in Future.');
1000: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');
1001: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'FROM CURRENCY TO CURRENCY CONVERSION DATE COLLECTION STATUS');
1002: */

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

995: -- Print records where conversion date is in future
996: -- Added for Currency Conversion Date Enhancement
997: -------------------------------------------------------------------------------
998: /* FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');
999: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Following Section displays records where Conversion Dates are in Future.');
1000: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');
1001: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'FROM CURRENCY TO CURRENCY CONVERSION DATE COLLECTION STATUS');
1002: */
1003: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');

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

996: -- Added for Currency Conversion Date Enhancement
997: -------------------------------------------------------------------------------
998: /* FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');
999: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Following Section displays records where Conversion Dates are in Future.');
1000: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');
1001: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'FROM CURRENCY TO CURRENCY CONVERSION DATE COLLECTION STATUS');
1002: */
1003: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');
1004: FND_MESSAGE.SET_NAME('FII','FII_FUTURE_CONV_RATES');

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

997: -------------------------------------------------------------------------------
998: /* FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');
999: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Following Section displays records where Conversion Dates are in Future.');
1000: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');
1001: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'FROM CURRENCY TO CURRENCY CONVERSION DATE COLLECTION STATUS');
1002: */
1003: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');
1004: FND_MESSAGE.SET_NAME('FII','FII_FUTURE_CONV_RATES');
1005: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,fnd_message.get);

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

999: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Following Section displays records where Conversion Dates are in Future.');
1000: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');
1001: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'FROM CURRENCY TO CURRENCY CONVERSION DATE COLLECTION STATUS');
1002: */
1003: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');
1004: FND_MESSAGE.SET_NAME('FII','FII_FUTURE_CONV_RATES');
1005: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,fnd_message.get);
1006: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');
1007: l_msg := NULL;

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

1001: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'FROM CURRENCY TO CURRENCY CONVERSION DATE COLLECTION STATUS');
1002: */
1003: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');
1004: FND_MESSAGE.SET_NAME('FII','FII_FUTURE_CONV_RATES');
1005: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,fnd_message.get);
1006: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');
1007: l_msg := NULL;
1008: FND_MESSAGE.SET_NAME('FII','FII_FROM_CURRENCY');
1009: l_msg := l_msg||fnd_message.get||' ';

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

1002: */
1003: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');
1004: FND_MESSAGE.SET_NAME('FII','FII_FUTURE_CONV_RATES');
1005: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,fnd_message.get);
1006: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');
1007: l_msg := NULL;
1008: FND_MESSAGE.SET_NAME('FII','FII_FROM_CURRENCY');
1009: l_msg := l_msg||fnd_message.get||' ';
1010: FND_MESSAGE.SET_NAME('FII','FII_TO_CURRENCY');

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

1012: FND_MESSAGE.SET_NAME('FII','FII_MISS_CONV_DATES');
1013: l_msg := l_msg||fnd_message.get||' ';
1014: FND_MESSAGE.SET_NAME('FII','FII_COLLECTION_STATUS');
1015: l_msg := l_msg||fnd_message.get;
1016: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_msg);
1017: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '------------- ----------- --------------- -----------------');
1018:
1019: FOR d in c2 loop
1020: my_payment_currency := d.FROM_CURRENCY;

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

1013: l_msg := l_msg||fnd_message.get||' ';
1014: FND_MESSAGE.SET_NAME('FII','FII_COLLECTION_STATUS');
1015: l_msg := l_msg||fnd_message.get;
1016: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_msg);
1017: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '------------- ----------- --------------- -----------------');
1018:
1019: FOR d in c2 loop
1020: my_payment_currency := d.FROM_CURRENCY;
1021: my_inv_date := d.CONVERSION_DATE;

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

1020: my_payment_currency := d.FROM_CURRENCY;
1021: my_inv_date := d.CONVERSION_DATE;
1022: my_collection_status := d.COLLECTION_STATUS;
1023:
1024: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, my_payment_currency||
1025: ' '||l_to_currency||' '||my_inv_date||' '||my_collection_status);
1026:
1027: end loop;
1028: end if;