APPS.FLM_FILTER_CRITERIA_PROCESS dependencies on FND_API

Line 65: IF p_init_msg_list IS NOT NULL AND FND_API.TO_BOOLEAN(p_init_msg_list)

61: ORDER BY CRITERIA_NUM, CRITERIA_OPERATION;
62:
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:

Line 70: x_return_status := FND_API.G_RET_STS_SUCCESS;

66: THEN
67: FND_MSG_PUB.initialize;
68: END IF;
69:
70: x_return_status := FND_API.G_RET_STS_SUCCESS;
71:
72: l_debug_line := 10;
73: FOR criteria_list_rec IN criteria_list(p_criteria_group_id) LOOP
74:

Line 100: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

96: ELSE
97: l_filter := l_filter || ' = ';
98: END IF;
99: ELSE
100: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
101: return;
102: END IF;
103: ELSE
104: /*Connecting within an operation*/

Line 108: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

104: /*Connecting within an operation*/
105: IF criteria_list_rec.criteria_operation = FLM_CONSTANTS.OP_LESS_THAN_EQ THEN
106: l_filter := l_filter || ' AND ';
107: ELSE
108: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
109: return;
110: END IF;
111: END IF;
112:

Line 132: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

128: FLM_Util.add_bind(':filter_'|| l_counter,
129: to_char(criteria_list_rec.criteria_value_date, 'DD-MON-RR HH24:MI:SS'));
130:
131: ELSE
132: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
133: return;
134: END IF;
135:
136: l_debug_line := 40;

Line 147: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

143: l_debug_line := 50;
144:
145: EXCEPTION
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||')');