DBA Data[Home] [Help]

APPS.OKL_SETUPOPTVALUES_PVT dependencies on OKL_ACCOUNTING_UTIL

Line 349: l_token_1 := Okl_Accounting_Util.Get_Message_Token(p_region_code => 'OKL_LP_OPTVAL_SERCH',

345: BEGIN
346: x_valid := TRUE;
347: x_return_status := Okl_Api.G_RET_STS_SUCCESS;
348:
349: l_token_1 := Okl_Accounting_Util.Get_Message_Token(p_region_code => 'OKL_LP_OPTVAL_SERCH',
350: p_attribute_code => 'OKL_OPTION_VALUES');
351:
352: l_token_2 := Okl_Accounting_Util.Get_Message_Token(p_region_code => 'OKL_LP_OPTION_SERCH',
353: p_attribute_code => 'OKL_OPTIONS');

Line 352: l_token_2 := Okl_Accounting_Util.Get_Message_Token(p_region_code => 'OKL_LP_OPTION_SERCH',

348:
349: l_token_1 := Okl_Accounting_Util.Get_Message_Token(p_region_code => 'OKL_LP_OPTVAL_SERCH',
350: p_attribute_code => 'OKL_OPTION_VALUES');
351:
352: l_token_2 := Okl_Accounting_Util.Get_Message_Token(p_region_code => 'OKL_LP_OPTION_SERCH',
353: p_attribute_code => 'OKL_OPTIONS');
354:
355: l_token_3 := Okl_Accounting_Util.Get_Message_Token(p_region_code => 'OKL_LP_OPTION_RULE_SERCH',
356: p_attribute_code => 'OKL_OPTION_RULES');

Line 355: l_token_3 := Okl_Accounting_Util.Get_Message_Token(p_region_code => 'OKL_LP_OPTION_RULE_SERCH',

351:
352: l_token_2 := Okl_Accounting_Util.Get_Message_Token(p_region_code => 'OKL_LP_OPTION_SERCH',
353: p_attribute_code => 'OKL_OPTIONS');
354:
355: l_token_3 := Okl_Accounting_Util.Get_Message_Token(p_region_code => 'OKL_LP_OPTION_RULE_SERCH',
356: p_attribute_code => 'OKL_OPTION_RULES');
357:
358: l_token_4 := Okl_Accounting_Util.Get_Message_Token(p_region_code => 'OKL_LP_PDT_OPT_VAL_SUMRY',
359: p_attribute_code => 'OKL_PRODUCT_OPTION_VALUES');

Line 358: l_token_4 := Okl_Accounting_Util.Get_Message_Token(p_region_code => 'OKL_LP_PDT_OPT_VAL_SUMRY',

354:
355: l_token_3 := Okl_Accounting_Util.Get_Message_Token(p_region_code => 'OKL_LP_OPTION_RULE_SERCH',
356: p_attribute_code => 'OKL_OPTION_RULES');
357:
358: l_token_4 := Okl_Accounting_Util.Get_Message_Token(p_region_code => 'OKL_LP_PDT_OPT_VAL_SUMRY',
359: p_attribute_code => 'OKL_PRODUCT_OPTION_VALUES');
360:
361:
362: -- Fix for g_miss_date

Line 370: p_ovev_rec.value := Okl_Accounting_Util.okl_upper(p_ovev_rec.value);

366: l_to_date := p_ovev_rec.TO_DATE;
367: END IF;
368:
369: IF p_ovev_rec.id = Okl_Api.G_MISS_NUM THEN
370: p_ovev_rec.value := Okl_Accounting_Util.okl_upper(p_ovev_rec.value);
371: OPEN okl_ove_values_unique (p_ovev_rec.opt_id, p_ovev_rec.value);
372: FETCH okl_ove_values_unique INTO l_unique_key;
373: IF okl_ove_values_unique%FOUND THEN
374: Okl_Api.set_message(G_APP_NAME,'OKL_NOT_UNIQUE', 'OKL_TABLE_NAME',l_token_1);

Line 502: l_token_1 := Okl_Accounting_Util.Get_Message_Token('OKL_LP_OPTVAL_CRUPD','OKL_NAME');

498: BEGIN
499: -- initialize return status
500: x_return_status := Okc_Api.G_RET_STS_SUCCESS;
501:
502: l_token_1 := Okl_Accounting_Util.Get_Message_Token('OKL_LP_OPTVAL_CRUPD','OKL_NAME');
503: IF p_ovev_rec.value = Okc_Api.G_MISS_CHAR OR
504: p_ovev_rec.value IS NULL
505: THEN
506: Okc_Api.set_message(Okl_Ove_Pvt.G_APP_NAME, Okl_Ove_Pvt.G_REQUIRED_VALUE,Okl_Ove_Pvt.G_COL_NAME_TOKEN,l_token_1);

Line 509: p_ovev_rec.value := Okl_Accounting_Util.okl_upper(p_ovev_rec.value);

505: THEN
506: Okc_Api.set_message(Okl_Ove_Pvt.G_APP_NAME, Okl_Ove_Pvt.G_REQUIRED_VALUE,Okl_Ove_Pvt.G_COL_NAME_TOKEN,l_token_1);
507: x_return_status := Okc_Api.G_RET_STS_ERROR;
508: END IF;
509: p_ovev_rec.value := Okl_Accounting_Util.okl_upper(p_ovev_rec.value);
510: EXCEPTION
511: WHEN OTHERS THEN
512: Okc_Api.set_message(p_app_name =>Okl_Ove_Pvt.G_APP_NAME,
513: p_msg_name =>Okl_Ove_Pvt.G_UNEXPECTED_ERROR,

Line 545: l_token_1 := Okl_Accounting_Util.Get_Message_Token('OKL_LP_OPTVAL_CRUPD','OKL_EFFECTIVE_FROM');

541: l_token_1 VARCHAR2(999);
542: BEGIN
543: -- initialize return status
544: x_return_status := Okc_Api.G_RET_STS_SUCCESS;
545: l_token_1 := Okl_Accounting_Util.Get_Message_Token('OKL_LP_OPTVAL_CRUPD','OKL_EFFECTIVE_FROM');
546: IF p_ovev_rec.from_date IS NULL OR p_ovev_rec.from_date = Okl_Api.G_MISS_DATE
547: THEN
548: Okl_Api.set_message(Okl_Ove_Pvt.G_APP_NAME, Okl_Ove_Pvt.G_REQUIRED_VALUE,Okl_Ove_Pvt.G_COL_NAME_TOKEN,l_token_1);
549: x_return_status := Okl_Api.G_RET_STS_ERROR;