DBA Data[Home] [Help]

APPS.GMD_ROUTING_STEPS_PVT dependencies on FND_MSG_PUB

Line 81: FND_MSG_PUB.ADD;

77: OPEN Get_routingstep_id_seq;
78: FETCH Get_routingstep_id_seq INTO l_routingStep_id;
79: IF Get_routingStep_id_seq%NOTFOUND then
80: FND_MESSAGE.SET_NAME('GMD', 'GMD_INVALID_ROUT_SEQ');
81: FND_MSG_PUB.ADD;
82: CLOSE Get_routingstep_id_seq;
83: RAISE routing_step_creation_failure;
84: END IF;
85: CLOSE Get_routingstep_id_seq;

Line 138: fnd_msg_pub.add_exc_msg (gmd_routing_steps_PUB.m_pkg_name, l_api_name);

134: x_return_status := FND_API.G_RET_STS_ERROR;
135: WHEN setup_failure THEN
136: x_return_status := FND_API.G_RET_STS_ERROR;
137: WHEN OTHERS THEN
138: fnd_msg_pub.add_exc_msg (gmd_routing_steps_PUB.m_pkg_name, l_api_name);
139: IF (l_debug = 'Y') THEN
140: gmd_debug.put_line (m_pkg_name||'.'||l_api_name||':'||'When others exception:'||SQLERRM);
141: END IF;
142: x_return_status := FND_API.g_ret_sts_unexp_error;

Line 216: FND_MSG_PUB.ADD;

212: /* S.Dulyk - 12/27/02 Bug 2669986 Added validation for max_delay */
213: IF (p_routings_step_dep_tbl(i).max_delay < p_routings_step_dep_tbl(i).standard_delay AND
214: p_routings_step_dep_tbl(i).max_delay IS NOT NULL) THEN
215: FND_MESSAGE.SET_NAME('GMD','GMD_MAX_DELAY_VALIDATION');
216: FND_MSG_PUB.ADD;
217: x_return_status := FND_API.g_ret_sts_error;
218: END IF;
219:
220:

Line 283: fnd_msg_pub.add_exc_msg (gmd_routing_steps_PUB.m_pkg_name, l_api_name);

279: x_return_status := FND_API.G_RET_STS_ERROR;
280: WHEN setup_failure THEN
281: x_return_status := FND_API.G_RET_STS_ERROR;
282: WHEN OTHERS THEN
283: fnd_msg_pub.add_exc_msg (gmd_routing_steps_PUB.m_pkg_name, l_api_name);
284: IF (l_debug = 'Y') THEN
285: gmd_debug.put_line (m_pkg_name||'.'||l_api_name||':'||'When others exception:'||SQLERRM);
286: END IF;
287: x_return_status := FND_API.g_ret_sts_unexp_error;

Line 349: FND_MSG_PUB.ADD;

345: OPEN get_old_routingStep_rec(p_routingStep_id);
346: FETCH get_old_routingStep_rec INTO l_old_routingStep_rec;
347: IF get_old_routingStep_rec%NOTFOUND THEN
348: FND_MESSAGE.SET_NAME('GMD', 'GMD_ROUTINGSTEP_INVALID');
349: FND_MSG_PUB.ADD;
350: CLOSE get_old_routingStep_rec;
351: RAISE routing_update_step_failure;
352: END IF;
353: CLOSE get_old_routingStep_rec;

Line 530: FND_MSG_PUB.ADD;

526: x_return_status := FND_API.G_RET_STS_ERROR;
527: WHEN last_update_date_failure THEN
528: x_return_status := FND_API.G_RET_STS_ERROR;
529: FND_MESSAGE.SET_NAME('FND', 'FND_RECORD_CHANGED_ERROR');
530: FND_MSG_PUB.ADD;
531: WHEN setup_failure THEN
532: x_return_status := FND_API.G_RET_STS_ERROR;
533: WHEN OTHERS THEN
534: fnd_msg_pub.add_exc_msg (gmd_routing_steps_PUB.m_pkg_name, l_api_name);

Line 534: fnd_msg_pub.add_exc_msg (gmd_routing_steps_PUB.m_pkg_name, l_api_name);

530: FND_MSG_PUB.ADD;
531: WHEN setup_failure THEN
532: x_return_status := FND_API.G_RET_STS_ERROR;
533: WHEN OTHERS THEN
534: fnd_msg_pub.add_exc_msg (gmd_routing_steps_PUB.m_pkg_name, l_api_name);
535: IF (l_debug = 'Y') THEN
536: gmd_debug.put_line (m_pkg_name||'.'||l_api_name||':'||'When others exception:'||SQLERRM);
537: END IF;
538: x_return_status := FND_API.g_ret_sts_unexp_error;

Line 605: FND_MSG_PUB.ADD;

601: OPEN get_old_stepDep_rec(p_routingstep_no,p_dep_routingstep_no,p_routing_id);
602: FETCH get_old_stepDep_rec INTO l_old_stepDep_rec;
603: IF get_old_stepDep_rec%NOTFOUND THEN
604: FND_MESSAGE.SET_NAME('GMD', 'GMD_STEPDEP_INVALID');
605: FND_MSG_PUB.ADD;
606: CLOSE get_old_stepDep_rec;
607: RAISE routing_update_dep_failure;
608: END IF;
609: CLOSE get_old_stepDep_rec;

Line 650: FND_MSG_PUB.ADD;

646: /* S.Dulyk - 12/27/02 Bug 2669986 Added validation for max_delay */
647: IF (l_old_stepDep_rec.max_delay < l_old_stepDep_rec.standard_delay AND
648: l_old_stepDep_rec.max_delay IS NOT NULL) THEN
649: FND_MESSAGE.SET_NAME('GMD','GMD_MAX_DELAY_VALIDATION');
650: FND_MSG_PUB.ADD;
651: x_return_status := FND_API.g_ret_sts_error;
652: END IF;
653:
654: /* S.Dulyk - 12/27/02 Bug 2669986 Added max_delay */

Line 691: FND_MSG_PUB.ADD;

687: x_return_status := FND_API.G_RET_STS_ERROR;
688: WHEN last_update_date_failure THEN
689: x_return_status := FND_API.G_RET_STS_ERROR;
690: FND_MESSAGE.SET_NAME('FND', 'FND_RECORD_CHANGED_ERROR');
691: FND_MSG_PUB.ADD;
692: WHEN setup_failure THEN
693: x_return_status := FND_API.G_RET_STS_ERROR;
694: WHEN OTHERS THEN
695: fnd_msg_pub.add_exc_msg (gmd_routing_steps_PUB.m_pkg_name, l_api_name);

Line 695: fnd_msg_pub.add_exc_msg (gmd_routing_steps_PUB.m_pkg_name, l_api_name);

691: FND_MSG_PUB.ADD;
692: WHEN setup_failure THEN
693: x_return_status := FND_API.G_RET_STS_ERROR;
694: WHEN OTHERS THEN
695: fnd_msg_pub.add_exc_msg (gmd_routing_steps_PUB.m_pkg_name, l_api_name);
696: IF (l_debug = 'Y') THEN
697: gmd_debug.put_line (m_pkg_name||'.'||l_api_name||':'||'When others exception:'||SQLERRM);
698: END IF;
699: x_return_status := FND_API.g_ret_sts_unexp_error;

Line 804: FND_MSG_PUB.ADD;

800: ,x_return_status => l_return_status );
801: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
802: /* it indicates that this routing does'ntexists */
803: FND_MESSAGE.SET_NAME('GMD', 'GMD_ROUTINGSTEP_INVALID');
804: FND_MSG_PUB.ADD;
805: RAISE routing_delete_step_failure;
806: END IF;
807: END IF;
808:

Line 898: FND_MSG_PUB.ADD;

894: IF (l_debug = 'Y') THEN
895: gmd_debug.put_line (m_pkg_name||'.'||l_api_name||':'||'routing step '||l_routingstep_no||' has override data ');
896: END IF;
897: FND_MESSAGE.SET_NAME('GMD', 'GMD_STEP_USED_IN_RECIPE');
898: FND_MSG_PUB.ADD;
899: x_return_status := FND_API.G_RET_STS_ERROR;
900: WHEN routing_delete_stepdep_failure THEN
901: IF (l_debug = 'Y') THEN
902: gmd_debug.put_line (m_pkg_name||'.'||l_api_name||':'||'delete step dep API not complete');

Line 908: fnd_msg_pub.add_exc_msg (gmd_routing_steps_PUB.m_pkg_name, l_api_name);

904: x_return_status := FND_API.G_RET_STS_ERROR;
905: WHEN setup_failure THEN
906: x_return_status := FND_API.G_RET_STS_ERROR;
907: WHEN OTHERS THEN
908: fnd_msg_pub.add_exc_msg (gmd_routing_steps_PUB.m_pkg_name, l_api_name);
909: IF (l_debug = 'Y') THEN
910: gmd_debug.put_line (m_pkg_name||'.'||l_api_name||':'||'When others exception:'||SQLERRM);
911: END IF;
912: x_return_status := FND_API.g_ret_sts_unexp_error;

Line 995: fnd_msg_pub.add_exc_msg (gmd_routing_steps_PUB.m_pkg_name, l_api_name);

991: x_return_status := FND_API.G_RET_STS_ERROR;
992: WHEN setup_failure THEN
993: x_return_status := FND_API.G_RET_STS_ERROR;
994: WHEN OTHERS THEN
995: fnd_msg_pub.add_exc_msg (gmd_routing_steps_PUB.m_pkg_name, l_api_name);
996: IF (l_debug = 'Y') THEN
997: gmd_debug.put_line (m_pkg_name||'.'||l_api_name||':'||'When others exception:'||SQLERRM);
998: END IF;
999: x_return_status := FND_API.g_ret_sts_unexp_error;