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 246: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');

242: END IF;
243: WHEN OTHERS THEN
244: x_return_status := fnd_api.g_ret_sts_unexp_error;
245:
246: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
247: fnd_message.set_token('ERROR' ,SQLERRM);
248: fnd_msg_pub.add;
249:
250: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

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

243: WHEN OTHERS THEN
244: x_return_status := fnd_api.g_ret_sts_unexp_error;
245:
246: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
247: fnd_message.set_token('ERROR' ,SQLERRM);
248: fnd_msg_pub.add;
249:
250: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
251: p_count => x_msg_count,

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

432: OPEN is_cp_valid(l_owner_table_id, p_obj_type);
433: FETCH is_cp_valid INTO l_dummy;
434: CLOSE is_cp_valid;
435: IF(l_dummy IS NULL) THEN
436: FND_MESSAGE.SET_NAME('AR', 'HZ_API_INVALID_TCA_ID');
437: FND_MSG_PUB.ADD;
438: RAISE fnd_api.g_exc_error;
439: END IF;
440: END IF;

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

444: -- if px_id pass in
445: IF(px_id IS NOT NULL) THEN
446: -- if px_id is invalid, raise error
447: IF(l_valid_id IS NULL) THEN
448: FND_MESSAGE.SET_NAME('AR','HZ_API_INVALID_TCA_ID');
449: FND_MSG_PUB.ADD();
450: RAISE fnd_api.g_exc_error;
451: -- if px_id is valid
452: ELSE

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

452: ELSE
453: -- check if px_os/px_osr is passed
454: IF(l_ss_flag = 'Y') THEN
455: IF(l_count = 0) THEN
456: FND_MESSAGE.SET_NAME('AR','HZ_API_INVALID_SSM_ID');
457: FND_MSG_PUB.ADD();
458: RAISE fnd_api.g_exc_error;
459: -- if px_os/px_osr is valid
460: ELSE

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

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

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

476: -- else, get owner_table_id and assign it to px_id
477: IF(l_ss_flag = 'Y') AND (l_count = 1) AND (x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
478: px_id := l_owner_table_id;
479: ELSE
480: FND_MESSAGE.SET_NAME('AR','HZ_API_INVALID_SSM_ID');
481: FND_MSG_PUB.ADD();
482: RAISE fnd_api.g_exc_error;
483: END IF;
484: END IF;

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

524: END IF;
525: WHEN OTHERS THEN
526: x_return_status := fnd_api.g_ret_sts_unexp_error;
527:
528: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
529: fnd_message.set_token('ERROR' ,SQLERRM);
530: fnd_msg_pub.add;
531:
532: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

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

525: WHEN OTHERS THEN
526: x_return_status := fnd_api.g_ret_sts_unexp_error;
527:
528: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
529: fnd_message.set_token('ERROR' ,SQLERRM);
530: fnd_msg_pub.add;
531:
532: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
533: p_count => x_msg_count,