1453: null;
1454: WHEN OTHERS THEN
1455: retcode := 3;
1456: errbuf := sqlerrm;
1457: IF FND_MSG_PUB.Check_Msg_Level
1458: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1459: THEN
1460: FND_MSG_PUB.Add_Exc_Msg
1461: ( G_PKG_NAME ,
1454: WHEN OTHERS THEN
1455: retcode := 3;
1456: errbuf := sqlerrm;
1457: IF FND_MSG_PUB.Check_Msg_Level
1458: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1459: THEN
1460: FND_MSG_PUB.Add_Exc_Msg
1461: ( G_PKG_NAME ,
1462: l_api_name
1456: errbuf := sqlerrm;
1457: IF FND_MSG_PUB.Check_Msg_Level
1458: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1459: THEN
1460: FND_MSG_PUB.Add_Exc_Msg
1461: ( G_PKG_NAME ,
1462: l_api_name
1463: );
1464: END IF;