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 FND_LOG

Line 89: p_module IN fnd_log_messages.module%TYPE,

85:
86:
87: PROCEDURE write_to_log(
88: p_level IN VARCHAR2,
89: p_module IN fnd_log_messages.module%TYPE,
90: msg IN VARCHAR2 )
91: AS
92: -- l_level: S - Statement, P- Procedure, B - Both
93: BEGIN

Line 104: p_module IN fnd_log_messages.module%TYPE,

100: PROCEDURE put_in_log(
101: p_debug_enabled IN VARCHAR2,
102: is_debug_procedure_on IN BOOLEAN,
103: is_debug_statement_on IN BOOLEAN,
104: p_module IN fnd_log_messages.module%TYPE,
105: p_level IN VARCHAR2,
106: msg IN VARCHAR2 )
107: AS
108: -- l_level: S - Statement, P- Procedure, B - Both

Line 113: p_level => FND_LOG.LEVEL_PROCEDURE,

109: BEGIN
110: IF(p_debug_enabled='Y' AND is_debug_procedure_on AND p_level = 'P')
111: THEN
112: write_to_log(
113: p_level => FND_LOG.LEVEL_PROCEDURE,
114: p_module => p_module,
115: msg => msg);
116: ELSIF (p_debug_enabled='Y' AND is_debug_statement_on AND
117: (p_level = 'S' OR p_level = 'B' ))

Line 120: p_level => FND_LOG.LEVEL_STATEMENT,

116: ELSIF (p_debug_enabled='Y' AND is_debug_statement_on AND
117: (p_level = 'S' OR p_level = 'B' ))
118: THEN
119: write_to_log(
120: p_level => FND_LOG.LEVEL_STATEMENT,
121: p_module => p_module,
122: msg => msg);
123: END IF;
124: -- Log Each and Every Statement

Line 178: l_module CONSTANT fnd_log_messages.module%TYPE := G_MODULE || l_api_name;

174: l_api_version CONSTANT NUMBER := 1;
175: l_api_name CONSTANT VARCHAR2(30) := 'populate_code_combinations';
176: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
177: -- Debug related parameters
178: l_module CONSTANT fnd_log_messages.module%TYPE := G_MODULE || l_api_name;
179: l_debug_enabled VARCHAR2(10);
180: is_debug_procedure_on BOOLEAN;
181: is_debug_statement_on BOOLEAN;
182: -- Local Variables

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 344: l_module CONSTANT fnd_log_messages.module%TYPE := G_MODULE || l_api_name;

340: l_api_version CONSTANT NUMBER := 1;
341: l_api_name CONSTANT VARCHAR2(30) := 'populate_products';
342: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
343: -- Debug related parameters
344: l_module CONSTANT fnd_log_messages.module%TYPE := G_MODULE || l_api_name;
345: l_debug_enabled VARCHAR2(10);
346: is_debug_procedure_on BOOLEAN;
347: is_debug_statement_on BOOLEAN;
348: -- Local Variables

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 466: l_module CONSTANT fnd_log_messages.module%TYPE := G_MODULE || l_api_name;

462: l_api_version CONSTANT NUMBER := 1;
463: l_api_name CONSTANT VARCHAR2(30) := 'populate_trx_data';
464: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
465: -- Debug related parameters
466: l_module CONSTANT fnd_log_messages.module%TYPE := G_MODULE || l_api_name;
467: l_debug_enabled VARCHAR2(10);
468: is_debug_procedure_on BOOLEAN;
469: is_debug_statement_on BOOLEAN;
470: -- Local Variables

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 3246: l_module CONSTANT fnd_log_messages.module%TYPE := G_MODULE || l_api_name;

3242: l_api_version CONSTANT NUMBER := 1;
3243: l_api_name CONSTANT VARCHAR2(30) := 'process_strm_bal_details';
3244: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
3245: -- Debug related parameters
3246: l_module CONSTANT fnd_log_messages.module%TYPE := G_MODULE || l_api_name;
3247: l_debug_enabled VARCHAR2(10);
3248: is_debug_procedure_on BOOLEAN;
3249: is_debug_statement_on BOOLEAN;
3250: -- Local Variables

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 3480: l_module CONSTANT fnd_log_messages.module%TYPE := G_MODULE || l_api_name;

3476: l_api_version CONSTANT NUMBER := 1;
3477: l_api_name CONSTANT VARCHAR2(30) := 'populate_acc_data';
3478: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
3479: -- Debug related parameters
3480: l_module CONSTANT fnd_log_messages.module%TYPE := G_MODULE || l_api_name;
3481: l_debug_enabled VARCHAR2(10);
3482: is_debug_procedure_on BOOLEAN;
3483: is_debug_statement_on BOOLEAN;
3484: -- Local Variables

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 5089: l_module CONSTANT fnd_log_messages.module%TYPE := G_MODULE || l_api_name;

5085: l_api_version CONSTANT NUMBER := 1;
5086: l_api_name CONSTANT VARCHAR2(30) := 'populate_gl_balances';
5087: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
5088: -- Debug related parameters
5089: l_module CONSTANT fnd_log_messages.module%TYPE := G_MODULE || l_api_name;
5090: l_debug_enabled VARCHAR2(10);
5091: is_debug_procedure_on BOOLEAN;
5092: is_debug_statement_on BOOLEAN;
5093: -- Local Variables

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 5852: l_module CONSTANT fnd_log_messages.module%TYPE := G_MODULE || l_api_name;

5848: l_api_version CONSTANT NUMBER := 1;
5849: l_api_name CONSTANT VARCHAR2(30) := 'validate_orgs_access';
5850: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
5851: -- Debug related parameters
5852: l_module CONSTANT fnd_log_messages.module%TYPE := G_MODULE || l_api_name;
5853: l_debug_enabled VARCHAR2(10);
5854: is_debug_procedure_on BOOLEAN;
5855: is_debug_statement_on BOOLEAN;
5856: -- Local Variable Declarations

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 5972: l_module CONSTANT fnd_log_messages.module%TYPE := G_MODULE || l_api_name;

5968: l_api_name CONSTANT VARCHAR2(30) := 'POPULATE_STRM_TO_TRX_DATA';
5969: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
5970:
5971: -- Debug related parameters
5972: l_module CONSTANT fnd_log_messages.module%TYPE := G_MODULE || l_api_name;
5973: l_debug_enabled VARCHAR2(10);
5974: is_debug_procedure_on BOOLEAN;
5975: is_debug_statement_on BOOLEAN;
5976:

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 7382: l_module CONSTANT fnd_log_messages.module%TYPE := G_MODULE || l_api_name;

7378: l_api_version CONSTANT NUMBER := 1;
7379: l_api_name CONSTANT VARCHAR2(30) := 'generate_gross_inv_recon_rpt';
7380: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
7381: -- Debug related parameters
7382: l_module CONSTANT fnd_log_messages.module%TYPE := G_MODULE || l_api_name;
7383: l_debug_enabled VARCHAR2(10);
7384: is_debug_procedure_on BOOLEAN;
7385: is_debug_statement_on BOOLEAN;
7386: -- Local Variable declaration

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