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.23.12010000.2 2008/11/12 12:33:52 spasala ship $ */
3:
4: g_current_runtime_level NUMBER;
5: g_level_statement CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;

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

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

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

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

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

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

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

52: END IF;
53:
54: IF (g_level_statement >= g_current_runtime_level ) THEN
55: FND_LOG.STRING(g_level_statement,
56: 'ZX.PLSQL.ZX_ON_FLY_TRX_UPGRADE_AP_PKG.upgrade_trx_on_fly_ap',
57: 'Inserting data into zx_lines_det_factors and zx_lines_summary');
58: END IF;
59:
60:

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

1021: );
1022:
1023: IF (g_level_statement >= g_current_runtime_level ) THEN
1024: FND_LOG.STRING(g_level_statement,
1025: 'ZX.PLSQL.ZX_ON_FLY_TRX_UPGRADE_AP_PKG.upgrade_trx_on_fly_ap',
1026: 'Inserting data into zx_lines and zx_rec_nrec_dist');
1027: END IF;
1028:
1029: -- Insert data into zx_lines and zx_rec_nrec_dist

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

2133:
2134:
2135: IF (g_level_procedure >= g_current_runtime_level ) THEN
2136: FND_LOG.STRING(g_level_procedure,
2137: 'ZX.PLSQL.ZX_ON_FLY_TRX_UPGRADE_AP_PKG.upgrade_trx_on_fly_ap.END',
2138: 'ZX_ON_FLY_TRX_UPGRADE_AP_PKG.upgrade_trx_on_fly_ap(+)');
2139: END IF;
2140:
2141: EXCEPTION

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

2134:
2135: IF (g_level_procedure >= g_current_runtime_level ) THEN
2136: FND_LOG.STRING(g_level_procedure,
2137: 'ZX.PLSQL.ZX_ON_FLY_TRX_UPGRADE_AP_PKG.upgrade_trx_on_fly_ap.END',
2138: 'ZX_ON_FLY_TRX_UPGRADE_AP_PKG.upgrade_trx_on_fly_ap(+)');
2139: END IF;
2140:
2141: EXCEPTION
2142: WHEN OTHERS THEN

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

2142: WHEN OTHERS THEN
2143: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2144: IF (g_level_unexpected >= g_current_runtime_level ) THEN
2145: FND_LOG.STRING(g_level_unexpected,
2146: 'ZX.PLSQL.ZX_ON_FLY_TRX_UPGRADE_AP_PKG.upgrade_trx_on_fly_ap',
2147: sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80));
2148: FND_LOG.STRING(g_level_unexpected,
2149: 'ZX.PLSQL.ZX_ON_FLY_TRX_UPGRADE_AP_PKG.upgrade_trx_on_fly_ap.END',
2150: 'ZX_ON_FLY_TRX_UPGRADE_AP_PKG.upgrade_trx_on_fly_ap(-)');

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

2145: FND_LOG.STRING(g_level_unexpected,
2146: 'ZX.PLSQL.ZX_ON_FLY_TRX_UPGRADE_AP_PKG.upgrade_trx_on_fly_ap',
2147: sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80));
2148: FND_LOG.STRING(g_level_unexpected,
2149: 'ZX.PLSQL.ZX_ON_FLY_TRX_UPGRADE_AP_PKG.upgrade_trx_on_fly_ap.END',
2150: 'ZX_ON_FLY_TRX_UPGRADE_AP_PKG.upgrade_trx_on_fly_ap(-)');
2151: END IF;
2152:
2153: END upgrade_trx_on_fly_ap;

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

2146: 'ZX.PLSQL.ZX_ON_FLY_TRX_UPGRADE_AP_PKG.upgrade_trx_on_fly_ap',
2147: sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80));
2148: FND_LOG.STRING(g_level_unexpected,
2149: 'ZX.PLSQL.ZX_ON_FLY_TRX_UPGRADE_AP_PKG.upgrade_trx_on_fly_ap.END',
2150: 'ZX_ON_FLY_TRX_UPGRADE_AP_PKG.upgrade_trx_on_fly_ap(-)');
2151: END IF;
2152:
2153: END upgrade_trx_on_fly_ap;
2154:

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

2171: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
2172:
2173: IF (g_level_procedure >= g_current_runtime_level ) THEN
2174: FND_LOG.STRING(g_level_procedure,
2175: 'ZX.PLSQL.ZX_ON_FLY_TRX_UPGRADE_AP_PKG.upgrade_trx_on_fly_blk_ap.BEGIN',
2176: 'ZX_ON_FLY_TRX_UPGRADE_AP_PKG.upgrade_trx_on_fly_blk_ap(+)');
2177: END IF;
2178:
2179: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

2172:
2173: IF (g_level_procedure >= g_current_runtime_level ) THEN
2174: FND_LOG.STRING(g_level_procedure,
2175: 'ZX.PLSQL.ZX_ON_FLY_TRX_UPGRADE_AP_PKG.upgrade_trx_on_fly_blk_ap.BEGIN',
2176: 'ZX_ON_FLY_TRX_UPGRADE_AP_PKG.upgrade_trx_on_fly_blk_ap(+)');
2177: END IF;
2178:
2179: x_return_status := FND_API.G_RET_STS_SUCCESS;
2180: SELECT multi_org_flag INTO l_multi_org_flag FROM fnd_product_groups;

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

2184: FND_PROFILE.GET('ORG_ID',l_org_id);
2185: IF l_org_id is NULL THEN
2186: IF (g_level_unexpected >= g_current_runtime_level ) THEN
2187: FND_LOG.STRING(g_level_unexpected,
2188: 'ZX.PLSQL.ZX_ON_FLY_TRX_UPGRADE_AP_PKG.upgrade_trx_on_fly_blk_ar',
2189: 'Current envionment is a Single Org environment,'||
2190: ' but peofile ORG_ID is not set up');
2191: END IF;
2192:

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

2194: END IF;
2195:
2196: IF (g_level_statement >= g_current_runtime_level ) THEN
2197: FND_LOG.STRING(g_level_statement,
2198: 'ZX.PLSQL.ZX_ON_FLY_TRX_UPGRADE_AP_PKG.upgrade_trx_on_fly_blk_ap',
2199: 'Inserting data into zx_lines_det_factors and zx_lines_summary');
2200: END IF;
2201:
2202: -- Insert data into zx_lines_det_factors and zx_lines_summary

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

3146: );
3147:
3148: IF (g_level_statement >= g_current_runtime_level ) THEN
3149: FND_LOG.STRING(g_level_statement,
3150: 'ZX.PLSQL.ZX_ON_FLY_TRX_UPGRADE_AP_PKG.upgrade_trx_on_fly_blk_ap',
3151: 'Inserting data into zx_lines and zx_rec_nrec_dist');
3152: END IF;
3153:
3154: -- Insert data into zx_lines and zx_rec_nrec_dist

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

4239: AND ptp.party_id = DECODE(l_multi_org_flag,'N', l_org_id, ap_dists.org_id));
4240:
4241: IF (g_level_procedure >= g_current_runtime_level ) THEN
4242: FND_LOG.STRING(g_level_procedure,
4243: 'ZX.PLSQL.ZX_ON_FLY_TRX_UPGRADE_AP_PKG.upgrade_trx_on_fly_blk_ap.END',
4244: 'ZX_ON_FLY_TRX_UPGRADE_AP_PKG.upgrade_trx_on_fly_blk_ap(+)');
4245: END IF;
4246:
4247: EXCEPTION

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

4240:
4241: IF (g_level_procedure >= g_current_runtime_level ) THEN
4242: FND_LOG.STRING(g_level_procedure,
4243: 'ZX.PLSQL.ZX_ON_FLY_TRX_UPGRADE_AP_PKG.upgrade_trx_on_fly_blk_ap.END',
4244: 'ZX_ON_FLY_TRX_UPGRADE_AP_PKG.upgrade_trx_on_fly_blk_ap(+)');
4245: END IF;
4246:
4247: EXCEPTION
4248: WHEN OTHERS THEN

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

4248: WHEN OTHERS THEN
4249: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4250: IF (g_level_unexpected >= g_current_runtime_level ) THEN
4251: FND_LOG.STRING(g_level_unexpected,
4252: 'ZX.PLSQL.ZX_ON_FLY_TRX_UPGRADE_AP_PKG.upgrade_trx_on_fly_blk_ap',
4253: sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80));
4254: FND_LOG.STRING(g_level_unexpected,
4255: 'ZX.PLSQL.ZX_ON_FLY_TRX_UPGRADE_AP_PKG.upgrade_trx_on_fly_blk_ap.END',
4256: 'ZX_ON_FLY_TRX_UPGRADE_AP_PKG.upgrade_trx_on_fly_blk_ap(-)');

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

4251: FND_LOG.STRING(g_level_unexpected,
4252: 'ZX.PLSQL.ZX_ON_FLY_TRX_UPGRADE_AP_PKG.upgrade_trx_on_fly_blk_ap',
4253: sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80));
4254: FND_LOG.STRING(g_level_unexpected,
4255: 'ZX.PLSQL.ZX_ON_FLY_TRX_UPGRADE_AP_PKG.upgrade_trx_on_fly_blk_ap.END',
4256: 'ZX_ON_FLY_TRX_UPGRADE_AP_PKG.upgrade_trx_on_fly_blk_ap(-)');
4257: END IF;
4258:
4259: END upgrade_trx_on_fly_blk_ap;

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

4252: 'ZX.PLSQL.ZX_ON_FLY_TRX_UPGRADE_AP_PKG.upgrade_trx_on_fly_blk_ap',
4253: sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80));
4254: FND_LOG.STRING(g_level_unexpected,
4255: 'ZX.PLSQL.ZX_ON_FLY_TRX_UPGRADE_AP_PKG.upgrade_trx_on_fly_blk_ap.END',
4256: 'ZX_ON_FLY_TRX_UPGRADE_AP_PKG.upgrade_trx_on_fly_blk_ap(-)');
4257: END IF;
4258:
4259: END upgrade_trx_on_fly_blk_ap;
4260:

Line 4261: END ZX_ON_FLY_TRX_UPGRADE_AP_PKG;

4257: END IF;
4258:
4259: END upgrade_trx_on_fly_blk_ap;
4260:
4261: END ZX_ON_FLY_TRX_UPGRADE_AP_PKG;
4262: