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_SALES_QUOTE_QA_PVT dependencies on OKL_SALES_QUOTE_QA_PVT

Line 1: PACKAGE BODY OKL_SALES_QUOTE_QA_PVT AS

1: PACKAGE BODY OKL_SALES_QUOTE_QA_PVT AS
2: /* $Header: OKLRQQCB.pls 120.78 2008/01/04 19:39:51 rravikir noship $*/
3:
4: --Global Cursors
5: CURSOR get_message_text(p_message_name VARCHAR2) IS

Line 568: ,x_qa_result_tbl IN OUT NOCOPY OKL_SALES_QUOTE_QA_PVT.qa_results_tbl_type) IS

564: ,p_object_id IN NUMBER
565: ,x_return_status OUT NOCOPY VARCHAR2
566: ,x_msg_count OUT NOCOPY NUMBER
567: ,x_msg_data OUT NOCOPY VARCHAR2
568: ,x_qa_result_tbl IN OUT NOCOPY OKL_SALES_QUOTE_QA_PVT.qa_results_tbl_type) IS
569:
570: l_validation_set_id NUMBER;
571: lp_vlrv_tbl OKL_VLR_PVT.vlrv_tbl_type;
572: lx_vlrv_tbl OKL_VLR_PVT.vlrv_tbl_type;

Line 1054: ,x_qa_result_tbl IN OUT NOCOPY OKL_SALES_QUOTE_QA_PVT.qa_results_tbl_type

1050: ,p_object_id IN NUMBER
1051: ,x_return_status OUT NOCOPY VARCHAR2
1052: ,x_msg_count OUT NOCOPY NUMBER
1053: ,x_msg_data OUT NOCOPY VARCHAR2
1054: ,x_qa_result_tbl IN OUT NOCOPY OKL_SALES_QUOTE_QA_PVT.qa_results_tbl_type
1055: ,x_qa_result IN OUT NOCOPY VARCHAR2) IS
1056: i INTEGER;
1057: x VARCHAR2(2);
1058: lp_object_type VARCHAR2(30);

Line 1192: ,'end debug okl_sales_quote_qa_pvt.validate_cost_adjustments call validate_cost_adjustments');

1188:
1189: IF (l_debug_enabled = 'Y' AND is_debug_procedure_on) THEN
1190: okl_debug_pub.log_debug(fnd_log.level_procedure
1191: ,l_module
1192: ,'end debug okl_sales_quote_qa_pvt.validate_cost_adjustments call validate_cost_adjustments');
1193: END IF;
1194:
1195:
1196: EXCEPTION

Line 1255: ,x_qa_result_tbl IN OUT NOCOPY OKL_SALES_QUOTE_QA_PVT.qa_results_tbl_type

1251: ,p_object_id IN NUMBER
1252: ,x_return_status OUT NOCOPY VARCHAR2
1253: ,x_msg_count OUT NOCOPY NUMBER
1254: ,x_msg_data OUT NOCOPY VARCHAR2
1255: ,x_qa_result_tbl IN OUT NOCOPY OKL_SALES_QUOTE_QA_PVT.qa_results_tbl_type
1256: ,x_qa_result IN OUT NOCOPY VARCHAR2) IS
1257:
1258: i INTEGER;
1259: ret boolean;

Line 1265: l_module CONSTANT fnd_log_messages.module%TYPE := 'OKL_SALES_QUOTE_QA_PVT.validate_system_validation';

1261: call_user boolean;
1262: l_function_name okl_data_src_fnctns_v.name%TYPE;
1263: l_source_name okl_data_src_fnctns_v.source%TYPE;
1264: l_failure_severity VARCHAR2(30);
1265: l_module CONSTANT fnd_log_messages.module%TYPE := 'OKL_SALES_QUOTE_QA_PVT.validate_system_validation';
1266: l_debug_enabled varchar2(10);
1267: is_debug_procedure_on boolean;
1268: is_debug_statement_on boolean;
1269: l_message_name varchar2(2000);

Line 1359: ,'end debug okl_sales_quote_qa_pvt call validate_system_validation');

1355: ,x_msg_data => x_msg_data);
1356: IF (l_debug_enabled = 'Y' AND is_debug_procedure_on) THEN
1357: okl_debug_pub.log_debug(fnd_log.level_procedure
1358: ,l_module
1359: ,'end debug okl_sales_quote_qa_pvt call validate_system_validation');
1360: END IF;
1361: EXCEPTION
1362: WHEN okl_api.g_exception_error THEN
1363: IF c_validation_func%ISOPEN THEN

Line 1434: ,x_qa_result_tbl IN OUT NOCOPY OKL_SALES_QUOTE_QA_PVT.qa_results_tbl_type

1430: ,p_object_id IN NUMBER
1431: ,x_return_status OUT NOCOPY VARCHAR2
1432: ,x_msg_count OUT NOCOPY NUMBER
1433: ,x_msg_data OUT NOCOPY VARCHAR2
1434: ,x_qa_result_tbl IN OUT NOCOPY OKL_SALES_QUOTE_QA_PVT.qa_results_tbl_type
1435: ,x_qa_result IN OUT NOCOPY VARCHAR2) IS
1436: lp_object_type VARCHAR2(30);
1437: lp_quote_id NUMBER;
1438: lp_asset_id NUMBER;

Line 1629: ,'end debug okl_sales_quote_qa_pvt call validating_pricing_values');

1625:
1626: IF (l_debug_enabled = 'Y' AND is_debug_procedure_on) THEN
1627: okl_debug_pub.log_debug(fnd_log.level_procedure
1628: ,l_api_name
1629: ,'end debug okl_sales_quote_qa_pvt call validating_pricing_values');
1630: END IF;
1631: EXCEPTION
1632: WHEN OTHERS THEN
1633: x_return_status := okl_api.G_RET_STS_ERROR;

Line 1759: ,x_qa_result_tbl IN OUT NOCOPY OKL_SALES_QUOTE_QA_PVT.qa_results_tbl_type

1755: ,p_object_id IN NUMBER
1756: ,x_return_status OUT NOCOPY VARCHAR2
1757: ,x_msg_count OUT NOCOPY NUMBER
1758: ,x_msg_data OUT NOCOPY VARCHAR2
1759: ,x_qa_result_tbl IN OUT NOCOPY OKL_SALES_QUOTE_QA_PVT.qa_results_tbl_type
1760: ,x_qa_result IN OUT NOCOPY VARCHAR2) IS
1761: lp_object_type VARCHAR2(30);
1762: lp_quote_id NUMBER;
1763: lp_asset_id NUMBER;

Line 2131: ,'end debug okl_sales_quote_qa_pvt call validate_ec_criteria');

2127:
2128: IF (l_debug_enabled = 'Y' AND is_debug_procedure_on) THEN
2129: okl_debug_pub.log_debug(fnd_log.level_procedure
2130: ,l_module
2131: ,'end debug okl_sales_quote_qa_pvt call validate_ec_criteria');
2132: END IF;
2133: EXCEPTION
2134: WHEN okl_api.g_exception_error THEN
2135: x_return_status := okl_api.handle_exceptions(p_api_name =>l_api_name

Line 2182: ,x_qa_result_tbl IN OUT NOCOPY OKL_SALES_QUOTE_QA_PVT.qa_results_tbl_type

2178: ,p_object_id IN NUMBER
2179: ,x_return_status OUT NOCOPY VARCHAR2
2180: ,x_msg_count OUT NOCOPY NUMBER
2181: ,x_msg_data OUT NOCOPY VARCHAR2
2182: ,x_qa_result_tbl IN OUT NOCOPY OKL_SALES_QUOTE_QA_PVT.qa_results_tbl_type
2183: ,x_qa_result IN OUT NOCOPY VARCHAR2) IS
2184:
2185: lp_quote_id NUMBER;
2186: lp_asset_id NUMBER;

Line 2339: ,x_qa_result_tbl IN OUT NOCOPY OKL_SALES_QUOTE_QA_PVT.qa_results_tbl_type

2335: ,p_object_id IN NUMBER
2336: ,x_return_status OUT NOCOPY VARCHAR2
2337: ,x_msg_count OUT NOCOPY NUMBER
2338: ,x_msg_data OUT NOCOPY VARCHAR2
2339: ,x_qa_result_tbl IN OUT NOCOPY OKL_SALES_QUOTE_QA_PVT.qa_results_tbl_type
2340: ,x_qa_result IN OUT NOCOPY VARCHAR2) IS
2341: lp_quote_id NUMBER;
2342: lp_asset_id NUMBER;
2343: lp_rec_flag VARCHAR2(1);

Line 2576: ,'end debug okl_sales_quote_qa_pvt call extended_validations');

2572:
2573: IF (l_debug_enabled = 'Y' AND is_debug_procedure_on) THEN
2574: okl_debug_pub.log_debug(fnd_log.level_procedure
2575: ,l_module
2576: ,'end debug okl_sales_quote_qa_pvt call extended_validations');
2577: END IF;
2578:
2579: EXCEPTION
2580: WHEN okl_api.g_exception_error THEN

Line 2637: ,x_qa_result_tbl IN OUT NOCOPY OKL_SALES_QUOTE_QA_PVT.qa_results_tbl_type

2633: ,p_object_id IN NUMBER
2634: ,x_return_status OUT NOCOPY VARCHAR2
2635: ,x_msg_count OUT NOCOPY NUMBER
2636: ,x_msg_data OUT NOCOPY VARCHAR2
2637: ,x_qa_result_tbl IN OUT NOCOPY OKL_SALES_QUOTE_QA_PVT.qa_results_tbl_type
2638: ,x_qa_result IN OUT NOCOPY VARCHAR2) IS
2639:
2640: lp_quote_id NUMBER;
2641: lp_asset_id NUMBER;

Line 2766: ,'end debug okl_sales_quote_qa_pvt call check_subsidies');

2762:
2763: IF (l_debug_enabled = 'Y' AND is_debug_procedure_on) THEN
2764: okl_debug_pub.log_debug(fnd_log.level_procedure
2765: ,l_module
2766: ,'end debug okl_sales_quote_qa_pvt call check_subsidies');
2767: END IF;
2768: EXCEPTION
2769: WHEN okl_api.g_exception_error THEN
2770: x_return_status := okl_api.handle_exceptions(p_api_name =>l_api_name

Line 2824: ,x_qa_result_tbl IN OUT NOCOPY OKL_SALES_QUOTE_QA_PVT.qa_results_tbl_type

2820: ,p_object_id IN NUMBER
2821: ,x_return_status OUT NOCOPY VARCHAR2
2822: ,x_msg_count OUT NOCOPY NUMBER
2823: ,x_msg_data OUT NOCOPY VARCHAR2
2824: ,x_qa_result_tbl IN OUT NOCOPY OKL_SALES_QUOTE_QA_PVT.qa_results_tbl_type
2825: ,x_qa_result IN OUT NOCOPY VARCHAR2) IS
2826:
2827: -- bug 5048183 ssdeshpa Start
2828: -- Get all the Info abt the Assets for Quote

Line 2957: ,'end debug okl_sales_quote_qa_pvt call check_configuration ');

2953:
2954: IF (l_debug_enabled = 'Y' AND is_debug_procedure_on) THEN
2955: okl_debug_pub.log_debug(fnd_log.level_procedure
2956: ,l_module
2957: ,'end debug okl_sales_quote_qa_pvt call check_configuration ');
2958: END IF;
2959:
2960: EXCEPTION
2961: WHEN okl_api.g_exception_error THEN

Line 3017: ,x_qa_result_tbl IN OUT NOCOPY OKL_SALES_QUOTE_QA_PVT.qa_results_tbl_type

3013: ,p_object_id IN NUMBER
3014: ,x_return_status OUT NOCOPY VARCHAR2
3015: ,x_msg_count OUT NOCOPY NUMBER
3016: ,x_msg_data OUT NOCOPY VARCHAR2
3017: ,x_qa_result_tbl IN OUT NOCOPY OKL_SALES_QUOTE_QA_PVT.qa_results_tbl_type
3018: ,x_qa_result IN OUT NOCOPY VARCHAR2) IS
3019: lp_quote_id NUMBER;
3020: lp_asset_id NUMBER;
3021: lp_service_line_id NUMBER;

Line 3168: ,'end debug okl_sales_quote_qa_pvt.check_fees_and_services call');

3164:
3165: IF (l_debug_enabled = 'Y' AND is_debug_procedure_on) THEN
3166: okl_debug_pub.log_debug(fnd_log.level_procedure
3167: ,l_module
3168: ,'end debug okl_sales_quote_qa_pvt.check_fees_and_services call');
3169: END IF;
3170:
3171: EXCEPTION
3172: WHEN okl_api.g_exception_error THEN

Line 3225: ,x_qa_result_tbl IN OUT NOCOPY OKL_SALES_QUOTE_QA_PVT.qa_results_tbl_type

3221: ,p_object_id IN NUMBER
3222: ,x_return_status OUT NOCOPY VARCHAR2
3223: ,x_msg_count OUT NOCOPY NUMBER
3224: ,x_msg_data OUT NOCOPY VARCHAR2
3225: ,x_qa_result_tbl IN OUT NOCOPY OKL_SALES_QUOTE_QA_PVT.qa_results_tbl_type
3226: ,x_qa_result IN OUT NOCOPY VARCHAR2) IS
3227: lp_quote_id NUMBER;
3228: lp_service_line_id NUMBER;
3229: lp_vp_id NUMBER;

Line 4676: ,'end debug okl_sales_quote_qa_pvt call check_payment');

4672:
4673: IF (l_debug_enabled = 'Y' AND is_debug_procedure_on) THEN
4674: okl_debug_pub.log_debug(fnd_log.level_procedure
4675: ,l_module
4676: ,'end debug okl_sales_quote_qa_pvt call check_payment');
4677: END IF;
4678:
4679: EXCEPTION
4680: WHEN okl_api.g_exception_error THEN

Line 4732: ,x_qa_result_tbl OUT NOCOPY OKL_SALES_QUOTE_QA_PVT.qa_results_tbl_type) IS

4728: ,p_object_id IN NUMBER
4729: ,x_return_status OUT NOCOPY VARCHAR2
4730: ,x_msg_count OUT NOCOPY NUMBER
4731: ,x_msg_data OUT NOCOPY VARCHAR2
4732: ,x_qa_result_tbl OUT NOCOPY OKL_SALES_QUOTE_QA_PVT.qa_results_tbl_type) IS
4733: l_program_name CONSTANT VARCHAR2(30) := 'run_qa';
4734: l_api_name CONSTANT VARCHAR2(61) := l_program_name;
4735: i INTEGER;
4736: l_module CONSTANT fnd_log_messages.module%TYPE := 'SALE_QA_PVT';

Line 5126: ,'end debug okl_sales_quote_qa_pvt.run_qa3 call run_qa3');

5122: ,x_msg_data => x_msg_data);
5123: IF (l_debug_enabled = 'Y' AND is_debug_procedure_on) THEN
5124: okl_debug_pub.log_debug(fnd_log.level_procedure
5125: ,l_module
5126: ,'end debug okl_sales_quote_qa_pvt.run_qa3 call run_qa3');
5127: END IF;
5128: EXCEPTION
5129: WHEN okl_api.g_exception_error THEN
5130:

Line 5191: ,x_qa_result_tbl IN OUT NOCOPY OKL_SALES_QUOTE_QA_PVT.qa_results_tbl_type) IS

5187: ,x_return_status OUT NOCOPY VARCHAR2
5188: ,x_msg_count OUT NOCOPY NUMBER
5189: ,x_msg_data OUT NOCOPY VARCHAR2
5190: ,x_qa_result OUT NOCOPY VARCHAR2
5191: ,x_qa_result_tbl IN OUT NOCOPY OKL_SALES_QUOTE_QA_PVT.qa_results_tbl_type) IS
5192:
5193:
5194: l_program_name CONSTANT VARCHAR2(30) := 'run_qa_qq';
5195: l_api_name CONSTANT VARCHAR2(61) := l_program_name;

Line 5234: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,'okl.plsql.OKL_SALES_QUOTE_QA_PVT.run_qa_checker'

5230: RAISE okl_api.g_exception_error;
5231: END IF;
5232: ---------------Check for Valid Parent Object type----------------------
5233: IF(l_debug_enabled='Y') THEN
5234: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,'okl.plsql.OKL_SALES_QUOTE_QA_PVT.run_qa_checker'
5235: ,'begin debug call run_qa_checker');
5236: END IF;
5237: --Call wrapper run_qa_checker for QA Validations
5238: run_qa_checker (p_api_version => p_api_version

Line 5248: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,'okl.plsql.OKL_SALES_QUOTE_QA_PVT.run_qa_checker'

5244: ,x_msg_data => x_msg_data
5245: ,x_qa_result_tbl => x_qa_result_tbl);
5246:
5247: IF(l_debug_enabled='Y') THEN
5248: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,'okl.plsql.OKL_SALES_QUOTE_QA_PVT.run_qa_checker'
5249: ,'end debug call run_qa_checker');
5250: END IF;
5251: IF (x_return_status = okl_api.g_ret_sts_unexp_error) THEN
5252: RAISE okl_api.g_exception_unexpected_error;

Line 5273: ,'end debug okl_sales_quote_qa_pvt.run_qa2 call run_qa2');

5269: ,x_msg_data => x_msg_data);
5270: IF (l_debug_enabled = 'Y' AND is_debug_procedure_on) THEN
5271: okl_debug_pub.log_debug(fnd_log.level_procedure
5272: ,l_module
5273: ,'end debug okl_sales_quote_qa_pvt.run_qa2 call run_qa2');
5274: END IF;
5275:
5276: EXCEPTION
5277: WHEN okl_api.g_exception_error THEN

Line 5402: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,'okl.plsql.OKL_SALES_QUOTE_QA_PVT.run_qa_checker'

5398: ,x_msg_count => x_msg_count
5399: ,x_msg_data => x_msg_data
5400: ,x_qa_result_tbl => x_qa_result_tbl);
5401: IF(l_debug_enabled='Y') THEN
5402: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,'okl.plsql.OKL_SALES_QUOTE_QA_PVT.run_qa_checker'
5403: ,'end debug call run_qa_checker');
5404: END IF;
5405: IF (x_return_status = okl_api.g_ret_sts_unexp_error) THEN
5406: RAISE okl_api.g_exception_unexpected_error;

Line 5460: ,'end debug okl_sales_quote_qa_pvt call run_qa3');

5456:
5457: IF (l_debug_enabled = 'Y' AND is_debug_procedure_on) THEN
5458: okl_debug_pub.log_debug(fnd_log.level_procedure
5459: ,l_module
5460: ,'end debug okl_sales_quote_qa_pvt call run_qa3');
5461: END IF;
5462:
5463: EXCEPTION
5464: WHEN okl_api.g_exception_error THEN

Line 5492: END OKL_SALES_QUOTE_QA_PVT;

5488: ,x_msg_data =>x_msg_data
5489: ,p_api_type =>G_API_TYPE);
5490: END run_qa_checker;
5491: -------------------------------------------------------------------------------
5492: END OKL_SALES_QUOTE_QA_PVT;