eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKL_PRICING_UTILS_PVT dependencies on STANDARD

Line 340: -- Code to be written for handling the Standard Quote

336: l_so_hdr_rec.target_periods := t_rec.target_periods;
337: END LOOP;
338: ELSIF p_so_type = 'SQ'
339: THEN
340: -- Code to be written for handling the Standard Quote
341: NULL;
342: ELSE
343: -- Code to be written for raising an exception
344: OKL_API.SET_MESSAGE( p_app_name => g_app_name,

Line 4868: -- API which accepts the standard rate template version id and

4864: x_msg_data => x_msg_data,
4865: p_api_type => g_api_type);
4866: END get_lease_rate_factors;
4867:
4868: -- API which accepts the standard rate template version id and
4869: -- returns all the SRT details !
4870: PROCEDURE get_standard_rates(
4871: p_api_version IN NUMBER,
4872: p_init_msg_list IN VARCHAR2,

Line 4870: PROCEDURE get_standard_rates(

4866: END get_lease_rate_factors;
4867:
4868: -- API which accepts the standard rate template version id and
4869: -- returns all the SRT details !
4870: PROCEDURE get_standard_rates(
4871: p_api_version IN NUMBER,
4872: p_init_msg_list IN VARCHAR2,
4873: x_return_status OUT NOCOPY VARCHAR2,
4874: x_msg_count OUT NOCOPY NUMBER,

Line 4923: l_api_name CONSTANT VARCHAR2(30) DEFAULT 'get_standard_rates';

4919: AND hdr.index_id = indx.idx_id
4920: AND p_date BETWEEN indx.datetime_valid AND NVL(indx.datetime_invalid,p_date+1);
4921: -- Local Variables
4922: l_api_version CONSTANT NUMBER DEFAULT 1.0;
4923: l_api_name CONSTANT VARCHAR2(30) DEFAULT 'get_standard_rates';
4924: l_return_status VARCHAR2(1);
4925: l_module CONSTANT fnd_log_messages.module%TYPE := 'LEASE.ACCOUNTING.PRICING.'
4926: || G_PKG_NAME || '.' || UPPER(l_api_name);
4927: l_debug_enabled VARCHAR2(10);

Line 4970: 'Standard Rate Template ID is required !! ' );

4966: END IF;
4967: IF p_srt_id IS NULL
4968: THEN
4969: put_in_log(l_debug_enabled,is_debug_procedure_on,is_debug_statement_on,l_module, 'S',
4970: 'Standard Rate Template ID is required !! ' );
4971: OKL_API.set_message(
4972: G_APP_NAME,
4973: OKL_API.G_REQUIRED_VALUE,
4974: OKL_API.G_COL_NAME_TOKEN,

Line 4975: 'STANDARD RATE TEMPLATE ID');

4971: OKL_API.set_message(
4972: G_APP_NAME,
4973: OKL_API.G_REQUIRED_VALUE,
4974: OKL_API.G_COL_NAME_TOKEN,
4975: 'STANDARD RATE TEMPLATE ID');
4976: RAISE OKL_API.G_EXCEPTION_ERROR;
4977: END IF;
4978: put_in_log(l_debug_enabled,is_debug_procedure_on,is_debug_statement_on,l_module, 'S',
4979: ': p_srt_id= ' || p_srt_id );

Line 5081: END get_standard_rates;

5077: p_exc_name => 'OTHERS',
5078: x_msg_count => x_msg_count,
5079: x_msg_data => x_msg_data,
5080: p_api_type => g_api_type);
5081: END get_standard_rates;
5082:
5083: PROCEDURE compute_bk_yield(
5084: p_api_version IN NUMBER,
5085: p_init_msg_list IN VARCHAR2,

Line 5856: l_ac_rec_type.target_type := 'QUOTE'; -- Same for both Quick Quote and Standard Quote

5852: l_ac_rec_type.src_id := l_lrs_details.adj_mat_version_id; -- Pricing adjustment matrix ID
5853: l_ac_rec_type.source_name := NULL; -- NOT Mandatory Pricing Adjustment Matrix Name !
5854: l_ac_rec_type.target_id := p_qq_hdr_rec.ID ; -- Quote ID
5855: l_ac_rec_type.src_type := 'PAM'; -- Lookup Code
5856: l_ac_rec_type.target_type := 'QUOTE'; -- Same for both Quick Quote and Standard Quote
5857: l_ac_rec_type.target_eff_from := p_qq_hdr_rec.expected_start_date; -- Quote effective From
5858: l_ac_rec_type.term := p_qq_hdr_rec.term; -- Remaining four will be from teh business object like QQ / LQ
5859: l_ac_rec_type.territory := p_qq_hdr_rec.sales_territory_id;
5860: l_ac_rec_type.deal_size := l_sum_fin_amt; -- Not sure how to pass this value

Line 6092: -- Standard Rate Template Variables

6088: -- Lease Rate Factor Variables
6089: l_lrs_details lrs_details_rec_type;
6090: l_lrs_factor lrs_factor_rec_type;
6091: l_lrs_levels lrs_levels_tbl_type;
6092: -- Standard Rate Template Variables
6093: l_srt_details srt_details_rec_type;
6094: l_ac_rec_type OKL_EC_EVALUATE_PVT.okl_ac_rec_type;
6095: l_adj_factor NUMBER;
6096: l_deal_size NUMBER;

Line 6128: -- Extract details from the Standard Rate Template

6124: l_adj_factor := 0;
6125:
6126: IF p_qq_hdr_rec.rate_template_id IS NOT NULL
6127: THEN
6128: -- Extract details from the Standard Rate Template
6129: put_in_log(l_debug_enabled,is_debug_procedure_on,is_debug_statement_on,l_module, 'S',
6130: 'Fetching the Details from the Standard Rate Template ' );
6131: get_standard_rates(
6132: p_api_version => p_api_version,

Line 6130: 'Fetching the Details from the Standard Rate Template ' );

6126: IF p_qq_hdr_rec.rate_template_id IS NOT NULL
6127: THEN
6128: -- Extract details from the Standard Rate Template
6129: put_in_log(l_debug_enabled,is_debug_procedure_on,is_debug_statement_on,l_module, 'S',
6130: 'Fetching the Details from the Standard Rate Template ' );
6131: get_standard_rates(
6132: p_api_version => p_api_version,
6133: p_init_msg_list => p_init_msg_list,
6134: x_return_status => l_return_status,

Line 6131: get_standard_rates(

6127: THEN
6128: -- Extract details from the Standard Rate Template
6129: put_in_log(l_debug_enabled,is_debug_procedure_on,is_debug_statement_on,l_module, 'S',
6130: 'Fetching the Details from the Standard Rate Template ' );
6131: get_standard_rates(
6132: p_api_version => p_api_version,
6133: p_init_msg_list => p_init_msg_list,
6134: x_return_status => l_return_status,
6135: x_msg_count => x_msg_count,

Line 6162: l_ac_rec_type.target_type := 'QUOTE'; -- Same for both Quick Quote and Standard Quote

6158: l_ac_rec_type.src_id := l_srt_details.adj_mat_version_id; -- Pricing adjustment matrix ID
6159: l_ac_rec_type.source_name := NULL; -- NOT Mandatory Pricing Adjustment Matrix Name !
6160: l_ac_rec_type.target_id := p_qq_hdr_rec.ID ; -- Quote ID
6161: l_ac_rec_type.src_type := 'PAM'; -- Lookup Code
6162: l_ac_rec_type.target_type := 'QUOTE'; -- Same for both Quick Quote and Standard Quote
6163: l_ac_rec_type.target_eff_from := p_qq_hdr_rec.expected_start_date; -- Quote effective From
6164: l_ac_rec_type.term := p_qq_hdr_rec.term; -- Remaining four will be from teh business object like QQ / LQ
6165: l_ac_rec_type.territory := p_qq_hdr_rec.sales_territory_id;
6166: l_ac_rec_type.deal_size := l_deal_size;

Line 6457: -- Standard Rate Template Variables

6453: l_cash_flow_det_tbl so_cash_flow_details_tbl_type;
6454: i NUMBER; -- Index for looping over the Cash Flow Details
6455: l_months_per_period NUMBER;
6456: l_months_after NUMBER;
6457: -- Standard Rate Template Variables
6458: l_srt_details srt_details_rec_type;
6459: l_ac_rec_type OKL_EC_EVALUATE_PVT.okl_ac_rec_type;
6460: l_adj_factor NUMBER;
6461: l_months_factor NUMBER;

Line 6514: -- Extract details from the Standard Rate Template

6510: -- Fetch the target column values ..
6511: OPEN quote_csr(qteid => l_lq_id );
6512: FETCH quote_csr INTO quote_rec;
6513: CLOSE quote_csr;
6514: -- Extract details from the Standard Rate Template
6515: put_in_log(l_debug_enabled,is_debug_procedure_on,is_debug_statement_on,l_module, 'S',
6516: 'Fetching the Details from the Standard Rate Template ' );
6517: get_standard_rates(
6518: p_api_version => p_api_version,

Line 6516: 'Fetching the Details from the Standard Rate Template ' );

6512: FETCH quote_csr INTO quote_rec;
6513: CLOSE quote_csr;
6514: -- Extract details from the Standard Rate Template
6515: put_in_log(l_debug_enabled,is_debug_procedure_on,is_debug_statement_on,l_module, 'S',
6516: 'Fetching the Details from the Standard Rate Template ' );
6517: get_standard_rates(
6518: p_api_version => p_api_version,
6519: p_init_msg_list => p_init_msg_list,
6520: x_return_status => l_return_status,

Line 6517: get_standard_rates(

6513: CLOSE quote_csr;
6514: -- Extract details from the Standard Rate Template
6515: put_in_log(l_debug_enabled,is_debug_procedure_on,is_debug_statement_on,l_module, 'S',
6516: 'Fetching the Details from the Standard Rate Template ' );
6517: get_standard_rates(
6518: p_api_version => p_api_version,
6519: p_init_msg_list => p_init_msg_list,
6520: x_return_status => l_return_status,
6521: x_msg_count => x_msg_count,

Line 6545: l_ac_rec_type.target_type := 'QUOTE'; -- Same for both Quick Quote and Standard Quote

6541: l_ac_rec_type.src_id := l_srt_details.adj_mat_version_id; -- Pricing adjustment matrix ID
6542: l_ac_rec_type.source_name := NULL; -- NOT Mandatory Pricing Adjustment Matrix Name !
6543: l_ac_rec_type.target_id := l_lq_id; -- Quote ID
6544: l_ac_rec_type.src_type := 'PAM'; -- Lookup Code
6545: l_ac_rec_type.target_type := 'QUOTE'; -- Same for both Quick Quote and Standard Quote
6546: l_ac_rec_type.target_eff_from := p_adj_mat_cat_rec.target_eff_from; -- Quote effective From
6547: l_ac_rec_type.term := p_adj_mat_cat_rec.term; -- Remaining four will be from teh business object like QQ / LQ
6548: l_ac_rec_type.territory := p_adj_mat_cat_rec.territory;
6549: l_ac_rec_type.deal_size := p_adj_mat_cat_rec.deal_size; -- Not sure how to pass this value

Line 8465: -- Procedure Name : price_standard_quote_asset

8461: END distribute_fin_amount_lq;
8462:
8463: --------------------------------------------------------------------------------
8464: -- Start of Commnets
8465: -- Procedure Name : price_standard_quote_asset
8466: -- Description : This API would have been called once for each asset
8467: -- which has overridden the Quote Level Pricing Structure !
8468: -- Business Rules :
8469: -- Parameters :

Line 8484: -- the price_standard_quote api can use the already built streams for this asset

8480: -- to be overriding the payment structure defined at the LQ level.
8481: -- Hence, the Asset Level Cash flow Details will be fetched/defined ( incase of SRT )
8482: -- and the asset will be priced based on such information.
8483: -- 2/ Added, x_pricing_parameter_rec as an output parameter, because
8484: -- the price_standard_quote api can use the already built streams for this asset
8485: -- directly instead of it generating them again.
8486: -- End of Commnets
8487: --------------------------------------------------------------------------------
8488: PROCEDURE price_standard_quote_asset(

Line 8488: PROCEDURE price_standard_quote_asset(

8484: -- the price_standard_quote api can use the already built streams for this asset
8485: -- directly instead of it generating them again.
8486: -- End of Commnets
8487: --------------------------------------------------------------------------------
8488: PROCEDURE price_standard_quote_asset(
8489: x_return_status OUT NOCOPY VARCHAR2,
8490: x_msg_count OUT NOCOPY NUMBER,
8491: x_msg_data OUT NOCOPY VARCHAR2,
8492: p_api_version IN NUMBER,

Line 8501: l_api_name CONSTANT VARCHAR2(30) DEFAULT 'price_standard_quote_asset';

8497: p_target_rate IN NUMBER,
8498: x_pricing_parameter_rec IN OUT NOCOPY pricing_parameter_rec_type)
8499: IS
8500: l_api_version CONSTANT NUMBER DEFAULT 1.0;
8501: l_api_name CONSTANT VARCHAR2(30) DEFAULT 'price_standard_quote_asset';
8502: l_return_status VARCHAR2(1);
8503: l_module CONSTANT fnd_log_messages.module%TYPE := 'LEASE.ACCOUNTING.PRICING.'
8504: || G_PKG_NAME || '.' || UPPER(l_api_name);
8505:

Line 9298: l_ac_rec_type.target_type := 'QUOTE'; -- Same for both Quick Quote and Standard Quote

9294: l_ac_rec_type.src_id := l_lrs_details.adj_mat_version_id; -- Pricing adjustment matrix ID
9295: l_ac_rec_type.source_name := NULL; -- NOT Mandatory Pricing Adjustment Matrix Name !
9296: l_ac_rec_type.target_id := quote_rec.ID ; -- Quote ID
9297: l_ac_rec_type.src_type := 'PAM'; -- Lookup Code
9298: l_ac_rec_type.target_type := 'QUOTE'; -- Same for both Quick Quote and Standard Quote
9299: l_ac_rec_type.target_eff_from := quote_rec.expected_start_date; -- Quote effective From
9300: l_ac_rec_type.term := quote_rec.term; -- Remaining four will be from teh business object like QQ / LQ
9301: l_ac_rec_type.territory := l_adj_mat_cat_rec.territory;
9302: l_ac_rec_type.deal_size := lx_pricing_parameter_rec.financed_amount; -- Not sure how to pass this value

Line 9905: END price_standard_quote_asset;

9901: p_exc_name => 'OTHERS',
9902: x_msg_count => x_msg_count,
9903: x_msg_data => x_msg_data,
9904: p_api_type => g_api_type);
9905: END price_standard_quote_asset;
9906: --------------------------------------------------------------------------------
9907: -- Start of Commnets
9908: -- Procedure Name : is_asset_overriding
9909: -- Description :

Line 10018: -- Procedure Name : Price_Standard_Quote

10014: END is_asset_overriding;
10015:
10016: --------------------------------------------------------------------------------
10017: -- Start of Commnets
10018: -- Procedure Name : Price_Standard_Quote
10019: -- Description :
10020: -- Business Rules :
10021: -- Parameters :
10022: -- Version : 1.0

Line 10475: -- Procedure Name : Price_Standard_Quote

10471: END solve_pmnts_at_lq;
10472:
10473: --------------------------------------------------------------------------------
10474: -- Start of Commnets
10475: -- Procedure Name : Price_Standard_Quote
10476: -- Description :
10477: -- Business Rules :
10478: -- Parameters :
10479: -- Version : 1.0

Line 10483: PROCEDURE price_standard_quote(x_return_status OUT NOCOPY VARCHAR2,

10479: -- Version : 1.0
10480: -- History : ssiruvol 22-May-2005 - created
10481: -- End of Commnets
10482: --------------------------------------------------------------------------------
10483: PROCEDURE price_standard_quote(x_return_status OUT NOCOPY VARCHAR2,
10484: x_msg_count OUT NOCOPY NUMBER,
10485: x_msg_data OUT NOCOPY VARCHAR2,
10486: p_api_version IN NUMBER,
10487: p_init_msg_list IN VARCHAR2,

Line 10491: l_api_name CONSTANT VARCHAR2(30) DEFAULT 'price_standard_quote';

10487: p_init_msg_list IN VARCHAR2,
10488: p_qte_id IN NUMBER)
10489: IS
10490: l_api_version CONSTANT NUMBER DEFAULT 1.0;
10491: l_api_name CONSTANT VARCHAR2(30) DEFAULT 'price_standard_quote';
10492: l_return_status VARCHAR2(1);
10493: l_module CONSTANT fnd_log_messages.module%TYPE := 'LEASE.ACCOUNTING.PRICING.'
10494: || G_PKG_NAME || '.' || UPPER(l_api_name);
10495:

Line 11217: price_standard_quote_asset(

11213: IF assets_rec.fee_type = 'FREE_FORM1'
11214: THEN
11215: put_in_log(l_debug_enabled,is_debug_procedure_on,is_debug_statement_on,l_module, 'S',
11216: ' Asset with ID '|| assets_rec.ast_id || ' overrides the payment structure @ LQ level' );
11217: price_standard_quote_asset(
11218: x_return_status => l_return_status,
11219: x_msg_count => x_msg_count,
11220: x_msg_data => x_msg_data,
11221: p_api_version => p_api_version,

Line 11229: 'After price_standard_quote_asset ' || l_return_status );

11225: p_price_at_lq_level => FALSE, -- Use Asset Level Cash flows only !
11226: p_target_rate => NULL,
11227: x_pricing_parameter_rec => l_tmp_pricing_parameter_rec );
11228: put_in_log(l_debug_enabled,is_debug_procedure_on,is_debug_statement_on,l_module, 'S',
11229: 'After price_standard_quote_asset ' || l_return_status );
11230: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
11231: RAISE okl_api.g_exception_unexpected_error;
11232: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
11233: RAISE okl_api.g_exception_error;

Line 11372: ' Calling price_standard_quote_asset for ' || assets_rec.fee_type || ' with ID ' || assets_rec.fee_id );

11368: LOOP
11369: IF assets_rec.fee_type IN ( 'ROLLOVER', 'FINANCED')
11370: THEN
11371: put_in_log(l_debug_enabled,is_debug_procedure_on,is_debug_statement_on,l_module, 'S',
11372: ' Calling price_standard_quote_asset for ' || assets_rec.fee_type || ' with ID ' || assets_rec.fee_id );
11373: -- Price the fees ROLLOVER OR FINANCED
11374: price_standard_quote_asset(
11375: x_return_status => l_return_status,
11376: x_msg_count => x_msg_count,

Line 11374: price_standard_quote_asset(

11370: THEN
11371: put_in_log(l_debug_enabled,is_debug_procedure_on,is_debug_statement_on,l_module, 'S',
11372: ' Calling price_standard_quote_asset for ' || assets_rec.fee_type || ' with ID ' || assets_rec.fee_id );
11373: -- Price the fees ROLLOVER OR FINANCED
11374: price_standard_quote_asset(
11375: x_return_status => l_return_status,
11376: x_msg_count => x_msg_count,
11377: x_msg_data => x_msg_data,
11378: p_api_version => p_api_version,

Line 11386: 'After price_standard_quote_asset ' || l_return_status );

11382: p_price_at_lq_level => FALSE, -- Use Asset Level Cash flows only !
11383: p_target_rate => NULL,
11384: x_pricing_parameter_rec => l_tmp_pricing_parameter_rec );
11385: put_in_log(l_debug_enabled,is_debug_procedure_on,is_debug_statement_on,l_module, 'S',
11386: 'After price_standard_quote_asset ' || l_return_status );
11387: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
11388: RAISE okl_api.g_exception_unexpected_error;
11389: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
11390: RAISE okl_api.g_exception_error;

Line 11761: price_standard_quote_asset(

11757: IF assets_rec.fee_type = 'FREE_FORM1' --, 'ROLLOVER', 'FINANCED' )
11758: THEN
11759: put_in_log(l_debug_enabled,is_debug_procedure_on,is_debug_statement_on,l_module, 'S',
11760: ' Asset Overrides the Payment Structure defined @ Lease Quote level ' || assets_rec.asset_number );
11761: price_standard_quote_asset(
11762: x_return_status => l_return_status,
11763: x_msg_count => x_msg_count,
11764: x_msg_data => x_msg_data,
11765: p_api_version => p_api_version,

Line 11773: 'PM = SF | After price_Standard_quote_asset l_return_Status = '|| l_return_status );

11769: p_price_at_lq_level => FALSE, -- Use Asset Level Cash flows only !
11770: p_target_rate => NULL,
11771: x_pricing_parameter_rec => l_tmp_pricing_parameter_rec );
11772: put_in_log(l_debug_enabled,is_debug_procedure_on,is_debug_statement_on,l_module, 'S',
11773: 'PM = SF | After price_Standard_quote_asset l_return_Status = '|| l_return_status );
11774: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
11775: RAISE okl_api.g_exception_unexpected_error;
11776: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
11777: RAISE okl_api.g_exception_error;

Line 11966: ' Calling price_standard_quote_asset for ' || assets_rec.fee_type || ' with ID ' || assets_rec.fee_id );

11962: LOOP
11963: IF assets_rec.fee_type IN ( 'ROLLOVER', 'FINANCED')
11964: THEN
11965: put_in_log(l_debug_enabled,is_debug_procedure_on,is_debug_statement_on,l_module, 'S',
11966: ' Calling price_standard_quote_asset for ' || assets_rec.fee_type || ' with ID ' || assets_rec.fee_id );
11967: -- Price the fees ROLLOVER OR FINANCED
11968: price_standard_quote_asset(
11969: x_return_status => l_return_status,
11970: x_msg_count => x_msg_count,

Line 11968: price_standard_quote_asset(

11964: THEN
11965: put_in_log(l_debug_enabled,is_debug_procedure_on,is_debug_statement_on,l_module, 'S',
11966: ' Calling price_standard_quote_asset for ' || assets_rec.fee_type || ' with ID ' || assets_rec.fee_id );
11967: -- Price the fees ROLLOVER OR FINANCED
11968: price_standard_quote_asset(
11969: x_return_status => l_return_status,
11970: x_msg_count => x_msg_count,
11971: x_msg_data => x_msg_data,
11972: p_api_version => p_api_version,

Line 11980: 'After price_standard_quote_asset ' || l_return_status );

11976: p_price_at_lq_level => FALSE, -- Use Fee Level Cash flows only !
11977: p_target_rate => NULL,
11978: x_pricing_parameter_rec => l_tmp_pricing_parameter_rec );
11979: put_in_log(l_debug_enabled,is_debug_procedure_on,is_debug_statement_on,l_module, 'S',
11980: 'After price_standard_quote_asset ' || l_return_status );
11981: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
11982: RAISE okl_api.g_exception_unexpected_error;
11983: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
11984: RAISE okl_api.g_exception_error;

Line 12342: price_standard_quote_asset(

12338: IF assets_rec.fee_type = 'FREE_FORM1'
12339: THEN
12340: put_in_log(l_debug_enabled,is_debug_procedure_on,is_debug_statement_on,l_module, 'S',
12341: 'Asset with ID ' || assets_rec.ast_id || ' is overriding the payment structure defined @ LQ level !!' );
12342: price_standard_quote_asset(
12343: x_return_status => l_return_status,
12344: x_msg_count => x_msg_count,
12345: x_msg_data => x_msg_data,
12346: p_api_version => p_api_version,

Line 12354: 'Pricing method = ' || quote_rec.pricing_method || ' | After price_standard_quote_asset l_return_status = ' || l_return_status ||

12350: p_price_at_lq_level => FALSE, -- Use Asset Level Cash flows only !
12351: p_target_rate => NULL,
12352: x_pricing_parameter_rec => l_tmp_pricing_parameter_rec );
12353: put_in_log(l_debug_enabled,is_debug_procedure_on,is_debug_statement_on,l_module, 'S',
12354: 'Pricing method = ' || quote_rec.pricing_method || ' | After price_standard_quote_asset l_return_status = ' || l_return_status ||
12355: ' | assets_rec.ast_id = ' || assets_rec.ast_id );
12356: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
12357: RAISE okl_api.g_exception_unexpected_error;
12358: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN

Line 12553: price_standard_quote_asset(

12549: IF assets_rec.fee_type IN ( 'ROLLOVER', 'FINANCED' )
12550: THEN
12551: put_in_log(l_debug_enabled,is_debug_procedure_on,is_debug_statement_on,l_module, 'S',
12552: ' Pricing for fee type ' || assets_rec.fee_type );
12553: price_standard_quote_asset(
12554: x_return_status => l_return_status,
12555: x_msg_count => x_msg_count,
12556: x_msg_data => x_msg_data,
12557: p_api_version => p_api_version,

Line 12566: ' | After price_standard_quote_asset l_return_status = ' || l_return_status ||

12562: p_target_rate => NULL,
12563: x_pricing_parameter_rec => l_tmp_pricing_parameter_rec );
12564: put_in_log(l_debug_enabled,is_debug_procedure_on,is_debug_statement_on,l_module, 'S',
12565: 'Pricing method = ' || quote_rec.pricing_method ||
12566: ' | After price_standard_quote_asset l_return_status = ' || l_return_status ||
12567: ' | assets_rec.ast_id = ' || assets_rec.ast_id );
12568: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
12569: RAISE okl_api.g_exception_unexpected_error;
12570: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN

Line 12935: ' Calling price_standard_quote_asset for ' || assets_rec.fee_type || ' with ID ' || assets_rec.fee_id );

12931: LOOP
12932: IF assets_rec.fee_type IN ( 'ROLLOVER', 'FINANCED')
12933: THEN
12934: put_in_log(l_debug_enabled,is_debug_procedure_on,is_debug_statement_on,l_module, 'S',
12935: ' Calling price_standard_quote_asset for ' || assets_rec.fee_type || ' with ID ' || assets_rec.fee_id );
12936: -- Price the fees ROLLOVER OR FINANCED
12937: price_standard_quote_asset(
12938: x_return_status => l_return_status,
12939: x_msg_count => x_msg_count,

Line 12937: price_standard_quote_asset(

12933: THEN
12934: put_in_log(l_debug_enabled,is_debug_procedure_on,is_debug_statement_on,l_module, 'S',
12935: ' Calling price_standard_quote_asset for ' || assets_rec.fee_type || ' with ID ' || assets_rec.fee_id );
12936: -- Price the fees ROLLOVER OR FINANCED
12937: price_standard_quote_asset(
12938: x_return_status => l_return_status,
12939: x_msg_count => x_msg_count,
12940: x_msg_data => x_msg_data,
12941: p_api_version => p_api_version,

Line 12949: 'After price_standard_quote_asset ' || l_return_status );

12945: p_price_at_lq_level => TRUE, -- Use Asset Level Cash flows only !
12946: p_target_rate => quote_rec.target_rate / 100,
12947: x_pricing_parameter_rec => l_tmp_pricing_parameter_rec );
12948: put_in_log(l_debug_enabled,is_debug_procedure_on,is_debug_statement_on,l_module, 'S',
12949: 'After price_standard_quote_asset ' || l_return_status );
12950: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
12951: RAISE okl_api.g_exception_unexpected_error;
12952: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
12953: RAISE okl_api.g_exception_error;

Line 13396: -- For Rate Card Pricing the price_standard_quote_asset api will

13392: FOR assets_rec IN assets_csr(p_qte_id)
13393: LOOP
13394: IF assets_rec.fee_type = 'FREE_FORM1'
13395: THEN
13396: -- For Rate Card Pricing the price_standard_quote_asset api will
13397: -- a/ Create Cash flows for each configuration line
13398: -- Checks whether to pick the RC from Header of configuration level itself.
13399: -- b/ builds and return the pricing parameter record
13400: price_standard_quote_asset(

Line 13400: price_standard_quote_asset(

13396: -- For Rate Card Pricing the price_standard_quote_asset api will
13397: -- a/ Create Cash flows for each configuration line
13398: -- Checks whether to pick the RC from Header of configuration level itself.
13399: -- b/ builds and return the pricing parameter record
13400: price_standard_quote_asset(
13401: x_return_status => l_return_status,
13402: x_msg_count => x_msg_count,
13403: x_msg_data => x_msg_data,
13404: p_api_version => p_api_version,

Line 13412: 'After price_standard_quote_asset ' || l_return_status );

13408: p_price_at_lq_level => FALSE, -- Use Asset Level Cash flows only !
13409: p_target_rate => NULL,
13410: x_pricing_parameter_rec => l_tmp_pricing_parameter_rec );
13411: put_in_log(l_debug_enabled,is_debug_procedure_on,is_debug_statement_on,l_module, 'S',
13412: 'After price_standard_quote_asset ' || l_return_status );
13413: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
13414: RAISE okl_api.g_exception_unexpected_error;
13415: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
13416: RAISE okl_api.g_exception_error;

Line 13429: -- For Rate Card Pricing the price_standard_quote_asset api will

13425: FOR assets_rec IN assets_csr(p_qte_id)
13426: LOOP
13427: IF assets_rec.fee_type in ('ROLLOVER', 'FINANCED')
13428: THEN
13429: -- For Rate Card Pricing the price_standard_quote_asset api will
13430: -- a/ Create Cash flows for each configuration line
13431: -- Checks whether to pick the RC from Header of configuration level itself.
13432: -- b/ builds and return the pricing parameter record
13433: price_standard_quote_asset(

Line 13433: price_standard_quote_asset(

13429: -- For Rate Card Pricing the price_standard_quote_asset api will
13430: -- a/ Create Cash flows for each configuration line
13431: -- Checks whether to pick the RC from Header of configuration level itself.
13432: -- b/ builds and return the pricing parameter record
13433: price_standard_quote_asset(
13434: x_return_status => l_return_status,
13435: x_msg_count => x_msg_count,
13436: x_msg_data => x_msg_data,
13437: p_api_version => p_api_version,

Line 13445: 'After price_standard_quote_asset ' || l_return_status );

13441: p_price_at_lq_level => FALSE, -- Use Asset Level Cash flows only !
13442: p_target_rate => NULL,
13443: x_pricing_parameter_rec => l_tmp_pricing_parameter_rec );
13444: put_in_log(l_debug_enabled,is_debug_procedure_on,is_debug_statement_on,l_module, 'S',
13445: 'After price_standard_quote_asset ' || l_return_status );
13446: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
13447: RAISE okl_api.g_exception_unexpected_error;
13448: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
13449: RAISE okl_api.g_exception_error;

Line 13818: ' Calling price_standard_quote_asset ' || 'p_qte_id ' || p_qte_id

13814: IF assets_rec.fee_type = 'FREE_FORM1'
13815: THEN
13816: -- Price this Asset which has overridden the payment strcuture defined on the LQ !
13817: put_in_log(l_debug_enabled,is_debug_procedure_on,is_debug_statement_on,l_module, 'S',
13818: ' Calling price_standard_quote_asset ' || 'p_qte_id ' || p_qte_id
13819: || ' | assets_rec.ast_id ' || nvl(assets_rec.ast_id, assets_rec.fee_id) ||
13820: ' | p_price_at_lq_level = FALSE | p_target_rate = NULL' );
13821: price_standard_quote_asset(
13822: x_return_status => l_return_status,

Line 13821: price_standard_quote_asset(

13817: put_in_log(l_debug_enabled,is_debug_procedure_on,is_debug_statement_on,l_module, 'S',
13818: ' Calling price_standard_quote_asset ' || 'p_qte_id ' || p_qte_id
13819: || ' | assets_rec.ast_id ' || nvl(assets_rec.ast_id, assets_rec.fee_id) ||
13820: ' | p_price_at_lq_level = FALSE | p_target_rate = NULL' );
13821: price_standard_quote_asset(
13822: x_return_status => l_return_status,
13823: x_msg_count => x_msg_count,
13824: x_msg_data => x_msg_data,
13825: p_api_version => p_api_version,

Line 13833: 'After price_standard_quote_asset ' || l_return_status );

13829: p_price_at_lq_level => FALSE, -- Use Asset Level Cash flows only !
13830: p_target_rate => NULL,
13831: x_pricing_parameter_rec => l_tmp_pricing_parameter_rec );
13832: put_in_log(l_debug_enabled,is_debug_procedure_on,is_debug_statement_on,l_module, 'S',
13833: 'After price_standard_quote_asset ' || l_return_status );
13834: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
13835: RAISE okl_api.g_exception_unexpected_error;
13836: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
13837: RAISE okl_api.g_exception_error;

Line 13869: ' Calling price_standard_quote_asset for ' || assets_rec.fee_type || ' with ID ' || assets_rec.fee_id );

13865: LOOP
13866: IF assets_rec.fee_type IN ( 'ROLLOVER', 'FINANCED')
13867: THEN
13868: put_in_log(l_debug_enabled,is_debug_procedure_on,is_debug_statement_on,l_module, 'S',
13869: ' Calling price_standard_quote_asset for ' || assets_rec.fee_type || ' with ID ' || assets_rec.fee_id );
13870: -- Price the fees ROLLOVER OR FINANCED
13871: price_standard_quote_asset(
13872: x_return_status => l_return_status,
13873: x_msg_count => x_msg_count,

Line 13871: price_standard_quote_asset(

13867: THEN
13868: put_in_log(l_debug_enabled,is_debug_procedure_on,is_debug_statement_on,l_module, 'S',
13869: ' Calling price_standard_quote_asset for ' || assets_rec.fee_type || ' with ID ' || assets_rec.fee_id );
13870: -- Price the fees ROLLOVER OR FINANCED
13871: price_standard_quote_asset(
13872: x_return_status => l_return_status,
13873: x_msg_count => x_msg_count,
13874: x_msg_data => x_msg_data,
13875: p_api_version => p_api_version,

Line 13883: 'After price_standard_quote_asset ' || l_return_status );

13879: p_price_at_lq_level => FALSE, -- Use Asset Level Cash flows only !
13880: p_target_rate => NULL,
13881: x_pricing_parameter_rec => l_tmp_pricing_parameter_rec );
13882: put_in_log(l_debug_enabled,is_debug_procedure_on,is_debug_statement_on,l_module, 'S',
13883: 'After price_standard_quote_asset ' || l_return_status );
13884: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
13885: RAISE okl_api.g_exception_unexpected_error;
13886: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
13887: RAISE okl_api.g_exception_error;

Line 14538: END price_standard_quote;

14534: p_exc_name => 'OTHERS',
14535: x_msg_count => x_msg_count,
14536: x_msg_data => x_msg_data,
14537: p_api_type => g_api_type);
14538: END price_standard_quote;
14539: END OKL_PRICING_UTILS_PVT;