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.ZX_TCM_PTP_PKG dependencies on ZX_TCM_PTP_PKG

Line 1: PACKAGE BODY ZX_TCM_PTP_PKG AS

1: PACKAGE BODY ZX_TCM_PTP_PKG AS
2: /* $Header: zxcptpb.pls 120.41.12010000.2 2008/11/12 12:21:19 spasala ship $ */
3:
4: -- Logging Infra
5: G_PKG_NAME CONSTANT VARCHAR2(30) := 'ZX_TCM_PTP_PKG';

Line 5: G_PKG_NAME CONSTANT VARCHAR2(30) := 'ZX_TCM_PTP_PKG';

1: PACKAGE BODY ZX_TCM_PTP_PKG AS
2: /* $Header: zxcptpb.pls 120.41.12010000.2 2008/11/12 12:21:19 spasala ship $ */
3:
4: -- Logging Infra
5: G_PKG_NAME CONSTANT VARCHAR2(30) := 'ZX_TCM_PTP_PKG';
6: G_CURRENT_RUNTIME_LEVEL NUMBER;
7: G_LEVEL_UNEXPECTED CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
8: G_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
9: G_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;

Line 13: G_MODULE_NAME CONSTANT VARCHAR2(30) := 'ZX.PLSQL.ZX_TCM_PTP_PKG';

9: G_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
10: G_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
11: G_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
12: G_LEVEL_STATEMENT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
13: G_MODULE_NAME CONSTANT VARCHAR2(30) := 'ZX.PLSQL.ZX_TCM_PTP_PKG';
14:
15: TYPE l_ptp_id_rec_type IS RECORD(
16: le_id NUMBER,
17: party_type_code VARCHAR2(240),

Line 1510: FND_LOG.STRING(G_LEVEL_STATEMENT,'ZX_TCM_PTP_PKG.GET_PARTY_TAX_PROF_INFO', l_log_msg);

1506:
1507: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1508: l_log_msg := 'Party Tax Profile Id info for party_id: '||to_char(p_party_id)||' and party_type_code '
1509: ||p_party_type_code||' found in cache at index: '||to_char(l_tbl_index);
1510: FND_LOG.STRING(G_LEVEL_STATEMENT,'ZX_TCM_PTP_PKG.GET_PARTY_TAX_PROF_INFO', l_log_msg);
1511: END IF;
1512:
1513: X_TBL_INDEX := l_tbl_index;
1514: RETURN;

Line 1556: l_log_msg := 'No Data found in ZX_TCM_PTP_PKG.GET_PARTY_TAX_PROF_INFO. Still returning with success';

1552:
1553: EXCEPTION
1554: WHEN no_data_found then
1555: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
1556: l_log_msg := 'No Data found in ZX_TCM_PTP_PKG.GET_PARTY_TAX_PROF_INFO. Still returning with success';
1557: FND_LOG.STRING(G_LEVEL_PROCEDURE,'ZX_TCM_PTP_PKG.GET_PARTY_TAX_PROF_INFO', l_log_msg);
1558: END IF;
1559: X_TBL_INDEX := NULL;
1560: WHEN others then

Line 1557: FND_LOG.STRING(G_LEVEL_PROCEDURE,'ZX_TCM_PTP_PKG.GET_PARTY_TAX_PROF_INFO', l_log_msg);

1553: EXCEPTION
1554: WHEN no_data_found then
1555: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
1556: l_log_msg := 'No Data found in ZX_TCM_PTP_PKG.GET_PARTY_TAX_PROF_INFO. Still returning with success';
1557: FND_LOG.STRING(G_LEVEL_PROCEDURE,'ZX_TCM_PTP_PKG.GET_PARTY_TAX_PROF_INFO', l_log_msg);
1558: END IF;
1559: X_TBL_INDEX := NULL;
1560: WHEN others then
1561: IF ( G_LEVEL_UNEXPECTED >= G_CURRENT_RUNTIME_LEVEL) THEN

Line 1562: l_log_msg := 'Unexpected error in ZX_TCM_PTP_PKG.GET_PARTY_TAX_PROF_INFO: '||SQLCODE||' ; '||SQLERRM;

1558: END IF;
1559: X_TBL_INDEX := NULL;
1560: WHEN others then
1561: IF ( G_LEVEL_UNEXPECTED >= G_CURRENT_RUNTIME_LEVEL) THEN
1562: l_log_msg := 'Unexpected error in ZX_TCM_PTP_PKG.GET_PARTY_TAX_PROF_INFO: '||SQLCODE||' ; '||SQLERRM;
1563: FND_LOG.STRING(G_LEVEL_UNEXPECTED,'ZX_TCM_PTP_PKG.GET_PARTY_TAX_PROF_INFO', l_log_msg);
1564: END IF;
1565:
1566: END GET_PARTY_TAX_PROF_INFO;

Line 1563: FND_LOG.STRING(G_LEVEL_UNEXPECTED,'ZX_TCM_PTP_PKG.GET_PARTY_TAX_PROF_INFO', l_log_msg);

1559: X_TBL_INDEX := NULL;
1560: WHEN others then
1561: IF ( G_LEVEL_UNEXPECTED >= G_CURRENT_RUNTIME_LEVEL) THEN
1562: l_log_msg := 'Unexpected error in ZX_TCM_PTP_PKG.GET_PARTY_TAX_PROF_INFO: '||SQLCODE||' ; '||SQLERRM;
1563: FND_LOG.STRING(G_LEVEL_UNEXPECTED,'ZX_TCM_PTP_PKG.GET_PARTY_TAX_PROF_INFO', l_log_msg);
1564: END IF;
1565:
1566: END GET_PARTY_TAX_PROF_INFO;
1567:

Line 1615: FND_LOG.STRING(G_LEVEL_STATEMENT,'ZX_TCM_PTP_PKG.GET_PARTY_TAX_PROF_INFO', l_log_msg);

1611: THEN
1612:
1613: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1614: l_log_msg := 'Party Tax Profile Id info found in cache ';
1615: FND_LOG.STRING(G_LEVEL_STATEMENT,'ZX_TCM_PTP_PKG.GET_PARTY_TAX_PROF_INFO', l_log_msg);
1616: END IF;
1617:
1618: X_TBL_INDEX := p_party_tax_profile_id;
1619: RETURN;

Line 1663: l_log_msg := 'No Data found in ZX_TCM_PTP_PKG.GET_PARTY_TAX_PROF_INFO. Still returning with success';

1659: EXCEPTION
1660:
1661: WHEN no_data_found then
1662: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
1663: l_log_msg := 'No Data found in ZX_TCM_PTP_PKG.GET_PARTY_TAX_PROF_INFO. Still returning with success';
1664: FND_LOG.STRING(G_LEVEL_PROCEDURE,'ZX_TCM_PTP_PKG.GET_PARTY_TAX_PROF_INFO', l_log_msg);
1665: END IF;
1666: X_TBL_INDEX := NULL;
1667:

Line 1664: FND_LOG.STRING(G_LEVEL_PROCEDURE,'ZX_TCM_PTP_PKG.GET_PARTY_TAX_PROF_INFO', l_log_msg);

1660:
1661: WHEN no_data_found then
1662: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
1663: l_log_msg := 'No Data found in ZX_TCM_PTP_PKG.GET_PARTY_TAX_PROF_INFO. Still returning with success';
1664: FND_LOG.STRING(G_LEVEL_PROCEDURE,'ZX_TCM_PTP_PKG.GET_PARTY_TAX_PROF_INFO', l_log_msg);
1665: END IF;
1666: X_TBL_INDEX := NULL;
1667:
1668: WHEN others then

Line 1670: l_log_msg := 'Unexpected error in ZX_TCM_PTP_PKG.GET_PARTY_TAX_PROF_INFO: '||SQLCODE||' ; '||SQLERRM;

1666: X_TBL_INDEX := NULL;
1667:
1668: WHEN others then
1669: IF ( G_LEVEL_UNEXPECTED >= G_CURRENT_RUNTIME_LEVEL) THEN
1670: l_log_msg := 'Unexpected error in ZX_TCM_PTP_PKG.GET_PARTY_TAX_PROF_INFO: '||SQLCODE||' ; '||SQLERRM;
1671: FND_LOG.STRING(G_LEVEL_UNEXPECTED,'ZX_TCM_PTP_PKG.GET_PARTY_TAX_PROF_INFO', l_log_msg);
1672: END IF;
1673:
1674: END GET_PARTY_TAX_PROF_INFO;

Line 1671: FND_LOG.STRING(G_LEVEL_UNEXPECTED,'ZX_TCM_PTP_PKG.GET_PARTY_TAX_PROF_INFO', l_log_msg);

1667:
1668: WHEN others then
1669: IF ( G_LEVEL_UNEXPECTED >= G_CURRENT_RUNTIME_LEVEL) THEN
1670: l_log_msg := 'Unexpected error in ZX_TCM_PTP_PKG.GET_PARTY_TAX_PROF_INFO: '||SQLCODE||' ; '||SQLERRM;
1671: FND_LOG.STRING(G_LEVEL_UNEXPECTED,'ZX_TCM_PTP_PKG.GET_PARTY_TAX_PROF_INFO', l_log_msg);
1672: END IF;
1673:
1674: END GET_PARTY_TAX_PROF_INFO;
1675:

Line 1677: END ZX_TCM_PTP_PKG;

1673:
1674: END GET_PARTY_TAX_PROF_INFO;
1675:
1676:
1677: END ZX_TCM_PTP_PKG;