63: BEGIN
64: SAVEPOINT flm_get_filter_clause;
65: IF p_init_msg_list IS NOT NULL AND FND_API.TO_BOOLEAN(p_init_msg_list)
66: THEN
67: FND_MSG_PUB.initialize;
68: END IF;
69:
70: x_return_status := FND_API.G_RET_STS_SUCCESS;
71:
146: WHEN OTHERS THEN
147: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
148: ROLLBACK TO flm_get_filter_clause;
149:
150: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
151: FND_MSG_PUB.Add_Exc_Msg ('flm_filter_criteria_process' ,'get_filter_clause('||l_debug_line||')');
152: END IF;
153:
154: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count ,p_data => x_msg_data);
147: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
148: ROLLBACK TO flm_get_filter_clause;
149:
150: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
151: FND_MSG_PUB.Add_Exc_Msg ('flm_filter_criteria_process' ,'get_filter_clause('||l_debug_line||')');
152: END IF;
153:
154: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count ,p_data => x_msg_data);
155:
150: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
151: FND_MSG_PUB.Add_Exc_Msg ('flm_filter_criteria_process' ,'get_filter_clause('||l_debug_line||')');
152: END IF;
153:
154: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count ,p_data => x_msg_data);
155:
156: END get_filter_clause;
157:
158: