78:
79: /* Print into util file if v_debug ='Y' */
80:
81: If v_debug ='Y' Then
82: jai_cmn_utils_pkg.print_log('JAI_PLSQL_CACHE_PKG.log', ' read from db ' );
83: -- jai_cmn_utils_pkg.print_log('JAI_PLSQL_CACHE_PKG.log',
84: -- ' Inv org ledger id ' || lc_fetch_org_det.ledger_id);
85: End if;
86:
79: /* Print into util file if v_debug ='Y' */
80:
81: If v_debug ='Y' Then
82: jai_cmn_utils_pkg.print_log('JAI_PLSQL_CACHE_PKG.log', ' read from db ' );
83: -- jai_cmn_utils_pkg.print_log('JAI_PLSQL_CACHE_PKG.log',
84: -- ' Inv org ledger id ' || lc_fetch_org_det.ledger_id);
85: End if;
86:
87: --fnd_file.put_line(FND_FILE.LOG, '1. ledger id '
92: FETCH get_OU INTO lc_fetch_org_det;
93: CLOSE get_OU;
94: /* Print into util file if v_debug ='Y' */
95: If v_debug ='Y' Then
96: jai_cmn_utils_pkg.print_log('JAI_PLSQL_CACHE_PKG.log',
97: 'OU ledger id ' || lc_fetch_org_det.ledger_id);
98: End if;
99: --fnd_file.put_line(FND_FILE.LOG, ' 3. ledger id '
100: --|| lc_fetch_org_det.ledger_id);
175: */
176: /* Print into util file if v_debug ='Y' */
177:
178: If v_debug ='Y' Then
179: jai_cmn_utils_pkg.print_log('JAI_PLSQL_CACHE_PKG.log', 'from cache ledger id ' ||l_func_curr_det.ledger_id);
180: jai_cmn_utils_pkg.print_log('JAI_PLSQL_CACHE_PKG.log',
181: 'Curr code '|| l_func_curr_det.currency_code);
182: End if;
183:
176: /* Print into util file if v_debug ='Y' */
177:
178: If v_debug ='Y' Then
179: jai_cmn_utils_pkg.print_log('JAI_PLSQL_CACHE_PKG.log', 'from cache ledger id ' ||l_func_curr_det.ledger_id);
180: jai_cmn_utils_pkg.print_log('JAI_PLSQL_CACHE_PKG.log',
181: 'Curr code '|| l_func_curr_det.currency_code);
182: End if;
183:
184:
205: */
206: /* Print into util file if v_debug ='Y' */
207:
208: If v_debug ='Y' Then
209: jai_cmn_utils_pkg.print_log('JAI_PLSQL_CACHE_PKG.log', 'from db ledger id ' ||l_func_curr_det.ledger_id);
210: jai_cmn_utils_pkg.print_log('JAI_PLSQL_CACHE_PKG.log', 'Curr code '|| l_func_curr_det.currency_code);
211: End if;
212:
213: if l_func_curr_det.ledger_id is not null then
206: /* Print into util file if v_debug ='Y' */
207:
208: If v_debug ='Y' Then
209: jai_cmn_utils_pkg.print_log('JAI_PLSQL_CACHE_PKG.log', 'from db ledger id ' ||l_func_curr_det.ledger_id);
210: jai_cmn_utils_pkg.print_log('JAI_PLSQL_CACHE_PKG.log', 'Curr code '|| l_func_curr_det.currency_code);
211: End if;
212:
213: if l_func_curr_det.ledger_id is not null then
214: /*
227: */
228: /* Print into util file if v_debug ='Y' */
229:
230: If v_debug ='Y' Then
231: jai_cmn_utils_pkg.print_log('JAI_PLSQL_CACHE_PKG.log',
232: 'db value not null ledger id ' ||l_func_curr_det.ledger_id);
233: jai_cmn_utils_pkg.print_log('JAI_PLSQL_CACHE_PKG.log',
234: 'Curr code '|| l_func_curr_det.currency_code);
235: End if;
229:
230: If v_debug ='Y' Then
231: jai_cmn_utils_pkg.print_log('JAI_PLSQL_CACHE_PKG.log',
232: 'db value not null ledger id ' ||l_func_curr_det.ledger_id);
233: jai_cmn_utils_pkg.print_log('JAI_PLSQL_CACHE_PKG.log',
234: 'Curr code '|| l_func_curr_det.currency_code);
235: End if;
236: -- Write into cache the values got from db.
237: write_cache(p_org_id, l_func_curr_det);