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_KRP_PVT dependencies on OKL_API

Line 17: x_return_status VARCHAR2(1):= Okl_Api.G_RET_STS_SUCCESS;

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'

Line 35: x_return_status := Okl_Api.G_RET_STS_ERROR;

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

Line 41: x_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;

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;

Line 279: OKC_API.set_message(OKL_API.G_APP_NAME,G_INVALID_VALUE,G_COL_NAME_TOKEN,'EFFECTIVE_FROM_DATE');

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;

Line 280: OKC_API.set_message(OKL_API.G_APP_NAME,G_INVALID_VALUE,G_COL_NAME_TOKEN,'KHR_ID');

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);

Line 281: OKC_API.set_message(OKL_API.G_APP_NAME,G_INVALID_VALUE,G_COL_NAME_TOKEN,'PARAMETER_TYPE_CODE');

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;

Line 436: OKC_API.set_message(OKL_API.G_APP_NAME,G_INVALID_VALUE,G_COL_NAME_TOKEN,'PARAMETER_TYPE_CODE');

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;

Line 437: OKC_API.set_message(OKL_API.G_APP_NAME,G_INVALID_VALUE,G_COL_NAME_TOKEN,'EFFECTIVE_FROM_DATE');

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);

Line 438: OKC_API.set_message(OKL_API.G_APP_NAME,G_INVALID_VALUE,G_COL_NAME_TOKEN,'KHR_ID');

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;

Line 621: OKC_API.set_message(OKL_API.G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN, 'khr_id');

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

Line 648: OKC_API.set_message(OKL_API.G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN, 'parameter_type_code');

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

Line 675: OKC_API.set_message(OKL_API.G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN, 'effective_from_date');

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

Line 780: OKC_API.set_message(OKL_API.G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN, 'Conversion Option Code');

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

Line 783: ELSIF (p_lookup_code <> OKL_API.G_MISS_CHAR AND

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;

Line 822: x_return_status := OKL_API.G_RET_STS_ERROR;

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;

Line 825: x_return_status := OKL_API.G_RET_STS_SUCCESS;

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

Line 830: x_return_status := OKL_API.G_RET_STS_ERROR;

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: --------------------------------------------------

Line 853: x_return_status := OKL_API.G_RET_STS_ERROR;

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;

Line 856: x_return_status := OKL_API.G_RET_STS_SUCCESS;

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

Line 861: x_return_status := OKL_API.G_RET_STS_ERROR;

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 --

Line 972: OKL_API.SET_MESSAGE( p_app_name => OKL_API.G_APP_NAME

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'

Line 1005: OKL_API.SET_MESSAGE( p_app_name => OKL_API.G_APP_NAME

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;

Line 1023: OKL_API.SET_MESSAGE( p_app_name => OKL_API.G_APP_NAME

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'

Line 1049: OKL_API.SET_MESSAGE( p_app_name => OKL_API.G_APP_NAME

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'

Line 1073: OKL_API.SET_MESSAGE( p_app_name => OKL_API.G_APP_NAME

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'

Line 1097: OKL_API.SET_MESSAGE( p_app_name => OKL_API.G_APP_NAME

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'

Line 1121: OKL_API.SET_MESSAGE( p_app_name => OKL_API.G_APP_NAME

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'

Line 1145: OKL_API.SET_MESSAGE( p_app_name => OKL_API.G_APP_NAME

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'

Line 1170: OKL_API.SET_MESSAGE( p_app_name => OKL_API.G_APP_NAME

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'

Line 1195: OKL_API.SET_MESSAGE( p_app_name => OKL_API.G_APP_NAME

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'

Line 1220: OKL_API.SET_MESSAGE( p_app_name => OKL_API.G_APP_NAME

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'

Line 1245: OKL_API.SET_MESSAGE( p_app_name => OKL_API.G_APP_NAME

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'

Line 1267: OKL_API.SET_MESSAGE( p_app_name => OKL_API.G_APP_NAME

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'

Line 1288: OKL_API.SET_MESSAGE( p_app_name => OKL_API.G_APP_NAME

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'

Line 1309: OKL_API.SET_MESSAGE( p_app_name => OKL_API.G_APP_NAME

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'

Line 1330: OKL_API.SET_MESSAGE( p_app_name => OKL_API.G_APP_NAME

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'

Line 1351: OKL_API.SET_MESSAGE( p_app_name => OKL_API.G_APP_NAME

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'

Line 1373: OKC_API.set_message(p_app_name => OKL_API.G_APP_NAME,

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 Frequency');
1377: l_return_status := OKC_API.G_RET_STS_ERROR;

Line 1385: OKC_API.set_message(p_app_name => OKL_API.G_APP_NAME,

1381: END IF;
1382: ELSE -- Rate delay code is null
1383: IF (p_krpv_rec.Rate_Delay_Frequency is NOT NULL AND
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');
1389: l_return_status := OKC_API.G_RET_STS_ERROR;

Line 1403: OKC_API.set_message(p_app_name => OKL_API.G_APP_NAME,

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;

Line 1423: OKC_API.set_message(p_app_name => OKL_API.G_APP_NAME,

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;

Line 1437: OKC_API.set_message(p_app_name => OKL_API.G_APP_NAME,

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;

Line 1452: OKC_API.set_message(p_app_name => OKL_API.G_APP_NAME,

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;

Line 1472: OKC_API.set_message(p_app_name => OKL_API.G_APP_NAME,

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;

Line 1486: OKC_API.set_message(p_app_name => OKL_API.G_APP_NAME,

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;

Line 1502: OKC_API.set_message(p_app_name => OKL_API.G_APP_NAME,

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;

Line 1515: IF (l_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN

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);

Line 1591: --OKC_API.set_message(OKL_API.G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN, 'Conversion_Option_Code');

1587: IF (p_krpv_rec.Conversion_Option_Code = OKC_API.G_MISS_CHAR OR
1588: p_krpv_rec.Conversion_Option_Code IS NULL)
1589: THEN
1590: print('Conversion_Option_Code is NULL...');
1591: --OKC_API.set_message(OKL_API.G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN, 'Conversion_Option_Code');
1592: OKC_API.set_message(p_app_name => OKL_API.G_APP_NAME,
1593: p_msg_name => G_REQUIRED_VALUE,
1594: p_token1 => G_COL_NAME_TOKEN,
1595: p_token1_value => 'Conversion_Option_Code');

Line 1592: OKC_API.set_message(p_app_name => OKL_API.G_APP_NAME,

1588: p_krpv_rec.Conversion_Option_Code IS NULL)
1589: THEN
1590: print('Conversion_Option_Code is NULL...');
1591: --OKC_API.set_message(OKL_API.G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN, 'Conversion_Option_Code');
1592: OKC_API.set_message(p_app_name => OKL_API.G_APP_NAME,
1593: p_msg_name => G_REQUIRED_VALUE,
1594: p_token1 => G_COL_NAME_TOKEN,
1595: p_token1_value => 'Conversion_Option_Code');
1596: l_return_status := OKC_API.G_RET_STS_ERROR;

Line 1610: OKC_API.set_message(OKL_API.G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN, 'Next_Conversion_Date');

1606: IF (p_krpv_rec.Next_Conversion_Date = OKC_API.G_MISS_DATE OR
1607: p_krpv_rec.Next_Conversion_Date IS NULL)
1608: THEN
1609: print('next_Conversion_Date is NULL...');
1610: OKC_API.set_message(OKL_API.G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN, 'Next_Conversion_Date');
1611: l_return_status := OKC_API.G_RET_STS_ERROR;
1612: IF (p_stack_messages = 'N') THEN
1613: RAISE violated_ref_integrity;
1614: END IF;

Line 1627: OKC_API.set_message(OKL_API.G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN, 'Conversion Type Code');

1623: IF (p_krpv_rec.Conversion_Type_Code = OKC_API.G_MISS_CHAR OR
1624: p_krpv_rec.Conversion_Type_Code IS NULL)
1625: THEN
1626: print('Conversion_Type_Code is NULL...');
1627: OKC_API.set_message(OKL_API.G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN, 'Conversion Type Code');
1628: l_return_status := OKC_API.G_RET_STS_ERROR;
1629: IF (p_stack_messages = 'N') THEN
1630: RAISE violated_ref_integrity;
1631: END IF;

Line 1639: OKC_API.set_message(OKL_API.G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN,

1635: ELSIF (p_int_calc_basis = 'REAMORT' AND p_rev_rec_method ='STREAMS') THEN
1636: IF (p_krpv_rec.Interest_Index_Id = OKC_API.G_MISS_NUM OR
1637: p_krpv_rec.Interest_Index_Id IS NULL)
1638: THEN
1639: OKC_API.set_message(OKL_API.G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN,
1640: 'Interest Index Id');
1641: l_return_status := OKC_API.G_RET_STS_ERROR;
1642: IF (p_stack_messages = 'N') THEN
1643: RAISE violated_ref_integrity;

Line 1651: OKC_API.set_message(OKL_API.G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN,

1647: -- Bug 4907390
1648: /*IF (p_krpv_rec.Base_Rate = OKC_API.G_MISS_NUM OR
1649: p_krpv_rec.Base_Rate IS NULL)
1650: THEN
1651: OKC_API.set_message(OKL_API.G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN,
1652: 'Base Rate');
1653: l_return_status := OKC_API.G_RET_STS_ERROR;
1654: IF (p_stack_messages = 'N') THEN
1655: RAISE violated_ref_integrity;

Line 1662: OKC_API.set_message(OKL_API.G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN,

1658:
1659: IF (p_krpv_rec.Interest_Start_Date = OKC_API.G_MISS_DATE OR
1660: p_krpv_rec.Interest_Start_Date IS NULL)
1661: THEN
1662: OKC_API.set_message(OKL_API.G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN,
1663: 'Interest Start Date');
1664: l_return_status := OKC_API.G_RET_STS_ERROR;
1665: IF (p_stack_messages = 'N') THEN
1666: RAISE violated_ref_integrity;

Line 1673: OKC_API.set_message(OKL_API.G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN,

1669:
1670: IF (p_krpv_rec.Adder_Rate = OKC_API.G_MISS_NUM OR
1671: p_krpv_rec.Adder_Rate IS NULL)
1672: THEN
1673: OKC_API.set_message(OKL_API.G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN,
1674: 'Adder Rate');
1675: l_return_status := OKC_API.G_RET_STS_ERROR;
1676: IF (p_stack_messages = 'N') THEN
1677: RAISE violated_ref_integrity;

Line 1684: OKC_API.set_message(OKL_API.G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN,

1680:
1681: IF (p_krpv_rec.Maximum_Rate = OKC_API.G_MISS_NUM OR
1682: p_krpv_rec.Maximum_Rate IS NULL)
1683: THEN
1684: OKC_API.set_message(OKL_API.G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN,
1685: 'Maximum Rate');
1686: l_return_status := OKC_API.G_RET_STS_ERROR;
1687: IF (p_stack_messages = 'N') THEN
1688: RAISE violated_ref_integrity;

Line 1695: OKC_API.set_message(OKL_API.G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN,

1691:
1692: IF (p_krpv_rec.Minimum_Rate = OKC_API.G_MISS_NUM OR
1693: p_krpv_rec.Minimum_Rate IS NULL)
1694: THEN
1695: OKC_API.set_message(OKL_API.G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN,
1696: 'Minimum Rate');
1697: l_return_status := OKC_API.G_RET_STS_ERROR;
1698: IF (p_stack_messages = 'N') THEN
1699: RAISE violated_ref_integrity;

Line 1706: OKC_API.set_message(OKL_API.G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN,

1702:
1703: IF (p_krpv_rec.Principal_Basis_Code = OKC_API.G_MISS_CHAR OR
1704: p_krpv_rec.Principal_Basis_Code IS NULL)
1705: THEN
1706: OKC_API.set_message(OKL_API.G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN,
1707: 'Principal Basis Code');
1708: l_return_status := OKC_API.G_RET_STS_ERROR;
1709: IF (p_stack_messages = 'N') THEN
1710: RAISE violated_ref_integrity;

Line 1717: OKL_API.SET_MESSAGE( p_app_name => OKL_API.G_APP_NAME

1713: p_krpv_rec.Principal_Basis_Code IS NOT NULL) THEN
1714: IF (p_krpv_rec.Principal_Basis_Code <> 'SCHEDULED') THEN
1715: -- AKP: Todo: Set Proper Message
1716: --(Principal Basis Code is 'SCHEDULED' allowed only)
1717: OKL_API.SET_MESSAGE( p_app_name => OKL_API.G_APP_NAME
1718: ,p_msg_name => 'OKL_LA_APPLICABLE_VALUES'
1719: ,p_token1 => 'VALUE'
1720: ,p_token1_value => 'SCHEDULED'
1721: ,p_token2 => 'CODE0'

Line 1737: OKC_API.set_message(OKL_API.G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN,

1733:
1734: IF (p_krpv_rec.Days_In_A_Month_Code = OKC_API.G_MISS_CHAR OR
1735: p_krpv_rec.Days_In_A_Month_Code IS NULL)
1736: THEN
1737: OKC_API.set_message(OKL_API.G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN,
1738: 'Days In A Month Code');
1739: l_return_status := OKC_API.G_RET_STS_ERROR;
1740: IF (p_stack_messages = 'N') THEN
1741: RAISE violated_ref_integrity;

Line 1748: OKL_API.SET_MESSAGE( p_app_name => OKL_API.G_APP_NAME

1744: p_krpv_rec.Days_In_A_Month_Code IS NOT NULL) THEN
1745: IF (p_krpv_rec.Days_In_A_Month_Code <> '30') THEN
1746: -- AKP: Todo: Set Proper Message
1747: --(Days In A Month Code is '30' allowed only)
1748: OKL_API.SET_MESSAGE( p_app_name => OKL_API.G_APP_NAME
1749: ,p_msg_name => 'OKL_LA_APPLICABLE_VALUES'
1750: ,p_token1 => 'VALUE'
1751: ,p_token1_value => '30'
1752: ,p_token2 => 'CODE0'

Line 1768: OKC_API.set_message(OKL_API.G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN,

1764:
1765: IF (p_krpv_rec.Days_In_A_Year_Code = OKC_API.G_MISS_CHAR OR
1766: p_krpv_rec.Days_In_A_Year_Code IS NULL)
1767: THEN
1768: OKC_API.set_message(OKL_API.G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN,
1769: 'Days In A Year Code');
1770: l_return_status := OKC_API.G_RET_STS_ERROR;
1771: IF (p_stack_messages = 'N') THEN
1772: RAISE violated_ref_integrity;

Line 1779: OKL_API.SET_MESSAGE( p_app_name => OKL_API.G_APP_NAME

1775: p_krpv_rec.Days_In_A_Year_Code IS NOT NULL) THEN
1776: IF (p_krpv_rec.Days_In_A_Year_Code <> '360') THEN
1777: -- AKP: Todo: Set Proper Message
1778: --(Days In A Year Code is '360' allowed only)
1779: OKL_API.SET_MESSAGE( p_app_name => OKL_API.G_APP_NAME
1780: ,p_msg_name => 'OKL_LA_APPLICABLE_VALUES'
1781: ,p_token1 => 'VALUE'
1782: ,p_token1_value => '360'
1783: ,p_token2 => 'CODE0'

Line 1799: OKC_API.set_message(OKL_API.G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN,

1795:
1796: IF (p_krpv_rec.Interest_Basis_Code = OKC_API.G_MISS_CHAR OR
1797: p_krpv_rec.Interest_Basis_Code IS NULL)
1798: THEN
1799: OKC_API.set_message(OKL_API.G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN,
1800: 'Interest Basis Code');
1801: l_return_status := OKC_API.G_RET_STS_ERROR;
1802: IF (p_stack_messages = 'N') THEN
1803: RAISE violated_ref_integrity;

Line 1810: OKL_API.SET_MESSAGE( p_app_name => OKL_API.G_APP_NAME

1806: p_krpv_rec.Interest_Basis_Code IS NOT NULL) THEN
1807: IF (p_krpv_rec.Interest_Basis_Code <> 'SIMPLE') THEN
1808: -- AKP: Todo: Set Proper Message
1809: --(Interest Basis Code is 'SIMPLE' allowed only)
1810: OKL_API.SET_MESSAGE( p_app_name => OKL_API.G_APP_NAME
1811: ,p_msg_name => 'OKL_LA_APPLICABLE_VALUES'
1812: ,p_token1 => 'VALUE'
1813: ,p_token1_value => 'SIMPLE'
1814: ,p_token2 => 'CODE0'

Line 1834: OKC_API.set_message(OKL_API.G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN,

1830: /*
1831: IF (p_krpv_rec.Rate_Delay_Code = OKC_API.G_MISS_CHAR OR
1832: p_krpv_rec.Rate_Delay_Code IS NULL)
1833: THEN
1834: OKC_API.set_message(OKL_API.G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN,
1835: 'Rate Delay Code');
1836: l_return_status := OKC_API.G_RET_STS_ERROR;
1837: IF (p_stack_messages = 'N') THEN
1838: RAISE violated_ref_integrity;

Line 1845: OKC_API.set_message(OKL_API.G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN,

1841:
1842: IF (p_krpv_rec.Rate_Delay_Frequency = OKC_API.G_MISS_NUM OR
1843: p_krpv_rec.Rate_Delay_Frequency IS NULL)
1844: THEN
1845: OKC_API.set_message(OKL_API.G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN,
1846: 'Rate Delay Frequency');
1847: l_return_status := OKC_API.G_RET_STS_ERROR;
1848: IF (p_stack_messages = 'N') THEN
1849: RAISE violated_ref_integrity;

Line 1856: OKC_API.set_message(OKL_API.G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN,

1852:
1853: IF (p_krpv_rec.Rate_Change_Start_Date = OKC_API.G_MISS_DATE OR
1854: p_krpv_rec.Rate_Change_Start_Date IS NULL)
1855: THEN
1856: OKC_API.set_message(OKL_API.G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN,
1857: 'Rate Change Start Date');
1858: l_return_status := OKC_API.G_RET_STS_ERROR;
1859: IF (p_stack_messages = 'N') THEN
1860: RAISE violated_ref_integrity;

Line 1869: /*OKC_API.set_message(OKL_API.G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN,

1865: IF (p_krpv_rec.Rate_Change_Frequency_Code = OKC_API.G_MISS_CHAR OR
1866: p_krpv_rec.Rate_Change_Frequency_Code IS NULL)
1867: THEN
1868: -- Bug 4862551
1869: /*OKC_API.set_message(OKL_API.G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN,
1870: 'Rate Change Frequency Code');
1871: l_return_status := OKC_API.G_RET_STS_ERROR;
1872: IF (p_stack_messages = 'N') THEN
1873: RAISE violated_ref_integrity;

Line 1881: OKL_API.SET_MESSAGE( p_app_name => OKL_API.G_APP_NAME

1877: p_krpv_rec.Rate_Change_Frequency_Code IS NOT NULL) THEN
1878: IF (p_krpv_rec.Rate_Change_Frequency_Code <> 'BILLING_DATE') THEN
1879: -- AKP: Todo: Set Proper Message
1880: --(Rate Change Frequency Code is 'BILLING_DATE' allowed only)
1881: OKL_API.SET_MESSAGE( p_app_name => OKL_API.G_APP_NAME
1882: ,p_msg_name => 'OKL_LA_APPLICABLE_VALUES'
1883: ,p_token1 => 'VALUE'
1884: ,p_token1_value => 'BILLING_DATE'
1885: ,p_token2 => 'CODE0'

Line 1903: OKC_API.set_message(OKL_API.G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN,

1899: /*
1900: IF (p_krpv_rec.Rate_Change_Value = OKC_API.G_MISS_NUM OR
1901: p_krpv_rec.Rate_Change_Value IS NULL)
1902: THEN
1903: OKC_API.set_message(OKL_API.G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN,
1904: 'Rate Change Value');
1905: l_return_status := OKC_API.G_RET_STS_ERROR;
1906: IF (p_stack_messages = 'N') THEN
1907: RAISE violated_ref_integrity;

Line 1916: OKC_API.set_message(OKL_API.G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN,

1912: /*IF (p_krpv_rec.parameter_type_code = 'ACTUAL') THEN
1913: IF (p_krpv_rec.Conversion_Option_Code = OKC_API.G_MISS_CHAR OR
1914: p_krpv_rec.Conversion_Option_Code IS NULL)
1915: THEN
1916: OKC_API.set_message(OKL_API.G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN,
1917: 'Conversion Option Code');
1918: l_return_status := OKC_API.G_RET_STS_ERROR;
1919: IF (p_stack_messages = 'N') THEN
1920: RAISE violated_ref_integrity;

Line 1929: OKC_API.set_message(OKL_API.G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN,

1925: /*IF (p_krpv_rec.parameter_type_code = 'ACTUAL') THEN
1926: IF (p_krpv_rec.Next_Conversion_Date = OKC_API.G_MISS_DATE OR
1927: p_krpv_rec.Next_Conversion_Date IS NULL)
1928: THEN
1929: OKC_API.set_message(OKL_API.G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN,
1930: 'Next Conversion Date');
1931: l_return_status := OKC_API.G_RET_STS_ERROR;
1932: IF (p_stack_messages = 'N') THEN
1933: RAISE violated_ref_integrity;

Line 1942: OKC_API.set_message(OKL_API.G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN,

1938: /*IF (p_krpv_rec.parameter_type_code = 'ACTUAL') THEN
1939: IF (p_krpv_rec.Conversion_Type_Code = OKC_API.G_MISS_CHAR OR
1940: p_krpv_rec.Conversion_Type_Code IS NULL)
1941: THEN
1942: OKC_API.set_message(OKL_API.G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN,
1943: 'Conversion Type Code');
1944: l_return_status := OKC_API.G_RET_STS_ERROR;
1945: IF (p_stack_messages = 'N') THEN
1946: RAISE violated_ref_integrity;

Line 1957: OKC_API.set_message(OKL_API.G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN,

1953: -- Bug 4907390
1954: /*IF (p_krpv_rec.Base_Rate = OKC_API.G_MISS_NUM OR
1955: p_krpv_rec.Base_Rate IS NULL)
1956: THEN
1957: OKC_API.set_message(OKL_API.G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN,
1958: 'Base Rate');
1959: l_return_status := OKC_API.G_RET_STS_ERROR;
1960: IF (p_stack_messages = 'N') THEN
1961: RAISE violated_ref_integrity;

Line 1968: OKC_API.set_message(OKL_API.G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN,

1964:
1965: IF (p_krpv_rec.Interest_Start_Date = OKC_API.G_MISS_DATE OR
1966: p_krpv_rec.Interest_Start_Date IS NULL)
1967: THEN
1968: OKC_API.set_message(OKL_API.G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN,
1969: 'Interest Start Date');
1970: l_return_status := OKC_API.G_RET_STS_ERROR;
1971: IF (p_stack_messages = 'N') THEN
1972: RAISE violated_ref_integrity;

Line 1980: OKC_API.set_message(OKL_API.G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN,

1976: /*IF (p_krpv_rec.parameter_type_code = 'ACTUAL') THEN
1977: IF (p_krpv_rec.Conversion_Option_Code = OKC_API.G_MISS_CHAR OR
1978: p_krpv_rec.Conversion_Option_Code IS NULL)
1979: THEN
1980: OKC_API.set_message(OKL_API.G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN,
1981: 'Conversion Option Code');
1982: l_return_status := OKC_API.G_RET_STS_ERROR;
1983: IF (p_stack_messages = 'N') THEN
1984: RAISE violated_ref_integrity;

Line 1993: OKC_API.set_message(OKL_API.G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN,

1989: /*IF (p_krpv_rec.parameter_type_code = 'ACTUAL') THEN
1990: IF (p_krpv_rec.Next_Conversion_Date = OKC_API.G_MISS_DATE OR
1991: p_krpv_rec.Next_Conversion_Date IS NULL)
1992: THEN
1993: OKC_API.set_message(OKL_API.G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN,
1994: 'Next Conversion Date');
1995: l_return_status := OKC_API.G_RET_STS_ERROR;
1996: IF (p_stack_messages = 'N') THEN
1997: RAISE violated_ref_integrity;

Line 2006: OKC_API.set_message(OKL_API.G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN,

2002: /*IF (p_krpv_rec.parameter_type_code = 'ACTUAL') THEN
2003: IF (p_krpv_rec.Conversion_Type_Code = OKC_API.G_MISS_CHAR OR
2004: p_krpv_rec.Conversion_Type_Code IS NULL)
2005: THEN
2006: OKC_API.set_message(OKL_API.G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN,
2007: 'Conversion Type Code');
2008: l_return_status := OKC_API.G_RET_STS_ERROR;
2009: IF (p_stack_messages = 'N') THEN
2010: RAISE violated_ref_integrity;

Line 2019: OKC_API.set_message(OKL_API.G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN,

2015: -- Bug 4753087
2016: IF (p_krpv_rec.Principal_Basis_Code = OKC_API.G_MISS_CHAR OR
2017: p_krpv_rec.Principal_Basis_Code IS NULL)
2018: THEN
2019: OKC_API.set_message(OKL_API.G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN,
2020: 'Principal Basis Code');
2021: l_return_status := OKC_API.G_RET_STS_ERROR;
2022: IF (p_stack_messages = 'N') THEN
2023: RAISE violated_ref_integrity;

Line 2030: OKL_API.SET_MESSAGE( p_app_name => OKL_API.G_APP_NAME

2026: p_krpv_rec.Principal_Basis_Code IS NOT NULL) THEN
2027: IF (p_krpv_rec.Principal_Basis_Code <> 'SCHEDULED') THEN
2028: -- AKP: Todo: Set Proper Message
2029: --(Principal Basis Code is 'SCHEDULED' allowed only)
2030: OKL_API.SET_MESSAGE( p_app_name => OKL_API.G_APP_NAME
2031: ,p_msg_name => 'OKL_LA_APPLICABLE_VALUES'
2032: ,p_token1 => 'VALUE'
2033: ,p_token1_value => 'SCHEDULED'
2034: ,p_token2 => 'CODE0'

Line 2052: OKC_API.set_message(OKL_API.G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN,

2048: IF (p_krpv_rec.Calculation_Formula_Id = OKC_API.G_MISS_NUM OR
2049: p_krpv_rec.Calculation_Formula_Id IS NULL)
2050: THEN
2051: l_msg2_set := TRUE;
2052: OKC_API.set_message(OKL_API.G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN,
2053: 'Formula Name');
2054: l_return_status := OKC_API.G_RET_STS_ERROR;
2055: IF (p_stack_messages = 'N') THEN
2056: RAISE violated_ref_integrity;

Line 2073: p_init_msg_list => OKL_API.G_FALSE,

2069: p_krpv_rec.Base_Rate IS NULL)
2070: THEN
2071: OKL_K_RATE_PARAMS_PVT.check_principal_payment(
2072: p_api_version => 1,
2073: p_init_msg_list => OKL_API.G_FALSE,
2074: x_return_status => l_return_status,
2075: x_msg_count => l_msg_count,
2076: x_msg_data => l_msg_data,
2077: p_chr_id => p_krpv_rec.khr_id,

Line 2079: IF (l_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN

2075: x_msg_count => l_msg_count,
2076: x_msg_data => l_msg_data,
2077: p_chr_id => p_krpv_rec.khr_id,
2078: x_principal_payment_defined => l_principal_payment_defined);
2079: IF (l_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
2080: RAISE violated_ref_integrity;
2081: END IF;
2082:
2083: IF (l_principal_payment_defined) THEN

Line 2084: OKC_API.set_message(OKL_API.G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN,

2080: RAISE violated_ref_integrity;
2081: END IF;
2082:
2083: IF (l_principal_payment_defined) THEN
2084: OKC_API.set_message(OKL_API.G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN,
2085: 'Base Rate');
2086: l_return_status := OKC_API.G_RET_STS_ERROR;
2087: IF (p_stack_messages = 'N') THEN
2088: RAISE violated_ref_integrity;

Line 2097: OKC_API.set_message(OKL_API.G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN,

2093: /*IF (p_krpv_rec.parameter_type_code = 'ACTUAL') THEN
2094: IF (p_krpv_rec.Conversion_Option_Code = OKC_API.G_MISS_CHAR OR
2095: p_krpv_rec.Conversion_Option_Code IS NULL)
2096: THEN
2097: OKC_API.set_message(OKL_API.G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN,
2098: 'Conversion Option Code');
2099: l_return_status := OKC_API.G_RET_STS_ERROR;
2100: IF (p_stack_messages = 'N') THEN
2101: RAISE violated_ref_integrity;

Line 2110: OKC_API.set_message(OKL_API.G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN,

2106: /*IF (p_krpv_rec.parameter_type_code = 'ACTUAL') THEN
2107: IF (p_krpv_rec.Next_Conversion_Date = OKC_API.G_MISS_DATE OR
2108: p_krpv_rec.Next_Conversion_Date IS NULL)
2109: THEN
2110: OKC_API.set_message(OKL_API.G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN,
2111: 'Next Conversion Date');
2112: l_return_status := OKC_API.G_RET_STS_ERROR;
2113: IF (p_stack_messages = 'N') THEN
2114: RAISE violated_ref_integrity;

Line 2123: OKC_API.set_message(OKL_API.G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN,

2119: /*IF (p_krpv_rec.parameter_type_code = 'ACTUAL') THEN
2120: IF (p_krpv_rec.Conversion_Type_Code = OKC_API.G_MISS_CHAR OR
2121: p_krpv_rec.Conversion_Type_Code IS NULL)
2122: THEN
2123: OKC_API.set_message(OKL_API.G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN,
2124: 'Conversion Type Code');
2125: l_return_status := OKC_API.G_RET_STS_ERROR;
2126: IF (p_stack_messages = 'N') THEN
2127: RAISE violated_ref_integrity;

Line 2139: OKC_API.set_message(OKL_API.G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN,

2135: AND p_rev_rec_method = 'ESTIMATED_AND_BILLED') THEN
2136: IF (p_krpv_rec.Interest_Index_Id = OKC_API.G_MISS_NUM OR
2137: p_krpv_rec.Interest_Index_Id IS NULL)
2138: THEN
2139: OKC_API.set_message(OKL_API.G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN,
2140: 'Interest Index Id');
2141: l_return_status := OKC_API.G_RET_STS_ERROR;
2142: IF (p_stack_messages = 'N') THEN
2143: RAISE violated_ref_integrity;

Line 2151: OKC_API.set_message(OKL_API.G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN,

2147: -- Bug 4907390
2148: /*IF (p_krpv_rec.Base_Rate = OKC_API.G_MISS_NUM OR
2149: p_krpv_rec.Base_Rate IS NULL)
2150: THEN
2151: OKC_API.set_message(OKL_API.G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN,
2152: 'Base Rate');
2153: l_return_status := OKC_API.G_RET_STS_ERROR;
2154: IF (p_stack_messages = 'N') THEN
2155: RAISE violated_ref_integrity;

Line 2162: OKC_API.set_message(OKL_API.G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN,

2158:
2159: IF (p_krpv_rec.Interest_Start_Date = OKC_API.G_MISS_DATE OR
2160: p_krpv_rec.Interest_Start_Date IS NULL)
2161: THEN
2162: OKC_API.set_message(OKL_API.G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN,
2163: 'Interest Start Date');
2164: l_return_status := OKC_API.G_RET_STS_ERROR;
2165: IF (p_stack_messages = 'N') THEN
2166: RAISE violated_ref_integrity;

Line 2173: OKC_API.set_message(OKL_API.G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN,

2169:
2170: IF (p_krpv_rec.Adder_Rate = OKC_API.G_MISS_NUM OR
2171: p_krpv_rec.Adder_Rate IS NULL)
2172: THEN
2173: OKC_API.set_message(OKL_API.G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN,
2174: 'Adder Rate');
2175: l_return_status := OKC_API.G_RET_STS_ERROR;
2176: IF (p_stack_messages = 'N') THEN
2177: RAISE violated_ref_integrity;

Line 2184: OKC_API.set_message(OKL_API.G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN,

2180:
2181: IF (p_krpv_rec.Maximum_Rate = OKC_API.G_MISS_NUM OR
2182: p_krpv_rec.Maximum_Rate IS NULL)
2183: THEN
2184: OKC_API.set_message(OKL_API.G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN,
2185: 'Maximum Rate');
2186: l_return_status := OKC_API.G_RET_STS_ERROR;
2187: IF (p_stack_messages = 'N') THEN
2188: RAISE violated_ref_integrity;

Line 2195: OKC_API.set_message(OKL_API.G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN,

2191:
2192: IF (p_krpv_rec.Minimum_Rate = OKC_API.G_MISS_NUM OR
2193: p_krpv_rec.Minimum_Rate IS NULL)
2194: THEN
2195: OKC_API.set_message(OKL_API.G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN,
2196: 'Minimum Rate');
2197: l_return_status := OKC_API.G_RET_STS_ERROR;
2198: IF (p_stack_messages = 'N') THEN
2199: RAISE violated_ref_integrity;

Line 2206: OKC_API.set_message(OKL_API.G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN,

2202:
2203: IF (p_krpv_rec.Principal_Basis_Code = OKC_API.G_MISS_CHAR OR
2204: p_krpv_rec.Principal_Basis_Code IS NULL)
2205: THEN
2206: OKC_API.set_message(OKL_API.G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN,
2207: 'Principal Basis Code');
2208: l_return_status := OKC_API.G_RET_STS_ERROR;
2209: IF (p_stack_messages = 'N') THEN
2210: RAISE violated_ref_integrity;

Line 2217: OKC_API.set_message(OKL_API.G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN,

2213:
2214: IF (p_krpv_rec.Days_In_A_Month_Code = OKC_API.G_MISS_CHAR OR
2215: p_krpv_rec.Days_In_A_Month_Code IS NULL)
2216: THEN
2217: OKC_API.set_message(OKL_API.G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN,
2218: 'Days In A Month Code');
2219: l_return_status := OKC_API.G_RET_STS_ERROR;
2220: IF (p_stack_messages = 'N') THEN
2221: RAISE violated_ref_integrity;

Line 2228: OKC_API.set_message(OKL_API.G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN,

2224:
2225: IF (p_krpv_rec.Days_In_A_Year_Code = OKC_API.G_MISS_CHAR OR
2226: p_krpv_rec.Days_In_A_Year_Code IS NULL)
2227: THEN
2228: OKC_API.set_message(OKL_API.G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN,
2229: 'Days In A Year Code');
2230: l_return_status := OKC_API.G_RET_STS_ERROR;
2231: IF (p_stack_messages = 'N') THEN
2232: RAISE violated_ref_integrity;

Line 2239: OKC_API.set_message(OKL_API.G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN,

2235:
2236: IF (p_krpv_rec.Interest_Basis_Code = OKC_API.G_MISS_CHAR OR
2237: p_krpv_rec.Interest_Basis_Code IS NULL)
2238: THEN
2239: OKC_API.set_message(OKL_API.G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN,
2240: 'Interest Basis Code');
2241: l_return_status := OKC_API.G_RET_STS_ERROR;
2242: IF (p_stack_messages = 'N') THEN
2243: RAISE violated_ref_integrity;

Line 2252: OKC_API.set_message(OKL_API.G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN,

2248: /*
2249: IF (p_krpv_rec.Rate_Delay_Code = OKC_API.G_MISS_CHAR OR
2250: p_krpv_rec.Rate_Delay_Code IS NULL)
2251: THEN
2252: OKC_API.set_message(OKL_API.G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN,
2253: 'Rate Delay Code');
2254: l_return_status := OKC_API.G_RET_STS_ERROR;
2255: IF (p_stack_messages = 'N') THEN
2256: RAISE violated_ref_integrity;

Line 2263: OKC_API.set_message(OKL_API.G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN,

2259:
2260: IF (p_krpv_rec.Rate_Delay_Frequency = OKC_API.G_MISS_NUM OR
2261: p_krpv_rec.Rate_Delay_Frequency IS NULL)
2262: THEN
2263: OKC_API.set_message(OKL_API.G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN,
2264: 'Rate Delay Frequency');
2265: l_return_status := OKC_API.G_RET_STS_ERROR;
2266: IF (p_stack_messages = 'N') THEN
2267: RAISE violated_ref_integrity;

Line 2277: OKC_API.set_message(OKL_API.G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN,

2273: /*IF (p_krpv_rec.Compounding_Frequency_Code = OKC_API.G_MISS_CHAR OR
2274: p_krpv_rec.Compounding_Frequency_Code IS NULL)
2275: THEN
2276: l_msg1_set := TRUE;
2277: OKC_API.set_message(OKL_API.G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN,
2278: 'Compounding Frequency CODE');
2279: l_return_status := OKC_API.G_RET_STS_ERROR;
2280: IF (p_stack_messages = 'N') THEN
2281: RAISE violated_ref_integrity;

Line 2289: OKC_API.set_message(OKL_API.G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN,

2285: IF (p_krpv_rec.Calculation_Formula_Id = OKC_API.G_MISS_NUM OR
2286: p_krpv_rec.Calculation_Formula_Id IS NULL)
2287: THEN
2288: l_msg2_set := TRUE;
2289: OKC_API.set_message(OKL_API.G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN,
2290: 'Formula Name');
2291: l_return_status := OKC_API.G_RET_STS_ERROR;
2292: IF (p_stack_messages = 'N') THEN
2293: RAISE violated_ref_integrity;

Line 2302: OKC_API.set_message(OKL_API.G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN,

2298: /*
2299: IF (p_krpv_rec.Rate_Change_Start_Date = OKC_API.G_MISS_DATE OR
2300: p_krpv_rec.Rate_Change_Start_Date IS NULL)
2301: THEN
2302: OKC_API.set_message(OKL_API.G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN,
2303: 'Rate Change Start Date');
2304: l_return_status := OKC_API.G_RET_STS_ERROR;
2305: IF (p_stack_messages = 'N') THEN
2306: RAISE violated_ref_integrity;

Line 2313: OKC_API.set_message(OKL_API.G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN,

2309:
2310: IF (p_krpv_rec.Rate_Change_Frequency_Code = OKC_API.G_MISS_CHAR OR
2311: p_krpv_rec.Rate_Change_Frequency_Code IS NULL)
2312: THEN
2313: OKC_API.set_message(OKL_API.G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN,
2314: 'Rate Change Frequency Code');
2315: l_return_status := OKC_API.G_RET_STS_ERROR;
2316: IF (p_stack_messages = 'N') THEN
2317: RAISE violated_ref_integrity;

Line 2324: OKC_API.set_message(OKL_API.G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN,

2320:
2321: IF (p_krpv_rec.Rate_Change_Value = OKC_API.G_MISS_NUM OR
2322: p_krpv_rec.Rate_Change_Value IS NULL)
2323: THEN
2324: OKC_API.set_message(OKL_API.G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN,
2325: 'Rate Change Value');
2326: l_return_status := OKC_API.G_RET_STS_ERROR;
2327: IF (p_stack_messages = 'N') THEN
2328: RAISE violated_ref_integrity;

Line 2337: OKC_API.set_message(OKL_API.G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN,

2333: /*IF (p_krpv_rec.parameter_type_code = 'ACTUAL') THEN
2334: IF (p_krpv_rec.Conversion_Option_Code = OKC_API.G_MISS_CHAR OR
2335: p_krpv_rec.Conversion_Option_Code IS NULL)
2336: THEN
2337: OKC_API.set_message(OKL_API.G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN,
2338: 'Conversion Option Code');
2339: l_return_status := OKC_API.G_RET_STS_ERROR;
2340: IF (p_stack_messages = 'N') THEN
2341: RAISE violated_ref_integrity;

Line 2350: OKC_API.set_message(OKL_API.G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN,

2346: /*IF (p_krpv_rec.parameter_type_code = 'ACTUAL') THEN
2347: IF (p_krpv_rec.Next_Conversion_Date = OKC_API.G_MISS_DATE OR
2348: p_krpv_rec.Next_Conversion_Date IS NULL)
2349: THEN
2350: OKC_API.set_message(OKL_API.G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN,
2351: 'Next Conversion Date');
2352: l_return_status := OKC_API.G_RET_STS_ERROR;
2353: IF (p_stack_messages = 'N') THEN
2354: RAISE violated_ref_integrity;

Line 2363: OKC_API.set_message(OKL_API.G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN,

2359: /*IF (p_krpv_rec.parameter_type_code = 'ACTUAL') THEN
2360: IF (p_krpv_rec.Conversion_Type_Code = OKC_API.G_MISS_CHAR OR
2361: p_krpv_rec.Conversion_Type_Code IS NULL)
2362: THEN
2363: OKC_API.set_message(OKL_API.G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN,
2364: 'Conversion Type Code');
2365: l_return_status := OKC_API.G_RET_STS_ERROR;
2366: IF (p_stack_messages = 'N') THEN
2367: RAISE violated_ref_integrity;

Line 2377: OKC_API.set_message(OKL_API.G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN,

2373: AND p_rev_rec_method = 'ACTUAL') THEN
2374: IF (p_krpv_rec.Interest_Index_Id = OKC_API.G_MISS_NUM OR
2375: p_krpv_rec.Interest_Index_Id IS NULL)
2376: THEN
2377: OKC_API.set_message(OKL_API.G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN,
2378: 'Interest Index Id');
2379: l_return_status := OKC_API.G_RET_STS_ERROR;
2380: IF (p_stack_messages = 'N') THEN
2381: RAISE violated_ref_integrity;

Line 2389: OKC_API.set_message(OKL_API.G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN,

2385: -- Bug 4907390
2386: /*IF (p_krpv_rec.Base_Rate = OKC_API.G_MISS_NUM OR
2387: p_krpv_rec.Base_Rate IS NULL)
2388: THEN
2389: OKC_API.set_message(OKL_API.G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN,
2390: 'Base Rate');
2391: l_return_status := OKC_API.G_RET_STS_ERROR;
2392: IF (p_stack_messages = 'N') THEN
2393: RAISE violated_ref_integrity;

Line 2400: OKC_API.set_message(OKL_API.G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN,

2396:
2397: IF (p_krpv_rec.Interest_Start_Date = OKC_API.G_MISS_DATE OR
2398: p_krpv_rec.Interest_Start_Date IS NULL)
2399: THEN
2400: OKC_API.set_message(OKL_API.G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN,
2401: 'Interest Start Date');
2402: l_return_status := OKC_API.G_RET_STS_ERROR;
2403: IF (p_stack_messages = 'N') THEN
2404: RAISE violated_ref_integrity;

Line 2411: OKC_API.set_message(OKL_API.G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN,

2407:
2408: IF (p_krpv_rec.Adder_Rate = OKC_API.G_MISS_NUM OR
2409: p_krpv_rec.Adder_Rate IS NULL)
2410: THEN
2411: OKC_API.set_message(OKL_API.G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN,
2412: 'Adder Rate');
2413: l_return_status := OKC_API.G_RET_STS_ERROR;
2414: IF (p_stack_messages = 'N') THEN
2415: RAISE violated_ref_integrity;

Line 2422: OKC_API.set_message(OKL_API.G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN,

2418:
2419: IF (p_krpv_rec.Maximum_Rate = OKC_API.G_MISS_NUM OR
2420: p_krpv_rec.Maximum_Rate IS NULL)
2421: THEN
2422: OKC_API.set_message(OKL_API.G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN,
2423: 'Maximum Rate');
2424: l_return_status := OKC_API.G_RET_STS_ERROR;
2425: IF (p_stack_messages = 'N') THEN
2426: RAISE violated_ref_integrity;

Line 2433: OKC_API.set_message(OKL_API.G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN,

2429:
2430: IF (p_krpv_rec.Minimum_Rate = OKC_API.G_MISS_NUM OR
2431: p_krpv_rec.Minimum_Rate IS NULL)
2432: THEN
2433: OKC_API.set_message(OKL_API.G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN,
2434: 'Minimum Rate');
2435: l_return_status := OKC_API.G_RET_STS_ERROR;
2436: IF (p_stack_messages = 'N') THEN
2437: RAISE violated_ref_integrity;

Line 2444: OKC_API.set_message(OKL_API.G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN,

2440:
2441: IF (p_krpv_rec.Principal_Basis_Code = OKC_API.G_MISS_CHAR OR
2442: p_krpv_rec.Principal_Basis_Code IS NULL)
2443: THEN
2444: OKC_API.set_message(OKL_API.G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN,
2445: 'Principal Basis Code');
2446: l_return_status := OKC_API.G_RET_STS_ERROR;
2447: IF (p_stack_messages = 'N') THEN
2448: RAISE violated_ref_integrity;

Line 2455: OKL_API.SET_MESSAGE( p_app_name => OKL_API.G_APP_NAME

2451: p_krpv_rec.Principal_Basis_Code IS NOT NULL) THEN
2452: IF (p_krpv_rec.Principal_Basis_Code <> 'ACTUAL') THEN
2453: -- AKP: Todo: Set Proper Message
2454: --(Principal Basis Code is 'ACTUAL' allowed only)
2455: OKL_API.SET_MESSAGE( p_app_name => OKL_API.G_APP_NAME
2456: ,p_msg_name => 'OKL_LA_APPLICABLE_VALUES'
2457: ,p_token1 => 'VALUE'
2458: ,p_token1_value => 'ACTUAL'
2459: ,p_token2 => 'CODE0'

Line 2475: OKC_API.set_message(OKL_API.G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN,

2471:
2472: IF (p_krpv_rec.Days_In_A_Month_Code = OKC_API.G_MISS_CHAR OR
2473: p_krpv_rec.Days_In_A_Month_Code IS NULL)
2474: THEN
2475: OKC_API.set_message(OKL_API.G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN,
2476: 'Days In A Month Code');
2477: l_return_status := OKC_API.G_RET_STS_ERROR;
2478: IF (p_stack_messages = 'N') THEN
2479: RAISE violated_ref_integrity;

Line 2486: OKC_API.set_message(OKL_API.G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN,

2482:
2483: IF (p_krpv_rec.Days_In_A_Year_Code = OKC_API.G_MISS_CHAR OR
2484: p_krpv_rec.Days_In_A_Year_Code IS NULL)
2485: THEN
2486: OKC_API.set_message(OKL_API.G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN,
2487: 'Days In A Year Code');
2488: l_return_status := OKC_API.G_RET_STS_ERROR;
2489: IF (p_stack_messages = 'N') THEN
2490: RAISE violated_ref_integrity;

Line 2497: OKC_API.set_message(OKL_API.G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN,

2493:
2494: IF (p_krpv_rec.Interest_Basis_Code = OKC_API.G_MISS_CHAR OR
2495: p_krpv_rec.Interest_Basis_Code IS NULL)
2496: THEN
2497: OKC_API.set_message(OKL_API.G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN,
2498: 'Interest Basis Code');
2499: l_return_status := OKC_API.G_RET_STS_ERROR;
2500: IF (p_stack_messages = 'N') THEN
2501: RAISE violated_ref_integrity;

Line 2510: OKC_API.set_message(OKL_API.G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN,

2506: /*
2507: IF (p_krpv_rec.Rate_Delay_Code = OKC_API.G_MISS_CHAR OR
2508: p_krpv_rec.Rate_Delay_Code IS NULL)
2509: THEN
2510: OKC_API.set_message(OKL_API.G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN,
2511: 'Rate Delay Code');
2512: l_return_status := OKC_API.G_RET_STS_ERROR;
2513: IF (p_stack_messages = 'N') THEN
2514: RAISE violated_ref_integrity;

Line 2521: OKC_API.set_message(OKL_API.G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN,

2517:
2518: IF (p_krpv_rec.Rate_Delay_Frequency = OKC_API.G_MISS_NUM OR
2519: p_krpv_rec.Rate_Delay_Frequency IS NULL)
2520: THEN
2521: OKC_API.set_message(OKL_API.G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN,
2522: 'Rate Delay Frequency');
2523: l_return_status := OKC_API.G_RET_STS_ERROR;
2524: IF (p_stack_messages = 'N') THEN
2525: RAISE violated_ref_integrity;

Line 2535: OKC_API.set_message(OKL_API.G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN,

2531: /*IF (p_krpv_rec.Compounding_Frequency_Code = OKC_API.G_MISS_CHAR OR
2532: p_krpv_rec.Compounding_Frequency_Code IS NULL)
2533: THEN
2534: l_msg1_set := TRUE;
2535: OKC_API.set_message(OKL_API.G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN,
2536: 'Compounding Frequency CODE');
2537: l_return_status := OKC_API.G_RET_STS_ERROR;
2538: IF (p_stack_messages = 'N') THEN
2539: RAISE violated_ref_integrity;

Line 2547: OKC_API.set_message(OKL_API.G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN,

2543: IF (p_krpv_rec.Calculation_Formula_Id = OKC_API.G_MISS_NUM OR
2544: p_krpv_rec.Calculation_Formula_Id IS NULL)
2545: THEN
2546: l_msg2_set := TRUE;
2547: OKC_API.set_message(OKL_API.G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN,
2548: 'Formula Name');
2549: l_return_status := OKC_API.G_RET_STS_ERROR;
2550: IF (p_stack_messages = 'N') THEN
2551: RAISE violated_ref_integrity;

Line 2560: OKC_API.set_message(OKL_API.G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN,

2556: /*
2557: IF (p_krpv_rec.Rate_Change_Start_Date = OKC_API.G_MISS_DATE OR
2558: p_krpv_rec.Rate_Change_Start_Date IS NULL)
2559: THEN
2560: OKC_API.set_message(OKL_API.G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN,
2561: 'Rate Change Start Date');
2562: l_return_status := OKC_API.G_RET_STS_ERROR;
2563: IF (p_stack_messages = 'N') THEN
2564: RAISE violated_ref_integrity;

Line 2571: OKC_API.set_message(OKL_API.G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN,

2567:
2568: IF (p_krpv_rec.Rate_Change_Frequency_Code = OKC_API.G_MISS_CHAR OR
2569: p_krpv_rec.Rate_Change_Frequency_Code IS NULL)
2570: THEN
2571: OKC_API.set_message(OKL_API.G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN,
2572: 'Rate Change Frequency Code');
2573: l_return_status := OKC_API.G_RET_STS_ERROR;
2574: IF (p_stack_messages = 'N') THEN
2575: RAISE violated_ref_integrity;

Line 2582: OKC_API.set_message(OKL_API.G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN,

2578:
2579: IF (p_krpv_rec.Rate_Change_Value = OKC_API.G_MISS_NUM OR
2580: p_krpv_rec.Rate_Change_Value IS NULL)
2581: THEN
2582: OKC_API.set_message(OKL_API.G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN,
2583: 'Rate Change Value');
2584: l_return_status := OKC_API.G_RET_STS_ERROR;
2585: IF (p_stack_messages = 'N') THEN
2586: RAISE violated_ref_integrity;

Line 2595: OKC_API.set_message(OKL_API.G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN,

2591: /*IF (p_krpv_rec.parameter_type_code = 'ACTUAL') THEN
2592: IF (p_krpv_rec.Conversion_Option_Code = OKC_API.G_MISS_CHAR OR
2593: p_krpv_rec.Conversion_Option_Code IS NULL)
2594: THEN
2595: OKC_API.set_message(OKL_API.G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN,
2596: 'Conversion Option Code');
2597: l_return_status := OKC_API.G_RET_STS_ERROR;
2598: IF (p_stack_messages = 'N') THEN
2599: RAISE violated_ref_integrity;

Line 2608: OKC_API.set_message(OKL_API.G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN,

2604: /*IF (p_krpv_rec.parameter_type_code = 'ACTUAL') THEN
2605: IF (p_krpv_rec.Next_Conversion_Date = OKC_API.G_MISS_DATE OR
2606: p_krpv_rec.Next_Conversion_Date IS NULL)
2607: THEN
2608: OKC_API.set_message(OKL_API.G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN,
2609: 'Next Conversion Date');
2610: l_return_status := OKC_API.G_RET_STS_ERROR;
2611: IF (p_stack_messages = 'N') THEN
2612: RAISE violated_ref_integrity;

Line 2621: OKC_API.set_message(OKL_API.G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN,

2617: /*IF (p_krpv_rec.parameter_type_code = 'ACTUAL') THEN
2618: IF (p_krpv_rec.Conversion_Type_Code = OKC_API.G_MISS_CHAR OR
2619: p_krpv_rec.Conversion_Type_Code IS NULL)
2620: THEN
2621: OKC_API.set_message(OKL_API.G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN,
2622: 'Conversion Type Code');
2623: l_return_status := OKC_API.G_RET_STS_ERROR;
2624: IF (p_stack_messages = 'N') THEN
2625: RAISE violated_ref_integrity;

Line 2635: OKC_API.set_message(OKL_API.G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN,

2631: AND p_rev_rec_method = 'STREAMS') THEN
2632: IF (p_krpv_rec.Interest_Index_Id = OKC_API.G_MISS_NUM OR
2633: p_krpv_rec.Interest_Index_Id IS NULL)
2634: THEN
2635: OKC_API.set_message(OKL_API.G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN,
2636: 'Interest Index Id');
2637: l_return_status := OKC_API.G_RET_STS_ERROR;
2638: IF (p_stack_messages = 'N') THEN
2639: RAISE violated_ref_integrity;

Line 2647: OKC_API.set_message(OKL_API.G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN,

2643: -- Bug 4907390
2644: /*IF (p_krpv_rec.Base_Rate = OKC_API.G_MISS_NUM OR
2645: p_krpv_rec.Base_Rate IS NULL)
2646: THEN
2647: OKC_API.set_message(OKL_API.G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN,
2648: 'Base Rate');
2649: l_return_status := OKC_API.G_RET_STS_ERROR;
2650: IF (p_stack_messages = 'N') THEN
2651: RAISE violated_ref_integrity;

Line 2658: OKC_API.set_message(OKL_API.G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN,

2654:
2655: IF (p_krpv_rec.Interest_Start_Date = OKC_API.G_MISS_DATE OR
2656: p_krpv_rec.Interest_Start_Date IS NULL)
2657: THEN
2658: OKC_API.set_message(OKL_API.G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN,
2659: 'Interest Start Date');
2660: l_return_status := OKC_API.G_RET_STS_ERROR;
2661: IF (p_stack_messages = 'N') THEN
2662: RAISE violated_ref_integrity;

Line 2669: OKC_API.set_message(OKL_API.G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN,

2665:
2666: IF (p_krpv_rec.Adder_Rate = OKC_API.G_MISS_NUM OR
2667: p_krpv_rec.Adder_Rate IS NULL)
2668: THEN
2669: OKC_API.set_message(OKL_API.G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN,
2670: 'Adder Rate');
2671: l_return_status := OKC_API.G_RET_STS_ERROR;
2672: IF (p_stack_messages = 'N') THEN
2673: RAISE violated_ref_integrity;

Line 2680: OKC_API.set_message(OKL_API.G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN,

2676:
2677: IF (p_krpv_rec.Maximum_Rate = OKC_API.G_MISS_NUM OR
2678: p_krpv_rec.Maximum_Rate IS NULL)
2679: THEN
2680: OKC_API.set_message(OKL_API.G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN,
2681: 'Maximum Rate');
2682: l_return_status := OKC_API.G_RET_STS_ERROR;
2683: IF (p_stack_messages = 'N') THEN
2684: RAISE violated_ref_integrity;

Line 2691: OKC_API.set_message(OKL_API.G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN,

2687:
2688: IF (p_krpv_rec.Minimum_Rate = OKC_API.G_MISS_NUM OR
2689: p_krpv_rec.Minimum_Rate IS NULL)
2690: THEN
2691: OKC_API.set_message(OKL_API.G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN,
2692: 'Minimum Rate');
2693: l_return_status := OKC_API.G_RET_STS_ERROR;
2694: IF (p_stack_messages = 'N') THEN
2695: RAISE violated_ref_integrity;

Line 2702: OKC_API.set_message(OKL_API.G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN,

2698:
2699: IF (p_krpv_rec.Principal_Basis_Code = OKC_API.G_MISS_CHAR OR
2700: p_krpv_rec.Principal_Basis_Code IS NULL)
2701: THEN
2702: OKC_API.set_message(OKL_API.G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN,
2703: 'Principal Basis Code');
2704: l_return_status := OKC_API.G_RET_STS_ERROR;
2705: IF (p_stack_messages = 'N') THEN
2706: RAISE violated_ref_integrity;

Line 2713: OKL_API.SET_MESSAGE( p_app_name => OKL_API.G_APP_NAME

2709: p_krpv_rec.Principal_Basis_Code IS NOT NULL) THEN
2710: IF (p_krpv_rec.Principal_Basis_Code <> 'SCHEDULED') THEN
2711: -- AKP: Todo: Set Proper Message
2712: --(Principal Basis Code is 'SCHEDULED' allowed only)
2713: OKL_API.SET_MESSAGE( p_app_name => OKL_API.G_APP_NAME
2714: ,p_msg_name => 'OKL_LA_APPLICABLE_VALUES'
2715: ,p_token1 => 'VALUE'
2716: ,p_token1_value => 'SCHEDULED'
2717: ,p_token2 => 'CODE0'

Line 2733: OKC_API.set_message(OKL_API.G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN,

2729:
2730: IF (p_krpv_rec.Days_In_A_Month_Code = OKC_API.G_MISS_CHAR OR
2731: p_krpv_rec.Days_In_A_Month_Code IS NULL)
2732: THEN
2733: OKC_API.set_message(OKL_API.G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN,
2734: 'Days In A Month Code');
2735: l_return_status := OKC_API.G_RET_STS_ERROR;
2736: IF (p_stack_messages = 'N') THEN
2737: RAISE violated_ref_integrity;

Line 2744: OKL_API.SET_MESSAGE( p_app_name => OKL_API.G_APP_NAME

2740: p_krpv_rec.Days_In_A_Month_Code IS NOT NULL) THEN
2741: IF (p_krpv_rec.Days_In_A_Month_Code <> '30') THEN
2742: -- AKP: Todo: Set Proper Message
2743: --(Days In A Month Code is '30' allowed only)
2744: OKL_API.SET_MESSAGE( p_app_name => OKL_API.G_APP_NAME
2745: ,p_msg_name => 'OKL_LA_APPLICABLE_VALUES'
2746: ,p_token1 => 'VALUE'
2747: ,p_token1_value => '30'
2748: ,p_token2 => 'CODE0'

Line 2764: OKC_API.set_message(OKL_API.G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN,

2760:
2761: IF (p_krpv_rec.Days_In_A_Year_Code = OKC_API.G_MISS_CHAR OR
2762: p_krpv_rec.Days_In_A_Year_Code IS NULL)
2763: THEN
2764: OKC_API.set_message(OKL_API.G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN,
2765: 'Days In A Year Code');
2766: l_return_status := OKC_API.G_RET_STS_ERROR;
2767: IF (p_stack_messages = 'N') THEN
2768: RAISE violated_ref_integrity;

Line 2775: OKL_API.SET_MESSAGE( p_app_name => OKL_API.G_APP_NAME

2771: p_krpv_rec.Days_In_A_Year_Code IS NOT NULL) THEN
2772: IF (p_krpv_rec.Days_In_A_Year_Code <> '360') THEN
2773: -- AKP: Todo: Set Proper Message
2774: --(Days In A Year Code is '360' allowed only)
2775: OKL_API.SET_MESSAGE( p_app_name => OKL_API.G_APP_NAME
2776: ,p_msg_name => 'OKL_LA_APPLICABLE_VALUES'
2777: ,p_token1 => 'VALUE'
2778: ,p_token1_value => '360'
2779: ,p_token2 => 'CODE0'

Line 2795: OKC_API.set_message(OKL_API.G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN,

2791:
2792: IF (p_krpv_rec.Interest_Basis_Code = OKC_API.G_MISS_CHAR OR
2793: p_krpv_rec.Interest_Basis_Code IS NULL)
2794: THEN
2795: OKC_API.set_message(OKL_API.G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN,
2796: 'Interest Basis Code');
2797: l_return_status := OKC_API.G_RET_STS_ERROR;
2798: IF (p_stack_messages = 'N') THEN
2799: RAISE violated_ref_integrity;

Line 2806: OKL_API.SET_MESSAGE( p_app_name => OKL_API.G_APP_NAME

2802: p_krpv_rec.Interest_Basis_Code IS NOT NULL) THEN
2803: IF (p_krpv_rec.Interest_Basis_Code <> 'SIMPLE') THEN
2804: -- AKP: Todo: Set Proper Message
2805: --(Interest Basis Code is 'SIMPLE' allowed only)
2806: OKL_API.SET_MESSAGE( p_app_name => OKL_API.G_APP_NAME
2807: ,p_msg_name => 'OKL_LA_APPLICABLE_VALUES'
2808: ,p_token1 => 'VALUE'
2809: ,p_token1_value => 'SIMPLE'
2810: ,p_token2 => 'CODE0'

Line 2828: OKC_API.set_message(OKL_API.G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN,

2824: /*
2825: IF (p_krpv_rec.Rate_Delay_Code = OKC_API.G_MISS_CHAR OR
2826: p_krpv_rec.Rate_Delay_Code IS NULL)
2827: THEN
2828: OKC_API.set_message(OKL_API.G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN,
2829: 'Rate Delay Code');
2830: l_return_status := OKC_API.G_RET_STS_ERROR;
2831: IF (p_stack_messages = 'N') THEN
2832: RAISE violated_ref_integrity;

Line 2839: OKC_API.set_message(OKL_API.G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN,

2835:
2836: IF (p_krpv_rec.Rate_Delay_Frequency = OKC_API.G_MISS_NUM OR
2837: p_krpv_rec.Rate_Delay_Frequency IS NULL)
2838: THEN
2839: OKC_API.set_message(OKL_API.G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN,
2840: 'Rate Delay Frequency');
2841: l_return_status := OKC_API.G_RET_STS_ERROR;
2842: IF (p_stack_messages = 'N') THEN
2843: RAISE violated_ref_integrity;

Line 2850: OKC_API.set_message(OKL_API.G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN,

2846:
2847: IF (p_krpv_rec.Rate_Change_Start_Date = OKC_API.G_MISS_DATE OR
2848: p_krpv_rec.Rate_Change_Start_Date IS NULL)
2849: THEN
2850: OKC_API.set_message(OKL_API.G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN,
2851: 'Rate Change Start Date');
2852: l_return_status := OKC_API.G_RET_STS_ERROR;
2853: IF (p_stack_messages = 'N') THEN
2854: RAISE violated_ref_integrity;

Line 2864: /*OKC_API.set_message(OKL_API.G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN,

2860: p_krpv_rec.Rate_Change_Frequency_Code IS NULL)
2861: THEN
2862: -- Bug 4862551
2863: NULL;
2864: /*OKC_API.set_message(OKL_API.G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN,
2865: 'Rate Change Frequency Code');
2866: l_return_status := OKC_API.G_RET_STS_ERROR;
2867: IF (p_stack_messages = 'N') THEN
2868: RAISE violated_ref_integrity;

Line 2875: OKL_API.SET_MESSAGE( p_app_name => OKL_API.G_APP_NAME

2871: p_krpv_rec.Rate_Change_Frequency_Code IS NOT NULL) THEN
2872: IF (p_krpv_rec.Rate_Change_Frequency_Code <> 'BILLING_DATE') THEN
2873: -- AKP: Todo: Set Proper Message
2874: --(Rate Change Frequency Code is 'BILLING_DATE' allowed only)
2875: OKL_API.SET_MESSAGE( p_app_name => OKL_API.G_APP_NAME
2876: ,p_msg_name => 'OKL_LA_APPLICABLE_VALUES'
2877: ,p_token1 => 'VALUE'
2878: ,p_token1_value => 'BILLING_DATE'
2879: ,p_token2 => 'CODE0'

Line 2897: OKC_API.set_message(OKL_API.G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN,

2893: /*
2894: IF (p_krpv_rec.Rate_Change_Value = OKC_API.G_MISS_NUM OR
2895: p_krpv_rec.Rate_Change_Value IS NULL)
2896: THEN
2897: OKC_API.set_message(OKL_API.G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN,
2898: 'Rate Change Value');
2899: l_return_status := OKC_API.G_RET_STS_ERROR;
2900: IF (p_stack_messages = 'N') THEN
2901: RAISE violated_ref_integrity;

Line 2910: OKC_API.set_message(OKL_API.G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN,

2906: /*IF (p_krpv_rec.parameter_type_code = 'ACTUAL') THEN
2907: IF (p_krpv_rec.Conversion_Option_Code = OKC_API.G_MISS_CHAR OR
2908: p_krpv_rec.Conversion_Option_Code IS NULL)
2909: THEN
2910: OKC_API.set_message(OKL_API.G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN,
2911: 'Conversion Option Code');
2912: l_return_status := OKC_API.G_RET_STS_ERROR;
2913: IF (p_stack_messages = 'N') THEN
2914: RAISE violated_ref_integrity;

Line 2923: OKC_API.set_message(OKL_API.G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN,

2919: /*IF (p_krpv_rec.parameter_type_code = 'ACTUAL') THEN
2920: IF (p_krpv_rec.Next_Conversion_Date = OKC_API.G_MISS_DATE OR
2921: p_krpv_rec.Next_Conversion_Date IS NULL)
2922: THEN
2923: OKC_API.set_message(OKL_API.G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN,
2924: 'Next Conversion Date');
2925: l_return_status := OKC_API.G_RET_STS_ERROR;
2926: IF (p_stack_messages = 'N') THEN
2927: RAISE violated_ref_integrity;

Line 2936: OKC_API.set_message(OKL_API.G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN,

2932: /*IF (p_krpv_rec.parameter_type_code = 'ACTUAL') THEN
2933: IF (p_krpv_rec.Conversion_Type_Code = OKC_API.G_MISS_CHAR OR
2934: p_krpv_rec.Conversion_Type_Code IS NULL)
2935: THEN
2936: OKC_API.set_message(OKL_API.G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN,
2937: 'Conversion Type Code');
2938: l_return_status := OKC_API.G_RET_STS_ERROR;
2939: IF (p_stack_messages = 'N') THEN
2940: RAISE violated_ref_integrity;

Line 2950: OKC_API.set_message(OKL_API.G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN,

2946: AND p_rev_rec_method = 'ACTUAL') THEN
2947: IF (p_krpv_rec.Interest_Index_Id = OKC_API.G_MISS_NUM OR
2948: p_krpv_rec.Interest_Index_Id IS NULL)
2949: THEN
2950: OKC_API.set_message(OKL_API.G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN,
2951: 'Interest Index Id');
2952: l_return_status := OKC_API.G_RET_STS_ERROR;
2953: IF (p_stack_messages = 'N') THEN
2954: RAISE violated_ref_integrity;

Line 2962: OKC_API.set_message(OKL_API.G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN,

2958: -- Bug 4907390
2959: /*IF (p_krpv_rec.Base_Rate = OKC_API.G_MISS_NUM OR
2960: p_krpv_rec.Base_Rate IS NULL)
2961: THEN
2962: OKC_API.set_message(OKL_API.G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN,
2963: 'Base Rate');
2964: l_return_status := OKC_API.G_RET_STS_ERROR;
2965: IF (p_stack_messages = 'N') THEN
2966: RAISE violated_ref_integrity;

Line 2973: OKC_API.set_message(OKL_API.G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN,

2969:
2970: IF (p_krpv_rec.Interest_Start_Date = OKC_API.G_MISS_DATE OR
2971: p_krpv_rec.Interest_Start_Date IS NULL)
2972: THEN
2973: OKC_API.set_message(OKL_API.G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN,
2974: 'Interest Start Date');
2975: l_return_status := OKC_API.G_RET_STS_ERROR;
2976: IF (p_stack_messages = 'N') THEN
2977: RAISE violated_ref_integrity;

Line 2984: OKC_API.set_message(OKL_API.G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN,

2980:
2981: IF (p_krpv_rec.Adder_Rate = OKC_API.G_MISS_NUM OR
2982: p_krpv_rec.Adder_Rate IS NULL)
2983: THEN
2984: OKC_API.set_message(OKL_API.G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN,
2985: 'Adder Rate');
2986: l_return_status := OKC_API.G_RET_STS_ERROR;
2987: IF (p_stack_messages = 'N') THEN
2988: RAISE violated_ref_integrity;

Line 2995: OKC_API.set_message(OKL_API.G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN,

2991:
2992: IF (p_krpv_rec.Maximum_Rate = OKC_API.G_MISS_NUM OR
2993: p_krpv_rec.Maximum_Rate IS NULL)
2994: THEN
2995: OKC_API.set_message(OKL_API.G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN,
2996: 'Maximum Rate');
2997: l_return_status := OKC_API.G_RET_STS_ERROR;
2998: IF (p_stack_messages = 'N') THEN
2999: RAISE violated_ref_integrity;

Line 3006: OKC_API.set_message(OKL_API.G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN,

3002:
3003: IF (p_krpv_rec.Minimum_Rate = OKC_API.G_MISS_NUM OR
3004: p_krpv_rec.Minimum_Rate IS NULL)
3005: THEN
3006: OKC_API.set_message(OKL_API.G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN,
3007: 'Minimum Rate');
3008: l_return_status := OKC_API.G_RET_STS_ERROR;
3009: IF (p_stack_messages = 'N') THEN
3010: RAISE violated_ref_integrity;

Line 3017: OKC_API.set_message(OKL_API.G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN,

3013:
3014: IF (p_krpv_rec.Principal_Basis_Code = OKC_API.G_MISS_CHAR OR
3015: p_krpv_rec.Principal_Basis_Code IS NULL)
3016: THEN
3017: OKC_API.set_message(OKL_API.G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN,
3018: 'Principal Basis Code');
3019: l_return_status := OKC_API.G_RET_STS_ERROR;
3020: IF (p_stack_messages = 'N') THEN
3021: RAISE violated_ref_integrity;

Line 3029: OKL_API.SET_MESSAGE( p_app_name => OKL_API.G_APP_NAME

3025: IF (p_krpv_rec.Principal_Basis_Code <> 'SCHEDULED') THEN -- 4896751
3026: --IF (p_krpv_rec.Principal_Basis_Code <> 'ACTUAL') THEN -- 4753087
3027: -- AKP: Todo: Set Proper Message
3028: --(Principal Basis Code is 'ACTUAL' allowed only) -- 4753087
3029: OKL_API.SET_MESSAGE( p_app_name => OKL_API.G_APP_NAME
3030: ,p_msg_name => 'OKL_LA_APPLICABLE_VALUES'
3031: ,p_token1 => 'VALUE'
3032: --,p_token1_value => 'ACTUAL' -- 4753087
3033: ,p_token1_value => 'SCHEDULED' -- 4896751

Line 3050: OKC_API.set_message(OKL_API.G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN,

3046:
3047: IF (p_krpv_rec.Days_In_A_Month_Code = OKC_API.G_MISS_CHAR OR
3048: p_krpv_rec.Days_In_A_Month_Code IS NULL)
3049: THEN
3050: OKC_API.set_message(OKL_API.G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN,
3051: 'Days In A Month Code');
3052: l_return_status := OKC_API.G_RET_STS_ERROR;
3053: IF (p_stack_messages = 'N') THEN
3054: RAISE violated_ref_integrity;

Line 3061: OKC_API.set_message(OKL_API.G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN,

3057:
3058: IF (p_krpv_rec.Days_In_A_Year_Code = OKC_API.G_MISS_CHAR OR
3059: p_krpv_rec.Days_In_A_Year_Code IS NULL)
3060: THEN
3061: OKC_API.set_message(OKL_API.G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN,
3062: 'Days In A Year Code');
3063: l_return_status := OKC_API.G_RET_STS_ERROR;
3064: IF (p_stack_messages = 'N') THEN
3065: RAISE violated_ref_integrity;

Line 3072: OKC_API.set_message(OKL_API.G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN,

3068:
3069: IF (p_krpv_rec.Interest_Basis_Code = OKC_API.G_MISS_CHAR OR
3070: p_krpv_rec.Interest_Basis_Code IS NULL)
3071: THEN
3072: OKC_API.set_message(OKL_API.G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN,
3073: 'Interest Basis Code');
3074: l_return_status := OKC_API.G_RET_STS_ERROR;
3075: IF (p_stack_messages = 'N') THEN
3076: RAISE violated_ref_integrity;

Line 3085: OKC_API.set_message(OKL_API.G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN,

3081: /*
3082: IF (p_krpv_rec.Rate_Delay_Code = OKC_API.G_MISS_CHAR OR
3083: p_krpv_rec.Rate_Delay_Code IS NULL)
3084: THEN
3085: OKC_API.set_message(OKL_API.G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN,
3086: 'Rate Delay Code');
3087: l_return_status := OKC_API.G_RET_STS_ERROR;
3088: IF (p_stack_messages = 'N') THEN
3089: RAISE violated_ref_integrity;

Line 3096: OKC_API.set_message(OKL_API.G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN,

3092:
3093: IF (p_krpv_rec.Rate_Delay_Frequency = OKC_API.G_MISS_NUM OR
3094: p_krpv_rec.Rate_Delay_Frequency IS NULL)
3095: THEN
3096: OKC_API.set_message(OKL_API.G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN,
3097: 'Rate Delay Frequency');
3098: l_return_status := OKC_API.G_RET_STS_ERROR;
3099: IF (p_stack_messages = 'N') THEN
3100: RAISE violated_ref_integrity;

Line 3110: OKC_API.set_message(OKL_API.G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN,

3106: /*IF (p_krpv_rec.Compounding_Frequency_Code = OKC_API.G_MISS_CHAR OR
3107: p_krpv_rec.Compounding_Frequency_Code IS NULL)
3108: THEN
3109: l_msg1_set := TRUE;
3110: OKC_API.set_message(OKL_API.G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN,
3111: 'Compounding Frequency Code');
3112: l_return_status := OKC_API.G_RET_STS_ERROR;
3113: IF (p_stack_messages = 'N') THEN
3114: RAISE violated_ref_integrity;

Line 3122: OKC_API.set_message(OKL_API.G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN,

3118: IF (p_krpv_rec.Calculation_Formula_Id = OKC_API.G_MISS_NUM OR
3119: p_krpv_rec.Calculation_Formula_Id IS NULL)
3120: THEN
3121: l_msg2_set := TRUE;
3122: OKC_API.set_message(OKL_API.G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN,
3123: 'Formula Name');
3124: l_return_status := OKC_API.G_RET_STS_ERROR;
3125: IF (p_stack_messages = 'N') THEN
3126: RAISE violated_ref_integrity;

Line 3134: OKC_API.set_message(OKL_API.G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN,

3130: /*
3131: IF (p_krpv_rec.Rate_Change_Start_Date = OKC_API.G_MISS_DATE OR
3132: p_krpv_rec.Rate_Change_Start_Date IS NULL)
3133: THEN
3134: OKC_API.set_message(OKL_API.G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN,
3135: 'Rate Change Start Date');
3136: l_return_status := OKC_API.G_RET_STS_ERROR;
3137: IF (p_stack_messages = 'N') THEN
3138: RAISE violated_ref_integrity;

Line 3145: OKC_API.set_message(OKL_API.G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN,

3141:
3142: IF (p_krpv_rec.Rate_Change_Frequency_Code = OKC_API.G_MISS_CHAR OR
3143: p_krpv_rec.Rate_Change_Frequency_Code IS NULL)
3144: THEN
3145: OKC_API.set_message(OKL_API.G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN,
3146: 'Rate Change Frequency Code');
3147: l_return_status := OKC_API.G_RET_STS_ERROR;
3148: IF (p_stack_messages = 'N') THEN
3149: RAISE violated_ref_integrity;

Line 3156: OKC_API.set_message(OKL_API.G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN,

3152:
3153: IF (p_krpv_rec.Rate_Change_Value = OKC_API.G_MISS_NUM OR
3154: p_krpv_rec.Rate_Change_Value IS NULL)
3155: THEN
3156: OKC_API.set_message(OKL_API.G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN,
3157: 'Rate Change Value');
3158: l_return_status := OKC_API.G_RET_STS_ERROR;
3159: IF (p_stack_messages = 'N') THEN
3160: RAISE violated_ref_integrity;

Line 3169: OKC_API.set_message(OKL_API.G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN,

3165: /*IF (p_krpv_rec.parameter_type_code = 'ACTUAL') THEN
3166: IF (p_krpv_rec.Conversion_Option_Code = OKC_API.G_MISS_CHAR OR
3167: p_krpv_rec.Conversion_Option_Code IS NULL)
3168: THEN
3169: OKC_API.set_message(OKL_API.G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN,
3170: 'Conversion Option Code');
3171: l_return_status := OKC_API.G_RET_STS_ERROR;
3172: IF (p_stack_messages = 'N') THEN
3173: RAISE violated_ref_integrity;

Line 3182: OKC_API.set_message(OKL_API.G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN,

3178: /*IF (p_krpv_rec.parameter_type_code = 'ACTUAL') THEN
3179: IF (p_krpv_rec.Next_Conversion_Date = OKC_API.G_MISS_DATE OR
3180: p_krpv_rec.Next_Conversion_Date IS NULL)
3181: THEN
3182: OKC_API.set_message(OKL_API.G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN,
3183: 'Next Conversion Date');
3184: l_return_status := OKC_API.G_RET_STS_ERROR;
3185: IF (p_stack_messages = 'N') THEN
3186: RAISE violated_ref_integrity;

Line 3195: OKC_API.set_message(OKL_API.G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN,

3191: /*IF (p_krpv_rec.parameter_type_code = 'ACTUAL') THEN
3192: IF (p_krpv_rec.Conversion_Type_Code = OKC_API.G_MISS_CHAR OR
3193: p_krpv_rec.Conversion_Type_Code IS NULL)
3194: THEN
3195: OKC_API.set_message(OKL_API.G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN,
3196: 'Conversion Type Code');
3197: l_return_status := OKC_API.G_RET_STS_ERROR;
3198: IF (p_stack_messages = 'N') THEN
3199: RAISE violated_ref_integrity;

Line 3209: OKC_API.set_message(OKL_API.G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN,

3205: AND p_rev_rec_method = 'STREAMS') THEN
3206: IF (p_krpv_rec.Interest_Index_Id = OKC_API.G_MISS_NUM OR
3207: p_krpv_rec.Interest_Index_Id IS NULL)
3208: THEN
3209: OKC_API.set_message(OKL_API.G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN,
3210: 'Interest Index Id');
3211: l_return_status := OKC_API.G_RET_STS_ERROR;
3212: IF (p_stack_messages = 'N') THEN
3213: RAISE violated_ref_integrity;

Line 3221: OKC_API.set_message(OKL_API.G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN,

3217: -- Bug 4907390
3218: /*IF (p_krpv_rec.Base_Rate = OKC_API.G_MISS_NUM OR
3219: p_krpv_rec.Base_Rate IS NULL)
3220: THEN
3221: OKC_API.set_message(OKL_API.G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN,
3222: 'Base Rate');
3223: l_return_status := OKC_API.G_RET_STS_ERROR;
3224: IF (p_stack_messages = 'N') THEN
3225: RAISE violated_ref_integrity;

Line 3232: OKC_API.set_message(OKL_API.G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN,

3228:
3229: IF (p_krpv_rec.Interest_Start_Date = OKC_API.G_MISS_DATE OR
3230: p_krpv_rec.Interest_Start_Date IS NULL)
3231: THEN
3232: OKC_API.set_message(OKL_API.G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN,
3233: 'Interest Start Date');
3234: l_return_status := OKC_API.G_RET_STS_ERROR;
3235: IF (p_stack_messages = 'N') THEN
3236: RAISE violated_ref_integrity;

Line 3243: OKC_API.set_message(OKL_API.G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN,

3239:
3240: IF (p_krpv_rec.Adder_Rate = OKC_API.G_MISS_NUM OR
3241: p_krpv_rec.Adder_Rate IS NULL)
3242: THEN
3243: OKC_API.set_message(OKL_API.G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN,
3244: 'Adder Rate');
3245: l_return_status := OKC_API.G_RET_STS_ERROR;
3246: IF (p_stack_messages = 'N') THEN
3247: RAISE violated_ref_integrity;

Line 3254: OKC_API.set_message(OKL_API.G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN,

3250:
3251: IF (p_krpv_rec.Maximum_Rate = OKC_API.G_MISS_NUM OR
3252: p_krpv_rec.Maximum_Rate IS NULL)
3253: THEN
3254: OKC_API.set_message(OKL_API.G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN,
3255: 'Maximum Rate');
3256: l_return_status := OKC_API.G_RET_STS_ERROR;
3257: IF (p_stack_messages = 'N') THEN
3258: RAISE violated_ref_integrity;

Line 3265: OKC_API.set_message(OKL_API.G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN,

3261:
3262: IF (p_krpv_rec.Minimum_Rate = OKC_API.G_MISS_NUM OR
3263: p_krpv_rec.Minimum_Rate IS NULL)
3264: THEN
3265: OKC_API.set_message(OKL_API.G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN,
3266: 'Minimum Rate');
3267: l_return_status := OKC_API.G_RET_STS_ERROR;
3268: IF (p_stack_messages = 'N') THEN
3269: RAISE violated_ref_integrity;

Line 3276: OKC_API.set_message(OKL_API.G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN,

3272:
3273: IF (p_krpv_rec.Principal_Basis_Code = OKC_API.G_MISS_CHAR OR
3274: p_krpv_rec.Principal_Basis_Code IS NULL)
3275: THEN
3276: OKC_API.set_message(OKL_API.G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN,
3277: 'Principal Basis Code');
3278: l_return_status := OKC_API.G_RET_STS_ERROR;
3279: IF (p_stack_messages = 'N') THEN
3280: RAISE violated_ref_integrity;

Line 3287: OKL_API.SET_MESSAGE( p_app_name => OKL_API.G_APP_NAME

3283: p_krpv_rec.Principal_Basis_Code IS NOT NULL) THEN
3284: IF (p_krpv_rec.Principal_Basis_Code <> 'ACTUAL') THEN
3285: -- AKP: Todo: Set Proper Message
3286: --(Principal Basis Code is 'ACTUAL' allowed only)
3287: OKL_API.SET_MESSAGE( p_app_name => OKL_API.G_APP_NAME
3288: ,p_msg_name => 'OKL_LA_APPLICABLE_VALUES'
3289: ,p_token1 => 'VALUE'
3290: ,p_token1_value => 'ACTUAL'
3291: ,p_token2 => 'CODE0'

Line 3307: OKC_API.set_message(OKL_API.G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN,

3303:
3304: IF (p_krpv_rec.Days_In_A_Month_Code = OKC_API.G_MISS_CHAR OR
3305: p_krpv_rec.Days_In_A_Month_Code IS NULL)
3306: THEN
3307: OKC_API.set_message(OKL_API.G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN,
3308: 'Days In A Month Code');
3309: l_return_status := OKC_API.G_RET_STS_ERROR;
3310: IF (p_stack_messages = 'N') THEN
3311: RAISE violated_ref_integrity;

Line 3318: OKC_API.set_message(OKL_API.G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN,

3314:
3315: IF (p_krpv_rec.Days_In_A_Year_Code = OKC_API.G_MISS_CHAR OR
3316: p_krpv_rec.Days_In_A_Year_Code IS NULL)
3317: THEN
3318: OKC_API.set_message(OKL_API.G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN,
3319: 'Days In A Year Code');
3320: l_return_status := OKC_API.G_RET_STS_ERROR;
3321: IF (p_stack_messages = 'N') THEN
3322: RAISE violated_ref_integrity;

Line 3329: OKC_API.set_message(OKL_API.G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN,

3325:
3326: IF (p_krpv_rec.Interest_Basis_Code = OKC_API.G_MISS_CHAR OR
3327: p_krpv_rec.Interest_Basis_Code IS NULL)
3328: THEN
3329: OKC_API.set_message(OKL_API.G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN,
3330: 'Interest Basis Code');
3331: l_return_status := OKC_API.G_RET_STS_ERROR;
3332: IF (p_stack_messages = 'N') THEN
3333: RAISE violated_ref_integrity;

Line 3342: OKC_API.set_message(OKL_API.G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN,

3338: /*
3339: IF (p_krpv_rec.Rate_Delay_Code = OKC_API.G_MISS_CHAR OR
3340: p_krpv_rec.Rate_Delay_Code IS NULL)
3341: THEN
3342: OKC_API.set_message(OKL_API.G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN,
3343: 'Rate Delay Code');
3344: l_return_status := OKC_API.G_RET_STS_ERROR;
3345: IF (p_stack_messages = 'N') THEN
3346: RAISE violated_ref_integrity;

Line 3353: OKC_API.set_message(OKL_API.G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN,

3349:
3350: IF (p_krpv_rec.Rate_Delay_Frequency = OKC_API.G_MISS_NUM OR
3351: p_krpv_rec.Rate_Delay_Frequency IS NULL)
3352: THEN
3353: OKC_API.set_message(OKL_API.G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN,
3354: 'Rate Delay Frequency');
3355: l_return_status := OKC_API.G_RET_STS_ERROR;
3356: IF (p_stack_messages = 'N') THEN
3357: RAISE violated_ref_integrity;

Line 3367: OKC_API.set_message(OKL_API.G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN,

3363: /*IF (p_krpv_rec.Compounding_Frequency_Code = OKC_API.G_MISS_CHAR OR
3364: p_krpv_rec.Compounding_Frequency_Code IS NULL)
3365: THEN
3366: l_msg1_set := TRUE;
3367: OKC_API.set_message(OKL_API.G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN,
3368: 'Compounding Frequency Code');
3369: l_return_status := OKC_API.G_RET_STS_ERROR;
3370: IF (p_stack_messages = 'N') THEN
3371: RAISE violated_ref_integrity;

Line 3379: OKC_API.set_message(OKL_API.G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN,

3375: IF (p_krpv_rec.Calculation_Formula_Id = OKC_API.G_MISS_NUM OR
3376: p_krpv_rec.Calculation_Formula_Id IS NULL)
3377: THEN
3378: l_msg2_set := TRUE;
3379: OKC_API.set_message(OKL_API.G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN,
3380: 'Formula Name');
3381: l_return_status := OKC_API.G_RET_STS_ERROR;
3382: IF (p_stack_messages = 'N') THEN
3383: RAISE violated_ref_integrity;

Line 3390: OKC_API.set_message(OKL_API.G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN,

3386:
3387: IF (p_krpv_rec.Catchup_Basis_Code = OKC_API.G_MISS_CHAR OR
3388: p_krpv_rec.Catchup_Basis_Code IS NULL)
3389: THEN
3390: OKC_API.set_message(OKL_API.G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN,
3391: 'Catchup Basis Code');
3392: l_return_status := OKC_API.G_RET_STS_ERROR;
3393: IF (p_stack_messages = 'N') THEN
3394: RAISE violated_ref_integrity;

Line 3401: OKL_API.SET_MESSAGE( p_app_name => OKL_API.G_APP_NAME

3397: p_krpv_rec.Catchup_Basis_Code IS NOT NULL) THEN
3398: IF (p_krpv_rec.Catchup_Basis_Code <> 'ACTUAL') THEN
3399: -- AKP: Todo: Set Proper Message
3400: --(Catchup Basis Code is 'ACTUAL' allowed only)
3401: OKL_API.SET_MESSAGE( p_app_name => OKL_API.G_APP_NAME
3402: ,p_msg_name => 'OKL_LA_APPLICABLE_VALUES'
3403: ,p_token1 => 'VALUE'
3404: ,p_token1_value => 'ACTUAL'
3405: ,p_token2 => 'CODE0'

Line 3421: OKC_API.set_message(OKL_API.G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN,

3417:
3418: IF (p_krpv_rec.Catchup_Start_Date = OKC_API.G_MISS_DATE OR
3419: p_krpv_rec.Catchup_Start_Date IS NULL)
3420: THEN
3421: OKC_API.set_message(OKL_API.G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN,
3422: 'Catchup Start Date');
3423: l_return_status := OKC_API.G_RET_STS_ERROR;
3424: IF (p_stack_messages = 'N') THEN
3425: RAISE violated_ref_integrity;

Line 3432: OKC_API.set_message(OKL_API.G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN,

3428:
3429: IF (p_krpv_rec.Catchup_Settlement_Code = OKC_API.G_MISS_CHAR OR
3430: p_krpv_rec.Catchup_Settlement_Code IS NULL)
3431: THEN
3432: OKC_API.set_message(OKL_API.G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN,
3433: 'Catchup Settlement Code');
3434: l_return_status := OKC_API.G_RET_STS_ERROR;
3435: IF (p_stack_messages = 'N') THEN
3436: RAISE violated_ref_integrity;

Line 3445: OKC_API.set_message(OKL_API.G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN,

3441: /*
3442: IF (p_krpv_rec.Rate_Change_Start_Date = OKC_API.G_MISS_DATE OR
3443: p_krpv_rec.Rate_Change_Start_Date IS NULL)
3444: THEN
3445: OKC_API.set_message(OKL_API.G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN,
3446: 'Rate Change Start Date');
3447: l_return_status := OKC_API.G_RET_STS_ERROR;
3448: IF (p_stack_messages = 'N') THEN
3449: RAISE violated_ref_integrity;

Line 3456: OKC_API.set_message(OKL_API.G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN,

3452:
3453: IF (p_krpv_rec.Rate_Change_Frequency_Code = OKC_API.G_MISS_CHAR OR
3454: p_krpv_rec.Rate_Change_Frequency_Code IS NULL)
3455: THEN
3456: OKC_API.set_message(OKL_API.G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN,
3457: 'Rate Change Frequency Code');
3458: l_return_status := OKC_API.G_RET_STS_ERROR;
3459: IF (p_stack_messages = 'N') THEN
3460: RAISE violated_ref_integrity;

Line 3467: OKC_API.set_message(OKL_API.G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN,

3463:
3464: IF (p_krpv_rec.Rate_Change_Value = OKC_API.G_MISS_NUM OR
3465: p_krpv_rec.Rate_Change_Value IS NULL)
3466: THEN
3467: OKC_API.set_message(OKL_API.G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN,
3468: 'Rate Change Value');
3469: l_return_status := OKC_API.G_RET_STS_ERROR;
3470: IF (p_stack_messages = 'N') THEN
3471: RAISE violated_ref_integrity;

Line 3480: OKC_API.set_message(OKL_API.G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN,

3476: /*IF (p_krpv_rec.parameter_type_code = 'ACTUAL') THEN
3477: IF (p_krpv_rec.Conversion_Option_Code = OKC_API.G_MISS_CHAR OR
3478: p_krpv_rec.Conversion_Option_Code IS NULL)
3479: THEN
3480: OKC_API.set_message(OKL_API.G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN,
3481: 'Conversion Option Code');
3482: l_return_status := OKC_API.G_RET_STS_ERROR;
3483: IF (p_stack_messages = 'N') THEN
3484: RAISE violated_ref_integrity;

Line 3493: OKC_API.set_message(OKL_API.G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN,

3489: /*IF (p_krpv_rec.parameter_type_code = 'ACTUAL') THEN
3490: IF (p_krpv_rec.Next_Conversion_Date = OKC_API.G_MISS_DATE OR
3491: p_krpv_rec.Next_Conversion_Date IS NULL)
3492: THEN
3493: OKC_API.set_message(OKL_API.G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN,
3494: 'Next Conversion Date');
3495: l_return_status := OKC_API.G_RET_STS_ERROR;
3496: IF (p_stack_messages = 'N') THEN
3497: RAISE violated_ref_integrity;

Line 3506: OKC_API.set_message(OKL_API.G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN,

3502: /*IF (p_krpv_rec.parameter_type_code = 'ACTUAL') THEN
3503: IF (p_krpv_rec.Conversion_Type_Code = OKC_API.G_MISS_CHAR OR
3504: p_krpv_rec.Conversion_Type_Code IS NULL)
3505: THEN
3506: OKC_API.set_message(OKL_API.G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN,
3507: 'Conversion Type Code');
3508: l_return_status := OKC_API.G_RET_STS_ERROR;
3509: IF (p_stack_messages = 'N') THEN
3510: RAISE violated_ref_integrity;

Line 3524: OKC_API.set_message(OKL_API.G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN,

3520: p_rev_rec_method IN ('ESTIMATED_AND_BILLED', 'ACTUAL')) THEN
3521: IF (p_krpv_rec.Interest_Index_Id = OKC_API.G_MISS_NUM OR
3522: p_krpv_rec.Interest_Index_Id IS NULL)
3523: THEN
3524: OKC_API.set_message(OKL_API.G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN,
3525: 'Interest Index Id');
3526: l_return_status := OKC_API.G_RET_STS_ERROR;
3527: IF (p_stack_messages = 'N') THEN
3528: RAISE violated_ref_integrity;

Line 3536: OKC_API.set_message(OKL_API.G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN,

3532: -- Bug 4907390
3533: /*IF (p_krpv_rec.Base_Rate = OKC_API.G_MISS_NUM OR
3534: p_krpv_rec.Base_Rate IS NULL)
3535: THEN
3536: OKC_API.set_message(OKL_API.G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN,
3537: 'Base Rate');
3538: l_return_status := OKC_API.G_RET_STS_ERROR;
3539: IF (p_stack_messages = 'N') THEN
3540: RAISE violated_ref_integrity;

Line 3547: OKC_API.set_message(OKL_API.G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN,

3543:
3544: IF (p_krpv_rec.Interest_Start_Date = OKC_API.G_MISS_DATE OR
3545: p_krpv_rec.Interest_Start_Date IS NULL)
3546: THEN
3547: OKC_API.set_message(OKL_API.G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN,
3548: 'Interest Start Date');
3549: l_return_status := OKC_API.G_RET_STS_ERROR;
3550: IF (p_stack_messages = 'N') THEN
3551: RAISE violated_ref_integrity;

Line 3558: OKC_API.set_message(OKL_API.G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN,

3554:
3555: IF (p_krpv_rec.Adder_Rate = OKC_API.G_MISS_NUM OR
3556: p_krpv_rec.Adder_Rate IS NULL)
3557: THEN
3558: OKC_API.set_message(OKL_API.G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN,
3559: 'Adder Rate');
3560: l_return_status := OKC_API.G_RET_STS_ERROR;
3561: IF (p_stack_messages = 'N') THEN
3562: RAISE violated_ref_integrity;

Line 3569: OKC_API.set_message(OKL_API.G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN,

3565:
3566: IF (p_krpv_rec.Maximum_Rate = OKC_API.G_MISS_NUM OR
3567: p_krpv_rec.Maximum_Rate IS NULL)
3568: THEN
3569: OKC_API.set_message(OKL_API.G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN,
3570: 'Maximum Rate');
3571: l_return_status := OKC_API.G_RET_STS_ERROR;
3572: IF (p_stack_messages = 'N') THEN
3573: RAISE violated_ref_integrity;

Line 3580: OKC_API.set_message(OKL_API.G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN,

3576:
3577: IF (p_krpv_rec.Minimum_Rate = OKC_API.G_MISS_NUM OR
3578: p_krpv_rec.Minimum_Rate IS NULL)
3579: THEN
3580: OKC_API.set_message(OKL_API.G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN,
3581: 'Minimum Rate');
3582: l_return_status := OKC_API.G_RET_STS_ERROR;
3583: IF (p_stack_messages = 'N') THEN
3584: RAISE violated_ref_integrity;

Line 3591: OKC_API.set_message(OKL_API.G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN,

3587:
3588: IF (p_krpv_rec.Principal_Basis_Code = OKC_API.G_MISS_CHAR OR
3589: p_krpv_rec.Principal_Basis_Code IS NULL)
3590: THEN
3591: OKC_API.set_message(OKL_API.G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN,
3592: 'Principal Basis Code');
3593: l_return_status := OKC_API.G_RET_STS_ERROR;
3594: IF (p_stack_messages = 'N') THEN
3595: RAISE violated_ref_integrity;

Line 3602: OKL_API.SET_MESSAGE( p_app_name => OKL_API.G_APP_NAME

3598: p_krpv_rec.Principal_Basis_Code IS NOT NULL) THEN
3599: IF (p_krpv_rec.Principal_Basis_Code <> 'ACTUAL') THEN
3600: -- AKP: Todo: Set Proper Message
3601: --(Principal Basis Code is 'ACTUAL' allowed only)
3602: OKL_API.SET_MESSAGE( p_app_name => OKL_API.G_APP_NAME
3603: ,p_msg_name => 'OKL_LA_APPLICABLE_VALUES'
3604: ,p_token1 => 'VALUE'
3605: ,p_token1_value => 'ACTUAL'
3606: ,p_token2 => 'CODE0'

Line 3622: OKC_API.set_message(OKL_API.G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN,

3618:
3619: IF (p_krpv_rec.Days_In_A_Month_Code = OKC_API.G_MISS_CHAR OR
3620: p_krpv_rec.Days_In_A_Month_Code IS NULL)
3621: THEN
3622: OKC_API.set_message(OKL_API.G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN,
3623: 'Days In A Month Code');
3624: l_return_status := OKC_API.G_RET_STS_ERROR;
3625: IF (p_stack_messages = 'N') THEN
3626: RAISE violated_ref_integrity;

Line 3633: OKC_API.set_message(OKL_API.G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN,

3629:
3630: IF (p_krpv_rec.Days_In_A_Year_Code = OKC_API.G_MISS_CHAR OR
3631: p_krpv_rec.Days_In_A_Year_Code IS NULL)
3632: THEN
3633: OKC_API.set_message(OKL_API.G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN,
3634: 'Days In A Year Code');
3635: l_return_status := OKC_API.G_RET_STS_ERROR;
3636: IF (p_stack_messages = 'N') THEN
3637: RAISE violated_ref_integrity;

Line 3644: OKC_API.set_message(OKL_API.G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN,

3640:
3641: IF (p_krpv_rec.Interest_Basis_Code = OKC_API.G_MISS_CHAR OR
3642: p_krpv_rec.Interest_Basis_Code IS NULL)
3643: THEN
3644: OKC_API.set_message(OKL_API.G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN,
3645: 'Interest Basis Code');
3646: l_return_status := OKC_API.G_RET_STS_ERROR;
3647: IF (p_stack_messages = 'N') THEN
3648: RAISE violated_ref_integrity;

Line 3657: OKC_API.set_message(OKL_API.G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN,

3653: /*
3654: IF (p_krpv_rec.Rate_Delay_Code = OKC_API.G_MISS_CHAR OR
3655: p_krpv_rec.Rate_Delay_Code IS NULL)
3656: THEN
3657: OKC_API.set_message(OKL_API.G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN,
3658: 'Rate Delay Code');
3659: l_return_status := OKC_API.G_RET_STS_ERROR;
3660: IF (p_stack_messages = 'N') THEN
3661: RAISE violated_ref_integrity;

Line 3668: OKC_API.set_message(OKL_API.G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN,

3664:
3665: IF (p_krpv_rec.Rate_Delay_Frequency = OKC_API.G_MISS_NUM OR
3666: p_krpv_rec.Rate_Delay_Frequency IS NULL)
3667: THEN
3668: OKC_API.set_message(OKL_API.G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN,
3669: 'Rate Delay Frequency');
3670: l_return_status := OKC_API.G_RET_STS_ERROR;
3671: IF (p_stack_messages = 'N') THEN
3672: RAISE violated_ref_integrity;

Line 3682: OKC_API.set_message(OKL_API.G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN,

3678: /*IF (p_krpv_rec.Compounding_Frequency_Code = OKC_API.G_MISS_CHAR OR
3679: p_krpv_rec.Compounding_Frequency_Code IS NULL)
3680: THEN
3681: l_msg1_set := TRUE;
3682: OKC_API.set_message(OKL_API.G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN,
3683: 'Compounding Frequency Code');
3684: l_return_status := OKC_API.G_RET_STS_ERROR;
3685: IF (p_stack_messages = 'N') THEN
3686: RAISE violated_ref_integrity;

Line 3694: OKC_API.set_message(OKL_API.G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN,

3690: IF (p_krpv_rec.Calculation_Formula_Id = OKC_API.G_MISS_NUM OR
3691: p_krpv_rec.Calculation_Formula_Id IS NULL)
3692: THEN
3693: l_msg2_set := TRUE;
3694: OKC_API.set_message(OKL_API.G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN,
3695: 'Formula Name');
3696: l_return_status := OKC_API.G_RET_STS_ERROR;
3697: IF (p_stack_messages = 'N') THEN
3698: RAISE violated_ref_integrity;

Line 3707: OKC_API.set_message(OKL_API.G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN,

3703: /*
3704: IF (p_krpv_rec.Rate_Change_Start_Date = OKC_API.G_MISS_DATE OR
3705: p_krpv_rec.Rate_Change_Start_Date IS NULL)
3706: THEN
3707: OKC_API.set_message(OKL_API.G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN,
3708: 'Rate Change Start Date');
3709: l_return_status := OKC_API.G_RET_STS_ERROR;
3710: IF (p_stack_messages = 'N') THEN
3711: RAISE violated_ref_integrity;

Line 3718: OKC_API.set_message(OKL_API.G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN,

3714:
3715: IF (p_krpv_rec.Rate_Change_Frequency_Code = OKC_API.G_MISS_CHAR OR
3716: p_krpv_rec.Rate_Change_Frequency_Code IS NULL)
3717: THEN
3718: OKC_API.set_message(OKL_API.G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN,
3719: 'Rate Change Frequency Code');
3720: l_return_status := OKC_API.G_RET_STS_ERROR;
3721: IF (p_stack_messages = 'N') THEN
3722: RAISE violated_ref_integrity;

Line 3729: OKC_API.set_message(OKL_API.G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN,

3725:
3726: IF (p_krpv_rec.Rate_Change_Value = OKC_API.G_MISS_NUM OR
3727: p_krpv_rec.Rate_Change_Value IS NULL)
3728: THEN
3729: OKC_API.set_message(OKL_API.G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN,
3730: 'Rate Change Value');
3731: l_return_status := OKC_API.G_RET_STS_ERROR;
3732: IF (p_stack_messages = 'N') THEN
3733: RAISE violated_ref_integrity;

Line 3741: OKC_API.set_message(OKL_API.G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN,

3737:
3738: /*IF (p_krpv_rec.Conversion_Option_Code = OKC_API.G_MISS_CHAR OR
3739: p_krpv_rec.Conversion_Option_Code IS NULL)
3740: THEN
3741: OKC_API.set_message(OKL_API.G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN,
3742: 'Conversion Option Code');
3743: l_return_status := OKC_API.G_RET_STS_ERROR;
3744: IF (p_stack_messages = 'N') THEN
3745: RAISE violated_ref_integrity;

Line 3752: OKC_API.set_message(OKL_API.G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN,

3748:
3749: /*IF (p_krpv_rec.Next_Conversion_Date = OKC_API.G_MISS_DATE OR
3750: p_krpv_rec.Next_Conversion_Date IS NULL)
3751: THEN
3752: OKC_API.set_message(OKL_API.G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN,
3753: 'Next Conversion Date');
3754: l_return_status := OKC_API.G_RET_STS_ERROR;
3755: IF (p_stack_messages = 'N') THEN
3756: RAISE violated_ref_integrity;

Line 3763: OKC_API.set_message(OKL_API.G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN,

3759:
3760: /*IF (p_krpv_rec.Conversion_Type_Code = OKC_API.G_MISS_CHAR OR
3761: p_krpv_rec.Conversion_Type_Code IS NULL)
3762: THEN
3763: OKC_API.set_message(OKL_API.G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN,
3764: 'Conversion Type Code');
3765: l_return_status := OKC_API.G_RET_STS_ERROR;
3766: IF (p_stack_messages = 'N') THEN
3767: RAISE violated_ref_integrity;

Line 3786: OKC_API.set_message(OKL_API.G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN,

3782: IF (p_krpv_rec.Compounding_Frequency_Code = OKC_API.G_MISS_CHAR OR
3783: p_krpv_rec.Compounding_Frequency_Code IS NULL)
3784: THEN
3785: l_msg1_set := TRUE;
3786: OKC_API.set_message(OKL_API.G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN,
3787: 'Compounding Frequency Code');
3788: l_return_status := OKC_API.G_RET_STS_ERROR;
3789: IF (p_stack_messages = 'N') THEN
3790: RAISE violated_ref_integrity;

Line 3800: OKC_API.set_message(OKL_API.G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN,

3796: IF (p_krpv_rec.Calculation_Formula_Id = OKC_API.G_MISS_NUM OR
3797: p_krpv_rec.Calculation_Formula_Id IS NULL)
3798: THEN
3799: l_msg2_set := TRUE;
3800: OKC_API.set_message(OKL_API.G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN,
3801: 'Formula Name');
3802: l_return_status := OKC_API.G_RET_STS_ERROR;
3803: IF (p_stack_messages = 'N') THEN
3804: RAISE violated_ref_integrity;

Line 3813: IF (l_return_status <> OKL_API.G_RET_STS_SUCCESS) AND

3809: END IF;
3810:
3811: END IF;
3812:
3813: IF (l_return_status <> OKL_API.G_RET_STS_SUCCESS) AND
3814: (p_stack_messages = 'N') THEN
3815: RAISE violated_ref_integrity;
3816: END IF;
3817:

Line 3825: l_return_status := OKL_API.G_RET_STS_ERROR;

3821: RETURN (l_return_status);
3822:
3823: EXCEPTION
3824: WHEN violated_ref_integrity THEN
3825: l_return_status := OKL_API.G_RET_STS_ERROR;
3826: RETURN (l_return_status);
3827: END Validate_Record;
3828:
3829: ---------------------------------------------------------------------------