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_LOG

Line 1580: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

1576: p_country_name_lang => l_country_name_lang
1577: );
1578:
1579: --log the context
1580: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
1581: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'ar.hz.plsql','ADDRESS FORMAT:p_country:' || p_country);
1582: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'ar.hz.plsql','ADDRESS FORMAT:l_style_code:' || l_style_code);
1583: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'ar.hz.plsql','ADDRESS FORMAT:l_style_format_code:' || l_style_format_code);
1584: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'ar.hz.plsql','ADDRESS FORMAT:l_to_territory_code:' || l_to_territory_code);

Line 1581: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'ar.hz.plsql','ADDRESS FORMAT:p_country:' || p_country);

1577: );
1578:
1579: --log the context
1580: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
1581: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'ar.hz.plsql','ADDRESS FORMAT:p_country:' || p_country);
1582: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'ar.hz.plsql','ADDRESS FORMAT:l_style_code:' || l_style_code);
1583: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'ar.hz.plsql','ADDRESS FORMAT:l_style_format_code:' || l_style_format_code);
1584: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'ar.hz.plsql','ADDRESS FORMAT:l_to_territory_code:' || l_to_territory_code);
1585: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'ar.hz.plsql','ADDRESS FORMAT:l_to_language_code:' || l_to_language_code);

Line 1582: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'ar.hz.plsql','ADDRESS FORMAT:l_style_code:' || l_style_code);

1578:
1579: --log the context
1580: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
1581: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'ar.hz.plsql','ADDRESS FORMAT:p_country:' || p_country);
1582: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'ar.hz.plsql','ADDRESS FORMAT:l_style_code:' || l_style_code);
1583: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'ar.hz.plsql','ADDRESS FORMAT:l_style_format_code:' || l_style_format_code);
1584: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'ar.hz.plsql','ADDRESS FORMAT:l_to_territory_code:' || l_to_territory_code);
1585: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'ar.hz.plsql','ADDRESS FORMAT:l_to_language_code:' || l_to_language_code);
1586: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'ar.hz.plsql','ADDRESS FORMAT:l_from_territory_code:' || l_from_territory_code);

Line 1583: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'ar.hz.plsql','ADDRESS FORMAT:l_style_format_code:' || l_style_format_code);

1579: --log the context
1580: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
1581: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'ar.hz.plsql','ADDRESS FORMAT:p_country:' || p_country);
1582: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'ar.hz.plsql','ADDRESS FORMAT:l_style_code:' || l_style_code);
1583: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'ar.hz.plsql','ADDRESS FORMAT:l_style_format_code:' || l_style_format_code);
1584: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'ar.hz.plsql','ADDRESS FORMAT:l_to_territory_code:' || l_to_territory_code);
1585: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'ar.hz.plsql','ADDRESS FORMAT:l_to_language_code:' || l_to_language_code);
1586: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'ar.hz.plsql','ADDRESS FORMAT:l_from_territory_code:' || l_from_territory_code);
1587: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'ar.hz.plsql','ADDRESS FORMAT:l_from_language_code:' || l_from_language_code);

Line 1584: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'ar.hz.plsql','ADDRESS FORMAT:l_to_territory_code:' || l_to_territory_code);

1580: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
1581: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'ar.hz.plsql','ADDRESS FORMAT:p_country:' || p_country);
1582: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'ar.hz.plsql','ADDRESS FORMAT:l_style_code:' || l_style_code);
1583: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'ar.hz.plsql','ADDRESS FORMAT:l_style_format_code:' || l_style_format_code);
1584: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'ar.hz.plsql','ADDRESS FORMAT:l_to_territory_code:' || l_to_territory_code);
1585: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'ar.hz.plsql','ADDRESS FORMAT:l_to_language_code:' || l_to_language_code);
1586: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'ar.hz.plsql','ADDRESS FORMAT:l_from_territory_code:' || l_from_territory_code);
1587: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'ar.hz.plsql','ADDRESS FORMAT:l_from_language_code:' || l_from_language_code);
1588: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'ar.hz.plsql','ADDRESS FORMAT:l_country_name_lang:' || l_country_name_lang);

Line 1585: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'ar.hz.plsql','ADDRESS FORMAT:l_to_language_code:' || l_to_language_code);

1581: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'ar.hz.plsql','ADDRESS FORMAT:p_country:' || p_country);
1582: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'ar.hz.plsql','ADDRESS FORMAT:l_style_code:' || l_style_code);
1583: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'ar.hz.plsql','ADDRESS FORMAT:l_style_format_code:' || l_style_format_code);
1584: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'ar.hz.plsql','ADDRESS FORMAT:l_to_territory_code:' || l_to_territory_code);
1585: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'ar.hz.plsql','ADDRESS FORMAT:l_to_language_code:' || l_to_language_code);
1586: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'ar.hz.plsql','ADDRESS FORMAT:l_from_territory_code:' || l_from_territory_code);
1587: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'ar.hz.plsql','ADDRESS FORMAT:l_from_language_code:' || l_from_language_code);
1588: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'ar.hz.plsql','ADDRESS FORMAT:l_country_name_lang:' || l_country_name_lang);
1589: end if;

Line 1586: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'ar.hz.plsql','ADDRESS FORMAT:l_from_territory_code:' || l_from_territory_code);

1582: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'ar.hz.plsql','ADDRESS FORMAT:l_style_code:' || l_style_code);
1583: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'ar.hz.plsql','ADDRESS FORMAT:l_style_format_code:' || l_style_format_code);
1584: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'ar.hz.plsql','ADDRESS FORMAT:l_to_territory_code:' || l_to_territory_code);
1585: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'ar.hz.plsql','ADDRESS FORMAT:l_to_language_code:' || l_to_language_code);
1586: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'ar.hz.plsql','ADDRESS FORMAT:l_from_territory_code:' || l_from_territory_code);
1587: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'ar.hz.plsql','ADDRESS FORMAT:l_from_language_code:' || l_from_language_code);
1588: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'ar.hz.plsql','ADDRESS FORMAT:l_country_name_lang:' || l_country_name_lang);
1589: end if;
1590: --

Line 1587: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'ar.hz.plsql','ADDRESS FORMAT:l_from_language_code:' || l_from_language_code);

1583: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'ar.hz.plsql','ADDRESS FORMAT:l_style_format_code:' || l_style_format_code);
1584: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'ar.hz.plsql','ADDRESS FORMAT:l_to_territory_code:' || l_to_territory_code);
1585: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'ar.hz.plsql','ADDRESS FORMAT:l_to_language_code:' || l_to_language_code);
1586: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'ar.hz.plsql','ADDRESS FORMAT:l_from_territory_code:' || l_from_territory_code);
1587: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'ar.hz.plsql','ADDRESS FORMAT:l_from_language_code:' || l_from_language_code);
1588: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'ar.hz.plsql','ADDRESS FORMAT:l_country_name_lang:' || l_country_name_lang);
1589: end if;
1590: --
1591: -- Load a PL/SQL mapping table so that we can access

Line 1588: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'ar.hz.plsql','ADDRESS FORMAT:l_country_name_lang:' || l_country_name_lang);

1584: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'ar.hz.plsql','ADDRESS FORMAT:l_to_territory_code:' || l_to_territory_code);
1585: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'ar.hz.plsql','ADDRESS FORMAT:l_to_language_code:' || l_to_language_code);
1586: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'ar.hz.plsql','ADDRESS FORMAT:l_from_territory_code:' || l_from_territory_code);
1587: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'ar.hz.plsql','ADDRESS FORMAT:l_from_language_code:' || l_from_language_code);
1588: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'ar.hz.plsql','ADDRESS FORMAT:l_country_name_lang:' || l_country_name_lang);
1589: end if;
1590: --
1591: -- Load a PL/SQL mapping table so that we can access
1592: -- the parameter values dynamically

Line 1624: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

1620:
1621: -- bug 3636389, county field for US address create/update
1622: -- temp workaround of the design/data model issue
1623: -- log the variation number
1624: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
1625: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'ar.hz.plsql','ADDRESS FORMAT: returned l_variation_num: ' || l_variation_num);
1626: end if;
1627:
1628: if(p_country = 'US') then

Line 1625: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'ar.hz.plsql','ADDRESS FORMAT: returned l_variation_num: ' || l_variation_num);

1621: -- bug 3636389, county field for US address create/update
1622: -- temp workaround of the design/data model issue
1623: -- log the variation number
1624: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
1625: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'ar.hz.plsql','ADDRESS FORMAT: returned l_variation_num: ' || l_variation_num);
1626: end if;
1627:
1628: if(p_country = 'US') then
1629: l_sql_string := 'select count(1) from HZ_STYLE_FMT_VARIATIONS ' ||

Line 1648: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

1644: l_variation_num := 2; --with county
1645: end if;
1646: end if;
1647: -- log the variation number
1648: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
1649: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'ar.hz.plsql','ADDRESS FORMAT: using l_variation_num: ' || l_variation_num);
1650: end if;
1651: --
1652: -- Load the format layout database table into

Line 1649: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'ar.hz.plsql','ADDRESS FORMAT: using l_variation_num: ' || l_variation_num);

1645: end if;
1646: end if;
1647: -- log the variation number
1648: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
1649: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'ar.hz.plsql','ADDRESS FORMAT: using l_variation_num: ' || l_variation_num);
1650: end if;
1651: --
1652: -- Load the format layout database table into
1653: -- an internal pl/sql table.

Line 3359: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

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
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);

Line 3363: p_msg_level=>fnd_log.level_procedure);

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;
3365:
3366: --Now checking ICX_TERRITORY profile option
3367:

Line 3374: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

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, ' ||
3376: 'Profile option ICX_TERRITORY = ' || l_nls_territory,
3377: p_prefix=>'',
3378: p_msg_level=>fnd_log.level_procedure);

Line 3378: p_msg_level=>fnd_log.level_procedure);

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;
3380:
3381: if l_nls_territory is not null then
3382: select territory_code into l_territory_code

Line 3389: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

3385: and OBSOLETE_FLAG = 'N'
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);

Line 3393: p_msg_level=>fnd_log.level_procedure);

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;
3395:
3396:
3397: END IF;

Line 3421: p_msg_level=>fnd_log.level_procedure);

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;
3423: END IF;
3424:
3425: --

Line 3470: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

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:
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=>'',

Line 3475: p_msg_level=>fnd_log.level_procedure);

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;
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.

Line 3485: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

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
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=>'',

Line 3490: p_msg_level=>fnd_log.level_procedure);

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;
3492:
3493:
3494: if l_nls_territory is not null then

Line 3501: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

3497: where nls_territory = l_nls_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);

Line 3505: p_msg_level=>fnd_log.level_procedure);

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;
3507:
3508:
3509:

Line 3534: p_msg_level=>fnd_log.level_procedure);

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;
3536: END IF;
3537:
3538: x_ref_territory_code := l_territory_code;