APPS.OKL_CAT_PVT dependencies on OKC_API

Line 517: IF (p_catv_rec.start_date = OKC_API.G_MISS_DATE OR

513: x_return_status OUT NOCOPY VARCHAR2,
514: p_catv_rec IN catv_rec_type) AS
515: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
516: BEGIN
517: IF (p_catv_rec.start_date = OKC_API.G_MISS_DATE OR
518: p_catv_rec.start_date IS NULL)
519: THEN
520: OKL_API.set_message(G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN, 'start_date');
521: l_return_status := OKC_API.G_RET_STS_ERROR;

Line 521: l_return_status := OKC_API.G_RET_STS_ERROR;

517: IF (p_catv_rec.start_date = OKC_API.G_MISS_DATE OR
518: p_catv_rec.start_date IS NULL)
519: THEN
520: OKL_API.set_message(G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN, 'start_date');
521: l_return_status := OKC_API.G_RET_STS_ERROR;
522: END IF;
523:
524: x_return_status := l_return_status;
525: EXCEPTION

Line 1044: IF (x_return_status <> Okc_Api.G_RET_STS_SUCCESS) THEN

1040:
1041: Validate_Amt_Tol_Percent(x_return_status => x_return_status,
1042: p_catv_rec => p_catv_rec);
1043:
1044: IF (x_return_status <> Okc_Api.G_RET_STS_SUCCESS) THEN
1045: IF (x_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
1046: -- need to exit
1047: l_return_status := x_return_status;
1048: RAISE G_EXCEPTION_HALT_VALIDATION;

Line 1045: IF (x_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN

1041: Validate_Amt_Tol_Percent(x_return_status => x_return_status,
1042: p_catv_rec => p_catv_rec);
1043:
1044: IF (x_return_status <> Okc_Api.G_RET_STS_SUCCESS) THEN
1045: IF (x_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
1046: -- need to exit
1047: l_return_status := x_return_status;
1048: RAISE G_EXCEPTION_HALT_VALIDATION;
1049: ELSE

Line 1059: IF (x_return_status <> Okc_Api.G_RET_STS_SUCCESS) THEN

1055: Validate_days_pst_code_val_tol(x_return_status => x_return_status,
1056: p_catv_rec => p_catv_rec);
1057:
1058:
1059: IF (x_return_status <> Okc_Api.G_RET_STS_SUCCESS) THEN
1060: IF (x_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
1061: -- need to exit
1062: l_return_status := x_return_status;
1063: RAISE G_EXCEPTION_HALT_VALIDATION;

Line 1060: IF (x_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN

1056: p_catv_rec => p_catv_rec);
1057:
1058:
1059: IF (x_return_status <> Okc_Api.G_RET_STS_SUCCESS) THEN
1060: IF (x_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
1061: -- need to exit
1062: l_return_status := x_return_status;
1063: RAISE G_EXCEPTION_HALT_VALIDATION;
1064: ELSE

Line 1073: IF (x_return_status <> Okc_Api.G_RET_STS_SUCCESS) THEN

1069:
1070:
1071: Validate_mnths_bill_ahead(x_return_status => x_return_status,
1072: p_catv_rec => p_catv_rec);
1073: IF (x_return_status <> Okc_Api.G_RET_STS_SUCCESS) THEN
1074: IF (x_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
1075: -- need to exit
1076: l_return_status := x_return_status;
1077: RAISE G_EXCEPTION_HALT_VALIDATION;

Line 1074: IF (x_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN

1070:
1071: Validate_mnths_bill_ahead(x_return_status => x_return_status,
1072: p_catv_rec => p_catv_rec);
1073: IF (x_return_status <> Okc_Api.G_RET_STS_SUCCESS) THEN
1074: IF (x_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
1075: -- need to exit
1076: l_return_status := x_return_status;
1077: RAISE G_EXCEPTION_HALT_VALIDATION;
1078: ELSE

Line 1109: Okc_Api.SET_MESSAGE(p_app_name => g_app_name,

1105: RETURN (l_return_status);
1106:
1107: WHEN OTHERS THEN
1108: -- store SQL error message on message stack for caller
1109: Okc_Api.SET_MESSAGE(p_app_name => g_app_name,
1110: p_msg_name => g_unexpected_error,
1111: p_token1 => g_sqlcode_token,
1112: p_token1_value => SQLCODE,
1113: p_token2 => g_sqlerrm_token,

Line 1116: l_return_status := Okc_Api.G_RET_STS_UNEXP_ERROR;

1112: p_token1_value => SQLCODE,
1113: p_token2 => g_sqlerrm_token,
1114: p_token2_value => SQLERRM);
1115: -- notify caller of an UNEXPECTED error
1116: l_return_status := Okc_Api.G_RET_STS_UNEXP_ERROR;
1117: RETURN(l_return_status);
1118:
1119: END Validate_Attributes;
1120:

Line 2270: IF x_return_status <> Okc_Api.G_RET_STS_SUCCESS THEN

2266: x_msg_data => x_msg_data,
2267: p_catv_rec => p_catv_tbl(i));
2268: -- Begin Post-Generation Change
2269: -- store the highest degree of error
2270: IF x_return_status <> Okc_Api.G_RET_STS_SUCCESS THEN
2271: IF l_overall_status <> Okc_Api.G_RET_STS_UNEXP_ERROR THEN
2272: l_overall_status := x_return_status;
2273: END IF;
2274: END IF;

Line 2271: IF l_overall_status <> Okc_Api.G_RET_STS_UNEXP_ERROR THEN

2267: p_catv_rec => p_catv_tbl(i));
2268: -- Begin Post-Generation Change
2269: -- store the highest degree of error
2270: IF x_return_status <> Okc_Api.G_RET_STS_SUCCESS THEN
2271: IF l_overall_status <> Okc_Api.G_RET_STS_UNEXP_ERROR THEN
2272: l_overall_status := x_return_status;
2273: END IF;
2274: END IF;
2275: -- End Post-Generation Change