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 61: xla_utility_pkg.trace('> xla_flex_pkg.get_value_set_name' , 20);

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

243: l_number NUMBER;
244: l_number2 NUMBER;--Bug 12943068
245:
246: BEGIN
247: xla_utility_pkg.trace('> xla_flex_pkg.get_flex_value_meaning' , 20);
248:
249: xla_utility_pkg.trace('Flex_value_set_id = '||p_flex_value_set_id , 40);
250: xla_utility_pkg.trace('Flex_value = '||p_flex_value , 40);
251:

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

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

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

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

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

345:
346:
347: END IF;
348:
349: xla_utility_pkg.trace('Statement = '||l_statement , 50);
350:
351: --
352: -- Bug912223 with 8i
353: --

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

371: ,'LOCATION' ,'xla_flex_pkg.get_flex_value_meaning');
372: END IF;
373: END IF;
374:
375: xla_utility_pkg.trace('Flex_value_meaning = '||g_meaning_meaning , 40);
376:
377: xla_utility_pkg.trace('< xla_flex_pkg.get_flex_value_meaning' , 20);
378:
379: RETURN g_meaning_meaning;

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

373: END IF;
374:
375: xla_utility_pkg.trace('Flex_value_meaning = '||g_meaning_meaning , 40);
376:
377: xla_utility_pkg.trace('< xla_flex_pkg.get_flex_value_meaning' , 20);
378:
379: RETURN g_meaning_meaning;
380:
381: EXCEPTION

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

435: ;
436:
437: BEGIN
438:
439: xla_utility_pkg.trace('> xla_flex_pkg.get_flexfield_segment_info' , 20);
440:
441: xla_utility_pkg.trace('Application id = '||p_application_id , 40);
442: xla_utility_pkg.trace('Flex code = '||p_flex_code , 40);
443: xla_utility_pkg.trace('Chart of accounts id = '||p_chart_of_accounts_id , 40);

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

437: BEGIN
438:
439: xla_utility_pkg.trace('> xla_flex_pkg.get_flexfield_segment_info' , 20);
440:
441: xla_utility_pkg.trace('Application id = '||p_application_id , 40);
442: xla_utility_pkg.trace('Flex code = '||p_flex_code , 40);
443: xla_utility_pkg.trace('Chart of accounts id = '||p_chart_of_accounts_id , 40);
444: xla_utility_pkg.trace('Flexfield Segment Code = '||p_flexfield_segment_code , 40);
445:

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

438:
439: xla_utility_pkg.trace('> xla_flex_pkg.get_flexfield_segment_info' , 20);
440:
441: xla_utility_pkg.trace('Application id = '||p_application_id , 40);
442: xla_utility_pkg.trace('Flex code = '||p_flex_code , 40);
443: xla_utility_pkg.trace('Chart of accounts id = '||p_chart_of_accounts_id , 40);
444: xla_utility_pkg.trace('Flexfield Segment Code = '||p_flexfield_segment_code , 40);
445:
446: OPEN c_segment_info;

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

439: xla_utility_pkg.trace('> xla_flex_pkg.get_flexfield_segment_info' , 20);
440:
441: xla_utility_pkg.trace('Application id = '||p_application_id , 40);
442: xla_utility_pkg.trace('Flex code = '||p_flex_code , 40);
443: xla_utility_pkg.trace('Chart of accounts id = '||p_chart_of_accounts_id , 40);
444: xla_utility_pkg.trace('Flexfield Segment Code = '||p_flexfield_segment_code , 40);
445:
446: OPEN c_segment_info;
447:

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

440:
441: xla_utility_pkg.trace('Application id = '||p_application_id , 40);
442: xla_utility_pkg.trace('Flex code = '||p_flex_code , 40);
443: xla_utility_pkg.trace('Chart of accounts id = '||p_chart_of_accounts_id , 40);
444: xla_utility_pkg.trace('Flexfield Segment Code = '||p_flexfield_segment_code , 40);
445:
446: OPEN c_segment_info;
447:
448: FETCH c_segment_info

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

457: INTO p_flexfield_segment_num;
458:
459: CLOSE c_segment_num;
460:
461: xla_utility_pkg.trace('Segment name = '||p_flexfield_segment_name , 40);
462: xla_utility_pkg.trace('Segment num = '||p_flexfield_segment_num , 40);
463:
464: xla_utility_pkg.trace('< xla_flex_pkg.get_flexfield_segment_info' , 20);
465:

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

458:
459: CLOSE c_segment_num;
460:
461: xla_utility_pkg.trace('Segment name = '||p_flexfield_segment_name , 40);
462: xla_utility_pkg.trace('Segment num = '||p_flexfield_segment_num , 40);
463:
464: xla_utility_pkg.trace('< xla_flex_pkg.get_flexfield_segment_info' , 20);
465:
466: RETURN TRUE;

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

460:
461: xla_utility_pkg.trace('Segment name = '||p_flexfield_segment_name , 40);
462: xla_utility_pkg.trace('Segment num = '||p_flexfield_segment_num , 40);
463:
464: xla_utility_pkg.trace('< xla_flex_pkg.get_flexfield_segment_info' , 20);
465:
466: RETURN TRUE;
467:
468: EXCEPTION

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

498:
499:
500: BEGIN
501:
502: xla_utility_pkg.trace('> xla_flex_pkg.get_table_vset_select' , 20);
503:
504: xla_utility_pkg.trace('flex_value_set_id = '||p_flex_value_set_id , 40);
505:
506: fnd_flex_val_api.get_table_vset_select

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

500: BEGIN
501:
502: xla_utility_pkg.trace('> xla_flex_pkg.get_table_vset_select' , 20);
503:
504: xla_utility_pkg.trace('flex_value_set_id = '||p_flex_value_set_id , 40);
505:
506: fnd_flex_val_api.get_table_vset_select
507: (p_value_set_id => p_flex_value_set_id
508: ,x_select => p_select

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

509: ,x_mapping_code => p_mapping_code
510: ,x_success => p_success);
511:
512:
513: xla_utility_pkg.trace('select = '||p_select , 40);
514: xla_utility_pkg.trace('mapping code = '||p_mapping_code , 40);
515: xla_utility_pkg.trace('success = '||p_success , 40);
516:
517: xla_utility_pkg.trace('< xla_flex_pkg.get_table_vset_select' , 20);

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

510: ,x_success => p_success);
511:
512:
513: xla_utility_pkg.trace('select = '||p_select , 40);
514: xla_utility_pkg.trace('mapping code = '||p_mapping_code , 40);
515: xla_utility_pkg.trace('success = '||p_success , 40);
516:
517: xla_utility_pkg.trace('< xla_flex_pkg.get_table_vset_select' , 20);
518:

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

511:
512:
513: xla_utility_pkg.trace('select = '||p_select , 40);
514: xla_utility_pkg.trace('mapping code = '||p_mapping_code , 40);
515: xla_utility_pkg.trace('success = '||p_success , 40);
516:
517: xla_utility_pkg.trace('< xla_flex_pkg.get_table_vset_select' , 20);
518:
519: EXCEPTION

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

513: xla_utility_pkg.trace('select = '||p_select , 40);
514: xla_utility_pkg.trace('mapping code = '||p_mapping_code , 40);
515: xla_utility_pkg.trace('success = '||p_success , 40);
516:
517: xla_utility_pkg.trace('< xla_flex_pkg.get_table_vset_select' , 20);
518:
519: EXCEPTION
520: WHEN xla_exceptions_pkg.application_exception THEN
521: RAISE;

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

620: ;
621:
622: BEGIN
623:
624: xla_utility_pkg.trace('> xla_flex_pkg.segment_qualifier_is_enabled' , 20);
625:
626: xla_utility_pkg.trace('Application id = '||p_application_id , 40);
627: xla_utility_pkg.trace('Flex code = '||p_flex_code , 40);
628: xla_utility_pkg.trace('Chart of accounts id = '||p_chart_of_accounts_id , 40);

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

622: BEGIN
623:
624: xla_utility_pkg.trace('> xla_flex_pkg.segment_qualifier_is_enabled' , 20);
625:
626: xla_utility_pkg.trace('Application id = '||p_application_id , 40);
627: xla_utility_pkg.trace('Flex code = '||p_flex_code , 40);
628: xla_utility_pkg.trace('Chart of accounts id = '||p_chart_of_accounts_id , 40);
629: xla_utility_pkg.trace('Flexfield segment code = '||p_flexfield_segment_code , 40);
630:

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

623:
624: xla_utility_pkg.trace('> xla_flex_pkg.segment_qualifier_is_enabled' , 20);
625:
626: xla_utility_pkg.trace('Application id = '||p_application_id , 40);
627: xla_utility_pkg.trace('Flex code = '||p_flex_code , 40);
628: xla_utility_pkg.trace('Chart of accounts id = '||p_chart_of_accounts_id , 40);
629: xla_utility_pkg.trace('Flexfield segment code = '||p_flexfield_segment_code , 40);
630:
631: IF p_flexfield_segment_code in ('GL_BALANCING','GL_ACCOUNT','GL_INTERCOMPANY',

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

624: xla_utility_pkg.trace('> xla_flex_pkg.segment_qualifier_is_enabled' , 20);
625:
626: xla_utility_pkg.trace('Application id = '||p_application_id , 40);
627: xla_utility_pkg.trace('Flex code = '||p_flex_code , 40);
628: xla_utility_pkg.trace('Chart of accounts id = '||p_chart_of_accounts_id , 40);
629: xla_utility_pkg.trace('Flexfield segment code = '||p_flexfield_segment_code , 40);
630:
631: IF p_flexfield_segment_code in ('GL_BALANCING','GL_ACCOUNT','GL_INTERCOMPANY',
632: 'GL_MANAGEMENT','FA_COST_CTR') THEN

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

625:
626: xla_utility_pkg.trace('Application id = '||p_application_id , 40);
627: xla_utility_pkg.trace('Flex code = '||p_flex_code , 40);
628: xla_utility_pkg.trace('Chart of accounts id = '||p_chart_of_accounts_id , 40);
629: xla_utility_pkg.trace('Flexfield segment code = '||p_flexfield_segment_code , 40);
630:
631: IF p_flexfield_segment_code in ('GL_BALANCING','GL_ACCOUNT','GL_INTERCOMPANY',
632: 'GL_MANAGEMENT','FA_COST_CTR') THEN
633: OPEN c_qualifier;

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

642: ELSE
643: l_return := TRUE;
644: END IF;
645:
646: xla_utility_pkg.trace('< xla_flex_pkg.segment_qualifier_is_enabled' , 20);
647:
648: RETURN l_return;
649:
650: EXCEPTION

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

678: l_id_column_name varchar2(240);
679: l_return boolean;
680:
681: BEGIN
682: xla_utility_pkg.trace('> xla_flex_pkg.id_column_is_null' , 20);
683:
684: xla_utility_pkg.trace('Flex_value_set_id = '||p_flex_value_set_id , 40);
685:
686: SELECT id_column_name

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

680:
681: BEGIN
682: xla_utility_pkg.trace('> xla_flex_pkg.id_column_is_null' , 20);
683:
684: xla_utility_pkg.trace('Flex_value_set_id = '||p_flex_value_set_id , 40);
685:
686: SELECT id_column_name
687: INTO l_id_column_name
688: FROM fnd_flex_validation_tables

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

693: ELSE
694: l_return := FALSE;
695: END IF;
696:
697: xla_utility_pkg.trace('< xla_flex_pkg.id_column_is_null' , 20);
698:
699: RETURN l_return;
700:
701: EXCEPTION

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

723: l_meaning_column_name varchar2(240);
724: l_return boolean;
725:
726: BEGIN
727: xla_utility_pkg.trace('> xla_flex_pkg.meaning_column_is_null' , 20);
728:
729: xla_utility_pkg.trace('Flex_value_set_id = '||p_flex_value_set_id , 40);
730:
731: SELECT meaning_column_name

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

725:
726: BEGIN
727: xla_utility_pkg.trace('> xla_flex_pkg.meaning_column_is_null' , 20);
728:
729: xla_utility_pkg.trace('Flex_value_set_id = '||p_flex_value_set_id , 40);
730:
731: SELECT meaning_column_name
732: INTO l_meaning_column_name
733: FROM fnd_flex_validation_tables

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

738: ELSE
739: l_return := FALSE;
740: END IF;
741:
742: xla_utility_pkg.trace('< xla_flex_pkg.meaning_column_is_null' , 20);
743:
744: RETURN l_return;
745:
746: EXCEPTION

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

768: l_additional_where_clause varchar2(4000);
769: l_return varchar2(30);
770:
771: BEGIN
772: xla_utility_pkg.trace('> xla_flex_pkg.chk_additional_where_clause' , 20);
773:
774: xla_utility_pkg.trace('Flex_value_set_id = '||p_flex_value_set_id , 40);
775:
776: BEGIN

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

770:
771: BEGIN
772: xla_utility_pkg.trace('> xla_flex_pkg.chk_additional_where_clause' , 20);
773:
774: xla_utility_pkg.trace('Flex_value_set_id = '||p_flex_value_set_id , 40);
775:
776: BEGIN
777: SELECT additional_where_clause
778: INTO l_additional_where_clause

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

795: WHEN VALUE_ERROR THEN
796: l_return := 'FALSE';
797: END;
798:
799: xla_utility_pkg.trace('< xla_flex_pkg.chk_additional_where_clause' , 20);
800:
801: RETURN l_return;
802:
803: EXCEPTION

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

839: ;
840:
841: BEGIN
842:
843: xla_utility_pkg.trace('> xla_flex_pkg.get_qualifier_segment' , 20);
844:
845: xla_utility_pkg.trace('Application id = '||p_application_id , 40);
846: xla_utility_pkg.trace('Flex code = '||p_id_flex_code , 40);
847: xla_utility_pkg.trace('Chart of accounts id = '||p_id_flex_num , 40);

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

841: BEGIN
842:
843: xla_utility_pkg.trace('> xla_flex_pkg.get_qualifier_segment' , 20);
844:
845: xla_utility_pkg.trace('Application id = '||p_application_id , 40);
846: xla_utility_pkg.trace('Flex code = '||p_id_flex_code , 40);
847: xla_utility_pkg.trace('Chart of accounts id = '||p_id_flex_num , 40);
848: xla_utility_pkg.trace('Flexfield segment code = '||p_qualifier_segment , 40);
849:

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

842:
843: xla_utility_pkg.trace('> xla_flex_pkg.get_qualifier_segment' , 20);
844:
845: xla_utility_pkg.trace('Application id = '||p_application_id , 40);
846: xla_utility_pkg.trace('Flex code = '||p_id_flex_code , 40);
847: xla_utility_pkg.trace('Chart of accounts id = '||p_id_flex_num , 40);
848: xla_utility_pkg.trace('Flexfield segment code = '||p_qualifier_segment , 40);
849:
850: OPEN c_segment;

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

843: xla_utility_pkg.trace('> xla_flex_pkg.get_qualifier_segment' , 20);
844:
845: xla_utility_pkg.trace('Application id = '||p_application_id , 40);
846: xla_utility_pkg.trace('Flex code = '||p_id_flex_code , 40);
847: xla_utility_pkg.trace('Chart of accounts id = '||p_id_flex_num , 40);
848: xla_utility_pkg.trace('Flexfield segment code = '||p_qualifier_segment , 40);
849:
850: OPEN c_segment;
851: FETCH c_segment

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

844:
845: xla_utility_pkg.trace('Application id = '||p_application_id , 40);
846: xla_utility_pkg.trace('Flex code = '||p_id_flex_code , 40);
847: xla_utility_pkg.trace('Chart of accounts id = '||p_id_flex_num , 40);
848: xla_utility_pkg.trace('Flexfield segment code = '||p_qualifier_segment , 40);
849:
850: OPEN c_segment;
851: FETCH c_segment
852: INTO l_application_column_name;

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

851: FETCH c_segment
852: INTO l_application_column_name;
853: CLOSE c_segment;
854:
855: xla_utility_pkg.trace('< xla_flex_pkg.get_qualifier_segment' , 20);
856:
857: RETURN l_application_column_name;
858:
859: EXCEPTION

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

901: ;
902:
903: BEGIN
904:
905: xla_utility_pkg.trace('> xla_flex_pkg.get_segment_qualifier' , 20);
906:
907: xla_utility_pkg.trace('Application id = '||p_application_id , 40);
908: xla_utility_pkg.trace('Flex code = '||p_id_flex_code , 40);
909: xla_utility_pkg.trace('Structure id = '||p_id_flex_num , 40);

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

903: BEGIN
904:
905: xla_utility_pkg.trace('> xla_flex_pkg.get_segment_qualifier' , 20);
906:
907: xla_utility_pkg.trace('Application id = '||p_application_id , 40);
908: xla_utility_pkg.trace('Flex code = '||p_id_flex_code , 40);
909: xla_utility_pkg.trace('Structure id = '||p_id_flex_num , 40);
910: xla_utility_pkg.trace('Flexfield segment code = '||p_segment_code , 40);
911:

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

904:
905: xla_utility_pkg.trace('> xla_flex_pkg.get_segment_qualifier' , 20);
906:
907: xla_utility_pkg.trace('Application id = '||p_application_id , 40);
908: xla_utility_pkg.trace('Flex code = '||p_id_flex_code , 40);
909: xla_utility_pkg.trace('Structure id = '||p_id_flex_num , 40);
910: xla_utility_pkg.trace('Flexfield segment code = '||p_segment_code , 40);
911:
912: OPEN c_qualifier;

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

905: xla_utility_pkg.trace('> xla_flex_pkg.get_segment_qualifier' , 20);
906:
907: xla_utility_pkg.trace('Application id = '||p_application_id , 40);
908: xla_utility_pkg.trace('Flex code = '||p_id_flex_code , 40);
909: xla_utility_pkg.trace('Structure id = '||p_id_flex_num , 40);
910: xla_utility_pkg.trace('Flexfield segment code = '||p_segment_code , 40);
911:
912: OPEN c_qualifier;
913: FETCH c_qualifier

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

906:
907: xla_utility_pkg.trace('Application id = '||p_application_id , 40);
908: xla_utility_pkg.trace('Flex code = '||p_id_flex_code , 40);
909: xla_utility_pkg.trace('Structure id = '||p_id_flex_num , 40);
910: xla_utility_pkg.trace('Flexfield segment code = '||p_segment_code , 40);
911:
912: OPEN c_qualifier;
913: FETCH c_qualifier
914: INTO l_segment_attribute_type;

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

913: FETCH c_qualifier
914: INTO l_segment_attribute_type;
915: CLOSE c_qualifier;
916:
917: xla_utility_pkg.trace('< xla_flex_pkg.get_segment_qualifier' , 20);
918:
919: IF l_segment_attribute_type = null THEN
920: l_segment_attribute_type := 'X';
921: END IF;

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

966: ;
967:
968: BEGIN
969:
970: xla_utility_pkg.trace('> xla_flex_pkg.get_segment_valueset' , 20);
971:
972: xla_utility_pkg.trace('Application id = '||p_application_id , 40);
973: xla_utility_pkg.trace('Flex code = '||p_id_flex_code , 40);
974: xla_utility_pkg.trace('Structure id = '||p_id_flex_num , 40);

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

968: BEGIN
969:
970: xla_utility_pkg.trace('> xla_flex_pkg.get_segment_valueset' , 20);
971:
972: xla_utility_pkg.trace('Application id = '||p_application_id , 40);
973: xla_utility_pkg.trace('Flex code = '||p_id_flex_code , 40);
974: xla_utility_pkg.trace('Structure id = '||p_id_flex_num , 40);
975: xla_utility_pkg.trace('Flexfield segment code = '||p_segment_code , 40);
976:

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

969:
970: xla_utility_pkg.trace('> xla_flex_pkg.get_segment_valueset' , 20);
971:
972: xla_utility_pkg.trace('Application id = '||p_application_id , 40);
973: xla_utility_pkg.trace('Flex code = '||p_id_flex_code , 40);
974: xla_utility_pkg.trace('Structure id = '||p_id_flex_num , 40);
975: xla_utility_pkg.trace('Flexfield segment code = '||p_segment_code , 40);
976:
977: OPEN c_valueset;

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

970: xla_utility_pkg.trace('> xla_flex_pkg.get_segment_valueset' , 20);
971:
972: xla_utility_pkg.trace('Application id = '||p_application_id , 40);
973: xla_utility_pkg.trace('Flex code = '||p_id_flex_code , 40);
974: xla_utility_pkg.trace('Structure id = '||p_id_flex_num , 40);
975: xla_utility_pkg.trace('Flexfield segment code = '||p_segment_code , 40);
976:
977: OPEN c_valueset;
978: FETCH c_valueset

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

971:
972: xla_utility_pkg.trace('Application id = '||p_application_id , 40);
973: xla_utility_pkg.trace('Flex code = '||p_id_flex_code , 40);
974: xla_utility_pkg.trace('Structure id = '||p_id_flex_num , 40);
975: xla_utility_pkg.trace('Flexfield segment code = '||p_segment_code , 40);
976:
977: OPEN c_valueset;
978: FETCH c_valueset
979: INTO l_flex_value_set_id;

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

978: FETCH c_valueset
979: INTO l_flex_value_set_id;
980: CLOSE c_valueset;
981:
982: xla_utility_pkg.trace('< xla_flex_pkg.get_segment_valueset' , 20);
983:
984: IF l_flex_value_set_id = null THEN
985: l_flex_value_set_id := -99;
986: END IF;

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

1027: AND segment_attribute_type = p_qualifier_segment;
1028:
1029: BEGIN
1030:
1031: xla_utility_pkg.trace('> xla_flex_pkg.get_qualifier_name' , 20);
1032:
1033: xla_utility_pkg.trace('Application id = '||p_application_id , 40);
1034: xla_utility_pkg.trace('Flex code = '||p_id_flex_code , 40);
1035: xla_utility_pkg.trace('Flexfield segment code = '||p_qualifier_segment , 40);

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

1029: BEGIN
1030:
1031: xla_utility_pkg.trace('> xla_flex_pkg.get_qualifier_name' , 20);
1032:
1033: xla_utility_pkg.trace('Application id = '||p_application_id , 40);
1034: xla_utility_pkg.trace('Flex code = '||p_id_flex_code , 40);
1035: xla_utility_pkg.trace('Flexfield segment code = '||p_qualifier_segment , 40);
1036:
1037: OPEN c_segment;

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

1030:
1031: xla_utility_pkg.trace('> xla_flex_pkg.get_qualifier_name' , 20);
1032:
1033: xla_utility_pkg.trace('Application id = '||p_application_id , 40);
1034: xla_utility_pkg.trace('Flex code = '||p_id_flex_code , 40);
1035: xla_utility_pkg.trace('Flexfield segment code = '||p_qualifier_segment , 40);
1036:
1037: OPEN c_segment;
1038: FETCH c_segment

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

1031: xla_utility_pkg.trace('> xla_flex_pkg.get_qualifier_name' , 20);
1032:
1033: xla_utility_pkg.trace('Application id = '||p_application_id , 40);
1034: xla_utility_pkg.trace('Flex code = '||p_id_flex_code , 40);
1035: xla_utility_pkg.trace('Flexfield segment code = '||p_qualifier_segment , 40);
1036:
1037: OPEN c_segment;
1038: FETCH c_segment
1039: INTO l_segment_prompt;

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

1038: FETCH c_segment
1039: INTO l_segment_prompt;
1040: CLOSE c_segment;
1041:
1042: xla_utility_pkg.trace('< xla_flex_pkg.get_qualifier_name' , 20);
1043:
1044: RETURN l_segment_prompt;
1045:
1046: EXCEPTION

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

1082: AND id_flex_code = p_id_flex_code;
1083:
1084: BEGIN
1085:
1086: xla_utility_pkg.trace('> xla_flex_pkg.get_flexfield_structure' , 20);
1087:
1088: xla_utility_pkg.trace('Application id = '||p_application_id , 40);
1089: xla_utility_pkg.trace('Flex code = '||p_id_flex_code , 40);
1090:

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

1084: BEGIN
1085:
1086: xla_utility_pkg.trace('> xla_flex_pkg.get_flexfield_structure' , 20);
1087:
1088: xla_utility_pkg.trace('Application id = '||p_application_id , 40);
1089: xla_utility_pkg.trace('Flex code = '||p_id_flex_code , 40);
1090:
1091: OPEN c_struc;
1092: FETCH c_struc

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

1085:
1086: xla_utility_pkg.trace('> xla_flex_pkg.get_flexfield_structure' , 20);
1087:
1088: xla_utility_pkg.trace('Application id = '||p_application_id , 40);
1089: xla_utility_pkg.trace('Flex code = '||p_id_flex_code , 40);
1090:
1091: OPEN c_struc;
1092: FETCH c_struc
1093: INTO l_id_flex_num;

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

1092: FETCH c_struc
1093: INTO l_id_flex_num;
1094: CLOSE c_struc;
1095:
1096: xla_utility_pkg.trace('< xla_flex_pkg.get_flexfield_structure' , 20);
1097:
1098: RETURN l_id_flex_num;
1099:
1100: EXCEPTION