679: Retcode:=0;
680: l_from_date :=to_date(p_from_date,'YYYY/MM/DD HH24:MI:SS');
681: l_to_date :=to_date(p_to_date, 'YYYY/MM/DD HH24:MI:SS');
682: IF (Not EDW_COLLECTION_UTIL.setup(l_fact_name)) THEN
683: errbuf := fnd_message.get;
684: RAISE_APPLICATION_ERROR(-20000,'Error in SETUP: ' || errbuf);
685: END IF;
686: FII_AP_HOLD_DATA_F_C.g_push_date_range1 := nvl(l_from_date,
687: EDW_COLLECTION_UTIL.G_local_last_push_start_date - EDW_COLLECTION_UTIL.g_offset);
815: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');
816:
817: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'FROM CURRENCY TO CURRENCY CONVERSION DATE COLLECTION STATUS');
818: */
819: FND_MESSAGE.SET_NAME('FII','FII_MISS_CONV_RATES');
820: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ***'||fnd_message.get||'*** ');
821: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');
822: FND_MESSAGE.SET_NAME('FII','FII_PAST_CONV_RATES');
823: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,fnd_message.get);
816:
817: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'FROM CURRENCY TO CURRENCY CONVERSION DATE COLLECTION STATUS');
818: */
819: FND_MESSAGE.SET_NAME('FII','FII_MISS_CONV_RATES');
820: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ***'||fnd_message.get||'*** ');
821: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');
822: FND_MESSAGE.SET_NAME('FII','FII_PAST_CONV_RATES');
823: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,fnd_message.get);
824: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');
818: */
819: FND_MESSAGE.SET_NAME('FII','FII_MISS_CONV_RATES');
820: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ***'||fnd_message.get||'*** ');
821: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');
822: FND_MESSAGE.SET_NAME('FII','FII_PAST_CONV_RATES');
823: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,fnd_message.get);
824: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');
825: FND_MESSAGE.SET_NAME('FII','FII_FROM_CURRENCY');
826: l_msg := l_msg||fnd_message.get||' ';
819: FND_MESSAGE.SET_NAME('FII','FII_MISS_CONV_RATES');
820: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ***'||fnd_message.get||'*** ');
821: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');
822: FND_MESSAGE.SET_NAME('FII','FII_PAST_CONV_RATES');
823: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,fnd_message.get);
824: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');
825: FND_MESSAGE.SET_NAME('FII','FII_FROM_CURRENCY');
826: l_msg := l_msg||fnd_message.get||' ';
827: FND_MESSAGE.SET_NAME('FII','FII_TO_CURRENCY');
821: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');
822: FND_MESSAGE.SET_NAME('FII','FII_PAST_CONV_RATES');
823: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,fnd_message.get);
824: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');
825: FND_MESSAGE.SET_NAME('FII','FII_FROM_CURRENCY');
826: l_msg := l_msg||fnd_message.get||' ';
827: FND_MESSAGE.SET_NAME('FII','FII_TO_CURRENCY');
828: l_msg := l_msg||fnd_message.get||' ';
829: FND_MESSAGE.SET_NAME('FII','FII_MISS_CONV_DATES');
822: FND_MESSAGE.SET_NAME('FII','FII_PAST_CONV_RATES');
823: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,fnd_message.get);
824: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');
825: FND_MESSAGE.SET_NAME('FII','FII_FROM_CURRENCY');
826: l_msg := l_msg||fnd_message.get||' ';
827: FND_MESSAGE.SET_NAME('FII','FII_TO_CURRENCY');
828: l_msg := l_msg||fnd_message.get||' ';
829: FND_MESSAGE.SET_NAME('FII','FII_MISS_CONV_DATES');
830: l_msg := l_msg||fnd_message.get||' ';
823: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,fnd_message.get);
824: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');
825: FND_MESSAGE.SET_NAME('FII','FII_FROM_CURRENCY');
826: l_msg := l_msg||fnd_message.get||' ';
827: FND_MESSAGE.SET_NAME('FII','FII_TO_CURRENCY');
828: l_msg := l_msg||fnd_message.get||' ';
829: FND_MESSAGE.SET_NAME('FII','FII_MISS_CONV_DATES');
830: l_msg := l_msg||fnd_message.get||' ';
831: FND_MESSAGE.SET_NAME('FII','FII_COLLECTION_STATUS');
824: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');
825: FND_MESSAGE.SET_NAME('FII','FII_FROM_CURRENCY');
826: l_msg := l_msg||fnd_message.get||' ';
827: FND_MESSAGE.SET_NAME('FII','FII_TO_CURRENCY');
828: l_msg := l_msg||fnd_message.get||' ';
829: FND_MESSAGE.SET_NAME('FII','FII_MISS_CONV_DATES');
830: l_msg := l_msg||fnd_message.get||' ';
831: FND_MESSAGE.SET_NAME('FII','FII_COLLECTION_STATUS');
832: l_msg := l_msg||fnd_message.get;
825: FND_MESSAGE.SET_NAME('FII','FII_FROM_CURRENCY');
826: l_msg := l_msg||fnd_message.get||' ';
827: FND_MESSAGE.SET_NAME('FII','FII_TO_CURRENCY');
828: l_msg := l_msg||fnd_message.get||' ';
829: FND_MESSAGE.SET_NAME('FII','FII_MISS_CONV_DATES');
830: l_msg := l_msg||fnd_message.get||' ';
831: FND_MESSAGE.SET_NAME('FII','FII_COLLECTION_STATUS');
832: l_msg := l_msg||fnd_message.get;
833: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_msg);
826: l_msg := l_msg||fnd_message.get||' ';
827: FND_MESSAGE.SET_NAME('FII','FII_TO_CURRENCY');
828: l_msg := l_msg||fnd_message.get||' ';
829: FND_MESSAGE.SET_NAME('FII','FII_MISS_CONV_DATES');
830: l_msg := l_msg||fnd_message.get||' ';
831: FND_MESSAGE.SET_NAME('FII','FII_COLLECTION_STATUS');
832: l_msg := l_msg||fnd_message.get;
833: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_msg);
834: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '------------- ----------- --------------- -----------------');
827: FND_MESSAGE.SET_NAME('FII','FII_TO_CURRENCY');
828: l_msg := l_msg||fnd_message.get||' ';
829: FND_MESSAGE.SET_NAME('FII','FII_MISS_CONV_DATES');
830: l_msg := l_msg||fnd_message.get||' ';
831: FND_MESSAGE.SET_NAME('FII','FII_COLLECTION_STATUS');
832: l_msg := l_msg||fnd_message.get;
833: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_msg);
834: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '------------- ----------- --------------- -----------------');
835:
828: l_msg := l_msg||fnd_message.get||' ';
829: FND_MESSAGE.SET_NAME('FII','FII_MISS_CONV_DATES');
830: l_msg := l_msg||fnd_message.get||' ';
831: FND_MESSAGE.SET_NAME('FII','FII_COLLECTION_STATUS');
832: l_msg := l_msg||fnd_message.get;
833: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_msg);
834: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '------------- ----------- --------------- -----------------');
835:
836: FOR c in c1 loop
852: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');
853: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'FROM CURRENCY TO CURRENCY CONVERSION DATE COLLECTION STATUS');
854: */
855: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');
856: FND_MESSAGE.SET_NAME('FII','FII_FUTURE_CONV_RATES');
857: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,fnd_message.get);
858: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');
859: l_msg := NULL;
860: FND_MESSAGE.SET_NAME('FII','FII_FROM_CURRENCY');
853: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'FROM CURRENCY TO CURRENCY CONVERSION DATE COLLECTION STATUS');
854: */
855: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');
856: FND_MESSAGE.SET_NAME('FII','FII_FUTURE_CONV_RATES');
857: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,fnd_message.get);
858: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');
859: l_msg := NULL;
860: FND_MESSAGE.SET_NAME('FII','FII_FROM_CURRENCY');
861: l_msg := l_msg||fnd_message.get||' ';
856: FND_MESSAGE.SET_NAME('FII','FII_FUTURE_CONV_RATES');
857: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,fnd_message.get);
858: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');
859: l_msg := NULL;
860: FND_MESSAGE.SET_NAME('FII','FII_FROM_CURRENCY');
861: l_msg := l_msg||fnd_message.get||' ';
862: FND_MESSAGE.SET_NAME('FII','FII_TO_CURRENCY');
863: l_msg := l_msg||fnd_message.get||' ';
864: FND_MESSAGE.SET_NAME('FII','FII_MISS_CONV_DATES');
857: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,fnd_message.get);
858: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');
859: l_msg := NULL;
860: FND_MESSAGE.SET_NAME('FII','FII_FROM_CURRENCY');
861: l_msg := l_msg||fnd_message.get||' ';
862: FND_MESSAGE.SET_NAME('FII','FII_TO_CURRENCY');
863: l_msg := l_msg||fnd_message.get||' ';
864: FND_MESSAGE.SET_NAME('FII','FII_MISS_CONV_DATES');
865: l_msg := l_msg||fnd_message.get||' ';
858: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');
859: l_msg := NULL;
860: FND_MESSAGE.SET_NAME('FII','FII_FROM_CURRENCY');
861: l_msg := l_msg||fnd_message.get||' ';
862: FND_MESSAGE.SET_NAME('FII','FII_TO_CURRENCY');
863: l_msg := l_msg||fnd_message.get||' ';
864: FND_MESSAGE.SET_NAME('FII','FII_MISS_CONV_DATES');
865: l_msg := l_msg||fnd_message.get||' ';
866: FND_MESSAGE.SET_NAME('FII','FII_COLLECTION_STATUS');
859: l_msg := NULL;
860: FND_MESSAGE.SET_NAME('FII','FII_FROM_CURRENCY');
861: l_msg := l_msg||fnd_message.get||' ';
862: FND_MESSAGE.SET_NAME('FII','FII_TO_CURRENCY');
863: l_msg := l_msg||fnd_message.get||' ';
864: FND_MESSAGE.SET_NAME('FII','FII_MISS_CONV_DATES');
865: l_msg := l_msg||fnd_message.get||' ';
866: FND_MESSAGE.SET_NAME('FII','FII_COLLECTION_STATUS');
867: l_msg := l_msg||fnd_message.get;
860: FND_MESSAGE.SET_NAME('FII','FII_FROM_CURRENCY');
861: l_msg := l_msg||fnd_message.get||' ';
862: FND_MESSAGE.SET_NAME('FII','FII_TO_CURRENCY');
863: l_msg := l_msg||fnd_message.get||' ';
864: FND_MESSAGE.SET_NAME('FII','FII_MISS_CONV_DATES');
865: l_msg := l_msg||fnd_message.get||' ';
866: FND_MESSAGE.SET_NAME('FII','FII_COLLECTION_STATUS');
867: l_msg := l_msg||fnd_message.get;
868: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_msg);
861: l_msg := l_msg||fnd_message.get||' ';
862: FND_MESSAGE.SET_NAME('FII','FII_TO_CURRENCY');
863: l_msg := l_msg||fnd_message.get||' ';
864: FND_MESSAGE.SET_NAME('FII','FII_MISS_CONV_DATES');
865: l_msg := l_msg||fnd_message.get||' ';
866: FND_MESSAGE.SET_NAME('FII','FII_COLLECTION_STATUS');
867: l_msg := l_msg||fnd_message.get;
868: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_msg);
869: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '------------- ----------- --------------- -----------------');
862: FND_MESSAGE.SET_NAME('FII','FII_TO_CURRENCY');
863: l_msg := l_msg||fnd_message.get||' ';
864: FND_MESSAGE.SET_NAME('FII','FII_MISS_CONV_DATES');
865: l_msg := l_msg||fnd_message.get||' ';
866: FND_MESSAGE.SET_NAME('FII','FII_COLLECTION_STATUS');
867: l_msg := l_msg||fnd_message.get;
868: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_msg);
869: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '------------- ----------- --------------- -----------------');
870:
863: l_msg := l_msg||fnd_message.get||' ';
864: FND_MESSAGE.SET_NAME('FII','FII_MISS_CONV_DATES');
865: l_msg := l_msg||fnd_message.get||' ';
866: FND_MESSAGE.SET_NAME('FII','FII_COLLECTION_STATUS');
867: l_msg := l_msg||fnd_message.get;
868: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_msg);
869: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '------------- ----------- --------------- -----------------');
870:
871: FOR d in c2 loop