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_SIM_TRX_DISTRIBUTION dependencies on ZX_SIM_TRX_DISTRIBUTION

Line 1: PACKAGE BODY ZX_SIM_TRX_DISTRIBUTION AS

1: PACKAGE BODY ZX_SIM_TRX_DISTRIBUTION AS
2: /* $Header: zxritsimitdistb.pls 120.16.12010000.1 2008/07/28 13:37:19 appldev ship $ */
3:
4: g_current_runtime_level NUMBER;
5: g_level_statement CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;

Line 179: 'ZX.PLSQL.ZX_SIM_TRX_DISTRIBUTION.Insert_Row.BEGIN',

175: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
176:
177: IF (g_level_procedure >= g_current_runtime_level ) THEN
178: FND_LOG.STRING(g_level_procedure,
179: 'ZX.PLSQL.ZX_SIM_TRX_DISTRIBUTION.Insert_Row.BEGIN',
180: 'ZX_SIM_TRX_DISTRIBUTION: Insert_Row (+)');
181: FND_LOG.STRING(g_level_procedure,
182: 'ZX.PLSQL.ZX_SIM_TRX_DISTRIBUTION.Insert_Row',
183: 'Insert into ZX_SIM_TRX_DISTS (+)');

Line 180: 'ZX_SIM_TRX_DISTRIBUTION: Insert_Row (+)');

176:
177: IF (g_level_procedure >= g_current_runtime_level ) THEN
178: FND_LOG.STRING(g_level_procedure,
179: 'ZX.PLSQL.ZX_SIM_TRX_DISTRIBUTION.Insert_Row.BEGIN',
180: 'ZX_SIM_TRX_DISTRIBUTION: Insert_Row (+)');
181: FND_LOG.STRING(g_level_procedure,
182: 'ZX.PLSQL.ZX_SIM_TRX_DISTRIBUTION.Insert_Row',
183: 'Insert into ZX_SIM_TRX_DISTS (+)');
184: END IF;

Line 182: 'ZX.PLSQL.ZX_SIM_TRX_DISTRIBUTION.Insert_Row',

178: FND_LOG.STRING(g_level_procedure,
179: 'ZX.PLSQL.ZX_SIM_TRX_DISTRIBUTION.Insert_Row.BEGIN',
180: 'ZX_SIM_TRX_DISTRIBUTION: Insert_Row (+)');
181: FND_LOG.STRING(g_level_procedure,
182: 'ZX.PLSQL.ZX_SIM_TRX_DISTRIBUTION.Insert_Row',
183: 'Insert into ZX_SIM_TRX_DISTS (+)');
184: END IF;
185:
186: INSERT INTO ZX_SIM_TRX_DISTS (APPLICATION_ID,

Line 491: 'ZX.PLSQL.ZX_SIM_TRX_DISTRIBUTION.Insert_Row',

487: p_last_update_login);
488:
489: IF (g_level_procedure >= g_current_runtime_level ) THEN
490: FND_LOG.STRING(g_level_procedure,
491: 'ZX.PLSQL.ZX_SIM_TRX_DISTRIBUTION.Insert_Row',
492: 'Insert into ZX_SIM_TRX_DISTS (-)');
493: FND_LOG.STRING(g_level_procedure,
494: 'ZX.PLSQL.ZX_SIM_TRX_DISTRIBUTION.Insert_Row.END',
495: 'ZX_SIM_TRX_DISTRIBUTION: Insert_Row (-)');

Line 494: 'ZX.PLSQL.ZX_SIM_TRX_DISTRIBUTION.Insert_Row.END',

490: FND_LOG.STRING(g_level_procedure,
491: 'ZX.PLSQL.ZX_SIM_TRX_DISTRIBUTION.Insert_Row',
492: 'Insert into ZX_SIM_TRX_DISTS (-)');
493: FND_LOG.STRING(g_level_procedure,
494: 'ZX.PLSQL.ZX_SIM_TRX_DISTRIBUTION.Insert_Row.END',
495: 'ZX_SIM_TRX_DISTRIBUTION: Insert_Row (-)');
496: END IF;
497:
498: END Insert_row;

Line 495: 'ZX_SIM_TRX_DISTRIBUTION: Insert_Row (-)');

491: 'ZX.PLSQL.ZX_SIM_TRX_DISTRIBUTION.Insert_Row',
492: 'Insert into ZX_SIM_TRX_DISTS (-)');
493: FND_LOG.STRING(g_level_procedure,
494: 'ZX.PLSQL.ZX_SIM_TRX_DISTRIBUTION.Insert_Row.END',
495: 'ZX_SIM_TRX_DISTRIBUTION: Insert_Row (-)');
496: END IF;
497:
498: END Insert_row;
499:

Line 663: 'ZX.PLSQL.ZX_SIM_TRX_DISTRIBUTION.Update_Row.BEGIN',

659: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
660:
661: IF (g_level_procedure >= g_current_runtime_level ) THEN
662: FND_LOG.STRING(g_level_procedure,
663: 'ZX.PLSQL.ZX_SIM_TRX_DISTRIBUTION.Update_Row.BEGIN',
664: 'ZX_SIM_TRX_DISTRIBUTION: Update_Row (+)');
665: FND_LOG.STRING(g_level_procedure,
666: 'ZX.PLSQL.ZX_SIM_TRX_DISTRIBUTION.Update_Row',
667: 'Update ZX_SIM_TRX_DISTS (+)');

Line 664: 'ZX_SIM_TRX_DISTRIBUTION: Update_Row (+)');

660:
661: IF (g_level_procedure >= g_current_runtime_level ) THEN
662: FND_LOG.STRING(g_level_procedure,
663: 'ZX.PLSQL.ZX_SIM_TRX_DISTRIBUTION.Update_Row.BEGIN',
664: 'ZX_SIM_TRX_DISTRIBUTION: Update_Row (+)');
665: FND_LOG.STRING(g_level_procedure,
666: 'ZX.PLSQL.ZX_SIM_TRX_DISTRIBUTION.Update_Row',
667: 'Update ZX_SIM_TRX_DISTS (+)');
668: END IF;

Line 666: 'ZX.PLSQL.ZX_SIM_TRX_DISTRIBUTION.Update_Row',

662: FND_LOG.STRING(g_level_procedure,
663: 'ZX.PLSQL.ZX_SIM_TRX_DISTRIBUTION.Update_Row.BEGIN',
664: 'ZX_SIM_TRX_DISTRIBUTION: Update_Row (+)');
665: FND_LOG.STRING(g_level_procedure,
666: 'ZX.PLSQL.ZX_SIM_TRX_DISTRIBUTION.Update_Row',
667: 'Update ZX_SIM_TRX_DISTS (+)');
668: END IF;
669:
670: /*****************

Line 843: 'ZX.PLSQL.ZX_SIM_TRX_DISTRIBUTION.Update_Row',

839: AND TRX_LINE_DIST_ID = p_trx_line_dist_id;
840:
841: IF (g_level_procedure >= g_current_runtime_level ) THEN
842: FND_LOG.STRING(g_level_procedure,
843: 'ZX.PLSQL.ZX_SIM_TRX_DISTRIBUTION.Update_Row',
844: 'Update ZX_SIM_TRX_DISTS (-)');
845: FND_LOG.STRING(g_level_procedure,
846: 'ZX.PLSQL.ZX_SIM_TRX_DISTRIBUTION.Update_Row.END',
847: 'ZX_SIM_TRX_DISTRIBUTION: Update_Row (-)');

Line 846: 'ZX.PLSQL.ZX_SIM_TRX_DISTRIBUTION.Update_Row.END',

842: FND_LOG.STRING(g_level_procedure,
843: 'ZX.PLSQL.ZX_SIM_TRX_DISTRIBUTION.Update_Row',
844: 'Update ZX_SIM_TRX_DISTS (-)');
845: FND_LOG.STRING(g_level_procedure,
846: 'ZX.PLSQL.ZX_SIM_TRX_DISTRIBUTION.Update_Row.END',
847: 'ZX_SIM_TRX_DISTRIBUTION: Update_Row (-)');
848: END IF;
849:
850: END Update_row;

Line 847: 'ZX_SIM_TRX_DISTRIBUTION: Update_Row (-)');

843: 'ZX.PLSQL.ZX_SIM_TRX_DISTRIBUTION.Update_Row',
844: 'Update ZX_SIM_TRX_DISTS (-)');
845: FND_LOG.STRING(g_level_procedure,
846: 'ZX.PLSQL.ZX_SIM_TRX_DISTRIBUTION.Update_Row.END',
847: 'ZX_SIM_TRX_DISTRIBUTION: Update_Row (-)');
848: END IF;
849:
850: END Update_row;
851:

Line 1015: 'ZX.PLSQL.ZX_SIM_TRX_DISTRIBUTION.Delete_Row.BEGIN',

1011: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
1012:
1013: IF (g_level_procedure >= g_current_runtime_level ) THEN
1014: FND_LOG.STRING(g_level_procedure,
1015: 'ZX.PLSQL.ZX_SIM_TRX_DISTRIBUTION.Delete_Row.BEGIN',
1016: 'ZX_SIM_TRX_DISTRIBUTION: Delete_Row (+)');
1017: FND_LOG.STRING(g_level_procedure,
1018: 'ZX.PLSQL.ZX_SIM_TRX_DISTRIBUTION.Delete_Row',
1019: 'Delete from ZX_SIM_TRX_DISTRIBUTION (+)');

Line 1016: 'ZX_SIM_TRX_DISTRIBUTION: Delete_Row (+)');

1012:
1013: IF (g_level_procedure >= g_current_runtime_level ) THEN
1014: FND_LOG.STRING(g_level_procedure,
1015: 'ZX.PLSQL.ZX_SIM_TRX_DISTRIBUTION.Delete_Row.BEGIN',
1016: 'ZX_SIM_TRX_DISTRIBUTION: Delete_Row (+)');
1017: FND_LOG.STRING(g_level_procedure,
1018: 'ZX.PLSQL.ZX_SIM_TRX_DISTRIBUTION.Delete_Row',
1019: 'Delete from ZX_SIM_TRX_DISTRIBUTION (+)');
1020: END IF;

Line 1018: 'ZX.PLSQL.ZX_SIM_TRX_DISTRIBUTION.Delete_Row',

1014: FND_LOG.STRING(g_level_procedure,
1015: 'ZX.PLSQL.ZX_SIM_TRX_DISTRIBUTION.Delete_Row.BEGIN',
1016: 'ZX_SIM_TRX_DISTRIBUTION: Delete_Row (+)');
1017: FND_LOG.STRING(g_level_procedure,
1018: 'ZX.PLSQL.ZX_SIM_TRX_DISTRIBUTION.Delete_Row',
1019: 'Delete from ZX_SIM_TRX_DISTRIBUTION (+)');
1020: END IF;
1021:
1022: /* Delete code */

Line 1019: 'Delete from ZX_SIM_TRX_DISTRIBUTION (+)');

1015: 'ZX.PLSQL.ZX_SIM_TRX_DISTRIBUTION.Delete_Row.BEGIN',
1016: 'ZX_SIM_TRX_DISTRIBUTION: Delete_Row (+)');
1017: FND_LOG.STRING(g_level_procedure,
1018: 'ZX.PLSQL.ZX_SIM_TRX_DISTRIBUTION.Delete_Row',
1019: 'Delete from ZX_SIM_TRX_DISTRIBUTION (+)');
1020: END IF;
1021:
1022: /* Delete code */
1023:

Line 1026: 'ZX.PLSQL.ZX_SIM_TRX_DISTRIBUTION.Delete_Row',

1022: /* Delete code */
1023:
1024: IF (g_level_procedure >= g_current_runtime_level ) THEN
1025: FND_LOG.STRING(g_level_procedure,
1026: 'ZX.PLSQL.ZX_SIM_TRX_DISTRIBUTION.Delete_Row',
1027: 'Delete from ZX_SIM_TRX_DISTRIBUTION (-)');
1028: FND_LOG.STRING(g_level_procedure,
1029: 'ZX.PLSQL.ZX_SIM_TRX_DISTRIBUTION.Delete_Row.END',
1030: 'ZX_SIM_TRX_DISTRIBUTION: Delete_Row (-)');

Line 1027: 'Delete from ZX_SIM_TRX_DISTRIBUTION (-)');

1023:
1024: IF (g_level_procedure >= g_current_runtime_level ) THEN
1025: FND_LOG.STRING(g_level_procedure,
1026: 'ZX.PLSQL.ZX_SIM_TRX_DISTRIBUTION.Delete_Row',
1027: 'Delete from ZX_SIM_TRX_DISTRIBUTION (-)');
1028: FND_LOG.STRING(g_level_procedure,
1029: 'ZX.PLSQL.ZX_SIM_TRX_DISTRIBUTION.Delete_Row.END',
1030: 'ZX_SIM_TRX_DISTRIBUTION: Delete_Row (-)');
1031: END IF;

