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;
40:
41: -- for single org environment, get value of org_id from profile
42: IF l_multi_org_flag = 'N' THEN
2188: END IF;
2189:
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));
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;
2230:
2231: -- for single org environment, get value of org_id from profile
2232: IF l_multi_org_flag = 'N' THEN
4312: END IF;
4313:
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));