DBA Data[Home] [Help]

APPS.OKL_QTE_PVT dependencies on OKL_UTIL

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

130:
131: -- halt further validation of this column
132: RAISE G_EXCEPTION_HALT_VALIDATION;
133: END IF;
134: -- check from currency values using the generic okl_util.validate_currency_code
135: l_return_status := OKL_ACCOUNTING_UTIL.validate_currency_code(p_qtev_rec.currency_code);
136: IF (l_return_status <> OKC_API.G_TRUE) THEN
137: OKC_API.SET_MESSAGE(p_app_name => g_app_name,
138: p_msg_name => g_invalid_value,

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

180: ,p_token1_value => 'currency_conversion_code');
181: -- halt further validation of this column
182: RAISE G_EXCEPTION_HALT_VALIDATION;
183: END IF;
184: -- check from currency values using the generic okl_util.validate_currency_code
185: l_return_status := OKL_ACCOUNTING_UTIL.validate_currency_code(p_qtev_rec.currency_conversion_code);
186: IF (l_return_status <> OKC_API.G_TRUE) THEN
187: OKC_API.SET_MESSAGE(p_app_name => g_app_name,
188: p_msg_name => g_invalid_value,

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

223: -- initialize return status
224: x_return_status := OKC_API.G_RET_STS_SUCCESS;
225: IF (p_qtev_rec.currency_conversion_type <> OKL_API.G_MISS_CHAR AND
226: p_qtev_rec.currency_conversion_type IS NOT NULL) THEN
227: -- check from currency values using the generic okl_util.validate_currency_code
228: l_return_status := OKL_ACCOUNTING_UTIL.validate_currency_con_type(p_qtev_rec.currency_conversion_type);
229: IF (l_return_status <> OKC_API.G_TRUE) THEN
230: OKC_API.SET_MESSAGE(p_app_name => g_app_name,
231: p_msg_name => g_invalid_value,

Line 529: x_return_status := OKL_UTIL.check_lookup_code(

525: -- halt further validation of this column
526: RAISE G_EXCEPTION_HALT_VALIDATION;
527: END IF;
528:
529: x_return_status := OKL_UTIL.check_lookup_code(
530: p_lookup_type => 'OKL_QUOTE_REASON'
531: ,p_lookup_code => p_qtev_rec.qrs_code);
532:
533: IF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN

Line 596: x_return_status := OKL_UTIL.check_lookup_code(

592: -- halt further validation of this column
593: RAISE G_EXCEPTION_HALT_VALIDATION;
594: END IF;
595:
596: x_return_status := OKL_UTIL.check_lookup_code(
597: p_lookup_type => 'OKL_QUOTE_STATUS'
598: ,p_lookup_code => p_qtev_rec.qst_code);
599:
600: IF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN

Line 663: x_return_status := OKL_UTIL.check_lookup_code(

659: -- halt further validation of this column
660: RAISE G_EXCEPTION_HALT_VALIDATION;
661: END IF;
662:
663: x_return_status := OKL_UTIL.check_lookup_code(
664: p_lookup_type => 'OKL_QUOTE_TYPE'
665: ,p_lookup_code => p_qtev_rec.qtp_code);
666:
667: IF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN

Line 718: x_return_status := OKL_UTIL.check_lookup_code(

714: -- data is not required
715: IF (p_qtev_rec.trn_code IS NOT NULL) AND
716: (p_qtev_rec.trn_code <> OKC_API.G_MISS_CHAR) THEN
717:
718: x_return_status := OKL_UTIL.check_lookup_code(
719: p_lookup_type => 'OKC_TERMINATION_REASON'
720: ,p_lookup_code => p_qtev_rec.trn_code);
721:
722: IF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN

Line 774: x_return_status := OKL_UTIL.check_lookup_code(

770:
771: IF (p_qtev_rec.pop_code_end IS NOT NULL) AND
772: (p_qtev_rec.pop_code_end <> OKC_API.G_MISS_CHAR) THEN
773:
774: x_return_status := OKL_UTIL.check_lookup_code(
775: p_lookup_type => 'OKL_EOT_OPTION'
776: ,p_lookup_code => p_qtev_rec.pop_code_end);
777:
778: IF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN

Line 830: x_return_status := OKL_UTIL.check_lookup_code(

826:
827: IF (p_qtev_rec.pop_code_early IS NOT NULL) AND
828: (p_qtev_rec.pop_code_early <> OKC_API.G_MISS_CHAR) THEN
829:
830: x_return_status := OKL_UTIL.check_lookup_code(
831: p_lookup_type => 'OKL_PURCHASE_OPTION'
832: ,p_lookup_code => p_qtev_rec.pop_code_early);
833:
834: IF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN

Line 1118: x_return_status := OKL_UTIL.check_domain_yn(

1114: -- halt further validation of this column
1115: RAISE G_EXCEPTION_HALT_VALIDATION;
1116: END IF;
1117:
1118: x_return_status := OKL_UTIL.check_domain_yn(
1119: p_col_value => p_qtev_rec.early_termination_yn);
1120:
1121: IF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1122: OKC_API.SET_MESSAGE(p_app_name => G_APP_NAME,

Line 1184: x_return_status := OKL_UTIL.check_domain_yn(

1180: -- halt further validation of this column
1181: RAISE G_EXCEPTION_HALT_VALIDATION;
1182: END IF;
1183:
1184: x_return_status := OKL_UTIL.check_domain_yn(
1185: p_col_value => p_qtev_rec.partial_yn);
1186:
1187: IF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1188: OKC_API.SET_MESSAGE(p_app_name => G_APP_NAME,

Line 1250: x_return_status := OKL_UTIL.check_domain_yn(

1246: -- halt further validation of this column
1247: RAISE G_EXCEPTION_HALT_VALIDATION;
1248: END IF;
1249:
1250: x_return_status := OKL_UTIL.check_domain_yn(
1251: p_col_value => p_qtev_rec.preproceeds_yn);
1252:
1253: IF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1254: OKC_API.SET_MESSAGE(p_app_name => G_APP_NAME,

Line 1474: x_return_status := OKL_UTIL.check_domain_yn(

1470: -- halt further validation of this column
1471: RAISE G_EXCEPTION_HALT_VALIDATION;
1472: END IF;
1473:
1474: x_return_status := OKL_UTIL.check_domain_yn(
1475: p_col_value => p_qtev_rec.summary_format_yn);
1476:
1477: IF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1478: OKC_API.SET_MESSAGE(p_app_name => G_APP_NAME,

Line 1532: x_return_status := OKL_UTIL.check_domain_yn(

1528: -- halt further validation of this column
1529: RAISE G_EXCEPTION_HALT_VALIDATION;
1530: END IF;
1531:
1532: x_return_status := OKL_UTIL.check_domain_yn(
1533: p_col_value => p_qtev_rec.consolidated_yn);
1534:
1535: IF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1536: OKC_API.SET_MESSAGE(p_app_name => G_APP_NAME,

Line 2125: x_return_status := OKL_UTIL.check_domain_yn(

2121: -- halt further validation of this column
2122: RAISE G_EXCEPTION_HALT_VALIDATION;
2123: END IF;
2124:
2125: x_return_status := OKL_UTIL.check_domain_yn(
2126: p_col_value => p_qtev_rec.approved_yn);
2127:
2128: IF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
2129: OKC_API.SET_MESSAGE(p_app_name => G_APP_NAME,

Line 2183: x_return_status := OKL_UTIL.check_domain_yn(

2179: -- halt further validation of this column
2180: RAISE G_EXCEPTION_HALT_VALIDATION;
2181: END IF;
2182:
2183: x_return_status := OKL_UTIL.check_domain_yn(
2184: p_col_value => p_qtev_rec.accepted_yn);
2185:
2186: IF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
2187: OKC_API.SET_MESSAGE(p_app_name => G_APP_NAME,

Line 2241: x_return_status := OKL_UTIL.check_domain_yn(

2237: -- halt further validation of this column
2238: RAISE G_EXCEPTION_HALT_VALIDATION;
2239: END IF;
2240:
2241: x_return_status := OKL_UTIL.check_domain_yn(
2242: p_col_value => p_qtev_rec.payment_received_yn);
2243:
2244: IF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
2245: OKC_API.SET_MESSAGE(p_app_name => G_APP_NAME,

Line 2393: x_return_status := OKL_UTIL.check_org_id(p_org_id => p_qtev_rec.org_id);

2389:
2390: IF (p_qtev_rec.org_id IS NOT NULL) AND
2391: (p_qtev_rec.org_id <> OKC_API.G_MISS_NUM) THEN
2392:
2393: x_return_status := OKL_UTIL.check_org_id(p_org_id => p_qtev_rec.org_id);
2394:
2395: IF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
2396: OKC_API.SET_MESSAGE(p_app_name => G_APP_NAME,
2397: p_msg_name => G_INVALID_VALUE,

Line 2677: l_return_status := OKL_UTIL.check_from_to_date_range(

2673: x_return_status := l_return_status;
2674: END IF;
2675: END IF;
2676:
2677: l_return_status := OKL_UTIL.check_from_to_date_range(
2678: p_from_date => p_qtev_rec.date_restructure_start
2679: ,p_to_date => p_qtev_rec.date_restructure_end);
2680:
2681: -- Log error message on the error-message-stack

Line 2814: x_return_status := OKL_UTIL.check_from_to_date_range(

2810: BEGIN
2811: -- initialize return status
2812: x_return_status := OKC_API.G_RET_STS_SUCCESS;
2813:
2814: x_return_status := OKL_UTIL.check_from_to_date_range(
2815: p_from_date => p_qtev_rec.date_effective_from
2816: ,p_to_date => p_qtev_rec.date_effective_to);
2817:
2818: IF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN