DBA Data[Home] [Help]

APPS.OKL_SETUPPQYVALUES_PVT dependencies on OKL_ACCOUNTING_UTIL

Line 174: l_token_1 := Okl_Accounting_Util.Get_Message_Token(p_region_code => 'OKL_LP_PQVALS_CRUPD',

170: x_valid := TRUE;
171: x_return_status := Okl_Api.G_RET_STS_SUCCESS;
172:
173:
174: l_token_1 := Okl_Accounting_Util.Get_Message_Token(p_region_code => 'OKL_LP_PQVALS_CRUPD',
175: p_attribute_code => 'OKL_PRODUCT_QUALITY_VALUES');
176:
177: l_token_2 := Okl_Accounting_Util.Get_Message_Token(p_region_code => 'OKL_LP_PRDQLTY_CRUPD',
178: p_attribute_code => 'OKL_PRODUCT_QUALITIES');

Line 177: l_token_2 := Okl_Accounting_Util.Get_Message_Token(p_region_code => 'OKL_LP_PRDQLTY_CRUPD',

173:
174: l_token_1 := Okl_Accounting_Util.Get_Message_Token(p_region_code => 'OKL_LP_PQVALS_CRUPD',
175: p_attribute_code => 'OKL_PRODUCT_QUALITY_VALUES');
176:
177: l_token_2 := Okl_Accounting_Util.Get_Message_Token(p_region_code => 'OKL_LP_PRDQLTY_CRUPD',
178: p_attribute_code => 'OKL_PRODUCT_QUALITIES');
179:
180: l_token_3 := Okl_Accounting_Util.Get_Message_Token(p_region_code => 'OKL_LP_PDT_PQV_VAL_SUMRY',
181: p_attribute_code => 'OKL_PDT_QUALITY_VALUES');

Line 180: l_token_3 := Okl_Accounting_Util.Get_Message_Token(p_region_code => 'OKL_LP_PDT_PQV_VAL_SUMRY',

176:
177: l_token_2 := Okl_Accounting_Util.Get_Message_Token(p_region_code => 'OKL_LP_PRDQLTY_CRUPD',
178: p_attribute_code => 'OKL_PRODUCT_QUALITIES');
179:
180: l_token_3 := Okl_Accounting_Util.Get_Message_Token(p_region_code => 'OKL_LP_PDT_PQV_VAL_SUMRY',
181: p_attribute_code => 'OKL_PDT_QUALITY_VALUES');
182:
183:
184: IF p_qvev_rec.id = Okl_Api.G_MISS_NUM THEN

Line 185: p_qvev_rec.value := Okl_Accounting_Util.okl_upper(p_qvev_rec.value);

181: p_attribute_code => 'OKL_PDT_QUALITY_VALUES');
182:
183:
184: IF p_qvev_rec.id = Okl_Api.G_MISS_NUM THEN
185: p_qvev_rec.value := Okl_Accounting_Util.okl_upper(p_qvev_rec.value);
186:
187: OPEN okl_pqy_values_unique (p_qvev_rec.value, p_qvev_rec.pqy_id);
188: FETCH okl_pqy_values_unique INTO l_unique_key;
189: IF okl_pqy_values_unique%FOUND THEN

Line 294: l_token_1 := Okl_Accounting_Util.Get_Message_Token('OKL_LP_PQVALS_CRUPD','OKL_NAME');

290: BEGIN
291: -- initialize return status
292: x_return_status := Okl_Api.G_RET_STS_SUCCESS;
293:
294: l_token_1 := Okl_Accounting_Util.Get_Message_Token('OKL_LP_PQVALS_CRUPD','OKL_NAME');
295:
296: IF p_qvev_rec.value = Okl_Api.G_MISS_CHAR OR
297: p_qvev_rec.value IS NULL
298: THEN

Line 302: p_qvev_rec.value := Okl_Accounting_Util.okl_upper(p_qvev_rec.value);

298: THEN
299: Okl_Api.set_message(Okl_Qve_Pvt.G_APP_NAME, Okl_Qve_Pvt.G_REQUIRED_VALUE,Okl_Qve_Pvt.G_COL_NAME_TOKEN,l_token_1);
300: x_return_status := Okl_Api.G_RET_STS_ERROR;
301: END IF;
302: p_qvev_rec.value := Okl_Accounting_Util.okl_upper(p_qvev_rec.value);
303: EXCEPTION
304: WHEN OTHERS THEN
305: Okl_Api.set_message(p_app_name =>Okl_Qve_Pvt.G_APP_NAME,
306: p_msg_name =>Okl_Qve_Pvt.G_UNEXPECTED_ERROR,

Line 338: l_token_1 := Okl_Accounting_Util.Get_Message_Token('OKL_LP_PQVALS_CRUPD','OKL_EFFECTIVE_FROM');

334: l_token_1 VARCHAR2(999);
335: BEGIN
336: -- initialize return status
337: x_return_status := Okl_Api.G_RET_STS_SUCCESS;
338: l_token_1 := Okl_Accounting_Util.Get_Message_Token('OKL_LP_PQVALS_CRUPD','OKL_EFFECTIVE_FROM');
339: IF (p_qvev_rec.from_date IS NULL) OR
340: (p_qvev_rec.from_date = Okl_Api.G_MISS_DATE) THEN
341: Okl_Api.set_message(Okl_Qve_Pvt.G_APP_NAME, Okl_Qve_Pvt.G_REQUIRED_VALUE,Okl_Qve_Pvt.G_COL_NAME_TOKEN,l_token_1);
342: x_return_status := Okl_Api.G_RET_STS_ERROR;