APPS.HZ_FORMAT_PUB dependencies on HZ_FORMAT_PUB

Line 1: PACKAGE BODY hz_format_pub AS

1: PACKAGE BODY hz_format_pub AS
2: /*$Header: ARHPFMTB.pls 120.24.12010000.2 2008/09/16 11:12:02 rgokavar ship $ */
3:
4: /*=========================================================================+
5: |

Line 90: g_pkg_name VARCHAR2(30) := 'hz_format_pub';

86: --terr_short_name_tab var_indexed_table;
87:
88: /******************** PACKAGE GLOBAL VARIABLES ****************************/
89:
90: g_pkg_name VARCHAR2(30) := 'hz_format_pub';
91:
92: g_caching BOOLEAN := TRUE;
93: g_cache_style_format_code hz_style_formats_b.style_format_code%TYPE;
94: g_cache_variation_number NUMBER;

Line 3360: hz_utility_v2pub.debug(p_message=>'HZ_FORMAT_PUB.get_default_ref_territory, ' ||

3356:
3357: -- Debug HZ_REF_TERRITORY
3358:
3359: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3360: hz_utility_v2pub.debug(p_message=>'HZ_FORMAT_PUB.get_default_ref_territory, ' ||
3361: 'Profile option HZ_REF_TERRITORY = ' || l_territory_code,
3362: p_prefix=>'',
3363: p_msg_level=>fnd_log.level_procedure);
3364: END IF;

Line 3375: hz_utility_v2pub.debug(p_message=>'HZ_FORMAT_PUB.get_default_ref_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, ' ||
3376: 'Profile option ICX_TERRITORY = ' || l_nls_territory,
3377: p_prefix=>'',
3378: p_msg_level=>fnd_log.level_procedure);
3379: END IF;

Line 3390: hz_utility_v2pub.debug(p_message=>'HZ_FORMAT_PUB.get_default_ref_territory, ' ||

3386: and rownum = 1;
3387: end if;
3388:
3389: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3390: hz_utility_v2pub.debug(p_message=>'HZ_FORMAT_PUB.get_default_ref_territory, ' ||
3391: 'TERRITORY_CODE = ' || l_territory_code,
3392: p_prefix=>'',
3393: p_msg_level=>fnd_log.level_procedure);
3394: END IF;

Line 3418: hz_utility_v2pub.debug(p_message=>'HZ_FORMAT_PUB.get_default_ref_territory,'||

3414: l_territory_code := g_territory_code;
3415: end if;
3416: EXCEPTION
3417: WHEN NO_DATA_FOUND THEN
3418: hz_utility_v2pub.debug(p_message=>'HZ_FORMAT_PUB.get_default_ref_territory,'||
3419: 'NO_DATA_FOUND Error from query',
3420: p_prefix=>'',
3421: p_msg_level=>fnd_log.level_procedure);
3422: END;

Line 3472: hz_utility_v2pub.debug(p_message=>'HZ_FORMAT_PUB.get_default_eloc_ref_territory, ' ||

3468:
3469:
3470: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3471:
3472: hz_utility_v2pub.debug(p_message=>'HZ_FORMAT_PUB.get_default_eloc_ref_territory, ' ||
3473: 'Profile option HZ_REF_TERRITORY = ' ||l_territory_code,
3474: p_prefix=>'',
3475: p_msg_level=>fnd_log.level_procedure);
3476: END IF;

Line 3487: hz_utility_v2pub.debug(p_message=>'HZ_FORMAT_PUB.get_default_eloc_ref_territory, ' ||

3483: -- Debug ICX_TERRITORY value
3484: --
3485: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3486:
3487: hz_utility_v2pub.debug(p_message=>'HZ_FORMAT_PUB.get_default_eloc_ref_territory, ' ||
3488: 'Profile option ICX_TERRITORY = ' || l_nls_territory,
3489: p_prefix=>'',
3490: p_msg_level=>fnd_log.level_procedure);
3491: END IF;

Line 3502: hz_utility_v2pub.debug(p_message=>'HZ_FORMAT_PUB.get_default_eloc_ref_territory, ' ||

3498: and OBSOLETE_FLAG = 'N'
3499: and rownum = 1;
3500: end if;
3501: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3502: hz_utility_v2pub.debug(p_message=>'HZ_FORMAT_PUB.get_default_eloc_ref_territory, ' ||
3503: 'TERRITORY_CODE = ' || l_territory_code,
3504: p_prefix=>'',
3505: p_msg_level=>fnd_log.level_procedure);
3506: END IF;

Line 3531: hz_utility_v2pub.debug(p_message=>'HZ_FORMAT_PUB.get_default_eloc_ref_territory,'||

3527: l_territory_code := g_territory_code;
3528: end if;
3529: EXCEPTION
3530: WHEN NO_DATA_FOUND THEN
3531: hz_utility_v2pub.debug(p_message=>'HZ_FORMAT_PUB.get_default_eloc_ref_territory,'||
3532: 'NO_DATA_FOUND Error from query',
3533: p_prefix=>'',
3534: p_msg_level=>fnd_log.level_procedure);
3535: END;

Line 4375: END hz_format_pub;

4371: g_context.from_language_code := p_from_language_code;
4372: g_context.country_name_lang := p_country_name_lang;
4373: END;
4374:
4375: END hz_format_pub;