APPS.OKL_DSF_PVT dependencies on OKL_API

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

577: p_dsfv_rec IN dsfv_rec_type)
578: IS
579:
580: -- l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
581: l_return_status VARCHAR2(1) := OKL_API.G_TRUE;
582:
583: BEGIN
584: -- initialize return status
585: x_return_status := OKC_API.G_RET_STS_SUCCESS;

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

586:
587: -- check from domain values using the generic
588: -- l_return_status := OKL_UTIL.check_domain_yn(p_dsfv_rec.sfwt_flag);
589: l_return_status := OKL_ACCOUNTING_UTIL.validate_lookup_code('YES_NO',p_dsfv_rec.sfwt_flag,0,0);
590: IF (l_return_status = OKL_API.G_FALSE) THEN
591: OKC_API.SET_MESSAGE(p_app_name => g_app_name,
592: p_msg_name => g_invalid_value,
593: p_token1 => g_col_name_token,
594: p_token1_value => 'sfwt_flag');

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

903: ) IS
904:
905: l_dummy VARCHAR2(1) := '?';
906: -- l_row_not_found BOOLEAN := FALSE;
907: l_row_found VARCHAR2(1) := OKL_API.G_TRUE;
908:
909: -- Cursor For OKL_DSF_FCL_FK;
910: /*
911: CURSOR okl_fclv_code_csr (p_code IN OKL_DATA_SRC_FNCTNS_V.fnctn_code%TYPE) IS

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

933: l_row_not_found := okl_fclv_code_csr%NOTFOUND;
934: CLOSE okl_fclv_code_csr;
935: */
936: l_row_found := OKL_ACCOUNTING_UTIL.validate_lookup_code('OKL_FUNCTION_TYPE', p_dsfv_rec.fnctn_code);
937: IF (l_row_found = OKL_API.G_FALSE) THEN
938: Okc_Api.set_message(G_APP_NAME,G_INVALID_VALUE,G_COL_NAME_TOKEN,'fnctn_code');
939: x_return_status := Okc_Api.G_RET_STS_ERROR;
940: END IF;
941:

Line 942: IF p_dsfv_rec.fnctn_code = G_PLSQL_TYPE AND (p_dsfv_rec.source = OKL_API.G_MISS_CHAR OR

938: Okc_Api.set_message(G_APP_NAME,G_INVALID_VALUE,G_COL_NAME_TOKEN,'fnctn_code');
939: x_return_status := Okc_Api.G_RET_STS_ERROR;
940: END IF;
941:
942: IF p_dsfv_rec.fnctn_code = G_PLSQL_TYPE AND (p_dsfv_rec.source = OKL_API.G_MISS_CHAR OR
943: p_dsfv_rec.source IS NULL)
944: THEN
945: OKL_API.SET_MESSAGE(p_app_name => 'OKL',
946: p_msg_name => G_MISS_DATA,

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

941:
942: IF p_dsfv_rec.fnctn_code = G_PLSQL_TYPE AND (p_dsfv_rec.source = OKL_API.G_MISS_CHAR OR
943: p_dsfv_rec.source IS NULL)
944: THEN
945: OKL_API.SET_MESSAGE(p_app_name => 'OKL',
946: p_msg_name => G_MISS_DATA,
947: p_token1 => G_COL_NAME_TOKEN,
948: p_token1_value => 'SOURCE');
949: x_return_status := Okc_Api.G_RET_STS_ERROR;

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

3949: p_last_update_date IN VARCHAR2)IS
3950:
3951: l_api_version CONSTANT number := 1;
3952: l_api_name CONSTANT varchar2(30) := 'LOAD_SEED_ROW';
3953: l_return_status varchar2(1) := okl_api.g_ret_sts_success;
3954: l_msg_count number;
3955: l_msg_data varchar2(4000);
3956: l_init_msg_list VARCHAR2(1):= 'T';
3957: l_dsfv_rec dsfv_rec_type;