34: ------------------------------------------------------------
35: -- Start processing
36: ------------------------------------------------------------
37:
38: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
39:
40:
41:
42:
53: ,x_trans_status => l_trans_status);
54:
55:
56:
57: IF ( x_return_status = Fnd_Api.G_RET_STS_ERROR ) THEN
58: RAISE Fnd_Api.G_EXC_ERROR;
59: ELSIF (X_return_status = Fnd_Api.G_RET_STS_UNEXP_ERROR ) THEN
60: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
61: END IF;
54:
55:
56:
57: IF ( x_return_status = Fnd_Api.G_RET_STS_ERROR ) THEN
58: RAISE Fnd_Api.G_EXC_ERROR;
59: ELSIF (X_return_status = Fnd_Api.G_RET_STS_UNEXP_ERROR ) THEN
60: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
61: END IF;
62:
55:
56:
57: IF ( x_return_status = Fnd_Api.G_RET_STS_ERROR ) THEN
58: RAISE Fnd_Api.G_EXC_ERROR;
59: ELSIF (X_return_status = Fnd_Api.G_RET_STS_UNEXP_ERROR ) THEN
60: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
61: END IF;
62:
63:
56:
57: IF ( x_return_status = Fnd_Api.G_RET_STS_ERROR ) THEN
58: RAISE Fnd_Api.G_EXC_ERROR;
59: ELSIF (X_return_status = Fnd_Api.G_RET_STS_UNEXP_ERROR ) THEN
60: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
61: END IF;
62:
63:
64:
63:
64:
65: EXCEPTION
66:
67: WHEN Fnd_Api.G_EXC_ERROR THEN
68: ROLLBACK TO VARIABLE_INTEREST;
69: x_return_status := Fnd_Api.G_RET_STS_ERROR;
70: x_msg_count := l_msg_count ;
71: x_msg_data := l_msg_data ;
65: EXCEPTION
66:
67: WHEN Fnd_Api.G_EXC_ERROR THEN
68: ROLLBACK TO VARIABLE_INTEREST;
69: x_return_status := Fnd_Api.G_RET_STS_ERROR;
70: x_msg_count := l_msg_count ;
71: x_msg_data := l_msg_data ;
72: Fnd_Msg_Pub.count_and_get(
73: p_count => x_msg_count
72: Fnd_Msg_Pub.count_and_get(
73: p_count => x_msg_count
74: ,p_data => x_msg_data);
75:
76: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
77: ROLLBACK TO VARIABLE_INTEREST;
78: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
79: x_msg_count := l_msg_count ;
80: x_msg_data := l_msg_data ;
74: ,p_data => x_msg_data);
75:
76: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
77: ROLLBACK TO VARIABLE_INTEREST;
78: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
79: x_msg_count := l_msg_count ;
80: x_msg_data := l_msg_data ;
81: Fnd_Msg_Pub.count_and_get(
82: p_count => x_msg_count
83: ,p_data => x_msg_data);
84:
85: WHEN OTHERS THEN
86: ROLLBACK TO VARIABLE_INTEREST;
87: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
88: x_msg_count := l_msg_count ;
89: x_msg_data := l_msg_data ;
90: Fnd_Msg_Pub.ADD_EXC_MSG('OKL_VARIABLE_INTEREST_PUB','VARIABLE_INTEREST');
91: Fnd_Msg_Pub.count_and_get(
121: ------------------------------------------------------------
122: -- Start processing
123: ------------------------------------------------------------
124:
125: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
126:
127:
128:
129:
157: END IF;
158: -- End of wraper code generated automatically by Debug code generator for OKL_VARIABLE_INTEREST_PVT.var_int_rent_level
159:
160:
161: IF ( x_return_status = Fnd_Api.G_RET_STS_ERROR ) THEN
162: RAISE Fnd_Api.G_EXC_ERROR;
163: ELSIF (X_return_status = Fnd_Api.G_RET_STS_UNEXP_ERROR ) THEN
164: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
165: END IF;
158: -- End of wraper code generated automatically by Debug code generator for OKL_VARIABLE_INTEREST_PVT.var_int_rent_level
159:
160:
161: IF ( x_return_status = Fnd_Api.G_RET_STS_ERROR ) THEN
162: RAISE Fnd_Api.G_EXC_ERROR;
163: ELSIF (X_return_status = Fnd_Api.G_RET_STS_UNEXP_ERROR ) THEN
164: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
165: END IF;
166:
159:
160:
161: IF ( x_return_status = Fnd_Api.G_RET_STS_ERROR ) THEN
162: RAISE Fnd_Api.G_EXC_ERROR;
163: ELSIF (X_return_status = Fnd_Api.G_RET_STS_UNEXP_ERROR ) THEN
164: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
165: END IF;
166:
167:
160:
161: IF ( x_return_status = Fnd_Api.G_RET_STS_ERROR ) THEN
162: RAISE Fnd_Api.G_EXC_ERROR;
163: ELSIF (X_return_status = Fnd_Api.G_RET_STS_UNEXP_ERROR ) THEN
164: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
165: END IF;
166:
167:
168:
167:
168:
169: EXCEPTION
170:
171: WHEN Fnd_Api.G_EXC_ERROR THEN
172: ROLLBACK TO VARIABLE_INTEREST;
173: x_return_status := Fnd_Api.G_RET_STS_ERROR;
174: x_msg_count := l_msg_count ;
175: x_msg_data := l_msg_data ;
169: EXCEPTION
170:
171: WHEN Fnd_Api.G_EXC_ERROR THEN
172: ROLLBACK TO VARIABLE_INTEREST;
173: x_return_status := Fnd_Api.G_RET_STS_ERROR;
174: x_msg_count := l_msg_count ;
175: x_msg_data := l_msg_data ;
176: Fnd_Msg_Pub.count_and_get(
177: p_count => x_msg_count
176: Fnd_Msg_Pub.count_and_get(
177: p_count => x_msg_count
178: ,p_data => x_msg_data);
179:
180: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
181: ROLLBACK TO VARIABLE_INTEREST;
182: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
183: x_msg_count := l_msg_count ;
184: x_msg_data := l_msg_data ;
178: ,p_data => x_msg_data);
179:
180: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
181: ROLLBACK TO VARIABLE_INTEREST;
182: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
183: x_msg_count := l_msg_count ;
184: x_msg_data := l_msg_data ;
185: Fnd_Msg_Pub.count_and_get(
186: p_count => x_msg_count
187: ,p_data => x_msg_data);
188:
189: WHEN OTHERS THEN
190: ROLLBACK TO VARIABLE_INTEREST;
191: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
192: x_msg_count := l_msg_count ;
193: x_msg_data := l_msg_data ;
194: Fnd_Msg_Pub.ADD_EXC_MSG('OKL_VARIABLE_INTEREST_PUB','VARIABLE_INTEREST');
195: Fnd_Msg_Pub.count_and_get(
245: END;
246: END IF;
247: -- End of wraper code generated automatically by Debug code generator for OKL_VARIABLE_INTEREST_PVT.VARIABLE_INTEREST
248:
249: IF ( x_return_status = Fnd_Api.G_RET_STS_ERROR ) THEN
250: RAISE Fnd_Api.G_EXC_ERROR;
251: ELSIF (X_return_status = Fnd_Api.G_RET_STS_UNEXP_ERROR ) THEN
252: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
253: END IF;
246: END IF;
247: -- End of wraper code generated automatically by Debug code generator for OKL_VARIABLE_INTEREST_PVT.VARIABLE_INTEREST
248:
249: IF ( x_return_status = Fnd_Api.G_RET_STS_ERROR ) THEN
250: RAISE Fnd_Api.G_EXC_ERROR;
251: ELSIF (X_return_status = Fnd_Api.G_RET_STS_UNEXP_ERROR ) THEN
252: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
253: END IF;
254:
247: -- End of wraper code generated automatically by Debug code generator for OKL_VARIABLE_INTEREST_PVT.VARIABLE_INTEREST
248:
249: IF ( x_return_status = Fnd_Api.G_RET_STS_ERROR ) THEN
250: RAISE Fnd_Api.G_EXC_ERROR;
251: ELSIF (X_return_status = Fnd_Api.G_RET_STS_UNEXP_ERROR ) THEN
252: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
253: END IF;
254:
255:
248:
249: IF ( x_return_status = Fnd_Api.G_RET_STS_ERROR ) THEN
250: RAISE Fnd_Api.G_EXC_ERROR;
251: ELSIF (X_return_status = Fnd_Api.G_RET_STS_UNEXP_ERROR ) THEN
252: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
253: END IF;
254:
255:
256:
255:
256:
257: EXCEPTION
258:
259: WHEN Fnd_Api.G_EXC_ERROR THEN
260: -- 4739869 commenting out the code to Rollback the transactions
261: -- ROLLBACK TO VARIABLE_INTEREST;
262: x_return_status := Fnd_Api.G_RET_STS_ERROR;
263: x_msg_count := l_msg_count ;
258:
259: WHEN Fnd_Api.G_EXC_ERROR THEN
260: -- 4739869 commenting out the code to Rollback the transactions
261: -- ROLLBACK TO VARIABLE_INTEREST;
262: x_return_status := Fnd_Api.G_RET_STS_ERROR;
263: x_msg_count := l_msg_count ;
264: x_msg_data := l_msg_data ;
265: Fnd_Msg_Pub.count_and_get(
266: p_count => x_msg_count
265: Fnd_Msg_Pub.count_and_get(
266: p_count => x_msg_count
267: ,p_data => x_msg_data);
268:
269: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
270: -- 4739869 commenting out the code to Rollback the transactions
271: -- ROLLBACK TO VARIABLE_INTEREST;
272: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
273: x_msg_count := l_msg_count ;
268:
269: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
270: -- 4739869 commenting out the code to Rollback the transactions
271: -- ROLLBACK TO VARIABLE_INTEREST;
272: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
273: x_msg_count := l_msg_count ;
274: x_msg_data := l_msg_data ;
275: Fnd_Msg_Pub.count_and_get(
276: p_count => x_msg_count
278:
279: WHEN OTHERS THEN
280: -- 4739869 commenting out the code to Rollback the transactions
281: -- ROLLBACK TO VARIABLE_INTEREST;
282: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
283: x_msg_count := l_msg_count ;
284: x_msg_data := l_msg_data ;
285: Fnd_Msg_Pub.ADD_EXC_MSG('OKL_VARIABLE_INTEREST_PUB','VARIABLE_INTEREST');
286: Fnd_Msg_Pub.count_and_get(
315: l_to_date := FND_DATE.CANONICAL_TO_DATE(p_to_date);
316: END IF;
317:
318: VARIABLE_INTEREST(p_api_version => l_api_vesrions,
319: p_init_msg_list => FND_API.G_FALSE,
320: x_return_status => lx_return_status,
321: x_msg_count => lx_msg_count,
322: x_msg_data => errbuf,
323: p_contract_number => p_contract_number,