APPS.GMI_ITEM_PUB dependencies on FND_MESSAGE

Line 132: FND_MESSAGE.SET_NAME('GMI','IC_API_INVALID_USER_NAME');

128: , x_user_id => l_user_id
129: );
130: IF l_user_id = 0
131: THEN
132: FND_MESSAGE.SET_NAME('GMI','IC_API_INVALID_USER_NAME');
133: FND_MESSAGE.SET_TOKEN('USER_NAME',l_user_name);
134: FND_MSG_PUB.Add;
135: RAISE FND_API.G_EXC_ERROR;
136: END IF;

Line 133: FND_MESSAGE.SET_TOKEN('USER_NAME',l_user_name);

129: );
130: IF l_user_id = 0
131: THEN
132: FND_MESSAGE.SET_NAME('GMI','IC_API_INVALID_USER_NAME');
133: FND_MESSAGE.SET_TOKEN('USER_NAME',l_user_name);
134: FND_MSG_PUB.Add;
135: RAISE FND_API.G_EXC_ERROR;
136: END IF;
137:

Line 144: FND_MESSAGE.SET_NAME('GMI','IC_API_UNABLE_TO_GET_CONSTANT');

140: , user_id => l_user_id
141: );
142: IF (IC$DEFAULT_LOT IS NULL)
143: THEN
144: FND_MESSAGE.SET_NAME('GMI','IC_API_UNABLE_TO_GET_CONSTANT');
145: FND_MESSAGE.SET_TOKEN('CONSTANT_NAME','IC$DEFAULT_LOT');
146: FND_MSG_PUB.Add;
147: RAISE FND_API.G_EXC_ERROR;
148: END IF;

Line 145: FND_MESSAGE.SET_TOKEN('CONSTANT_NAME','IC$DEFAULT_LOT');

141: );
142: IF (IC$DEFAULT_LOT IS NULL)
143: THEN
144: FND_MESSAGE.SET_NAME('GMI','IC_API_UNABLE_TO_GET_CONSTANT');
145: FND_MESSAGE.SET_TOKEN('CONSTANT_NAME','IC$DEFAULT_LOT');
146: FND_MSG_PUB.Add;
147: RAISE FND_API.G_EXC_ERROR;
148: END IF;
149:

Line 182: FND_MESSAGE.SET_NAME('GMI','IC_API_UNABLE_TO_GET_SURROGATE');

178: -- First get the surrogate key (item_id) for the item
179: SELECT gem5_item_id_s.nextval INTO l_item_id FROM dual;
180: IF (l_item_id <=0)
181: THEN
182: FND_MESSAGE.SET_NAME('GMI','IC_API_UNABLE_TO_GET_SURROGATE');
183: FND_MESSAGE.SET_TOKEN('SKEY','item_id');
184: FND_MSG_PUB.Add;
185: RAISE FND_API.G_EXC_ERROR;
186: END IF;

Line 183: FND_MESSAGE.SET_TOKEN('SKEY','item_id');

179: SELECT gem5_item_id_s.nextval INTO l_item_id FROM dual;
180: IF (l_item_id <=0)
181: THEN
182: FND_MESSAGE.SET_NAME('GMI','IC_API_UNABLE_TO_GET_SURROGATE');
183: FND_MESSAGE.SET_TOKEN('SKEY','item_id');
184: FND_MSG_PUB.Add;
185: RAISE FND_API.G_EXC_ERROR;
186: END IF;
187:

Line 445: FND_MESSAGE.SET_NAME('GMI','IC_API_ITEM_CREATED');

441: THEN
442: COMMIT WORK;
443: END IF;
444: -- Success message
445: FND_MESSAGE.SET_NAME('GMI','IC_API_ITEM_CREATED');
446: FND_MESSAGE.SET_TOKEN('ITEM_NO', l_item_no);
447: FND_MSG_PUB.Add;
448: -- Standard Call to get message count and if count is 1,
449: -- get message info.

Line 446: FND_MESSAGE.SET_TOKEN('ITEM_NO', l_item_no);

442: COMMIT WORK;
443: END IF;
444: -- Success message
445: FND_MESSAGE.SET_NAME('GMI','IC_API_ITEM_CREATED');
446: FND_MESSAGE.SET_TOKEN('ITEM_NO', l_item_no);
447: FND_MSG_PUB.Add;
448: -- Standard Call to get message count and if count is 1,
449: -- get message info.
450:

Line 584: FND_MESSAGE.SET_NAME('GMI','IC_API_ITEM_ALREADY_EXISTS');

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;
587: RAISE FND_API.G_EXC_ERROR;
588: END IF;

Line 585: FND_MESSAGE.SET_TOKEN('ITEM_NO',l_item_no);

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;
587: RAISE FND_API.G_EXC_ERROR;
588: END IF;
589:

Line 593: FND_MESSAGE.SET_NAME('GMI','IC_API_INVALID_ITEM_DESC1');

589:
590: -- Check description
591: IF (p_item_rec.item_desc1 = ' ' OR p_item_rec.item_desc1 IS NULL)
592: THEN
593: FND_MESSAGE.SET_NAME('GMI','IC_API_INVALID_ITEM_DESC1');
594:
595: FND_MESSAGE.SET_TOKEN('ITEM_NO',l_item_no);
596: FND_MSG_PUB.Add;
597: RAISE FND_API.G_EXC_ERROR;

