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_VALIDATIONS_PKG dependencies on XLA_UTILITY_PKG

Line 42: xla_utility_pkg.trace('> xla_validations_pkg.object_name_is_valid' , 10);

38: l_char varchar2(1) := null;
39: l_return BOOLEAN := TRUE;
40:
41: BEGIN
42: xla_utility_pkg.trace('> xla_validations_pkg.object_name_is_valid' , 10);
43:
44: xla_utility_pkg.trace('Object Name = '||p_object_name , 20);
45:
46: SELECT length(p_object_name)

Line 44: xla_utility_pkg.trace('Object Name = '||p_object_name , 20);

40:
41: BEGIN
42: xla_utility_pkg.trace('> xla_validations_pkg.object_name_is_valid' , 10);
43:
44: xla_utility_pkg.trace('Object Name = '||p_object_name , 20);
45:
46: SELECT length(p_object_name)
47: INTO l_length
48: FROM dual;

Line 65: xla_utility_pkg.trace('< xla_validations_pkg.object_name_is_valid' , 10);

61: END IF;
62: END IF;
63: END LOOP;
64:
65: xla_utility_pkg.trace('< xla_validations_pkg.object_name_is_valid' , 10);
66:
67: RETURN l_return;
68:
69: EXCEPTION

Line 117: xla_utility_pkg.trace('> xla_validations_pkg.get_product_rule_info' , 10);

113: AND xpr.product_rule_code = p_product_rule_code
114: AND xpr.language = USERENV('LANG');
115:
116: BEGIN
117: xla_utility_pkg.trace('> xla_validations_pkg.get_product_rule_info' , 10);
118:
119: xla_utility_pkg.trace('Application_id = '||p_application_id , 20);
120: xla_utility_pkg.trace('product_rule_type_code = '||p_product_rule_type_code , 20);
121: xla_utility_pkg.trace('product_rule_code = '||p_product_rule_code , 20);

Line 119: xla_utility_pkg.trace('Application_id = '||p_application_id , 20);

115:
116: BEGIN
117: xla_utility_pkg.trace('> xla_validations_pkg.get_product_rule_info' , 10);
118:
119: xla_utility_pkg.trace('Application_id = '||p_application_id , 20);
120: xla_utility_pkg.trace('product_rule_type_code = '||p_product_rule_type_code , 20);
121: xla_utility_pkg.trace('product_rule_code = '||p_product_rule_code , 20);
122:
123: OPEN c_prod_rule;

Line 120: xla_utility_pkg.trace('product_rule_type_code = '||p_product_rule_type_code , 20);

116: BEGIN
117: xla_utility_pkg.trace('> xla_validations_pkg.get_product_rule_info' , 10);
118:
119: xla_utility_pkg.trace('Application_id = '||p_application_id , 20);
120: xla_utility_pkg.trace('product_rule_type_code = '||p_product_rule_type_code , 20);
121: xla_utility_pkg.trace('product_rule_code = '||p_product_rule_code , 20);
122:
123: OPEN c_prod_rule;
124: FETCH c_prod_rule

Line 121: xla_utility_pkg.trace('product_rule_code = '||p_product_rule_code , 20);

117: xla_utility_pkg.trace('> xla_validations_pkg.get_product_rule_info' , 10);
118:
119: xla_utility_pkg.trace('Application_id = '||p_application_id , 20);
120: xla_utility_pkg.trace('product_rule_type_code = '||p_product_rule_type_code , 20);
121: xla_utility_pkg.trace('product_rule_code = '||p_product_rule_code , 20);
122:
123: OPEN c_prod_rule;
124: FETCH c_prod_rule
125: INTO p_application_name, p_product_rule_name, p_product_rule_type;

Line 128: xla_utility_pkg.trace('< xla_validations_pkg.get_product_rule_info' , 10);

124: FETCH c_prod_rule
125: INTO p_application_name, p_product_rule_name, p_product_rule_type;
126: CLOSE c_prod_rule;
127:
128: xla_utility_pkg.trace('< xla_validations_pkg.get_product_rule_info' , 10);
129:
130: EXCEPTION
131: WHEN xla_exceptions_pkg.application_exception THEN
132: RAISE;

Line 179: xla_utility_pkg.trace('> xla_validations_pkg.get_description_info' , 10);

175: AND xdt.description_code = p_description_code
176: AND xdt.language = USERENV('LANG');
177:
178: BEGIN
179: xla_utility_pkg.trace('> xla_validations_pkg.get_description_info' , 10);
180:
181: xla_utility_pkg.trace('Application_id = '||p_application_id , 20);
182: xla_utility_pkg.trace('description_type_code = '||p_description_type_code , 20);
183: xla_utility_pkg.trace('description_code = '||p_description_code , 20);

Line 181: xla_utility_pkg.trace('Application_id = '||p_application_id , 20);

177:
178: BEGIN
179: xla_utility_pkg.trace('> xla_validations_pkg.get_description_info' , 10);
180:
181: xla_utility_pkg.trace('Application_id = '||p_application_id , 20);
182: xla_utility_pkg.trace('description_type_code = '||p_description_type_code , 20);
183: xla_utility_pkg.trace('description_code = '||p_description_code , 20);
184:
185: OPEN c_desc_rule;

Line 182: xla_utility_pkg.trace('description_type_code = '||p_description_type_code , 20);

178: BEGIN
179: xla_utility_pkg.trace('> xla_validations_pkg.get_description_info' , 10);
180:
181: xla_utility_pkg.trace('Application_id = '||p_application_id , 20);
182: xla_utility_pkg.trace('description_type_code = '||p_description_type_code , 20);
183: xla_utility_pkg.trace('description_code = '||p_description_code , 20);
184:
185: OPEN c_desc_rule;
186: FETCH c_desc_rule

Line 183: xla_utility_pkg.trace('description_code = '||p_description_code , 20);

179: xla_utility_pkg.trace('> xla_validations_pkg.get_description_info' , 10);
180:
181: xla_utility_pkg.trace('Application_id = '||p_application_id , 20);
182: xla_utility_pkg.trace('description_type_code = '||p_description_type_code , 20);
183: xla_utility_pkg.trace('description_code = '||p_description_code , 20);
184:
185: OPEN c_desc_rule;
186: FETCH c_desc_rule
187: INTO p_application_name, p_description_name, p_description_type;

Line 190: xla_utility_pkg.trace('< xla_validations_pkg.get_description_info' , 10);

186: FETCH c_desc_rule
187: INTO p_application_name, p_description_name, p_description_type;
188: CLOSE c_desc_rule;
189:
190: xla_utility_pkg.trace('< xla_validations_pkg.get_description_info' , 10);
191:
192: EXCEPTION
193: WHEN xla_exceptions_pkg.application_exception THEN
194: RAISE;

Line 241: xla_utility_pkg.trace('> xla_validations_pkg.get_segment_rule_info' , 10);

237: AND xsr.segment_rule_code = p_segment_rule_code
238: AND xsr.language = USERENV('LANG');
239:
240: BEGIN
241: xla_utility_pkg.trace('> xla_validations_pkg.get_segment_rule_info' , 10);
242:
243: xla_utility_pkg.trace('Application_id = '||p_application_id , 20);
244: xla_utility_pkg.trace('segment_rule_type_code = '||p_segment_rule_type_code , 20
245: );

Line 243: xla_utility_pkg.trace('Application_id = '||p_application_id , 20);

239:
240: BEGIN
241: xla_utility_pkg.trace('> xla_validations_pkg.get_segment_rule_info' , 10);
242:
243: xla_utility_pkg.trace('Application_id = '||p_application_id , 20);
244: xla_utility_pkg.trace('segment_rule_type_code = '||p_segment_rule_type_code , 20
245: );
246: xla_utility_pkg.trace('segment_rule_code = '||p_segment_rule_code , 20);
247:

