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

Line 60: xla_utility_pkg.trace('> xla_flex_pkg.get_value_set_name' , 20);

56:
57: IS
58:
59: BEGIN
60: xla_utility_pkg.trace('> xla_flex_pkg.get_value_set_name' , 20);
61:
62: xla_utility_pkg.trace('Value set id = '||p_flex_value_set_id , 40);
63:
64: IF p_flex_value_set_id = g_flex_value_set_id THEN

Line 62: xla_utility_pkg.trace('Value set id = '||p_flex_value_set_id , 40);

58:
59: BEGIN
60: xla_utility_pkg.trace('> xla_flex_pkg.get_value_set_name' , 20);
61:
62: xla_utility_pkg.trace('Value set id = '||p_flex_value_set_id , 40);
63:
64: IF p_flex_value_set_id = g_flex_value_set_id THEN
65:
66: NULL;

Line 79: xla_utility_pkg.trace('Value set name = '||g_flex_value_set_name , 40);

75:
76: g_flex_value_set_id := p_flex_value_set_id;
77: END IF;
78:
79: xla_utility_pkg.trace('Value set name = '||g_flex_value_set_name , 40);
80:
81: xla_utility_pkg.trace('< xla_flex_pkg.get_value_set_name' , 20);
82:
83: RETURN g_flex_value_set_name;

Line 81: xla_utility_pkg.trace('< xla_flex_pkg.get_value_set_name' , 20);

77: END IF;
78:
79: xla_utility_pkg.trace('Value set name = '||g_flex_value_set_name , 40);
80:
81: xla_utility_pkg.trace('< xla_flex_pkg.get_value_set_name' , 20);
82:
83: RETURN g_flex_value_set_name;
84:
85: EXCEPTION

Line 113: xla_utility_pkg.trace('> xla_flex_pkg.get_chart_of_accounts_name' , 20);

109:
110: l_chart_of_accounts_name VARCHAR2(80);
111:
112: BEGIN
113: xla_utility_pkg.trace('> xla_flex_pkg.get_chart_of_accounts_name' , 20);
114:
115: xla_utility_pkg.trace('Application id = '||p_application_id , 40);
116: xla_utility_pkg.trace('Flex code = '||p_flex_code , 40);
117: xla_utility_pkg.trace('Chart of accounts id = '||p_chart_of_accounts_id , 40);

Line 115: xla_utility_pkg.trace('Application id = '||p_application_id , 40);

111:
112: BEGIN
113: xla_utility_pkg.trace('> xla_flex_pkg.get_chart_of_accounts_name' , 20);
114:
115: xla_utility_pkg.trace('Application id = '||p_application_id , 40);
116: xla_utility_pkg.trace('Flex code = '||p_flex_code , 40);
117: xla_utility_pkg.trace('Chart of accounts id = '||p_chart_of_accounts_id , 40);
118:
119: IF (p_application_id = g_coa_application_id

Line 116: xla_utility_pkg.trace('Flex code = '||p_flex_code , 40);

112: BEGIN
113: xla_utility_pkg.trace('> xla_flex_pkg.get_chart_of_accounts_name' , 20);
114:
115: xla_utility_pkg.trace('Application id = '||p_application_id , 40);
116: xla_utility_pkg.trace('Flex code = '||p_flex_code , 40);
117: xla_utility_pkg.trace('Chart of accounts id = '||p_chart_of_accounts_id , 40);
118:
119: IF (p_application_id = g_coa_application_id
120: AND p_flex_code = g_coa_flex_code

Line 117: xla_utility_pkg.trace('Chart of accounts id = '||p_chart_of_accounts_id , 40);

113: xla_utility_pkg.trace('> xla_flex_pkg.get_chart_of_accounts_name' , 20);
114:
115: xla_utility_pkg.trace('Application id = '||p_application_id , 40);
116: xla_utility_pkg.trace('Flex code = '||p_flex_code , 40);
117: xla_utility_pkg.trace('Chart of accounts id = '||p_chart_of_accounts_id , 40);
118:
119: IF (p_application_id = g_coa_application_id
120: AND p_flex_code = g_coa_flex_code
121: AND p_chart_of_accounts_id = g_coa_id) THEN

Line 140: xla_utility_pkg.trace('Chart of accounts name = '||g_coa_name , 40);

136: g_coa_flex_code := p_flex_code;
137: g_coa_id := p_chart_of_accounts_id;
138: END IF;
139:
140: xla_utility_pkg.trace('Chart of accounts name = '||g_coa_name , 40);
141:
142: xla_utility_pkg.trace('< xla_flex_pkg.get_chart_of_accounts_name' , 20);
143:
144: RETURN g_coa_name;

Line 142: xla_utility_pkg.trace('< xla_flex_pkg.get_chart_of_accounts_name' , 20);

138: END IF;
139:
140: xla_utility_pkg.trace('Chart of accounts name = '||g_coa_name , 40);
141:
142: xla_utility_pkg.trace('< xla_flex_pkg.get_chart_of_accounts_name' , 20);
143:
144: RETURN g_coa_name;
145:
146: EXCEPTION

Line 187: xla_utility_pkg.trace('> xla_flex_pkg.get_flexfield_segment_name' , 20);

183: ;
184:
185: BEGIN
186:
187: xla_utility_pkg.trace('> xla_flex_pkg.get_flexfield_segment_name' , 20);
188:
189: xla_utility_pkg.trace('Application id = '||p_application_id , 40);
190: xla_utility_pkg.trace('Flex code = '||p_flex_code , 40);
191: xla_utility_pkg.trace('Chart of accounts id = '||p_chart_of_accounts_id , 40);

Line 189: xla_utility_pkg.trace('Application id = '||p_application_id , 40);

185: BEGIN
186:
187: xla_utility_pkg.trace('> xla_flex_pkg.get_flexfield_segment_name' , 20);
188:
189: xla_utility_pkg.trace('Application id = '||p_application_id , 40);
190: xla_utility_pkg.trace('Flex code = '||p_flex_code , 40);
191: xla_utility_pkg.trace('Chart of accounts id = '||p_chart_of_accounts_id , 40);
192: xla_utility_pkg.trace('Flexfield Segment Code = '||p_flexfield_segment_code , 40);
193:

Line 190: xla_utility_pkg.trace('Flex code = '||p_flex_code , 40);

186:
187: xla_utility_pkg.trace('> xla_flex_pkg.get_flexfield_segment_name' , 20);
188:
189: xla_utility_pkg.trace('Application id = '||p_application_id , 40);
190: xla_utility_pkg.trace('Flex code = '||p_flex_code , 40);
191: xla_utility_pkg.trace('Chart of accounts id = '||p_chart_of_accounts_id , 40);
192: xla_utility_pkg.trace('Flexfield Segment Code = '||p_flexfield_segment_code , 40);
193:
194: OPEN c_segment_name;

Line 191: xla_utility_pkg.trace('Chart of accounts id = '||p_chart_of_accounts_id , 40);

187: xla_utility_pkg.trace('> xla_flex_pkg.get_flexfield_segment_name' , 20);
188:
189: xla_utility_pkg.trace('Application id = '||p_application_id , 40);
190: xla_utility_pkg.trace('Flex code = '||p_flex_code , 40);
191: xla_utility_pkg.trace('Chart of accounts id = '||p_chart_of_accounts_id , 40);
192: xla_utility_pkg.trace('Flexfield Segment Code = '||p_flexfield_segment_code , 40);
193:
194: OPEN c_segment_name;
195:

Line 192: xla_utility_pkg.trace('Flexfield Segment Code = '||p_flexfield_segment_code , 40);

188:
189: xla_utility_pkg.trace('Application id = '||p_application_id , 40);
190: xla_utility_pkg.trace('Flex code = '||p_flex_code , 40);
191: xla_utility_pkg.trace('Chart of accounts id = '||p_chart_of_accounts_id , 40);
192: xla_utility_pkg.trace('Flexfield Segment Code = '||p_flexfield_segment_code , 40);
193:
194: OPEN c_segment_name;
195:
196: FETCH c_segment_name

Line 201: xla_utility_pkg.trace('Segment name = '||l_flexfield_segment_name , 40);

197: INTO l_flexfield_segment_name;
198:
199: CLOSE c_segment_name;
200:
201: xla_utility_pkg.trace('Segment name = '||l_flexfield_segment_name , 40);
202:
203: xla_utility_pkg.trace('< xla_flex_pkg.get_flexfield_segment_name' , 20);
204:
205: RETURN l_flexfield_segment_name;

Line 203: xla_utility_pkg.trace('< xla_flex_pkg.get_flexfield_segment_name' , 20);

199: CLOSE c_segment_name;
200:
201: xla_utility_pkg.trace('Segment name = '||l_flexfield_segment_name , 40);
202:
203: xla_utility_pkg.trace('< xla_flex_pkg.get_flexfield_segment_name' , 20);
204:
205: RETURN l_flexfield_segment_name;
206:
207: EXCEPTION

Line 245: xla_utility_pkg.trace('> xla_flex_pkg.get_flex_value_meaning' , 20);

241: l_additional_where_clause VARCHAR2(4000);
242: l_number NUMBER;
243:
244: BEGIN
245: xla_utility_pkg.trace('> xla_flex_pkg.get_flex_value_meaning' , 20);
246:
247: xla_utility_pkg.trace('Flex_value_set_id = '||p_flex_value_set_id , 40);
248: xla_utility_pkg.trace('Flex_value = '||p_flex_value , 40);
249:

Line 247: xla_utility_pkg.trace('Flex_value_set_id = '||p_flex_value_set_id , 40);

243:
244: BEGIN
245: xla_utility_pkg.trace('> xla_flex_pkg.get_flex_value_meaning' , 20);
246:
247: xla_utility_pkg.trace('Flex_value_set_id = '||p_flex_value_set_id , 40);
248: xla_utility_pkg.trace('Flex_value = '||p_flex_value , 40);
249:
250: IF (p_flex_value_set_id = g_meaning_flex_value_set_id
251: AND p_flex_value = g_meaning_flex_value) THEN

Line 248: xla_utility_pkg.trace('Flex_value = '||p_flex_value , 40);

244: BEGIN
245: xla_utility_pkg.trace('> xla_flex_pkg.get_flex_value_meaning' , 20);
246:
247: xla_utility_pkg.trace('Flex_value_set_id = '||p_flex_value_set_id , 40);
248: xla_utility_pkg.trace('Flex_value = '||p_flex_value , 40);
249:
250: IF (p_flex_value_set_id = g_meaning_flex_value_set_id
251: AND p_flex_value = g_meaning_flex_value) THEN
252:

Line 343: xla_utility_pkg.trace('Statement = '||l_statement , 50);

339:
340:
341: END IF;
342:
343: xla_utility_pkg.trace('Statement = '||l_statement , 50);
344:
345: --
346: -- Bug912223 with 8i
347: --

Line 369: xla_utility_pkg.trace('Flex_value_meaning = '||g_meaning_meaning , 40);

365: ,'LOCATION' ,'xla_flex_pkg.get_flex_value_meaning');
366: END IF;
367: END IF;
368:
369: xla_utility_pkg.trace('Flex_value_meaning = '||g_meaning_meaning , 40);
370:
371: xla_utility_pkg.trace('< xla_flex_pkg.get_flex_value_meaning' , 20);
372:
373: RETURN g_meaning_meaning;

Line 371: xla_utility_pkg.trace('< xla_flex_pkg.get_flex_value_meaning' , 20);

367: END IF;
368:
369: xla_utility_pkg.trace('Flex_value_meaning = '||g_meaning_meaning , 40);
370:
371: xla_utility_pkg.trace('< xla_flex_pkg.get_flex_value_meaning' , 20);
372:
373: RETURN g_meaning_meaning;
374:
375: EXCEPTION

Line 433: xla_utility_pkg.trace('> xla_flex_pkg.get_flexfield_segment_info' , 20);

429: ;
430:
431: BEGIN
432:
433: xla_utility_pkg.trace('> xla_flex_pkg.get_flexfield_segment_info' , 20);
434:
435: xla_utility_pkg.trace('Application id = '||p_application_id , 40);
436: xla_utility_pkg.trace('Flex code = '||p_flex_code , 40);
437: xla_utility_pkg.trace('Chart of accounts id = '||p_chart_of_accounts_id , 40);

Line 435: xla_utility_pkg.trace('Application id = '||p_application_id , 40);

431: BEGIN
432:
433: xla_utility_pkg.trace('> xla_flex_pkg.get_flexfield_segment_info' , 20);
434:
435: xla_utility_pkg.trace('Application id = '||p_application_id , 40);
436: xla_utility_pkg.trace('Flex code = '||p_flex_code , 40);
437: xla_utility_pkg.trace('Chart of accounts id = '||p_chart_of_accounts_id , 40);
438: xla_utility_pkg.trace('Flexfield Segment Code = '||p_flexfield_segment_code , 40);
439:

Line 436: xla_utility_pkg.trace('Flex code = '||p_flex_code , 40);

432:
433: xla_utility_pkg.trace('> xla_flex_pkg.get_flexfield_segment_info' , 20);
434:
435: xla_utility_pkg.trace('Application id = '||p_application_id , 40);
436: xla_utility_pkg.trace('Flex code = '||p_flex_code , 40);
437: xla_utility_pkg.trace('Chart of accounts id = '||p_chart_of_accounts_id , 40);
438: xla_utility_pkg.trace('Flexfield Segment Code = '||p_flexfield_segment_code , 40);
439:
440: OPEN c_segment_info;

Line 437: xla_utility_pkg.trace('Chart of accounts id = '||p_chart_of_accounts_id , 40);

433: xla_utility_pkg.trace('> xla_flex_pkg.get_flexfield_segment_info' , 20);
434:
435: xla_utility_pkg.trace('Application id = '||p_application_id , 40);
436: xla_utility_pkg.trace('Flex code = '||p_flex_code , 40);
437: xla_utility_pkg.trace('Chart of accounts id = '||p_chart_of_accounts_id , 40);
438: xla_utility_pkg.trace('Flexfield Segment Code = '||p_flexfield_segment_code , 40);
439:
440: OPEN c_segment_info;
441:

Line 438: xla_utility_pkg.trace('Flexfield Segment Code = '||p_flexfield_segment_code , 40);

434:
435: xla_utility_pkg.trace('Application id = '||p_application_id , 40);
436: xla_utility_pkg.trace('Flex code = '||p_flex_code , 40);
437: xla_utility_pkg.trace('Chart of accounts id = '||p_chart_of_accounts_id , 40);
438: xla_utility_pkg.trace('Flexfield Segment Code = '||p_flexfield_segment_code , 40);
439:
440: OPEN c_segment_info;
441:
442: FETCH c_segment_info

Line 455: xla_utility_pkg.trace('Segment name = '||p_flexfield_segment_name , 40);

451: INTO p_flexfield_segment_num;
452:
453: CLOSE c_segment_num;
454:
455: xla_utility_pkg.trace('Segment name = '||p_flexfield_segment_name , 40);
456: xla_utility_pkg.trace('Segment num = '||p_flexfield_segment_num , 40);
457:
458: xla_utility_pkg.trace('< xla_flex_pkg.get_flexfield_segment_info' , 20);
459:

Line 456: xla_utility_pkg.trace('Segment num = '||p_flexfield_segment_num , 40);

452:
453: CLOSE c_segment_num;
454:
455: xla_utility_pkg.trace('Segment name = '||p_flexfield_segment_name , 40);
456: xla_utility_pkg.trace('Segment num = '||p_flexfield_segment_num , 40);
457:
458: xla_utility_pkg.trace('< xla_flex_pkg.get_flexfield_segment_info' , 20);
459:
460: RETURN TRUE;

Line 458: xla_utility_pkg.trace('< xla_flex_pkg.get_flexfield_segment_info' , 20);

454:
455: xla_utility_pkg.trace('Segment name = '||p_flexfield_segment_name , 40);
456: xla_utility_pkg.trace('Segment num = '||p_flexfield_segment_num , 40);
457:
458: xla_utility_pkg.trace('< xla_flex_pkg.get_flexfield_segment_info' , 20);
459:
460: RETURN TRUE;
461:
462: EXCEPTION

Line 496: xla_utility_pkg.trace('> xla_flex_pkg.get_table_vset_select' , 20);

492:
493:
494: BEGIN
495:
496: xla_utility_pkg.trace('> xla_flex_pkg.get_table_vset_select' , 20);
497:
498: xla_utility_pkg.trace('flex_value_set_id = '||p_flex_value_set_id , 40);
499:
500: fnd_flex_val_api.get_table_vset_select

Line 498: xla_utility_pkg.trace('flex_value_set_id = '||p_flex_value_set_id , 40);

494: BEGIN
495:
496: xla_utility_pkg.trace('> xla_flex_pkg.get_table_vset_select' , 20);
497:
498: xla_utility_pkg.trace('flex_value_set_id = '||p_flex_value_set_id , 40);
499:
500: fnd_flex_val_api.get_table_vset_select
501: (p_value_set_id => p_flex_value_set_id
502: ,x_select => p_select

Line 507: xla_utility_pkg.trace('select = '||p_select , 40);

503: ,x_mapping_code => p_mapping_code
504: ,x_success => p_success);
505:
506:
507: xla_utility_pkg.trace('select = '||p_select , 40);
508: xla_utility_pkg.trace('mapping code = '||p_mapping_code , 40);
509: xla_utility_pkg.trace('success = '||p_success , 40);
510:
511: xla_utility_pkg.trace('< xla_flex_pkg.get_table_vset_select' , 20);

Line 508: xla_utility_pkg.trace('mapping code = '||p_mapping_code , 40);

504: ,x_success => p_success);
505:
506:
507: xla_utility_pkg.trace('select = '||p_select , 40);
508: xla_utility_pkg.trace('mapping code = '||p_mapping_code , 40);
509: xla_utility_pkg.trace('success = '||p_success , 40);
510:
511: xla_utility_pkg.trace('< xla_flex_pkg.get_table_vset_select' , 20);
512:

Line 509: xla_utility_pkg.trace('success = '||p_success , 40);

505:
506:
507: xla_utility_pkg.trace('select = '||p_select , 40);
508: xla_utility_pkg.trace('mapping code = '||p_mapping_code , 40);
509: xla_utility_pkg.trace('success = '||p_success , 40);
510:
511: xla_utility_pkg.trace('< xla_flex_pkg.get_table_vset_select' , 20);
512:
513: EXCEPTION

Line 511: xla_utility_pkg.trace('< xla_flex_pkg.get_table_vset_select' , 20);

507: xla_utility_pkg.trace('select = '||p_select , 40);
508: xla_utility_pkg.trace('mapping code = '||p_mapping_code , 40);
509: xla_utility_pkg.trace('success = '||p_success , 40);
510:
511: xla_utility_pkg.trace('< xla_flex_pkg.get_table_vset_select' , 20);
512:
513: EXCEPTION
514: WHEN xla_exceptions_pkg.application_exception THEN
515: RAISE;

Line 555: xla_utility_pkg.trace('> xla_flex_pkg.segment_qualifier_is_enabled' , 20);

551: ;
552:
553: BEGIN
554:
555: xla_utility_pkg.trace('> xla_flex_pkg.segment_qualifier_is_enabled' , 20);
556:
557: xla_utility_pkg.trace('Application id = '||p_application_id , 40);
558: xla_utility_pkg.trace('Flex code = '||p_flex_code , 40);
559: xla_utility_pkg.trace('Chart of accounts id = '||p_chart_of_accounts_id , 40);

Line 557: xla_utility_pkg.trace('Application id = '||p_application_id , 40);

553: BEGIN
554:
555: xla_utility_pkg.trace('> xla_flex_pkg.segment_qualifier_is_enabled' , 20);
556:
557: xla_utility_pkg.trace('Application id = '||p_application_id , 40);
558: xla_utility_pkg.trace('Flex code = '||p_flex_code , 40);
559: xla_utility_pkg.trace('Chart of accounts id = '||p_chart_of_accounts_id , 40);
560: xla_utility_pkg.trace('Flexfield segment code = '||p_flexfield_segment_code , 40);
561:

Line 558: xla_utility_pkg.trace('Flex code = '||p_flex_code , 40);

554:
555: xla_utility_pkg.trace('> xla_flex_pkg.segment_qualifier_is_enabled' , 20);
556:
557: xla_utility_pkg.trace('Application id = '||p_application_id , 40);
558: xla_utility_pkg.trace('Flex code = '||p_flex_code , 40);
559: xla_utility_pkg.trace('Chart of accounts id = '||p_chart_of_accounts_id , 40);
560: xla_utility_pkg.trace('Flexfield segment code = '||p_flexfield_segment_code , 40);
561:
562: IF p_flexfield_segment_code in ('GL_BALANCING','GL_ACCOUNT','GL_INTERCOMPANY',

Line 559: xla_utility_pkg.trace('Chart of accounts id = '||p_chart_of_accounts_id , 40);

555: xla_utility_pkg.trace('> xla_flex_pkg.segment_qualifier_is_enabled' , 20);
556:
557: xla_utility_pkg.trace('Application id = '||p_application_id , 40);
558: xla_utility_pkg.trace('Flex code = '||p_flex_code , 40);
559: xla_utility_pkg.trace('Chart of accounts id = '||p_chart_of_accounts_id , 40);
560: xla_utility_pkg.trace('Flexfield segment code = '||p_flexfield_segment_code , 40);
561:
562: IF p_flexfield_segment_code in ('GL_BALANCING','GL_ACCOUNT','GL_INTERCOMPANY',
563: 'GL_MANAGEMENT','FA_COST_CTR') THEN

Line 560: xla_utility_pkg.trace('Flexfield segment code = '||p_flexfield_segment_code , 40);

556:
557: xla_utility_pkg.trace('Application id = '||p_application_id , 40);
558: xla_utility_pkg.trace('Flex code = '||p_flex_code , 40);
559: xla_utility_pkg.trace('Chart of accounts id = '||p_chart_of_accounts_id , 40);
560: xla_utility_pkg.trace('Flexfield segment code = '||p_flexfield_segment_code , 40);
561:
562: IF p_flexfield_segment_code in ('GL_BALANCING','GL_ACCOUNT','GL_INTERCOMPANY',
563: 'GL_MANAGEMENT','FA_COST_CTR') THEN
564: OPEN c_qualifier;

Line 577: xla_utility_pkg.trace('< xla_flex_pkg.segment_qualifier_is_enabled' , 20);

573: ELSE
574: l_return := TRUE;
575: END IF;
576:
577: xla_utility_pkg.trace('< xla_flex_pkg.segment_qualifier_is_enabled' , 20);
578:
579: RETURN l_return;
580:
581: EXCEPTION

Line 613: xla_utility_pkg.trace('> xla_flex_pkg.id_column_is_null' , 20);

609: l_id_column_name varchar2(240);
610: l_return boolean;
611:
612: BEGIN
613: xla_utility_pkg.trace('> xla_flex_pkg.id_column_is_null' , 20);
614:
615: xla_utility_pkg.trace('Flex_value_set_id = '||p_flex_value_set_id , 40);
616:
617: SELECT id_column_name

Line 615: xla_utility_pkg.trace('Flex_value_set_id = '||p_flex_value_set_id , 40);

611:
612: BEGIN
613: xla_utility_pkg.trace('> xla_flex_pkg.id_column_is_null' , 20);
614:
615: xla_utility_pkg.trace('Flex_value_set_id = '||p_flex_value_set_id , 40);
616:
617: SELECT id_column_name
618: INTO l_id_column_name
619: FROM fnd_flex_validation_tables

Line 628: xla_utility_pkg.trace('< xla_flex_pkg.id_column_is_null' , 20);

624: ELSE
625: l_return := FALSE;
626: END IF;
627:
628: xla_utility_pkg.trace('< xla_flex_pkg.id_column_is_null' , 20);
629:
630: RETURN l_return;
631:
632: EXCEPTION

Line 658: xla_utility_pkg.trace('> xla_flex_pkg.meaning_column_is_null' , 20);

654: l_meaning_column_name varchar2(240);
655: l_return boolean;
656:
657: BEGIN
658: xla_utility_pkg.trace('> xla_flex_pkg.meaning_column_is_null' , 20);
659:
660: xla_utility_pkg.trace('Flex_value_set_id = '||p_flex_value_set_id , 40);
661:
662: SELECT meaning_column_name

Line 660: xla_utility_pkg.trace('Flex_value_set_id = '||p_flex_value_set_id , 40);

656:
657: BEGIN
658: xla_utility_pkg.trace('> xla_flex_pkg.meaning_column_is_null' , 20);
659:
660: xla_utility_pkg.trace('Flex_value_set_id = '||p_flex_value_set_id , 40);
661:
662: SELECT meaning_column_name
663: INTO l_meaning_column_name
664: FROM fnd_flex_validation_tables

Line 673: xla_utility_pkg.trace('< xla_flex_pkg.meaning_column_is_null' , 20);

669: ELSE
670: l_return := FALSE;
671: END IF;
672:
673: xla_utility_pkg.trace('< xla_flex_pkg.meaning_column_is_null' , 20);
674:
675: RETURN l_return;
676:
677: EXCEPTION

Line 703: xla_utility_pkg.trace('> xla_flex_pkg.chk_additional_where_clause' , 20);

699: l_additional_where_clause varchar2(4000);
700: l_return varchar2(30);
701:
702: BEGIN
703: xla_utility_pkg.trace('> xla_flex_pkg.chk_additional_where_clause' , 20);
704:
705: xla_utility_pkg.trace('Flex_value_set_id = '||p_flex_value_set_id , 40);
706:
707: BEGIN

Line 705: xla_utility_pkg.trace('Flex_value_set_id = '||p_flex_value_set_id , 40);

701:
702: BEGIN
703: xla_utility_pkg.trace('> xla_flex_pkg.chk_additional_where_clause' , 20);
704:
705: xla_utility_pkg.trace('Flex_value_set_id = '||p_flex_value_set_id , 40);
706:
707: BEGIN
708: SELECT additional_where_clause
709: INTO l_additional_where_clause

Line 730: xla_utility_pkg.trace('< xla_flex_pkg.chk_additional_where_clause' , 20);

726: WHEN VALUE_ERROR THEN
727: l_return := 'FALSE';
728: END;
729:
730: xla_utility_pkg.trace('< xla_flex_pkg.chk_additional_where_clause' , 20);
731:
732: RETURN l_return;
733:
734: EXCEPTION

Line 774: xla_utility_pkg.trace('> xla_flex_pkg.get_qualifier_segment' , 20);

770: ;
771:
772: BEGIN
773:
774: xla_utility_pkg.trace('> xla_flex_pkg.get_qualifier_segment' , 20);
775:
776: xla_utility_pkg.trace('Application id = '||p_application_id , 40);
777: xla_utility_pkg.trace('Flex code = '||p_id_flex_code , 40);
778: xla_utility_pkg.trace('Chart of accounts id = '||p_id_flex_num , 40);

Line 776: xla_utility_pkg.trace('Application id = '||p_application_id , 40);

772: BEGIN
773:
774: xla_utility_pkg.trace('> xla_flex_pkg.get_qualifier_segment' , 20);
775:
776: xla_utility_pkg.trace('Application id = '||p_application_id , 40);
777: xla_utility_pkg.trace('Flex code = '||p_id_flex_code , 40);
778: xla_utility_pkg.trace('Chart of accounts id = '||p_id_flex_num , 40);
779: xla_utility_pkg.trace('Flexfield segment code = '||p_qualifier_segment , 40);
780:

Line 777: xla_utility_pkg.trace('Flex code = '||p_id_flex_code , 40);

773:
774: xla_utility_pkg.trace('> xla_flex_pkg.get_qualifier_segment' , 20);
775:
776: xla_utility_pkg.trace('Application id = '||p_application_id , 40);
777: xla_utility_pkg.trace('Flex code = '||p_id_flex_code , 40);
778: xla_utility_pkg.trace('Chart of accounts id = '||p_id_flex_num , 40);
779: xla_utility_pkg.trace('Flexfield segment code = '||p_qualifier_segment , 40);
780:
781: OPEN c_segment;

Line 778: xla_utility_pkg.trace('Chart of accounts id = '||p_id_flex_num , 40);

774: xla_utility_pkg.trace('> xla_flex_pkg.get_qualifier_segment' , 20);
775:
776: xla_utility_pkg.trace('Application id = '||p_application_id , 40);
777: xla_utility_pkg.trace('Flex code = '||p_id_flex_code , 40);
778: xla_utility_pkg.trace('Chart of accounts id = '||p_id_flex_num , 40);
779: xla_utility_pkg.trace('Flexfield segment code = '||p_qualifier_segment , 40);
780:
781: OPEN c_segment;
782: FETCH c_segment

Line 779: xla_utility_pkg.trace('Flexfield segment code = '||p_qualifier_segment , 40);

775:
776: xla_utility_pkg.trace('Application id = '||p_application_id , 40);
777: xla_utility_pkg.trace('Flex code = '||p_id_flex_code , 40);
778: xla_utility_pkg.trace('Chart of accounts id = '||p_id_flex_num , 40);
779: xla_utility_pkg.trace('Flexfield segment code = '||p_qualifier_segment , 40);
780:
781: OPEN c_segment;
782: FETCH c_segment
783: INTO l_application_column_name;

Line 786: xla_utility_pkg.trace('< xla_flex_pkg.get_qualifier_segment' , 20);

782: FETCH c_segment
783: INTO l_application_column_name;
784: CLOSE c_segment;
785:
786: xla_utility_pkg.trace('< xla_flex_pkg.get_qualifier_segment' , 20);
787:
788: RETURN l_application_column_name;
789:
790: EXCEPTION

Line 836: xla_utility_pkg.trace('> xla_flex_pkg.get_segment_qualifier' , 20);

832: ;
833:
834: BEGIN
835:
836: xla_utility_pkg.trace('> xla_flex_pkg.get_segment_qualifier' , 20);
837:
838: xla_utility_pkg.trace('Application id = '||p_application_id , 40);
839: xla_utility_pkg.trace('Flex code = '||p_id_flex_code , 40);
840: xla_utility_pkg.trace('Structure id = '||p_id_flex_num , 40);

Line 838: xla_utility_pkg.trace('Application id = '||p_application_id , 40);

834: BEGIN
835:
836: xla_utility_pkg.trace('> xla_flex_pkg.get_segment_qualifier' , 20);
837:
838: xla_utility_pkg.trace('Application id = '||p_application_id , 40);
839: xla_utility_pkg.trace('Flex code = '||p_id_flex_code , 40);
840: xla_utility_pkg.trace('Structure id = '||p_id_flex_num , 40);
841: xla_utility_pkg.trace('Flexfield segment code = '||p_segment_code , 40);
842:

Line 839: xla_utility_pkg.trace('Flex code = '||p_id_flex_code , 40);

835:
836: xla_utility_pkg.trace('> xla_flex_pkg.get_segment_qualifier' , 20);
837:
838: xla_utility_pkg.trace('Application id = '||p_application_id , 40);
839: xla_utility_pkg.trace('Flex code = '||p_id_flex_code , 40);
840: xla_utility_pkg.trace('Structure id = '||p_id_flex_num , 40);
841: xla_utility_pkg.trace('Flexfield segment code = '||p_segment_code , 40);
842:
843: OPEN c_qualifier;

Line 840: xla_utility_pkg.trace('Structure id = '||p_id_flex_num , 40);

836: xla_utility_pkg.trace('> xla_flex_pkg.get_segment_qualifier' , 20);
837:
838: xla_utility_pkg.trace('Application id = '||p_application_id , 40);
839: xla_utility_pkg.trace('Flex code = '||p_id_flex_code , 40);
840: xla_utility_pkg.trace('Structure id = '||p_id_flex_num , 40);
841: xla_utility_pkg.trace('Flexfield segment code = '||p_segment_code , 40);
842:
843: OPEN c_qualifier;
844: FETCH c_qualifier

Line 841: xla_utility_pkg.trace('Flexfield segment code = '||p_segment_code , 40);

837:
838: xla_utility_pkg.trace('Application id = '||p_application_id , 40);
839: xla_utility_pkg.trace('Flex code = '||p_id_flex_code , 40);
840: xla_utility_pkg.trace('Structure id = '||p_id_flex_num , 40);
841: xla_utility_pkg.trace('Flexfield segment code = '||p_segment_code , 40);
842:
843: OPEN c_qualifier;
844: FETCH c_qualifier
845: INTO l_segment_attribute_type;

Line 848: xla_utility_pkg.trace('< xla_flex_pkg.get_segment_qualifier' , 20);

844: FETCH c_qualifier
845: INTO l_segment_attribute_type;
846: CLOSE c_qualifier;
847:
848: xla_utility_pkg.trace('< xla_flex_pkg.get_segment_qualifier' , 20);
849:
850: IF l_segment_attribute_type = null THEN
851: l_segment_attribute_type := 'X';
852: END IF;

Line 901: xla_utility_pkg.trace('> xla_flex_pkg.get_segment_valueset' , 20);

897: ;
898:
899: BEGIN
900:
901: xla_utility_pkg.trace('> xla_flex_pkg.get_segment_valueset' , 20);
902:
903: xla_utility_pkg.trace('Application id = '||p_application_id , 40);
904: xla_utility_pkg.trace('Flex code = '||p_id_flex_code , 40);
905: xla_utility_pkg.trace('Structure id = '||p_id_flex_num , 40);

Line 903: xla_utility_pkg.trace('Application id = '||p_application_id , 40);

899: BEGIN
900:
901: xla_utility_pkg.trace('> xla_flex_pkg.get_segment_valueset' , 20);
902:
903: xla_utility_pkg.trace('Application id = '||p_application_id , 40);
904: xla_utility_pkg.trace('Flex code = '||p_id_flex_code , 40);
905: xla_utility_pkg.trace('Structure id = '||p_id_flex_num , 40);
906: xla_utility_pkg.trace('Flexfield segment code = '||p_segment_code , 40);
907:

Line 904: xla_utility_pkg.trace('Flex code = '||p_id_flex_code , 40);

900:
901: xla_utility_pkg.trace('> xla_flex_pkg.get_segment_valueset' , 20);
902:
903: xla_utility_pkg.trace('Application id = '||p_application_id , 40);
904: xla_utility_pkg.trace('Flex code = '||p_id_flex_code , 40);
905: xla_utility_pkg.trace('Structure id = '||p_id_flex_num , 40);
906: xla_utility_pkg.trace('Flexfield segment code = '||p_segment_code , 40);
907:
908: OPEN c_valueset;

Line 905: xla_utility_pkg.trace('Structure id = '||p_id_flex_num , 40);

901: xla_utility_pkg.trace('> xla_flex_pkg.get_segment_valueset' , 20);
902:
903: xla_utility_pkg.trace('Application id = '||p_application_id , 40);
904: xla_utility_pkg.trace('Flex code = '||p_id_flex_code , 40);
905: xla_utility_pkg.trace('Structure id = '||p_id_flex_num , 40);
906: xla_utility_pkg.trace('Flexfield segment code = '||p_segment_code , 40);
907:
908: OPEN c_valueset;
909: FETCH c_valueset

Line 906: xla_utility_pkg.trace('Flexfield segment code = '||p_segment_code , 40);

902:
903: xla_utility_pkg.trace('Application id = '||p_application_id , 40);
904: xla_utility_pkg.trace('Flex code = '||p_id_flex_code , 40);
905: xla_utility_pkg.trace('Structure id = '||p_id_flex_num , 40);
906: xla_utility_pkg.trace('Flexfield segment code = '||p_segment_code , 40);
907:
908: OPEN c_valueset;
909: FETCH c_valueset
910: INTO l_flex_value_set_id;

Line 913: xla_utility_pkg.trace('< xla_flex_pkg.get_segment_valueset' , 20);

909: FETCH c_valueset
910: INTO l_flex_value_set_id;
911: CLOSE c_valueset;
912:
913: xla_utility_pkg.trace('< xla_flex_pkg.get_segment_valueset' , 20);
914:
915: IF l_flex_value_set_id = null THEN
916: l_flex_value_set_id := -99;
917: END IF;

Line 962: xla_utility_pkg.trace('> xla_flex_pkg.get_qualifier_name' , 20);

958: AND segment_attribute_type = p_qualifier_segment;
959:
960: BEGIN
961:
962: xla_utility_pkg.trace('> xla_flex_pkg.get_qualifier_name' , 20);
963:
964: xla_utility_pkg.trace('Application id = '||p_application_id , 40);
965: xla_utility_pkg.trace('Flex code = '||p_id_flex_code , 40);
966: xla_utility_pkg.trace('Flexfield segment code = '||p_qualifier_segment , 40);

Line 964: xla_utility_pkg.trace('Application id = '||p_application_id , 40);

960: BEGIN
961:
962: xla_utility_pkg.trace('> xla_flex_pkg.get_qualifier_name' , 20);
963:
964: xla_utility_pkg.trace('Application id = '||p_application_id , 40);
965: xla_utility_pkg.trace('Flex code = '||p_id_flex_code , 40);
966: xla_utility_pkg.trace('Flexfield segment code = '||p_qualifier_segment , 40);
967:
968: OPEN c_segment;

Line 965: xla_utility_pkg.trace('Flex code = '||p_id_flex_code , 40);

961:
962: xla_utility_pkg.trace('> xla_flex_pkg.get_qualifier_name' , 20);
963:
964: xla_utility_pkg.trace('Application id = '||p_application_id , 40);
965: xla_utility_pkg.trace('Flex code = '||p_id_flex_code , 40);
966: xla_utility_pkg.trace('Flexfield segment code = '||p_qualifier_segment , 40);
967:
968: OPEN c_segment;
969: FETCH c_segment

Line 966: xla_utility_pkg.trace('Flexfield segment code = '||p_qualifier_segment , 40);

962: xla_utility_pkg.trace('> xla_flex_pkg.get_qualifier_name' , 20);
963:
964: xla_utility_pkg.trace('Application id = '||p_application_id , 40);
965: xla_utility_pkg.trace('Flex code = '||p_id_flex_code , 40);
966: xla_utility_pkg.trace('Flexfield segment code = '||p_qualifier_segment , 40);
967:
968: OPEN c_segment;
969: FETCH c_segment
970: INTO l_segment_prompt;

Line 973: xla_utility_pkg.trace('< xla_flex_pkg.get_qualifier_name' , 20);

969: FETCH c_segment
970: INTO l_segment_prompt;
971: CLOSE c_segment;
972:
973: xla_utility_pkg.trace('< xla_flex_pkg.get_qualifier_name' , 20);
974:
975: RETURN l_segment_prompt;
976:
977: EXCEPTION

Line 1017: xla_utility_pkg.trace('> xla_flex_pkg.get_flexfield_structure' , 20);

1013: AND id_flex_code = p_id_flex_code;
1014:
1015: BEGIN
1016:
1017: xla_utility_pkg.trace('> xla_flex_pkg.get_flexfield_structure' , 20);
1018:
1019: xla_utility_pkg.trace('Application id = '||p_application_id , 40);
1020: xla_utility_pkg.trace('Flex code = '||p_id_flex_code , 40);
1021:

Line 1019: xla_utility_pkg.trace('Application id = '||p_application_id , 40);

1015: BEGIN
1016:
1017: xla_utility_pkg.trace('> xla_flex_pkg.get_flexfield_structure' , 20);
1018:
1019: xla_utility_pkg.trace('Application id = '||p_application_id , 40);
1020: xla_utility_pkg.trace('Flex code = '||p_id_flex_code , 40);
1021:
1022: OPEN c_struc;
1023: FETCH c_struc

Line 1020: xla_utility_pkg.trace('Flex code = '||p_id_flex_code , 40);

1016:
1017: xla_utility_pkg.trace('> xla_flex_pkg.get_flexfield_structure' , 20);
1018:
1019: xla_utility_pkg.trace('Application id = '||p_application_id , 40);
1020: xla_utility_pkg.trace('Flex code = '||p_id_flex_code , 40);
1021:
1022: OPEN c_struc;
1023: FETCH c_struc
1024: INTO l_id_flex_num;

Line 1027: xla_utility_pkg.trace('< xla_flex_pkg.get_flexfield_structure' , 20);

1023: FETCH c_struc
1024: INTO l_id_flex_num;
1025: CLOSE c_struc;
1026:
1027: xla_utility_pkg.trace('< xla_flex_pkg.get_flexfield_structure' , 20);
1028:
1029: RETURN l_id_flex_num;
1030:
1031: EXCEPTION