DBA Data[Home] [Help]

APPS.HZ_EXTRACT_BO_UTIL_PVT dependencies on FND_MSG_PUB

Line 43: FND_MSG_PUB.ADD;

39: then
40: if p_party_id is null
41: then
42: FND_MESSAGE.SET_NAME('AR', 'HZ_API_INVALID_EVENT_ID');
43: FND_MSG_PUB.ADD;
44: x_return_status := FND_API.G_RET_STS_ERROR;
45: RAISE FND_API.G_EXC_ERROR;
46: else
47: FND_MESSAGE.SET_NAME('AR', 'HZ_API_INVALID_EVENT_OBJ_ID');

Line 48: FND_MSG_PUB.ADD;

44: x_return_status := FND_API.G_RET_STS_ERROR;
45: RAISE FND_API.G_EXC_ERROR;
46: else
47: FND_MESSAGE.SET_NAME('AR', 'HZ_API_INVALID_EVENT_OBJ_ID');
48: FND_MSG_PUB.ADD;
49: x_return_status := FND_API.G_RET_STS_ERROR;
50: RAISE FND_API.G_EXC_ERROR;
51: end if;
52: end if;

Line 167: FND_MSG_PUB.initialize;

163: x_return_status := FND_API.G_RET_STS_SUCCESS;
164:
165: -- Initialize message list if p_init_msg_list is set to TRUE
166: IF FND_API.to_Boolean(p_init_msg_list) THEN
167: FND_MSG_PUB.initialize;
168: END IF;
169:
170:
171: -- Debug info.

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

200:
201: WHEN fnd_api.g_exc_error THEN
202: x_return_status := fnd_api.g_ret_sts_error;
203:
204: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
205: p_count => x_msg_count,
206: p_data => x_msg_data);
207:
208: -- Debug info.

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

219: END IF;
220: WHEN fnd_api.g_exc_unexpected_error THEN
221: x_return_status := fnd_api.g_ret_sts_unexp_error;
222:
223: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
224: p_count => x_msg_count,
225: p_data => x_msg_data);
226:
227: -- Debug info.

Line 244: fnd_msg_pub.add;

240: x_return_status := fnd_api.g_ret_sts_unexp_error;
241:
242: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
243: fnd_message.set_token('ERROR' ,SQLERRM);
244: fnd_msg_pub.add;
245:
246: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
247: p_count => x_msg_count,
248: p_data => x_msg_data);

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

242: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
243: fnd_message.set_token('ERROR' ,SQLERRM);
244: fnd_msg_pub.add;
245:
246: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
247: p_count => x_msg_count,
248: p_data => x_msg_data);
249:
250: -- Debug info.

Line 433: FND_MSG_PUB.ADD;

429: FETCH is_cp_valid INTO l_dummy;
430: CLOSE is_cp_valid;
431: IF(l_dummy IS NULL) THEN
432: FND_MESSAGE.SET_NAME('AR', 'HZ_API_INVALID_TCA_ID');
433: FND_MSG_PUB.ADD;
434: RAISE fnd_api.g_exc_error;
435: END IF;
436: END IF;
437: END IF;

Line 445: FND_MSG_PUB.ADD();

441: IF(px_id IS NOT NULL) THEN
442: -- if px_id is invalid, raise error
443: IF(l_valid_id IS NULL) THEN
444: FND_MESSAGE.SET_NAME('AR','HZ_API_INVALID_TCA_ID');
445: FND_MSG_PUB.ADD();
446: RAISE fnd_api.g_exc_error;
447: -- if px_id is valid
448: ELSE
449: -- check if px_os/px_osr is passed

Line 453: FND_MSG_PUB.ADD();

449: -- check if px_os/px_osr is passed
450: IF(l_ss_flag = 'Y') THEN
451: IF(l_count = 0) THEN
452: FND_MESSAGE.SET_NAME('AR','HZ_API_INVALID_SSM_ID');
453: FND_MSG_PUB.ADD();
454: RAISE fnd_api.g_exc_error;
455: -- if px_os/px_osr is valid
456: ELSE
457: -- if px_os/px_osr is valid, but not same as px_id

Line 460: FND_MSG_PUB.ADD();

456: ELSE
457: -- if px_os/px_osr is valid, but not same as px_id
458: IF(l_owner_table_id <> px_id) OR (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
459: FND_MESSAGE.SET_NAME('AR','HZ_API_INVALID_TCA_SSM_ID');
460: FND_MSG_PUB.ADD();
461: RAISE fnd_api.g_exc_error;
462: END IF;
463: END IF;
464: -- if px_os/px_osr is valid and return value is same as px_id

Line 477: FND_MSG_PUB.ADD();

473: IF(l_ss_flag = 'Y') AND (l_count = 1) AND (x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
474: px_id := l_owner_table_id;
475: ELSE
476: FND_MESSAGE.SET_NAME('AR','HZ_API_INVALID_SSM_ID');
477: FND_MSG_PUB.ADD();
478: RAISE fnd_api.g_exc_error;
479: END IF;
480: END IF;
481:

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

482: EXCEPTION
483: WHEN fnd_api.g_exc_error THEN
484: x_return_status := fnd_api.g_ret_sts_error;
485:
486: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
487: p_count => x_msg_count,
488: p_data => x_msg_data);
489:
490: -- Debug info.

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

501: END IF;
502: WHEN fnd_api.g_exc_unexpected_error THEN
503: x_return_status := fnd_api.g_ret_sts_unexp_error;
504:
505: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
506: p_count => x_msg_count,
507: p_data => x_msg_data);
508:
509: -- Debug info.

Line 526: fnd_msg_pub.add;

522: x_return_status := fnd_api.g_ret_sts_unexp_error;
523:
524: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
525: fnd_message.set_token('ERROR' ,SQLERRM);
526: fnd_msg_pub.add;
527:
528: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
529: p_count => x_msg_count,
530: p_data => x_msg_data);

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

524: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
525: fnd_message.set_token('ERROR' ,SQLERRM);
526: fnd_msg_pub.add;
527:
528: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
529: p_count => x_msg_count,
530: p_data => x_msg_data);
531:
532: -- Debug info.