642: Retcode:=0;
643: l_from_date :=to_date(p_from_date,'YYYY/MM/DD HH24:MI:SS');
644: l_to_date :=to_date(p_to_date, 'YYYY/MM/DD HH24:MI:SS');
645: IF (Not EDW_COLLECTION_UTIL.setup(l_fact_name)) THEN
646: errbuf := fnd_message.get;
647: RAISE_APPLICATION_ERROR(-20000,'Error in SETUP: ' || errbuf);
648: END IF;
649: FII_AP_INV_ON_HOLD_F_C.g_push_date_range1 := nvl(l_from_date,
650: EDW_COLLECTION_UTIL.G_local_last_push_start_date - EDW_COLLECTION_UTIL.g_offset);
777: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');
778:
779: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'FROM CURRENCY TO CURRENCY CONVERSION DATE COLLECTION STATUS');
780: */
781: FND_MESSAGE.SET_NAME('FII','FII_MISS_CONV_RATES');
782: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ***'||fnd_message.get||'*** ');
783: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');
784: FND_MESSAGE.SET_NAME('FII','FII_PAST_CONV_RATES');
785: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,fnd_message.get);
778:
779: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'FROM CURRENCY TO CURRENCY CONVERSION DATE COLLECTION STATUS');
780: */
781: FND_MESSAGE.SET_NAME('FII','FII_MISS_CONV_RATES');
782: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ***'||fnd_message.get||'*** ');
783: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');
784: FND_MESSAGE.SET_NAME('FII','FII_PAST_CONV_RATES');
785: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,fnd_message.get);
786: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');
780: */
781: FND_MESSAGE.SET_NAME('FII','FII_MISS_CONV_RATES');
782: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ***'||fnd_message.get||'*** ');
783: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');
784: FND_MESSAGE.SET_NAME('FII','FII_PAST_CONV_RATES');
785: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,fnd_message.get);
786: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');
787: FND_MESSAGE.SET_NAME('FII','FII_FROM_CURRENCY');
788: l_msg := l_msg||fnd_message.get||' ';
781: FND_MESSAGE.SET_NAME('FII','FII_MISS_CONV_RATES');
782: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ***'||fnd_message.get||'*** ');
783: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');
784: FND_MESSAGE.SET_NAME('FII','FII_PAST_CONV_RATES');
785: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,fnd_message.get);
786: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');
787: FND_MESSAGE.SET_NAME('FII','FII_FROM_CURRENCY');
788: l_msg := l_msg||fnd_message.get||' ';
789: FND_MESSAGE.SET_NAME('FII','FII_TO_CURRENCY');
783: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');
784: FND_MESSAGE.SET_NAME('FII','FII_PAST_CONV_RATES');
785: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,fnd_message.get);
786: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');
787: FND_MESSAGE.SET_NAME('FII','FII_FROM_CURRENCY');
788: l_msg := l_msg||fnd_message.get||' ';
789: FND_MESSAGE.SET_NAME('FII','FII_TO_CURRENCY');
790: l_msg := l_msg||fnd_message.get||' ';
791: FND_MESSAGE.SET_NAME('FII','FII_MISS_CONV_DATES');
784: FND_MESSAGE.SET_NAME('FII','FII_PAST_CONV_RATES');
785: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,fnd_message.get);
786: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');
787: FND_MESSAGE.SET_NAME('FII','FII_FROM_CURRENCY');
788: l_msg := l_msg||fnd_message.get||' ';
789: FND_MESSAGE.SET_NAME('FII','FII_TO_CURRENCY');
790: l_msg := l_msg||fnd_message.get||' ';
791: FND_MESSAGE.SET_NAME('FII','FII_MISS_CONV_DATES');
792: l_msg := l_msg||fnd_message.get||' ';
785: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,fnd_message.get);
786: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');
787: FND_MESSAGE.SET_NAME('FII','FII_FROM_CURRENCY');
788: l_msg := l_msg||fnd_message.get||' ';
789: FND_MESSAGE.SET_NAME('FII','FII_TO_CURRENCY');
790: l_msg := l_msg||fnd_message.get||' ';
791: FND_MESSAGE.SET_NAME('FII','FII_MISS_CONV_DATES');
792: l_msg := l_msg||fnd_message.get||' ';
793: FND_MESSAGE.SET_NAME('FII','FII_COLLECTION_STATUS');
786: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');
787: FND_MESSAGE.SET_NAME('FII','FII_FROM_CURRENCY');
788: l_msg := l_msg||fnd_message.get||' ';
789: FND_MESSAGE.SET_NAME('FII','FII_TO_CURRENCY');
790: l_msg := l_msg||fnd_message.get||' ';
791: FND_MESSAGE.SET_NAME('FII','FII_MISS_CONV_DATES');
792: l_msg := l_msg||fnd_message.get||' ';
793: FND_MESSAGE.SET_NAME('FII','FII_COLLECTION_STATUS');
794: l_msg := l_msg||fnd_message.get;
787: FND_MESSAGE.SET_NAME('FII','FII_FROM_CURRENCY');
788: l_msg := l_msg||fnd_message.get||' ';
789: FND_MESSAGE.SET_NAME('FII','FII_TO_CURRENCY');
790: l_msg := l_msg||fnd_message.get||' ';
791: FND_MESSAGE.SET_NAME('FII','FII_MISS_CONV_DATES');
792: l_msg := l_msg||fnd_message.get||' ';
793: FND_MESSAGE.SET_NAME('FII','FII_COLLECTION_STATUS');
794: l_msg := l_msg||fnd_message.get;
795: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_msg);
788: l_msg := l_msg||fnd_message.get||' ';
789: FND_MESSAGE.SET_NAME('FII','FII_TO_CURRENCY');
790: l_msg := l_msg||fnd_message.get||' ';
791: FND_MESSAGE.SET_NAME('FII','FII_MISS_CONV_DATES');
792: l_msg := l_msg||fnd_message.get||' ';
793: FND_MESSAGE.SET_NAME('FII','FII_COLLECTION_STATUS');
794: l_msg := l_msg||fnd_message.get;
795: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_msg);
796: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '------------- ----------- --------------- -----------------');
789: FND_MESSAGE.SET_NAME('FII','FII_TO_CURRENCY');
790: l_msg := l_msg||fnd_message.get||' ';
791: FND_MESSAGE.SET_NAME('FII','FII_MISS_CONV_DATES');
792: l_msg := l_msg||fnd_message.get||' ';
793: FND_MESSAGE.SET_NAME('FII','FII_COLLECTION_STATUS');
794: l_msg := l_msg||fnd_message.get;
795: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_msg);
796: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '------------- ----------- --------------- -----------------');
797:
790: l_msg := l_msg||fnd_message.get||' ';
791: FND_MESSAGE.SET_NAME('FII','FII_MISS_CONV_DATES');
792: l_msg := l_msg||fnd_message.get||' ';
793: FND_MESSAGE.SET_NAME('FII','FII_COLLECTION_STATUS');
794: l_msg := l_msg||fnd_message.get;
795: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_msg);
796: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '------------- ----------- --------------- -----------------');
797:
798: FOR c in c1 loop
814: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');
815: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'FROM CURRENCY TO CURRENCY CONVERSION DATE COLLECTION STATUS');
816: */
817: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');
818: FND_MESSAGE.SET_NAME('FII','FII_FUTURE_CONV_RATES');
819: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,fnd_message.get);
820: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');
821: l_msg := NULL;
822: FND_MESSAGE.SET_NAME('FII','FII_FROM_CURRENCY');
815: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'FROM CURRENCY TO CURRENCY CONVERSION DATE COLLECTION STATUS');
816: */
817: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');
818: FND_MESSAGE.SET_NAME('FII','FII_FUTURE_CONV_RATES');
819: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,fnd_message.get);
820: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');
821: l_msg := NULL;
822: FND_MESSAGE.SET_NAME('FII','FII_FROM_CURRENCY');
823: l_msg := l_msg||fnd_message.get||' ';
818: FND_MESSAGE.SET_NAME('FII','FII_FUTURE_CONV_RATES');
819: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,fnd_message.get);
820: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');
821: l_msg := NULL;
822: FND_MESSAGE.SET_NAME('FII','FII_FROM_CURRENCY');
823: l_msg := l_msg||fnd_message.get||' ';
824: FND_MESSAGE.SET_NAME('FII','FII_TO_CURRENCY');
825: l_msg := l_msg||fnd_message.get||' ';
826: FND_MESSAGE.SET_NAME('FII','FII_MISS_CONV_DATES');
819: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,fnd_message.get);
820: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');
821: l_msg := NULL;
822: FND_MESSAGE.SET_NAME('FII','FII_FROM_CURRENCY');
823: l_msg := l_msg||fnd_message.get||' ';
824: FND_MESSAGE.SET_NAME('FII','FII_TO_CURRENCY');
825: l_msg := l_msg||fnd_message.get||' ';
826: FND_MESSAGE.SET_NAME('FII','FII_MISS_CONV_DATES');
827: l_msg := l_msg||fnd_message.get||' ';
820: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');
821: l_msg := NULL;
822: FND_MESSAGE.SET_NAME('FII','FII_FROM_CURRENCY');
823: l_msg := l_msg||fnd_message.get||' ';
824: FND_MESSAGE.SET_NAME('FII','FII_TO_CURRENCY');
825: l_msg := l_msg||fnd_message.get||' ';
826: FND_MESSAGE.SET_NAME('FII','FII_MISS_CONV_DATES');
827: l_msg := l_msg||fnd_message.get||' ';
828: FND_MESSAGE.SET_NAME('FII','FII_COLLECTION_STATUS');
821: l_msg := NULL;
822: FND_MESSAGE.SET_NAME('FII','FII_FROM_CURRENCY');
823: l_msg := l_msg||fnd_message.get||' ';
824: FND_MESSAGE.SET_NAME('FII','FII_TO_CURRENCY');
825: l_msg := l_msg||fnd_message.get||' ';
826: FND_MESSAGE.SET_NAME('FII','FII_MISS_CONV_DATES');
827: l_msg := l_msg||fnd_message.get||' ';
828: FND_MESSAGE.SET_NAME('FII','FII_COLLECTION_STATUS');
829: l_msg := l_msg||fnd_message.get;
822: FND_MESSAGE.SET_NAME('FII','FII_FROM_CURRENCY');
823: l_msg := l_msg||fnd_message.get||' ';
824: FND_MESSAGE.SET_NAME('FII','FII_TO_CURRENCY');
825: l_msg := l_msg||fnd_message.get||' ';
826: FND_MESSAGE.SET_NAME('FII','FII_MISS_CONV_DATES');
827: l_msg := l_msg||fnd_message.get||' ';
828: FND_MESSAGE.SET_NAME('FII','FII_COLLECTION_STATUS');
829: l_msg := l_msg||fnd_message.get;
830: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_msg);
823: l_msg := l_msg||fnd_message.get||' ';
824: FND_MESSAGE.SET_NAME('FII','FII_TO_CURRENCY');
825: l_msg := l_msg||fnd_message.get||' ';
826: FND_MESSAGE.SET_NAME('FII','FII_MISS_CONV_DATES');
827: l_msg := l_msg||fnd_message.get||' ';
828: FND_MESSAGE.SET_NAME('FII','FII_COLLECTION_STATUS');
829: l_msg := l_msg||fnd_message.get;
830: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_msg);
831: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '------------- ----------- --------------- -----------------');
824: FND_MESSAGE.SET_NAME('FII','FII_TO_CURRENCY');
825: l_msg := l_msg||fnd_message.get||' ';
826: FND_MESSAGE.SET_NAME('FII','FII_MISS_CONV_DATES');
827: l_msg := l_msg||fnd_message.get||' ';
828: FND_MESSAGE.SET_NAME('FII','FII_COLLECTION_STATUS');
829: l_msg := l_msg||fnd_message.get;
830: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_msg);
831: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '------------- ----------- --------------- -----------------');
832:
825: l_msg := l_msg||fnd_message.get||' ';
826: FND_MESSAGE.SET_NAME('FII','FII_MISS_CONV_DATES');
827: l_msg := l_msg||fnd_message.get||' ';
828: FND_MESSAGE.SET_NAME('FII','FII_COLLECTION_STATUS');
829: l_msg := l_msg||fnd_message.get;
830: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_msg);
831: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '------------- ----------- --------------- -----------------');
832:
833: FOR d in c2 loop