1618: IF (l_count > 0)
1619: THEN
1620: x_ok_to_delete := FND_API.G_FALSE;
1621: l_message := 'EGO_ASSOCIATED_AG_IN_USE';
1622: FND_MESSAGE.Set_Name(g_app_name, l_message);
1623: FND_MESSAGE.Set_Token('ATTR_GROUP_NAME', l_attr_display_name);
1624: FND_MSG_PUB.Add;
1625: x_return_status := FND_API.G_RET_STS_ERROR;
1626:
1619: THEN
1620: x_ok_to_delete := FND_API.G_FALSE;
1621: l_message := 'EGO_ASSOCIATED_AG_IN_USE';
1622: FND_MESSAGE.Set_Name(g_app_name, l_message);
1623: FND_MESSAGE.Set_Token('ATTR_GROUP_NAME', l_attr_display_name);
1624: FND_MSG_PUB.Add;
1625: x_return_status := FND_API.G_RET_STS_ERROR;
1626:
1627: END IF;
1642: IF (l_count > 0)
1643: THEN
1644: x_ok_to_delete := FND_API.G_FALSE;
1645: l_message := 'EGO_ASSOCIATED_AG_IN_USE';
1646: FND_MESSAGE.Set_Name(g_app_name, l_message);
1647: FND_MESSAGE.Set_Token('ATTR_GROUP_NAME', l_attr_display_name);
1648: FND_MSG_PUB.Add;
1649: x_return_status := FND_API.G_RET_STS_ERROR;
1650: END IF;
1643: THEN
1644: x_ok_to_delete := FND_API.G_FALSE;
1645: l_message := 'EGO_ASSOCIATED_AG_IN_USE';
1646: FND_MESSAGE.Set_Name(g_app_name, l_message);
1647: FND_MESSAGE.Set_Token('ATTR_GROUP_NAME', l_attr_display_name);
1648: FND_MSG_PUB.Add;
1649: x_return_status := FND_API.G_RET_STS_ERROR;
1650: END IF;
1651: IF (l_count = 0) THEN
1664: IF (l_count > 0)
1665: THEN
1666: x_ok_to_delete := FND_API.G_FALSE;
1667: l_message := 'EGO_ASSOCIATED_AG_IN_USE';
1668: FND_MESSAGE.Set_Name(g_app_name, l_message);
1669: FND_MESSAGE.Set_Token('ATTR_GROUP_NAME', l_attr_display_name);
1670: FND_MSG_PUB.Add;
1671: x_return_status := FND_API.G_RET_STS_ERROR;
1672: END IF;
1665: THEN
1666: x_ok_to_delete := FND_API.G_FALSE;
1667: l_message := 'EGO_ASSOCIATED_AG_IN_USE';
1668: FND_MESSAGE.Set_Name(g_app_name, l_message);
1669: FND_MESSAGE.Set_Token('ATTR_GROUP_NAME', l_attr_display_name);
1670: FND_MSG_PUB.Add;
1671: x_return_status := FND_API.G_RET_STS_ERROR;
1672: END IF;
1673: END IF; --if no search criteria exist
1685: EXCEPTION
1686: WHEN OTHERS THEN
1687: x_ok_to_delete := FND_API.G_FALSE;
1688: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1689: FND_MESSAGE.Set_Name(g_app_name, g_plsql_err);
1690: FND_MESSAGE.Set_Token(g_pkg_name_token, g_pkg_name);
1691: FND_MESSAGE.Set_Token(g_api_name_token, l_api_name);
1692: FND_MESSAGE.Set_Token(g_sql_err_msg_token, SQLERRM);
1693: FND_MSG_PUB.Add;
1686: WHEN OTHERS THEN
1687: x_ok_to_delete := FND_API.G_FALSE;
1688: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1689: FND_MESSAGE.Set_Name(g_app_name, g_plsql_err);
1690: FND_MESSAGE.Set_Token(g_pkg_name_token, g_pkg_name);
1691: FND_MESSAGE.Set_Token(g_api_name_token, l_api_name);
1692: FND_MESSAGE.Set_Token(g_sql_err_msg_token, SQLERRM);
1693: FND_MSG_PUB.Add;
1694:
1687: x_ok_to_delete := FND_API.G_FALSE;
1688: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1689: FND_MESSAGE.Set_Name(g_app_name, g_plsql_err);
1690: FND_MESSAGE.Set_Token(g_pkg_name_token, g_pkg_name);
1691: FND_MESSAGE.Set_Token(g_api_name_token, l_api_name);
1692: FND_MESSAGE.Set_Token(g_sql_err_msg_token, SQLERRM);
1693: FND_MSG_PUB.Add;
1694:
1695:
1688: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1689: FND_MESSAGE.Set_Name(g_app_name, g_plsql_err);
1690: FND_MESSAGE.Set_Token(g_pkg_name_token, g_pkg_name);
1691: FND_MESSAGE.Set_Token(g_api_name_token, l_api_name);
1692: FND_MESSAGE.Set_Token(g_sql_err_msg_token, SQLERRM);
1693: FND_MSG_PUB.Add;
1694:
1695:
1696: END Check_Delete_Associations;