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 171: FND_MSG_PUB.initialize;

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

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

204:
205: WHEN fnd_api.g_exc_error THEN
206: x_return_status := fnd_api.g_ret_sts_error;
207:
208: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
209: p_count => x_msg_count,
210: p_data => x_msg_data);
211:
212: -- Debug info.

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

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

Line 248: fnd_msg_pub.add;

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,
252: p_data => x_msg_data);

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

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,
252: p_data => x_msg_data);
253:
254: -- Debug info.

Line 437: FND_MSG_PUB.ADD;

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;
441: END IF;

Line 449: FND_MSG_PUB.ADD();

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
453: -- check if px_os/px_osr is passed

Line 457: FND_MSG_PUB.ADD();

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
461: -- if px_os/px_osr is valid, but not same as px_id

Line 464: FND_MSG_PUB.ADD();

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;
468: -- if px_os/px_osr is valid and return value is same as px_id

Line 481: FND_MSG_PUB.ADD();

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;
485:

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

486: EXCEPTION
487: WHEN fnd_api.g_exc_error THEN
488: x_return_status := fnd_api.g_ret_sts_error;
489:
490: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
491: p_count => x_msg_count,
492: p_data => x_msg_data);
493:
494: -- Debug info.

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

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

Line 530: fnd_msg_pub.add;

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,
534: p_data => x_msg_data);

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

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,
534: p_data => x_msg_data);
535:
536: -- Debug info.