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 393: --FND_MESSAGE.set_name('INV','INV_MGD_MVT_MIS_UNW');

389: ------------Missing Unit_weight--------
390: ELSIF p_excp_list(l_count_i).excp_message_cd=1
391: AND p_excp_list(l_count_i).excp_col_name='UNIT_WEIGHT'
392: THEN
393: --FND_MESSAGE.set_name('INV','INV_MGD_MVT_MIS_UNW');
394:
395: -- FND_MESSAGE.set_token('EXCP_MISSING_COL'
396: -- , p_excp_list(l_count_i).excp_col_name
397: -- );

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

391: AND p_excp_list(l_count_i).excp_col_name='UNIT_WEIGHT'
392: THEN
393: --FND_MESSAGE.set_name('INV','INV_MGD_MVT_MIS_UNW');
394:
395: -- FND_MESSAGE.set_token('EXCP_MISSING_COL'
396: -- , p_excp_list(l_count_i).excp_col_name
397: -- );
398:
399: l_error_name:='INV_MGD_MVT_MIS_UNW';

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

563: AND p_excp_list(l_count_i).excp_col_name='CURRENCY_CONVERSION_RATE'
564:
565: THEN
566:
567: --FND_MESSAGE.set_name('INV','INV_MGD_MVT_MIS_EXR');
568:
569: --FND_MESSAGE.set_token('EXCP_MISSING_COL'
570: -- , p_excp_list(l_count_i).excp_col_name
571: -- );

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

565: THEN
566:
567: --FND_MESSAGE.set_name('INV','INV_MGD_MVT_MIS_EXR');
568:
569: --FND_MESSAGE.set_token('EXCP_MISSING_COL'
570: -- , p_excp_list(l_count_i).excp_col_name
571: -- );
572:
573: l_error_name:='INV_MGD_MVT_MIS_EXR';

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

683: AND p_mtl_movement_transaction.bill_to_site_use_id IS NOT NULL
684: THEN
685: l_tp_name:=p_mtl_movement_transaction.CUSTOMER_NAME;
686:
687: FND_MESSAGE.set_name('INV','INV_MGD_MVT_EXCP_TP_CUST');
688: l_tp_type:=FND_MESSAGE.GET;
689:
690:
691: ELSIF p_mtl_movement_transaction.document_source_type in ('PO','RTV')

Line 688: l_tp_type:=FND_MESSAGE.GET;

684: THEN
685: l_tp_name:=p_mtl_movement_transaction.CUSTOMER_NAME;
686:
687: FND_MESSAGE.set_name('INV','INV_MGD_MVT_EXCP_TP_CUST');
688: l_tp_type:=FND_MESSAGE.GET;
689:
690:
691: ELSIF p_mtl_movement_transaction.document_source_type in ('PO','RTV')
692: AND p_mtl_movement_transaction.vendor_site_id IS NOT NULL

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

692: AND p_mtl_movement_transaction.vendor_site_id IS NOT NULL
693: THEN
694: l_tp_name:=p_mtl_movement_transaction.VENDOR_NAME;
695:
696: FND_MESSAGE.set_name('INV','INV_MGD_MVT_EXCP_TP_SUP');
697: l_tp_type:=FND_MESSAGE.GET;
698:
699: ELSIF p_mtl_movement_transaction.document_source_type = 'INV'
700: THEN

Line 697: l_tp_type:=FND_MESSAGE.GET;

693: THEN
694: l_tp_name:=p_mtl_movement_transaction.VENDOR_NAME;
695:
696: FND_MESSAGE.set_name('INV','INV_MGD_MVT_EXCP_TP_SUP');
697: l_tp_type:=FND_MESSAGE.GET;
698:
699: ELSIF p_mtl_movement_transaction.document_source_type = 'INV'
700: THEN
701: FND_MESSAGE.set_name('INV','INV_MGD_MVT_EXCP_TP_ORG');

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

697: l_tp_type:=FND_MESSAGE.GET;
698:
699: ELSIF p_mtl_movement_transaction.document_source_type = 'INV'
700: THEN
701: FND_MESSAGE.set_name('INV','INV_MGD_MVT_EXCP_TP_ORG');
702: l_tp_type:=FND_MESSAGE.GET;
703:
704: BEGIN
705:

Line 702: l_tp_type:=FND_MESSAGE.GET;

698:
699: ELSIF p_mtl_movement_transaction.document_source_type = 'INV'
700: THEN
701: FND_MESSAGE.set_name('INV','INV_MGD_MVT_EXCP_TP_ORG');
702: l_tp_type:=FND_MESSAGE.GET;
703:
704: BEGIN
705:
706: SELECT name

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

799:
800: -------------Incorrect Value------------------------------
801: ELSIF p_excp_list(l_count_i).excp_message_cd=2
802: THEN
803: --FND_MESSAGE.set_name('INV','INV_MGD_MVT_INVAL_VAL');
804:
805: --FND_MESSAGE.set_token('EXCP_INCORRECT_COL'
806: -- , p_excp_list(l_count_i).excp_col_name
807: -- );

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

