DBA Data[Home] [Help]

APPS.OKL_VARIABLE_INTEREST_PUB dependencies on FND_API

Line 38: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;

34: ------------------------------------------------------------
35: -- Start processing
36: ------------------------------------------------------------
37:
38: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
39:
40:
41:
42:

Line 57: IF ( x_return_status = Fnd_Api.G_RET_STS_ERROR ) THEN

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;

Line 58: RAISE Fnd_Api.G_EXC_ERROR;

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:

Line 59: ELSIF (X_return_status = Fnd_Api.G_RET_STS_UNEXP_ERROR ) THEN

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:

Line 60: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;

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:

Line 67: WHEN Fnd_Api.G_EXC_ERROR THEN

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 ;

Line 69: x_return_status := Fnd_Api.G_RET_STS_ERROR;

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

Line 76: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN

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 ;

Line 78: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;

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

Line 87: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;

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(

Line 125: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;

121: ------------------------------------------------------------
122: -- Start processing
123: ------------------------------------------------------------
124:
125: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
126:
127:
128:
129:

Line 161: IF ( x_return_status = Fnd_Api.G_RET_STS_ERROR ) THEN

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;

Line 162: RAISE Fnd_Api.G_EXC_ERROR;

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:

Line 163: ELSIF (X_return_status = Fnd_Api.G_RET_STS_UNEXP_ERROR ) THEN

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:

Line 164: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;

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:

Line 171: WHEN Fnd_Api.G_EXC_ERROR THEN

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 ;

Line 173: x_return_status := Fnd_Api.G_RET_STS_ERROR;

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

Line 180: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN

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 ;

Line 182: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;

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

Line 191: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;

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(

Line 249: IF ( x_return_status = Fnd_Api.G_RET_STS_ERROR ) THEN

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;

Line 250: RAISE Fnd_Api.G_EXC_ERROR;

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:

Line 251: ELSIF (X_return_status = Fnd_Api.G_RET_STS_UNEXP_ERROR ) THEN

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:

Line 252: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;

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:

Line 259: WHEN Fnd_Api.G_EXC_ERROR THEN

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 ;

Line 262: x_return_status := Fnd_Api.G_RET_STS_ERROR;

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

Line 269: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN

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 ;

Line 272: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;

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

Line 282: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;

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(

Line 319: p_init_msg_list => FND_API.G_FALSE,

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,