DBA Data[Home] [Help]

APPS.ZX_DETERMINING_FACTORS_PKG dependencies on FND_LOG

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

1: package body ZX_DETERMINING_FACTORS_PKG as
2: /* $Header: zxritrldetfactb.pls 120.14 2005/11/01 23:51:58 rsanthan ship $ */
3:
4: g_current_runtime_level CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
5: g_level_statement CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
6: g_level_procedure CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
7: g_level_event CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
8: g_level_unexpected CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;

Line 5: g_level_statement CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;

1: package body ZX_DETERMINING_FACTORS_PKG as
2: /* $Header: zxritrldetfactb.pls 120.14 2005/11/01 23:51:58 rsanthan ship $ */
3:
4: g_current_runtime_level CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
5: g_level_statement CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
6: g_level_procedure CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
7: g_level_event CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
8: g_level_unexpected CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
9:

Line 6: g_level_procedure CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;

2: /* $Header: zxritrldetfactb.pls 120.14 2005/11/01 23:51:58 rsanthan ship $ */
3:
4: g_current_runtime_level CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
5: g_level_statement CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
6: g_level_procedure CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
7: g_level_event CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
8: g_level_unexpected CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
9:
10: PROCEDURE INSERT_ROW

Line 7: g_level_event CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;

3:
4: g_current_runtime_level CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
5: g_level_statement CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
6: g_level_procedure CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
7: g_level_event CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
8: g_level_unexpected CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
9:
10: PROCEDURE INSERT_ROW
11: (X_ROWID IN OUT NOCOPY VARCHAR2,

Line 8: g_level_unexpected CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;

4: g_current_runtime_level CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
5: g_level_statement CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
6: g_level_procedure CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
7: g_level_event CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
8: g_level_unexpected CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
9:
10: PROCEDURE INSERT_ROW
11: (X_ROWID IN OUT NOCOPY VARCHAR2,
12: X_DETERMINING_FACTOR_ID NUMBER,

Line 44: FND_LOG.STRING(g_level_procedure,

40: WHERE DETERMINING_FACTOR_ID = X_DETERMINING_FACTOR_ID;
41:
42: BEGIN
43: IF (g_level_procedure >= g_current_runtime_level ) THEN
44: FND_LOG.STRING(g_level_procedure,
45: 'ZX.PLSQL.ZX_DETERMINING_FACTORS_PKG.INSERT_ROW.BEGIN',
46: 'ZX_DETERMINING_FACTORS_PKG.INSERT_ROW (+)');
47: END IF;
48:

Line 130: FND_LOG.STRING(g_level_procedure,

126: END IF;
127: CLOSE C;
128:
129: IF (g_level_procedure >= g_current_runtime_level ) THEN
130: FND_LOG.STRING(g_level_procedure,
131: 'ZX.PLSQL.ZX_DETERMINING_FACTORS_PKG.INSERT_ROW.END',
132: 'ZX_DETERMINING_FACTORS_PKG.INSERT_ROW (-)');
133: END IF;
134: END INSERT_ROW;

Line 190: FND_LOG.STRING(g_level_procedure,

186: FOR UPDATE OF DETERMINING_FACTOR_ID NOWAIT;
187:
188: BEGIN
189: IF (g_level_procedure >= g_current_runtime_level ) THEN
190: FND_LOG.STRING(g_level_procedure,
191: 'ZX.PLSQL.ZX_DETERMINING_FACTORS_PKG.LOCK_ROW.BEGIN',
192: 'ZX_DETERMINING_FACTORS_PKG.LOCK_ROW (+)');
193: END IF;
194:

Line 262: FND_LOG.STRING(g_level_procedure,

258: END IF;
259: END LOOP;
260:
261: IF (g_level_procedure >= g_current_runtime_level ) THEN
262: FND_LOG.STRING(g_level_procedure,
263: 'ZX.PLSQL.ZX_DETERMINING_FACTORS_PKG.LOCK_ROW.END',
264: 'ZX_DETERMINING_FACTORS_PKG.LOCK_ROW (-)');
265: END IF;
266:

Line 296: FND_LOG.STRING(g_level_procedure,

292: X_OBJECT_VERSION_NUMBER NUMBER) IS
293:
294: BEGIN
295: IF (g_level_procedure >= g_current_runtime_level ) THEN
296: FND_LOG.STRING(g_level_procedure,
297: 'ZX.PLSQL.ZX_DETERMINING_FACTORS_PKG.UPDATE_ROW.BEGIN',
298: 'ZX_DETERMINING_FACTORS_PKG.UPDATE_ROW (+)');
299: END IF;
300:

Line 342: FND_LOG.STRING(g_level_procedure,

338: RAISE NO_DATA_FOUND;
339: END IF;
340:
341: IF (g_level_procedure >= g_current_runtime_level ) THEN
342: FND_LOG.STRING(g_level_procedure,
343: 'ZX.PLSQL.ZX_DETERMINING_FACTORS_PKG.UPDATE_ROW.END',
344: 'ZX_DETERMINING_FACTORS_PKG.UPDATE_ROW (-)');
345: END IF;
346:

Line 354: FND_LOG.STRING(g_level_procedure,

350: (X_DETERMINING_FACTOR_ID NUMBER) IS
351:
352: BEGIN
353: IF (g_level_procedure >= g_current_runtime_level ) THEN
354: FND_LOG.STRING(g_level_procedure,
355: 'ZX.PLSQL.ZX_DETERMINING_FACTORS_PKG.DELETE_ROW.BEGIN',
356: 'ZX_DETERMINING_FACTORS_PKG.DELETE_ROW (+)');
357: END IF;
358:

Line 374: FND_LOG.STRING(g_level_procedure,

370: RAISE NO_DATA_FOUND;
371: END IF;
372:
373: IF (g_level_procedure >= g_current_runtime_level ) THEN
374: FND_LOG.STRING(g_level_procedure,
375: 'ZX.PLSQL.ZX_DETERMINING_FACTORS_PKG.DELETE_ROW.END',
376: 'ZX_DETERMINING_FACTORS_PKG.DELETE_ROW (-)');
377: END IF;
378:

Line 385: FND_LOG.STRING(g_level_procedure,

381: PROCEDURE ADD_LANGUAGE IS
382:
383: BEGIN
384: IF (g_level_procedure >= g_current_runtime_level ) THEN
385: FND_LOG.STRING(g_level_procedure,
386: 'ZX.PLSQL.ZX_DETERMINING_FACTORS_PKG.ADD_LANGUAGE.BEGIN',
387: 'ZX_DETERMINING_FACTORS_PKG.ADD_LANGUAGE (+)');
388: END IF;
389:

Line 447: FND_LOG.STRING(g_level_procedure,

443: WHERE T.DETERMINING_FACTOR_ID = B.DETERMINING_FACTOR_ID
444: AND T.LANGUAGE = L.LANGUAGE_CODE);
445:
446: IF (g_level_procedure >= g_current_runtime_level ) THEN
447: FND_LOG.STRING(g_level_procedure,
448: 'ZX.PLSQL.ZX_DETERMINING_FACTORS_PKG.ADD_LANGUAGE.END',
449: 'ZX_DETERMINING_FACTORS_PKG.ADD_LANGUAGE (-)');
450: END IF;
451:

Line 468: FND_LOG.STRING(g_level_procedure,

464: WHERE DETERMINING_FACTOR_CLASS_CODE = X_DETERMINING_FACTOR_CLASS_COD
465: AND DETERMINING_FACTOR_CODE = X_DETERMINING_FACTOR_CODE;
466: BEGIN
467: IF (g_level_procedure >= g_current_runtime_level ) THEN
468: FND_LOG.STRING(g_level_procedure,
469: 'ZX.PLSQL.ZX_DETERMINING_FACTORS_PKG.INSERT_GEOGRAPHY_ROW.BEGIN',
470: 'ZX_DETERMINING_FACTORS_PKG.INSERT_GEOGRAPHY_ROW (+)');
471: END IF;
472:

Line 516: FND_LOG.STRING(g_level_procedure,

512: 1);
513: END IF;
514: CLOSE C;
515: IF (g_level_procedure >= g_current_runtime_level ) THEN
516: FND_LOG.STRING(g_level_procedure,
517: 'ZX.PLSQL.ZX_DETERMINING_FACTORS_PKG.INSERT_GEOGRAPHY_ROW.END',
518: 'ZX_DETERMINING_FACTORS_PKG.INSERT_GEOGRAPHY_ROW (-)');
519: END IF;
520: