DBA Data[Home] [Help]

APPS.HZ_STYLE_FMT_LOCALE_V2PUB dependencies on FND_MSG_PUB

Line 214: FND_MSG_PUB.ADD;

210: p_object_version_number = l_object_version_number ) )
211: THEN
212: FND_MESSAGE.SET_NAME('AR', 'HZ_API_RECORD_CHANGED');
213: FND_MESSAGE.SET_TOKEN('TABLE', 'hz_style_fmt_locales');
214: FND_MSG_PUB.ADD;
215: RAISE FND_API.G_EXC_ERROR;
216: END IF;
217:
218: p_object_version_number := nvl(l_object_version_number, 1) + 1;

Line 224: FND_MSG_PUB.ADD;

220: EXCEPTION WHEN NO_DATA_FOUND THEN
221: FND_MESSAGE.SET_NAME('AR', 'HZ_API_NO_RECORD');
222: FND_MESSAGE.SET_TOKEN('RECORD', 'style format locale');
223: FND_MESSAGE.SET_TOKEN('VALUE', NVL(( p_style_fmt_locale_rec.style_fmt_locale_id), 'null'));
224: FND_MSG_PUB.ADD;
225: RAISE FND_API.G_EXC_ERROR;
226: END;
227:
228: -- validate style format locale record

Line 337: FND_MSG_PUB.initialize;

333: END IF;
334:
335: -- initialize message list if p_init_msg_list is set to TRUE.
336: IF FND_API.to_Boolean(p_init_msg_list) THEN
337: FND_MSG_PUB.initialize;
338: END IF;
339:
340: -- initialize API return status to success.
341: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 351: FND_MSG_PUB.Count_And_Get(

347:
348: p_style_fmt_locale_id := l_style_fmt_locale_rec.style_fmt_locale_id;
349:
350: -- standard call to get message count and if count is 1, get message info.
351: FND_MSG_PUB.Count_And_Get(
352: p_encoded => FND_API.G_FALSE,
353: p_count => x_msg_count,
354: p_data => x_msg_data);
355: -- Debug info.

Line 375: FND_MSG_PUB.Count_And_Get(

371: EXCEPTION
372: WHEN FND_API.G_EXC_ERROR THEN
373: ROLLBACK TO create_style_fmt_locale;
374: x_return_status := FND_API.G_RET_STS_ERROR;
375: FND_MSG_PUB.Count_And_Get(
376: p_encoded => FND_API.G_FALSE,
377: p_count => x_msg_count,
378: p_data => x_msg_data);
379:

Line 399: FND_MSG_PUB.Count_And_Get(

395:
396: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
397: ROLLBACK TO create_style_fmt_locale;
398: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
399: FND_MSG_PUB.Count_And_Get(
400: p_encoded => FND_API.G_FALSE,
401: p_count => x_msg_count,
402: p_data => x_msg_data);
403:

Line 426: FND_MSG_PUB.ADD;

422: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
423:
424: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
425: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
426: FND_MSG_PUB.ADD;
427:
428: FND_MSG_PUB.Count_And_Get(
429: p_encoded => FND_API.G_FALSE,
430: p_count => x_msg_count,

Line 428: FND_MSG_PUB.Count_And_Get(

424: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
425: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
426: FND_MSG_PUB.ADD;
427:
428: FND_MSG_PUB.Count_And_Get(
429: p_encoded => FND_API.G_FALSE,
430: p_count => x_msg_count,
431: p_data => x_msg_data);
432:

Line 514: FND_MSG_PUB.initialize;

510: END IF;
511:
512: -- initialize message list if p_init_msg_list is set to TRUE.
513: IF FND_API.to_Boolean(p_init_msg_list) THEN
514: FND_MSG_PUB.initialize;
515: END IF;
516:
517: -- initialize API return status to success.
518: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 527: FND_MSG_PUB.Count_And_Get(

523: p_object_version_number,
524: x_return_status);
525:
526: -- standard call to get message count and if count is 1, get message info.
527: FND_MSG_PUB.Count_And_Get(
528: p_encoded => FND_API.G_FALSE,
529: p_count => x_msg_count,
530: p_data => x_msg_data);
531:

Line 552: FND_MSG_PUB.Count_And_Get(

548: EXCEPTION
549: WHEN FND_API.G_EXC_ERROR THEN
550: ROLLBACK TO update_style_fmt_locale;
551: x_return_status := FND_API.G_RET_STS_ERROR;
552: FND_MSG_PUB.Count_And_Get(
553: p_encoded => FND_API.G_FALSE,
554: p_count => x_msg_count,
555: p_data => x_msg_data);
556:

Line 576: FND_MSG_PUB.Count_And_Get(

572:
573: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
574: ROLLBACK TO update_style_fmt_locale;
575: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
576: FND_MSG_PUB.Count_And_Get(
577: p_encoded => FND_API.G_FALSE,
578: p_count => x_msg_count,
579: p_data => x_msg_data);
580:

Line 603: FND_MSG_PUB.ADD;

599: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
600:
601: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
602: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
603: FND_MSG_PUB.ADD;
604:
605: FND_MSG_PUB.Count_And_Get(
606: p_encoded => FND_API.G_FALSE,
607: p_count => x_msg_count,

Line 605: FND_MSG_PUB.Count_And_Get(

601: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
602: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
603: FND_MSG_PUB.ADD;
604:
605: FND_MSG_PUB.Count_And_Get(
606: p_encoded => FND_API.G_FALSE,
607: p_count => x_msg_count,
608: p_data => x_msg_data);
609:

Line 683: fnd_msg_pub.initialize;

679: END IF;
680:
681: -- Initialize message list if p_init_msg_list is set to TRUE.
682: IF fnd_api.to_boolean(p_init_msg_list) THEN
683: fnd_msg_pub.initialize;
684: END IF;
685:
686: -- Initialize API return status to success.
687: x_return_status := fnd_api.g_ret_sts_success;

Line 694: fnd_msg_pub.add;

690: IF p_style_fmt_locale_id IS NULL OR
691: p_style_fmt_locale_id = fnd_api.g_miss_num THEN
692: fnd_message.set_name('AR', 'HZ_API_MISSING_COLUMN');
693: fnd_message.set_token('COLUMN', 'style_fmt_locale_id');
694: fnd_msg_pub.add;
695: RAISE fnd_api.g_exc_error;
696: END IF;
697:
698: x_style_fmt_locale_rec.style_fmt_locale_id := p_style_fmt_locale_id;

Line 724: fnd_msg_pub.count_and_get(

720: p_msg_level=>fnd_log.level_procedure);
721: END IF;
722:
723: --Standard call to get message count and if count is 1, get message info.
724: fnd_msg_pub.count_and_get(
725: p_encoded => fnd_api.g_false,
726: p_count => x_msg_count,
727: p_data => x_msg_data
728: );

Line 749: fnd_msg_pub.count_and_get(

745: --disable_debug;
746: EXCEPTION
747: WHEN fnd_api.g_exc_error THEN
748: x_return_status := fnd_api.g_ret_sts_error;
749: fnd_msg_pub.count_and_get(
750: p_encoded => fnd_api.g_false,
751: p_count => x_msg_count,
752: p_data => x_msg_data
753: );

Line 774: fnd_msg_pub.count_and_get(

770:
771: WHEN fnd_api.g_exc_unexpected_error THEN
772: x_return_status := fnd_api.g_ret_sts_unexp_error;
773:
774: fnd_msg_pub.count_and_get(
775: p_encoded => fnd_api.g_false,
776: p_count => x_msg_count,
777: p_data => x_msg_data
778: );

Line 801: fnd_msg_pub.add;

797: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
798:
799: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
800: fnd_message.set_token('ERROR' ,SQLERRM);
801: fnd_msg_pub.add;
802:
803: fnd_msg_pub.count_and_get(
804: p_encoded => fnd_api.g_false,
805: p_count => x_msg_count,

Line 803: fnd_msg_pub.count_and_get(

799: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
800: fnd_message.set_token('ERROR' ,SQLERRM);
801: fnd_msg_pub.add;
802:
803: fnd_msg_pub.count_and_get(
804: p_encoded => fnd_api.g_false,
805: p_count => x_msg_count,
806: p_data => x_msg_data
807: );