Line 1029: 'ZX.PLSQL.ZX_SIM_TRX_DISTRIBUTION.Delete_Row.END',

1025: FND_LOG.STRING(g_level_procedure,
1026: 'ZX.PLSQL.ZX_SIM_TRX_DISTRIBUTION.Delete_Row',
1027: 'Delete from ZX_SIM_TRX_DISTRIBUTION (-)');
1028: FND_LOG.STRING(g_level_procedure,
1029: 'ZX.PLSQL.ZX_SIM_TRX_DISTRIBUTION.Delete_Row.END',
1030: 'ZX_SIM_TRX_DISTRIBUTION: Delete_Row (-)');
1031: END IF;
1032:
1033: END Delete_row;

Line 1030: 'ZX_SIM_TRX_DISTRIBUTION: Delete_Row (-)');

1026: 'ZX.PLSQL.ZX_SIM_TRX_DISTRIBUTION.Delete_Row',
1027: 'Delete from ZX_SIM_TRX_DISTRIBUTION (-)');
1028: FND_LOG.STRING(g_level_procedure,
1029: 'ZX.PLSQL.ZX_SIM_TRX_DISTRIBUTION.Delete_Row.END',
1030: 'ZX_SIM_TRX_DISTRIBUTION: Delete_Row (-)');
1031: END IF;
1032:
1033: END Delete_row;
1034:

Line 1366: 'ZX.PLSQL.ZX_SIM_TRX_DISTRIBUTION.Lock_row.BEGIN',

1362:
1363: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
1364: IF (g_level_procedure >= g_current_runtime_level ) THEN
1365: FND_LOG.STRING(g_level_procedure,
1366: 'ZX.PLSQL.ZX_SIM_TRX_DISTRIBUTION.Lock_row.BEGIN',
1367: 'ZX_SIM_TRX_DISTRIBUTION: Lock_row (+)');
1368: END IF;
1369:
1370: debug_info := 'Open cursor C';

Line 1367: 'ZX_SIM_TRX_DISTRIBUTION: Lock_row (+)');

1363: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
1364: IF (g_level_procedure >= g_current_runtime_level ) THEN
1365: FND_LOG.STRING(g_level_procedure,
1366: 'ZX.PLSQL.ZX_SIM_TRX_DISTRIBUTION.Lock_row.BEGIN',
1367: 'ZX_SIM_TRX_DISTRIBUTION: Lock_row (+)');
1368: END IF;
1369:
1370: debug_info := 'Open cursor C';
1371: OPEN C;

Line 1819: 'ZX.PLSQL.ZX_SIM_TRX_DISTRIBUTION.Lock_row.END',

1815: END IF;
1816:
1817: IF (g_level_procedure >= g_current_runtime_level ) THEN
1818: FND_LOG.STRING(g_level_procedure,
1819: 'ZX.PLSQL.ZX_SIM_TRX_DISTRIBUTION.Lock_row.END',
1820: 'ZX_SIM_TRX_DISTRIBUTION: Lock_row (-)');
1821: END IF;
1822:
1823: EXCEPTION

Line 1820: 'ZX_SIM_TRX_DISTRIBUTION: Lock_row (-)');

1816:
1817: IF (g_level_procedure >= g_current_runtime_level ) THEN
1818: FND_LOG.STRING(g_level_procedure,
1819: 'ZX.PLSQL.ZX_SIM_TRX_DISTRIBUTION.Lock_row.END',
1820: 'ZX_SIM_TRX_DISTRIBUTION: Lock_row (-)');
1821: END IF;
1822:
1823: EXCEPTION
1824: WHEN OTHERS THEN

Line 1832: 'ZX.PLSQL.ZX_SIM_TRX_DISTRIBUTION.Lock_Row',

1828: FND_MSG_PUB.Add;
1829:
1830: IF (g_level_unexpected >= g_current_runtime_level ) THEN
1831: FND_LOG.STRING(g_level_unexpected,
1832: 'ZX.PLSQL.ZX_SIM_TRX_DISTRIBUTION.Lock_Row',
1833: p_error_buffer);
1834: END IF;
1835:
1836: END Lock_Row;

Line 1869: 'ZX.PLSQL.ZX_SIM_TRX_DISTRIBUTION.Insert_Temporary_Table.BEGIN',

1865: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
1866:
1867: IF (g_level_procedure >= g_current_runtime_level ) THEN
1868: FND_LOG.STRING(g_level_procedure,
1869: 'ZX.PLSQL.ZX_SIM_TRX_DISTRIBUTION.Insert_Temporary_Table.BEGIN',
1870: 'ZX_SIM_TRX_DISTRIBUTION: Insert_Temporary_Table (+)');
1871:
1872: END IF;
1873:

Line 1870: 'ZX_SIM_TRX_DISTRIBUTION: Insert_Temporary_Table (+)');

1866:
1867: IF (g_level_procedure >= g_current_runtime_level ) THEN
1868: FND_LOG.STRING(g_level_procedure,
1869: 'ZX.PLSQL.ZX_SIM_TRX_DISTRIBUTION.Insert_Temporary_Table.BEGIN',
1870: 'ZX_SIM_TRX_DISTRIBUTION: Insert_Temporary_Table (+)');
1871:
1872: END IF;
1873:
1874: DELETE ZX_TRX_HEADERS_GT

Line 1882: 'ZX.PLSQL.ZX_SIM_TRX_DISTRIBUTION.Insert_Temporary_Tables',

1878: AND TRX_ID = p_trx_id;
1879:
1880: IF (g_level_procedure >= g_current_runtime_level ) THEN
1881: FND_LOG.STRING(g_level_procedure,
1882: 'ZX.PLSQL.ZX_SIM_TRX_DISTRIBUTION.Insert_Temporary_Tables',
1883: 'Insert into zx_trx_headers_gt (+)');
1884: END IF;
1885:
1886: INSERT INTO ZX_TRX_HEADERS_GT (INTERNAL_ORGANIZATION_ID,

Line 2065: 'ZX.PLSQL.ZX_SIM_TRX_DISTRIBUTION.Insert_Temporary_Table',

2061: AND TRX_ID = p_trx_id;
2062:
2063: IF (g_level_procedure >= g_current_runtime_level ) THEN
2064: FND_LOG.STRING(g_level_procedure,
2065: 'ZX.PLSQL.ZX_SIM_TRX_DISTRIBUTION.Insert_Temporary_Table',
2066: 'Insert into zx_trx_headers_gt (-)');
2067: END IF;
2068:
2069: IF (g_level_procedure >= g_current_runtime_level ) THEN

Line 2071: 'ZX.PLSQL.ZX_SIM_TRX_DISTRIBUTION.Insert_Temporary_Tables',

2067: END IF;
2068:
2069: IF (g_level_procedure >= g_current_runtime_level ) THEN
2070: FND_LOG.STRING(g_level_procedure,
2071: 'ZX.PLSQL.ZX_SIM_TRX_DISTRIBUTION.Insert_Temporary_Tables',
2072: 'Insert into ZX_ITM_DISTRIBUTIONS_GT (+)');
2073: END IF;
2074:
2075: INSERT INTO ZX_ITM_DISTRIBUTIONS_GT (APPLICATION_ID,

Line 2374: 'ZX.PLSQL.ZX_SIM_TRX_DISTRIBUTION.Insert_Temporary_Table',

2370: AND TRX_LINE_ID = p_trx_line_id;
2371:
2372: IF (g_level_procedure >= g_current_runtime_level ) THEN
2373: FND_LOG.STRING(g_level_procedure,
2374: 'ZX.PLSQL.ZX_SIM_TRX_DISTRIBUTION.Insert_Temporary_Table',
2375: 'Insert into ZX_ITM_DISTRIBUTIONS_GT (-)');
2376: END IF;
2377:
2378: BEGIN

Line 2382: 'ZX.PLSQL.ZX_SIM_TRX_DISTRIBUTION.Insert_Temporary_Table',

2378: BEGIN
2379:
2380: IF (g_level_procedure >= g_current_runtime_level ) THEN
2381: FND_LOG.STRING(g_level_procedure,
2382: 'ZX.PLSQL.ZX_SIM_TRX_DISTRIBUTION.Insert_Temporary_Table',
2383: 'API zx_api_pub.Determine_recovery for Insert_Temporary_Table (+)');
2384: END IF;
2385:
2386: ZX_API_PUB.Determine_recovery (p_api_version => 1.0,

Line 2396: 'ZX.PLSQL.ZX_SIM_TRX_DISTRIBUTION.Insert_Temporary_Table',

2392: x_msg_data => l_msg_data);
2393:
2394: IF (g_level_procedure >= g_current_runtime_level ) THEN
2395: FND_LOG.STRING(g_level_procedure,
2396: 'ZX.PLSQL.ZX_SIM_TRX_DISTRIBUTION.Insert_Temporary_Table',
2397: 'API zx_api_pub.Determine_recovery for Insert_Temporary_Table (-)');
2398: END IF;
2399:
2400:

Line 2403: 'ZX.PLSQL.ZX_SIM_TRX_DISTRIBUTION.Insert_Temporary_Table',

2399:
2400:
2401: IF (g_level_procedure >= g_current_runtime_level ) THEN
2402: FND_LOG.STRING(g_level_procedure,
2403: 'ZX.PLSQL.ZX_SIM_TRX_DISTRIBUTION.Insert_Temporary_Table',
2404: 'Return Status = ' || l_return_status);
2405:
2406: FND_LOG.STRING(g_level_procedure,
2407: 'ZX.PLSQL.ZX_SIM_TRX_DISTRIBUTION.Insert_Temporary_Table',

Line 2407: 'ZX.PLSQL.ZX_SIM_TRX_DISTRIBUTION.Insert_Temporary_Table',

2403: 'ZX.PLSQL.ZX_SIM_TRX_DISTRIBUTION.Insert_Temporary_Table',
2404: 'Return Status = ' || l_return_status);
2405:
2406: FND_LOG.STRING(g_level_procedure,
2407: 'ZX.PLSQL.ZX_SIM_TRX_DISTRIBUTION.Insert_Temporary_Table',
2408: 'Message Count = ' || l_msg_count);
2409:
2410: FND_LOG.STRING(g_level_procedure,
2411: 'ZX.PLSQL.ZX_SIM_TRX_DISTRIBUTION.Insert_Temporary_Table',

Line 2411: 'ZX.PLSQL.ZX_SIM_TRX_DISTRIBUTION.Insert_Temporary_Table',

2407: 'ZX.PLSQL.ZX_SIM_TRX_DISTRIBUTION.Insert_Temporary_Table',
2408: 'Message Count = ' || l_msg_count);
2409:
2410: FND_LOG.STRING(g_level_procedure,
2411: 'ZX.PLSQL.ZX_SIM_TRX_DISTRIBUTION.Insert_Temporary_Table',
2412: 'Message data = ' || l_msg_data);
2413: END IF;
2414: END;
2415:

Line 2418: 'ZX.PLSQL.ZX_SIM_TRX_DISTRIBUTION.Insert_Temporary_Table.END',

2414: END;
2415:
2416: IF (g_level_procedure >= g_current_runtime_level ) THEN
2417: FND_LOG.STRING(g_level_procedure,
2418: 'ZX.PLSQL.ZX_SIM_TRX_DISTRIBUTION.Insert_Temporary_Table.END',
2419: 'ZX_SIM_TRX_DISTRIBUTION: Insert_Temporary_Table (-)');
2420: END IF;
2421:
2422: EXCEPTION

Line 2419: 'ZX_SIM_TRX_DISTRIBUTION: Insert_Temporary_Table (-)');

2415:
2416: IF (g_level_procedure >= g_current_runtime_level ) THEN
2417: FND_LOG.STRING(g_level_procedure,
2418: 'ZX.PLSQL.ZX_SIM_TRX_DISTRIBUTION.Insert_Temporary_Table.END',
2419: 'ZX_SIM_TRX_DISTRIBUTION: Insert_Temporary_Table (-)');
2420: END IF;
2421:
2422: EXCEPTION
2423: WHEN OTHERS THEN

Line 2432: 'ZX.PLSQL.ZX_SIM_TRX_DISTRIBUTION.Insert_Temporary_Table',

2428: FND_MSG_PUB.Add;
2429:
2430: IF (g_level_unexpected >= g_current_runtime_level ) THEN
2431: FND_LOG.STRING(g_level_unexpected,
2432: 'ZX.PLSQL.ZX_SIM_TRX_DISTRIBUTION.Insert_Temporary_Table',
2433: p_error_buffer);
2434: END IF;
2435: END Insert_Temporary_Table;
2436:

Line 2465: 'ZX.PLSQL.ZX_SIM_TRX_DISTRIBUTION.Update_Transaction_Lines.BEGIN',

2461:
2462: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
2463: IF (g_level_procedure >= g_current_runtime_level ) THEN
2464: FND_LOG.STRING(g_level_procedure,
2465: 'ZX.PLSQL.ZX_SIM_TRX_DISTRIBUTION.Update_Transaction_Lines.BEGIN',
2466: 'ZX_SIM_TRX_DISTRIBUTION: Update_Transaction_Lines (+)');
2467: END IF;
2468:
2469:

Line 2466: 'ZX_SIM_TRX_DISTRIBUTION: Update_Transaction_Lines (+)');

