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.HZ_FORMAT_PUB dependencies on FND_PROFILE

Line 121: g_icx_territory CONSTANT VARCHAR2(30) := FND_PROFILE.VALUE('ICX_TERRITORY');

117: k_profile_country_lang CONSTANT VARCHAR2(30) := 'HZ_LANG_FOR_COUNTRY_DISPLAY';
118: k_profile_def_addr_style CONSTANT VARCHAR2(30) := 'HZ_DEFAULT_ADDR_STYLE';
119: k_profile_def_name_style CONSTANT VARCHAR2(30) := 'HZ_DEFAULT_NAME_STYLE';
120:
121: g_icx_territory CONSTANT VARCHAR2(30) := FND_PROFILE.VALUE('ICX_TERRITORY');
122: g_profile_ref_lang CONSTANT VARCHAR2(4) := FND_PROFILE.VALUE('HZ_REF_LANG');
123: g_profile_ref_territory CONSTANT VARCHAR2(2) := FND_PROFILE.VALUE('HZ_REF_TERRITORY');
124: g_profile_country_lang CONSTANT VARCHAR2(4) := FND_PROFILE.VALUE('HZ_LANG_FOR_COUNTRY_DISPLAY');
125: g_profile_def_addr_style CONSTANT VARCHAR2(30) := FND_PROFILE.VALUE('HZ_DEFAULT_ADDR_STYLE');

Line 122: g_profile_ref_lang CONSTANT VARCHAR2(4) := FND_PROFILE.VALUE('HZ_REF_LANG');

118: k_profile_def_addr_style CONSTANT VARCHAR2(30) := 'HZ_DEFAULT_ADDR_STYLE';
119: k_profile_def_name_style CONSTANT VARCHAR2(30) := 'HZ_DEFAULT_NAME_STYLE';
120:
121: g_icx_territory CONSTANT VARCHAR2(30) := FND_PROFILE.VALUE('ICX_TERRITORY');
122: g_profile_ref_lang CONSTANT VARCHAR2(4) := FND_PROFILE.VALUE('HZ_REF_LANG');
123: g_profile_ref_territory CONSTANT VARCHAR2(2) := FND_PROFILE.VALUE('HZ_REF_TERRITORY');
124: g_profile_country_lang CONSTANT VARCHAR2(4) := FND_PROFILE.VALUE('HZ_LANG_FOR_COUNTRY_DISPLAY');
125: g_profile_def_addr_style CONSTANT VARCHAR2(30) := FND_PROFILE.VALUE('HZ_DEFAULT_ADDR_STYLE');
126: g_profile_def_name_style CONSTANT VARCHAR2(30) := FND_PROFILE.VALUE('HZ_DEFAULT_NAME_STYLE');

Line 123: g_profile_ref_territory CONSTANT VARCHAR2(2) := FND_PROFILE.VALUE('HZ_REF_TERRITORY');

119: k_profile_def_name_style CONSTANT VARCHAR2(30) := 'HZ_DEFAULT_NAME_STYLE';
120:
121: g_icx_territory CONSTANT VARCHAR2(30) := FND_PROFILE.VALUE('ICX_TERRITORY');
122: g_profile_ref_lang CONSTANT VARCHAR2(4) := FND_PROFILE.VALUE('HZ_REF_LANG');
123: g_profile_ref_territory CONSTANT VARCHAR2(2) := FND_PROFILE.VALUE('HZ_REF_TERRITORY');
124: g_profile_country_lang CONSTANT VARCHAR2(4) := FND_PROFILE.VALUE('HZ_LANG_FOR_COUNTRY_DISPLAY');
125: g_profile_def_addr_style CONSTANT VARCHAR2(30) := FND_PROFILE.VALUE('HZ_DEFAULT_ADDR_STYLE');
126: g_profile_def_name_style CONSTANT VARCHAR2(30) := FND_PROFILE.VALUE('HZ_DEFAULT_NAME_STYLE');
127:

Line 124: g_profile_country_lang CONSTANT VARCHAR2(4) := FND_PROFILE.VALUE('HZ_LANG_FOR_COUNTRY_DISPLAY');

120:
121: g_icx_territory CONSTANT VARCHAR2(30) := FND_PROFILE.VALUE('ICX_TERRITORY');
122: g_profile_ref_lang CONSTANT VARCHAR2(4) := FND_PROFILE.VALUE('HZ_REF_LANG');
123: g_profile_ref_territory CONSTANT VARCHAR2(2) := FND_PROFILE.VALUE('HZ_REF_TERRITORY');
124: g_profile_country_lang CONSTANT VARCHAR2(4) := FND_PROFILE.VALUE('HZ_LANG_FOR_COUNTRY_DISPLAY');
125: g_profile_def_addr_style CONSTANT VARCHAR2(30) := FND_PROFILE.VALUE('HZ_DEFAULT_ADDR_STYLE');
126: g_profile_def_name_style CONSTANT VARCHAR2(30) := FND_PROFILE.VALUE('HZ_DEFAULT_NAME_STYLE');
127:
128: k_addr_table_name CONSTANT VARCHAR2(30) := 'HZ_LOCATIONS';

Line 125: g_profile_def_addr_style CONSTANT VARCHAR2(30) := FND_PROFILE.VALUE('HZ_DEFAULT_ADDR_STYLE');

121: g_icx_territory CONSTANT VARCHAR2(30) := FND_PROFILE.VALUE('ICX_TERRITORY');
122: g_profile_ref_lang CONSTANT VARCHAR2(4) := FND_PROFILE.VALUE('HZ_REF_LANG');
123: g_profile_ref_territory CONSTANT VARCHAR2(2) := FND_PROFILE.VALUE('HZ_REF_TERRITORY');
124: g_profile_country_lang CONSTANT VARCHAR2(4) := FND_PROFILE.VALUE('HZ_LANG_FOR_COUNTRY_DISPLAY');
125: g_profile_def_addr_style CONSTANT VARCHAR2(30) := FND_PROFILE.VALUE('HZ_DEFAULT_ADDR_STYLE');
126: g_profile_def_name_style CONSTANT VARCHAR2(30) := FND_PROFILE.VALUE('HZ_DEFAULT_NAME_STYLE');
127:
128: k_addr_table_name CONSTANT VARCHAR2(30) := 'HZ_LOCATIONS';
129: k_addr_table_pk CONSTANT VARCHAR2(30) := 'LOCATION_ID';

Line 126: g_profile_def_name_style CONSTANT VARCHAR2(30) := FND_PROFILE.VALUE('HZ_DEFAULT_NAME_STYLE');

122: g_profile_ref_lang CONSTANT VARCHAR2(4) := FND_PROFILE.VALUE('HZ_REF_LANG');
123: g_profile_ref_territory CONSTANT VARCHAR2(2) := FND_PROFILE.VALUE('HZ_REF_TERRITORY');
124: g_profile_country_lang CONSTANT VARCHAR2(4) := FND_PROFILE.VALUE('HZ_LANG_FOR_COUNTRY_DISPLAY');
125: g_profile_def_addr_style CONSTANT VARCHAR2(30) := FND_PROFILE.VALUE('HZ_DEFAULT_ADDR_STYLE');
126: g_profile_def_name_style CONSTANT VARCHAR2(30) := FND_PROFILE.VALUE('HZ_DEFAULT_NAME_STYLE');
127:
128: k_addr_table_name CONSTANT VARCHAR2(30) := 'HZ_LOCATIONS';
129: k_addr_table_pk CONSTANT VARCHAR2(30) := 'LOCATION_ID';
130: k_name_table_name CONSTANT VARCHAR2(30) := 'HZ_PARTIES';

Line 3281: fnd_profile.get(

3277:
3278: IF p_object_name = k_name_table_name THEN
3279: /* Fix perf bug 3669930, 4220460, use cached profile option value
3280: -- check profile option
3281: fnd_profile.get(
3282: name => k_profile_def_name_style,
3283: val => l_style_code
3284: );
3285: */

Line 3290: fnd_profile.get(

3286: l_style_code := g_profile_def_name_style;
3287: ELSIF p_object_name = k_addr_table_name THEN
3288: /* Fix perf bug 3669930, 4220460, use cached profile option value
3289: -- check profile option
3290: fnd_profile.get(
3291: name => k_profile_def_addr_style,
3292: val => l_style_code
3293: );
3294: */

Line 3355: l_territory_code := FND_PROFILE.VALUE('HZ_REF_TERRITORY');

3351: ---Bug No. 5110275. First check HZ_REF_TERRITORY profile option and then ICX_TERRITORY profile option
3352:
3353: -- Bug No. 7139602. The profile value must be read at runtime. Cached value should not be used.
3354: --l_territory_code := g_profile_ref_territory;
3355: l_territory_code := FND_PROFILE.VALUE('HZ_REF_TERRITORY');
3356:
3357: -- Debug HZ_REF_TERRITORY
3358:
3359: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

Line 3371: l_nls_territory := FND_PROFILE.VALUE('ICX_TERRITORY');

3367:
3368: IF l_territory_code IS NULL THEN
3369: -- Bug No. 7139602. The profile value must be read at runtime. Cached value should not be used.
3370: -- l_nls_territory := g_icx_territory;
3371: l_nls_territory := FND_PROFILE.VALUE('ICX_TERRITORY');
3372:
3373: -- Debug ICX_TERRITORY
3374: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3375: hz_utility_v2pub.debug(p_message=>'HZ_FORMAT_PUB.get_default_ref_territory, ' ||

Line 3467: l_territory_code := FND_PROFILE.VALUE('HZ_REF_TERRITORY');

3463: ----Bug No. 5110275. First check for HZ_REF_TERRITORY and then for ICX_TERRITORY PROFILE OPTION
3464:
3465: -- Bug No. 7139602. The profile value must be read at runtime. Cached value should not be used.
3466: --l_territory_code := g_profile_ref_territory;
3467: l_territory_code := FND_PROFILE.VALUE('HZ_REF_TERRITORY');
3468:
3469:
3470: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3471:

Line 3481: l_nls_territory := FND_PROFILE.VALUE('ICX_TERRITORY');

3477:
3478: IF l_territory_code IS NULL THEN
3479: -- Bug No. 7139602. The profile value must be read at runtime. Cached value should not be used.
3480: -- l_nls_territory := g_icx_territory;
3481: l_nls_territory := FND_PROFILE.VALUE('ICX_TERRITORY');
3482:
3483: -- Debug ICX_TERRITORY value
3484: --
3485: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

Line 3573: fnd_profile.get(

3569: BEGIN
3570:
3571: /* Fix perf bug 3669930, 4220460, use cached profile option value
3572: -- check profile option
3573: fnd_profile.get(
3574: name => k_profile_ref_lang,
3575: val => l_language_code
3576: );
3577: */

Line 3634: fnd_profile.get(

3630: -- Language
3631: --
3632:
3633: /* Fix perf bug 3669930, 4220460, use cached profile option value
3634: fnd_profile.get(
3635: name => k_profile_country_lang,
3636: val => l_language_code
3637: );
3638: */

Line 3642: fnd_profile.get(

3638: */
3639: l_language_code := g_profile_country_lang;
3640: IF l_language_code IS NULL THEN
3641: /* Fix perf bug 3669930, 4220460, use cached profile option value
3642: fnd_profile.get(
3643: name => k_profile_ref_lang,
3644: val => l_language_code
3645: );
3646: */