[Home] [Help]
111: l_rent_sty,
112: l_return_status,
113: l_sty_id);
114:
115: IF l_sty_id IS NULL OR l_sty_id = OKL_API.G_MISS_NUM THEN
116: --message logging
117: IF (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
118: FND_LOG.STRING(FND_LOG.LEVEL_ERROR
119: ,'OKL_AM_SECURITIZATION_PVT.create_inv_khr_obligation'
120: ,'OKL_STREAMS_UTIL.get_primary_stream_type returned no values');
121: END IF;
122:
123: -- smoduga +++++++++ User Defined Streams -- end ++++++++++++++++
124: OKL_API.set_message(p_app_name => G_APP_NAME,
125: p_msg_name => G_INVALID_VALUE1,
126: p_token1 => 'COL_NAME',
127: p_token1_value => 'STY_ID');
128: RAISE OKL_API.G_EXCEPTION_ERROR;
124: OKL_API.set_message(p_app_name => G_APP_NAME,
125: p_msg_name => G_INVALID_VALUE1,
126: p_token1 => 'COL_NAME',
127: p_token1_value => 'STY_ID');
128: RAISE OKL_API.G_EXCEPTION_ERROR;
129: END IF;
130:
131: IF p_asset_rec.p_amount IS NOT NULL THEN
132: --message logging
146: ,x_formula_value => l_formula_amount
147: ,x_return_status => l_return_status);
148:
149: IF (l_return_status = G_RET_STS_UNEXP_ERROR) THEN
150: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
151: ELSIF (l_return_status = G_RET_STS_ERROR) THEN
152: RAISE OKL_API.G_EXCEPTION_ERROR;
153: END IF;
154: -- message logging
148:
149: IF (l_return_status = G_RET_STS_UNEXP_ERROR) THEN
150: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
151: ELSIF (l_return_status = G_RET_STS_ERROR) THEN
152: RAISE OKL_API.G_EXCEPTION_ERROR;
153: END IF;
154: -- message logging
155: IF (FND_LOG.LEVEL_STATEMENT >=
156: FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
207: ,x_stmv_rec => x_stmv_rec
208: ,x_selv_tbl => x_selv_tbl );
209:
210: IF (l_return_status = G_RET_STS_UNEXP_ERROR) THEN
211: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
212: ELSIF (l_return_status = G_RET_STS_ERROR) THEN
213: RAISE OKL_API.G_EXCEPTION_ERROR;
214: END IF;
215: --message logging
209:
210: IF (l_return_status = G_RET_STS_UNEXP_ERROR) THEN
211: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
212: ELSIF (l_return_status = G_RET_STS_ERROR) THEN
213: RAISE OKL_API.G_EXCEPTION_ERROR;
214: END IF;
215: --message logging
216: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
217: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT
230:
231: x_return_status := l_return_status;
232:
233: EXCEPTION
234: WHEN OKL_API.G_EXCEPTION_ERROR THEN
235:
236:
237: IF get_next_trx_val_csr%ISOPEN THEN
238: CLOSE get_next_trx_val_csr;
244: ,'OKL_AM_SECURITIZATION_PVT.create_inv_khr_obligation'
245: , 'Handled exception occured');
246: END IF;
247:
248: x_return_status := OKL_API.HANDLE_EXCEPTIONS
249: (
250: 'create_inv_khr_obligation',
251: G_PKG_NAME,
252: 'OKC_API.G_RET_STS_ERROR',
254: x_msg_data,
255: '_PVT'
256: );
257:
258: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
259:
260:
261: IF get_next_trx_val_csr%ISOPEN THEN
262: CLOSE get_next_trx_val_csr;
268: ,'OKL_AM_SECURITIZATION_PVT.create_inv_khr_obligation'
269: , 'Expected exception occured');
270: END IF;
271:
272: x_return_status := OKL_API.HANDLE_EXCEPTIONS
273: (
274: 'create_inv_khr_obligation',
275: G_PKG_NAME,
276: 'OKC_API.G_RET_STS_UNEXP_ERROR',
292: ,'OKL_AM_SECURITIZATION_PVT.create_inv_khr_obligation'
293: , 'When others exception occured');
294: END IF;
295:
296: OKL_API.set_message(p_app_name => g_app_name,
297: p_msg_name => g_unexpected_error,
298: p_token1 => g_sqlcode_token,
299: p_token1_value => sqlcode,
300: p_token2 => g_sqlerrm_token,
299: p_token1_value => sqlcode,
300: p_token2 => g_sqlerrm_token,
301: p_token2_value => sqlerrm);
302:
303: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
304:
305:
306: END create_inv_khr_obligation;
307: -- cklee R12 bug7164915/okl.h Bug 7009075 - Added - End
382: CURSOR get_next_trx_val_csr IS
383: SELECT okl_sif_seq.nextval
384: FROM dual;
385:
386: l_return_status VARCHAR2(3) := OKL_API.G_RET_STS_SUCCESS;
387: l_invdisbas_sty_id NUMBER;
388: l_rbkadj_sty_id NUMBER;
389: l_adj_amount NUMBER := 0;
390: l_adj_amount2 NUMBER := 0;
404: ,'OKL_AM_SECURITIZATION_PVT.do_disb_adjustments'
405: , 'START+');
406: END IF;
407:
408: l_return_status := OKL_API.start_activity(
409: p_api_name => l_api_name,
410: p_pkg_name => G_PKG_NAME,
411: p_init_msg_list => p_init_msg_list,
412: l_api_version => l_api_version,
414: p_api_type => G_API_TYPE,
415: x_return_status => l_return_status);
416:
417: IF (l_return_status = G_RET_STS_UNEXP_ERROR) THEN
418: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
419: ELSIF (l_return_status = G_RET_STS_ERROR) THEN
420: RAISE OKL_API.G_EXCEPTION_ERROR;
421: END IF;
422:
416:
417: IF (l_return_status = G_RET_STS_UNEXP_ERROR) THEN
418: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
419: ELSIF (l_return_status = G_RET_STS_ERROR) THEN
420: RAISE OKL_API.G_EXCEPTION_ERROR;
421: END IF;
422:
423: -- get disbursement amounts only when FULL TERMINATION
424: IF p_partial_yn = 'N' THEN
436: , 'get_primary_stream_type INVESTOR_DISB_ADJUSTMENT returns '||l_return_status);
437: END IF;
438:
439: IF (l_return_status = G_RET_STS_UNEXP_ERROR) THEN
440: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
441: ELSIF (l_return_status = G_RET_STS_ERROR) THEN
442: RAISE OKL_API.G_EXCEPTION_ERROR;
443: END IF;
444:
438:
439: IF (l_return_status = G_RET_STS_UNEXP_ERROR) THEN
440: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
441: ELSIF (l_return_status = G_RET_STS_ERROR) THEN
442: RAISE OKL_API.G_EXCEPTION_ERROR;
443: END IF;
444:
445: -- get investor rent disb basis stream purpose
446: OKL_STREAMS_UTIL.get_primary_stream_type(
455: , 'get_primary_stream_type INVESTOR_RENT_DISB_BASIS returns '||l_return_status);
456: END IF;
457:
458: IF (l_return_status = G_RET_STS_UNEXP_ERROR) THEN
459: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
460: ELSIF (l_return_status = G_RET_STS_ERROR) THEN
461: RAISE OKL_API.G_EXCEPTION_ERROR;
462: END IF;
463:
457:
458: IF (l_return_status = G_RET_STS_UNEXP_ERROR) THEN
459: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
460: ELSIF (l_return_status = G_RET_STS_ERROR) THEN
461: RAISE OKL_API.G_EXCEPTION_ERROR;
462: END IF;
463:
464: OPEN get_disb_streams_csr(
465: p_ia_id,
508: l_selv_tbl(1).se_line_number := 1;
509:
510: OKL_STREAMS_PUB.create_streams(
511: p_api_version => p_api_version
512: ,p_init_msg_list => OKL_API.G_FALSE
513: ,x_return_status => l_return_status
514: ,x_msg_count => x_msg_count
515: ,x_msg_data => x_msg_data
516: ,p_stmv_rec => l_stmv_rec
524: , 'create_streams returns '||l_return_status);
525: END IF;
526:
527: IF (l_return_status = G_RET_STS_UNEXP_ERROR) THEN
528: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
529: ELSIF (l_return_status = G_RET_STS_ERROR) THEN
530: RAISE OKL_API.G_EXCEPTION_ERROR;
531: END IF;
532:
526:
527: IF (l_return_status = G_RET_STS_UNEXP_ERROR) THEN
528: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
529: ELSIF (l_return_status = G_RET_STS_ERROR) THEN
530: RAISE OKL_API.G_EXCEPTION_ERROR;
531: END IF;
532:
533: END IF;
534: END IF;
534: END IF;
535:
536: x_return_status := l_return_status;
537:
538: OKL_API.end_activity(x_msg_count => x_msg_count
539: ,x_msg_data => x_msg_data);
540:
541: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
542: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION
624: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION
625: ,'OKL_AM_SECURITIZATION_PVT.do_disb_adjustments'
626: , 'When others exception occured');
627: END IF;
628: OKL_API.set_message(p_app_name => g_app_name,
629: p_msg_name => g_unexpected_error,
630: p_token1 => g_sqlcode_token,
631: p_token1_value => sqlcode,
632: p_token2 => g_sqlerrm_token,
631: p_token1_value => sqlcode,
632: p_token2 => g_sqlerrm_token,
633: p_token2_value => sqlerrm);
634:
635: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
636:
637: END;
638: -- gboomina Bug 4775555 - End
639:
708: CURSOR get_next_trx_val_csr IS
709: SELECT okl_sif_seq.nextval
710: FROM dual;
711:
712: l_return_status VARCHAR2(3) := OKL_API.G_RET_STS_SUCCESS;
713: l_invdisbas_sty_id NUMBER;
714: l_intdisbas_sty_id NUMBER;
715: l_rbkadj_sty_id NUMBER;
716: l_adj_amount NUMBER := 0;
731: ,'OKL_AM_SECURITIZATION_PVT.do_disb_adjustments_loan'
732: , 'START+');
733: END IF;
734:
735: l_return_status := OKL_API.start_activity(
736: p_api_name => l_api_name,
737: p_pkg_name => G_PKG_NAME,
738: p_init_msg_list => p_init_msg_list,
739: l_api_version => l_api_version,
741: p_api_type => G_API_TYPE,
742: x_return_status => l_return_status);
743:
744: IF (l_return_status = G_RET_STS_UNEXP_ERROR) THEN
745: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
746: ELSIF (l_return_status = G_RET_STS_ERROR) THEN
747: RAISE OKL_API.G_EXCEPTION_ERROR;
748: END IF;
749:
743:
744: IF (l_return_status = G_RET_STS_UNEXP_ERROR) THEN
745: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
746: ELSIF (l_return_status = G_RET_STS_ERROR) THEN
747: RAISE OKL_API.G_EXCEPTION_ERROR;
748: END IF;
749:
750: -- get disbursement amounts only when FULL TERMINATION
751: IF p_partial_yn = 'N' THEN
763: , 'get_primary_stream_type INVESTOR_DISB_ADJUSTMENT returns '||l_return_status);
764: END IF;
765:
766: IF (l_return_status = G_RET_STS_UNEXP_ERROR) THEN
767: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
768: ELSIF (l_return_status = G_RET_STS_ERROR) THEN
769: RAISE OKL_API.G_EXCEPTION_ERROR;
770: END IF;
771:
765:
766: IF (l_return_status = G_RET_STS_UNEXP_ERROR) THEN
767: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
768: ELSIF (l_return_status = G_RET_STS_ERROR) THEN
769: RAISE OKL_API.G_EXCEPTION_ERROR;
770: END IF;
771:
772: -- get investor investor disb basis stream purpose
773: OKL_STREAMS_UTIL.get_primary_stream_type(
788: , 'get_primary_stream_type INVESTOR_RENT_DISB_BASIS returns '||l_return_status);
789: END IF;
790:
791: IF (l_return_status = G_RET_STS_UNEXP_ERROR) THEN
792: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
793: ELSIF (l_return_status = G_RET_STS_ERROR) THEN
794: RAISE OKL_API.G_EXCEPTION_ERROR;
795: END IF;
796:
790:
791: IF (l_return_status = G_RET_STS_UNEXP_ERROR) THEN
792: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
793: ELSIF (l_return_status = G_RET_STS_ERROR) THEN
794: RAISE OKL_API.G_EXCEPTION_ERROR;
795: END IF;
796:
797: OPEN get_disb_streams_csr(
798: p_ia_id,
843: l_selv_tbl(1).se_line_number := 1;
844:
845: OKL_STREAMS_PUB.create_streams(
846: p_api_version => p_api_version
847: ,p_init_msg_list => OKL_API.G_FALSE
848: ,x_return_status => l_return_status
849: ,x_msg_count => x_msg_count
850: ,x_msg_data => x_msg_data
851: ,p_stmv_rec => l_stmv_rec
859: , 'create_streams returns '||l_return_status);
860: END IF;
861:
862: IF (l_return_status = G_RET_STS_UNEXP_ERROR) THEN
863: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
864: ELSIF (l_return_status = G_RET_STS_ERROR) THEN
865: RAISE OKL_API.G_EXCEPTION_ERROR;
866: END IF;
867:
861:
862: IF (l_return_status = G_RET_STS_UNEXP_ERROR) THEN
863: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
864: ELSIF (l_return_status = G_RET_STS_ERROR) THEN
865: RAISE OKL_API.G_EXCEPTION_ERROR;
866: END IF;
867:
868: END IF;
869: END IF;
869: END IF;
870:
871: x_return_status := l_return_status;
872:
873: OKL_API.end_activity(x_msg_count => x_msg_count
874: ,x_msg_data => x_msg_data);
875:
876: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
877: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION
959: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION
960: ,'OKL_AM_SECURITIZATION_PVT.do_disb_adjustments_loan'
961: , 'When others exception occured');
962: END IF;
963: OKL_API.set_message(p_app_name => g_app_name,
964: p_msg_name => g_unexpected_error,
965: p_token1 => g_sqlcode_token,
966: p_token1_value => sqlcode,
967: p_token2 => g_sqlerrm_token,
966: p_token1_value => sqlcode,
967: p_token2 => g_sqlerrm_token,
968: p_token2_value => sqlerrm);
969:
970: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
971:
972: END;
973: /* sosharma end changes*/
974:
1213: --message logging
1214: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1215: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT
1216: ,'OKL_AM_SECURITIZATION_PVT.process_securitized_streams'
1217: ,'calling Okl_Api.START_ACTIVITY');
1218: END IF;
1219:
1220: -- Check API version, initialize message list and create savepoint.
1221: l_return_status := Okl_Api.START_ACTIVITY(
1217: ,'calling Okl_Api.START_ACTIVITY');
1218: END IF;
1219:
1220: -- Check API version, initialize message list and create savepoint.
1221: l_return_status := Okl_Api.START_ACTIVITY(
1222: p_api_name => l_api_name,
1223: p_pkg_name => G_PKG_NAME,
1224: p_init_msg_list => p_init_msg_list,
1225: l_api_version => l_api_version,
1230: --message logging
1231: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1232: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT
1233: ,'OKL_AM_SECURITIZATION_PVT.process_securitized_streams'
1234: ,'returning from Okl_Api.START_ACTIVITY, status is '
1235: ||l_return_status);
1236: END IF;
1237:
1238: IF (l_return_status = G_RET_STS_UNEXP_ERROR) THEN
1235: ||l_return_status);
1236: END IF;
1237:
1238: IF (l_return_status = G_RET_STS_UNEXP_ERROR) THEN
1239: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1240: ELSIF (l_return_status = G_RET_STS_ERROR) THEN
1241: RAISE OKL_API.G_EXCEPTION_ERROR;
1242: END IF;
1243:
1237:
1238: IF (l_return_status = G_RET_STS_UNEXP_ERROR) THEN
1239: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1240: ELSIF (l_return_status = G_RET_STS_ERROR) THEN
1241: RAISE OKL_API.G_EXCEPTION_ERROR;
1242: END IF;
1243:
1244: SELECT sysdate INTO l_sysdate FROM dual;
1245:
1245:
1246: -- Check which parameters have been passed to determine
1247: -- the origin of the call
1248: -- rmunjulu 24-Nov-04 Changed OR to AND in the below IF
1249: IF (p_quote_id IS NOT NULL) AND (p_quote_id <> OKL_API.G_MISS_NUM) THEN
1250:
1251: -- rmunjulu EDAT
1252: -- set the operands for formula engine with quote_id
1253: g_add_params(1).name := 'quote_id';
1266: ,'OKL_AM_SECURITIZATION_PVT.process_securitized_streams'
1267: ,'cursor get_khr_id_csr returned no values');
1268: END IF;
1269:
1270: OKL_API.set_message(p_app_name => G_APP_NAME,
1271: p_msg_name => G_INVALID_VALUE1,
1272: p_token1 => 'COL_NAME',
1273: p_token1_value => 'Quote Id');
1274: x_return_status := G_RET_STS_ERROR;
1271: p_msg_name => G_INVALID_VALUE1,
1272: p_token1 => 'COL_NAME',
1273: p_token1_value => 'Quote Id');
1274: x_return_status := G_RET_STS_ERROR;
1275: RAISE OKL_API.G_EXCEPTION_ERROR;
1276: END IF;
1277: CLOSE get_khr_id_csr;
1278:
1279: /* sosharma 17-01-2008
1285: FETCH get_bok_class_csr INTO l_book_class;
1286: IF get_bok_class_csr%NOTFOUND THEN
1287: CLOSE get_bok_class_csr;
1288: x_return_status := G_RET_STS_ERROR;
1289: RAISE OKL_API.G_EXCEPTION_ERROR;
1290: END IF;
1291: CLOSE get_bok_class_csr;
1292:
1293: IF l_book_class = 'LOAN' THEN
1307: G_DATE_EFFECTIVE_FROM := l_effective_from_date; -- rmunjulu set effective from date global flag
1308: --gboomina Bug 4775555 - End
1309:
1310: -- rmunjulu 24-Nov-04 Changed OR to AND in the below ELSIF
1311: ELSIF ((p_kle_id IS NOT NULL) AND (p_kle_id <> OKL_API.G_MISS_NUM)) AND
1312: ((p_sale_price IS NOT NULL) AND (p_sale_price <> OKL_API.G_MISS_NUM)) THEN
1313:
1314: l_disb_type := 'RESIDUAL';
1315:
1308: --gboomina Bug 4775555 - End
1309:
1310: -- rmunjulu 24-Nov-04 Changed OR to AND in the below ELSIF
1311: ELSIF ((p_kle_id IS NOT NULL) AND (p_kle_id <> OKL_API.G_MISS_NUM)) AND
1312: ((p_sale_price IS NOT NULL) AND (p_sale_price <> OKL_API.G_MISS_NUM)) THEN
1313:
1314: l_disb_type := 'RESIDUAL';
1315:
1316: ELSE
1321: ,'parameter p_quote_id is null or (p_kle_id and p_sale_price)'
1322: ||' are null');
1323: END IF;
1324:
1325: OKL_API.set_message(p_app_name => G_APP_NAME,
1326: p_msg_name => G_REQUIRED_VALUE);
1327: x_return_status := G_RET_STS_ERROR;
1328: RAISE OKL_API.G_EXCEPTION_ERROR;
1329: END IF;
1324:
1325: OKL_API.set_message(p_app_name => G_APP_NAME,
1326: p_msg_name => G_REQUIRED_VALUE);
1327: x_return_status := G_RET_STS_ERROR;
1328: RAISE OKL_API.G_EXCEPTION_ERROR;
1329: END IF;
1330:
1331:
1332: -- check if securitized items exist for the underlying contract
1345: ,'OKL_AM_SECURITIZATION_PVT.process_securitized_streams'
1346: ,'cursor get_khr_id_csr returned no values');
1347: END IF;
1348:
1349: OKL_API.set_message(p_app_name => G_APP_NAME,
1350: p_msg_name => G_INVALID_VALUE1,
1351: p_token1 => 'COL_NAME',
1352: p_token1_value => 'Quote Id');
1353: x_return_status := G_RET_STS_ERROR;
1350: p_msg_name => G_INVALID_VALUE1,
1351: p_token1 => 'COL_NAME',
1352: p_token1_value => 'Quote Id');
1353: x_return_status := G_RET_STS_ERROR;
1354: RAISE OKL_API.G_EXCEPTION_ERROR;
1355: END IF;
1356: CLOSE get_khr_id_csr;
1357: */
1358: -- rmunjulu 4398936 end
1372: ,'OKL_AM_SECURITIZATION_PVT.process_securitized_streams'
1373: ,'cursor get_rv_khr_id_csr returned no values');
1374: END IF;
1375:
1376: OKL_API.set_message(p_app_name => G_APP_NAME,
1377: p_msg_name => G_INVALID_VALUE1,
1378: p_token1 => 'COL_NAME',
1379: p_token1_value => 'Asset Id');
1380: x_return_status := G_RET_STS_ERROR;
1377: p_msg_name => G_INVALID_VALUE1,
1378: p_token1 => 'COL_NAME',
1379: p_token1_value => 'Asset Id');
1380: x_return_status := G_RET_STS_ERROR;
1381: RAISE OKL_API.G_EXCEPTION_ERROR;
1382: END IF;
1383: CLOSE get_rv_khr_id_csr;
1384:
1385:
1419: ,x_value => l_is_securitized
1420: ,x_inv_agmt_chr_id_tbl => l_inv_agmt_chr_id_tbl );
1421:
1422: IF (l_return_status = G_RET_STS_UNEXP_ERROR) THEN
1423: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1424: ELSIF (l_return_status = G_RET_STS_ERROR) THEN
1425: RAISE OKL_API.G_EXCEPTION_ERROR;
1426: END IF;
1427:
1421:
1422: IF (l_return_status = G_RET_STS_UNEXP_ERROR) THEN
1423: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1424: ELSIF (l_return_status = G_RET_STS_ERROR) THEN
1425: RAISE OKL_API.G_EXCEPTION_ERROR;
1426: END IF;
1427:
1428: -- rmunjulu 3910833
1429: -- get the investor agreement for this contract's RENT or RESIDUAL streams
1567: ,p_effective_date => l_quote_eff_date -- rmunjulu EDAT 24-Nov-04
1568: ,p_transaction_date => l_quote_accpt_date -- rmunjulu EDAT 24-Nov-04
1569: ,p_asset_rec => l_asset_tbl(l_loop_counter));
1570: IF (l_return_status = G_RET_STS_UNEXP_ERROR) THEN
1571: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1572: ELSIF (l_return_status = G_RET_STS_ERROR) THEN
1573: RAISE OKL_API.G_EXCEPTION_ERROR;
1574: END IF;
1575: END IF;
1569: ,p_asset_rec => l_asset_tbl(l_loop_counter));
1570: IF (l_return_status = G_RET_STS_UNEXP_ERROR) THEN
1571: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1572: ELSIF (l_return_status = G_RET_STS_ERROR) THEN
1573: RAISE OKL_API.G_EXCEPTION_ERROR;
1574: END IF;
1575: END IF;
1576:
1577: -- Do disbursement adjustments if contract is securitized as of termination date
1577: -- Do disbursement adjustments if contract is securitized as of termination date
1578: IF l_is_securitized = OKC_API.G_TRUE THEN
1579: do_disb_adjustments (
1580: p_api_version => p_api_version,
1581: p_init_msg_list => OKL_API.G_FALSE,
1582: x_msg_count => x_msg_count,
1583: x_msg_data => x_msg_data,
1584: p_ia_id => l_ia_id,
1585: p_khr_id => l_asset_tbl(l_loop_counter).p_khr_id,
1588: p_quote_eff_date => G_DATE_EFFECTIVE_FROM,
1589: x_return_status => l_return_status);
1590:
1591: IF (l_return_status = G_RET_STS_UNEXP_ERROR) THEN
1592: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1593: ELSIF (l_return_status = G_RET_STS_ERROR) THEN
1594: RAISE OKL_API.G_EXCEPTION_ERROR;
1595: END IF;
1596: END IF; -- end of l_is_securitized check
1590:
1591: IF (l_return_status = G_RET_STS_UNEXP_ERROR) THEN
1592: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1593: ELSIF (l_return_status = G_RET_STS_ERROR) THEN
1594: RAISE OKL_API.G_EXCEPTION_ERROR;
1595: END IF;
1596: END IF; -- end of l_is_securitized check
1597: END IF; -- end of check for amount not null
1598: END LOOP; -- end of for loop over l_asset_tbl
1618: ,p_transaction_date => l_quote_accpt_date -- rmunjulu EDAT 24-Nov-04
1619: ,p_sale_price => p_sale_price);
1620:
1621: IF (l_return_status = G_RET_STS_UNEXP_ERROR) THEN
1622: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1623: ELSIF (l_return_status = G_RET_STS_ERROR) THEN
1624: RAISE OKL_API.G_EXCEPTION_ERROR;
1625: END IF;
1626:
1620:
1621: IF (l_return_status = G_RET_STS_UNEXP_ERROR) THEN
1622: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1623: ELSIF (l_return_status = G_RET_STS_ERROR) THEN
1624: RAISE OKL_API.G_EXCEPTION_ERROR;
1625: END IF;
1626:
1627: -- Historize Residual Value Stream
1628: -- set the tbl type for streams pub
1656: x_msg_data => x_msg_data,
1657: p_stmv_tbl => lp_stmv_tbl,
1658: x_stmv_tbl => lx_stmv_tbl);
1659:
1660: IF l_return_status <> OKL_API.G_RET_STS_SUCCESS THEN
1661: OKL_API.set_message( p_app_name => G_APP_NAME,
1662: p_msg_name => 'OKL_AM_ERR_UPD_STREAMS');
1663: END IF;
1664: --message logging
1657: p_stmv_tbl => lp_stmv_tbl,
1658: x_stmv_tbl => lx_stmv_tbl);
1659:
1660: IF l_return_status <> OKL_API.G_RET_STS_SUCCESS THEN
1661: OKL_API.set_message( p_app_name => G_APP_NAME,
1662: p_msg_name => 'OKL_AM_ERR_UPD_STREAMS');
1663: END IF;
1664: --message logging
1665: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1731: ,p_transaction_date => l_quote_accpt_date
1732: ,p_asset_tbl => l_asset_tbl);
1733:
1734: IF (l_return_status = G_RET_STS_UNEXP_ERROR) THEN
1735: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1736: ELSIF (l_return_status = G_RET_STS_ERROR) THEN
1737: RAISE OKL_API.G_EXCEPTION_ERROR;
1738: END IF;
1739: END IF;
1733:
1734: IF (l_return_status = G_RET_STS_UNEXP_ERROR) THEN
1735: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1736: ELSIF (l_return_status = G_RET_STS_ERROR) THEN
1737: RAISE OKL_API.G_EXCEPTION_ERROR;
1738: END IF;
1739: END IF;
1740:
1741: -- END IF;
1760: ,p_transaction_date => l_quote_accpt_date -- rmunjulu EDAT 24-Nov-04
1761: ,p_disb_type => l_disb_type);
1762:
1763: IF (l_return_status = G_RET_STS_UNEXP_ERROR) THEN
1764: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1765: ELSIF (l_return_status = G_RET_STS_ERROR) THEN
1766: RAISE OKL_API.G_EXCEPTION_ERROR;
1767: END IF;
1768: END IF; -- mdokal Bug #3247596 End
1762:
1763: IF (l_return_status = G_RET_STS_UNEXP_ERROR) THEN
1764: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1765: ELSIF (l_return_status = G_RET_STS_ERROR) THEN
1766: RAISE OKL_API.G_EXCEPTION_ERROR;
1767: END IF;
1768: END IF; -- mdokal Bug #3247596 End
1769: END IF;
1770:
1771: --message logging
1772: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1773: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT
1774: ,'OKL_AM_SECURITIZATION_PVT.process_securitized_streams'
1775: ,'calling Okl_Api.END_ACTIVITY');
1776: END IF;
1777:
1778: Okl_Api.END_ACTIVITY(x_msg_count => x_msg_count
1779: ,x_msg_data => x_msg_data);
1774: ,'OKL_AM_SECURITIZATION_PVT.process_securitized_streams'
1775: ,'calling Okl_Api.END_ACTIVITY');
1776: END IF;
1777:
1778: Okl_Api.END_ACTIVITY(x_msg_count => x_msg_count
1779: ,x_msg_data => x_msg_data);
1780:
1781: x_return_status := l_return_status;
1782: --message logging
1782: --message logging
1783: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1784: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT
1785: ,'OKL_AM_SECURITIZATION_PVT.process_securitized_streams'
1786: ,' returning from Okl_Api.END_ACTIVITY, status is ||'
1787: ||x_return_status);
1788: END IF;
1789: --message logging
1790: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1886: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION
1887: ,'OKL_AM_SECURITIZATION_PVT.process_securitized_streams'
1888: , 'When others exception occured');
1889: END IF;
1890: OKL_API.set_message(p_app_name => g_app_name,
1891: p_msg_name => g_unexpected_error,
1892: p_token1 => g_sqlcode_token,
1893: p_token1_value => sqlcode,
1894: p_token2 => g_sqlerrm_token,
1893: p_token1_value => sqlcode,
1894: p_token2 => g_sqlerrm_token,
1895: p_token2_value => sqlerrm);
1896:
1897: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
1898:
1899: END process_securitized_streams;
1900:
1901: /*========================================================================
2013: l_rent_sty,
2014: l_return_status,
2015: l_sty_id);
2016:
2017: IF l_sty_id IS NULL OR l_sty_id = OKL_API.G_MISS_NUM THEN
2018: --message logging
2019: IF (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2020: FND_LOG.STRING(FND_LOG.LEVEL_ERROR
2021: ,'OKL_AM_SECURITIZATION_PVT.disburse_investor_rent'
2022: ,'OKL_STREAMS_UTIL.get_primary_stream_type returned no values');
2023: END IF;
2024:
2025: -- smoduga +++++++++ User Defined Streams -- end ++++++++++++++++
2026: OKL_API.set_message(p_app_name => G_APP_NAME,
2027: p_msg_name => G_INVALID_VALUE1,
2028: p_token1 => 'COL_NAME',
2029: p_token1_value => 'STY_ID');
2030: END IF;
2051: ,x_formula_value => l_formula_amount
2052: ,x_return_status => l_return_status);
2053:
2054: IF (l_return_status = G_RET_STS_UNEXP_ERROR) THEN
2055: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2056: ELSIF (l_return_status = G_RET_STS_ERROR) THEN
2057: RAISE OKL_API.G_EXCEPTION_ERROR;
2058: END IF;
2059: --message logging
2053:
2054: IF (l_return_status = G_RET_STS_UNEXP_ERROR) THEN
2055: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2056: ELSIF (l_return_status = G_RET_STS_ERROR) THEN
2057: RAISE OKL_API.G_EXCEPTION_ERROR;
2058: END IF;
2059: --message logging
2060: IF (FND_LOG.LEVEL_STATEMENT >=
2061: FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2115: ,x_stmv_rec => x_stmv_rec
2116: ,x_selv_tbl => x_selv_tbl );
2117:
2118: IF (l_return_status = G_RET_STS_UNEXP_ERROR) THEN
2119: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2120: ELSIF (l_return_status = G_RET_STS_ERROR) THEN
2121: RAISE OKL_API.G_EXCEPTION_ERROR;
2122: END IF;
2123: --message logging
2117:
2118: IF (l_return_status = G_RET_STS_UNEXP_ERROR) THEN
2119: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2120: ELSIF (l_return_status = G_RET_STS_ERROR) THEN
2121: RAISE OKL_API.G_EXCEPTION_ERROR;
2122: END IF;
2123: --message logging
2124: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2125: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT
2130: -- gboomina Bug 4775555 - Start
2131: -- INVESTOR_DISB_ADJUSTMENTS
2132: do_disb_adjustments (
2133: p_api_version => p_api_version,
2134: p_init_msg_list => OKL_API.G_FALSE,
2135: x_msg_count => x_msg_count,
2136: x_msg_data => x_msg_data,
2137: p_ia_id => p_ia_id,
2138: p_khr_id => p_asset_tbl(l_loop_counter).p_khr_id,
2149: ||' status is '||l_return_status);
2150: END IF;
2151:
2152: IF (l_return_status = G_RET_STS_UNEXP_ERROR) THEN
2153: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2154: ELSIF (l_return_status = G_RET_STS_ERROR) THEN
2155: RAISE OKL_API.G_EXCEPTION_ERROR;
2156: END IF;
2157: -- gboomina Bug 4775555 - End
2151:
2152: IF (l_return_status = G_RET_STS_UNEXP_ERROR) THEN
2153: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2154: ELSIF (l_return_status = G_RET_STS_ERROR) THEN
2155: RAISE OKL_API.G_EXCEPTION_ERROR;
2156: END IF;
2157: -- gboomina Bug 4775555 - End
2158: END IF;
2159: END LOOP; -- p_asset_tbl
2228: ,'OKL_AM_SECURITIZATION_PVT.disburse_investor_rent'
2229: , 'When others exception occured');
2230: END IF;
2231:
2232: OKL_API.set_message(p_app_name => g_app_name,
2233: p_msg_name => g_unexpected_error,
2234: p_token1 => g_sqlcode_token,
2235: p_token1_value => sqlcode,
2236: p_token2 => g_sqlerrm_token,
2235: p_token1_value => sqlcode,
2236: p_token2 => g_sqlerrm_token,
2237: p_token2_value => sqlerrm);
2238:
2239: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
2240:
2241:
2242: END disburse_investor_rent;
2243:
2348: l_rent_sty,
2349: l_return_status,
2350: l_sty_id);
2351:
2352: IF l_sty_id IS NULL OR l_sty_id = OKL_API.G_MISS_NUM THEN
2353: --message logging
2354: IF (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2355: FND_LOG.STRING(FND_LOG.LEVEL_ERROR
2356: ,'OKL_AM_SECURITIZATION_PVT.disburse_investor_loan_payment'
2357: ,'OKL_STREAMS_UTIL.get_primary_stream_type returned no values');
2358: END IF;
2359:
2360: -- smoduga +++++++++ User Defined Streams -- end ++++++++++++++++
2361: OKL_API.set_message(p_app_name => G_APP_NAME,
2362: p_msg_name => G_INVALID_VALUE1,
2363: p_token1 => 'COL_NAME',
2364: p_token1_value => 'STY_ID');
2365: END IF;
2386: ,x_formula_value => l_formula_amount
2387: ,x_return_status => l_return_status);
2388:
2389: IF (l_return_status = G_RET_STS_UNEXP_ERROR) THEN
2390: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2391: ELSIF (l_return_status = G_RET_STS_ERROR) THEN
2392: RAISE OKL_API.G_EXCEPTION_ERROR;
2393: END IF;
2394: --message logging
2388:
2389: IF (l_return_status = G_RET_STS_UNEXP_ERROR) THEN
2390: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2391: ELSIF (l_return_status = G_RET_STS_ERROR) THEN
2392: RAISE OKL_API.G_EXCEPTION_ERROR;
2393: END IF;
2394: --message logging
2395: IF (FND_LOG.LEVEL_STATEMENT >=
2396: FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2450: ,x_stmv_rec => x_stmv_rec
2451: ,x_selv_tbl => x_selv_tbl );
2452:
2453: IF (l_return_status = G_RET_STS_UNEXP_ERROR) THEN
2454: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2455: ELSIF (l_return_status = G_RET_STS_ERROR) THEN
2456: RAISE OKL_API.G_EXCEPTION_ERROR;
2457: END IF;
2458: --message logging
2452:
2453: IF (l_return_status = G_RET_STS_UNEXP_ERROR) THEN
2454: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2455: ELSIF (l_return_status = G_RET_STS_ERROR) THEN
2456: RAISE OKL_API.G_EXCEPTION_ERROR;
2457: END IF;
2458: --message logging
2459: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2460: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT
2465: -- gboomina Bug 4775555 - Start
2466: -- INVESTOR_DISB_ADJUSTMENTS
2467: do_disb_adjustments_loan (
2468: p_api_version => p_api_version,
2469: p_init_msg_list => OKL_API.G_FALSE,
2470: x_msg_count => x_msg_count,
2471: x_msg_data => x_msg_data,
2472: p_ia_id => p_ia_id,
2473: p_khr_id => p_asset_tbl(l_loop_counter).p_khr_id,
2484: ||' status is '||l_return_status);
2485: END IF;
2486:
2487: IF (l_return_status = G_RET_STS_UNEXP_ERROR) THEN
2488: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2489: ELSIF (l_return_status = G_RET_STS_ERROR) THEN
2490: RAISE OKL_API.G_EXCEPTION_ERROR;
2491: END IF;
2492: -- gboomina Bug 4775555 - End
2486:
2487: IF (l_return_status = G_RET_STS_UNEXP_ERROR) THEN
2488: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2489: ELSIF (l_return_status = G_RET_STS_ERROR) THEN
2490: RAISE OKL_API.G_EXCEPTION_ERROR;
2491: END IF;
2492: -- gboomina Bug 4775555 - End
2493: END IF;
2494: END LOOP; -- p_asset_tbl
2563: ,'OKL_AM_SECURITIZATION_PVT.disburse_investor_loan_payment'
2564: , 'When others exception occured');
2565: END IF;
2566:
2567: OKL_API.set_message(p_app_name => g_app_name,
2568: p_msg_name => g_unexpected_error,
2569: p_token1 => g_sqlcode_token,
2570: p_token1_value => sqlcode,
2571: p_token2 => g_sqlerrm_token,
2570: p_token1_value => sqlcode,
2571: p_token2 => g_sqlerrm_token,
2572: p_token2_value => sqlerrm);
2573:
2574: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
2575:
2576:
2577: END disburse_investor_loan_payment;
2578:
2680: x_formula_value => l_formula_amount,
2681: x_return_status => l_return_status);
2682:
2683: IF (l_return_status = G_RET_STS_UNEXP_ERROR) THEN
2684: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2685: ELSIF (l_return_status = G_RET_STS_ERROR) THEN
2686: RAISE OKL_API.G_EXCEPTION_ERROR;
2687: END IF;
2688: --message logging
2682:
2683: IF (l_return_status = G_RET_STS_UNEXP_ERROR) THEN
2684: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2685: ELSIF (l_return_status = G_RET_STS_ERROR) THEN
2686: RAISE OKL_API.G_EXCEPTION_ERROR;
2687: END IF;
2688: --message logging
2689: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2690: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT
2702: OKL_STREAMS_UTIL.get_primary_stream_type(p_ia_id,
2703: l_rent_sty,
2704: l_return_status,
2705: l_stmv_rec.sty_id);
2706: IF l_stmv_rec.sty_id IS NULL OR l_stmv_rec.sty_id = OKL_API.G_MISS_NUM THEN
2707:
2708: --message logging
2709: IF (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2710: FND_LOG.STRING(FND_LOG.LEVEL_ERROR
2712: ,' OKL_STREAMS_UTIL.get_primary_stream_type returned no values');
2713: END IF;
2714: -- smoduga +++++++++ User Defined Streams -- end ++++++++++++++++
2715:
2716: OKL_API.set_message(p_app_name => G_APP_NAME,
2717: p_msg_name => G_INVALID_VALUE1,
2718: p_token1 => 'COL_NAME',
2719: p_token1_value => 'STY.CODE');
2720: END IF;
2761: ,x_stmv_rec => x_stmv_rec
2762: ,x_selv_tbl => x_selv_tbl );
2763:
2764: IF (l_return_status = G_RET_STS_UNEXP_ERROR) THEN
2765: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2766: ELSIF (l_return_status = G_RET_STS_ERROR) THEN
2767: RAISE OKL_API.G_EXCEPTION_ERROR;
2768: END IF;
2769: --message logging
2763:
2764: IF (l_return_status = G_RET_STS_UNEXP_ERROR) THEN
2765: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2766: ELSIF (l_return_status = G_RET_STS_ERROR) THEN
2767: RAISE OKL_API.G_EXCEPTION_ERROR;
2768: END IF;
2769: --message logging
2770: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2771: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT
2845: ,'OKL_AM_SECURITIZATION_PVT.disburse_investor_rv'
2846: , 'When others exception occured');
2847: END IF;
2848:
2849: OKL_API.set_message(p_app_name => g_app_name,
2850: p_msg_name => g_unexpected_error,
2851: p_token1 => g_sqlcode_token,
2852: p_token1_value => sqlcode,
2853: p_token2 => g_sqlerrm_token,
2852: p_token1_value => sqlcode,
2853: p_token2 => g_sqlerrm_token,
2854: p_token2_value => sqlerrm);
2855:
2856: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
2857:
2858: END disburse_investor_rv;
2859:
2860: /*========================================================================
2963: ,x_msg_count => x_msg_count
2964: ,x_msg_data => x_msg_data );
2965:
2966: IF (l_return_status = G_RET_STS_UNEXP_ERROR) THEN
2967: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2968: ELSIF (l_return_status = G_RET_STS_ERROR) THEN
2969: RAISE OKL_API.G_EXCEPTION_ERROR;
2970: END IF;
2971: --message logging
2965:
2966: IF (l_return_status = G_RET_STS_UNEXP_ERROR) THEN
2967: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2968: ELSIF (l_return_status = G_RET_STS_ERROR) THEN
2969: RAISE OKL_API.G_EXCEPTION_ERROR;
2970: END IF;
2971: --message logging
2972: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2973: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT
3012: ,x_msg_count => x_msg_count
3013: ,x_msg_data => x_msg_data );
3014:
3015: IF (l_return_status = G_RET_STS_UNEXP_ERROR) THEN
3016: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3017: ELSIF (l_return_status = G_RET_STS_ERROR) THEN
3018: RAISE OKL_API.G_EXCEPTION_ERROR;
3019: END IF;
3020: --message logging
3014:
3015: IF (l_return_status = G_RET_STS_UNEXP_ERROR) THEN
3016: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3017: ELSIF (l_return_status = G_RET_STS_ERROR) THEN
3018: RAISE OKL_API.G_EXCEPTION_ERROR;
3019: END IF;
3020: --message logging
3021: IF (FND_LOG.LEVEL_STATEMENT >=
3022: FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3085: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION
3086: ,'OKL_AM_SECURITIZATION_PVT.create_pool_transaction'
3087: , 'When others exception occured');
3088: END IF;
3089: OKL_API.set_message(p_app_name => g_app_name,
3090: p_msg_name => g_unexpected_error,
3091: p_token1 => g_sqlcode_token,
3092: p_token1_value => sqlcode,
3093: p_token2 => g_sqlerrm_token,
3092: p_token1_value => sqlcode,
3093: p_token2 => g_sqlerrm_token,
3094: p_token2_value => sqlerrm);
3095:
3096: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
3097:
3098: END create_pool_transaction;
3099:
3100: