830: Retcode:=0;
831: l_from_date :=to_date(p_from_date,'YYYY/MM/DD HH24:MI:SS');
832: l_to_date :=to_date(p_to_date, 'YYYY/MM/DD HH24:MI:SS');
833: IF (Not EDW_COLLECTION_UTIL.setup(l_fact_name)) THEN
834: errbuf := fnd_message.get;
835: RAISE_APPLICATION_ERROR(-20000,'Error in SETUP: ' || errbuf);
836: END IF;
837: FII_AP_INV_PAYMTS_F_C.g_push_date_range1 := nvl(l_from_date,
838: EDW_COLLECTION_UTIL.G_local_last_push_start_date - EDW_COLLECTION_UTIL.g_offset);
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,' ');
970: FND_MESSAGE.SET_NAME('FII','FII_PAST_CONV_RATES');
971: 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,' ');
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');
974: l_msg := l_msg||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');
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');
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||' ';
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');
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;
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);
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, '------------- ----------- --------------- -----------------');
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:
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
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;
1008: FND_MESSAGE.SET_NAME('FII','FII_FROM_CURRENCY');
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||' ';
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');
1011: l_msg := l_msg||fnd_message.get||' ';
1012: FND_MESSAGE.SET_NAME('FII','FII_MISS_CONV_DATES');
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');
1011: l_msg := l_msg||fnd_message.get||' ';
1012: FND_MESSAGE.SET_NAME('FII','FII_MISS_CONV_DATES');
1013: l_msg := l_msg||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');
1011: l_msg := l_msg||fnd_message.get||' ';
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');
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');
1011: l_msg := l_msg||fnd_message.get||' ';
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;
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');
1011: l_msg := l_msg||fnd_message.get||' ';
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);
1009: l_msg := l_msg||fnd_message.get||' ';
1010: FND_MESSAGE.SET_NAME('FII','FII_TO_CURRENCY');
1011: l_msg := l_msg||fnd_message.get||' ';
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, '------------- ----------- --------------- -----------------');
1010: FND_MESSAGE.SET_NAME('FII','FII_TO_CURRENCY');
1011: l_msg := l_msg||fnd_message.get||' ';
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:
1011: l_msg := l_msg||fnd_message.get||' ';
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