DBA Data[Home] [Help]

APPS.ZX_TRX_LINE_APP_REGIMES_PKG dependencies on FND_LOG

Line 4: G_CURRENT_RUNTIME_LEVEL CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

1: PACKAGE BODY ZX_TRX_LINE_APP_REGIMES_PKG AS
2: /* $Header: zxiflineappregb.pls 120.3 2009/06/05 18:56:59 hongliu ship $ */
3: G_PKG_NAME CONSTANT VARCHAR2(30) := 'ZX_TRX_LINE_APP_REGIMES_PKG';
4: G_CURRENT_RUNTIME_LEVEL CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
5: G_LEVEL_UNEXPECTED CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
6: G_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
7: G_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
8: G_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;

Line 5: G_LEVEL_UNEXPECTED CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;

1: PACKAGE BODY ZX_TRX_LINE_APP_REGIMES_PKG AS
2: /* $Header: zxiflineappregb.pls 120.3 2009/06/05 18:56:59 hongliu ship $ */
3: G_PKG_NAME CONSTANT VARCHAR2(30) := 'ZX_TRX_LINE_APP_REGIMES_PKG';
4: G_CURRENT_RUNTIME_LEVEL CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
5: G_LEVEL_UNEXPECTED CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
6: G_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
7: G_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
8: G_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
9: G_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;

Line 6: G_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;

2: /* $Header: zxiflineappregb.pls 120.3 2009/06/05 18:56:59 hongliu ship $ */
3: G_PKG_NAME CONSTANT VARCHAR2(30) := 'ZX_TRX_LINE_APP_REGIMES_PKG';
4: G_CURRENT_RUNTIME_LEVEL CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
5: G_LEVEL_UNEXPECTED CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
6: G_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
7: G_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
8: G_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
9: G_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
10: G_LEVEL_STATEMENT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;

Line 7: G_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;

3: G_PKG_NAME CONSTANT VARCHAR2(30) := 'ZX_TRX_LINE_APP_REGIMES_PKG';
4: G_CURRENT_RUNTIME_LEVEL CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
5: G_LEVEL_UNEXPECTED CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
6: G_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
7: G_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
8: G_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
9: G_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
10: G_LEVEL_STATEMENT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
11: G_MODULE_NAME CONSTANT VARCHAR2(80) := 'ZX.PLSQL.ZX_TRX_LINE_APP_REGIMES_PKG.';

Line 8: G_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;

4: G_CURRENT_RUNTIME_LEVEL CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
5: G_LEVEL_UNEXPECTED CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
6: G_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
7: G_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
8: G_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
9: G_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
10: G_LEVEL_STATEMENT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
11: G_MODULE_NAME CONSTANT VARCHAR2(80) := 'ZX.PLSQL.ZX_TRX_LINE_APP_REGIMES_PKG.';
12:

Line 9: G_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;

5: G_LEVEL_UNEXPECTED CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
6: G_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
7: G_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
8: G_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
9: G_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
10: G_LEVEL_STATEMENT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
11: G_MODULE_NAME CONSTANT VARCHAR2(80) := 'ZX.PLSQL.ZX_TRX_LINE_APP_REGIMES_PKG.';
12:
13: procedure INSERT_ROW (

Line 10: G_LEVEL_STATEMENT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;

6: G_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
7: G_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
8: G_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
9: G_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
10: G_LEVEL_STATEMENT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
11: G_MODULE_NAME CONSTANT VARCHAR2(80) := 'ZX.PLSQL.ZX_TRX_LINE_APP_REGIMES_PKG.';
12:
13: procedure INSERT_ROW (
14: X_APPLICATION_ID in NUMBER,

Line 36: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.BEGIN','ZX_TRX_LINE_APP_REGIMES_PKG: '||l_api_name||'()+');

32: l_api_name CONSTANT VARCHAR2(30) := 'INSERT_ROW';
33: BEGIN
34:
35: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN
36: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.BEGIN','ZX_TRX_LINE_APP_REGIMES_PKG: '||l_api_name||'()+');
37: END IF;
38:
39: x_return_status := FND_API.G_RET_STS_SUCCESS;
40:

Line 82: FND_LOG.STRING(G_LEVEL_EXCEPTION,

78: if (sql%notfound) then
79: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
80:
81: IF ( G_LEVEL_EXCEPTION >= G_CURRENT_RUNTIME_LEVEL) THEN
82: FND_LOG.STRING(G_LEVEL_EXCEPTION,
83: G_MODULE_NAME || l_api_name,
84: SQLCODE || ': ' || SQLERRM);
85: END IF;
86:

Line 91: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.END','ZX_TRX_LINE_APP_REGIMES_PKG: '||l_api_name||'()-');

87: raise no_data_found;
88: end if;
89:
90: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN
91: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.END','ZX_TRX_LINE_APP_REGIMES_PKG: '||l_api_name||'()-');
92: END IF;
93: end INSERT_ROW;
94:
95: procedure UPDATE_ROW (

Line 116: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.BEGIN','ZX_TRX_LINE_APP_REGIMES_PKG: '||l_api_name||'()+');

112: ) is
113: l_api_name CONSTANT VARCHAR2(30) := 'UPDATE_ROW';
114: begin
115: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN
116: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.BEGIN','ZX_TRX_LINE_APP_REGIMES_PKG: '||l_api_name||'()+');
117: END IF;
118:
119: x_return_status := FND_API.G_RET_STS_SUCCESS;
120:

Line 144: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.BEGIN','ZX_TRX_LINE_APP_REGIMES_PKG: '||l_api_name||'()+');

140: raise no_data_found;
141: end if;
142:
143: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN
144: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.BEGIN','ZX_TRX_LINE_APP_REGIMES_PKG: '||l_api_name||'()+');
145: END IF;
146:
147: end UPDATE_ROW;
148: