DBA Data[Home] [Help]

APPS.OKL_SETUPPRODUCTS_PVT dependencies on OKL_ACCOUNTING_UTIL

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

1722: BEGIN
1723: -- initialize return status
1724: x_return_status := Okl_Api.G_RET_STS_SUCCESS;
1725:
1726: l_token_1 := Okl_Accounting_Util.Get_Message_Token('OKL_LP_PRODUCT_CRUPD','OKL_NAME');
1727:
1728: OPEN c2(p_pdtv_rec.id);
1729: FETCH c2 INTO l_found;
1730:

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

1802: /*
1803: -- initialize return status
1804: x_return_status := Okl_Api.G_RET_STS_SUCCESS;
1805:
1806: l_token_1 := Okl_Accounting_Util.Get_Message_Token('OKL_LP_PDT_TMPL_CREATE_UPDATE','OKL_PRODUCT_TEMPLATE');
1807:
1808: OPEN c1(p_pdtv_rec.id);
1809: FETCH c1 INTO l_row_found;
1810: IF (c1%NOTFOUND) THEN

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

2125: OKL_API.SET_MESSAGE(
2126: p_app_name => G_APP_NAME,
2127: p_msg_name => 'OKL_NEW_INVESTOR_MISMATCH',
2128: p_token1 => 'PQVALUE',
2129: p_token1_value => OKL_ACCOUNTING_UTIL.GET_LOOKUP_MEANING( 'OKL_SECURITIZATION_TYPE', pdt_rec.deal_type ),
2130: p_token2 => 'SGTVALUE',
2131: p_token2_value => OKL_ACCOUNTING_UTIL.GET_LOOKUP_MEANING( 'OKL_STREAM_INV_BOOK_CLASS', sgt_rec.deal_type) );
2132: x_return_status := Okl_Api.G_RET_STS_ERROR;
2133: RAISE OKL_API.G_EXCEPTION_ERROR;

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

2127: p_msg_name => 'OKL_NEW_INVESTOR_MISMATCH',
2128: p_token1 => 'PQVALUE',
2129: p_token1_value => OKL_ACCOUNTING_UTIL.GET_LOOKUP_MEANING( 'OKL_SECURITIZATION_TYPE', pdt_rec.deal_type ),
2130: p_token2 => 'SGTVALUE',
2131: p_token2_value => OKL_ACCOUNTING_UTIL.GET_LOOKUP_MEANING( 'OKL_STREAM_INV_BOOK_CLASS', sgt_rec.deal_type) );
2132: x_return_status := Okl_Api.G_RET_STS_ERROR;
2133: RAISE OKL_API.G_EXCEPTION_ERROR;
2134: END IF;
2135: ELSIF pdt_rec.product_subclass = 'LEASE'

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

2144: Okl_Api.SET_MESSAGE(
2145: p_app_name => G_APP_NAME,
2146: p_msg_name => 'OKL_NEW_PDT_QUAL_MISMATCH',
2147: p_token1 => 'SGTDEALTYPE',
2148: p_token1_value => OKL_ACCOUNTING_UTIL.GET_LOOKUP_MEANING( 'OKL_STREAM_ALL_BOOK_CLASS',sgt_rec.deal_type ),
2149: p_token2 => 'SGTTAXOWNER',
2150: p_token2_value => OKL_ACCOUNTING_UTIL.GET_LOOKUP_MEANING( 'OKL_TAX_OWNER',sgt_rec.tax_owner),
2151: p_token3 => 'SGTINTCALC',
2152: p_token3_value => OKL_ACCOUNTING_UTIL.GET_LOOKUP_MEANING( 'OKL_INTEREST_CALCULATION_BASIS',sgt_rec.interest_calc_meth_code ),

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

2146: p_msg_name => 'OKL_NEW_PDT_QUAL_MISMATCH',
2147: p_token1 => 'SGTDEALTYPE',
2148: p_token1_value => OKL_ACCOUNTING_UTIL.GET_LOOKUP_MEANING( 'OKL_STREAM_ALL_BOOK_CLASS',sgt_rec.deal_type ),
2149: p_token2 => 'SGTTAXOWNER',
2150: p_token2_value => OKL_ACCOUNTING_UTIL.GET_LOOKUP_MEANING( 'OKL_TAX_OWNER',sgt_rec.tax_owner),
2151: p_token3 => 'SGTINTCALC',
2152: p_token3_value => OKL_ACCOUNTING_UTIL.GET_LOOKUP_MEANING( 'OKL_INTEREST_CALCULATION_BASIS',sgt_rec.interest_calc_meth_code ),
2153: p_token4 => 'SGTRRB',
2154: p_token4_value => OKL_ACCOUNTING_UTIL.GET_LOOKUP_MEANING( 'OKL_REVENUE_RECOGNITION_METHOD',sgt_rec.revenue_recog_meth_code)

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

2148: p_token1_value => OKL_ACCOUNTING_UTIL.GET_LOOKUP_MEANING( 'OKL_STREAM_ALL_BOOK_CLASS',sgt_rec.deal_type ),
2149: p_token2 => 'SGTTAXOWNER',
2150: p_token2_value => OKL_ACCOUNTING_UTIL.GET_LOOKUP_MEANING( 'OKL_TAX_OWNER',sgt_rec.tax_owner),
2151: p_token3 => 'SGTINTCALC',
2152: p_token3_value => OKL_ACCOUNTING_UTIL.GET_LOOKUP_MEANING( 'OKL_INTEREST_CALCULATION_BASIS',sgt_rec.interest_calc_meth_code ),
2153: p_token4 => 'SGTRRB',
2154: p_token4_value => OKL_ACCOUNTING_UTIL.GET_LOOKUP_MEANING( 'OKL_REVENUE_RECOGNITION_METHOD',sgt_rec.revenue_recog_meth_code)
2155: );
2156: x_return_status := Okl_Api.G_RET_STS_ERROR;

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

2150: p_token2_value => OKL_ACCOUNTING_UTIL.GET_LOOKUP_MEANING( 'OKL_TAX_OWNER',sgt_rec.tax_owner),
2151: p_token3 => 'SGTINTCALC',
2152: p_token3_value => OKL_ACCOUNTING_UTIL.GET_LOOKUP_MEANING( 'OKL_INTEREST_CALCULATION_BASIS',sgt_rec.interest_calc_meth_code ),
2153: p_token4 => 'SGTRRB',
2154: p_token4_value => OKL_ACCOUNTING_UTIL.GET_LOOKUP_MEANING( 'OKL_REVENUE_RECOGNITION_METHOD',sgt_rec.revenue_recog_meth_code)
2155: );
2156: x_return_status := Okl_Api.G_RET_STS_ERROR;
2157: RAISE OKL_API.G_EXCEPTION_ERROR;
2158: END IF;

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

2423:
2424: BEGIN
2425: -- initialize return status
2426: x_return_status := Okl_Api.G_RET_STS_SUCCESS;
2427: l_token_1 := Okl_Accounting_Util.Get_Message_Token('OKL_LP_TEMPLATE_SETS','OKL_TEMPLATE_SET');
2428:
2429: -- check for data before processing
2430: IF (p_pdtv_rec.aes_id IS NULL) OR
2431: (p_pdtv_rec.aes_id = Okl_Api.G_MISS_NUM) THEN

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

2527: BEGIN
2528: -- initialize return status
2529: x_return_status := Okl_Api.G_RET_STS_SUCCESS;
2530:
2531: l_token_1 := Okl_Accounting_Util.Get_Message_Token('OKL_LP_PDT_TMPL_CREATE_UPDATE','OKL_PRODUCT_TEMPLATE');
2532:
2533: -- check for data before processing
2534: IF (p_pdtv_rec.ptl_id IS NULL) OR
2535: (p_pdtv_rec.ptl_id = Okl_Api.G_MISS_NUM) THEN

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

2625: BEGIN
2626: -- initialize return status
2627: x_return_status := Okl_Api.G_RET_STS_SUCCESS;
2628:
2629: l_token_1 := Okl_Accounting_Util.Get_Message_Token('OKL_LP_PRODUCT_CRUPD','OKL_EFFECTIVE_FROM');
2630:
2631: -- check for data before processing
2632: IF (p_pdtv_rec.from_date IS NULL) OR
2633: (p_pdtv_rec.from_date = Okl_Api.G_MISS_DATE) THEN

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

2699:
2700: BEGIN
2701: -- initialize return status
2702: x_return_status := Okl_Api.G_RET_STS_SUCCESS;
2703: l_token_1 := Okl_Accounting_Util.Get_Message_Token('OKL_LP_PRODUCT_CRUPD','OKL_NAME');
2704:
2705: -- check for data before processing
2706: IF (p_pdtv_rec.name IS NULL) OR
2707: (p_pdtv_rec.name = Okl_Api.G_MISS_CHAR) THEN

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

2728: -- End of wraper code generated automatically by Debug code generator for Okl_Api.SET_MESSAGE
2729: x_return_status := Okl_Api.G_RET_STS_ERROR;
2730: RAISE G_EXCEPTION_HALT_PROCESSING;
2731: END IF;
2732: p_pdtv_rec.name := Okl_Accounting_Util.okl_upper(p_pdtv_rec.name);
2733: EXCEPTION
2734: WHEN G_EXCEPTION_HALT_PROCESSING THEN
2735: -- no processing necessary; validation can continue
2736: -- with the next column