26: l_folder_description varchar2(32000);
27: l_results_tbl BIS_GNRL_SEARCH_ENGINE_PVT.results_tbl_typ;
28:
29: BEGIN
30: x_return_status := FND_API.G_RET_STS_SUCCESS;
31:
32: -- To make sure the Intermedia query does not break becuase of lack of schema name
33: IF (p_eul IS NOT NULL) THEN
34: v_eul := p_eul ||'.';
139:
140:
141: EXCEPTION
142: WHEN NO_DATA_FOUND THEN
143: x_return_status := FND_API.G_RET_STS_ERROR;
144: WHEN OTHERS THEN
145: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
146: BIS_UTILITIES_PVT.Add_Error_Message
147: ( p_error_table => x_error_Tbl
141: EXCEPTION
142: WHEN NO_DATA_FOUND THEN
143: x_return_status := FND_API.G_RET_STS_ERROR;
144: WHEN OTHERS THEN
145: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
146: BIS_UTILITIES_PVT.Add_Error_Message
147: ( p_error_table => x_error_Tbl
148: , p_error_msg_id => SQLCODE
149: , p_error_description => SQLERRM