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 XLA_MO_REPORTING_API

Line 1: PACKAGE BODY XLA_MO_REPORTING_API AS

1: PACKAGE BODY XLA_MO_REPORTING_API AS
2: /* $Header: XLAMORPB.pls 120.12 2011/12/06 10:24:26 nmikkili ship $ */
3:
4: g_max_num NUMBER DEFAULT 100;
5: g_pred VARCHAR2(2000) DEFAULT NULL;

Line 85: Generic_Error( 'xla.plsql.XLA_MO_REPORTING_API.APP_ERROR'

81: app_exception.raise_exception;
82:
83: EXCEPTION
84: WHEN OTHERS THEN
85: Generic_Error( 'xla.plsql.XLA_MO_REPORTING_API.APP_ERROR'
86: , sqlcode
87: , sqlerrm);
88: END App_Error;
89:

Line 106: 'xla.plsql.XLA_MO_REPORTING_API.INITIALIZE.begin',

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||
110: ',p_pred_type=>'||p_pred_type);

Line 107: 'Calling PL/SQL procedure XLA_MO_REPORTING_API.INITIALIZE:'||

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||
110: ',p_pred_type=>'||p_pred_type);
111: END IF;

Line 120: 'xla.plsql.XLA_MO_REPORTING_API.INITIALIZE.end',

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;
124:

Line 121: 'Returning from PL/SQL procedure XLA_MO_REPORTING_API.INITIALIZE:');

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;
124:
125: END Initialize;

Line 159: Generic_Error( 'xla.plsql.XLA_MO_REPORTING_API.GET_PREDICATE'

155: RETURN l_return_pred;
156:
157: EXCEPTION
158: WHEN OTHERS THEN
159: Generic_Error( 'xla.plsql.XLA_MO_REPORTING_API.GET_PREDICATE'
160: , sqlcode
161: , sqlerrm);
162:
163: END Get_Predicate;

Line 185: Generic_Error( 'xla.plsql.XLA_MO_REPORTING_API.GET_REPORTING_LEVEL_NAME'

181: RETURN l_reporting_level_name;
182:
183: EXCEPTION
184: WHEN OTHERS THEN
185: Generic_Error( 'xla.plsql.XLA_MO_REPORTING_API.GET_REPORTING_LEVEL_NAME'
186: , sqlcode
187: , sqlerrm);
188:
189: END Get_Reporting_Level_Name;

Line 222: Generic_Error( 'xla.plsql.XLA_MO_REPORTING_API.GET_REPORTING_ENTITY_NAME'

218: RETURN l_reporting_entity_name;
219:
220: EXCEPTION
221: WHEN OTHERS THEN
222: Generic_Error( 'xla.plsql.XLA_MO_REPORTING_API.GET_REPORTING_ENTITY_NAME'
223: , sqlcode
224: , sqlerrm);
225:
226: END Get_Reporting_Entity_Name;

Line 256: 'xla.plsql.XLA_MO_REPORTING_API.VALIDATE_REPORTING_LEVEL.begin',

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;
260:

Line 257: 'Calling PL/SQL procedure XLA_MO_REPORTING_API.VALIDATE_REPORTING_LEVEL:'||

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;
260:
261: l_top_reporting_level := fnd_profile.value('XLA_MO_TOP_REPORTING_LEVEL');

Line 265: 'xla.plsql.XLA_MO_REPORTING_API.VALIDATE_REPORTING_LEVEL.config',

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:
269: OPEN l_check_reporting_level( p_reporting_level, l_top_reporting_level);

Line 275: App_Error( 'xla.plsql.XLA_MO_REPORTING_API.VALIDATE_REPORTING_LEVEL'

271:
272: IF (l_check_reporting_level%NOTFOUND )
273: THEN
274: CLOSE l_check_reporting_level;
275: App_Error( 'xla.plsql.XLA_MO_REPORTING_API.VALIDATE_REPORTING_LEVEL'
276: , 'XLA_MO_RPTAPI_LEVEL'
277: , 'REPORTING_LEVEL', p_reporting_level
278: , 'TOP_REPORTING_LEVEL', l_top_reporting_level);
279:

Line 286: 'xla.plsql.XLA_MO_REPORTING_API.VALIDATE_REPORTING_LEVEL.end',

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;
290:

Line 288: 'XLA_MO_REPORTING_API.VALIDATE_REPORTING_LEVEL');

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;
290:
291: EXCEPTION
292: WHEN OTHERS THEN

Line 293: Generic_Error( 'xla.plsql.XLA_MO_REPORTING_API.VALIDATE_REPORTING_LEVEL'

289: END IF;
290:
291: EXCEPTION
292: WHEN OTHERS THEN
293: Generic_Error( 'xla.plsql.XLA_MO_REPORTING_API.VALIDATE_REPORTING_LEVEL'
294: , sqlcode
295: , sqlerrm);
296:
297: END Validate_Reporting_Level;

Line 343: 'xla.plsql.XLA_MO_REPORTING_API.VALIDATE_REPORTING_ENTITY.begin',

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);
347: END IF;

Line 344: 'Calling PL/SQL procedure XLA_MO_REPORTING_API.VALIDATE_REPORTING_ENTITY:'||

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);
347: END IF;
348:

Line 353: 'xla.plsql.XLA_MO_REPORTING_API.VALIDATE_REPORTING_ENTITY.rep_level_valid',

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:
357: OPEN l_check_reporting_entity ( p_reporting_level, p_reporting_entity_id );

Line 363: App_Error('xla.plsql.XLA_MO_REPORTING_API.VALIDATE_REPORTING_ENTITY',

359:
360: IF ( l_check_reporting_entity%NOTFOUND )
361: THEN
362: CLOSE l_check_reporting_entity;
363: App_Error('xla.plsql.XLA_MO_REPORTING_API.VALIDATE_REPORTING_ENTITY',
364: 'XLA_MO_RPTAPI_ENTITY',
365: 'REPORTING_ENTITY',
366: p_reporting_entity_id);
367: END IF;

Line 373: 'xla.plsql.XLA_MO_REPORTING_API.VALIDATE_REPORTING_ENTITY.end',

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;
377:

Line 375: 'XLA_MO_REPORTING_API.VALIDATE_REPORTING_ENTITY:');

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;
377:
378: EXCEPTION
379: WHEN OTHERS THEN

Line 380: Generic_Error( 'xla.plsql.XLA_MO_REPORTING_API.VALIDATE_REPORTING_ENTITY'

376: END IF;
377:
378: EXCEPTION
379: WHEN OTHERS THEN
380: Generic_Error( 'xla.plsql.XLA_MO_REPORTING_API.VALIDATE_REPORTING_ENTITY'
381: , sqlcode
382: , sqlerrm);
383:
384: END Validate_Reporting_Entity;

Line 431: 'xla.plsql.XLA_MO_REPORTING_API.INITIALIZE.begin',

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||
435: ',p_pred_type=>'||p_pred_type||

Line 432: 'Calling PL/SQL procedure XLA_MO_REPORTING_API.INITIALIZE:'||

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||
435: ',p_pred_type=>'||p_pred_type||
436: ',p_use_nvl=>'||p_use_nvl);

Line 452: 'xla.plsql.XLA_MO_REPORTING_API.INITIALIZE.use_nvl',

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;
456:

Line 473: 'xla.plsql.XLA_MO_REPORTING_API.INITIALIZE.get_sob_type',

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:
477: IF l_sob_type = 'R' then

Line 489: 'xla.plsql.XLA_MO_REPORTING_API.INITIALIZE.primary_sob_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:
493: END IF;

Line 523: 'xla.plsql.XLA_MO_REPORTING_API.INITIALIZE.pred_type',

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||
527: ',l_pred_type='||l_pred_type);

Line 540: 'xla.plsql.XLA_MO_REPORTING_API.INITIALIZE.pred_type',

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;
544:

Line 552: 'xla.plsql.XLA_MO_REPORTING_API.INITIALIZE.pred_text',

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:
556: IF (l_use_nvl = 'Y') THEN

Line 572: 'xla.plsql.XLA_MO_REPORTING_API.INITIALIZE.pred_text',

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:
576: IF (l_use_nvl = 'Y') THEN

Line 611: 'xla.plsql.XLA_MO_REPORTING_API.INITIALIZE.pred_text',

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:
615: IF (l_use_nvl = 'Y') THEN

Line 651: 'xla.plsql.XLA_MO_REPORTING_API.INITIALIZE.pred_text',

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:
655: IF (l_use_nvl = 'Y') THEN

Line 689: 'xla.plsql.XLA_MO_REPORTING_API.INITIALIZE.pred_text',

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:
693: IF (l_use_nvl = 'Y') THEN

Line 731: 'xla.plsql.XLA_MO_REPORTING_API.INITIALIZE.end',

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||
735: ',g_max_num='||g_max_num||

Line 732: 'Returning from PL/SQL procedure XLA_MO_REPORTING_API.INITIALIZE:'||

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||
735: ',g_max_num='||g_max_num||
736: ',g_pred='||g_pred);

Line 741: Generic_Error( 'xla.plsql.XLA_MO_REPORTING_API.INITIALIZE'

737: END IF;
738:
739: EXCEPTION
740: WHEN OTHERS THEN
741: Generic_Error( 'xla.plsql.XLA_MO_REPORTING_API.INITIALIZE'
742: , sqlcode
743: , sqlerrm);
744:
745: END initialize;

Line 748: END XLA_MO_REPORTING_API;

744:
745: END initialize;
746:
747:
748: END XLA_MO_REPORTING_API;