1597:
1598:
1599: -- Initialize message list if p_init_msg_list is set to TRUE
1600: IF FND_API.To_Boolean(p_init_msg_list) THEN
1601: FND_MSG_PUB.Initialize;
1602: END IF;
1603:
1604: SELECT
1605: attr_group_disp_name INTO l_attr_display_name
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;
1628:
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
1652: -- check if this ag is used to create any result formats
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
1674: END IF; -- no page entry exist
1671: x_return_status := FND_API.G_RET_STS_ERROR;
1672: END IF;
1673: END IF; --if no search criteria exist
1674: END IF; -- no page entry exist
1675: FND_MSG_PUB.Count_And_Get(
1676: p_encoded => FND_API.G_FALSE,
1677: p_count => x_msg_count,
1678: p_data => x_msg_data
1679: );
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;
1697: --End of Bug:3070807