82:
83: BEGIN
84:
85: if (p_log_level_rec.statement_level) then
86: fa_debug_pkg.add('get_trx',
87: 'getting',
88: 'currency code - primary',
89: p_log_level_rec);
90: end if;
94: p_set_of_books_id => p_prim_set_of_books_id);
95:
96:
97: if (p_log_level_rec.statement_level) then
98: fa_debug_pkg.add('get_trx',
99: 'getting',
100: 'currency code - reporting',
101: p_log_level_rec);
102: end if;
104: l_reporting_currency_code := gl_mc_currency_pkg.get_currency_code (
105: p_set_of_books_id => p_reporting_set_of_books_id);
106:
107: if (p_log_level_rec.statement_level) then
108: fa_debug_pkg.add('get_trx',
109: 'getting',
110: 'exchange_rate',
111: p_log_level_rec);
112: end if;
131: p_denominator_rate => l_denominator_rate,
132: p_numerator_rate => l_numerator_rate);
133:
134: if (p_log_level_rec.statement_level) then
135: fa_debug_pkg.add('get_trx',
136: 'getting',
137: 'relation',
138: p_log_level_rec);
139: end if;
146: x_fixed_rate => l_fixed_rate,
147: x_relationship => l_relation);
148:
149: if (p_log_level_rec.statement_level) then
150: fa_debug_pkg.add('get_trx',
151: 'done getting',
152: 'relation', p_log_level_rec);
153: end if;
154:
298: if (p_inv_rec.feeder_system_name = 'ORACLE PAYABLES' or
299: p_inv_rec.feeder_system_name = 'ORACLE PROJECTS') then
300:
301: if (p_log_level_rec.statement_level) then
302: fa_debug_pkg.add(l_calling_fn,
303: 'getting',
304: 'currency code - reporting', p_log_level_rec);
305: end if;
306:
307: l_currency_code := gl_mc_currency_pkg.get_currency_code (
308: p_set_of_books_id => p_set_of_books_id);
309:
310: if (p_log_level_rec.statement_level) then
311: fa_debug_pkg.add(l_calling_fn,
312: 'getting',
313: 'currency code - primary', p_log_level_rec);
314: end if;
315:
318:
319: end if;
320:
321: if (p_log_level_rec.statement_level) then
322: fa_debug_pkg.add(l_calling_fn,
323: 'feeder system name',
324: p_inv_rec.feeder_system_name, p_log_level_rec);
325: end if;
326:
328: -- derive and load it... this is needed for quick/detail adds
329: -- and source line additions as well as for flexibility
330:
331: if (p_log_level_rec.statement_level) then
332: fa_debug_pkg.add('X','p sob', l_primary_sob_id, p_log_level_rec);
333: fa_debug_pkg.add('X','r sob', p_set_of_books_id, p_log_level_rec);
334: fa_debug_pkg.add('X','p date', px_exchange_date, p_log_level_rec);
335: fa_debug_pkg.add('X','p book', p_book_type_code, p_log_level_rec);
336: end if;
329: -- and source line additions as well as for flexibility
330:
331: if (p_log_level_rec.statement_level) then
332: fa_debug_pkg.add('X','p sob', l_primary_sob_id, p_log_level_rec);
333: fa_debug_pkg.add('X','r sob', p_set_of_books_id, p_log_level_rec);
334: fa_debug_pkg.add('X','p date', px_exchange_date, p_log_level_rec);
335: fa_debug_pkg.add('X','p book', p_book_type_code, p_log_level_rec);
336: end if;
337:
330:
331: if (p_log_level_rec.statement_level) then
332: fa_debug_pkg.add('X','p sob', l_primary_sob_id, p_log_level_rec);
333: fa_debug_pkg.add('X','r sob', p_set_of_books_id, p_log_level_rec);
334: fa_debug_pkg.add('X','p date', px_exchange_date, p_log_level_rec);
335: fa_debug_pkg.add('X','p book', p_book_type_code, p_log_level_rec);
336: end if;
337:
338: if not get_trx_rate
331: if (p_log_level_rec.statement_level) then
332: fa_debug_pkg.add('X','p sob', l_primary_sob_id, p_log_level_rec);
333: fa_debug_pkg.add('X','r sob', p_set_of_books_id, p_log_level_rec);
334: fa_debug_pkg.add('X','p date', px_exchange_date, p_log_level_rec);
335: fa_debug_pkg.add('X','p book', p_book_type_code, p_log_level_rec);
336: end if;
337:
338: if not get_trx_rate
339: (p_prim_set_of_books_id => l_primary_sob_id,