APPS.ZX_LINES_DET_FACTORS_PKG dependencies on ZX_LINES_DET_FACTORS_PKG

Line 1: PACKAGE BODY ZX_LINES_DET_FACTORS_PKG AS

1: PACKAGE BODY ZX_LINES_DET_FACTORS_PKG AS
2: /* $Header: zxiflinedetfactb.pls 120.21 2006/06/28 16:56:04 lxzhang ship $ */
3:
4: /* ======================================================================*
5: | Global Data Types |

Line 8: G_PKG_NAME CONSTANT VARCHAR2(30) := 'ZX_LINES_DET_FACTORS_PKG';

4: /* ======================================================================*
5: | Global Data Types |
6: * ======================================================================*/
7:
8: G_PKG_NAME CONSTANT VARCHAR2(30) := 'ZX_LINES_DET_FACTORS_PKG';
9: G_MSG_UERROR CONSTANT NUMBER := FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR;
10: G_MSG_ERROR CONSTANT NUMBER := FND_MSG_PUB.G_MSG_LVL_ERROR;
11: G_MSG_SUCCESS CONSTANT NUMBER := FND_MSG_PUB.G_MSG_LVL_SUCCESS;
12: G_MSG_HIGH CONSTANT NUMBER := FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH;

Line 24: G_MODULE_NAME CONSTANT VARCHAR2(80) := 'ZX.PLSQL.ZX_LINES_DET_FACTORS_PKG.';

20: G_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
21: G_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
22: G_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
23: G_LEVEL_STATEMENT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
24: G_MODULE_NAME CONSTANT VARCHAR2(80) := 'ZX.PLSQL.ZX_LINES_DET_FACTORS_PKG.';
25:
26: CURSOR get_lines_det_factors(p_transaction_rec ZX_API_PUB.transaction_rec_type) IS
27: SELECT APPLICATION_ID,
28: ENTITY_CODE,

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

75: l_return_status VARCHAR2(1);
76:
77: BEGIN
78: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
79: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.BEGIN','ZX_LINES_DET_FACTORS_PKG: '||l_api_name||'()+');
80: END IF;
81:
82: /*-----------------------------------------+
83: | Initialize return status to SUCCESS |

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

109: AND trx_line_id = p_transaction_line_rec.trx_line_id
110: AND trx_level_type = p_transaction_line_rec.trx_level_type;
111:
112: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
113: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.END','ZX_LINES_DET_FACTORS_PKG: '||l_api_name||'()-');
114: END IF;
115:
116: EXCEPTION
117: WHEN OTHERS THEN

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

142: l_event_class_rec ZX_API_PUB.event_class_rec_type;
143:
144: BEGIN
145: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
146: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.BEGIN','ZX_LINES_DET_FACTORS_PKG: '||l_api_name||'()+');
147: END IF;
148:
149:
150: /*-----------------------------------------+

Line 239: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.END','ZX_LINES_DET_FACTORS_PKG: '||l_api_name||'()-'||' RETURN_STATUS = ' || l_return_status);

235: AND event_class_code = p_transaction_rec.event_class_code
236: AND trx_id = p_transaction_rec.trx_id ;
237:
238: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
239: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.END','ZX_LINES_DET_FACTORS_PKG: '||l_api_name||'()-'||' RETURN_STATUS = ' || l_return_status);
240: END IF;
241:
242: EXCEPTION
243: WHEN OTHERS THEN

Line 302: END ZX_LINES_DET_FACTORS_PKG;

298:
299: END IF;
300: END lock_line_det_factors;
301:
302: END ZX_LINES_DET_FACTORS_PKG;
303: