DBA Data[Home] [Help]

APPS.EGO_ITEM_CATALOG_PUB dependencies on FND_MESSAGE

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

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;

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

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:

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

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;

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

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:

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

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;

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

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

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

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;

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

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;

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

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;

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

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:

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

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;

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

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: ---------------------------------------------------------------

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

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:

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

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:

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

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;