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 FND_LOG

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

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

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

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:
11: -------------------------------------------------------------------------------
12: -- PUBLIC PROCEDURE

Line 29: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

25: l_multi_org_flag fnd_product_groups.multi_org_flag%TYPE;
26: l_org_id NUMBER;
27:
28: 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',

Line 32: FND_LOG.STRING(g_level_procedure,

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

Line 45: FND_LOG.STRING(g_level_unexpected,

41: IF l_multi_org_flag = 'N' THEN
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;

Line 55: FND_LOG.STRING(g_level_statement,

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

Line 1024: FND_LOG.STRING(g_level_statement,

1020: AND zxdet.trx_line_id=lines.line_number)
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:

Line 2136: FND_LOG.STRING(g_level_procedure,

2132: );
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:

Line 2145: FND_LOG.STRING(g_level_unexpected,

2141: EXCEPTION
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',

Line 2148: FND_LOG.STRING(g_level_unexpected,

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(-)');
2151: END IF;
2152:

Line 2171: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

2167: l_multi_org_flag fnd_product_groups.multi_org_flag%TYPE;
2168: l_org_id NUMBER;
2169:
2170: 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',

Line 2174: FND_LOG.STRING(g_level_procedure,

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

Line 2187: FND_LOG.STRING(g_level_unexpected,

2183: IF l_multi_org_flag = 'N' THEN
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;

Line 2197: FND_LOG.STRING(g_level_statement,

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

Line 3149: FND_LOG.STRING(g_level_statement,

3145: AND ptp.party_id = DECODE(l_multi_org_flag,'N',l_org_id,lines.org_id)
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:

Line 4242: FND_LOG.STRING(g_level_procedure,

4238: AND ptp.party_type_code = 'OU'
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:

Line 4251: FND_LOG.STRING(g_level_unexpected,

4247: EXCEPTION
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',

Line 4254: FND_LOG.STRING(g_level_unexpected,

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(-)');
4257: END IF;
4258: