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_TRX_MASTER dependencies on ZX_TRX_MASTER

Line 1: PACKAGE BODY ZX_TRX_MASTER AS

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;

Line 109: 'ZX.PLSQL.ZX_TRX_MASTER.Insert_Row.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',
113: 'Insert into ZX_TRANSACTION (+)');

Line 110: 'ZX_TRX_MASTER: Insert_Row (+)');

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',
113: 'Insert into ZX_TRANSACTION (+)');
114: END IF;

Line 112: 'ZX.PLSQL.ZX_TRX_MASTER.Insert_Row',

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:
116: INSERT INTO ZX_TRANSACTION (FIRST_PTY_ORG_ID,

Line 289: 'ZX.PLSQL.ZX_TRX_MASTER.Insert_Row',

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',
293: 'Insert into ZX_SIM_PURGE (+)');

Line 292: 'ZX.PLSQL.ZX_TRX_MASTER.Insert_Row',

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:
296: INSERT INTO ZX_SIM_PURGE (TRX_ID,

Line 317: 'ZX.PLSQL.ZX_TRX_MASTER.Insert_Row',

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',
321: 'ZX_TRX_MASTER: Insert_Row (-)');

Line 320: 'ZX.PLSQL.ZX_TRX_MASTER.Insert_Row.END',

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:
324:

Line 321: 'ZX_TRX_MASTER: Insert_Row (-)');

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:
324:
325: END Insert_Row;

Line 457: 'ZX.PLSQL.ZX_TRX_MASTER.update_Row.BEGIN',

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',
461: 'Update into ZX_TRANSACTION (+)');

Line 458: 'ZX_TRX_MASTER: update_Row (+)');

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',
461: 'Update into ZX_TRANSACTION (+)');
462: END IF;

Line 460: 'ZX.PLSQL.ZX_TRX_MASTER.update_Row',

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:
464: UPDATE ZX_TRANSACTION

Line 542: 'ZX.PLSQL.ZX_TRX_MASTER.Update_Row',

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:
546: IF (g_level_procedure >= g_current_runtime_level ) THEN

Line 548: 'ZX.PLSQL.ZX_TRX_MASTER.Update_Row',

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,
552: 'ZX.PLSQL.ZX_TRX_MASTER.Update_Row',

Line 552: 'ZX.PLSQL.ZX_TRX_MASTER.Update_Row',

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:
556: --

Line 636: 'ZX.PLSQL.ZX_TRX_MASTER.Insert_Temporary_Table',

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:
640: INSERT INTO ZX_TRX_HEADERS_GT (INTERNAL_ORGANIZATION_ID,

Line 819: 'ZX.PLSQL.ZX_TRX_MASTER.Insert_Temporary_Table',

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:
823: IF (g_level_procedure >= g_current_runtime_level ) THEN

Line 825: 'ZX.PLSQL.ZX_TRX_MASTER.Insert_Temporary_Table',

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:
829: INSERT INTO ZX_TRANSACTION_LINES_GT (APPLICATION_ID,

Line 1346: 'ZX.PLSQL.ZX_TRX_MASTER.Update_Row',

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:
1350: IF (g_level_procedure >= g_current_runtime_level ) THEN

Line 1352: 'ZX.PLSQL.ZX_TRX_MASTER.update_Row.END',

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;
1356:

Line 1353: 'ZX_TRX_MASTER: update_Row (-)');

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;
1356:
1357: PROCEDURE Delete_Row

Line 1446: 'ZX.PLSQL.ZX_TRX_MASTER.Delete_Row.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',
1450: 'Update for DELETE in ZX_TRANSACTION (+)');

Line 1447: 'ZX_TRX_MASTER: Delete_Row (+)');

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',
1450: 'Update for DELETE in ZX_TRANSACTION (+)');
1451: END IF;

Line 1449: 'ZX.PLSQL.ZX_TRX_MASTER.Delete_Row',

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:
1453: UPDATE ZX_TRANSACTION

Line 1526: 'ZX.PLSQL.ZX_TRX_MASTER.Delete_Row',

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',
1530: 'ZX_TRX_MASTER: Delete_Row (-)');

Line 1529: 'ZX.PLSQL.ZX_TRX_MASTER.Delete_Row.END',

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;
1533:

Line 1530: 'ZX_TRX_MASTER: Delete_Row (-)');

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;
1533:
1534: PROCEDURE Lock_Row

Line 1722: 'ZX.PLSQL.ZX_TRX_MASTER.Lock_Row.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:
1726: debug_info := 'Open cursor C';

Line 1723: 'ZX_TRX_MASTER: Lock_Row (+)');

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:
1726: debug_info := 'Open cursor C';
1727: OPEN C;

Line 1965: 'ZX.PLSQL.ZX_TRX_MASTER.Lock_Row.END',

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
1969: WHEN OTHERS THEN

Line 1966: 'ZX_TRX_MASTER: Lock_Row (-)');

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
1969: WHEN OTHERS THEN
1970: p_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80);

Line 1977: 'ZX.PLSQL.ZX_TRX_MASTER.Lock_Row',

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;
1981:

Line 1982: END ZX_TRX_MASTER;

1978: p_error_buffer);
1979: END IF;
1980: END Lock_Row;
1981:
1982: END ZX_TRX_MASTER;