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.XLA_MO_REPORTING_API dependencies on FND_LOG

Line 27: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

23: FND_MESSAGE.SET_NAME('FND', 'SQL_PLSQL_ERROR');
24: FND_MESSAGE.SET_TOKEN('ROUTINE', routine);
25: FND_MESSAGE.SET_TOKEN('ERRNO', errcode);
26: FND_MESSAGE.SET_TOKEN('REASON', errmsg);
27: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
28: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED, routine, FALSE);
29: END IF;
30: APP_EXCEPTION.RAISE_EXCEPTION;
31: EXCEPTION

Line 28: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED, routine, FALSE);

24: FND_MESSAGE.SET_TOKEN('ROUTINE', routine);
25: FND_MESSAGE.SET_TOKEN('ERRNO', errcode);
26: FND_MESSAGE.SET_TOKEN('REASON', errmsg);
27: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
28: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED, routine, FALSE);
29: END IF;
30: APP_EXCEPTION.RAISE_EXCEPTION;
31: EXCEPTION
32: WHEN OTHERS THEN RAISE;

Line 77: IF (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

73: THEN
74: fnd_message.set_token(token4,value4);
75: END IF;
76:
77: IF (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
78: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR, routine, FALSE);
79: END IF;
80:
81: app_exception.raise_exception;

Line 78: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR, routine, FALSE);

74: fnd_message.set_token(token4,value4);
75: END IF;
76:
77: IF (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
78: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR, routine, FALSE);
79: END IF;
80:
81: app_exception.raise_exception;
82:

Line 104: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

100: )
101: IS
102:
103: BEGIN
104: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
105: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
106: 'xla.plsql.XLA_MO_REPORTING_API.INITIALIZE.begin',
107: 'Calling PL/SQL procedure XLA_MO_REPORTING_API.INITIALIZE:'||
108: ' p_reporting_level=>'||p_reporting_level||

Line 105: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

101: IS
102:
103: BEGIN
104: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
105: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
106: 'xla.plsql.XLA_MO_REPORTING_API.INITIALIZE.begin',
107: 'Calling PL/SQL procedure XLA_MO_REPORTING_API.INITIALIZE:'||
108: ' p_reporting_level=>'||p_reporting_level||
109: ',p_reporting_entity_id=>'||p_reporting_entity_id||

Line 118: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

114: p_reporting_entity_id,
115: p_pred_type,
116: 'Y');
117:
118: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
119: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
120: 'xla.plsql.XLA_MO_REPORTING_API.INITIALIZE.end',
121: 'Returning from PL/SQL procedure XLA_MO_REPORTING_API.INITIALIZE:');
122:

Line 119: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

115: p_pred_type,
116: 'Y');
117:
118: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
119: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
120: 'xla.plsql.XLA_MO_REPORTING_API.INITIALIZE.end',
121: 'Returning from PL/SQL procedure XLA_MO_REPORTING_API.INITIALIZE:');
122:
123: END IF;

Line 254: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

250:
251: l_dummy NUMBER;
252:
253: BEGIN
254: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
255: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
256: 'xla.plsql.XLA_MO_REPORTING_API.VALIDATE_REPORTING_LEVEL.begin',
257: 'Calling PL/SQL procedure XLA_MO_REPORTING_API.VALIDATE_REPORTING_LEVEL:'||
258: ' p_reporting_level=>'||p_reporting_level);

Line 255: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

251: l_dummy NUMBER;
252:
253: BEGIN
254: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
255: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
256: 'xla.plsql.XLA_MO_REPORTING_API.VALIDATE_REPORTING_LEVEL.begin',
257: 'Calling PL/SQL procedure XLA_MO_REPORTING_API.VALIDATE_REPORTING_LEVEL:'||
258: ' p_reporting_level=>'||p_reporting_level);
259: END IF;

Line 263: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

259: END IF;
260:
261: l_top_reporting_level := fnd_profile.value('XLA_MO_TOP_REPORTING_LEVEL');
262:
263: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
264: FND_LOG.STRING(FND_LOG.LEVEL_EVENT,
265: 'xla.plsql.XLA_MO_REPORTING_API.VALIDATE_REPORTING_LEVEL.config',
266: 'MO: Top Reporting Level='||l_top_reporting_level);
267: END IF;

Line 264: FND_LOG.STRING(FND_LOG.LEVEL_EVENT,

260:
261: l_top_reporting_level := fnd_profile.value('XLA_MO_TOP_REPORTING_LEVEL');
262:
263: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
264: FND_LOG.STRING(FND_LOG.LEVEL_EVENT,
265: 'xla.plsql.XLA_MO_REPORTING_API.VALIDATE_REPORTING_LEVEL.config',
266: 'MO: Top Reporting Level='||l_top_reporting_level);
267: END IF;
268:

Line 284: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

280: END IF;
281:
282: CLOSE l_check_reporting_level;
283:
284: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
285: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
286: 'xla.plsql.XLA_MO_REPORTING_API.VALIDATE_REPORTING_LEVEL.end',
287: 'Returning from PL/SQL procedure '||
288: 'XLA_MO_REPORTING_API.VALIDATE_REPORTING_LEVEL');

Line 285: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

281:
282: CLOSE l_check_reporting_level;
283:
284: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
285: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
286: 'xla.plsql.XLA_MO_REPORTING_API.VALIDATE_REPORTING_LEVEL.end',
287: 'Returning from PL/SQL procedure '||
288: 'XLA_MO_REPORTING_API.VALIDATE_REPORTING_LEVEL');
289: END IF;

Line 341: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

337:
338: l_dummy NUMBER;
339:
340: BEGIN
341: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
342: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
343: 'xla.plsql.XLA_MO_REPORTING_API.VALIDATE_REPORTING_ENTITY.begin',
344: 'Calling PL/SQL procedure XLA_MO_REPORTING_API.VALIDATE_REPORTING_ENTITY:'||
345: ' p_reporting_level=>'||p_reporting_level||

Line 342: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

338: l_dummy NUMBER;
339:
340: BEGIN
341: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
342: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
343: 'xla.plsql.XLA_MO_REPORTING_API.VALIDATE_REPORTING_ENTITY.begin',
344: 'Calling PL/SQL procedure XLA_MO_REPORTING_API.VALIDATE_REPORTING_ENTITY:'||
345: ' p_reporting_level=>'||p_reporting_level||
346: ',p_reporting_entity_id=>'||p_reporting_entity_id);

Line 351: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

347: END IF;
348:
349: validate_reporting_level(p_reporting_level);
350:
351: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
352: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
353: 'xla.plsql.XLA_MO_REPORTING_API.VALIDATE_REPORTING_ENTITY.rep_level_valid',
354: 'Reporting level is valid');
355: END IF;

Line 352: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

348:
349: validate_reporting_level(p_reporting_level);
350:
351: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
352: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
353: 'xla.plsql.XLA_MO_REPORTING_API.VALIDATE_REPORTING_ENTITY.rep_level_valid',
354: 'Reporting level is valid');
355: END IF;
356:

Line 371: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

367: END IF;
368:
369: CLOSE l_check_reporting_entity;
370:
371: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
372: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
373: 'xla.plsql.XLA_MO_REPORTING_API.VALIDATE_REPORTING_ENTITY.end',
374: 'Returning from PL/SQL procedure '||
375: 'XLA_MO_REPORTING_API.VALIDATE_REPORTING_ENTITY:');

Line 372: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

368:
369: CLOSE l_check_reporting_entity;
370:
371: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
372: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
373: 'xla.plsql.XLA_MO_REPORTING_API.VALIDATE_REPORTING_ENTITY.end',
374: 'Returning from PL/SQL procedure '||
375: 'XLA_MO_REPORTING_API.VALIDATE_REPORTING_ENTITY:');
376: END IF;

Line 429: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

425:
426: l_use_nvl VARCHAR2(1);
427:
428: BEGIN
429: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
430: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
431: 'xla.plsql.XLA_MO_REPORTING_API.INITIALIZE.begin',
432: 'Calling PL/SQL procedure XLA_MO_REPORTING_API.INITIALIZE:'||
433: ' p_reporting_level=>'||p_reporting_level||

Line 430: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

426: l_use_nvl VARCHAR2(1);
427:
428: BEGIN
429: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
430: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
431: 'xla.plsql.XLA_MO_REPORTING_API.INITIALIZE.begin',
432: 'Calling PL/SQL procedure XLA_MO_REPORTING_API.INITIALIZE:'||
433: ' p_reporting_level=>'||p_reporting_level||
434: ',p_reporting_entity_id=>'||p_reporting_entity_id||

Line 450: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

446: ELSE
447: l_use_nvl := 'Y';
448: END IF;
449:
450: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
451: FND_LOG.STRING(FND_LOG.LEVEL_EVENT,
452: 'xla.plsql.XLA_MO_REPORTING_API.INITIALIZE.use_nvl',
453: 'nvl(fnd_product_groups.multi_org_flag,''N'')='||l_multi_org_enabled||
454: ',l_use_nvl='||l_use_nvl);