Line 595: FND_MESSAGE.SET_TOKEN('ITEM_NO',l_item_no);

591: IF (p_item_rec.item_desc1 = ' ' OR p_item_rec.item_desc1 IS NULL)
592: THEN
593: FND_MESSAGE.SET_NAME('GMI','IC_API_INVALID_ITEM_DESC1');
594:
595: FND_MESSAGE.SET_TOKEN('ITEM_NO',l_item_no);
596: FND_MSG_PUB.Add;
597: RAISE FND_API.G_EXC_ERROR;
598: END IF;
599:

Line 604: FND_MESSAGE.SET_NAME('GMI','IC_API_INVALID_UOM');

600:
601: -- Primary Unit of Measure
602: IF NOT GMA_VALID_GRP.Validate_um(l_item_um)
603: THEN
604: FND_MESSAGE.SET_NAME('GMI','IC_API_INVALID_UOM');
605: FND_MESSAGE.SET_TOKEN('ITEM_NO',l_item_no);
606: FND_MESSAGE.SET_TOKEN('UOM',l_item_um);
607: FND_MSG_PUB.Add;
608: RAISE FND_API.G_EXC_ERROR;

Line 605: FND_MESSAGE.SET_TOKEN('ITEM_NO',l_item_no);

601: -- Primary Unit of Measure
602: IF NOT GMA_VALID_GRP.Validate_um(l_item_um)
603: THEN
604: FND_MESSAGE.SET_NAME('GMI','IC_API_INVALID_UOM');
605: FND_MESSAGE.SET_TOKEN('ITEM_NO',l_item_no);
606: FND_MESSAGE.SET_TOKEN('UOM',l_item_um);
607: FND_MSG_PUB.Add;
608: RAISE FND_API.G_EXC_ERROR;
609: END IF;

Line 606: FND_MESSAGE.SET_TOKEN('UOM',l_item_um);

602: IF NOT GMA_VALID_GRP.Validate_um(l_item_um)
603: THEN
604: FND_MESSAGE.SET_NAME('GMI','IC_API_INVALID_UOM');
605: FND_MESSAGE.SET_TOKEN('ITEM_NO',l_item_no);
606: FND_MESSAGE.SET_TOKEN('UOM',l_item_um);
607: FND_MSG_PUB.Add;
608: RAISE FND_API.G_EXC_ERROR;
609: END IF;
610:

Line 614: FND_MESSAGE.SET_NAME('GMI','IC_API_INVALID_DUALUM_IND');

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;
617: RAISE FND_API.G_EXC_ERROR;
618: END IF;

Line 615: FND_MESSAGE.SET_TOKEN('ITEM_NO',l_item_no);

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;
617: RAISE FND_API.G_EXC_ERROR;
618: END IF;
619:

Line 624: FND_MESSAGE.SET_NAME('GMI','IC_API_INVALID_UOM');

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);
627: FND_MSG_PUB.Add;
628: RAISE FND_API.G_EXC_ERROR;

Line 625: FND_MESSAGE.SET_TOKEN('ITEM_NO',l_item_no);

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);
627: FND_MSG_PUB.Add;
628: RAISE FND_API.G_EXC_ERROR;
629: END IF;

Line 626: FND_MESSAGE.SET_TOKEN('UOM',l_item_um2);

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);
627: FND_MSG_PUB.Add;
628: RAISE FND_API.G_EXC_ERROR;
629: END IF;
630:

Line 637: FND_MESSAGE.SET_NAME('GMI','IC_API_INVALID_DEVIATION');

633: , p_item_rec.deviation_lo
634: )
635:
636: THEN
637: FND_MESSAGE.SET_NAME('GMI','IC_API_INVALID_DEVIATION');
638: FND_MESSAGE.SET_TOKEN('ITEM_NO',l_item_no);
639: FND_MSG_PUB.Add;
640: RAISE FND_API.G_EXC_ERROR;
641: END IF;

Line 638: FND_MESSAGE.SET_TOKEN('ITEM_NO',l_item_no);

634: )
635:
636: THEN
637: FND_MESSAGE.SET_NAME('GMI','IC_API_INVALID_DEVIATION');
638: FND_MESSAGE.SET_TOKEN('ITEM_NO',l_item_no);
639: FND_MSG_PUB.Add;
640: RAISE FND_API.G_EXC_ERROR;
641: END IF;
642:

Line 648: FND_MESSAGE.SET_NAME('GMI','IC_API_INVALID_DEVIATION');

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');
649:
650: FND_MESSAGE.SET_TOKEN('ITEM_NO',l_item_no);
651: FND_MSG_PUB.Add;
652: RAISE FND_API.G_EXC_ERROR;

Line 650: FND_MESSAGE.SET_TOKEN('ITEM_NO',l_item_no);

646: )
647: THEN
648: FND_MESSAGE.SET_NAME('GMI','IC_API_INVALID_DEVIATION');
649:
650: FND_MESSAGE.SET_TOKEN('ITEM_NO',l_item_no);
651: FND_MSG_PUB.Add;
652: RAISE FND_API.G_EXC_ERROR;
653: END IF;
654:

Line 658: FND_MESSAGE.SET_NAME('GMI','IC_API_INVALID_LOT_CTL');

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;
661: RAISE FND_API.G_EXC_ERROR;
662: END IF;

