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
66:
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
72:
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:
78: END create_working_copy;
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:
78: END create_working_copy;
79:
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
140:
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
146:
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:
152: END calculate;
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:
152: END calculate;
153:
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
213:
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
219:
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:
225: END update_ppd_request;
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:
225: END update_ppd_request;
226:
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
290:
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
296:
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:
302: END create_ppd_invoice;
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:
302: END create_ppd_invoice;
303:
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
350:
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
356:
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;
362:
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;
362:
363:
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
409:
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
415:
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;
421:
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;
421:
422:
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
466:
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
472:
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;
478:
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;
478:
479: PROCEDURE process_lpd(
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
522:
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
528:
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;
534:
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;
534:
535: END OKL_CS_PRINCIPAL_PAYDOWN_PUB;