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.32.12010000.4 2008/11/12 12:42:04 spasala ship $ */
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 1537: FND_LOG.STRING(g_level_statement, 'ZX.PLSQL.ZX_TCM_EXT_SERVICES_PUB.get_fc_country_def_cache_info.BEGIN',

1533: x_return_status := FND_API.G_RET_STS_SUCCESS;
1534: x_found_in_cache := FALSE;
1535:
1536: IF (g_level_statement >= g_current_runtime_level ) THEN
1537: FND_LOG.STRING(g_level_statement, 'ZX.PLSQL.ZX_TCM_EXT_SERVICES_PUB.get_fc_country_def_cache_info.BEGIN',
1538: 'ZX_TCM_EXT_SERVICES_PUB.get_fc_country_def_cache_info(+)');
1539: END IF;
1540:
1541:

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

1534: x_found_in_cache := FALSE;
1535:
1536: IF (g_level_statement >= g_current_runtime_level ) THEN
1537: FND_LOG.STRING(g_level_statement, 'ZX.PLSQL.ZX_TCM_EXT_SERVICES_PUB.get_fc_country_def_cache_info.BEGIN',
1538: 'ZX_TCM_EXT_SERVICES_PUB.get_fc_country_def_cache_info(+)');
1539: END IF;
1540:
1541:
1542: l_index := dbms_utility.get_hash_value(

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

1550: IF ZX_GLOBAL_STRUCTURES_PKG.FC_COUNTRY_DEF_VAL_TBL.EXISTS(l_index)
1551: THEN
1552: IF (g_level_statement >= g_current_runtime_level ) THEN
1553: FND_LOG.STRING(g_level_statement,
1554: 'ZX.PLSQL.LSQL.ZX_TCM_EXT_SERVICES_PUB.get_fc_country_def_cache_info',
1555: 'Default Classification type '||p_classification_type||
1556: ' for country code '||p_country_code||' from cache, at index = ' || to_char(l_index));
1557: END IF;
1558: x_found_in_cache := TRUE;

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

1560:
1561: ELSE
1562: IF (g_level_statement >= g_current_runtime_level ) THEN
1563: FND_LOG.STRING(g_level_statement,
1564: 'ZX.PLSQL.LSQL.ZX_TCM_EXT_SERVICES_PUB.get_fc_country_def_cache_info',
1565: 'Default Classification type '||p_classification_type||
1566: ' for country code '||p_country_code||' not found in cache ');
1567: END IF;
1568:

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

1568:
1569: END IF;
1570:
1571: IF (g_level_statement >= g_current_runtime_level ) THEN
1572: FND_LOG.STRING(g_level_statement, 'ZX.PLSQL.ZX_TCM_EXT_SERVICES_PUB.get_fc_country_def_cache_info.BEGIN',
1573: 'ZX_TCM_EXT_SERVICES_PUB.get_fc_country_def_cache_info(-)');
1574: END IF;
1575:
1576: END get_fc_country_def_cache_info;

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

1569: END IF;
1570:
1571: IF (g_level_statement >= g_current_runtime_level ) THEN
1572: FND_LOG.STRING(g_level_statement, 'ZX.PLSQL.ZX_TCM_EXT_SERVICES_PUB.get_fc_country_def_cache_info.BEGIN',
1573: 'ZX_TCM_EXT_SERVICES_PUB.get_fc_country_def_cache_info(-)');
1574: END IF;
1575:
1576: END get_fc_country_def_cache_info;
1577:

Line 1622: END ZX_TCM_EXT_SERVICES_PUB;

1618: END;
1619: END IF;
1620: END is_territory_code_valid;
1621:
1622: END ZX_TCM_EXT_SERVICES_PUB;