[Home] [Help]
13: -- Lookup Code Validation
14: ---------------------------------------------------------------------------
15: FUNCTION check_lookup_code(p_lookup_type IN VARCHAR2,
16: p_lookup_code IN VARCHAR2) RETURN VARCHAR2 IS
17: x_return_status VARCHAR2(1):= Okl_Api.G_RET_STS_SUCCESS;
18: l_sysdate DATE := SYSDATE ;
19: l_dummy_var VARCHAR2(1) := '?';
20: CURSOR l_lookup_code_csr IS
21: SELECT 'X'
31: CLOSE l_lookup_code_csr;
32: -- if l_dummy_var still set to default, data was not found
33: IF (l_dummy_var = '?') THEN
34: -- notify caller of an error
35: x_return_status := Okl_Api.G_RET_STS_ERROR;
36: END IF;
37: RETURN (x_return_status);
38: EXCEPTION
39: WHEN OTHERS THEN
37: RETURN (x_return_status);
38: EXCEPTION
39: WHEN OTHERS THEN
40: -- notify caller of an UNEXPECTED error
41: x_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;
42: -- verify that cursor was closed
43: IF l_lookup_code_csr%ISOPEN THEN
44: CLOSE l_lookup_code_csr;
45: END IF;
275: BEGIN
276: x_return_status := OKC_API.G_RET_STS_SUCCESS;
277: l_krpv_rec := get_rec(p_krpv_rec, l_row_notfound);
278: IF (l_row_notfound) THEN
279: OKC_API.set_message(OKL_API.G_APP_NAME,G_INVALID_VALUE,G_COL_NAME_TOKEN,'EFFECTIVE_FROM_DATE');
280: OKC_API.set_message(OKL_API.G_APP_NAME,G_INVALID_VALUE,G_COL_NAME_TOKEN,'KHR_ID');
281: OKC_API.set_message(OKL_API.G_APP_NAME,G_INVALID_VALUE,G_COL_NAME_TOKEN,'PARAMETER_TYPE_CODE');
282: x_return_status := OKC_API.G_RET_STS_ERROR;
283: END IF;
276: x_return_status := OKC_API.G_RET_STS_SUCCESS;
277: l_krpv_rec := get_rec(p_krpv_rec, l_row_notfound);
278: IF (l_row_notfound) THEN
279: OKC_API.set_message(OKL_API.G_APP_NAME,G_INVALID_VALUE,G_COL_NAME_TOKEN,'EFFECTIVE_FROM_DATE');
280: OKC_API.set_message(OKL_API.G_APP_NAME,G_INVALID_VALUE,G_COL_NAME_TOKEN,'KHR_ID');
281: OKC_API.set_message(OKL_API.G_APP_NAME,G_INVALID_VALUE,G_COL_NAME_TOKEN,'PARAMETER_TYPE_CODE');
282: x_return_status := OKC_API.G_RET_STS_ERROR;
283: END IF;
284: RETURN(l_krpv_rec);
277: l_krpv_rec := get_rec(p_krpv_rec, l_row_notfound);
278: IF (l_row_notfound) THEN
279: OKC_API.set_message(OKL_API.G_APP_NAME,G_INVALID_VALUE,G_COL_NAME_TOKEN,'EFFECTIVE_FROM_DATE');
280: OKC_API.set_message(OKL_API.G_APP_NAME,G_INVALID_VALUE,G_COL_NAME_TOKEN,'KHR_ID');
281: OKC_API.set_message(OKL_API.G_APP_NAME,G_INVALID_VALUE,G_COL_NAME_TOKEN,'PARAMETER_TYPE_CODE');
282: x_return_status := OKC_API.G_RET_STS_ERROR;
283: END IF;
284: RETURN(l_krpv_rec);
285: END get_rec;
432: BEGIN
433: x_return_status := OKC_API.G_RET_STS_SUCCESS;
434: l_krp_rec := get_rec(p_krp_rec, l_row_notfound);
435: IF (l_row_notfound) THEN
436: OKC_API.set_message(OKL_API.G_APP_NAME,G_INVALID_VALUE,G_COL_NAME_TOKEN,'PARAMETER_TYPE_CODE');
437: OKC_API.set_message(OKL_API.G_APP_NAME,G_INVALID_VALUE,G_COL_NAME_TOKEN,'EFFECTIVE_FROM_DATE');
438: OKC_API.set_message(OKL_API.G_APP_NAME,G_INVALID_VALUE,G_COL_NAME_TOKEN,'KHR_ID');
439: x_return_status := OKC_API.G_RET_STS_ERROR;
440: END IF;
433: x_return_status := OKC_API.G_RET_STS_SUCCESS;
434: l_krp_rec := get_rec(p_krp_rec, l_row_notfound);
435: IF (l_row_notfound) THEN
436: OKC_API.set_message(OKL_API.G_APP_NAME,G_INVALID_VALUE,G_COL_NAME_TOKEN,'PARAMETER_TYPE_CODE');
437: OKC_API.set_message(OKL_API.G_APP_NAME,G_INVALID_VALUE,G_COL_NAME_TOKEN,'EFFECTIVE_FROM_DATE');
438: OKC_API.set_message(OKL_API.G_APP_NAME,G_INVALID_VALUE,G_COL_NAME_TOKEN,'KHR_ID');
439: x_return_status := OKC_API.G_RET_STS_ERROR;
440: END IF;
441: RETURN(l_krp_rec);
434: l_krp_rec := get_rec(p_krp_rec, l_row_notfound);
435: IF (l_row_notfound) THEN
436: OKC_API.set_message(OKL_API.G_APP_NAME,G_INVALID_VALUE,G_COL_NAME_TOKEN,'PARAMETER_TYPE_CODE');
437: OKC_API.set_message(OKL_API.G_APP_NAME,G_INVALID_VALUE,G_COL_NAME_TOKEN,'EFFECTIVE_FROM_DATE');
438: OKC_API.set_message(OKL_API.G_APP_NAME,G_INVALID_VALUE,G_COL_NAME_TOKEN,'KHR_ID');
439: x_return_status := OKC_API.G_RET_STS_ERROR;
440: END IF;
441: RETURN(l_krp_rec);
442: END get_rec;
617: x_return_status := OKC_API.G_RET_STS_SUCCESS;
618: IF (p_khr_id = OKC_API.G_MISS_NUM OR
619: p_khr_id IS NULL)
620: THEN
621: OKC_API.set_message(OKL_API.G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN, 'khr_id');
622: x_return_status := OKC_API.G_RET_STS_ERROR;
623: RAISE G_EXCEPTION_HALT_VALIDATION;
624: END IF;
625: EXCEPTION
644: x_return_status := OKC_API.G_RET_STS_SUCCESS;
645: IF (p_parameter_type_code = OKC_API.G_MISS_CHAR OR
646: p_parameter_type_code IS NULL)
647: THEN
648: OKC_API.set_message(OKL_API.G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN, 'parameter_type_code');
649: x_return_status := OKC_API.G_RET_STS_ERROR;
650: RAISE G_EXCEPTION_HALT_VALIDATION;
651: END IF;
652: EXCEPTION
671: x_return_status := OKC_API.G_RET_STS_SUCCESS;
672: IF (p_effective_from_date = OKC_API.G_MISS_DATE OR
673: p_effective_from_date IS NULL)
674: THEN
675: OKC_API.set_message(OKL_API.G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN, 'effective_from_date');
676: x_return_status := OKC_API.G_RET_STS_ERROR;
677: RAISE G_EXCEPTION_HALT_VALIDATION;
678: END IF;
679: EXCEPTION
776: x_return_status := OKC_API.G_RET_STS_SUCCESS;
777: IF (p_lookup_code = OKC_API.G_MISS_CHAR OR
778: p_lookup_code IS NULL)
779: THEN
780: OKC_API.set_message(OKL_API.G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN, 'Conversion Option Code');
781: x_return_status := OKC_API.G_RET_STS_ERROR;
782: RAISE G_EXCEPTION_HALT_VALIDATION;
783: ELSIF (p_lookup_code <> OKL_API.G_MISS_CHAR AND
784: p_lookup_code is NOT NULL) THEN
779: THEN
780: OKC_API.set_message(OKL_API.G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN, 'Conversion Option Code');
781: x_return_status := OKC_API.G_RET_STS_ERROR;
782: RAISE G_EXCEPTION_HALT_VALIDATION;
783: ELSIF (p_lookup_code <> OKL_API.G_MISS_CHAR AND
784: p_lookup_code is NOT NULL) THEN
785: x_return_status := check_lookup_code('OKL_CONVERSION_OPTION_CODE',
786: p_lookup_code);
787: END IF;
818: CURSOR C1(p_id NUMBER) IS
819: SELECT ID from OKL_FORMULAE_B
820: WHERE ID = p_id;
821: BEGIN
822: x_return_status := OKL_API.G_RET_STS_ERROR;
823: FOR r IN C1(p_calculation_formula_id)
824: LOOP
825: x_return_status := OKL_API.G_RET_STS_SUCCESS;
826: END LOOP;
821: BEGIN
822: x_return_status := OKL_API.G_RET_STS_ERROR;
823: FOR r IN C1(p_calculation_formula_id)
824: LOOP
825: x_return_status := OKL_API.G_RET_STS_SUCCESS;
826: END LOOP;
827: return;
828:
829: EXCEPTION WHEN OTHERS THEN
826: END LOOP;
827: return;
828:
829: EXCEPTION WHEN OTHERS THEN
830: x_return_status := OKL_API.G_RET_STS_ERROR;
831: END validate_calculatio_formula_id;
832: --------------------------------------------------
833: -- Validate_Attributes for: catchup_frequency_code --
834: --------------------------------------------------
849: CURSOR C1(p_id NUMBER) IS
850: SELECT ID from OKL_INDICES
851: WHERE ID = p_id;
852: BEGIN
853: x_return_status := OKL_API.G_RET_STS_ERROR;
854: FOR r IN C1(p_interest_index_id)
855: LOOP
856: x_return_status := OKL_API.G_RET_STS_SUCCESS;
857: END LOOP;
852: BEGIN
853: x_return_status := OKL_API.G_RET_STS_ERROR;
854: FOR r IN C1(p_interest_index_id)
855: LOOP
856: x_return_status := OKL_API.G_RET_STS_SUCCESS;
857: END LOOP;
858: return;
859:
860: EXCEPTION WHEN OTHERS THEN
857: END LOOP;
858: return;
859:
860: EXCEPTION WHEN OTHERS THEN
861: x_return_status := OKL_API.G_RET_STS_ERROR;
862: END validate_interest_index_id;
863:
864: --------------------------------------------------
865: -- Validate_Attributes for: days_in_a_month_code --
968: -- khr_id
969: -- ***
970: validate_khr_id(x_return_status, p_krpv_rec.khr_id);
971: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
972: OKL_API.SET_MESSAGE( p_app_name => OKL_API.G_APP_NAME
973: ,p_msg_name => 'OKL_LA_VAR_INVALID_PARAM'
974: ,p_token1 => 'VALUE'
975: ,p_token1_value => p_krpv_rec.khr_id
976: ,p_token2 => 'PARAM'
1001: x_return_status := check_lookup_code('OKL_RATE_PARAM_TYPE_CODE',
1002: p_krpv_rec.parameter_type_code);
1003: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
1004: -- AKP Todo: Set message (invalid parameter type code)
1005: OKL_API.SET_MESSAGE( p_app_name => OKL_API.G_APP_NAME
1006: ,p_msg_name => 'OKL_LA_INVALID_PARAM_TYPE_CODE'
1007: ,p_token1 => 'CODE'
1008: ,p_token1_value => p_krpv_rec.parameter_type_code);
1009: l_return_status := x_return_status;
1019: -- effective_from_date
1020: -- ***
1021: validate_effective_from_date(x_return_status, p_krpv_rec.effective_from_date);
1022: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
1023: OKL_API.SET_MESSAGE( p_app_name => OKL_API.G_APP_NAME
1024: ,p_msg_name => 'OKL_LA_VAR_INVALID_PARAM'
1025: ,p_token1 => 'VALUE'
1026: ,p_token1_value => p_krpv_rec.effective_from_date
1027: ,p_token2 => 'PARAM'
1045: p_krpv_rec.interest_basis_code);
1046: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
1047: l_return_status := x_return_status;
1048: -- AKP Todo: Set message (invalid Interest Calculation basis code)
1049: OKL_API.SET_MESSAGE( p_app_name => OKL_API.G_APP_NAME
1050: ,p_msg_name => 'OKL_LA_VAR_INVALID_PARAM'
1051: ,p_token1 => 'VALUE'
1052: ,p_token1_value => p_krpv_rec.interest_basis_code
1053: ,p_token2 => 'PARAM'
1069: p_krpv_rec.Rate_Delay_Code);
1070: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
1071: l_return_status := x_return_status;
1072: -- AKP Todo: Set message (invalid Rate Delay code)
1073: OKL_API.SET_MESSAGE( p_app_name => OKL_API.G_APP_NAME
1074: ,p_msg_name => 'OKL_LA_VAR_INVALID_PARAM'
1075: ,p_token1 => 'VALUE'
1076: ,p_token1_value => p_krpv_rec.rate_delay_code
1077: ,p_token2 => 'PARAM'
1093: p_krpv_rec.Compounding_Frequency_Code);
1094: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
1095: l_return_status := x_return_status;
1096: -- AKP Todo: Set message (invalid Compounding_Frequency_Code)
1097: OKL_API.SET_MESSAGE( p_app_name => OKL_API.G_APP_NAME
1098: ,p_msg_name => 'OKL_LA_VAR_INVALID_PARAM'
1099: ,p_token1 => 'VALUE'
1100: ,p_token1_value => p_krpv_rec.compounding_frequency_code
1101: ,p_token2 => 'PARAM'
1117: p_krpv_rec.Rate_Change_Frequency_Code);
1118: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
1119: l_return_status := x_return_status;
1120: -- AKP Todo: Set message (invalid Rate Change Frequency Code)
1121: OKL_API.SET_MESSAGE( p_app_name => OKL_API.G_APP_NAME
1122: ,p_msg_name => 'OKL_LA_VAR_INVALID_PARAM'
1123: ,p_token1 => 'VALUE'
1124: ,p_token1_value => p_krpv_rec.rate_change_frequency_code
1125: ,p_token2 => 'PARAM'
1141: p_krpv_rec.Principal_Basis_Code);
1142: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
1143: l_return_status := x_return_status;
1144: -- AKP Todo: Set message (invalid Principal_Basis_Code)
1145: OKL_API.SET_MESSAGE( p_app_name => OKL_API.G_APP_NAME
1146: ,p_msg_name => 'OKL_LA_VAR_INVALID_PARAM'
1147: ,p_token1 => 'VALUE'
1148: ,p_token1_value => p_krpv_rec.principal_basis_code
1149: ,p_token2 => 'PARAM'
1166: p_krpv_rec.Catchup_Basis_Code);
1167: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
1168: l_return_status := x_return_status;
1169: -- AKP Todo: Set message (invalid Catchup_Basis_Code)
1170: OKL_API.SET_MESSAGE( p_app_name => OKL_API.G_APP_NAME
1171: ,p_msg_name => 'OKL_LA_VAR_INVALID_PARAM'
1172: ,p_token1 => 'VALUE'
1173: ,p_token1_value => p_krpv_rec.catchup_basis_code
1174: ,p_token2 => 'PARAM'
1191: p_krpv_rec.Catchup_Settlement_Code);
1192: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
1193: l_return_status := x_return_status;
1194: -- AKP Todo: Set message (invalid Catchup_Settlement_Code)
1195: OKL_API.SET_MESSAGE( p_app_name => OKL_API.G_APP_NAME
1196: ,p_msg_name => 'OKL_LA_VAR_INVALID_PARAM'
1197: ,p_token1 => 'VALUE'
1198: ,p_token1_value => p_krpv_rec.catchup_settlement_code
1199: ,p_token2 => 'PARAM'
1216: p_krpv_rec.Conversion_Option_Code);
1217: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
1218: l_return_status := x_return_status;
1219: -- AKP Todo: Set message (invalid Conversion_Option_Code)
1220: OKL_API.SET_MESSAGE( p_app_name => OKL_API.G_APP_NAME
1221: ,p_msg_name => 'OKL_LA_VAR_INVALID_PARAM'
1222: ,p_token1 => 'VALUE'
1223: ,p_token1_value => p_krpv_rec.conversion_option_code
1224: ,p_token2 => 'PARAM'
1241: p_krpv_rec.Conversion_Type_Code);
1242: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
1243: l_return_status := x_return_status;
1244: -- AKP Todo: Set message (invalid Conversion_Type_Code)
1245: OKL_API.SET_MESSAGE( p_app_name => OKL_API.G_APP_NAME
1246: ,p_msg_name => 'OKL_LA_VAR_INVALID_PARAM'
1247: ,p_token1 => 'VALUE'
1248: ,p_token1_value => p_krpv_rec.conversion_type_code
1249: ,p_token2 => 'PARAM'
1263: validate_calculatio_formula_id(x_return_status,
1264: p_krpv_rec.calculation_formula_id);
1265: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
1266: l_return_status := x_return_status;
1267: OKL_API.SET_MESSAGE( p_app_name => OKL_API.G_APP_NAME
1268: ,p_msg_name => 'OKL_LA_VAR_INVALID_PARAM'
1269: ,p_token1 => 'VALUE'
1270: ,p_token1_value => p_krpv_rec.calculation_formula_id
1271: ,p_token2 => 'PARAM'
1284: validate_catchup_freq_code(x_return_status,
1285: p_krpv_rec.catchup_frequency_code);
1286: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
1287: l_return_status := x_return_status;
1288: OKL_API.SET_MESSAGE( p_app_name => OKL_API.G_APP_NAME
1289: ,p_msg_name => 'OKL_LA_VAR_INVALID_PARAM'
1290: ,p_token1 => 'VALUE'
1291: ,p_token1_value => p_krpv_rec.catchup_frequency_code
1292: ,p_token2 => 'PARAM'
1305: validate_interest_index_id(x_return_status,
1306: p_krpv_rec.interest_index_id);
1307: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
1308: l_return_status := x_return_status;
1309: OKL_API.SET_MESSAGE( p_app_name => OKL_API.G_APP_NAME
1310: ,p_msg_name => 'OKL_LA_VAR_INVALID_PARAM'
1311: ,p_token1 => 'VALUE'
1312: ,p_token1_value => p_krpv_rec.interest_index_id
1313: ,p_token2 => 'PARAM'
1326: validate_days_in_a_month_code(x_return_status,
1327: p_krpv_rec.days_in_a_month_code);
1328: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
1329: l_return_status := x_return_status;
1330: OKL_API.SET_MESSAGE( p_app_name => OKL_API.G_APP_NAME
1331: ,p_msg_name => 'OKL_LA_VAR_INVALID_PARAM'
1332: ,p_token1 => 'VALUE'
1333: ,p_token1_value => p_krpv_rec.days_in_a_month_code
1334: ,p_token2 => 'PARAM'
1347: validate_days_in_a_year_code(x_return_status,
1348: p_krpv_rec.days_in_a_year_code);
1349: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
1350: l_return_status := x_return_status;
1351: OKL_API.SET_MESSAGE( p_app_name => OKL_API.G_APP_NAME
1352: ,p_msg_name => 'OKL_LA_VAR_INVALID_PARAM'
1353: ,p_token1 => 'VALUE'
1354: ,p_token1_value => p_krpv_rec.days_in_a_year_code
1355: ,p_token2 => 'PARAM'
1369: IF (p_krpv_rec.Rate_Delay_Frequency is NOT NULL AND
1370: p_krpv_rec.Rate_Delay_Frequency <> G_MISS_NUM) THEN
1371: NULL;
1372: ELSE
1373: OKC_API.set_message(p_app_name => OKL_API.G_APP_NAME,
1374: p_msg_name => G_REQUIRED_VALUE,
1375: p_token1 => G_COL_NAME_TOKEN,
1376: p_token1_value => 'Rate Delay'); -- changed to rate dealy
1377: l_return_status := OKC_API.G_RET_STS_ERROR;
1381: END IF;
1382: ELSE -- Rate delay code is null
1383: IF (p_krpv_rec.Rate_Delay_Frequency is NOT NULL AND p_krpv_rec.Rate_Delay_Frequency <> 0 AND -- added and condition for bug 14701461
1384: p_krpv_rec.Rate_Delay_Frequency <> G_MISS_NUM) THEN
1385: OKC_API.set_message(p_app_name => OKL_API.G_APP_NAME,
1386: p_msg_name => G_REQUIRED_VALUE,
1387: p_token1 => G_COL_NAME_TOKEN,
1388: p_token1_value => 'Rate Delay Frequency'); -- changed to rate delay frequency
1389: l_return_status := OKC_API.G_RET_STS_ERROR;
1399: IF (p_krpv_rec.calculation_formula_id is NOT NULL AND
1400: p_krpv_rec.calculation_formula_id <> G_MISS_NUM) THEN
1401: NULL;
1402: ELSE
1403: OKC_API.set_message(p_app_name => OKL_API.G_APP_NAME,
1404: p_msg_name => G_REQUIRED_VALUE,
1405: p_token1 => G_COL_NAME_TOKEN,
1406: p_token1_value => 'Formula Name');
1407: l_return_status := OKC_API.G_RET_STS_ERROR;
1419: IF (p_krpv_rec.rate_change_start_date is NOT NULL AND
1420: p_krpv_rec.rate_change_start_date <> G_MISS_DATE) THEN
1421: NULL;
1422: ELSE
1423: OKC_API.set_message(p_app_name => OKL_API.G_APP_NAME,
1424: p_msg_name => G_REQUIRED_VALUE,
1425: p_token1 => G_COL_NAME_TOKEN,
1426: p_token1_value => 'Rate Change Start Date');
1427: l_return_status := OKC_API.G_RET_STS_ERROR;
1433: IF (p_krpv_rec.rate_change_value is NOT NULL AND
1434: p_krpv_rec.rate_change_value <> G_MISS_NUM) THEN
1435: NULL;
1436: ELSE
1437: OKC_API.set_message(p_app_name => OKL_API.G_APP_NAME,
1438: p_msg_name => G_REQUIRED_VALUE,
1439: p_token1 => G_COL_NAME_TOKEN,
1440: p_token1_value => 'Rate Change Value');
1441: l_return_status := OKC_API.G_RET_STS_ERROR;
1448: IF ((p_krpv_rec.rate_change_value is NOT NULL AND
1449: p_krpv_rec.rate_change_value <> G_MISS_NUM) OR
1450: (p_krpv_rec.rate_change_start_date is NOT NULL AND
1451: p_krpv_rec.rate_change_start_date <> G_MISS_DATE) ) THEN
1452: OKC_API.set_message(p_app_name => OKL_API.G_APP_NAME,
1453: p_msg_name => G_REQUIRED_VALUE,
1454: p_token1 => G_COL_NAME_TOKEN,
1455: p_token1_value => 'Rate Change Frequency');
1456: l_return_status := OKC_API.G_RET_STS_ERROR;
1468: IF (p_krpv_rec.next_conversion_date is NOT NULL AND
1469: p_krpv_rec.next_conversion_date <> G_MISS_DATE) THEN
1470: NULL;
1471: ELSE
1472: OKC_API.set_message(p_app_name => OKL_API.G_APP_NAME,
1473: p_msg_name => G_REQUIRED_VALUE,
1474: p_token1 => G_COL_NAME_TOKEN,
1475: p_token1_value => 'Next Conversion Date');
1476: l_return_status := OKC_API.G_RET_STS_ERROR;
1482: IF (p_krpv_rec.conversion_type_code is NOT NULL AND
1483: p_krpv_rec.conversion_type_code <> G_MISS_CHAR) THEN
1484: NULL;
1485: ELSE
1486: OKC_API.set_message(p_app_name => OKL_API.G_APP_NAME,
1487: p_msg_name => G_REQUIRED_VALUE,
1488: p_token1 => G_COL_NAME_TOKEN,
1489: p_token1_value => 'Conversion Type');
1490: l_return_status := OKC_API.G_RET_STS_ERROR;
1498: p_krpv_rec.conversion_type_code <> G_MISS_CHAR) OR
1499: (p_krpv_rec.next_conversion_date is NOT NULL AND
1500: p_krpv_rec.next_conversion_date <> G_MISS_DATE)) THEN
1501:
1502: OKC_API.set_message(p_app_name => OKL_API.G_APP_NAME,
1503: p_msg_name => G_REQUIRED_VALUE,
1504: p_token1 => G_COL_NAME_TOKEN,
1505: p_token1_value => 'Conversion Option Code');
1506: l_return_status := OKC_API.G_RET_STS_ERROR;
1511: END IF;
1512:
1513: END IF;
1514:
1515: IF (l_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
1516: RAISE G_EXCEPTION_HALT_VALIDATION;
1517: END IF;
1518:
1519: RETURN(l_return_status);
1600: IF (p_krpv_rec.Conversion_Option_Code = OKC_API.G_MISS_CHAR OR
1601: p_krpv_rec.Conversion_Option_Code IS NULL)
1602: THEN
1603: print('Conversion_Option_Code is NULL...');
1604: --OKC_API.set_message(OKL_API.G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN, 'Conversion_Option_Code');
1605: OKC_API.set_message(p_app_name => OKL_API.G_APP_NAME,
1606: p_msg_name => G_REQUIRED_VALUE,
1607: p_token1 => G_COL_NAME_TOKEN,
1608: p_token1_value => 'Conversion_Option_Code');
1601: p_krpv_rec.Conversion_Option_Code IS NULL)
1602: THEN
1603: print('Conversion_Option_Code is NULL...');
1604: --OKC_API.set_message(OKL_API.G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN, 'Conversion_Option_Code');
1605: OKC_API.set_message(p_app_name => OKL_API.G_APP_NAME,
1606: p_msg_name => G_REQUIRED_VALUE,
1607: p_token1 => G_COL_NAME_TOKEN,
1608: p_token1_value => 'Conversion_Option_Code');
1609: l_return_status := OKC_API.G_RET_STS_ERROR;
1619: IF (p_krpv_rec.Next_Conversion_Date = OKC_API.G_MISS_DATE OR
1620: p_krpv_rec.Next_Conversion_Date IS NULL)
1621: THEN
1622: print('next_Conversion_Date is NULL...');
1623: OKC_API.set_message(OKL_API.G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN, 'Next_Conversion_Date');
1624: l_return_status := OKC_API.G_RET_STS_ERROR;
1625: IF (p_stack_messages = 'N') THEN
1626: RAISE violated_ref_integrity;
1627: END IF;
1636: IF (p_krpv_rec.Conversion_Type_Code = OKC_API.G_MISS_CHAR OR
1637: p_krpv_rec.Conversion_Type_Code IS NULL)
1638: THEN
1639: print('Conversion_Type_Code is NULL...');
1640: OKC_API.set_message(OKL_API.G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN, 'Conversion Type Code');
1641: l_return_status := OKC_API.G_RET_STS_ERROR;
1642: IF (p_stack_messages = 'N') THEN
1643: RAISE violated_ref_integrity;
1644: END IF;
1648: ELSIF (p_int_calc_basis = 'REAMORT' AND p_rev_rec_method ='STREAMS') THEN
1649: IF (p_krpv_rec.Interest_Index_Id = OKC_API.G_MISS_NUM OR
1650: p_krpv_rec.Interest_Index_Id IS NULL)
1651: THEN
1652: OKC_API.set_message(OKL_API.G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN,
1653: 'Interest Index Id');
1654: l_return_status := OKC_API.G_RET_STS_ERROR;
1655: IF (p_stack_messages = 'N') THEN
1656: RAISE violated_ref_integrity;
1660: -- Bug 4907390
1661: /*IF (p_krpv_rec.Base_Rate = OKC_API.G_MISS_NUM OR
1662: p_krpv_rec.Base_Rate IS NULL)
1663: THEN
1664: OKC_API.set_message(OKL_API.G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN,
1665: 'Base Rate');
1666: l_return_status := OKC_API.G_RET_STS_ERROR;
1667: IF (p_stack_messages = 'N') THEN
1668: RAISE violated_ref_integrity;
1671:
1672: IF (p_krpv_rec.Interest_Start_Date = OKC_API.G_MISS_DATE OR
1673: p_krpv_rec.Interest_Start_Date IS NULL)
1674: THEN
1675: OKC_API.set_message(OKL_API.G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN,
1676: 'Interest Start Date');
1677: l_return_status := OKC_API.G_RET_STS_ERROR;
1678: IF (p_stack_messages = 'N') THEN
1679: RAISE violated_ref_integrity;
1685: LOOP
1686:
1687: IF ( TRUNC(p_krpv_rec.Interest_Start_Date) <> TRUNC(r1.start_date) )
1688: THEN
1689: OKL_API.SET_MESSAGE( p_app_name => OKL_API.G_APP_NAME
1690: ,p_msg_name => 'OKL_LA_INT_START_DT_REAMORT');
1691: l_return_status := OKC_API.G_RET_STS_ERROR;
1692: IF (p_stack_messages = 'N') THEN
1693: RAISE violated_ref_integrity;
1699:
1700: IF (p_krpv_rec.Adder_Rate = OKC_API.G_MISS_NUM OR
1701: p_krpv_rec.Adder_Rate IS NULL)
1702: THEN
1703: OKC_API.set_message(OKL_API.G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN,
1704: 'Adder Rate');
1705: l_return_status := OKC_API.G_RET_STS_ERROR;
1706: IF (p_stack_messages = 'N') THEN
1707: RAISE violated_ref_integrity;
1710:
1711: IF (p_krpv_rec.Maximum_Rate = OKC_API.G_MISS_NUM OR
1712: p_krpv_rec.Maximum_Rate IS NULL)
1713: THEN
1714: OKC_API.set_message(OKL_API.G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN,
1715: 'Maximum Rate');
1716: l_return_status := OKC_API.G_RET_STS_ERROR;
1717: IF (p_stack_messages = 'N') THEN
1718: RAISE violated_ref_integrity;
1721:
1722: IF (p_krpv_rec.Minimum_Rate = OKC_API.G_MISS_NUM OR
1723: p_krpv_rec.Minimum_Rate IS NULL)
1724: THEN
1725: OKC_API.set_message(OKL_API.G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN,
1726: 'Minimum Rate');
1727: l_return_status := OKC_API.G_RET_STS_ERROR;
1728: IF (p_stack_messages = 'N') THEN
1729: RAISE violated_ref_integrity;
1732:
1733: IF (p_krpv_rec.Principal_Basis_Code = OKC_API.G_MISS_CHAR OR
1734: p_krpv_rec.Principal_Basis_Code IS NULL)
1735: THEN
1736: OKC_API.set_message(OKL_API.G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN,
1737: 'Principal Basis Code');
1738: l_return_status := OKC_API.G_RET_STS_ERROR;
1739: IF (p_stack_messages = 'N') THEN
1740: RAISE violated_ref_integrity;
1743: p_krpv_rec.Principal_Basis_Code IS NOT NULL) THEN
1744: IF (p_krpv_rec.Principal_Basis_Code <> 'SCHEDULED') THEN
1745: -- AKP: Todo: Set Proper Message
1746: --(Principal Basis Code is 'SCHEDULED' allowed only)
1747: OKL_API.SET_MESSAGE( p_app_name => OKL_API.G_APP_NAME
1748: ,p_msg_name => 'OKL_LA_APPLICABLE_VALUES'
1749: ,p_token1 => 'VALUE'
1750: ,p_token1_value => 'SCHEDULED'
1751: ,p_token2 => 'CODE0'
1763:
1764: IF (p_krpv_rec.Days_In_A_Month_Code = OKC_API.G_MISS_CHAR OR
1765: p_krpv_rec.Days_In_A_Month_Code IS NULL)
1766: THEN
1767: OKC_API.set_message(OKL_API.G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN,
1768: 'Days In A Month Code');
1769: l_return_status := OKC_API.G_RET_STS_ERROR;
1770: IF (p_stack_messages = 'N') THEN
1771: RAISE violated_ref_integrity;
1774: p_krpv_rec.Days_In_A_Month_Code IS NOT NULL) THEN
1775: IF (p_krpv_rec.Days_In_A_Month_Code <> '30') THEN
1776: -- AKP: Todo: Set Proper Message
1777: --(Days In A Month Code is '30' allowed only)
1778: OKL_API.SET_MESSAGE( p_app_name => OKL_API.G_APP_NAME
1779: ,p_msg_name => 'OKL_LA_APPLICABLE_VALUES'
1780: ,p_token1 => 'VALUE'
1781: ,p_token1_value => '30'
1782: ,p_token2 => 'CODE0'
1794:
1795: IF (p_krpv_rec.Days_In_A_Year_Code = OKC_API.G_MISS_CHAR OR
1796: p_krpv_rec.Days_In_A_Year_Code IS NULL)
1797: THEN
1798: OKC_API.set_message(OKL_API.G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN,
1799: 'Days In A Year Code');
1800: l_return_status := OKC_API.G_RET_STS_ERROR;
1801: IF (p_stack_messages = 'N') THEN
1802: RAISE violated_ref_integrity;
1805: p_krpv_rec.Days_In_A_Year_Code IS NOT NULL) THEN
1806: IF (p_krpv_rec.Days_In_A_Year_Code <> '360') THEN
1807: -- AKP: Todo: Set Proper Message
1808: --(Days In A Year Code is '360' allowed only)
1809: OKL_API.SET_MESSAGE( p_app_name => OKL_API.G_APP_NAME
1810: ,p_msg_name => 'OKL_LA_APPLICABLE_VALUES'
1811: ,p_token1 => 'VALUE'
1812: ,p_token1_value => '360'
1813: ,p_token2 => 'CODE0'
1825:
1826: IF (p_krpv_rec.Interest_Basis_Code = OKC_API.G_MISS_CHAR OR
1827: p_krpv_rec.Interest_Basis_Code IS NULL)
1828: THEN
1829: OKC_API.set_message(OKL_API.G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN,
1830: 'Interest Basis Code');
1831: l_return_status := OKC_API.G_RET_STS_ERROR;
1832: IF (p_stack_messages = 'N') THEN
1833: RAISE violated_ref_integrity;
1836: p_krpv_rec.Interest_Basis_Code IS NOT NULL) THEN
1837: IF (p_krpv_rec.Interest_Basis_Code <> 'SIMPLE') THEN
1838: -- AKP: Todo: Set Proper Message
1839: --(Interest Basis Code is 'SIMPLE' allowed only)
1840: OKL_API.SET_MESSAGE( p_app_name => OKL_API.G_APP_NAME
1841: ,p_msg_name => 'OKL_LA_APPLICABLE_VALUES'
1842: ,p_token1 => 'VALUE'
1843: ,p_token1_value => 'SIMPLE'
1844: ,p_token2 => 'CODE0'
1860: /*
1861: IF (p_krpv_rec.Rate_Delay_Code = OKC_API.G_MISS_CHAR OR
1862: p_krpv_rec.Rate_Delay_Code IS NULL)
1863: THEN
1864: OKC_API.set_message(OKL_API.G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN,
1865: 'Rate Delay Code');
1866: l_return_status := OKC_API.G_RET_STS_ERROR;
1867: IF (p_stack_messages = 'N') THEN
1868: RAISE violated_ref_integrity;
1871:
1872: IF (p_krpv_rec.Rate_Delay_Frequency = OKC_API.G_MISS_NUM OR
1873: p_krpv_rec.Rate_Delay_Frequency IS NULL)
1874: THEN
1875: OKC_API.set_message(OKL_API.G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN,
1876: 'Rate Delay Frequency');
1877: l_return_status := OKC_API.G_RET_STS_ERROR;
1878: IF (p_stack_messages = 'N') THEN
1879: RAISE violated_ref_integrity;
1882:
1883: IF (p_krpv_rec.Rate_Change_Start_Date = OKC_API.G_MISS_DATE OR
1884: p_krpv_rec.Rate_Change_Start_Date IS NULL)
1885: THEN
1886: OKC_API.set_message(OKL_API.G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN,
1887: 'Rate Change Start Date');
1888: l_return_status := OKC_API.G_RET_STS_ERROR;
1889: IF (p_stack_messages = 'N') THEN
1890: RAISE violated_ref_integrity;
1895: IF (p_krpv_rec.Rate_Change_Frequency_Code = OKC_API.G_MISS_CHAR OR
1896: p_krpv_rec.Rate_Change_Frequency_Code IS NULL)
1897: THEN
1898: -- Bug 4862551
1899: /*OKC_API.set_message(OKL_API.G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN,
1900: 'Rate Change Frequency Code');
1901: l_return_status := OKC_API.G_RET_STS_ERROR;
1902: IF (p_stack_messages = 'N') THEN
1903: RAISE violated_ref_integrity;
1907: p_krpv_rec.Rate_Change_Frequency_Code IS NOT NULL) THEN
1908: IF (p_krpv_rec.Rate_Change_Frequency_Code <> 'BILLING_DATE') THEN
1909: -- AKP: Todo: Set Proper Message
1910: --(Rate Change Frequency Code is 'BILLING_DATE' allowed only)
1911: OKL_API.SET_MESSAGE( p_app_name => OKL_API.G_APP_NAME
1912: ,p_msg_name => 'OKL_LA_APPLICABLE_VALUES'
1913: ,p_token1 => 'VALUE'
1914: ,p_token1_value => 'BILLING_DATE'
1915: ,p_token2 => 'CODE0'
1929: /*
1930: IF (p_krpv_rec.Rate_Change_Value = OKC_API.G_MISS_NUM OR
1931: p_krpv_rec.Rate_Change_Value IS NULL)
1932: THEN
1933: OKC_API.set_message(OKL_API.G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN,
1934: 'Rate Change Value');
1935: l_return_status := OKC_API.G_RET_STS_ERROR;
1936: IF (p_stack_messages = 'N') THEN
1937: RAISE violated_ref_integrity;
1942: /*IF (p_krpv_rec.parameter_type_code = 'ACTUAL') THEN
1943: IF (p_krpv_rec.Conversion_Option_Code = OKC_API.G_MISS_CHAR OR
1944: p_krpv_rec.Conversion_Option_Code IS NULL)
1945: THEN
1946: OKC_API.set_message(OKL_API.G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN,
1947: 'Conversion Option Code');
1948: l_return_status := OKC_API.G_RET_STS_ERROR;
1949: IF (p_stack_messages = 'N') THEN
1950: RAISE violated_ref_integrity;
1955: /*IF (p_krpv_rec.parameter_type_code = 'ACTUAL') THEN
1956: IF (p_krpv_rec.Next_Conversion_Date = OKC_API.G_MISS_DATE OR
1957: p_krpv_rec.Next_Conversion_Date IS NULL)
1958: THEN
1959: OKC_API.set_message(OKL_API.G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN,
1960: 'Next Conversion Date');
1961: l_return_status := OKC_API.G_RET_STS_ERROR;
1962: IF (p_stack_messages = 'N') THEN
1963: RAISE violated_ref_integrity;
1968: /*IF (p_krpv_rec.parameter_type_code = 'ACTUAL') THEN
1969: IF (p_krpv_rec.Conversion_Type_Code = OKC_API.G_MISS_CHAR OR
1970: p_krpv_rec.Conversion_Type_Code IS NULL)
1971: THEN
1972: OKC_API.set_message(OKL_API.G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN,
1973: 'Conversion Type Code');
1974: l_return_status := OKC_API.G_RET_STS_ERROR;
1975: IF (p_stack_messages = 'N') THEN
1976: RAISE violated_ref_integrity;
1983: -- Bug 4907390
1984: /*IF (p_krpv_rec.Base_Rate = OKC_API.G_MISS_NUM OR
1985: p_krpv_rec.Base_Rate IS NULL)
1986: THEN
1987: OKC_API.set_message(OKL_API.G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN,
1988: 'Base Rate');
1989: l_return_status := OKC_API.G_RET_STS_ERROR;
1990: IF (p_stack_messages = 'N') THEN
1991: RAISE violated_ref_integrity;
1994:
1995: IF (p_krpv_rec.Interest_Start_Date = OKC_API.G_MISS_DATE OR
1996: p_krpv_rec.Interest_Start_Date IS NULL)
1997: THEN
1998: OKC_API.set_message(OKL_API.G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN,
1999: 'Interest Start Date');
2000: l_return_status := OKC_API.G_RET_STS_ERROR;
2001: IF (p_stack_messages = 'N') THEN
2002: RAISE violated_ref_integrity;
2006: /*IF (p_krpv_rec.parameter_type_code = 'ACTUAL') THEN
2007: IF (p_krpv_rec.Conversion_Option_Code = OKC_API.G_MISS_CHAR OR
2008: p_krpv_rec.Conversion_Option_Code IS NULL)
2009: THEN
2010: OKC_API.set_message(OKL_API.G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN,
2011: 'Conversion Option Code');
2012: l_return_status := OKC_API.G_RET_STS_ERROR;
2013: IF (p_stack_messages = 'N') THEN
2014: RAISE violated_ref_integrity;
2019: /*IF (p_krpv_rec.parameter_type_code = 'ACTUAL') THEN
2020: IF (p_krpv_rec.Next_Conversion_Date = OKC_API.G_MISS_DATE OR
2021: p_krpv_rec.Next_Conversion_Date IS NULL)
2022: THEN
2023: OKC_API.set_message(OKL_API.G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN,
2024: 'Next Conversion Date');
2025: l_return_status := OKC_API.G_RET_STS_ERROR;
2026: IF (p_stack_messages = 'N') THEN
2027: RAISE violated_ref_integrity;
2032: /*IF (p_krpv_rec.parameter_type_code = 'ACTUAL') THEN
2033: IF (p_krpv_rec.Conversion_Type_Code = OKC_API.G_MISS_CHAR OR
2034: p_krpv_rec.Conversion_Type_Code IS NULL)
2035: THEN
2036: OKC_API.set_message(OKL_API.G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN,
2037: 'Conversion Type Code');
2038: l_return_status := OKC_API.G_RET_STS_ERROR;
2039: IF (p_stack_messages = 'N') THEN
2040: RAISE violated_ref_integrity;
2045: -- Bug 4753087
2046: IF (p_krpv_rec.Principal_Basis_Code = OKC_API.G_MISS_CHAR OR
2047: p_krpv_rec.Principal_Basis_Code IS NULL)
2048: THEN
2049: OKC_API.set_message(OKL_API.G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN,
2050: 'Principal Basis Code');
2051: l_return_status := OKC_API.G_RET_STS_ERROR;
2052: IF (p_stack_messages = 'N') THEN
2053: RAISE violated_ref_integrity;
2056: p_krpv_rec.Principal_Basis_Code IS NOT NULL) THEN
2057: IF (p_krpv_rec.Principal_Basis_Code <> 'SCHEDULED') THEN
2058: -- AKP: Todo: Set Proper Message
2059: --(Principal Basis Code is 'SCHEDULED' allowed only)
2060: OKL_API.SET_MESSAGE( p_app_name => OKL_API.G_APP_NAME
2061: ,p_msg_name => 'OKL_LA_APPLICABLE_VALUES'
2062: ,p_token1 => 'VALUE'
2063: ,p_token1_value => 'SCHEDULED'
2064: ,p_token2 => 'CODE0'
2078: IF (p_krpv_rec.Calculation_Formula_Id = OKC_API.G_MISS_NUM OR
2079: p_krpv_rec.Calculation_Formula_Id IS NULL)
2080: THEN
2081: l_msg2_set := TRUE;
2082: OKC_API.set_message(OKL_API.G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN,
2083: 'Formula Name');
2084: l_return_status := OKC_API.G_RET_STS_ERROR;
2085: IF (p_stack_messages = 'N') THEN
2086: RAISE violated_ref_integrity;
2099: p_krpv_rec.Base_Rate IS NULL)
2100: THEN
2101: OKL_K_RATE_PARAMS_PVT.check_principal_payment(
2102: p_api_version => 1,
2103: p_init_msg_list => OKL_API.G_FALSE,
2104: x_return_status => lx_return_status, --Bug# 13002041
2105: x_msg_count => l_msg_count,
2106: x_msg_data => l_msg_data,
2107: p_chr_id => p_krpv_rec.khr_id,
2106: x_msg_data => l_msg_data,
2107: p_chr_id => p_krpv_rec.khr_id,
2108: x_principal_payment_defined => l_principal_payment_defined);
2109: --Bug# 13002041
2110: IF (lx_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
2111: l_return_status := lx_return_status;
2112: RAISE violated_ref_integrity;
2113: END IF;
2114:
2112: RAISE violated_ref_integrity;
2113: END IF;
2114:
2115: IF (l_principal_payment_defined) THEN
2116: OKC_API.set_message(OKL_API.G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN,
2117: 'Base Rate');
2118: l_return_status := OKC_API.G_RET_STS_ERROR;
2119: IF (p_stack_messages = 'N') THEN
2120: RAISE violated_ref_integrity;
2125: /*IF (p_krpv_rec.parameter_type_code = 'ACTUAL') THEN
2126: IF (p_krpv_rec.Conversion_Option_Code = OKC_API.G_MISS_CHAR OR
2127: p_krpv_rec.Conversion_Option_Code IS NULL)
2128: THEN
2129: OKC_API.set_message(OKL_API.G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN,
2130: 'Conversion Option Code');
2131: l_return_status := OKC_API.G_RET_STS_ERROR;
2132: IF (p_stack_messages = 'N') THEN
2133: RAISE violated_ref_integrity;
2138: /*IF (p_krpv_rec.parameter_type_code = 'ACTUAL') THEN
2139: IF (p_krpv_rec.Next_Conversion_Date = OKC_API.G_MISS_DATE OR
2140: p_krpv_rec.Next_Conversion_Date IS NULL)
2141: THEN
2142: OKC_API.set_message(OKL_API.G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN,
2143: 'Next Conversion Date');
2144: l_return_status := OKC_API.G_RET_STS_ERROR;
2145: IF (p_stack_messages = 'N') THEN
2146: RAISE violated_ref_integrity;
2151: /*IF (p_krpv_rec.parameter_type_code = 'ACTUAL') THEN
2152: IF (p_krpv_rec.Conversion_Type_Code = OKC_API.G_MISS_CHAR OR
2153: p_krpv_rec.Conversion_Type_Code IS NULL)
2154: THEN
2155: OKC_API.set_message(OKL_API.G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN,
2156: 'Conversion Type Code');
2157: l_return_status := OKC_API.G_RET_STS_ERROR;
2158: IF (p_stack_messages = 'N') THEN
2159: RAISE violated_ref_integrity;
2167: AND p_rev_rec_method = 'ESTIMATED_AND_BILLED') THEN
2168: IF (p_krpv_rec.Interest_Index_Id = OKC_API.G_MISS_NUM OR
2169: p_krpv_rec.Interest_Index_Id IS NULL)
2170: THEN
2171: OKC_API.set_message(OKL_API.G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN,
2172: 'Interest Index Id');
2173: l_return_status := OKC_API.G_RET_STS_ERROR;
2174: IF (p_stack_messages = 'N') THEN
2175: RAISE violated_ref_integrity;
2179: -- Bug 4907390
2180: /*IF (p_krpv_rec.Base_Rate = OKC_API.G_MISS_NUM OR
2181: p_krpv_rec.Base_Rate IS NULL)
2182: THEN
2183: OKC_API.set_message(OKL_API.G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN,
2184: 'Base Rate');
2185: l_return_status := OKC_API.G_RET_STS_ERROR;
2186: IF (p_stack_messages = 'N') THEN
2187: RAISE violated_ref_integrity;
2190:
2191: IF (p_krpv_rec.Interest_Start_Date = OKC_API.G_MISS_DATE OR
2192: p_krpv_rec.Interest_Start_Date IS NULL)
2193: THEN
2194: OKC_API.set_message(OKL_API.G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN,
2195: 'Interest Start Date');
2196: l_return_status := OKC_API.G_RET_STS_ERROR;
2197: IF (p_stack_messages = 'N') THEN
2198: RAISE violated_ref_integrity;
2201:
2202: IF (p_krpv_rec.Adder_Rate = OKC_API.G_MISS_NUM OR
2203: p_krpv_rec.Adder_Rate IS NULL)
2204: THEN
2205: OKC_API.set_message(OKL_API.G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN,
2206: 'Adder Rate');
2207: l_return_status := OKC_API.G_RET_STS_ERROR;
2208: IF (p_stack_messages = 'N') THEN
2209: RAISE violated_ref_integrity;
2212:
2213: IF (p_krpv_rec.Maximum_Rate = OKC_API.G_MISS_NUM OR
2214: p_krpv_rec.Maximum_Rate IS NULL)
2215: THEN
2216: OKC_API.set_message(OKL_API.G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN,
2217: 'Maximum Rate');
2218: l_return_status := OKC_API.G_RET_STS_ERROR;
2219: IF (p_stack_messages = 'N') THEN
2220: RAISE violated_ref_integrity;
2223:
2224: IF (p_krpv_rec.Minimum_Rate = OKC_API.G_MISS_NUM OR
2225: p_krpv_rec.Minimum_Rate IS NULL)
2226: THEN
2227: OKC_API.set_message(OKL_API.G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN,
2228: 'Minimum Rate');
2229: l_return_status := OKC_API.G_RET_STS_ERROR;
2230: IF (p_stack_messages = 'N') THEN
2231: RAISE violated_ref_integrity;
2234:
2235: IF (p_krpv_rec.Principal_Basis_Code = OKC_API.G_MISS_CHAR OR
2236: p_krpv_rec.Principal_Basis_Code IS NULL)
2237: THEN
2238: OKC_API.set_message(OKL_API.G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN,
2239: 'Principal Basis Code');
2240: l_return_status := OKC_API.G_RET_STS_ERROR;
2241: IF (p_stack_messages = 'N') THEN
2242: RAISE violated_ref_integrity;
2245:
2246: IF (p_krpv_rec.Days_In_A_Month_Code = OKC_API.G_MISS_CHAR OR
2247: p_krpv_rec.Days_In_A_Month_Code IS NULL)
2248: THEN
2249: OKC_API.set_message(OKL_API.G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN,
2250: 'Days In A Month Code');
2251: l_return_status := OKC_API.G_RET_STS_ERROR;
2252: IF (p_stack_messages = 'N') THEN
2253: RAISE violated_ref_integrity;
2256:
2257: IF (p_krpv_rec.Days_In_A_Year_Code = OKC_API.G_MISS_CHAR OR
2258: p_krpv_rec.Days_In_A_Year_Code IS NULL)
2259: THEN
2260: OKC_API.set_message(OKL_API.G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN,
2261: 'Days In A Year Code');
2262: l_return_status := OKC_API.G_RET_STS_ERROR;
2263: IF (p_stack_messages = 'N') THEN
2264: RAISE violated_ref_integrity;
2267:
2268: IF (p_krpv_rec.Interest_Basis_Code = OKC_API.G_MISS_CHAR OR
2269: p_krpv_rec.Interest_Basis_Code IS NULL)
2270: THEN
2271: OKC_API.set_message(OKL_API.G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN,
2272: 'Interest Basis Code');
2273: l_return_status := OKC_API.G_RET_STS_ERROR;
2274: IF (p_stack_messages = 'N') THEN
2275: RAISE violated_ref_integrity;
2280: /*
2281: IF (p_krpv_rec.Rate_Delay_Code = OKC_API.G_MISS_CHAR OR
2282: p_krpv_rec.Rate_Delay_Code IS NULL)
2283: THEN
2284: OKC_API.set_message(OKL_API.G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN,
2285: 'Rate Delay Code');
2286: l_return_status := OKC_API.G_RET_STS_ERROR;
2287: IF (p_stack_messages = 'N') THEN
2288: RAISE violated_ref_integrity;
2291:
2292: IF (p_krpv_rec.Rate_Delay_Frequency = OKC_API.G_MISS_NUM OR
2293: p_krpv_rec.Rate_Delay_Frequency IS NULL)
2294: THEN
2295: OKC_API.set_message(OKL_API.G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN,
2296: 'Rate Delay Frequency');
2297: l_return_status := OKC_API.G_RET_STS_ERROR;
2298: IF (p_stack_messages = 'N') THEN
2299: RAISE violated_ref_integrity;
2305: /*IF (p_krpv_rec.Compounding_Frequency_Code = OKC_API.G_MISS_CHAR OR
2306: p_krpv_rec.Compounding_Frequency_Code IS NULL)
2307: THEN
2308: l_msg1_set := TRUE;
2309: OKC_API.set_message(OKL_API.G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN,
2310: 'Compounding Frequency CODE');
2311: l_return_status := OKC_API.G_RET_STS_ERROR;
2312: IF (p_stack_messages = 'N') THEN
2313: RAISE violated_ref_integrity;
2317: IF (p_krpv_rec.Calculation_Formula_Id = OKC_API.G_MISS_NUM OR
2318: p_krpv_rec.Calculation_Formula_Id IS NULL)
2319: THEN
2320: l_msg2_set := TRUE;
2321: OKC_API.set_message(OKL_API.G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN,
2322: 'Formula Name');
2323: l_return_status := OKC_API.G_RET_STS_ERROR;
2324: IF (p_stack_messages = 'N') THEN
2325: RAISE violated_ref_integrity;
2330: /*
2331: IF (p_krpv_rec.Rate_Change_Start_Date = OKC_API.G_MISS_DATE OR
2332: p_krpv_rec.Rate_Change_Start_Date IS NULL)
2333: THEN
2334: OKC_API.set_message(OKL_API.G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN,
2335: 'Rate Change Start Date');
2336: l_return_status := OKC_API.G_RET_STS_ERROR;
2337: IF (p_stack_messages = 'N') THEN
2338: RAISE violated_ref_integrity;
2341:
2342: IF (p_krpv_rec.Rate_Change_Frequency_Code = OKC_API.G_MISS_CHAR OR
2343: p_krpv_rec.Rate_Change_Frequency_Code IS NULL)
2344: THEN
2345: OKC_API.set_message(OKL_API.G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN,
2346: 'Rate Change Frequency Code');
2347: l_return_status := OKC_API.G_RET_STS_ERROR;
2348: IF (p_stack_messages = 'N') THEN
2349: RAISE violated_ref_integrity;
2352:
2353: IF (p_krpv_rec.Rate_Change_Value = OKC_API.G_MISS_NUM OR
2354: p_krpv_rec.Rate_Change_Value IS NULL)
2355: THEN
2356: OKC_API.set_message(OKL_API.G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN,
2357: 'Rate Change Value');
2358: l_return_status := OKC_API.G_RET_STS_ERROR;
2359: IF (p_stack_messages = 'N') THEN
2360: RAISE violated_ref_integrity;
2365: /*IF (p_krpv_rec.parameter_type_code = 'ACTUAL') THEN
2366: IF (p_krpv_rec.Conversion_Option_Code = OKC_API.G_MISS_CHAR OR
2367: p_krpv_rec.Conversion_Option_Code IS NULL)
2368: THEN
2369: OKC_API.set_message(OKL_API.G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN,
2370: 'Conversion Option Code');
2371: l_return_status := OKC_API.G_RET_STS_ERROR;
2372: IF (p_stack_messages = 'N') THEN
2373: RAISE violated_ref_integrity;
2378: /*IF (p_krpv_rec.parameter_type_code = 'ACTUAL') THEN
2379: IF (p_krpv_rec.Next_Conversion_Date = OKC_API.G_MISS_DATE OR
2380: p_krpv_rec.Next_Conversion_Date IS NULL)
2381: THEN
2382: OKC_API.set_message(OKL_API.G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN,
2383: 'Next Conversion Date');
2384: l_return_status := OKC_API.G_RET_STS_ERROR;
2385: IF (p_stack_messages = 'N') THEN
2386: RAISE violated_ref_integrity;
2391: /*IF (p_krpv_rec.parameter_type_code = 'ACTUAL') THEN
2392: IF (p_krpv_rec.Conversion_Type_Code = OKC_API.G_MISS_CHAR OR
2393: p_krpv_rec.Conversion_Type_Code IS NULL)
2394: THEN
2395: OKC_API.set_message(OKL_API.G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN,
2396: 'Conversion Type Code');
2397: l_return_status := OKC_API.G_RET_STS_ERROR;
2398: IF (p_stack_messages = 'N') THEN
2399: RAISE violated_ref_integrity;
2405: AND p_rev_rec_method = 'ACTUAL') THEN
2406: IF (p_krpv_rec.Interest_Index_Id = OKC_API.G_MISS_NUM OR
2407: p_krpv_rec.Interest_Index_Id IS NULL)
2408: THEN
2409: OKC_API.set_message(OKL_API.G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN,
2410: 'Interest Index Id');
2411: l_return_status := OKC_API.G_RET_STS_ERROR;
2412: IF (p_stack_messages = 'N') THEN
2413: RAISE violated_ref_integrity;
2417: -- Bug 4907390
2418: /*IF (p_krpv_rec.Base_Rate = OKC_API.G_MISS_NUM OR
2419: p_krpv_rec.Base_Rate IS NULL)
2420: THEN
2421: OKC_API.set_message(OKL_API.G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN,
2422: 'Base Rate');
2423: l_return_status := OKC_API.G_RET_STS_ERROR;
2424: IF (p_stack_messages = 'N') THEN
2425: RAISE violated_ref_integrity;
2428:
2429: IF (p_krpv_rec.Interest_Start_Date = OKC_API.G_MISS_DATE OR
2430: p_krpv_rec.Interest_Start_Date IS NULL)
2431: THEN
2432: OKC_API.set_message(OKL_API.G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN,
2433: 'Interest Start Date');
2434: l_return_status := OKC_API.G_RET_STS_ERROR;
2435: IF (p_stack_messages = 'N') THEN
2436: RAISE violated_ref_integrity;
2439:
2440: IF (p_krpv_rec.Adder_Rate = OKC_API.G_MISS_NUM OR
2441: p_krpv_rec.Adder_Rate IS NULL)
2442: THEN
2443: OKC_API.set_message(OKL_API.G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN,
2444: 'Adder Rate');
2445: l_return_status := OKC_API.G_RET_STS_ERROR;
2446: IF (p_stack_messages = 'N') THEN
2447: RAISE violated_ref_integrity;
2450:
2451: IF (p_krpv_rec.Maximum_Rate = OKC_API.G_MISS_NUM OR
2452: p_krpv_rec.Maximum_Rate IS NULL)
2453: THEN
2454: OKC_API.set_message(OKL_API.G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN,
2455: 'Maximum Rate');
2456: l_return_status := OKC_API.G_RET_STS_ERROR;
2457: IF (p_stack_messages = 'N') THEN
2458: RAISE violated_ref_integrity;
2461:
2462: IF (p_krpv_rec.Minimum_Rate = OKC_API.G_MISS_NUM OR
2463: p_krpv_rec.Minimum_Rate IS NULL)
2464: THEN
2465: OKC_API.set_message(OKL_API.G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN,
2466: 'Minimum Rate');
2467: l_return_status := OKC_API.G_RET_STS_ERROR;
2468: IF (p_stack_messages = 'N') THEN
2469: RAISE violated_ref_integrity;
2472:
2473: IF (p_krpv_rec.Principal_Basis_Code = OKC_API.G_MISS_CHAR OR
2474: p_krpv_rec.Principal_Basis_Code IS NULL)
2475: THEN
2476: OKC_API.set_message(OKL_API.G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN,
2477: 'Principal Basis Code');
2478: l_return_status := OKC_API.G_RET_STS_ERROR;
2479: IF (p_stack_messages = 'N') THEN
2480: RAISE violated_ref_integrity;
2483: p_krpv_rec.Principal_Basis_Code IS NOT NULL) THEN
2484: IF (p_krpv_rec.Principal_Basis_Code <> 'ACTUAL') THEN
2485: -- AKP: Todo: Set Proper Message
2486: --(Principal Basis Code is 'ACTUAL' allowed only)
2487: OKL_API.SET_MESSAGE( p_app_name => OKL_API.G_APP_NAME
2488: ,p_msg_name => 'OKL_LA_APPLICABLE_VALUES'
2489: ,p_token1 => 'VALUE'
2490: ,p_token1_value => 'ACTUAL'
2491: ,p_token2 => 'CODE0'
2503:
2504: IF (p_krpv_rec.Days_In_A_Month_Code = OKC_API.G_MISS_CHAR OR
2505: p_krpv_rec.Days_In_A_Month_Code IS NULL)
2506: THEN
2507: OKC_API.set_message(OKL_API.G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN,
2508: 'Days In A Month Code');
2509: l_return_status := OKC_API.G_RET_STS_ERROR;
2510: IF (p_stack_messages = 'N') THEN
2511: RAISE violated_ref_integrity;
2514:
2515: IF (p_krpv_rec.Days_In_A_Year_Code = OKC_API.G_MISS_CHAR OR
2516: p_krpv_rec.Days_In_A_Year_Code IS NULL)
2517: THEN
2518: OKC_API.set_message(OKL_API.G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN,
2519: 'Days In A Year Code');
2520: l_return_status := OKC_API.G_RET_STS_ERROR;
2521: IF (p_stack_messages = 'N') THEN
2522: RAISE violated_ref_integrity;
2525:
2526: IF (p_krpv_rec.Interest_Basis_Code = OKC_API.G_MISS_CHAR OR
2527: p_krpv_rec.Interest_Basis_Code IS NULL)
2528: THEN
2529: OKC_API.set_message(OKL_API.G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN,
2530: 'Interest Basis Code');
2531: l_return_status := OKC_API.G_RET_STS_ERROR;
2532: IF (p_stack_messages = 'N') THEN
2533: RAISE violated_ref_integrity;
2538: /*
2539: IF (p_krpv_rec.Rate_Delay_Code = OKC_API.G_MISS_CHAR OR
2540: p_krpv_rec.Rate_Delay_Code IS NULL)
2541: THEN
2542: OKC_API.set_message(OKL_API.G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN,
2543: 'Rate Delay Code');
2544: l_return_status := OKC_API.G_RET_STS_ERROR;
2545: IF (p_stack_messages = 'N') THEN
2546: RAISE violated_ref_integrity;
2549:
2550: IF (p_krpv_rec.Rate_Delay_Frequency = OKC_API.G_MISS_NUM OR
2551: p_krpv_rec.Rate_Delay_Frequency IS NULL)
2552: THEN
2553: OKC_API.set_message(OKL_API.G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN,
2554: 'Rate Delay Frequency');
2555: l_return_status := OKC_API.G_RET_STS_ERROR;
2556: IF (p_stack_messages = 'N') THEN
2557: RAISE violated_ref_integrity;
2563: /*IF (p_krpv_rec.Compounding_Frequency_Code = OKC_API.G_MISS_CHAR OR
2564: p_krpv_rec.Compounding_Frequency_Code IS NULL)
2565: THEN
2566: l_msg1_set := TRUE;
2567: OKC_API.set_message(OKL_API.G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN,
2568: 'Compounding Frequency CODE');
2569: l_return_status := OKC_API.G_RET_STS_ERROR;
2570: IF (p_stack_messages = 'N') THEN
2571: RAISE violated_ref_integrity;
2575: IF (p_krpv_rec.Calculation_Formula_Id = OKC_API.G_MISS_NUM OR
2576: p_krpv_rec.Calculation_Formula_Id IS NULL)
2577: THEN
2578: l_msg2_set := TRUE;
2579: OKC_API.set_message(OKL_API.G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN,
2580: 'Formula Name');
2581: l_return_status := OKC_API.G_RET_STS_ERROR;
2582: IF (p_stack_messages = 'N') THEN
2583: RAISE violated_ref_integrity;
2588: /*
2589: IF (p_krpv_rec.Rate_Change_Start_Date = OKC_API.G_MISS_DATE OR
2590: p_krpv_rec.Rate_Change_Start_Date IS NULL)
2591: THEN
2592: OKC_API.set_message(OKL_API.G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN,
2593: 'Rate Change Start Date');
2594: l_return_status := OKC_API.G_RET_STS_ERROR;
2595: IF (p_stack_messages = 'N') THEN
2596: RAISE violated_ref_integrity;
2599:
2600: IF (p_krpv_rec.Rate_Change_Frequency_Code = OKC_API.G_MISS_CHAR OR
2601: p_krpv_rec.Rate_Change_Frequency_Code IS NULL)
2602: THEN
2603: OKC_API.set_message(OKL_API.G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN,
2604: 'Rate Change Frequency Code');
2605: l_return_status := OKC_API.G_RET_STS_ERROR;
2606: IF (p_stack_messages = 'N') THEN
2607: RAISE violated_ref_integrity;
2610:
2611: IF (p_krpv_rec.Rate_Change_Value = OKC_API.G_MISS_NUM OR
2612: p_krpv_rec.Rate_Change_Value IS NULL)
2613: THEN
2614: OKC_API.set_message(OKL_API.G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN,
2615: 'Rate Change Value');
2616: l_return_status := OKC_API.G_RET_STS_ERROR;
2617: IF (p_stack_messages = 'N') THEN
2618: RAISE violated_ref_integrity;
2623: /*IF (p_krpv_rec.parameter_type_code = 'ACTUAL') THEN
2624: IF (p_krpv_rec.Conversion_Option_Code = OKC_API.G_MISS_CHAR OR
2625: p_krpv_rec.Conversion_Option_Code IS NULL)
2626: THEN
2627: OKC_API.set_message(OKL_API.G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN,
2628: 'Conversion Option Code');
2629: l_return_status := OKC_API.G_RET_STS_ERROR;
2630: IF (p_stack_messages = 'N') THEN
2631: RAISE violated_ref_integrity;
2636: /*IF (p_krpv_rec.parameter_type_code = 'ACTUAL') THEN
2637: IF (p_krpv_rec.Next_Conversion_Date = OKC_API.G_MISS_DATE OR
2638: p_krpv_rec.Next_Conversion_Date IS NULL)
2639: THEN
2640: OKC_API.set_message(OKL_API.G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN,
2641: 'Next Conversion Date');
2642: l_return_status := OKC_API.G_RET_STS_ERROR;
2643: IF (p_stack_messages = 'N') THEN
2644: RAISE violated_ref_integrity;
2649: /*IF (p_krpv_rec.parameter_type_code = 'ACTUAL') THEN
2650: IF (p_krpv_rec.Conversion_Type_Code = OKC_API.G_MISS_CHAR OR
2651: p_krpv_rec.Conversion_Type_Code IS NULL)
2652: THEN
2653: OKC_API.set_message(OKL_API.G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN,
2654: 'Conversion Type Code');
2655: l_return_status := OKC_API.G_RET_STS_ERROR;
2656: IF (p_stack_messages = 'N') THEN
2657: RAISE violated_ref_integrity;
2663: AND p_rev_rec_method = 'STREAMS') THEN
2664: IF (p_krpv_rec.Interest_Index_Id = OKC_API.G_MISS_NUM OR
2665: p_krpv_rec.Interest_Index_Id IS NULL)
2666: THEN
2667: OKC_API.set_message(OKL_API.G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN,
2668: 'Interest Index Id');
2669: l_return_status := OKC_API.G_RET_STS_ERROR;
2670: IF (p_stack_messages = 'N') THEN
2671: RAISE violated_ref_integrity;
2675: -- Bug 4907390
2676: /*IF (p_krpv_rec.Base_Rate = OKC_API.G_MISS_NUM OR
2677: p_krpv_rec.Base_Rate IS NULL)
2678: THEN
2679: OKC_API.set_message(OKL_API.G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN,
2680: 'Base Rate');
2681: l_return_status := OKC_API.G_RET_STS_ERROR;
2682: IF (p_stack_messages = 'N') THEN
2683: RAISE violated_ref_integrity;
2686:
2687: IF (p_krpv_rec.Interest_Start_Date = OKC_API.G_MISS_DATE OR
2688: p_krpv_rec.Interest_Start_Date IS NULL)
2689: THEN
2690: OKC_API.set_message(OKL_API.G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN,
2691: 'Interest Start Date');
2692: l_return_status := OKC_API.G_RET_STS_ERROR;
2693: IF (p_stack_messages = 'N') THEN
2694: RAISE violated_ref_integrity;
2700: LOOP
2701:
2702: IF ( TRUNC(p_krpv_rec.Interest_Start_Date) <> TRUNC(r1.start_date) )
2703: THEN
2704: OKL_API.SET_MESSAGE( p_app_name => OKL_API.G_APP_NAME
2705: ,p_msg_name => 'OKL_LA_INT_START_DT_REAMORT');
2706: l_return_status := OKC_API.G_RET_STS_ERROR;
2707: IF (p_stack_messages = 'N') THEN
2708: RAISE violated_ref_integrity;
2715:
2716: IF (p_krpv_rec.Adder_Rate = OKC_API.G_MISS_NUM OR
2717: p_krpv_rec.Adder_Rate IS NULL)
2718: THEN
2719: OKC_API.set_message(OKL_API.G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN,
2720: 'Adder Rate');
2721: l_return_status := OKC_API.G_RET_STS_ERROR;
2722: IF (p_stack_messages = 'N') THEN
2723: RAISE violated_ref_integrity;
2726:
2727: IF (p_krpv_rec.Maximum_Rate = OKC_API.G_MISS_NUM OR
2728: p_krpv_rec.Maximum_Rate IS NULL)
2729: THEN
2730: OKC_API.set_message(OKL_API.G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN,
2731: 'Maximum Rate');
2732: l_return_status := OKC_API.G_RET_STS_ERROR;
2733: IF (p_stack_messages = 'N') THEN
2734: RAISE violated_ref_integrity;
2737:
2738: IF (p_krpv_rec.Minimum_Rate = OKC_API.G_MISS_NUM OR
2739: p_krpv_rec.Minimum_Rate IS NULL)
2740: THEN
2741: OKC_API.set_message(OKL_API.G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN,
2742: 'Minimum Rate');
2743: l_return_status := OKC_API.G_RET_STS_ERROR;
2744: IF (p_stack_messages = 'N') THEN
2745: RAISE violated_ref_integrity;
2748:
2749: IF (p_krpv_rec.Principal_Basis_Code = OKC_API.G_MISS_CHAR OR
2750: p_krpv_rec.Principal_Basis_Code IS NULL)
2751: THEN
2752: OKC_API.set_message(OKL_API.G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN,
2753: 'Principal Basis Code');
2754: l_return_status := OKC_API.G_RET_STS_ERROR;
2755: IF (p_stack_messages = 'N') THEN
2756: RAISE violated_ref_integrity;
2759: p_krpv_rec.Principal_Basis_Code IS NOT NULL) THEN
2760: IF (p_krpv_rec.Principal_Basis_Code <> 'SCHEDULED') THEN
2761: -- AKP: Todo: Set Proper Message
2762: --(Principal Basis Code is 'SCHEDULED' allowed only)
2763: OKL_API.SET_MESSAGE( p_app_name => OKL_API.G_APP_NAME
2764: ,p_msg_name => 'OKL_LA_APPLICABLE_VALUES'
2765: ,p_token1 => 'VALUE'
2766: ,p_token1_value => 'SCHEDULED'
2767: ,p_token2 => 'CODE0'
2779:
2780: IF (p_krpv_rec.Days_In_A_Month_Code = OKC_API.G_MISS_CHAR OR
2781: p_krpv_rec.Days_In_A_Month_Code IS NULL)
2782: THEN
2783: OKC_API.set_message(OKL_API.G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN,
2784: 'Days In A Month Code');
2785: l_return_status := OKC_API.G_RET_STS_ERROR;
2786: IF (p_stack_messages = 'N') THEN
2787: RAISE violated_ref_integrity;
2790: p_krpv_rec.Days_In_A_Month_Code IS NOT NULL) THEN
2791: IF (p_krpv_rec.Days_In_A_Month_Code <> '30') THEN
2792: -- AKP: Todo: Set Proper Message
2793: --(Days In A Month Code is '30' allowed only)
2794: OKL_API.SET_MESSAGE( p_app_name => OKL_API.G_APP_NAME
2795: ,p_msg_name => 'OKL_LA_APPLICABLE_VALUES'
2796: ,p_token1 => 'VALUE'
2797: ,p_token1_value => '30'
2798: ,p_token2 => 'CODE0'
2810:
2811: IF (p_krpv_rec.Days_In_A_Year_Code = OKC_API.G_MISS_CHAR OR
2812: p_krpv_rec.Days_In_A_Year_Code IS NULL)
2813: THEN
2814: OKC_API.set_message(OKL_API.G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN,
2815: 'Days In A Year Code');
2816: l_return_status := OKC_API.G_RET_STS_ERROR;
2817: IF (p_stack_messages = 'N') THEN
2818: RAISE violated_ref_integrity;
2821: p_krpv_rec.Days_In_A_Year_Code IS NOT NULL) THEN
2822: IF (p_krpv_rec.Days_In_A_Year_Code <> '360') THEN
2823: -- AKP: Todo: Set Proper Message
2824: --(Days In A Year Code is '360' allowed only)
2825: OKL_API.SET_MESSAGE( p_app_name => OKL_API.G_APP_NAME
2826: ,p_msg_name => 'OKL_LA_APPLICABLE_VALUES'
2827: ,p_token1 => 'VALUE'
2828: ,p_token1_value => '360'
2829: ,p_token2 => 'CODE0'
2841:
2842: IF (p_krpv_rec.Interest_Basis_Code = OKC_API.G_MISS_CHAR OR
2843: p_krpv_rec.Interest_Basis_Code IS NULL)
2844: THEN
2845: OKC_API.set_message(OKL_API.G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN,
2846: 'Interest Basis Code');
2847: l_return_status := OKC_API.G_RET_STS_ERROR;
2848: IF (p_stack_messages = 'N') THEN
2849: RAISE violated_ref_integrity;
2852: p_krpv_rec.Interest_Basis_Code IS NOT NULL) THEN
2853: IF (p_krpv_rec.Interest_Basis_Code <> 'SIMPLE') THEN
2854: -- AKP: Todo: Set Proper Message
2855: --(Interest Basis Code is 'SIMPLE' allowed only)
2856: OKL_API.SET_MESSAGE( p_app_name => OKL_API.G_APP_NAME
2857: ,p_msg_name => 'OKL_LA_APPLICABLE_VALUES'
2858: ,p_token1 => 'VALUE'
2859: ,p_token1_value => 'SIMPLE'
2860: ,p_token2 => 'CODE0'
2874: /*
2875: IF (p_krpv_rec.Rate_Delay_Code = OKC_API.G_MISS_CHAR OR
2876: p_krpv_rec.Rate_Delay_Code IS NULL)
2877: THEN
2878: OKC_API.set_message(OKL_API.G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN,
2879: 'Rate Delay Code');
2880: l_return_status := OKC_API.G_RET_STS_ERROR;
2881: IF (p_stack_messages = 'N') THEN
2882: RAISE violated_ref_integrity;
2885:
2886: IF (p_krpv_rec.Rate_Delay_Frequency = OKC_API.G_MISS_NUM OR
2887: p_krpv_rec.Rate_Delay_Frequency IS NULL)
2888: THEN
2889: OKC_API.set_message(OKL_API.G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN,
2890: 'Rate Delay Frequency');
2891: l_return_status := OKC_API.G_RET_STS_ERROR;
2892: IF (p_stack_messages = 'N') THEN
2893: RAISE violated_ref_integrity;
2896:
2897: IF (p_krpv_rec.Rate_Change_Start_Date = OKC_API.G_MISS_DATE OR
2898: p_krpv_rec.Rate_Change_Start_Date IS NULL)
2899: THEN
2900: OKC_API.set_message(OKL_API.G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN,
2901: 'Rate Change Start Date');
2902: l_return_status := OKC_API.G_RET_STS_ERROR;
2903: IF (p_stack_messages = 'N') THEN
2904: RAISE violated_ref_integrity;
2910: p_krpv_rec.Rate_Change_Frequency_Code IS NULL)
2911: THEN
2912: -- Bug 4862551
2913: NULL;
2914: /*OKC_API.set_message(OKL_API.G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN,
2915: 'Rate Change Frequency Code');
2916: l_return_status := OKC_API.G_RET_STS_ERROR;
2917: IF (p_stack_messages = 'N') THEN
2918: RAISE violated_ref_integrity;
2921: p_krpv_rec.Rate_Change_Frequency_Code IS NOT NULL) THEN
2922: IF (p_krpv_rec.Rate_Change_Frequency_Code <> 'BILLING_DATE') THEN
2923: -- AKP: Todo: Set Proper Message
2924: --(Rate Change Frequency Code is 'BILLING_DATE' allowed only)
2925: OKL_API.SET_MESSAGE( p_app_name => OKL_API.G_APP_NAME
2926: ,p_msg_name => 'OKL_LA_APPLICABLE_VALUES'
2927: ,p_token1 => 'VALUE'
2928: ,p_token1_value => 'BILLING_DATE'
2929: ,p_token2 => 'CODE0'
2943: /*
2944: IF (p_krpv_rec.Rate_Change_Value = OKC_API.G_MISS_NUM OR
2945: p_krpv_rec.Rate_Change_Value IS NULL)
2946: THEN
2947: OKC_API.set_message(OKL_API.G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN,
2948: 'Rate Change Value');
2949: l_return_status := OKC_API.G_RET_STS_ERROR;
2950: IF (p_stack_messages = 'N') THEN
2951: RAISE violated_ref_integrity;
2956: /*IF (p_krpv_rec.parameter_type_code = 'ACTUAL') THEN
2957: IF (p_krpv_rec.Conversion_Option_Code = OKC_API.G_MISS_CHAR OR
2958: p_krpv_rec.Conversion_Option_Code IS NULL)
2959: THEN
2960: OKC_API.set_message(OKL_API.G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN,
2961: 'Conversion Option Code');
2962: l_return_status := OKC_API.G_RET_STS_ERROR;
2963: IF (p_stack_messages = 'N') THEN
2964: RAISE violated_ref_integrity;
2969: /*IF (p_krpv_rec.parameter_type_code = 'ACTUAL') THEN
2970: IF (p_krpv_rec.Next_Conversion_Date = OKC_API.G_MISS_DATE OR
2971: p_krpv_rec.Next_Conversion_Date IS NULL)
2972: THEN
2973: OKC_API.set_message(OKL_API.G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN,
2974: 'Next Conversion Date');
2975: l_return_status := OKC_API.G_RET_STS_ERROR;
2976: IF (p_stack_messages = 'N') THEN
2977: RAISE violated_ref_integrity;
2982: /*IF (p_krpv_rec.parameter_type_code = 'ACTUAL') THEN
2983: IF (p_krpv_rec.Conversion_Type_Code = OKC_API.G_MISS_CHAR OR
2984: p_krpv_rec.Conversion_Type_Code IS NULL)
2985: THEN
2986: OKC_API.set_message(OKL_API.G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN,
2987: 'Conversion Type Code');
2988: l_return_status := OKC_API.G_RET_STS_ERROR;
2989: IF (p_stack_messages = 'N') THEN
2990: RAISE violated_ref_integrity;
2996: AND p_rev_rec_method = 'ACTUAL') THEN
2997: IF (p_krpv_rec.Interest_Index_Id = OKC_API.G_MISS_NUM OR
2998: p_krpv_rec.Interest_Index_Id IS NULL)
2999: THEN
3000: OKC_API.set_message(OKL_API.G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN,
3001: 'Interest Index Id');
3002: l_return_status := OKC_API.G_RET_STS_ERROR;
3003: IF (p_stack_messages = 'N') THEN
3004: RAISE violated_ref_integrity;
3008: -- Bug 4907390
3009: /*IF (p_krpv_rec.Base_Rate = OKC_API.G_MISS_NUM OR
3010: p_krpv_rec.Base_Rate IS NULL)
3011: THEN
3012: OKC_API.set_message(OKL_API.G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN,
3013: 'Base Rate');
3014: l_return_status := OKC_API.G_RET_STS_ERROR;
3015: IF (p_stack_messages = 'N') THEN
3016: RAISE violated_ref_integrity;
3019:
3020: IF (p_krpv_rec.Interest_Start_Date = OKC_API.G_MISS_DATE OR
3021: p_krpv_rec.Interest_Start_Date IS NULL)
3022: THEN
3023: OKC_API.set_message(OKL_API.G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN,
3024: 'Interest Start Date');
3025: l_return_status := OKC_API.G_RET_STS_ERROR;
3026: IF (p_stack_messages = 'N') THEN
3027: RAISE violated_ref_integrity;
3030:
3031: IF (p_krpv_rec.Adder_Rate = OKC_API.G_MISS_NUM OR
3032: p_krpv_rec.Adder_Rate IS NULL)
3033: THEN
3034: OKC_API.set_message(OKL_API.G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN,
3035: 'Adder Rate');
3036: l_return_status := OKC_API.G_RET_STS_ERROR;
3037: IF (p_stack_messages = 'N') THEN
3038: RAISE violated_ref_integrity;
3041:
3042: IF (p_krpv_rec.Maximum_Rate = OKC_API.G_MISS_NUM OR
3043: p_krpv_rec.Maximum_Rate IS NULL)
3044: THEN
3045: OKC_API.set_message(OKL_API.G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN,
3046: 'Maximum Rate');
3047: l_return_status := OKC_API.G_RET_STS_ERROR;
3048: IF (p_stack_messages = 'N') THEN
3049: RAISE violated_ref_integrity;
3052:
3053: IF (p_krpv_rec.Minimum_Rate = OKC_API.G_MISS_NUM OR
3054: p_krpv_rec.Minimum_Rate IS NULL)
3055: THEN
3056: OKC_API.set_message(OKL_API.G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN,
3057: 'Minimum Rate');
3058: l_return_status := OKC_API.G_RET_STS_ERROR;
3059: IF (p_stack_messages = 'N') THEN
3060: RAISE violated_ref_integrity;
3063:
3064: IF (p_krpv_rec.Principal_Basis_Code = OKC_API.G_MISS_CHAR OR
3065: p_krpv_rec.Principal_Basis_Code IS NULL)
3066: THEN
3067: OKC_API.set_message(OKL_API.G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN,
3068: 'Principal Basis Code');
3069: l_return_status := OKC_API.G_RET_STS_ERROR;
3070: IF (p_stack_messages = 'N') THEN
3071: RAISE violated_ref_integrity;
3075: IF (p_krpv_rec.Principal_Basis_Code <> 'SCHEDULED') THEN -- 4896751
3076: --IF (p_krpv_rec.Principal_Basis_Code <> 'ACTUAL') THEN -- 4753087
3077: -- AKP: Todo: Set Proper Message
3078: --(Principal Basis Code is 'ACTUAL' allowed only) -- 4753087
3079: OKL_API.SET_MESSAGE( p_app_name => OKL_API.G_APP_NAME
3080: ,p_msg_name => 'OKL_LA_APPLICABLE_VALUES'
3081: ,p_token1 => 'VALUE'
3082: --,p_token1_value => 'ACTUAL' -- 4753087
3083: ,p_token1_value => 'SCHEDULED' -- 4896751
3096:
3097: IF (p_krpv_rec.Days_In_A_Month_Code = OKC_API.G_MISS_CHAR OR
3098: p_krpv_rec.Days_In_A_Month_Code IS NULL)
3099: THEN
3100: OKC_API.set_message(OKL_API.G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN,
3101: 'Days In A Month Code');
3102: l_return_status := OKC_API.G_RET_STS_ERROR;
3103: IF (p_stack_messages = 'N') THEN
3104: RAISE violated_ref_integrity;
3107:
3108: IF (p_krpv_rec.Days_In_A_Year_Code = OKC_API.G_MISS_CHAR OR
3109: p_krpv_rec.Days_In_A_Year_Code IS NULL)
3110: THEN
3111: OKC_API.set_message(OKL_API.G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN,
3112: 'Days In A Year Code');
3113: l_return_status := OKC_API.G_RET_STS_ERROR;
3114: IF (p_stack_messages = 'N') THEN
3115: RAISE violated_ref_integrity;
3118:
3119: IF (p_krpv_rec.Interest_Basis_Code = OKC_API.G_MISS_CHAR OR
3120: p_krpv_rec.Interest_Basis_Code IS NULL)
3121: THEN
3122: OKC_API.set_message(OKL_API.G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN,
3123: 'Interest Basis Code');
3124: l_return_status := OKC_API.G_RET_STS_ERROR;
3125: IF (p_stack_messages = 'N') THEN
3126: RAISE violated_ref_integrity;
3131: /*
3132: IF (p_krpv_rec.Rate_Delay_Code = OKC_API.G_MISS_CHAR OR
3133: p_krpv_rec.Rate_Delay_Code IS NULL)
3134: THEN
3135: OKC_API.set_message(OKL_API.G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN,
3136: 'Rate Delay Code');
3137: l_return_status := OKC_API.G_RET_STS_ERROR;
3138: IF (p_stack_messages = 'N') THEN
3139: RAISE violated_ref_integrity;
3142:
3143: IF (p_krpv_rec.Rate_Delay_Frequency = OKC_API.G_MISS_NUM OR
3144: p_krpv_rec.Rate_Delay_Frequency IS NULL)
3145: THEN
3146: OKC_API.set_message(OKL_API.G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN,
3147: 'Rate Delay Frequency');
3148: l_return_status := OKC_API.G_RET_STS_ERROR;
3149: IF (p_stack_messages = 'N') THEN
3150: RAISE violated_ref_integrity;
3156: /*IF (p_krpv_rec.Compounding_Frequency_Code = OKC_API.G_MISS_CHAR OR
3157: p_krpv_rec.Compounding_Frequency_Code IS NULL)
3158: THEN
3159: l_msg1_set := TRUE;
3160: OKC_API.set_message(OKL_API.G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN,
3161: 'Compounding Frequency Code');
3162: l_return_status := OKC_API.G_RET_STS_ERROR;
3163: IF (p_stack_messages = 'N') THEN
3164: RAISE violated_ref_integrity;
3168: IF (p_krpv_rec.Calculation_Formula_Id = OKC_API.G_MISS_NUM OR
3169: p_krpv_rec.Calculation_Formula_Id IS NULL)
3170: THEN
3171: l_msg2_set := TRUE;
3172: OKC_API.set_message(OKL_API.G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN,
3173: 'Formula Name');
3174: l_return_status := OKC_API.G_RET_STS_ERROR;
3175: IF (p_stack_messages = 'N') THEN
3176: RAISE violated_ref_integrity;
3180: /*
3181: IF (p_krpv_rec.Rate_Change_Start_Date = OKC_API.G_MISS_DATE OR
3182: p_krpv_rec.Rate_Change_Start_Date IS NULL)
3183: THEN
3184: OKC_API.set_message(OKL_API.G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN,
3185: 'Rate Change Start Date');
3186: l_return_status := OKC_API.G_RET_STS_ERROR;
3187: IF (p_stack_messages = 'N') THEN
3188: RAISE violated_ref_integrity;
3191:
3192: IF (p_krpv_rec.Rate_Change_Frequency_Code = OKC_API.G_MISS_CHAR OR
3193: p_krpv_rec.Rate_Change_Frequency_Code IS NULL)
3194: THEN
3195: OKC_API.set_message(OKL_API.G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN,
3196: 'Rate Change Frequency Code');
3197: l_return_status := OKC_API.G_RET_STS_ERROR;
3198: IF (p_stack_messages = 'N') THEN
3199: RAISE violated_ref_integrity;
3202:
3203: IF (p_krpv_rec.Rate_Change_Value = OKC_API.G_MISS_NUM OR
3204: p_krpv_rec.Rate_Change_Value IS NULL)
3205: THEN
3206: OKC_API.set_message(OKL_API.G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN,
3207: 'Rate Change Value');
3208: l_return_status := OKC_API.G_RET_STS_ERROR;
3209: IF (p_stack_messages = 'N') THEN
3210: RAISE violated_ref_integrity;
3215: /*IF (p_krpv_rec.parameter_type_code = 'ACTUAL') THEN
3216: IF (p_krpv_rec.Conversion_Option_Code = OKC_API.G_MISS_CHAR OR
3217: p_krpv_rec.Conversion_Option_Code IS NULL)
3218: THEN
3219: OKC_API.set_message(OKL_API.G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN,
3220: 'Conversion Option Code');
3221: l_return_status := OKC_API.G_RET_STS_ERROR;
3222: IF (p_stack_messages = 'N') THEN
3223: RAISE violated_ref_integrity;
3228: /*IF (p_krpv_rec.parameter_type_code = 'ACTUAL') THEN
3229: IF (p_krpv_rec.Next_Conversion_Date = OKC_API.G_MISS_DATE OR
3230: p_krpv_rec.Next_Conversion_Date IS NULL)
3231: THEN
3232: OKC_API.set_message(OKL_API.G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN,
3233: 'Next Conversion Date');
3234: l_return_status := OKC_API.G_RET_STS_ERROR;
3235: IF (p_stack_messages = 'N') THEN
3236: RAISE violated_ref_integrity;
3241: /*IF (p_krpv_rec.parameter_type_code = 'ACTUAL') THEN
3242: IF (p_krpv_rec.Conversion_Type_Code = OKC_API.G_MISS_CHAR OR
3243: p_krpv_rec.Conversion_Type_Code IS NULL)
3244: THEN
3245: OKC_API.set_message(OKL_API.G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN,
3246: 'Conversion Type Code');
3247: l_return_status := OKC_API.G_RET_STS_ERROR;
3248: IF (p_stack_messages = 'N') THEN
3249: RAISE violated_ref_integrity;
3255: AND p_rev_rec_method = 'STREAMS') THEN
3256: IF (p_krpv_rec.Interest_Index_Id = OKC_API.G_MISS_NUM OR
3257: p_krpv_rec.Interest_Index_Id IS NULL)
3258: THEN
3259: OKC_API.set_message(OKL_API.G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN,
3260: 'Interest Index Id');
3261: l_return_status := OKC_API.G_RET_STS_ERROR;
3262: IF (p_stack_messages = 'N') THEN
3263: RAISE violated_ref_integrity;
3267: -- Bug 4907390
3268: /*IF (p_krpv_rec.Base_Rate = OKC_API.G_MISS_NUM OR
3269: p_krpv_rec.Base_Rate IS NULL)
3270: THEN
3271: OKC_API.set_message(OKL_API.G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN,
3272: 'Base Rate');
3273: l_return_status := OKC_API.G_RET_STS_ERROR;
3274: IF (p_stack_messages = 'N') THEN
3275: RAISE violated_ref_integrity;
3278:
3279: IF (p_krpv_rec.Interest_Start_Date = OKC_API.G_MISS_DATE OR
3280: p_krpv_rec.Interest_Start_Date IS NULL)
3281: THEN
3282: OKC_API.set_message(OKL_API.G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN,
3283: 'Interest Start Date');
3284: l_return_status := OKC_API.G_RET_STS_ERROR;
3285: IF (p_stack_messages = 'N') THEN
3286: RAISE violated_ref_integrity;
3289:
3290: IF (p_krpv_rec.Adder_Rate = OKC_API.G_MISS_NUM OR
3291: p_krpv_rec.Adder_Rate IS NULL)
3292: THEN
3293: OKC_API.set_message(OKL_API.G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN,
3294: 'Adder Rate');
3295: l_return_status := OKC_API.G_RET_STS_ERROR;
3296: IF (p_stack_messages = 'N') THEN
3297: RAISE violated_ref_integrity;
3300:
3301: IF (p_krpv_rec.Maximum_Rate = OKC_API.G_MISS_NUM OR
3302: p_krpv_rec.Maximum_Rate IS NULL)
3303: THEN
3304: OKC_API.set_message(OKL_API.G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN,
3305: 'Maximum Rate');
3306: l_return_status := OKC_API.G_RET_STS_ERROR;
3307: IF (p_stack_messages = 'N') THEN
3308: RAISE violated_ref_integrity;
3311:
3312: IF (p_krpv_rec.Minimum_Rate = OKC_API.G_MISS_NUM OR
3313: p_krpv_rec.Minimum_Rate IS NULL)
3314: THEN
3315: OKC_API.set_message(OKL_API.G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN,
3316: 'Minimum Rate');
3317: l_return_status := OKC_API.G_RET_STS_ERROR;
3318: IF (p_stack_messages = 'N') THEN
3319: RAISE violated_ref_integrity;
3322:
3323: IF (p_krpv_rec.Principal_Basis_Code = OKC_API.G_MISS_CHAR OR
3324: p_krpv_rec.Principal_Basis_Code IS NULL)
3325: THEN
3326: OKC_API.set_message(OKL_API.G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN,
3327: 'Principal Basis Code');
3328: l_return_status := OKC_API.G_RET_STS_ERROR;
3329: IF (p_stack_messages = 'N') THEN
3330: RAISE violated_ref_integrity;
3333: p_krpv_rec.Principal_Basis_Code IS NOT NULL) THEN
3334: IF (p_krpv_rec.Principal_Basis_Code <> 'ACTUAL') THEN
3335: -- AKP: Todo: Set Proper Message
3336: --(Principal Basis Code is 'ACTUAL' allowed only)
3337: OKL_API.SET_MESSAGE( p_app_name => OKL_API.G_APP_NAME
3338: ,p_msg_name => 'OKL_LA_APPLICABLE_VALUES'
3339: ,p_token1 => 'VALUE'
3340: ,p_token1_value => 'ACTUAL'
3341: ,p_token2 => 'CODE0'
3353:
3354: IF (p_krpv_rec.Days_In_A_Month_Code = OKC_API.G_MISS_CHAR OR
3355: p_krpv_rec.Days_In_A_Month_Code IS NULL)
3356: THEN
3357: OKC_API.set_message(OKL_API.G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN,
3358: 'Days In A Month Code');
3359: l_return_status := OKC_API.G_RET_STS_ERROR;
3360: IF (p_stack_messages = 'N') THEN
3361: RAISE violated_ref_integrity;
3364:
3365: IF (p_krpv_rec.Days_In_A_Year_Code = OKC_API.G_MISS_CHAR OR
3366: p_krpv_rec.Days_In_A_Year_Code IS NULL)
3367: THEN
3368: OKC_API.set_message(OKL_API.G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN,
3369: 'Days In A Year Code');
3370: l_return_status := OKC_API.G_RET_STS_ERROR;
3371: IF (p_stack_messages = 'N') THEN
3372: RAISE violated_ref_integrity;
3375:
3376: IF (p_krpv_rec.Interest_Basis_Code = OKC_API.G_MISS_CHAR OR
3377: p_krpv_rec.Interest_Basis_Code IS NULL)
3378: THEN
3379: OKC_API.set_message(OKL_API.G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN,
3380: 'Interest Basis Code');
3381: l_return_status := OKC_API.G_RET_STS_ERROR;
3382: IF (p_stack_messages = 'N') THEN
3383: RAISE violated_ref_integrity;
3388: /*
3389: IF (p_krpv_rec.Rate_Delay_Code = OKC_API.G_MISS_CHAR OR
3390: p_krpv_rec.Rate_Delay_Code IS NULL)
3391: THEN
3392: OKC_API.set_message(OKL_API.G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN,
3393: 'Rate Delay Code');
3394: l_return_status := OKC_API.G_RET_STS_ERROR;
3395: IF (p_stack_messages = 'N') THEN
3396: RAISE violated_ref_integrity;
3399:
3400: IF (p_krpv_rec.Rate_Delay_Frequency = OKC_API.G_MISS_NUM OR
3401: p_krpv_rec.Rate_Delay_Frequency IS NULL)
3402: THEN
3403: OKC_API.set_message(OKL_API.G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN,
3404: 'Rate Delay Frequency');
3405: l_return_status := OKC_API.G_RET_STS_ERROR;
3406: IF (p_stack_messages = 'N') THEN
3407: RAISE violated_ref_integrity;
3413: /*IF (p_krpv_rec.Compounding_Frequency_Code = OKC_API.G_MISS_CHAR OR
3414: p_krpv_rec.Compounding_Frequency_Code IS NULL)
3415: THEN
3416: l_msg1_set := TRUE;
3417: OKC_API.set_message(OKL_API.G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN,
3418: 'Compounding Frequency Code');
3419: l_return_status := OKC_API.G_RET_STS_ERROR;
3420: IF (p_stack_messages = 'N') THEN
3421: RAISE violated_ref_integrity;
3425: IF (p_krpv_rec.Calculation_Formula_Id = OKC_API.G_MISS_NUM OR
3426: p_krpv_rec.Calculation_Formula_Id IS NULL)
3427: THEN
3428: l_msg2_set := TRUE;
3429: OKC_API.set_message(OKL_API.G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN,
3430: 'Formula Name');
3431: l_return_status := OKC_API.G_RET_STS_ERROR;
3432: IF (p_stack_messages = 'N') THEN
3433: RAISE violated_ref_integrity;
3436:
3437: IF (p_krpv_rec.Catchup_Basis_Code = OKC_API.G_MISS_CHAR OR
3438: p_krpv_rec.Catchup_Basis_Code IS NULL)
3439: THEN
3440: OKC_API.set_message(OKL_API.G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN,
3441: 'Catchup Basis Code');
3442: l_return_status := OKC_API.G_RET_STS_ERROR;
3443: IF (p_stack_messages = 'N') THEN
3444: RAISE violated_ref_integrity;
3447: p_krpv_rec.Catchup_Basis_Code IS NOT NULL) THEN
3448: IF (p_krpv_rec.Catchup_Basis_Code <> 'ACTUAL') THEN
3449: -- AKP: Todo: Set Proper Message
3450: --(Catchup Basis Code is 'ACTUAL' allowed only)
3451: OKL_API.SET_MESSAGE( p_app_name => OKL_API.G_APP_NAME
3452: ,p_msg_name => 'OKL_LA_APPLICABLE_VALUES'
3453: ,p_token1 => 'VALUE'
3454: ,p_token1_value => 'ACTUAL'
3455: ,p_token2 => 'CODE0'
3467:
3468: IF (p_krpv_rec.Catchup_Start_Date = OKC_API.G_MISS_DATE OR
3469: p_krpv_rec.Catchup_Start_Date IS NULL)
3470: THEN
3471: OKC_API.set_message(OKL_API.G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN,
3472: 'Catchup Start Date');
3473: l_return_status := OKC_API.G_RET_STS_ERROR;
3474: IF (p_stack_messages = 'N') THEN
3475: RAISE violated_ref_integrity;
3478:
3479: IF (p_krpv_rec.Catchup_Settlement_Code = OKC_API.G_MISS_CHAR OR
3480: p_krpv_rec.Catchup_Settlement_Code IS NULL)
3481: THEN
3482: OKC_API.set_message(OKL_API.G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN,
3483: 'Catchup Settlement Code');
3484: l_return_status := OKC_API.G_RET_STS_ERROR;
3485: IF (p_stack_messages = 'N') THEN
3486: RAISE violated_ref_integrity;
3491: /*
3492: IF (p_krpv_rec.Rate_Change_Start_Date = OKC_API.G_MISS_DATE OR
3493: p_krpv_rec.Rate_Change_Start_Date IS NULL)
3494: THEN
3495: OKC_API.set_message(OKL_API.G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN,
3496: 'Rate Change Start Date');
3497: l_return_status := OKC_API.G_RET_STS_ERROR;
3498: IF (p_stack_messages = 'N') THEN
3499: RAISE violated_ref_integrity;
3502:
3503: IF (p_krpv_rec.Rate_Change_Frequency_Code = OKC_API.G_MISS_CHAR OR
3504: p_krpv_rec.Rate_Change_Frequency_Code IS NULL)
3505: THEN
3506: OKC_API.set_message(OKL_API.G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN,
3507: 'Rate Change Frequency Code');
3508: l_return_status := OKC_API.G_RET_STS_ERROR;
3509: IF (p_stack_messages = 'N') THEN
3510: RAISE violated_ref_integrity;
3513:
3514: IF (p_krpv_rec.Rate_Change_Value = OKC_API.G_MISS_NUM OR
3515: p_krpv_rec.Rate_Change_Value IS NULL)
3516: THEN
3517: OKC_API.set_message(OKL_API.G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN,
3518: 'Rate Change Value');
3519: l_return_status := OKC_API.G_RET_STS_ERROR;
3520: IF (p_stack_messages = 'N') THEN
3521: RAISE violated_ref_integrity;
3526: /*IF (p_krpv_rec.parameter_type_code = 'ACTUAL') THEN
3527: IF (p_krpv_rec.Conversion_Option_Code = OKC_API.G_MISS_CHAR OR
3528: p_krpv_rec.Conversion_Option_Code IS NULL)
3529: THEN
3530: OKC_API.set_message(OKL_API.G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN,
3531: 'Conversion Option Code');
3532: l_return_status := OKC_API.G_RET_STS_ERROR;
3533: IF (p_stack_messages = 'N') THEN
3534: RAISE violated_ref_integrity;
3539: /*IF (p_krpv_rec.parameter_type_code = 'ACTUAL') THEN
3540: IF (p_krpv_rec.Next_Conversion_Date = OKC_API.G_MISS_DATE OR
3541: p_krpv_rec.Next_Conversion_Date IS NULL)
3542: THEN
3543: OKC_API.set_message(OKL_API.G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN,
3544: 'Next Conversion Date');
3545: l_return_status := OKC_API.G_RET_STS_ERROR;
3546: IF (p_stack_messages = 'N') THEN
3547: RAISE violated_ref_integrity;
3552: /*IF (p_krpv_rec.parameter_type_code = 'ACTUAL') THEN
3553: IF (p_krpv_rec.Conversion_Type_Code = OKC_API.G_MISS_CHAR OR
3554: p_krpv_rec.Conversion_Type_Code IS NULL)
3555: THEN
3556: OKC_API.set_message(OKL_API.G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN,
3557: 'Conversion Type Code');
3558: l_return_status := OKC_API.G_RET_STS_ERROR;
3559: IF (p_stack_messages = 'N') THEN
3560: RAISE violated_ref_integrity;
3570: p_rev_rec_method IN ('ESTIMATED_AND_BILLED', 'ACTUAL')) THEN
3571: IF (p_krpv_rec.Interest_Index_Id = OKC_API.G_MISS_NUM OR
3572: p_krpv_rec.Interest_Index_Id IS NULL)
3573: THEN
3574: OKC_API.set_message(OKL_API.G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN,
3575: 'Interest Index Id');
3576: l_return_status := OKC_API.G_RET_STS_ERROR;
3577: IF (p_stack_messages = 'N') THEN
3578: RAISE violated_ref_integrity;
3582: -- Bug 4907390
3583: /*IF (p_krpv_rec.Base_Rate = OKC_API.G_MISS_NUM OR
3584: p_krpv_rec.Base_Rate IS NULL)
3585: THEN
3586: OKC_API.set_message(OKL_API.G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN,
3587: 'Base Rate');
3588: l_return_status := OKC_API.G_RET_STS_ERROR;
3589: IF (p_stack_messages = 'N') THEN
3590: RAISE violated_ref_integrity;
3593:
3594: IF (p_krpv_rec.Interest_Start_Date = OKC_API.G_MISS_DATE OR
3595: p_krpv_rec.Interest_Start_Date IS NULL)
3596: THEN
3597: OKC_API.set_message(OKL_API.G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN,
3598: 'Interest Start Date');
3599: l_return_status := OKC_API.G_RET_STS_ERROR;
3600: IF (p_stack_messages = 'N') THEN
3601: RAISE violated_ref_integrity;
3604:
3605: IF (p_krpv_rec.Adder_Rate = OKC_API.G_MISS_NUM OR
3606: p_krpv_rec.Adder_Rate IS NULL)
3607: THEN
3608: OKC_API.set_message(OKL_API.G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN,
3609: 'Adder Rate');
3610: l_return_status := OKC_API.G_RET_STS_ERROR;
3611: IF (p_stack_messages = 'N') THEN
3612: RAISE violated_ref_integrity;
3615:
3616: IF (p_krpv_rec.Maximum_Rate = OKC_API.G_MISS_NUM OR
3617: p_krpv_rec.Maximum_Rate IS NULL)
3618: THEN
3619: OKC_API.set_message(OKL_API.G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN,
3620: 'Maximum Rate');
3621: l_return_status := OKC_API.G_RET_STS_ERROR;
3622: IF (p_stack_messages = 'N') THEN
3623: RAISE violated_ref_integrity;
3626:
3627: IF (p_krpv_rec.Minimum_Rate = OKC_API.G_MISS_NUM OR
3628: p_krpv_rec.Minimum_Rate IS NULL)
3629: THEN
3630: OKC_API.set_message(OKL_API.G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN,
3631: 'Minimum Rate');
3632: l_return_status := OKC_API.G_RET_STS_ERROR;
3633: IF (p_stack_messages = 'N') THEN
3634: RAISE violated_ref_integrity;
3637:
3638: IF (p_krpv_rec.Principal_Basis_Code = OKC_API.G_MISS_CHAR OR
3639: p_krpv_rec.Principal_Basis_Code IS NULL)
3640: THEN
3641: OKC_API.set_message(OKL_API.G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN,
3642: 'Principal Basis Code');
3643: l_return_status := OKC_API.G_RET_STS_ERROR;
3644: IF (p_stack_messages = 'N') THEN
3645: RAISE violated_ref_integrity;
3648: p_krpv_rec.Principal_Basis_Code IS NOT NULL) THEN
3649: IF (p_krpv_rec.Principal_Basis_Code <> 'ACTUAL') THEN
3650: -- AKP: Todo: Set Proper Message
3651: --(Principal Basis Code is 'ACTUAL' allowed only)
3652: OKL_API.SET_MESSAGE( p_app_name => OKL_API.G_APP_NAME
3653: ,p_msg_name => 'OKL_LA_APPLICABLE_VALUES'
3654: ,p_token1 => 'VALUE'
3655: ,p_token1_value => 'ACTUAL'
3656: ,p_token2 => 'CODE0'
3668:
3669: IF (p_krpv_rec.Days_In_A_Month_Code = OKC_API.G_MISS_CHAR OR
3670: p_krpv_rec.Days_In_A_Month_Code IS NULL)
3671: THEN
3672: OKC_API.set_message(OKL_API.G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN,
3673: 'Days In A Month Code');
3674: l_return_status := OKC_API.G_RET_STS_ERROR;
3675: IF (p_stack_messages = 'N') THEN
3676: RAISE violated_ref_integrity;
3679:
3680: IF (p_krpv_rec.Days_In_A_Year_Code = OKC_API.G_MISS_CHAR OR
3681: p_krpv_rec.Days_In_A_Year_Code IS NULL)
3682: THEN
3683: OKC_API.set_message(OKL_API.G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN,
3684: 'Days In A Year Code');
3685: l_return_status := OKC_API.G_RET_STS_ERROR;
3686: IF (p_stack_messages = 'N') THEN
3687: RAISE violated_ref_integrity;
3690:
3691: IF (p_krpv_rec.Interest_Basis_Code = OKC_API.G_MISS_CHAR OR
3692: p_krpv_rec.Interest_Basis_Code IS NULL)
3693: THEN
3694: OKC_API.set_message(OKL_API.G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN,
3695: 'Interest Basis Code');
3696: l_return_status := OKC_API.G_RET_STS_ERROR;
3697: IF (p_stack_messages = 'N') THEN
3698: RAISE violated_ref_integrity;
3703: /*
3704: IF (p_krpv_rec.Rate_Delay_Code = OKC_API.G_MISS_CHAR OR
3705: p_krpv_rec.Rate_Delay_Code IS NULL)
3706: THEN
3707: OKC_API.set_message(OKL_API.G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN,
3708: 'Rate Delay Code');
3709: l_return_status := OKC_API.G_RET_STS_ERROR;
3710: IF (p_stack_messages = 'N') THEN
3711: RAISE violated_ref_integrity;
3714:
3715: IF (p_krpv_rec.Rate_Delay_Frequency = OKC_API.G_MISS_NUM OR
3716: p_krpv_rec.Rate_Delay_Frequency IS NULL)
3717: THEN
3718: OKC_API.set_message(OKL_API.G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN,
3719: 'Rate Delay Frequency');
3720: l_return_status := OKC_API.G_RET_STS_ERROR;
3721: IF (p_stack_messages = 'N') THEN
3722: RAISE violated_ref_integrity;
3728: /*IF (p_krpv_rec.Compounding_Frequency_Code = OKC_API.G_MISS_CHAR OR
3729: p_krpv_rec.Compounding_Frequency_Code IS NULL)
3730: THEN
3731: l_msg1_set := TRUE;
3732: OKC_API.set_message(OKL_API.G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN,
3733: 'Compounding Frequency Code');
3734: l_return_status := OKC_API.G_RET_STS_ERROR;
3735: IF (p_stack_messages = 'N') THEN
3736: RAISE violated_ref_integrity;
3740: IF (p_krpv_rec.Calculation_Formula_Id = OKC_API.G_MISS_NUM OR
3741: p_krpv_rec.Calculation_Formula_Id IS NULL)
3742: THEN
3743: l_msg2_set := TRUE;
3744: OKC_API.set_message(OKL_API.G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN,
3745: 'Formula Name');
3746: l_return_status := OKC_API.G_RET_STS_ERROR;
3747: IF (p_stack_messages = 'N') THEN
3748: RAISE violated_ref_integrity;
3753: /*
3754: IF (p_krpv_rec.Rate_Change_Start_Date = OKC_API.G_MISS_DATE OR
3755: p_krpv_rec.Rate_Change_Start_Date IS NULL)
3756: THEN
3757: OKC_API.set_message(OKL_API.G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN,
3758: 'Rate Change Start Date');
3759: l_return_status := OKC_API.G_RET_STS_ERROR;
3760: IF (p_stack_messages = 'N') THEN
3761: RAISE violated_ref_integrity;
3764:
3765: IF (p_krpv_rec.Rate_Change_Frequency_Code = OKC_API.G_MISS_CHAR OR
3766: p_krpv_rec.Rate_Change_Frequency_Code IS NULL)
3767: THEN
3768: OKC_API.set_message(OKL_API.G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN,
3769: 'Rate Change Frequency Code');
3770: l_return_status := OKC_API.G_RET_STS_ERROR;
3771: IF (p_stack_messages = 'N') THEN
3772: RAISE violated_ref_integrity;
3775:
3776: IF (p_krpv_rec.Rate_Change_Value = OKC_API.G_MISS_NUM OR
3777: p_krpv_rec.Rate_Change_Value IS NULL)
3778: THEN
3779: OKC_API.set_message(OKL_API.G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN,
3780: 'Rate Change Value');
3781: l_return_status := OKC_API.G_RET_STS_ERROR;
3782: IF (p_stack_messages = 'N') THEN
3783: RAISE violated_ref_integrity;
3787:
3788: /*IF (p_krpv_rec.Conversion_Option_Code = OKC_API.G_MISS_CHAR OR
3789: p_krpv_rec.Conversion_Option_Code IS NULL)
3790: THEN
3791: OKC_API.set_message(OKL_API.G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN,
3792: 'Conversion Option Code');
3793: l_return_status := OKC_API.G_RET_STS_ERROR;
3794: IF (p_stack_messages = 'N') THEN
3795: RAISE violated_ref_integrity;
3798:
3799: /*IF (p_krpv_rec.Next_Conversion_Date = OKC_API.G_MISS_DATE OR
3800: p_krpv_rec.Next_Conversion_Date IS NULL)
3801: THEN
3802: OKC_API.set_message(OKL_API.G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN,
3803: 'Next Conversion Date');
3804: l_return_status := OKC_API.G_RET_STS_ERROR;
3805: IF (p_stack_messages = 'N') THEN
3806: RAISE violated_ref_integrity;
3809:
3810: /*IF (p_krpv_rec.Conversion_Type_Code = OKC_API.G_MISS_CHAR OR
3811: p_krpv_rec.Conversion_Type_Code IS NULL)
3812: THEN
3813: OKC_API.set_message(OKL_API.G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN,
3814: 'Conversion Type Code');
3815: l_return_status := OKC_API.G_RET_STS_ERROR;
3816: IF (p_stack_messages = 'N') THEN
3817: RAISE violated_ref_integrity;
3832: IF (p_krpv_rec.Compounding_Frequency_Code = OKC_API.G_MISS_CHAR OR
3833: p_krpv_rec.Compounding_Frequency_Code IS NULL)
3834: THEN
3835: l_msg1_set := TRUE;
3836: OKC_API.set_message(OKL_API.G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN,
3837: 'Compounding Frequency Code');
3838: l_return_status := OKC_API.G_RET_STS_ERROR;
3839: IF (p_stack_messages = 'N') THEN
3840: RAISE violated_ref_integrity;
3846: IF (p_krpv_rec.Calculation_Formula_Id = OKC_API.G_MISS_NUM OR
3847: p_krpv_rec.Calculation_Formula_Id IS NULL)
3848: THEN
3849: l_msg2_set := TRUE;
3850: OKC_API.set_message(OKL_API.G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN,
3851: 'Formula Name');
3852: l_return_status := OKC_API.G_RET_STS_ERROR;
3853: IF (p_stack_messages = 'N') THEN
3854: RAISE violated_ref_integrity;
3868:
3869: Okl_Streams_Util.get_pricing_engine(p_khr_id => p_krpv_rec.khr_id,
3870: x_pricing_engine => l_pricing_engine,
3871: x_return_status => lx_return_status);
3872: IF (lx_return_status <> Okl_Api.G_RET_STS_SUCCESS) THEN
3873: l_return_status := lx_return_status;
3874: IF (p_stack_messages = 'N') THEN
3875: RAISE violated_ref_integrity;
3876: END IF;
3885: AND (l_days_month_yr_concat <> 'ACTUAL*360')
3886: AND (l_days_month_yr_concat <> '30*365')
3887: AND (l_days_month_yr_concat <> 'ACTUAL*ACTUAL')
3888: THEN
3889: OKC_API.set_message(OKL_API.G_APP_NAME,
3890: 'OKL_DAY_CONVEN_VAL_EXT');
3891: l_return_status := OKC_API.G_RET_STS_ERROR;
3892: IF (p_stack_messages = 'N') THEN
3893: RAISE violated_ref_integrity;
3899: IF (l_days_month_yr_concat <> '30*360')
3900: AND (l_days_month_yr_concat <> 'ACTUAL*365')
3901: AND (l_days_month_yr_concat <> 'ACTUAL*ACTUAL')
3902: THEN
3903: OKC_API.set_message(OKL_API.G_APP_NAME,
3904: 'OKL_DAY_CONVEN_VAL_INT');
3905: l_return_status := OKC_API.G_RET_STS_ERROR;
3906: IF (p_stack_messages = 'N') THEN
3907: RAISE violated_ref_integrity;
3911: END IF;
3912: END IF;
3913: --Bug# 13002041
3914:
3915: IF (l_return_status <> OKL_API.G_RET_STS_SUCCESS) AND
3916: (p_stack_messages = 'N') THEN
3917: RAISE violated_ref_integrity;
3918: END IF;
3919:
3923: RETURN (l_return_status);
3924:
3925: EXCEPTION
3926: WHEN violated_ref_integrity THEN
3927: l_return_status := OKL_API.G_RET_STS_ERROR;
3928: RETURN (l_return_status);
3929: END Validate_Record;
3930:
3931: ---------------------------------------------------------------------------