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 FND_LOG

Line 70: l_module CONSTANT fnd_log_messages.module%TYPE := 'set_fnd_message';

66: ,p_token4 IN varchar2 DEFAULT NULL
67: ,p_value4 IN varchar2 DEFAULT NULL) IS
68:
69: l_msg varchar2(2700);
70: l_module CONSTANT fnd_log_messages.module%TYPE := 'set_fnd_message';
71: l_debug_enabled varchar2(10);
72: is_debug_procedure_on boolean;
73: is_debug_statement_on boolean;
74:

Line 78: ,fnd_log.level_procedure);

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
82: ,l_module

Line 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);

Line 104: okl_debug_pub.log_debug(fnd_log.level_procedure

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:

Line 136: l_module CONSTANT fnd_log_messages.module%TYPE := 'lrs';

132: PROCEDURE populate_lq_rec_values(p_target_id number,
133: l_okl_ec_rec_type IN OUT NOCOPY okl_ec_evaluate_pvt.okl_ec_rec_type) IS
134:
135: i INTEGER;
136: l_module CONSTANT fnd_log_messages.module%TYPE := 'lrs';
137: l_debug_enabled varchar2(10);
138: is_debug_procedure_on boolean;
139: is_debug_statement_on boolean;
140: p_api_version CONSTANT number := 1.0;

Line 292: l_module CONSTANT fnd_log_messages.module%TYPE := 'srt';

288: /* PROCEDURE check_srt_effective_rate(p_srt_version_id NUMBER,
289: p_quote_id NUMBER,
290: x_qa_result_tbl IN OUT NOCOPY qa_results_tbl_type) IS
291: l_msg_count NUMBER;
292: l_module CONSTANT fnd_log_messages.module%TYPE := 'srt';
293: l_debug_enabled varchar2(10);
294: is_debug_procedure_on boolean;
295: is_debug_statement_on boolean;
296: p_api_version CONSTANT number := 1.0;

Line 580: l_module CONSTANT fnd_log_messages.module%TYPE := 'OKLRQQCB.pls.run_qa';

576: call_user boolean;
577: l_function_name okl_data_src_fnctns_v.name%TYPE;
578: l_source_name okl_data_src_fnctns_v.source%TYPE;
579: l_failure_severity VARCHAR2(30);
580: l_module CONSTANT fnd_log_messages.module%TYPE := 'OKLRQQCB.pls.run_qa';
581: l_debug_enabled varchar2(10);
582: is_debug_procedure_on boolean;
583: is_debug_statement_on boolean;
584: cursor c_sys_opt_vls IS

Line 614: okl_debug_pub.log_debug(fnd_log.level_statement

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 ' ||

Line 1066: l_module CONSTANT fnd_log_messages.module%TYPE := 'val_c_ad';

1062: lp_cost_adj_total INTEGER:=0;
1063: lp_qq_lines_cost INTEGER:=0;
1064: lp_rec_flag VARCHAR2(1);
1065: l_flag boolean:= FALSE;
1066: l_module CONSTANT fnd_log_messages.module%TYPE := 'val_c_ad';
1067: l_debug_enabled varchar2(10);
1068: is_debug_procedure_on boolean;
1069: is_debug_statement_on boolean;
1070: l_program_name CONSTANT VARCHAR2(30) := 'val_c_ad';

Line 1086: ,fnd_log.level_procedure);

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
1090: okl_debug_pub.log_debug(fnd_log.level_procedure

Line 1090: okl_debug_pub.log_debug(fnd_log.level_procedure

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

Line 1095: ,fnd_log.level_statement);

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
1099:

Line 1190: okl_debug_pub.log_debug(fnd_log.level_procedure

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:

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 1289: ,fnd_log.level_procedure);

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
1293: okl_debug_pub.log_debug(fnd_log.level_procedure

Line 1293: okl_debug_pub.log_debug(fnd_log.level_procedure

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

Line 1298: ,fnd_log.level_statement);

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
1302:

Line 1357: okl_debug_pub.log_debug(fnd_log.level_procedure

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

Line 1483: ,fnd_log.level_procedure);

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
1487: okl_debug_pub.log_debug(fnd_log.level_procedure

Line 1487: okl_debug_pub.log_debug(fnd_log.level_procedure

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

Line 1492: ,fnd_log.level_statement);

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
1496: x_return_status := okl_api.start_activity(p_api_name=>l_api_name

Line 1627: okl_debug_pub.log_debug(fnd_log.level_procedure

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

Line 1769: l_module CONSTANT fnd_log_messages.module%TYPE := 'v_ec_crt';

1765: lp_cost_adj_total INTEGER:=0;
1766: lp_rec_flag VARCHAR2(1);
1767: i INTEGER;
1768: l_api_name CONSTANT VARCHAR2(61) := 'v_ec_crt';
1769: l_module CONSTANT fnd_log_messages.module%TYPE := 'v_ec_crt';
1770: l_debug_enabled varchar2(10);
1771: is_debug_procedure_on boolean;
1772: is_debug_statement_on boolean;
1773: l_validation_mode VARCHAR2(3):='LOV';

Line 1831: ,fnd_log.level_procedure);

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
1835: okl_debug_pub.log_debug(fnd_log.level_procedure

Line 1835: okl_debug_pub.log_debug(fnd_log.level_procedure

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

Line 1840: ,fnd_log.level_statement);

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
1844: x_return_status := okl_api.start_activity(p_api_name=>l_api_name

Line 2129: okl_debug_pub.log_debug(fnd_log.level_procedure

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

Line 2346: l_module CONSTANT fnd_log_messages.module%TYPE := 'ext_val';

2342: lp_asset_id NUMBER;
2343: lp_rec_flag VARCHAR2(1);
2344: x VARCHAR2(1);
2345: i INTEGER;
2346: l_module CONSTANT fnd_log_messages.module%TYPE := 'ext_val';
2347: l_debug_enabled varchar2(10);
2348: is_debug_procedure_on boolean;
2349: is_debug_statement_on boolean;
2350: l_program_name CONSTANT VARCHAR2(30) := 'ext_val';

Line 2417: ,fnd_log.level_procedure);

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
2421: okl_debug_pub.log_debug(fnd_log.level_procedure

Line 2421: okl_debug_pub.log_debug(fnd_log.level_procedure

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

Line 2426: ,fnd_log.level_statement);

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
2430:

Line 2574: okl_debug_pub.log_debug(fnd_log.level_procedure

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:

Line 2645: l_module CONSTANT fnd_log_messages.module%TYPE := 'chk_ss';

2641: lp_asset_id NUMBER;
2642: lp_subsidy_calc_basis VARCHAR2(30);
2643: lp_rec_flag VARCHAR2(1);
2644: i INTEGER;
2645: l_module CONSTANT fnd_log_messages.module%TYPE := 'chk_ss';
2646: l_debug_enabled varchar2(10);
2647: is_debug_procedure_on boolean;
2648: is_debug_statement_on boolean;
2649: l_program_name CONSTANT VARCHAR2(30) := 'chk_ss';

Line 2682: ,fnd_log.level_procedure);

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
2686: okl_debug_pub.log_debug(fnd_log.level_procedure

Line 2686: okl_debug_pub.log_debug(fnd_log.level_procedure

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

Line 2691: ,fnd_log.level_statement);

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
2695: x_return_status := okl_api.start_activity(p_api_name=>l_api_name

Line 2764: okl_debug_pub.log_debug(fnd_log.level_procedure

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

Line 2847: l_module CONSTANT fnd_log_messages.module%TYPE := 'chk_cnfg';

2843: lp_asset_id NUMBER;
2844: lp_rec_flag VARCHAR2(1);
2845: l_asset_count INTEGER := 0;
2846: i INTEGER;
2847: l_module CONSTANT fnd_log_messages.module%TYPE := 'chk_cnfg';
2848: l_debug_enabled varchar2(10);
2849: is_debug_procedure_on boolean;
2850: is_debug_statement_on boolean;
2851: l_program_name CONSTANT VARCHAR2(30) := 'chk_cnfg';

Line 2857: ,fnd_log.level_procedure);

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
2861: okl_debug_pub.log_debug(fnd_log.level_procedure

Line 2861: okl_debug_pub.log_debug(fnd_log.level_procedure

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

Line 2866: ,fnd_log.level_statement);

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
2870:

Line 2955: okl_debug_pub.log_debug(fnd_log.level_procedure

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:

Line 3030: l_module CONSTANT fnd_log_messages.module%TYPE := 'chk_fees_and_services';

3026: total_line_amount INTEGER:=0;
3027: lp_fee_amount INTEGER:=0;
3028: lp_service_line_total INTEGER:=0;
3029:
3030: l_module CONSTANT fnd_log_messages.module%TYPE := 'chk_fees_and_services';
3031: l_debug_enabled varchar2(10);
3032: is_debug_procedure_on boolean;
3033: is_debug_statement_on boolean;
3034: l_program_name CONSTANT VARCHAR2(30) := 'chck_fee';

Line 3060: ,fnd_log.level_procedure);

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
3064: okl_debug_pub.log_debug(fnd_log.level_procedure

Line 3064: okl_debug_pub.log_debug(fnd_log.level_procedure

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

Line 3069: ,fnd_log.level_statement);

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
3073:

Line 3166: okl_debug_pub.log_debug(fnd_log.level_procedure

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:

Line 3253: l_module CONSTANT fnd_log_messages.module%TYPE := 'chek_pay';

3249: l_are_all_lines_overriden VARCHAR2(1);
3250: l_qte_pric_opts_entered VARCHAR2(1);
3251: l_cashflow_count INTEGER := 0;
3252: l_fees_count INTEGER := 0;
3253: l_module CONSTANT fnd_log_messages.module%TYPE := 'chek_pay';
3254: l_debug_enabled varchar2(10);
3255: is_debug_procedure_on boolean;
3256: is_debug_statement_on boolean;
3257: l_program_name CONSTANT VARCHAR2(30) := 'chek_pay';

Line 3363: ,fnd_log.level_procedure);

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
3367: okl_debug_pub.log_debug(fnd_log.level_procedure

Line 3367: okl_debug_pub.log_debug(fnd_log.level_procedure

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

Line 3372: ,fnd_log.level_statement);

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
3376:

Line 4674: okl_debug_pub.log_debug(fnd_log.level_procedure

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:

Line 4736: l_module CONSTANT fnd_log_messages.module%TYPE := 'SALE_QA_PVT';

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';
4737: l_debug_enabled varchar2(10);
4738: is_debug_procedure_on boolean;
4739: is_debug_statement_on boolean;
4740:

Line 4765: ,fnd_log.level_procedure);

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
4769: okl_debug_pub.log_debug(fnd_log.level_procedure

Line 4769: okl_debug_pub.log_debug(fnd_log.level_procedure

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

Line 4774: ,fnd_log.level_statement);

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:
4778: x_return_status := okl_api.start_activity(p_api_name=>l_api_name

Line 5126: okl_debug_pub.log_debug(fnd_log.level_procedure

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

Line 5199: l_module CONSTANT fnd_log_messages.module%TYPE := 'OKL_SALE_QUOTE_QA_PVT.run_qa_checker2';

5195:
5196: l_program_name CONSTANT VARCHAR2(30) := 'run_qa_qq';
5197: l_api_name CONSTANT VARCHAR2(61) := l_program_name;
5198: i INTEGER;
5199: l_module CONSTANT fnd_log_messages.module%TYPE := 'OKL_SALE_QUOTE_QA_PVT.run_qa_checker2';
5200: l_debug_enabled varchar2(10);
5201: is_debug_procedure_on boolean;
5202: is_debug_statement_on boolean;
5203: BEGIN

Line 5206: ,fnd_log.level_procedure);

5202: is_debug_statement_on boolean;
5203: BEGIN
5204: l_debug_enabled := okl_debug_pub.check_log_enabled;
5205: is_debug_procedure_on := okl_debug_pub.check_log_on(l_module
5206: ,fnd_log.level_procedure);
5207:
5208:
5209: IF (l_debug_enabled = 'Y' AND is_debug_procedure_on) THEN
5210: okl_debug_pub.log_debug(fnd_log.level_procedure

Line 5210: okl_debug_pub.log_debug(fnd_log.level_procedure

5206: ,fnd_log.level_procedure);
5207:
5208:
5209: IF (l_debug_enabled = 'Y' AND is_debug_procedure_on) THEN
5210: okl_debug_pub.log_debug(fnd_log.level_procedure
5211: ,l_module
5212: ,'begin debug OKLRQQCB.pls call run_qa_checker');
5213: END IF; -- check for logging on STATEMENT level
5214: is_debug_statement_on := okl_debug_pub.check_log_on(l_module

Line 5215: ,fnd_log.level_statement);

5211: ,l_module
5212: ,'begin debug OKLRQQCB.pls call run_qa_checker');
5213: END IF; -- check for logging on STATEMENT level
5214: is_debug_statement_on := okl_debug_pub.check_log_on(l_module
5215: ,fnd_log.level_statement);
5216:
5217: -- call START_ACTIVITY to create savepoint, check compatibility
5218: -- and initialize message list
5219:

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

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

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

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

Line 5273: okl_debug_pub.log_debug(fnd_log.level_procedure

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

Line 5346: l_module CONSTANT fnd_log_messages.module%TYPE := 'OKLRQQCB.pls.run_qa3';

5342:
5343: l_program_name CONSTANT VARCHAR2(30) := 'run_qa3';
5344: l_api_name CONSTANT VARCHAR2(61) := l_program_name;
5345: i INTEGER;
5346: l_module CONSTANT fnd_log_messages.module%TYPE := 'OKLRQQCB.pls.run_qa3';
5347: l_debug_enabled varchar2(10);
5348: is_debug_procedure_on boolean;
5349: is_debug_statement_on boolean;
5350: x_qa_result_tbl qa_results_tbl_type;

Line 5365: ,fnd_log.level_procedure);

5361: BEGIN
5362:
5363: l_debug_enabled := okl_debug_pub.check_log_enabled;
5364: is_debug_procedure_on := okl_debug_pub.check_log_on(l_module
5365: ,fnd_log.level_procedure);
5366:
5367:
5368: IF (l_debug_enabled = 'Y' AND is_debug_procedure_on) THEN
5369: okl_debug_pub.log_debug(fnd_log.level_procedure

Line 5369: okl_debug_pub.log_debug(fnd_log.level_procedure

5365: ,fnd_log.level_procedure);
5366:
5367:
5368: IF (l_debug_enabled = 'Y' AND is_debug_procedure_on) THEN
5369: okl_debug_pub.log_debug(fnd_log.level_procedure
5370: ,l_module
5371: ,'begin debug OKLRQQCB.pls call run_qa3');
5372: END IF; -- check for logging on STATEMENT level
5373: is_debug_statement_on := okl_debug_pub.check_log_on(l_module

Line 5374: ,fnd_log.level_statement);

5370: ,l_module
5371: ,'begin debug OKLRQQCB.pls call run_qa3');
5372: END IF; -- check for logging on STATEMENT level
5373: is_debug_statement_on := okl_debug_pub.check_log_on(l_module
5374: ,fnd_log.level_statement);
5375:
5376: -- call START_ACTIVITY to create savepoint, check compatibility
5377: -- and initialize message list
5378:

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

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

Line 5460: okl_debug_pub.log_debug(fnd_log.level_procedure

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