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.49.12020000.3 2013/02/25 10:00:56 jjuneja 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 373: 'before OKL_AM_CALCULATE_QUOTE_PVT.append_quote_line calls okl_accounting_util.convert_to_functional_currency'||l_return_status);

369: -- convert amount to functional currency
370:
371: IF (is_debug_statement_on) THEN
372: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,
373: 'before OKL_AM_CALCULATE_QUOTE_PVT.append_quote_line calls okl_accounting_util.convert_to_functional_currency'||l_return_status);
374: END IF;
375:
376: okl_accounting_util.convert_to_functional_currency(
377: p_khr_id => p_qtev_rec.khr_id,

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

386: x_converted_amount => lx_converted_amount );
387:
388: IF (is_debug_statement_on) THEN
389: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,
390: 'After OKL_AM_CALCULATE_QUOTE_PVT.append_quote_line calls okl_accounting_util.convert_to_functional_currency'||l_return_status);
391: END IF;
392:
393: IF (l_return_status = OKL_API.G_RET_STS_SUCCESS) THEN
394: l_tqlv_rec.currency_code := l_contract_curr_code ;

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

588: -- End : Bug 6030917 : prasjain
589:
590: IF (is_debug_statement_on) THEN
591: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,
592: 'Before OKL_AM_CALCULATE_QUOTE_PVT.contract_lines calls okl_am_util_pvt.get_net_investment'||l_return_status);
593: END IF;
594:
595:
596: -- Calculate Net Investment

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

603: x_return_status => l_return_status);
604:
605: IF (is_debug_statement_on) THEN
606: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,
607: 'After OKL_AM_CALCULATE_QUOTE_PVT.contract_lines calls okl_am_util_pvt.get_net_investment'||l_return_status);
608: END IF;
609:
610: -- Start : Bug 6030917 : prasjain
611: --NIV prorated okl_am_util_pvt.inside get_net_investment().

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

632: */
633:
634: IF (is_debug_statement_on) THEN
635: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,
636: 'Before OKL_AM_CALCULATE_QUOTE_PVT.contract_lines calls okl_am_calc_quote_stream_pvt.calc_stream_type_operand'||l_return_status);
637: END IF;
638:
639:
640:

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

648: x_return_status => l_return_status);
649:
650: IF (is_debug_statement_on) THEN
651: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,
652: 'After OKL_AM_CALCULATE_QUOTE_PVT.contract_lines calls okl_am_calc_quote_stream_pvt.calc_stream_type_operand'||l_return_status);
653: END IF;
654:
655: IF l_return_status <> OKL_API.G_RET_STS_SUCCESS THEN
656: l_asset_value := okl_am_util_pvt.get_ak_attribute(p_code => 'OKL_UNBILLED_RECIVABLES');

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

699: -- SECHAWLA - Bug 2680542 : Added p_asset_qty and p_quote_qty parameters in call to append_quote_line procedure.
700: -- Changed reference p_asset_tbl(l_asset_tbl_index) to p_asset_tbl(l_asset_tbl_index).p_asset_id
701: IF (is_debug_statement_on) THEN
702: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,
703: 'Before OKL_AM_CALCULATE_QUOTE_PVT.contract_lines calls append_quote_line'||l_return_status);
704: END IF;
705:
706:
707: append_quote_line (

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

729: END LOOP;
730:
731: IF (is_debug_statement_on) THEN
732: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,
733: 'After OKL_AM_CALCULATE_QUOTE_PVT.contract_lines calls append_quote_line'||l_return_status);
734: END IF;
735:
736: END IF;
737:

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

1050: p_source_table => 'OKL_TRX_QUOTES_B'); -- SOURCE_TABLE IS OKL_TRX_QUOTES_B
1051:
1052: IF (is_debug_statement_on) THEN
1053: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,
1054: 'After OKL_AM_CALCULATE_QUOTE_PVT.estimate_tax calls OKL_PROCESS_SALES_TAX_PUB.calculate_sales_tax :'||l_return_status);
1055: END IF;
1056: x_return_status := l_return_status; -- rmunjulu Sales_Tax_Enhancement
1057:
1058: EXCEPTION

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

6275: -- ***************************************************************
6276:
6277: IF (is_debug_statement_on) THEN
6278: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,
6279: 'Before OKL_AM_CALCULATE_QUOTE_PVT.generate calls OKL_API.START_ACTIVITY :'||l_return_status);
6280: END IF;
6281:
6282: l_return_status := OKL_API.START_ACTIVITY (
6283: l_api_name,

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

6289: x_return_status);
6290:
6291: IF (is_debug_statement_on) THEN
6292: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,
6293: 'After OKL_AM_CALCULATE_QUOTE_PVT.generate calls OKL_API.START_ACTIVITY :'||l_return_status);
6294: END IF;
6295:
6296: IF l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
6297: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

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

6388: THEN
6389:
6390: IF (is_debug_statement_on) THEN
6391: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,
6392: 'Before OKL_AM_CALCULATE_QUOTE_PVT.generate calls termination :'||l_return_status);
6393: END IF;
6394:
6395: termination (
6396: p_qtev_rec => l_qtev_rec,

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

6399: x_return_status => l_return_status);
6400:
6401: IF (is_debug_statement_on) THEN
6402: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,
6403: 'After OKL_AM_CALCULATE_QUOTE_PVT.generate calls termination :'||l_return_status);
6404: END IF;
6405:
6406: l_overall_status := l_return_status;
6407:

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

6408: ELSIF l_qtev_rec.qtp_code = 'REP_STANDARD' THEN
6409:
6410: IF (is_debug_statement_on) THEN
6411: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,
6412: 'Before OKL_AM_CALCULATE_QUOTE_PVT.generate calls repurchase_temp :'||l_return_status);
6413: END IF;
6414:
6415: repurchase_temp (
6416: p_qtev_rec => l_qtev_rec,

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

6419: x_return_status => l_return_status);
6420:
6421: IF (is_debug_statement_on) THEN
6422: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,
6423: 'After OKL_AM_CALCULATE_QUOTE_PVT.generate calls repurchase_temp :'||l_return_status);
6424: END IF;
6425:
6426: l_overall_status := l_return_status;
6427:

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

6491: -- *********************************************
6492:
6493: IF (is_debug_statement_on) THEN
6494: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,
6495: 'Before OKL_AM_CALCULATE_QUOTE_PVT.generate calls contract_lines :'||l_return_status);
6496: END IF;
6497:
6498: contract_lines (
6499: p_qtev_rec => l_qtev_rec,

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

6502: x_return_status => l_return_status);
6503:
6504: IF (is_debug_statement_on) THEN
6505: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,
6506: 'After OKL_AM_CALCULATE_QUOTE_PVT.generate calls contract_lines :'||l_return_status);
6507: END IF;
6508:
6509: IF l_return_status <> OKL_API.G_RET_STS_SUCCESS THEN
6510: IF l_overall_status <> OKL_API.G_RET_STS_UNEXP_ERROR THEN

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

6521: IF l_tqlv_tbl.COUNT > 0 THEN
6522:
6523: IF (is_debug_statement_on) THEN
6524: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,
6525: 'Before OKL_AM_CALCULATE_QUOTE_PVT.generate calls OKL_TQL_PVT.insert_row_bulk :'||l_return_status);
6526: END IF;
6527:
6528: -- PAGARG Bug 4300443 Call bulk insert instead of usual insert
6529: OKL_TQL_PVT.insert_row_bulk(

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

6536: x_tqlv_tbl => lx_tqlv_tbl);
6537:
6538: IF (is_debug_statement_on) THEN
6539: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,
6540: 'After OKL_AM_CALCULATE_QUOTE_PVT.generate calls OKL_TQL_PVT.insert_row_bulk :'||l_return_status);
6541: END IF;
6542:
6543: IF l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
6544: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

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

6552:
6553:
6554: IF (is_debug_statement_on) THEN
6555: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,
6556: 'Before OKL_AM_CALCULATE_QUOTE_PVT.generate calls OKL_TXL_QUOTE_LINES_PUB.insert_txl_quote_lines :'||l_return_status);
6557: END IF;
6558:
6559: OKL_TXL_QUOTE_LINES_PUB.insert_txl_quote_lines (
6560: p_api_version => l_api_version,

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

6566: x_tqlv_tbl => lx_tqlv_tbl);
6567:
6568: IF (is_debug_statement_on) THEN
6569: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,
6570: 'After OKL_AM_CALCULATE_QUOTE_PVT.generate calls OKL_TXL_QUOTE_LINES_PUB.insert_txl_quote_lines :'||l_return_status);
6571: END IF;
6572:
6573: IF l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
6574: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

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

6588: IF l_tqlv_tbl.COUNT > 0 THEN
6589:
6590: IF (is_debug_statement_on) THEN
6591: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,
6592: 'Before OKL_AM_CALCULATE_QUOTE_PVT.generate calls estimate_tax:'||l_return_status);
6593: END IF;
6594:
6595: estimate_tax (
6596: p_qtev_rec => l_qtev_rec,

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

6599: x_return_status => l_return_status);
6600:
6601: IF (is_debug_statement_on) THEN
6602: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,
6603: 'After OKL_AM_CALCULATE_QUOTE_PVT.generate calls estimate_tax:'||l_return_status);
6604: END IF;
6605:
6606: IF l_return_status <> OKL_API.G_RET_STS_SUCCESS THEN
6607: IF l_overall_status <> OKL_API.G_RET_STS_UNEXP_ERROR THEN

Line 6683: END OKL_AM_CALCULATE_QUOTE_PVT;

6679:
6680: END generate;
6681:
6682:
6683: END OKL_AM_CALCULATE_QUOTE_PVT;