74:
75: -- Initialize the message table if requested.
76:
77: if p_init_msg_tbl then
78: FND_MSG_PUB.initialize;
79: end if;
80:
81: savepoint Start_download;
82: if (AK_DOWNLOAD_GRP.G_WRITE_HEADER) then
137: end if;
138:
139: p_return_status := FND_API.G_RET_STS_SUCCESS;
140:
141: FND_MSG_PUB.Count_And_Get (
142: p_count => p_msg_count,
143: p_data => p_msg_data);
144:
145: EXCEPTION
144:
145: EXCEPTION
146: WHEN FND_API.G_EXC_ERROR THEN
147: p_return_status := FND_API.G_RET_STS_ERROR;
148: FND_MSG_PUB.Count_And_Get (
149: p_count => p_msg_count,
150: p_data => p_msg_data);
151: WHEN OTHERS THEN
152: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
149: p_count => p_msg_count,
150: p_data => p_msg_data);
151: WHEN OTHERS THEN
152: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
153: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,
154: SUBSTR (SQLERRM, 1, 240) );
155: FND_MSG_PUB.Add;
156: FND_MSG_PUB.Count_And_Get (
157: p_count => p_msg_count,
151: WHEN OTHERS THEN
152: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
153: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,
154: SUBSTR (SQLERRM, 1, 240) );
155: FND_MSG_PUB.Add;
156: FND_MSG_PUB.Count_And_Get (
157: p_count => p_msg_count,
158: p_data => p_msg_data);
159:
152: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
153: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,
154: SUBSTR (SQLERRM, 1, 240) );
155: FND_MSG_PUB.Add;
156: FND_MSG_PUB.Count_And_Get (
157: p_count => p_msg_count,
158: p_data => p_msg_data);
159:
160: end DOWNLOAD_QUERY_OBJECT;
206:
207: -- Initialize the message table if requested.
208:
209: if p_init_msg_tbl then
210: FND_MSG_PUB.initialize;
211: end if;
212:
213: savepoint start_create_query_object;
214:
245: p_return_status := FND_API.G_RET_STS_ERROR;
246: rollback to start_create_query_object;
247: WHEN OTHERS THEN
248: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
249: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,
250: SUBSTR (SQLERRM, 1, 240) );
251: FND_MSG_PUB.Add;
252: rollback to start_create_query_object;
253: end CREATE_QUERY_OBJECT;
247: WHEN OTHERS THEN
248: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
249: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,
250: SUBSTR (SQLERRM, 1, 240) );
251: FND_MSG_PUB.Add;
252: rollback to start_create_query_object;
253: end CREATE_QUERY_OBJECT;
254:
255: --=======================================================
302:
303: -- Initialize the message table if requested.
304:
305: if p_init_msg_tbl then
306: FND_MSG_PUB.initialize;
307: end if;
308:
309: savepoint start_create_query_object_line;
310:
343: p_return_status := FND_API.G_RET_STS_ERROR;
344: rollback to start_create_query_object_line;
345: WHEN OTHERS THEN
346: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
347: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,
348: SUBSTR (SQLERRM, 1, 240) );
349: FND_MSG_PUB.Add;
350: rollback to start_create_query_object_line;
351: end CREATE_QUERY_OBJECT_LINE;
345: WHEN OTHERS THEN
346: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
347: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,
348: SUBSTR (SQLERRM, 1, 240) );
349: FND_MSG_PUB.Add;
350: rollback to start_create_query_object_line;
351: end CREATE_QUERY_OBJECT_LINE;
352:
353: end AK_QUERYOBJ_GRP;