eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.EGO_ITEM_CATALOG_PUB dependencies on FND_API

Line 104: IF l_return_status <> FND_API.G_RET_STS_SUCCESS

100: , p_mesg_token_tbl => l_mesg_token_tbl
101: , x_mesg_token_tbl => l_mesg_token_tbl
102: );
103:
104: IF l_return_status <> FND_API.G_RET_STS_SUCCESS
105: THEN
106: Error_Handler.Set_Debug('N');
107: END IF;
108: END IF;

Line 519: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN

515: , x_catalog_group_name => x_catalog_group_name
516: );
517:
518: -- PIM4TELCO: CHECHAND: INSERT A ROW IN VERSIONS TABLE FOR DEFAULT DRAFT VERSION. - START
519: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
520: -- dbms_output.put_line ('PIM Telco Profile Value: '||profile_value);
521: if profile_value = 'Y' then
522: SELECT message_text into draft_str
523: FROM fnd_new_messages

Line 561: IF x_return_status = FND_API.G_RET_STS_SUCCESS AND

557: -- PIM4TELCO: CHECHAND: - END
558:
559:
560: -- Create an association between Default Template and Catalog Group
561: IF x_return_status = FND_API.G_RET_STS_SUCCESS AND
562: p_Template_Id is not null THEN
563:
564: INSERT INTO ego_cat_grp_templates
565: ( template_id

Line 595: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

591: END IF;
592:
593: EXCEPTION
594: WHEN OTHERS THEN
595: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
596:
597: Ego_Catalog_Group_Err_Handler.Log_Error
598: ( p_error_status => x_return_status
599: , p_error_scope => Error_Handler.G_SCOPE_ALL

Line 724: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN

720: , x_catalog_group_name => x_catalog_group_name
721: );
722:
723: -- Create an association between Default Template and Catalog Group
724: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
725:
726: -- check if catalog group is already associated with a default template
727: SELECT 'x' INTO v_dummy
728: FROM ego_cat_grp_templates

Line 788: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

784:
785: END IF;
786:
787: WHEN OTHERS THEN
788: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
789:
790: Ego_Catalog_Group_Err_Handler.Log_Error
791: ( p_error_status => x_return_status
792: , p_error_scope => Error_Handler.G_SCOPE_ALL

Line 823: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_FALSE

819: ,p_application_id IN NUMBER
820: ,p_attr_group_type IN VARCHAR2
821: ,p_attr_group_name IN VARCHAR2
822: ,p_enabled_code IN VARCHAR2
823: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_FALSE
824: ,x_ok_to_delete OUT NOCOPY VARCHAR2
825: ,x_return_status OUT NOCOPY VARCHAR2
826: ,x_errorcode OUT NOCOPY NUMBER
827: ,x_msg_count OUT NOCOPY NUMBER

Line 846: IF NOT FND_API.Compatible_API_Call (l_api_version

842:
843: BEGIN
844:
845: --Standard checks
846: IF NOT FND_API.Compatible_API_Call (l_api_version
847: ,p_api_version
848: ,l_api_name
849: ,g_pkg_name)
850: THEN

Line 851: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

847: ,p_api_version
848: ,l_api_name
849: ,g_pkg_name)
850: THEN
851: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
852: END IF;
853:
854: -- Initialize message list if p_init_msg_list is set to TRUE
855: IF FND_API.To_Boolean(p_init_msg_list) THEN

Line 855: IF FND_API.To_Boolean(p_init_msg_list) THEN

851: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
852: END IF;
853:
854: -- Initialize message list if p_init_msg_list is set to TRUE
855: IF FND_API.To_Boolean(p_init_msg_list) THEN
856: FND_MSG_PUB.Initialize;
857: END IF;
858:
859: SELECT

Line 879: x_ok_to_delete := FND_API.G_FALSE;

875: AND B.OBJ_NAME = 'EGO_ITEM' ;
876:
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;

Line 884: x_return_status := FND_API.G_RET_STS_ERROR;

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:
887: -- now need to get all the classification code that has p_classification_code as its parent
888: IF (l_count = 0) THEN

Line 909: x_ok_to_delete := FND_API.G_FALSE;

905:
906: EXECUTE IMMEDIATE l_dynamic_sql INTO l_count USING p_classification_code, p_classification_code, l_attr_group_id;
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;

Line 914: x_return_status := FND_API.G_RET_STS_ERROR;

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:
917: IF (l_count = 0) THEN
918: -- check if this ag is used to create any result formats

Line 934: x_ok_to_delete := FND_API.G_FALSE;

930:
931: EXECUTE IMMEDIATE l_dynamic_sql INTO l_count USING p_classification_code, p_classification_code, l_attr_group_id;
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;

Line 939: x_return_status := FND_API.G_RET_STS_ERROR;

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
942: END IF; -- no page entry exist
943:

Line 959: IF l_style_exists = FND_API.G_TRUE THEN

955: IF l_variant_Behaviour = 'Y' THEN
956: -- Style Exists check is enough for SKU Exists check,
957: -- Since SKU cannot exists with out a Style
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);

Line 960: x_ok_to_delete := FND_API.G_FALSE;

956: -- Style Exists check is enough for SKU Exists check,
957: -- Since SKU cannot exists with out a Style
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;

Line 965: x_return_status := FND_API.G_RET_STS_ERROR;

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;
968:
969:

Line 971: p_encoded => FND_API.G_FALSE,

967: END IF;
968:
969:
970: FND_MSG_PUB.Count_And_Get(
971: p_encoded => FND_API.G_FALSE,
972: p_count => x_msg_count,
973: p_data => x_msg_data
974: );
975:

Line 977: x_return_status := FND_API.G_RET_STS_SUCCESS;

973: p_data => x_msg_data
974: );
975:
976: IF (l_message IS NULL) THEN
977: x_return_status := FND_API.G_RET_STS_SUCCESS;
978: x_ok_to_delete := FND_API.G_TRUE;
979: END IF;
980: EXCEPTION
981: WHEN OTHERS THEN

Line 978: x_ok_to_delete := FND_API.G_TRUE;

974: );
975:
976: IF (l_message IS NULL) THEN
977: x_return_status := FND_API.G_RET_STS_SUCCESS;
978: x_ok_to_delete := FND_API.G_TRUE;
979: END IF;
980: EXCEPTION
981: WHEN OTHERS THEN
982: x_ok_to_delete := FND_API.G_FALSE;

Line 982: x_ok_to_delete := FND_API.G_FALSE;

978: x_ok_to_delete := FND_API.G_TRUE;
979: END IF;
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);

Line 983: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

979: END IF;
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);