227: p_object_version_number = l_object_version_number ) )
228: THEN
229: FND_MESSAGE.SET_NAME('AR', 'HZ_API_RECORD_CHANGED');
230: FND_MESSAGE.SET_TOKEN('TABLE', 'hz_style_formats');
231: FND_MSG_PUB.ADD;
232: RAISE FND_API.G_EXC_ERROR;
233: END IF;
234:
235: p_object_version_number := nvl(l_object_version_number, 1) + 1;
237: EXCEPTION WHEN NO_DATA_FOUND THEN
238: FND_MESSAGE.SET_NAME('AR', 'HZ_API_NO_RECORD');
239: FND_MESSAGE.SET_TOKEN('RECORD', 'style format');
240: FND_MESSAGE.SET_TOKEN('VALUE', NVL(( p_style_format_rec.style_format_code), 'null'));
241: FND_MSG_PUB.ADD;
242: RAISE FND_API.G_EXC_ERROR;
243: END;
244:
245: -- validate style format record
377: END IF;
378:
379: -- initialize message list if p_init_msg_list is set to TRUE.
380: IF FND_API.to_Boolean(p_init_msg_list) THEN
381: FND_MSG_PUB.initialize;
382: END IF;
383:
384: -- initialize API return status to success.
385: x_return_status := FND_API.G_RET_STS_SUCCESS;
389: l_style_format_rec,
390: x_return_status);
391:
392: -- standard call to get message count and if count is 1, get message info.
393: FND_MSG_PUB.Count_And_Get(
394: p_encoded => FND_API.G_FALSE,
395: p_count => x_msg_count,
396: p_data => x_msg_data);
397: -- Debug info.
413: EXCEPTION
414: WHEN FND_API.G_EXC_ERROR THEN
415: ROLLBACK TO create_style_format;
416: x_return_status := FND_API.G_RET_STS_ERROR;
417: FND_MSG_PUB.Count_And_Get(
418: p_encoded => FND_API.G_FALSE,
419: p_count => x_msg_count,
420: p_data => x_msg_data);
421:
437:
438: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
439: ROLLBACK TO create_style_format;
440: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
441: FND_MSG_PUB.Count_And_Get(
442: p_encoded => FND_API.G_FALSE,
443: p_count => x_msg_count,
444: p_data => x_msg_data);
445:
464: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
465:
466: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
467: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
468: FND_MSG_PUB.ADD;
469:
470: FND_MSG_PUB.Count_And_Get(
471: p_encoded => FND_API.G_FALSE,
472: p_count => x_msg_count,
466: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
467: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
468: FND_MSG_PUB.ADD;
469:
470: FND_MSG_PUB.Count_And_Get(
471: p_encoded => FND_API.G_FALSE,
472: p_count => x_msg_count,
473: p_data => x_msg_data);
474:
551: END IF;
552:
553: -- initialize message list if p_init_msg_list is set to TRUE.
554: IF FND_API.to_Boolean(p_init_msg_list) THEN
555: FND_MSG_PUB.initialize;
556: END IF;
557:
558: -- initialize API return status to success.
559: x_return_status := FND_API.G_RET_STS_SUCCESS;
564: p_object_version_number,
565: x_return_status);
566:
567: -- standard call to get message count and if count is 1, get message info.
568: FND_MSG_PUB.Count_And_Get(
569: p_encoded => FND_API.G_FALSE,
570: p_count => x_msg_count,
571: p_data => x_msg_data);
572:
589: EXCEPTION
590: WHEN FND_API.G_EXC_ERROR THEN
591: ROLLBACK TO update_style_format;
592: x_return_status := FND_API.G_RET_STS_ERROR;
593: FND_MSG_PUB.Count_And_Get(
594: p_encoded => FND_API.G_FALSE,
595: p_count => x_msg_count,
596: p_data => x_msg_data);
597:
613:
614: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
615: ROLLBACK TO update_style_format;
616: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
617: FND_MSG_PUB.Count_And_Get(
618: p_encoded => FND_API.G_FALSE,
619: p_count => x_msg_count,
620: p_data => x_msg_data);
621:
640: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
641:
642: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
643: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
644: FND_MSG_PUB.ADD;
645:
646: FND_MSG_PUB.Count_And_Get(
647: p_encoded => FND_API.G_FALSE,
648: p_count => x_msg_count,
642: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
643: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
644: FND_MSG_PUB.ADD;
645:
646: FND_MSG_PUB.Count_And_Get(
647: p_encoded => FND_API.G_FALSE,
648: p_count => x_msg_count,
649: p_data => x_msg_data);
650:
720: END IF;
721:
722: -- Initialize message list if p_init_msg_list is set to TRUE.
723: IF fnd_api.to_boolean(p_init_msg_list) THEN
724: fnd_msg_pub.initialize;
725: END IF;
726:
727: -- Initialize API return status to success.
728: x_return_status := fnd_api.g_ret_sts_success;
731: IF p_style_format_code IS NULL OR
732: p_style_format_code = fnd_api.g_miss_char THEN
733: fnd_message.set_name('AR', 'HZ_API_MISSING_COLUMN');
734: fnd_message.set_token('COLUMN', 'style_format_code');
735: fnd_msg_pub.add;
736: RAISE fnd_api.g_exc_error;
737: END IF;
738:
739: x_style_format_rec.style_format_code := p_style_format_code;
760: p_msg_level=>fnd_log.level_procedure);
761: END IF;
762:
763: --Standard call to get message count and if count is 1, get message info.
764: fnd_msg_pub.count_and_get(
765: p_encoded => fnd_api.g_false,
766: p_count => x_msg_count,
767: p_data => x_msg_data
768: );
784: --disable_debug;
785: EXCEPTION
786: WHEN fnd_api.g_exc_error THEN
787: x_return_status := fnd_api.g_ret_sts_error;
788: fnd_msg_pub.count_and_get(
789: p_encoded => fnd_api.g_false,
790: p_count => x_msg_count,
791: p_data => x_msg_data
792: );
809:
810: WHEN fnd_api.g_exc_unexpected_error THEN
811: x_return_status := fnd_api.g_ret_sts_unexp_error;
812:
813: fnd_msg_pub.count_and_get(
814: p_encoded => fnd_api.g_false,
815: p_count => x_msg_count,
816: p_data => x_msg_data
817: );
837: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
838:
839: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
840: fnd_message.set_token('ERROR' ,SQLERRM);
841: fnd_msg_pub.add;
842:
843: fnd_msg_pub.count_and_get(
844: p_encoded => fnd_api.g_false,
845: p_count => x_msg_count,
839: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
840: fnd_message.set_token('ERROR' ,SQLERRM);
841: fnd_msg_pub.add;
842:
843: fnd_msg_pub.count_and_get(
844: p_encoded => fnd_api.g_false,
845: p_count => x_msg_count,
846: p_data => x_msg_data
847: );