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_cash_rl_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_cash_rl_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: -- Fnd_Msg_Pub.count_and_get(
59: -- p_count => x_msg_count
58: -- Fnd_Msg_Pub.count_and_get(
59: -- p_count => x_msg_count
60: -- ,p_data => x_msg_data);
61:
62: WHEN Okl_Api.G_EXCEPTION_ERROR THEN
63: ROLLBACK TO okl_cash_rl_sumry;
64: x_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;
65: x_msg_count := l_msg_count ;
66: x_msg_data := l_msg_data ;
60: -- ,p_data => x_msg_data);
61:
62: WHEN Okl_Api.G_EXCEPTION_ERROR THEN
63: ROLLBACK TO okl_cash_rl_sumry;
64: x_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;
65: x_msg_count := l_msg_count ;
66: x_msg_data := l_msg_data ;
67: -- Fnd_Msg_Pub.count_and_get(
68: -- p_count => x_msg_count
69: -- ,p_data => x_msg_data);
70:
71: WHEN OTHERS THEN
72: ROLLBACK TO okl_cash_rl_sumry;
73: x_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;
74: x_msg_count := l_msg_count ;
75: x_msg_data := l_msg_data ;
76: Fnd_Msg_Pub.ADD_EXC_MSG('OKL_CASH_RULES_SUMRY_PUB','unknown exception');
77: Fnd_Msg_Pub.count_and_get(