844: Retcode:=0;
845: l_from_date :=to_date(p_from_date,'YYYY/MM/DD HH24:MI:SS');
846: l_to_date :=to_date(p_to_date, 'YYYY/MM/DD HH24:MI:SS');
847: IF (Not EDW_COLLECTION_UTIL.setup(l_fact_name)) THEN
848: errbuf := fnd_message.get;
849: RAISE_APPLICATION_ERROR(-20000,'Error in SETUP: ' || errbuf);
850: END IF;
851: FII_AP_SCH_PAYMTS_F_C.g_push_date_range1 := nvl(l_from_date,
852: EDW_COLLECTION_UTIL.G_local_last_push_start_date - EDW_COLLECTION_UTIL.g_offset);
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,' ');
981: FND_MESSAGE.SET_NAME('FII','FII_PAST_CONV_RATES');
982: 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,' ');
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');
985: l_msg := l_msg||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');
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||' ';
988: FND_MESSAGE.SET_NAME('FII','FII_MISS_CONV_DATES');
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||' ';
988: FND_MESSAGE.SET_NAME('FII','FII_MISS_CONV_DATES');
989: l_msg := l_msg||fnd_message.get||' ';
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||' ';
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');
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||' ';
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;
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||' ';
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);
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||' ';
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, '------------- ----------- --------------- -----------------');
986: FND_MESSAGE.SET_NAME('FII','FII_TO_CURRENCY');
987: l_msg := l_msg||fnd_message.get||' ';
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:
987: l_msg := l_msg||fnd_message.get||' ';
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
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;
1018: FND_MESSAGE.SET_NAME('FII','FII_FROM_CURRENCY');
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||' ';
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');
1021: l_msg := l_msg||fnd_message.get||' ';
1022: FND_MESSAGE.SET_NAME('FII','FII_MISS_CONV_DATES');
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');
1021: l_msg := l_msg||fnd_message.get||' ';
1022: FND_MESSAGE.SET_NAME('FII','FII_MISS_CONV_DATES');
1023: l_msg := l_msg||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');
1021: l_msg := l_msg||fnd_message.get||' ';
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');
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');
1021: l_msg := l_msg||fnd_message.get||' ';
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;
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');
1021: l_msg := l_msg||fnd_message.get||' ';
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);
1019: l_msg := l_msg||fnd_message.get||' ';
1020: FND_MESSAGE.SET_NAME('FII','FII_TO_CURRENCY');
1021: l_msg := l_msg||fnd_message.get||' ';
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, '------------- ----------- --------------- -----------------');
1020: FND_MESSAGE.SET_NAME('FII','FII_TO_CURRENCY');
1021: l_msg := l_msg||fnd_message.get||' ';
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:
1021: l_msg := l_msg||fnd_message.get||' ';
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