Line 451: FND_LOG.STRING(FND_LOG.LEVEL_EVENT,

447: l_use_nvl := 'Y';
448: END IF;
449:
450: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
451: FND_LOG.STRING(FND_LOG.LEVEL_EVENT,
452: 'xla.plsql.XLA_MO_REPORTING_API.INITIALIZE.use_nvl',
453: 'nvl(fnd_product_groups.multi_org_flag,''N'')='||l_multi_org_enabled||
454: ',l_use_nvl='||l_use_nvl);
455: END IF;

Line 471: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

467: -- association of primary and reporting set of books in HR.
468: IF p_reporting_level = '1000' then
469: gl_mc_info.get_sob_type(p_reporting_entity_id, l_sob_type);
470:
471: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
472: FND_LOG.STRING(FND_LOG.LEVEL_EVENT,
473: 'xla.plsql.XLA_MO_REPORTING_API.INITIALIZE.get_sob_type',
474: 'gl_mc_info.get_sob_type='||l_sob_type);
475: END IF;

Line 472: FND_LOG.STRING(FND_LOG.LEVEL_EVENT,

468: IF p_reporting_level = '1000' then
469: gl_mc_info.get_sob_type(p_reporting_entity_id, l_sob_type);
470:
471: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
472: FND_LOG.STRING(FND_LOG.LEVEL_EVENT,
473: 'xla.plsql.XLA_MO_REPORTING_API.INITIALIZE.get_sob_type',
474: 'gl_mc_info.get_sob_type='||l_sob_type);
475: END IF;
476:

Line 487: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

483: -- a given reporting set of books.
484: l_reporting_entity_id :=
485: gl_mc_info.get_primary_set_of_books_id(p_reporting_entity_id);
486:
487: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
488: FND_LOG.STRING(FND_LOG.LEVEL_EVENT,
489: 'xla.plsql.XLA_MO_REPORTING_API.INITIALIZE.primary_sob_id',
490: 'gl_mc_info.primary_set_of_books_id='||l_reporting_entity_id);
491: END IF;

Line 488: FND_LOG.STRING(FND_LOG.LEVEL_EVENT,

484: l_reporting_entity_id :=
485: gl_mc_info.get_primary_set_of_books_id(p_reporting_entity_id);
486:
487: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
488: FND_LOG.STRING(FND_LOG.LEVEL_EVENT,
489: 'xla.plsql.XLA_MO_REPORTING_API.INITIALIZE.primary_sob_id',
490: 'gl_mc_info.primary_set_of_books_id='||l_reporting_entity_id);
491: END IF;
492:

Line 521: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

517: ELSE
518: l_pred_type := 'EXISTS';
519: END IF;
520:
521: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
522: FND_LOG.STRING(FND_LOG.LEVEL_EVENT,
523: 'xla.plsql.XLA_MO_REPORTING_API.INITIALIZE.pred_type',
524: 'Determined predicate type:'||
525: ' l_count='||l_count||

Line 522: FND_LOG.STRING(FND_LOG.LEVEL_EVENT,

518: l_pred_type := 'EXISTS';
519: END IF;
520:
521: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
522: FND_LOG.STRING(FND_LOG.LEVEL_EVENT,
523: 'xla.plsql.XLA_MO_REPORTING_API.INITIALIZE.pred_type',
524: 'Determined predicate type:'||
525: ' l_count='||l_count||
526: ',g_max_num='||g_max_num||

Line 538: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

534: THEN
535:
536: l_pred_type := p_pred_type;
537:
538: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
539: FND_LOG.STRING(FND_LOG.LEVEL_EVENT,
540: 'xla.plsql.XLA_MO_REPORTING_API.INITIALIZE.pred_type',
541: 'Determined predicate type: '||
542: 'l_pred_type='||l_pred_type);

Line 539: FND_LOG.STRING(FND_LOG.LEVEL_EVENT,

535:
536: l_pred_type := p_pred_type;
537:
538: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
539: FND_LOG.STRING(FND_LOG.LEVEL_EVENT,
540: 'xla.plsql.XLA_MO_REPORTING_API.INITIALIZE.pred_type',
541: 'Determined predicate type: '||
542: 'l_pred_type='||l_pred_type);
543: END IF;

Line 550: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

546:
547:
548: IF ( p_reporting_level = '3000' ) /* Operating Unit Level */ THEN
549:
550: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
551: FND_LOG.STRING(FND_LOG.LEVEL_EVENT,
552: 'xla.plsql.XLA_MO_REPORTING_API.INITIALIZE.pred_text',
553: 'Generating predicate for reporting level 3000');
554: END IF;

Line 551: FND_LOG.STRING(FND_LOG.LEVEL_EVENT,

547:
548: IF ( p_reporting_level = '3000' ) /* Operating Unit Level */ THEN
549:
550: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
551: FND_LOG.STRING(FND_LOG.LEVEL_EVENT,
552: 'xla.plsql.XLA_MO_REPORTING_API.INITIALIZE.pred_text',
553: 'Generating predicate for reporting level 3000');
554: END IF;
555:

Line 570: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

566:
567: --Bug 13116125
568: --reverted from EXISTS to IN for IN_LIST replaced IN logic with EXISTS for performance reasons
569:
570: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
571: FND_LOG.STRING(FND_LOG.LEVEL_EVENT,
572: 'xla.plsql.XLA_MO_REPORTING_API.INITIALIZE.pred_text',
573: 'Generating IN_LIST predicate for reporting level 1000/2000');
574: END IF;

Line 571: FND_LOG.STRING(FND_LOG.LEVEL_EVENT,

567: --Bug 13116125
568: --reverted from EXISTS to IN for IN_LIST replaced IN logic with EXISTS for performance reasons
569:
570: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
571: FND_LOG.STRING(FND_LOG.LEVEL_EVENT,
572: 'xla.plsql.XLA_MO_REPORTING_API.INITIALIZE.pred_text',
573: 'Generating IN_LIST predicate for reporting level 1000/2000');
574: END IF;
575:

Line 609: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

605: AND l_pred_type = 'INSTR' ) THEN
606:
607: -- replaced INSTR logic with EXISTS for performance reasons
608:
609: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
610: FND_LOG.STRING(FND_LOG.LEVEL_EVENT,
611: 'xla.plsql.XLA_MO_REPORTING_API.INITIALIZE.pred_text',
612: 'Generating EXISTS predicate for reporting level 1000/2000');
613: END IF;

Line 610: FND_LOG.STRING(FND_LOG.LEVEL_EVENT,

606:
607: -- replaced INSTR logic with EXISTS for performance reasons
608:
609: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
610: FND_LOG.STRING(FND_LOG.LEVEL_EVENT,
611: 'xla.plsql.XLA_MO_REPORTING_API.INITIALIZE.pred_text',
612: 'Generating EXISTS predicate for reporting level 1000/2000');
613: END IF;
614:

Line 649: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

645: ELSIF ( ( p_reporting_level = '2000'
646: OR p_reporting_level = '1000' )
647: AND l_pred_type = 'EXISTS' ) THEN
648:
649: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
650: FND_LOG.STRING(FND_LOG.LEVEL_EVENT,
651: 'xla.plsql.XLA_MO_REPORTING_API.INITIALIZE.pred_text',
652: 'Generating EXISTS predicate for reporting level 1000/2000');
653: END IF;

Line 650: FND_LOG.STRING(FND_LOG.LEVEL_EVENT,

646: OR p_reporting_level = '1000' )
647: AND l_pred_type = 'EXISTS' ) THEN
648:
649: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
650: FND_LOG.STRING(FND_LOG.LEVEL_EVENT,
651: 'xla.plsql.XLA_MO_REPORTING_API.INITIALIZE.pred_text',
652: 'Generating EXISTS predicate for reporting level 1000/2000');
653: END IF;
654:

Line 687: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

683: ELSIF ( ( p_reporting_level = '2000'
684: OR p_reporting_level = '1000' )
685: AND l_pred_type = 'IN_SELECT' ) THEN
686:
687: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
688: FND_LOG.STRING(FND_LOG.LEVEL_EVENT,
689: 'xla.plsql.XLA_MO_REPORTING_API.INITIALIZE.pred_text',
690: 'Generating IN_SELECT predicate for reporting level 1000/2000');
691: END IF;

Line 688: FND_LOG.STRING(FND_LOG.LEVEL_EVENT,

684: OR p_reporting_level = '1000' )
685: AND l_pred_type = 'IN_SELECT' ) THEN
686:
687: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
688: FND_LOG.STRING(FND_LOG.LEVEL_EVENT,
689: 'xla.plsql.XLA_MO_REPORTING_API.INITIALIZE.pred_text',
690: 'Generating IN_SELECT predicate for reporting level 1000/2000');
691: END IF;
692:

Line 729: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

725: g_pred := l_pred;
726:
727: l_pred := NULL;
728:
729: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
730: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
731: 'xla.plsql.XLA_MO_REPORTING_API.INITIALIZE.end',
732: 'Returning from PL/SQL procedure XLA_MO_REPORTING_API.INITIALIZE:'||
733: ' g_reporting_level='||g_reporting_level||

Line 730: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

726:
727: l_pred := NULL;
728:
729: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
730: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
731: 'xla.plsql.XLA_MO_REPORTING_API.INITIALIZE.end',
732: 'Returning from PL/SQL procedure XLA_MO_REPORTING_API.INITIALIZE:'||
733: ' g_reporting_level='||g_reporting_level||
734: ',g_reporting_entity_id='||g_reporting_entity_id||