DBA Data[Home] [Help]

APPS.FA_IMPAIRMENT_DELETE_PVT dependencies on XLA_EVENTS_PUB_PKG

Line 405: XLA_EVENTS_PUB_PKG.C_EVENT_UNPROCESSED,

401: 'TRANSACTIONS' ,
402: 'IMPAIRMENT' ,
403: l_event_date ,
404: NULL ,
405: XLA_EVENTS_PUB_PKG.C_EVENT_UNPROCESSED,
406: to_char(p_thid(i)) ,
407: p_thid(i) ,
408: p_book_type_code ,
409: -- p_period_rec.period_counter ,

Line 418: XLA_EVENTS_PUB_PKG.create_bulk_events

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,
420: p_application_id => 140,
421: p_legal_entity_id => l_legal_entity_id,
422: p_ledger_id => p_set_of_books_id,

Line 466: l_deprn_source_info XLA_EVENTS_PUB_PKG.t_event_source_info;

462: p_log_level_rec IN FA_API_TYPES.log_level_rec_type) RETURN BOOLEAN IS
463:
464:
465: --Deprn event info
466: l_deprn_source_info XLA_EVENTS_PUB_PKG.t_event_source_info;
467: l_security_context XLA_EVENTS_PUB_PKG.t_security;
468:
469: l_event_id number;
470: l_deprn_run_id number;

Line 467: l_security_context XLA_EVENTS_PUB_PKG.t_security;

463:
464:
465: --Deprn event info
466: l_deprn_source_info XLA_EVENTS_PUB_PKG.t_event_source_info;
467: l_security_context XLA_EVENTS_PUB_PKG.t_security;
468:
469: l_event_id number;
470: l_deprn_run_id number;
471: l_event_status varchar2(1);

Line 486: l_secondary_deprn_source_info XLA_EVENTS_PUB_PKG.t_event_source_info;

482: l_secondary_sob_id number;
483: l_secondary_deprn_run_id NUMBER;
484: l_secondary_rev_event_id number;
485:
486: l_secondary_deprn_source_info XLA_EVENTS_PUB_PKG.t_event_source_info;
487: l_calling_fn varchar2(60) := 'FA_IMPAIRMENT_DELETE_PVT.rollback_deprn_event';
488: rb_err exception;
489:
490: begin

Line 563: l_secondary_event_status := XLA_EVENTS_PUB_PKG.get_event_status

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
564: (p_event_source_info => l_secondary_deprn_source_info,
565: p_event_id => l_secondary_event_id,
566: p_valuation_method => p_book_type_code,
567: p_security_context => l_security_context);

Line 573: if (l_secondary_event_status <> XLA_EVENTS_PUB_PKG.C_EVENT_PROCESSED) then

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:
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;

Line 579: XLA_EVENTS_PUB_PKG.delete_event

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,
581: p_event_id => l_secondary_event_id,
582: p_valuation_method => p_book_type_code,
583: p_security_context => l_security_context);

Line 586: l_result := XLA_EVENTS_PUB_PKG.delete_entity

582: p_valuation_method => p_book_type_code,
583: p_security_context => l_security_context);
584:
585: BEGIN
586: l_result := XLA_EVENTS_PUB_PKG.delete_entity
587: (p_source_info => l_secondary_deprn_source_info,
588: p_valuation_method => p_book_type_code,
589: p_security_context => l_security_context);
590:

Line 598: elsif (l_secondary_event_status = XLA_EVENTS_PUB_PKG.C_EVENT_PROCESSED) then

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
600: l_secondary_rev_event_id := xla_events_pub_pkg.create_event
601: (p_event_source_info => l_secondary_deprn_source_info,
602: p_event_type_code => 'ROLLBACK_DEPRECIATION',

Line 600: l_secondary_rev_event_id := xla_events_pub_pkg.create_event

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
600: l_secondary_rev_event_id := xla_events_pub_pkg.create_event
601: (p_event_source_info => l_secondary_deprn_source_info,
602: p_event_type_code => 'ROLLBACK_DEPRECIATION',
603: p_event_date => l_period_rec.calendar_period_close_date,
604: p_event_status_code => XLA_EVENTS_PUB_PKG.C_EVENT_UNPROCESSED,

Line 604: p_event_status_code => XLA_EVENTS_PUB_PKG.C_EVENT_UNPROCESSED,

600: l_secondary_rev_event_id := xla_events_pub_pkg.create_event
601: (p_event_source_info => l_secondary_deprn_source_info,
602: p_event_type_code => 'ROLLBACK_DEPRECIATION',
603: p_event_date => l_period_rec.calendar_period_close_date,
604: p_event_status_code => XLA_EVENTS_PUB_PKG.C_EVENT_UNPROCESSED,
605: p_event_number => NULL,
606: p_reference_info => NULL,
607: p_valuation_method => p_book_type_code,
608: p_security_context => l_security_context);

Line 628: l_event_status := XLA_EVENTS_PUB_PKG.get_event_status

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
629: (p_event_source_info => l_deprn_source_info,
630: p_event_id => l_event_id,
631: p_valuation_method => p_book_type_code,
632: p_security_context => l_security_context);

Line 638: if (l_event_status <> XLA_EVENTS_PUB_PKG.C_EVENT_PROCESSED) then

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:
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;

Line 644: XLA_EVENTS_PUB_PKG.delete_event

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,
646: p_event_id => l_event_id,
647: p_valuation_method => p_book_type_code,
648: p_security_context => l_security_context);

Line 651: l_result := XLA_EVENTS_PUB_PKG.delete_entity

647: p_valuation_method => p_book_type_code,
648: p_security_context => l_security_context);
649:
650: BEGIN
651: l_result := XLA_EVENTS_PUB_PKG.delete_entity
652: (p_source_info => l_deprn_source_info,
653: p_valuation_method => p_book_type_code,
654: p_security_context => l_security_context);
655:

Line 670: elsif (l_event_status = XLA_EVENTS_PUB_PKG.C_EVENT_PROCESSED) then

666: and book_type_code = p_book_type_code
667: and period_counter = l_period_rec.period_counter
668: and reversal_event_id is null;
669:
670: elsif (l_event_status = XLA_EVENTS_PUB_PKG.C_EVENT_PROCESSED) then
671: -- create the reversal event
672: if (p_mrc_sob_type_code = 'P') then
673: l_rev_event_id := xla_events_pub_pkg.create_event
674: (p_event_source_info => l_deprn_source_info,

Line 673: l_rev_event_id := xla_events_pub_pkg.create_event

669:
670: elsif (l_event_status = XLA_EVENTS_PUB_PKG.C_EVENT_PROCESSED) then
671: -- create the reversal event
672: if (p_mrc_sob_type_code = 'P') then
673: l_rev_event_id := xla_events_pub_pkg.create_event
674: (p_event_source_info => l_deprn_source_info,
675: p_event_type_code => 'ROLLBACK_DEPRECIATION',
676: p_event_date => l_period_rec.calendar_period_close_date,
677: p_event_status_code => XLA_EVENTS_PUB_PKG.C_EVENT_UNPROCESSED,

Line 677: p_event_status_code => XLA_EVENTS_PUB_PKG.C_EVENT_UNPROCESSED,

673: l_rev_event_id := xla_events_pub_pkg.create_event
674: (p_event_source_info => l_deprn_source_info,
675: p_event_type_code => 'ROLLBACK_DEPRECIATION',
676: p_event_date => l_period_rec.calendar_period_close_date,
677: p_event_status_code => XLA_EVENTS_PUB_PKG.C_EVENT_UNPROCESSED,
678: p_event_number => NULL,
679: p_reference_info => NULL,
680: p_valuation_method => p_book_type_code,
681: p_security_context => l_security_context);

Line 1031: l_deprn_source_info XLA_EVENTS_PUB_PKG.t_event_source_info;

1027: l_event_id number;
1028: l_rev_event_id number;
1029:
1030: l_deprn_run_id number;
1031: l_deprn_source_info XLA_EVENTS_PUB_PKG.t_event_source_info;
1032: l_security_context XLA_EVENTS_PUB_PKG.t_security;
1033:
1034: l_event_status varchar2(1);
1035: l_deprn_count number;

Line 1032: l_security_context XLA_EVENTS_PUB_PKG.t_security;

1028: l_rev_event_id number;
1029:
1030: l_deprn_run_id number;
1031: l_deprn_source_info XLA_EVENTS_PUB_PKG.t_event_source_info;
1032: l_security_context XLA_EVENTS_PUB_PKG.t_security;
1033:
1034: l_event_status varchar2(1);
1035: l_deprn_count number;
1036: l_sysdate date;

Line 1054: l_trx_source_info XLA_EVENTS_PUB_PKG.t_event_source_info;

1050: l_current_units number;
1051: l_thid number;
1052: l_login_id number(15) := fnd_global.user_id;
1053:
1054: l_trx_source_info XLA_EVENTS_PUB_PKG.t_event_source_info;
1055:
1056: CURSOR c_mrc_adjustments (p_thid number) IS
1057: SELECT adj.code_combination_id ,
1058: adj.distribution_id ,

Line 1137: l_event_status := XLA_EVENTS_PUB_PKG.get_event_status

1133: l_trx_source_info.entity_type_code := 'TRANSACTIONS';
1134:
1135: -- check the event status
1136:
1137: l_event_status := XLA_EVENTS_PUB_PKG.get_event_status
1138: (p_event_source_info => l_trx_source_info,
1139: p_event_id => l_event_id,
1140: p_valuation_method => p_book_type_code,
1141: p_security_context => l_security_context);

Line 1189: elsif (l_event_status = XLA_EVENTS_PUB_PKG.C_EVENT_PROCESSED) then

1185:
1186: delete from fa_transaction_headers
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:

Line 1245: l_rev_event_id := xla_events_pub_pkg.create_event

1241: l_trx_source_info.source_id_int_1 := l_thid;
1242: l_trx_source_info.source_id_char_1 := p_book_type_code;
1243:
1244: --Bug 10024912: Event_type_code should be ROLLBACK_IMPAIRMENT
1245: l_rev_event_id := xla_events_pub_pkg.create_event
1246: (p_event_source_info => l_trx_source_info,
1247: p_event_type_code => 'ROLLBACK_IMPAIRMENT',
1248: p_event_date => l_period_rec.calendar_period_close_date,
1249: p_event_status_code => XLA_EVENTS_PUB_PKG.C_EVENT_UNPROCESSED,

Line 1249: p_event_status_code => XLA_EVENTS_PUB_PKG.C_EVENT_UNPROCESSED,

1245: l_rev_event_id := xla_events_pub_pkg.create_event
1246: (p_event_source_info => l_trx_source_info,
1247: p_event_type_code => 'ROLLBACK_IMPAIRMENT',
1248: p_event_date => l_period_rec.calendar_period_close_date,
1249: p_event_status_code => XLA_EVENTS_PUB_PKG.C_EVENT_UNPROCESSED,
1250: p_event_number => NULL,
1251: p_reference_info => NULL,
1252: p_valuation_method => p_book_type_code,
1253: p_security_context => l_security_context);