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 FND_LOG

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

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;
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: 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;
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: TYPE var1_tab IS TABLE OF VARCHAR2(30) INDEX BY BINARY_INTEGER;

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: TYPE var1_tab IS TABLE OF VARCHAR2(30) INDEX BY BINARY_INTEGER;
11: trx_line_type_tab var1_tab;

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: TYPE var1_tab IS TABLE OF VARCHAR2(30) INDEX BY BINARY_INTEGER;
11: trx_line_type_tab var1_tab;
12:

Line 175: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

171: l_tax_event_type_code VARCHAR2(30);
172:
173: BEGIN
174:
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',

Line 178: FND_LOG.STRING(g_level_procedure,

174:
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',

Line 181: FND_LOG.STRING(g_level_procedure,

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

Line 490: FND_LOG.STRING(g_level_procedure,

486: p_last_update_date,
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',

Line 493: FND_LOG.STRING(g_level_procedure,

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 (-)');
496: END IF;
497:

Line 659: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

655: l_msg_data VARCHAR2(240);
656: p_error_buffer VARCHAR2(100);
657:
658: 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',

Line 662: FND_LOG.STRING(g_level_procedure,

658: 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',

Line 665: FND_LOG.STRING(g_level_procedure,

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

Line 842: FND_LOG.STRING(g_level_procedure,

838: AND TRX_LEVEL_TYPE = p_trx_level_type
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',

Line 845: FND_LOG.STRING(g_level_procedure,

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 (-)');
848: END IF;
849:

Line 1011: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

1007: l_msg_data VARCHAR2(240);
1008: p_error_buffer VARCHAR2(100);
1009:
1010: 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',

Line 1014: FND_LOG.STRING(g_level_procedure,

1010: 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',

Line 1017: FND_LOG.STRING(g_level_procedure,

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

Line 1025: FND_LOG.STRING(g_level_procedure,

1021:
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',

Line 1028: FND_LOG.STRING(g_level_procedure,

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

Line 1363: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

1359: p_error_buffer VARCHAR2(100);
1360:
1361: 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 (+)');

Line 1365: FND_LOG.STRING(g_level_procedure,

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

Line 1818: FND_LOG.STRING(g_level_procedure,

1814: APP_EXCEPTION.Raise_Exception;
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:

Line 1831: FND_LOG.STRING(g_level_unexpected,

1827: FND_MESSAGE.SET_NAME('ZX','ZX_UNEXPECTED_ERROR');
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:

Line 1865: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

1861: l_event_class_rec ZX_API_PUB.event_class_rec_type;
1862:
1863: BEGIN
1864:
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',

Line 1868: FND_LOG.STRING(g_level_procedure,

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

Line 1881: FND_LOG.STRING(g_level_procedure,

1877: AND EVENT_CLASS_CODE = p_event_class_code
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:

Line 2064: FND_LOG.STRING(g_level_procedure,

2060: AND EVENT_CLASS_CODE = p_event_class_code
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:

Line 2070: FND_LOG.STRING(g_level_procedure,

2066: 'Insert into zx_trx_headers_gt (-)');
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:

Line 2373: FND_LOG.STRING(g_level_procedure,

2369: AND TRX_ID = p_trx_id
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:

Line 2381: FND_LOG.STRING(g_level_procedure,

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

Line 2395: FND_LOG.STRING(g_level_procedure,

2391: x_msg_count => l_msg_count,
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:

Line 2402: FND_LOG.STRING(g_level_procedure,

2398: END IF;
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,

Line 2406: FND_LOG.STRING(g_level_procedure,

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',
2408: 'Message Count = ' || l_msg_count);
2409:
2410: FND_LOG.STRING(g_level_procedure,

Line 2410: FND_LOG.STRING(g_level_procedure,

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',
2412: 'Message data = ' || l_msg_data);
2413: END IF;
2414: END;

Line 2417: FND_LOG.STRING(g_level_procedure,

2413: END IF;
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:

Line 2431: FND_LOG.STRING(g_level_unexpected,

2427: FND_MESSAGE.SET_NAME('ZX','ZX_UNEXPECTED_ERROR');
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;

Line 2462: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

2458: debug_info VARCHAR2(100);
2459:
2460: 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 (+)');

Line 2464: FND_LOG.STRING(g_level_procedure,

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

Line 2471: FND_LOG.STRING(g_level_procedure,

2467: END IF;
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:

Line 2477: FND_LOG.STRING(g_level_procedure,

2473: 'Update ZX_ITM_DISTRIBUTIONS_GT (+)');
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:

Line 2660: FND_LOG.STRING(g_level_procedure,

2656: AND EVENT_CLASS_CODE = p_event_class_code
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:

Line 2666: FND_LOG.STRING(g_level_procedure,

2662: 'Insert into zx_trx_headers_gt (-)');
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:

Line 2968: FND_LOG.STRING(g_level_procedure,

2964: AND EVENT_CLASS_CODE = p_event_class_code
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:

Line 2976: FND_LOG.STRING(g_level_procedure,

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

Line 2991: FND_LOG.STRING(g_level_procedure,

2987: x_msg_count => l_msg_count,
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:

Line 2998: FND_LOG.STRING(g_level_procedure,

2994: END IF;
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,

Line 3002: FND_LOG.STRING(g_level_procedure,

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',
3004: 'Message Count = ' || l_msg_count);
3005:
3006: FND_LOG.STRING(g_level_procedure,

Line 3006: FND_LOG.STRING(g_level_procedure,

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',
3008: 'Message data = ' || l_msg_data);
3009: END IF;
3010: END;

Line 3012: FND_LOG.STRING(g_level_procedure,

3008: 'Message data = ' || l_msg_data);
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:

Line 3026: FND_LOG.STRING(g_level_unexpected,

3022: FND_MESSAGE.SET_NAME('ZX','ZX_UNEXPECTED_ERROR');
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;