APPS.OKL_FPR_PVT dependencies on OKL_API

Line 653: l_return_status VARCHAR2(1) := OKL_API.G_TRUE;

649: x_return_status OUT NOCOPY VARCHAR2)
650: IS
651:
652: -- l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
653: l_return_status VARCHAR2(1) := OKL_API.G_TRUE;
654:
655: BEGIN
656: -- initialize return status
657: x_return_status := Okc_Api.G_RET_STS_SUCCESS;

Line 664: IF (l_return_status = OKL_API.G_FALSE) THEN

660: -- l_return_status := Okl_Util.check_domain_yn(p_fprv_rec.sfwt_flag);
661: l_return_status := OKL_ACCOUNTING_UTIL.validate_lookup_code('YES_NO',p_fprv_rec.sfwt_flag,0,0);
662:
663: -- IF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
664: IF (l_return_status = OKL_API.G_FALSE) THEN
665: Okc_Api.SET_MESSAGE(p_app_name => g_app_name,
666: p_msg_name => g_invalid_value,
667: p_token1 => g_col_name_token,
668: p_token1_value => 'sfwt_flag');

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

781: x_return_status OUT NOCOPY VARCHAR2
782: ) IS
783: l_dummy VARCHAR2(1) := '?';
784: -- l_row_not_found Boolean := False;
785: l_row_found VARCHAR2(1) := OKL_API.G_TRUE;
786:
787: -- Cursor For OKL_FMA_FYP_FK - Foreign Key Constraint
788: /*
789: CURSOR okl_fprv_fk_csr (p_code IN OKL_FNCTN_PRMTRS_V.fpr_type%TYPE) IS

Line 816: IF (l_row_found = OKL_API.G_FALSE) then

812: */
813:
814: l_row_found := OKL_ACCOUNTING_UTIL.validate_lookup_code('OKL_FUNCTION_PMR_TYPE',p_fprv_rec.fpr_type);
815: -- IF l_row_not_found then
816: IF (l_row_found = OKL_API.G_FALSE) then
817: OKC_API.set_message(G_APP_NAME,G_INVALID_VALUE,G_COL_NAME_TOKEN,'fpr_type');
818: x_return_status := OKC_API.G_RET_STS_ERROR;
819: END IF;
820:

Line 821: IF p_fprv_rec.fpr_type = G_STATIC_TYPE AND (p_fprv_rec.value = OKL_API.G_MISS_CHAR OR

817: OKC_API.set_message(G_APP_NAME,G_INVALID_VALUE,G_COL_NAME_TOKEN,'fpr_type');
818: x_return_status := OKC_API.G_RET_STS_ERROR;
819: END IF;
820:
821: IF p_fprv_rec.fpr_type = G_STATIC_TYPE AND (p_fprv_rec.value = OKL_API.G_MISS_CHAR OR
822: p_fprv_rec.value IS NULL)
823: THEN
824: OKL_API.SET_MESSAGE(p_app_name => G_APP_NAME,
825: p_msg_name => G_MISS_DATA,

Line 824: OKL_API.SET_MESSAGE(p_app_name => G_APP_NAME,

820:
821: IF p_fprv_rec.fpr_type = G_STATIC_TYPE AND (p_fprv_rec.value = OKL_API.G_MISS_CHAR OR
822: p_fprv_rec.value IS NULL)
823: THEN
824: OKL_API.SET_MESSAGE(p_app_name => G_APP_NAME,
825: p_msg_name => G_MISS_DATA,
826: p_token1 => G_COL_NAME_TOKEN,
827: p_token1_value => 'VALUE');
828: x_return_status := Okc_Api.G_RET_STS_ERROR;

Line 832: IF p_fprv_rec.fpr_type = G_CONTEXT_TYPE AND (p_fprv_rec.pmr_id = OKL_API.G_MISS_NUM OR

828: x_return_status := Okc_Api.G_RET_STS_ERROR;
829: RAISE G_EXCEPTION_HALT_VALIDATION;
830: END IF;
831:
832: IF p_fprv_rec.fpr_type = G_CONTEXT_TYPE AND (p_fprv_rec.pmr_id = OKL_API.G_MISS_NUM OR
833: p_fprv_rec.pmr_id IS NULL)
834: THEN
835: OKL_API.SET_MESSAGE(p_app_name => G_APP_NAME,
836: p_msg_name => G_MISS_DATA,

Line 835: OKL_API.SET_MESSAGE(p_app_name => G_APP_NAME,

831:
832: IF p_fprv_rec.fpr_type = G_CONTEXT_TYPE AND (p_fprv_rec.pmr_id = OKL_API.G_MISS_NUM OR
833: p_fprv_rec.pmr_id IS NULL)
834: THEN
835: OKL_API.SET_MESSAGE(p_app_name => G_APP_NAME,
836: p_msg_name => G_MISS_DATA,
837: p_token1 => G_COL_NAME_TOKEN,
838: p_token1_value => 'PMR_ID');
839: x_return_status := Okc_Api.G_RET_STS_ERROR;

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

3381: p_last_update_date IN VARCHAR2)IS
3382:
3383: l_api_version CONSTANT number := 1;
3384: l_api_name CONSTANT varchar2(30) := 'LOAD_SEED_ROW';
3385: l_return_status varchar2(1) := okl_api.g_ret_sts_success;
3386: l_msg_count number;
3387: l_msg_data varchar2(4000);
3388: l_init_msg_list VARCHAR2(1):= 'T';
3389: l_fprv_rec fprv_rec_type;