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