APPS.ZX_TCM_EXT_SERVICES_PUB dependencies on ZX_TCM_EXT_SERVICES_PUB

Line 1: package body ZX_TCM_EXT_SERVICES_PUB AS

1: package body ZX_TCM_EXT_SERVICES_PUB AS
2: /* $Header: zxpservb.pls 120.44.12020000.2 2012/07/23 13:01:46 srajapar noship $ */
3:
4: -- Logging Infra
5: G_CURRENT_RUNTIME_LEVEL NUMBER;

Line 12: G_MODULE_NAME CONSTANT VARCHAR2(40) := 'ZX.PLSQL.ZX_TCM_EXT_SERVICES_PUB.';

8: G_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
9: G_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
10: G_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
11: G_LEVEL_STATEMENT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
12: G_MODULE_NAME CONSTANT VARCHAR2(40) := 'ZX.PLSQL.ZX_TCM_EXT_SERVICES_PUB.';
13:
14: PROCEDURE get_fc_country_def_cache_info (
15: p_country_code IN fnd_territories.territory_code%TYPE,
16: p_classification_type IN varchar2,

Line 1586: FND_LOG.STRING(g_level_statement, 'ZX.PLSQL.ZX_TCM_EXT_SERVICES_PUB.get_fc_country_def_cache_info.BEGIN',

1582: x_return_status := FND_API.G_RET_STS_SUCCESS;
1583: x_found_in_cache := FALSE;
1584:
1585: IF (g_level_statement >= g_current_runtime_level ) THEN
1586: FND_LOG.STRING(g_level_statement, 'ZX.PLSQL.ZX_TCM_EXT_SERVICES_PUB.get_fc_country_def_cache_info.BEGIN',
1587: 'ZX_TCM_EXT_SERVICES_PUB.get_fc_country_def_cache_info(+)');
1588: END IF;
1589:
1590:

Line 1587: 'ZX_TCM_EXT_SERVICES_PUB.get_fc_country_def_cache_info(+)');

1583: x_found_in_cache := FALSE;
1584:
1585: IF (g_level_statement >= g_current_runtime_level ) THEN
1586: FND_LOG.STRING(g_level_statement, 'ZX.PLSQL.ZX_TCM_EXT_SERVICES_PUB.get_fc_country_def_cache_info.BEGIN',
1587: 'ZX_TCM_EXT_SERVICES_PUB.get_fc_country_def_cache_info(+)');
1588: END IF;
1589:
1590:
1591: l_index := dbms_utility.get_hash_value(

Line 1603: 'ZX.PLSQL.LSQL.ZX_TCM_EXT_SERVICES_PUB.get_fc_country_def_cache_info',

1599: IF ZX_GLOBAL_STRUCTURES_PKG.FC_COUNTRY_DEF_VAL_TBL.EXISTS(l_index)
1600: THEN
1601: IF (g_level_statement >= g_current_runtime_level ) THEN
1602: FND_LOG.STRING(g_level_statement,
1603: 'ZX.PLSQL.LSQL.ZX_TCM_EXT_SERVICES_PUB.get_fc_country_def_cache_info',
1604: 'Default Classification type '||p_classification_type||
1605: ' for country code '||p_country_code||' from cache, at index = ' || to_char(l_index));
1606: END IF;
1607: x_found_in_cache := TRUE;

Line 1613: 'ZX.PLSQL.LSQL.ZX_TCM_EXT_SERVICES_PUB.get_fc_country_def_cache_info',

1609:
1610: ELSE
1611: IF (g_level_statement >= g_current_runtime_level ) THEN
1612: FND_LOG.STRING(g_level_statement,
1613: 'ZX.PLSQL.LSQL.ZX_TCM_EXT_SERVICES_PUB.get_fc_country_def_cache_info',
1614: 'Default Classification type '||p_classification_type||
1615: ' for country code '||p_country_code||' not found in cache ');
1616: END IF;
1617:

Line 1621: FND_LOG.STRING(g_level_statement, 'ZX.PLSQL.ZX_TCM_EXT_SERVICES_PUB.get_fc_country_def_cache_info.BEGIN',

1617:
1618: END IF;
1619:
1620: IF (g_level_statement >= g_current_runtime_level ) THEN
1621: FND_LOG.STRING(g_level_statement, 'ZX.PLSQL.ZX_TCM_EXT_SERVICES_PUB.get_fc_country_def_cache_info.BEGIN',
1622: 'ZX_TCM_EXT_SERVICES_PUB.get_fc_country_def_cache_info(-)');
1623: END IF;
1624:
1625: END get_fc_country_def_cache_info;

Line 1622: 'ZX_TCM_EXT_SERVICES_PUB.get_fc_country_def_cache_info(-)');

1618: END IF;
1619:
1620: IF (g_level_statement >= g_current_runtime_level ) THEN
1621: FND_LOG.STRING(g_level_statement, 'ZX.PLSQL.ZX_TCM_EXT_SERVICES_PUB.get_fc_country_def_cache_info.BEGIN',
1622: 'ZX_TCM_EXT_SERVICES_PUB.get_fc_country_def_cache_info(-)');
1623: END IF;
1624:
1625: END get_fc_country_def_cache_info;
1626:

Line 1671: END ZX_TCM_EXT_SERVICES_PUB;

1667: END;
1668: END IF;
1669: END is_territory_code_valid;
1670:
1671: END ZX_TCM_EXT_SERVICES_PUB;