Line 244: xla_utility_pkg.trace('segment_rule_type_code = '||p_segment_rule_type_code , 20

240: BEGIN
241: xla_utility_pkg.trace('> xla_validations_pkg.get_segment_rule_info' , 10);
242:
243: xla_utility_pkg.trace('Application_id = '||p_application_id , 20);
244: xla_utility_pkg.trace('segment_rule_type_code = '||p_segment_rule_type_code , 20
245: );
246: xla_utility_pkg.trace('segment_rule_code = '||p_segment_rule_code , 20);
247:
248: OPEN c_seg_rule;

Line 246: xla_utility_pkg.trace('segment_rule_code = '||p_segment_rule_code , 20);

242:
243: xla_utility_pkg.trace('Application_id = '||p_application_id , 20);
244: xla_utility_pkg.trace('segment_rule_type_code = '||p_segment_rule_type_code , 20
245: );
246: xla_utility_pkg.trace('segment_rule_code = '||p_segment_rule_code , 20);
247:
248: OPEN c_seg_rule;
249: FETCH c_seg_rule
250: INTO p_application_name, p_segment_rule_name, p_segment_rule_type;

Line 253: xla_utility_pkg.trace('< xla_validations_pkg.get_segment_rule_info' , 10);

249: FETCH c_seg_rule
250: INTO p_application_name, p_segment_rule_name, p_segment_rule_type;
251: CLOSE c_seg_rule;
252:
253: xla_utility_pkg.trace('< xla_validations_pkg.get_segment_rule_info' , 10);
254:
255: EXCEPTION
256: WHEN xla_exceptions_pkg.application_exception THEN
257: RAISE;

Line 308: xla_utility_pkg.trace('> xla_validations_pkg.get_line_type_info' , 10);

304: AND xal.accounting_line_code = p_accounting_line_code
305: AND xal.language = USERENV('LANG');
306:
307: BEGIN
308: xla_utility_pkg.trace('> xla_validations_pkg.get_line_type_info' , 10);
309:
310: xla_utility_pkg.trace('Application_id = '||p_application_id , 20);
311: xla_utility_pkg.trace('entity_code = '||p_entity_code , 20);
312: xla_utility_pkg.trace('event_class_code = '||p_event_class_code , 20);

Line 310: xla_utility_pkg.trace('Application_id = '||p_application_id , 20);

306:
307: BEGIN
308: xla_utility_pkg.trace('> xla_validations_pkg.get_line_type_info' , 10);
309:
310: xla_utility_pkg.trace('Application_id = '||p_application_id , 20);
311: xla_utility_pkg.trace('entity_code = '||p_entity_code , 20);
312: xla_utility_pkg.trace('event_class_code = '||p_event_class_code , 20);
313: xla_utility_pkg.trace('accounting_line_type_code = '||p_accounting_line_type_code , 20
314: );

Line 311: xla_utility_pkg.trace('entity_code = '||p_entity_code , 20);

307: BEGIN
308: xla_utility_pkg.trace('> xla_validations_pkg.get_line_type_info' , 10);
309:
310: xla_utility_pkg.trace('Application_id = '||p_application_id , 20);
311: xla_utility_pkg.trace('entity_code = '||p_entity_code , 20);
312: xla_utility_pkg.trace('event_class_code = '||p_event_class_code , 20);
313: xla_utility_pkg.trace('accounting_line_type_code = '||p_accounting_line_type_code , 20
314: );
315: xla_utility_pkg.trace('accounting_line_code = '||p_accounting_line_code , 20);

Line 312: xla_utility_pkg.trace('event_class_code = '||p_event_class_code , 20);

308: xla_utility_pkg.trace('> xla_validations_pkg.get_line_type_info' , 10);
309:
310: xla_utility_pkg.trace('Application_id = '||p_application_id , 20);
311: xla_utility_pkg.trace('entity_code = '||p_entity_code , 20);
312: xla_utility_pkg.trace('event_class_code = '||p_event_class_code , 20);
313: xla_utility_pkg.trace('accounting_line_type_code = '||p_accounting_line_type_code , 20
314: );
315: xla_utility_pkg.trace('accounting_line_code = '||p_accounting_line_code , 20);
316:

Line 313: xla_utility_pkg.trace('accounting_line_type_code = '||p_accounting_line_type_code , 20

309:
310: xla_utility_pkg.trace('Application_id = '||p_application_id , 20);
311: xla_utility_pkg.trace('entity_code = '||p_entity_code , 20);
312: xla_utility_pkg.trace('event_class_code = '||p_event_class_code , 20);
313: xla_utility_pkg.trace('accounting_line_type_code = '||p_accounting_line_type_code , 20
314: );
315: xla_utility_pkg.trace('accounting_line_code = '||p_accounting_line_code , 20);
316:
317: OPEN c_line_type;

Line 315: xla_utility_pkg.trace('accounting_line_code = '||p_accounting_line_code , 20);

311: xla_utility_pkg.trace('entity_code = '||p_entity_code , 20);
312: xla_utility_pkg.trace('event_class_code = '||p_event_class_code , 20);
313: xla_utility_pkg.trace('accounting_line_type_code = '||p_accounting_line_type_code , 20
314: );
315: xla_utility_pkg.trace('accounting_line_code = '||p_accounting_line_code , 20);
316:
317: OPEN c_line_type;
318: FETCH c_line_type
319: INTO p_application_name, p_accounting_line_type_name, p_accounting_line_type;

Line 322: xla_utility_pkg.trace('< xla_validations_pkg.get_line_type_info' , 10);

318: FETCH c_line_type
319: INTO p_application_name, p_accounting_line_type_name, p_accounting_line_type;
320: CLOSE c_line_type;
321:
322: xla_utility_pkg.trace('< xla_validations_pkg.get_line_type_info' , 10);
323:
324: EXCEPTION
325: WHEN xla_exceptions_pkg.application_exception THEN
326: RAISE;

Line 363: xla_utility_pkg.trace('> xla_validations_pkg.get_event_class_info' , 10);

359: AND event_class_code = p_event_class_code
360: AND language = USERENV('LANG');
361:
362: BEGIN
363: xla_utility_pkg.trace('> xla_validations_pkg.get_event_class_info' , 10);
364:
365: xla_utility_pkg.trace('Application_id = '||p_application_id , 20);
366: xla_utility_pkg.trace('entity_code = '||p_entity_code , 20);
367: xla_utility_pkg.trace('event_class_code = '||p_event_class_code , 20);

Line 365: xla_utility_pkg.trace('Application_id = '||p_application_id , 20);

361:
362: BEGIN
363: xla_utility_pkg.trace('> xla_validations_pkg.get_event_class_info' , 10);
364:
365: xla_utility_pkg.trace('Application_id = '||p_application_id , 20);
366: xla_utility_pkg.trace('entity_code = '||p_entity_code , 20);
367: xla_utility_pkg.trace('event_class_code = '||p_event_class_code , 20);
368:
369: OPEN c_event_class;

Line 366: xla_utility_pkg.trace('entity_code = '||p_entity_code , 20);

362: BEGIN
363: xla_utility_pkg.trace('> xla_validations_pkg.get_event_class_info' , 10);
364:
365: xla_utility_pkg.trace('Application_id = '||p_application_id , 20);
366: xla_utility_pkg.trace('entity_code = '||p_entity_code , 20);
367: xla_utility_pkg.trace('event_class_code = '||p_event_class_code , 20);
368:
369: OPEN c_event_class;
370: FETCH c_event_class

Line 367: xla_utility_pkg.trace('event_class_code = '||p_event_class_code , 20);

363: xla_utility_pkg.trace('> xla_validations_pkg.get_event_class_info' , 10);
364:
365: xla_utility_pkg.trace('Application_id = '||p_application_id , 20);
366: xla_utility_pkg.trace('entity_code = '||p_entity_code , 20);
367: xla_utility_pkg.trace('event_class_code = '||p_event_class_code , 20);
368:
369: OPEN c_event_class;
370: FETCH c_event_class
371: INTO p_event_class_name;

Line 374: xla_utility_pkg.trace('< xla_validations_pkg.get_event_class_info' , 10);

370: FETCH c_event_class
371: INTO p_event_class_name;
372: CLOSE c_event_class;
373:
374: xla_utility_pkg.trace('< xla_validations_pkg.get_event_class_info' , 10);
375:
376: EXCEPTION
377: WHEN xla_exceptions_pkg.application_exception THEN
378: RAISE;

Line 417: xla_utility_pkg.trace('> xla_validations_pkg.get_event_type_info' , 10);

413: AND event_type_code = p_event_type_code
414: AND language = USERENV('LANG');
415:
416: BEGIN
417: xla_utility_pkg.trace('> xla_validations_pkg.get_event_type_info' , 10);
418:
419: xla_utility_pkg.trace('Application_id = '||p_application_id , 20);
420: xla_utility_pkg.trace('entity_code = '||p_entity_code , 20);
421: xla_utility_pkg.trace('event_class_code = '||p_event_class_code , 20);

Line 419: xla_utility_pkg.trace('Application_id = '||p_application_id , 20);

415:
416: BEGIN
417: xla_utility_pkg.trace('> xla_validations_pkg.get_event_type_info' , 10);
418:
419: xla_utility_pkg.trace('Application_id = '||p_application_id , 20);
420: xla_utility_pkg.trace('entity_code = '||p_entity_code , 20);
421: xla_utility_pkg.trace('event_class_code = '||p_event_class_code , 20);
422: xla_utility_pkg.trace('event_type_code = '||p_event_type_code , 20);
423:

Line 420: xla_utility_pkg.trace('entity_code = '||p_entity_code , 20);

416: BEGIN
417: xla_utility_pkg.trace('> xla_validations_pkg.get_event_type_info' , 10);
418:
419: xla_utility_pkg.trace('Application_id = '||p_application_id , 20);
420: xla_utility_pkg.trace('entity_code = '||p_entity_code , 20);
421: xla_utility_pkg.trace('event_class_code = '||p_event_class_code , 20);
422: xla_utility_pkg.trace('event_type_code = '||p_event_type_code , 20);
423:
424: OPEN c_event_type;

Line 421: xla_utility_pkg.trace('event_class_code = '||p_event_class_code , 20);

417: xla_utility_pkg.trace('> xla_validations_pkg.get_event_type_info' , 10);
418:
419: xla_utility_pkg.trace('Application_id = '||p_application_id , 20);
420: xla_utility_pkg.trace('entity_code = '||p_entity_code , 20);
421: xla_utility_pkg.trace('event_class_code = '||p_event_class_code , 20);
422: xla_utility_pkg.trace('event_type_code = '||p_event_type_code , 20);
423:
424: OPEN c_event_type;
425: FETCH c_event_type

Line 422: xla_utility_pkg.trace('event_type_code = '||p_event_type_code , 20);

418:
419: xla_utility_pkg.trace('Application_id = '||p_application_id , 20);
420: xla_utility_pkg.trace('entity_code = '||p_entity_code , 20);
421: xla_utility_pkg.trace('event_class_code = '||p_event_class_code , 20);
422: xla_utility_pkg.trace('event_type_code = '||p_event_type_code , 20);
423:
424: OPEN c_event_type;
425: FETCH c_event_type
426: INTO p_event_type_name;

Line 429: xla_utility_pkg.trace('< xla_validations_pkg.get_event_type_info' , 10);

425: FETCH c_event_type
426: INTO p_event_type_name;
427: CLOSE c_event_type;
428:
429: xla_utility_pkg.trace('< xla_validations_pkg.get_event_type_info' , 10);
430:
431: EXCEPTION
432: WHEN xla_exceptions_pkg.application_exception THEN
433: RAISE;

Line 473: xla_utility_pkg.trace('> xla_validations_pkg.get_source_info' , 10);

469: AND s.source_type_code = l.lookup_code
470: AND l.lookup_type = 'XLA_SOURCE_TYPE';
471:
472: BEGIN
473: xla_utility_pkg.trace('> xla_validations_pkg.get_source_info' , 10);
474:
475: xla_utility_pkg.trace('Application_id = '||p_application_id , 20);
476: xla_utility_pkg.trace('source_code = '||p_source_code , 20);
477: xla_utility_pkg.trace('source_type_code = '||p_source_type_code , 20);

Line 475: xla_utility_pkg.trace('Application_id = '||p_application_id , 20);

471:
472: BEGIN
473: xla_utility_pkg.trace('> xla_validations_pkg.get_source_info' , 10);
474:
475: xla_utility_pkg.trace('Application_id = '||p_application_id , 20);
476: xla_utility_pkg.trace('source_code = '||p_source_code , 20);
477: xla_utility_pkg.trace('source_type_code = '||p_source_type_code , 20);
478:
479: OPEN c_source;

Line 476: xla_utility_pkg.trace('source_code = '||p_source_code , 20);

472: BEGIN
473: xla_utility_pkg.trace('> xla_validations_pkg.get_source_info' , 10);
474:
475: xla_utility_pkg.trace('Application_id = '||p_application_id , 20);
476: xla_utility_pkg.trace('source_code = '||p_source_code , 20);
477: xla_utility_pkg.trace('source_type_code = '||p_source_type_code , 20);
478:
479: OPEN c_source;
480: FETCH c_source

Line 477: xla_utility_pkg.trace('source_type_code = '||p_source_type_code , 20);

473: xla_utility_pkg.trace('> xla_validations_pkg.get_source_info' , 10);
474:
475: xla_utility_pkg.trace('Application_id = '||p_application_id , 20);
476: xla_utility_pkg.trace('source_code = '||p_source_code , 20);
477: xla_utility_pkg.trace('source_type_code = '||p_source_type_code , 20);
478:
479: OPEN c_source;
480: FETCH c_source
481: INTO p_source_name, p_source_type;

Line 484: xla_utility_pkg.trace('< xla_validations_pkg.get_source_info' , 10);

480: FETCH c_source
481: INTO p_source_name, p_source_type;
482: CLOSE c_source;
483:
484: xla_utility_pkg.trace('< xla_validations_pkg.get_source_info' , 10);
485:
486: EXCEPTION
487: WHEN xla_exceptions_pkg.application_exception THEN
488: RAISE;

Line 527: xla_utility_pkg.trace('> xla_validations_pkg.get_analytical_criteria_info' , 10);

523: AND s.analytical_criterion_type_code = l.lookup_code
524: AND l.lookup_type = 'XLA_OWNER_TYPE';
525:
526: BEGIN
527: xla_utility_pkg.trace('> xla_validations_pkg.get_analytical_criteria_info' , 10);
528:
529: xla_utility_pkg.trace('analytical_criteria_code = '||p_analytical_criterion_code , 20);
530: xla_utility_pkg.trace('anal_criteria_type_code = '||p_anal_criterion_type_code , 20);
531:

Line 529: xla_utility_pkg.trace('analytical_criteria_code = '||p_analytical_criterion_code , 20);

525:
526: BEGIN
527: xla_utility_pkg.trace('> xla_validations_pkg.get_analytical_criteria_info' , 10);
528:
529: xla_utility_pkg.trace('analytical_criteria_code = '||p_analytical_criterion_code , 20);
530: xla_utility_pkg.trace('anal_criteria_type_code = '||p_anal_criterion_type_code , 20);
531:
532: OPEN c_anc;
533: FETCH c_anc

Line 530: xla_utility_pkg.trace('anal_criteria_type_code = '||p_anal_criterion_type_code , 20);

526: BEGIN
527: xla_utility_pkg.trace('> xla_validations_pkg.get_analytical_criteria_info' , 10);
528:
529: xla_utility_pkg.trace('analytical_criteria_code = '||p_analytical_criterion_code , 20);
530: xla_utility_pkg.trace('anal_criteria_type_code = '||p_anal_criterion_type_code , 20);
531:
532: OPEN c_anc;
533: FETCH c_anc
534: INTO p_analytical_criteria_name, p_analytical_criteria_type;

Line 537: xla_utility_pkg.trace('< xla_validations_pkg.get_analytical_criteria_info' , 10);

533: FETCH c_anc
534: INTO p_analytical_criteria_name, p_analytical_criteria_type;
535: CLOSE c_anc;
536:
537: xla_utility_pkg.trace('< xla_validations_pkg.get_analytical_criteria_info' , 10);
538:
539: EXCEPTION
540: WHEN xla_exceptions_pkg.application_exception THEN
541: RAISE;

Line 580: xla_utility_pkg.trace('> xla_validations_pkg.get_accounting_method_info' , 10);

576: AND xam.accounting_method_code = p_accounting_method_code
577: AND xam.language = USERENV('LANG');
578:
579: BEGIN
580: xla_utility_pkg.trace('> xla_validations_pkg.get_accounting_method_info' , 10);
581:
582: xla_utility_pkg.trace('accounting_method_type_code = '||p_accounting_method_type_code , 20);
583: xla_utility_pkg.trace('accounting_method_code = '||p_accounting_method_code , 20);
584:

Line 582: xla_utility_pkg.trace('accounting_method_type_code = '||p_accounting_method_type_code , 20);

578:
579: BEGIN
580: xla_utility_pkg.trace('> xla_validations_pkg.get_accounting_method_info' , 10);
581:
582: xla_utility_pkg.trace('accounting_method_type_code = '||p_accounting_method_type_code , 20);
583: xla_utility_pkg.trace('accounting_method_code = '||p_accounting_method_code , 20);
584:
585: OPEN c_anc;
586: FETCH c_anc

Line 583: xla_utility_pkg.trace('accounting_method_code = '||p_accounting_method_code , 20);

579: BEGIN
580: xla_utility_pkg.trace('> xla_validations_pkg.get_accounting_method_info' , 10);
581:
582: xla_utility_pkg.trace('accounting_method_type_code = '||p_accounting_method_type_code , 20);
583: xla_utility_pkg.trace('accounting_method_code = '||p_accounting_method_code , 20);
584:
585: OPEN c_anc;
586: FETCH c_anc
587: INTO p_accounting_method_name, p_accounting_method_type;

Line 590: xla_utility_pkg.trace('< xla_validations_pkg.get_accounting_method_info' , 10);

586: FETCH c_anc
587: INTO p_accounting_method_name, p_accounting_method_type;
588: CLOSE c_anc;
589:
590: xla_utility_pkg.trace('< xla_validations_pkg.get_accounting_method_info' , 10);
591:
592: EXCEPTION
593: WHEN xla_exceptions_pkg.application_exception THEN
594: RAISE;

Line 627: xla_utility_pkg.trace('> xla_validations_pkg.get_application_name' , 10);

623: WHERE application_id = p_application_id
624: AND language = USERENV('LANG');
625:
626: BEGIN
627: xla_utility_pkg.trace('> xla_validations_pkg.get_application_name' , 10);
628:
629: xla_utility_pkg.trace('application_id = '||p_application_id , 20);
630:
631: OPEN c_application;

Line 629: xla_utility_pkg.trace('application_id = '||p_application_id , 20);

625:
626: BEGIN
627: xla_utility_pkg.trace('> xla_validations_pkg.get_application_name' , 10);
628:
629: xla_utility_pkg.trace('application_id = '||p_application_id , 20);
630:
631: OPEN c_application;
632: FETCH c_application
633: INTO p_application_name;

Line 636: xla_utility_pkg.trace('< xla_validations_pkg.get_application_name' , 10);

632: FETCH c_application
633: INTO p_application_name;
634: CLOSE c_application;
635:
636: xla_utility_pkg.trace('< xla_validations_pkg.get_application_name' , 10);
637:
638: EXCEPTION
639: WHEN xla_exceptions_pkg.application_exception THEN
640: RAISE;

Line 672: xla_utility_pkg.trace('> xla_validations_pkg.get_ledger_name' , 10);

668: FROM gl_ledgers
669: WHERE ledger_id = p_ledger_id;
670:
671: BEGIN
672: xla_utility_pkg.trace('> xla_validations_pkg.get_ledger_name' , 10);
673:
674: xla_utility_pkg.trace('ledger_id = '||p_ledger_id , 20);
675:
676: OPEN c_ledger;

Line 674: xla_utility_pkg.trace('ledger_id = '||p_ledger_id , 20);

670:
671: BEGIN
672: xla_utility_pkg.trace('> xla_validations_pkg.get_ledger_name' , 10);
673:
674: xla_utility_pkg.trace('ledger_id = '||p_ledger_id , 20);
675:
676: OPEN c_ledger;
677: FETCH c_ledger
678: INTO p_ledger_name;

Line 681: xla_utility_pkg.trace('< xla_validations_pkg.get_ledger_name' , 10);

677: FETCH c_ledger
678: INTO p_ledger_name;
679: CLOSE c_ledger;
680:
681: xla_utility_pkg.trace('< xla_validations_pkg.get_ledger_name' , 10);
682:
683: EXCEPTION
684: WHEN xla_exceptions_pkg.application_exception THEN
685: RAISE;

Line 729: xla_utility_pkg.trace('> xla_validations_pkg.get_trx_acct_def_info' , 10);

725: AND l.lookup_type = 'XLA_OWNER_TYPE';
726:
727: BEGIN
728:
729: xla_utility_pkg.trace('> xla_validations_pkg.get_trx_acct_def_info' , 10);
730:
731: xla_utility_pkg.trace('Application_id = '||p_application_id , 20);
732: xla_utility_pkg.trace('account_definition_type_code = '||p_account_definition_type_code , 20);
733: xla_utility_pkg.trace('account_definition_code = '||p_account_definition_code , 20);

Line 731: xla_utility_pkg.trace('Application_id = '||p_application_id , 20);

727: BEGIN
728:
729: xla_utility_pkg.trace('> xla_validations_pkg.get_trx_acct_def_info' , 10);
730:
731: xla_utility_pkg.trace('Application_id = '||p_application_id , 20);
732: xla_utility_pkg.trace('account_definition_type_code = '||p_account_definition_type_code , 20);
733: xla_utility_pkg.trace('account_definition_code = '||p_account_definition_code , 20);
734:
735: OPEN c_prod_rule;

Line 732: xla_utility_pkg.trace('account_definition_type_code = '||p_account_definition_type_code , 20);

728:
729: xla_utility_pkg.trace('> xla_validations_pkg.get_trx_acct_def_info' , 10);
730:
731: xla_utility_pkg.trace('Application_id = '||p_application_id , 20);
732: xla_utility_pkg.trace('account_definition_type_code = '||p_account_definition_type_code , 20);
733: xla_utility_pkg.trace('account_definition_code = '||p_account_definition_code , 20);
734:
735: OPEN c_prod_rule;
736: FETCH c_prod_rule

Line 733: xla_utility_pkg.trace('account_definition_code = '||p_account_definition_code , 20);

729: xla_utility_pkg.trace('> xla_validations_pkg.get_trx_acct_def_info' , 10);
730:
731: xla_utility_pkg.trace('Application_id = '||p_application_id , 20);
732: xla_utility_pkg.trace('account_definition_type_code = '||p_account_definition_type_code , 20);
733: xla_utility_pkg.trace('account_definition_code = '||p_account_definition_code , 20);
734:
735: OPEN c_prod_rule;
736: FETCH c_prod_rule
737: INTO p_application_name, p_trx_acct_def, p_trx_acct_def_type;

Line 740: xla_utility_pkg.trace('< xla_validations_pkg.get_trx_acct_def_info' , 10);

736: FETCH c_prod_rule
737: INTO p_application_name, p_trx_acct_def, p_trx_acct_def_type;
738: CLOSE c_prod_rule;
739:
740: xla_utility_pkg.trace('< xla_validations_pkg.get_trx_acct_def_info' , 10);
741:
742: EXCEPTION
743: WHEN xla_exceptions_pkg.application_exception THEN
744: RAISE;

Line 778: xla_utility_pkg.trace('> xla_validations_pkg.get_trx_acct_type_info' , 10);

774: WHERE application_id = p_application_id
775: AND account_type_code = p_account_type_code;
776:
777: BEGIN
778: xla_utility_pkg.trace('> xla_validations_pkg.get_trx_acct_type_info' , 10);
779: xla_utility_pkg.trace('Application_id = '||p_application_id , 20);
780: xla_utility_pkg.trace('account_type_code = '||p_account_type_code , 20);
781:
782: OPEN c_type;

Line 779: xla_utility_pkg.trace('Application_id = '||p_application_id , 20);

775: AND account_type_code = p_account_type_code;
776:
777: BEGIN
778: xla_utility_pkg.trace('> xla_validations_pkg.get_trx_acct_type_info' , 10);
779: xla_utility_pkg.trace('Application_id = '||p_application_id , 20);
780: xla_utility_pkg.trace('account_type_code = '||p_account_type_code , 20);
781:
782: OPEN c_type;
783: FETCH c_type

Line 780: xla_utility_pkg.trace('account_type_code = '||p_account_type_code , 20);

776:
777: BEGIN
778: xla_utility_pkg.trace('> xla_validations_pkg.get_trx_acct_type_info' , 10);
779: xla_utility_pkg.trace('Application_id = '||p_application_id , 20);
780: xla_utility_pkg.trace('account_type_code = '||p_account_type_code , 20);
781:
782: OPEN c_type;
783: FETCH c_type
784: INTO p_trx_acct_type;

Line 787: xla_utility_pkg.trace('< xla_validations_pkg.get_trx_acct_type_info' , 10);

783: FETCH c_type
784: INTO p_trx_acct_type;
785: CLOSE c_type;
786:
787: xla_utility_pkg.trace('< xla_validations_pkg.get_trx_acct_type_info' , 10);
788:
789: EXCEPTION
790: WHEN xla_exceptions_pkg.application_exception THEN
791: RAISE;

Line 827: xla_utility_pkg.trace('> xla_validations_pkg.table_name_is_valid' , 10);

823: FROM user_objects o
824: WHERE o.object_name = p_table_name;
825:
826: BEGIN
827: xla_utility_pkg.trace('> xla_validations_pkg.table_name_is_valid' , 10);
828:
829: xla_utility_pkg.trace('Table Name = '||p_table_name , 20);
830:
831: OPEN c_user_objects;

Line 829: xla_utility_pkg.trace('Table Name = '||p_table_name , 20);

825:
826: BEGIN
827: xla_utility_pkg.trace('> xla_validations_pkg.table_name_is_valid' , 10);
828:
829: xla_utility_pkg.trace('Table Name = '||p_table_name , 20);
830:
831: OPEN c_user_objects;
832: FETCH c_user_objects
833: INTO l_exist;

Line 841: xla_utility_pkg.trace('< xla_validations_pkg.table_name_is_valid' , 10);

837: l_return := FALSE;
838: END IF;
839: CLOSE c_user_objects;
840:
841: xla_utility_pkg.trace('< xla_validations_pkg.table_name_is_valid' , 10);
842:
843: RETURN l_return;
844:
845: EXCEPTION

Line 929: xla_utility_pkg.trace('> xla_validations_pkg.join_condition_is_valid' , 10);

925: l_return BOOLEAN;
926:
927: BEGIN
928:
929: xla_utility_pkg.trace('> xla_validations_pkg.join_condition_is_valid' , 10);
930:
931: BEGIN
932:
933: l_sql := 'SELECT 1 FROM '

Line 943: xla_utility_pkg.trace('SQL = '||l_sql , 20);

939: || ' AND 1 = 2';
940:
941: EXECUTE IMMEDIATE l_sql INTO l_dummy;
942:
943: xla_utility_pkg.trace('SQL = '||l_sql , 20);
944:
945: EXCEPTION
946: WHEN no_data_found THEN
947: l_return := TRUE;

Line 953: xla_utility_pkg.trace('< xla_validations_pkg.join_condition_is_valid' , 10);

949: l_return := FALSE;
950: p_error_message := SQLERRM;
951: END;
952:
953: xla_utility_pkg.trace('< xla_validations_pkg.join_condition_is_valid' , 10);
954:
955: RETURN l_return;
956:
957: EXCEPTION