eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.FA_DEPRN_EVENTS_PKG dependencies on FA_DEBUG_PKG

Line 75: FA_DEBUG_PKG.Initialize;

71: end if;
72: end if;
73:
74: -- clear the debug stack for each line
75: FA_DEBUG_PKG.Initialize;
76:
77: if (g_log_level_rec.statement_level) then
78: fa_debug_pkg.add(l_calling_fn, 'at ', 'begin' ,p_log_level_rec => g_log_level_rec);
79: end if;

Line 78: fa_debug_pkg.add(l_calling_fn, 'at ', 'begin' ,p_log_level_rec => g_log_level_rec);

74: -- clear the debug stack for each line
75: FA_DEBUG_PKG.Initialize;
76:
77: if (g_log_level_rec.statement_level) then
78: fa_debug_pkg.add(l_calling_fn, 'at ', 'begin' ,p_log_level_rec => g_log_level_rec);
79: end if;
80:
81: if not fa_cache_pkg.fazcbc(X_book => p_book_type_code,
82: p_log_level_rec => g_log_level_rec) then

Line 94: fa_debug_pkg.add(l_calling_fn, 'setting ', 'batch size',

90: raise error_found;
91: end if;
92:
93: if (g_log_level_rec.statement_level) then
94: fa_debug_pkg.add(l_calling_fn, 'setting ', 'batch size',
95: p_log_level_rec => g_log_level_rec);
96: end if;
97:
98: l_batch_size := nvl(fa_cache_pkg.fa_batch_size, 200);

Line 105: fa_debug_pkg.add(l_calling_fn, 'initializing', 'debug stack',

101: into l_deprn_run_id
102: from dual;
103:
104: if (g_log_level_rec.statement_level) then
105: fa_debug_pkg.add(l_calling_fn, 'initializing', 'debug stack',
106: p_log_level_rec => g_log_level_rec);
107: end if;
108:
109: if (g_log_level_rec.statement_level) then

Line 110: fa_debug_pkg.add(l_calling_fn, 'opening', 'deprn_events cursor',

106: p_log_level_rec => g_log_level_rec);
107: end if;
108:
109: if (g_log_level_rec.statement_level) then
110: fa_debug_pkg.add(l_calling_fn, 'opening', 'deprn_events cursor',
111: p_log_level_rec => g_log_level_rec);
112: end if;
113:
114: OPEN deprn_events(p_book_type_code => p_book_type_code,

Line 120: fa_debug_pkg.add(l_calling_fn, 'in', 'loop',

116:
117: loop
118:
119: if (g_log_level_rec.statement_level) then
120: fa_debug_pkg.add(l_calling_fn, 'in', 'loop',
121: p_log_level_rec => g_log_level_rec);
122: end if;
123:
124: FETCH deprn_events bulk collect

Line 130: fa_debug_pkg.add(l_calling_fn, 'l_asset_id_tbl.count', l_asset_id_tbl.count,

126: l_asset_id_tbl
127: LIMIT l_batch_size;
128:
129: if (g_log_level_rec.statement_level) then
130: fa_debug_pkg.add(l_calling_fn, 'l_asset_id_tbl.count', l_asset_id_tbl.count,
131: p_log_level_rec => g_log_level_rec);
132: end if;
133:
134: if (l_asset_id_tbl.count = 0) then

Line 139: fa_debug_pkg.add(l_calling_fn, 'calling', 'xla event api',

135: exit;
136: end if;
137:
138: if (g_log_level_rec.statement_level) then
139: fa_debug_pkg.add(l_calling_fn, 'calling', 'xla event api',
140: p_log_level_rec => g_log_level_rec);
141: end if;
142:
143: l_event_date :=

Line 161: fa_debug_pkg.add(l_calling_fn, 'performing', 'bulk update - primary',

157: p_calling_fn => l_calling_fn,
158: p_log_level_rec => g_log_level_rec);
159:
160: if (g_log_level_rec.statement_level) then
161: fa_debug_pkg.add(l_calling_fn, 'performing', 'bulk update - primary',
162: p_log_level_rec => g_log_level_rec);
163: end if;
164:
165: FORALL l_count in 1..l_asset_id_tbl.count

Line 180: fa_debug_pkg.add(l_calling_fn, 'performing', 'bulk update - reporting',

176: AND book_type_code = p_book_type_code
177: AND period_counter = p_period_counter;
178:
179: if (g_log_level_rec.statement_level) then
180: fa_debug_pkg.add(l_calling_fn, 'performing', 'bulk update - reporting',
181: p_log_level_rec => g_log_level_rec);
182: end if;
183:
184: -- now process all matching mrc rows

Line 202: fa_debug_pkg.add(l_calling_fn, 'done', 'bulk updates',

198: AND book_type_code = p_book_type_code
199: AND period_counter = p_period_counter;
200:
201: if (g_log_level_rec.statement_level) then
202: fa_debug_pkg.add(l_calling_fn, 'done', 'bulk updates',
203: p_log_level_rec => g_log_level_rec);
204: end if;
205:
206: FORALL l_count in 1..l_asset_id_tbl.count

Line 226: fa_debug_pkg.add(l_calling_fn, 'done', 'bulk insert',

222: l_event_id_tbl(l_count),
223: null);
224:
225: if (g_log_level_rec.statement_level) then
226: fa_debug_pkg.add(l_calling_fn, 'done', 'bulk insert',
227: p_log_level_rec => g_log_level_rec);
228: end if;
229:
230: commit;

Line 237: fa_debug_pkg.add(l_calling_fn, 'before', 'secondary bulk insert',

233: l_secondary_sob_id := FA_XLA_EVENTS_PVT.get_secondary_sob_id(p_book_type_code);
234: if(l_secondary_sob_id is not null) then
235:
236: if (g_log_level_rec.statement_level) then
237: fa_debug_pkg.add(l_calling_fn, 'before', 'secondary bulk insert',
238: p_log_level_rec => g_log_level_rec);
239: end if;
240:
241: select fa_deprn_summary_s.nextval

Line 258: fa_debug_pkg.add(l_calling_fn, 'after', 'secondary bulk insert',

254: p_calling_fn => l_calling_fn,
255: p_log_level_rec => g_log_level_rec);
256:
257: if (g_log_level_rec.statement_level) then
258: fa_debug_pkg.add(l_calling_fn, 'after', 'secondary bulk insert',
259: p_log_level_rec => g_log_level_rec);
260: end if;
261:
262: FORALL l_count in 1..l_asset_id_tbl.count

Line 299: fa_debug_pkg.add(l_calling_fn, 'opening mc_deprn_events for sob', l_sob_tbl(l_sob_index),

295: -- begin at index of 1 not 0 as in apis
296: FOR l_sob_index in 1..l_sob_tbl.count LOOP
297:
298: if (g_log_level_rec.statement_level) then
299: fa_debug_pkg.add(l_calling_fn, 'opening mc_deprn_events for sob', l_sob_tbl(l_sob_index),
300: p_log_level_rec => g_log_level_rec);
301: end if;
302:
303: OPEN mc_deprn_events(p_set_of_books_id => l_sob_tbl(l_sob_index),

Line 310: fa_debug_pkg.add(l_calling_fn, 'in', 'mrc loop',

306:
307: loop
308:
309: if (g_log_level_rec.statement_level) then
310: fa_debug_pkg.add(l_calling_fn, 'in', 'mrc loop',
311: p_log_level_rec => g_log_level_rec);
312: end if;
313:
314: FETCH mc_deprn_events bulk collect

Line 320: fa_debug_pkg.add(l_calling_fn, 'l_asset_id_tbl.count', l_asset_id_tbl.count,

316: l_asset_id_tbl
317: LIMIT l_batch_size;
318:
319: if (g_log_level_rec.statement_level) then
320: fa_debug_pkg.add(l_calling_fn, 'l_asset_id_tbl.count', l_asset_id_tbl.count,
321: p_log_level_rec => g_log_level_rec);
322: end if;
323:
324: if (l_asset_id_tbl.count = 0) then

Line 337: fa_debug_pkg.add(l_calling_fn, 'calling', 'xla event api',

333: sysdate),
334: sysdate));
335:
336: if (g_log_level_rec.statement_level) then
337: fa_debug_pkg.add(l_calling_fn, 'calling', 'xla event api',
338: p_log_level_rec => g_log_level_rec);
339: end if;
340:
341: fa_xla_events_pvt.create_bulk_deprn_event

Line 353: fa_debug_pkg.add(l_calling_fn, 'performing', 'bulk update - reporting1',

349: p_calling_fn => l_calling_fn,
350: p_log_level_rec => g_log_level_rec);
351:
352: if (g_log_level_rec.statement_level) then
353: fa_debug_pkg.add(l_calling_fn, 'performing', 'bulk update - reporting1',
354: p_log_level_rec => g_log_level_rec);
355: end if;
356:
357: FORALL l_count in 1..l_asset_id_tbl.count

Line 372: fa_debug_pkg.add(l_calling_fn, 'performing', 'bulk update - reporting2',

368: AND book_type_code = p_book_type_code
369: AND period_counter = p_period_counter;
370:
371: if (g_log_level_rec.statement_level) then
372: fa_debug_pkg.add(l_calling_fn, 'performing', 'bulk update - reporting2',
373: p_log_level_rec => g_log_level_rec);
374: end if;
375:
376: -- now process all matching mrc rows for summary

Line 387: fa_debug_pkg.add(l_calling_fn, 'done', 'mc bulk updates',

383: AND book_type_code = p_book_type_code
384: AND period_counter = p_period_counter;
385:
386: if (g_log_level_rec.statement_level) then
387: fa_debug_pkg.add(l_calling_fn, 'done', 'mc bulk updates',
388: p_log_level_rec => g_log_level_rec);
389: end if;
390:
391: FORALL l_count in 1..l_asset_id_tbl.count

Line 411: fa_debug_pkg.add(l_calling_fn, 'done', 'bulk insert',

407: l_event_id_tbl(l_count),
408: null);
409:
410: if (g_log_level_rec.statement_level) then
411: fa_debug_pkg.add(l_calling_fn, 'done', 'bulk insert',
412: p_log_level_rec => g_log_level_rec);
413: end if;
414:
415: end loop;

Line 493: fa_debug_pkg.add(l_calling_fn, 'at ', 'begin' ,p_log_level_rec => p_log_level_rec);

489:
490: BEGIN
491:
492: if (p_log_level_rec.statement_level) then
493: fa_debug_pkg.add(l_calling_fn, 'at ', 'begin' ,p_log_level_rec => p_log_level_rec);
494: end if;
495:
496: if not fa_cache_pkg.fazcbc(X_book => p_book_type_code,
497: p_log_level_rec => p_log_level_rec) then

Line 513: fa_debug_pkg.add(l_calling_fn, 'calling', 'xla event api',

509: into l_deprn_run_id
510: from dual;
511:
512: if (p_log_level_rec.statement_level) then
513: fa_debug_pkg.add(l_calling_fn, 'calling', 'xla event api',
514: p_log_level_rec => p_log_level_rec);
515: end if;
516:
517: l_event_date :=

Line 535: fa_debug_pkg.add(l_calling_fn, 'Updating', 'primary deprn',

531: p_calling_fn => l_calling_fn,
532: p_log_level_rec => p_log_level_rec);
533:
534: if (p_log_level_rec.statement_level) then
535: fa_debug_pkg.add(l_calling_fn, 'Updating', 'primary deprn',
536: p_log_level_rec => p_log_level_rec);
537: end if;
538:
539: UPDATE FA_DEPRN_SUMMARY

Line 554: fa_debug_pkg.add(l_calling_fn, 'Updating', 'reporting deprn',

550: AND book_type_code = p_book_type_code
551: AND period_counter = p_period_counter;
552:
553: if (p_log_level_rec.statement_level) then
554: fa_debug_pkg.add(l_calling_fn, 'Updating', 'reporting deprn',
555: p_log_level_rec => p_log_level_rec);
556: end if;
557:
558: UPDATE FA_MC_DEPRN_SUMMARY

Line 573: fa_debug_pkg.add(l_calling_fn, 'Inserting', 'deprn_events',

569: AND book_type_code = p_book_type_code
570: AND period_counter = p_period_counter;
571:
572: if (p_log_level_rec.statement_level) then
573: fa_debug_pkg.add(l_calling_fn, 'Inserting', 'deprn_events',
574: p_log_level_rec => p_log_level_rec);
575: end if;
576:
577: INSERT into fa_deprn_events

Line 600: fa_debug_pkg.add(l_calling_fn, 'before', 'secondary event creation',

596: l_secondary_sob_id := FA_XLA_EVENTS_PVT.get_secondary_sob_id(p_book_type_code);
597: if(l_secondary_sob_id is not null) then
598:
599: if (p_log_level_rec.statement_level) then
600: fa_debug_pkg.add(l_calling_fn, 'before', 'secondary event creation',
601: p_log_level_rec => p_log_level_rec);
602: end if;
603:
604: select fa_deprn_summary_s.nextval

Line 620: fa_debug_pkg.add(l_calling_fn, 'Updating', 'secondary deprn',

616: p_calling_fn => l_calling_fn,
617: p_log_level_rec => p_log_level_rec);
618:
619: if (p_log_level_rec.statement_level) then
620: fa_debug_pkg.add(l_calling_fn, 'Updating', 'secondary deprn',
621: p_log_level_rec => p_log_level_rec);
622: end if;
623:
624: UPDATE FA_MC_DEPRN_SUMMARY