APPS.ZX_ON_FLY_TRX_UPGRADE_PKG dependencies on FND_API

Line 37: x_return_status := FND_API.G_RET_STS_SUCCESS;

33: 'ZX.PLSQL.ZX_ON_FLY_TRX_UPGRADE_PKG.upgrade_trx_on_fly.BEGIN',
34: 'ZX_ON_FLY_TRX_UPGRADE_PKG.upgrade_trx_on_fly(+).wrapper');
35: END IF;
36:
37: x_return_status := FND_API.G_RET_STS_SUCCESS;
38:
39: l_upg_trx_info_rec.application_id := p_application_id;
40: l_upg_trx_info_rec.entity_code := p_entity_code;
41: l_upg_trx_info_rec.event_class_code := p_event_class_code;

Line 48: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

44: upgrade_trx_on_fly( l_upg_trx_info_rec, x_return_status);
45:
46: EXCEPTION
47: WHEN OTHERS THEN
48: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
49: IF (g_level_unexpected >= g_current_runtime_level ) THEN
50: FND_LOG.STRING(g_level_unexpected,
51: 'ZX.PLSQL.ZX_ON_FLY_TRX_UPGRADE_PKG.upgrade_trx_on_fly',
52: sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80));

Line 76: x_return_status := FND_API.G_RET_STS_SUCCESS;

72: 'ZX.PLSQL.ZX_ON_FLY_TRX_UPGRADE_PKG.upgrade_trx_on_fly.BEGIN',
73: 'ZX_ON_FLY_TRX_UPGRADE_PKG.upgrade_trx_on_fly(+)');
74: END IF;
75:
76: x_return_status := FND_API.G_RET_STS_SUCCESS;
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_PKG.upgrade_trx_on_fly',

Line 109: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

105: 'ZX.PLSQL.ZX_ON_FLY_TRX_UPGRADE_PKG.upgrade_trx_on_fly',
106: 'On the fly upgrade currently not support product: '||
107: p_upg_trx_info_rec.application_id );
108: END IF;
109: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
110: END IF;
111:
112: IF (g_level_procedure >= g_current_runtime_level ) THEN
113: FND_LOG.STRING(g_level_procedure,

Line 123: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

119: END IF;
120:
121: EXCEPTION
122: WHEN OTHERS THEN
123: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
124: IF (g_level_unexpected >= g_current_runtime_level ) THEN
125: FND_LOG.STRING(g_level_unexpected,
126: 'ZX.PLSQL.ZX_ON_FLY_TRX_UPGRADE_PKG.upgrade_trx_on_fly',
127: sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80));

Line 168: x_return_status := FND_API.G_RET_STS_SUCCESS;

164: 'ZX.PLSQL.ZX_ON_FLY_TRX_UPGRADE_PKG.upgrade_trx_on_fly_blk.BEGIN',
165: 'ZX_ON_FLY_TRX_UPGRADE_PKG.upgrade_trx_on_fly_blk(+)');
166: END IF;
167:
168: x_return_status := FND_API.G_RET_STS_SUCCESS;
169:
170: FOR t IN c_distinct_app_id LOOP
171: IF t.application_id = 222 THEN
172: ZX_ON_FLY_TRX_UPGRADE_AR_PKG.upgrade_trx_on_fly_blk_ar(

Line 192: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

188: 'ZX.PLSQL.ZX_ON_FLY_TRX_UPGRADE_PKG.upgrade_trx_on_fly_blk',
189: 'On the fly upgrade currently not support product: '||
190: t.application_id );
191: END IF;
192: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
193: END IF;
194: END LOOP;
195:
196: IF (g_level_procedure >= g_current_runtime_level ) THEN

Line 207: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

203: END IF;
204:
205: EXCEPTION
206: WHEN OTHERS THEN
207: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
208: IF (g_level_unexpected >= g_current_runtime_level ) THEN
209: FND_LOG.STRING(g_level_unexpected,
210: 'ZX.PLSQL.ZX_ON_FLY_TRX_UPGRADE_PKG.upgrade_trx_on_fly_blk',
211: sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80));

Line 252: x_return_status := FND_API.G_RET_STS_SUCCESS;

248: FND_LOG.STRING(g_level_procedure,
249: 'ZX.PLSQL.ZX_ON_FLY_TRX_UPGRADE_PKG.is_trx_migrated.BEGIN',
250: 'ZX_ON_FLY_TRX_UPGRADE_PKG.is_trx_migrated(+)');
251: END IF;
252: x_return_status := FND_API.G_RET_STS_SUCCESS;
253:
254: x_trx_migrated_b := TRUE;
255: IF p_upg_trx_info_rec.TRX_LINE_ID IS NOT NULL THEN
256: SELECT count(*) into l_count

Line 285: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

281: END IF;
282:
283: EXCEPTION
284: WHEN OTHERS THEN
285: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
286: IF (g_level_unexpected >= g_current_runtime_level ) THEN
287: FND_LOG.STRING(g_level_unexpected,
288: 'ZX.PLSQL.ZX_ON_FLY_TRX_UPGRADE_PKG.is_trx_migrated',
289: sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80));