DBA Data[Home] [Help]

APPS.INV_MGD_MVT_VALIDATE_PROC dependencies on FND_MESSAGE

Line 105: -- FND_MESSAGE.set_name('INV','INV_MGD_MVT_MIS_INV');

101: ---------------Missing Invoice------------------------
102: IF p_excp_list(l_count_i).excp_message_cd=1
103: AND p_excp_list(l_count_i).excp_col_name='INVOICE_ID'
104: THEN
105: -- FND_MESSAGE.set_name('INV','INV_MGD_MVT_MIS_INV');
106:
107: --FND_MESSAGE.set_token('EXCP_MISSING_COL'
108: -- , p_excp_list(l_count_i).excp_col_name
109: -- );

Line 107: --FND_MESSAGE.set_token('EXCP_MISSING_COL'

103: AND p_excp_list(l_count_i).excp_col_name='INVOICE_ID'
104: THEN
105: -- FND_MESSAGE.set_name('INV','INV_MGD_MVT_MIS_INV');
106:
107: --FND_MESSAGE.set_token('EXCP_MISSING_COL'
108: -- , p_excp_list(l_count_i).excp_col_name
109: -- );
110:
111: l_error_name:='INV_MGD_MVT_MIS_INV';

Line 384: --FND_MESSAGE.set_name('INV','INV_MGD_MVT_MIS_UNW');

380: ------------Missing Unit_weight--------
381: ELSIF p_excp_list(l_count_i).excp_message_cd=1
382: AND p_excp_list(l_count_i).excp_col_name='UNIT_WEIGHT'
383: THEN
384: --FND_MESSAGE.set_name('INV','INV_MGD_MVT_MIS_UNW');
385:
386: -- FND_MESSAGE.set_token('EXCP_MISSING_COL'
387: -- , p_excp_list(l_count_i).excp_col_name
388: -- );

Line 386: -- FND_MESSAGE.set_token('EXCP_MISSING_COL'

382: AND p_excp_list(l_count_i).excp_col_name='UNIT_WEIGHT'
383: THEN
384: --FND_MESSAGE.set_name('INV','INV_MGD_MVT_MIS_UNW');
385:
386: -- FND_MESSAGE.set_token('EXCP_MISSING_COL'
387: -- , p_excp_list(l_count_i).excp_col_name
388: -- );
389:
390: l_error_name:='INV_MGD_MVT_MIS_UNW';

Line 549: --FND_MESSAGE.set_name('INV','INV_MGD_MVT_MIS_EXR');

545: AND p_excp_list(l_count_i).excp_col_name='CURRENCY_CONVERSION_RATE'
546:
547: THEN
548:
549: --FND_MESSAGE.set_name('INV','INV_MGD_MVT_MIS_EXR');
550:
551: --FND_MESSAGE.set_token('EXCP_MISSING_COL'
552: -- , p_excp_list(l_count_i).excp_col_name
553: -- );

Line 551: --FND_MESSAGE.set_token('EXCP_MISSING_COL'

547: THEN
548:
549: --FND_MESSAGE.set_name('INV','INV_MGD_MVT_MIS_EXR');
550:
551: --FND_MESSAGE.set_token('EXCP_MISSING_COL'
552: -- , p_excp_list(l_count_i).excp_col_name
553: -- );
554:
555: l_error_name:='INV_MGD_MVT_MIS_EXR';

Line 669: FND_MESSAGE.set_name('INV','INV_MGD_MVT_EXCP_TP_CUST');

665: AND p_mtl_movement_transaction.bill_to_site_use_id IS NOT NULL
666: THEN
667: l_tp_name:=p_mtl_movement_transaction.CUSTOMER_NAME;
668:
669: FND_MESSAGE.set_name('INV','INV_MGD_MVT_EXCP_TP_CUST');
670: l_tp_type:=FND_MESSAGE.GET;
671:
672:
673: ELSIF p_mtl_movement_transaction.document_source_type in ('PO','RTV')

Line 670: l_tp_type:=FND_MESSAGE.GET;

666: THEN
667: l_tp_name:=p_mtl_movement_transaction.CUSTOMER_NAME;
668:
669: FND_MESSAGE.set_name('INV','INV_MGD_MVT_EXCP_TP_CUST');
670: l_tp_type:=FND_MESSAGE.GET;
671:
672:
673: ELSIF p_mtl_movement_transaction.document_source_type in ('PO','RTV')
674: AND p_mtl_movement_transaction.vendor_site_id IS NOT NULL

Line 678: FND_MESSAGE.set_name('INV','INV_MGD_MVT_EXCP_TP_SUP');

674: AND p_mtl_movement_transaction.vendor_site_id IS NOT NULL
675: THEN
676: l_tp_name:=p_mtl_movement_transaction.VENDOR_NAME;
677:
678: FND_MESSAGE.set_name('INV','INV_MGD_MVT_EXCP_TP_SUP');
679: l_tp_type:=FND_MESSAGE.GET;
680:
681: ELSIF p_mtl_movement_transaction.document_source_type = 'INV'
682: THEN

Line 679: l_tp_type:=FND_MESSAGE.GET;

675: THEN
676: l_tp_name:=p_mtl_movement_transaction.VENDOR_NAME;
677:
678: FND_MESSAGE.set_name('INV','INV_MGD_MVT_EXCP_TP_SUP');
679: l_tp_type:=FND_MESSAGE.GET;
680:
681: ELSIF p_mtl_movement_transaction.document_source_type = 'INV'
682: THEN
683: FND_MESSAGE.set_name('INV','INV_MGD_MVT_EXCP_TP_ORG');

Line 683: FND_MESSAGE.set_name('INV','INV_MGD_MVT_EXCP_TP_ORG');

679: l_tp_type:=FND_MESSAGE.GET;
680:
681: ELSIF p_mtl_movement_transaction.document_source_type = 'INV'
682: THEN
683: FND_MESSAGE.set_name('INV','INV_MGD_MVT_EXCP_TP_ORG');
684: l_tp_type:=FND_MESSAGE.GET;
685:
686: BEGIN
687:

Line 684: l_tp_type:=FND_MESSAGE.GET;

680:
681: ELSIF p_mtl_movement_transaction.document_source_type = 'INV'
682: THEN
683: FND_MESSAGE.set_name('INV','INV_MGD_MVT_EXCP_TP_ORG');
684: l_tp_type:=FND_MESSAGE.GET;
685:
686: BEGIN
687:
688: SELECT name

Line 785: --FND_MESSAGE.set_name('INV','INV_MGD_MVT_INVAL_VAL');

781:
782: -------------Incorrect Value------------------------------
783: ELSIF p_excp_list(l_count_i).excp_message_cd=2
784: THEN
785: --FND_MESSAGE.set_name('INV','INV_MGD_MVT_INVAL_VAL');
786:
787: --FND_MESSAGE.set_token('EXCP_INCORRECT_COL'
788: -- , p_excp_list(l_count_i).excp_col_name
789: -- );

Line 787: --FND_MESSAGE.set_token('EXCP_INCORRECT_COL'

783: ELSIF p_excp_list(l_count_i).excp_message_cd=2
784: THEN
785: --FND_MESSAGE.set_name('INV','INV_MGD_MVT_INVAL_VAL');
786:
787: --FND_MESSAGE.set_token('EXCP_INCORRECT_COL'
788: -- , p_excp_list(l_count_i).excp_col_name
789: -- );
790:
791: l_error_name:='INV_MGD_MVT_INVAL_VAL';

Line 797: FND_MESSAGE.set_name('INV'

793:
794: ------get the name as it appears in the form instead of column_name
795: IF p_excp_list(l_count_i).excp_col_name='DELIVERY_TERMS'
796: THEN
797: FND_MESSAGE.set_name('INV'
798: ,'INV_MGD_MVT_EXCP_DT'
799: );
800: l_excp_col_name:=FND_MESSAGE.GET;
801:

Line 800: l_excp_col_name:=FND_MESSAGE.GET;

796: THEN
797: FND_MESSAGE.set_name('INV'
798: ,'INV_MGD_MVT_EXCP_DT'
799: );
800: l_excp_col_name:=FND_MESSAGE.GET;
801:
802: ELSIF p_excp_list(l_count_i).excp_col_name='TRANSACTION_NATURE'
803: THEN
804: FND_MESSAGE.set_name('INV'

Line 804: FND_MESSAGE.set_name('INV'

800: l_excp_col_name:=FND_MESSAGE.GET;
801:
802: ELSIF p_excp_list(l_count_i).excp_col_name='TRANSACTION_NATURE'
803: THEN
804: FND_MESSAGE.set_name('INV'
805: ,'INV_MGD_MVT_EXCP_TN'
806: );
807: l_excp_col_name:=FND_MESSAGE.GET;
808:

Line 807: l_excp_col_name:=FND_MESSAGE.GET;

803: THEN
804: FND_MESSAGE.set_name('INV'
805: ,'INV_MGD_MVT_EXCP_TN'
806: );
807: l_excp_col_name:=FND_MESSAGE.GET;
808:
809: ELSIF p_excp_list(l_count_i).excp_col_name='TRANSPORT_MODE'
810: THEN
811: FND_MESSAGE.set_name('INV'

Line 811: FND_MESSAGE.set_name('INV'

807: l_excp_col_name:=FND_MESSAGE.GET;
808:
809: ELSIF p_excp_list(l_count_i).excp_col_name='TRANSPORT_MODE'
810: THEN
811: FND_MESSAGE.set_name('INV'
812: ,'INV_MGD_MVT_EXCP_TM'
813: );
814: l_excp_col_name:=FND_MESSAGE.GET;
815:

Line 814: l_excp_col_name:=FND_MESSAGE.GET;

810: THEN
811: FND_MESSAGE.set_name('INV'
812: ,'INV_MGD_MVT_EXCP_TM'
813: );
814: l_excp_col_name:=FND_MESSAGE.GET;
815:
816: ELSIF p_excp_list(l_count_i).excp_col_name='PORT'
817: THEN
818: FND_MESSAGE.set_name('INV'

Line 818: FND_MESSAGE.set_name('INV'

814: l_excp_col_name:=FND_MESSAGE.GET;
815:
816: ELSIF p_excp_list(l_count_i).excp_col_name='PORT'
817: THEN
818: FND_MESSAGE.set_name('INV'
819: ,'INV_MGD_MVT_EXCP_P'
820: );
821: l_excp_col_name:=FND_MESSAGE.GET;
822:

Line 821: l_excp_col_name:=FND_MESSAGE.GET;

817: THEN
818: FND_MESSAGE.set_name('INV'
819: ,'INV_MGD_MVT_EXCP_P'
820: );
821: l_excp_col_name:=FND_MESSAGE.GET;
822:
823: ELSIF p_excp_list(l_count_i).excp_col_name='STATISTICAL_PROCEDURE_CODE'
824: THEN
825: FND_MESSAGE.set_name('INV'

Line 825: FND_MESSAGE.set_name('INV'

821: l_excp_col_name:=FND_MESSAGE.GET;
822:
823: ELSIF p_excp_list(l_count_i).excp_col_name='STATISTICAL_PROCEDURE_CODE'
824: THEN
825: FND_MESSAGE.set_name('INV'
826: ,'INV_MGD_MVT_EXCP_SPC'
827: );
828: l_excp_col_name:=FND_MESSAGE.GET;
829:

Line 828: l_excp_col_name:=FND_MESSAGE.GET;

824: THEN
825: FND_MESSAGE.set_name('INV'
826: ,'INV_MGD_MVT_EXCP_SPC'
827: );
828: l_excp_col_name:=FND_MESSAGE.GET;
829:
830: ELSIF p_excp_list(l_count_i).excp_col_name='AREA'
831: THEN
832: FND_MESSAGE.set_name('INV'

Line 832: FND_MESSAGE.set_name('INV'

828: l_excp_col_name:=FND_MESSAGE.GET;
829:
830: ELSIF p_excp_list(l_count_i).excp_col_name='AREA'
831: THEN
832: FND_MESSAGE.set_name('INV'
833: ,'INV_MGD_MVT_EXCP_A'
834: );
835: l_excp_col_name:=FND_MESSAGE.GET;
836:

Line 835: l_excp_col_name:=FND_MESSAGE.GET;

831: THEN
832: FND_MESSAGE.set_name('INV'
833: ,'INV_MGD_MVT_EXCP_A'
834: );
835: l_excp_col_name:=FND_MESSAGE.GET;
836:
837: ELSIF p_excp_list(l_count_i).excp_col_name='OUTSIDE_CODE'
838: THEN
839: FND_MESSAGE.set_name('INV'

Line 839: FND_MESSAGE.set_name('INV'

835: l_excp_col_name:=FND_MESSAGE.GET;
836:
837: ELSIF p_excp_list(l_count_i).excp_col_name='OUTSIDE_CODE'
838: THEN
839: FND_MESSAGE.set_name('INV'
840: ,'INV_MGD_MVT_EXCP_PC'
841: );
842: l_excp_col_name:=FND_MESSAGE.GET;
843:

Line 842: l_excp_col_name:=FND_MESSAGE.GET;

838: THEN
839: FND_MESSAGE.set_name('INV'
840: ,'INV_MGD_MVT_EXCP_PC'
841: );
842: l_excp_col_name:=FND_MESSAGE.GET;
843:
844: ELSIF p_excp_list(l_count_i).excp_col_name='OUTSIDE_UNIT_PRICE'
845: THEN
846: FND_MESSAGE.set_name('INV'

Line 846: FND_MESSAGE.set_name('INV'

842: l_excp_col_name:=FND_MESSAGE.GET;
843:
844: ELSIF p_excp_list(l_count_i).excp_col_name='OUTSIDE_UNIT_PRICE'
845: THEN
846: FND_MESSAGE.set_name('INV'
847: ,'INV_MGD_MVT_EXCP_OUP'
848: );
849: l_excp_col_name:=FND_MESSAGE.GET;
850:

Line 849: l_excp_col_name:=FND_MESSAGE.GET;

845: THEN
846: FND_MESSAGE.set_name('INV'
847: ,'INV_MGD_MVT_EXCP_OUP'
848: );
849: l_excp_col_name:=FND_MESSAGE.GET;
850:
851: ELSIF p_excp_list(l_count_i).excp_col_name='TRIANGULATION_COUNTRY_CODE'
852: THEN
853: FND_MESSAGE.set_name('INV'

Line 853: FND_MESSAGE.set_name('INV'

849: l_excp_col_name:=FND_MESSAGE.GET;
850:
851: ELSIF p_excp_list(l_count_i).excp_col_name='TRIANGULATION_COUNTRY_CODE'
852: THEN
853: FND_MESSAGE.set_name('INV'
854: ,'INV_MGD_MVT_EXCP_TCC'
855: );
856: l_excp_col_name:=FND_MESSAGE.GET;
857:

Line 856: l_excp_col_name:=FND_MESSAGE.GET;

852: THEN
853: FND_MESSAGE.set_name('INV'
854: ,'INV_MGD_MVT_EXCP_TCC'
855: );
856: l_excp_col_name:=FND_MESSAGE.GET;
857:
858: ELSIF p_excp_list(l_count_i).excp_col_name='OIL_REFERENCE_CODE'
859: THEN
860: FND_MESSAGE.set_name('INV'

Line 860: FND_MESSAGE.set_name('INV'

856: l_excp_col_name:=FND_MESSAGE.GET;
857:
858: ELSIF p_excp_list(l_count_i).excp_col_name='OIL_REFERENCE_CODE'
859: THEN
860: FND_MESSAGE.set_name('INV'
861: ,'INV_MGD_MVT_EXCP_ORC'
862: );
863: l_excp_col_name:=FND_MESSAGE.GET;
864:

Line 863: l_excp_col_name:=FND_MESSAGE.GET;

859: THEN
860: FND_MESSAGE.set_name('INV'
861: ,'INV_MGD_MVT_EXCP_ORC'
862: );
863: l_excp_col_name:=FND_MESSAGE.GET;
864:
865: ELSIF p_excp_list(l_count_i).excp_col_name='CONTAINER_TYPE_CODE'
866: THEN
867: FND_MESSAGE.set_name('INV'

Line 867: FND_MESSAGE.set_name('INV'

863: l_excp_col_name:=FND_MESSAGE.GET;
864:
865: ELSIF p_excp_list(l_count_i).excp_col_name='CONTAINER_TYPE_CODE'
866: THEN
867: FND_MESSAGE.set_name('INV'
868: ,'INV_MGD_MVT_EXCP_CTC'
869: );
870: l_excp_col_name:=FND_MESSAGE.GET;
871:

Line 870: l_excp_col_name:=FND_MESSAGE.GET;

866: THEN
867: FND_MESSAGE.set_name('INV'
868: ,'INV_MGD_MVT_EXCP_CTC'
869: );
870: l_excp_col_name:=FND_MESSAGE.GET;
871:
872: ELSIF p_excp_list(l_count_i).excp_col_name='FLOW_INDICATOR_CODE'
873: THEN
874: FND_MESSAGE.set_name('INV'

Line 874: FND_MESSAGE.set_name('INV'

870: l_excp_col_name:=FND_MESSAGE.GET;
871:
872: ELSIF p_excp_list(l_count_i).excp_col_name='FLOW_INDICATOR_CODE'
873: THEN
874: FND_MESSAGE.set_name('INV'
875: ,'INV_MGD_MVT_EXCP_FIC'
876: );
877: l_excp_col_name:=FND_MESSAGE.GET;
878:

Line 877: l_excp_col_name:=FND_MESSAGE.GET;

873: THEN
874: FND_MESSAGE.set_name('INV'
875: ,'INV_MGD_MVT_EXCP_FIC'
876: );
877: l_excp_col_name:=FND_MESSAGE.GET;
878:
879: ELSIF p_excp_list(l_count_i).excp_col_name='AFFILIATION_REFERENCE_CODE'
880: THEN
881: FND_MESSAGE.set_name('INV'

Line 881: FND_MESSAGE.set_name('INV'

877: l_excp_col_name:=FND_MESSAGE.GET;
878:
879: ELSIF p_excp_list(l_count_i).excp_col_name='AFFILIATION_REFERENCE_CODE'
880: THEN
881: FND_MESSAGE.set_name('INV'
882: ,'INV_MGD_MVT_EXCP_ARC'
883: );
884: l_excp_col_name:=FND_MESSAGE.GET;
885:

Line 884: l_excp_col_name:=FND_MESSAGE.GET;

880: THEN
881: FND_MESSAGE.set_name('INV'
882: ,'INV_MGD_MVT_EXCP_ARC'
883: );
884: l_excp_col_name:=FND_MESSAGE.GET;
885:
886: ELSIF p_excp_list(l_count_i).excp_col_name='OUTSIDE_EXT_VALUE'
887: THEN
888: FND_MESSAGE.set_name('INV'

Line 888: FND_MESSAGE.set_name('INV'

884: l_excp_col_name:=FND_MESSAGE.GET;
885:
886: ELSIF p_excp_list(l_count_i).excp_col_name='OUTSIDE_EXT_VALUE'
887: THEN
888: FND_MESSAGE.set_name('INV'
889: ,'INV_MGD_MVT_EXCP_OEV'
890: );
891: l_excp_col_name:=FND_MESSAGE.GET;
892:

Line 891: l_excp_col_name:=FND_MESSAGE.GET;

887: THEN
888: FND_MESSAGE.set_name('INV'
889: ,'INV_MGD_MVT_EXCP_OEV'
890: );
891: l_excp_col_name:=FND_MESSAGE.GET;
892:
893:
894: ELSE
895: l_excp_col_name:=p_excp_list(l_count_i).excp_col_name;