31:
32: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
33: THEN
34:
35: FND_MESSAGE.SET_NAME('MRP','MRP_ORG_ID_REQUIRED');
36: FND_MSG_PUB.Add;
37:
38: END IF;
39:
46:
47: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
48: THEN
49:
50: FND_MESSAGE.SET_NAME('MRP','MRP_WIP_ENTITY_ID_REQUIRED');
51: FND_MSG_PUB.Add;
52:
53: END IF;
54:
65:
66: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
67: THEN
68:
69: FND_MESSAGE.SET_NAME('MRP','MRP_SCH_FLAG_REQUIRED');
70: FND_MSG_PUB.Add;
71:
72: END IF;
73:
80:
81: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
82: THEN
83:
84: FND_MESSAGE.SET_NAME('MRP','MRP_ITEM_ID_REQUIRED');
85: FND_MSG_PUB.Add;
86:
87: END IF;
88:
95:
96: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
97: THEN
98:
99: FND_MESSAGE.SET_NAME('MRP','MRP_CLASS_CODE_REQUIRED');
100: FND_MSG_PUB.Add;
101:
102: END IF;
103:
110:
111: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
112: THEN
113:
114: FND_MESSAGE.SET_NAME('MRP','MRP_SCH_COMP_DATE_REQUIRED');
115: FND_MSG_PUB.Add;
116:
117: END IF;
118:
125:
126: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
127: THEN
128:
129: FND_MESSAGE.SET_NAME('MRP','MRP_PLANNED_QTY_REQUIRED');
130: FND_MSG_PUB.Add;
131:
132: END IF;
133:
140:
141: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
142: THEN
143:
144: FND_MESSAGE.SET_NAME('MRP','MRP_QTY_COMP_REQUIRED');
145: FND_MSG_PUB.Add;
146:
147: END IF;
148:
155:
156: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
157: THEN
158:
159: FND_MESSAGE.SET_NAME('MRP','MRP_SCH_START_DATE_REQUIRED');
160: FND_MSG_PUB.Add;
161:
162: END IF;
163:
170:
171: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
172: THEN
173:
174: FND_MESSAGE.SET_NAME('MRP','MRP_STATUS_REQUIRED');
175: FND_MSG_PUB.Add;
176:
177: END IF;
178:
185:
186: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
187: THEN
188:
189: FND_MESSAGE.SET_NAME('MRP','MRP_SCH_NUMBER_REQUIRED');
190: FND_MSG_PUB.Add;
191:
192: END IF;
193:
232:
233: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
234: THEN
235:
236: FND_MESSAGE.SET_NAME('MRP','MRP_INVALID_ALT_BOM_DESIG');
237: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
238: l_flow_schedule_rec.alternate_bom_designator);
239: FND_MSG_PUB.Add;
240:
233: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
234: THEN
235:
236: FND_MESSAGE.SET_NAME('MRP','MRP_INVALID_ALT_BOM_DESIG');
237: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
238: l_flow_schedule_rec.alternate_bom_designator);
239: FND_MSG_PUB.Add;
240:
241: END IF;
282:
283: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
284: THEN
285:
286: FND_MESSAGE.SET_NAME('MRP','MRP_INVALID_ALT_RTG_DESIG');
287: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
288: l_flow_schedule_rec.alternate_routing_desig);
289: FND_MSG_PUB.Add;
290:
283: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
284: THEN
285:
286: FND_MESSAGE.SET_NAME('MRP','MRP_INVALID_ALT_RTG_DESIG');
287: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
288: l_flow_schedule_rec.alternate_routing_desig);
289: FND_MSG_PUB.Add;
290:
291: END IF;
333:
334: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
335: THEN
336:
337: FND_MESSAGE.SET_NAME('MRP','MRP_INVALID_BOM_REV');
338: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
339: l_flow_schedule_rec.bom_revision);
340: FND_MSG_PUB.Add;
341:
334: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
335: THEN
336:
337: FND_MESSAGE.SET_NAME('MRP','MRP_INVALID_BOM_REV');
338: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
339: l_flow_schedule_rec.bom_revision);
340: FND_MSG_PUB.Add;
341:
342: END IF;
403:
404: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
405: THEN
406:
407: FND_MESSAGE.SET_NAME('MRP','MRP_INVALID_BUILD_SEQ');
408: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
409: l_flow_schedule_rec.build_sequence);
410: FND_MSG_PUB.Add;
411:
404: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
405: THEN
406:
407: FND_MESSAGE.SET_NAME('MRP','MRP_INVALID_BUILD_SEQ');
408: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
409: l_flow_schedule_rec.build_sequence);
410: FND_MSG_PUB.Add;
411:
412: END IF;
460:
461: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
462: THEN
463:
464: FND_MESSAGE.SET_NAME('MRP','MRP_INVALID_CLASS_CODE');
465: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
466: l_flow_schedule_rec.class_code);
467: FND_MSG_PUB.Add;
468:
461: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
462: THEN
463:
464: FND_MESSAGE.SET_NAME('MRP','MRP_INVALID_CLASS_CODE');
465: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
466: l_flow_schedule_rec.class_code);
467: FND_MSG_PUB.Add;
468:
469: END IF;
510:
511: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
512: THEN
513:
514: FND_MESSAGE.SET_NAME('MRP','MRP_INVALID_COMP_LOC_ID');
515: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
516: l_flow_schedule_rec.completion_locator_id);
517: FND_MSG_PUB.Add;
518:
511: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
512: THEN
513:
514: FND_MESSAGE.SET_NAME('MRP','MRP_INVALID_COMP_LOC_ID');
515: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
516: l_flow_schedule_rec.completion_locator_id);
517: FND_MSG_PUB.Add;
518:
519: END IF;
560:
561: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
562: THEN
563:
564: FND_MESSAGE.SET_NAME('MRP','MRP_INVALID_COMP_SUBINV');
565: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
566: l_flow_schedule_rec.completion_subinventory);
567: FND_MSG_PUB.Add;
568:
561: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
562: THEN
563:
564: FND_MESSAGE.SET_NAME('MRP','MRP_INVALID_COMP_SUBINV');
565: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
566: l_flow_schedule_rec.completion_subinventory);
567: FND_MSG_PUB.Add;
568:
569: END IF;
622:
623: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
624: THEN
625:
626: FND_MESSAGE.SET_NAME('MRP','MRP_INVALID_DEMAND_SOURCE');
627: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
628: l_flow_schedule_rec.demand_source_header_id);
629: FND_MSG_PUB.Add;
630:
623: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
624: THEN
625:
626: FND_MESSAGE.SET_NAME('MRP','MRP_INVALID_DEMAND_SOURCE');
627: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
628: l_flow_schedule_rec.demand_source_header_id);
629: FND_MSG_PUB.Add;
630:
631: END IF;
668:
669: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
670: THEN
671:
672: FND_MESSAGE.SET_NAME('MRP','MRP_INVALID_LINE_ID');
673: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
674: l_flow_schedule_rec.line_id);
675: FND_MSG_PUB.Add;
676:
669: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
670: THEN
671:
672: FND_MESSAGE.SET_NAME('MRP','MRP_INVALID_LINE_ID');
673: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
674: l_flow_schedule_rec.line_id);
675: FND_MSG_PUB.Add;
676:
677: END IF;
721:
722: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
723: THEN
724:
725: FND_MESSAGE.SET_NAME('MRP','MRP_INVALID_ITEM');
726: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
727: l_flow_schedule_rec.primary_item_id);
728: FND_MSG_PUB.Add;
729:
722: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
723: THEN
724:
725: FND_MESSAGE.SET_NAME('MRP','MRP_INVALID_ITEM');
726: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
727: l_flow_schedule_rec.primary_item_id);
728: FND_MSG_PUB.Add;
729:
730: END IF;
773:
774: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
775: THEN
776:
777: FND_MESSAGE.SET_NAME('MRP','MRP_INVALID_RTG_REV');
778: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
779: l_flow_schedule_rec.routing_revision);
780: FND_MSG_PUB.Add;
781:
774: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
775: THEN
776:
777: FND_MESSAGE.SET_NAME('MRP','MRP_INVALID_RTG_REV');
778: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
779: l_flow_schedule_rec.routing_revision);
780: FND_MSG_PUB.Add;
781:
782: END IF;
820:
821: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
822: THEN
823:
824: FND_MESSAGE.SET_NAME('MRP','MRP_INVALID_SCH_GRP');
825: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
826: l_flow_schedule_rec.schedule_group_id);
827: FND_MSG_PUB.Add;
828:
821: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
822: THEN
823:
824: FND_MESSAGE.SET_NAME('MRP','MRP_INVALID_SCH_GRP');
825: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
826: l_flow_schedule_rec.schedule_group_id);
827: FND_MSG_PUB.Add;
828:
829: END IF;
867:
868: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
869: THEN
870:
871: FND_MESSAGE.SET_NAME('MRP','MRP_INVALID_TASK');
872: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
873: l_flow_schedule_rec.task_id);
874: FND_MSG_PUB.Add;
875:
868: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
869: THEN
870:
871: FND_MESSAGE.SET_NAME('MRP','MRP_INVALID_TASK');
872: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
873: l_flow_schedule_rec.task_id);
874: FND_MSG_PUB.Add;
875:
876: END IF;