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_AM_CALCULATE_QUOTE_PVT dependencies on OKL_AM_CALCULATE_QUOTE_PVT

Line 1: PACKAGE BODY OKL_AM_CALCULATE_QUOTE_PVT AS

1: PACKAGE BODY OKL_AM_CALCULATE_QUOTE_PVT AS
2: /* $Header: OKLRCQUB.pls 120.46.12010000.2 2008/08/18 22:06:13 sechawla ship $ */
3:
4: -- GLOBAL VARIABLES
5: G_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;

Line 8: G_MODULE_NAME CONSTANT VARCHAR2(500) := 'okl.am.plsql.okl_am_calculate_quote_pvt.';

4: -- GLOBAL VARIABLES
5: G_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
6: G_LEVEL_STATEMENT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
7: G_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
8: G_MODULE_NAME CONSTANT VARCHAR2(500) := 'okl.am.plsql.okl_am_calculate_quote_pvt.';
9:
10: --+++++++++ rmunjulu 3797384 Future Dated Term Qte -- Start ++++++++++++++++
11:
12: -- declare g_add_params as global variable, so that it can be passed to all formulae

Line 161: 'before OKL_AM_CALCULATE_QUOTE_PVT.append_quote_line calls append_quote_line'||l_return_status);

157: IF p_sub_tqlv_tbl.COUNT > 0 THEN
158:
159: IF (is_debug_statement_on) THEN
160: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,
161: 'before OKL_AM_CALCULATE_QUOTE_PVT.append_quote_line calls append_quote_line'||l_return_status);
162:
163: END IF;
164:
165: l_tbl_ind := p_sub_tqlv_tbl.FIRST;

Line 193: 'After OKL_AM_CALCULATE_QUOTE_PVT.append_quote_line calls append_quote_line'||l_return_status);

189: END LOOP;
190:
191: IF (is_debug_statement_on) THEN
192: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,
193: 'After OKL_AM_CALCULATE_QUOTE_PVT.append_quote_line calls append_quote_line'||l_return_status);
194: END IF;
195:
196:
197: END IF;

Line 328: 'before OKL_AM_CALCULATE_QUOTE_PVT.append_quote_line calls okl_accounting_util.convert_to_functional_currency'||l_return_status);

324: -- convert amount to functional currency
325:
326: IF (is_debug_statement_on) THEN
327: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,
328: 'before OKL_AM_CALCULATE_QUOTE_PVT.append_quote_line calls okl_accounting_util.convert_to_functional_currency'||l_return_status);
329: END IF;
330:
331:
332: okl_accounting_util.convert_to_functional_currency(

Line 346: 'After OKL_AM_CALCULATE_QUOTE_PVT.append_quote_line calls okl_accounting_util.convert_to_functional_currency'||l_return_status);

342: x_converted_amount => lx_converted_amount );
343:
344: IF (is_debug_statement_on) THEN
345: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,
346: 'After OKL_AM_CALCULATE_QUOTE_PVT.append_quote_line calls okl_accounting_util.convert_to_functional_currency'||l_return_status);
347: END IF;
348:
349:
350: IF (l_return_status = OKL_API.G_RET_STS_SUCCESS) THEN

Line 551: 'Before OKL_AM_CALCULATE_QUOTE_PVT.contract_lines calls okl_am_util_pvt.get_net_investment'||l_return_status);

547: -- End : Bug 6030917 : prasjain
548:
549: IF (is_debug_statement_on) THEN
550: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,
551: 'Before OKL_AM_CALCULATE_QUOTE_PVT.contract_lines calls okl_am_util_pvt.get_net_investment'||l_return_status);
552: END IF;
553:
554:
555: -- Calculate Net Investment

Line 566: 'After OKL_AM_CALCULATE_QUOTE_PVT.contract_lines calls okl_am_util_pvt.get_net_investment'||l_return_status);

562: x_return_status => l_return_status);
563:
564: IF (is_debug_statement_on) THEN
565: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,
566: 'After OKL_AM_CALCULATE_QUOTE_PVT.contract_lines calls okl_am_util_pvt.get_net_investment'||l_return_status);
567: END IF;
568:
569: -- Start : Bug 6030917 : prasjain
570: --NIV prorated okl_am_util_pvt.inside get_net_investment().

Line 595: 'Before OKL_AM_CALCULATE_QUOTE_PVT.contract_lines calls okl_am_calc_quote_stream_pvt.calc_stream_type_operand'||l_return_status);

591: */
592:
593: IF (is_debug_statement_on) THEN
594: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,
595: 'Before OKL_AM_CALCULATE_QUOTE_PVT.contract_lines calls okl_am_calc_quote_stream_pvt.calc_stream_type_operand'||l_return_status);
596: END IF;
597:
598:
599:

Line 611: 'After OKL_AM_CALCULATE_QUOTE_PVT.contract_lines calls okl_am_calc_quote_stream_pvt.calc_stream_type_operand'||l_return_status);

607: x_return_status => l_return_status);
608:
609: IF (is_debug_statement_on) THEN
610: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,
611: 'After OKL_AM_CALCULATE_QUOTE_PVT.contract_lines calls okl_am_calc_quote_stream_pvt.calc_stream_type_operand'||l_return_status);
612: END IF;
613:
614: IF l_return_status <> OKL_API.G_RET_STS_SUCCESS THEN
615: l_asset_value := okl_am_util_pvt.get_ak_attribute(p_code => 'OKL_UNBILLED_RECIVABLES');

Line 662: 'Before OKL_AM_CALCULATE_QUOTE_PVT.contract_lines calls append_quote_line'||l_return_status);

658: -- SECHAWLA - Bug 2680542 : Added p_asset_qty and p_quote_qty parameters in call to append_quote_line procedure.
659: -- Changed reference p_asset_tbl(l_asset_tbl_index) to p_asset_tbl(l_asset_tbl_index).p_asset_id
660: IF (is_debug_statement_on) THEN
661: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,
662: 'Before OKL_AM_CALCULATE_QUOTE_PVT.contract_lines calls append_quote_line'||l_return_status);
663: END IF;
664:
665:
666: append_quote_line (

Line 692: 'After OKL_AM_CALCULATE_QUOTE_PVT.contract_lines calls append_quote_line'||l_return_status);

688: END LOOP;
689:
690: IF (is_debug_statement_on) THEN
691: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,
692: 'After OKL_AM_CALCULATE_QUOTE_PVT.contract_lines calls append_quote_line'||l_return_status);
693: END IF;
694:
695: END IF;
696:

Line 1013: 'After OKL_AM_CALCULATE_QUOTE_PVT.estimate_tax calls OKL_PROCESS_SALES_TAX_PUB.calculate_sales_tax :'||l_return_status);

1009: p_source_table => 'OKL_TRX_QUOTES_B'); -- SOURCE_TABLE IS OKL_TRX_QUOTES_B
1010:
1011: IF (is_debug_statement_on) THEN
1012: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,
1013: 'After OKL_AM_CALCULATE_QUOTE_PVT.estimate_tax calls OKL_PROCESS_SALES_TAX_PUB.calculate_sales_tax :'||l_return_status);
1014: END IF;
1015: x_return_status := l_return_status; -- rmunjulu Sales_Tax_Enhancement
1016:
1017: EXCEPTION

Line 6160: 'Before OKL_AM_CALCULATE_QUOTE_PVT.generate calls OKL_API.START_ACTIVITY :'||l_return_status);

6156: -- ***************************************************************
6157:
6158: IF (is_debug_statement_on) THEN
6159: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,
6160: 'Before OKL_AM_CALCULATE_QUOTE_PVT.generate calls OKL_API.START_ACTIVITY :'||l_return_status);
6161: END IF;
6162:
6163: l_return_status := OKL_API.START_ACTIVITY (
6164: l_api_name,

Line 6174: 'After OKL_AM_CALCULATE_QUOTE_PVT.generate calls OKL_API.START_ACTIVITY :'||l_return_status);

6170: x_return_status);
6171:
6172: IF (is_debug_statement_on) THEN
6173: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,
6174: 'After OKL_AM_CALCULATE_QUOTE_PVT.generate calls OKL_API.START_ACTIVITY :'||l_return_status);
6175: END IF;
6176:
6177: IF l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
6178: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

Line 6273: 'Before OKL_AM_CALCULATE_QUOTE_PVT.generate calls termination :'||l_return_status);

6269: THEN
6270:
6271: IF (is_debug_statement_on) THEN
6272: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,
6273: 'Before OKL_AM_CALCULATE_QUOTE_PVT.generate calls termination :'||l_return_status);
6274: END IF;
6275:
6276: termination (
6277: p_qtev_rec => l_qtev_rec,

Line 6284: 'After OKL_AM_CALCULATE_QUOTE_PVT.generate calls termination :'||l_return_status);

6280: x_return_status => l_return_status);
6281:
6282: IF (is_debug_statement_on) THEN
6283: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,
6284: 'After OKL_AM_CALCULATE_QUOTE_PVT.generate calls termination :'||l_return_status);
6285: END IF;
6286:
6287: l_overall_status := l_return_status;
6288:

Line 6293: 'Before OKL_AM_CALCULATE_QUOTE_PVT.generate calls repurchase_temp :'||l_return_status);

6289: ELSIF l_qtev_rec.qtp_code = 'REP_STANDARD' THEN
6290:
6291: IF (is_debug_statement_on) THEN
6292: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,
6293: 'Before OKL_AM_CALCULATE_QUOTE_PVT.generate calls repurchase_temp :'||l_return_status);
6294: END IF;
6295:
6296: repurchase_temp (
6297: p_qtev_rec => l_qtev_rec,

Line 6304: 'After OKL_AM_CALCULATE_QUOTE_PVT.generate calls repurchase_temp :'||l_return_status);

6300: x_return_status => l_return_status);
6301:
6302: IF (is_debug_statement_on) THEN
6303: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,
6304: 'After OKL_AM_CALCULATE_QUOTE_PVT.generate calls repurchase_temp :'||l_return_status);
6305: END IF;
6306:
6307: l_overall_status := l_return_status;
6308:

Line 6376: 'Before OKL_AM_CALCULATE_QUOTE_PVT.generate calls contract_lines :'||l_return_status);

6372: -- *********************************************
6373:
6374: IF (is_debug_statement_on) THEN
6375: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,
6376: 'Before OKL_AM_CALCULATE_QUOTE_PVT.generate calls contract_lines :'||l_return_status);
6377: END IF;
6378:
6379: contract_lines (
6380: p_qtev_rec => l_qtev_rec,

Line 6387: 'After OKL_AM_CALCULATE_QUOTE_PVT.generate calls contract_lines :'||l_return_status);

6383: x_return_status => l_return_status);
6384:
6385: IF (is_debug_statement_on) THEN
6386: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,
6387: 'After OKL_AM_CALCULATE_QUOTE_PVT.generate calls contract_lines :'||l_return_status);
6388: END IF;
6389:
6390: IF l_return_status <> OKL_API.G_RET_STS_SUCCESS THEN
6391: IF l_overall_status <> OKL_API.G_RET_STS_UNEXP_ERROR THEN

Line 6406: 'Before OKL_AM_CALCULATE_QUOTE_PVT.generate calls OKL_TQL_PVT.insert_row_bulk :'||l_return_status);

6402: IF l_tqlv_tbl.COUNT > 0 THEN
6403:
6404: IF (is_debug_statement_on) THEN
6405: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,
6406: 'Before OKL_AM_CALCULATE_QUOTE_PVT.generate calls OKL_TQL_PVT.insert_row_bulk :'||l_return_status);
6407: END IF;
6408:
6409: -- PAGARG Bug 4300443 Call bulk insert instead of usual insert
6410: OKL_TQL_PVT.insert_row_bulk(

Line 6421: 'After OKL_AM_CALCULATE_QUOTE_PVT.generate calls OKL_TQL_PVT.insert_row_bulk :'||l_return_status);

6417: x_tqlv_tbl => lx_tqlv_tbl);
6418:
6419: IF (is_debug_statement_on) THEN
6420: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,
6421: 'After OKL_AM_CALCULATE_QUOTE_PVT.generate calls OKL_TQL_PVT.insert_row_bulk :'||l_return_status);
6422: END IF;
6423:
6424: IF l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
6425: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

Line 6437: 'Before OKL_AM_CALCULATE_QUOTE_PVT.generate calls OKL_TXL_QUOTE_LINES_PUB.insert_txl_quote_lines :'||l_return_status);

6433:
6434:
6435: IF (is_debug_statement_on) THEN
6436: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,
6437: 'Before OKL_AM_CALCULATE_QUOTE_PVT.generate calls OKL_TXL_QUOTE_LINES_PUB.insert_txl_quote_lines :'||l_return_status);
6438: END IF;
6439:
6440: OKL_TXL_QUOTE_LINES_PUB.insert_txl_quote_lines (
6441: p_api_version => l_api_version,

Line 6451: 'After OKL_AM_CALCULATE_QUOTE_PVT.generate calls OKL_TXL_QUOTE_LINES_PUB.insert_txl_quote_lines :'||l_return_status);

6447: x_tqlv_tbl => lx_tqlv_tbl);
6448:
6449: IF (is_debug_statement_on) THEN
6450: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,
6451: 'After OKL_AM_CALCULATE_QUOTE_PVT.generate calls OKL_TXL_QUOTE_LINES_PUB.insert_txl_quote_lines :'||l_return_status);
6452: END IF;
6453:
6454: IF l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
6455: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

Line 6473: 'Before OKL_AM_CALCULATE_QUOTE_PVT.generate calls estimate_tax:'||l_return_status);

6469: IF l_tqlv_tbl.COUNT > 0 THEN
6470:
6471: IF (is_debug_statement_on) THEN
6472: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,
6473: 'Before OKL_AM_CALCULATE_QUOTE_PVT.generate calls estimate_tax:'||l_return_status);
6474: END IF;
6475:
6476: estimate_tax (
6477: p_qtev_rec => l_qtev_rec,

Line 6484: 'After OKL_AM_CALCULATE_QUOTE_PVT.generate calls estimate_tax:'||l_return_status);

6480: x_return_status => l_return_status);
6481:
6482: IF (is_debug_statement_on) THEN
6483: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,
6484: 'After OKL_AM_CALCULATE_QUOTE_PVT.generate calls estimate_tax:'||l_return_status);
6485: END IF;
6486:
6487: IF l_return_status <> OKL_API.G_RET_STS_SUCCESS THEN
6488: IF l_overall_status <> OKL_API.G_RET_STS_UNEXP_ERROR THEN

Line 6564: END OKL_AM_CALCULATE_QUOTE_PVT;

6560:
6561: END generate;
6562:
6563:
6564: END OKL_AM_CALCULATE_QUOTE_PVT;