DBA Data[Home] [Help]

APPS.HZ_PARTY_SEARCH_BO_PUB dependencies on FND_API

Line 5: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,

1: PACKAGE BODY HZ_PARTY_SEARCH_BO_PUB AS
2: /*$Header: ARHDBOSB.pls 120.2 2007/02/23 11:37:58 rarajend ship $ */
3:
4: PROCEDURE find_party_bos (
5: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
6: p_within_os IN VARCHAR2,
7: p_rule_id IN NUMBER,
8: p_search_attr_obj IN HZ_SEARCH_ATTR_OBJ_TBL,
9: p_party_status IN VARCHAR2,

Line 172: x_return_status := FND_API.G_RET_STS_SUCCESS;

168:
169: BEGIN
170:
171: -- initialize API return status to success.
172: x_return_status := FND_API.G_RET_STS_SUCCESS;
173:
174: -- Initialize message list if p_init_msg_list is set to TRUE
175: IF FND_API.to_Boolean(p_init_msg_list) THEN
176: FND_MSG_PUB.initialize;

Line 175: IF FND_API.to_Boolean(p_init_msg_list) THEN

171: -- initialize API return status to success.
172: x_return_status := FND_API.G_RET_STS_SUCCESS;
173:
174: -- Initialize message list if p_init_msg_list is set to TRUE
175: IF FND_API.to_Boolean(p_init_msg_list) THEN
176: FND_MSG_PUB.initialize;
177: END IF;
178:
179: -- Check if the 'p_within_os' parameter passed has a value

Line 280: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

276: x_return_status => l_return_status,
277: x_msg_count => l_msg_count,
278: x_msg_data => l_msg_data
279: );
280: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
281:
282: RAISE FND_API.G_EXC_ERROR;
283: -- IF this API returns successfully then populate the results
284: -- into the output object table.

Line 282: RAISE FND_API.G_EXC_ERROR;

278: x_msg_data => l_msg_data
279: );
280: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
281:
282: RAISE FND_API.G_EXC_ERROR;
283: -- IF this API returns successfully then populate the results
284: -- into the output object table.
285: ELSIF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
286:

Line 285: ELSIF l_return_status = FND_API.G_RET_STS_SUCCESS THEN

281:
282: RAISE FND_API.G_EXC_ERROR;
283: -- IF this API returns successfully then populate the results
284: -- into the output object table.
285: ELSIF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
286:
287: -- check if p_within_os parameter has a value
288: IF p_within_os IS NULL THEN
289:

Line 305: WHEN fnd_api.g_exc_error THEN

301:
302: END IF;
303: END IF;
304: EXCEPTION
305: WHEN fnd_api.g_exc_error THEN
306: x_return_status := fnd_api.g_ret_sts_error;
307: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
308: p_count => x_msg_count,
309: p_data => x_msg_data);

Line 306: x_return_status := fnd_api.g_ret_sts_error;

302: END IF;
303: END IF;
304: EXCEPTION
305: WHEN fnd_api.g_exc_error THEN
306: x_return_status := fnd_api.g_ret_sts_error;
307: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
308: p_count => x_msg_count,
309: p_data => x_msg_data);
310: WHEN fnd_api.g_exc_unexpected_error THEN

Line 307: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

303: END IF;
304: EXCEPTION
305: WHEN fnd_api.g_exc_error THEN
306: x_return_status := fnd_api.g_ret_sts_error;
307: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
308: p_count => x_msg_count,
309: p_data => x_msg_data);
310: WHEN fnd_api.g_exc_unexpected_error THEN
311: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 310: WHEN fnd_api.g_exc_unexpected_error THEN

306: x_return_status := fnd_api.g_ret_sts_error;
307: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
308: p_count => x_msg_count,
309: p_data => x_msg_data);
310: WHEN fnd_api.g_exc_unexpected_error THEN
311: x_return_status := fnd_api.g_ret_sts_unexp_error;
312: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
313: p_count => x_msg_count,
314: p_data => x_msg_data);

Line 311: x_return_status := fnd_api.g_ret_sts_unexp_error;

307: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
308: p_count => x_msg_count,
309: p_data => x_msg_data);
310: WHEN fnd_api.g_exc_unexpected_error THEN
311: x_return_status := fnd_api.g_ret_sts_unexp_error;
312: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
313: p_count => x_msg_count,
314: p_data => x_msg_data);
315: WHEN OTHERS THEN

Line 312: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

308: p_count => x_msg_count,
309: p_data => x_msg_data);
310: WHEN fnd_api.g_exc_unexpected_error THEN
311: x_return_status := fnd_api.g_ret_sts_unexp_error;
312: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
313: p_count => x_msg_count,
314: p_data => x_msg_data);
315: WHEN OTHERS THEN
316: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 316: x_return_status := fnd_api.g_ret_sts_unexp_error;

312: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
313: p_count => x_msg_count,
314: p_data => x_msg_data);
315: WHEN OTHERS THEN
316: x_return_status := fnd_api.g_ret_sts_unexp_error;
317: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
318: fnd_message.set_token('ERROR' ,SQLERRM);
319: fnd_msg_pub.add;
320: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

Line 320: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

316: x_return_status := fnd_api.g_ret_sts_unexp_error;
317: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
318: fnd_message.set_token('ERROR' ,SQLERRM);
319: fnd_msg_pub.add;
320: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
321: p_count => x_msg_count,
322: p_data => x_msg_data);
323:
324: END find_party_bos;