36: EXCEPTION
37: WHEN OTHERS THEN
38: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
39: x_serial_number := NULL;
40: IF fnd_msg_pub.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
41: THEN
42: FND_MSG_PUB.Add_Exc_Msg ('USER_PKG_SERIAL','GENERATE_SERIAL_NUMBER');
43: END IF;
44: END generate_serial_number;
38: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
39: x_serial_number := NULL;
40: IF fnd_msg_pub.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
41: THEN
42: FND_MSG_PUB.Add_Exc_Msg ('USER_PKG_SERIAL','GENERATE_SERIAL_NUMBER');
43: END IF;
44: END generate_serial_number;
45:
46: END user_pkg_serial;