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 64: G_COL_NAME CONSTANT VARCHAR2(30) := OKC_API.G_COL_NAME_TOKEN;

60: G_STRM_INTEREST_PAYMENT CONSTANT OKL_STRM_TYPE_V.STREAM_TYPE_PURPOSE%TYPE := 'INTEREST_PAYMENT';
61: G_RRM_EST_BILLED CONSTANT OKL_PRODUCT_PARAMETERS_V.REVENUE_RECOGNITION_METHOD%TYPE := 'ESTIMATED_AND_BILLED';
62: /* 13394074 */
63:
64: G_COL_NAME CONSTANT VARCHAR2(30) := OKC_API.G_COL_NAME_TOKEN;
65: G_DUE_DATE CONSTANT VARCHAR2(30) := 'DUE_DATE';
66: -- smadhava Bug#4542290 - 22-Aug-2005 - Added - End
67:
68:

Line 241: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

237: End Is_Rebook_Copy;
238:
239: PROCEDURE get_effective_from_date(
240: p_api_version IN NUMBER,
241: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
242: x_return_status OUT NOCOPY VARCHAR2,
243: x_msg_count OUT NOCOPY NUMBER,
244: x_msg_data OUT NOCOPY VARCHAR2,
245: p_chr_id IN OKC_K_HEADERS_B.ID%TYPE,

Line 271: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

267: END;
268:
269: procedure get_product(
270: p_api_version IN NUMBER,
271: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
272: x_return_status OUT NOCOPY VARCHAR2,
273: x_msg_count OUT NOCOPY NUMBER,
274: x_msg_data OUT NOCOPY VARCHAR2,
275: p_khr_id IN okc_k_headers_b.id%type,

Line 349: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

345: END;
346:
347: procedure get_product2(
348: p_api_version IN NUMBER,
349: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
350: x_return_status OUT NOCOPY VARCHAR2,
351: x_msg_count OUT NOCOPY NUMBER,
352: x_msg_data OUT NOCOPY VARCHAR2,
353: p_khr_id IN okc_k_headers_b.id%type,

Line 554: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

550:
551: --Bug# 7566308
552: PROCEDURE validate_rate_params_rbk(
553: p_api_version IN NUMBER,
554: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
555: x_return_status OUT NOCOPY VARCHAR2,
556: x_msg_count OUT NOCOPY NUMBER,
557: x_msg_data OUT NOCOPY VARCHAR2,
558: p_krpv_rec IN krpv_rec_type,

Line 673: OKC_API.SET_MESSAGE( p_app_name => G_APP_NAME

669: l_orig_rate_rec.BASE_RATE <> G_MISS_NUM) OR
670: (p_krpv_rec.BASE_RATE IS NOT NULL AND
671: p_krpv_rec.BASE_RATE <> G_MISS_NUM)) AND
672: (l_orig_rate_rec.BASE_RATE <> p_krpv_rec.BASE_RATE) THEN
673: OKC_API.SET_MESSAGE( p_app_name => G_APP_NAME
674: ,p_msg_name => 'OKL_LLA_VAR_RATE_INT_PROC'
675: ,p_token1 => 'PARAMETER_NAME'
676: ,p_token1_value => 'BASE_RATE'
677: ,p_token2 => 'CONTRACT_NUMBER'

Line 687: OKC_API.SET_MESSAGE( p_app_name => G_APP_NAME

683: l_orig_rate_rec.INTEREST_START_DATE <> G_MISS_DATE) OR
684: (p_krpv_rec.INTEREST_START_DATE IS NOT NULL AND
685: p_krpv_rec.INTEREST_START_DATE <> G_MISS_DATE)) AND
686: (l_orig_rate_rec.INTEREST_START_DATE <> p_krpv_rec.INTEREST_START_DATE) THEN
687: OKC_API.SET_MESSAGE( p_app_name => G_APP_NAME
688: ,p_msg_name => 'OKL_LLA_VAR_RATE_INT_PROC'
689: ,p_token1 => 'PARAMETER_NAME'
690: ,p_token1_value => 'INTEREST_START_DATE'
691: ,p_token2 => 'CONTRACT_NUMBER'

Line 701: OKC_API.SET_MESSAGE( p_app_name => G_APP_NAME

697: l_orig_rate_rec.PRINCIPAL_BASIS_CODE <> G_MISS_CHAR) OR
698: (p_krpv_rec.PRINCIPAL_BASIS_CODE IS NOT NULL AND
699: p_krpv_rec.PRINCIPAL_BASIS_CODE <> G_MISS_CHAR)) AND
700: (l_orig_rate_rec.PRINCIPAL_BASIS_CODE <> p_krpv_rec.PRINCIPAL_BASIS_CODE) THEN
701: OKC_API.SET_MESSAGE( p_app_name => G_APP_NAME
702: ,p_msg_name => 'OKL_LLA_VAR_RATE_INT_PROC'
703: ,p_token1 => 'PARAMETER_NAME'
704: ,p_token1_value => 'PRINCIPAL_BASIS_CODE'
705: ,p_token2 => 'CONTRACT_NUMBER'

Line 715: OKC_API.SET_MESSAGE( p_app_name => G_APP_NAME

711: l_orig_rate_rec.DAYS_IN_A_MONTH_CODE <> G_MISS_CHAR) OR
712: (p_krpv_rec.DAYS_IN_A_MONTH_CODE IS NOT NULL AND
713: p_krpv_rec.DAYS_IN_A_MONTH_CODE <> G_MISS_CHAR)) AND
714: (l_orig_rate_rec.DAYS_IN_A_MONTH_CODE <> p_krpv_rec.DAYS_IN_A_MONTH_CODE) THEN
715: OKC_API.SET_MESSAGE( p_app_name => G_APP_NAME
716: ,p_msg_name => 'OKL_LLA_VAR_RATE_INT_PROC'
717: ,p_token1 => 'PARAMETER_NAME'
718: ,p_token1_value => 'DAYS_IN_A_MONTH_CODE'
719: ,p_token2 => 'CONTRACT_NUMBER'

Line 729: OKC_API.SET_MESSAGE( p_app_name => G_APP_NAME

725: l_orig_rate_rec.DAYS_IN_A_YEAR_CODE <> G_MISS_CHAR) OR
726: (p_krpv_rec.DAYS_IN_A_YEAR_CODE IS NOT NULL AND
727: p_krpv_rec.DAYS_IN_A_YEAR_CODE <> G_MISS_CHAR)) AND
728: (l_orig_rate_rec.DAYS_IN_A_YEAR_CODE <> p_krpv_rec.DAYS_IN_A_YEAR_CODE) THEN
729: OKC_API.SET_MESSAGE( p_app_name => G_APP_NAME
730: ,p_msg_name => 'OKL_LLA_VAR_RATE_INT_PROC'
731: ,p_token1 => 'PARAMETER_NAME'
732: ,p_token1_value => 'DAYS_IN_A_YEAR_CODE'
733: ,p_token2 => 'CONTRACT_NUMBER'

Line 743: OKC_API.SET_MESSAGE( p_app_name => G_APP_NAME

739: l_orig_rate_rec.CATCHUP_START_DATE <> G_MISS_DATE) OR
740: (p_krpv_rec.CATCHUP_START_DATE IS NOT NULL AND
741: p_krpv_rec.CATCHUP_START_DATE <> G_MISS_DATE)) AND
742: (l_orig_rate_rec.CATCHUP_START_DATE <> p_krpv_rec.CATCHUP_START_DATE) THEN
743: OKC_API.SET_MESSAGE( p_app_name => G_APP_NAME
744: ,p_msg_name => 'OKL_LLA_VAR_RATE_INT_PROC'
745: ,p_token1 => 'PARAMETER_NAME'
746: ,p_token1_value => 'CATCHUP_START_DATE'
747: ,p_token2 => 'CONTRACT_NUMBER'

Line 757: OKC_API.SET_MESSAGE( p_app_name => G_APP_NAME

753: l_orig_rate_rec.CATCHUP_SETTLEMENT_CODE <> G_MISS_CHAR) OR
754: (p_krpv_rec.CATCHUP_SETTLEMENT_CODE IS NOT NULL AND
755: p_krpv_rec.CATCHUP_SETTLEMENT_CODE <> G_MISS_CHAR)) AND
756: (l_orig_rate_rec.CATCHUP_SETTLEMENT_CODE <> p_krpv_rec.CATCHUP_SETTLEMENT_CODE) THEN
757: OKC_API.SET_MESSAGE( p_app_name => G_APP_NAME
758: ,p_msg_name => 'OKL_LLA_VAR_RATE_INT_PROC'
759: ,p_token1 => 'PARAMETER_NAME'
760: ,p_token1_value => 'CATCHUP_SETTLEMENT_CODE'
761: ,p_token2 => 'CONTRACT_NUMBER'

Line 771: OKC_API.SET_MESSAGE( p_app_name => G_APP_NAME

767: l_orig_rate_rec.RATE_CHANGE_START_DATE <> G_MISS_DATE) OR
768: (p_krpv_rec.RATE_CHANGE_START_DATE IS NOT NULL AND
769: p_krpv_rec.RATE_CHANGE_START_DATE <> G_MISS_DATE)) AND
770: (l_orig_rate_rec.RATE_CHANGE_START_DATE <> p_krpv_rec.RATE_CHANGE_START_DATE) THEN
771: OKC_API.SET_MESSAGE( p_app_name => G_APP_NAME
772: ,p_msg_name => 'OKL_LLA_VAR_RATE_INT_PROC'
773: ,p_token1 => 'PARAMETER_NAME'
774: ,p_token1_value => 'RATE_CHANGE_START_DATE'
775: ,p_token2 => 'CONTRACT_NUMBER'

Line 850: OKC_API.SET_MESSAGE(

846: -- IF any of the above values changed
847: IF (l_deal_type IN ('LEASEOP', 'LEASEDF', 'LEASEST') AND
848: l_interest_calculation_basis IN ('FIXED', 'FLOAT_FACTORS')) THEN
849: IF (p_krpv_rec.EFFECTIVE_FROM_DATE < l_orig_rate_rec.EFFECTIVE_FROM_DATE) THEN
850: OKC_API.SET_MESSAGE(
851: p_app_name => G_APP_NAME
852: ,p_msg_name => 'OKL_LLA_VAR_RATE_EFF_DATE');
853: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
854: END IF;

Line 860: OKC_API.SET_MESSAGE(

856: l_interest_calculation_basis = 'REAMORT' ) THEN
857: IF (p_krpv_rec.EFFECTIVE_FROM_DATE <= l_rebook_date) OR
858: (p_krpv_rec.EFFECTIVE_FROM_DATE <= l_last_interest_calc_date)
859: THEN
860: OKC_API.SET_MESSAGE(
861: p_app_name => G_APP_NAME
862: ,p_msg_name => 'OKL_LLA_VAR_RATE_RBK_DATE');
863: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
864: END IF;

Line 873: OKC_API.SET_MESSAGE(

869: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'p_krpv_rec.effective_from_date=' || p_krpv_rec.effective_from_date);
870: 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);
871: END IF;
872: IF (p_krpv_rec.EFFECTIVE_FROM_DATE < l_orig_rate_rec.EFFECTIVE_FROM_DATE) THEN
873: OKC_API.SET_MESSAGE(
874: p_app_name => G_APP_NAME
875: ,p_msg_name => 'OKL_LLA_VAR_RATE_EFF_DATE');
876: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
877: END IF;

Line 883: OKC_API.SET_MESSAGE(

879: l_interest_calculation_basis = 'REAMORT') THEN
880: IF (p_krpv_rec.EFFECTIVE_FROM_DATE <= l_rebook_date) OR
881: (p_krpv_rec.EFFECTIVE_FROM_DATE <= l_last_interest_calc_date)
882: THEN
883: OKC_API.SET_MESSAGE(
884: p_app_name => G_APP_NAME
885: ,p_msg_name => 'OKL_LLA_VAR_RATE_RBK_DATE');
886: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
887: END IF;

Line 891: OKC_API.SET_MESSAGE(

887: END IF;
888: ELSIF (l_deal_type = 'LOAN-REVOLVING' AND
889: l_interest_calculation_basis = 'FLOAT') THEN
890: IF (p_krpv_rec.EFFECTIVE_FROM_DATE < l_orig_rate_rec.EFFECTIVE_FROM_DATE) THEN
891: OKC_API.SET_MESSAGE(
892: p_app_name => G_APP_NAME
893: ,p_msg_name => 'OKL_LLA_VAR_RATE_EFF_DATE');
894: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
895: END IF;

Line 937: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

933: /* This is to be called from contract import and UI*/
934: --Zero
935: PROCEDURE create_k_rate_params(
936: p_api_version IN NUMBER,
937: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
938: x_return_status OUT NOCOPY VARCHAR2,
939: x_msg_count OUT NOCOPY NUMBER,
940: x_msg_data OUT NOCOPY VARCHAR2,
941: p_krpv_rec IN krpv_rec_type,

Line 1074: OKC_API.SET_MESSAGE( p_app_name => G_APP_NAME

1070: l_rate_count := r.count1;
1071: END LOOP;
1072:
1073: IF (l_rate_count > 0) THEN
1074: OKC_API.SET_MESSAGE( p_app_name => G_APP_NAME
1075: ,p_msg_name => 'OKL_LLA_VAR_RATE_EXISTS');
1076: RAISE OKL_API.G_EXCEPTION_ERROR;
1077: END IF;
1078: END IF;

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

1174: (l_krpv_rec.rate_delay_frequency is NULL OR
1175: l_krpv_rec.rate_delay_frequency = G_MISS_NUM) THEN
1176: NULL;
1177: ELSE
1178: OKC_API.set_message(p_app_name => G_APP_NAME,
1179: p_msg_name => G_REQUIRED_VALUE,
1180: p_token1 => G_COL_NAME_TOKEN,
1181: p_token1_value => 'CATCHUP FREQUENCY');
1182: RAISE OKL_API.G_EXCEPTION_ERROR;

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

1187: IF (l_krpv_rec.catchup_frequency_code is NOT NULL AND
1188: l_krpv_rec.catchup_frequency_code <> G_MISS_CHAR) THEN
1189: NULL;
1190: ELSE
1191: OKC_API.set_message(p_app_name => G_APP_NAME,
1192: p_msg_name => G_REQUIRED_VALUE,
1193: p_token1 => G_COL_NAME_TOKEN,
1194: p_token1_value => 'Catchup Frequency');
1195: RAISE OKL_API.G_EXCEPTION_ERROR;

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

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

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

1220: IF (l_krpv_rec.catchup_basis_code is NOT NULL AND
1221: l_krpv_rec.catchup_basis_code <> G_MISS_CHAR) THEN
1222: NULL;
1223: ELSE
1224: OKC_API.set_message(p_app_name => G_APP_NAME,
1225: p_msg_name => G_REQUIRED_VALUE,
1226: p_token1 => G_COL_NAME_TOKEN,
1227: p_token1_value => 'Catchup Basis');
1228: RAISE OKL_API.G_EXCEPTION_ERROR;

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

1255: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'p_krpv_rec.effective_from_Date=' || p_krpv_rec.effective_from_Date);
1256: END IF;
1257: IF (l_last_billed_due_date IS NOT NULL AND
1258: p_krpv_rec.effective_from_Date <= l_last_billed_due_date) THEN
1259: OKC_API.set_message(p_app_name => G_APP_NAME,
1260: p_msg_name => 'OKL_LLA_VAR_RATE_INT_DATE',
1261: p_token1 => 'EFF_DATE',
1262: p_token1_value => p_krpv_rec.effective_from_Date,
1263: p_token2 => 'INTEREST_DATE',

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

1269: -- Bug 4999888
1270: IF (l_pdt_parameter_rec.interest_calculation_basis IN ('FLOAT', 'REAMORT', 'FLOAT_FACTORS', 'CATCHUP/CLEANUP')) THEN
1271: IF (l_last_interest_cal_date IS NOT NULL) THEN
1272: IF (p_krpv_rec.effective_from_Date <= l_last_interest_cal_date) THEN
1273: OKC_API.set_message(p_app_name => G_APP_NAME,
1274: p_msg_name => 'OKL_LLA_VAR_RATE_INT_DATE',
1275: p_token1 => 'EFF_DATE',
1276: p_token1_value => p_krpv_rec.effective_from_Date,
1277: p_token2 => 'INTEREST_DATE',

Line 1383: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

1379:
1380: -- First
1381: PROCEDURE create_k_rate_params(
1382: p_api_version IN NUMBER,
1383: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
1384: x_return_status OUT NOCOPY VARCHAR2,
1385: x_msg_count OUT NOCOPY NUMBER,
1386: x_msg_data OUT NOCOPY VARCHAR2,
1387: p_krpr_rec IN krpr_rec_type,

Line 1507: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

1503:
1504: -- Second
1505: PROCEDURE create_k_rate_params(
1506: p_api_version IN NUMBER,
1507: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
1508: x_return_status OUT NOCOPY VARCHAR2,
1509: x_msg_count OUT NOCOPY NUMBER,
1510: x_msg_data OUT NOCOPY VARCHAR2,
1511: p_krpar_rec IN krpar_rec_type,

Line 1628: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

1624:
1625: -- Third
1626: PROCEDURE create_k_rate_params(
1627: p_api_version IN NUMBER,
1628: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
1629: x_return_status OUT NOCOPY VARCHAR2,
1630: x_msg_count OUT NOCOPY NUMBER,
1631: x_msg_data OUT NOCOPY VARCHAR2,
1632: p_krpc_rec IN krpc_rec_type,

Line 1736: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

1732: /* For both UI and contract import */
1733: --Zero
1734: PROCEDURE update_k_rate_params(
1735: p_api_version IN NUMBER,
1736: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
1737: x_return_status OUT NOCOPY VARCHAR2,
1738: x_msg_count OUT NOCOPY NUMBER,
1739: x_msg_data OUT NOCOPY VARCHAR2,
1740: p_krpv_rec IN krpv_rec_type,

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

1917: (l_krpv_rec.rate_delay_frequency is NULL OR
1918: l_krpv_rec.rate_delay_frequency = G_MISS_NUM) THEN
1919: NULL;
1920: ELSE
1921: OKC_API.set_message(p_app_name => G_APP_NAME,
1922: p_msg_name => G_REQUIRED_VALUE,
1923: p_token1 => G_COL_NAME_TOKEN,
1924: p_token1_value => 'CATCHUP FREQUENCY');
1925: RAISE OKL_API.G_EXCEPTION_ERROR;

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

1933: IF (l_krpv_rec.catchup_frequency_code is NOT NULL AND
1934: l_krpv_rec.catchup_frequency_code <> G_MISS_CHAR) THEN
1935: NULL;
1936: ELSE
1937: OKC_API.set_message(p_app_name => G_APP_NAME,
1938: p_msg_name => G_REQUIRED_VALUE,
1939: p_token1 => G_COL_NAME_TOKEN,
1940: p_token1_value => 'Catchup Frequency');
1941: RAISE OKL_API.G_EXCEPTION_ERROR;

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

1958: IF (l_krpv_rec.catchup_settlement_code is NOT NULL AND
1959: l_krpv_rec.catchup_settlement_code <> G_MISS_CHAR) THEN
1960: NULL;
1961: ELSE
1962: OKC_API.set_message(p_app_name => G_APP_NAME,
1963: p_msg_name => G_REQUIRED_VALUE,
1964: p_token1 => G_COL_NAME_TOKEN,
1965: p_token1_value => 'Catchup Settlement');
1966: RAISE OKL_API.G_EXCEPTION_ERROR;

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

1972: IF (l_krpv_rec.catchup_basis_code is NOT NULL AND
1973: l_krpv_rec.catchup_basis_code <> G_MISS_CHAR) THEN
1974: NULL;
1975: ELSE
1976: OKC_API.set_message(p_app_name => G_APP_NAME,
1977: p_msg_name => G_REQUIRED_VALUE,
1978: p_token1 => G_COL_NAME_TOKEN,
1979: p_token1_value => 'Catchup Basis');
1980: RAISE OKL_API.G_EXCEPTION_ERROR;

Line 2063: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

2059:
2060: -- First
2061: PROCEDURE update_k_rate_params(
2062: p_api_version IN NUMBER,
2063: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
2064: x_return_status OUT NOCOPY VARCHAR2,
2065: x_msg_count OUT NOCOPY NUMBER,
2066: x_msg_data OUT NOCOPY VARCHAR2,
2067: p_krpr_rec IN krpr_rec_type,

Line 2167: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

2163:
2164: -- Second
2165: PROCEDURE update_k_rate_params(
2166: p_api_version IN NUMBER,
2167: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
2168: x_return_status OUT NOCOPY VARCHAR2,
2169: x_msg_count OUT NOCOPY NUMBER,
2170: x_msg_data OUT NOCOPY VARCHAR2,
2171: p_krpar_rec IN krpar_rec_type,

Line 2271: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

2267:
2268: -- Third
2269: PROCEDURE update_k_rate_params(
2270: p_api_version IN NUMBER,
2271: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
2272: x_return_status OUT NOCOPY VARCHAR2,
2273: x_msg_count OUT NOCOPY NUMBER,
2274: x_msg_data OUT NOCOPY VARCHAR2,
2275: p_krpc_rec IN krpc_rec_type,

Line 2360: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

2356: end;
2357:
2358: PROCEDURE delete_k_rate_params(
2359: p_api_version IN NUMBER,
2360: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
2361: x_return_status OUT NOCOPY VARCHAR2,
2362: x_msg_count OUT NOCOPY NUMBER,
2363: x_msg_data OUT NOCOPY VARCHAR2,
2364: p_krpdel_tbl IN krpdel_tbl_type) IS

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

2433: --Bug# 7440232
2434: ELSIF (p_krpdel_tbl(i).rate_type IN ('INTEREST_RATE_PARAMS_CONV')) THEN
2435: l_parameter_type_code := 'CONVERSION';
2436: ELSE
2437: OKC_API.set_message(p_app_name => G_APP_NAME,
2438: p_msg_name => 'OKL_LLA_VAR_RATE_INV_PARAM');
2439: RAISE OKL_API.G_EXCEPTION_ERROR;
2440: END IF;
2441:

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

2454: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_orig_system_source_code=' || l_orig_system_source_code);
2455: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_orig_system_id1=' || l_orig_system_id1);
2456: END IF;
2457: IF (l_effective_to_date IS NOT NULL) THEN
2458: OKC_API.set_message(p_app_name => G_APP_NAME,
2459: p_msg_name => 'OKL_LLA_VAR_RATE_DELETE_ERR');
2460: RAISE OKL_API.G_EXCEPTION_ERROR;
2461: END IF;
2462:

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

2461: END IF;
2462:
2463: --Bug# 7440232
2464: IF (l_sts_code = 'BOOKED') THEN
2465: OKC_API.set_message(p_app_name => G_APP_NAME,
2466: p_msg_name => 'OKL_LLA_VAR_RATE_DELETE_ERR1');
2467: RAISE OKL_API.G_EXCEPTION_ERROR;
2468: END IF;
2469:

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

2485:
2486: --Bug# 7440232
2487: IF (l_orig_effective_from_date =
2488: p_krpdel_tbl(i).effective_from_date) THEN
2489: OKC_API.set_message(p_app_name => G_APP_NAME,
2490: p_msg_name => 'OKL_LLA_VAR_RATE_DELETE_ERR2');
2491: RAISE OKL_API.G_EXCEPTION_ERROR;
2492: END IF;
2493:

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

2669: END LOOP;
2670:
2671: IF (l_orig_effective_from_date =
2672: p_krpdel_tbl(i).effective_from_date) THEN
2673: OKC_API.set_message(p_app_name => G_APP_NAME,
2674: p_msg_name => 'OKL_LA_VAR_RATE_DELETE_ERR2');
2675: RAISE OKL_API.G_EXCEPTION_ERROR;
2676: END IF;*/
2677:

Line 2744: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

2740:
2741: /* For QA checker to call - stack Error messages and no raise exception*/
2742: PROCEDURE validate_k_rate_params(
2743: p_api_version IN NUMBER,
2744: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
2745: x_return_status OUT NOCOPY VARCHAR2,
2746: x_msg_count OUT NOCOPY NUMBER,
2747: x_msg_data OUT NOCOPY VARCHAR2,
2748: p_khr_id IN okc_k_headers_b.id%type,

Line 2915: OKC_API.SET_MESSAGE( p_app_name => G_APP_NAME

2911: (l_interest_calculation_basis IN ('FIXED', 'REAMORT'))) OR
2912: ((l_deal_type = 'LOAN') AND
2913: (l_interest_calculation_basis = 'REAMORT')) ) THEN
2914: IF (l_k_rate_tbl.COUNT > 0) THEN
2915: OKC_API.SET_MESSAGE( p_app_name => G_APP_NAME
2916: ,p_msg_name => G_OKL_LLA_VAR_RATE_ERROR
2917: ,p_token1 => G_LEASE_TYPE
2918: ,p_token1_value => 'LEASEOP,LEASEDF,LEASEST'
2919: ,p_token2 => G_INT_BASIS

Line 2938: OKC_API.SET_MESSAGE( p_app_name => G_APP_NAME

2934: l_revenue_recognition_method = 'ACTUAL') )) OR
2935: ((l_deal_type = 'LOAN-REVOLVING') AND
2936: (l_interest_calculation_basis = 'FLOAT')) ) THEN
2937: IF (l_k_rate_tbl.COUNT < 1) THEN
2938: OKC_API.SET_MESSAGE( p_app_name => G_APP_NAME
2939: ,p_msg_name => G_OKL_LLA_VAR_RATE_MISSING
2940: ,p_token1 => G_CONT_ID
2941: ,p_token1_value => p_khr_id);
2942: RAISE OKL_API.G_EXCEPTION_ERROR;

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

2980: IF (l_k_rate_tbl(i).catchup_frequency_code is NOT NULL AND
2981: l_k_rate_tbl(i).catchup_frequency_code <> G_MISS_CHAR) THEN
2982: NULL;
2983: ELSE
2984: OKC_API.set_message(p_app_name => G_APP_NAME,
2985: p_msg_name => G_REQUIRED_VALUE,
2986: p_token1 => G_COL_NAME_TOKEN,
2987: p_token1_value => 'Catchup Frequency');
2988: RAISE OKL_API.G_EXCEPTION_ERROR;

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

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

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

3012: IF (l_k_rate_tbl(i).catchup_basis_code is NOT NULL AND
3013: l_k_rate_tbl(i).catchup_basis_code <> G_MISS_CHAR) THEN
3014: NULL;
3015: ELSE
3016: OKC_API.set_message(p_app_name => G_APP_NAME,
3017: p_msg_name => G_REQUIRED_VALUE,
3018: p_token1 => G_COL_NAME_TOKEN,
3019: p_token1_value => 'Catchup Basis');
3020: RAISE OKL_API.G_EXCEPTION_ERROR;

Line 3061: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

3057:
3058: /* For UI/contract import to call */
3059: PROCEDURE validate_k_rate_params(
3060: p_api_version IN NUMBER,
3061: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
3062: x_return_status OUT NOCOPY VARCHAR2,
3063: x_msg_count OUT NOCOPY NUMBER,
3064: x_msg_data OUT NOCOPY VARCHAR2,
3065: p_product_id IN okl_products_v.id%type,

Line 3153: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

3149: -- End of comments
3150:
3151: Procedure generate_rate_summary(
3152: p_api_version IN NUMBER,
3153: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
3154: x_return_status OUT NOCOPY VARCHAR2,
3155: x_msg_count OUT NOCOPY NUMBER,
3156: x_msg_data OUT NOCOPY VARCHAR2,
3157: p_chr_id IN NUMBER,

Line 3359: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

3355: -- Default the values based on business rules
3356:
3357: PROCEDURE default_k_rate_params(
3358: p_api_version IN NUMBER,
3359: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
3360: x_return_status OUT NOCOPY VARCHAR2,
3361: x_msg_count OUT NOCOPY NUMBER,
3362: x_msg_data OUT NOCOPY VARCHAR2,
3363: p_deal_type IN okl_product_parameters_v.deal_type%type,

Line 3369: x_return_status := OKC_API.G_RET_STS_SUCCESS;

3365: p_int_calc_basis IN okl_product_parameters_v.interest_calculation_basis%type,
3366: p_column_name IN VARCHAR2,
3367: p_krpv_rec IN OUT NOCOPY krpv_rec_type) IS
3368: BEGIN
3369: x_return_status := OKC_API.G_RET_STS_SUCCESS;
3370:
3371: IF (p_column_name = 'PRINCIPAL_BASIS_CODE' OR p_column_name = 'ALL') THEN
3372: IF (p_deal_type IN ('LEASEOP', 'LEASEDF', 'LEASEST') AND
3373: (p_int_calc_basis = 'REAMORT' AND p_rev_rec_method = 'STREAMS')) THEN

Line 3473: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

3469: END;
3470:
3471: PROCEDURE cascade_contract_start_date(
3472: p_api_version IN NUMBER,
3473: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
3474: x_return_status OUT NOCOPY VARCHAR2,
3475: x_msg_count OUT NOCOPY NUMBER,
3476: x_msg_data OUT NOCOPY VARCHAR2,
3477: p_chr_id IN OKC_K_HEADERS_B.ID%TYPE,

Line 3502: x_return_status := OKC_API.G_RET_STS_SUCCESS;

3498: l_catchup_start_date DATE;
3499:
3500:
3501: BEGIN
3502: x_return_status := OKC_API.G_RET_STS_SUCCESS;
3503: x_return_status := OKL_API.START_ACTIVITY(
3504: p_api_name => l_api_name,
3505: p_pkg_name => g_pkg_name,
3506: p_init_msg_list => p_init_msg_list,

Line 3539: OKC_API.SET_MESSAGE( p_app_name => G_APP_NAME

3535:
3536: IF (l_interest_processing_started) THEN
3537: -- Parameters RATE_CHANGE_START_DATE can not be updated because
3538: -- Interest Processing has already started for contract CONTRACT_NUMBER.
3539: OKC_API.SET_MESSAGE( p_app_name => G_APP_NAME
3540: ,p_msg_name => 'OKL_LLA_VAR_RATE_INT_PROC'
3541: ,p_token1 => 'PARAMETER_NAME'
3542: --,p_token1_value => 'INTEREST_START_DATE'
3543: ,p_token1_value =>

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

3573: x_msg_data ,
3574: p_chr_id ,
3575: l_effective_from_date,
3576: l_no_data_found);
3577: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
3578: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3579: END IF;
3580:
3581: IF NOT(l_no_data_found) THEN

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

3613: x_msg_data => x_msg_data,
3614: p_krpv_rec => l_krpv_rec,
3615: x_krpv_rec => x_krpv_rec);
3616: --p_validate_flag => 'Y');
3617: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
3618: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3619: END IF; */
3620:
3621: update okl_k_rate_params

Line 3694: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

3690: --End of Comments
3691: ------------------------------------------------------------------------------
3692: PROCEDURE check_rebook_allowed (
3693: p_api_version IN NUMBER,
3694: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
3695: x_return_status OUT NOCOPY VARCHAR2,
3696: x_msg_count OUT NOCOPY NUMBER,
3697: x_msg_data OUT NOCOPY VARCHAR2,
3698: p_chr_id IN OKC_K_HEADERS_B.ID%TYPE,

Line 3885: OKC_API.SET_MESSAGE( p_app_name => G_APP_NAME

3881:
3882: IF (l_book_class = G_BOOK_CLASS_OP) THEN
3883: IF (l_interest_calc_basis NOT IN
3884: (G_ICB_FIXED, G_ICB_FLOAT_FACTOR, G_ICB_REAMORT )) THEN
3885: OKC_API.SET_MESSAGE( p_app_name => G_APP_NAME
3886: ,p_msg_name => G_OKL_LLA_REBOOK_INVALID
3887: ,p_token1 => G_BOOK_CLASS
3888: ,p_token1_value => l_book_class_meaning
3889: ,p_token2 => G_INT_CALC_BASIS

Line 3900: OKC_API.SET_MESSAGE( p_app_name => G_APP_NAME

3896: IF ( l_interest_proc_date IS NOT NULL ) THEN
3897: IF (l_mass_rebook_flag = OKL_API.G_TRUE) THEN -- 4766555
3898: NULL;
3899: ELSE
3900: OKC_API.SET_MESSAGE( p_app_name => G_APP_NAME
3901: ,p_msg_name => G_OKL_LLA_RBK_INT_PROC_INVAL
3902: ,p_token1 => G_COL_NAME
3903: ,p_token1_value => l_contract_number);
3904: RAISE OKL_API.G_EXCEPTION_ERROR;

Line 3921: OKC_API.SET_MESSAGE( p_app_name => G_APP_NAME

3917: CLOSE get_last_accrued_due_date; */
3918:
3919: IF ( l_last_billed_due_date IS NOT NULL
3920: AND p_rebook_date <= l_last_billed_due_date) THEN
3921: OKC_API.SET_MESSAGE( p_app_name => G_APP_NAME
3922: ,p_msg_name => G_OKL_LLA_RBK_DATE_BILL_INVAL
3923: ,p_token1 => G_STREAM
3924: ,p_token1_value => l_stream_name
3925: ,p_token2 => G_DUE_DATE

Line 3930: OKC_API.SET_MESSAGE( p_app_name => G_APP_NAME

3926: ,p_token2_value => l_last_billed_due_date);
3927: RAISE OKL_API.G_EXCEPTION_ERROR;
3928: /*ELSIF ( l_last_accrued_due_date IS NOT NULL
3929: AND p_rebook_date <= l_last_accrued_due_date) THEN
3930: OKC_API.SET_MESSAGE( p_app_name => G_APP_NAME
3931: ,p_msg_name => G_OKL_LLA_RBK_DATE_ACCR_INVAL
3932: ,p_token1 => G_STREAM
3933: ,p_token1_value => l_stream_name
3934: ,p_token2 => G_DUE_DATE

Line 3946: OKC_API.SET_MESSAGE( p_app_name => G_APP_NAME

3942: -- Check for Sales Type Lease
3943: ELSIF (l_book_class = G_BOOK_CLASS_ST) THEN
3944: IF (l_interest_calc_basis NOT IN
3945: (G_ICB_FIXED, G_ICB_FLOAT_FACTOR, G_ICB_REAMORT )) THEN
3946: OKC_API.SET_MESSAGE( p_app_name => G_APP_NAME
3947: ,p_msg_name => G_OKL_LLA_REBOOK_INVALID
3948: ,p_token1 => G_BOOK_CLASS
3949: ,p_token1_value => l_book_class_meaning
3950: ,p_token2 => G_INT_CALC_BASIS

Line 3960: OKC_API.SET_MESSAGE( p_app_name => G_APP_NAME

3956: IF ( l_interest_proc_date IS NOT NULL ) THEN
3957: IF (l_mass_rebook_flag = OKL_API.G_TRUE) THEN -- 4766555
3958: NULL;
3959: ELSE
3960: OKC_API.SET_MESSAGE( p_app_name => G_APP_NAME
3961: ,p_msg_name => G_OKL_LLA_RBK_INT_PROC_INVAL
3962: ,p_token1 => G_COL_NAME
3963: ,p_token1_value => l_contract_number);
3964: RAISE OKL_API.G_EXCEPTION_ERROR;

Line 3982: OKC_API.SET_MESSAGE( p_app_name => G_APP_NAME

3978: CLOSE get_last_accrued_due_date; */
3979:
3980: IF ( l_last_billed_due_date IS NOT NULL AND
3981: p_rebook_date <= l_last_billed_due_date) THEN
3982: OKC_API.SET_MESSAGE( p_app_name => G_APP_NAME
3983: ,p_msg_name => G_OKL_LLA_RBK_DATE_BILL_INVAL
3984: ,p_token1 => G_STREAM
3985: ,p_token1_value => l_stream_name
3986: ,p_token2 => G_DUE_DATE

Line 3991: OKC_API.SET_MESSAGE( p_app_name => G_APP_NAME

3987: ,p_token2_value => l_last_billed_due_date);
3988: RAISE OKL_API.G_EXCEPTION_ERROR;
3989: /*ELSIF ( l_last_accrued_due_date IS NOT NULL AND
3990: p_rebook_date <= l_last_accrued_due_date) THEN
3991: OKC_API.SET_MESSAGE( p_app_name => G_APP_NAME
3992: ,p_msg_name => G_OKL_LLA_RBK_DATE_ACCR_INVAL
3993: ,p_token1 => G_STREAM
3994: ,p_token1_value => l_stream_name
3995: ,p_token2 => G_DUE_DATE

Line 4007: OKC_API.SET_MESSAGE( p_app_name => G_APP_NAME

4003: -- Check for Direct Finance Lease
4004: ELSIF (l_book_class = G_BOOK_CLASS_DF) THEN
4005: IF (l_interest_calc_basis NOT IN
4006: (G_ICB_FIXED, G_ICB_FLOAT_FACTOR, G_ICB_REAMORT )) THEN
4007: OKC_API.SET_MESSAGE( p_app_name => G_APP_NAME
4008: ,p_msg_name => G_OKL_LLA_REBOOK_INVALID
4009: ,p_token1 => G_BOOK_CLASS
4010: ,p_token1_value => l_book_class_meaning
4011: ,p_token2 => G_INT_CALC_BASIS

Line 4022: OKC_API.SET_MESSAGE( p_app_name => G_APP_NAME

4018: IF ( l_interest_proc_date IS NOT NULL ) THEN
4019: IF (l_mass_rebook_flag = OKL_API.G_TRUE) THEN -- 4766555
4020: NULL;
4021: ELSE
4022: OKC_API.SET_MESSAGE( p_app_name => G_APP_NAME
4023: ,p_msg_name => G_OKL_LLA_RBK_INT_PROC_INVAL
4024: ,p_token1 => G_COL_NAME
4025: ,p_token1_value => l_contract_number);
4026: RAISE OKL_API.G_EXCEPTION_ERROR;

Line 4044: OKC_API.SET_MESSAGE( p_app_name => G_APP_NAME

4040: CLOSE get_last_accrued_due_date; */
4041:
4042: IF ( l_last_billed_due_date IS NOT NULL AND
4043: p_rebook_date <= l_last_billed_due_date) THEN
4044: OKC_API.SET_MESSAGE( p_app_name => G_APP_NAME
4045: ,p_msg_name => G_OKL_LLA_RBK_DATE_BILL_INVAL
4046: ,p_token1 => G_STREAM
4047: ,p_token1_value => l_stream_name
4048: ,p_token2 => G_DUE_DATE

Line 4053: OKC_API.SET_MESSAGE( p_app_name => G_APP_NAME

4049: ,p_token2_value => l_last_billed_due_date);
4050: RAISE OKL_API.G_EXCEPTION_ERROR;
4051: /*ELSIF ( l_last_accrued_due_date IS NOT NULL AND
4052: p_rebook_date <= l_last_accrued_due_date) THEN
4053: OKC_API.SET_MESSAGE( p_app_name => G_APP_NAME
4054: ,p_msg_name => G_OKL_LLA_RBK_DATE_ACCR_INVAL
4055: ,p_token1 => G_STREAM
4056: ,p_token1_value => l_stream_name
4057: ,p_token2 => G_DUE_DATE

Line 4069: OKC_API.SET_MESSAGE( p_app_name => G_APP_NAME

4065: -- Check for Loan
4066: ELSIF (l_book_class = G_BOOK_CLASS_LOAN) THEN
4067: IF (l_interest_calc_basis NOT IN
4068: (G_ICB_FIXED, G_ICB_FLOAT, G_ICB_REAMORT, G_ICB_CATCHUP_CLEANUP)) THEN
4069: OKC_API.SET_MESSAGE( p_app_name => G_APP_NAME
4070: ,p_msg_name => G_OKL_LLA_REBOOK_INVALID
4071: ,p_token1 => G_BOOK_CLASS
4072: ,p_token1_value => l_book_class_meaning
4073: ,p_token2 => G_INT_CALC_BASIS

Line 4082: OKC_API.SET_MESSAGE( p_app_name => G_APP_NAME

4078: --Bug# 13831818
4079: IF (l_interest_calc_basis = G_ICB_CATCHUP_CLEANUP) THEN
4080: IF (l_interest_proc_date IS NOT NULL) AND (p_rebook_date <= l_interest_proc_date) THEN
4081:
4082: OKC_API.SET_MESSAGE( p_app_name => G_APP_NAME
4083: ,p_msg_name => G_OKL_LLA_RBK_INT_CAL_DT_INV
4084: ,p_token2 => G_DUE_DATE
4085: ,p_token2_value => l_interest_proc_date);
4086: RAISE OKL_API.G_EXCEPTION_ERROR;

Line 4096: OKC_API.SET_MESSAGE( p_app_name => G_APP_NAME

4092: IF ( l_interest_proc_date IS NOT NULL ) THEN
4093: IF (l_mass_rebook_flag = OKL_API.G_TRUE) THEN -- 4766555
4094: NULL;
4095: ELSE
4096: OKC_API.SET_MESSAGE( p_app_name => G_APP_NAME
4097: ,p_msg_name => G_OKL_LLA_RBK_INT_PROC_INVAL
4098: ,p_token1 => G_COL_NAME
4099: ,p_token1_value => l_contract_number);
4100: RAISE OKL_API.G_EXCEPTION_ERROR;

Line 4121: OKC_API.SET_MESSAGE( p_app_name => G_APP_NAME

4117:
4118: /* 13394074
4119: IF ( l_last_billed_due_date IS NOT NULL
4120: AND p_rebook_date <= l_last_billed_due_date) THEN
4121: OKC_API.SET_MESSAGE( p_app_name => G_APP_NAME
4122: ,p_msg_name => G_OKL_LLA_RBK_DATE_BILL_INVAL
4123: ,p_token1 => G_STREAM
4124: ,p_token1_value => l_stream_name
4125: ,p_token2 => G_DUE_DATE

Line 4131: OKC_API.SET_MESSAGE( p_app_name => G_APP_NAME

4127: RAISE OKL_API.G_EXCEPTION_ERROR;
4128: 13394074 */
4129: /*ELSIF ( l_last_accrued_due_date IS NOT NULL AND
4130: p_rebook_date <= l_last_accrued_due_date) THEN
4131: OKC_API.SET_MESSAGE( p_app_name => G_APP_NAME
4132: ,p_msg_name => G_OKL_LLA_RBK_DATE_ACCR_INVAL
4133: ,p_token1 => G_STREAM
4134: ,p_token1_value => l_stream_name
4135: ,p_token2 => G_DUE_DATE

Line 4149: OKC_API.SET_MESSAGE( p_app_name => G_APP_NAME

4145: INTO l_last_billed_due_date, l_stream_name;
4146: CLOSE get_last_billed_due_date;
4147: IF ( l_last_billed_due_date IS NOT NULL
4148: AND p_rebook_date <= l_last_billed_due_date) THEN
4149: OKC_API.SET_MESSAGE( p_app_name => G_APP_NAME
4150: ,p_msg_name => G_OKL_LLA_RBK_DATE_BILL_INVAL
4151: ,p_token1 => G_STREAM
4152: ,p_token1_value => l_stream_name
4153: ,p_token2 => G_DUE_DATE

Line 4165: OKC_API.SET_MESSAGE( p_app_name => G_APP_NAME

4161: INTO l_last_billed_due_date, l_stream_name;
4162: CLOSE get_last_billed_due_date;
4163: IF ( l_last_billed_due_date IS NOT NULL
4164: AND p_rebook_date <= l_last_billed_due_date) THEN
4165: OKC_API.SET_MESSAGE( p_app_name => G_APP_NAME
4166: ,p_msg_name => G_OKL_LLA_RBK_DATE_BILL_INVAL
4167: ,p_token1 => G_STREAM
4168: ,p_token1_value => l_stream_name
4169: ,p_token2 => G_DUE_DATE

Line 4181: OKC_API.SET_MESSAGE( p_app_name => G_APP_NAME

4177: INTO l_last_billed_due_date, l_stream_name;
4178: CLOSE get_last_billed_due_date;
4179: IF ( l_last_billed_due_date IS NOT NULL
4180: AND p_rebook_date <= l_last_billed_due_date) THEN
4181: OKC_API.SET_MESSAGE( p_app_name => G_APP_NAME
4182: ,p_msg_name => G_OKL_LLA_RBK_DATE_BILL_INVAL
4183: ,p_token1 => G_STREAM
4184: ,p_token1_value => l_stream_name
4185: ,p_token2 => G_DUE_DATE

Line 4218: OKC_API.SET_MESSAGE( p_app_name => G_APP_NAME

4214: CLOSE get_last_accrued_due_date; */
4215:
4216: IF ( l_last_billed_due_date IS NOT NULL AND
4217: p_rebook_date <= l_last_billed_due_date) THEN
4218: OKC_API.SET_MESSAGE( p_app_name => G_APP_NAME
4219: ,p_msg_name => G_OKL_LLA_RBK_DATE_BILL_INVAL
4220: ,p_token1 => G_STREAM
4221: ,p_token1_value => l_stream_name
4222: ,p_token2 => G_DUE_DATE

Line 4227: OKC_API.SET_MESSAGE( p_app_name => G_APP_NAME

4223: ,p_token2_value => l_last_billed_due_date);
4224: RAISE OKL_API.G_EXCEPTION_ERROR;
4225: /*ELSIF ( l_last_accrued_due_date IS NOT NULL AND
4226: p_rebook_date <= l_last_accrued_due_date) THEN
4227: OKC_API.SET_MESSAGE( p_app_name => G_APP_NAME
4228: ,p_msg_name => G_OKL_LLA_RBK_DATE_ACCR_INVAL
4229: ,p_token1 => G_STREAM
4230: ,p_token1_value => l_stream_name
4231: ,p_token2 => G_DUE_DATE

Line 4253: OKC_API.SET_MESSAGE( p_app_name => G_APP_NAME

4249: CLOSE get_last_accrued_due_date; */
4250:
4251: IF ( l_last_billed_due_date IS NOT NULL AND
4252: p_rebook_date <= l_last_billed_due_date) THEN
4253: OKC_API.SET_MESSAGE( p_app_name => G_APP_NAME
4254: ,p_msg_name => G_OKL_LLA_RBK_DATE_BILL_INVAL
4255: ,p_token1 => G_STREAM
4256: ,p_token1_value => l_stream_name
4257: ,p_token2 => G_DUE_DATE

Line 4262: OKC_API.SET_MESSAGE( p_app_name => G_APP_NAME

4258: ,p_token2_value => l_last_billed_due_date);
4259: RAISE OKL_API.G_EXCEPTION_ERROR;
4260: /*ELSIF ( l_last_accrued_due_date IS NOT NULL AND
4261: p_rebook_date <= l_last_accrued_due_date) THEN
4262: OKC_API.SET_MESSAGE( p_app_name => G_APP_NAME
4263: ,p_msg_name => G_OKL_LLA_RBK_DATE_ACCR_INVAL
4264: ,p_token1 => G_STREAM
4265: ,p_token1_value => l_stream_name
4266: ,p_token2 => G_DUE_DATE

Line 4276: OKC_API.SET_MESSAGE( p_app_name => G_APP_NAME

4272:
4273: -- Check for Revolving Loans
4274: ELSIF (l_book_class = G_BOOK_CLASS_REVLOAN) THEN
4275: IF (l_interest_calc_basis <> G_ICB_FLOAT) THEN
4276: OKC_API.SET_MESSAGE( p_app_name => G_APP_NAME
4277: ,p_msg_name => G_OKL_LLA_REBOOK_INVALID
4278: ,p_token1 => G_BOOK_CLASS
4279: ,p_token1_value => l_book_class_meaning
4280: ,p_token2 => G_INT_CALC_BASIS

Line 4303: OKC_API.SET_MESSAGE( p_app_name => G_APP_NAME

4299: CLOSE get_last_accrued_due_date; */
4300:
4301: IF ( l_last_billed_due_date IS NOT NULL AND
4302: p_rebook_date <= l_last_billed_due_date) THEN
4303: OKC_API.SET_MESSAGE( p_app_name => G_APP_NAME
4304: ,p_msg_name => G_OKL_LLA_RBK_DATE_BILL_INVAL
4305: ,p_token1 => G_STREAM
4306: ,p_token1_value => l_stream_name
4307: ,p_token2 => G_DUE_DATE

Line 4312: OKC_API.SET_MESSAGE( p_app_name => G_APP_NAME

4308: ,p_token2_value => l_last_billed_due_date);
4309: RAISE OKL_API.G_EXCEPTION_ERROR;
4310: /*ELSIF ( l_last_accrued_due_date IS NOT NULL AND
4311: p_rebook_date <= l_last_accrued_due_date) THEN
4312: OKC_API.SET_MESSAGE( p_app_name => G_APP_NAME
4313: ,p_msg_name => G_OKL_LLA_RBK_DATE_ACCR_INVAL
4314: ,p_token1 => G_STREAM
4315: ,p_token1_value => l_stream_name
4316: ,p_token2 => G_DUE_DATE

Line 4338: OKC_API.SET_MESSAGE( p_app_name => G_APP_NAME

4334: CLOSE get_last_accrued_due_date; */
4335:
4336: IF ( l_last_billed_due_date IS NOT NULL AND
4337: p_rebook_date <= l_last_billed_due_date) THEN
4338: OKC_API.SET_MESSAGE( p_app_name => G_APP_NAME
4339: ,p_msg_name => G_OKL_LLA_RBK_DATE_BILL_INVAL
4340: ,p_token1 => G_STREAM
4341: ,p_token1_value => l_stream_name
4342: ,p_token2 => G_DUE_DATE

Line 4347: OKC_API.SET_MESSAGE( p_app_name => G_APP_NAME

4343: ,p_token2_value => l_last_billed_due_date);
4344: RAISE OKL_API.G_EXCEPTION_ERROR;
4345: /*ELSIF ( l_last_accrued_due_date IS NOT NULL AND
4346: p_rebook_date <= l_last_accrued_due_date) THEN
4347: OKC_API.SET_MESSAGE( p_app_name => G_APP_NAME
4348: ,p_msg_name => G_OKL_LLA_RBK_DATE_ACCR_INVAL
4349: ,p_token1 => G_STREAM
4350: ,p_token1_value => l_stream_name
4351: ,p_token2 => G_DUE_DATE

Line 4759: RAISE OKC_API.G_EXCEPTION_ERROR;

4755: END IF;
4756: END LOOP;
4757: END IF;
4758:
4759: RAISE OKC_API.G_EXCEPTION_ERROR;
4760: END SYNC_RATE_PARAMS;
4761:
4762: PROCEDURE check_base_rate(
4763: p_khr_id IN NUMBER,

Line 4800: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

4796: END;
4797:
4798: PROCEDURE check_principal_payment(
4799: p_api_version IN NUMBER,
4800: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
4801: x_return_status OUT NOCOPY VARCHAR2,
4802: x_msg_count OUT NOCOPY NUMBER,
4803: x_msg_data OUT NOCOPY VARCHAR2,
4804: p_chr_id IN OKC_K_HEADERS_B.ID%TYPE,

Line 4909: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

4905: end;
4906:
4907: PROCEDURE copy_k_rate_params(
4908: p_api_version IN NUMBER,
4909: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
4910: x_return_status OUT NOCOPY VARCHAR2,
4911: x_msg_count OUT NOCOPY NUMBER,
4912: x_msg_data OUT NOCOPY VARCHAR2,
4913: p_khr_id IN NUMBER,

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

5005: l_parameter_type_code := 'ACTUAL';
5006: ELSIF (p_rate_type IN ('INTEREST_RATE_PARAMS_CONV', 'ADDL_INTEREST_RATE_PARAMS_CONV')) THEN
5007: l_parameter_type_code := 'CONVERSION';
5008: ELSE
5009: OKC_API.set_message(p_app_name => G_APP_NAME,
5010: p_msg_name => 'OKL_LLA_VAR_RATE_INV_PARAM');
5011: RAISE OKL_API.G_EXCEPTION_ERROR;
5012: END IF;
5013:

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

5036: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
5037: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'copy:l_orig_system_source_code=' || l_orig_system_source_code);
5038: END IF;
5039: IF (l_orig_system_source_code <> 'OKL_REBOOK') THEN
5040: OKC_API.set_message(p_app_name => G_APP_NAME,
5041: p_msg_name => 'OKL_LLA_VAR_RATE_COPY_NA');
5042: RAISE OKL_API.G_EXCEPTION_ERROR;
5043: END IF;
5044:

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

5057: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'p_effective_from_date=' || p_effective_from_date);
5058: END IF;
5059: IF (l_last_billed_due_date IS NOT NULL AND
5060: p_effective_from_date <= l_last_billed_due_date) THEN
5061: OKC_API.set_message(p_app_name => G_APP_NAME,
5062: p_msg_name => 'OKL_LLA_VAR_RATE_INT_DATE',
5063: p_token1 => 'EFF_DATE',
5064: p_token1_value => p_effective_from_date,
5065: p_token2 => 'INTEREST_DATE',

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

5072: IF (l_interest_calc_basis IN
5073: ('FLOAT', 'REAMORT', 'FLOAT_FACTORS', 'CATCHUP/CLEANUP')) THEN
5074: IF (l_last_interest_cal_date IS NOT NULL) THEN
5075: IF (p_effective_from_date <= l_last_interest_cal_date) THEN
5076: OKC_API.set_message(p_app_name => G_APP_NAME,
5077: p_msg_name => 'OKL_LLA_VAR_RATE_INT_DATE',
5078: p_token1 => 'EFF_DATE',
5079: p_token1_value => p_effective_from_date,
5080: p_token2 => 'INTEREST_DATE',

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

5099: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
5100: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'copy:Yes, inside...');
5101: END IF;
5102: x_return_status := OKL_API.G_RET_STS_ERROR;
5103: OKC_API.set_message(p_app_name => G_APP_NAME,
5104: p_msg_name => 'OKL_LLA_VAR_RATE_EXISTS');
5105: RAISE OKL_API.G_EXCEPTION_ERROR;
5106: END IF;
5107:

Line 5230: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

5226:
5227: -- Bug 4917614
5228: PROCEDURE SYNC_BASE_RATE(
5229: p_api_version IN NUMBER,
5230: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
5231: x_return_status OUT NOCOPY VARCHAR2,
5232: x_msg_count OUT NOCOPY NUMBER,
5233: x_msg_data OUT NOCOPY VARCHAR2,
5234: p_khr_id IN NUMBER) IS