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.GMI_ITEM_PUB dependencies on GMI_VALID_GRP

Line 189: l_qcitem_id := GMI_VALID_GRP.Validate_item_existance(l_qcitem_no);

185: RAISE FND_API.G_EXC_ERROR;
186: END IF;
187:
188: -- Get item_id of warehouse item and QC reference item if required
189: l_qcitem_id := GMI_VALID_GRP.Validate_item_existance(l_qcitem_no);
190: IF (l_qcitem_id = 0)
191: THEN
192: l_qcitem_id := NULL;
193: END IF;

Line 195: l_whse_item_id := GMI_VALID_GRP.Validate_item_existance(l_whse_item_no);

191: THEN
192: l_qcitem_id := NULL;
193: END IF;
194:
195: l_whse_item_id := GMI_VALID_GRP.Validate_item_existance(l_whse_item_no);
196:
197: IF (l_whse_item_id = 0)
198: THEN
199: l_whse_item_id := l_item_id;

Line 582: IF (GMI_VALID_GRP.Validate_item_existance(l_item_no) <> 0)

578: l_user_name := UPPER(p_item_rec.user_name);
579:
580:
581: -- Check item does not already exist
582: IF (GMI_VALID_GRP.Validate_item_existance(l_item_no) <> 0)
583: THEN
584: FND_MESSAGE.SET_NAME('GMI','IC_API_ITEM_ALREADY_EXISTS');
585: FND_MESSAGE.SET_TOKEN('ITEM_NO',l_item_no);
586: FND_MSG_PUB.Add;

Line 612: IF NOT GMI_VALID_GRP.Validate_dualum_ind(p_item_rec.dualum_ind)

608: RAISE FND_API.G_EXC_ERROR;
609: END IF;
610:
611: -- Dual unit of measure indicator
612: IF NOT GMI_VALID_GRP.Validate_dualum_ind(p_item_rec.dualum_ind)
613: THEN
614: FND_MESSAGE.SET_NAME('GMI','IC_API_INVALID_DUALUM_IND');
615: FND_MESSAGE.SET_TOKEN('ITEM_NO',l_item_no);
616: FND_MSG_PUB.Add;

Line 622: IF NOT GMI_VALID_GRP.Validate_item_um2(p_item_rec.dualum_ind,l_item_um2)

618: END IF;
619:
620: -- Secondary Unit of Measure
621:
622: IF NOT GMI_VALID_GRP.Validate_item_um2(p_item_rec.dualum_ind,l_item_um2)
623: THEN
624: FND_MESSAGE.SET_NAME('GMI','IC_API_INVALID_UOM');
625: FND_MESSAGE.SET_TOKEN('ITEM_NO',l_item_no);
626: FND_MESSAGE.SET_TOKEN('UOM',l_item_um2);

Line 632: IF NOT GMI_VALID_GRP.Validate_deviation ( p_item_rec.dualum_ind

628: RAISE FND_API.G_EXC_ERROR;
629: END IF;
630:
631: -- Deviation factor lo
632: IF NOT GMI_VALID_GRP.Validate_deviation ( p_item_rec.dualum_ind
633: , p_item_rec.deviation_lo
634: )
635:
636: THEN

Line 644: IF NOT GMI_VALID_GRP.Validate_deviation ( p_item_rec.dualum_ind

640: RAISE FND_API.G_EXC_ERROR;
641: END IF;
642:
643: -- Deviation factor hi
644: IF NOT GMI_VALID_GRP.Validate_deviation ( p_item_rec.dualum_ind
645: , p_item_rec.deviation_hi
646: )
647: THEN
648: FND_MESSAGE.SET_NAME('GMI','IC_API_INVALID_DEVIATION');

Line 656: IF NOT GMI_VALID_GRP.Validate_lot_ctl(p_item_rec.lot_ctl)

652: RAISE FND_API.G_EXC_ERROR;
653: END IF;
654:
655: -- lot control flag
656: IF NOT GMI_VALID_GRP.Validate_lot_ctl(p_item_rec.lot_ctl)
657: THEN
658: FND_MESSAGE.SET_NAME('GMI','IC_API_INVALID_LOT_CTL');
659: FND_MESSAGE.SET_TOKEN('ITEM_NO',l_item_no);
660: FND_MSG_PUB.Add;

Line 666: IF NOT GMI_VALID_GRP.Validate_lot_indivisible ( p_item_rec.lot_ctl

662: END IF;
663:
664:
665: -- lot indivisible flag
666: IF NOT GMI_VALID_GRP.Validate_lot_indivisible ( p_item_rec.lot_ctl
667: , p_item_rec.lot_indivisible
668: )
669: THEN
670: FND_MESSAGE.SET_NAME('GMI','IC_API_INVALID_LOT_INDIVISIBLE');

Line 678: IF NOT GMI_VALID_GRP.Validate_sublot_ctl ( p_item_rec.lot_ctl

674: END IF;
675:
676: -- Sublot control flag
677:
678: IF NOT GMI_VALID_GRP.Validate_sublot_ctl ( p_item_rec.lot_ctl
679: , p_item_rec.sublot_ctl
680: )
681: THEN
682: FND_MESSAGE.SET_NAME('GMI','IC_API_INVALID_SUBLOT_CTL');

Line 689: IF NOT GMI_VALID_GRP.Validate_loct_ctl(p_item_rec.loct_ctl)

685: RAISE FND_API.G_EXC_ERROR;
686: END IF;
687:
688: -- Location control flag
689: IF NOT GMI_VALID_GRP.Validate_loct_ctl(p_item_rec.loct_ctl)
690: THEN
691:
692: FND_MESSAGE.SET_NAME('GMI','IC_API_INVALID_LOCT_CTL');
693: FND_MESSAGE.SET_TOKEN('ITEM_NO',l_item_no);

Line 699: IF NOT GMI_VALID_GRP.Validate_noninv_ind ( p_item_rec.noninv_ind

695: RAISE FND_API.G_EXC_ERROR;
696: END IF;
697:
698: -- Non-inventory flag
699: IF NOT GMI_VALID_GRP.Validate_noninv_ind ( p_item_rec.noninv_ind
700: , p_item_rec.lot_ctl
701: )
702: THEN
703: FND_MESSAGE.SET_NAME('GMI','IC_API_INVALID_NONINV_IND');

Line 711: -- IF NOT GMI_VALID_GRP.Validate_Type( 'MATCH_TYPE'

707: RAISE FND_API.G_EXC_ERROR;
708: END IF;
709:
710: -- Match type
711: -- IF NOT GMI_VALID_GRP.Validate_Type( 'MATCH_TYPE'
712: -- , p_item_rec.match_type)
713: -- THEN
714: -- FND_MESSAGE.SET_NAME('GMI','IC_API_INVALID_MATCH_TYPE');
715: -- FND_MESSAGE.SET_TOKEN('ITEM_NO',l_item_no);

Line 722: IF NOT GMI_VALID_GRP.Validate_inactive_ind(p_item_rec.inactive_ind)

718: -- END IF;
719:
720:
721: -- Inactive indicator
722: IF NOT GMI_VALID_GRP.Validate_inactive_ind(p_item_rec.inactive_ind)
723: THEN
724: FND_MESSAGE.SET_NAME('GMI','IC_API_INVALID_INACTIVE_IND');
725: FND_MESSAGE.SET_TOKEN('ITEM_NO',l_item_no);
726: FND_MSG_PUB.Add;

Line 734: IF NOT GMI_VALID_GRP.Validate_inv_type(p_item_rec.inv_type)

730: -- Inventory Type
731: IF (p_item_rec.inv_type <> ' ' AND p_item_rec.inv_type IS NOT NULL)
732: THEN
733:
734: IF NOT GMI_VALID_GRP.Validate_inv_type(p_item_rec.inv_type)
735: THEN
736: FND_MESSAGE.SET_NAME('GMI','IC_API_INVALID_INV_TYPE');
737: FND_MESSAGE.SET_TOKEN('ITEM_NO',l_item_no);
738: FND_MSG_PUB.Add;

Line 744: IF NOT GMI_VALID_GRP.Validate_shelf_life ( p_item_rec.shelf_life

740: END IF;
741: END IF;
742:
743: -- Shelf Life
744: IF NOT GMI_VALID_GRP.Validate_shelf_life ( p_item_rec.shelf_life
745: , p_item_rec.grade_ctl
746: )
747:
748: THEN

Line 756: IF NOT GMI_VALID_GRP.Validate_retest_interval ( p_item_rec.retest_interval

752: RAISE FND_API.G_EXC_ERROR;
753: END IF;
754:
755: -- Retest Interval
756: IF NOT GMI_VALID_GRP.Validate_retest_interval ( p_item_rec.retest_interval
757: , p_item_rec.grade_ctl
758: )
759: THEN
760: FND_MESSAGE.SET_NAME('GMI','IC_API_INVALID_RETEST_INTERVAL');

Line 771: IF NOT GMI_VALID_GRP.Validate_gl_class(p_item_rec.gl_class)

767: -- GL class
768:
769: IF (p_item_rec.gl_class <> ' ' AND p_item_rec.gl_class IS NOT NULL)
770: THEN
771: IF NOT GMI_VALID_GRP.Validate_gl_class(p_item_rec.gl_class)
772: THEN
773: FND_MESSAGE.SET_NAME('GMI','IC_API_INVALID_GL_CLASS');
774: FND_MESSAGE.SET_TOKEN('ITEM_NO',l_item_no);
775:

Line 785: IF NOT GMI_VALID_GRP.Validate_inv_class(p_item_rec.inv_class)

781: -- Inventory class
782:
783: IF (p_item_rec.inv_class <> ' ' AND p_item_rec.inv_class IS NOT NULL)
784: THEN
785: IF NOT GMI_VALID_GRP.Validate_inv_class(p_item_rec.inv_class)
786: THEN
787: FND_MESSAGE.SET_NAME('GMI','IC_API_INVALID_INV_CLASS');
788: FND_MESSAGE.SET_TOKEN('ITEM_NO',l_item_no);
789:

Line 799: IF NOT GMI_VALID_GRP.Validate_sales_class(p_item_rec.sales_class)

795: -- Sales class
796:
797: IF (p_item_rec.sales_class <> ' ' AND p_item_rec.sales_class IS NOT NULL)
798: THEN
799: IF NOT GMI_VALID_GRP.Validate_sales_class(p_item_rec.sales_class)
800: THEN
801: FND_MESSAGE.SET_NAME('GMI','IC_API_INVALID_SALES_CLASS');
802: FND_MESSAGE.SET_TOKEN('ITEM_NO',l_item_no);
803:

Line 813: IF NOT GMI_VALID_GRP.Validate_ship_class(p_item_rec.ship_class)

809: -- Ship class
810:
811: IF (p_item_rec.ship_class <> ' ' AND p_item_rec.ship_class IS NOT NULL)
812: THEN
813: IF NOT GMI_VALID_GRP.Validate_ship_class(p_item_rec.ship_class)
814: THEN
815: FND_MESSAGE.SET_NAME('GMI','IC_API_INVALID_SHIP_CLASS');
816: FND_MESSAGE.SET_TOKEN('ITEM_NO',l_item_no);
817:

Line 827: IF NOT GMI_VALID_GRP.Validate_frt_class(p_item_rec.frt_class)

823: -- Freight class
824:
825: IF (p_item_rec.frt_class <> ' ' AND p_item_rec.frt_class IS NOT NULL)
826: THEN
827: IF NOT GMI_VALID_GRP.Validate_frt_class(p_item_rec.frt_class)
828: THEN
829: FND_MESSAGE.SET_NAME('GMI','IC_API_INVALID_FRT_CLASS');
830: FND_MESSAGE.SET_TOKEN('ITEM_NO',l_item_no);
831:

Line 841: IF NOT GMI_VALID_GRP.Validate_price_class(p_item_rec.price_class)

837: -- Price class
838:
839: IF (p_item_rec.price_class <> ' ' AND p_item_rec.price_class IS NOT NULL)
840: THEN
841: IF NOT GMI_VALID_GRP.Validate_price_class(p_item_rec.price_class)
842: THEN
843: FND_MESSAGE.SET_NAME('GMI','IC_API_INVALID_PRICE_CLASS');
844: FND_MESSAGE.SET_TOKEN('ITEM_NO',l_item_no);
845:

Line 855: IF NOT GMI_VALID_GRP.Validate_storage_class(p_item_rec.storage_class)

851: -- Storage class
852:
853: IF (p_item_rec.storage_class <> ' ' AND p_item_rec.storage_class IS NOT NULL)
854: THEN
855: IF NOT GMI_VALID_GRP.Validate_storage_class(p_item_rec.storage_class)
856: THEN
857: FND_MESSAGE.SET_NAME('GMI','IC_API_INVALID_STORAGE_CLASS');
858: FND_MESSAGE.SET_TOKEN('ITEM_NO',l_item_no);
859:

Line 869: IF NOT GMI_VALID_GRP.Validate_purch_class(p_item_rec.purch_class)

865: -- Purchase class
866:
867: IF (p_item_rec.purch_class <> ' ' AND p_item_rec.purch_class IS NOT NULL)
868: THEN
869: IF NOT GMI_VALID_GRP.Validate_purch_class(p_item_rec.purch_class)
870: THEN
871: FND_MESSAGE.SET_NAME('GMI','IC_API_INVALID_PURCH_CLASS');
872: FND_MESSAGE.SET_TOKEN('ITEM_NO',l_item_no);
873:

Line 883: IF NOT GMI_VALID_GRP.Validate_tax_class(p_item_rec.tax_class)

879: -- Tax class
880:
881: IF (p_item_rec.tax_class <> ' ' AND p_item_rec.tax_class IS NOT NULL)
882: THEN
883: IF NOT GMI_VALID_GRP.Validate_tax_class(p_item_rec.tax_class)
884: THEN
885: FND_MESSAGE.SET_NAME('GMI','IC_API_INVALID_TAX_CLASS');
886: FND_MESSAGE.SET_TOKEN('ITEM_NO',l_item_no);
887:

Line 897: IF NOT GMI_VALID_GRP.Validate_customs_class(p_item_rec.customs_class)

893: -- Customs class
894:
895: IF (p_item_rec.customs_class <> ' ' AND p_item_rec.customs_class IS NOT NULL)
896: THEN
897: IF NOT GMI_VALID_GRP.Validate_customs_class(p_item_rec.customs_class)
898: THEN
899: FND_MESSAGE.SET_NAME('GMI','IC_API_INVALID_CUSTOMS_CLASS');
900: FND_MESSAGE.SET_TOKEN('ITEM_NO',l_item_no);
901:

Line 911: IF NOT GMI_VALID_GRP.Validate_alloc_class(p_item_rec.alloc_class)

907: -- Allocation class
908:
909: IF (p_item_rec.alloc_class <> ' ' AND p_item_rec.alloc_class IS NOT NULL)
910: THEN
911: IF NOT GMI_VALID_GRP.Validate_alloc_class(p_item_rec.alloc_class)
912: THEN
913: FND_MESSAGE.SET_NAME('GMI','IC_API_INVALID_ALLOC_CLASS');
914: FND_MESSAGE.SET_TOKEN('ITEM_NO',l_item_no);
915:

Line 926: IF NOT GMI_VALID_GRP.Validate_planning_class(p_item_rec.planning_class)

922:
923: IF (p_item_rec.planning_class <> ' ' AND
924: p_item_rec.planning_class IS NOT NULL)
925: THEN
926: IF NOT GMI_VALID_GRP.Validate_planning_class(p_item_rec.planning_class)
927: THEN
928: FND_MESSAGE.SET_NAME('GMI','IC_API_INVALID_PLANNING_CLASS');
929:
930: FND_MESSAGE.SET_TOKEN('ITEM_NO',l_item_no);

Line 940: IF NOT GMI_VALID_GRP.Validate_itemcost_class(p_item_rec.itemcost_class)

936: -- item Cost class
937: IF (p_item_rec.itemcost_class <> ' ' AND
938: p_item_rec.itemcost_class IS NOT NULL)
939: THEN
940: IF NOT GMI_VALID_GRP.Validate_itemcost_class(p_item_rec.itemcost_class)
941: THEN
942: FND_MESSAGE.SET_NAME('GMI','IC_API_INVALID_ITEMCOST_CLASS');
943:
944: FND_MESSAGE.SET_TOKEN('ITEM_NO',l_item_no);

Line 954: IF NOT GMI_VALID_GRP.Validate_cost_mthd_code(p_item_rec.cost_mthd_code)

950: -- Cost Method Code
951: IF (p_item_rec.cost_mthd_code <> ' ' AND
952: p_item_rec.cost_mthd_code IS NOT NULL)
953: THEN
954: IF NOT GMI_VALID_GRP.Validate_cost_mthd_code(p_item_rec.cost_mthd_code)
955: THEN
956: FND_MESSAGE.SET_NAME('GMI','IC_API_INVALID_COST_MTHD_CODE');
957:
958: FND_MESSAGE.SET_TOKEN('ITEM_NO',l_item_no);

Line 965: IF NOT GMI_VALID_GRP.Validate_grade_ctl ( p_item_rec.grade_ctl

961: END IF;
962: END IF;
963:
964: -- Grade control
965: IF NOT GMI_VALID_GRP.Validate_grade_ctl ( p_item_rec.grade_ctl
966: , p_item_rec.lot_ctl
967: )
968: THEN
969: FND_MESSAGE.SET_NAME('GMI','IC_API_INVALID_GRADE_CTL');

Line 977: IF NOT GMI_VALID_GRP.Validate_status_ctl ( p_item_rec.status_ctl

973: RAISE FND_API.G_EXC_ERROR;
974: END IF;
975:
976: -- lot status control
977: IF NOT GMI_VALID_GRP.Validate_status_ctl ( p_item_rec.status_ctl
978: , p_item_rec.lot_ctl
979: )
980: THEN
981: FND_MESSAGE.SET_NAME('GMI','IC_API_INVALID_STATUS_CTL');

Line 996: IF NOT GMI_VALID_GRP.Validate_qc_grade ( l_qc_grade

992: l_qc_grade :='';
993: ELSE
994: l_qc_grade := UPPER(p_item_rec.qc_grade);
995: END IF;
996: IF NOT GMI_VALID_GRP.Validate_qc_grade ( l_qc_grade
997: , p_item_rec.grade_ctl
998: )
999: --B965832(1) end
1000: THEN

Line 1019: IF NOT GMI_VALID_GRP.Validate_lot_status ( l_lot_status

1015: l_lot_status := '';
1016: ELSE
1017: l_lot_status := UPPER(p_item_rec.lot_status);
1018: END IF;
1019: IF NOT GMI_VALID_GRP.Validate_lot_status ( l_lot_status
1020: , p_item_rec.status_ctl
1021: )
1022: --B965832(1) end
1023: THEN

Line 1076: -- IF NOT GMI_VALID_GRP.Validate_qchold_res_code(p_item_rec.qchold_res_code,

1072: END IF;
1073:
1074:
1075: -- QC Hold reason code
1076: -- IF NOT GMI_VALID_GRP.Validate_qchold_res_code(p_item_rec.qchold_res_code,
1077: -- p_item_rec.qc_grade) THEN
1078: -- FND_MESSAGE.SET_NAME('GMI','IC_API_INVALID_QCHOLD_RES_CODE');
1079: -- FND_MESSAGE.SET_TOKEN('ITEM_NO',l_item_no);
1080: -- FND_MSG_PUB.Add;

Line 1089: IF NOT GMI_VALID_GRP.Validate_expaction_code ( p_item_rec.expaction_code

1085: IF (p_item_rec.expaction_code <> ' ' AND
1086: p_item_rec.expaction_code IS NOT NULL)
1087:
1088: THEN
1089: IF NOT GMI_VALID_GRP.Validate_expaction_code ( p_item_rec.expaction_code
1090: , p_item_rec.grade_ctl
1091: )
1092: THEN
1093: FND_MESSAGE.SET_NAME('GMI','IC_API_INVALID_EXPACTION_CODE');

Line 1102: IF NOT GMI_VALID_GRP.Validate_expaction_interval(p_item_rec.expaction_interval

1098: END IF;
1099:
1100: -- Expiry Action Interval
1101:
1102: IF NOT GMI_VALID_GRP.Validate_expaction_interval(p_item_rec.expaction_interval
1103:
1104:
1105: , p_item_rec.grade_ctl
1106: )

Line 1151: IF NOT GMI_VALID_GRP.Validate_experimental_ind(p_item_rec.experimental_ind)

1147: END IF;
1148: END IF;
1149:
1150: -- Experimental Indicator
1151: IF NOT GMI_VALID_GRP.Validate_experimental_ind(p_item_rec.experimental_ind)
1152: THEN
1153: FND_MESSAGE.SET_NAME('GMI','IC_API_INVALID_EXPERIMENTAL');
1154: FND_MESSAGE.SET_TOKEN('ITEM_NO',l_item_no);
1155: FND_MSG_PUB.Add;

Line 1165: IF NOT GMI_VALID_GRP.Validate_seq_dpnd_class(p_item_rec.seq_dpnd_class)

1161:
1162: IF (p_item_rec.seq_dpnd_class <> ' ' AND
1163: p_item_rec.seq_dpnd_class IS NOT NULL)
1164: THEN
1165: IF NOT GMI_VALID_GRP.Validate_seq_dpnd_class(p_item_rec.seq_dpnd_class)
1166: THEN
1167: FND_MESSAGE.SET_NAME('GMI','IC_API_INVALID_SEQ_DPND_CLASS');
1168: FND_MESSAGE.SET_TOKEN('ITEM_NO',l_item_no);
1169: FND_MSG_PUB.Add;

Line 1176: IF (NOT GMI_VALID_GRP.Validate_ic_matr_days(p_item_rec.ic_matr_days) OR

1172: END IF;
1173: END IF;
1174:
1175: -- Maturity days (CPG)
1176: IF (NOT GMI_VALID_GRP.Validate_ic_matr_days(p_item_rec.ic_matr_days) OR
1177: p_item_rec.ic_matr_days IS NULL)
1178: THEN
1179: FND_MESSAGE.SET_NAME('GMI','IC_API_INVALID_MATR_DAYS');
1180: FND_MESSAGE.SET_TOKEN('ITEM_NO',l_item_no);

Line 1186: IF (NOT GMI_VALID_GRP.Validate_ic_hold_days(p_item_rec.ic_hold_days) OR

1182: RAISE FND_API.G_EXC_ERROR;
1183: END IF;
1184:
1185: -- Hold release days (CPG)
1186: IF (NOT GMI_VALID_GRP.Validate_ic_hold_days(p_item_rec.ic_hold_days) OR
1187: p_item_rec.ic_hold_days IS NULL)
1188: THEN
1189:
1190: FND_MESSAGE.SET_NAME('GMI','IC_API_INVALID_HOLD_DAYS');