36: x_return_status => l_return_status,
37: x_msg_count => l_msg_count,
38: x_msg_data => l_msg_data);
39:
40: IF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
41: RAISE OKL_API.G_EXCEPTION_ERROR;
42: ELSIF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
43: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
44: END IF;
37: x_msg_count => l_msg_count,
38: x_msg_data => l_msg_data);
39:
40: IF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
41: RAISE OKL_API.G_EXCEPTION_ERROR;
42: ELSIF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
43: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
44: END IF;
45:
38: x_msg_data => l_msg_data);
39:
40: IF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
41: RAISE OKL_API.G_EXCEPTION_ERROR;
42: ELSIF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
43: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
44: END IF;
45:
46: --End Call to Private API
39:
40: IF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
41: RAISE OKL_API.G_EXCEPTION_ERROR;
42: ELSIF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
43: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
44: END IF;
45:
46: --End Call to Private API
47:
58: x_msg_data := l_msg_data;
59:
60: EXCEPTION
61:
62: WHEN OKL_API.G_EXCEPTION_ERROR THEN
63: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
64: FND_MSG_PUB.count_and_get(p_count => x_msg_count,
65: p_data => x_msg_data);
66:
59:
60: EXCEPTION
61:
62: WHEN OKL_API.G_EXCEPTION_ERROR THEN
63: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
64: FND_MSG_PUB.count_and_get(p_count => x_msg_count,
65: p_data => x_msg_data);
66:
67: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
63: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
64: FND_MSG_PUB.count_and_get(p_count => x_msg_count,
65: p_data => x_msg_data);
66:
67: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
68: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
69: FND_MSG_PUB.count_and_get(p_count => x_msg_count,
70: p_data => x_msg_data);
71:
64: FND_MSG_PUB.count_and_get(p_count => x_msg_count,
65: p_data => x_msg_data);
66:
67: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
68: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
69: FND_MSG_PUB.count_and_get(p_count => x_msg_count,
70: p_data => x_msg_data);
71:
72: WHEN OTHERS THEN
69: FND_MSG_PUB.count_and_get(p_count => x_msg_count,
70: p_data => x_msg_data);
71:
72: WHEN OTHERS THEN
73: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
74: FND_MSG_PUB.ADD_EXC_MSG('OKL_BLK_AST_UPD_PUB','Update_Location');
75: FND_MSG_PUB.count_and_get(p_count => x_msg_count,
76: p_data => x_msg_data);
77:
118: x_return_status => l_return_status,
119: x_msg_count => l_msg_count,
120: x_msg_data => l_msg_data);
121:
122: IF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
123: RAISE OKL_API.G_EXCEPTION_ERROR;
124: ELSIF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
125: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
126: END IF;
119: x_msg_count => l_msg_count,
120: x_msg_data => l_msg_data);
121:
122: IF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
123: RAISE OKL_API.G_EXCEPTION_ERROR;
124: ELSIF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
125: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
126: END IF;
127:
120: x_msg_data => l_msg_data);
121:
122: IF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
123: RAISE OKL_API.G_EXCEPTION_ERROR;
124: ELSIF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
125: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
126: END IF;
127:
128: --End Call to Private API
121:
122: IF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
123: RAISE OKL_API.G_EXCEPTION_ERROR;
124: ELSIF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
125: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
126: END IF;
127:
128: --End Call to Private API
129:
140: x_msg_data := l_msg_data;
141:
142: EXCEPTION
143:
144: WHEN OKL_API.G_EXCEPTION_ERROR THEN
145: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
146: FND_MSG_PUB.count_and_get(p_count => x_msg_count,
147: p_data => x_msg_data);
148:
141:
142: EXCEPTION
143:
144: WHEN OKL_API.G_EXCEPTION_ERROR THEN
145: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
146: FND_MSG_PUB.count_and_get(p_count => x_msg_count,
147: p_data => x_msg_data);
148:
149: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
145: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
146: FND_MSG_PUB.count_and_get(p_count => x_msg_count,
147: p_data => x_msg_data);
148:
149: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
150: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
151: FND_MSG_PUB.count_and_get(p_count => x_msg_count,
152: p_data => x_msg_data);
153:
146: FND_MSG_PUB.count_and_get(p_count => x_msg_count,
147: p_data => x_msg_data);
148:
149: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
150: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
151: FND_MSG_PUB.count_and_get(p_count => x_msg_count,
152: p_data => x_msg_data);
153:
154: WHEN OTHERS THEN
151: FND_MSG_PUB.count_and_get(p_count => x_msg_count,
152: p_data => x_msg_data);
153:
154: WHEN OTHERS THEN
155: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
156: FND_MSG_PUB.ADD_EXC_MSG('OKL_BLK_AST_UPD_PUB','Update_Location');
157: FND_MSG_PUB.count_and_get(p_count => x_msg_count,
158: p_data => x_msg_data);
159: