APPS.OKL_OPD_PVT dependencies on OKL_API

Line 637: l_row_found VARCHAR2(1) := OKL_API.G_TRUE;

633: ) IS
634:
635: l_dummy VARCHAR2(1) := '?';
636: -- l_row_not_found BOOLEAN := FALSE;
637: l_row_found VARCHAR2(1) := OKL_API.G_TRUE;
638:
639: -- Cursor For OKL_OPD_FCL_FK;
640: /*
641: CURSOR okl_fclv_code_csr (p_code IN OKL_OPERANDS_V.opd_type%TYPE) IS

Line 668: IF (l_row_found = OKL_API.G_FALSE) THEN

664: CLOSE okl_fclv_code_csr;
665: */
666: l_row_found := OKL_ACCOUNTING_UTIL.validate_lookup_code('OKL_OPERAND_TYPE', p_opdv_rec.opd_type);
667:
668: IF (l_row_found = OKL_API.G_FALSE) THEN
669: Okc_Api.set_message(G_APP_NAME,G_INVALID_VALUE,G_COL_NAME_TOKEN,'opd_type');
670: x_return_status := Okc_Api.G_RET_STS_ERROR;
671: END IF;
672:

Line 675: IF p_opdv_rec.opd_type = G_FUNCTION_TYPE AND (p_opdv_rec.dsf_id = OKL_API.G_MISS_NUM OR

671: END IF;
672:
673: -- RPOONUGA002: Added this check to validate the values in opd_type and its
674: -- attached fields(dsf_id, fma_id, source)
675: IF p_opdv_rec.opd_type = G_FUNCTION_TYPE AND (p_opdv_rec.dsf_id = OKL_API.G_MISS_NUM OR
676: p_opdv_rec.dsf_id IS NULL)
677: THEN
678: OKL_API.SET_MESSAGE(p_app_name => 'OKL',
679: p_msg_name => G_MISS_DATA,

Line 678: OKL_API.SET_MESSAGE(p_app_name => 'OKL',

674: -- attached fields(dsf_id, fma_id, source)
675: IF p_opdv_rec.opd_type = G_FUNCTION_TYPE AND (p_opdv_rec.dsf_id = OKL_API.G_MISS_NUM OR
676: p_opdv_rec.dsf_id IS NULL)
677: THEN
678: OKL_API.SET_MESSAGE(p_app_name => 'OKL',
679: p_msg_name => G_MISS_DATA,
680: p_token1 => G_COL_NAME_TOKEN,
681: p_token1_value => 'DSF_ID');
682: x_return_status := Okc_Api.G_RET_STS_ERROR;

Line 686: IF p_opdv_rec.opd_type = G_FORMULA_TYPE AND (p_opdv_rec.fma_id = OKL_API.G_MISS_NUM OR

682: x_return_status := Okc_Api.G_RET_STS_ERROR;
683: RAISE G_EXCEPTION_HALT_VALIDATION;
684: END IF;
685:
686: IF p_opdv_rec.opd_type = G_FORMULA_TYPE AND (p_opdv_rec.fma_id = OKL_API.G_MISS_NUM OR
687: p_opdv_rec.fma_id IS NULL)
688: THEN
689: OKL_API.SET_MESSAGE(p_app_name => 'OKL',
690: p_msg_name => G_MISS_DATA,

Line 689: OKL_API.SET_MESSAGE(p_app_name => 'OKL',

685:
686: IF p_opdv_rec.opd_type = G_FORMULA_TYPE AND (p_opdv_rec.fma_id = OKL_API.G_MISS_NUM OR
687: p_opdv_rec.fma_id IS NULL)
688: THEN
689: OKL_API.SET_MESSAGE(p_app_name => 'OKL',
690: p_msg_name => G_MISS_DATA,
691: p_token1 => G_COL_NAME_TOKEN,
692: p_token1_value => 'FMA_ID');
693: x_return_status := Okc_Api.G_RET_STS_ERROR;

Line 697: IF p_opdv_rec.opd_type = G_CONSTANT_TYPE AND (p_opdv_rec.source = OKL_API.G_MISS_CHAR OR

693: x_return_status := Okc_Api.G_RET_STS_ERROR;
694: RAISE G_EXCEPTION_HALT_VALIDATION;
695: END IF;
696:
697: IF p_opdv_rec.opd_type = G_CONSTANT_TYPE AND (p_opdv_rec.source = OKL_API.G_MISS_CHAR OR
698: p_opdv_rec.source IS NULL)
699: THEN
700: OKL_API.SET_MESSAGE(p_app_name => 'OKL',
701: p_msg_name => G_MISS_DATA,

Line 700: OKL_API.SET_MESSAGE(p_app_name => 'OKL',

696:
697: IF p_opdv_rec.opd_type = G_CONSTANT_TYPE AND (p_opdv_rec.source = OKL_API.G_MISS_CHAR OR
698: p_opdv_rec.source IS NULL)
699: THEN
700: OKL_API.SET_MESSAGE(p_app_name => 'OKL',
701: p_msg_name => G_MISS_DATA,
702: p_token1 => G_COL_NAME_TOKEN,
703: p_token1_value => 'SOURCE');
704: x_return_status := Okc_Api.G_RET_STS_ERROR;

Line 1089: x_return_status := Okl_Api.G_RET_STS_SUCCESS;

1085: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
1086:
1087: BEGIN
1088: -- initialize return status
1089: x_return_status := Okl_Api.G_RET_STS_SUCCESS;
1090:
1091: -- check from domain values using the generic
1092: IF (p_opdv_rec.sfwt_flag IS NULL)OR (p_opdv_rec.sfwt_flag = OKC_API.G_MISS_CHAR) THEN
1093: l_return_status:=Okl_Api.G_RET_STS_ERROR;

Line 1093: l_return_status:=Okl_Api.G_RET_STS_ERROR;

1089: x_return_status := Okl_Api.G_RET_STS_SUCCESS;
1090:
1091: -- check from domain values using the generic
1092: IF (p_opdv_rec.sfwt_flag IS NULL)OR (p_opdv_rec.sfwt_flag = OKC_API.G_MISS_CHAR) THEN
1093: l_return_status:=Okl_Api.G_RET_STS_ERROR;
1094: ELSE
1095: IF UPPER(p_opdv_rec.sfwt_flag) NOT IN('Y','N') THEN
1096: l_return_status:=Okl_Api.G_RET_STS_ERROR;
1097: END IF;

Line 1096: l_return_status:=Okl_Api.G_RET_STS_ERROR;

1092: IF (p_opdv_rec.sfwt_flag IS NULL)OR (p_opdv_rec.sfwt_flag = OKC_API.G_MISS_CHAR) THEN
1093: l_return_status:=Okl_Api.G_RET_STS_ERROR;
1094: ELSE
1095: IF UPPER(p_opdv_rec.sfwt_flag) NOT IN('Y','N') THEN
1096: l_return_status:=Okl_Api.G_RET_STS_ERROR;
1097: END IF;
1098: END IF;
1099:
1100: IF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN

Line 3783: l_return_status varchar2(1) := okl_api.g_ret_sts_success;

3779: p_description IN VARCHAR2) IS
3780:
3781: l_api_version CONSTANT number := 1;
3782: l_api_name CONSTANT varchar2(30) := 'LOAD_SEED_ROW';
3783: l_return_status varchar2(1) := okl_api.g_ret_sts_success;
3784: l_msg_count number;
3785: l_msg_data varchar2(4000);
3786: l_init_msg_list VARCHAR2(1):= 'T';
3787: l_opdv_rec opdv_rec_type;