eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.FND_NEW_MESSAGES_PKG dependencies on FND_MESSAGE

Line 645: fnd_message.set_name('FND', 'AFDICT_VAL_INVALID_TYPE');

641: '30_PCT_EXPANSION_PROMPT',
642: '50_PCT_EXPANSION_PROMPT',
643: '100_PCT_EXPANSION_PROMPT',
644: 'MENU', 'TOKEN', 'OTHER') then
645: fnd_message.set_name('FND', 'AFDICT_VAL_INVALID_TYPE');
646: fnd_message.set_token('MESSAGE_NAME', X_MESSAGE_NAME);
647: fnd_message.set_token('TYPE', X_TYPE);
648: app_exception.raise_exception();
649: end if;

Line 646: fnd_message.set_token('MESSAGE_NAME', X_MESSAGE_NAME);

642: '50_PCT_EXPANSION_PROMPT',
643: '100_PCT_EXPANSION_PROMPT',
644: 'MENU', 'TOKEN', 'OTHER') then
645: fnd_message.set_name('FND', 'AFDICT_VAL_INVALID_TYPE');
646: fnd_message.set_token('MESSAGE_NAME', X_MESSAGE_NAME);
647: fnd_message.set_token('TYPE', X_TYPE);
648: app_exception.raise_exception();
649: end if;
650:

Line 647: fnd_message.set_token('TYPE', X_TYPE);

643: '100_PCT_EXPANSION_PROMPT',
644: 'MENU', 'TOKEN', 'OTHER') then
645: fnd_message.set_name('FND', 'AFDICT_VAL_INVALID_TYPE');
646: fnd_message.set_token('MESSAGE_NAME', X_MESSAGE_NAME);
647: fnd_message.set_token('TYPE', X_TYPE);
648: app_exception.raise_exception();
649: end if;
650:
651: end CHECK_MESSAGE_TYPE;

Line 667: fnd_message.set_name('FND', 'AFDICT_VAL_NEED_DESCR');

663: -- ******************************
664:
665: if X_TYPE in ('OTHER', 'TOKEN')
666: and X_DESCRIPTION is null then
667: fnd_message.set_name('FND', 'AFDICT_VAL_NEED_DESCR');
668: fnd_message.set_token('MESSAGE_NAME', X_MESSAGE_NAME);
669: fnd_message.set_token('TYPE', X_TYPE);
670: app_exception.raise_exception();
671: end if;

Line 668: fnd_message.set_token('MESSAGE_NAME', X_MESSAGE_NAME);

664:
665: if X_TYPE in ('OTHER', 'TOKEN')
666: and X_DESCRIPTION is null then
667: fnd_message.set_name('FND', 'AFDICT_VAL_NEED_DESCR');
668: fnd_message.set_token('MESSAGE_NAME', X_MESSAGE_NAME);
669: fnd_message.set_token('TYPE', X_TYPE);
670: app_exception.raise_exception();
671: end if;
672:

Line 669: fnd_message.set_token('TYPE', X_TYPE);

665: if X_TYPE in ('OTHER', 'TOKEN')
666: and X_DESCRIPTION is null then
667: fnd_message.set_name('FND', 'AFDICT_VAL_NEED_DESCR');
668: fnd_message.set_token('MESSAGE_NAME', X_MESSAGE_NAME);
669: fnd_message.set_token('TYPE', X_TYPE);
670: app_exception.raise_exception();
671: end if;
672:
673: end CHECK_MESSAGE_DESCRIPTION;

Line 689: fnd_message.set_name('FND', 'AFDICT_VAL_MAX_LEN_NOTNULL');

685: -- ******************************
686: if(X_TYPE not in ('ERROR', 'NOTE', 'TOKEN', 'OTHER')
687: and X_TYPE is not null
688: and X_MAX_LENGTH is not null) then
689: fnd_message.set_name('FND', 'AFDICT_VAL_MAX_LEN_NOTNULL');
690: fnd_message.set_token('MESSAGE_NAME', X_MESSAGE_NAME);
691: fnd_message.set_token('TYPE', X_TYPE);
692: app_exception.raise_exception();
693: end if;

Line 690: fnd_message.set_token('MESSAGE_NAME', X_MESSAGE_NAME);

686: if(X_TYPE not in ('ERROR', 'NOTE', 'TOKEN', 'OTHER')
687: and X_TYPE is not null
688: and X_MAX_LENGTH is not null) then
689: fnd_message.set_name('FND', 'AFDICT_VAL_MAX_LEN_NOTNULL');
690: fnd_message.set_token('MESSAGE_NAME', X_MESSAGE_NAME);
691: fnd_message.set_token('TYPE', X_TYPE);
692: app_exception.raise_exception();
693: end if;
694:

Line 691: fnd_message.set_token('TYPE', X_TYPE);

687: and X_TYPE is not null
688: and X_MAX_LENGTH is not null) then
689: fnd_message.set_name('FND', 'AFDICT_VAL_MAX_LEN_NOTNULL');
690: fnd_message.set_token('MESSAGE_NAME', X_MESSAGE_NAME);
691: fnd_message.set_token('TYPE', X_TYPE);
692: app_exception.raise_exception();
693: end if;
694:
695: end CHECK_MAX_LENGTH_TYPE;

Line 736: fnd_message.set_name('FND', 'AFDICT_VAL_MAXLEN_SMALL');

732: trans_length := limit_length/1.3;
733: if (actual_length > limit_length) then
734: if ((X_VALIDATION is not null) and (X_VALIDATION='POST_TRANSLATE'))
735: or (X_VALIDATION is null) then
736: fnd_message.set_name('FND', 'AFDICT_VAL_MAXLEN_SMALL');
737: fnd_message.set_token('MESSAGE_NAME', X_MESSAGE_NAME);
738: fnd_message.set_token('MESSAGE_TEXT_LENGTH', actual_length);
739: fnd_message.set_token('MAXIMUM_LENGTH', limit_length);
740: app_exception.raise_exception();

Line 737: fnd_message.set_token('MESSAGE_NAME', X_MESSAGE_NAME);

733: if (actual_length > limit_length) then
734: if ((X_VALIDATION is not null) and (X_VALIDATION='POST_TRANSLATE'))
735: or (X_VALIDATION is null) then
736: fnd_message.set_name('FND', 'AFDICT_VAL_MAXLEN_SMALL');
737: fnd_message.set_token('MESSAGE_NAME', X_MESSAGE_NAME);
738: fnd_message.set_token('MESSAGE_TEXT_LENGTH', actual_length);
739: fnd_message.set_token('MAXIMUM_LENGTH', limit_length);
740: app_exception.raise_exception();
741: end if;

Line 738: fnd_message.set_token('MESSAGE_TEXT_LENGTH', actual_length);

734: if ((X_VALIDATION is not null) and (X_VALIDATION='POST_TRANSLATE'))
735: or (X_VALIDATION is null) then
736: fnd_message.set_name('FND', 'AFDICT_VAL_MAXLEN_SMALL');
737: fnd_message.set_token('MESSAGE_NAME', X_MESSAGE_NAME);
738: fnd_message.set_token('MESSAGE_TEXT_LENGTH', actual_length);
739: fnd_message.set_token('MAXIMUM_LENGTH', limit_length);
740: app_exception.raise_exception();
741: end if;
742: end if;

Line 739: fnd_message.set_token('MAXIMUM_LENGTH', limit_length);

735: or (X_VALIDATION is null) then
736: fnd_message.set_name('FND', 'AFDICT_VAL_MAXLEN_SMALL');
737: fnd_message.set_token('MESSAGE_NAME', X_MESSAGE_NAME);
738: fnd_message.set_token('MESSAGE_TEXT_LENGTH', actual_length);
739: fnd_message.set_token('MAXIMUM_LENGTH', limit_length);
740: app_exception.raise_exception();
741: end if;
742: end if;
743: if (actual_length > trans_length) then

Line 746: fnd_message.set_name('FND', 'AFDICT_VAL_MAXLEN_SMALL_TRN');

742: end if;
743: if (actual_length > trans_length) then
744: if ((X_VALIDATION is not null) and (X_VALIDATION='STRICT'))
745: then
746: fnd_message.set_name('FND', 'AFDICT_VAL_MAXLEN_SMALL_TRN');
747: fnd_message.set_token('MESSAGE_NAME', X_MESSAGE_NAME);
748: fnd_message.set_token('MESSAGE_TEXT_LENGTH', actual_length);
749: fnd_message.set_token('MAXIMUM_LENGTH', limit_length);
750: fnd_message.set_token('TRANSLATED_MAXIMUM_LENGTH',

Line 747: fnd_message.set_token('MESSAGE_NAME', X_MESSAGE_NAME);

743: if (actual_length > trans_length) then
744: if ((X_VALIDATION is not null) and (X_VALIDATION='STRICT'))
745: then
746: fnd_message.set_name('FND', 'AFDICT_VAL_MAXLEN_SMALL_TRN');
747: fnd_message.set_token('MESSAGE_NAME', X_MESSAGE_NAME);
748: fnd_message.set_token('MESSAGE_TEXT_LENGTH', actual_length);
749: fnd_message.set_token('MAXIMUM_LENGTH', limit_length);
750: fnd_message.set_token('TRANSLATED_MAXIMUM_LENGTH',
751: trans_length);

Line 748: fnd_message.set_token('MESSAGE_TEXT_LENGTH', actual_length);

744: if ((X_VALIDATION is not null) and (X_VALIDATION='STRICT'))
745: then
746: fnd_message.set_name('FND', 'AFDICT_VAL_MAXLEN_SMALL_TRN');
747: fnd_message.set_token('MESSAGE_NAME', X_MESSAGE_NAME);
748: fnd_message.set_token('MESSAGE_TEXT_LENGTH', actual_length);
749: fnd_message.set_token('MAXIMUM_LENGTH', limit_length);
750: fnd_message.set_token('TRANSLATED_MAXIMUM_LENGTH',
751: trans_length);
752: app_exception.raise_exception();

Line 749: fnd_message.set_token('MAXIMUM_LENGTH', limit_length);

745: then
746: fnd_message.set_name('FND', 'AFDICT_VAL_MAXLEN_SMALL_TRN');
747: fnd_message.set_token('MESSAGE_NAME', X_MESSAGE_NAME);
748: fnd_message.set_token('MESSAGE_TEXT_LENGTH', actual_length);
749: fnd_message.set_token('MAXIMUM_LENGTH', limit_length);
750: fnd_message.set_token('TRANSLATED_MAXIMUM_LENGTH',
751: trans_length);
752: app_exception.raise_exception();
753: end if;

Line 750: fnd_message.set_token('TRANSLATED_MAXIMUM_LENGTH',

746: fnd_message.set_name('FND', 'AFDICT_VAL_MAXLEN_SMALL_TRN');
747: fnd_message.set_token('MESSAGE_NAME', X_MESSAGE_NAME);
748: fnd_message.set_token('MESSAGE_TEXT_LENGTH', actual_length);
749: fnd_message.set_token('MAXIMUM_LENGTH', limit_length);
750: fnd_message.set_token('TRANSLATED_MAXIMUM_LENGTH',
751: trans_length);
752: app_exception.raise_exception();
753: end if;
754: end if;

Line 814: fnd_message.set_name('FND', 'AFDICT_VAL_SINGLE_AMP_MIDDLE');

810:
811: token := ltrim(rtrim(token));
812:
813: if (substr(token,1,1) <> '&') and (instr(token,'&&',1)=0) then
814: fnd_message.set_name('FND', 'AFDICT_VAL_SINGLE_AMP_MIDDLE');
815: fnd_message.set_token('MESSAGE_NAME', X_MESSAGE_NAME);
816: fnd_message.set_token('WORD', token);
817: app_exception.raise_exception();
818: end if;

Line 815: fnd_message.set_token('MESSAGE_NAME', X_MESSAGE_NAME);

811: token := ltrim(rtrim(token));
812:
813: if (substr(token,1,1) <> '&') and (instr(token,'&&',1)=0) then
814: fnd_message.set_name('FND', 'AFDICT_VAL_SINGLE_AMP_MIDDLE');
815: fnd_message.set_token('MESSAGE_NAME', X_MESSAGE_NAME);
816: fnd_message.set_token('WORD', token);
817: app_exception.raise_exception();
818: end if;
819:

Line 816: fnd_message.set_token('WORD', token);

812:
813: if (substr(token,1,1) <> '&') and (instr(token,'&&',1)=0) then
814: fnd_message.set_name('FND', 'AFDICT_VAL_SINGLE_AMP_MIDDLE');
815: fnd_message.set_token('MESSAGE_NAME', X_MESSAGE_NAME);
816: fnd_message.set_token('WORD', token);
817: app_exception.raise_exception();
818: end if;
819:
820: if upper(token)=token and instr(token,'&&',1)>0 then

Line 821: fnd_message.set_name('FND', 'AFDICT_VAL_DOUBLE_AMP_UPPER');

817: app_exception.raise_exception();
818: end if;
819:
820: if upper(token)=token and instr(token,'&&',1)>0 then
821: fnd_message.set_name('FND', 'AFDICT_VAL_DOUBLE_AMP_UPPER');
822: fnd_message.set_token('MESSAGE_NAME', X_MESSAGE_NAME);
823: fnd_message.set_token('WORD', token);
824: app_exception.raise_exception();
825: end if;

Line 822: fnd_message.set_token('MESSAGE_NAME', X_MESSAGE_NAME);

818: end if;
819:
820: if upper(token)=token and instr(token,'&&',1)>0 then
821: fnd_message.set_name('FND', 'AFDICT_VAL_DOUBLE_AMP_UPPER');
822: fnd_message.set_token('MESSAGE_NAME', X_MESSAGE_NAME);
823: fnd_message.set_token('WORD', token);
824: app_exception.raise_exception();
825: end if;
826:

Line 823: fnd_message.set_token('WORD', token);

819:
820: if upper(token)=token and instr(token,'&&',1)>0 then
821: fnd_message.set_name('FND', 'AFDICT_VAL_DOUBLE_AMP_UPPER');
822: fnd_message.set_token('MESSAGE_NAME', X_MESSAGE_NAME);
823: fnd_message.set_token('WORD', token);
824: app_exception.raise_exception();
825: end if;
826:
827: if upper(token)<>token and substr(token,1,1)='&'

Line 829: fnd_message.set_name('FND', 'AFDICT_VAL_SINGLE_AMP_MIXED');

825: end if;
826:
827: if upper(token)<>token and substr(token,1,1)='&'
828: and substr(token,2,1)<>'&' then
829: fnd_message.set_name('FND', 'AFDICT_VAL_SINGLE_AMP_MIXED');
830: fnd_message.set_token('MESSAGE_NAME', X_MESSAGE_NAME);
831: fnd_message.set_token('WORD', token);
832: app_exception.raise_exception();
833: end if;

Line 830: fnd_message.set_token('MESSAGE_NAME', X_MESSAGE_NAME);

826:
827: if upper(token)<>token and substr(token,1,1)='&'
828: and substr(token,2,1)<>'&' then
829: fnd_message.set_name('FND', 'AFDICT_VAL_SINGLE_AMP_MIXED');
830: fnd_message.set_token('MESSAGE_NAME', X_MESSAGE_NAME);
831: fnd_message.set_token('WORD', token);
832: app_exception.raise_exception();
833: end if;
834:

Line 831: fnd_message.set_token('WORD', token);

827: if upper(token)<>token and substr(token,1,1)='&'
828: and substr(token,2,1)<>'&' then
829: fnd_message.set_name('FND', 'AFDICT_VAL_SINGLE_AMP_MIXED');
830: fnd_message.set_token('MESSAGE_NAME', X_MESSAGE_NAME);
831: fnd_message.set_token('WORD', token);
832: app_exception.raise_exception();
833: end if;
834:
835: if substr(line, i+1,1)='&' then

Line 904: fnd_message.set_name('FND', 'AFDICT_VAL_TYPELEN_SMALL');

900: trans_length := limit_length/trans_ratio;
901: if (actual_length > limit_length) then
902: if ((X_VALIDATION is not null) and (X_VALIDATION='POST_TRANSLATE'))
903: or (X_VALIDATION is null) then
904: fnd_message.set_name('FND', 'AFDICT_VAL_TYPELEN_SMALL');
905: fnd_message.set_token('MESSAGE_NAME', X_MESSAGE_NAME);
906: fnd_message.set_token('MESSAGE_TEXT_LENGTH', actual_length);
907: fnd_message.set_token('MAXIMUM_LENGTH', limit_length);
908: fnd_message.set_token('TYPE', X_TYPE);

Line 905: fnd_message.set_token('MESSAGE_NAME', X_MESSAGE_NAME);

901: if (actual_length > limit_length) then
902: if ((X_VALIDATION is not null) and (X_VALIDATION='POST_TRANSLATE'))
903: or (X_VALIDATION is null) then
904: fnd_message.set_name('FND', 'AFDICT_VAL_TYPELEN_SMALL');
905: fnd_message.set_token('MESSAGE_NAME', X_MESSAGE_NAME);
906: fnd_message.set_token('MESSAGE_TEXT_LENGTH', actual_length);
907: fnd_message.set_token('MAXIMUM_LENGTH', limit_length);
908: fnd_message.set_token('TYPE', X_TYPE);
909: app_exception.raise_exception();

Line 906: fnd_message.set_token('MESSAGE_TEXT_LENGTH', actual_length);

902: if ((X_VALIDATION is not null) and (X_VALIDATION='POST_TRANSLATE'))
903: or (X_VALIDATION is null) then
904: fnd_message.set_name('FND', 'AFDICT_VAL_TYPELEN_SMALL');
905: fnd_message.set_token('MESSAGE_NAME', X_MESSAGE_NAME);
906: fnd_message.set_token('MESSAGE_TEXT_LENGTH', actual_length);
907: fnd_message.set_token('MAXIMUM_LENGTH', limit_length);
908: fnd_message.set_token('TYPE', X_TYPE);
909: app_exception.raise_exception();
910: end if;

Line 907: fnd_message.set_token('MAXIMUM_LENGTH', limit_length);

903: or (X_VALIDATION is null) then
904: fnd_message.set_name('FND', 'AFDICT_VAL_TYPELEN_SMALL');
905: fnd_message.set_token('MESSAGE_NAME', X_MESSAGE_NAME);
906: fnd_message.set_token('MESSAGE_TEXT_LENGTH', actual_length);
907: fnd_message.set_token('MAXIMUM_LENGTH', limit_length);
908: fnd_message.set_token('TYPE', X_TYPE);
909: app_exception.raise_exception();
910: end if;
911: end if;

Line 908: fnd_message.set_token('TYPE', X_TYPE);

904: fnd_message.set_name('FND', 'AFDICT_VAL_TYPELEN_SMALL');
905: fnd_message.set_token('MESSAGE_NAME', X_MESSAGE_NAME);
906: fnd_message.set_token('MESSAGE_TEXT_LENGTH', actual_length);
907: fnd_message.set_token('MAXIMUM_LENGTH', limit_length);
908: fnd_message.set_token('TYPE', X_TYPE);
909: app_exception.raise_exception();
910: end if;
911: end if;
912: if lengthb(X_MESSAGE_TEXT) > trans_length then

Line 915: fnd_message.set_name('FND', 'AFDICT_VAL_TYPELEN_SMALL_TRN');

911: end if;
912: if lengthb(X_MESSAGE_TEXT) > trans_length then
913: if ((X_VALIDATION is not null) and (X_VALIDATION='STRICT'))
914: then
915: fnd_message.set_name('FND', 'AFDICT_VAL_TYPELEN_SMALL_TRN');
916: fnd_message.set_token('MESSAGE_NAME', X_MESSAGE_NAME);
917: fnd_message.set_token('MESSAGE_TEXT_LENGTH', actual_length);
918: fnd_message.set_token('MAXIMUM_LENGTH', limit_length);
919: fnd_message.set_token('TRANSLATED_MAXIMUM_LENGTH', trans_length);

Line 916: fnd_message.set_token('MESSAGE_NAME', X_MESSAGE_NAME);

912: if lengthb(X_MESSAGE_TEXT) > trans_length then
913: if ((X_VALIDATION is not null) and (X_VALIDATION='STRICT'))
914: then
915: fnd_message.set_name('FND', 'AFDICT_VAL_TYPELEN_SMALL_TRN');
916: fnd_message.set_token('MESSAGE_NAME', X_MESSAGE_NAME);
917: fnd_message.set_token('MESSAGE_TEXT_LENGTH', actual_length);
918: fnd_message.set_token('MAXIMUM_LENGTH', limit_length);
919: fnd_message.set_token('TRANSLATED_MAXIMUM_LENGTH', trans_length);
920: fnd_message.set_token('TYPE', X_TYPE);

Line 917: fnd_message.set_token('MESSAGE_TEXT_LENGTH', actual_length);

913: if ((X_VALIDATION is not null) and (X_VALIDATION='STRICT'))
914: then
915: fnd_message.set_name('FND', 'AFDICT_VAL_TYPELEN_SMALL_TRN');
916: fnd_message.set_token('MESSAGE_NAME', X_MESSAGE_NAME);
917: fnd_message.set_token('MESSAGE_TEXT_LENGTH', actual_length);
918: fnd_message.set_token('MAXIMUM_LENGTH', limit_length);
919: fnd_message.set_token('TRANSLATED_MAXIMUM_LENGTH', trans_length);
920: fnd_message.set_token('TYPE', X_TYPE);
921: app_exception.raise_exception();

Line 918: fnd_message.set_token('MAXIMUM_LENGTH', limit_length);

914: then
915: fnd_message.set_name('FND', 'AFDICT_VAL_TYPELEN_SMALL_TRN');
916: fnd_message.set_token('MESSAGE_NAME', X_MESSAGE_NAME);
917: fnd_message.set_token('MESSAGE_TEXT_LENGTH', actual_length);
918: fnd_message.set_token('MAXIMUM_LENGTH', limit_length);
919: fnd_message.set_token('TRANSLATED_MAXIMUM_LENGTH', trans_length);
920: fnd_message.set_token('TYPE', X_TYPE);
921: app_exception.raise_exception();
922: end if;

Line 919: fnd_message.set_token('TRANSLATED_MAXIMUM_LENGTH', trans_length);

915: fnd_message.set_name('FND', 'AFDICT_VAL_TYPELEN_SMALL_TRN');
916: fnd_message.set_token('MESSAGE_NAME', X_MESSAGE_NAME);
917: fnd_message.set_token('MESSAGE_TEXT_LENGTH', actual_length);
918: fnd_message.set_token('MAXIMUM_LENGTH', limit_length);
919: fnd_message.set_token('TRANSLATED_MAXIMUM_LENGTH', trans_length);
920: fnd_message.set_token('TYPE', X_TYPE);
921: app_exception.raise_exception();
922: end if;
923: end if;

Line 920: fnd_message.set_token('TYPE', X_TYPE);

916: fnd_message.set_token('MESSAGE_NAME', X_MESSAGE_NAME);
917: fnd_message.set_token('MESSAGE_TEXT_LENGTH', actual_length);
918: fnd_message.set_token('MAXIMUM_LENGTH', limit_length);
919: fnd_message.set_token('TRANSLATED_MAXIMUM_LENGTH', trans_length);
920: fnd_message.set_token('TYPE', X_TYPE);
921: app_exception.raise_exception();
922: end if;
923: end if;
924:

Line 939: fnd_message.set_name('FND', 'AFDICT_VAL_MAXLEN_RANGE');

935: -- Check for Max Length range
936: -- ******************************
937: if(X_MAX_LENGTH is not null
938: and (X_MAX_LENGTH < 10 or X_MAX_LENGTH > 1800)) then
939: fnd_message.set_name('FND', 'AFDICT_VAL_MAXLEN_RANGE');
940: fnd_message.set_token('MESSAGE_NAME', X_MESSAGE_NAME);
941: fnd_message.set_token('MAXIMUM_LENGTH', X_MAX_LENGTH);
942: fnd_message.set_token('MINIMUM', 10);
943: fnd_message.set_token('MAXIMUM', 1800);

Line 940: fnd_message.set_token('MESSAGE_NAME', X_MESSAGE_NAME);

936: -- ******************************
937: if(X_MAX_LENGTH is not null
938: and (X_MAX_LENGTH < 10 or X_MAX_LENGTH > 1800)) then
939: fnd_message.set_name('FND', 'AFDICT_VAL_MAXLEN_RANGE');
940: fnd_message.set_token('MESSAGE_NAME', X_MESSAGE_NAME);
941: fnd_message.set_token('MAXIMUM_LENGTH', X_MAX_LENGTH);
942: fnd_message.set_token('MINIMUM', 10);
943: fnd_message.set_token('MAXIMUM', 1800);
944: app_exception.raise_exception();

Line 941: fnd_message.set_token('MAXIMUM_LENGTH', X_MAX_LENGTH);

937: if(X_MAX_LENGTH is not null
938: and (X_MAX_LENGTH < 10 or X_MAX_LENGTH > 1800)) then
939: fnd_message.set_name('FND', 'AFDICT_VAL_MAXLEN_RANGE');
940: fnd_message.set_token('MESSAGE_NAME', X_MESSAGE_NAME);
941: fnd_message.set_token('MAXIMUM_LENGTH', X_MAX_LENGTH);
942: fnd_message.set_token('MINIMUM', 10);
943: fnd_message.set_token('MAXIMUM', 1800);
944: app_exception.raise_exception();
945: end if;

Line 942: fnd_message.set_token('MINIMUM', 10);

938: and (X_MAX_LENGTH < 10 or X_MAX_LENGTH > 1800)) then
939: fnd_message.set_name('FND', 'AFDICT_VAL_MAXLEN_RANGE');
940: fnd_message.set_token('MESSAGE_NAME', X_MESSAGE_NAME);
941: fnd_message.set_token('MAXIMUM_LENGTH', X_MAX_LENGTH);
942: fnd_message.set_token('MINIMUM', 10);
943: fnd_message.set_token('MAXIMUM', 1800);
944: app_exception.raise_exception();
945: end if;
946:

Line 943: fnd_message.set_token('MAXIMUM', 1800);

939: fnd_message.set_name('FND', 'AFDICT_VAL_MAXLEN_RANGE');
940: fnd_message.set_token('MESSAGE_NAME', X_MESSAGE_NAME);
941: fnd_message.set_token('MAXIMUM_LENGTH', X_MAX_LENGTH);
942: fnd_message.set_token('MINIMUM', 10);
943: fnd_message.set_token('MAXIMUM', 1800);
944: app_exception.raise_exception();
945: end if;
946:
947:

Line 978: fnd_message.set_name('FND', 'AFDICT_CATEGORY_NOT_VALID');

974: select count(*) into count_category from fnd_lookups
975: where lookup_type = 'FND_KBF_CATEGORY' AND
976: lookup_code = X_CATEGORY;
977: if ( count_category = 0 ) then
978: fnd_message.set_name('FND', 'AFDICT_CATEGORY_NOT_VALID');
979: fnd_message.set_token('MESSAGE_NAME', X_MESSAGE_NAME);
980: fnd_message.set_token('CATEGORY', X_CATEGORY);
981: app_exception.raise_exception();
982: end if;

Line 979: fnd_message.set_token('MESSAGE_NAME', X_MESSAGE_NAME);

975: where lookup_type = 'FND_KBF_CATEGORY' AND
976: lookup_code = X_CATEGORY;
977: if ( count_category = 0 ) then
978: fnd_message.set_name('FND', 'AFDICT_CATEGORY_NOT_VALID');
979: fnd_message.set_token('MESSAGE_NAME', X_MESSAGE_NAME);
980: fnd_message.set_token('CATEGORY', X_CATEGORY);
981: app_exception.raise_exception();
982: end if;
983: end if;

Line 980: fnd_message.set_token('CATEGORY', X_CATEGORY);

976: lookup_code = X_CATEGORY;
977: if ( count_category = 0 ) then
978: fnd_message.set_name('FND', 'AFDICT_CATEGORY_NOT_VALID');
979: fnd_message.set_token('MESSAGE_NAME', X_MESSAGE_NAME);
980: fnd_message.set_token('CATEGORY', X_CATEGORY);
981: app_exception.raise_exception();
982: end if;
983: end if;
984: end if;

Line 996: fnd_message.set_name('FND', 'AFDICT_SEVERITY_NOT_VALID');

992: select count(*) into count_severity from fnd_lookups
993: where lookup_type = 'FND_KBF_SEVERITY' AND
994: lookup_code = X_SEVERITY;
995: if ( count_severity = 0 ) then
996: fnd_message.set_name('FND', 'AFDICT_SEVERITY_NOT_VALID');
997: fnd_message.set_token('MESSAGE_NAME', X_MESSAGE_NAME);
998: fnd_message.set_token('SEVERITY', X_SEVERITY);
999: app_exception.raise_exception();
1000: end if;

Line 997: fnd_message.set_token('MESSAGE_NAME', X_MESSAGE_NAME);

993: where lookup_type = 'FND_KBF_SEVERITY' AND
994: lookup_code = X_SEVERITY;
995: if ( count_severity = 0 ) then
996: fnd_message.set_name('FND', 'AFDICT_SEVERITY_NOT_VALID');
997: fnd_message.set_token('MESSAGE_NAME', X_MESSAGE_NAME);
998: fnd_message.set_token('SEVERITY', X_SEVERITY);
999: app_exception.raise_exception();
1000: end if;
1001: end if;

Line 998: fnd_message.set_token('SEVERITY', X_SEVERITY);

994: lookup_code = X_SEVERITY;
995: if ( count_severity = 0 ) then
996: fnd_message.set_name('FND', 'AFDICT_SEVERITY_NOT_VALID');
997: fnd_message.set_token('MESSAGE_NAME', X_MESSAGE_NAME);
998: fnd_message.set_token('SEVERITY', X_SEVERITY);
999: app_exception.raise_exception();
1000: end if;
1001: end if;
1002: end if;

Line 1014: fnd_message.set_name('FND', 'AFDICT_SEVERITY_NOT_VALID');

1010: select count(*) into count_severity from fnd_lookups
1011: where lookup_type = 'AFLOG_LEVELS' AND
1012: lookup_code = X_FND_LOG_SEVERITY;
1013: if ( count_severity = 0 ) then
1014: fnd_message.set_name('FND', 'AFDICT_SEVERITY_NOT_VALID');
1015: fnd_message.set_token('MESSAGE_NAME', X_MESSAGE_NAME);
1016: fnd_message.set_token('SEVERITY', X_FND_LOG_SEVERITY);
1017: app_exception.raise_exception();
1018: end if;

Line 1015: fnd_message.set_token('MESSAGE_NAME', X_MESSAGE_NAME);

1011: where lookup_type = 'AFLOG_LEVELS' AND
1012: lookup_code = X_FND_LOG_SEVERITY;
1013: if ( count_severity = 0 ) then
1014: fnd_message.set_name('FND', 'AFDICT_SEVERITY_NOT_VALID');
1015: fnd_message.set_token('MESSAGE_NAME', X_MESSAGE_NAME);
1016: fnd_message.set_token('SEVERITY', X_FND_LOG_SEVERITY);
1017: app_exception.raise_exception();
1018: end if;
1019: end if;

Line 1016: fnd_message.set_token('SEVERITY', X_FND_LOG_SEVERITY);

1012: lookup_code = X_FND_LOG_SEVERITY;
1013: if ( count_severity = 0 ) then
1014: fnd_message.set_name('FND', 'AFDICT_SEVERITY_NOT_VALID');
1015: fnd_message.set_token('MESSAGE_NAME', X_MESSAGE_NAME);
1016: fnd_message.set_token('SEVERITY', X_FND_LOG_SEVERITY);
1017: app_exception.raise_exception();
1018: end if;
1019: end if;
1020: end if;