2556:
2557: when OTHERS then
2558: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2559:
2560: if FND_MSG_PUB.Check_Msg_Level
2561: (p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) then
2562: FND_MSG_PUB.Add_Exc_Msg
2563: (p_pkg_name => G_PKG_NAME,
2564: p_procedure_name => l_api_name);
2557: when OTHERS then
2558: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2559:
2560: if FND_MSG_PUB.Check_Msg_Level
2561: (p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) then
2562: FND_MSG_PUB.Add_Exc_Msg
2563: (p_pkg_name => G_PKG_NAME,
2564: p_procedure_name => l_api_name);
2565: end if;
2558: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2559:
2560: if FND_MSG_PUB.Check_Msg_Level
2561: (p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) then
2562: FND_MSG_PUB.Add_Exc_Msg
2563: (p_pkg_name => G_PKG_NAME,
2564: p_procedure_name => l_api_name);
2565: end if;
2566:
2760:
2761: when OTHERS then
2762: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2763:
2764: if FND_MSG_PUB.Check_Msg_Level
2765: (p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) then
2766: FND_MSG_PUB.Add_Exc_Msg
2767: (p_pkg_name => G_PKG_NAME,
2768: p_procedure_name => l_api_name);
2761: when OTHERS then
2762: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2763:
2764: if FND_MSG_PUB.Check_Msg_Level
2765: (p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) then
2766: FND_MSG_PUB.Add_Exc_Msg
2767: (p_pkg_name => G_PKG_NAME,
2768: p_procedure_name => l_api_name);
2769: end if;
2762: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2763:
2764: if FND_MSG_PUB.Check_Msg_Level
2765: (p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) then
2766: FND_MSG_PUB.Add_Exc_Msg
2767: (p_pkg_name => G_PKG_NAME,
2768: p_procedure_name => l_api_name);
2769: end if;
2770:
2816: end loop;
2817:
2818: end if;
2819:
2820: FND_MSG_PUB.Add;
2821:
2822: end if;
2823:
2824: -- Clear Message Token stack