44: x_msg_count => l_msg_count,
45: x_msg_data => l_msg_data
46: );
47:
48: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
49: RAISE FND_API.G_EXC_ERROR;
50: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
51: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
52: END IF;
45: x_msg_data => l_msg_data
46: );
47:
48: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
49: RAISE FND_API.G_EXC_ERROR;
50: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
51: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
52: END IF;
53: -- Public API Call end
46: );
47:
48: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
49: RAISE FND_API.G_EXC_ERROR;
50: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
51: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
52: END IF;
53: -- Public API Call end
54:
47:
48: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
49: RAISE FND_API.G_EXC_ERROR;
50: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
51: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
52: END IF;
53: -- Public API Call end
54:
55:
60: x_msg_data := l_msg_data ;
61:
62: EXCEPTION
63:
64: WHEN FND_API.G_EXC_ERROR THEN
65: SAVEPOINT CREATE_CASE;
66: x_return_status := FND_API.G_RET_STS_ERROR;
67: x_msg_count := l_msg_count ;
68: x_msg_data := l_msg_data ;
62: EXCEPTION
63:
64: WHEN FND_API.G_EXC_ERROR THEN
65: SAVEPOINT CREATE_CASE;
66: x_return_status := FND_API.G_RET_STS_ERROR;
67: x_msg_count := l_msg_count ;
68: x_msg_data := l_msg_data ;
69: FND_MSG_PUB.ADD_EXC_MSG('OKL_CASE_UTIL_PUB','CREATE_CASE');
70: FND_MSG_PUB.count_and_get( p_count => x_msg_count
69: FND_MSG_PUB.ADD_EXC_MSG('OKL_CASE_UTIL_PUB','CREATE_CASE');
70: FND_MSG_PUB.count_and_get( p_count => x_msg_count
71: ,p_data => x_msg_data);
72:
73: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
74: SAVEPOINT CREATE_CASE;
75: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
76: x_msg_count := l_msg_count ;
77: x_msg_data := l_msg_data ;
71: ,p_data => x_msg_data);
72:
73: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
74: SAVEPOINT CREATE_CASE;
75: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
76: x_msg_count := l_msg_count ;
77: x_msg_data := l_msg_data ;
78: FND_MSG_PUB.ADD_EXC_MSG('OKL_CASE_UTIL_PUB','CREATE_CASE');
79: FND_MSG_PUB.count_and_get( p_count => x_msg_count
80: ,p_data => x_msg_data);
81:
82: WHEN OTHERS THEN
83: SAVEPOINT CREATE_CASE;
84: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
85: x_msg_count := l_msg_count ;
86: x_msg_data := l_msg_data ;
87: FND_MSG_PUB.ADD_EXC_MSG('OKL_CASE_UTIL_PUB','CREATE_CASE');
88: FND_MSG_PUB.count_and_get( p_count => x_msg_count