Line 659: FND_MESSAGE.SET_TOKEN('ITEM_NO',l_item_no);

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;
661: RAISE FND_API.G_EXC_ERROR;
662: END IF;
663:

Line 670: FND_MESSAGE.SET_NAME('GMI','IC_API_INVALID_LOT_INDIVISIBLE');

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');
671: FND_MESSAGE.SET_TOKEN('ITEM_NO',l_item_no);
672: FND_MSG_PUB.Add;
673: RAISE FND_API.G_EXC_ERROR;
674: END IF;

Line 671: FND_MESSAGE.SET_TOKEN('ITEM_NO',l_item_no);

667: , p_item_rec.lot_indivisible
668: )
669: THEN
670: FND_MESSAGE.SET_NAME('GMI','IC_API_INVALID_LOT_INDIVISIBLE');
671: FND_MESSAGE.SET_TOKEN('ITEM_NO',l_item_no);
672: FND_MSG_PUB.Add;
673: RAISE FND_API.G_EXC_ERROR;
674: END IF;
675:

Line 682: FND_MESSAGE.SET_NAME('GMI','IC_API_INVALID_SUBLOT_CTL');

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');
683: FND_MESSAGE.SET_TOKEN('ITEM_NO',l_item_no);
684: FND_MSG_PUB.Add;
685: RAISE FND_API.G_EXC_ERROR;
686: END IF;

Line 683: FND_MESSAGE.SET_TOKEN('ITEM_NO',l_item_no);

679: , p_item_rec.sublot_ctl
680: )
681: THEN
682: FND_MESSAGE.SET_NAME('GMI','IC_API_INVALID_SUBLOT_CTL');
683: FND_MESSAGE.SET_TOKEN('ITEM_NO',l_item_no);
684: FND_MSG_PUB.Add;
685: RAISE FND_API.G_EXC_ERROR;
686: END IF;
687:

Line 692: FND_MESSAGE.SET_NAME('GMI','IC_API_INVALID_LOCT_CTL');

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);
694: FND_MSG_PUB.Add;
695: RAISE FND_API.G_EXC_ERROR;
696: END IF;

Line 693: FND_MESSAGE.SET_TOKEN('ITEM_NO',l_item_no);

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);
694: FND_MSG_PUB.Add;
695: RAISE FND_API.G_EXC_ERROR;
696: END IF;
697:

Line 703: FND_MESSAGE.SET_NAME('GMI','IC_API_INVALID_NONINV_IND');

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');
704: FND_MESSAGE.SET_TOKEN('ITEM_NO',l_item_no);
705:
706: FND_MSG_PUB.Add;
707: RAISE FND_API.G_EXC_ERROR;

Line 704: FND_MESSAGE.SET_TOKEN('ITEM_NO',l_item_no);

700: , p_item_rec.lot_ctl
701: )
702: THEN
703: FND_MESSAGE.SET_NAME('GMI','IC_API_INVALID_NONINV_IND');
704: FND_MESSAGE.SET_TOKEN('ITEM_NO',l_item_no);
705:
706: FND_MSG_PUB.Add;
707: RAISE FND_API.G_EXC_ERROR;
708: END IF;

Line 714: -- FND_MESSAGE.SET_NAME('GMI','IC_API_INVALID_MATCH_TYPE');

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);
716: --FND_MSG_PUB.Add;
717: -- RAISE FND_API.G_EXC_ERROR;
718: -- END IF;

Line 715: -- FND_MESSAGE.SET_TOKEN('ITEM_NO',l_item_no);

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);
716: --FND_MSG_PUB.Add;
717: -- RAISE FND_API.G_EXC_ERROR;
718: -- END IF;
719:

Line 724: FND_MESSAGE.SET_NAME('GMI','IC_API_INVALID_INACTIVE_IND');

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;
727: RAISE FND_API.G_EXC_ERROR;
728: END IF;

Line 725: FND_MESSAGE.SET_TOKEN('ITEM_NO',l_item_no);

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;
727: RAISE FND_API.G_EXC_ERROR;
728: END IF;
729:

Line 736: FND_MESSAGE.SET_NAME('GMI','IC_API_INVALID_INV_TYPE');

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;
739: RAISE FND_API.G_EXC_ERROR;
740: END IF;

Line 737: FND_MESSAGE.SET_TOKEN('ITEM_NO',l_item_no);

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;
739: RAISE FND_API.G_EXC_ERROR;
740: END IF;
741: END IF;

Line 749: FND_MESSAGE.SET_NAME('GMI','IC_API_INVALID_SHELF_LIFE');

745: , p_item_rec.grade_ctl
746: )
747:
748: THEN
749: FND_MESSAGE.SET_NAME('GMI','IC_API_INVALID_SHELF_LIFE');
750: FND_MESSAGE.SET_TOKEN('ITEM_NO',l_item_no);
751: FND_MSG_PUB.Add;
752: RAISE FND_API.G_EXC_ERROR;
753: END IF;

Line 750: FND_MESSAGE.SET_TOKEN('ITEM_NO',l_item_no);

746: )
747:
748: THEN
749: FND_MESSAGE.SET_NAME('GMI','IC_API_INVALID_SHELF_LIFE');
750: FND_MESSAGE.SET_TOKEN('ITEM_NO',l_item_no);
751: FND_MSG_PUB.Add;
752: RAISE FND_API.G_EXC_ERROR;
753: END IF;
754:

Line 760: FND_MESSAGE.SET_NAME('GMI','IC_API_INVALID_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');
761:
762: FND_MESSAGE.SET_TOKEN('ITEM_NO',l_item_no);
763: FND_MSG_PUB.Add;
764: RAISE FND_API.G_EXC_ERROR;

Line 762: FND_MESSAGE.SET_TOKEN('ITEM_NO',l_item_no);

758: )
759: THEN
760: FND_MESSAGE.SET_NAME('GMI','IC_API_INVALID_RETEST_INTERVAL');
761:
762: FND_MESSAGE.SET_TOKEN('ITEM_NO',l_item_no);
763: FND_MSG_PUB.Add;
764: RAISE FND_API.G_EXC_ERROR;
765: END IF;
766:

Line 773: FND_MESSAGE.SET_NAME('GMI','IC_API_INVALID_GL_CLASS');

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:
776: FND_MSG_PUB.Add;
777: RAISE FND_API.G_EXC_ERROR;

Line 774: FND_MESSAGE.SET_TOKEN('ITEM_NO',l_item_no);

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:
776: FND_MSG_PUB.Add;
777: RAISE FND_API.G_EXC_ERROR;
778: END IF;

Line 787: FND_MESSAGE.SET_NAME('GMI','IC_API_INVALID_INV_CLASS');

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:
790: FND_MSG_PUB.Add;
791: RAISE FND_API.G_EXC_ERROR;

Line 788: FND_MESSAGE.SET_TOKEN('ITEM_NO',l_item_no);

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:
790: FND_MSG_PUB.Add;
791: RAISE FND_API.G_EXC_ERROR;
792: END IF;

Line 801: FND_MESSAGE.SET_NAME('GMI','IC_API_INVALID_SALES_CLASS');

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:
804: FND_MSG_PUB.Add;
805: RAISE FND_API.G_EXC_ERROR;

Line 802: FND_MESSAGE.SET_TOKEN('ITEM_NO',l_item_no);

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:
804: FND_MSG_PUB.Add;
805: RAISE FND_API.G_EXC_ERROR;
806: END IF;

Line 815: FND_MESSAGE.SET_NAME('GMI','IC_API_INVALID_SHIP_CLASS');

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:
818: FND_MSG_PUB.Add;
819: RAISE FND_API.G_EXC_ERROR;

Line 816: FND_MESSAGE.SET_TOKEN('ITEM_NO',l_item_no);

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:
818: FND_MSG_PUB.Add;
819: RAISE FND_API.G_EXC_ERROR;
820: END IF;

Line 829: FND_MESSAGE.SET_NAME('GMI','IC_API_INVALID_FRT_CLASS');

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:
832: FND_MSG_PUB.Add;
833: RAISE FND_API.G_EXC_ERROR;

Line 830: FND_MESSAGE.SET_TOKEN('ITEM_NO',l_item_no);

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:
832: FND_MSG_PUB.Add;
833: RAISE FND_API.G_EXC_ERROR;
834: END IF;

Line 843: FND_MESSAGE.SET_NAME('GMI','IC_API_INVALID_PRICE_CLASS');

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:
846: FND_MSG_PUB.Add;
847: RAISE FND_API.G_EXC_ERROR;

Line 844: FND_MESSAGE.SET_TOKEN('ITEM_NO',l_item_no);

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:
846: FND_MSG_PUB.Add;
847: RAISE FND_API.G_EXC_ERROR;
848: END IF;

Line 857: FND_MESSAGE.SET_NAME('GMI','IC_API_INVALID_STORAGE_CLASS');

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:
860: FND_MSG_PUB.Add;
861: RAISE FND_API.G_EXC_ERROR;

Line 858: FND_MESSAGE.SET_TOKEN('ITEM_NO',l_item_no);

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:
860: FND_MSG_PUB.Add;
861: RAISE FND_API.G_EXC_ERROR;
862: END IF;

Line 871: FND_MESSAGE.SET_NAME('GMI','IC_API_INVALID_PURCH_CLASS');

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:
874: FND_MSG_PUB.Add;
875: RAISE FND_API.G_EXC_ERROR;

Line 872: FND_MESSAGE.SET_TOKEN('ITEM_NO',l_item_no);

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:
874: FND_MSG_PUB.Add;
875: RAISE FND_API.G_EXC_ERROR;
876: END IF;

Line 885: FND_MESSAGE.SET_NAME('GMI','IC_API_INVALID_TAX_CLASS');

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:
888: FND_MSG_PUB.Add;
889: RAISE FND_API.G_EXC_ERROR;

Line 886: FND_MESSAGE.SET_TOKEN('ITEM_NO',l_item_no);

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:
888: FND_MSG_PUB.Add;
889: RAISE FND_API.G_EXC_ERROR;
890: END IF;

Line 899: FND_MESSAGE.SET_NAME('GMI','IC_API_INVALID_CUSTOMS_CLASS');

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:
902: FND_MSG_PUB.Add;
903: RAISE FND_API.G_EXC_ERROR;

Line 900: FND_MESSAGE.SET_TOKEN('ITEM_NO',l_item_no);

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:
902: FND_MSG_PUB.Add;
903: RAISE FND_API.G_EXC_ERROR;
904: END IF;

Line 913: FND_MESSAGE.SET_NAME('GMI','IC_API_INVALID_ALLOC_CLASS');

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:
916: FND_MSG_PUB.Add;
917: RAISE FND_API.G_EXC_ERROR;

Line 914: FND_MESSAGE.SET_TOKEN('ITEM_NO',l_item_no);

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:
916: FND_MSG_PUB.Add;
917: RAISE FND_API.G_EXC_ERROR;
918: END IF;

Line 928: FND_MESSAGE.SET_NAME('GMI','IC_API_INVALID_PLANNING_CLASS');

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);
931: FND_MSG_PUB.Add;
932: RAISE FND_API.G_EXC_ERROR;

Line 930: FND_MESSAGE.SET_TOKEN('ITEM_NO',l_item_no);

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);
931: FND_MSG_PUB.Add;
932: RAISE FND_API.G_EXC_ERROR;
933: END IF;
934: END IF;

Line 942: FND_MESSAGE.SET_NAME('GMI','IC_API_INVALID_ITEMCOST_CLASS');

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);
945: FND_MSG_PUB.Add;
946: RAISE FND_API.G_EXC_ERROR;

Line 944: FND_MESSAGE.SET_TOKEN('ITEM_NO',l_item_no);

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);
945: FND_MSG_PUB.Add;
946: RAISE FND_API.G_EXC_ERROR;
947: END IF;
948: END IF;

Line 956: FND_MESSAGE.SET_NAME('GMI','IC_API_INVALID_COST_MTHD_CODE');

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);
959: FND_MSG_PUB.Add;
960: RAISE FND_API.G_EXC_ERROR;

Line 958: FND_MESSAGE.SET_TOKEN('ITEM_NO',l_item_no);

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);
959: FND_MSG_PUB.Add;
960: RAISE FND_API.G_EXC_ERROR;
961: END IF;
962: END IF;

Line 969: FND_MESSAGE.SET_NAME('GMI','IC_API_INVALID_GRADE_CTL');

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');
970: FND_MESSAGE.SET_TOKEN('ITEM_NO',l_item_no);
971:
972: FND_MSG_PUB.Add;
973: RAISE FND_API.G_EXC_ERROR;

Line 970: FND_MESSAGE.SET_TOKEN('ITEM_NO',l_item_no);

966: , p_item_rec.lot_ctl
967: )
968: THEN
969: FND_MESSAGE.SET_NAME('GMI','IC_API_INVALID_GRADE_CTL');
970: FND_MESSAGE.SET_TOKEN('ITEM_NO',l_item_no);
971:
972: FND_MSG_PUB.Add;
973: RAISE FND_API.G_EXC_ERROR;
974: END IF;

Line 981: FND_MESSAGE.SET_NAME('GMI','IC_API_INVALID_STATUS_CTL');

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');
982: FND_MESSAGE.SET_TOKEN('ITEM_NO',l_item_no);
983: FND_MSG_PUB.Add;
984: RAISE FND_API.G_EXC_ERROR;
985:

Line 982: FND_MESSAGE.SET_TOKEN('ITEM_NO',l_item_no);

978: , p_item_rec.lot_ctl
979: )
980: THEN
981: FND_MESSAGE.SET_NAME('GMI','IC_API_INVALID_STATUS_CTL');
982: FND_MESSAGE.SET_TOKEN('ITEM_NO',l_item_no);
983: FND_MSG_PUB.Add;
984: RAISE FND_API.G_EXC_ERROR;
985:
986: END IF;

Line 1001: FND_MESSAGE.SET_NAME('GMI','IC_API_INVALID_QC_GRADE');

997: , p_item_rec.grade_ctl
998: )
999: --B965832(1) end
1000: THEN
1001: FND_MESSAGE.SET_NAME('GMI','IC_API_INVALID_QC_GRADE');
1002: FND_MESSAGE.SET_TOKEN('QC_GRADE',p_item_rec.qc_grade);
1003: FND_MESSAGE.SET_TOKEN('ITEM_NO',l_item_no);
1004: FND_MSG_PUB.Add;
1005: RAISE FND_API.G_EXC_ERROR;

Line 1002: FND_MESSAGE.SET_TOKEN('QC_GRADE',p_item_rec.qc_grade);

998: )
999: --B965832(1) end
1000: THEN
1001: FND_MESSAGE.SET_NAME('GMI','IC_API_INVALID_QC_GRADE');
1002: FND_MESSAGE.SET_TOKEN('QC_GRADE',p_item_rec.qc_grade);
1003: FND_MESSAGE.SET_TOKEN('ITEM_NO',l_item_no);
1004: FND_MSG_PUB.Add;
1005: RAISE FND_API.G_EXC_ERROR;
1006: END IF;

Line 1003: FND_MESSAGE.SET_TOKEN('ITEM_NO',l_item_no);

999: --B965832(1) end
1000: THEN
1001: FND_MESSAGE.SET_NAME('GMI','IC_API_INVALID_QC_GRADE');
1002: FND_MESSAGE.SET_TOKEN('QC_GRADE',p_item_rec.qc_grade);
1003: FND_MESSAGE.SET_TOKEN('ITEM_NO',l_item_no);
1004: FND_MSG_PUB.Add;
1005: RAISE FND_API.G_EXC_ERROR;
1006: END IF;
1007:

Line 1024: FND_MESSAGE.SET_NAME('GMI','IC_API_INVALID_LOT_STATUS');

1020: , p_item_rec.status_ctl
1021: )
1022: --B965832(1) end
1023: THEN
1024: FND_MESSAGE.SET_NAME('GMI','IC_API_INVALID_LOT_STATUS');
1025: FND_MESSAGE.SET_TOKEN('LOT_STATUS',p_item_rec.lot_status);
1026: FND_MESSAGE.SET_TOKEN('ITEM_NO',l_item_no);
1027: FND_MSG_PUB.Add;
1028: RAISE FND_API.G_EXC_ERROR;

Line 1025: FND_MESSAGE.SET_TOKEN('LOT_STATUS',p_item_rec.lot_status);

1021: )
1022: --B965832(1) end
1023: THEN
1024: FND_MESSAGE.SET_NAME('GMI','IC_API_INVALID_LOT_STATUS');
1025: FND_MESSAGE.SET_TOKEN('LOT_STATUS',p_item_rec.lot_status);
1026: FND_MESSAGE.SET_TOKEN('ITEM_NO',l_item_no);
1027: FND_MSG_PUB.Add;
1028: RAISE FND_API.G_EXC_ERROR;
1029: END IF;

Line 1026: FND_MESSAGE.SET_TOKEN('ITEM_NO',l_item_no);

1022: --B965832(1) end
1023: THEN
1024: FND_MESSAGE.SET_NAME('GMI','IC_API_INVALID_LOT_STATUS');
1025: FND_MESSAGE.SET_TOKEN('LOT_STATUS',p_item_rec.lot_status);
1026: FND_MESSAGE.SET_TOKEN('ITEM_NO',l_item_no);
1027: FND_MSG_PUB.Add;
1028: RAISE FND_API.G_EXC_ERROR;
1029: END IF;
1030:

Line 1037: FND_MESSAGE.SET_NAME('GMI','IC_API_INVALID_QCITEM_NO');

1033: IF (p_item_rec.grade_ctl <> 1 AND
1034: p_item_rec.qcitem_no <> ' ' AND
1035: p_item_rec.qcitem_no IS NOT NULL)
1036: THEN
1037: FND_MESSAGE.SET_NAME('GMI','IC_API_INVALID_QCITEM_NO');
1038: FND_MESSAGE.SET_TOKEN('ITEM_NO',l_item_no);
1039: FND_MSG_PUB.Add;
1040: RAISE FND_API.G_EXC_ERROR;
1041: ELSIF (p_item_rec.qcitem_no <> ' ' AND p_item_rec.qcitem_no IS NOT NULL)

Line 1038: FND_MESSAGE.SET_TOKEN('ITEM_NO',l_item_no);

1034: p_item_rec.qcitem_no <> ' ' AND
1035: p_item_rec.qcitem_no IS NOT NULL)
1036: THEN
1037: FND_MESSAGE.SET_NAME('GMI','IC_API_INVALID_QCITEM_NO');
1038: FND_MESSAGE.SET_TOKEN('ITEM_NO',l_item_no);
1039: FND_MSG_PUB.Add;
1040: RAISE FND_API.G_EXC_ERROR;
1041: ELSIF (p_item_rec.qcitem_no <> ' ' AND p_item_rec.qcitem_no IS NOT NULL)
1042: THEN

Line 1054: FND_MESSAGE.SET_NAME('GMI','IC_API_INVALID_QCITEM_NO');

1050: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1051: ELSIF (l_ic_item_mst_rec.item_id = 0) OR
1052: (l_ic_item_mst_rec.delete_mark = 1)
1053: THEN
1054: FND_MESSAGE.SET_NAME('GMI','IC_API_INVALID_QCITEM_NO');
1055: FND_MESSAGE.SET_TOKEN('ITEM_NO',l_item_no);
1056: FND_MSG_PUB.Add;
1057: RAISE FND_API.G_EXC_ERROR;
1058: ELSIF (l_ic_item_mst_rec.noninv_ind = 1)

Line 1055: FND_MESSAGE.SET_TOKEN('ITEM_NO',l_item_no);

1051: ELSIF (l_ic_item_mst_rec.item_id = 0) OR
1052: (l_ic_item_mst_rec.delete_mark = 1)
1053: THEN
1054: FND_MESSAGE.SET_NAME('GMI','IC_API_INVALID_QCITEM_NO');
1055: FND_MESSAGE.SET_TOKEN('ITEM_NO',l_item_no);
1056: FND_MSG_PUB.Add;
1057: RAISE FND_API.G_EXC_ERROR;
1058: ELSIF (l_ic_item_mst_rec.noninv_ind = 1)
1059:

Line 1061: FND_MESSAGE.SET_NAME('GMI','IC_API_NONINV_ITEM_NO');

1057: RAISE FND_API.G_EXC_ERROR;
1058: ELSIF (l_ic_item_mst_rec.noninv_ind = 1)
1059:
1060: THEN
1061: FND_MESSAGE.SET_NAME('GMI','IC_API_NONINV_ITEM_NO');
1062: FND_MESSAGE.SET_TOKEN('ITEM_NO',l_item_no);
1063: FND_MSG_PUB.Add;
1064: RAISE FND_API.G_EXC_ERROR;
1065: ELSIF (l_ic_item_mst_rec.inactive_ind = 1)

Line 1062: FND_MESSAGE.SET_TOKEN('ITEM_NO',l_item_no);

1058: ELSIF (l_ic_item_mst_rec.noninv_ind = 1)
1059:
1060: THEN
1061: FND_MESSAGE.SET_NAME('GMI','IC_API_NONINV_ITEM_NO');
1062: FND_MESSAGE.SET_TOKEN('ITEM_NO',l_item_no);
1063: FND_MSG_PUB.Add;
1064: RAISE FND_API.G_EXC_ERROR;
1065: ELSIF (l_ic_item_mst_rec.inactive_ind = 1)
1066: THEN

Line 1067: FND_MESSAGE.SET_NAME('GMI','IC_API_INACTIVE_ITEM_NO');

1063: FND_MSG_PUB.Add;
1064: RAISE FND_API.G_EXC_ERROR;
1065: ELSIF (l_ic_item_mst_rec.inactive_ind = 1)
1066: THEN
1067: FND_MESSAGE.SET_NAME('GMI','IC_API_INACTIVE_ITEM_NO');
1068: FND_MESSAGE.SET_TOKEN('ITEM_NO',l_item_no);
1069: FND_MSG_PUB.Add;
1070: RAISE FND_API.G_EXC_ERROR;
1071: END IF;

Line 1068: FND_MESSAGE.SET_TOKEN('ITEM_NO',l_item_no);

1064: RAISE FND_API.G_EXC_ERROR;
1065: ELSIF (l_ic_item_mst_rec.inactive_ind = 1)
1066: THEN
1067: FND_MESSAGE.SET_NAME('GMI','IC_API_INACTIVE_ITEM_NO');
1068: FND_MESSAGE.SET_TOKEN('ITEM_NO',l_item_no);
1069: FND_MSG_PUB.Add;
1070: RAISE FND_API.G_EXC_ERROR;
1071: END IF;
1072: END IF;

Line 1078: -- FND_MESSAGE.SET_NAME('GMI','IC_API_INVALID_QCHOLD_RES_CODE');

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;
1081: -- RAISE FND_API.G_EXC_ERROR;
1082: -- END IF;

Line 1079: -- FND_MESSAGE.SET_TOKEN('ITEM_NO',l_item_no);

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;
1081: -- RAISE FND_API.G_EXC_ERROR;
1082: -- END IF;
1083:

Line 1093: FND_MESSAGE.SET_NAME('GMI','IC_API_INVALID_EXPACTION_CODE');

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');
1094: FND_MESSAGE.SET_TOKEN('ITEM_NO',l_item_no);
1095: FND_MSG_PUB.Add;
1096: RAISE FND_API.G_EXC_ERROR;
1097: END IF;

Line 1094: FND_MESSAGE.SET_TOKEN('ITEM_NO',l_item_no);

1090: , p_item_rec.grade_ctl
1091: )
1092: THEN
1093: FND_MESSAGE.SET_NAME('GMI','IC_API_INVALID_EXPACTION_CODE');
1094: FND_MESSAGE.SET_TOKEN('ITEM_NO',l_item_no);
1095: FND_MSG_PUB.Add;
1096: RAISE FND_API.G_EXC_ERROR;
1097: END IF;
1098: END IF;

Line 1108: FND_MESSAGE.SET_NAME('GMI','IC_API_INVALID_EXPACTION_CODE');

1104:
1105: , p_item_rec.grade_ctl
1106: )
1107: THEN
1108: FND_MESSAGE.SET_NAME('GMI','IC_API_INVALID_EXPACTION_CODE');
1109: FND_MESSAGE.SET_TOKEN('ITEM_NO',l_item_no);
1110: FND_MSG_PUB.Add;
1111: RAISE FND_API.G_EXC_ERROR;
1112: END IF;

Line 1109: FND_MESSAGE.SET_TOKEN('ITEM_NO',l_item_no);

1105: , p_item_rec.grade_ctl
1106: )
1107: THEN
1108: FND_MESSAGE.SET_NAME('GMI','IC_API_INVALID_EXPACTION_CODE');
1109: FND_MESSAGE.SET_TOKEN('ITEM_NO',l_item_no);
1110: FND_MSG_PUB.Add;
1111: RAISE FND_API.G_EXC_ERROR;
1112: END IF;
1113:

Line 1130: FND_MESSAGE.SET_NAME('GMI','IC_API_INVALID_WHSE_ITEM_NO');

1126: ELSIF (l_ic_item_mst_rec.item_id = 0) OR
1127: (l_ic_item_mst_rec.delete_mark = 1)
1128: THEN
1129:
1130: FND_MESSAGE.SET_NAME('GMI','IC_API_INVALID_WHSE_ITEM_NO');
1131: FND_MESSAGE.SET_TOKEN('ITEM_NO',l_item_no);
1132: FND_MSG_PUB.Add;
1133: RAISE FND_API.G_EXC_ERROR;
1134: ELSIF (l_ic_item_mst_rec.noninv_ind = 1)

Line 1131: FND_MESSAGE.SET_TOKEN('ITEM_NO',l_item_no);

1127: (l_ic_item_mst_rec.delete_mark = 1)
1128: THEN
1129:
1130: FND_MESSAGE.SET_NAME('GMI','IC_API_INVALID_WHSE_ITEM_NO');
1131: FND_MESSAGE.SET_TOKEN('ITEM_NO',l_item_no);
1132: FND_MSG_PUB.Add;
1133: RAISE FND_API.G_EXC_ERROR;
1134: ELSIF (l_ic_item_mst_rec.noninv_ind = 1)
1135: THEN

Line 1136: FND_MESSAGE.SET_NAME('GMI','IC_API_NONINV_ITEM_NO');

1132: FND_MSG_PUB.Add;
1133: RAISE FND_API.G_EXC_ERROR;
1134: ELSIF (l_ic_item_mst_rec.noninv_ind = 1)
1135: THEN
1136: FND_MESSAGE.SET_NAME('GMI','IC_API_NONINV_ITEM_NO');
1137: FND_MESSAGE.SET_TOKEN('ITEM_NO',l_item_no);
1138: FND_MSG_PUB.Add;
1139: RAISE FND_API.G_EXC_ERROR;
1140: ELSIF (l_ic_item_mst_rec.inactive_ind = 1)

Line 1137: FND_MESSAGE.SET_TOKEN('ITEM_NO',l_item_no);

1133: RAISE FND_API.G_EXC_ERROR;
1134: ELSIF (l_ic_item_mst_rec.noninv_ind = 1)
1135: THEN
1136: FND_MESSAGE.SET_NAME('GMI','IC_API_NONINV_ITEM_NO');
1137: FND_MESSAGE.SET_TOKEN('ITEM_NO',l_item_no);
1138: FND_MSG_PUB.Add;
1139: RAISE FND_API.G_EXC_ERROR;
1140: ELSIF (l_ic_item_mst_rec.inactive_ind = 1)
1141: THEN

Line 1142: FND_MESSAGE.SET_NAME('GMI','IC_API_INACTIVE_ITEM_NO');

1138: FND_MSG_PUB.Add;
1139: RAISE FND_API.G_EXC_ERROR;
1140: ELSIF (l_ic_item_mst_rec.inactive_ind = 1)
1141: THEN
1142: FND_MESSAGE.SET_NAME('GMI','IC_API_INACTIVE_ITEM_NO');
1143:
1144: FND_MESSAGE.SET_TOKEN('ITEM_NO',l_item_no);
1145: FND_MSG_PUB.Add;
1146: RAISE FND_API.G_EXC_ERROR;

Line 1144: FND_MESSAGE.SET_TOKEN('ITEM_NO',l_item_no);

1140: ELSIF (l_ic_item_mst_rec.inactive_ind = 1)
1141: THEN
1142: FND_MESSAGE.SET_NAME('GMI','IC_API_INACTIVE_ITEM_NO');
1143:
1144: FND_MESSAGE.SET_TOKEN('ITEM_NO',l_item_no);
1145: FND_MSG_PUB.Add;
1146: RAISE FND_API.G_EXC_ERROR;
1147: END IF;
1148: END IF;

Line 1153: FND_MESSAGE.SET_NAME('GMI','IC_API_INVALID_EXPERIMENTAL');

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;
1156: RAISE FND_API.G_EXC_ERROR;
1157:

Line 1154: FND_MESSAGE.SET_TOKEN('ITEM_NO',l_item_no);

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;
1156: RAISE FND_API.G_EXC_ERROR;
1157:
1158: END IF;

Line 1167: FND_MESSAGE.SET_NAME('GMI','IC_API_INVALID_SEQ_DPND_CLASS');

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;
1170: RAISE FND_API.G_EXC_ERROR;
1171:

Line 1168: FND_MESSAGE.SET_TOKEN('ITEM_NO',l_item_no);

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;
1170: RAISE FND_API.G_EXC_ERROR;
1171:
1172: END IF;

Line 1179: FND_MESSAGE.SET_NAME('GMI','IC_API_INVALID_MATR_DAYS');

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);
1181: FND_MSG_PUB.Add;
1182: RAISE FND_API.G_EXC_ERROR;
1183: END IF;

Line 1180: FND_MESSAGE.SET_TOKEN('ITEM_NO',l_item_no);

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);
1181: FND_MSG_PUB.Add;
1182: RAISE FND_API.G_EXC_ERROR;
1183: END IF;
1184:

Line 1190: FND_MESSAGE.SET_NAME('GMI','IC_API_INVALID_HOLD_DAYS');

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');
1191: FND_MESSAGE.SET_TOKEN('ITEM_NO',l_item_no);
1192: FND_MSG_PUB.Add;
1193: RAISE FND_API.G_EXC_ERROR;
1194: END IF;

Line 1191: FND_MESSAGE.SET_TOKEN('ITEM_NO',l_item_no);

1187: p_item_rec.ic_hold_days IS NULL)
1188: THEN
1189:
1190: FND_MESSAGE.SET_NAME('GMI','IC_API_INVALID_HOLD_DAYS');
1191: FND_MESSAGE.SET_TOKEN('ITEM_NO',l_item_no);
1192: FND_MSG_PUB.Add;
1193: RAISE FND_API.G_EXC_ERROR;
1194: END IF;
1195: