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 FND_MSG_PUB

Line 121: FND_MSG_PUB.Initialize;

117: END IF;
118: -- Initialize message list if p_int_msg_list is set TRUE.
119: IF FND_API.to_boolean(p_init_msg_list)
120: THEN
121: FND_MSG_PUB.Initialize;
122: END IF;
123: -- Initialize API return status to sucess
124: x_return_status := FND_API.G_RET_STS_SUCCESS;
125:

Line 134: FND_MSG_PUB.Add;

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:
138: -- Get required system constants

Line 146: FND_MSG_PUB.Add;

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:
150:

Line 184: FND_MSG_PUB.Add;

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:
188: -- Get item_id of warehouse item and QC reference item if required

Line 447: FND_MSG_PUB.Add;

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:
451: FND_MSG_PUB.Count_AND_GET ( p_count => x_msg_count

Line 451: FND_MSG_PUB.Count_AND_GET ( p_count => x_msg_count

447: FND_MSG_PUB.Add;
448: -- Standard Call to get message count and if count is 1,
449: -- get message info.
450:
451: FND_MSG_PUB.Count_AND_GET ( p_count => x_msg_count
452: , p_data => x_msg_data
453: );
454:
455: EXCEPTION

Line 459: FND_MSG_PUB.Count_AND_GET ( p_count => x_msg_count

455: EXCEPTION
456: WHEN FND_API.G_EXC_ERROR THEN
457: ROLLBACK TO Create_Item;
458: x_return_status := FND_API.G_RET_STS_ERROR;
459: FND_MSG_PUB.Count_AND_GET ( p_count => x_msg_count
460: , p_data => x_msg_data
461: );
462:
463: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 466: FND_MSG_PUB.Count_AND_GET ( p_count => x_msg_count

462:
463: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
464: ROLLBACK TO Create_Item;
465: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
466: FND_MSG_PUB.Count_AND_GET ( p_count => x_msg_count
467: , p_data => x_msg_data
468: );
469: WHEN OTHERS THEN
470: ROLLBACK TO Create_Item;

Line 472: -- IF FND_MSG_PUB.check_msg_level

468: );
469: WHEN OTHERS THEN
470: ROLLBACK TO Create_Item;
471: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
472: -- IF FND_MSG_PUB.check_msg_level
473: -- (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
474: -- THEN
475:
476: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME

Line 473: -- (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

469: WHEN OTHERS THEN
470: ROLLBACK TO Create_Item;
471: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
472: -- IF FND_MSG_PUB.check_msg_level
473: -- (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
474: -- THEN
475:
476: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME
477: , l_api_name

Line 476: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME

472: -- IF FND_MSG_PUB.check_msg_level
473: -- (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
474: -- THEN
475:
476: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME
477: , l_api_name
478: );
479: -- END IF;
480: FND_MSG_PUB.Count_AND_GET ( p_count => x_msg_count

Line 480: FND_MSG_PUB.Count_AND_GET ( p_count => x_msg_count

476: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME
477: , l_api_name
478: );
479: -- END IF;
480: FND_MSG_PUB.Count_AND_GET ( p_count => x_msg_count
481: , p_data => x_msg_data
482: );
483: END Create_Item;
484:

Line 568: FND_MSG_PUB.Initialize;

564: -- Initialize message list if p_int_msg_list is set TRUE.
565: IF FND_API.to_boolean(p_init_msg_list)
566:
567: THEN
568: FND_MSG_PUB.Initialize;
569: END IF;
570: -- Initialize API return status to sucess
571: x_return_status := FND_API.G_RET_STS_SUCCESS;
572:

Line 586: FND_MSG_PUB.Add;

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:
590: -- Check description

Line 596: FND_MSG_PUB.Add;

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:
600:

Line 607: FND_MSG_PUB.Add;

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:
611: -- Dual unit of measure indicator

Line 616: FND_MSG_PUB.Add;

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:
620: -- Secondary Unit of Measure

Line 627: FND_MSG_PUB.Add;

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:
631: -- Deviation factor lo

Line 639: FND_MSG_PUB.Add;

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:
643: -- Deviation factor hi

Line 651: FND_MSG_PUB.Add;

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:
655: -- lot control flag

Line 660: FND_MSG_PUB.Add;

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:
664:

Line 672: FND_MSG_PUB.Add;

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:
676: -- Sublot control flag

Line 684: FND_MSG_PUB.Add;

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:
688: -- Location control flag

Line 694: FND_MSG_PUB.Add;

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:
698: -- Non-inventory flag

Line 706: FND_MSG_PUB.Add;

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;
709:
710: -- Match type

Line 716: --FND_MSG_PUB.Add;

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:
720:

Line 726: FND_MSG_PUB.Add;

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:
730: -- Inventory Type

Line 738: FND_MSG_PUB.Add;

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;
742:

Line 751: FND_MSG_PUB.Add;

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:
755: -- Retest Interval

Line 763: FND_MSG_PUB.Add;

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:
767: -- GL class

Line 776: FND_MSG_PUB.Add;

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;
779: END IF;
780:

Line 790: FND_MSG_PUB.Add;

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;
793: END IF;
794:

Line 804: FND_MSG_PUB.Add;

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;
807: END IF;
808:

Line 818: FND_MSG_PUB.Add;

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;
821: END IF;
822:

Line 832: FND_MSG_PUB.Add;

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;
835: END IF;
836:

Line 846: FND_MSG_PUB.Add;

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;
849: END IF;
850:

Line 860: FND_MSG_PUB.Add;

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;
863: END IF;
864:

Line 874: FND_MSG_PUB.Add;

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;
877: END IF;
878:

Line 888: FND_MSG_PUB.Add;

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;
891: END IF;
892:

Line 902: FND_MSG_PUB.Add;

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;
905: END IF;
906:

Line 916: FND_MSG_PUB.Add;

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;
919: END IF;
920:

Line 931: FND_MSG_PUB.Add;

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;
935:

Line 945: FND_MSG_PUB.Add;

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;
949:

Line 959: FND_MSG_PUB.Add;

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;
963:

Line 972: FND_MSG_PUB.Add;

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;
975:
976: -- lot status control

Line 983: FND_MSG_PUB.Add;

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;
987:

Line 1004: FND_MSG_PUB.Add;

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:
1008:

Line 1027: FND_MSG_PUB.Add;

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:
1031:

Line 1039: FND_MSG_PUB.Add;

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
1043: GMI_GLOBAL_GRP.Get_Item ( p_item_no => p_item_rec.qcitem_no

Line 1056: FND_MSG_PUB.Add;

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:
1060: THEN

Line 1063: FND_MSG_PUB.Add;

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
1067: FND_MESSAGE.SET_NAME('GMI','IC_API_INACTIVE_ITEM_NO');

Line 1069: FND_MSG_PUB.Add;

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;
1073:

Line 1080: -- FND_MSG_PUB.Add;

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:
1084: -- Expiry Action Code

Line 1095: FND_MSG_PUB.Add;

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;
1099:

Line 1110: FND_MSG_PUB.Add;

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:
1114: -- Warehouse item no.

Line 1132: FND_MSG_PUB.Add;

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
1136: FND_MESSAGE.SET_NAME('GMI','IC_API_NONINV_ITEM_NO');

Line 1138: FND_MSG_PUB.Add;

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
1142: FND_MESSAGE.SET_NAME('GMI','IC_API_INACTIVE_ITEM_NO');

Line 1145: FND_MSG_PUB.Add;

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;
1149:

Line 1155: FND_MSG_PUB.Add;

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;
1159:

Line 1169: FND_MSG_PUB.Add;

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;
1173: END IF;

Line 1181: FND_MSG_PUB.Add;

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:
1185: -- Hold release days (CPG)

Line 1192: FND_MSG_PUB.Add;

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:
1196: EXCEPTION

Line 1199: FND_MSG_PUB.Count_AND_GET ( p_count => x_msg_count

1195:
1196: EXCEPTION
1197: WHEN FND_API.G_EXC_ERROR THEN
1198: x_return_status := FND_API.G_RET_STS_ERROR;
1199: FND_MSG_PUB.Count_AND_GET ( p_count => x_msg_count
1200: , p_data => x_msg_data
1201: );
1202: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1203:

Line 1205: FND_MSG_PUB.Count_AND_GET ( p_count => x_msg_count

1201: );
1202: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1203:
1204: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1205: FND_MSG_PUB.Count_AND_GET ( p_count => x_msg_count
1206: , p_data => x_msg_data
1207: );
1208: WHEN OTHERS THEN
1209: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1210: -- IF FND_MSG_PUB.check_msg_level

1206: , p_data => x_msg_data
1207: );
1208: WHEN OTHERS THEN
1209: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1210: -- IF FND_MSG_PUB.check_msg_level
1211: -- (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1212: -- THEN
1213:
1214: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME

Line 1211: -- (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

1207: );
1208: WHEN OTHERS THEN
1209: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1210: -- IF FND_MSG_PUB.check_msg_level
1211: -- (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1212: -- THEN
1213:
1214: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME
1215: , l_api_name

Line 1214: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME

1210: -- IF FND_MSG_PUB.check_msg_level
1211: -- (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1212: -- THEN
1213:
1214: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME
1215: , l_api_name
1216: );
1217:
1218: -- END IF;

Line 1219: FND_MSG_PUB.Count_AND_GET ( p_count => x_msg_count

1215: , l_api_name
1216: );
1217:
1218: -- END IF;
1219: FND_MSG_PUB.Count_AND_GET ( p_count => x_msg_count
1220: , p_data => x_msg_data
1221: );
1222:
1223: END Validate_Item;