46: l_msg_data := '';
47:
48: FOR l_cur IN 1..l_msg_count LOOP
49:
50: l_msg_data :=l_msg_data||' '|| FND_MSg_PUB.GET(l_cur, FND_API.g_FALSE);
51:
52: END LOOP;
53:
54: ELSE
118: x_return_status => l_return_status,
119: x_msg_count => l_msg_count,
120: x_msg_data => l_msg_data );
121:
122: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
123: raise FND_API.G_EXC_ERROR;
124: END IF;
125: RETURN l_where_clause;
126: END IF;
119: x_msg_count => l_msg_count,
120: x_msg_data => l_msg_data );
121:
122: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
123: raise FND_API.G_EXC_ERROR;
124: END IF;
125: RETURN l_where_clause;
126: END IF;
127: EXCEPTION
124: END IF;
125: RETURN l_where_clause;
126: END IF;
127: EXCEPTION
128: WHEN FND_API.G_EXC_ERROR THEN
129:
130: l_where_clause := Generate_and_raise(p_object);
131:
132: RETURN '1=2';
130: l_where_clause := Generate_and_raise(p_object);
131:
132: RETURN '1=2';
133:
134: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
135:
136: l_where_clause := Generate_and_raise(p_object);
137:
138: RETURN '1=2';