35: p_parent_line_id => p_parent_line_id,
36: p_year => p_year,
37: x_year => x_year);
38:
39: IF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
40: RAISE OKL_API.G_EXCEPTION_ERROR;
41: ELSIF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
42: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
43: END IF;
36: p_year => p_year,
37: x_year => x_year);
38:
39: IF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
40: RAISE OKL_API.G_EXCEPTION_ERROR;
41: ELSIF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
42: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
43: END IF;
44:
37: x_year => x_year);
38:
39: IF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
40: RAISE OKL_API.G_EXCEPTION_ERROR;
41: ELSIF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
42: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
43: END IF;
44:
45: --End Call to Private API
38:
39: IF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
40: RAISE OKL_API.G_EXCEPTION_ERROR;
41: ELSIF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
42: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
43: END IF;
44:
45: --End Call to Private API
46:
59: x_msg_data := l_msg_data;
60:
61: EXCEPTION
62:
63: WHEN OKL_API.G_EXCEPTION_ERROR THEN
64: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
65: FND_MSG_PUB.count_and_get(p_count => x_msg_count,
66: p_data => x_msg_data);
67:
60:
61: EXCEPTION
62:
63: WHEN OKL_API.G_EXCEPTION_ERROR THEN
64: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
65: FND_MSG_PUB.count_and_get(p_count => x_msg_count,
66: p_data => x_msg_data);
67:
68: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
64: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
65: FND_MSG_PUB.count_and_get(p_count => x_msg_count,
66: p_data => x_msg_data);
67:
68: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
69: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
70: FND_MSG_PUB.count_and_get(p_count => x_msg_count,
71: p_data => x_msg_data);
72:
65: FND_MSG_PUB.count_and_get(p_count => x_msg_count,
66: p_data => x_msg_data);
67:
68: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
69: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
70: FND_MSG_PUB.count_and_get(p_count => x_msg_count,
71: p_data => x_msg_data);
72:
73: WHEN OTHERS THEN
70: FND_MSG_PUB.count_and_get(p_count => x_msg_count,
71: p_data => x_msg_data);
72:
73: WHEN OTHERS THEN
74: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
75: FND_MSG_PUB.ADD_EXC_MSG('OKL_ASSET_DETAILS_PUB','Update_Year');
76: FND_MSG_PUB.count_and_get(p_count => x_msg_count,
77: p_data => x_msg_data);
78:
124: x_rule_information2 => x_rule_information2,
125: x_rule_information3 => x_rule_information3,
126: x_rule_information4 => x_rule_information4);
127:
128: IF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
129: RAISE OKL_API.G_EXCEPTION_ERROR;
130: ELSIF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
131: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
132: END IF;
125: x_rule_information3 => x_rule_information3,
126: x_rule_information4 => x_rule_information4);
127:
128: IF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
129: RAISE OKL_API.G_EXCEPTION_ERROR;
130: ELSIF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
131: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
132: END IF;
133:
126: x_rule_information4 => x_rule_information4);
127:
128: IF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
129: RAISE OKL_API.G_EXCEPTION_ERROR;
130: ELSIF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
131: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
132: END IF;
133:
134: --End Call to Private API
127:
128: IF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
129: RAISE OKL_API.G_EXCEPTION_ERROR;
130: ELSIF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
131: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
132: END IF;
133:
134: --End Call to Private API
135:
148: x_msg_data := l_msg_data;
149:
150: EXCEPTION
151:
152: WHEN OKL_API.G_EXCEPTION_ERROR THEN
153: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
154: FND_MSG_PUB.count_and_get(p_count => x_msg_count,
155: p_data => x_msg_data);
156:
149:
150: EXCEPTION
151:
152: WHEN OKL_API.G_EXCEPTION_ERROR THEN
153: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
154: FND_MSG_PUB.count_and_get(p_count => x_msg_count,
155: p_data => x_msg_data);
156:
157: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
153: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
154: FND_MSG_PUB.count_and_get(p_count => x_msg_count,
155: p_data => x_msg_data);
156:
157: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
158: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
159: FND_MSG_PUB.count_and_get(p_count => x_msg_count,
160: p_data => x_msg_data);
161:
154: FND_MSG_PUB.count_and_get(p_count => x_msg_count,
155: p_data => x_msg_data);
156:
157: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
158: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
159: FND_MSG_PUB.count_and_get(p_count => x_msg_count,
160: p_data => x_msg_data);
161:
162: WHEN OTHERS THEN
159: FND_MSG_PUB.count_and_get(p_count => x_msg_count,
160: p_data => x_msg_data);
161:
162: WHEN OTHERS THEN
163: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
164: FND_MSG_PUB.ADD_EXC_MSG('OKL_ASSET_DETAILS_PUB','Update_Tax');
165: FND_MSG_PUB.count_and_get(p_count => x_msg_count,
166: p_data => x_msg_data);
167:
201: px_asset_desc => px_asset_desc,
202: px_model_no => px_model_no,
203: px_manufacturer => px_manufacturer);
204:
205: IF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
206: RAISE OKL_API.G_EXCEPTION_ERROR;
207: ELSIF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
208: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
209: END IF;
202: px_model_no => px_model_no,
203: px_manufacturer => px_manufacturer);
204:
205: IF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
206: RAISE OKL_API.G_EXCEPTION_ERROR;
207: ELSIF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
208: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
209: END IF;
210:
203: px_manufacturer => px_manufacturer);
204:
205: IF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
206: RAISE OKL_API.G_EXCEPTION_ERROR;
207: ELSIF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
208: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
209: END IF;
210:
211: --End Call to Private API
204:
205: IF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
206: RAISE OKL_API.G_EXCEPTION_ERROR;
207: ELSIF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
208: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
209: END IF;
210:
211: --End Call to Private API
212:
225: x_msg_data := l_msg_data;
226:
227: EXCEPTION
228:
229: WHEN OKL_API.G_EXCEPTION_ERROR THEN
230: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
231: FND_MSG_PUB.count_and_get(p_count => x_msg_count,
232: p_data => x_msg_data);
233:
226:
227: EXCEPTION
228:
229: WHEN OKL_API.G_EXCEPTION_ERROR THEN
230: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
231: FND_MSG_PUB.count_and_get(p_count => x_msg_count,
232: p_data => x_msg_data);
233:
234: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
230: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
231: FND_MSG_PUB.count_and_get(p_count => x_msg_count,
232: p_data => x_msg_data);
233:
234: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
235: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
236: FND_MSG_PUB.count_and_get(p_count => x_msg_count,
237: p_data => x_msg_data);
238:
231: FND_MSG_PUB.count_and_get(p_count => x_msg_count,
232: p_data => x_msg_data);
233:
234: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
235: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
236: FND_MSG_PUB.count_and_get(p_count => x_msg_count,
237: p_data => x_msg_data);
238:
239: WHEN OTHERS THEN
236: FND_MSG_PUB.count_and_get(p_count => x_msg_count,
237: p_data => x_msg_data);
238:
239: WHEN OTHERS THEN
240: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
241: FND_MSG_PUB.ADD_EXC_MSG('OKL_ASSET_DETAILS_PUB','Update_Asset');
242: FND_MSG_PUB.count_and_get(p_count => x_msg_count,
243: p_data => x_msg_data);
244: