[Home] [Help]
126: BEGIN
127:
128: IF ((p_tbcv_rec.RESULT_CODE = OKL_API.G_MISS_CHAR OR p_tbcv_rec.RESULT_CODE IS NULL) ) THEN
129:
130: x_return_status := OKC_API.G_RET_STS_ERROR;
131: --Unable to create Category definition as mandatory attributes are provided.
132: OKL_API.set_message(p_app_name => 'OKL',
133: p_msg_name => 'OKL_TX_NO_TBC_ATTR');
134: RAISE G_EXCEPTION_HALT_VALIDATION;
136: END IF;
137: IF (p_tbcv_rec.AGE_OF_EQUIP_FROM IS NOT NULL AND p_tbcv_rec.AGE_OF_EQUIP_FROM <> OKL_API.G_MISS_NUM) AND
138: (p_tbcv_rec.AGE_OF_EQUIP_TO IS NOT NULL AND p_tbcv_rec.AGE_OF_EQUIP_TO <> OKL_API.G_MISS_NUM) THEN
139: IF p_tbcv_rec.AGE_OF_EQUIP_TO < p_tbcv_rec.AGE_OF_EQUIP_FROM THEN
140: x_return_status := OKC_API.G_RET_STS_ERROR;
141: --Unable to create Transcation Business Category definition as none of the attributes are provided.
142: OKL_API.set_message(p_app_name => 'OKL',
143: p_msg_name => 'OKL_TX_INVALID_AGE_RANGE');
144: RAISE G_EXCEPTION_HALT_VALIDATION;
189: END IF;
190:
191: -- There can be at the most one duplicate record.
192: IF l_result_code <> 'XXXXX' THEN
193: x_return_status := OKC_API.G_RET_STS_ERROR;
194: -- Another Category already exists for this combination of tax determinants.
195: -- modified by dcshanmu for eBTax project - modification start
196: -- modified default values passed to p_msg_name and p_token1
197: IF l_token1 = 'UFC_CODE' THEN
692: x_msg_data OUT NOCOPY VARCHAR2,
693: p_tbcv_rec IN tbcv_rec_type) IS
694:
695: i NUMBER :=0;
696: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
697: l_api_version NUMBER ;
698: l_init_msg_list VARCHAR2(1) ;
699: l_msg_data VARCHAR2(2000);
700: l_msg_count NUMBER ;
778: x_msg_data OUT NOCOPY VARCHAR2,
779: p_tbcv_tbl IN tbcv_tbl_type) IS
780:
781: i NUMBER := 0;
782: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
783: l_api_version NUMBER := p_api_version ;
784: l_init_msg_list VARCHAR2(1) := p_init_msg_list ;
785: l_msg_data VARCHAR2(2000);
786: l_msg_count NUMBER ;