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.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;
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.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;
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 30: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

26: l_org_id NUMBER;
27: l_estb_id NUMBER;
28:
29: 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',

Line 33: FND_LOG.STRING(g_level_procedure,

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

Line 46: FND_LOG.STRING(g_level_unexpected,

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

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 79: FND_LOG.STRING(g_level_statement,

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

Line 1050: FND_LOG.STRING(g_level_statement,

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

Line 2185: FND_LOG.STRING(g_level_procedure,

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

Line 2194: FND_LOG.STRING(g_level_unexpected,

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

Line 2197: FND_LOG.STRING(g_level_unexpected,

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(-)');
2200: END IF;
2201:

Line 2220: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

2216: l_multi_org_flag fnd_product_groups.multi_org_flag%TYPE;
2217: l_org_id NUMBER;
2218:
2219: 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',

Line 2223: FND_LOG.STRING(g_level_procedure,

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

Line 2236: FND_LOG.STRING(g_level_unexpected,

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

Line 2246: FND_LOG.STRING(g_level_statement,

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

Line 3200: FND_LOG.STRING(g_level_statement,

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

Line 4309: FND_LOG.STRING(g_level_procedure,

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

Line 4318: FND_LOG.STRING(g_level_unexpected,

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

Line 4321: FND_LOG.STRING(g_level_unexpected,

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(-)');
4324: END IF;
4325: