811: IF (l_count > 0)
812: THEN
813: x_ok_to_delete := FND_API.G_FALSE;
814: l_message := 'EGO_ASSOCIATED_AG_IN_USE';
815: FND_MESSAGE.Set_Name(g_app_name, l_message);
816: FND_MESSAGE.Set_Token('ATTR_GROUP_NAME', l_attr_display_name);
817: FND_MSG_PUB.Add;
818: x_return_status := FND_API.G_RET_STS_ERROR;
819: END IF;
812: THEN
813: x_ok_to_delete := FND_API.G_FALSE;
814: l_message := 'EGO_ASSOCIATED_AG_IN_USE';
815: FND_MESSAGE.Set_Name(g_app_name, l_message);
816: FND_MESSAGE.Set_Token('ATTR_GROUP_NAME', l_attr_display_name);
817: FND_MSG_PUB.Add;
818: x_return_status := FND_API.G_RET_STS_ERROR;
819: END IF;
820:
841: IF (l_count > 0)
842: THEN
843: x_ok_to_delete := FND_API.G_FALSE;
844: l_message := 'EGO_ASSOCIATED_AG_IN_USE';
845: FND_MESSAGE.Set_Name(g_app_name, l_message);
846: FND_MESSAGE.Set_Token('ATTR_GROUP_NAME', l_attr_display_name);
847: FND_MSG_PUB.Add;
848: x_return_status := FND_API.G_RET_STS_ERROR;
849: END IF;
842: THEN
843: x_ok_to_delete := FND_API.G_FALSE;
844: l_message := 'EGO_ASSOCIATED_AG_IN_USE';
845: FND_MESSAGE.Set_Name(g_app_name, l_message);
846: FND_MESSAGE.Set_Token('ATTR_GROUP_NAME', l_attr_display_name);
847: FND_MSG_PUB.Add;
848: x_return_status := FND_API.G_RET_STS_ERROR;
849: END IF;
850:
866: IF (l_count > 0)
867: THEN
868: x_ok_to_delete := FND_API.G_FALSE;
869: l_message := 'EGO_ASSOCIATED_AG_IN_USE';
870: FND_MESSAGE.Set_Name(g_app_name, l_message);
871: FND_MESSAGE.Set_Token('ATTR_GROUP_NAME', l_attr_display_name);
872: FND_MSG_PUB.Add;
873: x_return_status := FND_API.G_RET_STS_ERROR;
874: END IF;
867: THEN
868: x_ok_to_delete := FND_API.G_FALSE;
869: l_message := 'EGO_ASSOCIATED_AG_IN_USE';
870: FND_MESSAGE.Set_Name(g_app_name, l_message);
871: FND_MESSAGE.Set_Token('ATTR_GROUP_NAME', l_attr_display_name);
872: FND_MSG_PUB.Add;
873: x_return_status := FND_API.G_RET_STS_ERROR;
874: END IF;
875: END IF; --if no search criteria exist
892: l_style_exists := EGO_STYLE_SKU_ITEM_PVT.IsStyle_Item_Exist_For_ICC( p_classification_code );
893: IF l_style_exists = FND_API.G_TRUE THEN
894: x_ok_to_delete := FND_API.G_FALSE;
895: l_message := 'EGO_ASSOCIATED_AG_IN_USE';
896: FND_MESSAGE.Set_Name(g_app_name, l_message);
897: FND_MESSAGE.Set_Token('ATTR_GROUP_NAME', l_attr_display_name);
898: FND_MSG_PUB.Add;
899: x_return_status := FND_API.G_RET_STS_ERROR;
900: END IF;
893: IF l_style_exists = FND_API.G_TRUE THEN
894: x_ok_to_delete := FND_API.G_FALSE;
895: l_message := 'EGO_ASSOCIATED_AG_IN_USE';
896: FND_MESSAGE.Set_Name(g_app_name, l_message);
897: FND_MESSAGE.Set_Token('ATTR_GROUP_NAME', l_attr_display_name);
898: FND_MSG_PUB.Add;
899: x_return_status := FND_API.G_RET_STS_ERROR;
900: END IF;
901: END IF;
914: EXCEPTION
915: WHEN OTHERS THEN
916: x_ok_to_delete := FND_API.G_FALSE;
917: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
918: FND_MESSAGE.Set_Name(g_app_name, g_plsql_err);
919: FND_MESSAGE.Set_Token(g_pkg_name_token, g_pkg_name);
920: FND_MESSAGE.Set_Token(g_api_name_token, l_api_name);
921: FND_MESSAGE.Set_Token(g_sql_err_msg_token, SQLERRM);
922: FND_MSG_PUB.Add;
915: WHEN OTHERS THEN
916: x_ok_to_delete := FND_API.G_FALSE;
917: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
918: FND_MESSAGE.Set_Name(g_app_name, g_plsql_err);
919: FND_MESSAGE.Set_Token(g_pkg_name_token, g_pkg_name);
920: FND_MESSAGE.Set_Token(g_api_name_token, l_api_name);
921: FND_MESSAGE.Set_Token(g_sql_err_msg_token, SQLERRM);
922: FND_MSG_PUB.Add;
923:
916: x_ok_to_delete := FND_API.G_FALSE;
917: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
918: FND_MESSAGE.Set_Name(g_app_name, g_plsql_err);
919: FND_MESSAGE.Set_Token(g_pkg_name_token, g_pkg_name);
920: FND_MESSAGE.Set_Token(g_api_name_token, l_api_name);
921: FND_MESSAGE.Set_Token(g_sql_err_msg_token, SQLERRM);
922: FND_MSG_PUB.Add;
923:
924: END Check_Delete_AttrGroup_Assoc;
917: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
918: FND_MESSAGE.Set_Name(g_app_name, g_plsql_err);
919: FND_MESSAGE.Set_Token(g_pkg_name_token, g_pkg_name);
920: FND_MESSAGE.Set_Token(g_api_name_token, l_api_name);
921: FND_MESSAGE.Set_Token(g_sql_err_msg_token, SQLERRM);
922: FND_MSG_PUB.Add;
923:
924: END Check_Delete_AttrGroup_Assoc;
925: ---------------------------------------------------------------
1018: OPEN c;
1019: FETCH c into recinfo;
1020: IF (c%notfound) THEN
1021: CLOSE c;
1022: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
1023: app_exception.raise_exception;
1024: END IF;
1025: CLOSE c;
1026:
1072: ) THEN
1073: null;
1074: ELSE
1075: --failed to lock row b/c data has changed since last fetch
1076: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
1077: app_exception.raise_exception;
1078: end if;
1079:
1080:
1085: ) then
1086: null;
1087: else
1088: --failed to lock row b/c data has changed since last fetch
1089: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
1090: app_exception.raise_exception;
1091: end if;
1092: end if;
1093: end loop;