399:
400: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_SUCCESS)
401: THEN
402:
403: FND_MESSAGE.SET_NAME('MRP','MRP_BOTH_VAL_AND_ID_EXIST');
404: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','wip_entity');
405: FND_MSG_PUB.Add;
406:
407: END IF;
400: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_SUCCESS)
401: THEN
402:
403: FND_MESSAGE.SET_NAME('MRP','MRP_BOTH_VAL_AND_ID_EXIST');
404: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','wip_entity');
405: FND_MSG_PUB.Add;
406:
407: END IF;
408:
417: IF l_wip_entity_id = FND_API.G_MISS_NUM THEN
418: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
419: THEN
420:
421: FND_MESSAGE.SET_NAME('MRP','MRP_INVALID_BUSINESS_OBJ_VALUE');
422: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','wip_entity');
423: FND_MSG_PUB.Add;
424:
425: END IF;
418: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
419: THEN
420:
421: FND_MESSAGE.SET_NAME('MRP','MRP_INVALID_BUSINESS_OBJ_VALUE');
422: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','wip_entity');
423: FND_MSG_PUB.Add;
424:
425: END IF;
426: END IF;
868: AND ORGANIZATION_ID = p_org_id;
869:
870: IF (p_calculate_option NOT IN (0,1)) THEN
871: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
872: FND_MESSAGE.SET_NAME('MRP','MRP_INVALID_BUSINESS_OBJ_VALUE');
873: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','calculate_option');
874: FND_MSG_PUB.Add;
875: END IF;
876: RAISE FND_API.G_EXC_ERROR;
869:
870: IF (p_calculate_option NOT IN (0,1)) THEN
871: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
872: FND_MESSAGE.SET_NAME('MRP','MRP_INVALID_BUSINESS_OBJ_VALUE');
873: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','calculate_option');
874: FND_MSG_PUB.Add;
875: END IF;
876: RAISE FND_API.G_EXC_ERROR;
877: END IF;
882: WHERE OPERATION_SEQUENCE_ID = p_operation_sequence_id
883: AND ROUTING_SEQUENCE_ID = p_routing_sequence_id;
884: IF (l_cnt = 0) THEN
885: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
886: FND_MESSAGE.SET_NAME('MRP','MRP_INVALID_BUSINESS_OBJ_VALUE');
887: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','operation_sequence_id');
888: FND_MSG_PUB.Add;
889: END IF;
890: RAISE FND_API.G_EXC_ERROR;
883: AND ROUTING_SEQUENCE_ID = p_routing_sequence_id;
884: IF (l_cnt = 0) THEN
885: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
886: FND_MESSAGE.SET_NAME('MRP','MRP_INVALID_BUSINESS_OBJ_VALUE');
887: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','operation_sequence_id');
888: FND_MSG_PUB.Add;
889: END IF;
890: RAISE FND_API.G_EXC_ERROR;
891: END IF;
1008: from oe_order_lines_all
1009: where line_id = p_line_id;
1010: EXCEPTION WHEN OTHERS THEN
1011: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1012: FND_MESSAGE.SET_NAME('MRP','MRP_INVALID_OE_LINE_ID');
1013: FND_MSG_PUB.Add;
1014: END IF;
1015: RAISE FND_API.G_EXC_ERROR;
1016: END;
1016: END;
1017:
1018: if( p_assembly_item_id is null or l_item_id <> p_assembly_item_id ) then
1019: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1020: FND_MESSAGE.SET_NAME('MRP','MRP_ITEM_OE_LINE_ID_NOT_MATCH');
1021: FND_MSG_PUB.Add;
1022: END IF;
1023: RAISE FND_API.G_EXC_ERROR;
1024: end if;