APPS.OKL_TRQ_PVT dependencies on OKL_UTIL

Line 962: l_return_status := OKL_UTIL.check_lookup_code(G_STATUS_LOOKUP_TYPE,

958:
959: END IF;
960: --Hand coded this.
961: -- Enforce Foreign Key
962: l_return_status := OKL_UTIL.check_lookup_code(G_STATUS_LOOKUP_TYPE,
963: p_trqv_rec.request_status_code);
964: IF l_return_status <> x_return_status THEN
965: -- Notify Error
966: OKL_API.set_message(G_APP_NAME, G_NO_MATCHING_RECORD, G_COL_NAME_TOKEN, 'request_status_code');

Line 995: l_return_status := OKL_UTIL.check_lookup_code(G_APPLY_TO_CODE_LOOKUP_TYPE,

991: IF (p_trqv_rec.apply_to_code <> OKL_API.G_MISS_CHAR OR
992: p_trqv_rec.apply_to_code IS NOT NULL) THEN
993:
994: -- Enforce Foreign Key
995: l_return_status := OKL_UTIL.check_lookup_code(G_APPLY_TO_CODE_LOOKUP_TYPE,
996: p_trqv_rec.apply_to_code);
997: IF l_return_status <> x_return_status THEN
998: -- Notify Error
999: OKL_API.set_message(G_APP_NAME, G_NO_MATCHING_RECORD, G_COL_NAME_TOKEN, 'apply_to_code');

Line 1029: l_return_status := OKL_UTIL.check_lookup_code(G_ADJ_FREQ_CODE_LOOKUP_TYPE,

1025: IF (p_trqv_rec.adjustment_frequency_code <> OKL_API.G_MISS_CHAR OR
1026: p_trqv_rec.adjustment_frequency_code IS NOT NULL) THEN
1027:
1028: -- Enforce Foreign Key
1029: l_return_status := OKL_UTIL.check_lookup_code(G_ADJ_FREQ_CODE_LOOKUP_TYPE,
1030: p_trqv_rec.adjustment_frequency_code);
1031: IF l_return_status <> x_return_status THEN
1032: -- Notify Error
1033: OKL_API.set_message(G_APP_NAME, G_NO_MATCHING_RECORD, G_COL_NAME_TOKEN, 'adjustment_frequency_code');

Line 1063: l_return_status := OKL_UTIL.check_lookup_code(G_VAR_METHOD_CODE_LOOKUP_TYPE,

1059: IF (p_trqv_rec.variable_method_code <> OKL_API.G_MISS_CHAR OR
1060: p_trqv_rec.variable_method_code IS NOT NULL) THEN
1061:
1062: -- Enforce Foreign Key
1063: l_return_status := OKL_UTIL.check_lookup_code(G_VAR_METHOD_CODE_LOOKUP_TYPE,
1064: p_trqv_rec.variable_method_code);
1065: IF l_return_status <> x_return_status THEN
1066: -- Notify Error
1067: OKL_API.set_message(G_APP_NAME, G_NO_MATCHING_RECORD, G_COL_NAME_TOKEN, 'variable_method_code');

Line 1097: l_return_status := OKL_UTIL.check_lookup_code(G_INT_METHOD_CODE_LOOKUP_TYPE,

1093: IF (p_trqv_rec.interest_method_code <> OKL_API.G_MISS_CHAR OR
1094: p_trqv_rec.interest_method_code IS NOT NULL) THEN
1095:
1096: -- Enforce Foreign Key
1097: l_return_status := OKL_UTIL.check_lookup_code(G_INT_METHOD_CODE_LOOKUP_TYPE,
1098: p_trqv_rec.interest_method_code);
1099: IF l_return_status <> x_return_status THEN
1100: -- Notify Error
1101: OKL_API.set_message(G_APP_NAME, G_NO_MATCHING_RECORD, G_COL_NAME_TOKEN, 'interest_method_code');

Line 1132: l_return_status := OKL_UTIL.check_lookup_code(G_CALC_METHOD_CODE_LOOKUP_TYPE,

1128: IF (p_trqv_rec.method_of_calculation_code <> OKL_API.G_MISS_CHAR OR
1129: p_trqv_rec.method_of_calculation_code IS NOT NULL) THEN
1130:
1131: -- Enforce Foreign Key
1132: l_return_status := OKL_UTIL.check_lookup_code(G_CALC_METHOD_CODE_LOOKUP_TYPE,
1133: p_trqv_rec.method_of_calculation_code);
1134: IF l_return_status <> x_return_status THEN
1135: -- Notify Error
1136: OKL_API.set_message(G_APP_NAME, G_NO_MATCHING_RECORD, G_COL_NAME_TOKEN, 'method_of_calculation_code');

Line 1167: l_return_status := OKL_UTIL.check_lookup_code(G_PAY_FREQ_CODE_LOOKUP_TYPE,

1163: IF (p_trqv_rec.payment_frequency_code <> OKL_API.G_MISS_CHAR OR
1164: p_trqv_rec.payment_frequency_code IS NOT NULL) THEN
1165:
1166: -- Enforce Foreign Key
1167: l_return_status := OKL_UTIL.check_lookup_code(G_PAY_FREQ_CODE_LOOKUP_TYPE,
1168: p_trqv_rec.payment_frequency_code);
1169: IF l_return_status <> x_return_status THEN
1170: -- Notify Error
1171: OKL_API.set_message(G_APP_NAME, G_NO_MATCHING_RECORD, G_COL_NAME_TOKEN, 'payment_frequency_code');

Line 1204: -- check from currency values using the generic okl_util.validate_currency_code

1200: -- initialize return status
1201: x_return_status := OKL_API.G_RET_STS_SUCCESS;
1202: IF (p_trqv_rec.currency_code <> OKL_API.G_MISS_CHAR AND
1203: p_trqv_rec.currency_code IS NOT NULL) THEN
1204: -- check from currency values using the generic okl_util.validate_currency_code
1205: l_valid := OKL_ACCOUNTING_UTIL.validate_currency_code(p_trqv_rec.currency_code);
1206: IF l_valid <> OKL_API.G_TRUE THEN
1207: l_return_status := OKL_API.G_RET_STS_ERROR;
1208: END IF;

Line 1246: -- check from currency values using the generic okl_util.validate_currency_con_type

1242: -- initialize return status
1243: x_return_status := OKL_API.G_RET_STS_SUCCESS;
1244: IF (p_trqv_rec.currency_conversion_type <> OKL_API.G_MISS_CHAR AND
1245: p_trqv_rec.currency_conversion_type IS NOT NULL) THEN
1246: -- check from currency values using the generic okl_util.validate_currency_con_type
1247: l_valid := OKL_ACCOUNTING_UTIL.validate_currency_con_type(p_trqv_rec.currency_conversion_type);
1248: IF l_valid <> OKL_API.G_TRUE THEN
1249: l_return_status := OKL_API.G_RET_STS_ERROR;
1250: END IF;