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
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',
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
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',