510: OPEN Cur_get_routing_details (p_routing_id);
511: FETCH Cur_get_routing_details INTO l_routing_no, l_routing_vers;
512: CLOSE Cur_get_routing_details ;
513: -- Raise the Note Message.
514: FND_MESSAGE.SET_NAME('GMD', 'GMD_DF_ROUTING_STAT_NOT_VALID');
515: FND_MESSAGE.SET_TOKEN('STATUS', l_default_recipe_status.entity_status);
516: FND_MESSAGE.SET_TOKEN('ROUTING_NO', l_routing_no);
517: FND_MESSAGE.SET_TOKEN('ROUTING_VERS', l_routing_vers);
518: FND_MSG_PUB.ADD;
511: FETCH Cur_get_routing_details INTO l_routing_no, l_routing_vers;
512: CLOSE Cur_get_routing_details ;
513: -- Raise the Note Message.
514: FND_MESSAGE.SET_NAME('GMD', 'GMD_DF_ROUTING_STAT_NOT_VALID');
515: FND_MESSAGE.SET_TOKEN('STATUS', l_default_recipe_status.entity_status);
516: FND_MESSAGE.SET_TOKEN('ROUTING_NO', l_routing_no);
517: FND_MESSAGE.SET_TOKEN('ROUTING_VERS', l_routing_vers);
518: FND_MSG_PUB.ADD;
519: X_return_status := FND_API.G_RET_STS_SUCCESS;
512: CLOSE Cur_get_routing_details ;
513: -- Raise the Note Message.
514: FND_MESSAGE.SET_NAME('GMD', 'GMD_DF_ROUTING_STAT_NOT_VALID');
515: FND_MESSAGE.SET_TOKEN('STATUS', l_default_recipe_status.entity_status);
516: FND_MESSAGE.SET_TOKEN('ROUTING_NO', l_routing_no);
517: FND_MESSAGE.SET_TOKEN('ROUTING_VERS', l_routing_vers);
518: FND_MSG_PUB.ADD;
519: X_return_status := FND_API.G_RET_STS_SUCCESS;
520: RETURN;
513: -- Raise the Note Message.
514: FND_MESSAGE.SET_NAME('GMD', 'GMD_DF_ROUTING_STAT_NOT_VALID');
515: FND_MESSAGE.SET_TOKEN('STATUS', l_default_recipe_status.entity_status);
516: FND_MESSAGE.SET_TOKEN('ROUTING_NO', l_routing_no);
517: FND_MESSAGE.SET_TOKEN('ROUTING_VERS', l_routing_vers);
518: FND_MSG_PUB.ADD;
519: X_return_status := FND_API.G_RET_STS_SUCCESS;
520: RETURN;
521: END IF;