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 495: IF x_return_status = FND_API.G_RET_STS_SUCCESS AND

491: , x_catalog_group_name => x_catalog_group_name
492: );
493:
494: -- Create an association between Default Template and Catalog Group
495: IF x_return_status = FND_API.G_RET_STS_SUCCESS AND
496: p_Template_Id is not null THEN
497:
498: INSERT INTO ego_cat_grp_templates
499: ( template_id

Line 529: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

525: END IF;
526:
527: EXCEPTION
528: WHEN OTHERS THEN
529: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
530:
531: Ego_Catalog_Group_Err_Handler.Log_Error
532: ( p_error_status => x_return_status
533: , p_error_scope => Error_Handler.G_SCOPE_ALL

Line 658: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN

654: , x_catalog_group_name => x_catalog_group_name
655: );
656:
657: -- Create an association between Default Template and Catalog Group
658: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
659:
660: -- check if catalog group is already associated with a default template
661: SELECT 'x' INTO v_dummy
662: FROM ego_cat_grp_templates

Line 722: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

718:
719: END IF;
720:
721: WHEN OTHERS THEN
722: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
723:
724: Ego_Catalog_Group_Err_Handler.Log_Error
725: ( p_error_status => x_return_status
726: , p_error_scope => Error_Handler.G_SCOPE_ALL

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

753: ,p_application_id IN NUMBER
754: ,p_attr_group_type IN VARCHAR2
755: ,p_attr_group_name IN VARCHAR2
756: ,p_enabled_code IN VARCHAR2
757: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_FALSE
758: ,x_ok_to_delete OUT NOCOPY VARCHAR2
759: ,x_return_status OUT NOCOPY VARCHAR2
760: ,x_errorcode OUT NOCOPY NUMBER
761: ,x_msg_count OUT NOCOPY NUMBER

Line 780: IF NOT FND_API.Compatible_API_Call (l_api_version

776:
777: BEGIN
778:
779: --Standard checks
780: IF NOT FND_API.Compatible_API_Call (l_api_version
781: ,p_api_version
782: ,l_api_name
783: ,g_pkg_name)
784: THEN

Line 785: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

781: ,p_api_version
782: ,l_api_name
783: ,g_pkg_name)
784: THEN
785: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
786: END IF;
787:
788: -- Initialize message list if p_init_msg_list is set to TRUE
789: IF FND_API.To_Boolean(p_init_msg_list) THEN

Line 789: IF FND_API.To_Boolean(p_init_msg_list) THEN

785: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
786: END IF;
787:
788: -- Initialize message list if p_init_msg_list is set to TRUE
789: IF FND_API.To_Boolean(p_init_msg_list) THEN
790: FND_MSG_PUB.Initialize;
791: END IF;
792:
793: SELECT

Line 813: x_ok_to_delete := FND_API.G_FALSE;

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

Line 818: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 843: x_ok_to_delete := FND_API.G_FALSE;

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

Line 848: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 868: x_ok_to_delete := FND_API.G_FALSE;

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

Line 873: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 893: IF l_style_exists = FND_API.G_TRUE THEN

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

Line 894: x_ok_to_delete := FND_API.G_FALSE;

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

Line 899: x_return_status := FND_API.G_RET_STS_ERROR;

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;
902:
903:

Line 905: p_encoded => FND_API.G_FALSE,

901: END IF;
902:
903:
904: FND_MSG_PUB.Count_And_Get(
905: p_encoded => FND_API.G_FALSE,
906: p_count => x_msg_count,
907: p_data => x_msg_data
908: );
909:

Line 911: x_return_status := FND_API.G_RET_STS_SUCCESS;

907: p_data => x_msg_data
908: );
909:
910: IF (l_message IS NULL) THEN
911: x_return_status := FND_API.G_RET_STS_SUCCESS;
912: x_ok_to_delete := FND_API.G_TRUE;
913: END IF;
914: EXCEPTION
915: WHEN OTHERS THEN

Line 912: x_ok_to_delete := FND_API.G_TRUE;

908: );
909:
910: IF (l_message IS NULL) THEN
911: x_return_status := FND_API.G_RET_STS_SUCCESS;
912: x_ok_to_delete := FND_API.G_TRUE;
913: END IF;
914: EXCEPTION
915: WHEN OTHERS THEN
916: x_ok_to_delete := FND_API.G_FALSE;

Line 916: x_ok_to_delete := FND_API.G_FALSE;

912: x_ok_to_delete := FND_API.G_TRUE;
913: 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);

Line 917: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

913: 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);