DBA Data[Home] [Help]

APPS.OKL_KHR_PVT dependencies on OKL_API

Line 157: (p_khrv_rec.legal_entity_id <> Okl_Api.G_MISS_NUM) THEN

153:
154: x_return_status := Okc_Api.G_RET_STS_SUCCESS;
155:
156: IF (p_khrv_rec.legal_entity_id IS NOT NULL) AND
157: (p_khrv_rec.legal_entity_id <> Okl_Api.G_MISS_NUM) THEN
158: l_exists := OKL_LEGAL_ENTITY_UTIL.check_le_id_exists(p_khrv_rec.legal_entity_id) ;
159: IF (l_exists<>1) THEN
160: Okc_Api.set_message(G_APP_NAME, G_INVALID_VALUE,G_COL_NAME_TOKEN,'LEGAL_ENTITY_ID');
161: RAISE item_not_found_error;

Line 844: x_return_status := OKL_API.G_RET_STS_SUCCESS;

840: l_desc_flex_name VARCHAR2(30) := 'OKL_K_HEADERS_DF';
841: l_segment_partial_name VARCHAR2(30) := 'ATTRIBUTE';
842: Begin
843: -- initialize return status
844: x_return_status := OKL_API.G_RET_STS_SUCCESS;
845:
846: l_segment_values_rec.attribute_category := p_khrv_rec.attribute_category;
847: l_segment_values_rec.attribute1 := p_khrv_rec.attribute1;
848: l_segment_values_rec.attribute2 := p_khrv_rec.attribute2;

Line 865: ,p_init_msg_list => OKL_API.G_FALSE

861: l_segment_values_rec.attribute15 := p_khrv_rec.attribute15;
862:
863: okl_dflex_util_pvt.validate_desc_flex
864: (p_api_version => 1.0
865: ,p_init_msg_list => OKL_API.G_FALSE
866: ,x_return_status => x_return_status
867: ,x_msg_count => l_msg_count
868: ,x_msg_data => l_msg_data
869: ,p_appl_short_name => l_appl_short_name

Line 875: IF (x_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN

871: ,p_segment_partial_name => l_segment_partial_name
872: ,p_segment_values_rec => l_segment_values_rec);
873:
874: -- check return status
875: IF (x_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
876: RAISE G_EXCEPTION_HALT_VALIDATION;
877: END IF;
878:
879: exception

Line 881: x_return_status := OKL_API.G_RET_STS_ERROR;

877: END IF;
878:
879: exception
880: when G_EXCEPTION_HALT_VALIDATION THEN
881: x_return_status := OKL_API.G_RET_STS_ERROR;
882:
883: when OTHERS then
884: -- store SQL error message on message stack
885: OKL_API.SET_MESSAGE(p_app_name => g_app_name,

Line 885: OKL_API.SET_MESSAGE(p_app_name => g_app_name,

881: x_return_status := OKL_API.G_RET_STS_ERROR;
882:
883: when OTHERS then
884: -- store SQL error message on message stack
885: OKL_API.SET_MESSAGE(p_app_name => g_app_name,
886: p_msg_name => g_unexpected_error,
887: p_token1 => g_sqlcode_token,
888: p_token1_value => sqlcode,
889: p_token2 => g_sqlerrm_token,

Line 892: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;

888: p_token1_value => sqlcode,
889: p_token2 => g_sqlerrm_token,
890: p_token2_value => sqlerrm);
891: -- notify caller of an error as UNEXPETED error
892: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
893: End validate_DFF_attributes;
894: --Bug# 4558486: end
895:
896: -- ********************* END OF HAND CODED VALIDATION ********************************

Line 1142: if ( NVL(p_khrv_rec.validate_dff_yn,OKL_API.G_MISS_CHAR) = 'Y') then

1138: --Bug# 4558486
1139: -- ***
1140: -- DFF Attributes
1141: -- ***
1142: if ( NVL(p_khrv_rec.validate_dff_yn,OKL_API.G_MISS_CHAR) = 'Y') then
1143: validate_DFF_attributes
1144: (x_return_status => l_return_status,
1145: p_khrv_rec => p_khrv_rec);
1146:

Line 2185: IF (l_khrv_rec.LEGAL_ENTITY_ID = OKL_API.G_MISS_NUM) THEN

2181: l_khrv_rec.TRADEIN_DESCRIPTION := NULL;
2182: END IF;
2183:
2184: --Added by dpsingh for LE uptake
2185: IF (l_khrv_rec.LEGAL_ENTITY_ID = OKL_API.G_MISS_NUM) THEN
2186: l_khrv_rec.LEGAL_ENTITY_ID := NULL;
2187: END IF;
2188:
2189: RETURN(l_khrv_rec);

Line 4278: IF (x_khr_rec.LEGAL_ENTITY_ID = OKL_API.G_MISS_NUM) THEN

4274: IF (x_khr_rec.TRADEIN_DESCRIPTION = OKC_API.G_MISS_CHAR) THEN
4275: x_khr_rec.TRADEIN_DESCRIPTION := l_khr_rec.TRADEIN_DESCRIPTION;
4276: END IF;
4277: --Added by dpsingh for LE uptake
4278: IF (x_khr_rec.LEGAL_ENTITY_ID = OKL_API.G_MISS_NUM) THEN
4279: x_khr_rec.LEGAL_ENTITY_ID := l_khr_rec.LEGAL_ENTITY_ID;
4280: END IF;
4281: RETURN(l_return_status);
4282: END populate_new_record;

Line 4847: IF (x_khrv_rec.LEGAL_ENTITY_ID = OKL_API.G_MISS_NUM) THEN

4843: IF (x_khrv_rec.TRADEIN_DESCRIPTION = OKC_API.G_MISS_CHAR) THEN
4844: x_khrv_rec.TRADEIN_DESCRIPTION := l_khrv_rec.TRADEIN_DESCRIPTION;
4845: END IF;
4846: --Added by dpsingh for LE uptake
4847: IF (x_khrv_rec.LEGAL_ENTITY_ID = OKL_API.G_MISS_NUM) THEN
4848: x_khrv_rec.LEGAL_ENTITY_ID := l_khrv_rec.LEGAL_ENTITY_ID;
4849: END IF;
4850:
4851: RETURN(l_return_status);