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_ROLLBACK_PVT dependencies on XLA_EVENTS

Line 45: from xla_events xeve,

41: order by transaction_header_id desc;
42: --Secondary Changes
43: CURSOR c_get_sec_event_id(c_thid number) is
44: select event_id
45: from xla_events xeve,
46: xla_transaction_entities partition (ofa) xent
47: where xeve.application_id = 140
48: and xeve.event_type_code = '%TERMINAL_GAIN_LOSS%'
49: and xent.application_id = xeve.application_id

Line 59: l_deprn_source_info XLA_EVENTS_PUB_PKG.t_event_source_info;

55: -- Terminal Gain/Loss
56: l_thid NUMBER;
57: l_event_id NUMBER;
58: l_event_status VARCHAR2(1);
59: l_deprn_source_info XLA_EVENTS_PUB_PKG.t_event_source_info;
60: l_security_context XLA_EVENTS_PUB_PKG.t_security;
61: l_trans_rec FA_API_TYPES.trans_rec_type;
62: l_asset_type_rec FA_API_TYPES.asset_type_rec_type;
63: l_asset_fin_rec FA_API_TYPES.asset_fin_rec_type;

Line 60: l_security_context XLA_EVENTS_PUB_PKG.t_security;

56: l_thid NUMBER;
57: l_event_id NUMBER;
58: l_event_status VARCHAR2(1);
59: l_deprn_source_info XLA_EVENTS_PUB_PKG.t_event_source_info;
60: l_security_context XLA_EVENTS_PUB_PKG.t_security;
61: l_trans_rec FA_API_TYPES.trans_rec_type;
62: l_asset_type_rec FA_API_TYPES.asset_type_rec_type;
63: l_asset_fin_rec FA_API_TYPES.asset_fin_rec_type;
64: l_status boolean;

Line 819: l_secondary_event_status := XLA_EVENTS_PUB_PKG.get_event_status

815: l_deprn_source_info.transaction_number := to_char(l_thid);
816: l_deprn_source_info.source_id_char_1 := p_asset_hdr_rec.book_type_code;
817:
818: -- check the event status
819: l_secondary_event_status := XLA_EVENTS_PUB_PKG.get_event_status
820: (p_event_source_info => l_deprn_source_info,
821: p_event_id => l_secondary_event_id,
822: p_valuation_method => p_asset_hdr_rec.book_type_code,
823: p_security_context => l_security_context);

Line 830: if (l_secondary_event_status = XLA_EVENTS_PUB_PKG.C_EVENT_PROCESSED) then

826: fa_debug_pkg.add(l_calling_fn, 'event status ', l_secondary_event_status
827: ,p_log_level_rec => p_log_level_rec);
828: end if;
829:
830: if (l_secondary_event_status = XLA_EVENTS_PUB_PKG.C_EVENT_PROCESSED) then
831:
832: open c_get_new_thid;
833: fetch c_get_new_thid into l_secondary_trans_rec.transaction_header_id
834: , l_secondary_trans_rec.who_info.last_update_date;

Line 846: if not FA_XLA_EVENTS_PVT.create_transaction_event(

842: l_secondary_trans_rec.calling_interface := 'FAXDRB';
843:
844: l_asset_type_rec.asset_type := 'GROUP';
845:
846: if not FA_XLA_EVENTS_PVT.create_transaction_event(
847: p_asset_hdr_rec => p_asset_hdr_rec,
848: p_asset_type_rec => l_asset_type_rec,
849: px_trans_rec => l_secondary_trans_rec,
850: p_event_status => NULL,

Line 857: elsif (l_secondary_event_status = XLA_EVENTS_PUB_PKG.C_EVENT_UNPROCESSED) then

853: fa_debug_pkg.add(l_calling_fn, 'ERROR', 'Calling create_transaction_event'
854: ,p_log_level_rec => p_log_level_rec);
855: raise rb_error;
856: end if;
857: elsif (l_secondary_event_status = XLA_EVENTS_PUB_PKG.C_EVENT_UNPROCESSED) then
858: XLA_EVENTS_PUB_PKG.delete_event
859: (p_event_source_info => l_deprn_source_info,
860: p_event_id => l_secondary_event_id,
861: p_valuation_method => p_asset_hdr_rec.book_type_code,

Line 858: XLA_EVENTS_PUB_PKG.delete_event

854: ,p_log_level_rec => p_log_level_rec);
855: raise rb_error;
856: end if;
857: elsif (l_secondary_event_status = XLA_EVENTS_PUB_PKG.C_EVENT_UNPROCESSED) then
858: XLA_EVENTS_PUB_PKG.delete_event
859: (p_event_source_info => l_deprn_source_info,
860: p_event_id => l_secondary_event_id,
861: p_valuation_method => p_asset_hdr_rec.book_type_code,
862: p_security_context => l_security_context);

Line 866: l_result := XLA_EVENTS_PUB_PKG.delete_entity

862: p_security_context => l_security_context);
863:
864: --6702657
865: BEGIN
866: l_result := XLA_EVENTS_PUB_PKG.delete_entity
867: (p_source_info => l_deprn_source_info,
868: p_valuation_method => p_asset_hdr_rec.book_type_code,
869: p_security_context => l_security_context);
870:

Line 901: l_event_status := XLA_EVENTS_PUB_PKG.get_event_status

897: l_deprn_source_info.transaction_number := to_char(l_thid);
898: l_deprn_source_info.source_id_char_1 := p_asset_hdr_rec.book_type_code;
899:
900: -- check the event status
901: l_event_status := XLA_EVENTS_PUB_PKG.get_event_status
902: (p_event_source_info => l_deprn_source_info,
903: p_event_id => l_event_id,
904: p_valuation_method => p_asset_hdr_rec.book_type_code,
905: p_security_context => l_security_context);

Line 914: if (l_event_status = XLA_EVENTS_PUB_PKG.C_EVENT_PROCESSED) then

910: end if;
911:
912: end if;
913:
914: if (l_event_status = XLA_EVENTS_PUB_PKG.C_EVENT_PROCESSED) then
915: -- Reverse Terminal Gain Loss
916:
917: if (p_mrc_sob_type_code <> 'R') then
918: SELECT fa_transaction_headers_s.nextval

Line 923: -- Populating for calling FA_XLA_EVENTS_PVT.create_transaction_event

919: INTO l_trans_rec.transaction_header_id
920: FROM DUAL;
921:
922: --
923: -- Populating for calling FA_XLA_EVENTS_PVT.create_transaction_event
924: --
925: l_trans_rec.transaction_subtype := 'AMORTIZED';
926: l_trans_rec.transaction_type_code := 'ADJUSTMENT';
927: l_trans_rec.transaction_key := 'TG';

Line 935: if not FA_XLA_EVENTS_PVT.create_transaction_event(

931: l_trans_rec.calling_interface := 'FAXDRB';
932:
933: l_asset_type_rec.asset_type := 'GROUP';
934:
935: if not FA_XLA_EVENTS_PVT.create_transaction_event(
936: p_asset_hdr_rec => p_asset_hdr_rec,
937: p_asset_type_rec => l_asset_type_rec,
938: px_trans_rec => l_trans_rec,
939: p_event_status => NULL,

Line 1358: elsif (l_event_status = XLA_EVENTS_PUB_PKG.C_EVENT_UNPROCESSED OR p_mrc_sob_type_code = 'R' ) then

1354: ,p_log_level_rec => p_log_level_rec);
1355: raise rb_error;
1356: end if;
1357: /* Bug#9018861 - Modified condition for reporting currency */
1358: elsif (l_event_status = XLA_EVENTS_PUB_PKG.C_EVENT_UNPROCESSED OR p_mrc_sob_type_code = 'R' ) then
1359:
1360: if (p_log_level_rec.statement_level) then
1361: fa_debug_pkg.add(l_calling_fn, 'deleting event', l_event_id
1362: ,p_log_level_rec => p_log_level_rec);

Line 1366: XLA_EVENTS_PUB_PKG.delete_event

1362: ,p_log_level_rec => p_log_level_rec);
1363: end if;
1364: /* Bug#9018861 - Null means already deleted for primary book */
1365: if p_mrc_sob_type_code <> 'R' then
1366: XLA_EVENTS_PUB_PKG.delete_event
1367: (p_event_source_info => l_deprn_source_info,
1368: p_event_id => l_event_id,
1369: p_valuation_method => p_asset_hdr_rec.book_type_code,
1370: p_security_context => l_security_context);

Line 1374: l_result := XLA_EVENTS_PUB_PKG.delete_entity

1370: p_security_context => l_security_context);
1371:
1372: --6702657
1373: BEGIN
1374: l_result := XLA_EVENTS_PUB_PKG.delete_entity
1375: (p_source_info => l_deprn_source_info,
1376: p_valuation_method => p_asset_hdr_rec.book_type_code,
1377: p_security_context => l_security_context);
1378:

Line 1435: end if; -- (l_event_status = XLA_EVENTS_PUB_PKG.C_EVENT_PROCESSED)

1431: end if; -- (p_mrc_sob_type_code <> 'R')
1432:
1433: else
1434: raise rb_error;
1435: end if; -- (l_event_status = XLA_EVENTS_PUB_PKG.C_EVENT_PROCESSED)
1436:
1437: -- Common for both situations (reverse, delete)
1438: if (p_mrc_sob_type_code <> 'R') then
1439: update fa_books_summary