801: ELSIF p_excp_list(l_count_i).excp_message_cd=2
802: THEN
803: --FND_MESSAGE.set_name('INV','INV_MGD_MVT_INVAL_VAL');
804:
805: --FND_MESSAGE.set_token('EXCP_INCORRECT_COL'
806: -- , p_excp_list(l_count_i).excp_col_name
807: -- );
808:
809: l_error_name:='INV_MGD_MVT_INVAL_VAL';

Line 815: FND_MESSAGE.set_name('INV'

811:
812: ------get the name as it appears in the form instead of column_name
813: IF p_excp_list(l_count_i).excp_col_name='DELIVERY_TERMS'
814: THEN
815: FND_MESSAGE.set_name('INV'
816: ,'INV_MGD_MVT_EXCP_DT'
817: );
818: l_excp_col_name:=FND_MESSAGE.GET;
819:

Line 818: l_excp_col_name:=FND_MESSAGE.GET;

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

Line 822: FND_MESSAGE.set_name('INV'

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

Line 825: l_excp_col_name:=FND_MESSAGE.GET;

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

Line 829: FND_MESSAGE.set_name('INV'

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

Line 832: l_excp_col_name:=FND_MESSAGE.GET;

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

Line 836: FND_MESSAGE.set_name('INV'

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

Line 839: l_excp_col_name:=FND_MESSAGE.GET;

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

Line 843: FND_MESSAGE.set_name('INV'

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

Line 846: l_excp_col_name:=FND_MESSAGE.GET;

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

Line 850: FND_MESSAGE.set_name('INV'

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

Line 853: l_excp_col_name:=FND_MESSAGE.GET;

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

Line 857: FND_MESSAGE.set_name('INV'

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

Line 860: l_excp_col_name:=FND_MESSAGE.GET;

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

Line 864: FND_MESSAGE.set_name('INV'

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

Line 867: l_excp_col_name:=FND_MESSAGE.GET;

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

Line 871: FND_MESSAGE.set_name('INV'

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

Line 874: l_excp_col_name:=FND_MESSAGE.GET;

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

Line 878: FND_MESSAGE.set_name('INV'

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

Line 881: l_excp_col_name:=FND_MESSAGE.GET;

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

Line 885: FND_MESSAGE.set_name('INV'

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

Line 888: l_excp_col_name:=FND_MESSAGE.GET;

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

Line 892: FND_MESSAGE.set_name('INV'

888: l_excp_col_name:=FND_MESSAGE.GET;
889:
890: ELSIF p_excp_list(l_count_i).excp_col_name='FLOW_INDICATOR_CODE'
891: THEN
892: FND_MESSAGE.set_name('INV'
893: ,'INV_MGD_MVT_EXCP_FIC'
894: );
895: l_excp_col_name:=FND_MESSAGE.GET;
896:

Line 895: l_excp_col_name:=FND_MESSAGE.GET;

891: THEN
892: FND_MESSAGE.set_name('INV'
893: ,'INV_MGD_MVT_EXCP_FIC'
894: );
895: l_excp_col_name:=FND_MESSAGE.GET;
896:
897: ELSIF p_excp_list(l_count_i).excp_col_name='AFFILIATION_REFERENCE_CODE'
898: THEN
899: FND_MESSAGE.set_name('INV'

Line 899: FND_MESSAGE.set_name('INV'

895: l_excp_col_name:=FND_MESSAGE.GET;
896:
897: ELSIF p_excp_list(l_count_i).excp_col_name='AFFILIATION_REFERENCE_CODE'
898: THEN
899: FND_MESSAGE.set_name('INV'
900: ,'INV_MGD_MVT_EXCP_ARC'
901: );
902: l_excp_col_name:=FND_MESSAGE.GET;
903:

Line 902: l_excp_col_name:=FND_MESSAGE.GET;

898: THEN
899: FND_MESSAGE.set_name('INV'
900: ,'INV_MGD_MVT_EXCP_ARC'
901: );
902: l_excp_col_name:=FND_MESSAGE.GET;
903:
904: ELSIF p_excp_list(l_count_i).excp_col_name='OUTSIDE_EXT_VALUE'
905: THEN
906: FND_MESSAGE.set_name('INV'

Line 906: FND_MESSAGE.set_name('INV'

902: l_excp_col_name:=FND_MESSAGE.GET;
903:
904: ELSIF p_excp_list(l_count_i).excp_col_name='OUTSIDE_EXT_VALUE'
905: THEN
906: FND_MESSAGE.set_name('INV'
907: ,'INV_MGD_MVT_EXCP_OEV'
908: );
909: l_excp_col_name:=FND_MESSAGE.GET;
910:

Line 909: l_excp_col_name:=FND_MESSAGE.GET;

905: THEN
906: FND_MESSAGE.set_name('INV'
907: ,'INV_MGD_MVT_EXCP_OEV'
908: );
909: l_excp_col_name:=FND_MESSAGE.GET;
910:
911:
912: ELSE
913: l_excp_col_name:=p_excp_list(l_count_i).excp_col_name;