676:
677: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
678: x_return_code := 1;
679: x_return_status := FND_API.G_RET_STS_ERROR;
680: x_err_msg := l_progress||':'||FND_MSG_PUB.get(FND_MSG_PUB.G_LAST,'F');
681: return;
682: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
683: raise FND_API.G_EXC_UNEXPECTED_ERROR;
684: END IF; -- l_return_status
724:
725: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
726: x_return_code := 1;
727: x_return_status := FND_API.G_RET_STS_ERROR;
728: x_err_msg := l_progress||':'||FND_MSG_PUB.get(FND_MSG_PUB.G_LAST,'F');
729: return;
730: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
731: raise FND_API.G_EXC_UNEXPECTED_ERROR;
732: END IF; -- l_return_status
738: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
739:
740: x_return_code := 2;
741: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
742: x_err_msg := l_progress||':'||FND_MSG_PUB.get(FND_MSG_PUB.G_LAST,'F');
743:
744: WHEN OTHERS THEN
745:
746: x_return_code := 2;