DBA Data[Home] [Help]

APPS.EGO_ITEM_CATALOG_PUB dependencies on FND_MESSAGE

Line 881: FND_MESSAGE.Set_Name(g_app_name, l_message);

877: IF (l_count > 0)
878: THEN
879: x_ok_to_delete := FND_API.G_FALSE;
880: l_message := 'EGO_ASSOCIATED_AG_IN_USE';
881: FND_MESSAGE.Set_Name(g_app_name, l_message);
882: FND_MESSAGE.Set_Token('ATTR_GROUP_NAME', l_attr_display_name);
883: FND_MSG_PUB.Add;
884: x_return_status := FND_API.G_RET_STS_ERROR;
885: END IF;

Line 882: FND_MESSAGE.Set_Token('ATTR_GROUP_NAME', l_attr_display_name);

878: THEN
879: x_ok_to_delete := FND_API.G_FALSE;
880: l_message := 'EGO_ASSOCIATED_AG_IN_USE';
881: FND_MESSAGE.Set_Name(g_app_name, l_message);
882: FND_MESSAGE.Set_Token('ATTR_GROUP_NAME', l_attr_display_name);
883: FND_MSG_PUB.Add;
884: x_return_status := FND_API.G_RET_STS_ERROR;
885: END IF;
886:

Line 911: FND_MESSAGE.Set_Name(g_app_name, l_message);

907: IF (l_count > 0)
908: THEN
909: x_ok_to_delete := FND_API.G_FALSE;
910: l_message := 'EGO_ASSOCIATED_AG_IN_USE';
911: FND_MESSAGE.Set_Name(g_app_name, l_message);
912: FND_MESSAGE.Set_Token('ATTR_GROUP_NAME', l_attr_display_name);
913: FND_MSG_PUB.Add;
914: x_return_status := FND_API.G_RET_STS_ERROR;
915: END IF;

Line 912: FND_MESSAGE.Set_Token('ATTR_GROUP_NAME', l_attr_display_name);

908: THEN
909: x_ok_to_delete := FND_API.G_FALSE;
910: l_message := 'EGO_ASSOCIATED_AG_IN_USE';
911: FND_MESSAGE.Set_Name(g_app_name, l_message);
912: FND_MESSAGE.Set_Token('ATTR_GROUP_NAME', l_attr_display_name);
913: FND_MSG_PUB.Add;
914: x_return_status := FND_API.G_RET_STS_ERROR;
915: END IF;
916:

Line 936: FND_MESSAGE.Set_Name(g_app_name, l_message);

932: IF (l_count > 0)
933: THEN
934: x_ok_to_delete := FND_API.G_FALSE;
935: l_message := 'EGO_ASSOCIATED_AG_IN_USE';
936: FND_MESSAGE.Set_Name(g_app_name, l_message);
937: FND_MESSAGE.Set_Token('ATTR_GROUP_NAME', l_attr_display_name);
938: FND_MSG_PUB.Add;
939: x_return_status := FND_API.G_RET_STS_ERROR;
940: END IF;

Line 937: FND_MESSAGE.Set_Token('ATTR_GROUP_NAME', l_attr_display_name);

933: THEN
934: x_ok_to_delete := FND_API.G_FALSE;
935: l_message := 'EGO_ASSOCIATED_AG_IN_USE';
936: FND_MESSAGE.Set_Name(g_app_name, l_message);
937: FND_MESSAGE.Set_Token('ATTR_GROUP_NAME', l_attr_display_name);
938: FND_MSG_PUB.Add;
939: x_return_status := FND_API.G_RET_STS_ERROR;
940: END IF;
941: END IF; --if no search criteria exist

Line 962: FND_MESSAGE.Set_Name(g_app_name, l_message);

958: l_style_exists := EGO_STYLE_SKU_ITEM_PVT.IsStyle_Item_Exist_For_ICC( p_classification_code );
959: IF l_style_exists = FND_API.G_TRUE THEN
960: x_ok_to_delete := FND_API.G_FALSE;
961: l_message := 'EGO_ASSOCIATED_AG_IN_USE';
962: FND_MESSAGE.Set_Name(g_app_name, l_message);
963: FND_MESSAGE.Set_Token('ATTR_GROUP_NAME', l_attr_display_name);
964: FND_MSG_PUB.Add;
965: x_return_status := FND_API.G_RET_STS_ERROR;
966: END IF;

Line 963: FND_MESSAGE.Set_Token('ATTR_GROUP_NAME', l_attr_display_name);

959: IF l_style_exists = FND_API.G_TRUE THEN
960: x_ok_to_delete := FND_API.G_FALSE;
961: l_message := 'EGO_ASSOCIATED_AG_IN_USE';
962: FND_MESSAGE.Set_Name(g_app_name, l_message);
963: FND_MESSAGE.Set_Token('ATTR_GROUP_NAME', l_attr_display_name);
964: FND_MSG_PUB.Add;
965: x_return_status := FND_API.G_RET_STS_ERROR;
966: END IF;
967: END IF;

Line 984: FND_MESSAGE.Set_Name(g_app_name, g_plsql_err);

980: EXCEPTION
981: WHEN OTHERS THEN
982: x_ok_to_delete := FND_API.G_FALSE;
983: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
984: FND_MESSAGE.Set_Name(g_app_name, g_plsql_err);
985: FND_MESSAGE.Set_Token(g_pkg_name_token, g_pkg_name);
986: FND_MESSAGE.Set_Token(g_api_name_token, l_api_name);
987: FND_MESSAGE.Set_Token(g_sql_err_msg_token, SQLERRM);
988: FND_MSG_PUB.Add;

Line 985: FND_MESSAGE.Set_Token(g_pkg_name_token, g_pkg_name);

981: WHEN OTHERS THEN
982: x_ok_to_delete := FND_API.G_FALSE;
983: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
984: FND_MESSAGE.Set_Name(g_app_name, g_plsql_err);
985: FND_MESSAGE.Set_Token(g_pkg_name_token, g_pkg_name);
986: FND_MESSAGE.Set_Token(g_api_name_token, l_api_name);
987: FND_MESSAGE.Set_Token(g_sql_err_msg_token, SQLERRM);
988: FND_MSG_PUB.Add;
989:

Line 986: FND_MESSAGE.Set_Token(g_api_name_token, l_api_name);

982: x_ok_to_delete := FND_API.G_FALSE;
983: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
984: FND_MESSAGE.Set_Name(g_app_name, g_plsql_err);
985: FND_MESSAGE.Set_Token(g_pkg_name_token, g_pkg_name);
986: FND_MESSAGE.Set_Token(g_api_name_token, l_api_name);
987: FND_MESSAGE.Set_Token(g_sql_err_msg_token, SQLERRM);
988: FND_MSG_PUB.Add;
989:
990: END Check_Delete_AttrGroup_Assoc;

Line 987: FND_MESSAGE.Set_Token(g_sql_err_msg_token, SQLERRM);

983: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
984: FND_MESSAGE.Set_Name(g_app_name, g_plsql_err);
985: FND_MESSAGE.Set_Token(g_pkg_name_token, g_pkg_name);
986: FND_MESSAGE.Set_Token(g_api_name_token, l_api_name);
987: FND_MESSAGE.Set_Token(g_sql_err_msg_token, SQLERRM);
988: FND_MSG_PUB.Add;
989:
990: END Check_Delete_AttrGroup_Assoc;
991: ---------------------------------------------------------------

Line 1088: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');

1084: OPEN c;
1085: FETCH c into recinfo;
1086: IF (c%notfound) THEN
1087: CLOSE c;
1088: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
1089: app_exception.raise_exception;
1090: END IF;
1091: CLOSE c;
1092:

Line 1142: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');

1138: ) THEN
1139: null;
1140: ELSE
1141: --failed to lock row b/c data has changed since last fetch
1142: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
1143: app_exception.raise_exception;
1144: end if;
1145:
1146:

Line 1155: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');

1151: ) then
1152: null;
1153: else
1154: --failed to lock row b/c data has changed since last fetch
1155: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
1156: app_exception.raise_exception;
1157: end if;
1158: end if;
1159: end loop;