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_ON_FLY_TRX_UPGRADE_AP_PKG dependencies on ZX_ON_FLY_TRX_UPGRADE_AP_PKG

Line 1: PACKAGE BODY ZX_ON_FLY_TRX_UPGRADE_AP_PKG AS

1: PACKAGE BODY ZX_ON_FLY_TRX_UPGRADE_AP_PKG AS
2: /* $Header: zxmigtrxflyapb.pls 120.40 2011/11/25 07:47:17 prigovin ship $ */
3:
4: g_current_runtime_level NUMBER;
5: g_level_statement CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;

Line 34: 'ZX.PLSQL.ZX_ON_FLY_TRX_UPGRADE_AP_PKG.upgrade_trx_on_fly_ap.BEGIN',

30: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
31:
32: IF (g_level_procedure >= g_current_runtime_level ) THEN
33: FND_LOG.STRING(g_level_procedure,
34: 'ZX.PLSQL.ZX_ON_FLY_TRX_UPGRADE_AP_PKG.upgrade_trx_on_fly_ap.BEGIN',
35: 'ZX_ON_FLY_TRX_UPGRADE_AP_PKG.upgrade_trx_on_fly_ap(+)');
36: END IF;
37:
38: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 35: 'ZX_ON_FLY_TRX_UPGRADE_AP_PKG.upgrade_trx_on_fly_ap(+)');

31:
32: IF (g_level_procedure >= g_current_runtime_level ) THEN
33: FND_LOG.STRING(g_level_procedure,
34: 'ZX.PLSQL.ZX_ON_FLY_TRX_UPGRADE_AP_PKG.upgrade_trx_on_fly_ap.BEGIN',
35: 'ZX_ON_FLY_TRX_UPGRADE_AP_PKG.upgrade_trx_on_fly_ap(+)');
36: END IF;
37:
38: x_return_status := FND_API.G_RET_STS_SUCCESS;
39: SELECT multi_org_flag INTO l_multi_org_flag FROM fnd_product_groups;

Line 47: 'ZX.PLSQL.ZX_ON_FLY_TRX_UPGRADE_AP_PKG.upgrade_trx_on_fly_blk_ap',

43: FND_PROFILE.GET('ORG_ID',l_org_id);
44: IF l_org_id is NULL THEN
45: IF (g_level_unexpected >= g_current_runtime_level ) THEN
46: FND_LOG.STRING(g_level_unexpected,
47: 'ZX.PLSQL.ZX_ON_FLY_TRX_UPGRADE_AP_PKG.upgrade_trx_on_fly_blk_ap',
48: 'Current envionment is a Single Org environment,'||
49: ' but peofile ORG_ID is not set up');
50: END IF;
51:

Line 73: FND_LOG.STRING(G_LEVEL_UNEXPECTED,'ZX_ON_FLY_TRX_UPGRADE_AP_PKG.upgrade_trx_on_fly_ap',

69: EXCEPTION
70: WHEN OTHERS THEN
71: l_estb_id := NULL;
72: IF ( G_LEVEL_UNEXPECTED >= G_CURRENT_RUNTIME_LEVEL) THEN
73: FND_LOG.STRING(G_LEVEL_UNEXPECTED,'ZX_ON_FLY_TRX_UPGRADE_AP_PKG.upgrade_trx_on_fly_ap',
74: 'Main Establishment Not Defined ' ||SQLERRM);
75: END IF;
76: END;
77:

Line 80: 'ZX.PLSQL.ZX_ON_FLY_TRX_UPGRADE_AP_PKG.upgrade_trx_on_fly_ap',

76: END;
77:
78: IF (g_level_statement >= g_current_runtime_level ) THEN
79: FND_LOG.STRING(g_level_statement,
80: 'ZX.PLSQL.ZX_ON_FLY_TRX_UPGRADE_AP_PKG.upgrade_trx_on_fly_ap',
81: 'Inserting data into zx_lines_det_factors and zx_lines_summary');
82: END IF;
83:
84:

Line 1051: 'ZX.PLSQL.ZX_ON_FLY_TRX_UPGRADE_AP_PKG.upgrade_trx_on_fly_ap',

1047: );
1048:
1049: IF (g_level_statement >= g_current_runtime_level ) THEN
1050: FND_LOG.STRING(g_level_statement,
1051: 'ZX.PLSQL.ZX_ON_FLY_TRX_UPGRADE_AP_PKG.upgrade_trx_on_fly_ap',
1052: 'Inserting data into zx_lines and zx_rec_nrec_dist');
1053: END IF;
1054:
1055: -- Insert data into zx_lines and zx_rec_nrec_dist

Line 2186: 'ZX.PLSQL.ZX_ON_FLY_TRX_UPGRADE_AP_PKG.upgrade_trx_on_fly_ap.END',

2182:
2183:
2184: IF (g_level_procedure >= g_current_runtime_level ) THEN
2185: FND_LOG.STRING(g_level_procedure,
2186: 'ZX.PLSQL.ZX_ON_FLY_TRX_UPGRADE_AP_PKG.upgrade_trx_on_fly_ap.END',
2187: 'ZX_ON_FLY_TRX_UPGRADE_AP_PKG.upgrade_trx_on_fly_ap(+)');
2188: END IF;
2189:
2190: EXCEPTION

Line 2187: 'ZX_ON_FLY_TRX_UPGRADE_AP_PKG.upgrade_trx_on_fly_ap(+)');

2183:
2184: IF (g_level_procedure >= g_current_runtime_level ) THEN
2185: FND_LOG.STRING(g_level_procedure,
2186: 'ZX.PLSQL.ZX_ON_FLY_TRX_UPGRADE_AP_PKG.upgrade_trx_on_fly_ap.END',
2187: 'ZX_ON_FLY_TRX_UPGRADE_AP_PKG.upgrade_trx_on_fly_ap(+)');
2188: END IF;
2189:
2190: EXCEPTION
2191: WHEN OTHERS THEN

Line 2195: 'ZX.PLSQL.ZX_ON_FLY_TRX_UPGRADE_AP_PKG.upgrade_trx_on_fly_ap',

2191: WHEN OTHERS THEN
2192: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2193: IF (g_level_unexpected >= g_current_runtime_level ) THEN
2194: FND_LOG.STRING(g_level_unexpected,
2195: 'ZX.PLSQL.ZX_ON_FLY_TRX_UPGRADE_AP_PKG.upgrade_trx_on_fly_ap',
2196: sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80));
2197: FND_LOG.STRING(g_level_unexpected,
2198: 'ZX.PLSQL.ZX_ON_FLY_TRX_UPGRADE_AP_PKG.upgrade_trx_on_fly_ap.END',
2199: 'ZX_ON_FLY_TRX_UPGRADE_AP_PKG.upgrade_trx_on_fly_ap(-)');

Line 2198: 'ZX.PLSQL.ZX_ON_FLY_TRX_UPGRADE_AP_PKG.upgrade_trx_on_fly_ap.END',

2194: FND_LOG.STRING(g_level_unexpected,
2195: 'ZX.PLSQL.ZX_ON_FLY_TRX_UPGRADE_AP_PKG.upgrade_trx_on_fly_ap',
2196: sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80));
2197: FND_LOG.STRING(g_level_unexpected,
2198: 'ZX.PLSQL.ZX_ON_FLY_TRX_UPGRADE_AP_PKG.upgrade_trx_on_fly_ap.END',
2199: 'ZX_ON_FLY_TRX_UPGRADE_AP_PKG.upgrade_trx_on_fly_ap(-)');
2200: END IF;
2201:
2202: END upgrade_trx_on_fly_ap;

Line 2199: 'ZX_ON_FLY_TRX_UPGRADE_AP_PKG.upgrade_trx_on_fly_ap(-)');

2195: 'ZX.PLSQL.ZX_ON_FLY_TRX_UPGRADE_AP_PKG.upgrade_trx_on_fly_ap',
2196: sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80));
2197: FND_LOG.STRING(g_level_unexpected,
2198: 'ZX.PLSQL.ZX_ON_FLY_TRX_UPGRADE_AP_PKG.upgrade_trx_on_fly_ap.END',
2199: 'ZX_ON_FLY_TRX_UPGRADE_AP_PKG.upgrade_trx_on_fly_ap(-)');
2200: END IF;
2201:
2202: END upgrade_trx_on_fly_ap;
2203:

Line 2224: 'ZX.PLSQL.ZX_ON_FLY_TRX_UPGRADE_AP_PKG.upgrade_trx_on_fly_blk_ap.BEGIN',

2220: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
2221:
2222: IF (g_level_procedure >= g_current_runtime_level ) THEN
2223: FND_LOG.STRING(g_level_procedure,
2224: 'ZX.PLSQL.ZX_ON_FLY_TRX_UPGRADE_AP_PKG.upgrade_trx_on_fly_blk_ap.BEGIN',
2225: 'ZX_ON_FLY_TRX_UPGRADE_AP_PKG.upgrade_trx_on_fly_blk_ap(+)');
2226: END IF;
2227:
2228: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 2225: 'ZX_ON_FLY_TRX_UPGRADE_AP_PKG.upgrade_trx_on_fly_blk_ap(+)');

2221:
2222: IF (g_level_procedure >= g_current_runtime_level ) THEN
2223: FND_LOG.STRING(g_level_procedure,
2224: 'ZX.PLSQL.ZX_ON_FLY_TRX_UPGRADE_AP_PKG.upgrade_trx_on_fly_blk_ap.BEGIN',
2225: 'ZX_ON_FLY_TRX_UPGRADE_AP_PKG.upgrade_trx_on_fly_blk_ap(+)');
2226: END IF;
2227:
2228: x_return_status := FND_API.G_RET_STS_SUCCESS;
2229: SELECT multi_org_flag INTO l_multi_org_flag FROM fnd_product_groups;

Line 2237: 'ZX.PLSQL.ZX_ON_FLY_TRX_UPGRADE_AP_PKG.upgrade_trx_on_fly_blk_ar',

2233: FND_PROFILE.GET('ORG_ID',l_org_id);
2234: IF l_org_id is NULL THEN
2235: IF (g_level_unexpected >= g_current_runtime_level ) THEN
2236: FND_LOG.STRING(g_level_unexpected,
2237: 'ZX.PLSQL.ZX_ON_FLY_TRX_UPGRADE_AP_PKG.upgrade_trx_on_fly_blk_ar',
2238: 'Current envionment is a Single Org environment,'||
2239: ' but peofile ORG_ID is not set up');
2240: END IF;
2241:

Line 2247: 'ZX.PLSQL.ZX_ON_FLY_TRX_UPGRADE_AP_PKG.upgrade_trx_on_fly_blk_ap',

2243: END IF;
2244:
2245: IF (g_level_statement >= g_current_runtime_level ) THEN
2246: FND_LOG.STRING(g_level_statement,
2247: 'ZX.PLSQL.ZX_ON_FLY_TRX_UPGRADE_AP_PKG.upgrade_trx_on_fly_blk_ap',
2248: 'Inserting data into zx_lines_det_factors and zx_lines_summary');
2249: END IF;
2250:
2251: -- Insert data into zx_lines_det_factors and zx_lines_summary

Line 3201: 'ZX.PLSQL.ZX_ON_FLY_TRX_UPGRADE_AP_PKG.upgrade_trx_on_fly_blk_ap',

3197: );
3198:
3199: IF (g_level_statement >= g_current_runtime_level ) THEN
3200: FND_LOG.STRING(g_level_statement,
3201: 'ZX.PLSQL.ZX_ON_FLY_TRX_UPGRADE_AP_PKG.upgrade_trx_on_fly_blk_ap',
3202: 'Inserting data into zx_lines and zx_rec_nrec_dist');
3203: END IF;
3204:
3205: -- Insert data into zx_lines and zx_rec_nrec_dist

Line 4310: 'ZX.PLSQL.ZX_ON_FLY_TRX_UPGRADE_AP_PKG.upgrade_trx_on_fly_blk_ap.END',

4306: AND ptp.party_id = DECODE(l_multi_org_flag,'N', l_org_id, ap_dists.org_id));
4307:
4308: IF (g_level_procedure >= g_current_runtime_level ) THEN
4309: FND_LOG.STRING(g_level_procedure,
4310: 'ZX.PLSQL.ZX_ON_FLY_TRX_UPGRADE_AP_PKG.upgrade_trx_on_fly_blk_ap.END',
4311: 'ZX_ON_FLY_TRX_UPGRADE_AP_PKG.upgrade_trx_on_fly_blk_ap(+)');
4312: END IF;
4313:
4314: EXCEPTION

Line 4311: 'ZX_ON_FLY_TRX_UPGRADE_AP_PKG.upgrade_trx_on_fly_blk_ap(+)');

4307:
4308: IF (g_level_procedure >= g_current_runtime_level ) THEN
4309: FND_LOG.STRING(g_level_procedure,
4310: 'ZX.PLSQL.ZX_ON_FLY_TRX_UPGRADE_AP_PKG.upgrade_trx_on_fly_blk_ap.END',
4311: 'ZX_ON_FLY_TRX_UPGRADE_AP_PKG.upgrade_trx_on_fly_blk_ap(+)');
4312: END IF;
4313:
4314: EXCEPTION
4315: WHEN OTHERS THEN

Line 4319: 'ZX.PLSQL.ZX_ON_FLY_TRX_UPGRADE_AP_PKG.upgrade_trx_on_fly_blk_ap',

4315: WHEN OTHERS THEN
4316: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4317: IF (g_level_unexpected >= g_current_runtime_level ) THEN
4318: FND_LOG.STRING(g_level_unexpected,
4319: 'ZX.PLSQL.ZX_ON_FLY_TRX_UPGRADE_AP_PKG.upgrade_trx_on_fly_blk_ap',
4320: sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80));
4321: FND_LOG.STRING(g_level_unexpected,
4322: 'ZX.PLSQL.ZX_ON_FLY_TRX_UPGRADE_AP_PKG.upgrade_trx_on_fly_blk_ap.END',
4323: 'ZX_ON_FLY_TRX_UPGRADE_AP_PKG.upgrade_trx_on_fly_blk_ap(-)');

Line 4322: 'ZX.PLSQL.ZX_ON_FLY_TRX_UPGRADE_AP_PKG.upgrade_trx_on_fly_blk_ap.END',

4318: FND_LOG.STRING(g_level_unexpected,
4319: 'ZX.PLSQL.ZX_ON_FLY_TRX_UPGRADE_AP_PKG.upgrade_trx_on_fly_blk_ap',
4320: sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80));
4321: FND_LOG.STRING(g_level_unexpected,
4322: 'ZX.PLSQL.ZX_ON_FLY_TRX_UPGRADE_AP_PKG.upgrade_trx_on_fly_blk_ap.END',
4323: 'ZX_ON_FLY_TRX_UPGRADE_AP_PKG.upgrade_trx_on_fly_blk_ap(-)');
4324: END IF;
4325:
4326: END upgrade_trx_on_fly_blk_ap;

Line 4323: 'ZX_ON_FLY_TRX_UPGRADE_AP_PKG.upgrade_trx_on_fly_blk_ap(-)');

4319: 'ZX.PLSQL.ZX_ON_FLY_TRX_UPGRADE_AP_PKG.upgrade_trx_on_fly_blk_ap',
4320: sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80));
4321: FND_LOG.STRING(g_level_unexpected,
4322: 'ZX.PLSQL.ZX_ON_FLY_TRX_UPGRADE_AP_PKG.upgrade_trx_on_fly_blk_ap.END',
4323: 'ZX_ON_FLY_TRX_UPGRADE_AP_PKG.upgrade_trx_on_fly_blk_ap(-)');
4324: END IF;
4325:
4326: END upgrade_trx_on_fly_blk_ap;
4327:

Line 4328: END ZX_ON_FLY_TRX_UPGRADE_AP_PKG;

4324: END IF;
4325:
4326: END upgrade_trx_on_fly_blk_ap;
4327:
4328: END ZX_ON_FLY_TRX_UPGRADE_AP_PKG;
4329: