72: is_debug_procedure_on boolean;
73: is_debug_statement_on boolean;
74:
75: BEGIN
76: l_debug_enabled := okl_debug_pub.check_log_enabled;
77: is_debug_procedure_on := okl_debug_pub.check_log_on(l_module
78: ,fnd_log.level_procedure);
79:
80: IF (l_debug_enabled = 'Y' AND is_debug_procedure_on) THEN
73: is_debug_statement_on boolean;
74:
75: BEGIN
76: l_debug_enabled := okl_debug_pub.check_log_enabled;
77: is_debug_procedure_on := okl_debug_pub.check_log_on(l_module
78: ,fnd_log.level_procedure);
79:
80: IF (l_debug_enabled = 'Y' AND is_debug_procedure_on) THEN
81: okl_debug_pub.log_debug(fnd_log.level_procedure
77: is_debug_procedure_on := okl_debug_pub.check_log_on(l_module
78: ,fnd_log.level_procedure);
79:
80: IF (l_debug_enabled = 'Y' AND is_debug_procedure_on) THEN
81: okl_debug_pub.log_debug(fnd_log.level_procedure
82: ,l_module
83: ,'begin debug OKLRECUB.pls.pls call set_fnd_message');
84: END IF;
85: fnd_message.set_name(g_app_name, p_msg_name);
100: fnd_message.set_token(token => p_token4, value => p_value4);
101: END IF;
102:
103: IF (l_debug_enabled = 'Y' AND is_debug_procedure_on) THEN
104: okl_debug_pub.log_debug(fnd_log.level_procedure
105: ,l_module
106: ,'end debug OKLRECUB.pls.pls call set_fnd_message');
107: END IF;
108:
610: p_vlrv_tbl => lp_vlrv_tbl,
611: x_vlrv_tbl => lx_vlrv_tbl);
612:
613: IF (nvl(l_debug_enabled, 'N') = 'Y' AND is_debug_statement_on) THEN
614: okl_debug_pub.log_debug(fnd_log.level_statement
615: ,l_module
616: ,'okl_sales_quote_pvt.populate_result_table returned with status ' ||
617: x_return_status ||
618: ' x_msg_data ' ||
1080: AND OAB.PARENT_OBJECT_ID = p_quote_id
1081: AND OCA.ADJUSTMENT_SOURCE_TYPE= p_adj_source_type;
1082: lp_okl_cost_adj_rec c_okl_cost_adj_rec%ROWTYPE;
1083: BEGIN
1084: l_debug_enabled := okl_debug_pub.check_log_enabled;
1085: is_debug_procedure_on := okl_debug_pub.check_log_on(l_module
1086: ,fnd_log.level_procedure);
1087:
1088:
1081: AND OCA.ADJUSTMENT_SOURCE_TYPE= p_adj_source_type;
1082: lp_okl_cost_adj_rec c_okl_cost_adj_rec%ROWTYPE;
1083: BEGIN
1084: l_debug_enabled := okl_debug_pub.check_log_enabled;
1085: is_debug_procedure_on := okl_debug_pub.check_log_on(l_module
1086: ,fnd_log.level_procedure);
1087:
1088:
1089: IF (l_debug_enabled = 'Y' AND is_debug_procedure_on) THEN
1086: ,fnd_log.level_procedure);
1087:
1088:
1089: IF (l_debug_enabled = 'Y' AND is_debug_procedure_on) THEN
1090: okl_debug_pub.log_debug(fnd_log.level_procedure
1091: ,l_module
1092: ,'begin debug OKLRQQCB.pls.validate_cost_adjustments call validate_cost_adjustments');
1093: END IF; -- check for logging on STATEMENT level
1094: is_debug_statement_on := okl_debug_pub.check_log_on(l_module
1090: okl_debug_pub.log_debug(fnd_log.level_procedure
1091: ,l_module
1092: ,'begin debug OKLRQQCB.pls.validate_cost_adjustments call validate_cost_adjustments');
1093: END IF; -- check for logging on STATEMENT level
1094: is_debug_statement_on := okl_debug_pub.check_log_on(l_module
1095: ,fnd_log.level_statement);
1096:
1097: -- call START_ACTIVITY to create savepoint, check compatibility
1098: -- and initialize message list
1186: okl_api.end_activity(x_msg_count => x_msg_count
1187: ,x_msg_data => x_msg_data);
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:
1283:
1284: l_validation_set_id NUMBER;
1285:
1286: BEGIN
1287: l_debug_enabled := okl_debug_pub.check_log_enabled;
1288: is_debug_procedure_on := okl_debug_pub.check_log_on(l_module
1289: ,fnd_log.level_procedure);
1290:
1291:
1284: l_validation_set_id NUMBER;
1285:
1286: BEGIN
1287: l_debug_enabled := okl_debug_pub.check_log_enabled;
1288: is_debug_procedure_on := okl_debug_pub.check_log_on(l_module
1289: ,fnd_log.level_procedure);
1290:
1291:
1292: IF (l_debug_enabled = 'Y' AND is_debug_procedure_on) THEN
1289: ,fnd_log.level_procedure);
1290:
1291:
1292: IF (l_debug_enabled = 'Y' AND is_debug_procedure_on) THEN
1293: okl_debug_pub.log_debug(fnd_log.level_procedure
1294: ,l_module
1295: ,'begin debug OKLRQQCB.pls call validate_system_validations');
1296: END IF; -- check for logging on STATEMENT level
1297: is_debug_statement_on := okl_debug_pub.check_log_on(l_module
1293: okl_debug_pub.log_debug(fnd_log.level_procedure
1294: ,l_module
1295: ,'begin debug OKLRQQCB.pls call validate_system_validations');
1296: END IF; -- check for logging on STATEMENT level
1297: is_debug_statement_on := okl_debug_pub.check_log_on(l_module
1298: ,fnd_log.level_statement);
1299:
1300: -- call START_ACTIVITY to create savepoint, check compatibility
1301: -- and initialize message list
1353: END IF;
1354: okl_api.end_activity(x_msg_count => x_msg_count
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
1477: AND t2.quick_quote_id=t1.id;
1478:
1479: -----------------------------------------------------------------------
1480: BEGIN
1481: l_debug_enabled := okl_debug_pub.check_log_enabled;
1482: is_debug_procedure_on := okl_debug_pub.check_log_on(l_api_name
1483: ,fnd_log.level_procedure);
1484:
1485:
1478:
1479: -----------------------------------------------------------------------
1480: BEGIN
1481: l_debug_enabled := okl_debug_pub.check_log_enabled;
1482: is_debug_procedure_on := okl_debug_pub.check_log_on(l_api_name
1483: ,fnd_log.level_procedure);
1484:
1485:
1486: IF (l_debug_enabled = 'Y' AND is_debug_procedure_on) THEN
1483: ,fnd_log.level_procedure);
1484:
1485:
1486: IF (l_debug_enabled = 'Y' AND is_debug_procedure_on) THEN
1487: okl_debug_pub.log_debug(fnd_log.level_procedure
1488: ,l_api_name
1489: ,'begin debug OKLRQQCB.pls call validating_pricing_values');
1490: END IF; -- check for logging on STATEMENT level
1491: is_debug_statement_on := okl_debug_pub.check_log_on(l_api_name
1487: okl_debug_pub.log_debug(fnd_log.level_procedure
1488: ,l_api_name
1489: ,'begin debug OKLRQQCB.pls call validating_pricing_values');
1490: END IF; -- check for logging on STATEMENT level
1491: is_debug_statement_on := okl_debug_pub.check_log_on(l_api_name
1492: ,fnd_log.level_statement);
1493:
1494: -- call START_ACTIVITY to create savepoint, check compatibility
1495: -- and initialize message list
1623: okl_api.end_activity(x_msg_count => x_msg_count
1624: ,x_msg_data => x_msg_data);
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
1825: where srt.std_rate_tmpl_id=srv.std_rate_tmpl_id
1826: AND srv.std_rate_tmpl_ver_id = p_srt_ver_id;
1827: --Bug # 5050143 ssdeshpa end
1828: BEGIN
1829: l_debug_enabled := okl_debug_pub.check_log_enabled;
1830: is_debug_procedure_on := okl_debug_pub.check_log_on(l_module
1831: ,fnd_log.level_procedure);
1832:
1833:
1826: AND srv.std_rate_tmpl_ver_id = p_srt_ver_id;
1827: --Bug # 5050143 ssdeshpa end
1828: BEGIN
1829: l_debug_enabled := okl_debug_pub.check_log_enabled;
1830: is_debug_procedure_on := okl_debug_pub.check_log_on(l_module
1831: ,fnd_log.level_procedure);
1832:
1833:
1834: IF (l_debug_enabled = 'Y' AND is_debug_procedure_on) THEN
1831: ,fnd_log.level_procedure);
1832:
1833:
1834: IF (l_debug_enabled = 'Y' AND is_debug_procedure_on) THEN
1835: okl_debug_pub.log_debug(fnd_log.level_procedure
1836: ,l_module
1837: ,'begin debug OKLRQQCB.pls call validate_ec_criteria');
1838: END IF; -- check for logging on STATEMENT level
1839: is_debug_statement_on := okl_debug_pub.check_log_on(l_module
1835: okl_debug_pub.log_debug(fnd_log.level_procedure
1836: ,l_module
1837: ,'begin debug OKLRQQCB.pls call validate_ec_criteria');
1838: END IF; -- check for logging on STATEMENT level
1839: is_debug_statement_on := okl_debug_pub.check_log_on(l_module
1840: ,fnd_log.level_statement);
1841:
1842: -- call START_ACTIVITY to create savepoint, check compatibility
1843: -- and initialize message list
2125: okl_api.end_activity(x_msg_count => x_msg_count
2126: ,x_msg_data => x_msg_data);
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
2411: l_ou_tax_upfront_yn VARCHAR2(1);
2412: l_err_msg VARCHAR2(80);
2413: --Added Bug # 5647107 ssdeshpa end
2414: BEGIN
2415: l_debug_enabled := okl_debug_pub.check_log_enabled;
2416: is_debug_procedure_on := okl_debug_pub.check_log_on(l_module
2417: ,fnd_log.level_procedure);
2418:
2419:
2412: l_err_msg VARCHAR2(80);
2413: --Added Bug # 5647107 ssdeshpa end
2414: BEGIN
2415: l_debug_enabled := okl_debug_pub.check_log_enabled;
2416: is_debug_procedure_on := okl_debug_pub.check_log_on(l_module
2417: ,fnd_log.level_procedure);
2418:
2419:
2420: IF (l_debug_enabled = 'Y' AND is_debug_procedure_on) THEN
2417: ,fnd_log.level_procedure);
2418:
2419:
2420: IF (l_debug_enabled = 'Y' AND is_debug_procedure_on) THEN
2421: okl_debug_pub.log_debug(fnd_log.level_procedure
2422: ,l_module
2423: ,'begin debug OKLRQQCB.pls call extended_validations');
2424: END IF; -- check for logging on STATEMENT level
2425: is_debug_statement_on := okl_debug_pub.check_log_on(l_module
2421: okl_debug_pub.log_debug(fnd_log.level_procedure
2422: ,l_module
2423: ,'begin debug OKLRQQCB.pls call extended_validations');
2424: END IF; -- check for logging on STATEMENT level
2425: is_debug_statement_on := okl_debug_pub.check_log_on(l_module
2426: ,fnd_log.level_statement);
2427:
2428: -- call START_ACTIVITY to create savepoint, check compatibility
2429: -- and initialize message list
2570: okl_api.end_activity(x_msg_count => x_msg_count
2571: ,x_msg_data => x_msg_data);
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:
2676:
2677: lp_lq_cost_adj_rec c_lq_cost_adj_rec%ROWTYPE;
2678:
2679: BEGIN
2680: l_debug_enabled := okl_debug_pub.check_log_enabled;
2681: is_debug_procedure_on := okl_debug_pub.check_log_on(l_module
2682: ,fnd_log.level_procedure);
2683:
2684:
2677: lp_lq_cost_adj_rec c_lq_cost_adj_rec%ROWTYPE;
2678:
2679: BEGIN
2680: l_debug_enabled := okl_debug_pub.check_log_enabled;
2681: is_debug_procedure_on := okl_debug_pub.check_log_on(l_module
2682: ,fnd_log.level_procedure);
2683:
2684:
2685: IF (l_debug_enabled = 'Y' AND is_debug_procedure_on) THEN
2682: ,fnd_log.level_procedure);
2683:
2684:
2685: IF (l_debug_enabled = 'Y' AND is_debug_procedure_on) THEN
2686: okl_debug_pub.log_debug(fnd_log.level_procedure
2687: ,l_module
2688: ,'begin debug OKLRQQCB.pls call check_subsidies');
2689: END IF; -- check for logging on STATEMENT level
2690: is_debug_statement_on := okl_debug_pub.check_log_on(l_module
2686: okl_debug_pub.log_debug(fnd_log.level_procedure
2687: ,l_module
2688: ,'begin debug OKLRQQCB.pls call check_subsidies');
2689: END IF; -- check for logging on STATEMENT level
2690: is_debug_statement_on := okl_debug_pub.check_log_on(l_module
2691: ,fnd_log.level_statement);
2692:
2693: -- call START_ACTIVITY to create savepoint, check compatibility
2694: -- and initialize message list
2760: okl_api.end_activity(x_msg_count => x_msg_count
2761: ,x_msg_data => x_msg_data);
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
2851: l_program_name CONSTANT VARCHAR2(30) := 'chk_cnfg';
2852: l_api_name CONSTANT VARCHAR2(61) := G_PKG_NAME||'.'||l_program_name;
2853:
2854: BEGIN
2855: l_debug_enabled := okl_debug_pub.check_log_enabled;
2856: is_debug_procedure_on := okl_debug_pub.check_log_on(l_module
2857: ,fnd_log.level_procedure);
2858:
2859:
2852: l_api_name CONSTANT VARCHAR2(61) := G_PKG_NAME||'.'||l_program_name;
2853:
2854: BEGIN
2855: l_debug_enabled := okl_debug_pub.check_log_enabled;
2856: is_debug_procedure_on := okl_debug_pub.check_log_on(l_module
2857: ,fnd_log.level_procedure);
2858:
2859:
2860: IF (l_debug_enabled = 'Y' AND is_debug_procedure_on) THEN
2857: ,fnd_log.level_procedure);
2858:
2859:
2860: IF (l_debug_enabled = 'Y' AND is_debug_procedure_on) THEN
2861: okl_debug_pub.log_debug(fnd_log.level_procedure
2862: ,l_module
2863: ,'begin debug OKLRQQCB.pls call check_configuration');
2864: END IF; -- check for logging on STATEMENT level
2865: is_debug_statement_on := okl_debug_pub.check_log_on(l_module
2861: okl_debug_pub.log_debug(fnd_log.level_procedure
2862: ,l_module
2863: ,'begin debug OKLRQQCB.pls call check_configuration');
2864: END IF; -- check for logging on STATEMENT level
2865: is_debug_statement_on := okl_debug_pub.check_log_on(l_module
2866: ,fnd_log.level_statement);
2867:
2868: -- call START_ACTIVITY to create savepoint, check compatibility
2869: -- and initialize message list
2951: okl_api.end_activity(x_msg_count => x_msg_count
2952: ,x_msg_data => x_msg_data);
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:
3054:
3055: lp_lq_fee_rec c_lq_fee_rec%ROWTYPE;
3056: lp_lq_asset_line c_lq_asset_line%ROWTYPE;
3057: BEGIN
3058: l_debug_enabled := okl_debug_pub.check_log_enabled;
3059: is_debug_procedure_on := okl_debug_pub.check_log_on(l_module
3060: ,fnd_log.level_procedure);
3061:
3062:
3055: lp_lq_fee_rec c_lq_fee_rec%ROWTYPE;
3056: lp_lq_asset_line c_lq_asset_line%ROWTYPE;
3057: BEGIN
3058: l_debug_enabled := okl_debug_pub.check_log_enabled;
3059: is_debug_procedure_on := okl_debug_pub.check_log_on(l_module
3060: ,fnd_log.level_procedure);
3061:
3062:
3063: IF (l_debug_enabled = 'Y' AND is_debug_procedure_on) THEN
3060: ,fnd_log.level_procedure);
3061:
3062:
3063: IF (l_debug_enabled = 'Y' AND is_debug_procedure_on) THEN
3064: okl_debug_pub.log_debug(fnd_log.level_procedure
3065: ,l_module
3066: ,'begin debug OKLRQQCB.pls.check_fees_and_services call ');
3067: END IF; -- check for logging on STATEMENT level
3068: is_debug_statement_on := okl_debug_pub.check_log_on(l_module
3064: okl_debug_pub.log_debug(fnd_log.level_procedure
3065: ,l_module
3066: ,'begin debug OKLRQQCB.pls.check_fees_and_services call ');
3067: END IF; -- check for logging on STATEMENT level
3068: is_debug_statement_on := okl_debug_pub.check_log_on(l_module
3069: ,fnd_log.level_statement);
3070:
3071: -- call START_ACTIVITY to create savepoint, check compatibility
3072: -- and initialize message list
3162: okl_api.end_activity(x_msg_count => x_msg_count
3163: ,x_msg_data => x_msg_data);
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:
3357: lp_lq_service_fee c_lq_fee_rec%ROWTYPE;
3358: lp_lq_cfl_line c_lq_cfl_line%ROWTYPE;
3359: lp_payment_level_rec c_payment_level_rec%ROWTYPE;
3360: BEGIN
3361: l_debug_enabled := okl_debug_pub.check_log_enabled;
3362: is_debug_procedure_on := okl_debug_pub.check_log_on(l_module
3363: ,fnd_log.level_procedure);
3364:
3365:
3358: lp_lq_cfl_line c_lq_cfl_line%ROWTYPE;
3359: lp_payment_level_rec c_payment_level_rec%ROWTYPE;
3360: BEGIN
3361: l_debug_enabled := okl_debug_pub.check_log_enabled;
3362: is_debug_procedure_on := okl_debug_pub.check_log_on(l_module
3363: ,fnd_log.level_procedure);
3364:
3365:
3366: IF (l_debug_enabled = 'Y' AND is_debug_procedure_on) THEN
3363: ,fnd_log.level_procedure);
3364:
3365:
3366: IF (l_debug_enabled = 'Y' AND is_debug_procedure_on) THEN
3367: okl_debug_pub.log_debug(fnd_log.level_procedure
3368: ,l_module
3369: ,'begin debug OKLRQQCB.pls call check_payments');
3370: END IF; -- check for logging on STATEMENT level
3371: is_debug_statement_on := okl_debug_pub.check_log_on(l_module
3367: okl_debug_pub.log_debug(fnd_log.level_procedure
3368: ,l_module
3369: ,'begin debug OKLRQQCB.pls call check_payments');
3370: END IF; -- check for logging on STATEMENT level
3371: is_debug_statement_on := okl_debug_pub.check_log_on(l_module
3372: ,fnd_log.level_statement);
3373:
3374: -- call START_ACTIVITY to create savepoint, check compatibility
3375: -- and initialize message list
4670: okl_api.end_activity(x_msg_count => x_msg_count
4671: ,x_msg_data => x_msg_data);
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:
4759: AND PARENT_OBJECT_CODE=p_object_type
4760: AND PRIMARY_QUOTE='Y';
4761:
4762: BEGIN
4763: l_debug_enabled := okl_debug_pub.check_log_enabled;
4764: is_debug_procedure_on := okl_debug_pub.check_log_on(l_module
4765: ,fnd_log.level_procedure);
4766:
4767:
4760: AND PRIMARY_QUOTE='Y';
4761:
4762: BEGIN
4763: l_debug_enabled := okl_debug_pub.check_log_enabled;
4764: is_debug_procedure_on := okl_debug_pub.check_log_on(l_module
4765: ,fnd_log.level_procedure);
4766:
4767:
4768: IF (l_debug_enabled = 'Y' AND is_debug_procedure_on) THEN
4765: ,fnd_log.level_procedure);
4766:
4767:
4768: IF (l_debug_enabled = 'Y' AND is_debug_procedure_on) THEN
4769: okl_debug_pub.log_debug(fnd_log.level_procedure
4770: ,l_module
4771: ,'begin debug OKLRQQCB.pls call run_qa3');
4772: END IF; -- check for logging on STATEMENT level
4773: is_debug_statement_on := okl_debug_pub.check_log_on(l_module
4769: okl_debug_pub.log_debug(fnd_log.level_procedure
4770: ,l_module
4771: ,'begin debug OKLRQQCB.pls call run_qa3');
4772: END IF; -- check for logging on STATEMENT level
4773: is_debug_statement_on := okl_debug_pub.check_log_on(l_module
4774: ,fnd_log.level_statement);
4775: -- call START_ACTIVITY to create savepoint, check compatibility
4776: -- and initialize message list
4777:
5120:
5121: okl_api.end_activity(x_msg_count => x_msg_count
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
5198: l_debug_enabled varchar2(10);
5199: is_debug_procedure_on boolean;
5200: is_debug_statement_on boolean;
5201: BEGIN
5202: l_debug_enabled := okl_debug_pub.check_log_enabled;
5203: is_debug_procedure_on := okl_debug_pub.check_log_on(l_module
5204: ,fnd_log.level_procedure);
5205:
5206:
5199: is_debug_procedure_on boolean;
5200: is_debug_statement_on boolean;
5201: BEGIN
5202: l_debug_enabled := okl_debug_pub.check_log_enabled;
5203: is_debug_procedure_on := okl_debug_pub.check_log_on(l_module
5204: ,fnd_log.level_procedure);
5205:
5206:
5207: IF (l_debug_enabled = 'Y' AND is_debug_procedure_on) THEN
5204: ,fnd_log.level_procedure);
5205:
5206:
5207: IF (l_debug_enabled = 'Y' AND is_debug_procedure_on) THEN
5208: okl_debug_pub.log_debug(fnd_log.level_procedure
5209: ,l_module
5210: ,'begin debug OKLRQQCB.pls call run_qa_checker');
5211: END IF; -- check for logging on STATEMENT level
5212: is_debug_statement_on := okl_debug_pub.check_log_on(l_module
5208: okl_debug_pub.log_debug(fnd_log.level_procedure
5209: ,l_module
5210: ,'begin debug OKLRQQCB.pls call run_qa_checker');
5211: END IF; -- check for logging on STATEMENT level
5212: is_debug_statement_on := okl_debug_pub.check_log_on(l_module
5213: ,fnd_log.level_statement);
5214:
5215: -- call START_ACTIVITY to create savepoint, check compatibility
5216: -- and initialize message list
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
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;
5267:
5268: okl_api.end_activity(x_msg_count => x_msg_count
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:
5357: AND PRIMARY_QUOTE='Y';
5358:
5359: BEGIN
5360:
5361: l_debug_enabled := okl_debug_pub.check_log_enabled;
5362: is_debug_procedure_on := okl_debug_pub.check_log_on(l_module
5363: ,fnd_log.level_procedure);
5364:
5365:
5358:
5359: BEGIN
5360:
5361: l_debug_enabled := okl_debug_pub.check_log_enabled;
5362: is_debug_procedure_on := okl_debug_pub.check_log_on(l_module
5363: ,fnd_log.level_procedure);
5364:
5365:
5366: IF (l_debug_enabled = 'Y' AND is_debug_procedure_on) THEN
5363: ,fnd_log.level_procedure);
5364:
5365:
5366: IF (l_debug_enabled = 'Y' AND is_debug_procedure_on) THEN
5367: okl_debug_pub.log_debug(fnd_log.level_procedure
5368: ,l_module
5369: ,'begin debug OKLRQQCB.pls call run_qa3');
5370: END IF; -- check for logging on STATEMENT level
5371: is_debug_statement_on := okl_debug_pub.check_log_on(l_module
5367: okl_debug_pub.log_debug(fnd_log.level_procedure
5368: ,l_module
5369: ,'begin debug OKLRQQCB.pls call run_qa3');
5370: END IF; -- check for logging on STATEMENT level
5371: is_debug_statement_on := okl_debug_pub.check_log_on(l_module
5372: ,fnd_log.level_statement);
5373:
5374: -- call START_ACTIVITY to create savepoint, check compatibility
5375: -- and initialize message list
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;
5454: okl_api.end_activity(x_msg_count => x_msg_count
5455: ,x_msg_data => x_msg_data);
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: