1: PACKAGE BODY GMD_SUBSTITUTION_PVT AS
2: /* $Header: GMDVSUBB.pls 120.0.12000000.1 2007/01/31 16:17:23 appldev noship $ */
3:
4: -- common cursors
5: CURSOR Cur_get_substitution(vSubstitution_id NUMBER) IS
200: p_count => x_message_count
201: ,p_encoded => FND_API.g_false
202: ,p_data => x_message_list);
203: WHEN OTHERS THEN
204: fnd_msg_pub.add_exc_msg (GMD_SUBSTITUTION_PVT.m_pkg_name, l_api_name);
205: x_return_status := FND_API.g_ret_sts_unexp_error;
206: fnd_msg_pub.count_and_get (
207: p_count => x_message_count
208: ,p_encoded => FND_API.g_false
266: p_count => x_message_count
267: ,p_encoded => FND_API.g_false
268: ,p_data => x_message_list);
269: WHEN OTHERS THEN
270: fnd_msg_pub.add_exc_msg (GMD_SUBSTITUTION_PVT.m_pkg_name, l_api_name);
271: x_return_status := FND_API.g_ret_sts_unexp_error;
272: fnd_msg_pub.count_and_get (
273: p_count => x_message_count
274: ,p_encoded => FND_API.g_false
387: p_count => x_message_count
388: ,p_encoded => FND_API.g_false
389: ,p_data => x_message_list);
390: WHEN OTHERS THEN
391: fnd_msg_pub.add_exc_msg (GMD_SUBSTITUTION_PVT.m_pkg_name, l_api_name);
392: x_return_status := FND_API.g_ret_sts_unexp_error;
393: fnd_msg_pub.count_and_get (
394: p_count => x_message_count
395: ,p_encoded => FND_API.g_false
562: p_count => x_message_count
563: ,p_encoded => FND_API.g_false
564: ,p_data => x_message_list);
565: WHEN OTHERS THEN
566: fnd_msg_pub.add_exc_msg (GMD_SUBSTITUTION_PVT.m_pkg_name, l_api_name);
567: x_return_status := FND_API.g_ret_sts_unexp_error;
568: fnd_msg_pub.count_and_get (
569: p_count => x_message_count
570: ,p_encoded => FND_API.g_false
621: ,p_encoded => FND_API.g_false
622: ,p_data => x_message_list);
623: EXCEPTION
624: WHEN OTHERS THEN
625: fnd_msg_pub.add_exc_msg (gmd_substitution_pvt.m_pkg_name, l_api_name);
626: x_return_status := FND_API.g_ret_sts_unexp_error;
627: fnd_msg_pub.count_and_get (
628: p_count => x_message_count
629: ,p_encoded => FND_API.g_false
715: ,p_encoded => FND_API.g_false
716: ,p_data => x_message_list);
717: EXCEPTION
718: WHEN OTHERS THEN
719: fnd_msg_pub.add_exc_msg (gmd_substitution_pvt.m_pkg_name, l_api_name);
720: x_return_status := FND_API.g_ret_sts_unexp_error;
721: fnd_msg_pub.count_and_get (
722: p_count => x_message_count
723: ,p_encoded => FND_API.g_false
942: p_count => x_message_count
943: ,p_encoded => FND_API.g_false
944: ,p_data => x_message_list);
945: WHEN OTHERS THEN
946: fnd_msg_pub.add_exc_msg (gmd_substitution_pvt.m_pkg_name, l_api_name);
947: x_return_status := FND_API.g_ret_sts_unexp_error;
948: fnd_msg_pub.count_and_get (
949: p_count => x_message_count
950: ,p_encoded => FND_API.g_false
950: ,p_encoded => FND_API.g_false
951: ,p_data => x_message_list);
952: END Copy_substitution;
953:
954: END GMD_SUBSTITUTION_PVT;