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