2462: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
2463: IF (g_level_procedure >= g_current_runtime_level ) THEN
2464: FND_LOG.STRING(g_level_procedure,
2465: 'ZX.PLSQL.ZX_SIM_TRX_DISTRIBUTION.Update_Transaction_Lines.BEGIN',
2466: 'ZX_SIM_TRX_DISTRIBUTION: Update_Transaction_Lines (+)');
2467: END IF;
2468:
2469:
2470: IF (g_level_procedure >= g_current_runtime_level ) THEN

Line 2472: 'ZX.PLSQL.ZX_SIM_TRX_DISTRIBUTION.Update_Transaction_Lines',

2468:
2469:
2470: IF (g_level_procedure >= g_current_runtime_level ) THEN
2471: FND_LOG.STRING(g_level_procedure,
2472: 'ZX.PLSQL.ZX_SIM_TRX_DISTRIBUTION.Update_Transaction_Lines',
2473: 'Update ZX_ITM_DISTRIBUTIONS_GT (+)');
2474: END IF;
2475:
2476: IF (g_level_procedure >= g_current_runtime_level ) THEN

Line 2478: 'ZX.PLSQL.ZX_SIM_TRX_DISTRIBUTION.Insert_Temporary_Tables',

2474: END IF;
2475:
2476: IF (g_level_procedure >= g_current_runtime_level ) THEN
2477: FND_LOG.STRING(g_level_procedure,
2478: 'ZX.PLSQL.ZX_SIM_TRX_DISTRIBUTION.Insert_Temporary_Tables',
2479: 'Insert into zx_trx_headers_gt (+)');
2480: END IF;
2481:
2482: INSERT INTO ZX_TRX_HEADERS_GT (INTERNAL_ORGANIZATION_ID,

Line 2661: 'ZX.PLSQL.ZX_SIM_TRX_DISTRIBUTION.Insert_Temporary_Table',

2657: AND TRX_ID = p_trx_id;
2658:
2659: IF (g_level_procedure >= g_current_runtime_level ) THEN
2660: FND_LOG.STRING(g_level_procedure,
2661: 'ZX.PLSQL.ZX_SIM_TRX_DISTRIBUTION.Insert_Temporary_Table',
2662: 'Insert into zx_trx_headers_gt (-)');
2663: END IF;
2664:
2665: IF (g_level_procedure >= g_current_runtime_level ) THEN

Line 2667: 'ZX.PLSQL.ZX_SIM_TRX_DISTRIBUTION.Update_Transaction_Lines',

2663: END IF;
2664:
2665: IF (g_level_procedure >= g_current_runtime_level ) THEN
2666: FND_LOG.STRING(g_level_procedure,
2667: 'ZX.PLSQL.ZX_SIM_TRX_DISTRIBUTION.Update_Transaction_Lines',
2668: 'Insert ZX_ITM_DISTRIBUTIONS_GT (+)');
2669: END IF;
2670:
2671: INSERT INTO ZX_ITM_DISTRIBUTIONS_GT (APPLICATION_ID,

Line 2969: 'ZX.PLSQL.ZX_SIM_TRX_DISTRIBUTION.Update_Transaction_Lines',

2965: AND TRX_ID = p_trx_id;
2966:
2967: IF (g_level_procedure >= g_current_runtime_level ) THEN
2968: FND_LOG.STRING(g_level_procedure,
2969: 'ZX.PLSQL.ZX_SIM_TRX_DISTRIBUTION.Update_Transaction_Lines',
2970: 'Insert ZX_ITM_DISTRIBUTIONS_GT (-)');
2971: END IF;
2972:
2973: BEGIN

Line 2977: 'ZX.PLSQL.ZX_SIM_TRX_DISTRIBUTION.Update_Temporary_Table',

2973: BEGIN
2974:
2975: IF (g_level_procedure >= g_current_runtime_level ) THEN
2976: FND_LOG.STRING(g_level_procedure,
2977: 'ZX.PLSQL.ZX_SIM_TRX_DISTRIBUTION.Update_Temporary_Table',
2978: 'API zx_api_pub.Determine_recovery for Update_Temporary_Table (+)');
2979: END IF;
2980:
2981:

Line 2992: 'ZX.PLSQL.ZX_SIM_TRX_DISTRIBUTION.Update_Temporary_Table',

2988: x_msg_data => l_msg_data);
2989:
2990: IF (g_level_procedure >= g_current_runtime_level ) THEN
2991: FND_LOG.STRING(g_level_procedure,
2992: 'ZX.PLSQL.ZX_SIM_TRX_DISTRIBUTION.Update_Temporary_Table',
2993: 'API zx_api_pub.Determine_recovery for Update_Temporary_Table (-)');
2994: END IF;
2995:
2996:

Line 2999: 'ZX.PLSQL.ZX_SIM_TRX_DISTRIBUTION.Update_Temporary_Table',

2995:
2996:
2997: IF (g_level_procedure >= g_current_runtime_level ) THEN
2998: FND_LOG.STRING(g_level_procedure,
2999: 'ZX.PLSQL.ZX_SIM_TRX_DISTRIBUTION.Update_Temporary_Table',
3000: 'Return Status = ' || l_return_status);
3001:
3002: FND_LOG.STRING(g_level_procedure,
3003: 'ZX.PLSQL.ZX_SIM_TRX_DISTRIBUTION.Update_Temporary_Table',

Line 3003: 'ZX.PLSQL.ZX_SIM_TRX_DISTRIBUTION.Update_Temporary_Table',

2999: 'ZX.PLSQL.ZX_SIM_TRX_DISTRIBUTION.Update_Temporary_Table',
3000: 'Return Status = ' || l_return_status);
3001:
3002: FND_LOG.STRING(g_level_procedure,
3003: 'ZX.PLSQL.ZX_SIM_TRX_DISTRIBUTION.Update_Temporary_Table',
3004: 'Message Count = ' || l_msg_count);
3005:
3006: FND_LOG.STRING(g_level_procedure,
3007: 'ZX.PLSQL.ZX_SIM_TRX_DISTRIBUTION.Update_Temporary_Table',

Line 3007: 'ZX.PLSQL.ZX_SIM_TRX_DISTRIBUTION.Update_Temporary_Table',

3003: 'ZX.PLSQL.ZX_SIM_TRX_DISTRIBUTION.Update_Temporary_Table',
3004: 'Message Count = ' || l_msg_count);
3005:
3006: FND_LOG.STRING(g_level_procedure,
3007: 'ZX.PLSQL.ZX_SIM_TRX_DISTRIBUTION.Update_Temporary_Table',
3008: 'Message data = ' || l_msg_data);
3009: END IF;
3010: END;
3011: IF (g_level_procedure >= g_current_runtime_level ) THEN

Line 3013: 'ZX.PLSQL.ZX_SIM_TRX_DISTRIBUTION.Update_Transaction_Lines',

3009: END IF;
3010: END;
3011: IF (g_level_procedure >= g_current_runtime_level ) THEN
3012: FND_LOG.STRING(g_level_procedure,
3013: 'ZX.PLSQL.ZX_SIM_TRX_DISTRIBUTION.Update_Transaction_Lines',
3014: 'Update ZX_ITM_DISTRIBUTIONS_GT (-)');
3015: END IF;
3016:
3017: EXCEPTION

Line 3027: 'ZX.PLSQL.ZX_SIM_TRX_DISTRIBUTION.Update_Transaction_Lines',

3023: FND_MSG_PUB.Add;
3024:
3025: IF (g_level_unexpected >= g_current_runtime_level ) THEN
3026: FND_LOG.STRING(g_level_unexpected,
3027: 'ZX.PLSQL.ZX_SIM_TRX_DISTRIBUTION.Update_Transaction_Lines',
3028: p_error_buffer);
3029: END IF;
3030: END Update_Transaction_Lines;
3031:

Line 3032: END ZX_SIM_TRX_DISTRIBUTION;

3028: p_error_buffer);
3029: END IF;
3030: END Update_Transaction_Lines;
3031:
3032: END ZX_SIM_TRX_DISTRIBUTION;