59: l_content_node_type VARCHAR2(30);
60: l_component_style_id NUMBER;
61: BEGIN
62:
63: x_return_status := FND_API.G_RET_STS_SUCCESS;
64:
65: IF (p_association_type_code = 'PRP_COMPONENT_DOCUMENT') THEN
66:
67: -- Check to see if the component is in hidden folder. If it is in hidden folder return the component style name.
111:
112: END IF;
113:
114: EXCEPTION
115: WHEN FND_API.G_EXC_ERROR THEN
116: x_return_status := FND_API.G_RET_STS_ERROR;
117: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count,
118: p_data => x_msg_data);
119: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
112: END IF;
113:
114: EXCEPTION
115: WHEN FND_API.G_EXC_ERROR THEN
116: x_return_status := FND_API.G_RET_STS_ERROR;
117: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count,
118: p_data => x_msg_data);
119: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
120: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
115: WHEN FND_API.G_EXC_ERROR THEN
116: x_return_status := FND_API.G_RET_STS_ERROR;
117: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count,
118: p_data => x_msg_data);
119: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
120: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
121: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count,
122: p_data => x_msg_data);
123:
116: x_return_status := FND_API.G_RET_STS_ERROR;
117: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count,
118: p_data => x_msg_data);
119: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
120: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
121: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count,
122: p_data => x_msg_data);
123:
124: WHEN OTHERS THEN
121: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count,
122: p_data => x_msg_data);
123:
124: WHEN OTHERS THEN
125: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
126: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
127: THEN
128: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
129: END IF;