148: EXCEPTION
149: WHEN OTHERS THEN
150: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
151:
152: IF FND_MSG_PUB.Check_Msg_Level
153: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
154: THEN
155: FND_MSG_PUB.Add_Exc_Msg
156: (
149: WHEN OTHERS THEN
150: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
151:
152: IF FND_MSG_PUB.Check_Msg_Level
153: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
154: THEN
155: FND_MSG_PUB.Add_Exc_Msg
156: (
157: G_PKG_NAME,
151:
152: IF FND_MSG_PUB.Check_Msg_Level
153: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
154: THEN
155: FND_MSG_PUB.Add_Exc_Msg
156: (
157: G_PKG_NAME,
158: l_api_name
159: );
342: WHEN OTHERS THEN
343:
344: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
345:
346: IF FND_MSG_PUB.Check_Msg_Level
347: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
348: THEN
349: FND_MSG_PUB.Add_Exc_Msg
350: (
343:
344: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
345:
346: IF FND_MSG_PUB.Check_Msg_Level
347: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
348: THEN
349: FND_MSG_PUB.Add_Exc_Msg
350: (
351: G_PKG_NAME,
345:
346: IF FND_MSG_PUB.Check_Msg_Level
347: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
348: THEN
349: FND_MSG_PUB.Add_Exc_Msg
350: (
351: G_PKG_NAME,
352: l_api_name
353: );
562: WHEN OTHERS THEN
563:
564: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
565:
566: IF FND_MSG_PUB.Check_Msg_Level
567: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
568: THEN
569: FND_MSG_PUB.Add_Exc_Msg
570: (
563:
564: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
565:
566: IF FND_MSG_PUB.Check_Msg_Level
567: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
568: THEN
569: FND_MSG_PUB.Add_Exc_Msg
570: (
571: G_PKG_NAME,
565:
566: IF FND_MSG_PUB.Check_Msg_Level
567: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
568: THEN
569: FND_MSG_PUB.Add_Exc_Msg
570: (
571: G_PKG_NAME,
572: l_api_name
573: );
666: WHEN OTHERS THEN
667:
668: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
669:
670: IF FND_MSG_PUB.Check_Msg_Level
671: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
672: THEN
673: FND_MSG_PUB.Add_Exc_Msg
674: (
667:
668: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
669:
670: IF FND_MSG_PUB.Check_Msg_Level
671: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
672: THEN
673: FND_MSG_PUB.Add_Exc_Msg
674: (
675: G_PKG_NAME,
669:
670: IF FND_MSG_PUB.Check_Msg_Level
671: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
672: THEN
673: FND_MSG_PUB.Add_Exc_Msg
674: (
675: G_PKG_NAME,
676: l_api_name
677: );
865: WHEN OTHERS THEN
866:
867: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
868:
869: IF FND_MSG_PUB.Check_Msg_Level
870: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
871: THEN
872: FND_MSG_PUB.Add_Exc_Msg
873: (
866:
867: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
868:
869: IF FND_MSG_PUB.Check_Msg_Level
870: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
871: THEN
872: FND_MSG_PUB.Add_Exc_Msg
873: (
874: G_PKG_NAME,
868:
869: IF FND_MSG_PUB.Check_Msg_Level
870: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
871: THEN
872: FND_MSG_PUB.Add_Exc_Msg
873: (
874: G_PKG_NAME,
875: l_api_name
876: );