41: px_clmv_tbl => l_clmv_tbl,
42: px_acdv_tbl => l_acdv_tbl,
43: px_acnv_tbl => l_acnv_tbl
44: );
45: IF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
46: x_return_status := l_return_status;
47: --return(l_return_status);
48: RAISE OKL_API.G_EXCEPTION_ERROR;
49: ELSIF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
44: );
45: IF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
46: x_return_status := l_return_status;
47: --return(l_return_status);
48: RAISE OKL_API.G_EXCEPTION_ERROR;
49: ELSIF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
50: x_return_status := l_return_status;
51: --return(l_return_status);
52: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
45: IF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
46: x_return_status := l_return_status;
47: --return(l_return_status);
48: RAISE OKL_API.G_EXCEPTION_ERROR;
49: ELSIF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
50: x_return_status := l_return_status;
51: --return(l_return_status);
52: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
53: END IF;
48: RAISE OKL_API.G_EXCEPTION_ERROR;
49: ELSIF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
50: x_return_status := l_return_status;
51: --return(l_return_status);
52: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
53: END IF;
54: ------------ End Call to Private Process API--------------
55:
56: px_clmv_tbl := l_clmv_tbl;
59: x_return_status := l_return_status;
60:
61: --return(l_return_status);
62: EXCEPTION
63: WHEN OKL_API.G_EXCEPTION_ERROR THEN
64: --ROLLBACK TO create_fulfillment;
65: l_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
66: FND_MSG_PUB.count_and_get(p_count => l_msg_count,
67: p_data => l_msg_data);
61: --return(l_return_status);
62: EXCEPTION
63: WHEN OKL_API.G_EXCEPTION_ERROR THEN
64: --ROLLBACK TO create_fulfillment;
65: l_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
66: FND_MSG_PUB.count_and_get(p_count => l_msg_count,
67: p_data => l_msg_data);
68: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
69: --ROLLBACK TO create_fulfillment;
64: --ROLLBACK TO create_fulfillment;
65: l_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
66: FND_MSG_PUB.count_and_get(p_count => l_msg_count,
67: p_data => l_msg_data);
68: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
69: --ROLLBACK TO create_fulfillment;
70: l_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
71: FND_MSG_PUB.count_and_get(p_count => l_msg_count,
72: p_data => l_msg_data);
66: FND_MSG_PUB.count_and_get(p_count => l_msg_count,
67: p_data => l_msg_data);
68: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
69: --ROLLBACK TO create_fulfillment;
70: l_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
71: FND_MSG_PUB.count_and_get(p_count => l_msg_count,
72: p_data => l_msg_data);
73: WHEN OTHERS THEN
74: --ROLLBACK TO create_fulfillment;
71: FND_MSG_PUB.count_and_get(p_count => l_msg_count,
72: p_data => l_msg_data);
73: WHEN OTHERS THEN
74: --ROLLBACK TO create_fulfillment;
75: l_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
76: FND_MSG_PUB.ADD_EXC_MSG('OKL_INS_CLAIM_ASSET_PUB','create_lease_claim');
77: FND_MSG_PUB.count_and_get(p_count => l_msg_count,
78: p_data => l_msg_data);
79: x_return_status:=l_return_status;
110: x_msg_count => l_msg_count,
111: x_msg_data => l_msg_data,
112: p_lsm_id => l_lsm_id
113: );
114: IF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
115: x_return_status := l_return_status;
116: --return(l_return_status);
117: RAISE OKL_API.G_EXCEPTION_ERROR;
118: ELSIF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
113: );
114: IF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
115: x_return_status := l_return_status;
116: --return(l_return_status);
117: RAISE OKL_API.G_EXCEPTION_ERROR;
118: ELSIF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
119: x_return_status := l_return_status;
120: --return(l_return_status);
121: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
114: IF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
115: x_return_status := l_return_status;
116: --return(l_return_status);
117: RAISE OKL_API.G_EXCEPTION_ERROR;
118: ELSIF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
119: x_return_status := l_return_status;
120: --return(l_return_status);
121: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
122: END IF;
117: RAISE OKL_API.G_EXCEPTION_ERROR;
118: ELSIF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
119: x_return_status := l_return_status;
120: --return(l_return_status);
121: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
122: END IF;
123: ------------ End Call to Private Process API--------------
124: x_return_status := l_return_status;
125: --return(l_return_status);
123: ------------ End Call to Private Process API--------------
124: x_return_status := l_return_status;
125: --return(l_return_status);
126: EXCEPTION
127: WHEN OKL_API.G_EXCEPTION_ERROR THEN
128: --ROLLBACK TO create_fulfillment;
129: l_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
130: FND_MSG_PUB.count_and_get(p_count => l_msg_count,
131: p_data => l_msg_data);
125: --return(l_return_status);
126: EXCEPTION
127: WHEN OKL_API.G_EXCEPTION_ERROR THEN
128: --ROLLBACK TO create_fulfillment;
129: l_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
130: FND_MSG_PUB.count_and_get(p_count => l_msg_count,
131: p_data => l_msg_data);
132: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
133: --ROLLBACK TO create_fulfillment;
128: --ROLLBACK TO create_fulfillment;
129: l_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
130: FND_MSG_PUB.count_and_get(p_count => l_msg_count,
131: p_data => l_msg_data);
132: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
133: --ROLLBACK TO create_fulfillment;
134: l_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
135: FND_MSG_PUB.count_and_get(p_count => l_msg_count,
136: p_data => l_msg_data);
130: FND_MSG_PUB.count_and_get(p_count => l_msg_count,
131: p_data => l_msg_data);
132: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
133: --ROLLBACK TO create_fulfillment;
134: l_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
135: FND_MSG_PUB.count_and_get(p_count => l_msg_count,
136: p_data => l_msg_data);
137: WHEN OTHERS THEN
138: --ROLLBACK TO create_fulfillment;
135: FND_MSG_PUB.count_and_get(p_count => l_msg_count,
136: p_data => l_msg_data);
137: WHEN OTHERS THEN
138: --ROLLBACK TO create_fulfillment;
139: l_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
140: FND_MSG_PUB.ADD_EXC_MSG('OKL_INS_CLAIM_ASSET_PUB','hold_streams');
141: FND_MSG_PUB.count_and_get(p_count => l_msg_count,
142: p_data => l_msg_data);
143: x_return_status := l_return_status;