47: );
48:
49:
50:
51: IF ( x_return_status = Fnd_Api.G_RET_STS_ERROR ) THEN
52: RAISE Fnd_Api.G_EXC_ERROR;
53: ELSIF (l_return_status = Fnd_Api.G_RET_STS_UNEXP_ERROR ) THEN
54: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
55: END IF;
48:
49:
50:
51: IF ( x_return_status = Fnd_Api.G_RET_STS_ERROR ) THEN
52: RAISE Fnd_Api.G_EXC_ERROR;
53: ELSIF (l_return_status = Fnd_Api.G_RET_STS_UNEXP_ERROR ) THEN
54: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
55: END IF;
56:
49:
50:
51: IF ( x_return_status = Fnd_Api.G_RET_STS_ERROR ) THEN
52: RAISE Fnd_Api.G_EXC_ERROR;
53: ELSIF (l_return_status = Fnd_Api.G_RET_STS_UNEXP_ERROR ) THEN
54: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
55: END IF;
56:
57: EXCEPTION
50:
51: IF ( x_return_status = Fnd_Api.G_RET_STS_ERROR ) THEN
52: RAISE Fnd_Api.G_EXC_ERROR;
53: ELSIF (l_return_status = Fnd_Api.G_RET_STS_UNEXP_ERROR ) THEN
54: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
55: END IF;
56:
57: EXCEPTION
58:
55: END IF;
56:
57: EXCEPTION
58:
59: WHEN FND_API.G_EXC_ERROR THEN
60: ROLLBACK TO updt_cash_dtls_pub;
61: x_return_status := FND_API.G_RET_STS_ERROR;
62: x_msg_count := l_msg_count ;
63: x_msg_data := l_msg_data ;
57: EXCEPTION
58:
59: WHEN FND_API.G_EXC_ERROR THEN
60: ROLLBACK TO updt_cash_dtls_pub;
61: x_return_status := FND_API.G_RET_STS_ERROR;
62: x_msg_count := l_msg_count ;
63: x_msg_data := l_msg_data ;
64: FND_MSG_PUB.count_and_get(
65: p_count => x_msg_count
65: p_count => x_msg_count
66: ,p_data => x_msg_data);
67:
68:
69: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
70: ROLLBACK TO updt_cash_dtls_pub;
71: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
72: x_msg_count := l_msg_count ;
73: x_msg_data := l_msg_data ;
67:
68:
69: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
70: ROLLBACK TO updt_cash_dtls_pub;
71: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
72: x_msg_count := l_msg_count ;
73: x_msg_data := l_msg_data ;
74: FND_MSG_PUB.count_and_get(
75: p_count => x_msg_count