1631: null;
1632: WHEN OTHERS THEN
1633: retcode := 3;
1634: errbuf := sqlerrm;
1635: IF FND_MSG_PUB.Check_Msg_Level
1636: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1637: THEN
1638: FND_MSG_PUB.Add_Exc_Msg
1639: ( G_PKG_NAME ,
1632: WHEN OTHERS THEN
1633: retcode := 3;
1634: errbuf := sqlerrm;
1635: IF FND_MSG_PUB.Check_Msg_Level
1636: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1637: THEN
1638: FND_MSG_PUB.Add_Exc_Msg
1639: ( G_PKG_NAME ,
1640: l_api_name
1634: errbuf := sqlerrm;
1635: IF FND_MSG_PUB.Check_Msg_Level
1636: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1637: THEN
1638: FND_MSG_PUB.Add_Exc_Msg
1639: ( G_PKG_NAME ,
1640: l_api_name
1641: );
1642: END IF;