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_IMPAIRMENT_DELETE_PVT dependencies on FA_DEBUG_PKG

Line 79: fa_debug_pkg.add(l_calling_fn,'Begin', p_book_type_code, p_log_level_rec => p_log_level_rec);

75:
76: BEGIN
77:
78: if (p_log_level_rec.statement_level) then
79: fa_debug_pkg.add(l_calling_fn,'Begin', p_book_type_code, p_log_level_rec => p_log_level_rec);
80: end if;
81:
82: if (p_mrc_sob_type_code = 'R') then
83: if G_release = 11 then

Line 118: fa_debug_pkg.add(l_calling_fn,'after rollback_deprn_event ', '', p_log_level_rec => p_log_level_rec);

114: raise del_err;
115: end if;
116: end loop;
117: if (p_log_level_rec.statement_level) then
118: fa_debug_pkg.add(l_calling_fn,'after rollback_deprn_event *********', '*********', p_log_level_rec => p_log_level_rec);
119: end if;
120: for i in 1..t_asset_id.count loop
121: if not rollback_impair_event(p_request_id,
122: p_book_type_code,

Line 132: fa_debug_pkg.add(l_calling_fn,'after rollback_impair_event ', '', p_log_level_rec => p_log_level_rec);

128: raise del_err;
129: end if;
130: end loop;
131: if (p_log_level_rec.statement_level) then
132: fa_debug_pkg.add(l_calling_fn,'after rollback_impair_event *********', '*********', p_log_level_rec => p_log_level_rec);
133: end if;
134: close c_mc_get_recs;
135: end if;
136:

Line 223: fa_debug_pkg.add(l_calling_fn,'after rollback_deprn_event ', '', p_log_level_rec => p_log_level_rec);

219: raise del_err;
220: end if;
221: end loop;
222: if (p_log_level_rec.statement_level) then
223: fa_debug_pkg.add(l_calling_fn,'after rollback_deprn_event *********', '*********', p_log_level_rec => p_log_level_rec);
224: end if;
225: for i in 1..t_asset_id.count loop
226: if not rollback_impair_event(p_request_id,
227: p_book_type_code,

Line 237: fa_debug_pkg.add(l_calling_fn,'after rollback_impair_event ', '', p_log_level_rec => p_log_level_rec);

233: raise del_err;
234: end if;
235: end loop;
236: if (p_log_level_rec.statement_level) then
237: fa_debug_pkg.add(l_calling_fn,'after rollback_impair_event *********', '*********', p_log_level_rec => p_log_level_rec);
238: end if;
239: close c_get_recs;
240: end if;
241:

Line 296: fa_debug_pkg.add(l_calling_fn,'Manual Override', 'BEGIN', p_log_level_rec => p_log_level_rec);

292: and worker_id = p_worker_id
293: and period_counter = p_period_rec.period_counter;
294:
295: if (p_log_level_rec.statement_level) then
296: fa_debug_pkg.add(l_calling_fn,'Manual Override', 'BEGIN', p_log_level_rec => p_log_level_rec);
297: end if;
298:
299: fa_std_types.deprn_override_trigger_enabled:= FALSE;
300:

Line 315: fa_debug_pkg.add(l_calling_fn,'End', p_book_type_code, p_log_level_rec => p_log_level_rec);

311:
312: end if;
313:
314: if (p_log_level_rec.statement_level) then
315: fa_debug_pkg.add(l_calling_fn,'End', p_book_type_code, p_log_level_rec => p_log_level_rec);
316: end if;
317:
318: return true;
319:

Line 324: fa_debug_pkg.add(l_calling_fn,'EXCEPTION', 'del_err', p_log_level_rec => p_log_level_rec);

320: EXCEPTION
321: WHEN del_err THEN
322:
323: if (p_log_level_rec.statement_level) then
324: fa_debug_pkg.add(l_calling_fn,'EXCEPTION', 'del_err', p_log_level_rec => p_log_level_rec);
325: fa_debug_pkg.add(l_calling_fn,'sqlerrm', substrb(sqlerrm, 1, 200));
326: end if;
327:
328: return false;

Line 325: fa_debug_pkg.add(l_calling_fn,'sqlerrm', substrb(sqlerrm, 1, 200));

321: WHEN del_err THEN
322:
323: if (p_log_level_rec.statement_level) then
324: fa_debug_pkg.add(l_calling_fn,'EXCEPTION', 'del_err', p_log_level_rec => p_log_level_rec);
325: fa_debug_pkg.add(l_calling_fn,'sqlerrm', substrb(sqlerrm, 1, 200));
326: end if;
327:
328: return false;
329:

Line 333: fa_debug_pkg.add(l_calling_fn,'EXCEPTION', 'OTHERS', p_log_level_rec => p_log_level_rec);

329:
330: WHEN OTHERS THEN
331:
332: if (p_log_level_rec.statement_level) then
333: fa_debug_pkg.add(l_calling_fn,'EXCEPTION', 'OTHERS', p_log_level_rec => p_log_level_rec);
334: fa_debug_pkg.add(l_calling_fn,'sqlerrm', substrb(sqlerrm, 1, 200));
335: end if;
336:
337: return false;

Line 334: fa_debug_pkg.add(l_calling_fn,'sqlerrm', substrb(sqlerrm, 1, 200));

330: WHEN OTHERS THEN
331:
332: if (p_log_level_rec.statement_level) then
333: fa_debug_pkg.add(l_calling_fn,'EXCEPTION', 'OTHERS', p_log_level_rec => p_log_level_rec);
334: fa_debug_pkg.add(l_calling_fn,'sqlerrm', substrb(sqlerrm, 1, 200));
335: end if;
336:
337: return false;
338:

Line 361: fa_debug_pkg.add(l_calling_fn, 'Begins ', 'process_impair_event',p_log_level_rec => p_log_level_rec);

357: l_calling_fn varchar2(60) := 'FA_IMPAIRMENT_DELETE_PVT.process_impair_event';
358:
359: begin
360: if (p_log_level_rec.statement_level) then
361: fa_debug_pkg.add(l_calling_fn, 'Begins ', 'process_impair_event',p_log_level_rec => p_log_level_rec);
362: fa_debug_pkg.add(l_calling_fn, 'p_book_type_code ', p_book_type_code,p_log_level_rec => p_log_level_rec);
363: fa_debug_pkg.add(l_calling_fn, 'p_mrc_sob_type_code ', p_mrc_sob_type_code,p_log_level_rec => p_log_level_rec);
364: fa_debug_pkg.add(l_calling_fn, 'p_set_of_books_id ', p_set_of_books_id,p_log_level_rec => p_log_level_rec);
365: fa_debug_pkg.add(l_calling_fn, 'p_thid count ', p_thid.count ,p_log_level_rec => p_log_level_rec);

Line 362: fa_debug_pkg.add(l_calling_fn, 'p_book_type_code ', p_book_type_code,p_log_level_rec => p_log_level_rec);

358:
359: begin
360: if (p_log_level_rec.statement_level) then
361: fa_debug_pkg.add(l_calling_fn, 'Begins ', 'process_impair_event',p_log_level_rec => p_log_level_rec);
362: fa_debug_pkg.add(l_calling_fn, 'p_book_type_code ', p_book_type_code,p_log_level_rec => p_log_level_rec);
363: fa_debug_pkg.add(l_calling_fn, 'p_mrc_sob_type_code ', p_mrc_sob_type_code,p_log_level_rec => p_log_level_rec);
364: fa_debug_pkg.add(l_calling_fn, 'p_set_of_books_id ', p_set_of_books_id,p_log_level_rec => p_log_level_rec);
365: fa_debug_pkg.add(l_calling_fn, 'p_thid count ', p_thid.count ,p_log_level_rec => p_log_level_rec);
366: end if;

Line 363: fa_debug_pkg.add(l_calling_fn, 'p_mrc_sob_type_code ', p_mrc_sob_type_code,p_log_level_rec => p_log_level_rec);

359: begin
360: if (p_log_level_rec.statement_level) then
361: fa_debug_pkg.add(l_calling_fn, 'Begins ', 'process_impair_event',p_log_level_rec => p_log_level_rec);
362: fa_debug_pkg.add(l_calling_fn, 'p_book_type_code ', p_book_type_code,p_log_level_rec => p_log_level_rec);
363: fa_debug_pkg.add(l_calling_fn, 'p_mrc_sob_type_code ', p_mrc_sob_type_code,p_log_level_rec => p_log_level_rec);
364: fa_debug_pkg.add(l_calling_fn, 'p_set_of_books_id ', p_set_of_books_id,p_log_level_rec => p_log_level_rec);
365: fa_debug_pkg.add(l_calling_fn, 'p_thid count ', p_thid.count ,p_log_level_rec => p_log_level_rec);
366: end if;
367:

Line 364: fa_debug_pkg.add(l_calling_fn, 'p_set_of_books_id ', p_set_of_books_id,p_log_level_rec => p_log_level_rec);

360: if (p_log_level_rec.statement_level) then
361: fa_debug_pkg.add(l_calling_fn, 'Begins ', 'process_impair_event',p_log_level_rec => p_log_level_rec);
362: fa_debug_pkg.add(l_calling_fn, 'p_book_type_code ', p_book_type_code,p_log_level_rec => p_log_level_rec);
363: fa_debug_pkg.add(l_calling_fn, 'p_mrc_sob_type_code ', p_mrc_sob_type_code,p_log_level_rec => p_log_level_rec);
364: fa_debug_pkg.add(l_calling_fn, 'p_set_of_books_id ', p_set_of_books_id,p_log_level_rec => p_log_level_rec);
365: fa_debug_pkg.add(l_calling_fn, 'p_thid count ', p_thid.count ,p_log_level_rec => p_log_level_rec);
366: end if;
367:
368: l_event_date :=

Line 365: fa_debug_pkg.add(l_calling_fn, 'p_thid count ', p_thid.count ,p_log_level_rec => p_log_level_rec);

361: fa_debug_pkg.add(l_calling_fn, 'Begins ', 'process_impair_event',p_log_level_rec => p_log_level_rec);
362: fa_debug_pkg.add(l_calling_fn, 'p_book_type_code ', p_book_type_code,p_log_level_rec => p_log_level_rec);
363: fa_debug_pkg.add(l_calling_fn, 'p_mrc_sob_type_code ', p_mrc_sob_type_code,p_log_level_rec => p_log_level_rec);
364: fa_debug_pkg.add(l_calling_fn, 'p_set_of_books_id ', p_set_of_books_id,p_log_level_rec => p_log_level_rec);
365: fa_debug_pkg.add(l_calling_fn, 'p_thid count ', p_thid.count ,p_log_level_rec => p_log_level_rec);
366: end if;
367:
368: l_event_date :=
369: greatest(fa_cache_pkg.fazcdp_record.calendar_period_open_date,

Line 375: fa_debug_pkg.add(l_calling_fn, 'Before inserting into : ', 'xla_events_int_gt',p_log_level_rec => p_log_level_rec);

371: sysdate),
372: sysdate));
373:
374: if (p_log_level_rec.statement_level) then
375: fa_debug_pkg.add(l_calling_fn, 'Before inserting into : ', 'xla_events_int_gt',p_log_level_rec => p_log_level_rec);
376: end if;
377: -- load the array as required by SLA:
378: -- verify event number and transaction number relevance here
379: -- since neither table uses a transaction sequence

Line 415: fa_debug_pkg.add(l_calling_fn, 'calling : ', 'create_bulk_events',p_log_level_rec => p_log_level_rec);

411: p_book_type_code
412: );
413:
414: if (p_log_level_rec.statement_level) then
415: fa_debug_pkg.add(l_calling_fn, 'calling : ', 'create_bulk_events',p_log_level_rec => p_log_level_rec);
416: end if;
417:
418: XLA_EVENTS_PUB_PKG.create_bulk_events
419: (p_source_application_id => NULL,

Line 427: fa_debug_pkg.add(l_calling_fn, 'Created events ', 'SUCCESSFULLY',p_log_level_rec => p_log_level_rec);

423: p_entity_type_code => 'TRANSACTIONS'
424: );
425:
426: if (p_log_level_rec.statement_level) then
427: fa_debug_pkg.add(l_calling_fn, 'Created events ', 'SUCCESSFULLY',p_log_level_rec => p_log_level_rec);
428: end if;
429: --Fetch event ids created.
430: select event_id,source_id_int_1 bulk collect
431: into l_event_id_tbl,l_thid

Line 436: fa_debug_pkg.add(l_calling_fn, 'Updating event id in : ', 'fa_transaction_headers',p_log_level_rec => p_log_level_rec);

432: from xla_events_int_gt;
433:
434:
435: if (p_log_level_rec.statement_level) then
436: fa_debug_pkg.add(l_calling_fn, 'Updating event id in : ', 'fa_transaction_headers',p_log_level_rec => p_log_level_rec);
437: end if;
438:
439: FORALL i in 1..l_thid.count
440: UPDATE FA_TRANSACTION_HEADERS

