DBA Data[Home] [Help]

APPS.FII_AP_SCH_PAYMTS_F_C dependencies on FND_FILE

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

967: if (g_missing_rates >0) then
968: --------------------------------------------------------------------
969: -- Print Records where conversion date is in past
970: ---------------------------------------------------------------------
971: /* FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ***Information for Missing Currency Conversion Rates*** ');
972: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');
973: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Following Section displays records where Conversion Dates are in Past.');
974: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'To fix the issue , please enter rates for these Conversion Dates and re-collect the fact.');
975: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');

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

968: --------------------------------------------------------------------
969: -- Print Records where conversion date is in past
970: ---------------------------------------------------------------------
971: /* FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ***Information for Missing Currency Conversion Rates*** ');
972: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');
973: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Following Section displays records where Conversion Dates are in Past.');
974: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'To fix the issue , please enter rates for these Conversion Dates and re-collect the fact.');
975: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');
976: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'FROM CURRENCY TO CURRENCY CONVERSION DATE COLLECTION STATUS');

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

969: -- Print Records where conversion date is in past
970: ---------------------------------------------------------------------
971: /* FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ***Information for Missing Currency Conversion Rates*** ');
972: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');
973: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Following Section displays records where Conversion Dates are in Past.');
974: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'To fix the issue , please enter rates for these Conversion Dates and re-collect the fact.');
975: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');
976: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'FROM CURRENCY TO CURRENCY CONVERSION DATE COLLECTION STATUS');
977: */

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

970: ---------------------------------------------------------------------
971: /* FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ***Information for Missing Currency Conversion Rates*** ');
972: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');
973: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Following Section displays records where Conversion Dates are in Past.');
974: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'To fix the issue , please enter rates for these Conversion Dates and re-collect the fact.');
975: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');
976: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'FROM CURRENCY TO CURRENCY CONVERSION DATE COLLECTION STATUS');
977: */
978: FND_MESSAGE.SET_NAME('FII','FII_MISS_CONV_RATES');

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

971: /* FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ***Information for Missing Currency Conversion Rates*** ');
972: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');
973: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Following Section displays records where Conversion Dates are in Past.');
974: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'To fix the issue , please enter rates for these Conversion Dates and re-collect the fact.');
975: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');
976: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'FROM CURRENCY TO CURRENCY CONVERSION DATE COLLECTION STATUS');
977: */
978: FND_MESSAGE.SET_NAME('FII','FII_MISS_CONV_RATES');
979: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ***'||fnd_message.get||'*** ');

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

972: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');
973: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Following Section displays records where Conversion Dates are in Past.');
974: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'To fix the issue , please enter rates for these Conversion Dates and re-collect the fact.');
975: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');
976: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'FROM CURRENCY TO CURRENCY CONVERSION DATE COLLECTION STATUS');
977: */
978: FND_MESSAGE.SET_NAME('FII','FII_MISS_CONV_RATES');
979: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ***'||fnd_message.get||'*** ');
980: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');

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

975: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');
976: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'FROM CURRENCY TO CURRENCY CONVERSION DATE COLLECTION STATUS');
977: */
978: FND_MESSAGE.SET_NAME('FII','FII_MISS_CONV_RATES');
979: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ***'||fnd_message.get||'*** ');
980: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');
981: FND_MESSAGE.SET_NAME('FII','FII_PAST_CONV_RATES');
982: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,fnd_message.get);
983: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');

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

976: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'FROM CURRENCY TO CURRENCY CONVERSION DATE COLLECTION STATUS');
977: */
978: FND_MESSAGE.SET_NAME('FII','FII_MISS_CONV_RATES');
979: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ***'||fnd_message.get||'*** ');
980: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');
981: FND_MESSAGE.SET_NAME('FII','FII_PAST_CONV_RATES');
982: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,fnd_message.get);
983: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');
984: FND_MESSAGE.SET_NAME('FII','FII_FROM_CURRENCY');

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

978: FND_MESSAGE.SET_NAME('FII','FII_MISS_CONV_RATES');
979: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ***'||fnd_message.get||'*** ');
980: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');
981: FND_MESSAGE.SET_NAME('FII','FII_PAST_CONV_RATES');
982: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,fnd_message.get);
983: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');
984: FND_MESSAGE.SET_NAME('FII','FII_FROM_CURRENCY');
985: l_msg := l_msg||fnd_message.get||' ';
986: FND_MESSAGE.SET_NAME('FII','FII_TO_CURRENCY');

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

979: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ***'||fnd_message.get||'*** ');
980: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');
981: FND_MESSAGE.SET_NAME('FII','FII_PAST_CONV_RATES');
982: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,fnd_message.get);
983: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');
984: FND_MESSAGE.SET_NAME('FII','FII_FROM_CURRENCY');
985: l_msg := l_msg||fnd_message.get||' ';
986: FND_MESSAGE.SET_NAME('FII','FII_TO_CURRENCY');
987: l_msg := l_msg||fnd_message.get||' ';

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

988: FND_MESSAGE.SET_NAME('FII','FII_MISS_CONV_DATES');
989: l_msg := l_msg||fnd_message.get||' ';
990: FND_MESSAGE.SET_NAME('FII','FII_COLLECTION_STATUS');
991: l_msg := l_msg||fnd_message.get;
992: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_msg);
993: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '------------- ----------- --------------- -----------------');
994:
995: FOR c in c1 loop
996: my_payment_currency := c.FROM_CURRENCY;

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

989: l_msg := l_msg||fnd_message.get||' ';
990: FND_MESSAGE.SET_NAME('FII','FII_COLLECTION_STATUS');
991: l_msg := l_msg||fnd_message.get;
992: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_msg);
993: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '------------- ----------- --------------- -----------------');
994:
995: FOR c in c1 loop
996: my_payment_currency := c.FROM_CURRENCY;
997: my_inv_date := c.CONVERSION_DATE;

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

996: my_payment_currency := c.FROM_CURRENCY;
997: my_inv_date := c.CONVERSION_DATE;
998: my_collection_status := c.COLLECTION_STATUS;
999:
1000: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, my_payment_currency||
1001: ' '||l_to_currency||' '||my_inv_date||' '||my_collection_status);
1002:
1003: end loop;
1004:

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

1004:
1005: ------------------------------------------------------------------------------
1006: -- Print records where conversion date is in future
1007: -------------------------------------------------------------------------------
1008: /* FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');
1009: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Following Section displays records where Conversion Dates are in Future.');
1010: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');
1011: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'FROM CURRENCY TO CURRENCY CONVERSION DATE COLLECTION STATUS');
1012: */

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

1005: ------------------------------------------------------------------------------
1006: -- Print records where conversion date is in future
1007: -------------------------------------------------------------------------------
1008: /* FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');
1009: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Following Section displays records where Conversion Dates are in Future.');
1010: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');
1011: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'FROM CURRENCY TO CURRENCY CONVERSION DATE COLLECTION STATUS');
1012: */
1013: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');

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

1006: -- Print records where conversion date is in future
1007: -------------------------------------------------------------------------------
1008: /* FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');
1009: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Following Section displays records where Conversion Dates are in Future.');
1010: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');
1011: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'FROM CURRENCY TO CURRENCY CONVERSION DATE COLLECTION STATUS');
1012: */
1013: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');
1014: FND_MESSAGE.SET_NAME('FII','FII_FUTURE_CONV_RATES');

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

1007: -------------------------------------------------------------------------------
1008: /* FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');
1009: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Following Section displays records where Conversion Dates are in Future.');
1010: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');
1011: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'FROM CURRENCY TO CURRENCY CONVERSION DATE COLLECTION STATUS');
1012: */
1013: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');
1014: FND_MESSAGE.SET_NAME('FII','FII_FUTURE_CONV_RATES');
1015: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,fnd_message.get);

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

1009: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Following Section displays records where Conversion Dates are in Future.');
1010: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');
1011: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'FROM CURRENCY TO CURRENCY CONVERSION DATE COLLECTION STATUS');
1012: */
1013: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');
1014: FND_MESSAGE.SET_NAME('FII','FII_FUTURE_CONV_RATES');
1015: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,fnd_message.get);
1016: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');
1017: l_msg := NULL;

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

1011: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'FROM CURRENCY TO CURRENCY CONVERSION DATE COLLECTION STATUS');
1012: */
1013: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');
1014: FND_MESSAGE.SET_NAME('FII','FII_FUTURE_CONV_RATES');
1015: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,fnd_message.get);
1016: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');
1017: l_msg := NULL;
1018: FND_MESSAGE.SET_NAME('FII','FII_FROM_CURRENCY');
1019: l_msg := l_msg||fnd_message.get||' ';

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

1012: */
1013: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');
1014: FND_MESSAGE.SET_NAME('FII','FII_FUTURE_CONV_RATES');
1015: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,fnd_message.get);
1016: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');
1017: l_msg := NULL;
1018: FND_MESSAGE.SET_NAME('FII','FII_FROM_CURRENCY');
1019: l_msg := l_msg||fnd_message.get||' ';
1020: FND_MESSAGE.SET_NAME('FII','FII_TO_CURRENCY');

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

1022: FND_MESSAGE.SET_NAME('FII','FII_MISS_CONV_DATES');
1023: l_msg := l_msg||fnd_message.get||' ';
1024: FND_MESSAGE.SET_NAME('FII','FII_COLLECTION_STATUS');
1025: l_msg := l_msg||fnd_message.get;
1026: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_msg);
1027: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '------------- ----------- --------------- -----------------');
1028:
1029: FOR d in c2 loop
1030: my_payment_currency := d.FROM_CURRENCY;

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

1023: l_msg := l_msg||fnd_message.get||' ';
1024: FND_MESSAGE.SET_NAME('FII','FII_COLLECTION_STATUS');
1025: l_msg := l_msg||fnd_message.get;
1026: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_msg);
1027: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '------------- ----------- --------------- -----------------');
1028:
1029: FOR d in c2 loop
1030: my_payment_currency := d.FROM_CURRENCY;
1031: my_inv_date := d.CONVERSION_DATE;

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

1030: my_payment_currency := d.FROM_CURRENCY;
1031: my_inv_date := d.CONVERSION_DATE;
1032: my_collection_status := d.COLLECTION_STATUS;
1033:
1034: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, my_payment_currency||
1035: ' '||l_to_currency||' '||my_inv_date||' '||my_collection_status);
1036:
1037: end loop;
1038: end if;