DBA Data[Home] [Help]

APPS.FII_AP_INV_ON_HOLD_F_C dependencies on FND_MESSAGE

Line 646: errbuf := fnd_message.get;

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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:

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

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

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

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

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

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

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

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

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

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

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

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

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

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;

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

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

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

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

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

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:

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

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