DBA Data[Home] [Help]

APPS.FA_DEPRN_EVENTS_PKG dependencies on FA_DEBUG_PKG

Line 70: FA_DEBUG_PKG.Initialize;

66: end if;
67:
68:
69: -- clear the debug stack for each line
70: FA_DEBUG_PKG.Initialize;
71:
72: if (g_log_level_rec.statement_level) then
73: fa_debug_pkg.add(l_calling_fn, 'at ', 'begin' ,p_log_level_rec => g_log_level_rec);
74: end if;

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

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

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

86: end if;
87:
88:
89: if (g_log_level_rec.statement_level) then
90: fa_debug_pkg.add(l_calling_fn, 'setting ', 'batch size',
91: p_log_level_rec => g_log_level_rec);
92: end if;
93:
94: l_batch_size := nvl(fa_cache_pkg.fa_batch_size, 200);

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

97: into l_deprn_run_id
98: from dual;
99:
100: if (g_log_level_rec.statement_level) then
101: fa_debug_pkg.add(l_calling_fn, 'initializing', 'debug stack',
102: p_log_level_rec => g_log_level_rec);
103: end if;
104:
105:

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

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

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 132: fa_debug_pkg.add(l_calling_fn, 'l_asset_id_tbl.count', l_asset_id_tbl.count,

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

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

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

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

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

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

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

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

203: AND book_type_code = p_book_type_code
204: AND period_counter = p_period_counter;
205:
206: if (g_log_level_rec.statement_level) then
207: fa_debug_pkg.add(l_calling_fn, 'done', 'bulk updates',
208: p_log_level_rec => g_log_level_rec);
209: end if;
210:
211: FORALL l_count in 1..l_asset_id_tbl.count

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

227: l_event_id_tbl(l_count),
228: null);
229:
230: if (g_log_level_rec.statement_level) then
231: fa_debug_pkg.add(l_calling_fn, 'done', 'bulk insert',
232: p_log_level_rec => g_log_level_rec);
233: end if;
234:
235: commit;

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

250: -- begin at index of 1 not 0 as in apis
251: FOR l_sob_index in 1..l_sob_tbl.count LOOP
252:
253: if (g_log_level_rec.statement_level) then
254: fa_debug_pkg.add(l_calling_fn, 'opening mc_deprn_events for sob', l_sob_tbl(l_sob_index),
255: p_log_level_rec => g_log_level_rec);
256: end if;
257:
258: OPEN mc_deprn_events(p_set_of_books_id => l_sob_tbl(l_sob_index),

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

261:
262: loop
263:
264: if (g_log_level_rec.statement_level) then
265: fa_debug_pkg.add(l_calling_fn, 'in', 'mrc loop',
266: p_log_level_rec => g_log_level_rec);
267: end if;
268:
269: FETCH mc_deprn_events bulk collect

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

271: l_asset_id_tbl
272: LIMIT l_batch_size;
273:
274: if (g_log_level_rec.statement_level) then
275: fa_debug_pkg.add(l_calling_fn, 'l_asset_id_tbl.count', l_asset_id_tbl.count,
276: p_log_level_rec => g_log_level_rec);
277: end if;
278:
279: if (l_asset_id_tbl.count = 0) then

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

280: exit;
281: end if;
282:
283: if (g_log_level_rec.statement_level) then
284: fa_debug_pkg.add(l_calling_fn, 'calling', 'xla event api',
285: p_log_level_rec => g_log_level_rec);
286: end if;
287:
288: fa_xla_events_pvt.create_bulk_deprn_event

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

296: p_calling_fn => l_calling_fn,
297: p_log_level_rec => g_log_level_rec);
298:
299: if (g_log_level_rec.statement_level) then
300: fa_debug_pkg.add(l_calling_fn, 'performing', 'bulk update - reporting1',
301: p_log_level_rec => g_log_level_rec);
302: end if;
303:
304: FORALL l_count in 1..l_asset_id_tbl.count

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

316: AND book_type_code = p_book_type_code
317: AND period_counter = p_period_counter;
318:
319: if (g_log_level_rec.statement_level) then
320: fa_debug_pkg.add(l_calling_fn, 'performing', 'bulk update - reporting2',
321: p_log_level_rec => g_log_level_rec);
322: end if;
323:
324: -- now process all matching mrc rows for summary

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

331: AND book_type_code = p_book_type_code
332: AND period_counter = p_period_counter;
333:
334: if (g_log_level_rec.statement_level) then
335: fa_debug_pkg.add(l_calling_fn, 'done', 'mc bulk updates',
336: p_log_level_rec => g_log_level_rec);
337: end if;
338:
339: FORALL l_count in 1..l_asset_id_tbl.count

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

355: l_event_id_tbl(l_count),
356: null);
357:
358: if (g_log_level_rec.statement_level) then
359: fa_debug_pkg.add(l_calling_fn, 'done', 'bulk insert',
360: p_log_level_rec => g_log_level_rec);
361: end if;
362:
363:

Line 485: FA_DEBUG_PKG.Initialize;

481:
482: l_batch_size := nvl(fa_cache_pkg.fa_batch_size, 200);
483:
484: -- clear the debug stack for each line
485: FA_DEBUG_PKG.Initialize;
486:
487:
488: OPEN deferred_events(p_corp_book_type_code => p_corp_book_type_code,
489: p_tax_book_type_code => p_tax_book_type_code,