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_AM_TERMINATE_INV_AGMT_PVT dependencies on FND_LOG

Line 453: IF( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

449: l_return_status VARCHAR2(1) := G_RET_STS_SUCCESS;
450:
451: BEGIN
452:
453: IF( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
454: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
455: 'OKL_AM_TERMINATE_INV_AGMT_PVT.get_ia_leases.',
456: 'Begin(+)');
457: END IF;

Line 454: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

450:
451: BEGIN
452:
453: IF( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
454: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
455: 'OKL_AM_TERMINATE_INV_AGMT_PVT.get_ia_leases.',
456: 'Begin(+)');
457: END IF;
458:

Line 476: IF( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

472:
473: x_return_status := l_return_status;
474: x_ia_k_tbl := l_ia_k_tbl;
475:
476: IF( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
477: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
478: 'OKL_AM_TERMINATE_INV_AGMT_PVT.get_ia_leases.',
479: 'End(-)');
480: END IF;

Line 477: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

473: x_return_status := l_return_status;
474: x_ia_k_tbl := l_ia_k_tbl;
475:
476: IF( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
477: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
478: 'OKL_AM_TERMINATE_INV_AGMT_PVT.get_ia_leases.',
479: 'End(-)');
480: END IF;
481:

Line 494: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

490: p_token1_value => SQLCODE,
491: p_token2 => G_SQLERRM_TOKEN,
492: p_token2_value => SQLERRM);
493:
494: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
495: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
496: 'OKL_AM_TERMINATE_INV_AGMT_PVT.get_ia_leases.',
497: 'EXP - OTHERS');
498: END IF;

Line 495: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

491: p_token2 => G_SQLERRM_TOKEN,
492: p_token2_value => SQLERRM);
493:
494: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
495: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
496: 'OKL_AM_TERMINATE_INV_AGMT_PVT.get_ia_leases.',
497: 'EXP - OTHERS');
498: END IF;
499:

Line 564: IF( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

560: l_sel_id NUMBER := G_MISS_NUM;
561:
562: BEGIN
563:
564: IF( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
565: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
566: 'OKL_AM_TERMINATE_INV_AGMT_PVT.validate_ia_pool.',
567: 'Begin(+)');
568: END IF;

Line 565: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

561:
562: BEGIN
563:
564: IF( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
565: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
566: 'OKL_AM_TERMINATE_INV_AGMT_PVT.validate_ia_pool.',
567: 'Begin(+)');
568: END IF;
569:

Line 622: IF( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

618:
619: -- Set return status
620: x_return_status := l_return_status;
621:
622: IF( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
623: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
624: 'OKL_AM_TERMINATE_INV_AGMT_PVT.validate_ia_pool.',
625: 'End(-)');
626: END IF;

Line 623: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

619: -- Set return status
620: x_return_status := l_return_status;
621:
622: IF( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
623: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
624: 'OKL_AM_TERMINATE_INV_AGMT_PVT.validate_ia_pool.',
625: 'End(-)');
626: END IF;
627:

Line 634: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

630: WHEN G_EXCEPTION_ERROR THEN
631: ROLLBACK TO validate_ia_pool_trx;
632: x_return_status := G_RET_STS_ERROR;
633:
634: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
635: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
636: 'OKL_AM_TERMINATE_INV_AGMT_PVT.validate_ia_pool.',
637: 'EXP - G_EXCEPTION_ERROR');
638: END IF;

Line 635: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

631: ROLLBACK TO validate_ia_pool_trx;
632: x_return_status := G_RET_STS_ERROR;
633:
634: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
635: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
636: 'OKL_AM_TERMINATE_INV_AGMT_PVT.validate_ia_pool.',
637: 'EXP - G_EXCEPTION_ERROR');
638: END IF;
639:

Line 644: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

640: WHEN G_EXCEPTION_UNEXPECTED_ERROR THEN
641: ROLLBACK TO validate_ia_pool_trx;
642: x_return_status := G_RET_STS_UNEXP_ERROR;
643:
644: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
645: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
646: 'OKL_AM_TERMINATE_INV_AGMT_PVT.validate_ia_pool.',
647: 'EXP - G_EXCEPTION_UNEXPECTED_ERROR');
648: END IF;

Line 645: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

641: ROLLBACK TO validate_ia_pool_trx;
642: x_return_status := G_RET_STS_UNEXP_ERROR;
643:
644: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
645: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
646: 'OKL_AM_TERMINATE_INV_AGMT_PVT.validate_ia_pool.',
647: 'EXP - G_EXCEPTION_UNEXPECTED_ERROR');
648: END IF;
649:

Line 664: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

660: p_token2_value => SQLERRM);
661:
662: x_return_status := G_RET_STS_UNEXP_ERROR;
663:
664: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
665: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
666: 'OKL_AM_TERMINATE_INV_AGMT_PVT.validate_ia_pool.',
667: 'EXP - OTHERS');
668: END IF;

Line 665: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

661:
662: x_return_status := G_RET_STS_UNEXP_ERROR;
663:
664: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
665: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
666: 'OKL_AM_TERMINATE_INV_AGMT_PVT.validate_ia_pool.',
667: 'EXP - OTHERS');
668: END IF;
669:

Line 718: IF( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

714: l_strm_id NUMBER;
715:
716: BEGIN
717:
718: IF( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
719: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
720: 'OKL_AM_TERMINATE_INV_AGMT_PVT.check_unbilled_streams_of_pool.',
721: 'Begin(+)');
722: END IF;

Line 719: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

715:
716: BEGIN
717:
718: IF( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
719: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
720: 'OKL_AM_TERMINATE_INV_AGMT_PVT.check_unbilled_streams_of_pool.',
721: 'Begin(+)');
722: END IF;
723:

Line 753: IF( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

749:
750: -- Set return status
751: x_return_status := l_return_status;
752:
753: IF( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
754: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
755: 'OKL_AM_TERMINATE_INV_AGMT_PVT.check_unbilled_streams_of_pool.',
756: 'End(-)');
757: END IF;

Line 754: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

750: -- Set return status
751: x_return_status := l_return_status;
752:
753: IF( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
754: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
755: 'OKL_AM_TERMINATE_INV_AGMT_PVT.check_unbilled_streams_of_pool.',
756: 'End(-)');
757: END IF;
758:

Line 766: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

762:
763: ROLLBACK TO check_unbilled_trx;
764: x_return_status := G_RET_STS_ERROR;
765:
766: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
767: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
768: 'OKL_AM_TERMINATE_INV_AGMT_PVT.check_unbilled_streams_of_pool.',
769: 'EXP - G_EXCEPTION_ERROR');
770: END IF;

Line 767: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

763: ROLLBACK TO check_unbilled_trx;
764: x_return_status := G_RET_STS_ERROR;
765:
766: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
767: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
768: 'OKL_AM_TERMINATE_INV_AGMT_PVT.check_unbilled_streams_of_pool.',
769: 'EXP - G_EXCEPTION_ERROR');
770: END IF;
771:

Line 777: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

773:
774: ROLLBACK TO check_unbilled_trx;
775: x_return_status := G_RET_STS_UNEXP_ERROR;
776:
777: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
778: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
779: 'OKL_AM_TERMINATE_INV_AGMT_PVT.check_unbilled_streams_of_pool.',
780: 'EXP - G_EXCEPTION_UNEXPECTED_ERROR');
781: END IF;

Line 778: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

774: ROLLBACK TO check_unbilled_trx;
775: x_return_status := G_RET_STS_UNEXP_ERROR;
776:
777: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
778: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
779: 'OKL_AM_TERMINATE_INV_AGMT_PVT.check_unbilled_streams_of_pool.',
780: 'EXP - G_EXCEPTION_UNEXPECTED_ERROR');
781: END IF;
782:

Line 798: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

794: p_token2_value => SQLERRM);
795:
796: x_return_status := G_RET_STS_UNEXP_ERROR;
797:
798: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
799: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
800: 'OKL_AM_TERMINATE_INV_AGMT_PVT.check_unbilled_streams_of_pool.',
801: 'EXP - OTHERS');
802: END IF;

Line 799: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

795:
796: x_return_status := G_RET_STS_UNEXP_ERROR;
797:
798: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
799: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
800: 'OKL_AM_TERMINATE_INV_AGMT_PVT.check_unbilled_streams_of_pool.',
801: 'EXP - OTHERS');
802: END IF;
803:

Line 916: IF( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

912:
913:
914: BEGIN
915:
916: IF( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
917: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
918: 'OKL_AM_TERMINATE_INV_AGMT_PVT.check_pending_disb_for_ia.',
919: 'Begin(+)');
920: END IF;

Line 917: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

913:
914: BEGIN
915:
916: IF( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
917: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
918: 'OKL_AM_TERMINATE_INV_AGMT_PVT.check_pending_disb_for_ia.',
919: 'Begin(+)');
920: END IF;
921:

Line 1032: IF( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1028:
1029: -- Set return status
1030: x_return_status := l_return_status;
1031:
1032: IF( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1033: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
1034: 'OKL_AM_TERMINATE_INV_AGMT_PVT.check_pending_disb_for_ia.',
1035: 'End(-)');
1036: END IF;

Line 1033: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

1029: -- Set return status
1030: x_return_status := l_return_status;
1031:
1032: IF( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1033: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
1034: 'OKL_AM_TERMINATE_INV_AGMT_PVT.check_pending_disb_for_ia.',
1035: 'End(-)');
1036: END IF;
1037:

Line 1045: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1041:
1042: ROLLBACK TO check_pending_disb_trx;
1043: x_return_status := G_RET_STS_ERROR;
1044:
1045: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1046: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
1047: 'OKL_AM_TERMINATE_INV_AGMT_PVT.check_pending_disb_for_ia.',
1048: 'EXP - G_EXCEPTION_ERROR');
1049: END IF;

Line 1046: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

1042: ROLLBACK TO check_pending_disb_trx;
1043: x_return_status := G_RET_STS_ERROR;
1044:
1045: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1046: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
1047: 'OKL_AM_TERMINATE_INV_AGMT_PVT.check_pending_disb_for_ia.',
1048: 'EXP - G_EXCEPTION_ERROR');
1049: END IF;
1050:

Line 1056: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1052:
1053: ROLLBACK TO check_pending_disb_trx;
1054: x_return_status := G_RET_STS_UNEXP_ERROR;
1055:
1056: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1057: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
1058: 'OKL_AM_TERMINATE_INV_AGMT_PVT.check_pending_disb_for_ia.',
1059: 'EXP - G_EXCEPTION_UNEXPECTED_ERROR');
1060: END IF;

Line 1057: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

1053: ROLLBACK TO check_pending_disb_trx;
1054: x_return_status := G_RET_STS_UNEXP_ERROR;
1055:
1056: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1057: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
1058: 'OKL_AM_TERMINATE_INV_AGMT_PVT.check_pending_disb_for_ia.',
1059: 'EXP - G_EXCEPTION_UNEXPECTED_ERROR');
1060: END IF;
1061:

Line 1077: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1073: p_token2_value => SQLERRM);
1074:
1075: x_return_status := G_RET_STS_UNEXP_ERROR;
1076:
1077: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1078: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
1079: 'OKL_AM_TERMINATE_INV_AGMT_PVT.check_pending_disb_for_ia.',
1080: 'EXP - OTHERS');
1081: END IF;

Line 1078: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

1074:
1075: x_return_status := G_RET_STS_UNEXP_ERROR;
1076:
1077: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1078: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
1079: 'OKL_AM_TERMINATE_INV_AGMT_PVT.check_pending_disb_for_ia.',
1080: 'EXP - OTHERS');
1081: END IF;
1082:

Line 1129: IF( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1125: l_status VARCHAR2(300);
1126:
1127: BEGIN
1128:
1129: IF( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1130: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
1131: 'OKL_AM_TERMINATE_INV_AGMT_PVT.pop_investor_agreement.',
1132: 'Begin(+)');
1133: END IF;

Line 1130: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

1126:
1127: BEGIN
1128:
1129: IF( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1130: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
1131: 'OKL_AM_TERMINATE_INV_AGMT_PVT.pop_investor_agreement.',
1132: 'Begin(+)');
1133: END IF;
1134:

Line 1155: IF( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1151:
1152: -- Set return values
1153: x_return_status := l_return_status;
1154:
1155: IF( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1156: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
1157: 'OKL_AM_TERMINATE_INV_AGMT_PVT.pop_investor_agreement.',
1158: 'End(-)');
1159: END IF;

Line 1156: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

1152: -- Set return values
1153: x_return_status := l_return_status;
1154:
1155: IF( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1156: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
1157: 'OKL_AM_TERMINATE_INV_AGMT_PVT.pop_investor_agreement.',
1158: 'End(-)');
1159: END IF;
1160:

Line 1176: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1172: p_token2_value => SQLERRM);
1173:
1174: x_return_status := G_RET_STS_UNEXP_ERROR;
1175:
1176: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1177: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
1178: 'OKL_AM_TERMINATE_INV_AGMT_PVT.pop_investor_agreement.',
1179: 'EXP - OTHERS');
1180: END IF;

Line 1177: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

1173:
1174: x_return_status := G_RET_STS_UNEXP_ERROR;
1175:
1176: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1177: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
1178: 'OKL_AM_TERMINATE_INV_AGMT_PVT.pop_investor_agreement.',
1179: 'EXP - OTHERS');
1180: END IF;
1181:

Line 1274: IF( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1270: --
1271: -- End Logic
1272: -- ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
1273:
1274: IF( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1275: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
1276: 'OKL_AM_TERMINATE_INV_AGMT_PVT.val_pop_investor_agreement.',
1277: 'Begin(+)');
1278: END IF;

Line 1275: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

1271: -- End Logic
1272: -- ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
1273:
1274: IF( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1275: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
1276: 'OKL_AM_TERMINATE_INV_AGMT_PVT.val_pop_investor_agreement.',
1277: 'Begin(+)');
1278: END IF;
1279:

Line 1471: IF( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1467: x_return_status := l_return_status;
1468: x_ialn_tbl := l_ialn_tbl;
1469: x_ia_rec := l_ia_rec;
1470:
1471: IF( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1472: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
1473: 'OKL_AM_TERMINATE_INV_AGMT_PVT.val_pop_investor_agreement.',
1474: 'End(-)');
1475: END IF;

Line 1472: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

1468: x_ialn_tbl := l_ialn_tbl;
1469: x_ia_rec := l_ia_rec;
1470:
1471: IF( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1472: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
1473: 'OKL_AM_TERMINATE_INV_AGMT_PVT.val_pop_investor_agreement.',
1474: 'End(-)');
1475: END IF;
1476:

Line 1486: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1482:
1483: x_ialn_tbl := l_ialn_tbl;
1484: x_ia_rec := l_ia_rec;
1485:
1486: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1487: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
1488: 'OKL_AM_TERMINATE_INV_AGMT_PVT.val_pop_investor_agreement.',
1489: 'EXP - G_EXCEPTION_ERROR');
1490: END IF;

Line 1487: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

1483: x_ialn_tbl := l_ialn_tbl;
1484: x_ia_rec := l_ia_rec;
1485:
1486: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1487: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
1488: 'OKL_AM_TERMINATE_INV_AGMT_PVT.val_pop_investor_agreement.',
1489: 'EXP - G_EXCEPTION_ERROR');
1490: END IF;
1491:

Line 1499: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1495:
1496: x_ialn_tbl := l_ialn_tbl;
1497: x_ia_rec := l_ia_rec;
1498:
1499: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1500: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
1501: 'OKL_AM_TERMINATE_INV_AGMT_PVT.val_pop_investor_agreement.',
1502: 'EXP - G_EXCEPTION_UNEXPECTED_ERROR');
1503: END IF;

Line 1500: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

1496: x_ialn_tbl := l_ialn_tbl;
1497: x_ia_rec := l_ia_rec;
1498:
1499: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1500: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
1501: 'OKL_AM_TERMINATE_INV_AGMT_PVT.val_pop_investor_agreement.',
1502: 'EXP - G_EXCEPTION_UNEXPECTED_ERROR');
1503: END IF;
1504:

Line 1521: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1517:
1518: x_ialn_tbl := l_ialn_tbl;
1519: x_ia_rec := l_ia_rec;
1520:
1521: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1522: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
1523: 'OKL_AM_TERMINATE_INV_AGMT_PVT.val_pop_investor_agreement.',
1524: 'EXP - OTHERS');
1525: END IF;

Line 1522: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

1518: x_ialn_tbl := l_ialn_tbl;
1519: x_ia_rec := l_ia_rec;
1520:
1521: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1522: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
1523: 'OKL_AM_TERMINATE_INV_AGMT_PVT.val_pop_investor_agreement.',
1524: 'EXP - OTHERS');
1525: END IF;
1526:

Line 1591: IF( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1587: l_msg_data VARCHAR2(2000);
1588:
1589: BEGIN
1590:
1591: IF( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1592: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
1593: 'OKL_AM_TERMINATE_INV_AGMT_PVT.pop_or_insert_transaction.',
1594: 'Begin(+)');
1595: END IF;

Line 1592: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

1588:
1589: BEGIN
1590:
1591: IF( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1592: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
1593: 'OKL_AM_TERMINATE_INV_AGMT_PVT.pop_or_insert_transaction.',
1594: 'Begin(+)');
1595: END IF;
1596:

Line 1720: IF( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1716: x_return_status := l_return_status;
1717: px_tcnv_rec := lx_tcnv_rec;
1718: x_trn_already_yn := l_trn_already_yn;
1719:
1720: IF( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1721: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
1722: 'OKL_AM_TERMINATE_INV_AGMT_PVT.pop_or_insert_transaction.',
1723: 'End(-)');
1724: END IF;

Line 1721: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

1717: px_tcnv_rec := lx_tcnv_rec;
1718: x_trn_already_yn := l_trn_already_yn;
1719:
1720: IF( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1721: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
1722: 'OKL_AM_TERMINATE_INV_AGMT_PVT.pop_or_insert_transaction.',
1723: 'End(-)');
1724: END IF;
1725:

Line 1732: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1728: WHEN G_EXCEPTION_ERROR THEN
1729: ROLLBACK TO pop_insert_trn_trx;
1730: x_return_status := G_RET_STS_ERROR;
1731:
1732: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1733: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
1734: 'OKL_AM_TERMINATE_INV_AGMT_PVT.pop_or_insert_transaction.',
1735: 'EXP - G_EXCEPTION_ERROR');
1736: END IF;

Line 1733: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

1729: ROLLBACK TO pop_insert_trn_trx;
1730: x_return_status := G_RET_STS_ERROR;
1731:
1732: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1733: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
1734: 'OKL_AM_TERMINATE_INV_AGMT_PVT.pop_or_insert_transaction.',
1735: 'EXP - G_EXCEPTION_ERROR');
1736: END IF;
1737:

Line 1742: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1738: WHEN G_EXCEPTION_UNEXPECTED_ERROR THEN
1739: ROLLBACK TO pop_insert_trn_trx;
1740: x_return_status := G_RET_STS_UNEXP_ERROR;
1741:
1742: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1743: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
1744: 'OKL_AM_TERMINATE_INV_AGMT_PVT.pop_or_insert_transaction.',
1745: 'EXP - G_EXCEPTION_UNEXPECTED_ERROR');
1746: END IF;

Line 1743: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

1739: ROLLBACK TO pop_insert_trn_trx;
1740: x_return_status := G_RET_STS_UNEXP_ERROR;
1741:
1742: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1743: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
1744: 'OKL_AM_TERMINATE_INV_AGMT_PVT.pop_or_insert_transaction.',
1745: 'EXP - G_EXCEPTION_UNEXPECTED_ERROR');
1746: END IF;
1747:

Line 1762: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1758: p_token2_value => SQLERRM);
1759:
1760: x_return_status := G_RET_STS_UNEXP_ERROR;
1761:
1762: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1763: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
1764: 'OKL_AM_TERMINATE_INV_AGMT_PVT.pop_or_insert_transaction.',
1765: 'EXP - OTHERS');
1766: END IF;

Line 1763: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

1759:
1760: x_return_status := G_RET_STS_UNEXP_ERROR;
1761:
1762: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1763: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
1764: 'OKL_AM_TERMINATE_INV_AGMT_PVT.pop_or_insert_transaction.',
1765: 'EXP - OTHERS');
1766: END IF;
1767:

Line 1795: IF( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1791: l_msg_data VARCHAR2(2000);
1792:
1793: BEGIN
1794:
1795: IF( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1796: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
1797: 'OKL_AM_TERMINATE_INV_AGMT_PVT.reverse_loss_provisions.',
1798: 'Begin(+)');
1799: END IF;

Line 1796: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

1792:
1793: BEGIN
1794:
1795: IF( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1796: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
1797: 'OKL_AM_TERMINATE_INV_AGMT_PVT.reverse_loss_provisions.',
1798: 'Begin(+)');
1799: END IF;
1800:

Line 1847: IF( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1843:
1844: -- Set return status
1845: x_return_status := l_return_status;
1846:
1847: IF( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1848: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
1849: 'OKL_AM_TERMINATE_INV_AGMT_PVT.reverse_loss_provisions.',
1850: 'End(-)');
1851: END IF;

Line 1848: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

1844: -- Set return status
1845: x_return_status := l_return_status;
1846:
1847: IF( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1848: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
1849: 'OKL_AM_TERMINATE_INV_AGMT_PVT.reverse_loss_provisions.',
1850: 'End(-)');
1851: END IF;
1852:

Line 1859: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1855: WHEN G_EXCEPTION_ERROR THEN
1856: ROLLBACK TO reverse_loss_trx;
1857: x_return_status := G_RET_STS_ERROR;
1858:
1859: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1860: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
1861: 'OKL_AM_TERMINATE_INV_AGMT_PVT.reverse_loss_provisions.',
1862: 'EXP - G_EXCEPTION_ERROR');
1863: END IF;

Line 1860: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

1856: ROLLBACK TO reverse_loss_trx;
1857: x_return_status := G_RET_STS_ERROR;
1858:
1859: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1860: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
1861: 'OKL_AM_TERMINATE_INV_AGMT_PVT.reverse_loss_provisions.',
1862: 'EXP - G_EXCEPTION_ERROR');
1863: END IF;
1864:

Line 1869: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1865: WHEN G_EXCEPTION_UNEXPECTED_ERROR THEN
1866: ROLLBACK TO reverse_loss_trx;
1867: x_return_status := G_RET_STS_UNEXP_ERROR;
1868:
1869: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1870: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
1871: 'OKL_AM_TERMINATE_INV_AGMT_PVT.reverse_loss_provisions.',
1872: 'EXP - G_EXCEPTION_UNEXPECTED_ERROR');
1873: END IF;

Line 1870: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

1866: ROLLBACK TO reverse_loss_trx;
1867: x_return_status := G_RET_STS_UNEXP_ERROR;
1868:
1869: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1870: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
1871: 'OKL_AM_TERMINATE_INV_AGMT_PVT.reverse_loss_provisions.',
1872: 'EXP - G_EXCEPTION_UNEXPECTED_ERROR');
1873: END IF;
1874:

Line 1889: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1885: p_token2_value => SQLERRM);
1886:
1887: x_return_status := G_RET_STS_UNEXP_ERROR;
1888:
1889: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1890: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
1891: 'OKL_AM_TERMINATE_INV_AGMT_PVT.reverse_loss_provisions.',
1892: 'EXP - OTHERS');
1893: END IF;

Line 1890: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

1886:
1887: x_return_status := G_RET_STS_UNEXP_ERROR;
1888:
1889: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1890: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
1891: 'OKL_AM_TERMINATE_INV_AGMT_PVT.reverse_loss_provisions.',
1892: 'EXP - OTHERS');
1893: END IF;
1894:

Line 1918: IF( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1914: l_return_status VARCHAR2(1) := G_RET_STS_SUCCESS;
1915:
1916: BEGIN
1917:
1918: IF( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1919: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
1920: 'OKL_AM_TERMINATE_INV_AGMT_PVT.accounting_entries.',
1921: 'Begin(+)');
1922: END IF;

Line 1919: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

1915:
1916: BEGIN
1917:
1918: IF( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1919: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
1920: 'OKL_AM_TERMINATE_INV_AGMT_PVT.accounting_entries.',
1921: 'Begin(+)');
1922: END IF;
1923:

Line 1952: IF( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1948: px_tcnv_rec.tmt_accounting_entries_yn := G_YES;
1949:
1950: END IF;
1951:
1952: IF( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1953: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
1954: 'OKL_AM_TERMINATE_INV_AGMT_PVT.accounting_entries.',
1955: 'End(-)');
1956: END IF;

Line 1953: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

1949:
1950: END IF;
1951:
1952: IF( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1953: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
1954: 'OKL_AM_TERMINATE_INV_AGMT_PVT.accounting_entries.',
1955: 'End(-)');
1956: END IF;
1957:

Line 1966: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1962: x_return_status := G_RET_STS_ERROR;
1963: px_tcnv_rec.tmt_accounting_entries_yn := G_NO;
1964: px_tcnv_rec.tsu_code := 'ERROR';
1965:
1966: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1967: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
1968: 'OKL_AM_TERMINATE_INV_AGMT_PVT.accounting_entries.',
1969: 'EXP - G_EXCEPTION_ERROR');
1970: END IF;

Line 1967: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

1963: px_tcnv_rec.tmt_accounting_entries_yn := G_NO;
1964: px_tcnv_rec.tsu_code := 'ERROR';
1965:
1966: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1967: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
1968: 'OKL_AM_TERMINATE_INV_AGMT_PVT.accounting_entries.',
1969: 'EXP - G_EXCEPTION_ERROR');
1970: END IF;
1971:

Line 1978: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1974: x_return_status := G_RET_STS_UNEXP_ERROR;
1975: px_tcnv_rec.tmt_accounting_entries_yn := G_NO;
1976: px_tcnv_rec.tsu_code := 'ERROR';
1977:
1978: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1979: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
1980: 'OKL_AM_TERMINATE_INV_AGMT_PVT.accounting_entries.',
1981: 'EXP - G_EXCEPTION_UNEXPECTED_ERROR');
1982: END IF;

Line 1979: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

1975: px_tcnv_rec.tmt_accounting_entries_yn := G_NO;
1976: px_tcnv_rec.tsu_code := 'ERROR';
1977:
1978: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1979: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
1980: 'OKL_AM_TERMINATE_INV_AGMT_PVT.accounting_entries.',
1981: 'EXP - G_EXCEPTION_UNEXPECTED_ERROR');
1982: END IF;
1983:

Line 2000: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1996: x_return_status := G_RET_STS_UNEXP_ERROR;
1997: px_tcnv_rec.tmt_accounting_entries_yn := G_NO;
1998: px_tcnv_rec.tsu_code := 'ERROR';
1999:
2000: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2001: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
2002: 'OKL_AM_TERMINATE_INV_AGMT_PVT.accounting_entries.',
2003: 'EXP - OTHERS');
2004: END IF;

Line 2001: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

1997: px_tcnv_rec.tmt_accounting_entries_yn := G_NO;
1998: px_tcnv_rec.tsu_code := 'ERROR';
1999:
2000: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2001: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
2002: 'OKL_AM_TERMINATE_INV_AGMT_PVT.accounting_entries.',
2003: 'EXP - OTHERS');
2004: END IF;
2005:

Line 2044: IF( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

2040: i NUMBER;
2041:
2042: BEGIN
2043:
2044: IF( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2045: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
2046: 'OKL_AM_TERMINATE_INV_AGMT_PVT.update_ia_and_lines.',
2047: 'Begin(+)');
2048: END IF;

Line 2045: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

2041:
2042: BEGIN
2043:
2044: IF( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2045: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
2046: 'OKL_AM_TERMINATE_INV_AGMT_PVT.update_ia_and_lines.',
2047: 'Begin(+)');
2048: END IF;
2049:

Line 2144: IF( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

2140:
2141: -- Set return status
2142: x_return_status := l_return_status;
2143:
2144: IF( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2145: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
2146: 'OKL_AM_TERMINATE_INV_AGMT_PVT.update_ia_and_lines.',
2147: 'End(-)');
2148: END IF;

Line 2145: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

2141: -- Set return status
2142: x_return_status := l_return_status;
2143:
2144: IF( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2145: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
2146: 'OKL_AM_TERMINATE_INV_AGMT_PVT.update_ia_and_lines.',
2147: 'End(-)');
2148: END IF;
2149:

Line 2156: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

2152: WHEN G_EXCEPTION_ERROR THEN
2153: ROLLBACK TO update_ia_and_lines_trx;
2154: x_return_status := G_RET_STS_ERROR;
2155:
2156: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2157: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
2158: 'OKL_AM_TERMINATE_INV_AGMT_PVT.update_ia_and_lines.',
2159: 'EXP - G_EXCEPTION_ERROR');
2160: END IF;

Line 2157: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

2153: ROLLBACK TO update_ia_and_lines_trx;
2154: x_return_status := G_RET_STS_ERROR;
2155:
2156: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2157: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
2158: 'OKL_AM_TERMINATE_INV_AGMT_PVT.update_ia_and_lines.',
2159: 'EXP - G_EXCEPTION_ERROR');
2160: END IF;
2161:

Line 2166: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

2162: WHEN G_EXCEPTION_UNEXPECTED_ERROR THEN
2163: ROLLBACK TO update_ia_and_lines_trx;
2164: x_return_status := G_RET_STS_UNEXP_ERROR;
2165:
2166: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2167: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
2168: 'OKL_AM_TERMINATE_INV_AGMT_PVT.update_ia_and_lines.',
2169: 'EXP - G_EXCEPTION_UNEXPECTED_ERROR');
2170: END IF;

Line 2167: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

2163: ROLLBACK TO update_ia_and_lines_trx;
2164: x_return_status := G_RET_STS_UNEXP_ERROR;
2165:
2166: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2167: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
2168: 'OKL_AM_TERMINATE_INV_AGMT_PVT.update_ia_and_lines.',
2169: 'EXP - G_EXCEPTION_UNEXPECTED_ERROR');
2170: END IF;
2171:

Line 2186: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

2182: p_token2_value => SQLERRM);
2183:
2184: x_return_status := G_RET_STS_UNEXP_ERROR;
2185:
2186: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2187: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
2188: 'OKL_AM_TERMINATE_INV_AGMT_PVT.update_ia_and_lines.',
2189: 'EXP - OTHERS');
2190: END IF;

Line 2187: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

2183:
2184: x_return_status := G_RET_STS_UNEXP_ERROR;
2185:
2186: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2187: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
2188: 'OKL_AM_TERMINATE_INV_AGMT_PVT.update_ia_and_lines.',
2189: 'EXP - OTHERS');
2190: END IF;
2191:

Line 2280: IF( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

2276:
2277:
2278: BEGIN
2279:
2280: IF( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2281: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
2282: 'OKL_AM_TERMINATE_INV_AGMT_PVT.update_pools.',
2283: 'Begin(+)');
2284: END IF;

Line 2281: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

2277:
2278: BEGIN
2279:
2280: IF( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2281: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
2282: 'OKL_AM_TERMINATE_INV_AGMT_PVT.update_pools.',
2283: 'Begin(+)');
2284: END IF;
2285:

Line 2458: IF( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

2454:
2455: -- Set return status
2456: x_return_status := l_return_status;
2457:
2458: IF( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2459: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
2460: 'OKL_AM_TERMINATE_INV_AGMT_PVT.update_pools.',
2461: 'End(-)');
2462: END IF;

Line 2459: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

2455: -- Set return status
2456: x_return_status := l_return_status;
2457:
2458: IF( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2459: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
2460: 'OKL_AM_TERMINATE_INV_AGMT_PVT.update_pools.',
2461: 'End(-)');
2462: END IF;
2463:

Line 2470: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

2466: WHEN G_EXCEPTION_ERROR THEN
2467: ROLLBACK TO update_pools_trx;
2468: x_return_status := G_RET_STS_ERROR;
2469:
2470: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2471: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
2472: 'OKL_AM_TERMINATE_INV_AGMT_PVT.update_pools.',
2473: 'EXP - G_EXCEPTION_ERROR');
2474: END IF;

Line 2471: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

2467: ROLLBACK TO update_pools_trx;
2468: x_return_status := G_RET_STS_ERROR;
2469:
2470: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2471: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
2472: 'OKL_AM_TERMINATE_INV_AGMT_PVT.update_pools.',
2473: 'EXP - G_EXCEPTION_ERROR');
2474: END IF;
2475:

Line 2480: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

2476: WHEN G_EXCEPTION_UNEXPECTED_ERROR THEN
2477: ROLLBACK TO update_pools_trx;
2478: x_return_status := G_RET_STS_UNEXP_ERROR;
2479:
2480: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2481: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
2482: 'OKL_AM_TERMINATE_INV_AGMT_PVT.update_pools.',
2483: 'EXP - G_EXCEPTION_UNEXPECTED_ERROR');
2484: END IF;

Line 2481: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

2477: ROLLBACK TO update_pools_trx;
2478: x_return_status := G_RET_STS_UNEXP_ERROR;
2479:
2480: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2481: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
2482: 'OKL_AM_TERMINATE_INV_AGMT_PVT.update_pools.',
2483: 'EXP - G_EXCEPTION_UNEXPECTED_ERROR');
2484: END IF;
2485:

Line 2500: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

2496: p_token2_value => SQLERRM);
2497:
2498: x_return_status := G_RET_STS_UNEXP_ERROR;
2499:
2500: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2501: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
2502: 'OKL_AM_TERMINATE_INV_AGMT_PVT.update_pools.',
2503: 'EXP - OTHERS');
2504: END IF;

Line 2501: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

2497:
2498: x_return_status := G_RET_STS_UNEXP_ERROR;
2499:
2500: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2501: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
2502: 'OKL_AM_TERMINATE_INV_AGMT_PVT.update_pools.',
2503: 'EXP - OTHERS');
2504: END IF;
2505:

Line 2530: IF( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

2526: l_return_status VARCHAR2(1) := G_RET_STS_SUCCESS;
2527:
2528: BEGIN
2529:
2530: IF( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2531: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
2532: 'OKL_AM_TERMINATE_INV_AGMT_PVT.update_investor_agreement.',
2533: 'Begin(+)');
2534: END IF;

Line 2531: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

2527:
2528: BEGIN
2529:
2530: IF( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2531: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
2532: 'OKL_AM_TERMINATE_INV_AGMT_PVT.update_investor_agreement.',
2533: 'Begin(+)');
2534: END IF;
2535:

Line 2590: IF( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

2586: px_tcnv_rec.tsu_code := 'PROCESSED';
2587:
2588: END IF;
2589:
2590: IF( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2591: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
2592: 'OKL_AM_TERMINATE_INV_AGMT_PVT.update_investor_agreement.',
2593: 'End(-)');
2594: END IF;

Line 2591: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

2587:
2588: END IF;
2589:
2590: IF( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2591: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
2592: 'OKL_AM_TERMINATE_INV_AGMT_PVT.update_investor_agreement.',
2593: 'End(-)');
2594: END IF;
2595:

Line 2604: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

2600: x_return_status := G_RET_STS_ERROR;
2601: px_tcnv_rec.tmt_contract_updated_yn := G_NO;
2602: px_tcnv_rec.tsu_code := 'ERROR';
2603:
2604: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2605: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
2606: 'OKL_AM_TERMINATE_INV_AGMT_PVT.update_investor_agreement.',
2607: 'EXP - G_EXCEPTION_ERROR');
2608: END IF;

Line 2605: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

2601: px_tcnv_rec.tmt_contract_updated_yn := G_NO;
2602: px_tcnv_rec.tsu_code := 'ERROR';
2603:
2604: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2605: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
2606: 'OKL_AM_TERMINATE_INV_AGMT_PVT.update_investor_agreement.',
2607: 'EXP - G_EXCEPTION_ERROR');
2608: END IF;
2609:

Line 2616: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

2612: x_return_status := G_RET_STS_UNEXP_ERROR;
2613: px_tcnv_rec.tmt_contract_updated_yn := G_NO;
2614: px_tcnv_rec.tsu_code := 'ERROR';
2615:
2616: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2617: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
2618: 'OKL_AM_TERMINATE_INV_AGMT_PVT.update_investor_agreement.',
2619: 'EXP - G_EXCEPTION_UNEXPECTED_ERROR');
2620: END IF;

Line 2617: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

2613: px_tcnv_rec.tmt_contract_updated_yn := G_NO;
2614: px_tcnv_rec.tsu_code := 'ERROR';
2615:
2616: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2617: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
2618: 'OKL_AM_TERMINATE_INV_AGMT_PVT.update_investor_agreement.',
2619: 'EXP - G_EXCEPTION_UNEXPECTED_ERROR');
2620: END IF;
2621:

Line 2638: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

2634: x_return_status := G_RET_STS_UNEXP_ERROR;
2635: px_tcnv_rec.tmt_contract_updated_yn := G_NO;
2636: px_tcnv_rec.tsu_code := 'ERROR';
2637:
2638: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2639: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
2640: 'OKL_AM_TERMINATE_INV_AGMT_PVT.update_investor_agreement.',
2641: 'EXP - OTHERS');
2642: END IF;

Line 2639: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

2635: px_tcnv_rec.tmt_contract_updated_yn := G_NO;
2636: px_tcnv_rec.tsu_code := 'ERROR';
2637:
2638: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2639: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
2640: 'OKL_AM_TERMINATE_INV_AGMT_PVT.update_investor_agreement.',
2641: 'EXP - OTHERS');
2642: END IF;
2643:

Line 2672: IF( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

2668: l_msg_data VARCHAR2(2000);
2669:
2670: BEGIN
2671:
2672: IF( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2673: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
2674: 'OKL_AM_TERMINATE_INV_AGMT_PVT.update_transaction.',
2675: 'Begin(+)');
2676: END IF;

Line 2673: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

2669:
2670: BEGIN
2671:
2672: IF( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2673: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
2674: 'OKL_AM_TERMINATE_INV_AGMT_PVT.update_transaction.',
2675: 'Begin(+)');
2676: END IF;
2677:

Line 2711: IF( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

2707:
2708: -- Set return status
2709: x_return_status := l_return_status;
2710:
2711: IF( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2712: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
2713: 'OKL_AM_TERMINATE_INV_AGMT_PVT.update_transaction.',
2714: 'End(-)');
2715: END IF;

Line 2712: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

2708: -- Set return status
2709: x_return_status := l_return_status;
2710:
2711: IF( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2712: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
2713: 'OKL_AM_TERMINATE_INV_AGMT_PVT.update_transaction.',
2714: 'End(-)');
2715: END IF;
2716:

Line 2723: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

2719: WHEN G_EXCEPTION_ERROR THEN
2720: ROLLBACK TO update_transaction_trx;
2721: x_return_status := G_RET_STS_ERROR;
2722:
2723: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2724: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
2725: 'OKL_AM_TERMINATE_INV_AGMT_PVT.update_transaction.',
2726: 'EXP - G_EXCEPTION_ERROR');
2727: END IF;

Line 2724: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

2720: ROLLBACK TO update_transaction_trx;
2721: x_return_status := G_RET_STS_ERROR;
2722:
2723: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2724: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
2725: 'OKL_AM_TERMINATE_INV_AGMT_PVT.update_transaction.',
2726: 'EXP - G_EXCEPTION_ERROR');
2727: END IF;
2728:

Line 2733: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

2729: WHEN G_EXCEPTION_UNEXPECTED_ERROR THEN
2730: ROLLBACK TO update_transaction_trx;
2731: x_return_status := G_RET_STS_UNEXP_ERROR;
2732:
2733: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2734: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
2735: 'OKL_AM_TERMINATE_INV_AGMT_PVT.update_transaction.',
2736: 'EXP - G_EXCEPTION_UNEXPECTED_ERROR');
2737: END IF;

Line 2734: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

2730: ROLLBACK TO update_transaction_trx;
2731: x_return_status := G_RET_STS_UNEXP_ERROR;
2732:
2733: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2734: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
2735: 'OKL_AM_TERMINATE_INV_AGMT_PVT.update_transaction.',
2736: 'EXP - G_EXCEPTION_UNEXPECTED_ERROR');
2737: END IF;
2738:

Line 2753: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

2749: p_token2_value => SQLERRM);
2750:
2751: x_return_status := G_RET_STS_UNEXP_ERROR;
2752:
2753: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2754: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
2755: 'OKL_AM_TERMINATE_INV_AGMT_PVT.update_transaction.',
2756: 'EXP - OTHERS');
2757: END IF;

Line 2754: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

2750:
2751: x_return_status := G_RET_STS_UNEXP_ERROR;
2752:
2753: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2754: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
2755: 'OKL_AM_TERMINATE_INV_AGMT_PVT.update_transaction.',
2756: 'EXP - OTHERS');
2757: END IF;
2758:

Line 2817: IF( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

2813: -- Create a Termination Transaction -- tcn_type = 'IAT' first time --
2814: -- Uses the created termination transaction later on, but does validate every time
2815: -- will not do Accounting Entries if already done
2816:
2817: IF( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2818: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
2819: 'OKL_AM_TERMINATE_INV_AGMT_PVT.terminate_investor_agreement.',
2820: 'Begin(+)');
2821: END IF;

Line 2818: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

2814: -- Uses the created termination transaction later on, but does validate every time
2815: -- will not do Accounting Entries if already done
2816:
2817: IF( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2818: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
2819: 'OKL_AM_TERMINATE_INV_AGMT_PVT.terminate_investor_agreement.',
2820: 'Begin(+)');
2821: END IF;
2822:

Line 2859: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

2855: x_ia_rec => l_ia_rec,
2856: x_ialn_tbl => l_ialn_tbl,
2857: x_return_status => l_return_status);
2858:
2859: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2860: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
2861: 'OKL_AM_TERMINATE_INV_AGMT_PVT.terminate_investor_agreement.',
2862: 'val_pop_investor_agreement = '||l_return_status );
2863: END IF;

Line 2860: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

2856: x_ialn_tbl => l_ialn_tbl,
2857: x_return_status => l_return_status);
2858:
2859: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2860: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
2861: 'OKL_AM_TERMINATE_INV_AGMT_PVT.terminate_investor_agreement.',
2862: 'val_pop_investor_agreement = '||l_return_status );
2863: END IF;
2864:

Line 2882: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

2878: px_tcnv_rec => l_tcnv_rec,
2879: p_validate_success => l_overall_status,
2880: x_return_status => l_return_status);
2881:
2882: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2883: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
2884: 'OKL_AM_TERMINATE_INV_AGMT_PVT.pop_or_insert_transaction.',
2885: 'pop_or_insert_transaction = '||l_return_status );
2886: END IF;

Line 2883: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

2879: p_validate_success => l_overall_status,
2880: x_return_status => l_return_status);
2881:
2882: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2883: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
2884: 'OKL_AM_TERMINATE_INV_AGMT_PVT.pop_or_insert_transaction.',
2885: 'pop_or_insert_transaction = '||l_return_status );
2886: END IF;
2887:

Line 2908: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

2904: p_termination_date => l_sys_date,
2905: p_tcnv_rec => l_tcnv_rec,
2906: x_return_status => l_return_status);
2907:
2908: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2909: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
2910: 'OKL_AM_TERMINATE_INV_AGMT_PVT.terminate_investor_agreement.',
2911: 'update_transaction = '||l_return_status );
2912: END IF;

Line 2909: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

2905: p_tcnv_rec => l_tcnv_rec,
2906: x_return_status => l_return_status);
2907:
2908: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2909: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
2910: 'OKL_AM_TERMINATE_INV_AGMT_PVT.terminate_investor_agreement.',
2911: 'update_transaction = '||l_return_status );
2912: END IF;
2913:

Line 2936: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

2932: p_gl_date => l_valid_gl_date,
2933: px_tcnv_rec => l_tcnv_rec,
2934: x_return_status => l_return_status);
2935:
2936: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2937: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
2938: 'OKL_AM_TERMINATE_INV_AGMT_PVT.accounting_entries.',
2939: 'accounting_entries = '||l_return_status );
2940: END IF;

Line 2937: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

2933: px_tcnv_rec => l_tcnv_rec,
2934: x_return_status => l_return_status);
2935:
2936: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2937: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
2938: 'OKL_AM_TERMINATE_INV_AGMT_PVT.accounting_entries.',
2939: 'accounting_entries = '||l_return_status );
2940: END IF;
2941:

Line 2960: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

2956: px_tcnv_rec => l_tcnv_rec,
2957: p_overall_status => l_overall_status,
2958: x_return_status => l_return_status);
2959:
2960: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2961: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
2962: 'OKL_AM_TERMINATE_INV_AGMT_PVT.update_investor_agreement.',
2963: 'update_investor_agreement = '||l_return_status );
2964: END IF;

Line 2961: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

2957: p_overall_status => l_overall_status,
2958: x_return_status => l_return_status);
2959:
2960: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2961: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
2962: 'OKL_AM_TERMINATE_INV_AGMT_PVT.update_investor_agreement.',
2963: 'update_investor_agreement = '||l_return_status );
2964: END IF;
2965:

Line 2976: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

2972: p_termination_date => l_sys_date,
2973: p_tcnv_rec => l_tcnv_rec,
2974: x_return_status => l_return_status);
2975:
2976: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2977: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
2978: 'OKL_AM_TERMINATE_INV_AGMT_PVT.terminate_investor_agreement.',
2979: 'update_transaction = '||l_return_status );
2980: END IF;

Line 2977: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

2973: p_tcnv_rec => l_tcnv_rec,
2974: x_return_status => l_return_status);
2975:
2976: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2977: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
2978: 'OKL_AM_TERMINATE_INV_AGMT_PVT.terminate_investor_agreement.',
2979: 'update_transaction = '||l_return_status );
2980: END IF;
2981:

Line 3015: IF( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

3011:
3012: -- End Activity
3013: OKL_API.end_activity (x_msg_count, x_msg_data);
3014:
3015: IF( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3016: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
3017: 'OKL_AM_TERMINATE_INV_AGMT_PVT.terminate_investor_agreement.',
3018: 'End(-)');
3019: END IF;

Line 3016: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

3012: -- End Activity
3013: OKL_API.end_activity (x_msg_count, x_msg_data);
3014:
3015: IF( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3016: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
3017: 'OKL_AM_TERMINATE_INV_AGMT_PVT.terminate_investor_agreement.',
3018: 'End(-)');
3019: END IF;
3020:

Line 3040: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

3036: p_ia_rec => l_ia_rec,
3037: p_control_flag => 'ERROR');
3038: END IF;
3039:
3040: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3041: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
3042: 'OKL_AM_TERMINATE_INV_AGMT_PVT.terminate_investor_agreement.',
3043: 'EXP - G_EXCEPTION');
3044: END IF;

Line 3041: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

3037: p_control_flag => 'ERROR');
3038: END IF;
3039:
3040: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3041: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
3042: 'OKL_AM_TERMINATE_INV_AGMT_PVT.terminate_investor_agreement.',
3043: 'EXP - G_EXCEPTION');
3044: END IF;
3045:

Line 3063: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

3059: x_msg_count => x_msg_count,
3060: x_msg_data => x_msg_data,
3061: p_api_type => '_PVT');
3062:
3063: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3064: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
3065: 'OKL_AM_TERMINATE_INV_AGMT_PVT.terminate_investor_agreement.',
3066: 'EXP - G_EXCEPTION_ERROR');
3067: END IF;

Line 3064: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

3060: x_msg_data => x_msg_data,
3061: p_api_type => '_PVT');
3062:
3063: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3064: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
3065: 'OKL_AM_TERMINATE_INV_AGMT_PVT.terminate_investor_agreement.',
3066: 'EXP - G_EXCEPTION_ERROR');
3067: END IF;
3068:

Line 3086: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

3082: x_msg_count => x_msg_count,
3083: x_msg_data => x_msg_data,
3084: p_api_type => '_PVT');
3085:
3086: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3087: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
3088: 'OKL_AM_TERMINATE_INV_AGMT_PVT.terminate_investor_agreement.',
3089: 'EXP - G_EXCEPTION_UNEXPECTED_ERROR');
3090: END IF;

Line 3087: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

3083: x_msg_data => x_msg_data,
3084: p_api_type => '_PVT');
3085:
3086: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3087: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
3088: 'OKL_AM_TERMINATE_INV_AGMT_PVT.terminate_investor_agreement.',
3089: 'EXP - G_EXCEPTION_UNEXPECTED_ERROR');
3090: END IF;
3091:

Line 3109: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

3105: x_msg_count => x_msg_count,
3106: x_msg_data => x_msg_data,
3107: p_api_type => '_PVT');
3108:
3109: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3110: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
3111: 'OKL_AM_TERMINATE_INV_AGMT_PVT.terminate_investor_agreement.',
3112: 'EXP - OTHERS');
3113: END IF;

Line 3110: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

3106: x_msg_data => x_msg_data,
3107: p_api_type => '_PVT');
3108:
3109: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3110: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
3111: 'OKL_AM_TERMINATE_INV_AGMT_PVT.terminate_investor_agreement.',
3112: 'EXP - OTHERS');
3113: END IF;
3114: