20: +=======================================================================*/
21: --
22: --
23: TYPE t_rec_array_event IS RECORD
24: (array_legal_entity_id XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num
25: ,array_entity_id XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num
26: ,array_entity_code XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L
27: ,array_transaction_num XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L
28: ,array_event_id xla_number_array_type --XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num
21: --
22: --
23: TYPE t_rec_array_event IS RECORD
24: (array_legal_entity_id XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num
25: ,array_entity_id XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num
26: ,array_entity_code XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L
27: ,array_transaction_num XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L
28: ,array_event_id xla_number_array_type --XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num
29: ,array_class_code XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L
22: --
23: TYPE t_rec_array_event IS RECORD
24: (array_legal_entity_id XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num
25: ,array_entity_id XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num
26: ,array_entity_code XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L
27: ,array_transaction_num XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L
28: ,array_event_id xla_number_array_type --XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num
29: ,array_class_code XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L
30: ,array_event_type XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L
23: TYPE t_rec_array_event IS RECORD
24: (array_legal_entity_id XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num
25: ,array_entity_id XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num
26: ,array_entity_code XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L
27: ,array_transaction_num XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L
28: ,array_event_id xla_number_array_type --XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num
29: ,array_class_code XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L
30: ,array_event_type XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L
31: ,array_event_number XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num
24: (array_legal_entity_id XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num
25: ,array_entity_id XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num
26: ,array_entity_code XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L
27: ,array_transaction_num XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L
28: ,array_event_id xla_number_array_type --XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num
29: ,array_class_code XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L
30: ,array_event_type XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L
31: ,array_event_number XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num
32: ,array_event_date XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date
25: ,array_entity_id XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num
26: ,array_entity_code XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L
27: ,array_transaction_num XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L
28: ,array_event_id xla_number_array_type --XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num
29: ,array_class_code XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L
30: ,array_event_type XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L
31: ,array_event_number XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num
32: ,array_event_date XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date
33: ,array_reference_num_1 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num
26: ,array_entity_code XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L
27: ,array_transaction_num XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L
28: ,array_event_id xla_number_array_type --XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num
29: ,array_class_code XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L
30: ,array_event_type XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L
31: ,array_event_number XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num
32: ,array_event_date XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date
33: ,array_reference_num_1 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num
34: ,array_reference_num_2 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num
27: ,array_transaction_num XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L
28: ,array_event_id xla_number_array_type --XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num
29: ,array_class_code XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L
30: ,array_event_type XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L
31: ,array_event_number XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num
32: ,array_event_date XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date
33: ,array_reference_num_1 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num
34: ,array_reference_num_2 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num
35: ,array_reference_num_3 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num
28: ,array_event_id xla_number_array_type --XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num
29: ,array_class_code XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L
30: ,array_event_type XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L
31: ,array_event_number XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num
32: ,array_event_date XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date
33: ,array_reference_num_1 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num
34: ,array_reference_num_2 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num
35: ,array_reference_num_3 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num
36: ,array_reference_num_4 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num
29: ,array_class_code XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L
30: ,array_event_type XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L
31: ,array_event_number XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num
32: ,array_event_date XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date
33: ,array_reference_num_1 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num
34: ,array_reference_num_2 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num
35: ,array_reference_num_3 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num
36: ,array_reference_num_4 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num
37: ,array_reference_char_1 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L
30: ,array_event_type XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L
31: ,array_event_number XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num
32: ,array_event_date XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date
33: ,array_reference_num_1 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num
34: ,array_reference_num_2 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num
35: ,array_reference_num_3 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num
36: ,array_reference_num_4 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num
37: ,array_reference_char_1 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L
38: ,array_reference_char_2 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L
31: ,array_event_number XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num
32: ,array_event_date XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date
33: ,array_reference_num_1 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num
34: ,array_reference_num_2 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num
35: ,array_reference_num_3 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num
36: ,array_reference_num_4 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num
37: ,array_reference_char_1 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L
38: ,array_reference_char_2 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L
39: ,array_reference_char_3 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L
32: ,array_event_date XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date
33: ,array_reference_num_1 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num
34: ,array_reference_num_2 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num
35: ,array_reference_num_3 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num
36: ,array_reference_num_4 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num
37: ,array_reference_char_1 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L
38: ,array_reference_char_2 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L
39: ,array_reference_char_3 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L
40: ,array_reference_char_4 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L
33: ,array_reference_num_1 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num
34: ,array_reference_num_2 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num
35: ,array_reference_num_3 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num
36: ,array_reference_num_4 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num
37: ,array_reference_char_1 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L
38: ,array_reference_char_2 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L
39: ,array_reference_char_3 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L
40: ,array_reference_char_4 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L
41: ,array_reference_date_1 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date
34: ,array_reference_num_2 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num
35: ,array_reference_num_3 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num
36: ,array_reference_num_4 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num
37: ,array_reference_char_1 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L
38: ,array_reference_char_2 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L
39: ,array_reference_char_3 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L
40: ,array_reference_char_4 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L
41: ,array_reference_date_1 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date
42: ,array_reference_date_2 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date
35: ,array_reference_num_3 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num
36: ,array_reference_num_4 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num
37: ,array_reference_char_1 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L
38: ,array_reference_char_2 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L
39: ,array_reference_char_3 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L
40: ,array_reference_char_4 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L
41: ,array_reference_date_1 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date
42: ,array_reference_date_2 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date
43: ,array_reference_date_3 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date
36: ,array_reference_num_4 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num
37: ,array_reference_char_1 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L
38: ,array_reference_char_2 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L
39: ,array_reference_char_3 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L
40: ,array_reference_char_4 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L
41: ,array_reference_date_1 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date
42: ,array_reference_date_2 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date
43: ,array_reference_date_3 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date
44: ,array_reference_date_4 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date
37: ,array_reference_char_1 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L
38: ,array_reference_char_2 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L
39: ,array_reference_char_3 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L
40: ,array_reference_char_4 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L
41: ,array_reference_date_1 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date
42: ,array_reference_date_2 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date
43: ,array_reference_date_3 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date
44: ,array_reference_date_4 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date
45: ,array_event_created_by XLA_AE_JOURNAL_ENTRY_PKG.t_array_V100L
38: ,array_reference_char_2 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L
39: ,array_reference_char_3 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L
40: ,array_reference_char_4 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L
41: ,array_reference_date_1 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date
42: ,array_reference_date_2 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date
43: ,array_reference_date_3 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date
44: ,array_reference_date_4 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date
45: ,array_event_created_by XLA_AE_JOURNAL_ENTRY_PKG.t_array_V100L
46: );
39: ,array_reference_char_3 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L
40: ,array_reference_char_4 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L
41: ,array_reference_date_1 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date
42: ,array_reference_date_2 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date
43: ,array_reference_date_3 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date
44: ,array_reference_date_4 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date
45: ,array_event_created_by XLA_AE_JOURNAL_ENTRY_PKG.t_array_V100L
46: );
47: --
40: ,array_reference_char_4 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L
41: ,array_reference_date_1 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date
42: ,array_reference_date_2 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date
43: ,array_reference_date_3 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date
44: ,array_reference_date_4 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date
45: ,array_event_created_by XLA_AE_JOURNAL_ENTRY_PKG.t_array_V100L
46: );
47: --
48: type t_array_value_num is table of number index by varchar2(30);
41: ,array_reference_date_1 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date
42: ,array_reference_date_2 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date
43: ,array_reference_date_3 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date
44: ,array_reference_date_4 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date
45: ,array_event_created_by XLA_AE_JOURNAL_ENTRY_PKG.t_array_V100L
46: );
47: --
48: type t_array_value_num is table of number index by varchar2(30);
49: type t_array_value_char is table of varchar2(240) index by varchar2(30);
158:
159: END IF;
160:
161: IF p_lookup_code IS NOT NULL AND p_meaning IS NULL THEN
162: xla_ae_journal_entry_pkg.g_global_status := xla_ae_journal_entry_pkg.C_INVALID;
163: xla_accounting_err_pkg. build_message
164: (p_appli_s_name => 'XLA'
165: ,p_msg_name => 'XLA_AP_NO_LOOKUP_MEANING'
166: ,p_token_1 => 'SOURCE_NAME'
173: ,p_value_2 => p_lookup_code
174: ,p_token_3 => 'LOOKUP_TYPE'
175: ,p_value_3 => p_lookup_type
176: ,p_token_4 => 'PRODUCT_NAME'
177: ,p_value_4 => xla_ae_journal_entry_pkg.g_cache_event.application_name
178: ,p_entity_id => xla_ae_journal_entry_pkg.g_cache_event.entity_id
179: ,p_event_id => xla_ae_journal_entry_pkg.g_cache_event.event_id
180: ,p_ledger_id => xla_ae_journal_entry_pkg.g_cache_event.target_ledger_id
181: );
174: ,p_token_3 => 'LOOKUP_TYPE'
175: ,p_value_3 => p_lookup_type
176: ,p_token_4 => 'PRODUCT_NAME'
177: ,p_value_4 => xla_ae_journal_entry_pkg.g_cache_event.application_name
178: ,p_entity_id => xla_ae_journal_entry_pkg.g_cache_event.entity_id
179: ,p_event_id => xla_ae_journal_entry_pkg.g_cache_event.event_id
180: ,p_ledger_id => xla_ae_journal_entry_pkg.g_cache_event.target_ledger_id
181: );
182:
175: ,p_value_3 => p_lookup_type
176: ,p_token_4 => 'PRODUCT_NAME'
177: ,p_value_4 => xla_ae_journal_entry_pkg.g_cache_event.application_name
178: ,p_entity_id => xla_ae_journal_entry_pkg.g_cache_event.entity_id
179: ,p_event_id => xla_ae_journal_entry_pkg.g_cache_event.event_id
180: ,p_ledger_id => xla_ae_journal_entry_pkg.g_cache_event.target_ledger_id
181: );
182:
183: IF (C_LEVEL_ERROR >= g_log_level) THEN
176: ,p_token_4 => 'PRODUCT_NAME'
177: ,p_value_4 => xla_ae_journal_entry_pkg.g_cache_event.application_name
178: ,p_entity_id => xla_ae_journal_entry_pkg.g_cache_event.entity_id
179: ,p_event_id => xla_ae_journal_entry_pkg.g_cache_event.event_id
180: ,p_ledger_id => xla_ae_journal_entry_pkg.g_cache_event.target_ledger_id
181: );
182:
183: IF (C_LEVEL_ERROR >= g_log_level) THEN
184: trace
265: ,p_level => C_LEVEL_PROCEDURE
266: ,p_module => l_log_module);
267: END IF;
268:
269: l_ledger_language := xla_ae_journal_entry_pkg.g_cache_ledgers_info.description_language;
270: l_component_type := 'AMB_DESCRIPTION';
271: l_component_code := 'FV_TREASURY_DESC';
272: l_component_type_code := 'S';
273: l_component_appl_id := 8901;
292: l_description := SUBSTR(CONCAT(l_description,' Check Date:'),1,2000);
293: l_description := SUBSTR(CONCAT(l_description,' '),1,2000);
294: END IF;
295: l_source := SUBSTR(xla_ae_sources_pkg.DATE_TO_CHAR(p_source_2,
296: xla_ae_journal_entry_pkg.g_cache_ledgers_info.nls_desc_language),1,1996);
297: IF l_source IS NOT NULL THEN
298: l_description := SUBSTR(CONCAT(l_description,l_source),1,2000);
299: l_description := SUBSTR(CONCAT(l_description,' '),1,2000);
300: END IF;
455: ,p_module => l_log_module);
456:
457: END IF;
458:
459: xla_ae_journal_entry_pkg.g_global_status := xla_ae_journal_entry_pkg.C_INVALID;
460: x_value_combination_id := null;
461: x_value_segment_code := null;
462: x_value_type_code := null;
463: l_output_value := null;
477: 'XLA_OWNER_TYPE'
478: ,l_component_type_code
479: )
480: ,p_token_3 => 'PAD_NAME'
481: ,p_value_3 => xla_ae_journal_entry_pkg.g_cache_pad.pad_session_name
482: ,p_token_4 => 'PAD_OWNER'
483: ,p_value_4 => xla_lookups_pkg.get_meaning(
484: 'XLA_OWNER_TYPE'
485: ,xla_ae_journal_entry_pkg.g_cache_pad.product_rule_type_code
481: ,p_value_3 => xla_ae_journal_entry_pkg.g_cache_pad.pad_session_name
482: ,p_token_4 => 'PAD_OWNER'
483: ,p_value_4 => xla_lookups_pkg.get_meaning(
484: 'XLA_OWNER_TYPE'
485: ,xla_ae_journal_entry_pkg.g_cache_pad.product_rule_type_code
486: )
487: ,p_entity_id => xla_ae_journal_entry_pkg.g_cache_event.entity_id
488: ,p_event_id => xla_ae_journal_entry_pkg.g_cache_event.event_id
489: ,p_ledger_id => xla_ae_journal_entry_pkg.g_cache_event.target_ledger_id
483: ,p_value_4 => xla_lookups_pkg.get_meaning(
484: 'XLA_OWNER_TYPE'
485: ,xla_ae_journal_entry_pkg.g_cache_pad.product_rule_type_code
486: )
487: ,p_entity_id => xla_ae_journal_entry_pkg.g_cache_event.entity_id
488: ,p_event_id => xla_ae_journal_entry_pkg.g_cache_event.event_id
489: ,p_ledger_id => xla_ae_journal_entry_pkg.g_cache_event.target_ledger_id
490: ,p_ae_header_id => NULL
491: );
484: 'XLA_OWNER_TYPE'
485: ,xla_ae_journal_entry_pkg.g_cache_pad.product_rule_type_code
486: )
487: ,p_entity_id => xla_ae_journal_entry_pkg.g_cache_event.entity_id
488: ,p_event_id => xla_ae_journal_entry_pkg.g_cache_event.event_id
489: ,p_ledger_id => xla_ae_journal_entry_pkg.g_cache_event.target_ledger_id
490: ,p_ae_header_id => NULL
491: );
492: RETURN l_output_value;
485: ,xla_ae_journal_entry_pkg.g_cache_pad.product_rule_type_code
486: )
487: ,p_entity_id => xla_ae_journal_entry_pkg.g_cache_event.entity_id
488: ,p_event_id => xla_ae_journal_entry_pkg.g_cache_event.event_id
489: ,p_ledger_id => xla_ae_journal_entry_pkg.g_cache_event.target_ledger_id
490: ,p_ae_header_id => NULL
491: );
492: RETURN l_output_value;
493: EXCEPTION
577: ,p_module => l_log_module);
578:
579: END IF;
580:
581: xla_ae_journal_entry_pkg.g_global_status := xla_ae_journal_entry_pkg.C_INVALID;
582: x_value_combination_id := null;
583: x_value_segment_code := null;
584: x_value_type_code := null;
585: l_output_value := null;
599: 'XLA_OWNER_TYPE'
600: ,l_component_type_code
601: )
602: ,p_token_3 => 'PAD_NAME'
603: ,p_value_3 => xla_ae_journal_entry_pkg.g_cache_pad.pad_session_name
604: ,p_token_4 => 'PAD_OWNER'
605: ,p_value_4 => xla_lookups_pkg.get_meaning(
606: 'XLA_OWNER_TYPE'
607: ,xla_ae_journal_entry_pkg.g_cache_pad.product_rule_type_code
603: ,p_value_3 => xla_ae_journal_entry_pkg.g_cache_pad.pad_session_name
604: ,p_token_4 => 'PAD_OWNER'
605: ,p_value_4 => xla_lookups_pkg.get_meaning(
606: 'XLA_OWNER_TYPE'
607: ,xla_ae_journal_entry_pkg.g_cache_pad.product_rule_type_code
608: )
609: ,p_entity_id => xla_ae_journal_entry_pkg.g_cache_event.entity_id
610: ,p_event_id => xla_ae_journal_entry_pkg.g_cache_event.event_id
611: ,p_ledger_id => xla_ae_journal_entry_pkg.g_cache_event.target_ledger_id
605: ,p_value_4 => xla_lookups_pkg.get_meaning(
606: 'XLA_OWNER_TYPE'
607: ,xla_ae_journal_entry_pkg.g_cache_pad.product_rule_type_code
608: )
609: ,p_entity_id => xla_ae_journal_entry_pkg.g_cache_event.entity_id
610: ,p_event_id => xla_ae_journal_entry_pkg.g_cache_event.event_id
611: ,p_ledger_id => xla_ae_journal_entry_pkg.g_cache_event.target_ledger_id
612: ,p_ae_header_id => NULL
613: );
606: 'XLA_OWNER_TYPE'
607: ,xla_ae_journal_entry_pkg.g_cache_pad.product_rule_type_code
608: )
609: ,p_entity_id => xla_ae_journal_entry_pkg.g_cache_event.entity_id
610: ,p_event_id => xla_ae_journal_entry_pkg.g_cache_event.event_id
611: ,p_ledger_id => xla_ae_journal_entry_pkg.g_cache_event.target_ledger_id
612: ,p_ae_header_id => NULL
613: );
614: RETURN l_output_value;
607: ,xla_ae_journal_entry_pkg.g_cache_pad.product_rule_type_code
608: )
609: ,p_entity_id => xla_ae_journal_entry_pkg.g_cache_event.entity_id
610: ,p_event_id => xla_ae_journal_entry_pkg.g_cache_event.event_id
611: ,p_ledger_id => xla_ae_journal_entry_pkg.g_cache_event.target_ledger_id
612: ,p_ae_header_id => NULL
613: );
614: RETURN l_output_value;
615: EXCEPTION
734: ,p_module => l_log_module);
735:
736: END IF;
737:
738: xla_ae_journal_entry_pkg.g_global_status := xla_ae_journal_entry_pkg.C_INVALID;
739: x_value_combination_id := null;
740: x_value_segment_code := null;
741: x_value_type_code := null;
742: l_output_value := null;
756: 'XLA_OWNER_TYPE'
757: ,l_component_type_code
758: )
759: ,p_token_3 => 'PAD_NAME'
760: ,p_value_3 => xla_ae_journal_entry_pkg.g_cache_pad.pad_session_name
761: ,p_token_4 => 'PAD_OWNER'
762: ,p_value_4 => xla_lookups_pkg.get_meaning(
763: 'XLA_OWNER_TYPE'
764: ,xla_ae_journal_entry_pkg.g_cache_pad.product_rule_type_code
760: ,p_value_3 => xla_ae_journal_entry_pkg.g_cache_pad.pad_session_name
761: ,p_token_4 => 'PAD_OWNER'
762: ,p_value_4 => xla_lookups_pkg.get_meaning(
763: 'XLA_OWNER_TYPE'
764: ,xla_ae_journal_entry_pkg.g_cache_pad.product_rule_type_code
765: )
766: ,p_entity_id => xla_ae_journal_entry_pkg.g_cache_event.entity_id
767: ,p_event_id => xla_ae_journal_entry_pkg.g_cache_event.event_id
768: ,p_ledger_id => xla_ae_journal_entry_pkg.g_cache_event.target_ledger_id
762: ,p_value_4 => xla_lookups_pkg.get_meaning(
763: 'XLA_OWNER_TYPE'
764: ,xla_ae_journal_entry_pkg.g_cache_pad.product_rule_type_code
765: )
766: ,p_entity_id => xla_ae_journal_entry_pkg.g_cache_event.entity_id
767: ,p_event_id => xla_ae_journal_entry_pkg.g_cache_event.event_id
768: ,p_ledger_id => xla_ae_journal_entry_pkg.g_cache_event.target_ledger_id
769: ,p_ae_header_id => NULL
770: );
763: 'XLA_OWNER_TYPE'
764: ,xla_ae_journal_entry_pkg.g_cache_pad.product_rule_type_code
765: )
766: ,p_entity_id => xla_ae_journal_entry_pkg.g_cache_event.entity_id
767: ,p_event_id => xla_ae_journal_entry_pkg.g_cache_event.event_id
768: ,p_ledger_id => xla_ae_journal_entry_pkg.g_cache_event.target_ledger_id
769: ,p_ae_header_id => NULL
770: );
771: RETURN l_output_value;
764: ,xla_ae_journal_entry_pkg.g_cache_pad.product_rule_type_code
765: )
766: ,p_entity_id => xla_ae_journal_entry_pkg.g_cache_event.entity_id
767: ,p_event_id => xla_ae_journal_entry_pkg.g_cache_event.event_id
768: ,p_ledger_id => xla_ae_journal_entry_pkg.g_cache_event.target_ledger_id
769: ,p_ae_header_id => NULL
770: );
771: RETURN l_output_value;
772: EXCEPTION
882: ,p_module => l_log_module);
883:
884: END IF;
885:
886: xla_ae_journal_entry_pkg.g_global_status := xla_ae_journal_entry_pkg.C_INVALID;
887: x_value_combination_id := null;
888: x_value_segment_code := null;
889: x_value_type_code := null;
890: l_output_value := null;
904: 'XLA_OWNER_TYPE'
905: ,l_component_type_code
906: )
907: ,p_token_3 => 'PAD_NAME'
908: ,p_value_3 => xla_ae_journal_entry_pkg.g_cache_pad.pad_session_name
909: ,p_token_4 => 'PAD_OWNER'
910: ,p_value_4 => xla_lookups_pkg.get_meaning(
911: 'XLA_OWNER_TYPE'
912: ,xla_ae_journal_entry_pkg.g_cache_pad.product_rule_type_code
908: ,p_value_3 => xla_ae_journal_entry_pkg.g_cache_pad.pad_session_name
909: ,p_token_4 => 'PAD_OWNER'
910: ,p_value_4 => xla_lookups_pkg.get_meaning(
911: 'XLA_OWNER_TYPE'
912: ,xla_ae_journal_entry_pkg.g_cache_pad.product_rule_type_code
913: )
914: ,p_entity_id => xla_ae_journal_entry_pkg.g_cache_event.entity_id
915: ,p_event_id => xla_ae_journal_entry_pkg.g_cache_event.event_id
916: ,p_ledger_id => xla_ae_journal_entry_pkg.g_cache_event.target_ledger_id
910: ,p_value_4 => xla_lookups_pkg.get_meaning(
911: 'XLA_OWNER_TYPE'
912: ,xla_ae_journal_entry_pkg.g_cache_pad.product_rule_type_code
913: )
914: ,p_entity_id => xla_ae_journal_entry_pkg.g_cache_event.entity_id
915: ,p_event_id => xla_ae_journal_entry_pkg.g_cache_event.event_id
916: ,p_ledger_id => xla_ae_journal_entry_pkg.g_cache_event.target_ledger_id
917: ,p_ae_header_id => NULL
918: );
911: 'XLA_OWNER_TYPE'
912: ,xla_ae_journal_entry_pkg.g_cache_pad.product_rule_type_code
913: )
914: ,p_entity_id => xla_ae_journal_entry_pkg.g_cache_event.entity_id
915: ,p_event_id => xla_ae_journal_entry_pkg.g_cache_event.event_id
916: ,p_ledger_id => xla_ae_journal_entry_pkg.g_cache_event.target_ledger_id
917: ,p_ae_header_id => NULL
918: );
919: RETURN l_output_value;
912: ,xla_ae_journal_entry_pkg.g_cache_pad.product_rule_type_code
913: )
914: ,p_entity_id => xla_ae_journal_entry_pkg.g_cache_event.entity_id
915: ,p_event_id => xla_ae_journal_entry_pkg.g_cache_event.event_id
916: ,p_ledger_id => xla_ae_journal_entry_pkg.g_cache_event.target_ledger_id
917: ,p_ae_header_id => NULL
918: );
919: RETURN l_output_value;
920: EXCEPTION
1030: ,p_module => l_log_module);
1031:
1032: END IF;
1033:
1034: xla_ae_journal_entry_pkg.g_global_status := xla_ae_journal_entry_pkg.C_INVALID;
1035: x_value_combination_id := null;
1036: x_value_segment_code := null;
1037: x_value_type_code := null;
1038: l_output_value := null;
1052: 'XLA_OWNER_TYPE'
1053: ,l_component_type_code
1054: )
1055: ,p_token_3 => 'PAD_NAME'
1056: ,p_value_3 => xla_ae_journal_entry_pkg.g_cache_pad.pad_session_name
1057: ,p_token_4 => 'PAD_OWNER'
1058: ,p_value_4 => xla_lookups_pkg.get_meaning(
1059: 'XLA_OWNER_TYPE'
1060: ,xla_ae_journal_entry_pkg.g_cache_pad.product_rule_type_code
1056: ,p_value_3 => xla_ae_journal_entry_pkg.g_cache_pad.pad_session_name
1057: ,p_token_4 => 'PAD_OWNER'
1058: ,p_value_4 => xla_lookups_pkg.get_meaning(
1059: 'XLA_OWNER_TYPE'
1060: ,xla_ae_journal_entry_pkg.g_cache_pad.product_rule_type_code
1061: )
1062: ,p_entity_id => xla_ae_journal_entry_pkg.g_cache_event.entity_id
1063: ,p_event_id => xla_ae_journal_entry_pkg.g_cache_event.event_id
1064: ,p_ledger_id => xla_ae_journal_entry_pkg.g_cache_event.target_ledger_id
1058: ,p_value_4 => xla_lookups_pkg.get_meaning(
1059: 'XLA_OWNER_TYPE'
1060: ,xla_ae_journal_entry_pkg.g_cache_pad.product_rule_type_code
1061: )
1062: ,p_entity_id => xla_ae_journal_entry_pkg.g_cache_event.entity_id
1063: ,p_event_id => xla_ae_journal_entry_pkg.g_cache_event.event_id
1064: ,p_ledger_id => xla_ae_journal_entry_pkg.g_cache_event.target_ledger_id
1065: ,p_ae_header_id => NULL
1066: );
1059: 'XLA_OWNER_TYPE'
1060: ,xla_ae_journal_entry_pkg.g_cache_pad.product_rule_type_code
1061: )
1062: ,p_entity_id => xla_ae_journal_entry_pkg.g_cache_event.entity_id
1063: ,p_event_id => xla_ae_journal_entry_pkg.g_cache_event.event_id
1064: ,p_ledger_id => xla_ae_journal_entry_pkg.g_cache_event.target_ledger_id
1065: ,p_ae_header_id => NULL
1066: );
1067: RETURN l_output_value;
1060: ,xla_ae_journal_entry_pkg.g_cache_pad.product_rule_type_code
1061: )
1062: ,p_entity_id => xla_ae_journal_entry_pkg.g_cache_event.entity_id
1063: ,p_event_id => xla_ae_journal_entry_pkg.g_cache_event.event_id
1064: ,p_ledger_id => xla_ae_journal_entry_pkg.g_cache_event.target_ledger_id
1065: ,p_ae_header_id => NULL
1066: );
1067: RETURN l_output_value;
1068: EXCEPTION
1136: (p_msg => 'END of AcctDerRule_7(invalid)'
1137: ,p_level => C_LEVEL_PROCEDURE
1138: ,p_module => l_log_module);
1139: END IF;
1140: xla_ae_journal_entry_pkg.g_global_status := xla_ae_journal_entry_pkg.C_INVALID;
1141: x_value_type_code := null;
1142: l_output_value := null;
1143: xla_accounting_err_pkg.build_message
1144: (p_appli_s_name => 'XLA'
1156: 'XLA_OWNER_TYPE'
1157: ,l_component_type_code
1158: )
1159: ,p_token_3 => 'PAD_NAME'
1160: ,p_value_3 => xla_ae_journal_entry_pkg.g_cache_pad.pad_session_name
1161: ,p_token_4 => 'PAD_OWNER'
1162: ,p_value_4 => xla_lookups_pkg.get_meaning(
1163: 'XLA_OWNER_TYPE'
1164: ,xla_ae_journal_entry_pkg.g_cache_pad.product_rule_type_code
1160: ,p_value_3 => xla_ae_journal_entry_pkg.g_cache_pad.pad_session_name
1161: ,p_token_4 => 'PAD_OWNER'
1162: ,p_value_4 => xla_lookups_pkg.get_meaning(
1163: 'XLA_OWNER_TYPE'
1164: ,xla_ae_journal_entry_pkg.g_cache_pad.product_rule_type_code
1165: )
1166: ,p_entity_id => xla_ae_journal_entry_pkg.g_cache_event.entity_id
1167: ,p_event_id => xla_ae_journal_entry_pkg.g_cache_event.event_id
1168: ,p_ledger_id => xla_ae_journal_entry_pkg.g_cache_event.target_ledger_id
1162: ,p_value_4 => xla_lookups_pkg.get_meaning(
1163: 'XLA_OWNER_TYPE'
1164: ,xla_ae_journal_entry_pkg.g_cache_pad.product_rule_type_code
1165: )
1166: ,p_entity_id => xla_ae_journal_entry_pkg.g_cache_event.entity_id
1167: ,p_event_id => xla_ae_journal_entry_pkg.g_cache_event.event_id
1168: ,p_ledger_id => xla_ae_journal_entry_pkg.g_cache_event.target_ledger_id
1169: ,p_ae_header_id => NULL
1170: );
1163: 'XLA_OWNER_TYPE'
1164: ,xla_ae_journal_entry_pkg.g_cache_pad.product_rule_type_code
1165: )
1166: ,p_entity_id => xla_ae_journal_entry_pkg.g_cache_event.entity_id
1167: ,p_event_id => xla_ae_journal_entry_pkg.g_cache_event.event_id
1168: ,p_ledger_id => xla_ae_journal_entry_pkg.g_cache_event.target_ledger_id
1169: ,p_ae_header_id => NULL
1170: );
1171: RETURN l_output_value;
1164: ,xla_ae_journal_entry_pkg.g_cache_pad.product_rule_type_code
1165: )
1166: ,p_entity_id => xla_ae_journal_entry_pkg.g_cache_event.entity_id
1167: ,p_event_id => xla_ae_journal_entry_pkg.g_cache_event.event_id
1168: ,p_ledger_id => xla_ae_journal_entry_pkg.g_cache_event.target_ledger_id
1169: ,p_ae_header_id => NULL
1170: );
1171: RETURN l_output_value;
1172: EXCEPTION
1263: (p_msg => 'END of AcctDerRule_8(invalid)'
1264: ,p_level => C_LEVEL_PROCEDURE
1265: ,p_module => l_log_module);
1266: END IF;
1267: xla_ae_journal_entry_pkg.g_global_status := xla_ae_journal_entry_pkg.C_INVALID;
1268: x_value_type_code := null;
1269: l_output_value := null;
1270: xla_accounting_err_pkg.build_message
1271: (p_appli_s_name => 'XLA'
1283: 'XLA_OWNER_TYPE'
1284: ,l_component_type_code
1285: )
1286: ,p_token_3 => 'PAD_NAME'
1287: ,p_value_3 => xla_ae_journal_entry_pkg.g_cache_pad.pad_session_name
1288: ,p_token_4 => 'PAD_OWNER'
1289: ,p_value_4 => xla_lookups_pkg.get_meaning(
1290: 'XLA_OWNER_TYPE'
1291: ,xla_ae_journal_entry_pkg.g_cache_pad.product_rule_type_code
1287: ,p_value_3 => xla_ae_journal_entry_pkg.g_cache_pad.pad_session_name
1288: ,p_token_4 => 'PAD_OWNER'
1289: ,p_value_4 => xla_lookups_pkg.get_meaning(
1290: 'XLA_OWNER_TYPE'
1291: ,xla_ae_journal_entry_pkg.g_cache_pad.product_rule_type_code
1292: )
1293: ,p_entity_id => xla_ae_journal_entry_pkg.g_cache_event.entity_id
1294: ,p_event_id => xla_ae_journal_entry_pkg.g_cache_event.event_id
1295: ,p_ledger_id => xla_ae_journal_entry_pkg.g_cache_event.target_ledger_id
1289: ,p_value_4 => xla_lookups_pkg.get_meaning(
1290: 'XLA_OWNER_TYPE'
1291: ,xla_ae_journal_entry_pkg.g_cache_pad.product_rule_type_code
1292: )
1293: ,p_entity_id => xla_ae_journal_entry_pkg.g_cache_event.entity_id
1294: ,p_event_id => xla_ae_journal_entry_pkg.g_cache_event.event_id
1295: ,p_ledger_id => xla_ae_journal_entry_pkg.g_cache_event.target_ledger_id
1296: ,p_ae_header_id => NULL
1297: );
1290: 'XLA_OWNER_TYPE'
1291: ,xla_ae_journal_entry_pkg.g_cache_pad.product_rule_type_code
1292: )
1293: ,p_entity_id => xla_ae_journal_entry_pkg.g_cache_event.entity_id
1294: ,p_event_id => xla_ae_journal_entry_pkg.g_cache_event.event_id
1295: ,p_ledger_id => xla_ae_journal_entry_pkg.g_cache_event.target_ledger_id
1296: ,p_ae_header_id => NULL
1297: );
1298: RETURN l_output_value;
1291: ,xla_ae_journal_entry_pkg.g_cache_pad.product_rule_type_code
1292: )
1293: ,p_entity_id => xla_ae_journal_entry_pkg.g_cache_event.entity_id
1294: ,p_event_id => xla_ae_journal_entry_pkg.g_cache_event.event_id
1295: ,p_ledger_id => xla_ae_journal_entry_pkg.g_cache_event.target_ledger_id
1296: ,p_ae_header_id => NULL
1297: );
1298: RETURN l_output_value;
1299: EXCEPTION
1400: l_tmp_amt NUMBER;
1401: l_acc_rev_natural_side_code VARCHAR2(1);
1402:
1403: l_num_entries NUMBER;
1404: l_gl_dates xla_ae_journal_entry_pkg.t_array_date;
1405: l_accted_amts xla_ae_journal_entry_pkg.t_array_num;
1406: l_entered_amts xla_ae_journal_entry_pkg.t_array_num;
1407: l_period_names xla_ae_journal_entry_pkg.t_array_V15L;
1408: l_recog_line_1 NUMBER;
1401: l_acc_rev_natural_side_code VARCHAR2(1);
1402:
1403: l_num_entries NUMBER;
1404: l_gl_dates xla_ae_journal_entry_pkg.t_array_date;
1405: l_accted_amts xla_ae_journal_entry_pkg.t_array_num;
1406: l_entered_amts xla_ae_journal_entry_pkg.t_array_num;
1407: l_period_names xla_ae_journal_entry_pkg.t_array_V15L;
1408: l_recog_line_1 NUMBER;
1409: l_recog_line_2 NUMBER;
1402:
1403: l_num_entries NUMBER;
1404: l_gl_dates xla_ae_journal_entry_pkg.t_array_date;
1405: l_accted_amts xla_ae_journal_entry_pkg.t_array_num;
1406: l_entered_amts xla_ae_journal_entry_pkg.t_array_num;
1407: l_period_names xla_ae_journal_entry_pkg.t_array_V15L;
1408: l_recog_line_1 NUMBER;
1409: l_recog_line_2 NUMBER;
1410:
1403: l_num_entries NUMBER;
1404: l_gl_dates xla_ae_journal_entry_pkg.t_array_date;
1405: l_accted_amts xla_ae_journal_entry_pkg.t_array_num;
1406: l_entered_amts xla_ae_journal_entry_pkg.t_array_num;
1407: l_period_names xla_ae_journal_entry_pkg.t_array_V15L;
1408: l_recog_line_1 NUMBER;
1409: l_recog_line_2 NUMBER;
1410:
1411: l_bflow_applied_to_amt_idx NUMBER; -- 5132302
1409: l_recog_line_2 NUMBER;
1410:
1411: l_bflow_applied_to_amt_idx NUMBER; -- 5132302
1412: l_bflow_applied_to_amt NUMBER; -- 5132302
1413: l_bflow_applied_to_amts xla_ae_journal_entry_pkg.t_array_num; -- 5132302
1414:
1415: l_event_id NUMBER; -- To handle MPA header Description: xla_ae_header_pkg.SetHdrDescription
1416:
1417: --l_rounding_ccy VARCHAR2(15); -- To handle MPA rounding 4262811b
1484: l_accrual_line_num := NULL; -- 4262811
1485: l_tmp_amt := NULL; -- 4262811
1486: --
1487:
1488: IF XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.target_ledger_id = XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.ledger_id OR
1489: l_balance_type_code <> 'B' THEN
1490: IF NVL(
1491: xla_ae_sources_pkg.GetSystemSourceChar(
1492: p_source_code => 'XLA_EVENT_TYPE_CODE'
1562: --
1563: XLA_AE_LINES_PKG.g_rec_lines.array_balance_type_code(XLA_AE_LINES_PKG.g_LineNumber) := l_balance_type_code;
1564:
1565: XLA_AE_LINES_PKG.g_rec_lines.array_ledger_id(XLA_AE_LINES_PKG.g_LineNumber) :=
1566: XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.target_ledger_id;
1567:
1568: -- 4955764
1569: XLA_AE_LINES_PKG.g_rec_lines.array_gl_date(XLA_AE_LINES_PKG.g_LineNumber) :=
1570: XLA_AE_HEADER_PKG.g_rec_header_new.array_gl_date(g_array_event(p_event_id).array_value_num('header_index'));
1616: l_enc_upg_option := XLA_AE_LINES_PKG.g_rec_lines.array_enc_upg_option(XLA_AE_LINES_PKG.g_LineNumber);
1617:
1618: IF xla_accounting_cache_pkg.GetValueChar
1619: (p_source_code => 'LEDGER_CATEGORY_CODE'
1620: ,p_target_ledger_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.target_ledger_id) IN ('PRIMARY','ALC')
1621: AND l_bflow_method_code = 'PRIOR_ENTRY'
1622: -- AND (l_actual_upg_option = 'Y' OR l_enc_upg_option = 'Y') Bug 4922099
1623: AND ( (NVL(l_actual_upg_option, 'N') IN ('Y', 'O')) OR
1624: (NVL(l_enc_upg_option, 'N') IN ('Y', 'O'))
1814: p_lookup_type => 'XLA_OWNER_TYPE'
1815: ,p_lookup_code => l_component_type_code
1816: )
1817: ,p_token_4 => 'PRODUCT_NAME'
1818: ,p_value_4 => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.application_name
1819: ,p_entity_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.entity_id
1820: ,p_event_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.event_id
1821: ,p_ledger_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.target_ledger_id
1822: ,p_ae_header_id => NULL
1815: ,p_lookup_code => l_component_type_code
1816: )
1817: ,p_token_4 => 'PRODUCT_NAME'
1818: ,p_value_4 => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.application_name
1819: ,p_entity_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.entity_id
1820: ,p_event_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.event_id
1821: ,p_ledger_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.target_ledger_id
1822: ,p_ae_header_id => NULL
1823: );
1816: )
1817: ,p_token_4 => 'PRODUCT_NAME'
1818: ,p_value_4 => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.application_name
1819: ,p_entity_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.entity_id
1820: ,p_event_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.event_id
1821: ,p_ledger_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.target_ledger_id
1822: ,p_ae_header_id => NULL
1823: );
1824:
1817: ,p_token_4 => 'PRODUCT_NAME'
1818: ,p_value_4 => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.application_name
1819: ,p_entity_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.entity_id
1820: ,p_event_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.event_id
1821: ,p_ledger_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.target_ledger_id
1822: ,p_ae_header_id => NULL
1823: );
1824:
1825: IF (C_LEVEL_ERROR>= g_log_level) THEN
1848: ----------------------------------------------------------------------------------
1849: -- 4219869 Business Flow
1850: -- Update journal entry status -- Need to generate this within IF
1851: ----------------------------------------------------------------------------------
1852: XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
1853: (p_hdr_idx => g_array_event(p_event_id).array_value_num('header_index')
1854: ,p_balance_type_code => l_balance_type_code
1855: );
1856:
1893:
1894: --
1895: -- Depending on the Reversal Method setup, do a switch side or changes sign for the amounts
1896: --
1897: IF (XLA_AE_JOURNAL_ENTRY_PKG.g_cache_ledgers_info.ledger_reversal_option = 'SIDE') THEN
1898: XLA_AE_LINES_PKG.g_rec_lines.array_natural_side_code(XLA_AE_LINES_PKG.g_LineNumber) := l_acc_rev_natural_side_code;
1899: ELSE
1900: ---------------------------------------------------------------------------------------------------
1901: -- 4262811a Switch Sign
1918:
1919: XLA_AE_LINES_PKG.ValidateCurrentLine;
1920: XLA_AE_LINES_PKG.SetDebitCreditAmounts;
1921:
1922: XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
1923: (p_hdr_idx => g_array_event(p_event_id).array_value_num('acc_rev_header_index')
1924: ,p_balance_type_code => l_balance_type_code);
1925:
1926: END IF;
2022: l_tmp_amt NUMBER;
2023: l_acc_rev_natural_side_code VARCHAR2(1);
2024:
2025: l_num_entries NUMBER;
2026: l_gl_dates xla_ae_journal_entry_pkg.t_array_date;
2027: l_accted_amts xla_ae_journal_entry_pkg.t_array_num;
2028: l_entered_amts xla_ae_journal_entry_pkg.t_array_num;
2029: l_period_names xla_ae_journal_entry_pkg.t_array_V15L;
2030: l_recog_line_1 NUMBER;
2023: l_acc_rev_natural_side_code VARCHAR2(1);
2024:
2025: l_num_entries NUMBER;
2026: l_gl_dates xla_ae_journal_entry_pkg.t_array_date;
2027: l_accted_amts xla_ae_journal_entry_pkg.t_array_num;
2028: l_entered_amts xla_ae_journal_entry_pkg.t_array_num;
2029: l_period_names xla_ae_journal_entry_pkg.t_array_V15L;
2030: l_recog_line_1 NUMBER;
2031: l_recog_line_2 NUMBER;
2024:
2025: l_num_entries NUMBER;
2026: l_gl_dates xla_ae_journal_entry_pkg.t_array_date;
2027: l_accted_amts xla_ae_journal_entry_pkg.t_array_num;
2028: l_entered_amts xla_ae_journal_entry_pkg.t_array_num;
2029: l_period_names xla_ae_journal_entry_pkg.t_array_V15L;
2030: l_recog_line_1 NUMBER;
2031: l_recog_line_2 NUMBER;
2032:
2025: l_num_entries NUMBER;
2026: l_gl_dates xla_ae_journal_entry_pkg.t_array_date;
2027: l_accted_amts xla_ae_journal_entry_pkg.t_array_num;
2028: l_entered_amts xla_ae_journal_entry_pkg.t_array_num;
2029: l_period_names xla_ae_journal_entry_pkg.t_array_V15L;
2030: l_recog_line_1 NUMBER;
2031: l_recog_line_2 NUMBER;
2032:
2033: l_bflow_applied_to_amt_idx NUMBER; -- 5132302
2031: l_recog_line_2 NUMBER;
2032:
2033: l_bflow_applied_to_amt_idx NUMBER; -- 5132302
2034: l_bflow_applied_to_amt NUMBER; -- 5132302
2035: l_bflow_applied_to_amts xla_ae_journal_entry_pkg.t_array_num; -- 5132302
2036:
2037: l_event_id NUMBER; -- To handle MPA header Description: xla_ae_header_pkg.SetHdrDescription
2038:
2039: --l_rounding_ccy VARCHAR2(15); -- To handle MPA rounding 4262811b
2106: l_accrual_line_num := NULL; -- 4262811
2107: l_tmp_amt := NULL; -- 4262811
2108: --
2109:
2110: IF XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.target_ledger_id = XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.ledger_id OR
2111: l_balance_type_code <> 'B' THEN
2112: IF NVL(
2113: xla_ae_sources_pkg.GetSystemSourceChar(
2114: p_source_code => 'XLA_EVENT_TYPE_CODE'
2190: --
2191: XLA_AE_LINES_PKG.g_rec_lines.array_balance_type_code(XLA_AE_LINES_PKG.g_LineNumber) := l_balance_type_code;
2192:
2193: XLA_AE_LINES_PKG.g_rec_lines.array_ledger_id(XLA_AE_LINES_PKG.g_LineNumber) :=
2194: XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.target_ledger_id;
2195:
2196: -- 4955764
2197: XLA_AE_LINES_PKG.g_rec_lines.array_gl_date(XLA_AE_LINES_PKG.g_LineNumber) :=
2198: XLA_AE_HEADER_PKG.g_rec_header_new.array_gl_date(g_array_event(p_event_id).array_value_num('header_index'));
2238: l_enc_upg_option := XLA_AE_LINES_PKG.g_rec_lines.array_enc_upg_option(XLA_AE_LINES_PKG.g_LineNumber);
2239:
2240: IF xla_accounting_cache_pkg.GetValueChar
2241: (p_source_code => 'LEDGER_CATEGORY_CODE'
2242: ,p_target_ledger_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.target_ledger_id) IN ('PRIMARY','ALC')
2243: AND l_bflow_method_code = 'PRIOR_ENTRY'
2244: -- AND (l_actual_upg_option = 'Y' OR l_enc_upg_option = 'Y') Bug 4922099
2245: AND ( (NVL(l_actual_upg_option, 'N') IN ('Y', 'O')) OR
2246: (NVL(l_enc_upg_option, 'N') IN ('Y', 'O'))
2311: p_lookup_type => 'XLA_OWNER_TYPE'
2312: ,p_lookup_code => l_component_type_code
2313: )
2314: ,p_token_4 => 'PRODUCT_NAME'
2315: ,p_value_4 => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.application_name
2316: ,p_entity_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.entity_id
2317: ,p_event_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.event_id
2318: ,p_ledger_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.target_ledger_id
2319: ,p_ae_header_id => NULL
2312: ,p_lookup_code => l_component_type_code
2313: )
2314: ,p_token_4 => 'PRODUCT_NAME'
2315: ,p_value_4 => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.application_name
2316: ,p_entity_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.entity_id
2317: ,p_event_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.event_id
2318: ,p_ledger_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.target_ledger_id
2319: ,p_ae_header_id => NULL
2320: );
2313: )
2314: ,p_token_4 => 'PRODUCT_NAME'
2315: ,p_value_4 => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.application_name
2316: ,p_entity_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.entity_id
2317: ,p_event_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.event_id
2318: ,p_ledger_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.target_ledger_id
2319: ,p_ae_header_id => NULL
2320: );
2321:
2314: ,p_token_4 => 'PRODUCT_NAME'
2315: ,p_value_4 => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.application_name
2316: ,p_entity_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.entity_id
2317: ,p_event_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.event_id
2318: ,p_ledger_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.target_ledger_id
2319: ,p_ae_header_id => NULL
2320: );
2321:
2322: IF (C_LEVEL_ERROR>= g_log_level) THEN
2345: ----------------------------------------------------------------------------------
2346: -- 4219869 Business Flow
2347: -- Update journal entry status -- Need to generate this within IF
2348: ----------------------------------------------------------------------------------
2349: XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
2350: (p_hdr_idx => g_array_event(p_event_id).array_value_num('header_index')
2351: ,p_balance_type_code => l_balance_type_code
2352: );
2353:
2390:
2391: --
2392: -- Depending on the Reversal Method setup, do a switch side or changes sign for the amounts
2393: --
2394: IF (XLA_AE_JOURNAL_ENTRY_PKG.g_cache_ledgers_info.ledger_reversal_option = 'SIDE') THEN
2395: XLA_AE_LINES_PKG.g_rec_lines.array_natural_side_code(XLA_AE_LINES_PKG.g_LineNumber) := l_acc_rev_natural_side_code;
2396: ELSE
2397: ---------------------------------------------------------------------------------------------------
2398: -- 4262811a Switch Sign
2415:
2416: XLA_AE_LINES_PKG.ValidateCurrentLine;
2417: XLA_AE_LINES_PKG.SetDebitCreditAmounts;
2418:
2419: XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
2420: (p_hdr_idx => g_array_event(p_event_id).array_value_num('acc_rev_header_index')
2421: ,p_balance_type_code => l_balance_type_code);
2422:
2423: END IF;
2540: l_tmp_amt NUMBER;
2541: l_acc_rev_natural_side_code VARCHAR2(1);
2542:
2543: l_num_entries NUMBER;
2544: l_gl_dates xla_ae_journal_entry_pkg.t_array_date;
2545: l_accted_amts xla_ae_journal_entry_pkg.t_array_num;
2546: l_entered_amts xla_ae_journal_entry_pkg.t_array_num;
2547: l_period_names xla_ae_journal_entry_pkg.t_array_V15L;
2548: l_recog_line_1 NUMBER;
2541: l_acc_rev_natural_side_code VARCHAR2(1);
2542:
2543: l_num_entries NUMBER;
2544: l_gl_dates xla_ae_journal_entry_pkg.t_array_date;
2545: l_accted_amts xla_ae_journal_entry_pkg.t_array_num;
2546: l_entered_amts xla_ae_journal_entry_pkg.t_array_num;
2547: l_period_names xla_ae_journal_entry_pkg.t_array_V15L;
2548: l_recog_line_1 NUMBER;
2549: l_recog_line_2 NUMBER;
2542:
2543: l_num_entries NUMBER;
2544: l_gl_dates xla_ae_journal_entry_pkg.t_array_date;
2545: l_accted_amts xla_ae_journal_entry_pkg.t_array_num;
2546: l_entered_amts xla_ae_journal_entry_pkg.t_array_num;
2547: l_period_names xla_ae_journal_entry_pkg.t_array_V15L;
2548: l_recog_line_1 NUMBER;
2549: l_recog_line_2 NUMBER;
2550:
2543: l_num_entries NUMBER;
2544: l_gl_dates xla_ae_journal_entry_pkg.t_array_date;
2545: l_accted_amts xla_ae_journal_entry_pkg.t_array_num;
2546: l_entered_amts xla_ae_journal_entry_pkg.t_array_num;
2547: l_period_names xla_ae_journal_entry_pkg.t_array_V15L;
2548: l_recog_line_1 NUMBER;
2549: l_recog_line_2 NUMBER;
2550:
2551: l_bflow_applied_to_amt_idx NUMBER; -- 5132302
2549: l_recog_line_2 NUMBER;
2550:
2551: l_bflow_applied_to_amt_idx NUMBER; -- 5132302
2552: l_bflow_applied_to_amt NUMBER; -- 5132302
2553: l_bflow_applied_to_amts xla_ae_journal_entry_pkg.t_array_num; -- 5132302
2554:
2555: l_event_id NUMBER; -- To handle MPA header Description: xla_ae_header_pkg.SetHdrDescription
2556:
2557: --l_rounding_ccy VARCHAR2(15); -- To handle MPA rounding 4262811b
2624: l_accrual_line_num := NULL; -- 4262811
2625: l_tmp_amt := NULL; -- 4262811
2626: --
2627:
2628: IF XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.target_ledger_id = XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.ledger_id OR
2629: l_balance_type_code <> 'B' THEN
2630: IF NVL(
2631: xla_ae_sources_pkg.GetSystemSourceChar(
2632: p_source_code => 'XLA_EVENT_TYPE_CODE'
2702: --
2703: XLA_AE_LINES_PKG.g_rec_lines.array_balance_type_code(XLA_AE_LINES_PKG.g_LineNumber) := l_balance_type_code;
2704:
2705: XLA_AE_LINES_PKG.g_rec_lines.array_ledger_id(XLA_AE_LINES_PKG.g_LineNumber) :=
2706: XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.target_ledger_id;
2707:
2708: -- 4955764
2709: XLA_AE_LINES_PKG.g_rec_lines.array_gl_date(XLA_AE_LINES_PKG.g_LineNumber) :=
2710: XLA_AE_HEADER_PKG.g_rec_header_new.array_gl_date(g_array_event(p_event_id).array_value_num('header_index'));
2756: l_enc_upg_option := XLA_AE_LINES_PKG.g_rec_lines.array_enc_upg_option(XLA_AE_LINES_PKG.g_LineNumber);
2757:
2758: IF xla_accounting_cache_pkg.GetValueChar
2759: (p_source_code => 'LEDGER_CATEGORY_CODE'
2760: ,p_target_ledger_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.target_ledger_id) IN ('PRIMARY','ALC')
2761: AND l_bflow_method_code = 'PRIOR_ENTRY'
2762: -- AND (l_actual_upg_option = 'Y' OR l_enc_upg_option = 'Y') Bug 4922099
2763: AND ( (NVL(l_actual_upg_option, 'N') IN ('Y', 'O')) OR
2764: (NVL(l_enc_upg_option, 'N') IN ('Y', 'O'))
2952: p_lookup_type => 'XLA_OWNER_TYPE'
2953: ,p_lookup_code => l_component_type_code
2954: )
2955: ,p_token_4 => 'PRODUCT_NAME'
2956: ,p_value_4 => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.application_name
2957: ,p_entity_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.entity_id
2958: ,p_event_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.event_id
2959: ,p_ledger_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.target_ledger_id
2960: ,p_ae_header_id => NULL
2953: ,p_lookup_code => l_component_type_code
2954: )
2955: ,p_token_4 => 'PRODUCT_NAME'
2956: ,p_value_4 => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.application_name
2957: ,p_entity_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.entity_id
2958: ,p_event_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.event_id
2959: ,p_ledger_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.target_ledger_id
2960: ,p_ae_header_id => NULL
2961: );
2954: )
2955: ,p_token_4 => 'PRODUCT_NAME'
2956: ,p_value_4 => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.application_name
2957: ,p_entity_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.entity_id
2958: ,p_event_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.event_id
2959: ,p_ledger_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.target_ledger_id
2960: ,p_ae_header_id => NULL
2961: );
2962:
2955: ,p_token_4 => 'PRODUCT_NAME'
2956: ,p_value_4 => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.application_name
2957: ,p_entity_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.entity_id
2958: ,p_event_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.event_id
2959: ,p_ledger_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.target_ledger_id
2960: ,p_ae_header_id => NULL
2961: );
2962:
2963: IF (C_LEVEL_ERROR>= g_log_level) THEN
2986: ----------------------------------------------------------------------------------
2987: -- 4219869 Business Flow
2988: -- Update journal entry status -- Need to generate this within IF
2989: ----------------------------------------------------------------------------------
2990: XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
2991: (p_hdr_idx => g_array_event(p_event_id).array_value_num('header_index')
2992: ,p_balance_type_code => l_balance_type_code
2993: );
2994:
3031:
3032: --
3033: -- Depending on the Reversal Method setup, do a switch side or changes sign for the amounts
3034: --
3035: IF (XLA_AE_JOURNAL_ENTRY_PKG.g_cache_ledgers_info.ledger_reversal_option = 'SIDE') THEN
3036: XLA_AE_LINES_PKG.g_rec_lines.array_natural_side_code(XLA_AE_LINES_PKG.g_LineNumber) := l_acc_rev_natural_side_code;
3037: ELSE
3038: ---------------------------------------------------------------------------------------------------
3039: -- 4262811a Switch Sign
3056:
3057: XLA_AE_LINES_PKG.ValidateCurrentLine;
3058: XLA_AE_LINES_PKG.SetDebitCreditAmounts;
3059:
3060: XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
3061: (p_hdr_idx => g_array_event(p_event_id).array_value_num('acc_rev_header_index')
3062: ,p_balance_type_code => l_balance_type_code);
3063:
3064: END IF;
3160: l_tmp_amt NUMBER;
3161: l_acc_rev_natural_side_code VARCHAR2(1);
3162:
3163: l_num_entries NUMBER;
3164: l_gl_dates xla_ae_journal_entry_pkg.t_array_date;
3165: l_accted_amts xla_ae_journal_entry_pkg.t_array_num;
3166: l_entered_amts xla_ae_journal_entry_pkg.t_array_num;
3167: l_period_names xla_ae_journal_entry_pkg.t_array_V15L;
3168: l_recog_line_1 NUMBER;
3161: l_acc_rev_natural_side_code VARCHAR2(1);
3162:
3163: l_num_entries NUMBER;
3164: l_gl_dates xla_ae_journal_entry_pkg.t_array_date;
3165: l_accted_amts xla_ae_journal_entry_pkg.t_array_num;
3166: l_entered_amts xla_ae_journal_entry_pkg.t_array_num;
3167: l_period_names xla_ae_journal_entry_pkg.t_array_V15L;
3168: l_recog_line_1 NUMBER;
3169: l_recog_line_2 NUMBER;
3162:
3163: l_num_entries NUMBER;
3164: l_gl_dates xla_ae_journal_entry_pkg.t_array_date;
3165: l_accted_amts xla_ae_journal_entry_pkg.t_array_num;
3166: l_entered_amts xla_ae_journal_entry_pkg.t_array_num;
3167: l_period_names xla_ae_journal_entry_pkg.t_array_V15L;
3168: l_recog_line_1 NUMBER;
3169: l_recog_line_2 NUMBER;
3170:
3163: l_num_entries NUMBER;
3164: l_gl_dates xla_ae_journal_entry_pkg.t_array_date;
3165: l_accted_amts xla_ae_journal_entry_pkg.t_array_num;
3166: l_entered_amts xla_ae_journal_entry_pkg.t_array_num;
3167: l_period_names xla_ae_journal_entry_pkg.t_array_V15L;
3168: l_recog_line_1 NUMBER;
3169: l_recog_line_2 NUMBER;
3170:
3171: l_bflow_applied_to_amt_idx NUMBER; -- 5132302
3169: l_recog_line_2 NUMBER;
3170:
3171: l_bflow_applied_to_amt_idx NUMBER; -- 5132302
3172: l_bflow_applied_to_amt NUMBER; -- 5132302
3173: l_bflow_applied_to_amts xla_ae_journal_entry_pkg.t_array_num; -- 5132302
3174:
3175: l_event_id NUMBER; -- To handle MPA header Description: xla_ae_header_pkg.SetHdrDescription
3176:
3177: --l_rounding_ccy VARCHAR2(15); -- To handle MPA rounding 4262811b
3244: l_accrual_line_num := NULL; -- 4262811
3245: l_tmp_amt := NULL; -- 4262811
3246: --
3247:
3248: IF XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.target_ledger_id = XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.ledger_id OR
3249: l_balance_type_code <> 'B' THEN
3250: IF NVL(
3251: xla_ae_sources_pkg.GetSystemSourceChar(
3252: p_source_code => 'XLA_EVENT_TYPE_CODE'
3328: --
3329: XLA_AE_LINES_PKG.g_rec_lines.array_balance_type_code(XLA_AE_LINES_PKG.g_LineNumber) := l_balance_type_code;
3330:
3331: XLA_AE_LINES_PKG.g_rec_lines.array_ledger_id(XLA_AE_LINES_PKG.g_LineNumber) :=
3332: XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.target_ledger_id;
3333:
3334: -- 4955764
3335: XLA_AE_LINES_PKG.g_rec_lines.array_gl_date(XLA_AE_LINES_PKG.g_LineNumber) :=
3336: XLA_AE_HEADER_PKG.g_rec_header_new.array_gl_date(g_array_event(p_event_id).array_value_num('header_index'));
3376: l_enc_upg_option := XLA_AE_LINES_PKG.g_rec_lines.array_enc_upg_option(XLA_AE_LINES_PKG.g_LineNumber);
3377:
3378: IF xla_accounting_cache_pkg.GetValueChar
3379: (p_source_code => 'LEDGER_CATEGORY_CODE'
3380: ,p_target_ledger_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.target_ledger_id) IN ('PRIMARY','ALC')
3381: AND l_bflow_method_code = 'PRIOR_ENTRY'
3382: -- AND (l_actual_upg_option = 'Y' OR l_enc_upg_option = 'Y') Bug 4922099
3383: AND ( (NVL(l_actual_upg_option, 'N') IN ('Y', 'O')) OR
3384: (NVL(l_enc_upg_option, 'N') IN ('Y', 'O'))
3449: p_lookup_type => 'XLA_OWNER_TYPE'
3450: ,p_lookup_code => l_component_type_code
3451: )
3452: ,p_token_4 => 'PRODUCT_NAME'
3453: ,p_value_4 => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.application_name
3454: ,p_entity_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.entity_id
3455: ,p_event_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.event_id
3456: ,p_ledger_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.target_ledger_id
3457: ,p_ae_header_id => NULL
3450: ,p_lookup_code => l_component_type_code
3451: )
3452: ,p_token_4 => 'PRODUCT_NAME'
3453: ,p_value_4 => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.application_name
3454: ,p_entity_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.entity_id
3455: ,p_event_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.event_id
3456: ,p_ledger_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.target_ledger_id
3457: ,p_ae_header_id => NULL
3458: );
3451: )
3452: ,p_token_4 => 'PRODUCT_NAME'
3453: ,p_value_4 => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.application_name
3454: ,p_entity_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.entity_id
3455: ,p_event_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.event_id
3456: ,p_ledger_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.target_ledger_id
3457: ,p_ae_header_id => NULL
3458: );
3459:
3452: ,p_token_4 => 'PRODUCT_NAME'
3453: ,p_value_4 => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.application_name
3454: ,p_entity_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.entity_id
3455: ,p_event_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.event_id
3456: ,p_ledger_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.target_ledger_id
3457: ,p_ae_header_id => NULL
3458: );
3459:
3460: IF (C_LEVEL_ERROR>= g_log_level) THEN
3483: ----------------------------------------------------------------------------------
3484: -- 4219869 Business Flow
3485: -- Update journal entry status -- Need to generate this within IF
3486: ----------------------------------------------------------------------------------
3487: XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
3488: (p_hdr_idx => g_array_event(p_event_id).array_value_num('header_index')
3489: ,p_balance_type_code => l_balance_type_code
3490: );
3491:
3528:
3529: --
3530: -- Depending on the Reversal Method setup, do a switch side or changes sign for the amounts
3531: --
3532: IF (XLA_AE_JOURNAL_ENTRY_PKG.g_cache_ledgers_info.ledger_reversal_option = 'SIDE') THEN
3533: XLA_AE_LINES_PKG.g_rec_lines.array_natural_side_code(XLA_AE_LINES_PKG.g_LineNumber) := l_acc_rev_natural_side_code;
3534: ELSE
3535: ---------------------------------------------------------------------------------------------------
3536: -- 4262811a Switch Sign
3553:
3554: XLA_AE_LINES_PKG.ValidateCurrentLine;
3555: XLA_AE_LINES_PKG.SetDebitCreditAmounts;
3556:
3557: XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
3558: (p_hdr_idx => g_array_event(p_event_id).array_value_num('acc_rev_header_index')
3559: ,p_balance_type_code => l_balance_type_code);
3560:
3561: END IF;
3671: l_tmp_amt NUMBER;
3672: l_acc_rev_natural_side_code VARCHAR2(1);
3673:
3674: l_num_entries NUMBER;
3675: l_gl_dates xla_ae_journal_entry_pkg.t_array_date;
3676: l_accted_amts xla_ae_journal_entry_pkg.t_array_num;
3677: l_entered_amts xla_ae_journal_entry_pkg.t_array_num;
3678: l_period_names xla_ae_journal_entry_pkg.t_array_V15L;
3679: l_recog_line_1 NUMBER;
3672: l_acc_rev_natural_side_code VARCHAR2(1);
3673:
3674: l_num_entries NUMBER;
3675: l_gl_dates xla_ae_journal_entry_pkg.t_array_date;
3676: l_accted_amts xla_ae_journal_entry_pkg.t_array_num;
3677: l_entered_amts xla_ae_journal_entry_pkg.t_array_num;
3678: l_period_names xla_ae_journal_entry_pkg.t_array_V15L;
3679: l_recog_line_1 NUMBER;
3680: l_recog_line_2 NUMBER;
3673:
3674: l_num_entries NUMBER;
3675: l_gl_dates xla_ae_journal_entry_pkg.t_array_date;
3676: l_accted_amts xla_ae_journal_entry_pkg.t_array_num;
3677: l_entered_amts xla_ae_journal_entry_pkg.t_array_num;
3678: l_period_names xla_ae_journal_entry_pkg.t_array_V15L;
3679: l_recog_line_1 NUMBER;
3680: l_recog_line_2 NUMBER;
3681:
3674: l_num_entries NUMBER;
3675: l_gl_dates xla_ae_journal_entry_pkg.t_array_date;
3676: l_accted_amts xla_ae_journal_entry_pkg.t_array_num;
3677: l_entered_amts xla_ae_journal_entry_pkg.t_array_num;
3678: l_period_names xla_ae_journal_entry_pkg.t_array_V15L;
3679: l_recog_line_1 NUMBER;
3680: l_recog_line_2 NUMBER;
3681:
3682: l_bflow_applied_to_amt_idx NUMBER; -- 5132302
3680: l_recog_line_2 NUMBER;
3681:
3682: l_bflow_applied_to_amt_idx NUMBER; -- 5132302
3683: l_bflow_applied_to_amt NUMBER; -- 5132302
3684: l_bflow_applied_to_amts xla_ae_journal_entry_pkg.t_array_num; -- 5132302
3685:
3686: l_event_id NUMBER; -- To handle MPA header Description: xla_ae_header_pkg.SetHdrDescription
3687:
3688: --l_rounding_ccy VARCHAR2(15); -- To handle MPA rounding 4262811b
3755: l_accrual_line_num := NULL; -- 4262811
3756: l_tmp_amt := NULL; -- 4262811
3757: --
3758:
3759: IF XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.target_ledger_id = XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.ledger_id OR
3760: l_balance_type_code <> 'B' THEN
3761: IF NVL(
3762: xla_ae_sources_pkg.GetSystemSourceChar(
3763: p_source_code => 'XLA_EVENT_TYPE_CODE'
3832: --
3833: XLA_AE_LINES_PKG.g_rec_lines.array_balance_type_code(XLA_AE_LINES_PKG.g_LineNumber) := l_balance_type_code;
3834:
3835: XLA_AE_LINES_PKG.g_rec_lines.array_ledger_id(XLA_AE_LINES_PKG.g_LineNumber) :=
3836: XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.target_ledger_id;
3837:
3838: -- 4955764
3839: XLA_AE_LINES_PKG.g_rec_lines.array_gl_date(XLA_AE_LINES_PKG.g_LineNumber) :=
3840: XLA_AE_HEADER_PKG.g_rec_header_new.array_gl_date(g_array_event(p_event_id).array_value_num('header_index'));
3886: l_enc_upg_option := XLA_AE_LINES_PKG.g_rec_lines.array_enc_upg_option(XLA_AE_LINES_PKG.g_LineNumber);
3887:
3888: IF xla_accounting_cache_pkg.GetValueChar
3889: (p_source_code => 'LEDGER_CATEGORY_CODE'
3890: ,p_target_ledger_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.target_ledger_id) IN ('PRIMARY','ALC')
3891: AND l_bflow_method_code = 'PRIOR_ENTRY'
3892: -- AND (l_actual_upg_option = 'Y' OR l_enc_upg_option = 'Y') Bug 4922099
3893: AND ( (NVL(l_actual_upg_option, 'N') IN ('Y', 'O')) OR
3894: (NVL(l_enc_upg_option, 'N') IN ('Y', 'O'))
4035: p_lookup_type => 'XLA_OWNER_TYPE'
4036: ,p_lookup_code => l_component_type_code
4037: )
4038: ,p_token_4 => 'PRODUCT_NAME'
4039: ,p_value_4 => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.application_name
4040: ,p_entity_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.entity_id
4041: ,p_event_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.event_id
4042: ,p_ledger_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.target_ledger_id
4043: ,p_ae_header_id => NULL
4036: ,p_lookup_code => l_component_type_code
4037: )
4038: ,p_token_4 => 'PRODUCT_NAME'
4039: ,p_value_4 => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.application_name
4040: ,p_entity_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.entity_id
4041: ,p_event_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.event_id
4042: ,p_ledger_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.target_ledger_id
4043: ,p_ae_header_id => NULL
4044: );
4037: )
4038: ,p_token_4 => 'PRODUCT_NAME'
4039: ,p_value_4 => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.application_name
4040: ,p_entity_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.entity_id
4041: ,p_event_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.event_id
4042: ,p_ledger_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.target_ledger_id
4043: ,p_ae_header_id => NULL
4044: );
4045:
4038: ,p_token_4 => 'PRODUCT_NAME'
4039: ,p_value_4 => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.application_name
4040: ,p_entity_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.entity_id
4041: ,p_event_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.event_id
4042: ,p_ledger_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.target_ledger_id
4043: ,p_ae_header_id => NULL
4044: );
4045:
4046: IF (C_LEVEL_ERROR>= g_log_level) THEN
4069: ----------------------------------------------------------------------------------
4070: -- 4219869 Business Flow
4071: -- Update journal entry status -- Need to generate this within IF
4072: ----------------------------------------------------------------------------------
4073: XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
4074: (p_hdr_idx => g_array_event(p_event_id).array_value_num('header_index')
4075: ,p_balance_type_code => l_balance_type_code
4076: );
4077:
4114:
4115: --
4116: -- Depending on the Reversal Method setup, do a switch side or changes sign for the amounts
4117: --
4118: IF (XLA_AE_JOURNAL_ENTRY_PKG.g_cache_ledgers_info.ledger_reversal_option = 'SIDE') THEN
4119: XLA_AE_LINES_PKG.g_rec_lines.array_natural_side_code(XLA_AE_LINES_PKG.g_LineNumber) := l_acc_rev_natural_side_code;
4120: ELSE
4121: ---------------------------------------------------------------------------------------------------
4122: -- 4262811a Switch Sign
4139:
4140: XLA_AE_LINES_PKG.ValidateCurrentLine;
4141: XLA_AE_LINES_PKG.SetDebitCreditAmounts;
4142:
4143: XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
4144: (p_hdr_idx => g_array_event(p_event_id).array_value_num('acc_rev_header_index')
4145: ,p_balance_type_code => l_balance_type_code);
4146:
4147: END IF;
4243: l_tmp_amt NUMBER;
4244: l_acc_rev_natural_side_code VARCHAR2(1);
4245:
4246: l_num_entries NUMBER;
4247: l_gl_dates xla_ae_journal_entry_pkg.t_array_date;
4248: l_accted_amts xla_ae_journal_entry_pkg.t_array_num;
4249: l_entered_amts xla_ae_journal_entry_pkg.t_array_num;
4250: l_period_names xla_ae_journal_entry_pkg.t_array_V15L;
4251: l_recog_line_1 NUMBER;
4244: l_acc_rev_natural_side_code VARCHAR2(1);
4245:
4246: l_num_entries NUMBER;
4247: l_gl_dates xla_ae_journal_entry_pkg.t_array_date;
4248: l_accted_amts xla_ae_journal_entry_pkg.t_array_num;
4249: l_entered_amts xla_ae_journal_entry_pkg.t_array_num;
4250: l_period_names xla_ae_journal_entry_pkg.t_array_V15L;
4251: l_recog_line_1 NUMBER;
4252: l_recog_line_2 NUMBER;
4245:
4246: l_num_entries NUMBER;
4247: l_gl_dates xla_ae_journal_entry_pkg.t_array_date;
4248: l_accted_amts xla_ae_journal_entry_pkg.t_array_num;
4249: l_entered_amts xla_ae_journal_entry_pkg.t_array_num;
4250: l_period_names xla_ae_journal_entry_pkg.t_array_V15L;
4251: l_recog_line_1 NUMBER;
4252: l_recog_line_2 NUMBER;
4253:
4246: l_num_entries NUMBER;
4247: l_gl_dates xla_ae_journal_entry_pkg.t_array_date;
4248: l_accted_amts xla_ae_journal_entry_pkg.t_array_num;
4249: l_entered_amts xla_ae_journal_entry_pkg.t_array_num;
4250: l_period_names xla_ae_journal_entry_pkg.t_array_V15L;
4251: l_recog_line_1 NUMBER;
4252: l_recog_line_2 NUMBER;
4253:
4254: l_bflow_applied_to_amt_idx NUMBER; -- 5132302
4252: l_recog_line_2 NUMBER;
4253:
4254: l_bflow_applied_to_amt_idx NUMBER; -- 5132302
4255: l_bflow_applied_to_amt NUMBER; -- 5132302
4256: l_bflow_applied_to_amts xla_ae_journal_entry_pkg.t_array_num; -- 5132302
4257:
4258: l_event_id NUMBER; -- To handle MPA header Description: xla_ae_header_pkg.SetHdrDescription
4259:
4260: --l_rounding_ccy VARCHAR2(15); -- To handle MPA rounding 4262811b
4327: l_accrual_line_num := NULL; -- 4262811
4328: l_tmp_amt := NULL; -- 4262811
4329: --
4330:
4331: IF XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.target_ledger_id = XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.ledger_id OR
4332: l_balance_type_code <> 'B' THEN
4333: IF NVL(
4334: xla_ae_sources_pkg.GetSystemSourceChar(
4335: p_source_code => 'XLA_EVENT_TYPE_CODE'
4411: --
4412: XLA_AE_LINES_PKG.g_rec_lines.array_balance_type_code(XLA_AE_LINES_PKG.g_LineNumber) := l_balance_type_code;
4413:
4414: XLA_AE_LINES_PKG.g_rec_lines.array_ledger_id(XLA_AE_LINES_PKG.g_LineNumber) :=
4415: XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.target_ledger_id;
4416:
4417: -- 4955764
4418: XLA_AE_LINES_PKG.g_rec_lines.array_gl_date(XLA_AE_LINES_PKG.g_LineNumber) :=
4419: XLA_AE_HEADER_PKG.g_rec_header_new.array_gl_date(g_array_event(p_event_id).array_value_num('header_index'));
4459: l_enc_upg_option := XLA_AE_LINES_PKG.g_rec_lines.array_enc_upg_option(XLA_AE_LINES_PKG.g_LineNumber);
4460:
4461: IF xla_accounting_cache_pkg.GetValueChar
4462: (p_source_code => 'LEDGER_CATEGORY_CODE'
4463: ,p_target_ledger_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.target_ledger_id) IN ('PRIMARY','ALC')
4464: AND l_bflow_method_code = 'PRIOR_ENTRY'
4465: -- AND (l_actual_upg_option = 'Y' OR l_enc_upg_option = 'Y') Bug 4922099
4466: AND ( (NVL(l_actual_upg_option, 'N') IN ('Y', 'O')) OR
4467: (NVL(l_enc_upg_option, 'N') IN ('Y', 'O'))
4532: p_lookup_type => 'XLA_OWNER_TYPE'
4533: ,p_lookup_code => l_component_type_code
4534: )
4535: ,p_token_4 => 'PRODUCT_NAME'
4536: ,p_value_4 => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.application_name
4537: ,p_entity_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.entity_id
4538: ,p_event_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.event_id
4539: ,p_ledger_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.target_ledger_id
4540: ,p_ae_header_id => NULL
4533: ,p_lookup_code => l_component_type_code
4534: )
4535: ,p_token_4 => 'PRODUCT_NAME'
4536: ,p_value_4 => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.application_name
4537: ,p_entity_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.entity_id
4538: ,p_event_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.event_id
4539: ,p_ledger_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.target_ledger_id
4540: ,p_ae_header_id => NULL
4541: );
4534: )
4535: ,p_token_4 => 'PRODUCT_NAME'
4536: ,p_value_4 => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.application_name
4537: ,p_entity_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.entity_id
4538: ,p_event_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.event_id
4539: ,p_ledger_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.target_ledger_id
4540: ,p_ae_header_id => NULL
4541: );
4542:
4535: ,p_token_4 => 'PRODUCT_NAME'
4536: ,p_value_4 => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.application_name
4537: ,p_entity_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.entity_id
4538: ,p_event_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.event_id
4539: ,p_ledger_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.target_ledger_id
4540: ,p_ae_header_id => NULL
4541: );
4542:
4543: IF (C_LEVEL_ERROR>= g_log_level) THEN
4566: ----------------------------------------------------------------------------------
4567: -- 4219869 Business Flow
4568: -- Update journal entry status -- Need to generate this within IF
4569: ----------------------------------------------------------------------------------
4570: XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
4571: (p_hdr_idx => g_array_event(p_event_id).array_value_num('header_index')
4572: ,p_balance_type_code => l_balance_type_code
4573: );
4574:
4611:
4612: --
4613: -- Depending on the Reversal Method setup, do a switch side or changes sign for the amounts
4614: --
4615: IF (XLA_AE_JOURNAL_ENTRY_PKG.g_cache_ledgers_info.ledger_reversal_option = 'SIDE') THEN
4616: XLA_AE_LINES_PKG.g_rec_lines.array_natural_side_code(XLA_AE_LINES_PKG.g_LineNumber) := l_acc_rev_natural_side_code;
4617: ELSE
4618: ---------------------------------------------------------------------------------------------------
4619: -- 4262811a Switch Sign
4636:
4637: XLA_AE_LINES_PKG.ValidateCurrentLine;
4638: XLA_AE_LINES_PKG.SetDebitCreditAmounts;
4639:
4640: XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
4641: (p_hdr_idx => g_array_event(p_event_id).array_value_num('acc_rev_header_index')
4642: ,p_balance_type_code => l_balance_type_code);
4643:
4644: END IF;
4754: l_tmp_amt NUMBER;
4755: l_acc_rev_natural_side_code VARCHAR2(1);
4756:
4757: l_num_entries NUMBER;
4758: l_gl_dates xla_ae_journal_entry_pkg.t_array_date;
4759: l_accted_amts xla_ae_journal_entry_pkg.t_array_num;
4760: l_entered_amts xla_ae_journal_entry_pkg.t_array_num;
4761: l_period_names xla_ae_journal_entry_pkg.t_array_V15L;
4762: l_recog_line_1 NUMBER;
4755: l_acc_rev_natural_side_code VARCHAR2(1);
4756:
4757: l_num_entries NUMBER;
4758: l_gl_dates xla_ae_journal_entry_pkg.t_array_date;
4759: l_accted_amts xla_ae_journal_entry_pkg.t_array_num;
4760: l_entered_amts xla_ae_journal_entry_pkg.t_array_num;
4761: l_period_names xla_ae_journal_entry_pkg.t_array_V15L;
4762: l_recog_line_1 NUMBER;
4763: l_recog_line_2 NUMBER;
4756:
4757: l_num_entries NUMBER;
4758: l_gl_dates xla_ae_journal_entry_pkg.t_array_date;
4759: l_accted_amts xla_ae_journal_entry_pkg.t_array_num;
4760: l_entered_amts xla_ae_journal_entry_pkg.t_array_num;
4761: l_period_names xla_ae_journal_entry_pkg.t_array_V15L;
4762: l_recog_line_1 NUMBER;
4763: l_recog_line_2 NUMBER;
4764:
4757: l_num_entries NUMBER;
4758: l_gl_dates xla_ae_journal_entry_pkg.t_array_date;
4759: l_accted_amts xla_ae_journal_entry_pkg.t_array_num;
4760: l_entered_amts xla_ae_journal_entry_pkg.t_array_num;
4761: l_period_names xla_ae_journal_entry_pkg.t_array_V15L;
4762: l_recog_line_1 NUMBER;
4763: l_recog_line_2 NUMBER;
4764:
4765: l_bflow_applied_to_amt_idx NUMBER; -- 5132302
4763: l_recog_line_2 NUMBER;
4764:
4765: l_bflow_applied_to_amt_idx NUMBER; -- 5132302
4766: l_bflow_applied_to_amt NUMBER; -- 5132302
4767: l_bflow_applied_to_amts xla_ae_journal_entry_pkg.t_array_num; -- 5132302
4768:
4769: l_event_id NUMBER; -- To handle MPA header Description: xla_ae_header_pkg.SetHdrDescription
4770:
4771: --l_rounding_ccy VARCHAR2(15); -- To handle MPA rounding 4262811b
4838: l_accrual_line_num := NULL; -- 4262811
4839: l_tmp_amt := NULL; -- 4262811
4840: --
4841:
4842: IF XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.target_ledger_id = XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.ledger_id OR
4843: l_balance_type_code <> 'B' THEN
4844: IF NVL(
4845: xla_ae_sources_pkg.GetSystemSourceChar(
4846: p_source_code => 'XLA_EVENT_TYPE_CODE'
4915: --
4916: XLA_AE_LINES_PKG.g_rec_lines.array_balance_type_code(XLA_AE_LINES_PKG.g_LineNumber) := l_balance_type_code;
4917:
4918: XLA_AE_LINES_PKG.g_rec_lines.array_ledger_id(XLA_AE_LINES_PKG.g_LineNumber) :=
4919: XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.target_ledger_id;
4920:
4921: -- 4955764
4922: XLA_AE_LINES_PKG.g_rec_lines.array_gl_date(XLA_AE_LINES_PKG.g_LineNumber) :=
4923: XLA_AE_HEADER_PKG.g_rec_header_new.array_gl_date(g_array_event(p_event_id).array_value_num('header_index'));
4969: l_enc_upg_option := XLA_AE_LINES_PKG.g_rec_lines.array_enc_upg_option(XLA_AE_LINES_PKG.g_LineNumber);
4970:
4971: IF xla_accounting_cache_pkg.GetValueChar
4972: (p_source_code => 'LEDGER_CATEGORY_CODE'
4973: ,p_target_ledger_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.target_ledger_id) IN ('PRIMARY','ALC')
4974: AND l_bflow_method_code = 'PRIOR_ENTRY'
4975: -- AND (l_actual_upg_option = 'Y' OR l_enc_upg_option = 'Y') Bug 4922099
4976: AND ( (NVL(l_actual_upg_option, 'N') IN ('Y', 'O')) OR
4977: (NVL(l_enc_upg_option, 'N') IN ('Y', 'O'))
5118: p_lookup_type => 'XLA_OWNER_TYPE'
5119: ,p_lookup_code => l_component_type_code
5120: )
5121: ,p_token_4 => 'PRODUCT_NAME'
5122: ,p_value_4 => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.application_name
5123: ,p_entity_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.entity_id
5124: ,p_event_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.event_id
5125: ,p_ledger_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.target_ledger_id
5126: ,p_ae_header_id => NULL
5119: ,p_lookup_code => l_component_type_code
5120: )
5121: ,p_token_4 => 'PRODUCT_NAME'
5122: ,p_value_4 => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.application_name
5123: ,p_entity_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.entity_id
5124: ,p_event_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.event_id
5125: ,p_ledger_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.target_ledger_id
5126: ,p_ae_header_id => NULL
5127: );
5120: )
5121: ,p_token_4 => 'PRODUCT_NAME'
5122: ,p_value_4 => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.application_name
5123: ,p_entity_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.entity_id
5124: ,p_event_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.event_id
5125: ,p_ledger_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.target_ledger_id
5126: ,p_ae_header_id => NULL
5127: );
5128:
5121: ,p_token_4 => 'PRODUCT_NAME'
5122: ,p_value_4 => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.application_name
5123: ,p_entity_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.entity_id
5124: ,p_event_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.event_id
5125: ,p_ledger_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.target_ledger_id
5126: ,p_ae_header_id => NULL
5127: );
5128:
5129: IF (C_LEVEL_ERROR>= g_log_level) THEN
5152: ----------------------------------------------------------------------------------
5153: -- 4219869 Business Flow
5154: -- Update journal entry status -- Need to generate this within IF
5155: ----------------------------------------------------------------------------------
5156: XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
5157: (p_hdr_idx => g_array_event(p_event_id).array_value_num('header_index')
5158: ,p_balance_type_code => l_balance_type_code
5159: );
5160:
5197:
5198: --
5199: -- Depending on the Reversal Method setup, do a switch side or changes sign for the amounts
5200: --
5201: IF (XLA_AE_JOURNAL_ENTRY_PKG.g_cache_ledgers_info.ledger_reversal_option = 'SIDE') THEN
5202: XLA_AE_LINES_PKG.g_rec_lines.array_natural_side_code(XLA_AE_LINES_PKG.g_LineNumber) := l_acc_rev_natural_side_code;
5203: ELSE
5204: ---------------------------------------------------------------------------------------------------
5205: -- 4262811a Switch Sign
5222:
5223: XLA_AE_LINES_PKG.ValidateCurrentLine;
5224: XLA_AE_LINES_PKG.SetDebitCreditAmounts;
5225:
5226: XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
5227: (p_hdr_idx => g_array_event(p_event_id).array_value_num('acc_rev_header_index')
5228: ,p_balance_type_code => l_balance_type_code);
5229:
5230: END IF;
5326: l_tmp_amt NUMBER;
5327: l_acc_rev_natural_side_code VARCHAR2(1);
5328:
5329: l_num_entries NUMBER;
5330: l_gl_dates xla_ae_journal_entry_pkg.t_array_date;
5331: l_accted_amts xla_ae_journal_entry_pkg.t_array_num;
5332: l_entered_amts xla_ae_journal_entry_pkg.t_array_num;
5333: l_period_names xla_ae_journal_entry_pkg.t_array_V15L;
5334: l_recog_line_1 NUMBER;
5327: l_acc_rev_natural_side_code VARCHAR2(1);
5328:
5329: l_num_entries NUMBER;
5330: l_gl_dates xla_ae_journal_entry_pkg.t_array_date;
5331: l_accted_amts xla_ae_journal_entry_pkg.t_array_num;
5332: l_entered_amts xla_ae_journal_entry_pkg.t_array_num;
5333: l_period_names xla_ae_journal_entry_pkg.t_array_V15L;
5334: l_recog_line_1 NUMBER;
5335: l_recog_line_2 NUMBER;
5328:
5329: l_num_entries NUMBER;
5330: l_gl_dates xla_ae_journal_entry_pkg.t_array_date;
5331: l_accted_amts xla_ae_journal_entry_pkg.t_array_num;
5332: l_entered_amts xla_ae_journal_entry_pkg.t_array_num;
5333: l_period_names xla_ae_journal_entry_pkg.t_array_V15L;
5334: l_recog_line_1 NUMBER;
5335: l_recog_line_2 NUMBER;
5336:
5329: l_num_entries NUMBER;
5330: l_gl_dates xla_ae_journal_entry_pkg.t_array_date;
5331: l_accted_amts xla_ae_journal_entry_pkg.t_array_num;
5332: l_entered_amts xla_ae_journal_entry_pkg.t_array_num;
5333: l_period_names xla_ae_journal_entry_pkg.t_array_V15L;
5334: l_recog_line_1 NUMBER;
5335: l_recog_line_2 NUMBER;
5336:
5337: l_bflow_applied_to_amt_idx NUMBER; -- 5132302
5335: l_recog_line_2 NUMBER;
5336:
5337: l_bflow_applied_to_amt_idx NUMBER; -- 5132302
5338: l_bflow_applied_to_amt NUMBER; -- 5132302
5339: l_bflow_applied_to_amts xla_ae_journal_entry_pkg.t_array_num; -- 5132302
5340:
5341: l_event_id NUMBER; -- To handle MPA header Description: xla_ae_header_pkg.SetHdrDescription
5342:
5343: --l_rounding_ccy VARCHAR2(15); -- To handle MPA rounding 4262811b
5410: l_accrual_line_num := NULL; -- 4262811
5411: l_tmp_amt := NULL; -- 4262811
5412: --
5413:
5414: IF XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.target_ledger_id = XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.ledger_id OR
5415: l_balance_type_code <> 'B' THEN
5416: IF NVL(
5417: xla_ae_sources_pkg.GetSystemSourceChar(
5418: p_source_code => 'XLA_EVENT_TYPE_CODE'
5494: --
5495: XLA_AE_LINES_PKG.g_rec_lines.array_balance_type_code(XLA_AE_LINES_PKG.g_LineNumber) := l_balance_type_code;
5496:
5497: XLA_AE_LINES_PKG.g_rec_lines.array_ledger_id(XLA_AE_LINES_PKG.g_LineNumber) :=
5498: XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.target_ledger_id;
5499:
5500: -- 4955764
5501: XLA_AE_LINES_PKG.g_rec_lines.array_gl_date(XLA_AE_LINES_PKG.g_LineNumber) :=
5502: XLA_AE_HEADER_PKG.g_rec_header_new.array_gl_date(g_array_event(p_event_id).array_value_num('header_index'));
5542: l_enc_upg_option := XLA_AE_LINES_PKG.g_rec_lines.array_enc_upg_option(XLA_AE_LINES_PKG.g_LineNumber);
5543:
5544: IF xla_accounting_cache_pkg.GetValueChar
5545: (p_source_code => 'LEDGER_CATEGORY_CODE'
5546: ,p_target_ledger_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.target_ledger_id) IN ('PRIMARY','ALC')
5547: AND l_bflow_method_code = 'PRIOR_ENTRY'
5548: -- AND (l_actual_upg_option = 'Y' OR l_enc_upg_option = 'Y') Bug 4922099
5549: AND ( (NVL(l_actual_upg_option, 'N') IN ('Y', 'O')) OR
5550: (NVL(l_enc_upg_option, 'N') IN ('Y', 'O'))
5615: p_lookup_type => 'XLA_OWNER_TYPE'
5616: ,p_lookup_code => l_component_type_code
5617: )
5618: ,p_token_4 => 'PRODUCT_NAME'
5619: ,p_value_4 => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.application_name
5620: ,p_entity_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.entity_id
5621: ,p_event_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.event_id
5622: ,p_ledger_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.target_ledger_id
5623: ,p_ae_header_id => NULL
5616: ,p_lookup_code => l_component_type_code
5617: )
5618: ,p_token_4 => 'PRODUCT_NAME'
5619: ,p_value_4 => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.application_name
5620: ,p_entity_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.entity_id
5621: ,p_event_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.event_id
5622: ,p_ledger_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.target_ledger_id
5623: ,p_ae_header_id => NULL
5624: );
5617: )
5618: ,p_token_4 => 'PRODUCT_NAME'
5619: ,p_value_4 => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.application_name
5620: ,p_entity_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.entity_id
5621: ,p_event_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.event_id
5622: ,p_ledger_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.target_ledger_id
5623: ,p_ae_header_id => NULL
5624: );
5625:
5618: ,p_token_4 => 'PRODUCT_NAME'
5619: ,p_value_4 => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.application_name
5620: ,p_entity_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.entity_id
5621: ,p_event_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.event_id
5622: ,p_ledger_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.target_ledger_id
5623: ,p_ae_header_id => NULL
5624: );
5625:
5626: IF (C_LEVEL_ERROR>= g_log_level) THEN
5649: ----------------------------------------------------------------------------------
5650: -- 4219869 Business Flow
5651: -- Update journal entry status -- Need to generate this within IF
5652: ----------------------------------------------------------------------------------
5653: XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
5654: (p_hdr_idx => g_array_event(p_event_id).array_value_num('header_index')
5655: ,p_balance_type_code => l_balance_type_code
5656: );
5657:
5694:
5695: --
5696: -- Depending on the Reversal Method setup, do a switch side or changes sign for the amounts
5697: --
5698: IF (XLA_AE_JOURNAL_ENTRY_PKG.g_cache_ledgers_info.ledger_reversal_option = 'SIDE') THEN
5699: XLA_AE_LINES_PKG.g_rec_lines.array_natural_side_code(XLA_AE_LINES_PKG.g_LineNumber) := l_acc_rev_natural_side_code;
5700: ELSE
5701: ---------------------------------------------------------------------------------------------------
5702: -- 4262811a Switch Sign
5719:
5720: XLA_AE_LINES_PKG.ValidateCurrentLine;
5721: XLA_AE_LINES_PKG.SetDebitCreditAmounts;
5722:
5723: XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
5724: (p_hdr_idx => g_array_event(p_event_id).array_value_num('acc_rev_header_index')
5725: ,p_balance_type_code => l_balance_type_code);
5726:
5727: END IF;
5957:
5958: l_calculate_acctd_flag VARCHAR2(1) :='N';
5959: l_calculate_g_l_flag VARCHAR2(1) :='N';
5960: --
5961: l_array_legal_entity_id XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
5962: l_array_entity_id XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
5963: l_array_entity_code XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L;
5964: l_array_transaction_num XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
5965: l_array_event_id XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
5958: l_calculate_acctd_flag VARCHAR2(1) :='N';
5959: l_calculate_g_l_flag VARCHAR2(1) :='N';
5960: --
5961: l_array_legal_entity_id XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
5962: l_array_entity_id XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
5963: l_array_entity_code XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L;
5964: l_array_transaction_num XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
5965: l_array_event_id XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
5966: l_array_class_code XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L;
5959: l_calculate_g_l_flag VARCHAR2(1) :='N';
5960: --
5961: l_array_legal_entity_id XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
5962: l_array_entity_id XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
5963: l_array_entity_code XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L;
5964: l_array_transaction_num XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
5965: l_array_event_id XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
5966: l_array_class_code XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L;
5967: l_array_event_type XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L;
5960: --
5961: l_array_legal_entity_id XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
5962: l_array_entity_id XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
5963: l_array_entity_code XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L;
5964: l_array_transaction_num XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
5965: l_array_event_id XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
5966: l_array_class_code XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L;
5967: l_array_event_type XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L;
5968: l_array_event_number XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
5961: l_array_legal_entity_id XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
5962: l_array_entity_id XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
5963: l_array_entity_code XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L;
5964: l_array_transaction_num XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
5965: l_array_event_id XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
5966: l_array_class_code XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L;
5967: l_array_event_type XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L;
5968: l_array_event_number XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
5969: l_array_event_date XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
5962: l_array_entity_id XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
5963: l_array_entity_code XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L;
5964: l_array_transaction_num XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
5965: l_array_event_id XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
5966: l_array_class_code XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L;
5967: l_array_event_type XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L;
5968: l_array_event_number XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
5969: l_array_event_date XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
5970: l_array_transaction_date XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
5963: l_array_entity_code XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L;
5964: l_array_transaction_num XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
5965: l_array_event_id XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
5966: l_array_class_code XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L;
5967: l_array_event_type XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L;
5968: l_array_event_number XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
5969: l_array_event_date XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
5970: l_array_transaction_date XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
5971: l_array_reference_num_1 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
5964: l_array_transaction_num XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
5965: l_array_event_id XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
5966: l_array_class_code XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L;
5967: l_array_event_type XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L;
5968: l_array_event_number XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
5969: l_array_event_date XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
5970: l_array_transaction_date XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
5971: l_array_reference_num_1 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
5972: l_array_reference_num_2 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
5965: l_array_event_id XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
5966: l_array_class_code XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L;
5967: l_array_event_type XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L;
5968: l_array_event_number XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
5969: l_array_event_date XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
5970: l_array_transaction_date XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
5971: l_array_reference_num_1 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
5972: l_array_reference_num_2 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
5973: l_array_reference_num_3 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
5966: l_array_class_code XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L;
5967: l_array_event_type XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L;
5968: l_array_event_number XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
5969: l_array_event_date XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
5970: l_array_transaction_date XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
5971: l_array_reference_num_1 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
5972: l_array_reference_num_2 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
5973: l_array_reference_num_3 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
5974: l_array_reference_num_4 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
5967: l_array_event_type XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L;
5968: l_array_event_number XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
5969: l_array_event_date XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
5970: l_array_transaction_date XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
5971: l_array_reference_num_1 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
5972: l_array_reference_num_2 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
5973: l_array_reference_num_3 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
5974: l_array_reference_num_4 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
5975: l_array_reference_char_1 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
5968: l_array_event_number XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
5969: l_array_event_date XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
5970: l_array_transaction_date XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
5971: l_array_reference_num_1 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
5972: l_array_reference_num_2 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
5973: l_array_reference_num_3 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
5974: l_array_reference_num_4 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
5975: l_array_reference_char_1 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
5976: l_array_reference_char_2 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
5969: l_array_event_date XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
5970: l_array_transaction_date XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
5971: l_array_reference_num_1 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
5972: l_array_reference_num_2 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
5973: l_array_reference_num_3 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
5974: l_array_reference_num_4 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
5975: l_array_reference_char_1 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
5976: l_array_reference_char_2 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
5977: l_array_reference_char_3 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
5970: l_array_transaction_date XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
5971: l_array_reference_num_1 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
5972: l_array_reference_num_2 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
5973: l_array_reference_num_3 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
5974: l_array_reference_num_4 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
5975: l_array_reference_char_1 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
5976: l_array_reference_char_2 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
5977: l_array_reference_char_3 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
5978: l_array_reference_char_4 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
5971: l_array_reference_num_1 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
5972: l_array_reference_num_2 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
5973: l_array_reference_num_3 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
5974: l_array_reference_num_4 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
5975: l_array_reference_char_1 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
5976: l_array_reference_char_2 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
5977: l_array_reference_char_3 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
5978: l_array_reference_char_4 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
5979: l_array_reference_date_1 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
5972: l_array_reference_num_2 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
5973: l_array_reference_num_3 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
5974: l_array_reference_num_4 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
5975: l_array_reference_char_1 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
5976: l_array_reference_char_2 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
5977: l_array_reference_char_3 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
5978: l_array_reference_char_4 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
5979: l_array_reference_date_1 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
5980: l_array_reference_date_2 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
5973: l_array_reference_num_3 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
5974: l_array_reference_num_4 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
5975: l_array_reference_char_1 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
5976: l_array_reference_char_2 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
5977: l_array_reference_char_3 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
5978: l_array_reference_char_4 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
5979: l_array_reference_date_1 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
5980: l_array_reference_date_2 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
5981: l_array_reference_date_3 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
5974: l_array_reference_num_4 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
5975: l_array_reference_char_1 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
5976: l_array_reference_char_2 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
5977: l_array_reference_char_3 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
5978: l_array_reference_char_4 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
5979: l_array_reference_date_1 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
5980: l_array_reference_date_2 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
5981: l_array_reference_date_3 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
5982: l_array_reference_date_4 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
5975: l_array_reference_char_1 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
5976: l_array_reference_char_2 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
5977: l_array_reference_char_3 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
5978: l_array_reference_char_4 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
5979: l_array_reference_date_1 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
5980: l_array_reference_date_2 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
5981: l_array_reference_date_3 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
5982: l_array_reference_date_4 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
5983: l_array_event_created_by XLA_AE_JOURNAL_ENTRY_PKG.t_array_V100L;
5976: l_array_reference_char_2 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
5977: l_array_reference_char_3 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
5978: l_array_reference_char_4 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
5979: l_array_reference_date_1 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
5980: l_array_reference_date_2 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
5981: l_array_reference_date_3 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
5982: l_array_reference_date_4 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
5983: l_array_event_created_by XLA_AE_JOURNAL_ENTRY_PKG.t_array_V100L;
5984: l_array_budgetary_control_flag XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L;
5977: l_array_reference_char_3 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
5978: l_array_reference_char_4 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
5979: l_array_reference_date_1 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
5980: l_array_reference_date_2 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
5981: l_array_reference_date_3 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
5982: l_array_reference_date_4 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
5983: l_array_event_created_by XLA_AE_JOURNAL_ENTRY_PKG.t_array_V100L;
5984: l_array_budgetary_control_flag XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L;
5985:
5978: l_array_reference_char_4 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
5979: l_array_reference_date_1 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
5980: l_array_reference_date_2 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
5981: l_array_reference_date_3 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
5982: l_array_reference_date_4 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
5983: l_array_event_created_by XLA_AE_JOURNAL_ENTRY_PKG.t_array_V100L;
5984: l_array_budgetary_control_flag XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L;
5985:
5986: l_event_id NUMBER;
5979: l_array_reference_date_1 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
5980: l_array_reference_date_2 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
5981: l_array_reference_date_3 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
5982: l_array_reference_date_4 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
5983: l_array_event_created_by XLA_AE_JOURNAL_ENTRY_PKG.t_array_V100L;
5984: l_array_budgetary_control_flag XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L;
5985:
5986: l_event_id NUMBER;
5987: l_previous_event_id NUMBER;
5980: l_array_reference_date_2 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
5981: l_array_reference_date_3 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
5982: l_array_reference_date_4 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
5983: l_array_event_created_by XLA_AE_JOURNAL_ENTRY_PKG.t_array_V100L;
5984: l_array_budgetary_control_flag XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L;
5985:
5986: l_event_id NUMBER;
5987: l_previous_event_id NUMBER;
5988: l_first_event_id NUMBER;
5998: l_event_class_name VARCHAR2(80) := 'Budget Execution Transactions';
5999: l_description VARCHAR2(4000);
6000: l_transaction_reversal NUMBER;
6001: l_ae_header_id NUMBER;
6002: l_array_extract_line_num xla_ae_journal_entry_pkg.t_array_Num;
6003: l_log_module VARCHAR2(240);
6004: --
6005: l_acct_reversal_source VARCHAR2(30);
6006: l_trx_reversal_source VARCHAR2(30);
6209:
6210: --
6211: -- set event info as cache for other routines to refer event attributes
6212: --
6213: XLA_AE_JOURNAL_ENTRY_PKG.set_event_info
6214: (p_application_id => p_application_id
6215: ,p_primary_ledger_id => p_primary_ledger_id
6216: ,p_base_ledger_id => p_base_ledger_id
6217: ,p_target_ledger_id => p_target_ledger_id
6242:
6243: --
6244: -- set the status of entry to C_VALID (0)
6245: --
6246: XLA_AE_JOURNAL_ENTRY_PKG.g_global_status := XLA_AE_JOURNAL_ENTRY_PKG.C_VALID;
6247:
6248: --
6249: -- initialize a row for ae header
6250: --
6267: --
6268: -- initilaize the status of ae headers for diffrent balance types
6269: -- the status is initialised to C_NOT_CREATED (2)
6270: --
6271: --g_array_event(l_event_id).array_value_num('actual_je_status') := XLA_AE_JOURNAL_ENTRY_PKG.C_NOT_CREATED;
6272: --g_array_event(l_event_id).array_value_num('budget_je_status') := XLA_AE_JOURNAL_ENTRY_PKG.C_NOT_CREATED;
6273: --g_array_event(l_event_id).array_value_num('encumbrance_je_status') := XLA_AE_JOURNAL_ENTRY_PKG.C_NOT_CREATED;
6274:
6275: --
6268: -- initilaize the status of ae headers for diffrent balance types
6269: -- the status is initialised to C_NOT_CREATED (2)
6270: --
6271: --g_array_event(l_event_id).array_value_num('actual_je_status') := XLA_AE_JOURNAL_ENTRY_PKG.C_NOT_CREATED;
6272: --g_array_event(l_event_id).array_value_num('budget_je_status') := XLA_AE_JOURNAL_ENTRY_PKG.C_NOT_CREATED;
6273: --g_array_event(l_event_id).array_value_num('encumbrance_je_status') := XLA_AE_JOURNAL_ENTRY_PKG.C_NOT_CREATED;
6274:
6275: --
6276: -- call api to validate and store accounting attributes for header
6269: -- the status is initialised to C_NOT_CREATED (2)
6270: --
6271: --g_array_event(l_event_id).array_value_num('actual_je_status') := XLA_AE_JOURNAL_ENTRY_PKG.C_NOT_CREATED;
6272: --g_array_event(l_event_id).array_value_num('budget_je_status') := XLA_AE_JOURNAL_ENTRY_PKG.C_NOT_CREATED;
6273: --g_array_event(l_event_id).array_value_num('encumbrance_je_status') := XLA_AE_JOURNAL_ENTRY_PKG.C_NOT_CREATED;
6274:
6275: --
6276: -- call api to validate and store accounting attributes for header
6277: --
6303: --
6304: l_trx_reversal_source := SUBSTR(NULL, 1,30);
6305:
6306: IF NVL(l_trx_reversal_source, 'N') NOT IN ('N','Y') THEN
6307: xla_ae_journal_entry_pkg.g_global_status := xla_ae_journal_entry_pkg.C_INVALID;
6308:
6309: xla_accounting_err_pkg.build_message
6310: (p_appli_s_name => 'XLA'
6311: ,p_msg_name => 'XLA_AP_INVALID_HDR_ATTR'
6311: ,p_msg_name => 'XLA_AP_INVALID_HDR_ATTR'
6312: ,p_token_1 => 'ACCT_ATTR_NAME'
6313: ,p_value_1 => xla_ae_sources_pkg.GetAccountingSourceName('TRX_ACCT_REVERSAL_OPTION')
6314: ,p_token_2 => 'PRODUCT_NAME'
6315: ,p_value_2 => xla_ae_journal_entry_pkg.g_cache_event.application_name
6316: ,p_entity_id => xla_ae_journal_entry_pkg.g_cache_event.entity_id
6317: ,p_event_id => xla_ae_journal_entry_pkg.g_cache_event.event_id
6318: ,p_ledger_id => xla_ae_journal_entry_pkg.g_cache_event.target_ledger_id);
6319:
6312: ,p_token_1 => 'ACCT_ATTR_NAME'
6313: ,p_value_1 => xla_ae_sources_pkg.GetAccountingSourceName('TRX_ACCT_REVERSAL_OPTION')
6314: ,p_token_2 => 'PRODUCT_NAME'
6315: ,p_value_2 => xla_ae_journal_entry_pkg.g_cache_event.application_name
6316: ,p_entity_id => xla_ae_journal_entry_pkg.g_cache_event.entity_id
6317: ,p_event_id => xla_ae_journal_entry_pkg.g_cache_event.event_id
6318: ,p_ledger_id => xla_ae_journal_entry_pkg.g_cache_event.target_ledger_id);
6319:
6320: ELSIF NVL(l_trx_reversal_source, 'N') = 'Y' THEN
6313: ,p_value_1 => xla_ae_sources_pkg.GetAccountingSourceName('TRX_ACCT_REVERSAL_OPTION')
6314: ,p_token_2 => 'PRODUCT_NAME'
6315: ,p_value_2 => xla_ae_journal_entry_pkg.g_cache_event.application_name
6316: ,p_entity_id => xla_ae_journal_entry_pkg.g_cache_event.entity_id
6317: ,p_event_id => xla_ae_journal_entry_pkg.g_cache_event.event_id
6318: ,p_ledger_id => xla_ae_journal_entry_pkg.g_cache_event.target_ledger_id);
6319:
6320: ELSIF NVL(l_trx_reversal_source, 'N') = 'Y' THEN
6321: --
6314: ,p_token_2 => 'PRODUCT_NAME'
6315: ,p_value_2 => xla_ae_journal_entry_pkg.g_cache_event.application_name
6316: ,p_entity_id => xla_ae_journal_entry_pkg.g_cache_event.entity_id
6317: ,p_event_id => xla_ae_journal_entry_pkg.g_cache_event.event_id
6318: ,p_ledger_id => xla_ae_journal_entry_pkg.g_cache_event.target_ledger_id);
6319:
6320: ELSIF NVL(l_trx_reversal_source, 'N') = 'Y' THEN
6321: --
6322: -- following sets the accounting attributes needed to reverse
6333: ----------------------------------------------------------------
6334: -- 4262811 - update the header statuses to invalid in need be
6335: ----------------------------------------------------------------
6336: --
6337: XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus (p_hdr_idx => hdr_idx);
6338:
6339:
6340: -----------------------------------------------
6341: -- No accrual reversal for the event class/type
6452: ,p_module => l_log_module);
6453: END IF;
6454:
6455: --
6456: -- set the XLA_AE_JOURNAL_ENTRY_PKG.g_global_status to C_VALID (0)
6457: --
6458: XLA_AE_JOURNAL_ENTRY_PKG.g_global_status := XLA_AE_JOURNAL_ENTRY_PKG.C_VALID;
6459: --
6460: -- set event info as cache for other routines to refer event attributes
6454:
6455: --
6456: -- set the XLA_AE_JOURNAL_ENTRY_PKG.g_global_status to C_VALID (0)
6457: --
6458: XLA_AE_JOURNAL_ENTRY_PKG.g_global_status := XLA_AE_JOURNAL_ENTRY_PKG.C_VALID;
6459: --
6460: -- set event info as cache for other routines to refer event attributes
6461: --
6462:
6462:
6463: IF l_event_id <> NVL(l_previous_event_id, -1) THEN
6464: l_previous_event_id := l_event_id;
6465:
6466: XLA_AE_JOURNAL_ENTRY_PKG.set_event_info
6467: (p_application_id => p_application_id
6468: ,p_primary_ledger_id => p_primary_ledger_id
6469: ,p_base_ledger_id => p_base_ledger_id
6470: ,p_target_ledger_id => p_target_ledger_id
6503: l_acct_reversal_source := SUBSTR(NULL, 1,30);
6504:
6505: IF l_continue_with_lines THEN
6506: IF NVL(l_acct_reversal_source, 'N') NOT IN ('N','Y','B') THEN
6507: xla_ae_journal_entry_pkg.g_global_status := xla_ae_journal_entry_pkg.C_INVALID;
6508:
6509: xla_accounting_err_pkg.build_message
6510: (p_appli_s_name => 'XLA'
6511: ,p_msg_name => 'XLA_AP_INVALID_REVERSAL_OPTION'
6511: ,p_msg_name => 'XLA_AP_INVALID_REVERSAL_OPTION'
6512: ,p_token_1 => 'LINE_NUMBER'
6513: ,p_value_1 => l_array_extract_line_num(Idx)
6514: ,p_token_2 => 'PRODUCT_NAME'
6515: ,p_value_2 => xla_ae_journal_entry_pkg.g_cache_event.application_name
6516: ,p_entity_id => xla_ae_journal_entry_pkg.g_cache_event.entity_id
6517: ,p_event_id => xla_ae_journal_entry_pkg.g_cache_event.event_id
6518: ,p_ledger_id => xla_ae_journal_entry_pkg.g_cache_event.target_ledger_id);
6519:
6512: ,p_token_1 => 'LINE_NUMBER'
6513: ,p_value_1 => l_array_extract_line_num(Idx)
6514: ,p_token_2 => 'PRODUCT_NAME'
6515: ,p_value_2 => xla_ae_journal_entry_pkg.g_cache_event.application_name
6516: ,p_entity_id => xla_ae_journal_entry_pkg.g_cache_event.entity_id
6517: ,p_event_id => xla_ae_journal_entry_pkg.g_cache_event.event_id
6518: ,p_ledger_id => xla_ae_journal_entry_pkg.g_cache_event.target_ledger_id);
6519:
6520: ELSIF NVL(l_acct_reversal_source, 'N') IN ('Y','B') THEN
6513: ,p_value_1 => l_array_extract_line_num(Idx)
6514: ,p_token_2 => 'PRODUCT_NAME'
6515: ,p_value_2 => xla_ae_journal_entry_pkg.g_cache_event.application_name
6516: ,p_entity_id => xla_ae_journal_entry_pkg.g_cache_event.entity_id
6517: ,p_event_id => xla_ae_journal_entry_pkg.g_cache_event.event_id
6518: ,p_ledger_id => xla_ae_journal_entry_pkg.g_cache_event.target_ledger_id);
6519:
6520: ELSIF NVL(l_acct_reversal_source, 'N') IN ('Y','B') THEN
6521: --
6514: ,p_token_2 => 'PRODUCT_NAME'
6515: ,p_value_2 => xla_ae_journal_entry_pkg.g_cache_event.application_name
6516: ,p_entity_id => xla_ae_journal_entry_pkg.g_cache_event.entity_id
6517: ,p_event_id => xla_ae_journal_entry_pkg.g_cache_event.event_id
6518: ,p_ledger_id => xla_ae_journal_entry_pkg.g_cache_event.target_ledger_id);
6519:
6520: ELSIF NVL(l_acct_reversal_source, 'N') IN ('Y','B') THEN
6521: --
6522: -- following sets the accounting attributes needed to reverse
6545: l_actual_flag := NULL; l_actual_gain_loss_ref := '#####';
6546: -- only execute it if calculate g/l flag is yes, and primary or secondary ledger
6547: -- or secondary ledger that has different currency with primary
6548: -- or alc that is calculated by sla
6549: IF (((l_calculate_g_l_flag = 'Y' AND XLA_AE_JOURNAL_ENTRY_PKG.g_cache_ledgers_info.ledger_category_code <> 'ALC') or
6550: (XLA_AE_JOURNAL_ENTRY_PKG.g_cache_ledgers_info.ledger_category_code in ('ALC', 'SECONDARY') AND XLA_AE_JOURNAL_ENTRY_PKG.g_cache_ledgers_info.calculate_amts_flag='Y'))
6551:
6552: -- IF((l_calculate_g_l_flag='Y' or XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.target_ledger_id <>
6553: -- XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.ledger_id)
6546: -- only execute it if calculate g/l flag is yes, and primary or secondary ledger
6547: -- or secondary ledger that has different currency with primary
6548: -- or alc that is calculated by sla
6549: IF (((l_calculate_g_l_flag = 'Y' AND XLA_AE_JOURNAL_ENTRY_PKG.g_cache_ledgers_info.ledger_category_code <> 'ALC') or
6550: (XLA_AE_JOURNAL_ENTRY_PKG.g_cache_ledgers_info.ledger_category_code in ('ALC', 'SECONDARY') AND XLA_AE_JOURNAL_ENTRY_PKG.g_cache_ledgers_info.calculate_amts_flag='Y'))
6551:
6552: -- IF((l_calculate_g_l_flag='Y' or XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.target_ledger_id <>
6553: -- XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.ledger_id)
6554: AND (l_actual_flag = 'A')) THEN
6548: -- or alc that is calculated by sla
6549: IF (((l_calculate_g_l_flag = 'Y' AND XLA_AE_JOURNAL_ENTRY_PKG.g_cache_ledgers_info.ledger_category_code <> 'ALC') or
6550: (XLA_AE_JOURNAL_ENTRY_PKG.g_cache_ledgers_info.ledger_category_code in ('ALC', 'SECONDARY') AND XLA_AE_JOURNAL_ENTRY_PKG.g_cache_ledgers_info.calculate_amts_flag='Y'))
6551:
6552: -- IF((l_calculate_g_l_flag='Y' or XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.target_ledger_id <>
6553: -- XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.ledger_id)
6554: AND (l_actual_flag = 'A')) THEN
6555: XLA_AE_LINES_PKG.CreateGainOrLossLines(
6556: p_event_id => xla_ae_journal_entry_pkg.g_cache_event.event_id
6549: IF (((l_calculate_g_l_flag = 'Y' AND XLA_AE_JOURNAL_ENTRY_PKG.g_cache_ledgers_info.ledger_category_code <> 'ALC') or
6550: (XLA_AE_JOURNAL_ENTRY_PKG.g_cache_ledgers_info.ledger_category_code in ('ALC', 'SECONDARY') AND XLA_AE_JOURNAL_ENTRY_PKG.g_cache_ledgers_info.calculate_amts_flag='Y'))
6551:
6552: -- IF((l_calculate_g_l_flag='Y' or XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.target_ledger_id <>
6553: -- XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.ledger_id)
6554: AND (l_actual_flag = 'A')) THEN
6555: XLA_AE_LINES_PKG.CreateGainOrLossLines(
6556: p_event_id => xla_ae_journal_entry_pkg.g_cache_event.event_id
6557: ,p_application_id => p_application_id
6552: -- IF((l_calculate_g_l_flag='Y' or XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.target_ledger_id <>
6553: -- XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.ledger_id)
6554: AND (l_actual_flag = 'A')) THEN
6555: XLA_AE_LINES_PKG.CreateGainOrLossLines(
6556: p_event_id => xla_ae_journal_entry_pkg.g_cache_event.event_id
6557: ,p_application_id => p_application_id
6558: ,p_amb_context_code => 'DEFAULT'
6559: ,p_entity_code => xla_ae_journal_entry_pkg.g_cache_event.entity_code
6560: ,p_event_class_code => C_EVENT_CLASS_CODE
6555: XLA_AE_LINES_PKG.CreateGainOrLossLines(
6556: p_event_id => xla_ae_journal_entry_pkg.g_cache_event.event_id
6557: ,p_application_id => p_application_id
6558: ,p_amb_context_code => 'DEFAULT'
6559: ,p_entity_code => xla_ae_journal_entry_pkg.g_cache_event.entity_code
6560: ,p_event_class_code => C_EVENT_CLASS_CODE
6561: ,p_event_type_code => C_EVENT_TYPE_CODE
6562:
6563: ,p_gain_ccid => -1
6846:
6847: l_calculate_acctd_flag VARCHAR2(1) :='N';
6848: l_calculate_g_l_flag VARCHAR2(1) :='N';
6849: --
6850: l_array_legal_entity_id XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
6851: l_array_entity_id XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
6852: l_array_entity_code XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L;
6853: l_array_transaction_num XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
6854: l_array_event_id XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
6847: l_calculate_acctd_flag VARCHAR2(1) :='N';
6848: l_calculate_g_l_flag VARCHAR2(1) :='N';
6849: --
6850: l_array_legal_entity_id XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
6851: l_array_entity_id XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
6852: l_array_entity_code XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L;
6853: l_array_transaction_num XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
6854: l_array_event_id XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
6855: l_array_class_code XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L;
6848: l_calculate_g_l_flag VARCHAR2(1) :='N';
6849: --
6850: l_array_legal_entity_id XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
6851: l_array_entity_id XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
6852: l_array_entity_code XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L;
6853: l_array_transaction_num XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
6854: l_array_event_id XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
6855: l_array_class_code XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L;
6856: l_array_event_type XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L;
6849: --
6850: l_array_legal_entity_id XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
6851: l_array_entity_id XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
6852: l_array_entity_code XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L;
6853: l_array_transaction_num XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
6854: l_array_event_id XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
6855: l_array_class_code XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L;
6856: l_array_event_type XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L;
6857: l_array_event_number XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
6850: l_array_legal_entity_id XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
6851: l_array_entity_id XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
6852: l_array_entity_code XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L;
6853: l_array_transaction_num XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
6854: l_array_event_id XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
6855: l_array_class_code XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L;
6856: l_array_event_type XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L;
6857: l_array_event_number XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
6858: l_array_event_date XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
6851: l_array_entity_id XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
6852: l_array_entity_code XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L;
6853: l_array_transaction_num XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
6854: l_array_event_id XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
6855: l_array_class_code XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L;
6856: l_array_event_type XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L;
6857: l_array_event_number XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
6858: l_array_event_date XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
6859: l_array_transaction_date XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
6852: l_array_entity_code XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L;
6853: l_array_transaction_num XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
6854: l_array_event_id XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
6855: l_array_class_code XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L;
6856: l_array_event_type XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L;
6857: l_array_event_number XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
6858: l_array_event_date XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
6859: l_array_transaction_date XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
6860: l_array_reference_num_1 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
6853: l_array_transaction_num XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
6854: l_array_event_id XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
6855: l_array_class_code XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L;
6856: l_array_event_type XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L;
6857: l_array_event_number XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
6858: l_array_event_date XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
6859: l_array_transaction_date XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
6860: l_array_reference_num_1 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
6861: l_array_reference_num_2 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
6854: l_array_event_id XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
6855: l_array_class_code XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L;
6856: l_array_event_type XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L;
6857: l_array_event_number XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
6858: l_array_event_date XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
6859: l_array_transaction_date XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
6860: l_array_reference_num_1 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
6861: l_array_reference_num_2 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
6862: l_array_reference_num_3 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
6855: l_array_class_code XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L;
6856: l_array_event_type XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L;
6857: l_array_event_number XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
6858: l_array_event_date XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
6859: l_array_transaction_date XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
6860: l_array_reference_num_1 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
6861: l_array_reference_num_2 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
6862: l_array_reference_num_3 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
6863: l_array_reference_num_4 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
6856: l_array_event_type XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L;
6857: l_array_event_number XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
6858: l_array_event_date XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
6859: l_array_transaction_date XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
6860: l_array_reference_num_1 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
6861: l_array_reference_num_2 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
6862: l_array_reference_num_3 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
6863: l_array_reference_num_4 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
6864: l_array_reference_char_1 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
6857: l_array_event_number XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
6858: l_array_event_date XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
6859: l_array_transaction_date XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
6860: l_array_reference_num_1 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
6861: l_array_reference_num_2 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
6862: l_array_reference_num_3 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
6863: l_array_reference_num_4 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
6864: l_array_reference_char_1 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
6865: l_array_reference_char_2 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
6858: l_array_event_date XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
6859: l_array_transaction_date XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
6860: l_array_reference_num_1 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
6861: l_array_reference_num_2 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
6862: l_array_reference_num_3 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
6863: l_array_reference_num_4 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
6864: l_array_reference_char_1 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
6865: l_array_reference_char_2 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
6866: l_array_reference_char_3 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
6859: l_array_transaction_date XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
6860: l_array_reference_num_1 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
6861: l_array_reference_num_2 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
6862: l_array_reference_num_3 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
6863: l_array_reference_num_4 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
6864: l_array_reference_char_1 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
6865: l_array_reference_char_2 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
6866: l_array_reference_char_3 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
6867: l_array_reference_char_4 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
6860: l_array_reference_num_1 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
6861: l_array_reference_num_2 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
6862: l_array_reference_num_3 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
6863: l_array_reference_num_4 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
6864: l_array_reference_char_1 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
6865: l_array_reference_char_2 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
6866: l_array_reference_char_3 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
6867: l_array_reference_char_4 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
6868: l_array_reference_date_1 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
6861: l_array_reference_num_2 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
6862: l_array_reference_num_3 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
6863: l_array_reference_num_4 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
6864: l_array_reference_char_1 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
6865: l_array_reference_char_2 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
6866: l_array_reference_char_3 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
6867: l_array_reference_char_4 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
6868: l_array_reference_date_1 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
6869: l_array_reference_date_2 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
6862: l_array_reference_num_3 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
6863: l_array_reference_num_4 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
6864: l_array_reference_char_1 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
6865: l_array_reference_char_2 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
6866: l_array_reference_char_3 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
6867: l_array_reference_char_4 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
6868: l_array_reference_date_1 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
6869: l_array_reference_date_2 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
6870: l_array_reference_date_3 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
6863: l_array_reference_num_4 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
6864: l_array_reference_char_1 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
6865: l_array_reference_char_2 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
6866: l_array_reference_char_3 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
6867: l_array_reference_char_4 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
6868: l_array_reference_date_1 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
6869: l_array_reference_date_2 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
6870: l_array_reference_date_3 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
6871: l_array_reference_date_4 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
6864: l_array_reference_char_1 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
6865: l_array_reference_char_2 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
6866: l_array_reference_char_3 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
6867: l_array_reference_char_4 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
6868: l_array_reference_date_1 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
6869: l_array_reference_date_2 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
6870: l_array_reference_date_3 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
6871: l_array_reference_date_4 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
6872: l_array_event_created_by XLA_AE_JOURNAL_ENTRY_PKG.t_array_V100L;
6865: l_array_reference_char_2 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
6866: l_array_reference_char_3 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
6867: l_array_reference_char_4 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
6868: l_array_reference_date_1 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
6869: l_array_reference_date_2 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
6870: l_array_reference_date_3 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
6871: l_array_reference_date_4 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
6872: l_array_event_created_by XLA_AE_JOURNAL_ENTRY_PKG.t_array_V100L;
6873: l_array_budgetary_control_flag XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L;
6866: l_array_reference_char_3 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
6867: l_array_reference_char_4 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
6868: l_array_reference_date_1 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
6869: l_array_reference_date_2 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
6870: l_array_reference_date_3 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
6871: l_array_reference_date_4 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
6872: l_array_event_created_by XLA_AE_JOURNAL_ENTRY_PKG.t_array_V100L;
6873: l_array_budgetary_control_flag XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L;
6874:
6867: l_array_reference_char_4 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
6868: l_array_reference_date_1 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
6869: l_array_reference_date_2 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
6870: l_array_reference_date_3 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
6871: l_array_reference_date_4 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
6872: l_array_event_created_by XLA_AE_JOURNAL_ENTRY_PKG.t_array_V100L;
6873: l_array_budgetary_control_flag XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L;
6874:
6875: l_event_id NUMBER;
6868: l_array_reference_date_1 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
6869: l_array_reference_date_2 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
6870: l_array_reference_date_3 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
6871: l_array_reference_date_4 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
6872: l_array_event_created_by XLA_AE_JOURNAL_ENTRY_PKG.t_array_V100L;
6873: l_array_budgetary_control_flag XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L;
6874:
6875: l_event_id NUMBER;
6876: l_previous_event_id NUMBER;
6869: l_array_reference_date_2 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
6870: l_array_reference_date_3 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
6871: l_array_reference_date_4 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
6872: l_array_event_created_by XLA_AE_JOURNAL_ENTRY_PKG.t_array_V100L;
6873: l_array_budgetary_control_flag XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L;
6874:
6875: l_event_id NUMBER;
6876: l_previous_event_id NUMBER;
6877: l_first_event_id NUMBER;
6887: l_event_class_name VARCHAR2(80) := 'Reprogram Budget Execution Transactions';
6888: l_description VARCHAR2(4000);
6889: l_transaction_reversal NUMBER;
6890: l_ae_header_id NUMBER;
6891: l_array_extract_line_num xla_ae_journal_entry_pkg.t_array_Num;
6892: l_log_module VARCHAR2(240);
6893: --
6894: l_acct_reversal_source VARCHAR2(30);
6895: l_trx_reversal_source VARCHAR2(30);
7098:
7099: --
7100: -- set event info as cache for other routines to refer event attributes
7101: --
7102: XLA_AE_JOURNAL_ENTRY_PKG.set_event_info
7103: (p_application_id => p_application_id
7104: ,p_primary_ledger_id => p_primary_ledger_id
7105: ,p_base_ledger_id => p_base_ledger_id
7106: ,p_target_ledger_id => p_target_ledger_id
7131:
7132: --
7133: -- set the status of entry to C_VALID (0)
7134: --
7135: XLA_AE_JOURNAL_ENTRY_PKG.g_global_status := XLA_AE_JOURNAL_ENTRY_PKG.C_VALID;
7136:
7137: --
7138: -- initialize a row for ae header
7139: --
7156: --
7157: -- initilaize the status of ae headers for diffrent balance types
7158: -- the status is initialised to C_NOT_CREATED (2)
7159: --
7160: --g_array_event(l_event_id).array_value_num('actual_je_status') := XLA_AE_JOURNAL_ENTRY_PKG.C_NOT_CREATED;
7161: --g_array_event(l_event_id).array_value_num('budget_je_status') := XLA_AE_JOURNAL_ENTRY_PKG.C_NOT_CREATED;
7162: --g_array_event(l_event_id).array_value_num('encumbrance_je_status') := XLA_AE_JOURNAL_ENTRY_PKG.C_NOT_CREATED;
7163:
7164: --
7157: -- initilaize the status of ae headers for diffrent balance types
7158: -- the status is initialised to C_NOT_CREATED (2)
7159: --
7160: --g_array_event(l_event_id).array_value_num('actual_je_status') := XLA_AE_JOURNAL_ENTRY_PKG.C_NOT_CREATED;
7161: --g_array_event(l_event_id).array_value_num('budget_je_status') := XLA_AE_JOURNAL_ENTRY_PKG.C_NOT_CREATED;
7162: --g_array_event(l_event_id).array_value_num('encumbrance_je_status') := XLA_AE_JOURNAL_ENTRY_PKG.C_NOT_CREATED;
7163:
7164: --
7165: -- call api to validate and store accounting attributes for header
7158: -- the status is initialised to C_NOT_CREATED (2)
7159: --
7160: --g_array_event(l_event_id).array_value_num('actual_je_status') := XLA_AE_JOURNAL_ENTRY_PKG.C_NOT_CREATED;
7161: --g_array_event(l_event_id).array_value_num('budget_je_status') := XLA_AE_JOURNAL_ENTRY_PKG.C_NOT_CREATED;
7162: --g_array_event(l_event_id).array_value_num('encumbrance_je_status') := XLA_AE_JOURNAL_ENTRY_PKG.C_NOT_CREATED;
7163:
7164: --
7165: -- call api to validate and store accounting attributes for header
7166: --
7192: --
7193: l_trx_reversal_source := SUBSTR(NULL, 1,30);
7194:
7195: IF NVL(l_trx_reversal_source, 'N') NOT IN ('N','Y') THEN
7196: xla_ae_journal_entry_pkg.g_global_status := xla_ae_journal_entry_pkg.C_INVALID;
7197:
7198: xla_accounting_err_pkg.build_message
7199: (p_appli_s_name => 'XLA'
7200: ,p_msg_name => 'XLA_AP_INVALID_HDR_ATTR'
7200: ,p_msg_name => 'XLA_AP_INVALID_HDR_ATTR'
7201: ,p_token_1 => 'ACCT_ATTR_NAME'
7202: ,p_value_1 => xla_ae_sources_pkg.GetAccountingSourceName('TRX_ACCT_REVERSAL_OPTION')
7203: ,p_token_2 => 'PRODUCT_NAME'
7204: ,p_value_2 => xla_ae_journal_entry_pkg.g_cache_event.application_name
7205: ,p_entity_id => xla_ae_journal_entry_pkg.g_cache_event.entity_id
7206: ,p_event_id => xla_ae_journal_entry_pkg.g_cache_event.event_id
7207: ,p_ledger_id => xla_ae_journal_entry_pkg.g_cache_event.target_ledger_id);
7208:
7201: ,p_token_1 => 'ACCT_ATTR_NAME'
7202: ,p_value_1 => xla_ae_sources_pkg.GetAccountingSourceName('TRX_ACCT_REVERSAL_OPTION')
7203: ,p_token_2 => 'PRODUCT_NAME'
7204: ,p_value_2 => xla_ae_journal_entry_pkg.g_cache_event.application_name
7205: ,p_entity_id => xla_ae_journal_entry_pkg.g_cache_event.entity_id
7206: ,p_event_id => xla_ae_journal_entry_pkg.g_cache_event.event_id
7207: ,p_ledger_id => xla_ae_journal_entry_pkg.g_cache_event.target_ledger_id);
7208:
7209: ELSIF NVL(l_trx_reversal_source, 'N') = 'Y' THEN
7202: ,p_value_1 => xla_ae_sources_pkg.GetAccountingSourceName('TRX_ACCT_REVERSAL_OPTION')
7203: ,p_token_2 => 'PRODUCT_NAME'
7204: ,p_value_2 => xla_ae_journal_entry_pkg.g_cache_event.application_name
7205: ,p_entity_id => xla_ae_journal_entry_pkg.g_cache_event.entity_id
7206: ,p_event_id => xla_ae_journal_entry_pkg.g_cache_event.event_id
7207: ,p_ledger_id => xla_ae_journal_entry_pkg.g_cache_event.target_ledger_id);
7208:
7209: ELSIF NVL(l_trx_reversal_source, 'N') = 'Y' THEN
7210: --
7203: ,p_token_2 => 'PRODUCT_NAME'
7204: ,p_value_2 => xla_ae_journal_entry_pkg.g_cache_event.application_name
7205: ,p_entity_id => xla_ae_journal_entry_pkg.g_cache_event.entity_id
7206: ,p_event_id => xla_ae_journal_entry_pkg.g_cache_event.event_id
7207: ,p_ledger_id => xla_ae_journal_entry_pkg.g_cache_event.target_ledger_id);
7208:
7209: ELSIF NVL(l_trx_reversal_source, 'N') = 'Y' THEN
7210: --
7211: -- following sets the accounting attributes needed to reverse
7222: ----------------------------------------------------------------
7223: -- 4262811 - update the header statuses to invalid in need be
7224: ----------------------------------------------------------------
7225: --
7226: XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus (p_hdr_idx => hdr_idx);
7227:
7228:
7229: -----------------------------------------------
7230: -- No accrual reversal for the event class/type
7341: ,p_module => l_log_module);
7342: END IF;
7343:
7344: --
7345: -- set the XLA_AE_JOURNAL_ENTRY_PKG.g_global_status to C_VALID (0)
7346: --
7347: XLA_AE_JOURNAL_ENTRY_PKG.g_global_status := XLA_AE_JOURNAL_ENTRY_PKG.C_VALID;
7348: --
7349: -- set event info as cache for other routines to refer event attributes
7343:
7344: --
7345: -- set the XLA_AE_JOURNAL_ENTRY_PKG.g_global_status to C_VALID (0)
7346: --
7347: XLA_AE_JOURNAL_ENTRY_PKG.g_global_status := XLA_AE_JOURNAL_ENTRY_PKG.C_VALID;
7348: --
7349: -- set event info as cache for other routines to refer event attributes
7350: --
7351:
7351:
7352: IF l_event_id <> NVL(l_previous_event_id, -1) THEN
7353: l_previous_event_id := l_event_id;
7354:
7355: XLA_AE_JOURNAL_ENTRY_PKG.set_event_info
7356: (p_application_id => p_application_id
7357: ,p_primary_ledger_id => p_primary_ledger_id
7358: ,p_base_ledger_id => p_base_ledger_id
7359: ,p_target_ledger_id => p_target_ledger_id
7392: l_acct_reversal_source := SUBSTR(NULL, 1,30);
7393:
7394: IF l_continue_with_lines THEN
7395: IF NVL(l_acct_reversal_source, 'N') NOT IN ('N','Y','B') THEN
7396: xla_ae_journal_entry_pkg.g_global_status := xla_ae_journal_entry_pkg.C_INVALID;
7397:
7398: xla_accounting_err_pkg.build_message
7399: (p_appli_s_name => 'XLA'
7400: ,p_msg_name => 'XLA_AP_INVALID_REVERSAL_OPTION'
7400: ,p_msg_name => 'XLA_AP_INVALID_REVERSAL_OPTION'
7401: ,p_token_1 => 'LINE_NUMBER'
7402: ,p_value_1 => l_array_extract_line_num(Idx)
7403: ,p_token_2 => 'PRODUCT_NAME'
7404: ,p_value_2 => xla_ae_journal_entry_pkg.g_cache_event.application_name
7405: ,p_entity_id => xla_ae_journal_entry_pkg.g_cache_event.entity_id
7406: ,p_event_id => xla_ae_journal_entry_pkg.g_cache_event.event_id
7407: ,p_ledger_id => xla_ae_journal_entry_pkg.g_cache_event.target_ledger_id);
7408:
7401: ,p_token_1 => 'LINE_NUMBER'
7402: ,p_value_1 => l_array_extract_line_num(Idx)
7403: ,p_token_2 => 'PRODUCT_NAME'
7404: ,p_value_2 => xla_ae_journal_entry_pkg.g_cache_event.application_name
7405: ,p_entity_id => xla_ae_journal_entry_pkg.g_cache_event.entity_id
7406: ,p_event_id => xla_ae_journal_entry_pkg.g_cache_event.event_id
7407: ,p_ledger_id => xla_ae_journal_entry_pkg.g_cache_event.target_ledger_id);
7408:
7409: ELSIF NVL(l_acct_reversal_source, 'N') IN ('Y','B') THEN
7402: ,p_value_1 => l_array_extract_line_num(Idx)
7403: ,p_token_2 => 'PRODUCT_NAME'
7404: ,p_value_2 => xla_ae_journal_entry_pkg.g_cache_event.application_name
7405: ,p_entity_id => xla_ae_journal_entry_pkg.g_cache_event.entity_id
7406: ,p_event_id => xla_ae_journal_entry_pkg.g_cache_event.event_id
7407: ,p_ledger_id => xla_ae_journal_entry_pkg.g_cache_event.target_ledger_id);
7408:
7409: ELSIF NVL(l_acct_reversal_source, 'N') IN ('Y','B') THEN
7410: --
7403: ,p_token_2 => 'PRODUCT_NAME'
7404: ,p_value_2 => xla_ae_journal_entry_pkg.g_cache_event.application_name
7405: ,p_entity_id => xla_ae_journal_entry_pkg.g_cache_event.entity_id
7406: ,p_event_id => xla_ae_journal_entry_pkg.g_cache_event.event_id
7407: ,p_ledger_id => xla_ae_journal_entry_pkg.g_cache_event.target_ledger_id);
7408:
7409: ELSIF NVL(l_acct_reversal_source, 'N') IN ('Y','B') THEN
7410: --
7411: -- following sets the accounting attributes needed to reverse
7434: l_actual_flag := NULL; l_actual_gain_loss_ref := '#####';
7435: -- only execute it if calculate g/l flag is yes, and primary or secondary ledger
7436: -- or secondary ledger that has different currency with primary
7437: -- or alc that is calculated by sla
7438: IF (((l_calculate_g_l_flag = 'Y' AND XLA_AE_JOURNAL_ENTRY_PKG.g_cache_ledgers_info.ledger_category_code <> 'ALC') or
7439: (XLA_AE_JOURNAL_ENTRY_PKG.g_cache_ledgers_info.ledger_category_code in ('ALC', 'SECONDARY') AND XLA_AE_JOURNAL_ENTRY_PKG.g_cache_ledgers_info.calculate_amts_flag='Y'))
7440:
7441: -- IF((l_calculate_g_l_flag='Y' or XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.target_ledger_id <>
7442: -- XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.ledger_id)
7435: -- only execute it if calculate g/l flag is yes, and primary or secondary ledger
7436: -- or secondary ledger that has different currency with primary
7437: -- or alc that is calculated by sla
7438: IF (((l_calculate_g_l_flag = 'Y' AND XLA_AE_JOURNAL_ENTRY_PKG.g_cache_ledgers_info.ledger_category_code <> 'ALC') or
7439: (XLA_AE_JOURNAL_ENTRY_PKG.g_cache_ledgers_info.ledger_category_code in ('ALC', 'SECONDARY') AND XLA_AE_JOURNAL_ENTRY_PKG.g_cache_ledgers_info.calculate_amts_flag='Y'))
7440:
7441: -- IF((l_calculate_g_l_flag='Y' or XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.target_ledger_id <>
7442: -- XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.ledger_id)
7443: AND (l_actual_flag = 'A')) THEN
7437: -- or alc that is calculated by sla
7438: IF (((l_calculate_g_l_flag = 'Y' AND XLA_AE_JOURNAL_ENTRY_PKG.g_cache_ledgers_info.ledger_category_code <> 'ALC') or
7439: (XLA_AE_JOURNAL_ENTRY_PKG.g_cache_ledgers_info.ledger_category_code in ('ALC', 'SECONDARY') AND XLA_AE_JOURNAL_ENTRY_PKG.g_cache_ledgers_info.calculate_amts_flag='Y'))
7440:
7441: -- IF((l_calculate_g_l_flag='Y' or XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.target_ledger_id <>
7442: -- XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.ledger_id)
7443: AND (l_actual_flag = 'A')) THEN
7444: XLA_AE_LINES_PKG.CreateGainOrLossLines(
7445: p_event_id => xla_ae_journal_entry_pkg.g_cache_event.event_id
7438: IF (((l_calculate_g_l_flag = 'Y' AND XLA_AE_JOURNAL_ENTRY_PKG.g_cache_ledgers_info.ledger_category_code <> 'ALC') or
7439: (XLA_AE_JOURNAL_ENTRY_PKG.g_cache_ledgers_info.ledger_category_code in ('ALC', 'SECONDARY') AND XLA_AE_JOURNAL_ENTRY_PKG.g_cache_ledgers_info.calculate_amts_flag='Y'))
7440:
7441: -- IF((l_calculate_g_l_flag='Y' or XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.target_ledger_id <>
7442: -- XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.ledger_id)
7443: AND (l_actual_flag = 'A')) THEN
7444: XLA_AE_LINES_PKG.CreateGainOrLossLines(
7445: p_event_id => xla_ae_journal_entry_pkg.g_cache_event.event_id
7446: ,p_application_id => p_application_id
7441: -- IF((l_calculate_g_l_flag='Y' or XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.target_ledger_id <>
7442: -- XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.ledger_id)
7443: AND (l_actual_flag = 'A')) THEN
7444: XLA_AE_LINES_PKG.CreateGainOrLossLines(
7445: p_event_id => xla_ae_journal_entry_pkg.g_cache_event.event_id
7446: ,p_application_id => p_application_id
7447: ,p_amb_context_code => 'DEFAULT'
7448: ,p_entity_code => xla_ae_journal_entry_pkg.g_cache_event.entity_code
7449: ,p_event_class_code => C_EVENT_CLASS_CODE
7444: XLA_AE_LINES_PKG.CreateGainOrLossLines(
7445: p_event_id => xla_ae_journal_entry_pkg.g_cache_event.event_id
7446: ,p_application_id => p_application_id
7447: ,p_amb_context_code => 'DEFAULT'
7448: ,p_entity_code => xla_ae_journal_entry_pkg.g_cache_event.entity_code
7449: ,p_event_class_code => C_EVENT_CLASS_CODE
7450: ,p_event_type_code => C_EVENT_TYPE_CODE
7451:
7452: ,p_gain_ccid => -1
7945:
7946: l_calculate_acctd_flag VARCHAR2(1) :='Y';
7947: l_calculate_g_l_flag VARCHAR2(1) :='Y';
7948: --
7949: l_array_legal_entity_id XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
7950: l_array_entity_id XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
7951: l_array_entity_code XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L;
7952: l_array_transaction_num XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
7953: l_array_event_id XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
7946: l_calculate_acctd_flag VARCHAR2(1) :='Y';
7947: l_calculate_g_l_flag VARCHAR2(1) :='Y';
7948: --
7949: l_array_legal_entity_id XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
7950: l_array_entity_id XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
7951: l_array_entity_code XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L;
7952: l_array_transaction_num XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
7953: l_array_event_id XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
7954: l_array_class_code XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L;
7947: l_calculate_g_l_flag VARCHAR2(1) :='Y';
7948: --
7949: l_array_legal_entity_id XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
7950: l_array_entity_id XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
7951: l_array_entity_code XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L;
7952: l_array_transaction_num XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
7953: l_array_event_id XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
7954: l_array_class_code XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L;
7955: l_array_event_type XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L;
7948: --
7949: l_array_legal_entity_id XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
7950: l_array_entity_id XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
7951: l_array_entity_code XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L;
7952: l_array_transaction_num XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
7953: l_array_event_id XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
7954: l_array_class_code XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L;
7955: l_array_event_type XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L;
7956: l_array_event_number XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
7949: l_array_legal_entity_id XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
7950: l_array_entity_id XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
7951: l_array_entity_code XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L;
7952: l_array_transaction_num XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
7953: l_array_event_id XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
7954: l_array_class_code XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L;
7955: l_array_event_type XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L;
7956: l_array_event_number XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
7957: l_array_event_date XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
7950: l_array_entity_id XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
7951: l_array_entity_code XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L;
7952: l_array_transaction_num XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
7953: l_array_event_id XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
7954: l_array_class_code XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L;
7955: l_array_event_type XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L;
7956: l_array_event_number XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
7957: l_array_event_date XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
7958: l_array_transaction_date XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
7951: l_array_entity_code XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L;
7952: l_array_transaction_num XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
7953: l_array_event_id XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
7954: l_array_class_code XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L;
7955: l_array_event_type XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L;
7956: l_array_event_number XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
7957: l_array_event_date XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
7958: l_array_transaction_date XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
7959: l_array_reference_num_1 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
7952: l_array_transaction_num XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
7953: l_array_event_id XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
7954: l_array_class_code XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L;
7955: l_array_event_type XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L;
7956: l_array_event_number XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
7957: l_array_event_date XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
7958: l_array_transaction_date XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
7959: l_array_reference_num_1 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
7960: l_array_reference_num_2 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
7953: l_array_event_id XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
7954: l_array_class_code XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L;
7955: l_array_event_type XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L;
7956: l_array_event_number XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
7957: l_array_event_date XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
7958: l_array_transaction_date XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
7959: l_array_reference_num_1 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
7960: l_array_reference_num_2 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
7961: l_array_reference_num_3 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
7954: l_array_class_code XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L;
7955: l_array_event_type XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L;
7956: l_array_event_number XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
7957: l_array_event_date XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
7958: l_array_transaction_date XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
7959: l_array_reference_num_1 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
7960: l_array_reference_num_2 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
7961: l_array_reference_num_3 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
7962: l_array_reference_num_4 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
7955: l_array_event_type XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L;
7956: l_array_event_number XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
7957: l_array_event_date XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
7958: l_array_transaction_date XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
7959: l_array_reference_num_1 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
7960: l_array_reference_num_2 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
7961: l_array_reference_num_3 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
7962: l_array_reference_num_4 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
7963: l_array_reference_char_1 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
7956: l_array_event_number XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
7957: l_array_event_date XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
7958: l_array_transaction_date XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
7959: l_array_reference_num_1 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
7960: l_array_reference_num_2 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
7961: l_array_reference_num_3 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
7962: l_array_reference_num_4 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
7963: l_array_reference_char_1 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
7964: l_array_reference_char_2 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
7957: l_array_event_date XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
7958: l_array_transaction_date XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
7959: l_array_reference_num_1 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
7960: l_array_reference_num_2 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
7961: l_array_reference_num_3 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
7962: l_array_reference_num_4 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
7963: l_array_reference_char_1 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
7964: l_array_reference_char_2 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
7965: l_array_reference_char_3 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
7958: l_array_transaction_date XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
7959: l_array_reference_num_1 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
7960: l_array_reference_num_2 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
7961: l_array_reference_num_3 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
7962: l_array_reference_num_4 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
7963: l_array_reference_char_1 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
7964: l_array_reference_char_2 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
7965: l_array_reference_char_3 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
7966: l_array_reference_char_4 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
7959: l_array_reference_num_1 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
7960: l_array_reference_num_2 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
7961: l_array_reference_num_3 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
7962: l_array_reference_num_4 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
7963: l_array_reference_char_1 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
7964: l_array_reference_char_2 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
7965: l_array_reference_char_3 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
7966: l_array_reference_char_4 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
7967: l_array_reference_date_1 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
7960: l_array_reference_num_2 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
7961: l_array_reference_num_3 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
7962: l_array_reference_num_4 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
7963: l_array_reference_char_1 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
7964: l_array_reference_char_2 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
7965: l_array_reference_char_3 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
7966: l_array_reference_char_4 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
7967: l_array_reference_date_1 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
7968: l_array_reference_date_2 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
7961: l_array_reference_num_3 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
7962: l_array_reference_num_4 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
7963: l_array_reference_char_1 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
7964: l_array_reference_char_2 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
7965: l_array_reference_char_3 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
7966: l_array_reference_char_4 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
7967: l_array_reference_date_1 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
7968: l_array_reference_date_2 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
7969: l_array_reference_date_3 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
7962: l_array_reference_num_4 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
7963: l_array_reference_char_1 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
7964: l_array_reference_char_2 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
7965: l_array_reference_char_3 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
7966: l_array_reference_char_4 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
7967: l_array_reference_date_1 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
7968: l_array_reference_date_2 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
7969: l_array_reference_date_3 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
7970: l_array_reference_date_4 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
7963: l_array_reference_char_1 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
7964: l_array_reference_char_2 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
7965: l_array_reference_char_3 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
7966: l_array_reference_char_4 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
7967: l_array_reference_date_1 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
7968: l_array_reference_date_2 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
7969: l_array_reference_date_3 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
7970: l_array_reference_date_4 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
7971: l_array_event_created_by XLA_AE_JOURNAL_ENTRY_PKG.t_array_V100L;
7964: l_array_reference_char_2 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
7965: l_array_reference_char_3 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
7966: l_array_reference_char_4 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
7967: l_array_reference_date_1 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
7968: l_array_reference_date_2 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
7969: l_array_reference_date_3 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
7970: l_array_reference_date_4 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
7971: l_array_event_created_by XLA_AE_JOURNAL_ENTRY_PKG.t_array_V100L;
7972: l_array_budgetary_control_flag XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L;
7965: l_array_reference_char_3 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
7966: l_array_reference_char_4 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
7967: l_array_reference_date_1 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
7968: l_array_reference_date_2 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
7969: l_array_reference_date_3 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
7970: l_array_reference_date_4 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
7971: l_array_event_created_by XLA_AE_JOURNAL_ENTRY_PKG.t_array_V100L;
7972: l_array_budgetary_control_flag XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L;
7973:
7966: l_array_reference_char_4 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
7967: l_array_reference_date_1 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
7968: l_array_reference_date_2 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
7969: l_array_reference_date_3 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
7970: l_array_reference_date_4 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
7971: l_array_event_created_by XLA_AE_JOURNAL_ENTRY_PKG.t_array_V100L;
7972: l_array_budgetary_control_flag XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L;
7973:
7974: l_event_id NUMBER;
7967: l_array_reference_date_1 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
7968: l_array_reference_date_2 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
7969: l_array_reference_date_3 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
7970: l_array_reference_date_4 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
7971: l_array_event_created_by XLA_AE_JOURNAL_ENTRY_PKG.t_array_V100L;
7972: l_array_budgetary_control_flag XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L;
7973:
7974: l_event_id NUMBER;
7975: l_previous_event_id NUMBER;
7968: l_array_reference_date_2 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
7969: l_array_reference_date_3 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
7970: l_array_reference_date_4 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
7971: l_array_event_created_by XLA_AE_JOURNAL_ENTRY_PKG.t_array_V100L;
7972: l_array_budgetary_control_flag XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L;
7973:
7974: l_event_id NUMBER;
7975: l_previous_event_id NUMBER;
7976: l_first_event_id NUMBER;
7986: l_event_class_name VARCHAR2(80) := 'Treasury Accomplishment';
7987: l_description VARCHAR2(4000);
7988: l_transaction_reversal NUMBER;
7989: l_ae_header_id NUMBER;
7990: l_array_extract_line_num xla_ae_journal_entry_pkg.t_array_Num;
7991: l_log_module VARCHAR2(240);
7992: --
7993: l_acct_reversal_source VARCHAR2(30);
7994: l_trx_reversal_source VARCHAR2(30);
8276:
8277: --
8278: -- set event info as cache for other routines to refer event attributes
8279: --
8280: XLA_AE_JOURNAL_ENTRY_PKG.set_event_info
8281: (p_application_id => p_application_id
8282: ,p_primary_ledger_id => p_primary_ledger_id
8283: ,p_base_ledger_id => p_base_ledger_id
8284: ,p_target_ledger_id => p_target_ledger_id
8309:
8310: --
8311: -- set the status of entry to C_VALID (0)
8312: --
8313: XLA_AE_JOURNAL_ENTRY_PKG.g_global_status := XLA_AE_JOURNAL_ENTRY_PKG.C_VALID;
8314:
8315: --
8316: -- initialize a row for ae header
8317: --
8337: --
8338: -- initilaize the status of ae headers for diffrent balance types
8339: -- the status is initialised to C_NOT_CREATED (2)
8340: --
8341: --g_array_event(l_event_id).array_value_num('actual_je_status') := XLA_AE_JOURNAL_ENTRY_PKG.C_NOT_CREATED;
8342: --g_array_event(l_event_id).array_value_num('budget_je_status') := XLA_AE_JOURNAL_ENTRY_PKG.C_NOT_CREATED;
8343: --g_array_event(l_event_id).array_value_num('encumbrance_je_status') := XLA_AE_JOURNAL_ENTRY_PKG.C_NOT_CREATED;
8344:
8345: --
8338: -- initilaize the status of ae headers for diffrent balance types
8339: -- the status is initialised to C_NOT_CREATED (2)
8340: --
8341: --g_array_event(l_event_id).array_value_num('actual_je_status') := XLA_AE_JOURNAL_ENTRY_PKG.C_NOT_CREATED;
8342: --g_array_event(l_event_id).array_value_num('budget_je_status') := XLA_AE_JOURNAL_ENTRY_PKG.C_NOT_CREATED;
8343: --g_array_event(l_event_id).array_value_num('encumbrance_je_status') := XLA_AE_JOURNAL_ENTRY_PKG.C_NOT_CREATED;
8344:
8345: --
8346: -- call api to validate and store accounting attributes for header
8339: -- the status is initialised to C_NOT_CREATED (2)
8340: --
8341: --g_array_event(l_event_id).array_value_num('actual_je_status') := XLA_AE_JOURNAL_ENTRY_PKG.C_NOT_CREATED;
8342: --g_array_event(l_event_id).array_value_num('budget_je_status') := XLA_AE_JOURNAL_ENTRY_PKG.C_NOT_CREATED;
8343: --g_array_event(l_event_id).array_value_num('encumbrance_je_status') := XLA_AE_JOURNAL_ENTRY_PKG.C_NOT_CREATED;
8344:
8345: --
8346: -- call api to validate and store accounting attributes for header
8347: --
8378: --
8379: l_trx_reversal_source := SUBSTR(NULL, 1,30);
8380:
8381: IF NVL(l_trx_reversal_source, 'N') NOT IN ('N','Y') THEN
8382: xla_ae_journal_entry_pkg.g_global_status := xla_ae_journal_entry_pkg.C_INVALID;
8383:
8384: xla_accounting_err_pkg.build_message
8385: (p_appli_s_name => 'XLA'
8386: ,p_msg_name => 'XLA_AP_INVALID_HDR_ATTR'
8386: ,p_msg_name => 'XLA_AP_INVALID_HDR_ATTR'
8387: ,p_token_1 => 'ACCT_ATTR_NAME'
8388: ,p_value_1 => xla_ae_sources_pkg.GetAccountingSourceName('TRX_ACCT_REVERSAL_OPTION')
8389: ,p_token_2 => 'PRODUCT_NAME'
8390: ,p_value_2 => xla_ae_journal_entry_pkg.g_cache_event.application_name
8391: ,p_entity_id => xla_ae_journal_entry_pkg.g_cache_event.entity_id
8392: ,p_event_id => xla_ae_journal_entry_pkg.g_cache_event.event_id
8393: ,p_ledger_id => xla_ae_journal_entry_pkg.g_cache_event.target_ledger_id);
8394:
8387: ,p_token_1 => 'ACCT_ATTR_NAME'
8388: ,p_value_1 => xla_ae_sources_pkg.GetAccountingSourceName('TRX_ACCT_REVERSAL_OPTION')
8389: ,p_token_2 => 'PRODUCT_NAME'
8390: ,p_value_2 => xla_ae_journal_entry_pkg.g_cache_event.application_name
8391: ,p_entity_id => xla_ae_journal_entry_pkg.g_cache_event.entity_id
8392: ,p_event_id => xla_ae_journal_entry_pkg.g_cache_event.event_id
8393: ,p_ledger_id => xla_ae_journal_entry_pkg.g_cache_event.target_ledger_id);
8394:
8395: ELSIF NVL(l_trx_reversal_source, 'N') = 'Y' THEN
8388: ,p_value_1 => xla_ae_sources_pkg.GetAccountingSourceName('TRX_ACCT_REVERSAL_OPTION')
8389: ,p_token_2 => 'PRODUCT_NAME'
8390: ,p_value_2 => xla_ae_journal_entry_pkg.g_cache_event.application_name
8391: ,p_entity_id => xla_ae_journal_entry_pkg.g_cache_event.entity_id
8392: ,p_event_id => xla_ae_journal_entry_pkg.g_cache_event.event_id
8393: ,p_ledger_id => xla_ae_journal_entry_pkg.g_cache_event.target_ledger_id);
8394:
8395: ELSIF NVL(l_trx_reversal_source, 'N') = 'Y' THEN
8396: --
8389: ,p_token_2 => 'PRODUCT_NAME'
8390: ,p_value_2 => xla_ae_journal_entry_pkg.g_cache_event.application_name
8391: ,p_entity_id => xla_ae_journal_entry_pkg.g_cache_event.entity_id
8392: ,p_event_id => xla_ae_journal_entry_pkg.g_cache_event.event_id
8393: ,p_ledger_id => xla_ae_journal_entry_pkg.g_cache_event.target_ledger_id);
8394:
8395: ELSIF NVL(l_trx_reversal_source, 'N') = 'Y' THEN
8396: --
8397: -- following sets the accounting attributes needed to reverse
8408: ----------------------------------------------------------------
8409: -- 4262811 - update the header statuses to invalid in need be
8410: ----------------------------------------------------------------
8411: --
8412: XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus (p_hdr_idx => hdr_idx);
8413:
8414:
8415: -----------------------------------------------
8416: -- No accrual reversal for the event class/type
8547: ,p_module => l_log_module);
8548: END IF;
8549:
8550: --
8551: -- set the XLA_AE_JOURNAL_ENTRY_PKG.g_global_status to C_VALID (0)
8552: --
8553: XLA_AE_JOURNAL_ENTRY_PKG.g_global_status := XLA_AE_JOURNAL_ENTRY_PKG.C_VALID;
8554: --
8555: -- set event info as cache for other routines to refer event attributes
8549:
8550: --
8551: -- set the XLA_AE_JOURNAL_ENTRY_PKG.g_global_status to C_VALID (0)
8552: --
8553: XLA_AE_JOURNAL_ENTRY_PKG.g_global_status := XLA_AE_JOURNAL_ENTRY_PKG.C_VALID;
8554: --
8555: -- set event info as cache for other routines to refer event attributes
8556: --
8557:
8557:
8558: IF l_event_id <> NVL(l_previous_event_id, -1) THEN
8559: l_previous_event_id := l_event_id;
8560:
8561: XLA_AE_JOURNAL_ENTRY_PKG.set_event_info
8562: (p_application_id => p_application_id
8563: ,p_primary_ledger_id => p_primary_ledger_id
8564: ,p_base_ledger_id => p_base_ledger_id
8565: ,p_target_ledger_id => p_target_ledger_id
8598: l_acct_reversal_source := SUBSTR(NULL, 1,30);
8599:
8600: IF l_continue_with_lines THEN
8601: IF NVL(l_acct_reversal_source, 'N') NOT IN ('N','Y','B') THEN
8602: xla_ae_journal_entry_pkg.g_global_status := xla_ae_journal_entry_pkg.C_INVALID;
8603:
8604: xla_accounting_err_pkg.build_message
8605: (p_appli_s_name => 'XLA'
8606: ,p_msg_name => 'XLA_AP_INVALID_REVERSAL_OPTION'
8606: ,p_msg_name => 'XLA_AP_INVALID_REVERSAL_OPTION'
8607: ,p_token_1 => 'LINE_NUMBER'
8608: ,p_value_1 => l_array_extract_line_num(Idx)
8609: ,p_token_2 => 'PRODUCT_NAME'
8610: ,p_value_2 => xla_ae_journal_entry_pkg.g_cache_event.application_name
8611: ,p_entity_id => xla_ae_journal_entry_pkg.g_cache_event.entity_id
8612: ,p_event_id => xla_ae_journal_entry_pkg.g_cache_event.event_id
8613: ,p_ledger_id => xla_ae_journal_entry_pkg.g_cache_event.target_ledger_id);
8614:
8607: ,p_token_1 => 'LINE_NUMBER'
8608: ,p_value_1 => l_array_extract_line_num(Idx)
8609: ,p_token_2 => 'PRODUCT_NAME'
8610: ,p_value_2 => xla_ae_journal_entry_pkg.g_cache_event.application_name
8611: ,p_entity_id => xla_ae_journal_entry_pkg.g_cache_event.entity_id
8612: ,p_event_id => xla_ae_journal_entry_pkg.g_cache_event.event_id
8613: ,p_ledger_id => xla_ae_journal_entry_pkg.g_cache_event.target_ledger_id);
8614:
8615: ELSIF NVL(l_acct_reversal_source, 'N') IN ('Y','B') THEN
8608: ,p_value_1 => l_array_extract_line_num(Idx)
8609: ,p_token_2 => 'PRODUCT_NAME'
8610: ,p_value_2 => xla_ae_journal_entry_pkg.g_cache_event.application_name
8611: ,p_entity_id => xla_ae_journal_entry_pkg.g_cache_event.entity_id
8612: ,p_event_id => xla_ae_journal_entry_pkg.g_cache_event.event_id
8613: ,p_ledger_id => xla_ae_journal_entry_pkg.g_cache_event.target_ledger_id);
8614:
8615: ELSIF NVL(l_acct_reversal_source, 'N') IN ('Y','B') THEN
8616: --
8609: ,p_token_2 => 'PRODUCT_NAME'
8610: ,p_value_2 => xla_ae_journal_entry_pkg.g_cache_event.application_name
8611: ,p_entity_id => xla_ae_journal_entry_pkg.g_cache_event.entity_id
8612: ,p_event_id => xla_ae_journal_entry_pkg.g_cache_event.event_id
8613: ,p_ledger_id => xla_ae_journal_entry_pkg.g_cache_event.target_ledger_id);
8614:
8615: ELSIF NVL(l_acct_reversal_source, 'N') IN ('Y','B') THEN
8616: --
8617: -- following sets the accounting attributes needed to reverse
8886:
8887: -- only execute it if calculate g/l flag is yes, and primary or secondary ledger
8888: -- or secondary ledger that has different currency with primary
8889: -- or alc that is calculated by sla
8890: IF (((l_calculate_g_l_flag = 'Y' AND XLA_AE_JOURNAL_ENTRY_PKG.g_cache_ledgers_info.ledger_category_code <> 'ALC') or
8891: (XLA_AE_JOURNAL_ENTRY_PKG.g_cache_ledgers_info.ledger_category_code in ('ALC', 'SECONDARY') AND XLA_AE_JOURNAL_ENTRY_PKG.g_cache_ledgers_info.calculate_amts_flag='Y'))
8892:
8893: -- IF((l_calculate_g_l_flag='Y' or XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.target_ledger_id <>
8894: -- XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.ledger_id)
8887: -- only execute it if calculate g/l flag is yes, and primary or secondary ledger
8888: -- or secondary ledger that has different currency with primary
8889: -- or alc that is calculated by sla
8890: IF (((l_calculate_g_l_flag = 'Y' AND XLA_AE_JOURNAL_ENTRY_PKG.g_cache_ledgers_info.ledger_category_code <> 'ALC') or
8891: (XLA_AE_JOURNAL_ENTRY_PKG.g_cache_ledgers_info.ledger_category_code in ('ALC', 'SECONDARY') AND XLA_AE_JOURNAL_ENTRY_PKG.g_cache_ledgers_info.calculate_amts_flag='Y'))
8892:
8893: -- IF((l_calculate_g_l_flag='Y' or XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.target_ledger_id <>
8894: -- XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.ledger_id)
8895: AND (l_actual_flag = 'A')) THEN
8889: -- or alc that is calculated by sla
8890: IF (((l_calculate_g_l_flag = 'Y' AND XLA_AE_JOURNAL_ENTRY_PKG.g_cache_ledgers_info.ledger_category_code <> 'ALC') or
8891: (XLA_AE_JOURNAL_ENTRY_PKG.g_cache_ledgers_info.ledger_category_code in ('ALC', 'SECONDARY') AND XLA_AE_JOURNAL_ENTRY_PKG.g_cache_ledgers_info.calculate_amts_flag='Y'))
8892:
8893: -- IF((l_calculate_g_l_flag='Y' or XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.target_ledger_id <>
8894: -- XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.ledger_id)
8895: AND (l_actual_flag = 'A')) THEN
8896: XLA_AE_LINES_PKG.CreateGainOrLossLines(
8897: p_event_id => xla_ae_journal_entry_pkg.g_cache_event.event_id
8890: IF (((l_calculate_g_l_flag = 'Y' AND XLA_AE_JOURNAL_ENTRY_PKG.g_cache_ledgers_info.ledger_category_code <> 'ALC') or
8891: (XLA_AE_JOURNAL_ENTRY_PKG.g_cache_ledgers_info.ledger_category_code in ('ALC', 'SECONDARY') AND XLA_AE_JOURNAL_ENTRY_PKG.g_cache_ledgers_info.calculate_amts_flag='Y'))
8892:
8893: -- IF((l_calculate_g_l_flag='Y' or XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.target_ledger_id <>
8894: -- XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.ledger_id)
8895: AND (l_actual_flag = 'A')) THEN
8896: XLA_AE_LINES_PKG.CreateGainOrLossLines(
8897: p_event_id => xla_ae_journal_entry_pkg.g_cache_event.event_id
8898: ,p_application_id => p_application_id
8893: -- IF((l_calculate_g_l_flag='Y' or XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.target_ledger_id <>
8894: -- XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.ledger_id)
8895: AND (l_actual_flag = 'A')) THEN
8896: XLA_AE_LINES_PKG.CreateGainOrLossLines(
8897: p_event_id => xla_ae_journal_entry_pkg.g_cache_event.event_id
8898: ,p_application_id => p_application_id
8899: ,p_amb_context_code => 'DEFAULT'
8900: ,p_entity_code => xla_ae_journal_entry_pkg.g_cache_event.entity_code
8901: ,p_event_class_code => C_EVENT_CLASS_CODE
8896: XLA_AE_LINES_PKG.CreateGainOrLossLines(
8897: p_event_id => xla_ae_journal_entry_pkg.g_cache_event.event_id
8898: ,p_application_id => p_application_id
8899: ,p_amb_context_code => 'DEFAULT'
8900: ,p_entity_code => xla_ae_journal_entry_pkg.g_cache_event.entity_code
8901: ,p_event_class_code => C_EVENT_CLASS_CODE
8902: ,p_event_type_code => C_EVENT_TYPE_CODE
8903:
8904: ,p_gain_ccid => -1
9018: ,p_level => C_LEVEL_PROCEDURE
9019: ,p_module => l_log_module);
9020: END IF;
9021:
9022: l_language := xla_ae_journal_entry_pkg.g_cache_ledgers_info.description_language;
9023: l_currency_code := xla_ae_journal_entry_pkg.g_cache_ledgers_info.currency_code;
9024: l_sla_ledger_id := xla_ae_journal_entry_pkg.g_cache_ledgers_info.sla_ledger_id;
9025:
9026: --
9019: ,p_module => l_log_module);
9020: END IF;
9021:
9022: l_language := xla_ae_journal_entry_pkg.g_cache_ledgers_info.description_language;
9023: l_currency_code := xla_ae_journal_entry_pkg.g_cache_ledgers_info.currency_code;
9024: l_sla_ledger_id := xla_ae_journal_entry_pkg.g_cache_ledgers_info.sla_ledger_id;
9025:
9026: --
9027: -- initialize array of lines with NULL
9020: END IF;
9021:
9022: l_language := xla_ae_journal_entry_pkg.g_cache_ledgers_info.description_language;
9023: l_currency_code := xla_ae_journal_entry_pkg.g_cache_ledgers_info.currency_code;
9024: l_sla_ledger_id := xla_ae_journal_entry_pkg.g_cache_ledgers_info.sla_ledger_id;
9025:
9026: --
9027: -- initialize array of lines with NULL
9028: --
9250: ,p_level => C_LEVEL_STATEMENT
9251: ,p_module => l_log_module);
9252: END IF;
9253: --
9254: xla_ae_journal_entry_pkg.SetProductAcctDefinition
9255: (p_product_rule_code => 'FV_STANDARD_AAD'
9256: ,p_product_rule_type_code => 'S'
9257: ,p_product_rule_version => ''
9258: ,p_product_rule_name => 'Federal Financials AAD'
9259: ,p_amb_context_code => 'DEFAULT'
9260: );
9261:
9262: l_array_ledgers :=
9263: xla_ae_journal_entry_pkg.GetAlternateCurrencyLedger
9264: (p_base_ledger_id => p_base_ledger_id);
9265:
9266: FOR Idx IN 1 .. l_array_ledgers.COUNT LOOP
9267: l_temp_result :=
9264: (p_base_ledger_id => p_base_ledger_id);
9265:
9266: FOR Idx IN 1 .. l_array_ledgers.COUNT LOOP
9267: l_temp_result :=
9268: XLA_AE_JOURNAL_ENTRY_PKG.GetLedgersInfo
9269: (p_application_id => p_application_id
9270: ,p_base_ledger_id => p_base_ledger_id
9271: ,p_target_ledger_id => l_array_ledgers(Idx)
9272: ,p_primary_ledger_id => p_primary_ledger_id