385: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
386: END IF;
387: -- initialize messages
388: IF FND_API.to_boolean(p_init_msg_list) THEN
389: FND_MSG_PUB.initialize;
390: END IF;
391:
392: ozf_utility_pvt.debug_message('Private API: '|| l_api_name || ' Start');
393: x_return_status := FND_API.G_RET_STS_SUCCESS;
466: EXCEPTION
467: WHEN FND_API.G_EXC_ERROR THEN
468: ROLLBACK TO Create_mo_preset_tiers;
469: x_return_status := FND_API.G_RET_STS_ERROR;
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: );
474: );
475: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
476: ROLLBACK TO Create_mo_preset_tiers;
477: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
478: FND_MSG_PUB.count_and_get(
479: p_encoded => FND_API.g_false
480: , p_count => x_msg_count
481: , p_data => x_msg_data
482: );
481: , p_data => x_msg_data
482: );
483: WHEN OTHERS THEN
484: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
485: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
486: THEN
487: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
488: END IF;
489: -- Standard call to get message count and if count=1, get the message
483: WHEN OTHERS THEN
484: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
485: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
486: THEN
487: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
488: END IF;
489: -- Standard call to get message count and if count=1, get the message
490: FND_MSG_PUB.Count_And_Get (
491: p_encoded => FND_API.G_FALSE,
486: THEN
487: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
488: END IF;
489: -- Standard call to get message count and if count=1, get the message
490: FND_MSG_PUB.Count_And_Get (
491: p_encoded => FND_API.G_FALSE,
492: p_count => x_msg_count,
493: p_data => x_msg_data
494: );
534: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
535: END IF;
536:
537: IF FND_API.to_boolean(p_init_msg_list) THEN
538: FND_MSG_PUB.initialize;
539: END IF;
540:
541: ozf_utility_pvt.debug_message('Private API: '|| l_api_name || ' Start');
542: x_return_status := FND_API.G_RET_STS_SUCCESS;
609: EXCEPTION
610: WHEN FND_API.G_EXC_ERROR THEN
611: ROLLBACK TO UPDATE_mo_PRESET_TIERS;
612: x_return_status := FND_API.G_RET_STS_ERROR;
613: FND_MSG_PUB.count_and_get(
614: p_encoded => FND_API.g_false
615: , p_count => x_msg_count
616: , p_data => x_msg_data
617: );
617: );
618: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
619: ROLLBACK TO UPDATE_mo_PRESET_TIERS;
620: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
621: FND_MSG_PUB.count_and_get(
622: p_encoded => FND_API.g_false
623: , p_count => x_msg_count
624: , p_data => x_msg_data
625: );
625: );
626: WHEN OTHERS THEN
627: ROLLBACK TO UPDATE_mo_PRESET_TIERS;
628: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
629: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
630: THEN
631: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
632: END IF;
633: -- Standard call to get message count and if count=1, get the message
627: ROLLBACK TO UPDATE_mo_PRESET_TIERS;
628: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
629: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
630: THEN
631: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
632: END IF;
633: -- Standard call to get message count and if count=1, get the message
634: FND_MSG_PUB.Count_And_Get (
635: p_encoded => FND_API.G_FALSE,
630: THEN
631: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
632: END IF;
633: -- Standard call to get message count and if count=1, get the message
634: FND_MSG_PUB.Count_And_Get (
635: p_encoded => FND_API.G_FALSE,
636: p_count => x_msg_count,
637: p_data => x_msg_data
638: );
667: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
668: END IF;
669:
670: IF FND_API.to_boolean(p_init_msg_list) THEN
671: FND_MSG_PUB.initialize;
672: END IF;
673:
674: x_return_status := FND_API.G_RET_STS_SUCCESS;
675: ozf_utility_pvt.debug_message('Private API: '|| l_api_name || ' Start');
690: EXCEPTION
691: WHEN FND_API.G_EXC_ERROR THEN
692: ROLLBACK TO Delete_mo_preset_tiers;
693: x_return_status := FND_API.G_RET_STS_ERROR;
694: FND_MSG_PUB.count_and_get(
695: p_encoded => FND_API.g_false
696: , p_count => x_msg_count
697: , p_data => x_msg_data
698: );
698: );
699: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
700: ROLLBACK TO Delete_mo_preset_tiers;
701: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
702: FND_MSG_PUB.count_and_get(
703: p_encoded => FND_API.g_false
704: , p_count => x_msg_count
705: , p_data => x_msg_data
706: );
706: );
707: WHEN OTHERS THEN
708: ROLLBACK TO Delete_mo_preset_tiers;
709: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
710: IF FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
711: FND_MSG_PUB.Add_exc_msg(G_PKG_NAME,l_api_name);
712: END IF;
713: FND_MSG_PUB.count_and_get(
714: p_encoded => FND_API.g_false
707: WHEN OTHERS THEN
708: ROLLBACK TO Delete_mo_preset_tiers;
709: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
710: IF FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
711: FND_MSG_PUB.Add_exc_msg(G_PKG_NAME,l_api_name);
712: END IF;
713: FND_MSG_PUB.count_and_get(
714: p_encoded => FND_API.g_false
715: , p_count => x_msg_count
709: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
710: IF FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
711: FND_MSG_PUB.Add_exc_msg(G_PKG_NAME,l_api_name);
712: END IF;
713: FND_MSG_PUB.count_and_get(
714: p_encoded => FND_API.g_false
715: , p_count => x_msg_count
716: , p_data => x_msg_data
717: );