642:
643: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
644: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
645: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
646: IF ( FND_MSG_PUB.Count_Msg > 0 ) THEN
647: FOR I IN 1..FND_MSG_PUB.Count_Msg LOOP
648: l_msg_text := FND_MSG_PUB.Get(p_encoded => FND_API.G_FALSE);
649: IF l_debug_level > 0 THEN
650: oe_debug_pub.Add(l_msg_text, 3);
643: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
644: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
645: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
646: IF ( FND_MSG_PUB.Count_Msg > 0 ) THEN
647: FOR I IN 1..FND_MSG_PUB.Count_Msg LOOP
648: l_msg_text := FND_MSG_PUB.Get(p_encoded => FND_API.G_FALSE);
649: IF l_debug_level > 0 THEN
650: oe_debug_pub.Add(l_msg_text, 3);
651: END IF;
644: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
645: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
646: IF ( FND_MSG_PUB.Count_Msg > 0 ) THEN
647: FOR I IN 1..FND_MSG_PUB.Count_Msg LOOP
648: l_msg_text := FND_MSG_PUB.Get(p_encoded => FND_API.G_FALSE);
649: IF l_debug_level > 0 THEN
650: oe_debug_pub.Add(l_msg_text, 3);
651: END IF;
652: oe_msg_pub.add_text(p_message_text => l_msg_text);
684:
685: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
686: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
687: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
688: IF ( FND_MSG_PUB.Count_Msg > 0 ) THEN
689: FOR I IN 1..FND_MSG_PUB.Count_Msg LOOP
690: l_msg_text := FND_MSG_PUB.Get(p_encoded => FND_API.G_FALSE);
691: IF l_debug_level > 0 THEN
692: oe_debug_pub.Add(l_msg_text, 3);
685: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
686: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
687: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
688: IF ( FND_MSG_PUB.Count_Msg > 0 ) THEN
689: FOR I IN 1..FND_MSG_PUB.Count_Msg LOOP
690: l_msg_text := FND_MSG_PUB.Get(p_encoded => FND_API.G_FALSE);
691: IF l_debug_level > 0 THEN
692: oe_debug_pub.Add(l_msg_text, 3);
693: END IF;
686: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
687: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
688: IF ( FND_MSG_PUB.Count_Msg > 0 ) THEN
689: FOR I IN 1..FND_MSG_PUB.Count_Msg LOOP
690: l_msg_text := FND_MSG_PUB.Get(p_encoded => FND_API.G_FALSE);
691: IF l_debug_level > 0 THEN
692: oe_debug_pub.Add(l_msg_text, 3);
693: END IF;
694: oe_msg_pub.add_text(p_message_text => l_msg_text);
1016:
1017: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1018: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1019: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1020: IF ( FND_MSG_PUB.Count_Msg > 0 ) THEN
1021: FOR I IN 1..FND_MSG_PUB.Count_Msg LOOP
1022: l_msg_text := FND_MSG_PUB.Get(p_encoded => FND_API.G_FALSE);
1023: IF l_debug_level > 0 THEN
1024: oe_debug_pub.Add(l_msg_text, 3);
1017: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1018: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1019: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1020: IF ( FND_MSG_PUB.Count_Msg > 0 ) THEN
1021: FOR I IN 1..FND_MSG_PUB.Count_Msg LOOP
1022: l_msg_text := FND_MSG_PUB.Get(p_encoded => FND_API.G_FALSE);
1023: IF l_debug_level > 0 THEN
1024: oe_debug_pub.Add(l_msg_text, 3);
1025: END IF;
1018: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1019: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1020: IF ( FND_MSG_PUB.Count_Msg > 0 ) THEN
1021: FOR I IN 1..FND_MSG_PUB.Count_Msg LOOP
1022: l_msg_text := FND_MSG_PUB.Get(p_encoded => FND_API.G_FALSE);
1023: IF l_debug_level > 0 THEN
1024: oe_debug_pub.Add(l_msg_text, 3);
1025: END IF;
1026: oe_msg_pub.add_text(p_message_text => l_msg_text);