DBA Data[Home] [Help]

APPS.OKL_SETUPPRODUCTS_PVT dependencies on OKL_ACCOUNTING_UTIL

Line 435: l_token_1 := Okl_Accounting_Util.Get_Message_Token(p_region_code => 'OKL_LP_PRODUCT_SERCH',

431: BEGIN
432: x_valid := TRUE;
433: x_return_status := Okl_Api.G_RET_STS_SUCCESS;
434:
435: l_token_1 := Okl_Accounting_Util.Get_Message_Token(p_region_code => 'OKL_LP_PRODUCT_SERCH',
436: p_attribute_code => 'OKL_PRODUCTS');
437:
438: l_token_2 := Okl_Accounting_Util.Get_Message_Token(p_region_code => 'OKL_LP_PRODUCT_TEMPLATE_SERCH',
439: p_attribute_code => 'OKL_PRODUCT_TEMPLATES');

Line 438: l_token_2 := Okl_Accounting_Util.Get_Message_Token(p_region_code => 'OKL_LP_PRODUCT_TEMPLATE_SERCH',

434:
435: l_token_1 := Okl_Accounting_Util.Get_Message_Token(p_region_code => 'OKL_LP_PRODUCT_SERCH',
436: p_attribute_code => 'OKL_PRODUCTS');
437:
438: l_token_2 := Okl_Accounting_Util.Get_Message_Token(p_region_code => 'OKL_LP_PRODUCT_TEMPLATE_SERCH',
439: p_attribute_code => 'OKL_PRODUCT_TEMPLATES');
440:
441: l_token_3 := Okl_Accounting_Util.Get_Message_Token(p_region_code => 'OKL_LP_TEMPLATE_SETS',
442: p_attribute_code => 'OKL_TEMPLATE_SETS');

Line 441: l_token_3 := Okl_Accounting_Util.Get_Message_Token(p_region_code => 'OKL_LP_TEMPLATE_SETS',

437:
438: l_token_2 := Okl_Accounting_Util.Get_Message_Token(p_region_code => 'OKL_LP_PRODUCT_TEMPLATE_SERCH',
439: p_attribute_code => 'OKL_PRODUCT_TEMPLATES');
440:
441: l_token_3 := Okl_Accounting_Util.Get_Message_Token(p_region_code => 'OKL_LP_TEMPLATE_SETS',
442: p_attribute_code => 'OKL_TEMPLATE_SETS');
443: l_token_4 := l_token_2 ||','||l_token_3;
444:
445: l_token_5 := Okl_Accounting_Util.Get_Message_Token(p_region_code => 'OKL_LP_PQVALS_CRUPD',

Line 445: l_token_5 := Okl_Accounting_Util.Get_Message_Token(p_region_code => 'OKL_LP_PQVALS_CRUPD',

441: l_token_3 := Okl_Accounting_Util.Get_Message_Token(p_region_code => 'OKL_LP_TEMPLATE_SETS',
442: p_attribute_code => 'OKL_TEMPLATE_SETS');
443: l_token_4 := l_token_2 ||','||l_token_3;
444:
445: l_token_5 := Okl_Accounting_Util.Get_Message_Token(p_region_code => 'OKL_LP_PQVALS_CRUPD',
446: p_attribute_code => 'OKL_PRODUCT_QUALITY_VALUES');
447:
448: l_token_6 := Okl_Accounting_Util.Get_Message_Token(p_region_code => 'OKL_LP_OPTION_SERCH',
449: p_attribute_code => 'OKL_OPTIONS');

Line 448: l_token_6 := Okl_Accounting_Util.Get_Message_Token(p_region_code => 'OKL_LP_OPTION_SERCH',

444:
445: l_token_5 := Okl_Accounting_Util.Get_Message_Token(p_region_code => 'OKL_LP_PQVALS_CRUPD',
446: p_attribute_code => 'OKL_PRODUCT_QUALITY_VALUES');
447:
448: l_token_6 := Okl_Accounting_Util.Get_Message_Token(p_region_code => 'OKL_LP_OPTION_SERCH',
449: p_attribute_code => 'OKL_OPTIONS');
450:
451: l_token_7 := Okl_Accounting_Util.Get_Message_Token(p_region_code => 'OKL_LP_OPTVAL_SERCH',
452: p_attribute_code => 'OKL_OPTION_VALUES');

Line 451: l_token_7 := Okl_Accounting_Util.Get_Message_Token(p_region_code => 'OKL_LP_OPTVAL_SERCH',

447:
448: l_token_6 := Okl_Accounting_Util.Get_Message_Token(p_region_code => 'OKL_LP_OPTION_SERCH',
449: p_attribute_code => 'OKL_OPTIONS');
450:
451: l_token_7 := Okl_Accounting_Util.Get_Message_Token(p_region_code => 'OKL_LP_OPTVAL_SERCH',
452: p_attribute_code => 'OKL_OPTION_VALUES');
453:
454: l_token_8 := l_token_5 ||','|| l_token_6 || ',' || l_token_7;
455:

Line 456: l_token_9 := Okl_Accounting_Util.Get_Message_Token(p_region_code => 'OKL_CONTRACT_DTLS',

452: p_attribute_code => 'OKL_OPTION_VALUES');
453:
454: l_token_8 := l_token_5 ||','|| l_token_6 || ',' || l_token_7;
455:
456: l_token_9 := Okl_Accounting_Util.Get_Message_Token(p_region_code => 'OKL_CONTRACT_DTLS',
457: p_attribute_code => 'OKL_KDTLS_CONTRACT');
458:
459:
460: l_token_10 := Okl_Accounting_Util.Get_Message_Token(p_region_code => 'OKL_LP_PRODUCT_CRUPD',

Line 460: l_token_10 := Okl_Accounting_Util.Get_Message_Token(p_region_code => 'OKL_LP_PRODUCT_CRUPD',

456: l_token_9 := Okl_Accounting_Util.Get_Message_Token(p_region_code => 'OKL_CONTRACT_DTLS',
457: p_attribute_code => 'OKL_KDTLS_CONTRACT');
458:
459:
460: l_token_10 := Okl_Accounting_Util.Get_Message_Token(p_region_code => 'OKL_LP_PRODUCT_CRUPD',
461: p_attribute_code => 'OKL_PRODUCT');
462:
463: -- Halt the processing if the Product is active(used by a contract).
464: IF p_pdtv_rec.id <> Okl_Api.G_MISS_NUM THEN

Line 497: l_name := Okl_Accounting_Util.okl_upper(p_pdtv_rec.name);

493: l_to_date := p_pdtv_rec.TO_DATE;
494: END IF;
495:
496: IF p_pdtv_rec.id = Okl_Api.G_MISS_NUM THEN
497: l_name := Okl_Accounting_Util.okl_upper(p_pdtv_rec.name);
498:
499: OPEN c1(l_name,
500: p_pdtv_rec.version);
501: FETCH c1 INTO l_pdt_status;

Line 1743: l_token_1 := Okl_Accounting_Util.Get_Message_Token('OKL_LP_PRODUCT_CRUPD','OKL_NAME');

1739: BEGIN
1740: -- initialize return status
1741: x_return_status := Okl_Api.G_RET_STS_SUCCESS;
1742:
1743: l_token_1 := Okl_Accounting_Util.Get_Message_Token('OKL_LP_PRODUCT_CRUPD','OKL_NAME');
1744:
1745: OPEN c2(p_pdtv_rec.id);
1746: FETCH c2 INTO l_found;
1747:

Line 1823: l_token_1 := Okl_Accounting_Util.Get_Message_Token('OKL_LP_PDT_TMPL_CREATE_UPDATE','OKL_PRODUCT_TEMPLATE');

1819: /*
1820: -- initialize return status
1821: x_return_status := Okl_Api.G_RET_STS_SUCCESS;
1822:
1823: l_token_1 := Okl_Accounting_Util.Get_Message_Token('OKL_LP_PDT_TMPL_CREATE_UPDATE','OKL_PRODUCT_TEMPLATE');
1824:
1825: OPEN c1(p_pdtv_rec.id);
1826: FETCH c1 INTO l_row_found;
1827: IF (c1%NOTFOUND) THEN

Line 2146: p_token1_value => OKL_ACCOUNTING_UTIL.GET_LOOKUP_MEANING( 'OKL_SECURITIZATION_TYPE', pdt_rec.deal_type ),

2142: OKL_API.SET_MESSAGE(
2143: p_app_name => G_APP_NAME,
2144: p_msg_name => 'OKL_NEW_INVESTOR_MISMATCH',
2145: p_token1 => 'PQVALUE',
2146: p_token1_value => OKL_ACCOUNTING_UTIL.GET_LOOKUP_MEANING( 'OKL_SECURITIZATION_TYPE', pdt_rec.deal_type ),
2147: p_token2 => 'SGTVALUE',
2148: p_token2_value => OKL_ACCOUNTING_UTIL.GET_LOOKUP_MEANING( 'OKL_STREAM_INV_BOOK_CLASS', sgt_rec.deal_type) );
2149: x_return_status := Okl_Api.G_RET_STS_ERROR;
2150: RAISE OKL_API.G_EXCEPTION_ERROR;

Line 2148: p_token2_value => OKL_ACCOUNTING_UTIL.GET_LOOKUP_MEANING( 'OKL_STREAM_INV_BOOK_CLASS', sgt_rec.deal_type) );

2144: p_msg_name => 'OKL_NEW_INVESTOR_MISMATCH',
2145: p_token1 => 'PQVALUE',
2146: p_token1_value => OKL_ACCOUNTING_UTIL.GET_LOOKUP_MEANING( 'OKL_SECURITIZATION_TYPE', pdt_rec.deal_type ),
2147: p_token2 => 'SGTVALUE',
2148: p_token2_value => OKL_ACCOUNTING_UTIL.GET_LOOKUP_MEANING( 'OKL_STREAM_INV_BOOK_CLASS', sgt_rec.deal_type) );
2149: x_return_status := Okl_Api.G_RET_STS_ERROR;
2150: RAISE OKL_API.G_EXCEPTION_ERROR;
2151: END IF;
2152: ELSIF pdt_rec.product_subclass = 'LEASE'

Line 2165: p_token1_value => OKL_ACCOUNTING_UTIL.GET_LOOKUP_MEANING( 'OKL_STREAM_ALL_BOOK_CLASS',sgt_rec.deal_type ),

2161: Okl_Api.SET_MESSAGE(
2162: p_app_name => G_APP_NAME,
2163: p_msg_name => 'OKL_NEW_PDT_QUAL_MISMATCH',
2164: p_token1 => 'SGTDEALTYPE',
2165: p_token1_value => OKL_ACCOUNTING_UTIL.GET_LOOKUP_MEANING( 'OKL_STREAM_ALL_BOOK_CLASS',sgt_rec.deal_type ),
2166: p_token2 => 'SGTTAXOWNER',
2167: p_token2_value => OKL_ACCOUNTING_UTIL.GET_LOOKUP_MEANING( 'OKL_TAX_OWNER',sgt_rec.tax_owner),
2168: p_token3 => 'SGTINTCALC',
2169: p_token3_value => OKL_ACCOUNTING_UTIL.GET_LOOKUP_MEANING( 'OKL_INTEREST_CALCULATION_BASIS',sgt_rec.interest_calc_meth_code ),

Line 2167: p_token2_value => OKL_ACCOUNTING_UTIL.GET_LOOKUP_MEANING( 'OKL_TAX_OWNER',sgt_rec.tax_owner),

2163: p_msg_name => 'OKL_NEW_PDT_QUAL_MISMATCH',
2164: p_token1 => 'SGTDEALTYPE',
2165: p_token1_value => OKL_ACCOUNTING_UTIL.GET_LOOKUP_MEANING( 'OKL_STREAM_ALL_BOOK_CLASS',sgt_rec.deal_type ),
2166: p_token2 => 'SGTTAXOWNER',
2167: p_token2_value => OKL_ACCOUNTING_UTIL.GET_LOOKUP_MEANING( 'OKL_TAX_OWNER',sgt_rec.tax_owner),
2168: p_token3 => 'SGTINTCALC',
2169: p_token3_value => OKL_ACCOUNTING_UTIL.GET_LOOKUP_MEANING( 'OKL_INTEREST_CALCULATION_BASIS',sgt_rec.interest_calc_meth_code ),
2170: p_token4 => 'SGTRRB',
2171: p_token4_value => OKL_ACCOUNTING_UTIL.GET_LOOKUP_MEANING( 'OKL_REVENUE_RECOGNITION_METHOD',sgt_rec.revenue_recog_meth_code)

Line 2169: p_token3_value => OKL_ACCOUNTING_UTIL.GET_LOOKUP_MEANING( 'OKL_INTEREST_CALCULATION_BASIS',sgt_rec.interest_calc_meth_code ),

2165: p_token1_value => OKL_ACCOUNTING_UTIL.GET_LOOKUP_MEANING( 'OKL_STREAM_ALL_BOOK_CLASS',sgt_rec.deal_type ),
2166: p_token2 => 'SGTTAXOWNER',
2167: p_token2_value => OKL_ACCOUNTING_UTIL.GET_LOOKUP_MEANING( 'OKL_TAX_OWNER',sgt_rec.tax_owner),
2168: p_token3 => 'SGTINTCALC',
2169: p_token3_value => OKL_ACCOUNTING_UTIL.GET_LOOKUP_MEANING( 'OKL_INTEREST_CALCULATION_BASIS',sgt_rec.interest_calc_meth_code ),
2170: p_token4 => 'SGTRRB',
2171: p_token4_value => OKL_ACCOUNTING_UTIL.GET_LOOKUP_MEANING( 'OKL_REVENUE_RECOGNITION_METHOD',sgt_rec.revenue_recog_meth_code)
2172: );
2173: x_return_status := Okl_Api.G_RET_STS_ERROR;

Line 2171: p_token4_value => OKL_ACCOUNTING_UTIL.GET_LOOKUP_MEANING( 'OKL_REVENUE_RECOGNITION_METHOD',sgt_rec.revenue_recog_meth_code)

2167: p_token2_value => OKL_ACCOUNTING_UTIL.GET_LOOKUP_MEANING( 'OKL_TAX_OWNER',sgt_rec.tax_owner),
2168: p_token3 => 'SGTINTCALC',
2169: p_token3_value => OKL_ACCOUNTING_UTIL.GET_LOOKUP_MEANING( 'OKL_INTEREST_CALCULATION_BASIS',sgt_rec.interest_calc_meth_code ),
2170: p_token4 => 'SGTRRB',
2171: p_token4_value => OKL_ACCOUNTING_UTIL.GET_LOOKUP_MEANING( 'OKL_REVENUE_RECOGNITION_METHOD',sgt_rec.revenue_recog_meth_code)
2172: );
2173: x_return_status := Okl_Api.G_RET_STS_ERROR;
2174: RAISE OKL_API.G_EXCEPTION_ERROR;
2175: END IF;

Line 2456: l_token_1 := Okl_Accounting_Util.Get_Message_Token('OKL_LP_TEMPLATE_SETS','OKL_TEMPLATE_SET');

2452:
2453: BEGIN
2454: -- initialize return status
2455: x_return_status := Okl_Api.G_RET_STS_SUCCESS;
2456: l_token_1 := Okl_Accounting_Util.Get_Message_Token('OKL_LP_TEMPLATE_SETS','OKL_TEMPLATE_SET');
2457:
2458: -- check for data before processing
2459: IF (p_pdtv_rec.aes_id IS NULL) OR
2460: (p_pdtv_rec.aes_id = Okl_Api.G_MISS_NUM) THEN

Line 2560: l_token_1 := Okl_Accounting_Util.Get_Message_Token('OKL_LP_PDT_TMPL_CREATE_UPDATE','OKL_PRODUCT_TEMPLATE');

2556: BEGIN
2557: -- initialize return status
2558: x_return_status := Okl_Api.G_RET_STS_SUCCESS;
2559:
2560: l_token_1 := Okl_Accounting_Util.Get_Message_Token('OKL_LP_PDT_TMPL_CREATE_UPDATE','OKL_PRODUCT_TEMPLATE');
2561:
2562: -- check for data before processing
2563: IF (p_pdtv_rec.ptl_id IS NULL) OR
2564: (p_pdtv_rec.ptl_id = Okl_Api.G_MISS_NUM) THEN

Line 2658: l_token_1 := Okl_Accounting_Util.Get_Message_Token('OKL_LP_PRODUCT_CRUPD','OKL_EFFECTIVE_FROM');

2654: BEGIN
2655: -- initialize return status
2656: x_return_status := Okl_Api.G_RET_STS_SUCCESS;
2657:
2658: l_token_1 := Okl_Accounting_Util.Get_Message_Token('OKL_LP_PRODUCT_CRUPD','OKL_EFFECTIVE_FROM');
2659:
2660: -- check for data before processing
2661: IF (p_pdtv_rec.from_date IS NULL) OR
2662: (p_pdtv_rec.from_date = Okl_Api.G_MISS_DATE) THEN

Line 2732: l_token_1 := Okl_Accounting_Util.Get_Message_Token('OKL_LP_PRODUCT_CRUPD','OKL_NAME');

2728:
2729: BEGIN
2730: -- initialize return status
2731: x_return_status := Okl_Api.G_RET_STS_SUCCESS;
2732: l_token_1 := Okl_Accounting_Util.Get_Message_Token('OKL_LP_PRODUCT_CRUPD','OKL_NAME');
2733:
2734: -- check for data before processing
2735: IF (p_pdtv_rec.name IS NULL) OR
2736: (p_pdtv_rec.name = Okl_Api.G_MISS_CHAR) THEN

Line 2761: p_pdtv_rec.name := Okl_Accounting_Util.okl_upper(p_pdtv_rec.name);

2757: -- End of wraper code generated automatically by Debug code generator for Okl_Api.SET_MESSAGE
2758: x_return_status := Okl_Api.G_RET_STS_ERROR;
2759: RAISE G_EXCEPTION_HALT_PROCESSING;
2760: END IF;
2761: p_pdtv_rec.name := Okl_Accounting_Util.okl_upper(p_pdtv_rec.name);
2762: EXCEPTION
2763: WHEN G_EXCEPTION_HALT_PROCESSING THEN
2764: -- no processing necessary; validation can continue
2765: -- with the next column