106: l_event_date := greatest(l_event_date,
107: fa_cache_pkg.fazcdp_record.calendar_period_open_date);
108:
109: if (p_log_level_rec.statement_level) then
110: fa_debug_pkg.add(l_calling_fn, 'l_trx_source_info.application_id ', l_trx_source_info.application_id
111: ,p_log_level_rec => p_log_level_rec);
112: fa_debug_pkg.add(l_calling_fn, 'l_trx_source_info.legal_entity_id ', l_trx_source_info.legal_entity_id
113: ,p_log_level_rec => p_log_level_rec);
114: fa_debug_pkg.add(l_calling_fn, 'l_trx_source_info.ledger_id ', l_trx_source_info.ledger_id
108:
109: if (p_log_level_rec.statement_level) then
110: fa_debug_pkg.add(l_calling_fn, 'l_trx_source_info.application_id ', l_trx_source_info.application_id
111: ,p_log_level_rec => p_log_level_rec);
112: fa_debug_pkg.add(l_calling_fn, 'l_trx_source_info.legal_entity_id ', l_trx_source_info.legal_entity_id
113: ,p_log_level_rec => p_log_level_rec);
114: fa_debug_pkg.add(l_calling_fn, 'l_trx_source_info.ledger_id ', l_trx_source_info.ledger_id
115: ,p_log_level_rec => p_log_level_rec);
116: fa_debug_pkg.add(l_calling_fn, 'l_trx_source_info.transaction_number', l_trx_source_info.transaction_number
110: fa_debug_pkg.add(l_calling_fn, 'l_trx_source_info.application_id ', l_trx_source_info.application_id
111: ,p_log_level_rec => p_log_level_rec);
112: fa_debug_pkg.add(l_calling_fn, 'l_trx_source_info.legal_entity_id ', l_trx_source_info.legal_entity_id
113: ,p_log_level_rec => p_log_level_rec);
114: fa_debug_pkg.add(l_calling_fn, 'l_trx_source_info.ledger_id ', l_trx_source_info.ledger_id
115: ,p_log_level_rec => p_log_level_rec);
116: fa_debug_pkg.add(l_calling_fn, 'l_trx_source_info.transaction_number', l_trx_source_info.transaction_number
117: ,p_log_level_rec => p_log_level_rec);
118: fa_debug_pkg.add(l_calling_fn, 'l_trx_source_info.source_id_int_1', l_trx_source_info.source_id_int_1
112: fa_debug_pkg.add(l_calling_fn, 'l_trx_source_info.legal_entity_id ', l_trx_source_info.legal_entity_id
113: ,p_log_level_rec => p_log_level_rec);
114: fa_debug_pkg.add(l_calling_fn, 'l_trx_source_info.ledger_id ', l_trx_source_info.ledger_id
115: ,p_log_level_rec => p_log_level_rec);
116: fa_debug_pkg.add(l_calling_fn, 'l_trx_source_info.transaction_number', l_trx_source_info.transaction_number
117: ,p_log_level_rec => p_log_level_rec);
118: fa_debug_pkg.add(l_calling_fn, 'l_trx_source_info.source_id_int_1', l_trx_source_info.source_id_int_1
119: ,p_log_level_rec => p_log_level_rec);
120: fa_debug_pkg.add(l_calling_fn, 'l_trx_source_info.entity_type_code', l_trx_source_info.entity_type_code
114: fa_debug_pkg.add(l_calling_fn, 'l_trx_source_info.ledger_id ', l_trx_source_info.ledger_id
115: ,p_log_level_rec => p_log_level_rec);
116: fa_debug_pkg.add(l_calling_fn, 'l_trx_source_info.transaction_number', l_trx_source_info.transaction_number
117: ,p_log_level_rec => p_log_level_rec);
118: fa_debug_pkg.add(l_calling_fn, 'l_trx_source_info.source_id_int_1', l_trx_source_info.source_id_int_1
119: ,p_log_level_rec => p_log_level_rec);
120: fa_debug_pkg.add(l_calling_fn, 'l_trx_source_info.entity_type_code', l_trx_source_info.entity_type_code
121: ,p_log_level_rec => p_log_level_rec);
122: fa_debug_pkg.add(l_calling_fn, 'l_event_type_code', l_event_type_code
116: fa_debug_pkg.add(l_calling_fn, 'l_trx_source_info.transaction_number', l_trx_source_info.transaction_number
117: ,p_log_level_rec => p_log_level_rec);
118: fa_debug_pkg.add(l_calling_fn, 'l_trx_source_info.source_id_int_1', l_trx_source_info.source_id_int_1
119: ,p_log_level_rec => p_log_level_rec);
120: fa_debug_pkg.add(l_calling_fn, 'l_trx_source_info.entity_type_code', l_trx_source_info.entity_type_code
121: ,p_log_level_rec => p_log_level_rec);
122: fa_debug_pkg.add(l_calling_fn, 'l_event_type_code', l_event_type_code
123: ,p_log_level_rec => p_log_level_rec);
124: fa_debug_pkg.add(l_calling_fn, 'l_event_date', l_event_date
118: fa_debug_pkg.add(l_calling_fn, 'l_trx_source_info.source_id_int_1', l_trx_source_info.source_id_int_1
119: ,p_log_level_rec => p_log_level_rec);
120: fa_debug_pkg.add(l_calling_fn, 'l_trx_source_info.entity_type_code', l_trx_source_info.entity_type_code
121: ,p_log_level_rec => p_log_level_rec);
122: fa_debug_pkg.add(l_calling_fn, 'l_event_type_code', l_event_type_code
123: ,p_log_level_rec => p_log_level_rec);
124: fa_debug_pkg.add(l_calling_fn, 'l_event_date', l_event_date
125: ,p_log_level_rec => p_log_level_rec);
126: fa_debug_pkg.add(l_calling_fn, 'l_valuation_method', l_valuation_method
120: fa_debug_pkg.add(l_calling_fn, 'l_trx_source_info.entity_type_code', l_trx_source_info.entity_type_code
121: ,p_log_level_rec => p_log_level_rec);
122: fa_debug_pkg.add(l_calling_fn, 'l_event_type_code', l_event_type_code
123: ,p_log_level_rec => p_log_level_rec);
124: fa_debug_pkg.add(l_calling_fn, 'l_event_date', l_event_date
125: ,p_log_level_rec => p_log_level_rec);
126: fa_debug_pkg.add(l_calling_fn, 'l_valuation_method', l_valuation_method
127: ,p_log_level_rec => p_log_level_rec);
128:
122: fa_debug_pkg.add(l_calling_fn, 'l_event_type_code', l_event_type_code
123: ,p_log_level_rec => p_log_level_rec);
124: fa_debug_pkg.add(l_calling_fn, 'l_event_date', l_event_date
125: ,p_log_level_rec => p_log_level_rec);
126: fa_debug_pkg.add(l_calling_fn, 'l_valuation_method', l_valuation_method
127: ,p_log_level_rec => p_log_level_rec);
128:
129: end if;
130:
774:
775: elsif (p_calling_fn = 'fa_cip_pvt.do_cap_rev.secondary') then
776:
777: if (p_log_level_rec.statement_level) then
778: fa_debug_pkg.add(l_calling_fn, 'in del trx event p_book_type_code', p_book_type_code ,p_log_level_rec => p_log_level_rec);
779: fa_debug_pkg.add(l_calling_fn, 'in del trx event p_transaction_header_id', p_transaction_header_id ,p_log_level_rec => p_log_level_rec);
780: end if;
781:
782: select event_id
775: elsif (p_calling_fn = 'fa_cip_pvt.do_cap_rev.secondary') then
776:
777: if (p_log_level_rec.statement_level) then
778: fa_debug_pkg.add(l_calling_fn, 'in del trx event p_book_type_code', p_book_type_code ,p_log_level_rec => p_log_level_rec);
779: fa_debug_pkg.add(l_calling_fn, 'in del trx event p_transaction_header_id', p_transaction_header_id ,p_log_level_rec => p_log_level_rec);
780: end if;
781:
782: select event_id
783: into l_event_id
791: and ledger_id = p_secondary_sob_id
792: and xeve.entity_id = xent.entity_id;
793:
794: if (p_log_level_rec.statement_level) then
795: fa_debug_pkg.add(l_calling_fn, 'in del trx event l_event_id', l_event_id ,p_log_level_rec => p_log_level_rec);
796: end if;
797:
798: end if;
799: end if;
814:
815: EXCEPTION
816: WHEN OTHERS THEN
817: l_result := 1;
818: fa_debug_pkg.add(l_calling_fn, 'Unable to delete entity for trx event',
819: l_event_id, p_log_level_rec => p_log_level_rec);
820: END; --annonymous
821:
822: End If;
873:
874: EXCEPTION
875: WHEN OTHERS THEN
876: l_result := 1;
877: fa_debug_pkg.add(l_calling_fn, 'Unable to delete entity for event',
878: p_event_id, p_log_level_rec => p_log_level_rec);
879: fa_debug_pkg.add(l_calling_fn, 'l_result', l_result, p_log_level_rec => p_log_level_rec);
880: END; --annonymous
881:
875: WHEN OTHERS THEN
876: l_result := 1;
877: fa_debug_pkg.add(l_calling_fn, 'Unable to delete entity for event',
878: p_event_id, p_log_level_rec => p_log_level_rec);
879: fa_debug_pkg.add(l_calling_fn, 'l_result', l_result, p_log_level_rec => p_log_level_rec);
880: END; --annonymous
881:
882: return true;
883:
938: l_source_info.source_id_char_1 := p_book_type_code;
939: l_source_info.entity_type_code := 'TRANSACTIONS';
940:
941: if (p_log_level_rec.statement_level) then
942: fa_debug_pkg.add(l_calling_fn, 'calling get event status for event ', p_event_id
943: ,p_log_level_rec => p_log_level_rec);
944: end if;
945:
946: -- check the event status