Line 446: fa_debug_pkg.add(l_calling_fn, 'process_impair_event', 'ends',p_log_level_rec => p_log_level_rec);

442: WHERE TRANSACTION_HEADER_ID = l_thid(i)
443: AND BOOK_TYPE_CODE = p_book_type_code;
444:
445: if (p_log_level_rec.statement_level) then
446: fa_debug_pkg.add(l_calling_fn, 'process_impair_event', 'ends',p_log_level_rec => p_log_level_rec);
447: end if;
448:
449: return true;
450: EXCEPTION

Line 492: fa_debug_pkg.add(l_calling_fn, 'Rollback_deprn_event ', 'Begins',p_log_level_rec => p_log_level_rec);

488: rb_err exception;
489:
490: begin
491: if (p_log_level_rec.statement_level) then
492: fa_debug_pkg.add(l_calling_fn, 'Rollback_deprn_event ', 'Begins',p_log_level_rec => p_log_level_rec);
493: fa_debug_pkg.add(l_calling_fn, 'p_book_type_code ', p_book_type_code,p_log_level_rec => p_log_level_rec);
494: fa_debug_pkg.add(l_calling_fn, 'p_asset_id ', p_asset_id ,p_log_level_rec => p_log_level_rec);
495: fa_debug_pkg.add(l_calling_fn, 'p_mrc_sob_type_code ', p_mrc_sob_type_code,p_log_level_rec => p_log_level_rec);
496: fa_debug_pkg.add(l_calling_fn, 'p_set_of_books_id ', p_set_of_books_id,p_log_level_rec => p_log_level_rec);

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

489:
490: begin
491: if (p_log_level_rec.statement_level) then
492: fa_debug_pkg.add(l_calling_fn, 'Rollback_deprn_event ', 'Begins',p_log_level_rec => p_log_level_rec);
493: fa_debug_pkg.add(l_calling_fn, 'p_book_type_code ', p_book_type_code,p_log_level_rec => p_log_level_rec);
494: fa_debug_pkg.add(l_calling_fn, 'p_asset_id ', p_asset_id ,p_log_level_rec => p_log_level_rec);
495: fa_debug_pkg.add(l_calling_fn, 'p_mrc_sob_type_code ', p_mrc_sob_type_code,p_log_level_rec => p_log_level_rec);
496: fa_debug_pkg.add(l_calling_fn, 'p_set_of_books_id ', p_set_of_books_id,p_log_level_rec => p_log_level_rec);
497: end if;

Line 494: fa_debug_pkg.add(l_calling_fn, 'p_asset_id ', p_asset_id ,p_log_level_rec => p_log_level_rec);

490: begin
491: if (p_log_level_rec.statement_level) then
492: fa_debug_pkg.add(l_calling_fn, 'Rollback_deprn_event ', 'Begins',p_log_level_rec => p_log_level_rec);
493: fa_debug_pkg.add(l_calling_fn, 'p_book_type_code ', p_book_type_code,p_log_level_rec => p_log_level_rec);
494: fa_debug_pkg.add(l_calling_fn, 'p_asset_id ', p_asset_id ,p_log_level_rec => p_log_level_rec);
495: fa_debug_pkg.add(l_calling_fn, 'p_mrc_sob_type_code ', p_mrc_sob_type_code,p_log_level_rec => p_log_level_rec);
496: fa_debug_pkg.add(l_calling_fn, 'p_set_of_books_id ', p_set_of_books_id,p_log_level_rec => p_log_level_rec);
497: end if;
498:

Line 495: fa_debug_pkg.add(l_calling_fn, 'p_mrc_sob_type_code ', p_mrc_sob_type_code,p_log_level_rec => p_log_level_rec);

491: if (p_log_level_rec.statement_level) then
492: fa_debug_pkg.add(l_calling_fn, 'Rollback_deprn_event ', 'Begins',p_log_level_rec => p_log_level_rec);
493: fa_debug_pkg.add(l_calling_fn, 'p_book_type_code ', p_book_type_code,p_log_level_rec => p_log_level_rec);
494: fa_debug_pkg.add(l_calling_fn, 'p_asset_id ', p_asset_id ,p_log_level_rec => p_log_level_rec);
495: fa_debug_pkg.add(l_calling_fn, 'p_mrc_sob_type_code ', p_mrc_sob_type_code,p_log_level_rec => p_log_level_rec);
496: fa_debug_pkg.add(l_calling_fn, 'p_set_of_books_id ', p_set_of_books_id,p_log_level_rec => p_log_level_rec);
497: end if;
498:
499: if (NOT FA_UTIL_PVT.get_period_rec (

Line 496: fa_debug_pkg.add(l_calling_fn, 'p_set_of_books_id ', p_set_of_books_id,p_log_level_rec => p_log_level_rec);

492: fa_debug_pkg.add(l_calling_fn, 'Rollback_deprn_event ', 'Begins',p_log_level_rec => p_log_level_rec);
493: fa_debug_pkg.add(l_calling_fn, 'p_book_type_code ', p_book_type_code,p_log_level_rec => p_log_level_rec);
494: fa_debug_pkg.add(l_calling_fn, 'p_asset_id ', p_asset_id ,p_log_level_rec => p_log_level_rec);
495: fa_debug_pkg.add(l_calling_fn, 'p_mrc_sob_type_code ', p_mrc_sob_type_code,p_log_level_rec => p_log_level_rec);
496: fa_debug_pkg.add(l_calling_fn, 'p_set_of_books_id ', p_set_of_books_id,p_log_level_rec => p_log_level_rec);
497: end if;
498:
499: if (NOT FA_UTIL_PVT.get_period_rec (
500: p_book => p_book_type_code,

Line 509: fa_debug_pkg.add(l_calling_fn,'fetched', 'period rec', p_log_level_rec => p_log_level_rec);

505: raise rb_err;
506: end if;
507:
508: if (p_log_level_rec.statement_level) then
509: fa_debug_pkg.add(l_calling_fn,'fetched', 'period rec', p_log_level_rec => p_log_level_rec);
510: end if;
511: l_secondary_sob_id := FA_XLA_EVENTS_PVT.get_secondary_sob_id(p_book_type_code);
512: if (l_secondary_sob_id > 0) then
513: l_secondary_event_id := FA_XLA_EVENTS_PVT.get_secondary_event_id(p_book_type_code,

Line 531: fa_debug_pkg.add(l_calling_fn, 'l_event_id', l_event_id,p_log_level_rec => p_log_level_rec);

527: and de.period_counter = l_period_rec.period_counter
528: and de.reversal_event_id is null;
529:
530: if (p_log_level_rec.statement_level) then
531: fa_debug_pkg.add(l_calling_fn, 'l_event_id', l_event_id,p_log_level_rec => p_log_level_rec);
532: fa_debug_pkg.add(l_calling_fn, 'l_deprn_run_id', l_deprn_run_id, p_log_level_rec => p_log_level_rec);
533: end if;
534: EXCEPTION
535:

Line 532: fa_debug_pkg.add(l_calling_fn, 'l_deprn_run_id', l_deprn_run_id, p_log_level_rec => p_log_level_rec);

528: and de.reversal_event_id is null;
529:
530: if (p_log_level_rec.statement_level) then
531: fa_debug_pkg.add(l_calling_fn, 'l_event_id', l_event_id,p_log_level_rec => p_log_level_rec);
532: fa_debug_pkg.add(l_calling_fn, 'l_deprn_run_id', l_deprn_run_id, p_log_level_rec => p_log_level_rec);
533: end if;
534: EXCEPTION
535:
536: WHEN NO_DATA_FOUND THEN

Line 538: fa_debug_pkg.add(l_calling_fn, 'no event found for this asset',p_asset_id,p_log_level_rec => p_log_level_rec);

534: EXCEPTION
535:
536: WHEN NO_DATA_FOUND THEN
537: if (p_log_level_rec.statement_level) then
538: fa_debug_pkg.add(l_calling_fn, 'no event found for this asset',p_asset_id,p_log_level_rec => p_log_level_rec);
539: end if;
540: END;
541: end if;
542: if (p_log_level_rec.statement_level) then

Line 543: fa_debug_pkg.add(l_calling_fn,'fetched event_id :', l_event_id, p_log_level_rec => p_log_level_rec);

539: end if;
540: END;
541: end if;
542: if (p_log_level_rec.statement_level) then
543: fa_debug_pkg.add(l_calling_fn,'fetched event_id :', l_event_id, p_log_level_rec => p_log_level_rec);
544: end if;
545: /*=================================================================
546: Secondary Changes Start
547: If primary and secondary sob_id is different then we need to

Line 559: fa_debug_pkg.add(l_calling_fn, 'fetching status of event ', l_secondary_event_id,p_log_level_rec => p_log_level_rec);

555: l_secondary_deprn_source_info.source_id_int_3 := l_secondary_deprn_run_id;
556: l_secondary_deprn_source_info.entity_type_code := 'DEPRECIATION';
557:
558: if (p_log_level_rec.statement_level) then
559: fa_debug_pkg.add(l_calling_fn, 'fetching status of event ', l_secondary_event_id,p_log_level_rec => p_log_level_rec);
560: end if;
561:
562: -- fetch the event status
563: l_secondary_event_status := XLA_EVENTS_PUB_PKG.get_event_status

Line 570: fa_debug_pkg.add(l_calling_fn, 'sec_ event status ', l_secondary_event_status,p_log_level_rec => p_log_level_rec);

566: p_valuation_method => p_book_type_code,
567: p_security_context => l_security_context);
568:
569: if (p_log_level_rec.statement_level) then
570: fa_debug_pkg.add(l_calling_fn, 'sec_ event status ', l_secondary_event_status,p_log_level_rec => p_log_level_rec);
571: end if;
572:
573: if (l_secondary_event_status <> XLA_EVENTS_PUB_PKG.C_EVENT_PROCESSED) then
574:

Line 576: fa_debug_pkg.add(l_calling_fn, 'sec_ Deleting unprocessed event', l_secondary_event_id,p_log_level_rec => p_log_level_rec);

572:
573: if (l_secondary_event_status <> XLA_EVENTS_PUB_PKG.C_EVENT_PROCESSED) then
574:
575: if (p_log_level_rec.statement_level) then
576: fa_debug_pkg.add(l_calling_fn, 'sec_ Deleting unprocessed event', l_secondary_event_id,p_log_level_rec => p_log_level_rec);
577: end if;
578:
579: XLA_EVENTS_PUB_PKG.delete_event
580: (p_event_source_info => l_secondary_deprn_source_info,

Line 594: fa_debug_pkg.add(l_calling_fn, 'Unable to delete entity for rb event',l_secondary_event_id, p_log_level_rec => p_log_level_rec);

590:
591: EXCEPTION
592: WHEN OTHERS THEN
593: l_result := 1;
594: fa_debug_pkg.add(l_calling_fn, 'Unable to delete entity for rb event',l_secondary_event_id, p_log_level_rec => p_log_level_rec);
595: fa_debug_pkg.add(l_calling_fn, 'l_result', l_result, p_log_level_rec => p_log_level_rec);
596: raise rb_err;
597: END; --annonymous
598: elsif (l_secondary_event_status = XLA_EVENTS_PUB_PKG.C_EVENT_PROCESSED) then

Line 595: fa_debug_pkg.add(l_calling_fn, 'l_result', l_result, p_log_level_rec => p_log_level_rec);

591: EXCEPTION
592: WHEN OTHERS THEN
593: l_result := 1;
594: fa_debug_pkg.add(l_calling_fn, 'Unable to delete entity for rb event',l_secondary_event_id, p_log_level_rec => p_log_level_rec);
595: fa_debug_pkg.add(l_calling_fn, 'l_result', l_result, p_log_level_rec => p_log_level_rec);
596: raise rb_err;
597: END; --annonymous
598: elsif (l_secondary_event_status = XLA_EVENTS_PUB_PKG.C_EVENT_PROCESSED) then
599: -- create the reversal event

Line 624: fa_debug_pkg.add(l_calling_fn, 'fetching status of event ', l_event_id,p_log_level_rec => p_log_level_rec);

620: l_deprn_source_info.source_id_int_3 := l_deprn_run_id;
621: l_deprn_source_info.entity_type_code := 'DEPRECIATION';
622:
623: if (p_log_level_rec.statement_level) then
624: fa_debug_pkg.add(l_calling_fn, 'fetching status of event ', l_event_id,p_log_level_rec => p_log_level_rec);
625: end if;
626:
627: -- fetch the event status
628: l_event_status := XLA_EVENTS_PUB_PKG.get_event_status

Line 635: fa_debug_pkg.add(l_calling_fn, 'event status ', l_event_status,p_log_level_rec => p_log_level_rec);

631: p_valuation_method => p_book_type_code,
632: p_security_context => l_security_context);
633:
634: if (p_log_level_rec.statement_level) then
635: fa_debug_pkg.add(l_calling_fn, 'event status ', l_event_status,p_log_level_rec => p_log_level_rec);
636: end if;
637:
638: if (l_event_status <> XLA_EVENTS_PUB_PKG.C_EVENT_PROCESSED) then
639:

Line 641: fa_debug_pkg.add(l_calling_fn, 'Deleting unprocessed event', l_event_id,p_log_level_rec => p_log_level_rec);

637:
638: if (l_event_status <> XLA_EVENTS_PUB_PKG.C_EVENT_PROCESSED) then
639:
640: if (p_log_level_rec.statement_level) then
641: fa_debug_pkg.add(l_calling_fn, 'Deleting unprocessed event', l_event_id,p_log_level_rec => p_log_level_rec);
642: end if;
643:
644: XLA_EVENTS_PUB_PKG.delete_event
645: (p_event_source_info => l_deprn_source_info,

Line 659: fa_debug_pkg.add(l_calling_fn, 'Unable to delete entity for rb event',l_event_id, p_log_level_rec => p_log_level_rec);

655:
656: EXCEPTION
657: WHEN OTHERS THEN
658: l_result := 1;
659: fa_debug_pkg.add(l_calling_fn, 'Unable to delete entity for rb event',l_event_id, p_log_level_rec => p_log_level_rec);
660: fa_debug_pkg.add(l_calling_fn, 'l_result', l_result, p_log_level_rec => p_log_level_rec);
661: raise rb_err;
662: END; --annonymous
663:

Line 660: fa_debug_pkg.add(l_calling_fn, 'l_result', l_result, p_log_level_rec => p_log_level_rec);

656: EXCEPTION
657: WHEN OTHERS THEN
658: l_result := 1;
659: fa_debug_pkg.add(l_calling_fn, 'Unable to delete entity for rb event',l_event_id, p_log_level_rec => p_log_level_rec);
660: fa_debug_pkg.add(l_calling_fn, 'l_result', l_result, p_log_level_rec => p_log_level_rec);
661: raise rb_err;
662: END; --annonymous
663:
664: DELETE from fa_deprn_events

Line 684: fa_debug_pkg.add(l_calling_fn, 'rollback event id', l_event_id, p_log_level_rec => p_log_level_rec);

680: p_valuation_method => p_book_type_code,
681: p_security_context => l_security_context);
682:
683: if (p_log_level_rec.statement_level) then
684: fa_debug_pkg.add(l_calling_fn, 'rollback event id', l_event_id, p_log_level_rec => p_log_level_rec);
685: end if;
686:
687: -- flag the header table too
688: update fa_deprn_events

Line 999: fa_debug_pkg.add(l_calling_fn, 'Rollback_deprn_event ', 'Ends',p_log_level_rec => p_log_level_rec);

995: end if;
996: end if; -- event is not null
997:
998: if (p_log_level_rec.statement_level) then
999: fa_debug_pkg.add(l_calling_fn, 'Rollback_deprn_event ', 'Ends',p_log_level_rec => p_log_level_rec);
1000: end if;
1001:
1002: return true;
1003:

Line 1085: fa_debug_pkg.add(l_calling_fn, 'Rollback_impair_event ', 'Begins',p_log_level_rec => p_log_level_rec);

1081: AND ad.asset_id = adj.asset_id;
1082:
1083: begin
1084: if (p_log_level_rec.statement_level) then
1085: fa_debug_pkg.add(l_calling_fn, 'Rollback_impair_event ', 'Begins',p_log_level_rec => p_log_level_rec);
1086: fa_debug_pkg.add(l_calling_fn, 'p_request_id ', p_request_id,p_log_level_rec => p_log_level_rec);
1087: fa_debug_pkg.add(l_calling_fn, 'p_book_type_code ', p_book_type_code,p_log_level_rec => p_log_level_rec);
1088: fa_debug_pkg.add(l_calling_fn, 'p_thid ', p_thid ,p_log_level_rec => p_log_level_rec);
1089: fa_debug_pkg.add(l_calling_fn, 'p_asset_id ', p_asset_id ,p_log_level_rec => p_log_level_rec);

Line 1086: fa_debug_pkg.add(l_calling_fn, 'p_request_id ', p_request_id,p_log_level_rec => p_log_level_rec);

1082:
1083: begin
1084: if (p_log_level_rec.statement_level) then
1085: fa_debug_pkg.add(l_calling_fn, 'Rollback_impair_event ', 'Begins',p_log_level_rec => p_log_level_rec);
1086: fa_debug_pkg.add(l_calling_fn, 'p_request_id ', p_request_id,p_log_level_rec => p_log_level_rec);
1087: fa_debug_pkg.add(l_calling_fn, 'p_book_type_code ', p_book_type_code,p_log_level_rec => p_log_level_rec);
1088: fa_debug_pkg.add(l_calling_fn, 'p_thid ', p_thid ,p_log_level_rec => p_log_level_rec);
1089: fa_debug_pkg.add(l_calling_fn, 'p_asset_id ', p_asset_id ,p_log_level_rec => p_log_level_rec);
1090: fa_debug_pkg.add(l_calling_fn, 'p_mrc_sob_type_code ', p_mrc_sob_type_code,p_log_level_rec => p_log_level_rec);

Line 1087: fa_debug_pkg.add(l_calling_fn, 'p_book_type_code ', p_book_type_code,p_log_level_rec => p_log_level_rec);

1083: begin
1084: if (p_log_level_rec.statement_level) then
1085: fa_debug_pkg.add(l_calling_fn, 'Rollback_impair_event ', 'Begins',p_log_level_rec => p_log_level_rec);
1086: fa_debug_pkg.add(l_calling_fn, 'p_request_id ', p_request_id,p_log_level_rec => p_log_level_rec);
1087: fa_debug_pkg.add(l_calling_fn, 'p_book_type_code ', p_book_type_code,p_log_level_rec => p_log_level_rec);
1088: fa_debug_pkg.add(l_calling_fn, 'p_thid ', p_thid ,p_log_level_rec => p_log_level_rec);
1089: fa_debug_pkg.add(l_calling_fn, 'p_asset_id ', p_asset_id ,p_log_level_rec => p_log_level_rec);
1090: fa_debug_pkg.add(l_calling_fn, 'p_mrc_sob_type_code ', p_mrc_sob_type_code,p_log_level_rec => p_log_level_rec);
1091: fa_debug_pkg.add(l_calling_fn, 'p_set_of_books_id ', p_set_of_books_id,p_log_level_rec => p_log_level_rec);

Line 1088: fa_debug_pkg.add(l_calling_fn, 'p_thid ', p_thid ,p_log_level_rec => p_log_level_rec);

1084: if (p_log_level_rec.statement_level) then
1085: fa_debug_pkg.add(l_calling_fn, 'Rollback_impair_event ', 'Begins',p_log_level_rec => p_log_level_rec);
1086: fa_debug_pkg.add(l_calling_fn, 'p_request_id ', p_request_id,p_log_level_rec => p_log_level_rec);
1087: fa_debug_pkg.add(l_calling_fn, 'p_book_type_code ', p_book_type_code,p_log_level_rec => p_log_level_rec);
1088: fa_debug_pkg.add(l_calling_fn, 'p_thid ', p_thid ,p_log_level_rec => p_log_level_rec);
1089: fa_debug_pkg.add(l_calling_fn, 'p_asset_id ', p_asset_id ,p_log_level_rec => p_log_level_rec);
1090: fa_debug_pkg.add(l_calling_fn, 'p_mrc_sob_type_code ', p_mrc_sob_type_code,p_log_level_rec => p_log_level_rec);
1091: fa_debug_pkg.add(l_calling_fn, 'p_set_of_books_id ', p_set_of_books_id,p_log_level_rec => p_log_level_rec);
1092: end if;

Line 1089: fa_debug_pkg.add(l_calling_fn, 'p_asset_id ', p_asset_id ,p_log_level_rec => p_log_level_rec);

1085: fa_debug_pkg.add(l_calling_fn, 'Rollback_impair_event ', 'Begins',p_log_level_rec => p_log_level_rec);
1086: fa_debug_pkg.add(l_calling_fn, 'p_request_id ', p_request_id,p_log_level_rec => p_log_level_rec);
1087: fa_debug_pkg.add(l_calling_fn, 'p_book_type_code ', p_book_type_code,p_log_level_rec => p_log_level_rec);
1088: fa_debug_pkg.add(l_calling_fn, 'p_thid ', p_thid ,p_log_level_rec => p_log_level_rec);
1089: fa_debug_pkg.add(l_calling_fn, 'p_asset_id ', p_asset_id ,p_log_level_rec => p_log_level_rec);
1090: fa_debug_pkg.add(l_calling_fn, 'p_mrc_sob_type_code ', p_mrc_sob_type_code,p_log_level_rec => p_log_level_rec);
1091: fa_debug_pkg.add(l_calling_fn, 'p_set_of_books_id ', p_set_of_books_id,p_log_level_rec => p_log_level_rec);
1092: end if;
1093:

Line 1090: fa_debug_pkg.add(l_calling_fn, 'p_mrc_sob_type_code ', p_mrc_sob_type_code,p_log_level_rec => p_log_level_rec);

1086: fa_debug_pkg.add(l_calling_fn, 'p_request_id ', p_request_id,p_log_level_rec => p_log_level_rec);
1087: fa_debug_pkg.add(l_calling_fn, 'p_book_type_code ', p_book_type_code,p_log_level_rec => p_log_level_rec);
1088: fa_debug_pkg.add(l_calling_fn, 'p_thid ', p_thid ,p_log_level_rec => p_log_level_rec);
1089: fa_debug_pkg.add(l_calling_fn, 'p_asset_id ', p_asset_id ,p_log_level_rec => p_log_level_rec);
1090: fa_debug_pkg.add(l_calling_fn, 'p_mrc_sob_type_code ', p_mrc_sob_type_code,p_log_level_rec => p_log_level_rec);
1091: fa_debug_pkg.add(l_calling_fn, 'p_set_of_books_id ', p_set_of_books_id,p_log_level_rec => p_log_level_rec);
1092: end if;
1093:
1094: if (NOT FA_UTIL_PVT.get_period_rec (

Line 1091: fa_debug_pkg.add(l_calling_fn, 'p_set_of_books_id ', p_set_of_books_id,p_log_level_rec => p_log_level_rec);

1087: fa_debug_pkg.add(l_calling_fn, 'p_book_type_code ', p_book_type_code,p_log_level_rec => p_log_level_rec);
1088: fa_debug_pkg.add(l_calling_fn, 'p_thid ', p_thid ,p_log_level_rec => p_log_level_rec);
1089: fa_debug_pkg.add(l_calling_fn, 'p_asset_id ', p_asset_id ,p_log_level_rec => p_log_level_rec);
1090: fa_debug_pkg.add(l_calling_fn, 'p_mrc_sob_type_code ', p_mrc_sob_type_code,p_log_level_rec => p_log_level_rec);
1091: fa_debug_pkg.add(l_calling_fn, 'p_set_of_books_id ', p_set_of_books_id,p_log_level_rec => p_log_level_rec);
1092: end if;
1093:
1094: if (NOT FA_UTIL_PVT.get_period_rec (
1095: p_book => p_book_type_code,

Line 1103: fa_debug_pkg.add(l_calling_fn,'fetched', 'period rec', p_log_level_rec => p_log_level_rec);

1099: )) then
1100: raise rb_err;
1101: end if;
1102: if (p_log_level_rec.statement_level) then
1103: fa_debug_pkg.add(l_calling_fn,'fetched', 'period rec', p_log_level_rec => p_log_level_rec);
1104: end if;
1105:
1106: /*8666930 - For mrc we will not find event as it was already deleted for primary if uprocessed*/
1107: BEGIN

Line 1120: fa_debug_pkg.add(l_calling_fn, 'no event found for this asset',p_asset_id,p_log_level_rec => p_log_level_rec);

1116: EXCEPTION
1117:
1118: WHEN NO_DATA_FOUND THEN
1119: if (p_log_level_rec.statement_level) then
1120: fa_debug_pkg.add(l_calling_fn, 'no event found for this asset',p_asset_id,p_log_level_rec => p_log_level_rec);
1121: end if;
1122: END;
1123:
1124: if (p_log_level_rec.statement_level) then

Line 1125: fa_debug_pkg.add(l_calling_fn,'l_event_id : ', l_event_id, p_log_level_rec => p_log_level_rec);

1121: end if;
1122: END;
1123:
1124: if (p_log_level_rec.statement_level) then
1125: fa_debug_pkg.add(l_calling_fn,'l_event_id : ', l_event_id, p_log_level_rec => p_log_level_rec);
1126: end if;
1127:
1128: if (l_event_id is not null) then
1129: l_trx_source_info.application_id := 140;

Line 1143: fa_debug_pkg.add(l_calling_fn, 'event status ', l_event_status,p_log_level_rec => p_log_level_rec);

1139: p_event_id => l_event_id,
1140: p_valuation_method => p_book_type_code,
1141: p_security_context => l_security_context);
1142: if (p_log_level_rec.statement_level) then
1143: fa_debug_pkg.add(l_calling_fn, 'event status ', l_event_status,p_log_level_rec => p_log_level_rec);
1144: end if;
1145:
1146: if l_event_status = FA_XLA_EVENTS_PVT.C_EVENT_UNPROCESSED then
1147: if (p_log_level_rec.statement_level) then

Line 1148: fa_debug_pkg.add(l_calling_fn,'deleting unprocessed impairment event',p_thid,p_log_level_rec => p_log_level_rec);

1144: end if;
1145:
1146: if l_event_status = FA_XLA_EVENTS_PVT.C_EVENT_UNPROCESSED then
1147: if (p_log_level_rec.statement_level) then
1148: fa_debug_pkg.add(l_calling_fn,'deleting unprocessed impairment event',p_thid,p_log_level_rec => p_log_level_rec);
1149: end if;
1150:
1151: if not fa_xla_events_pvt.delete_transaction_event
1152: (p_ledger_id => p_set_of_books_id,

Line 1158: fa_debug_pkg.add(l_calling_fn,'Failed ','delete_transaction_event',p_log_level_rec => p_log_level_rec);

1154: p_book_type_code => p_book_type_code,
1155: p_calling_fn => l_calling_fn
1156: ,p_log_level_rec => p_log_level_rec) then
1157: if (p_log_level_rec.statement_level) then
1158: fa_debug_pkg.add(l_calling_fn,'Failed ','delete_transaction_event',p_log_level_rec => p_log_level_rec);
1159: end if;
1160: raise rb_err;
1161: end if;
1162:

Line 1164: fa_debug_pkg.add(l_calling_fn,'deleted accounting impacts for impairment thid',p_thid,p_log_level_rec => p_log_level_rec);

1160: raise rb_err;
1161: end if;
1162:
1163: if (p_log_level_rec.statement_level) then
1164: fa_debug_pkg.add(l_calling_fn,'deleted accounting impacts for impairment thid',p_thid,p_log_level_rec => p_log_level_rec);
1165: end if;
1166:
1167: delete from fa_books
1168: where transaction_header_id_out is null

Line 1191: fa_debug_pkg.add(l_calling_fn,'event already processed need to reverse impairment entries.',p_thid,p_log_level_rec => p_log_level_rec);

1187: where transaction_header_id = p_thid;
1188:
1189: elsif (l_event_status = XLA_EVENTS_PUB_PKG.C_EVENT_PROCESSED) then
1190: if (p_log_level_rec.statement_level) then
1191: fa_debug_pkg.add(l_calling_fn,'event already processed need to reverse impairment entries.',p_thid,p_log_level_rec => p_log_level_rec);
1192: end if;
1193:
1194: if (p_mrc_sob_type_code = 'R') then
1195:

Line 1256: fa_debug_pkg.add(l_calling_fn, 'rolled back IMPAIRMENT event id', l_rev_event_id,p_log_level_rec => p_log_level_rec);

1252: p_valuation_method => p_book_type_code,
1253: p_security_context => l_security_context);
1254:
1255: if (p_log_level_rec.statement_level) then
1256: fa_debug_pkg.add(l_calling_fn, 'rolled back IMPAIRMENT event id', l_rev_event_id,p_log_level_rec => p_log_level_rec);
1257: end if;
1258:
1259: update fa_transaction_headers
1260: set event_id = l_rev_event_id

Line 1264: fa_debug_pkg.add(l_calling_fn,'Deactivating ', 'FA_BOOKS', p_log_level_rec => p_log_level_rec);

1260: set event_id = l_rev_event_id
1261: where transaction_header_id = l_thid;
1262:
1263: if (p_log_level_rec.statement_level) then
1264: fa_debug_pkg.add(l_calling_fn,'Deactivating ', 'FA_BOOKS', p_log_level_rec => p_log_level_rec);
1265: end if;
1266: end if;
1267:
1268: if (p_mrc_sob_type_code = 'R') then

Line 1895: fa_debug_pkg.add(l_calling_fn,'rollback_impair_event ','Ends',p_log_level_rec => p_log_level_rec);

1891: and set_of_books_id = p_set_of_books_id;
1892:
1893: end if;-- Event id not null
1894: if (p_log_level_rec.statement_level) then
1895: fa_debug_pkg.add(l_calling_fn,'rollback_impair_event ','Ends',p_log_level_rec => p_log_level_rec);
1896: end if;
1897: return true;
1898: EXCEPTION
1899: