684: ,p_log_level_rec => p_log_level_rec);
685:
686: if p_log_level_rec.statement_level then
687:
688: fnd_profile.get ('GL_SET_OF_BKS_ID',l_set_of_books_id);
689: l_currency_context := SUBSTRB(USERENV('CLIENT_INFO'),45,10);
690:
691: fa_debug_pkg.add(l_calling_fn,'opening', 'aj cursor'
692: ,p_log_level_rec => p_log_level_rec);
1158:
1159: begin <
1160:
1161: -- save profile sob id
1162: fnd_profile.get('GL_SET_OF_BKS_ID', l_profile_sob_id);
1163: l_currency_context := SUBSTRB(USERENV('CLIENT_INFO'),45,10);
1164:
1165: -- moving logic from fadgbi here:
1166: -- load the cache for current period counter
1260: l_mrc_sob_type_code := 'R';
1261: end if;
1262:
1263: -- set the gl_sob profile to this reporting book
1264: fnd_profile.put('GL_SET_OF_BKS_ID', c_rec.sob_id);
1265: fnd_client_info.set_currency_context (c_rec.sob_id);
1266:
1267: for row_ctr in 1..p_asset_dist_tbl.count loop --C3
1268: row_ctr_temp := row_ctr; --bug# 5523484
1480:
1481: end loop; -- end of mrc loop
1482:
1483: --put back the old value
1484: fnd_profile.put('GL_SET_OF_BKS_ID', l_profile_sob_id);
1485: fnd_client_info.set_currency_context (l_currency_context);
1486:
1487: return (TRUE);
1488:
1502: when error_found then
1503: fa_srvr_msg.add_message(calling_fn => l_calling_fn
1504: ,p_log_level_rec => p_log_level_rec);
1505: --put back the old value
1506: fnd_profile.put('GL_SET_OF_BKS_ID', l_profile_sob_id);
1507: fnd_client_info.set_currency_context (l_currency_context);
1508:
1509: return (FALSE);
1510:
1513: fa_srvr_msg.add_sql_error(calling_fn => l_calling_fn
1514: ,p_log_level_rec => p_log_level_rec);
1515:
1516: --put back the old value
1517: fnd_profile.put('GL_SET_OF_BKS_ID', l_profile_sob_id);
1518: fnd_client_info.set_currency_context (l_currency_context);
1519:
1520: return (FALSE);
1521: