DBA Data[Home] [Help]

APPS.GMD_ROUTINGS_PVT dependencies on FND_MESSAGE

Line 162: FND_MESSAGE.SET_NAME('GMD', 'GMD_UNEXPECTED_ERROR');

158: WHEN routing_creation_failure OR invalid_version THEN
159: IF (l_debug = 'Y') THEN
160: gmd_debug.put_line (m_pkg_name||'.'||l_api_name||':'||'API not complete');
161: END IF;
162: FND_MESSAGE.SET_NAME('GMD', 'GMD_UNEXPECTED_ERROR');
163: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);
164: FND_MSG_PUB.ADD;
165: x_return_status := FND_API.G_RET_STS_ERROR;
166: fnd_msg_pub.count_and_get (

Line 163: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);

159: IF (l_debug = 'Y') THEN
160: gmd_debug.put_line (m_pkg_name||'.'||l_api_name||':'||'API not complete');
161: END IF;
162: FND_MESSAGE.SET_NAME('GMD', 'GMD_UNEXPECTED_ERROR');
163: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);
164: FND_MSG_PUB.ADD;
165: x_return_status := FND_API.G_RET_STS_ERROR;
166: fnd_msg_pub.count_and_get (
167: p_count => x_message_count

Line 287: FND_MESSAGE.SET_NAME('GMD', 'GMD_ROUTING_INVALID');

283: /* Get the old routing rec value */
284: OPEN get_old_routing_rec(p_routing_id);
285: FETCH get_old_routing_rec INTO l_old_routing_rec;
286: IF get_old_routing_rec%NOTFOUND THEN
287: FND_MESSAGE.SET_NAME('GMD', 'GMD_ROUTING_INVALID');
288: FND_MSG_PUB.ADD;
289: CLOSE get_old_routing_rec;
290: RAISE routing_update_failure;
291: END IF;

Line 465: FND_MESSAGE.SET_NAME('GMD', 'GMD_ROUTING_DATE_IN_VR_DATE');

461: ' VR Start Date = '||l_vr_start_date);
462: END IF;
463:
464: IF l_vr_start_date < l_old_routing_rec.effective_start_date THEN
465: FND_MESSAGE.SET_NAME('GMD', 'GMD_ROUTING_DATE_IN_VR_DATE');
466: FND_MSG_PUB.ADD;
467: RAISE routing_update_failure;
468: END IF;
469:

Line 483: FND_MESSAGE.SET_NAME('GMD', 'GMD_ROUTING_DATE_IN_VR_DATE');

479: END IF;
480:
481: IF (l_vr_end_date IS NULL) AND
482: (l_old_routing_rec.effective_end_date IS NOT NULL) THEN
483: FND_MESSAGE.SET_NAME('GMD', 'GMD_ROUTING_DATE_IN_VR_DATE');
484: FND_MSG_PUB.ADD;
485: RAISE routing_update_failure;
486: END IF;
487:

Line 489: FND_MESSAGE.SET_NAME('GMD', 'GMD_ROUTING_DATE_IN_VR_DATE');

485: RAISE routing_update_failure;
486: END IF;
487:
488: IF l_vr_end_date > l_old_routing_rec.effective_end_date THEN
489: FND_MESSAGE.SET_NAME('GMD', 'GMD_ROUTING_DATE_IN_VR_DATE');
490: FND_MSG_PUB.ADD;
491: RAISE routing_update_failure;
492: END IF;
493: END IF;

Line 585: FND_MESSAGE.SET_NAME('FND', 'FND_RECORD_CHANGED_ERROR');

581: ,p_encoded => FND_API.g_false
582: ,p_data => x_message_list);
583: WHEN last_update_date_failure THEN
584: x_return_status := FND_API.G_RET_STS_ERROR;
585: FND_MESSAGE.SET_NAME('FND', 'FND_RECORD_CHANGED_ERROR');
586: FND_MSG_PUB.ADD;
587: fnd_msg_pub.count_and_get (
588: p_count => x_message_count
589: ,p_encoded => FND_API.g_false

Line 648: FND_MESSAGE.SET_NAME('GMD', 'QC_MIN_MAX_DATE');

644: p_effective_start_date||' ) '||
645: 'must be less then end date ( '||
646: p_effective_end_date||' ) ');
647: END IF;
648: FND_MESSAGE.SET_NAME('GMD', 'QC_MIN_MAX_DATE');
649: FND_MSG_PUB.ADD;
650: RETURN -1;
651: END IF;
652:

Line 664: FND_MESSAGE.SET_NAME('GMD', 'GMD_ROUTING_DATE_IN_OPRN_DATE');

660: 'Routing Start Date = '||p_effective_start_date||
661: ' Oprn Start Date = '||l_oprn_start_date);
662: END IF;
663: IF l_oprn_start_date > p_effective_start_date THEN
664: FND_MESSAGE.SET_NAME('GMD', 'GMD_ROUTING_DATE_IN_OPRN_DATE');
665: FND_MSG_PUB.ADD;
666: RETURN -1;
667: END IF;
668:

Line 678: FND_MESSAGE.SET_NAME('GMD', 'GMD_ROUT_EFF_END_DATE');

674: ' Oprn end Date = '||l_oprn_end_date);
675: END IF;
676: IF (l_oprn_end_date IS NOT NULL) AND
677: (p_effective_end_date IS NULL) THEN
678: FND_MESSAGE.SET_NAME('GMD', 'GMD_ROUT_EFF_END_DATE');
679: FND_MSG_PUB.ADD;
680: RETURN -1;
681: END IF;
682:

Line 684: FND_MESSAGE.SET_NAME('GMD', 'GMD_ROUTING_DATE_IN_OPRN_DATE');

680: RETURN -1;
681: END IF;
682:
683: IF l_oprn_end_date < p_effective_end_date THEN
684: FND_MESSAGE.SET_NAME('GMD', 'GMD_ROUTING_DATE_IN_OPRN_DATE');
685: FND_MSG_PUB.ADD;
686: RETURN -1;
687: END IF;
688: END IF;