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_K_RATE_PARAMS_PVT dependencies on OKC_API

Line 54: G_COL_NAME CONSTANT VARCHAR2(30) := OKC_API.G_COL_NAME_TOKEN;

50: G_STRM_INT_INCOME CONSTANT OKL_STRM_TYPE_V.STREAM_TYPE_PURPOSE%TYPE := 'INTEREST_INCOME';
51: G_STRM_LOAN_PAYMENT CONSTANT OKL_STRM_TYPE_V.STREAM_TYPE_PURPOSE%TYPE := 'LOAN_PAYMENT';
52: G_STRM_VAR_INT_INCOME CONSTANT OKL_STRM_TYPE_V.STREAM_TYPE_PURPOSE%TYPE := 'VARIABLE_INTEREST_INCOME';
53:
54: G_COL_NAME CONSTANT VARCHAR2(30) := OKC_API.G_COL_NAME_TOKEN;
55: G_DUE_DATE CONSTANT VARCHAR2(30) := 'DUE_DATE';
56: -- smadhava Bug#4542290 - 22-Aug-2005 - Added - End
57:
58:

Line 231: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

227: End Is_Rebook_Copy;
228:
229: PROCEDURE get_effective_from_date(
230: p_api_version IN NUMBER,
231: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
232: x_return_status OUT NOCOPY VARCHAR2,
233: x_msg_count OUT NOCOPY NUMBER,
234: x_msg_data OUT NOCOPY VARCHAR2,
235: p_chr_id IN OKC_K_HEADERS_B.ID%TYPE,

Line 261: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

257: END;
258:
259: procedure get_product(
260: p_api_version IN NUMBER,
261: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
262: x_return_status OUT NOCOPY VARCHAR2,
263: x_msg_count OUT NOCOPY NUMBER,
264: x_msg_data OUT NOCOPY VARCHAR2,
265: p_khr_id IN okc_k_headers_b.id%type,

Line 339: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

335: END;
336:
337: procedure get_product2(
338: p_api_version IN NUMBER,
339: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
340: x_return_status OUT NOCOPY VARCHAR2,
341: x_msg_count OUT NOCOPY NUMBER,
342: x_msg_data OUT NOCOPY VARCHAR2,
343: p_khr_id IN okc_k_headers_b.id%type,

Line 544: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

540:
541: --Bug# 7566308
542: PROCEDURE validate_rate_params_rbk(
543: p_api_version IN NUMBER,
544: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
545: x_return_status OUT NOCOPY VARCHAR2,
546: x_msg_count OUT NOCOPY NUMBER,
547: x_msg_data OUT NOCOPY VARCHAR2,
548: p_krpv_rec IN krpv_rec_type,

Line 663: OKC_API.SET_MESSAGE( p_app_name => G_APP_NAME

659: l_orig_rate_rec.BASE_RATE <> G_MISS_NUM) OR
660: (p_krpv_rec.BASE_RATE IS NOT NULL AND
661: p_krpv_rec.BASE_RATE <> G_MISS_NUM)) AND
662: (l_orig_rate_rec.BASE_RATE <> p_krpv_rec.BASE_RATE) THEN
663: OKC_API.SET_MESSAGE( p_app_name => G_APP_NAME
664: ,p_msg_name => 'OKL_LLA_VAR_RATE_INT_PROC'
665: ,p_token1 => 'PARAMETER_NAME'
666: ,p_token1_value => 'BASE_RATE'
667: ,p_token2 => 'CONTRACT_NUMBER'

Line 677: OKC_API.SET_MESSAGE( p_app_name => G_APP_NAME

673: l_orig_rate_rec.INTEREST_START_DATE <> G_MISS_DATE) OR
674: (p_krpv_rec.INTEREST_START_DATE IS NOT NULL AND
675: p_krpv_rec.INTEREST_START_DATE <> G_MISS_DATE)) AND
676: (l_orig_rate_rec.INTEREST_START_DATE <> p_krpv_rec.INTEREST_START_DATE) THEN
677: OKC_API.SET_MESSAGE( p_app_name => G_APP_NAME
678: ,p_msg_name => 'OKL_LLA_VAR_RATE_INT_PROC'
679: ,p_token1 => 'PARAMETER_NAME'
680: ,p_token1_value => 'INTEREST_START_DATE'
681: ,p_token2 => 'CONTRACT_NUMBER'

Line 691: OKC_API.SET_MESSAGE( p_app_name => G_APP_NAME

687: l_orig_rate_rec.PRINCIPAL_BASIS_CODE <> G_MISS_CHAR) OR
688: (p_krpv_rec.PRINCIPAL_BASIS_CODE IS NOT NULL AND
689: p_krpv_rec.PRINCIPAL_BASIS_CODE <> G_MISS_CHAR)) AND
690: (l_orig_rate_rec.PRINCIPAL_BASIS_CODE <> p_krpv_rec.PRINCIPAL_BASIS_CODE) THEN
691: OKC_API.SET_MESSAGE( p_app_name => G_APP_NAME
692: ,p_msg_name => 'OKL_LLA_VAR_RATE_INT_PROC'
693: ,p_token1 => 'PARAMETER_NAME'
694: ,p_token1_value => 'PRINCIPAL_BASIS_CODE'
695: ,p_token2 => 'CONTRACT_NUMBER'

Line 705: OKC_API.SET_MESSAGE( p_app_name => G_APP_NAME

701: l_orig_rate_rec.DAYS_IN_A_MONTH_CODE <> G_MISS_CHAR) OR
702: (p_krpv_rec.DAYS_IN_A_MONTH_CODE IS NOT NULL AND
703: p_krpv_rec.DAYS_IN_A_MONTH_CODE <> G_MISS_CHAR)) AND
704: (l_orig_rate_rec.DAYS_IN_A_MONTH_CODE <> p_krpv_rec.DAYS_IN_A_MONTH_CODE) THEN
705: OKC_API.SET_MESSAGE( p_app_name => G_APP_NAME
706: ,p_msg_name => 'OKL_LLA_VAR_RATE_INT_PROC'
707: ,p_token1 => 'PARAMETER_NAME'
708: ,p_token1_value => 'DAYS_IN_A_MONTH_CODE'
709: ,p_token2 => 'CONTRACT_NUMBER'

Line 719: OKC_API.SET_MESSAGE( p_app_name => G_APP_NAME

715: l_orig_rate_rec.DAYS_IN_A_YEAR_CODE <> G_MISS_CHAR) OR
716: (p_krpv_rec.DAYS_IN_A_YEAR_CODE IS NOT NULL AND
717: p_krpv_rec.DAYS_IN_A_YEAR_CODE <> G_MISS_CHAR)) AND
718: (l_orig_rate_rec.DAYS_IN_A_YEAR_CODE <> p_krpv_rec.DAYS_IN_A_YEAR_CODE) THEN
719: OKC_API.SET_MESSAGE( p_app_name => G_APP_NAME
720: ,p_msg_name => 'OKL_LLA_VAR_RATE_INT_PROC'
721: ,p_token1 => 'PARAMETER_NAME'
722: ,p_token1_value => 'DAYS_IN_A_YEAR_CODE'
723: ,p_token2 => 'CONTRACT_NUMBER'

Line 733: OKC_API.SET_MESSAGE( p_app_name => G_APP_NAME

729: l_orig_rate_rec.CATCHUP_START_DATE <> G_MISS_DATE) OR
730: (p_krpv_rec.CATCHUP_START_DATE IS NOT NULL AND
731: p_krpv_rec.CATCHUP_START_DATE <> G_MISS_DATE)) AND
732: (l_orig_rate_rec.CATCHUP_START_DATE <> p_krpv_rec.CATCHUP_START_DATE) THEN
733: OKC_API.SET_MESSAGE( p_app_name => G_APP_NAME
734: ,p_msg_name => 'OKL_LLA_VAR_RATE_INT_PROC'
735: ,p_token1 => 'PARAMETER_NAME'
736: ,p_token1_value => 'CATCHUP_START_DATE'
737: ,p_token2 => 'CONTRACT_NUMBER'

Line 747: OKC_API.SET_MESSAGE( p_app_name => G_APP_NAME

743: l_orig_rate_rec.CATCHUP_SETTLEMENT_CODE <> G_MISS_CHAR) OR
744: (p_krpv_rec.CATCHUP_SETTLEMENT_CODE IS NOT NULL AND
745: p_krpv_rec.CATCHUP_SETTLEMENT_CODE <> G_MISS_CHAR)) AND
746: (l_orig_rate_rec.CATCHUP_SETTLEMENT_CODE <> p_krpv_rec.CATCHUP_SETTLEMENT_CODE) THEN
747: OKC_API.SET_MESSAGE( p_app_name => G_APP_NAME
748: ,p_msg_name => 'OKL_LLA_VAR_RATE_INT_PROC'
749: ,p_token1 => 'PARAMETER_NAME'
750: ,p_token1_value => 'CATCHUP_SETTLEMENT_CODE'
751: ,p_token2 => 'CONTRACT_NUMBER'

Line 761: OKC_API.SET_MESSAGE( p_app_name => G_APP_NAME

757: l_orig_rate_rec.RATE_CHANGE_START_DATE <> G_MISS_DATE) OR
758: (p_krpv_rec.RATE_CHANGE_START_DATE IS NOT NULL AND
759: p_krpv_rec.RATE_CHANGE_START_DATE <> G_MISS_DATE)) AND
760: (l_orig_rate_rec.RATE_CHANGE_START_DATE <> p_krpv_rec.RATE_CHANGE_START_DATE) THEN
761: OKC_API.SET_MESSAGE( p_app_name => G_APP_NAME
762: ,p_msg_name => 'OKL_LLA_VAR_RATE_INT_PROC'
763: ,p_token1 => 'PARAMETER_NAME'
764: ,p_token1_value => 'RATE_CHANGE_START_DATE'
765: ,p_token2 => 'CONTRACT_NUMBER'

Line 840: OKC_API.SET_MESSAGE(

836: -- IF any of the above values changed
837: IF (l_deal_type IN ('LEASEOP', 'LEASEDF', 'LEASEST') AND
838: l_interest_calculation_basis IN ('FIXED', 'FLOAT_FACTORS')) THEN
839: IF (p_krpv_rec.EFFECTIVE_FROM_DATE < l_orig_rate_rec.EFFECTIVE_FROM_DATE) THEN
840: OKC_API.SET_MESSAGE(
841: p_app_name => G_APP_NAME
842: ,p_msg_name => 'OKL_LLA_VAR_RATE_EFF_DATE');
843: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
844: END IF;

Line 850: OKC_API.SET_MESSAGE(

846: l_interest_calculation_basis = 'REAMORT' ) THEN
847: IF (p_krpv_rec.EFFECTIVE_FROM_DATE <= l_rebook_date) OR
848: (p_krpv_rec.EFFECTIVE_FROM_DATE <= l_last_interest_calc_date)
849: THEN
850: OKC_API.SET_MESSAGE(
851: p_app_name => G_APP_NAME
852: ,p_msg_name => 'OKL_LLA_VAR_RATE_RBK_DATE');
853: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
854: END IF;

Line 863: OKC_API.SET_MESSAGE(

859: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'p_krpv_rec.effective_from_date=' || p_krpv_rec.effective_from_date);
860: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_orig_rate_rec.effective_from_date=' || l_orig_rate_rec.effective_from_date);
861: END IF;
862: IF (p_krpv_rec.EFFECTIVE_FROM_DATE < l_orig_rate_rec.EFFECTIVE_FROM_DATE) THEN
863: OKC_API.SET_MESSAGE(
864: p_app_name => G_APP_NAME
865: ,p_msg_name => 'OKL_LLA_VAR_RATE_EFF_DATE');
866: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
867: END IF;

Line 873: OKC_API.SET_MESSAGE(

869: l_interest_calculation_basis = 'REAMORT') THEN
870: IF (p_krpv_rec.EFFECTIVE_FROM_DATE <= l_rebook_date) OR
871: (p_krpv_rec.EFFECTIVE_FROM_DATE <= l_last_interest_calc_date)
872: THEN
873: OKC_API.SET_MESSAGE(
874: p_app_name => G_APP_NAME
875: ,p_msg_name => 'OKL_LLA_VAR_RATE_RBK_DATE');
876: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
877: END IF;

Line 881: OKC_API.SET_MESSAGE(

877: END IF;
878: ELSIF (l_deal_type = 'LOAN-REVOLVING' AND
879: l_interest_calculation_basis = 'FLOAT') THEN
880: IF (p_krpv_rec.EFFECTIVE_FROM_DATE < l_orig_rate_rec.EFFECTIVE_FROM_DATE) THEN
881: OKC_API.SET_MESSAGE(
882: p_app_name => G_APP_NAME
883: ,p_msg_name => 'OKL_LLA_VAR_RATE_EFF_DATE');
884: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
885: END IF;

Line 927: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

923: /* This is to be called from contract import and UI*/
924: --Zero
925: PROCEDURE create_k_rate_params(
926: p_api_version IN NUMBER,
927: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
928: x_return_status OUT NOCOPY VARCHAR2,
929: x_msg_count OUT NOCOPY NUMBER,
930: x_msg_data OUT NOCOPY VARCHAR2,
931: p_krpv_rec IN krpv_rec_type,

Line 1064: OKC_API.SET_MESSAGE( p_app_name => G_APP_NAME

1060: l_rate_count := r.count1;
1061: END LOOP;
1062:
1063: IF (l_rate_count > 0) THEN
1064: OKC_API.SET_MESSAGE( p_app_name => G_APP_NAME
1065: ,p_msg_name => 'OKL_LLA_VAR_RATE_EXISTS');
1066: RAISE OKL_API.G_EXCEPTION_ERROR;
1067: END IF;
1068: END IF;

Line 1168: OKC_API.set_message(p_app_name => G_APP_NAME,

1164: (l_krpv_rec.rate_delay_frequency is NULL OR
1165: l_krpv_rec.rate_delay_frequency = G_MISS_NUM) THEN
1166: NULL;
1167: ELSE
1168: OKC_API.set_message(p_app_name => G_APP_NAME,
1169: p_msg_name => G_REQUIRED_VALUE,
1170: p_token1 => G_COL_NAME_TOKEN,
1171: p_token1_value => 'CATCHUP FREQUENCY');
1172: RAISE OKL_API.G_EXCEPTION_ERROR;

Line 1181: OKC_API.set_message(p_app_name => G_APP_NAME,

1177: IF (l_krpv_rec.catchup_frequency_code is NOT NULL AND
1178: l_krpv_rec.catchup_frequency_code <> G_MISS_CHAR) THEN
1179: NULL;
1180: ELSE
1181: OKC_API.set_message(p_app_name => G_APP_NAME,
1182: p_msg_name => G_REQUIRED_VALUE,
1183: p_token1 => G_COL_NAME_TOKEN,
1184: p_token1_value => 'Catchup Frequency');
1185: RAISE OKL_API.G_EXCEPTION_ERROR;

Line 1202: OKC_API.set_message(p_app_name => G_APP_NAME,

1198: IF (l_krpv_rec.catchup_settlement_code is NOT NULL AND
1199: l_krpv_rec.catchup_settlement_code <> G_MISS_CHAR) THEN
1200: NULL;
1201: ELSE
1202: OKC_API.set_message(p_app_name => G_APP_NAME,
1203: p_msg_name => G_REQUIRED_VALUE,
1204: p_token1 => G_COL_NAME_TOKEN,
1205: p_token1_value => 'Catchup Settlement');
1206: RAISE OKL_API.G_EXCEPTION_ERROR;

Line 1214: OKC_API.set_message(p_app_name => G_APP_NAME,

1210: IF (l_krpv_rec.catchup_basis_code is NOT NULL AND
1211: l_krpv_rec.catchup_basis_code <> G_MISS_CHAR) THEN
1212: NULL;
1213: ELSE
1214: OKC_API.set_message(p_app_name => G_APP_NAME,
1215: p_msg_name => G_REQUIRED_VALUE,
1216: p_token1 => G_COL_NAME_TOKEN,
1217: p_token1_value => 'Catchup Basis');
1218: RAISE OKL_API.G_EXCEPTION_ERROR;

Line 1249: OKC_API.set_message(p_app_name => G_APP_NAME,

1245: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'p_krpv_rec.effective_from_Date=' || p_krpv_rec.effective_from_Date);
1246: END IF;
1247: IF (l_last_billed_due_date IS NOT NULL AND
1248: p_krpv_rec.effective_from_Date <= l_last_billed_due_date) THEN
1249: OKC_API.set_message(p_app_name => G_APP_NAME,
1250: p_msg_name => 'OKL_LLA_VAR_RATE_INT_DATE',
1251: p_token1 => 'EFF_DATE',
1252: p_token1_value => p_krpv_rec.effective_from_Date,
1253: p_token2 => 'INTEREST_DATE',

Line 1263: OKC_API.set_message(p_app_name => G_APP_NAME,

1259: -- Bug 4999888
1260: IF (l_pdt_parameter_rec.interest_calculation_basis IN ('FLOAT', 'REAMORT', 'FLOAT_FACTORS', 'CATCHUP/CLEANUP')) THEN
1261: IF (l_last_interest_cal_date IS NOT NULL) THEN
1262: IF (p_krpv_rec.effective_from_Date <= l_last_interest_cal_date) THEN
1263: OKC_API.set_message(p_app_name => G_APP_NAME,
1264: p_msg_name => 'OKL_LLA_VAR_RATE_INT_DATE',
1265: p_token1 => 'EFF_DATE',
1266: p_token1_value => p_krpv_rec.effective_from_Date,
1267: p_token2 => 'INTEREST_DATE',

Line 1373: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

1369:
1370: -- First
1371: PROCEDURE create_k_rate_params(
1372: p_api_version IN NUMBER,
1373: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
1374: x_return_status OUT NOCOPY VARCHAR2,
1375: x_msg_count OUT NOCOPY NUMBER,
1376: x_msg_data OUT NOCOPY VARCHAR2,
1377: p_krpr_rec IN krpr_rec_type,

Line 1497: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

1493:
1494: -- Second
1495: PROCEDURE create_k_rate_params(
1496: p_api_version IN NUMBER,
1497: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
1498: x_return_status OUT NOCOPY VARCHAR2,
1499: x_msg_count OUT NOCOPY NUMBER,
1500: x_msg_data OUT NOCOPY VARCHAR2,
1501: p_krpar_rec IN krpar_rec_type,

Line 1618: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

1614:
1615: -- Third
1616: PROCEDURE create_k_rate_params(
1617: p_api_version IN NUMBER,
1618: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
1619: x_return_status OUT NOCOPY VARCHAR2,
1620: x_msg_count OUT NOCOPY NUMBER,
1621: x_msg_data OUT NOCOPY VARCHAR2,
1622: p_krpc_rec IN krpc_rec_type,

Line 1726: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

1722: /* For both UI and contract import */
1723: --Zero
1724: PROCEDURE update_k_rate_params(
1725: p_api_version IN NUMBER,
1726: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
1727: x_return_status OUT NOCOPY VARCHAR2,
1728: x_msg_count OUT NOCOPY NUMBER,
1729: x_msg_data OUT NOCOPY VARCHAR2,
1730: p_krpv_rec IN krpv_rec_type,

Line 1911: OKC_API.set_message(p_app_name => G_APP_NAME,

1907: (l_krpv_rec.rate_delay_frequency is NULL OR
1908: l_krpv_rec.rate_delay_frequency = G_MISS_NUM) THEN
1909: NULL;
1910: ELSE
1911: OKC_API.set_message(p_app_name => G_APP_NAME,
1912: p_msg_name => G_REQUIRED_VALUE,
1913: p_token1 => G_COL_NAME_TOKEN,
1914: p_token1_value => 'CATCHUP FREQUENCY');
1915: RAISE OKL_API.G_EXCEPTION_ERROR;

Line 1927: OKC_API.set_message(p_app_name => G_APP_NAME,

1923: IF (l_krpv_rec.catchup_frequency_code is NOT NULL AND
1924: l_krpv_rec.catchup_frequency_code <> G_MISS_CHAR) THEN
1925: NULL;
1926: ELSE
1927: OKC_API.set_message(p_app_name => G_APP_NAME,
1928: p_msg_name => G_REQUIRED_VALUE,
1929: p_token1 => G_COL_NAME_TOKEN,
1930: p_token1_value => 'Catchup Frequency');
1931: RAISE OKL_API.G_EXCEPTION_ERROR;

Line 1952: OKC_API.set_message(p_app_name => G_APP_NAME,

1948: IF (l_krpv_rec.catchup_settlement_code is NOT NULL AND
1949: l_krpv_rec.catchup_settlement_code <> G_MISS_CHAR) THEN
1950: NULL;
1951: ELSE
1952: OKC_API.set_message(p_app_name => G_APP_NAME,
1953: p_msg_name => G_REQUIRED_VALUE,
1954: p_token1 => G_COL_NAME_TOKEN,
1955: p_token1_value => 'Catchup Settlement');
1956: RAISE OKL_API.G_EXCEPTION_ERROR;

Line 1966: OKC_API.set_message(p_app_name => G_APP_NAME,

1962: IF (l_krpv_rec.catchup_basis_code is NOT NULL AND
1963: l_krpv_rec.catchup_basis_code <> G_MISS_CHAR) THEN
1964: NULL;
1965: ELSE
1966: OKC_API.set_message(p_app_name => G_APP_NAME,
1967: p_msg_name => G_REQUIRED_VALUE,
1968: p_token1 => G_COL_NAME_TOKEN,
1969: p_token1_value => 'Catchup Basis');
1970: RAISE OKL_API.G_EXCEPTION_ERROR;

Line 2053: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

2049:
2050: -- First
2051: PROCEDURE update_k_rate_params(
2052: p_api_version IN NUMBER,
2053: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
2054: x_return_status OUT NOCOPY VARCHAR2,
2055: x_msg_count OUT NOCOPY NUMBER,
2056: x_msg_data OUT NOCOPY VARCHAR2,
2057: p_krpr_rec IN krpr_rec_type,

Line 2157: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

2153:
2154: -- Second
2155: PROCEDURE update_k_rate_params(
2156: p_api_version IN NUMBER,
2157: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
2158: x_return_status OUT NOCOPY VARCHAR2,
2159: x_msg_count OUT NOCOPY NUMBER,
2160: x_msg_data OUT NOCOPY VARCHAR2,
2161: p_krpar_rec IN krpar_rec_type,

Line 2261: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

2257:
2258: -- Third
2259: PROCEDURE update_k_rate_params(
2260: p_api_version IN NUMBER,
2261: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
2262: x_return_status OUT NOCOPY VARCHAR2,
2263: x_msg_count OUT NOCOPY NUMBER,
2264: x_msg_data OUT NOCOPY VARCHAR2,
2265: p_krpc_rec IN krpc_rec_type,

Line 2350: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

2346: end;
2347:
2348: PROCEDURE delete_k_rate_params(
2349: p_api_version IN NUMBER,
2350: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
2351: x_return_status OUT NOCOPY VARCHAR2,
2352: x_msg_count OUT NOCOPY NUMBER,
2353: x_msg_data OUT NOCOPY VARCHAR2,
2354: p_krpdel_tbl IN krpdel_tbl_type) IS

Line 2427: OKC_API.set_message(p_app_name => G_APP_NAME,

2423: --Bug# 7440232
2424: ELSIF (p_krpdel_tbl(i).rate_type IN ('INTEREST_RATE_PARAMS_CONV')) THEN
2425: l_parameter_type_code := 'CONVERSION';
2426: ELSE
2427: OKC_API.set_message(p_app_name => G_APP_NAME,
2428: p_msg_name => 'OKL_LLA_VAR_RATE_INV_PARAM');
2429: RAISE OKL_API.G_EXCEPTION_ERROR;
2430: END IF;
2431:

Line 2448: OKC_API.set_message(p_app_name => G_APP_NAME,

2444: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_orig_system_source_code=' || l_orig_system_source_code);
2445: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_orig_system_id1=' || l_orig_system_id1);
2446: END IF;
2447: IF (l_effective_to_date IS NOT NULL) THEN
2448: OKC_API.set_message(p_app_name => G_APP_NAME,
2449: p_msg_name => 'OKL_LLA_VAR_RATE_DELETE_ERR');
2450: RAISE OKL_API.G_EXCEPTION_ERROR;
2451: END IF;
2452:

Line 2455: OKC_API.set_message(p_app_name => G_APP_NAME,

2451: END IF;
2452:
2453: --Bug# 7440232
2454: IF (l_sts_code = 'BOOKED') THEN
2455: OKC_API.set_message(p_app_name => G_APP_NAME,
2456: p_msg_name => 'OKL_LLA_VAR_RATE_DELETE_ERR1');
2457: RAISE OKL_API.G_EXCEPTION_ERROR;
2458: END IF;
2459:

Line 2479: OKC_API.set_message(p_app_name => G_APP_NAME,

2475:
2476: --Bug# 7440232
2477: IF (l_orig_effective_from_date =
2478: p_krpdel_tbl(i).effective_from_date) THEN
2479: OKC_API.set_message(p_app_name => G_APP_NAME,
2480: p_msg_name => 'OKL_LLA_VAR_RATE_DELETE_ERR2');
2481: RAISE OKL_API.G_EXCEPTION_ERROR;
2482: END IF;
2483:

Line 2663: OKC_API.set_message(p_app_name => G_APP_NAME,

2659: END LOOP;
2660:
2661: IF (l_orig_effective_from_date =
2662: p_krpdel_tbl(i).effective_from_date) THEN
2663: OKC_API.set_message(p_app_name => G_APP_NAME,
2664: p_msg_name => 'OKL_LA_VAR_RATE_DELETE_ERR2');
2665: RAISE OKL_API.G_EXCEPTION_ERROR;
2666: END IF;*/
2667:

Line 2734: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

2730:
2731: /* For QA checker to call - stack Error messages and no raise exception*/
2732: PROCEDURE validate_k_rate_params(
2733: p_api_version IN NUMBER,
2734: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
2735: x_return_status OUT NOCOPY VARCHAR2,
2736: x_msg_count OUT NOCOPY NUMBER,
2737: x_msg_data OUT NOCOPY VARCHAR2,
2738: p_khr_id IN okc_k_headers_b.id%type,

Line 2905: OKC_API.SET_MESSAGE( p_app_name => G_APP_NAME

2901: (l_interest_calculation_basis IN ('FIXED', 'REAMORT'))) OR
2902: ((l_deal_type = 'LOAN') AND
2903: (l_interest_calculation_basis = 'REAMORT')) ) THEN
2904: IF (l_k_rate_tbl.COUNT > 0) THEN
2905: OKC_API.SET_MESSAGE( p_app_name => G_APP_NAME
2906: ,p_msg_name => G_OKL_LLA_VAR_RATE_ERROR
2907: ,p_token1 => G_LEASE_TYPE
2908: ,p_token1_value => 'LEASEOP,LEASEDF,LEASEST'
2909: ,p_token2 => G_INT_BASIS

Line 2928: OKC_API.SET_MESSAGE( p_app_name => G_APP_NAME

2924: l_revenue_recognition_method = 'ACTUAL') )) OR
2925: ((l_deal_type = 'LOAN-REVOLVING') AND
2926: (l_interest_calculation_basis = 'FLOAT')) ) THEN
2927: IF (l_k_rate_tbl.COUNT < 1) THEN
2928: OKC_API.SET_MESSAGE( p_app_name => G_APP_NAME
2929: ,p_msg_name => G_OKL_LLA_VAR_RATE_MISSING
2930: ,p_token1 => G_CONT_ID
2931: ,p_token1_value => p_khr_id);
2932: RAISE OKL_API.G_EXCEPTION_ERROR;

Line 2974: OKC_API.set_message(p_app_name => G_APP_NAME,

2970: IF (l_k_rate_tbl(i).catchup_frequency_code is NOT NULL AND
2971: l_k_rate_tbl(i).catchup_frequency_code <> G_MISS_CHAR) THEN
2972: NULL;
2973: ELSE
2974: OKC_API.set_message(p_app_name => G_APP_NAME,
2975: p_msg_name => G_REQUIRED_VALUE,
2976: p_token1 => G_COL_NAME_TOKEN,
2977: p_token1_value => 'Catchup Frequency');
2978: RAISE OKL_API.G_EXCEPTION_ERROR;

Line 2994: OKC_API.set_message(p_app_name => G_APP_NAME,

2990: IF (l_k_rate_tbl(i).catchup_settlement_code is NOT NULL AND
2991: l_k_rate_tbl(i).catchup_settlement_code <> G_MISS_CHAR) THEN
2992: NULL;
2993: ELSE
2994: OKC_API.set_message(p_app_name => G_APP_NAME,
2995: p_msg_name => G_REQUIRED_VALUE,
2996: p_token1 => G_COL_NAME_TOKEN,
2997: p_token1_value => 'Catchup Settlement');
2998: RAISE OKL_API.G_EXCEPTION_ERROR;

Line 3006: OKC_API.set_message(p_app_name => G_APP_NAME,

3002: IF (l_k_rate_tbl(i).catchup_basis_code is NOT NULL AND
3003: l_k_rate_tbl(i).catchup_basis_code <> G_MISS_CHAR) THEN
3004: NULL;
3005: ELSE
3006: OKC_API.set_message(p_app_name => G_APP_NAME,
3007: p_msg_name => G_REQUIRED_VALUE,
3008: p_token1 => G_COL_NAME_TOKEN,
3009: p_token1_value => 'Catchup Basis');
3010: RAISE OKL_API.G_EXCEPTION_ERROR;

Line 3051: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

3047:
3048: /* For UI/contract import to call */
3049: PROCEDURE validate_k_rate_params(
3050: p_api_version IN NUMBER,
3051: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
3052: x_return_status OUT NOCOPY VARCHAR2,
3053: x_msg_count OUT NOCOPY NUMBER,
3054: x_msg_data OUT NOCOPY VARCHAR2,
3055: p_product_id IN okl_products_v.id%type,

Line 3143: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

3139: -- End of comments
3140:
3141: Procedure generate_rate_summary(
3142: p_api_version IN NUMBER,
3143: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
3144: x_return_status OUT NOCOPY VARCHAR2,
3145: x_msg_count OUT NOCOPY NUMBER,
3146: x_msg_data OUT NOCOPY VARCHAR2,
3147: p_chr_id IN NUMBER,

Line 3349: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

3345: -- Default the values based on business rules
3346:
3347: PROCEDURE default_k_rate_params(
3348: p_api_version IN NUMBER,
3349: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
3350: x_return_status OUT NOCOPY VARCHAR2,
3351: x_msg_count OUT NOCOPY NUMBER,
3352: x_msg_data OUT NOCOPY VARCHAR2,
3353: p_deal_type IN okl_product_parameters_v.deal_type%type,

Line 3359: x_return_status := OKC_API.G_RET_STS_SUCCESS;

3355: p_int_calc_basis IN okl_product_parameters_v.interest_calculation_basis%type,
3356: p_column_name IN VARCHAR2,
3357: p_krpv_rec IN OUT NOCOPY krpv_rec_type) IS
3358: BEGIN
3359: x_return_status := OKC_API.G_RET_STS_SUCCESS;
3360:
3361: IF (p_column_name = 'PRINCIPAL_BASIS_CODE' OR p_column_name = 'ALL') THEN
3362: IF (p_deal_type IN ('LEASEOP', 'LEASEDF', 'LEASEST') AND
3363: (p_int_calc_basis = 'REAMORT' AND p_rev_rec_method = 'STREAMS')) THEN

Line 3463: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

3459: END;
3460:
3461: PROCEDURE cascade_contract_start_date(
3462: p_api_version IN NUMBER,
3463: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
3464: x_return_status OUT NOCOPY VARCHAR2,
3465: x_msg_count OUT NOCOPY NUMBER,
3466: x_msg_data OUT NOCOPY VARCHAR2,
3467: p_chr_id IN OKC_K_HEADERS_B.ID%TYPE,

Line 3492: x_return_status := OKC_API.G_RET_STS_SUCCESS;

3488: l_catchup_start_date DATE;
3489:
3490:
3491: BEGIN
3492: x_return_status := OKC_API.G_RET_STS_SUCCESS;
3493: x_return_status := OKL_API.START_ACTIVITY(
3494: p_api_name => l_api_name,
3495: p_pkg_name => g_pkg_name,
3496: p_init_msg_list => p_init_msg_list,

Line 3529: OKC_API.SET_MESSAGE( p_app_name => G_APP_NAME

3525:
3526: IF (l_interest_processing_started) THEN
3527: -- Parameters RATE_CHANGE_START_DATE can not be updated because
3528: -- Interest Processing has already started for contract CONTRACT_NUMBER.
3529: OKC_API.SET_MESSAGE( p_app_name => G_APP_NAME
3530: ,p_msg_name => 'OKL_LLA_VAR_RATE_INT_PROC'
3531: ,p_token1 => 'PARAMETER_NAME'
3532: --,p_token1_value => 'INTEREST_START_DATE'
3533: ,p_token1_value =>

Line 3567: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN

3563: x_msg_data ,
3564: p_chr_id ,
3565: l_effective_from_date,
3566: l_no_data_found);
3567: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
3568: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3569: END IF;
3570:
3571: IF NOT(l_no_data_found) THEN

Line 3607: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN

3603: x_msg_data => x_msg_data,
3604: p_krpv_rec => l_krpv_rec,
3605: x_krpv_rec => x_krpv_rec);
3606: --p_validate_flag => 'Y');
3607: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
3608: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3609: END IF; */
3610:
3611: update okl_k_rate_params

Line 3684: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

3680: --End of Comments
3681: ------------------------------------------------------------------------------
3682: PROCEDURE check_rebook_allowed (
3683: p_api_version IN NUMBER,
3684: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
3685: x_return_status OUT NOCOPY VARCHAR2,
3686: x_msg_count OUT NOCOPY NUMBER,
3687: x_msg_data OUT NOCOPY VARCHAR2,
3688: p_chr_id IN OKC_K_HEADERS_B.ID%TYPE,

Line 3869: OKC_API.SET_MESSAGE( p_app_name => G_APP_NAME

3865:
3866: IF (l_book_class = G_BOOK_CLASS_OP) THEN
3867: IF (l_interest_calc_basis NOT IN
3868: (G_ICB_FIXED, G_ICB_FLOAT_FACTOR, G_ICB_REAMORT )) THEN
3869: OKC_API.SET_MESSAGE( p_app_name => G_APP_NAME
3870: ,p_msg_name => G_OKL_LLA_REBOOK_INVALID
3871: ,p_token1 => G_BOOK_CLASS
3872: ,p_token1_value => l_book_class_meaning
3873: ,p_token2 => G_INT_CALC_BASIS

Line 3884: OKC_API.SET_MESSAGE( p_app_name => G_APP_NAME

3880: IF ( l_interest_proc_date IS NOT NULL ) THEN
3881: IF (l_mass_rebook_flag = OKL_API.G_TRUE) THEN -- 4766555
3882: NULL;
3883: ELSE
3884: OKC_API.SET_MESSAGE( p_app_name => G_APP_NAME
3885: ,p_msg_name => G_OKL_LLA_RBK_INT_PROC_INVAL
3886: ,p_token1 => G_COL_NAME
3887: ,p_token1_value => l_contract_number);
3888: RAISE OKL_API.G_EXCEPTION_ERROR;

Line 3905: OKC_API.SET_MESSAGE( p_app_name => G_APP_NAME

3901: CLOSE get_last_accrued_due_date; */
3902:
3903: IF ( l_last_billed_due_date IS NOT NULL
3904: AND p_rebook_date <= l_last_billed_due_date) THEN
3905: OKC_API.SET_MESSAGE( p_app_name => G_APP_NAME
3906: ,p_msg_name => G_OKL_LLA_RBK_DATE_BILL_INVAL
3907: ,p_token1 => G_STREAM
3908: ,p_token1_value => l_stream_name
3909: ,p_token2 => G_DUE_DATE

Line 3914: OKC_API.SET_MESSAGE( p_app_name => G_APP_NAME

3910: ,p_token2_value => l_last_billed_due_date);
3911: RAISE OKL_API.G_EXCEPTION_ERROR;
3912: /*ELSIF ( l_last_accrued_due_date IS NOT NULL
3913: AND p_rebook_date <= l_last_accrued_due_date) THEN
3914: OKC_API.SET_MESSAGE( p_app_name => G_APP_NAME
3915: ,p_msg_name => G_OKL_LLA_RBK_DATE_ACCR_INVAL
3916: ,p_token1 => G_STREAM
3917: ,p_token1_value => l_stream_name
3918: ,p_token2 => G_DUE_DATE

Line 3930: OKC_API.SET_MESSAGE( p_app_name => G_APP_NAME

3926: -- Check for Sales Type Lease
3927: ELSIF (l_book_class = G_BOOK_CLASS_ST) THEN
3928: IF (l_interest_calc_basis NOT IN
3929: (G_ICB_FIXED, G_ICB_FLOAT_FACTOR, G_ICB_REAMORT )) THEN
3930: OKC_API.SET_MESSAGE( p_app_name => G_APP_NAME
3931: ,p_msg_name => G_OKL_LLA_REBOOK_INVALID
3932: ,p_token1 => G_BOOK_CLASS
3933: ,p_token1_value => l_book_class_meaning
3934: ,p_token2 => G_INT_CALC_BASIS

Line 3944: OKC_API.SET_MESSAGE( p_app_name => G_APP_NAME

3940: IF ( l_interest_proc_date IS NOT NULL ) THEN
3941: IF (l_mass_rebook_flag = OKL_API.G_TRUE) THEN -- 4766555
3942: NULL;
3943: ELSE
3944: OKC_API.SET_MESSAGE( p_app_name => G_APP_NAME
3945: ,p_msg_name => G_OKL_LLA_RBK_INT_PROC_INVAL
3946: ,p_token1 => G_COL_NAME
3947: ,p_token1_value => l_contract_number);
3948: RAISE OKL_API.G_EXCEPTION_ERROR;

Line 3966: OKC_API.SET_MESSAGE( p_app_name => G_APP_NAME

3962: CLOSE get_last_accrued_due_date; */
3963:
3964: IF ( l_last_billed_due_date IS NOT NULL AND
3965: p_rebook_date <= l_last_billed_due_date) THEN
3966: OKC_API.SET_MESSAGE( p_app_name => G_APP_NAME
3967: ,p_msg_name => G_OKL_LLA_RBK_DATE_BILL_INVAL
3968: ,p_token1 => G_STREAM
3969: ,p_token1_value => l_stream_name
3970: ,p_token2 => G_DUE_DATE

Line 3975: OKC_API.SET_MESSAGE( p_app_name => G_APP_NAME

3971: ,p_token2_value => l_last_billed_due_date);
3972: RAISE OKL_API.G_EXCEPTION_ERROR;
3973: /*ELSIF ( l_last_accrued_due_date IS NOT NULL AND
3974: p_rebook_date <= l_last_accrued_due_date) THEN
3975: OKC_API.SET_MESSAGE( p_app_name => G_APP_NAME
3976: ,p_msg_name => G_OKL_LLA_RBK_DATE_ACCR_INVAL
3977: ,p_token1 => G_STREAM
3978: ,p_token1_value => l_stream_name
3979: ,p_token2 => G_DUE_DATE

Line 3991: OKC_API.SET_MESSAGE( p_app_name => G_APP_NAME

3987: -- Check for Direct Finance Lease
3988: ELSIF (l_book_class = G_BOOK_CLASS_DF) THEN
3989: IF (l_interest_calc_basis NOT IN
3990: (G_ICB_FIXED, G_ICB_FLOAT_FACTOR, G_ICB_REAMORT )) THEN
3991: OKC_API.SET_MESSAGE( p_app_name => G_APP_NAME
3992: ,p_msg_name => G_OKL_LLA_REBOOK_INVALID
3993: ,p_token1 => G_BOOK_CLASS
3994: ,p_token1_value => l_book_class_meaning
3995: ,p_token2 => G_INT_CALC_BASIS

Line 4006: OKC_API.SET_MESSAGE( p_app_name => G_APP_NAME

4002: IF ( l_interest_proc_date IS NOT NULL ) THEN
4003: IF (l_mass_rebook_flag = OKL_API.G_TRUE) THEN -- 4766555
4004: NULL;
4005: ELSE
4006: OKC_API.SET_MESSAGE( p_app_name => G_APP_NAME
4007: ,p_msg_name => G_OKL_LLA_RBK_INT_PROC_INVAL
4008: ,p_token1 => G_COL_NAME
4009: ,p_token1_value => l_contract_number);
4010: RAISE OKL_API.G_EXCEPTION_ERROR;

Line 4028: OKC_API.SET_MESSAGE( p_app_name => G_APP_NAME

4024: CLOSE get_last_accrued_due_date; */
4025:
4026: IF ( l_last_billed_due_date IS NOT NULL AND
4027: p_rebook_date <= l_last_billed_due_date) THEN
4028: OKC_API.SET_MESSAGE( p_app_name => G_APP_NAME
4029: ,p_msg_name => G_OKL_LLA_RBK_DATE_BILL_INVAL
4030: ,p_token1 => G_STREAM
4031: ,p_token1_value => l_stream_name
4032: ,p_token2 => G_DUE_DATE

Line 4037: OKC_API.SET_MESSAGE( p_app_name => G_APP_NAME

4033: ,p_token2_value => l_last_billed_due_date);
4034: RAISE OKL_API.G_EXCEPTION_ERROR;
4035: /*ELSIF ( l_last_accrued_due_date IS NOT NULL AND
4036: p_rebook_date <= l_last_accrued_due_date) THEN
4037: OKC_API.SET_MESSAGE( p_app_name => G_APP_NAME
4038: ,p_msg_name => G_OKL_LLA_RBK_DATE_ACCR_INVAL
4039: ,p_token1 => G_STREAM
4040: ,p_token1_value => l_stream_name
4041: ,p_token2 => G_DUE_DATE

Line 4053: OKC_API.SET_MESSAGE( p_app_name => G_APP_NAME

4049: -- Check for Loan
4050: ELSIF (l_book_class = G_BOOK_CLASS_LOAN) THEN
4051: IF (l_interest_calc_basis NOT IN
4052: (G_ICB_FIXED, G_ICB_FLOAT, G_ICB_REAMORT, G_ICB_CATCHUP_CLEANUP)) THEN
4053: OKC_API.SET_MESSAGE( p_app_name => G_APP_NAME
4054: ,p_msg_name => G_OKL_LLA_REBOOK_INVALID
4055: ,p_token1 => G_BOOK_CLASS
4056: ,p_token1_value => l_book_class_meaning
4057: ,p_token2 => G_INT_CALC_BASIS

Line 4067: OKC_API.SET_MESSAGE( p_app_name => G_APP_NAME

4063: IF ( l_interest_proc_date IS NOT NULL ) THEN
4064: IF (l_mass_rebook_flag = OKL_API.G_TRUE) THEN -- 4766555
4065: NULL;
4066: ELSE
4067: OKC_API.SET_MESSAGE( p_app_name => G_APP_NAME
4068: ,p_msg_name => G_OKL_LLA_RBK_INT_PROC_INVAL
4069: ,p_token1 => G_COL_NAME
4070: ,p_token1_value => l_contract_number);
4071: RAISE OKL_API.G_EXCEPTION_ERROR;

Line 4089: OKC_API.SET_MESSAGE( p_app_name => G_APP_NAME

4085: CLOSE get_last_accrued_due_date; */
4086:
4087: IF ( l_last_billed_due_date IS NOT NULL
4088: AND p_rebook_date <= l_last_billed_due_date) THEN
4089: OKC_API.SET_MESSAGE( p_app_name => G_APP_NAME
4090: ,p_msg_name => G_OKL_LLA_RBK_DATE_BILL_INVAL
4091: ,p_token1 => G_STREAM
4092: ,p_token1_value => l_stream_name
4093: ,p_token2 => G_DUE_DATE

Line 4098: OKC_API.SET_MESSAGE( p_app_name => G_APP_NAME

4094: ,p_token2_value => l_last_billed_due_date);
4095: RAISE OKL_API.G_EXCEPTION_ERROR;
4096: /*ELSIF ( l_last_accrued_due_date IS NOT NULL AND
4097: p_rebook_date <= l_last_accrued_due_date) THEN
4098: OKC_API.SET_MESSAGE( p_app_name => G_APP_NAME
4099: ,p_msg_name => G_OKL_LLA_RBK_DATE_ACCR_INVAL
4100: ,p_token1 => G_STREAM
4101: ,p_token1_value => l_stream_name
4102: ,p_token2 => G_DUE_DATE

Line 4128: OKC_API.SET_MESSAGE( p_app_name => G_APP_NAME

4124: CLOSE get_last_accrued_due_date; */
4125:
4126: IF ( l_last_billed_due_date IS NOT NULL AND
4127: p_rebook_date <= l_last_billed_due_date) THEN
4128: OKC_API.SET_MESSAGE( p_app_name => G_APP_NAME
4129: ,p_msg_name => G_OKL_LLA_RBK_DATE_BILL_INVAL
4130: ,p_token1 => G_STREAM
4131: ,p_token1_value => l_stream_name
4132: ,p_token2 => G_DUE_DATE

Line 4137: OKC_API.SET_MESSAGE( p_app_name => G_APP_NAME

4133: ,p_token2_value => l_last_billed_due_date);
4134: RAISE OKL_API.G_EXCEPTION_ERROR;
4135: /*ELSIF ( l_last_accrued_due_date IS NOT NULL AND
4136: p_rebook_date <= l_last_accrued_due_date) THEN
4137: OKC_API.SET_MESSAGE( p_app_name => G_APP_NAME
4138: ,p_msg_name => G_OKL_LLA_RBK_DATE_ACCR_INVAL
4139: ,p_token1 => G_STREAM
4140: ,p_token1_value => l_stream_name
4141: ,p_token2 => G_DUE_DATE

Line 4162: OKC_API.SET_MESSAGE( p_app_name => G_APP_NAME

4158: CLOSE get_last_accrued_due_date; */
4159:
4160: IF ( l_last_billed_due_date IS NOT NULL AND
4161: p_rebook_date <= l_last_billed_due_date) THEN
4162: OKC_API.SET_MESSAGE( p_app_name => G_APP_NAME
4163: ,p_msg_name => G_OKL_LLA_RBK_DATE_BILL_INVAL
4164: ,p_token1 => G_STREAM
4165: ,p_token1_value => l_stream_name
4166: ,p_token2 => G_DUE_DATE

Line 4171: OKC_API.SET_MESSAGE( p_app_name => G_APP_NAME

4167: ,p_token2_value => l_last_billed_due_date);
4168: RAISE OKL_API.G_EXCEPTION_ERROR;
4169: /*ELSIF ( l_last_accrued_due_date IS NOT NULL AND
4170: p_rebook_date <= l_last_accrued_due_date) THEN
4171: OKC_API.SET_MESSAGE( p_app_name => G_APP_NAME
4172: ,p_msg_name => G_OKL_LLA_RBK_DATE_ACCR_INVAL
4173: ,p_token1 => G_STREAM
4174: ,p_token1_value => l_stream_name
4175: ,p_token2 => G_DUE_DATE

Line 4185: OKC_API.SET_MESSAGE( p_app_name => G_APP_NAME

4181:
4182: -- Check for Revolving Loans
4183: ELSIF (l_book_class = G_BOOK_CLASS_REVLOAN) THEN
4184: IF (l_interest_calc_basis <> G_ICB_FLOAT) THEN
4185: OKC_API.SET_MESSAGE( p_app_name => G_APP_NAME
4186: ,p_msg_name => G_OKL_LLA_REBOOK_INVALID
4187: ,p_token1 => G_BOOK_CLASS
4188: ,p_token1_value => l_book_class_meaning
4189: ,p_token2 => G_INT_CALC_BASIS

Line 4210: OKC_API.SET_MESSAGE( p_app_name => G_APP_NAME

4206: CLOSE get_last_accrued_due_date; */
4207:
4208: IF ( l_last_billed_due_date IS NOT NULL AND
4209: p_rebook_date <= l_last_billed_due_date) THEN
4210: OKC_API.SET_MESSAGE( p_app_name => G_APP_NAME
4211: ,p_msg_name => G_OKL_LLA_RBK_DATE_BILL_INVAL
4212: ,p_token1 => G_STREAM
4213: ,p_token1_value => l_stream_name
4214: ,p_token2 => G_DUE_DATE

Line 4219: OKC_API.SET_MESSAGE( p_app_name => G_APP_NAME

4215: ,p_token2_value => l_last_billed_due_date);
4216: RAISE OKL_API.G_EXCEPTION_ERROR;
4217: /*ELSIF ( l_last_accrued_due_date IS NOT NULL AND
4218: p_rebook_date <= l_last_accrued_due_date) THEN
4219: OKC_API.SET_MESSAGE( p_app_name => G_APP_NAME
4220: ,p_msg_name => G_OKL_LLA_RBK_DATE_ACCR_INVAL
4221: ,p_token1 => G_STREAM
4222: ,p_token1_value => l_stream_name
4223: ,p_token2 => G_DUE_DATE

Line 4244: OKC_API.SET_MESSAGE( p_app_name => G_APP_NAME

4240: CLOSE get_last_accrued_due_date; */
4241:
4242: IF ( l_last_billed_due_date IS NOT NULL AND
4243: p_rebook_date <= l_last_billed_due_date) THEN
4244: OKC_API.SET_MESSAGE( p_app_name => G_APP_NAME
4245: ,p_msg_name => G_OKL_LLA_RBK_DATE_BILL_INVAL
4246: ,p_token1 => G_STREAM
4247: ,p_token1_value => l_stream_name
4248: ,p_token2 => G_DUE_DATE

Line 4253: OKC_API.SET_MESSAGE( p_app_name => G_APP_NAME

4249: ,p_token2_value => l_last_billed_due_date);
4250: RAISE OKL_API.G_EXCEPTION_ERROR;
4251: /*ELSIF ( l_last_accrued_due_date IS NOT NULL AND
4252: p_rebook_date <= l_last_accrued_due_date) THEN
4253: OKC_API.SET_MESSAGE( p_app_name => G_APP_NAME
4254: ,p_msg_name => G_OKL_LLA_RBK_DATE_ACCR_INVAL
4255: ,p_token1 => G_STREAM
4256: ,p_token1_value => l_stream_name
4257: ,p_token2 => G_DUE_DATE

Line 4662: RAISE OKC_API.G_EXCEPTION_ERROR;

4658: END IF;
4659: END LOOP;
4660: END IF;
4661:
4662: RAISE OKC_API.G_EXCEPTION_ERROR;
4663: END SYNC_RATE_PARAMS;
4664:
4665: PROCEDURE check_base_rate(
4666: p_khr_id IN NUMBER,

Line 4703: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

4699: END;
4700:
4701: PROCEDURE check_principal_payment(
4702: p_api_version IN NUMBER,
4703: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
4704: x_return_status OUT NOCOPY VARCHAR2,
4705: x_msg_count OUT NOCOPY NUMBER,
4706: x_msg_data OUT NOCOPY VARCHAR2,
4707: p_chr_id IN OKC_K_HEADERS_B.ID%TYPE,

Line 4812: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

4808: end;
4809:
4810: PROCEDURE copy_k_rate_params(
4811: p_api_version IN NUMBER,
4812: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
4813: x_return_status OUT NOCOPY VARCHAR2,
4814: x_msg_count OUT NOCOPY NUMBER,
4815: x_msg_data OUT NOCOPY VARCHAR2,
4816: p_khr_id IN NUMBER,

Line 4912: OKC_API.set_message(p_app_name => G_APP_NAME,

4908: l_parameter_type_code := 'ACTUAL';
4909: ELSIF (p_rate_type IN ('INTEREST_RATE_PARAMS_CONV', 'ADDL_INTEREST_RATE_PARAMS_CONV')) THEN
4910: l_parameter_type_code := 'CONVERSION';
4911: ELSE
4912: OKC_API.set_message(p_app_name => G_APP_NAME,
4913: p_msg_name => 'OKL_LLA_VAR_RATE_INV_PARAM');
4914: RAISE OKL_API.G_EXCEPTION_ERROR;
4915: END IF;
4916:

Line 4943: OKC_API.set_message(p_app_name => G_APP_NAME,

4939: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
4940: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'copy:l_orig_system_source_code=' || l_orig_system_source_code);
4941: END IF;
4942: IF (l_orig_system_source_code <> 'OKL_REBOOK') THEN
4943: OKC_API.set_message(p_app_name => G_APP_NAME,
4944: p_msg_name => 'OKL_LLA_VAR_RATE_COPY_NA');
4945: RAISE OKL_API.G_EXCEPTION_ERROR;
4946: END IF;
4947:

Line 4964: OKC_API.set_message(p_app_name => G_APP_NAME,

4960: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'p_effective_from_date=' || p_effective_from_date);
4961: END IF;
4962: IF (l_last_billed_due_date IS NOT NULL AND
4963: p_effective_from_date <= l_last_billed_due_date) THEN
4964: OKC_API.set_message(p_app_name => G_APP_NAME,
4965: p_msg_name => 'OKL_LLA_VAR_RATE_INT_DATE',
4966: p_token1 => 'EFF_DATE',
4967: p_token1_value => p_effective_from_date,
4968: p_token2 => 'INTEREST_DATE',

Line 4979: OKC_API.set_message(p_app_name => G_APP_NAME,

4975: IF (l_interest_calc_basis IN
4976: ('FLOAT', 'REAMORT', 'FLOAT_FACTORS', 'CATCHUP/CLEANUP')) THEN
4977: IF (l_last_interest_cal_date IS NOT NULL) THEN
4978: IF (p_effective_from_date <= l_last_interest_cal_date) THEN
4979: OKC_API.set_message(p_app_name => G_APP_NAME,
4980: p_msg_name => 'OKL_LLA_VAR_RATE_INT_DATE',
4981: p_token1 => 'EFF_DATE',
4982: p_token1_value => p_effective_from_date,
4983: p_token2 => 'INTEREST_DATE',

Line 5006: OKC_API.set_message(p_app_name => G_APP_NAME,

5002: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
5003: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'copy:Yes, inside...');
5004: END IF;
5005: x_return_status := OKL_API.G_RET_STS_ERROR;
5006: OKC_API.set_message(p_app_name => G_APP_NAME,
5007: p_msg_name => 'OKL_LLA_VAR_RATE_EXISTS');
5008: RAISE OKL_API.G_EXCEPTION_ERROR;
5009: END IF;
5010:

Line 5133: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

5129:
5130: -- Bug 4917614
5131: PROCEDURE SYNC_BASE_RATE(
5132: p_api_version IN NUMBER,
5133: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
5134: x_return_status OUT NOCOPY VARCHAR2,
5135: x_msg_count OUT NOCOPY NUMBER,
5136: x_msg_data OUT NOCOPY VARCHAR2,
5137: p_khr_id IN NUMBER) IS