92:
93: -- Initialize message list if p_init_msg_list is set to TRUE.
94: IF FND_API.to_Boolean( p_init_msg_list )
95: THEN
96: FND_MSG_PUB.initialize;
97: END IF;
98:
99: --
100: -- Initialize API return status to success
223:
224: IF l_count <> 0
225: THEN
226: --Error condition
227: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
228: THEN
229: fnd_message.set_name('CN', 'CN_RULESET_EXISTS');
230: fnd_msg_pub.add;
231: END IF;
226: --Error condition
227: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
228: THEN
229: fnd_message.set_name('CN', 'CN_RULESET_EXISTS');
230: fnd_msg_pub.add;
231: END IF;
232:
233: x_loading_status := 'CN_RULESET_EXISTS';
234: RAISE FND_API.G_EXC_ERROR;
406: --
407: -- Standard call to get message count and if count is 1, get message info.
408: --
409:
410: FND_MSG_PUB.Count_And_Get
411: (
412: p_count => x_msg_count ,
413: p_data => x_msg_data ,
414: p_encoded => FND_API.G_FALSE
416: EXCEPTION
417: WHEN FND_API.G_EXC_ERROR THEN
418: ROLLBACK TO Create_Ruleset;
419: x_return_status := FND_API.G_RET_STS_ERROR ;
420: FND_MSG_PUB.Count_And_Get
421: (
422: p_count => x_msg_count ,
423: p_data => x_msg_data ,
424: p_encoded => FND_API.G_FALSE
426: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
427: ROLLBACK TO Create_Ruleset;
428: x_loading_status := 'UNEXPECTED_ERR';
429: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
430: FND_MSG_PUB.Count_And_Get
431: (
432: p_count => x_msg_count ,
433: p_data => x_msg_data ,
434: p_encoded => FND_API.G_FALSE
436: WHEN OTHERS THEN
437: ROLLBACK TO Create_Ruleset;
438: x_loading_status := 'UNEXPECTED_ERR';
439: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
440: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
441: THEN
442: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
443: END IF;
444: FND_MSG_PUB.Count_And_Get
438: x_loading_status := 'UNEXPECTED_ERR';
439: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
440: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
441: THEN
442: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
443: END IF;
444: FND_MSG_PUB.Count_And_Get
445: (
446: p_count => x_msg_count ,
440: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
441: THEN
442: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
443: END IF;
444: FND_MSG_PUB.Count_And_Get
445: (
446: p_count => x_msg_count ,
447: p_data => x_msg_data ,
448: p_encoded => FND_API.G_FALSE
528:
529: -- Initialize message list if p_init_msg_list is set to TRUE.
530: IF FND_API.to_Boolean( p_init_msg_list )
531: THEN
532: FND_MSG_PUB.initialize;
533: END IF;
534:
535: --
536: -- Initialize API return status to success
687:
688: IF l_count = 0
689: THEN
690: --Error condition
691: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
692: THEN
693: fnd_message.set_name('CN', 'CN_INVALID_RULESET');
694: fnd_msg_pub.add;
695: END IF;
690: --Error condition
691: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
692: THEN
693: fnd_message.set_name('CN', 'CN_INVALID_RULESET');
694: fnd_msg_pub.add;
695: END IF;
696:
697: x_loading_status := 'CN_INVALID_RULESET';
698: RAISE FND_API.G_EXC_ERROR;
879: END IF;
880:
881:
882: -- Standard call to get message count and if count is 1, get message info.
883: FND_MSG_PUB.Count_And_Get
884: (p_count => x_msg_count,
885: p_data => x_msg_data
886: );
887: EXCEPTION
887: EXCEPTION
888: WHEN FND_API.G_EXC_ERROR THEN
889: ROLLBACK TO Update_Ruleset;
890: x_return_status := FND_API.G_RET_STS_ERROR ;
891: FND_MSG_PUB.Count_And_Get
892: (p_count => x_msg_count,
893: p_data => x_msg_data
894: );
895: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
894: );
895: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
896: ROLLBACK TO Update_Ruleset;
897: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
898: FND_MSG_PUB.Count_And_Get
899: (p_count => x_msg_count,
900: p_data => x_msg_data
901: );
902: WHEN OTHERS THEN
901: );
902: WHEN OTHERS THEN
903: ROLLBACK TO Update_Ruleset;
904: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
905: IF FND_MSG_PUB.Check_Msg_Level
906: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
907: THEN
908: FND_MSG_PUB.Add_Exc_Msg
909: (G_PKG_NAME,
902: WHEN OTHERS THEN
903: ROLLBACK TO Update_Ruleset;
904: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
905: IF FND_MSG_PUB.Check_Msg_Level
906: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
907: THEN
908: FND_MSG_PUB.Add_Exc_Msg
909: (G_PKG_NAME,
910: l_api_name
904: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
905: IF FND_MSG_PUB.Check_Msg_Level
906: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
907: THEN
908: FND_MSG_PUB.Add_Exc_Msg
909: (G_PKG_NAME,
910: l_api_name
911: );
912: END IF;
909: (G_PKG_NAME,
910: l_api_name
911: );
912: END IF;
913: FND_MSG_PUB.Count_And_Get
914: (p_count => x_msg_count,
915: p_data => x_msg_data
916: );
917: