67:
68: BEGIN
69:
70: IF fnd_api.to_boolean(P_Init_Msg_List) THEN
71: FND_MSG_PUB.initialize;
72: END IF;
73:
74: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version,
75: l_api_name, g_pkg_name)
108: END IF;
109:
110: EXCEPTION
111: WHEN OTHERS THEN
112: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
113: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
114: IF (g_fnd_debug = 'Y') AND FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
115: FND_LOG.string(FND_LOG.level_unexpected, g_module_prefix ||
116: l_api_name || '.others_exception', sqlcode);
109:
110: EXCEPTION
111: WHEN OTHERS THEN
112: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
113: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
114: IF (g_fnd_debug = 'Y') AND FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
115: FND_LOG.string(FND_LOG.level_unexpected, g_module_prefix ||
116: l_api_name || '.others_exception', sqlcode);
117: END IF;
591:
592: BEGIN
593:
594: IF fnd_api.to_boolean(P_Init_Msg_List) THEN
595: FND_MSG_PUB.initialize;
596: END IF;
597:
598: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version,
599: l_api_name, g_pkg_name)
742: FND_LOG.string(FND_LOG.level_unexpected, g_module_prefix ||
743: l_api_name || '.NO_DATA_FOUND Exception', sqlcode);
744: END IF;
745: WHEN OTHERS THEN
746: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
747: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
748: IF (g_fnd_debug = 'Y') AND FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
749: FND_LOG.string(FND_LOG.level_unexpected, g_module_prefix ||
750: l_api_name || '.others_exception', sqlcode);
743: l_api_name || '.NO_DATA_FOUND Exception', sqlcode);
744: END IF;
745: WHEN OTHERS THEN
746: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
747: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
748: IF (g_fnd_debug = 'Y') AND FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
749: FND_LOG.string(FND_LOG.level_unexpected, g_module_prefix ||
750: l_api_name || '.others_exception', sqlcode);
751: END IF;
793:
794: BEGIN
795:
796: IF fnd_api.to_boolean(P_Init_Msg_List) THEN
797: FND_MSG_PUB.initialize;
798: END IF;
799:
800: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version,
801: l_api_name, g_pkg_name) THEN
984: END IF;
985:
986: EXCEPTION
987: WHEN OTHERS THEN
988: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
989: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
990: IF (g_fnd_debug = 'Y') AND FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
991: FND_LOG.string(FND_LOG.level_unexpected, g_module_prefix ||
992: l_api_name || '.others_exception', sqlcode);
985:
986: EXCEPTION
987: WHEN OTHERS THEN
988: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
989: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
990: IF (g_fnd_debug = 'Y') AND FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
991: FND_LOG.string(FND_LOG.level_unexpected, g_module_prefix ||
992: l_api_name || '.others_exception', sqlcode);
993: END IF;
1037:
1038: BEGIN
1039:
1040: IF fnd_api.to_boolean(P_Init_Msg_List) THEN
1041: FND_MSG_PUB.initialize;
1042: END IF;
1043:
1044: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version,
1045: l_api_name, g_pkg_name)
1106: WHEN FND_API.g_exc_unexpected_error THEN
1107: x_return_status := FND_API.g_ret_sts_unexp_error;
1108: WHEN OTHERS THEN
1109: x_return_status := FND_API.g_ret_sts_unexp_error;
1110: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
1111: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
1112: IF (g_fnd_debug = 'Y') AND FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1113: FND_LOG.string(FND_LOG.level_unexpected, g_module_prefix ||
1114: l_api_name || '.others_exception', sqlcode);
1107: x_return_status := FND_API.g_ret_sts_unexp_error;
1108: WHEN OTHERS THEN
1109: x_return_status := FND_API.g_ret_sts_unexp_error;
1110: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
1111: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
1112: IF (g_fnd_debug = 'Y') AND FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1113: FND_LOG.string(FND_LOG.level_unexpected, g_module_prefix ||
1114: l_api_name || '.others_exception', sqlcode);
1115: END IF;
1235:
1236: BEGIN
1237:
1238: IF fnd_api.to_boolean(P_Init_Msg_List) THEN
1239: FND_MSG_PUB.initialize;
1240: END IF;
1241:
1242:
1243: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version,
1467: WHEN FND_API.g_exc_unexpected_error THEN
1468: x_return_status := FND_API.g_ret_sts_unexp_error;
1469: WHEN OTHERS THEN
1470: x_return_status := FND_API.g_ret_sts_unexp_error;
1471: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
1472: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
1473: IF (g_fnd_debug = 'Y') AND FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1474: FND_LOG.string(FND_LOG.level_unexpected, g_module_prefix ||
1475: l_api_name || '.others_exception', sqlcode);
1468: x_return_status := FND_API.g_ret_sts_unexp_error;
1469: WHEN OTHERS THEN
1470: x_return_status := FND_API.g_ret_sts_unexp_error;
1471: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
1472: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
1473: IF (g_fnd_debug = 'Y') AND FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1474: FND_LOG.string(FND_LOG.level_unexpected, g_module_prefix ||
1475: l_api_name || '.others_exception', sqlcode);
1476: END IF;
1571:
1572: BEGIN
1573:
1574: IF fnd_api.to_boolean(P_Init_Msg_List) THEN
1575: FND_MSG_PUB.initialize;
1576: END IF;
1577:
1578: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version,
1579: l_api_name, g_pkg_name)
1612: END IF;
1613:
1614: EXCEPTION
1615: WHEN OTHERS THEN
1616: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
1617: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
1618: IF (g_fnd_debug = 'Y') AND FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1619: FND_LOG.string(FND_LOG.level_unexpected, g_module_prefix ||
1620: l_api_name || '.others_exception', sqlcode);
1613:
1614: EXCEPTION
1615: WHEN OTHERS THEN
1616: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
1617: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
1618: IF (g_fnd_debug = 'Y') AND FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1619: FND_LOG.string(FND_LOG.level_unexpected, g_module_prefix ||
1620: l_api_name || '.others_exception', sqlcode);
1621: END IF;
1672:
1673: BEGIN
1674:
1675: IF fnd_api.to_boolean(P_Init_Msg_List) THEN
1676: FND_MSG_PUB.initialize;
1677: END IF;
1678:
1679: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version,
1680: l_api_name, g_pkg_name)
1825: WHEN FND_API.g_exc_unexpected_error THEN
1826: x_return_status := FND_API.g_ret_sts_unexp_error;
1827: WHEN OTHERS THEN
1828: x_return_status := FND_API.g_ret_sts_unexp_error;
1829: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
1830: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
1831: IF (g_fnd_debug = 'Y') AND FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1832: FND_LOG.string(FND_LOG.level_unexpected, g_module_prefix ||
1833: l_api_name || '.others_exception', sqlcode);
1826: x_return_status := FND_API.g_ret_sts_unexp_error;
1827: WHEN OTHERS THEN
1828: x_return_status := FND_API.g_ret_sts_unexp_error;
1829: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
1830: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
1831: IF (g_fnd_debug = 'Y') AND FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1832: FND_LOG.string(FND_LOG.level_unexpected, g_module_prefix ||
1833: l_api_name || '.others_exception', sqlcode);
1834: END IF;