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.JL_BR_SPED_DATA_EXTRACT_PKG dependencies on FND_SEGMENT_ATTRIBUTE_VALUES

Line 588: FROM fnd_segment_attribute_values

584:
585: BEGIN
586: SELECT application_column_name -- finding which segment column is used for balancing segment storage
587: INTO g_bsv_segment
588: FROM fnd_segment_attribute_values
589: WHERE id_flex_code = 'GL#'
590: AND attribute_value = 'Y'
591: AND segment_attribute_type = 'GL_BALANCING'
592: AND application_id = 101

Line 597: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,'No balacing segment found in fnd_segment_attribute_values' );

593: AND id_flex_num = g_chart_of_accounts_id;
594: EXCEPTION
595: WHEN NO_DATA_FOUND THEN
596: IF ( G_LEVEL_EXCEPTION >= G_CURRENT_RUNTIME_LEVEL) THEN
597: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,'No balacing segment found in fnd_segment_attribute_values' );
598: END IF;
599: g_errbuf := 'No balancing segment found in fnd_segment_attribute_values for '||g_chart_of_accounts_id;
600: g_retcode := 2;
601: return;

Line 599: g_errbuf := 'No balancing segment found in fnd_segment_attribute_values for '||g_chart_of_accounts_id;

595: WHEN NO_DATA_FOUND THEN
596: IF ( G_LEVEL_EXCEPTION >= G_CURRENT_RUNTIME_LEVEL) THEN
597: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,'No balacing segment found in fnd_segment_attribute_values' );
598: END IF;
599: g_errbuf := 'No balancing segment found in fnd_segment_attribute_values for '||g_chart_of_accounts_id;
600: g_retcode := 2;
601: return;
602: WHEN OTHERS THEN
603: IF ( G_LEVEL_EXCEPTION >= G_CURRENT_RUNTIME_LEVEL) THEN

Line 617: FROM fnd_segment_attribute_values

613:
614: BEGIN
615: SELECT application_column_name -- finding which segment column is used for natural account segment storage
616: INTO g_account_segment
617: FROM fnd_segment_attribute_values
618: WHERE id_flex_code = 'GL#'
619: AND attribute_value = 'Y'
620: AND segment_attribute_type = 'GL_ACCOUNT'
621: AND application_id = 101

Line 627: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,'No Natural account segment found in fnd_segment_attribute_values' );

623:
624: EXCEPTION
625: WHEN NO_DATA_FOUND THEN
626: IF ( G_LEVEL_EXCEPTION >= G_CURRENT_RUNTIME_LEVEL) THEN
627: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,'No Natural account segment found in fnd_segment_attribute_values' );
628: END IF;
629: g_errbuf := 'No Natural account segment found in fnd_segment_attribute_values for '||g_chart_of_accounts_id;
630: g_retcode := 2;
631: return;

Line 629: g_errbuf := 'No Natural account segment found in fnd_segment_attribute_values for '||g_chart_of_accounts_id;

625: WHEN NO_DATA_FOUND THEN
626: IF ( G_LEVEL_EXCEPTION >= G_CURRENT_RUNTIME_LEVEL) THEN
627: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,'No Natural account segment found in fnd_segment_attribute_values' );
628: END IF;
629: g_errbuf := 'No Natural account segment found in fnd_segment_attribute_values for '||g_chart_of_accounts_id;
630: g_retcode := 2;
631: return;
632: WHEN OTHERS THEN
633: IF ( G_LEVEL_EXCEPTION >= G_CURRENT_RUNTIME_LEVEL) THEN

Line 647: FROM fnd_segment_attribute_values

643:
644: BEGIN
645: SELECT application_column_name -- finding which segment column is used for cost center storage
646: INTO g_cost_center_segment
647: FROM fnd_segment_attribute_values
648: WHERE id_flex_code = 'GL#'
649: AND attribute_value = 'Y'
650: AND segment_attribute_type = 'FA_COST_CTR'
651: AND application_id = 101

Line 659: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,'No cost center segment found in fnd_segment_attribute_values' );

655:
656: EXCEPTION
657: WHEN NO_DATA_FOUND THEN
658: IF (G_LEVEL_EXCEPTION >= G_CURRENT_RUNTIME_LEVEL) THEN
659: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,'No cost center segment found in fnd_segment_attribute_values' );
660: END IF;
661:
662: l_cc_exists_flag := 0; -- cost center setup doesn't exist
663: g_cost_center_segment := 'SEGMENT20'; -- To frame the dynamic query in I155,I310 assigned this column name. But we won't retrieve this column values.