DBA Data[Home] [Help]

APPS.ZX_TRX_MASTER dependencies on FND_LOG

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

1: PACKAGE BODY ZX_TRX_MASTER AS
2: /* $Header: zxritsimmasterb.pls 120.27 2006/09/22 01:44:10 pla ship $ */
3:
4: g_current_runtime_level NUMBER;
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: zxritsimmasterb.pls 120.27 2006/09/22 01:44:10 pla ship $ */
3:
4: g_current_runtime_level NUMBER;
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 NUMBER;
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: (p_Rowid IN OUT NOCOPY VARCHAR2,

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

4: g_current_runtime_level NUMBER;
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: (p_Rowid IN OUT NOCOPY VARCHAR2,
12: p_first_pty_org_id NUMBER,

Line 105: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

101: AND EVENT_CLASS_CODE = p_event_class_code
102: AND TRX_ID = p_trx_id;
103:
104: BEGIN
105: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
106:
107: IF (g_level_procedure >= g_current_runtime_level ) THEN
108: FND_LOG.STRING(g_level_procedure,
109: 'ZX.PLSQL.ZX_TRX_MASTER.Insert_Row.BEGIN',

Line 108: FND_LOG.STRING(g_level_procedure,

104: BEGIN
105: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
106:
107: IF (g_level_procedure >= g_current_runtime_level ) THEN
108: FND_LOG.STRING(g_level_procedure,
109: 'ZX.PLSQL.ZX_TRX_MASTER.Insert_Row.BEGIN',
110: 'ZX_TRX_MASTER: Insert_Row (+)');
111: FND_LOG.STRING(g_level_procedure,
112: 'ZX.PLSQL.ZX_TRX_MASTER.Insert_Row',

Line 111: FND_LOG.STRING(g_level_procedure,

107: IF (g_level_procedure >= g_current_runtime_level ) THEN
108: FND_LOG.STRING(g_level_procedure,
109: 'ZX.PLSQL.ZX_TRX_MASTER.Insert_Row.BEGIN',
110: 'ZX_TRX_MASTER: Insert_Row (+)');
111: FND_LOG.STRING(g_level_procedure,
112: 'ZX.PLSQL.ZX_TRX_MASTER.Insert_Row',
113: 'Insert into ZX_TRANSACTION (+)');
114: END IF;
115:

Line 288: FND_LOG.STRING(g_level_procedure,

284: END IF;
285: CLOSE C;
286:
287: IF (g_level_procedure >= g_current_runtime_level ) THEN
288: FND_LOG.STRING(g_level_procedure,
289: 'ZX.PLSQL.ZX_TRX_MASTER.Insert_Row',
290: 'Insert into ZX_TRANSACTION (-)');
291: FND_LOG.STRING(g_level_procedure,
292: 'ZX.PLSQL.ZX_TRX_MASTER.Insert_Row',

Line 291: FND_LOG.STRING(g_level_procedure,

287: IF (g_level_procedure >= g_current_runtime_level ) THEN
288: FND_LOG.STRING(g_level_procedure,
289: 'ZX.PLSQL.ZX_TRX_MASTER.Insert_Row',
290: 'Insert into ZX_TRANSACTION (-)');
291: FND_LOG.STRING(g_level_procedure,
292: 'ZX.PLSQL.ZX_TRX_MASTER.Insert_Row',
293: 'Insert into ZX_SIM_PURGE (+)');
294: END IF;
295:

Line 316: FND_LOG.STRING(g_level_procedure,

312: p_last_update_date,
313: p_last_update_login);
314:
315: IF (g_level_procedure >= g_current_runtime_level ) THEN
316: FND_LOG.STRING(g_level_procedure,
317: 'ZX.PLSQL.ZX_TRX_MASTER.Insert_Row',
318: 'Insert into ZX_SIM_PURGE (-)');
319: FND_LOG.STRING(g_level_procedure,
320: 'ZX.PLSQL.ZX_TRX_MASTER.Insert_Row.END',

Line 319: FND_LOG.STRING(g_level_procedure,

315: IF (g_level_procedure >= g_current_runtime_level ) THEN
316: FND_LOG.STRING(g_level_procedure,
317: 'ZX.PLSQL.ZX_TRX_MASTER.Insert_Row',
318: 'Insert into ZX_SIM_PURGE (-)');
319: FND_LOG.STRING(g_level_procedure,
320: 'ZX.PLSQL.ZX_TRX_MASTER.Insert_Row.END',
321: 'ZX_TRX_MASTER: Insert_Row (-)');
322: END IF;
323:

Line 451: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

447: AND TRX_ID = p_trx_id
448: AND TRX_LINE_TYPE <> 'TAX';
449:
450: BEGIN
451: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
452:
453: i := 0;
454:
455: IF (g_level_procedure >= g_current_runtime_level ) THEN

Line 456: FND_LOG.STRING(g_level_procedure,

452:
453: i := 0;
454:
455: IF (g_level_procedure >= g_current_runtime_level ) THEN
456: FND_LOG.STRING(g_level_procedure,
457: 'ZX.PLSQL.ZX_TRX_MASTER.update_Row.BEGIN',
458: 'ZX_TRX_MASTER: update_Row (+)');
459: FND_LOG.STRING(g_level_procedure,
460: 'ZX.PLSQL.ZX_TRX_MASTER.update_Row',

Line 459: FND_LOG.STRING(g_level_procedure,

455: IF (g_level_procedure >= g_current_runtime_level ) THEN
456: FND_LOG.STRING(g_level_procedure,
457: 'ZX.PLSQL.ZX_TRX_MASTER.update_Row.BEGIN',
458: 'ZX_TRX_MASTER: update_Row (+)');
459: FND_LOG.STRING(g_level_procedure,
460: 'ZX.PLSQL.ZX_TRX_MASTER.update_Row',
461: 'Update into ZX_TRANSACTION (+)');
462: END IF;
463:

Line 541: FND_LOG.STRING(g_level_procedure,

537: AND EVENT_CLASS_CODE = p_event_class_code
538: AND TRX_ID = p_trx_id;
539:
540: IF (g_level_procedure >= g_current_runtime_level ) THEN
541: FND_LOG.STRING(g_level_procedure,
542: 'ZX.PLSQL.ZX_TRX_MASTER.Update_Row',
543: 'Update into ZX_TRANSACTION (-)');
544: END IF;
545:

Line 547: FND_LOG.STRING(g_level_procedure,

543: 'Update into ZX_TRANSACTION (-)');
544: END IF;
545:
546: IF (g_level_procedure >= g_current_runtime_level ) THEN
547: FND_LOG.STRING(g_level_procedure,
548: 'ZX.PLSQL.ZX_TRX_MASTER.Update_Row',
549: 'Document Event Type (+)');
550:
551: FND_LOG.STRING(g_level_procedure,

Line 551: FND_LOG.STRING(g_level_procedure,

547: FND_LOG.STRING(g_level_procedure,
548: 'ZX.PLSQL.ZX_TRX_MASTER.Update_Row',
549: 'Document Event Type (+)');
550:
551: FND_LOG.STRING(g_level_procedure,
552: 'ZX.PLSQL.ZX_TRX_MASTER.Update_Row',
553: 'Document Event Type: '||p_document_event_type);
554: END IF;
555:

Line 635: FND_LOG.STRING(g_level_procedure,

631:
632: ELSIF p_document_event = 'SYNC' THEN
633:
634: IF (g_level_procedure >= g_current_runtime_level ) THEN
635: FND_LOG.STRING(g_level_procedure,
636: 'ZX.PLSQL.ZX_TRX_MASTER.Insert_Temporary_Table',
637: 'Insert into zx_trx_headers_gt (+)');
638: END IF;
639:

Line 818: FND_LOG.STRING(g_level_procedure,

814: AND EVENT_CLASS_CODE = p_event_class_code
815: AND TRX_ID = p_trx_id;
816:
817: IF (g_level_procedure >= g_current_runtime_level ) THEN
818: FND_LOG.STRING(g_level_procedure,
819: 'ZX.PLSQL.ZX_TRX_MASTER.Insert_Temporary_Table',
820: 'Insert into zx_trx_headers_gt (-)');
821: END IF;
822:

Line 824: FND_LOG.STRING(g_level_procedure,

820: 'Insert into zx_trx_headers_gt (-)');
821: END IF;
822:
823: IF (g_level_procedure >= g_current_runtime_level ) THEN
824: FND_LOG.STRING(g_level_procedure,
825: 'ZX.PLSQL.ZX_TRX_MASTER.Insert_Temporary_Table',
826: 'Insert into ZX_TRANSACTION_LINES_GT (+)');
827: END IF;
828:

Line 1345: FND_LOG.STRING(g_level_procedure,

1341:
1342: END IF;
1343:
1344: IF (g_level_procedure >= g_current_runtime_level ) THEN
1345: FND_LOG.STRING(g_level_procedure,
1346: 'ZX.PLSQL.ZX_TRX_MASTER.Update_Row',
1347: 'Document Event Type (-)');
1348: END IF;
1349:

Line 1351: FND_LOG.STRING(g_level_procedure,

1347: 'Document Event Type (-)');
1348: END IF;
1349:
1350: IF (g_level_procedure >= g_current_runtime_level ) THEN
1351: FND_LOG.STRING(g_level_procedure,
1352: 'ZX.PLSQL.ZX_TRX_MASTER.update_Row.END',
1353: 'ZX_TRX_MASTER: update_Row (-)');
1354: END IF;
1355: END Update_Row;

Line 1442: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

1438: p_last_update_date DATE,
1439: p_last_update_login NUMBER) IS
1440:
1441: BEGIN
1442: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
1443:
1444: IF (g_level_procedure >= g_current_runtime_level ) THEN
1445: FND_LOG.STRING(g_level_procedure,
1446: 'ZX.PLSQL.ZX_TRX_MASTER.Delete_Row.BEGIN',

Line 1445: FND_LOG.STRING(g_level_procedure,

1441: BEGIN
1442: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
1443:
1444: IF (g_level_procedure >= g_current_runtime_level ) THEN
1445: FND_LOG.STRING(g_level_procedure,
1446: 'ZX.PLSQL.ZX_TRX_MASTER.Delete_Row.BEGIN',
1447: 'ZX_TRX_MASTER: Delete_Row (+)');
1448: FND_LOG.STRING(g_level_procedure,
1449: 'ZX.PLSQL.ZX_TRX_MASTER.Delete_Row',

Line 1448: FND_LOG.STRING(g_level_procedure,

1444: IF (g_level_procedure >= g_current_runtime_level ) THEN
1445: FND_LOG.STRING(g_level_procedure,
1446: 'ZX.PLSQL.ZX_TRX_MASTER.Delete_Row.BEGIN',
1447: 'ZX_TRX_MASTER: Delete_Row (+)');
1448: FND_LOG.STRING(g_level_procedure,
1449: 'ZX.PLSQL.ZX_TRX_MASTER.Delete_Row',
1450: 'Update for DELETE in ZX_TRANSACTION (+)');
1451: END IF;
1452:

Line 1525: FND_LOG.STRING(g_level_procedure,

1521: AND EVENT_CLASS_CODE = p_event_class_code
1522: AND TRX_ID = p_trx_id;
1523:
1524: IF (g_level_procedure >= g_current_runtime_level ) THEN
1525: FND_LOG.STRING(g_level_procedure,
1526: 'ZX.PLSQL.ZX_TRX_MASTER.Delete_Row',
1527: 'Update for DELETE in ZX_TRANSACTION (-)');
1528: FND_LOG.STRING(g_level_procedure,
1529: 'ZX.PLSQL.ZX_TRX_MASTER.Delete_Row.END',

Line 1528: FND_LOG.STRING(g_level_procedure,

1524: IF (g_level_procedure >= g_current_runtime_level ) THEN
1525: FND_LOG.STRING(g_level_procedure,
1526: 'ZX.PLSQL.ZX_TRX_MASTER.Delete_Row',
1527: 'Update for DELETE in ZX_TRANSACTION (-)');
1528: FND_LOG.STRING(g_level_procedure,
1529: 'ZX.PLSQL.ZX_TRX_MASTER.Delete_Row.END',
1530: 'ZX_TRX_MASTER: Delete_Row (-)');
1531: END IF;
1532: END Delete_Row;

Line 1719: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

1715: p_error_buffer VARCHAR2(100);
1716:
1717: BEGIN
1718:
1719: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
1720: IF (g_level_procedure >= g_current_runtime_level ) THEN
1721: FND_LOG.STRING(g_level_procedure,
1722: 'ZX.PLSQL.ZX_TRX_MASTER.Lock_Row.BEGIN',
1723: 'ZX_TRX_MASTER: Lock_Row (+)');

Line 1721: FND_LOG.STRING(g_level_procedure,

1717: BEGIN
1718:
1719: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
1720: IF (g_level_procedure >= g_current_runtime_level ) THEN
1721: FND_LOG.STRING(g_level_procedure,
1722: 'ZX.PLSQL.ZX_TRX_MASTER.Lock_Row.BEGIN',
1723: 'ZX_TRX_MASTER: Lock_Row (+)');
1724: END IF;
1725:

Line 1964: FND_LOG.STRING(g_level_procedure,

1960: APP_EXCEPTION.Raise_Exception;
1961: END IF;
1962:
1963: IF (g_level_procedure >= g_current_runtime_level ) THEN
1964: FND_LOG.STRING(g_level_procedure,
1965: 'ZX.PLSQL.ZX_TRX_MASTER.Lock_Row.END',
1966: 'ZX_TRX_MASTER: Lock_Row (-)');
1967: END IF;
1968: EXCEPTION

Line 1976: FND_LOG.STRING(g_level_unexpected,

1972: FND_MESSAGE.SET_NAME('ZX','ZX_UNEXPECTED_ERROR');
1973: FND_MSG_PUB.Add;
1974:
1975: IF (g_level_unexpected >= g_current_runtime_level ) THEN
1976: FND_LOG.STRING(g_level_unexpected,
1977: 'ZX.PLSQL.ZX_TRX_MASTER.Lock_Row',
1978: p_error_buffer);
1979: END IF;
1980: END Lock_Row;