DBA Data[Home] [Help]

APPS.FII_AP_HOLD_DATA_F_C dependencies on FND_MESSAGE

Line 683: errbuf := fnd_message.get;

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);

Line 819: FND_MESSAGE.SET_NAME('FII','FII_MISS_CONV_RATES');

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);

Line 820: 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,' ');

Line 822: FND_MESSAGE.SET_NAME('FII','FII_PAST_CONV_RATES');

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||' ';

Line 823: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,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');

Line 825: FND_MESSAGE.SET_NAME('FII','FII_FROM_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');

Line 826: l_msg := l_msg||fnd_message.get||' ';

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||' ';

Line 827: FND_MESSAGE.SET_NAME('FII','FII_TO_CURRENCY');

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');

Line 828: l_msg := l_msg||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');
832: l_msg := l_msg||fnd_message.get;

Line 829: FND_MESSAGE.SET_NAME('FII','FII_MISS_CONV_DATES');

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);

Line 830: l_msg := l_msg||fnd_message.get||' ';

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, '------------- ----------- --------------- -----------------');

Line 831: FND_MESSAGE.SET_NAME('FII','FII_COLLECTION_STATUS');

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:

Line 832: l_msg := l_msg||fnd_message.get;

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

Line 856: FND_MESSAGE.SET_NAME('FII','FII_FUTURE_CONV_RATES');

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');

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

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||' ';

Line 860: FND_MESSAGE.SET_NAME('FII','FII_FROM_CURRENCY');

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');

Line 861: l_msg := l_msg||fnd_message.get||' ';

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||' ';

Line 862: FND_MESSAGE.SET_NAME('FII','FII_TO_CURRENCY');

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');

Line 863: l_msg := l_msg||fnd_message.get||' ';

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;

Line 864: FND_MESSAGE.SET_NAME('FII','FII_MISS_CONV_DATES');

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);

Line 865: l_msg := l_msg||fnd_message.get||' ';

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, '------------- ----------- --------------- -----------------');

Line 866: FND_MESSAGE.SET_NAME('FII','FII_COLLECTION_STATUS');

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:

Line 867: l_msg := l_msg||fnd_message.get;

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