DBA Data[Home] [Help]

APPS.HZ_EXTRACT_BO_UTIL_PVT dependencies on FND_MESSAGE

Line 42: FND_MESSAGE.SET_NAME('AR', 'HZ_API_INVALID_EVENT_ID');

38: if NVL(l_valid_flag, 'N') <> 'Y'
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

Line 47: FND_MESSAGE.SET_NAME('AR', 'HZ_API_INVALID_EVENT_OBJ_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');
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;

Line 242: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');

238: END IF;
239: WHEN OTHERS THEN
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,

Line 243: fnd_message.set_token('ERROR' ,SQLERRM);

239: WHEN OTHERS THEN
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,

Line 432: FND_MESSAGE.SET_NAME('AR', 'HZ_API_INVALID_TCA_ID');

428: OPEN is_cp_valid(l_owner_table_id, p_obj_type);
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;

Line 444: FND_MESSAGE.SET_NAME('AR','HZ_API_INVALID_TCA_ID');

440: -- if px_id pass in
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

Line 452: FND_MESSAGE.SET_NAME('AR','HZ_API_INVALID_SSM_ID');

448: ELSE
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

Line 459: FND_MESSAGE.SET_NAME('AR','HZ_API_INVALID_TCA_SSM_ID');

455: -- if px_os/px_osr is valid
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;

Line 476: FND_MESSAGE.SET_NAME('AR','HZ_API_INVALID_SSM_ID');

472: -- else, get owner_table_id and assign it to px_id
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;

Line 524: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');

520: END IF;
521: WHEN OTHERS THEN
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,

Line 525: fnd_message.set_token('ERROR' ,SQLERRM);

521: WHEN OTHERS THEN
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,