eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKL_CS_PRINCIPAL_PAYDOWN_PUB dependencies on OKL_API

Line 39: IF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN

35: x_return_status => l_return_status,
36: x_msg_count => l_msg_count,
37: x_msg_data => l_msg_data);
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;

Line 40: RAISE OKL_API.G_EXCEPTION_ERROR;

36: x_msg_count => l_msg_count,
37: x_msg_data => l_msg_data);
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:

Line 41: ELSIF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

37: x_msg_data => l_msg_data);
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 Process API--------------

Line 42: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

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 Process API--------------
46:

Line 59: WHEN OKL_API.G_EXCEPTION_ERROR THEN

55: x_msg_data := l_msg_data;
56:
57: EXCEPTION
58:
59: WHEN OKL_API.G_EXCEPTION_ERROR THEN
60:
61: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
62: FND_MSG_PUB.count_and_get(p_count => x_msg_count,
63: p_data => x_msg_data);

Line 61: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;

57: EXCEPTION
58:
59: WHEN OKL_API.G_EXCEPTION_ERROR THEN
60:
61: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
62: FND_MSG_PUB.count_and_get(p_count => x_msg_count,
63: p_data => x_msg_data);
64:
65: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 65: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

61: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
62: FND_MSG_PUB.count_and_get(p_count => x_msg_count,
63: p_data => x_msg_data);
64:
65: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
66:
67: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
68: FND_MSG_PUB.count_and_get(p_count => x_msg_count,
69: p_data => x_msg_data);

Line 67: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;

63: p_data => x_msg_data);
64:
65: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
66:
67: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
68: FND_MSG_PUB.count_and_get(p_count => x_msg_count,
69: p_data => x_msg_data);
70:
71: WHEN OTHERS THEN

Line 73: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;

69: p_data => x_msg_data);
70:
71: WHEN OTHERS THEN
72:
73: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
74: FND_MSG_PUB.ADD_EXC_MSG('okl_cs_principal_paydown_PUB','create_working_copy');
75: FND_MSG_PUB.count_and_get(p_count => x_msg_count,
76: p_data => x_msg_data);
77:

Line 113: IF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN

109: x_msg_data => l_msg_data,
110: p_trqv_tbl => p_trqv_tbl,
111: x_trqv_tbl => x_trqv_tbl);
112:
113: IF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
114: RAISE OKL_API.G_EXCEPTION_ERROR;
115: ELSIF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
116: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
117: END IF;

Line 114: RAISE OKL_API.G_EXCEPTION_ERROR;

110: p_trqv_tbl => p_trqv_tbl,
111: x_trqv_tbl => x_trqv_tbl);
112:
113: IF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
114: RAISE OKL_API.G_EXCEPTION_ERROR;
115: ELSIF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
116: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
117: END IF;
118:

Line 115: ELSIF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

111: x_trqv_tbl => x_trqv_tbl);
112:
113: IF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
114: RAISE OKL_API.G_EXCEPTION_ERROR;
115: ELSIF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
116: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
117: END IF;
118:
119: ------------ End Call to Private Process API--------------

Line 116: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

112:
113: IF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
114: RAISE OKL_API.G_EXCEPTION_ERROR;
115: ELSIF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
116: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
117: END IF;
118:
119: ------------ End Call to Private Process API--------------
120:

Line 133: WHEN OKL_API.G_EXCEPTION_ERROR THEN

129: x_msg_data := l_msg_data;
130:
131: EXCEPTION
132:
133: WHEN OKL_API.G_EXCEPTION_ERROR THEN
134:
135: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
136: FND_MSG_PUB.count_and_get(p_count => x_msg_count,
137: p_data => x_msg_data);

Line 135: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;

131: EXCEPTION
132:
133: WHEN OKL_API.G_EXCEPTION_ERROR THEN
134:
135: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
136: FND_MSG_PUB.count_and_get(p_count => x_msg_count,
137: p_data => x_msg_data);
138:
139: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 139: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

135: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
136: FND_MSG_PUB.count_and_get(p_count => x_msg_count,
137: p_data => x_msg_data);
138:
139: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
140:
141: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
142: FND_MSG_PUB.count_and_get(p_count => x_msg_count,
143: p_data => x_msg_data);

Line 141: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;

137: p_data => x_msg_data);
138:
139: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
140:
141: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
142: FND_MSG_PUB.count_and_get(p_count => x_msg_count,
143: p_data => x_msg_data);
144:
145: WHEN OTHERS THEN

Line 147: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;

143: p_data => x_msg_data);
144:
145: WHEN OTHERS THEN
146:
147: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
148: FND_MSG_PUB.ADD_EXC_MSG('okl_cs_principal_paydown_PUB','calculate');
149: FND_MSG_PUB.count_and_get(p_count => x_msg_count,
150: p_data => x_msg_data);
151:

Line 186: IF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN

182: x_msg_data => l_msg_data,
183: p_trqv_rec => p_trqv_rec,
184: x_trqv_rec => x_trqv_rec);
185:
186: IF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
187: RAISE OKL_API.G_EXCEPTION_ERROR;
188: ELSIF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
189: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
190: END IF;

Line 187: RAISE OKL_API.G_EXCEPTION_ERROR;

183: p_trqv_rec => p_trqv_rec,
184: x_trqv_rec => x_trqv_rec);
185:
186: IF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
187: RAISE OKL_API.G_EXCEPTION_ERROR;
188: ELSIF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
189: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
190: END IF;
191:

Line 188: ELSIF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

184: x_trqv_rec => x_trqv_rec);
185:
186: IF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
187: RAISE OKL_API.G_EXCEPTION_ERROR;
188: ELSIF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
189: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
190: END IF;
191:
192: ------------ End Call to Private Process API--------------

Line 189: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

185:
186: IF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
187: RAISE OKL_API.G_EXCEPTION_ERROR;
188: ELSIF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
189: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
190: END IF;
191:
192: ------------ End Call to Private Process API--------------
193:

Line 206: WHEN OKL_API.G_EXCEPTION_ERROR THEN

202: x_msg_data := l_msg_data;
203:
204: EXCEPTION
205:
206: WHEN OKL_API.G_EXCEPTION_ERROR THEN
207:
208: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
209: FND_MSG_PUB.count_and_get(p_count => x_msg_count,
210: p_data => x_msg_data);

Line 208: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;

204: EXCEPTION
205:
206: WHEN OKL_API.G_EXCEPTION_ERROR THEN
207:
208: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
209: FND_MSG_PUB.count_and_get(p_count => x_msg_count,
210: p_data => x_msg_data);
211:
212: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 212: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

208: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
209: FND_MSG_PUB.count_and_get(p_count => x_msg_count,
210: p_data => x_msg_data);
211:
212: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
213:
214: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
215: FND_MSG_PUB.count_and_get(p_count => x_msg_count,
216: p_data => x_msg_data);

Line 214: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;

210: p_data => x_msg_data);
211:
212: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
213:
214: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
215: FND_MSG_PUB.count_and_get(p_count => x_msg_count,
216: p_data => x_msg_data);
217:
218: WHEN OTHERS THEN

Line 220: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;

216: p_data => x_msg_data);
217:
218: WHEN OTHERS THEN
219:
220: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
221: FND_MSG_PUB.ADD_EXC_MSG('okl_cs_principal_paydown_PUB','update_ppd_request');
222: FND_MSG_PUB.count_and_get(p_count => x_msg_count,
223: p_data => x_msg_data);
224:

Line 263: IF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN

259: x_return_status => l_return_status,
260: x_msg_count => l_msg_count,
261: x_msg_data => l_msg_data);
262:
263: IF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
264: RAISE OKL_API.G_EXCEPTION_ERROR;
265: ELSIF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
266: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
267: END IF;

Line 264: RAISE OKL_API.G_EXCEPTION_ERROR;

260: x_msg_count => l_msg_count,
261: x_msg_data => l_msg_data);
262:
263: IF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
264: RAISE OKL_API.G_EXCEPTION_ERROR;
265: ELSIF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
266: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
267: END IF;
268:

Line 265: ELSIF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

261: x_msg_data => l_msg_data);
262:
263: IF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
264: RAISE OKL_API.G_EXCEPTION_ERROR;
265: ELSIF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
266: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
267: END IF;
268:
269: ------------ End Call to Private Process API--------------

Line 266: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

262:
263: IF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
264: RAISE OKL_API.G_EXCEPTION_ERROR;
265: ELSIF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
266: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
267: END IF;
268:
269: ------------ End Call to Private Process API--------------
270:

Line 283: WHEN OKL_API.G_EXCEPTION_ERROR THEN

279: x_msg_data := l_msg_data;
280:
281: EXCEPTION
282:
283: WHEN OKL_API.G_EXCEPTION_ERROR THEN
284:
285: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
286: FND_MSG_PUB.count_and_get(p_count => x_msg_count,
287: p_data => x_msg_data);

Line 285: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;

281: EXCEPTION
282:
283: WHEN OKL_API.G_EXCEPTION_ERROR THEN
284:
285: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
286: FND_MSG_PUB.count_and_get(p_count => x_msg_count,
287: p_data => x_msg_data);
288:
289: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 289: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

285: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
286: FND_MSG_PUB.count_and_get(p_count => x_msg_count,
287: p_data => x_msg_data);
288:
289: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
290:
291: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
292: FND_MSG_PUB.count_and_get(p_count => x_msg_count,
293: p_data => x_msg_data);

Line 291: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;

287: p_data => x_msg_data);
288:
289: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
290:
291: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
292: FND_MSG_PUB.count_and_get(p_count => x_msg_count,
293: p_data => x_msg_data);
294:
295: WHEN OTHERS THEN

Line 297: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;

293: p_data => x_msg_data);
294:
295: WHEN OTHERS THEN
296:
297: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
298: FND_MSG_PUB.ADD_EXC_MSG('okl_cs_principal_paydown_PUB','create_ppd_invoice');
299: FND_MSG_PUB.count_and_get(p_count => x_msg_count,
300: p_data => x_msg_data);
301:

Line 330: IF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN

326: x_msg_count => l_msg_count,
327: x_msg_data => l_msg_data,
328: p_khr_id => p_khr_id);
329:
330: IF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
331: RAISE OKL_API.G_EXCEPTION_ERROR;
332: ELSIF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
333: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
334: END IF;

Line 331: RAISE OKL_API.G_EXCEPTION_ERROR;

327: x_msg_data => l_msg_data,
328: p_khr_id => p_khr_id);
329:
330: IF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
331: RAISE OKL_API.G_EXCEPTION_ERROR;
332: ELSIF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
333: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
334: END IF;
335:

Line 332: ELSIF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

328: p_khr_id => p_khr_id);
329:
330: IF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
331: RAISE OKL_API.G_EXCEPTION_ERROR;
332: ELSIF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
333: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
334: END IF;
335:
336: ------------ End Call to Private Process API--------------

Line 333: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

329:
330: IF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
331: RAISE OKL_API.G_EXCEPTION_ERROR;
332: ELSIF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
333: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
334: END IF;
335:
336: ------------ End Call to Private Process API--------------
337: x_return_status := l_return_status;

Line 343: WHEN OKL_API.G_EXCEPTION_ERROR THEN

339: x_msg_data := l_msg_data;
340:
341: EXCEPTION
342:
343: WHEN OKL_API.G_EXCEPTION_ERROR THEN
344:
345: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
346: FND_MSG_PUB.count_and_get(p_count => x_msg_count,
347: p_data => x_msg_data);

Line 345: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;

341: EXCEPTION
342:
343: WHEN OKL_API.G_EXCEPTION_ERROR THEN
344:
345: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
346: FND_MSG_PUB.count_and_get(p_count => x_msg_count,
347: p_data => x_msg_data);
348:
349: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 349: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

345: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
346: FND_MSG_PUB.count_and_get(p_count => x_msg_count,
347: p_data => x_msg_data);
348:
349: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
350:
351: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
352: FND_MSG_PUB.count_and_get(p_count => x_msg_count,
353: p_data => x_msg_data);

Line 351: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;

347: p_data => x_msg_data);
348:
349: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
350:
351: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
352: FND_MSG_PUB.count_and_get(p_count => x_msg_count,
353: p_data => x_msg_data);
354:
355: WHEN OTHERS THEN

Line 357: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;

353: p_data => x_msg_data);
354:
355: WHEN OTHERS THEN
356:
357: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
358: FND_MSG_PUB.ADD_EXC_MSG('OKL_CS_PRINCIPAL_PAYDOWN_PUB','cancel_ppd');
359: FND_MSG_PUB.count_and_get(p_count => x_msg_count,
360: p_data => x_msg_data);
361: END cancel_ppd;

Line 389: IF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN

385: x_msg_data => l_msg_data,
386: p_khr_id => p_khr_id,
387: p_trx_id => p_trx_id);
388:
389: IF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
390: RAISE OKL_API.G_EXCEPTION_ERROR;
391: ELSIF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
392: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
393: END IF;

Line 390: RAISE OKL_API.G_EXCEPTION_ERROR;

386: p_khr_id => p_khr_id,
387: p_trx_id => p_trx_id);
388:
389: IF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
390: RAISE OKL_API.G_EXCEPTION_ERROR;
391: ELSIF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
392: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
393: END IF;
394:

Line 391: ELSIF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

387: p_trx_id => p_trx_id);
388:
389: IF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
390: RAISE OKL_API.G_EXCEPTION_ERROR;
391: ELSIF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
392: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
393: END IF;
394:
395: ------------ End Call to Private Process API--------------

Line 392: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

388:
389: IF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
390: RAISE OKL_API.G_EXCEPTION_ERROR;
391: ELSIF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
392: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
393: END IF;
394:
395: ------------ End Call to Private Process API--------------
396: x_return_status := l_return_status;

Line 402: WHEN OKL_API.G_EXCEPTION_ERROR THEN

398: x_msg_data := l_msg_data;
399:
400: EXCEPTION
401:
402: WHEN OKL_API.G_EXCEPTION_ERROR THEN
403:
404: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
405: FND_MSG_PUB.count_and_get(p_count => x_msg_count,
406: p_data => x_msg_data);

Line 404: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;

400: EXCEPTION
401:
402: WHEN OKL_API.G_EXCEPTION_ERROR THEN
403:
404: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
405: FND_MSG_PUB.count_and_get(p_count => x_msg_count,
406: p_data => x_msg_data);
407:
408: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 408: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

404: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
405: FND_MSG_PUB.count_and_get(p_count => x_msg_count,
406: p_data => x_msg_data);
407:
408: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
409:
410: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
411: FND_MSG_PUB.count_and_get(p_count => x_msg_count,
412: p_data => x_msg_data);

Line 410: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;

406: p_data => x_msg_data);
407:
408: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
409:
410: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
411: FND_MSG_PUB.count_and_get(p_count => x_msg_count,
412: p_data => x_msg_data);
413:
414: WHEN OTHERS THEN

Line 416: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;

412: p_data => x_msg_data);
413:
414: WHEN OTHERS THEN
415:
416: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
417: FND_MSG_PUB.ADD_EXC_MSG('OKL_CS_PRINCIPAL_PAYDOWN_PUB','invoice_apply_ppd');
418: FND_MSG_PUB.count_and_get(p_count => x_msg_count,
419: p_data => x_msg_data);
420: END invoice_apply_ppd;

Line 446: IF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN

442: x_msg_count => l_msg_count,
443: x_msg_data => l_msg_data,
444: p_ppd_request_id => p_ppd_request_id);
445:
446: IF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
447: RAISE OKL_API.G_EXCEPTION_ERROR;
448: ELSIF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
449: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
450: END IF;

Line 447: RAISE OKL_API.G_EXCEPTION_ERROR;

443: x_msg_data => l_msg_data,
444: p_ppd_request_id => p_ppd_request_id);
445:
446: IF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
447: RAISE OKL_API.G_EXCEPTION_ERROR;
448: ELSIF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
449: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
450: END IF;
451:

Line 448: ELSIF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

444: p_ppd_request_id => p_ppd_request_id);
445:
446: IF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
447: RAISE OKL_API.G_EXCEPTION_ERROR;
448: ELSIF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
449: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
450: END IF;
451:
452: ------------ End Call to Private Process API--------------

Line 449: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

445:
446: IF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
447: RAISE OKL_API.G_EXCEPTION_ERROR;
448: ELSIF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
449: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
450: END IF;
451:
452: ------------ End Call to Private Process API--------------
453: x_return_status := l_return_status;

Line 459: WHEN OKL_API.G_EXCEPTION_ERROR THEN

455: x_msg_data := l_msg_data;
456:
457: EXCEPTION
458:
459: WHEN OKL_API.G_EXCEPTION_ERROR THEN
460:
461: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
462: FND_MSG_PUB.count_and_get(p_count => x_msg_count,
463: p_data => x_msg_data);

Line 461: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;

457: EXCEPTION
458:
459: WHEN OKL_API.G_EXCEPTION_ERROR THEN
460:
461: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
462: FND_MSG_PUB.count_and_get(p_count => x_msg_count,
463: p_data => x_msg_data);
464:
465: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 465: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

461: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
462: FND_MSG_PUB.count_and_get(p_count => x_msg_count,
463: p_data => x_msg_data);
464:
465: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
466:
467: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
468: FND_MSG_PUB.count_and_get(p_count => x_msg_count,
469: p_data => x_msg_data);

Line 467: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;

463: p_data => x_msg_data);
464:
465: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
466:
467: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
468: FND_MSG_PUB.count_and_get(p_count => x_msg_count,
469: p_data => x_msg_data);
470:
471: WHEN OTHERS THEN

Line 473: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;

469: p_data => x_msg_data);
470:
471: WHEN OTHERS THEN
472:
473: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
474: FND_MSG_PUB.ADD_EXC_MSG('OKL_CS_PRINCIPAL_PAYDOWN_PUB','process_ppd');
475: FND_MSG_PUB.count_and_get(p_count => x_msg_count,
476: p_data => x_msg_data);
477: END process_ppd;

Line 481: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

477: END process_ppd;
478:
479: PROCEDURE process_lpd(
480: p_api_version IN NUMBER,
481: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
482: x_return_status OUT NOCOPY VARCHAR2,
483: x_msg_count OUT NOCOPY NUMBER,
484: x_msg_data OUT NOCOPY VARCHAR2,
485: p_ppd_request_id IN NUMBER)

Line 502: IF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN

498: x_msg_count => l_msg_count,
499: x_msg_data => l_msg_data,
500: p_ppd_request_id => p_ppd_request_id);
501:
502: IF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
503: RAISE OKL_API.G_EXCEPTION_ERROR;
504: ELSIF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
505: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
506: END IF;

Line 503: RAISE OKL_API.G_EXCEPTION_ERROR;

499: x_msg_data => l_msg_data,
500: p_ppd_request_id => p_ppd_request_id);
501:
502: IF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
503: RAISE OKL_API.G_EXCEPTION_ERROR;
504: ELSIF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
505: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
506: END IF;
507:

Line 504: ELSIF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

500: p_ppd_request_id => p_ppd_request_id);
501:
502: IF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
503: RAISE OKL_API.G_EXCEPTION_ERROR;
504: ELSIF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
505: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
506: END IF;
507:
508: ------------ End Call to Private Process API--------------

Line 505: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

501:
502: IF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
503: RAISE OKL_API.G_EXCEPTION_ERROR;
504: ELSIF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
505: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
506: END IF;
507:
508: ------------ End Call to Private Process API--------------
509: x_return_status := l_return_status;

Line 515: WHEN OKL_API.G_EXCEPTION_ERROR THEN

511: x_msg_data := l_msg_data;
512:
513: EXCEPTION
514:
515: WHEN OKL_API.G_EXCEPTION_ERROR THEN
516:
517: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
518: FND_MSG_PUB.count_and_get(p_count => x_msg_count,
519: p_data => x_msg_data);

Line 517: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;

513: EXCEPTION
514:
515: WHEN OKL_API.G_EXCEPTION_ERROR THEN
516:
517: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
518: FND_MSG_PUB.count_and_get(p_count => x_msg_count,
519: p_data => x_msg_data);
520:
521: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 521: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

517: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
518: FND_MSG_PUB.count_and_get(p_count => x_msg_count,
519: p_data => x_msg_data);
520:
521: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
522:
523: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
524: FND_MSG_PUB.count_and_get(p_count => x_msg_count,
525: p_data => x_msg_data);

Line 523: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;

519: p_data => x_msg_data);
520:
521: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
522:
523: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
524: FND_MSG_PUB.count_and_get(p_count => x_msg_count,
525: p_data => x_msg_data);
526:
527: WHEN OTHERS THEN

Line 529: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;

525: p_data => x_msg_data);
526:
527: WHEN OTHERS THEN
528:
529: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
530: FND_MSG_PUB.ADD_EXC_MSG('OKL_CS_PRINCIPAL_PAYDOWN_PUB','process_ppd');
531: FND_MSG_PUB.count_and_get(p_count => x_msg_count,
532: p_data => x_msg_data);
533: END process_lpd;