27: raise FND_API.G_EXC_UNEXPECTED_ERROR;
28: end if;
29:
30: if FND_API.to_Boolean(p_init_msg_list) then
31: FND_MSG_PUB.initialize;
32: end if;
33: -- -- -- -- begin build_text_query -- -- -- -- --
34: CS_KNOWLEDGE_GRP.Construct_Text_Query
35: ( p_api_version =>1.0,
47: EXCEPTION
48: WHEN FND_API.G_EXC_ERROR THEN
49: ROLLBACK TO Const_Text_Qry_PUB;
50: x_return_status := FND_API.G_RET_STS_ERROR ;
51: FND_MSG_PUB.Count_And_Get(
52: p_count => x_msg_count,
53: p_data => x_msg_data );
54: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
55: ROLLBACK TO Const_Text_Qry_PUB;
53: p_data => x_msg_data );
54: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
55: ROLLBACK TO Const_Text_Qry_PUB;
56: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
57: FND_MSG_PUB.Count_And_Get(
58: p_count => x_msg_count,
59: p_data => x_msg_data);
60: WHEN OTHERS THEN
61: ROLLBACK TO Const_Text_Qry_PUB;
59: p_data => x_msg_data);
60: WHEN OTHERS THEN
61: ROLLBACK TO Const_Text_Qry_PUB;
62: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
63: IF FND_MSG_PUB.Check_Msg_Level
64: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
65: FND_MSG_PUB.Add_Exc_Msg(
66: G_PKG_NAME,
67: l_api_name);
60: WHEN OTHERS THEN
61: ROLLBACK TO Const_Text_Qry_PUB;
62: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
63: IF FND_MSG_PUB.Check_Msg_Level
64: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
65: FND_MSG_PUB.Add_Exc_Msg(
66: G_PKG_NAME,
67: l_api_name);
68: END IF;
61: ROLLBACK TO Const_Text_Qry_PUB;
62: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
63: IF FND_MSG_PUB.Check_Msg_Level
64: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
65: FND_MSG_PUB.Add_Exc_Msg(
66: G_PKG_NAME,
67: l_api_name);
68: END IF;
69: FND_MSG_PUB.Count_And_Get(
65: FND_MSG_PUB.Add_Exc_Msg(
66: G_PKG_NAME,
67: l_api_name);
68: END IF;
69: FND_MSG_PUB.Count_And_Get(
70: p_count => x_msg_count,
71: p_data => x_msg_data);
72: end Construct_Text_Query;
73:
235: EXCEPTION
236: WHEN FND_API.G_EXC_ERROR THEN
237: ROLLBACK TO Create_Set_And_Elements_PUB;
238: x_return_status := FND_API.G_RET_STS_ERROR ;
239: FND_MSG_PUB.Count_And_Get(
240: p_encoded => FND_API.G_FALSE,
241: p_count => x_msg_count,
242: p_data => x_msg_data );
243: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
242: p_data => x_msg_data );
243: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
244: ROLLBACK TO Create_Set_And_Elements_PUB;
245: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
246: FND_MSG_PUB.Count_And_Get(
247: p_count => x_msg_count,
248: p_data => x_msg_data);
249: WHEN OTHERS THEN
250: ROLLBACK TO Create_Set_And_Elements_PUB;
248: p_data => x_msg_data);
249: WHEN OTHERS THEN
250: ROLLBACK TO Create_Set_And_Elements_PUB;
251: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
252: IF FND_MSG_PUB.Check_Msg_Level
253: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
254: FND_MSG_PUB.Add_Exc_Msg(
255: G_PKG_NAME,
256: l_api_name);
249: WHEN OTHERS THEN
250: ROLLBACK TO Create_Set_And_Elements_PUB;
251: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
252: IF FND_MSG_PUB.Check_Msg_Level
253: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
254: FND_MSG_PUB.Add_Exc_Msg(
255: G_PKG_NAME,
256: l_api_name);
257: END IF;
250: ROLLBACK TO Create_Set_And_Elements_PUB;
251: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
252: IF FND_MSG_PUB.Check_Msg_Level
253: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
254: FND_MSG_PUB.Add_Exc_Msg(
255: G_PKG_NAME,
256: l_api_name);
257: END IF;
258: FND_MSG_PUB.Count_And_Get(
254: FND_MSG_PUB.Add_Exc_Msg(
255: G_PKG_NAME,
256: l_api_name);
257: END IF;
258: FND_MSG_PUB.Count_And_Get(
259: p_count => x_msg_count,
260: p_data => x_msg_data);
261:
262: end Create_Set_And_Elements;