41: x_return_status := l_return_status;
42: x_msg_count := l_msg_count;
43: x_msg_data := l_msg_data;
44:
45: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
46: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
47: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
48: RAISE Okl_Api.G_EXCEPTION_ERROR;
49: END IF;
42: x_msg_count := l_msg_count;
43: x_msg_data := l_msg_data;
44:
45: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
46: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
47: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
48: RAISE Okl_Api.G_EXCEPTION_ERROR;
49: END IF;
50:
43: x_msg_data := l_msg_data;
44:
45: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
46: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
47: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
48: RAISE Okl_Api.G_EXCEPTION_ERROR;
49: END IF;
50:
51: EXCEPTION
44:
45: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
46: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
47: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
48: RAISE Okl_Api.G_EXCEPTION_ERROR;
49: END IF;
50:
51: EXCEPTION
52:
49: END IF;
50:
51: EXCEPTION
52:
53: WHEN Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN
54: ROLLBACK TO okl_batch_sumry;
55: x_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;
56: x_msg_count := l_msg_count ;
57: x_msg_data := l_msg_data ;
51: EXCEPTION
52:
53: WHEN Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN
54: ROLLBACK TO okl_batch_sumry;
55: x_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;
56: x_msg_count := l_msg_count ;
57: x_msg_data := l_msg_data ;
58:
59: WHEN Okl_Api.G_EXCEPTION_ERROR THEN
55: x_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;
56: x_msg_count := l_msg_count ;
57: x_msg_data := l_msg_data ;
58:
59: WHEN Okl_Api.G_EXCEPTION_ERROR THEN
60: ROLLBACK TO okl_batch_sumry;
61: x_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;
62: x_msg_count := l_msg_count ;
63: x_msg_data := l_msg_data ;
57: x_msg_data := l_msg_data ;
58:
59: WHEN Okl_Api.G_EXCEPTION_ERROR THEN
60: ROLLBACK TO okl_batch_sumry;
61: x_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;
62: x_msg_count := l_msg_count ;
63: x_msg_data := l_msg_data ;
64:
65: WHEN OTHERS THEN
63: x_msg_data := l_msg_data ;
64:
65: WHEN OTHERS THEN
66: ROLLBACK TO okl_batch_sumry;
67: x_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;
68: x_msg_count := l_msg_count ;
69: x_msg_data := l_msg_data ;
70: Fnd_Msg_Pub.ADD_EXC_MSG('OKL_BTCH_CASH_SUMRY_PUB','unknown exception');
71: Fnd_Msg_Pub.count_and_get(