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_REPORT_GENERATOR_PVT dependencies on OKL_DEBUG_PUB

Line 18: G_DEBUG_ENABLED CONSTANT VARCHAR2(10) := OKL_DEBUG_PUB.CHECK_LOG_ENABLED;

14: --
15: -- End of comments
16: -- Package level variables
17: G_MODULE CONSTANT VARCHAR2(255):= 'LEASE.ACCOUNTING.RECONCILIATION.OKL_REPORT_GENERATOR_PVT';
18: G_DEBUG_ENABLED CONSTANT VARCHAR2(10) := OKL_DEBUG_PUB.CHECK_LOG_ENABLED;
19: G_IS_DEBUG_STATEMENT_ON BOOLEAN;
20:
21: CURSOR get_contracts_csr(
22: p_org_id NUMBER

Line 94: okl_debug_pub.log_debug(

90: msg IN VARCHAR2 )
91: AS
92: -- l_level: S - Statement, P- Procedure, B - Both
93: BEGIN
94: okl_debug_pub.log_debug(
95: p_level,
96: p_module,
97: msg);
98: END;

Line 185: l_debug_enabled := okl_debug_pub.check_log_enabled;

181: is_debug_statement_on BOOLEAN;
182: -- Local Variables
183: l_query_string VARCHAR2(4000);
184: BEGIN
185: l_debug_enabled := okl_debug_pub.check_log_enabled;
186: -- check for logging on PROCEDURE level
187: is_debug_procedure_on := okl_debug_pub.check_log_on(l_module,FND_LOG.LEVEL_PROCEDURE);
188: -- check for logging on STATEMENT level
189: is_debug_statement_on := okl_debug_pub.check_log_on(l_module,FND_LOG.LEVEL_STATEMENT);

Line 187: is_debug_procedure_on := okl_debug_pub.check_log_on(l_module,FND_LOG.LEVEL_PROCEDURE);

183: l_query_string VARCHAR2(4000);
184: BEGIN
185: l_debug_enabled := okl_debug_pub.check_log_enabled;
186: -- check for logging on PROCEDURE level
187: is_debug_procedure_on := okl_debug_pub.check_log_on(l_module,FND_LOG.LEVEL_PROCEDURE);
188: -- check for logging on STATEMENT level
189: is_debug_statement_on := okl_debug_pub.check_log_on(l_module,FND_LOG.LEVEL_STATEMENT);
190: put_in_log(l_debug_enabled,is_debug_procedure_on,is_debug_statement_on,l_module, 'P',
191: 'begin debug OKLRRPTB.pls call ' || l_api_name);

Line 189: is_debug_statement_on := okl_debug_pub.check_log_on(l_module,FND_LOG.LEVEL_STATEMENT);

185: l_debug_enabled := okl_debug_pub.check_log_enabled;
186: -- check for logging on PROCEDURE level
187: is_debug_procedure_on := okl_debug_pub.check_log_on(l_module,FND_LOG.LEVEL_PROCEDURE);
188: -- check for logging on STATEMENT level
189: is_debug_statement_on := okl_debug_pub.check_log_on(l_module,FND_LOG.LEVEL_STATEMENT);
190: put_in_log(l_debug_enabled,is_debug_procedure_on,is_debug_statement_on,l_module, 'P',
191: 'begin debug OKLRRPTB.pls call ' || l_api_name);
192: put_in_log(l_debug_enabled,is_debug_procedure_on,is_debug_statement_on,l_module, 'P',
193: 'BEGIN API OKL_REPORT_GENERATOR_PVT.' || l_api_name );

Line 353: l_debug_enabled := okl_debug_pub.check_log_enabled;

349: l_report_id NUMBER := p_report_id;
350: l_bc_or_pdts_mentioned VARCHAR2(1);
351: l_pdt_count NUMBER;
352: BEGIN
353: l_debug_enabled := okl_debug_pub.check_log_enabled;
354: -- check for logging on PROCEDURE level
355: is_debug_procedure_on := okl_debug_pub.check_log_on(l_module,FND_LOG.LEVEL_PROCEDURE);
356: -- check for logging on STATEMENT level
357: is_debug_statement_on := okl_debug_pub.check_log_on(l_module,FND_LOG.LEVEL_STATEMENT);

Line 355: is_debug_procedure_on := okl_debug_pub.check_log_on(l_module,FND_LOG.LEVEL_PROCEDURE);

351: l_pdt_count NUMBER;
352: BEGIN
353: l_debug_enabled := okl_debug_pub.check_log_enabled;
354: -- check for logging on PROCEDURE level
355: is_debug_procedure_on := okl_debug_pub.check_log_on(l_module,FND_LOG.LEVEL_PROCEDURE);
356: -- check for logging on STATEMENT level
357: is_debug_statement_on := okl_debug_pub.check_log_on(l_module,FND_LOG.LEVEL_STATEMENT);
358: put_in_log(l_debug_enabled,is_debug_procedure_on,is_debug_statement_on,l_module, 'P',
359: 'begin debug OKLRRPTB.pls call ' || l_api_name);

Line 357: is_debug_statement_on := okl_debug_pub.check_log_on(l_module,FND_LOG.LEVEL_STATEMENT);

353: l_debug_enabled := okl_debug_pub.check_log_enabled;
354: -- check for logging on PROCEDURE level
355: is_debug_procedure_on := okl_debug_pub.check_log_on(l_module,FND_LOG.LEVEL_PROCEDURE);
356: -- check for logging on STATEMENT level
357: is_debug_statement_on := okl_debug_pub.check_log_on(l_module,FND_LOG.LEVEL_STATEMENT);
358: put_in_log(l_debug_enabled,is_debug_procedure_on,is_debug_statement_on,l_module, 'P',
359: 'begin debug OKLRRPTB.pls call ' || l_api_name);
360: put_in_log(l_debug_enabled,is_debug_procedure_on,is_debug_statement_on,l_module, 'P',
361: 'BEGIN API OKL_REPORT_GENERATOR_PVT.' || l_api_name );

Line 474: l_debug_enabled := okl_debug_pub.check_log_enabled;

470: -- Local Variables
471: l_query_string VARCHAR2(4000);
472: l_trace_time DATE;
473: BEGIN
474: l_debug_enabled := okl_debug_pub.check_log_enabled;
475: -- check for logging on PROCEDURE level
476: is_debug_procedure_on := okl_debug_pub.check_log_on(l_module,FND_LOG.LEVEL_PROCEDURE);
477: -- check for logging on STATEMENT level
478: is_debug_statement_on := okl_debug_pub.check_log_on(l_module,FND_LOG.LEVEL_STATEMENT);

Line 476: is_debug_procedure_on := okl_debug_pub.check_log_on(l_module,FND_LOG.LEVEL_PROCEDURE);

472: l_trace_time DATE;
473: BEGIN
474: l_debug_enabled := okl_debug_pub.check_log_enabled;
475: -- check for logging on PROCEDURE level
476: is_debug_procedure_on := okl_debug_pub.check_log_on(l_module,FND_LOG.LEVEL_PROCEDURE);
477: -- check for logging on STATEMENT level
478: is_debug_statement_on := okl_debug_pub.check_log_on(l_module,FND_LOG.LEVEL_STATEMENT);
479: put_in_log(l_debug_enabled,is_debug_procedure_on,is_debug_statement_on,l_module, 'P',
480: 'begin debug OKLRRPTB.pls call ' || l_api_name);

Line 478: is_debug_statement_on := okl_debug_pub.check_log_on(l_module,FND_LOG.LEVEL_STATEMENT);

474: l_debug_enabled := okl_debug_pub.check_log_enabled;
475: -- check for logging on PROCEDURE level
476: is_debug_procedure_on := okl_debug_pub.check_log_on(l_module,FND_LOG.LEVEL_PROCEDURE);
477: -- check for logging on STATEMENT level
478: is_debug_statement_on := okl_debug_pub.check_log_on(l_module,FND_LOG.LEVEL_STATEMENT);
479: put_in_log(l_debug_enabled,is_debug_procedure_on,is_debug_statement_on,l_module, 'P',
480: 'begin debug OKLRRPTB.pls call ' || l_api_name);
481: put_in_log(l_debug_enabled,is_debug_procedure_on,is_debug_statement_on,l_module, 'S',
482: 'Begin: ' || l_api_name ||'(+)' );

Line 3256: l_debug_enabled := okl_debug_pub.check_log_enabled;

3252: l_trace_time DATE;
3253: l_strm_bal_tbl reports_gt_tbl_type;
3254: l_activity_code VARCHAR2(30);
3255: BEGIN
3256: l_debug_enabled := okl_debug_pub.check_log_enabled;
3257: -- check for logging on PROCEDURE level
3258: is_debug_procedure_on := okl_debug_pub.check_log_on(l_module,FND_LOG.LEVEL_PROCEDURE);
3259: -- check for logging on STATEMENT level
3260: is_debug_statement_on := okl_debug_pub.check_log_on(l_module,FND_LOG.LEVEL_STATEMENT);

Line 3258: is_debug_procedure_on := okl_debug_pub.check_log_on(l_module,FND_LOG.LEVEL_PROCEDURE);

3254: l_activity_code VARCHAR2(30);
3255: BEGIN
3256: l_debug_enabled := okl_debug_pub.check_log_enabled;
3257: -- check for logging on PROCEDURE level
3258: is_debug_procedure_on := okl_debug_pub.check_log_on(l_module,FND_LOG.LEVEL_PROCEDURE);
3259: -- check for logging on STATEMENT level
3260: is_debug_statement_on := okl_debug_pub.check_log_on(l_module,FND_LOG.LEVEL_STATEMENT);
3261: put_in_log(l_debug_enabled,is_debug_procedure_on,is_debug_statement_on,l_module, 'P',
3262: 'begin debug OKLRRPTB.pls call ' || l_api_name);

Line 3260: is_debug_statement_on := okl_debug_pub.check_log_on(l_module,FND_LOG.LEVEL_STATEMENT);

3256: l_debug_enabled := okl_debug_pub.check_log_enabled;
3257: -- check for logging on PROCEDURE level
3258: is_debug_procedure_on := okl_debug_pub.check_log_on(l_module,FND_LOG.LEVEL_PROCEDURE);
3259: -- check for logging on STATEMENT level
3260: is_debug_statement_on := okl_debug_pub.check_log_on(l_module,FND_LOG.LEVEL_STATEMENT);
3261: put_in_log(l_debug_enabled,is_debug_procedure_on,is_debug_statement_on,l_module, 'P',
3262: 'begin debug OKLRRPTB.pls call ' || l_api_name);
3263: put_in_log(l_debug_enabled,is_debug_procedure_on,is_debug_statement_on,l_module, 'S',
3264: 'Begin: ' || l_api_name ||'(+)' );

Line 3490: l_debug_enabled := okl_debug_pub.check_log_enabled;

3486: l_trace_time DATE;
3487: l_period_set_name VARCHAR2(15);
3488: l_period_type VARCHAR2(15);
3489: BEGIN
3490: l_debug_enabled := okl_debug_pub.check_log_enabled;
3491: -- check for logging on PROCEDURE level
3492: is_debug_procedure_on := okl_debug_pub.check_log_on(l_module,FND_LOG.LEVEL_PROCEDURE);
3493: -- check for logging on STATEMENT level
3494: is_debug_statement_on := okl_debug_pub.check_log_on(l_module,FND_LOG.LEVEL_STATEMENT);

Line 3492: is_debug_procedure_on := okl_debug_pub.check_log_on(l_module,FND_LOG.LEVEL_PROCEDURE);

3488: l_period_type VARCHAR2(15);
3489: BEGIN
3490: l_debug_enabled := okl_debug_pub.check_log_enabled;
3491: -- check for logging on PROCEDURE level
3492: is_debug_procedure_on := okl_debug_pub.check_log_on(l_module,FND_LOG.LEVEL_PROCEDURE);
3493: -- check for logging on STATEMENT level
3494: is_debug_statement_on := okl_debug_pub.check_log_on(l_module,FND_LOG.LEVEL_STATEMENT);
3495: put_in_log(l_debug_enabled,is_debug_procedure_on,is_debug_statement_on,l_module, 'P',
3496: 'begin debug OKLRRPTB.pls call ' || l_api_name);

Line 3494: is_debug_statement_on := okl_debug_pub.check_log_on(l_module,FND_LOG.LEVEL_STATEMENT);

3490: l_debug_enabled := okl_debug_pub.check_log_enabled;
3491: -- check for logging on PROCEDURE level
3492: is_debug_procedure_on := okl_debug_pub.check_log_on(l_module,FND_LOG.LEVEL_PROCEDURE);
3493: -- check for logging on STATEMENT level
3494: is_debug_statement_on := okl_debug_pub.check_log_on(l_module,FND_LOG.LEVEL_STATEMENT);
3495: put_in_log(l_debug_enabled,is_debug_procedure_on,is_debug_statement_on,l_module, 'P',
3496: 'begin debug OKLRRPTB.pls call ' || l_api_name);
3497: put_in_log(l_debug_enabled,is_debug_procedure_on,is_debug_statement_on,l_module, 'S',
3498: 'Begin: ' || l_api_name ||'(+)' );

Line 5096: l_debug_enabled := okl_debug_pub.check_log_enabled;

5092: is_debug_statement_on BOOLEAN;
5093: -- Local Variables
5094: l_trace_time DATE;
5095: BEGIN
5096: l_debug_enabled := okl_debug_pub.check_log_enabled;
5097: -- check for logging on PROCEDURE level
5098: is_debug_procedure_on := okl_debug_pub.check_log_on(l_module,FND_LOG.LEVEL_PROCEDURE);
5099: -- check for logging on STATEMENT level
5100: is_debug_statement_on := okl_debug_pub.check_log_on(l_module,FND_LOG.LEVEL_STATEMENT);

Line 5098: is_debug_procedure_on := okl_debug_pub.check_log_on(l_module,FND_LOG.LEVEL_PROCEDURE);

5094: l_trace_time DATE;
5095: BEGIN
5096: l_debug_enabled := okl_debug_pub.check_log_enabled;
5097: -- check for logging on PROCEDURE level
5098: is_debug_procedure_on := okl_debug_pub.check_log_on(l_module,FND_LOG.LEVEL_PROCEDURE);
5099: -- check for logging on STATEMENT level
5100: is_debug_statement_on := okl_debug_pub.check_log_on(l_module,FND_LOG.LEVEL_STATEMENT);
5101: put_in_log(l_debug_enabled,is_debug_procedure_on,is_debug_statement_on,l_module, 'P',
5102: 'begin debug OKLRRPTB.pls call ' || l_api_name);

Line 5100: is_debug_statement_on := okl_debug_pub.check_log_on(l_module,FND_LOG.LEVEL_STATEMENT);

5096: l_debug_enabled := okl_debug_pub.check_log_enabled;
5097: -- check for logging on PROCEDURE level
5098: is_debug_procedure_on := okl_debug_pub.check_log_on(l_module,FND_LOG.LEVEL_PROCEDURE);
5099: -- check for logging on STATEMENT level
5100: is_debug_statement_on := okl_debug_pub.check_log_on(l_module,FND_LOG.LEVEL_STATEMENT);
5101: put_in_log(l_debug_enabled,is_debug_procedure_on,is_debug_statement_on,l_module, 'P',
5102: 'begin debug OKLRRPTB.pls call ' || l_api_name);
5103: put_in_log(l_debug_enabled,is_debug_procedure_on,is_debug_statement_on,l_module, 'S',
5104: 'Begin: ' || l_api_name ||'(+)' );

Line 5865: l_debug_enabled := okl_debug_pub.check_log_enabled;

5861: INDEX BY BINARY_INTEGER;
5862: l_invalid_orgs_tbl rep_gt_tbl_type;
5863: i NUMBER;
5864: BEGIN
5865: l_debug_enabled := okl_debug_pub.check_log_enabled;
5866: -- check for logging on PROCEDURE level
5867: is_debug_procedure_on := okl_debug_pub.check_log_on(l_module,FND_LOG.LEVEL_PROCEDURE);
5868: -- check for logging on STATEMENT level
5869: is_debug_statement_on := okl_debug_pub.check_log_on(l_module,FND_LOG.LEVEL_STATEMENT);

Line 5867: is_debug_procedure_on := okl_debug_pub.check_log_on(l_module,FND_LOG.LEVEL_PROCEDURE);

5863: i NUMBER;
5864: BEGIN
5865: l_debug_enabled := okl_debug_pub.check_log_enabled;
5866: -- check for logging on PROCEDURE level
5867: is_debug_procedure_on := okl_debug_pub.check_log_on(l_module,FND_LOG.LEVEL_PROCEDURE);
5868: -- check for logging on STATEMENT level
5869: is_debug_statement_on := okl_debug_pub.check_log_on(l_module,FND_LOG.LEVEL_STATEMENT);
5870: put_in_log(l_debug_enabled,is_debug_procedure_on,is_debug_statement_on,l_module, 'P',
5871: 'begin debug OKLRRPTB.pls call ' || l_api_name);

Line 5869: is_debug_statement_on := okl_debug_pub.check_log_on(l_module,FND_LOG.LEVEL_STATEMENT);

5865: l_debug_enabled := okl_debug_pub.check_log_enabled;
5866: -- check for logging on PROCEDURE level
5867: is_debug_procedure_on := okl_debug_pub.check_log_on(l_module,FND_LOG.LEVEL_PROCEDURE);
5868: -- check for logging on STATEMENT level
5869: is_debug_statement_on := okl_debug_pub.check_log_on(l_module,FND_LOG.LEVEL_STATEMENT);
5870: put_in_log(l_debug_enabled,is_debug_procedure_on,is_debug_statement_on,l_module, 'P',
5871: 'begin debug OKLRRPTB.pls call ' || l_api_name);
5872: -- Constraint:
5873: -- The Report shouldnot be generated if the user doesnot have access to atleast

Line 6450: l_debug_enabled := okl_debug_pub.check_log_enabled;

6446: l_spec_sty_id_tbl sty_id_tbl_type;
6447: l_pdt_sty_id_tbl sty_id_tbl_type;
6448:
6449: BEGIN
6450: l_debug_enabled := okl_debug_pub.check_log_enabled;
6451: -- check for logging on PROCEDURE level
6452: is_debug_procedure_on := okl_debug_pub.check_log_on(l_module,FND_LOG.LEVEL_PROCEDURE);
6453: -- check for logging on STATEMENT level
6454: is_debug_statement_on := okl_debug_pub.check_log_on(l_module,FND_LOG.LEVEL_STATEMENT);

Line 6452: is_debug_procedure_on := okl_debug_pub.check_log_on(l_module,FND_LOG.LEVEL_PROCEDURE);

6448:
6449: BEGIN
6450: l_debug_enabled := okl_debug_pub.check_log_enabled;
6451: -- check for logging on PROCEDURE level
6452: is_debug_procedure_on := okl_debug_pub.check_log_on(l_module,FND_LOG.LEVEL_PROCEDURE);
6453: -- check for logging on STATEMENT level
6454: is_debug_statement_on := okl_debug_pub.check_log_on(l_module,FND_LOG.LEVEL_STATEMENT);
6455: put_in_log(l_debug_enabled,is_debug_procedure_on,is_debug_statement_on,l_module, 'P',
6456: 'begin debug OKLRRPTB.pls call ' || l_api_name);

Line 6454: is_debug_statement_on := okl_debug_pub.check_log_on(l_module,FND_LOG.LEVEL_STATEMENT);

6450: l_debug_enabled := okl_debug_pub.check_log_enabled;
6451: -- check for logging on PROCEDURE level
6452: is_debug_procedure_on := okl_debug_pub.check_log_on(l_module,FND_LOG.LEVEL_PROCEDURE);
6453: -- check for logging on STATEMENT level
6454: is_debug_statement_on := okl_debug_pub.check_log_on(l_module,FND_LOG.LEVEL_STATEMENT);
6455: put_in_log(l_debug_enabled,is_debug_procedure_on,is_debug_statement_on,l_module, 'P',
6456: 'begin debug OKLRRPTB.pls call ' || l_api_name);
6457: put_in_log(l_debug_enabled,is_debug_procedure_on,is_debug_statement_on,l_module, 'P',
6458: 'Input Parameters ' ||

Line 7391: l_debug_enabled := okl_debug_pub.check_log_enabled;

7387: l_org_id NUMBER;
7388: l_le_id NUMBER;
7389: l_proceed_flag BOOLEAN := TRUE;
7390: BEGIN
7391: l_debug_enabled := okl_debug_pub.check_log_enabled;
7392: -- check for logging on PROCEDURE level
7393: is_debug_procedure_on := okl_debug_pub.check_log_on(l_module,FND_LOG.LEVEL_PROCEDURE);
7394: -- check for logging on STATEMENT level
7395: is_debug_statement_on := okl_debug_pub.check_log_on(l_module,FND_LOG.LEVEL_STATEMENT);

Line 7393: is_debug_procedure_on := okl_debug_pub.check_log_on(l_module,FND_LOG.LEVEL_PROCEDURE);

7389: l_proceed_flag BOOLEAN := TRUE;
7390: BEGIN
7391: l_debug_enabled := okl_debug_pub.check_log_enabled;
7392: -- check for logging on PROCEDURE level
7393: is_debug_procedure_on := okl_debug_pub.check_log_on(l_module,FND_LOG.LEVEL_PROCEDURE);
7394: -- check for logging on STATEMENT level
7395: is_debug_statement_on := okl_debug_pub.check_log_on(l_module,FND_LOG.LEVEL_STATEMENT);
7396: put_in_log(l_debug_enabled,is_debug_procedure_on,is_debug_statement_on,l_module, 'P',
7397: 'begin debug OKLRRPTB.pls call ' || l_api_name);

Line 7395: is_debug_statement_on := okl_debug_pub.check_log_on(l_module,FND_LOG.LEVEL_STATEMENT);

7391: l_debug_enabled := okl_debug_pub.check_log_enabled;
7392: -- check for logging on PROCEDURE level
7393: is_debug_procedure_on := okl_debug_pub.check_log_on(l_module,FND_LOG.LEVEL_PROCEDURE);
7394: -- check for logging on STATEMENT level
7395: is_debug_statement_on := okl_debug_pub.check_log_on(l_module,FND_LOG.LEVEL_STATEMENT);
7396: put_in_log(l_debug_enabled,is_debug_procedure_on,is_debug_statement_on,l_module, 'P',
7397: 'begin debug OKLRRPTB.pls call ' || l_api_name);
7398: put_in_log(l_debug_enabled,is_debug_procedure_on,is_debug_statement_on,l_module, 'P',
7399: 'BEGIN API OKL_REPORT_GENERATOR_PVT.generate_gross_inv_recon_rpt');