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
273: ,p_level => C_LEVEL_PROCEDURE
274: ,p_module => l_log_module);
275: END IF;
276:
277: l_ledger_language := xla_ae_journal_entry_pkg.g_cache_ledgers_info.description_language;
278: l_component_type := 'AMB_DESCRIPTION';
279: l_component_code := 'PN_EXPENSE_DESCRIPTION';
280: l_component_type_code := 'S';
281: l_component_appl_id := 240;
404: ,p_level => C_LEVEL_PROCEDURE
405: ,p_module => l_log_module);
406: END IF;
407:
408: l_ledger_language := xla_ae_journal_entry_pkg.g_cache_ledgers_info.description_language;
409: l_component_type := 'AMB_DESCRIPTION';
410: l_component_code := 'PN_REVENUE_DESCRIPTION';
411: l_component_type_code := 'S';
412: l_component_appl_id := 240;
552: (p_msg => 'END of AcctDerRule_3(invalid)'
553: ,p_level => C_LEVEL_PROCEDURE
554: ,p_module => l_log_module);
555: END IF;
556: xla_ae_journal_entry_pkg.g_global_status := xla_ae_journal_entry_pkg.C_INVALID;
557: x_value_type_code := null;
558: l_output_value := null;
559: xla_accounting_err_pkg.build_message
560: (p_appli_s_name => 'XLA'
572: 'XLA_OWNER_TYPE'
573: ,l_component_type_code
574: )
575: ,p_token_3 => 'PAD_NAME'
576: ,p_value_3 => xla_ae_journal_entry_pkg.g_cache_pad.pad_session_name
577: ,p_token_4 => 'PAD_OWNER'
578: ,p_value_4 => xla_lookups_pkg.get_meaning(
579: 'XLA_OWNER_TYPE'
580: ,xla_ae_journal_entry_pkg.g_cache_pad.product_rule_type_code
576: ,p_value_3 => xla_ae_journal_entry_pkg.g_cache_pad.pad_session_name
577: ,p_token_4 => 'PAD_OWNER'
578: ,p_value_4 => xla_lookups_pkg.get_meaning(
579: 'XLA_OWNER_TYPE'
580: ,xla_ae_journal_entry_pkg.g_cache_pad.product_rule_type_code
581: )
582: ,p_entity_id => xla_ae_journal_entry_pkg.g_cache_event.entity_id
583: ,p_event_id => xla_ae_journal_entry_pkg.g_cache_event.event_id
584: ,p_ledger_id => xla_ae_journal_entry_pkg.g_cache_event.target_ledger_id
578: ,p_value_4 => xla_lookups_pkg.get_meaning(
579: 'XLA_OWNER_TYPE'
580: ,xla_ae_journal_entry_pkg.g_cache_pad.product_rule_type_code
581: )
582: ,p_entity_id => xla_ae_journal_entry_pkg.g_cache_event.entity_id
583: ,p_event_id => xla_ae_journal_entry_pkg.g_cache_event.event_id
584: ,p_ledger_id => xla_ae_journal_entry_pkg.g_cache_event.target_ledger_id
585: ,p_ae_header_id => NULL
586: );
579: 'XLA_OWNER_TYPE'
580: ,xla_ae_journal_entry_pkg.g_cache_pad.product_rule_type_code
581: )
582: ,p_entity_id => xla_ae_journal_entry_pkg.g_cache_event.entity_id
583: ,p_event_id => xla_ae_journal_entry_pkg.g_cache_event.event_id
584: ,p_ledger_id => xla_ae_journal_entry_pkg.g_cache_event.target_ledger_id
585: ,p_ae_header_id => NULL
586: );
587: RETURN l_output_value;
580: ,xla_ae_journal_entry_pkg.g_cache_pad.product_rule_type_code
581: )
582: ,p_entity_id => xla_ae_journal_entry_pkg.g_cache_event.entity_id
583: ,p_event_id => xla_ae_journal_entry_pkg.g_cache_event.event_id
584: ,p_ledger_id => xla_ae_journal_entry_pkg.g_cache_event.target_ledger_id
585: ,p_ae_header_id => NULL
586: );
587: RETURN l_output_value;
588: EXCEPTION
680: l_tmp_amt NUMBER;
681: l_acc_rev_natural_side_code VARCHAR2(1);
682:
683: l_num_entries NUMBER;
684: l_gl_dates xla_ae_journal_entry_pkg.t_array_date;
685: l_accted_amts xla_ae_journal_entry_pkg.t_array_num;
686: l_entered_amts xla_ae_journal_entry_pkg.t_array_num;
687: l_period_names xla_ae_journal_entry_pkg.t_array_V15L;
688: l_recog_line_1 NUMBER;
681: l_acc_rev_natural_side_code VARCHAR2(1);
682:
683: l_num_entries NUMBER;
684: l_gl_dates xla_ae_journal_entry_pkg.t_array_date;
685: l_accted_amts xla_ae_journal_entry_pkg.t_array_num;
686: l_entered_amts xla_ae_journal_entry_pkg.t_array_num;
687: l_period_names xla_ae_journal_entry_pkg.t_array_V15L;
688: l_recog_line_1 NUMBER;
689: l_recog_line_2 NUMBER;
682:
683: l_num_entries NUMBER;
684: l_gl_dates xla_ae_journal_entry_pkg.t_array_date;
685: l_accted_amts xla_ae_journal_entry_pkg.t_array_num;
686: l_entered_amts xla_ae_journal_entry_pkg.t_array_num;
687: l_period_names xla_ae_journal_entry_pkg.t_array_V15L;
688: l_recog_line_1 NUMBER;
689: l_recog_line_2 NUMBER;
690:
683: l_num_entries NUMBER;
684: l_gl_dates xla_ae_journal_entry_pkg.t_array_date;
685: l_accted_amts xla_ae_journal_entry_pkg.t_array_num;
686: l_entered_amts xla_ae_journal_entry_pkg.t_array_num;
687: l_period_names xla_ae_journal_entry_pkg.t_array_V15L;
688: l_recog_line_1 NUMBER;
689: l_recog_line_2 NUMBER;
690:
691: l_bflow_applied_to_amt_idx NUMBER; -- 5132302
689: l_recog_line_2 NUMBER;
690:
691: l_bflow_applied_to_amt_idx NUMBER; -- 5132302
692: l_bflow_applied_to_amt NUMBER; -- 5132302
693: l_bflow_applied_to_amts xla_ae_journal_entry_pkg.t_array_num; -- 5132302
694:
695: l_event_id NUMBER; -- To handle MPA header Description: xla_ae_header_pkg.SetHdrDescription
696:
697: --l_rounding_ccy VARCHAR2(15); -- To handle MPA rounding 4262811b
764: l_accrual_line_num := NULL; -- 4262811
765: l_tmp_amt := NULL; -- 4262811
766: --
767:
768: IF XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.target_ledger_id = XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.ledger_id OR
769: l_balance_type_code <> 'B' THEN
770: IF NVL(p_source_11,'
771: ') = 'ACC'
772: THEN
836: --
837: XLA_AE_LINES_PKG.g_rec_lines.array_balance_type_code(XLA_AE_LINES_PKG.g_LineNumber) := l_balance_type_code;
838:
839: XLA_AE_LINES_PKG.g_rec_lines.array_ledger_id(XLA_AE_LINES_PKG.g_LineNumber) :=
840: XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.target_ledger_id;
841:
842: -- 4955764
843: XLA_AE_LINES_PKG.g_rec_lines.array_gl_date(XLA_AE_LINES_PKG.g_LineNumber) :=
844: XLA_AE_HEADER_PKG.g_rec_header_new.array_gl_date(g_array_event(p_event_id).array_value_num('header_index'));
880: l_enc_upg_option := XLA_AE_LINES_PKG.g_rec_lines.array_enc_upg_option(XLA_AE_LINES_PKG.g_LineNumber);
881:
882: IF xla_accounting_cache_pkg.GetValueChar
883: (p_source_code => 'LEDGER_CATEGORY_CODE'
884: ,p_target_ledger_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.target_ledger_id) IN ('PRIMARY','ALC')
885: AND l_bflow_method_code = 'PRIOR_ENTRY'
886: -- AND (l_actual_upg_option = 'Y' OR l_enc_upg_option = 'Y') Bug 4922099
887: AND ( (NVL(l_actual_upg_option, 'N') IN ('Y', 'O')) OR
888: (NVL(l_enc_upg_option, 'N') IN ('Y', 'O'))
996: p_lookup_type => 'XLA_OWNER_TYPE'
997: ,p_lookup_code => l_component_type_code
998: )
999: ,p_token_4 => 'PRODUCT_NAME'
1000: ,p_value_4 => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.application_name
1001: ,p_entity_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.entity_id
1002: ,p_event_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.event_id
1003: ,p_ledger_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.target_ledger_id
1004: ,p_ae_header_id => NULL
997: ,p_lookup_code => l_component_type_code
998: )
999: ,p_token_4 => 'PRODUCT_NAME'
1000: ,p_value_4 => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.application_name
1001: ,p_entity_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.entity_id
1002: ,p_event_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.event_id
1003: ,p_ledger_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.target_ledger_id
1004: ,p_ae_header_id => NULL
1005: );
998: )
999: ,p_token_4 => 'PRODUCT_NAME'
1000: ,p_value_4 => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.application_name
1001: ,p_entity_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.entity_id
1002: ,p_event_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.event_id
1003: ,p_ledger_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.target_ledger_id
1004: ,p_ae_header_id => NULL
1005: );
1006:
999: ,p_token_4 => 'PRODUCT_NAME'
1000: ,p_value_4 => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.application_name
1001: ,p_entity_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.entity_id
1002: ,p_event_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.event_id
1003: ,p_ledger_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.target_ledger_id
1004: ,p_ae_header_id => NULL
1005: );
1006:
1007: IF (C_LEVEL_ERROR>= g_log_level) THEN
1030: ----------------------------------------------------------------------------------
1031: -- 4219869 Business Flow
1032: -- Update journal entry status -- Need to generate this within IF
1033: ----------------------------------------------------------------------------------
1034: XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
1035: (p_hdr_idx => g_array_event(p_event_id).array_value_num('header_index')
1036: ,p_balance_type_code => l_balance_type_code
1037: );
1038:
1117:
1118: --
1119: -- Depending on the Reversal Method setup, do a switch side or changes sign for the amounts
1120: --
1121: IF (XLA_AE_JOURNAL_ENTRY_PKG.g_cache_ledgers_info.ledger_reversal_option = 'SIDE') THEN
1122: XLA_AE_LINES_PKG.g_rec_lines.array_natural_side_code(XLA_AE_LINES_PKG.g_LineNumber) := l_acc_rev_natural_side_code;
1123: ELSE
1124: ---------------------------------------------------------------------------------------------------
1125: -- 4262811a Switch Sign
1142:
1143: XLA_AE_LINES_PKG.ValidateCurrentLine;
1144: XLA_AE_LINES_PKG.SetDebitCreditAmounts;
1145:
1146: XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
1147: (p_hdr_idx => g_array_event(p_event_id).array_value_num('acc_rev_header_index')
1148: ,p_balance_type_code => l_balance_type_code);
1149:
1150: END IF;
1262: l_tmp_amt NUMBER;
1263: l_acc_rev_natural_side_code VARCHAR2(1);
1264:
1265: l_num_entries NUMBER;
1266: l_gl_dates xla_ae_journal_entry_pkg.t_array_date;
1267: l_accted_amts xla_ae_journal_entry_pkg.t_array_num;
1268: l_entered_amts xla_ae_journal_entry_pkg.t_array_num;
1269: l_period_names xla_ae_journal_entry_pkg.t_array_V15L;
1270: l_recog_line_1 NUMBER;
1263: l_acc_rev_natural_side_code VARCHAR2(1);
1264:
1265: l_num_entries NUMBER;
1266: l_gl_dates xla_ae_journal_entry_pkg.t_array_date;
1267: l_accted_amts xla_ae_journal_entry_pkg.t_array_num;
1268: l_entered_amts xla_ae_journal_entry_pkg.t_array_num;
1269: l_period_names xla_ae_journal_entry_pkg.t_array_V15L;
1270: l_recog_line_1 NUMBER;
1271: l_recog_line_2 NUMBER;
1264:
1265: l_num_entries NUMBER;
1266: l_gl_dates xla_ae_journal_entry_pkg.t_array_date;
1267: l_accted_amts xla_ae_journal_entry_pkg.t_array_num;
1268: l_entered_amts xla_ae_journal_entry_pkg.t_array_num;
1269: l_period_names xla_ae_journal_entry_pkg.t_array_V15L;
1270: l_recog_line_1 NUMBER;
1271: l_recog_line_2 NUMBER;
1272:
1265: l_num_entries NUMBER;
1266: l_gl_dates xla_ae_journal_entry_pkg.t_array_date;
1267: l_accted_amts xla_ae_journal_entry_pkg.t_array_num;
1268: l_entered_amts xla_ae_journal_entry_pkg.t_array_num;
1269: l_period_names xla_ae_journal_entry_pkg.t_array_V15L;
1270: l_recog_line_1 NUMBER;
1271: l_recog_line_2 NUMBER;
1272:
1273: l_bflow_applied_to_amt_idx NUMBER; -- 5132302
1271: l_recog_line_2 NUMBER;
1272:
1273: l_bflow_applied_to_amt_idx NUMBER; -- 5132302
1274: l_bflow_applied_to_amt NUMBER; -- 5132302
1275: l_bflow_applied_to_amts xla_ae_journal_entry_pkg.t_array_num; -- 5132302
1276:
1277: l_event_id NUMBER; -- To handle MPA header Description: xla_ae_header_pkg.SetHdrDescription
1278:
1279: --l_rounding_ccy VARCHAR2(15); -- To handle MPA rounding 4262811b
1346: l_accrual_line_num := NULL; -- 4262811
1347: l_tmp_amt := NULL; -- 4262811
1348: --
1349:
1350: IF XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.target_ledger_id = XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.ledger_id OR
1351: l_balance_type_code <> 'B' THEN
1352: IF NVL(p_source_11,'
1353: ') = 'UNEARN'
1354: THEN
1418: --
1419: XLA_AE_LINES_PKG.g_rec_lines.array_balance_type_code(XLA_AE_LINES_PKG.g_LineNumber) := l_balance_type_code;
1420:
1421: XLA_AE_LINES_PKG.g_rec_lines.array_ledger_id(XLA_AE_LINES_PKG.g_LineNumber) :=
1422: XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.target_ledger_id;
1423:
1424: -- 4955764
1425: XLA_AE_LINES_PKG.g_rec_lines.array_gl_date(XLA_AE_LINES_PKG.g_LineNumber) :=
1426: XLA_AE_HEADER_PKG.g_rec_header_new.array_gl_date(g_array_event(p_event_id).array_value_num('header_index'));
1462: l_enc_upg_option := XLA_AE_LINES_PKG.g_rec_lines.array_enc_upg_option(XLA_AE_LINES_PKG.g_LineNumber);
1463:
1464: IF xla_accounting_cache_pkg.GetValueChar
1465: (p_source_code => 'LEDGER_CATEGORY_CODE'
1466: ,p_target_ledger_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.target_ledger_id) IN ('PRIMARY','ALC')
1467: AND l_bflow_method_code = 'PRIOR_ENTRY'
1468: -- AND (l_actual_upg_option = 'Y' OR l_enc_upg_option = 'Y') Bug 4922099
1469: AND ( (NVL(l_actual_upg_option, 'N') IN ('Y', 'O')) OR
1470: (NVL(l_enc_upg_option, 'N') IN ('Y', 'O'))
1578: p_lookup_type => 'XLA_OWNER_TYPE'
1579: ,p_lookup_code => l_component_type_code
1580: )
1581: ,p_token_4 => 'PRODUCT_NAME'
1582: ,p_value_4 => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.application_name
1583: ,p_entity_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.entity_id
1584: ,p_event_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.event_id
1585: ,p_ledger_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.target_ledger_id
1586: ,p_ae_header_id => NULL
1579: ,p_lookup_code => l_component_type_code
1580: )
1581: ,p_token_4 => 'PRODUCT_NAME'
1582: ,p_value_4 => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.application_name
1583: ,p_entity_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.entity_id
1584: ,p_event_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.event_id
1585: ,p_ledger_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.target_ledger_id
1586: ,p_ae_header_id => NULL
1587: );
1580: )
1581: ,p_token_4 => 'PRODUCT_NAME'
1582: ,p_value_4 => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.application_name
1583: ,p_entity_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.entity_id
1584: ,p_event_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.event_id
1585: ,p_ledger_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.target_ledger_id
1586: ,p_ae_header_id => NULL
1587: );
1588:
1581: ,p_token_4 => 'PRODUCT_NAME'
1582: ,p_value_4 => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.application_name
1583: ,p_entity_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.entity_id
1584: ,p_event_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.event_id
1585: ,p_ledger_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.target_ledger_id
1586: ,p_ae_header_id => NULL
1587: );
1588:
1589: IF (C_LEVEL_ERROR>= g_log_level) THEN
1612: ----------------------------------------------------------------------------------
1613: -- 4219869 Business Flow
1614: -- Update journal entry status -- Need to generate this within IF
1615: ----------------------------------------------------------------------------------
1616: XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
1617: (p_hdr_idx => g_array_event(p_event_id).array_value_num('header_index')
1618: ,p_balance_type_code => l_balance_type_code
1619: );
1620:
1699:
1700: --
1701: -- Depending on the Reversal Method setup, do a switch side or changes sign for the amounts
1702: --
1703: IF (XLA_AE_JOURNAL_ENTRY_PKG.g_cache_ledgers_info.ledger_reversal_option = 'SIDE') THEN
1704: XLA_AE_LINES_PKG.g_rec_lines.array_natural_side_code(XLA_AE_LINES_PKG.g_LineNumber) := l_acc_rev_natural_side_code;
1705: ELSE
1706: ---------------------------------------------------------------------------------------------------
1707: -- 4262811a Switch Sign
1724:
1725: XLA_AE_LINES_PKG.ValidateCurrentLine;
1726: XLA_AE_LINES_PKG.SetDebitCreditAmounts;
1727:
1728: XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
1729: (p_hdr_idx => g_array_event(p_event_id).array_value_num('acc_rev_header_index')
1730: ,p_balance_type_code => l_balance_type_code);
1731:
1732: END IF;
1844: l_tmp_amt NUMBER;
1845: l_acc_rev_natural_side_code VARCHAR2(1);
1846:
1847: l_num_entries NUMBER;
1848: l_gl_dates xla_ae_journal_entry_pkg.t_array_date;
1849: l_accted_amts xla_ae_journal_entry_pkg.t_array_num;
1850: l_entered_amts xla_ae_journal_entry_pkg.t_array_num;
1851: l_period_names xla_ae_journal_entry_pkg.t_array_V15L;
1852: l_recog_line_1 NUMBER;
1845: l_acc_rev_natural_side_code VARCHAR2(1);
1846:
1847: l_num_entries NUMBER;
1848: l_gl_dates xla_ae_journal_entry_pkg.t_array_date;
1849: l_accted_amts xla_ae_journal_entry_pkg.t_array_num;
1850: l_entered_amts xla_ae_journal_entry_pkg.t_array_num;
1851: l_period_names xla_ae_journal_entry_pkg.t_array_V15L;
1852: l_recog_line_1 NUMBER;
1853: l_recog_line_2 NUMBER;
1846:
1847: l_num_entries NUMBER;
1848: l_gl_dates xla_ae_journal_entry_pkg.t_array_date;
1849: l_accted_amts xla_ae_journal_entry_pkg.t_array_num;
1850: l_entered_amts xla_ae_journal_entry_pkg.t_array_num;
1851: l_period_names xla_ae_journal_entry_pkg.t_array_V15L;
1852: l_recog_line_1 NUMBER;
1853: l_recog_line_2 NUMBER;
1854:
1847: l_num_entries NUMBER;
1848: l_gl_dates xla_ae_journal_entry_pkg.t_array_date;
1849: l_accted_amts xla_ae_journal_entry_pkg.t_array_num;
1850: l_entered_amts xla_ae_journal_entry_pkg.t_array_num;
1851: l_period_names xla_ae_journal_entry_pkg.t_array_V15L;
1852: l_recog_line_1 NUMBER;
1853: l_recog_line_2 NUMBER;
1854:
1855: l_bflow_applied_to_amt_idx NUMBER; -- 5132302
1853: l_recog_line_2 NUMBER;
1854:
1855: l_bflow_applied_to_amt_idx NUMBER; -- 5132302
1856: l_bflow_applied_to_amt NUMBER; -- 5132302
1857: l_bflow_applied_to_amts xla_ae_journal_entry_pkg.t_array_num; -- 5132302
1858:
1859: l_event_id NUMBER; -- To handle MPA header Description: xla_ae_header_pkg.SetHdrDescription
1860:
1861: --l_rounding_ccy VARCHAR2(15); -- To handle MPA rounding 4262811b
1928: l_accrual_line_num := NULL; -- 4262811
1929: l_tmp_amt := NULL; -- 4262811
1930: --
1931:
1932: IF XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.target_ledger_id = XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.ledger_id OR
1933: l_balance_type_code <> 'B' THEN
1934: IF NVL(p_source_11,'
1935: ') = 'EXP'
1936: THEN
2000: --
2001: XLA_AE_LINES_PKG.g_rec_lines.array_balance_type_code(XLA_AE_LINES_PKG.g_LineNumber) := l_balance_type_code;
2002:
2003: XLA_AE_LINES_PKG.g_rec_lines.array_ledger_id(XLA_AE_LINES_PKG.g_LineNumber) :=
2004: XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.target_ledger_id;
2005:
2006: -- 4955764
2007: XLA_AE_LINES_PKG.g_rec_lines.array_gl_date(XLA_AE_LINES_PKG.g_LineNumber) :=
2008: XLA_AE_HEADER_PKG.g_rec_header_new.array_gl_date(g_array_event(p_event_id).array_value_num('header_index'));
2044: l_enc_upg_option := XLA_AE_LINES_PKG.g_rec_lines.array_enc_upg_option(XLA_AE_LINES_PKG.g_LineNumber);
2045:
2046: IF xla_accounting_cache_pkg.GetValueChar
2047: (p_source_code => 'LEDGER_CATEGORY_CODE'
2048: ,p_target_ledger_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.target_ledger_id) IN ('PRIMARY','ALC')
2049: AND l_bflow_method_code = 'PRIOR_ENTRY'
2050: -- AND (l_actual_upg_option = 'Y' OR l_enc_upg_option = 'Y') Bug 4922099
2051: AND ( (NVL(l_actual_upg_option, 'N') IN ('Y', 'O')) OR
2052: (NVL(l_enc_upg_option, 'N') IN ('Y', 'O'))
2160: p_lookup_type => 'XLA_OWNER_TYPE'
2161: ,p_lookup_code => l_component_type_code
2162: )
2163: ,p_token_4 => 'PRODUCT_NAME'
2164: ,p_value_4 => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.application_name
2165: ,p_entity_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.entity_id
2166: ,p_event_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.event_id
2167: ,p_ledger_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.target_ledger_id
2168: ,p_ae_header_id => NULL
2161: ,p_lookup_code => l_component_type_code
2162: )
2163: ,p_token_4 => 'PRODUCT_NAME'
2164: ,p_value_4 => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.application_name
2165: ,p_entity_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.entity_id
2166: ,p_event_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.event_id
2167: ,p_ledger_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.target_ledger_id
2168: ,p_ae_header_id => NULL
2169: );
2162: )
2163: ,p_token_4 => 'PRODUCT_NAME'
2164: ,p_value_4 => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.application_name
2165: ,p_entity_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.entity_id
2166: ,p_event_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.event_id
2167: ,p_ledger_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.target_ledger_id
2168: ,p_ae_header_id => NULL
2169: );
2170:
2163: ,p_token_4 => 'PRODUCT_NAME'
2164: ,p_value_4 => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.application_name
2165: ,p_entity_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.entity_id
2166: ,p_event_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.event_id
2167: ,p_ledger_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.target_ledger_id
2168: ,p_ae_header_id => NULL
2169: );
2170:
2171: IF (C_LEVEL_ERROR>= g_log_level) THEN
2194: ----------------------------------------------------------------------------------
2195: -- 4219869 Business Flow
2196: -- Update journal entry status -- Need to generate this within IF
2197: ----------------------------------------------------------------------------------
2198: XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
2199: (p_hdr_idx => g_array_event(p_event_id).array_value_num('header_index')
2200: ,p_balance_type_code => l_balance_type_code
2201: );
2202:
2281:
2282: --
2283: -- Depending on the Reversal Method setup, do a switch side or changes sign for the amounts
2284: --
2285: IF (XLA_AE_JOURNAL_ENTRY_PKG.g_cache_ledgers_info.ledger_reversal_option = 'SIDE') THEN
2286: XLA_AE_LINES_PKG.g_rec_lines.array_natural_side_code(XLA_AE_LINES_PKG.g_LineNumber) := l_acc_rev_natural_side_code;
2287: ELSE
2288: ---------------------------------------------------------------------------------------------------
2289: -- 4262811a Switch Sign
2306:
2307: XLA_AE_LINES_PKG.ValidateCurrentLine;
2308: XLA_AE_LINES_PKG.SetDebitCreditAmounts;
2309:
2310: XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
2311: (p_hdr_idx => g_array_event(p_event_id).array_value_num('acc_rev_header_index')
2312: ,p_balance_type_code => l_balance_type_code);
2313:
2314: END IF;
2426: l_tmp_amt NUMBER;
2427: l_acc_rev_natural_side_code VARCHAR2(1);
2428:
2429: l_num_entries NUMBER;
2430: l_gl_dates xla_ae_journal_entry_pkg.t_array_date;
2431: l_accted_amts xla_ae_journal_entry_pkg.t_array_num;
2432: l_entered_amts xla_ae_journal_entry_pkg.t_array_num;
2433: l_period_names xla_ae_journal_entry_pkg.t_array_V15L;
2434: l_recog_line_1 NUMBER;
2427: l_acc_rev_natural_side_code VARCHAR2(1);
2428:
2429: l_num_entries NUMBER;
2430: l_gl_dates xla_ae_journal_entry_pkg.t_array_date;
2431: l_accted_amts xla_ae_journal_entry_pkg.t_array_num;
2432: l_entered_amts xla_ae_journal_entry_pkg.t_array_num;
2433: l_period_names xla_ae_journal_entry_pkg.t_array_V15L;
2434: l_recog_line_1 NUMBER;
2435: l_recog_line_2 NUMBER;
2428:
2429: l_num_entries NUMBER;
2430: l_gl_dates xla_ae_journal_entry_pkg.t_array_date;
2431: l_accted_amts xla_ae_journal_entry_pkg.t_array_num;
2432: l_entered_amts xla_ae_journal_entry_pkg.t_array_num;
2433: l_period_names xla_ae_journal_entry_pkg.t_array_V15L;
2434: l_recog_line_1 NUMBER;
2435: l_recog_line_2 NUMBER;
2436:
2429: l_num_entries NUMBER;
2430: l_gl_dates xla_ae_journal_entry_pkg.t_array_date;
2431: l_accted_amts xla_ae_journal_entry_pkg.t_array_num;
2432: l_entered_amts xla_ae_journal_entry_pkg.t_array_num;
2433: l_period_names xla_ae_journal_entry_pkg.t_array_V15L;
2434: l_recog_line_1 NUMBER;
2435: l_recog_line_2 NUMBER;
2436:
2437: l_bflow_applied_to_amt_idx NUMBER; -- 5132302
2435: l_recog_line_2 NUMBER;
2436:
2437: l_bflow_applied_to_amt_idx NUMBER; -- 5132302
2438: l_bflow_applied_to_amt NUMBER; -- 5132302
2439: l_bflow_applied_to_amts xla_ae_journal_entry_pkg.t_array_num; -- 5132302
2440:
2441: l_event_id NUMBER; -- To handle MPA header Description: xla_ae_header_pkg.SetHdrDescription
2442:
2443: --l_rounding_ccy VARCHAR2(15); -- To handle MPA rounding 4262811b
2510: l_accrual_line_num := NULL; -- 4262811
2511: l_tmp_amt := NULL; -- 4262811
2512: --
2513:
2514: IF XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.target_ledger_id = XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.ledger_id OR
2515: l_balance_type_code <> 'B' THEN
2516: IF NVL(p_source_11,'
2517: ') = 'REV'
2518: THEN
2582: --
2583: XLA_AE_LINES_PKG.g_rec_lines.array_balance_type_code(XLA_AE_LINES_PKG.g_LineNumber) := l_balance_type_code;
2584:
2585: XLA_AE_LINES_PKG.g_rec_lines.array_ledger_id(XLA_AE_LINES_PKG.g_LineNumber) :=
2586: XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.target_ledger_id;
2587:
2588: -- 4955764
2589: XLA_AE_LINES_PKG.g_rec_lines.array_gl_date(XLA_AE_LINES_PKG.g_LineNumber) :=
2590: XLA_AE_HEADER_PKG.g_rec_header_new.array_gl_date(g_array_event(p_event_id).array_value_num('header_index'));
2626: l_enc_upg_option := XLA_AE_LINES_PKG.g_rec_lines.array_enc_upg_option(XLA_AE_LINES_PKG.g_LineNumber);
2627:
2628: IF xla_accounting_cache_pkg.GetValueChar
2629: (p_source_code => 'LEDGER_CATEGORY_CODE'
2630: ,p_target_ledger_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.target_ledger_id) IN ('PRIMARY','ALC')
2631: AND l_bflow_method_code = 'PRIOR_ENTRY'
2632: -- AND (l_actual_upg_option = 'Y' OR l_enc_upg_option = 'Y') Bug 4922099
2633: AND ( (NVL(l_actual_upg_option, 'N') IN ('Y', 'O')) OR
2634: (NVL(l_enc_upg_option, 'N') IN ('Y', 'O'))
2742: p_lookup_type => 'XLA_OWNER_TYPE'
2743: ,p_lookup_code => l_component_type_code
2744: )
2745: ,p_token_4 => 'PRODUCT_NAME'
2746: ,p_value_4 => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.application_name
2747: ,p_entity_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.entity_id
2748: ,p_event_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.event_id
2749: ,p_ledger_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.target_ledger_id
2750: ,p_ae_header_id => NULL
2743: ,p_lookup_code => l_component_type_code
2744: )
2745: ,p_token_4 => 'PRODUCT_NAME'
2746: ,p_value_4 => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.application_name
2747: ,p_entity_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.entity_id
2748: ,p_event_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.event_id
2749: ,p_ledger_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.target_ledger_id
2750: ,p_ae_header_id => NULL
2751: );
2744: )
2745: ,p_token_4 => 'PRODUCT_NAME'
2746: ,p_value_4 => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.application_name
2747: ,p_entity_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.entity_id
2748: ,p_event_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.event_id
2749: ,p_ledger_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.target_ledger_id
2750: ,p_ae_header_id => NULL
2751: );
2752:
2745: ,p_token_4 => 'PRODUCT_NAME'
2746: ,p_value_4 => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.application_name
2747: ,p_entity_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.entity_id
2748: ,p_event_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.event_id
2749: ,p_ledger_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.target_ledger_id
2750: ,p_ae_header_id => NULL
2751: );
2752:
2753: IF (C_LEVEL_ERROR>= g_log_level) THEN
2776: ----------------------------------------------------------------------------------
2777: -- 4219869 Business Flow
2778: -- Update journal entry status -- Need to generate this within IF
2779: ----------------------------------------------------------------------------------
2780: XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
2781: (p_hdr_idx => g_array_event(p_event_id).array_value_num('header_index')
2782: ,p_balance_type_code => l_balance_type_code
2783: );
2784:
2863:
2864: --
2865: -- Depending on the Reversal Method setup, do a switch side or changes sign for the amounts
2866: --
2867: IF (XLA_AE_JOURNAL_ENTRY_PKG.g_cache_ledgers_info.ledger_reversal_option = 'SIDE') THEN
2868: XLA_AE_LINES_PKG.g_rec_lines.array_natural_side_code(XLA_AE_LINES_PKG.g_LineNumber) := l_acc_rev_natural_side_code;
2869: ELSE
2870: ---------------------------------------------------------------------------------------------------
2871: -- 4262811a Switch Sign
2888:
2889: XLA_AE_LINES_PKG.ValidateCurrentLine;
2890: XLA_AE_LINES_PKG.SetDebitCreditAmounts;
2891:
2892: XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
2893: (p_hdr_idx => g_array_event(p_event_id).array_value_num('acc_rev_header_index')
2894: ,p_balance_type_code => l_balance_type_code);
2895:
2896: END IF;
3291:
3292: l_calculate_acctd_flag VARCHAR2(1) :='N';
3293: l_calculate_g_l_flag VARCHAR2(1) :='N';
3294: --
3295: l_array_legal_entity_id XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
3296: l_array_entity_id XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
3297: l_array_entity_code XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L;
3298: l_array_transaction_num XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
3299: l_array_event_id XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
3292: l_calculate_acctd_flag VARCHAR2(1) :='N';
3293: l_calculate_g_l_flag VARCHAR2(1) :='N';
3294: --
3295: l_array_legal_entity_id XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
3296: l_array_entity_id XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
3297: l_array_entity_code XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L;
3298: l_array_transaction_num XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
3299: l_array_event_id XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
3300: l_array_class_code XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L;
3293: l_calculate_g_l_flag VARCHAR2(1) :='N';
3294: --
3295: l_array_legal_entity_id XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
3296: l_array_entity_id XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
3297: l_array_entity_code XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L;
3298: l_array_transaction_num XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
3299: l_array_event_id XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
3300: l_array_class_code XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L;
3301: l_array_event_type XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L;
3294: --
3295: l_array_legal_entity_id XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
3296: l_array_entity_id XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
3297: l_array_entity_code XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L;
3298: l_array_transaction_num XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
3299: l_array_event_id XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
3300: l_array_class_code XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L;
3301: l_array_event_type XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L;
3302: l_array_event_number XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
3295: l_array_legal_entity_id XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
3296: l_array_entity_id XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
3297: l_array_entity_code XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L;
3298: l_array_transaction_num XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
3299: l_array_event_id XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
3300: l_array_class_code XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L;
3301: l_array_event_type XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L;
3302: l_array_event_number XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
3303: l_array_event_date XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
3296: l_array_entity_id XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
3297: l_array_entity_code XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L;
3298: l_array_transaction_num XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
3299: l_array_event_id XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
3300: l_array_class_code XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L;
3301: l_array_event_type XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L;
3302: l_array_event_number XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
3303: l_array_event_date XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
3304: l_array_transaction_date XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
3297: l_array_entity_code XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L;
3298: l_array_transaction_num XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
3299: l_array_event_id XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
3300: l_array_class_code XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L;
3301: l_array_event_type XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L;
3302: l_array_event_number XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
3303: l_array_event_date XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
3304: l_array_transaction_date XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
3305: l_array_reference_num_1 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
3298: l_array_transaction_num XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
3299: l_array_event_id XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
3300: l_array_class_code XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L;
3301: l_array_event_type XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L;
3302: l_array_event_number XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
3303: l_array_event_date XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
3304: l_array_transaction_date XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
3305: l_array_reference_num_1 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
3306: l_array_reference_num_2 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
3299: l_array_event_id XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
3300: l_array_class_code XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L;
3301: l_array_event_type XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L;
3302: l_array_event_number XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
3303: l_array_event_date XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
3304: l_array_transaction_date XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
3305: l_array_reference_num_1 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
3306: l_array_reference_num_2 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
3307: l_array_reference_num_3 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
3300: l_array_class_code XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L;
3301: l_array_event_type XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L;
3302: l_array_event_number XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
3303: l_array_event_date XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
3304: l_array_transaction_date XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
3305: l_array_reference_num_1 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
3306: l_array_reference_num_2 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
3307: l_array_reference_num_3 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
3308: l_array_reference_num_4 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
3301: l_array_event_type XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L;
3302: l_array_event_number XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
3303: l_array_event_date XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
3304: l_array_transaction_date XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
3305: l_array_reference_num_1 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
3306: l_array_reference_num_2 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
3307: l_array_reference_num_3 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
3308: l_array_reference_num_4 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
3309: l_array_reference_char_1 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
3302: l_array_event_number XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
3303: l_array_event_date XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
3304: l_array_transaction_date XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
3305: l_array_reference_num_1 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
3306: l_array_reference_num_2 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
3307: l_array_reference_num_3 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
3308: l_array_reference_num_4 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
3309: l_array_reference_char_1 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
3310: l_array_reference_char_2 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
3303: l_array_event_date XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
3304: l_array_transaction_date XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
3305: l_array_reference_num_1 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
3306: l_array_reference_num_2 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
3307: l_array_reference_num_3 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
3308: l_array_reference_num_4 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
3309: l_array_reference_char_1 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
3310: l_array_reference_char_2 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
3311: l_array_reference_char_3 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
3304: l_array_transaction_date XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
3305: l_array_reference_num_1 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
3306: l_array_reference_num_2 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
3307: l_array_reference_num_3 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
3308: l_array_reference_num_4 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
3309: l_array_reference_char_1 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
3310: l_array_reference_char_2 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
3311: l_array_reference_char_3 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
3312: l_array_reference_char_4 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
3305: l_array_reference_num_1 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
3306: l_array_reference_num_2 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
3307: l_array_reference_num_3 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
3308: l_array_reference_num_4 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
3309: l_array_reference_char_1 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
3310: l_array_reference_char_2 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
3311: l_array_reference_char_3 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
3312: l_array_reference_char_4 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
3313: l_array_reference_date_1 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
3306: l_array_reference_num_2 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
3307: l_array_reference_num_3 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
3308: l_array_reference_num_4 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
3309: l_array_reference_char_1 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
3310: l_array_reference_char_2 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
3311: l_array_reference_char_3 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
3312: l_array_reference_char_4 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
3313: l_array_reference_date_1 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
3314: l_array_reference_date_2 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
3307: l_array_reference_num_3 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
3308: l_array_reference_num_4 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
3309: l_array_reference_char_1 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
3310: l_array_reference_char_2 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
3311: l_array_reference_char_3 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
3312: l_array_reference_char_4 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
3313: l_array_reference_date_1 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
3314: l_array_reference_date_2 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
3315: l_array_reference_date_3 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
3308: l_array_reference_num_4 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
3309: l_array_reference_char_1 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
3310: l_array_reference_char_2 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
3311: l_array_reference_char_3 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
3312: l_array_reference_char_4 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
3313: l_array_reference_date_1 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
3314: l_array_reference_date_2 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
3315: l_array_reference_date_3 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
3316: l_array_reference_date_4 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
3309: l_array_reference_char_1 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
3310: l_array_reference_char_2 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
3311: l_array_reference_char_3 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
3312: l_array_reference_char_4 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
3313: l_array_reference_date_1 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
3314: l_array_reference_date_2 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
3315: l_array_reference_date_3 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
3316: l_array_reference_date_4 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
3317: l_array_event_created_by XLA_AE_JOURNAL_ENTRY_PKG.t_array_V100L;
3310: l_array_reference_char_2 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
3311: l_array_reference_char_3 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
3312: l_array_reference_char_4 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
3313: l_array_reference_date_1 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
3314: l_array_reference_date_2 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
3315: l_array_reference_date_3 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
3316: l_array_reference_date_4 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
3317: l_array_event_created_by XLA_AE_JOURNAL_ENTRY_PKG.t_array_V100L;
3318: l_array_budgetary_control_flag XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L;
3311: l_array_reference_char_3 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
3312: l_array_reference_char_4 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
3313: l_array_reference_date_1 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
3314: l_array_reference_date_2 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
3315: l_array_reference_date_3 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
3316: l_array_reference_date_4 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
3317: l_array_event_created_by XLA_AE_JOURNAL_ENTRY_PKG.t_array_V100L;
3318: l_array_budgetary_control_flag XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L;
3319: l_array_header_events XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num; --added
3312: l_array_reference_char_4 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
3313: l_array_reference_date_1 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
3314: l_array_reference_date_2 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
3315: l_array_reference_date_3 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
3316: l_array_reference_date_4 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
3317: l_array_event_created_by XLA_AE_JOURNAL_ENTRY_PKG.t_array_V100L;
3318: l_array_budgetary_control_flag XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L;
3319: l_array_header_events XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num; --added
3320: l_array_duplicate_checker XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num; --added
3313: l_array_reference_date_1 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
3314: l_array_reference_date_2 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
3315: l_array_reference_date_3 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
3316: l_array_reference_date_4 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
3317: l_array_event_created_by XLA_AE_JOURNAL_ENTRY_PKG.t_array_V100L;
3318: l_array_budgetary_control_flag XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L;
3319: l_array_header_events XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num; --added
3320: l_array_duplicate_checker XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num; --added
3321:
3314: l_array_reference_date_2 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
3315: l_array_reference_date_3 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
3316: l_array_reference_date_4 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
3317: l_array_event_created_by XLA_AE_JOURNAL_ENTRY_PKG.t_array_V100L;
3318: l_array_budgetary_control_flag XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L;
3319: l_array_header_events XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num; --added
3320: l_array_duplicate_checker XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num; --added
3321:
3322: l_event_id NUMBER;
3315: l_array_reference_date_3 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
3316: l_array_reference_date_4 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
3317: l_array_event_created_by XLA_AE_JOURNAL_ENTRY_PKG.t_array_V100L;
3318: l_array_budgetary_control_flag XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L;
3319: l_array_header_events XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num; --added
3320: l_array_duplicate_checker XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num; --added
3321:
3322: l_event_id NUMBER;
3323: l_previous_event_id NUMBER;
3316: l_array_reference_date_4 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
3317: l_array_event_created_by XLA_AE_JOURNAL_ENTRY_PKG.t_array_V100L;
3318: l_array_budgetary_control_flag XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L;
3319: l_array_header_events XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num; --added
3320: l_array_duplicate_checker XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num; --added
3321:
3322: l_event_id NUMBER;
3323: l_previous_event_id NUMBER;
3324: l_first_event_id NUMBER;
3334: l_event_class_name VARCHAR2(80) := 'Lease Expense';
3335: l_description VARCHAR2(4000);
3336: l_transaction_reversal NUMBER;
3337: l_ae_header_id NUMBER;
3338: l_array_extract_line_num xla_ae_journal_entry_pkg.t_array_Num;
3339: l_log_module VARCHAR2(240);
3340: --
3341: l_acct_reversal_source VARCHAR2(30);
3342: l_trx_reversal_source VARCHAR2(30);
3601:
3602: --
3603: -- set event info as cache for other routines to refer event attributes
3604: --
3605: XLA_AE_JOURNAL_ENTRY_PKG.set_event_info
3606: (p_application_id => p_application_id
3607: ,p_primary_ledger_id => p_primary_ledger_id
3608: ,p_base_ledger_id => p_base_ledger_id
3609: ,p_target_ledger_id => p_target_ledger_id
3634:
3635: --
3636: -- set the status of entry to C_VALID (0)
3637: --
3638: XLA_AE_JOURNAL_ENTRY_PKG.g_global_status := XLA_AE_JOURNAL_ENTRY_PKG.C_VALID;
3639:
3640: --
3641: -- initialize a row for ae header
3642: --
3666: --
3667: -- initilaize the status of ae headers for diffrent balance types
3668: -- the status is initialised to C_NOT_CREATED (2)
3669: --
3670: --g_array_event(l_event_id).array_value_num('actual_je_status') := XLA_AE_JOURNAL_ENTRY_PKG.C_NOT_CREATED;
3671: --g_array_event(l_event_id).array_value_num('budget_je_status') := XLA_AE_JOURNAL_ENTRY_PKG.C_NOT_CREATED;
3672: --g_array_event(l_event_id).array_value_num('encumbrance_je_status') := XLA_AE_JOURNAL_ENTRY_PKG.C_NOT_CREATED;
3673:
3674: --
3667: -- initilaize the status of ae headers for diffrent balance types
3668: -- the status is initialised to C_NOT_CREATED (2)
3669: --
3670: --g_array_event(l_event_id).array_value_num('actual_je_status') := XLA_AE_JOURNAL_ENTRY_PKG.C_NOT_CREATED;
3671: --g_array_event(l_event_id).array_value_num('budget_je_status') := XLA_AE_JOURNAL_ENTRY_PKG.C_NOT_CREATED;
3672: --g_array_event(l_event_id).array_value_num('encumbrance_je_status') := XLA_AE_JOURNAL_ENTRY_PKG.C_NOT_CREATED;
3673:
3674: --
3675: -- call api to validate and store accounting attributes for header
3668: -- the status is initialised to C_NOT_CREATED (2)
3669: --
3670: --g_array_event(l_event_id).array_value_num('actual_je_status') := XLA_AE_JOURNAL_ENTRY_PKG.C_NOT_CREATED;
3671: --g_array_event(l_event_id).array_value_num('budget_je_status') := XLA_AE_JOURNAL_ENTRY_PKG.C_NOT_CREATED;
3672: --g_array_event(l_event_id).array_value_num('encumbrance_je_status') := XLA_AE_JOURNAL_ENTRY_PKG.C_NOT_CREATED;
3673:
3674: --
3675: -- call api to validate and store accounting attributes for header
3676: --
3722: --
3723: l_trx_reversal_source := SUBSTR(NULL, 1,30);
3724:
3725: IF NVL(l_trx_reversal_source, 'N') NOT IN ('N','Y') THEN
3726: xla_ae_journal_entry_pkg.g_global_status := xla_ae_journal_entry_pkg.C_INVALID;
3727:
3728: xla_accounting_err_pkg.build_message
3729: (p_appli_s_name => 'XLA'
3730: ,p_msg_name => 'XLA_AP_INVALID_HDR_ATTR'
3730: ,p_msg_name => 'XLA_AP_INVALID_HDR_ATTR'
3731: ,p_token_1 => 'ACCT_ATTR_NAME'
3732: ,p_value_1 => xla_ae_sources_pkg.GetAccountingSourceName('TRX_ACCT_REVERSAL_OPTION')
3733: ,p_token_2 => 'PRODUCT_NAME'
3734: ,p_value_2 => xla_ae_journal_entry_pkg.g_cache_event.application_name
3735: ,p_entity_id => xla_ae_journal_entry_pkg.g_cache_event.entity_id
3736: ,p_event_id => xla_ae_journal_entry_pkg.g_cache_event.event_id
3737: ,p_ledger_id => xla_ae_journal_entry_pkg.g_cache_event.target_ledger_id);
3738:
3731: ,p_token_1 => 'ACCT_ATTR_NAME'
3732: ,p_value_1 => xla_ae_sources_pkg.GetAccountingSourceName('TRX_ACCT_REVERSAL_OPTION')
3733: ,p_token_2 => 'PRODUCT_NAME'
3734: ,p_value_2 => xla_ae_journal_entry_pkg.g_cache_event.application_name
3735: ,p_entity_id => xla_ae_journal_entry_pkg.g_cache_event.entity_id
3736: ,p_event_id => xla_ae_journal_entry_pkg.g_cache_event.event_id
3737: ,p_ledger_id => xla_ae_journal_entry_pkg.g_cache_event.target_ledger_id);
3738:
3739: ELSIF NVL(l_trx_reversal_source, 'N') = 'Y' THEN
3732: ,p_value_1 => xla_ae_sources_pkg.GetAccountingSourceName('TRX_ACCT_REVERSAL_OPTION')
3733: ,p_token_2 => 'PRODUCT_NAME'
3734: ,p_value_2 => xla_ae_journal_entry_pkg.g_cache_event.application_name
3735: ,p_entity_id => xla_ae_journal_entry_pkg.g_cache_event.entity_id
3736: ,p_event_id => xla_ae_journal_entry_pkg.g_cache_event.event_id
3737: ,p_ledger_id => xla_ae_journal_entry_pkg.g_cache_event.target_ledger_id);
3738:
3739: ELSIF NVL(l_trx_reversal_source, 'N') = 'Y' THEN
3740: --
3733: ,p_token_2 => 'PRODUCT_NAME'
3734: ,p_value_2 => xla_ae_journal_entry_pkg.g_cache_event.application_name
3735: ,p_entity_id => xla_ae_journal_entry_pkg.g_cache_event.entity_id
3736: ,p_event_id => xla_ae_journal_entry_pkg.g_cache_event.event_id
3737: ,p_ledger_id => xla_ae_journal_entry_pkg.g_cache_event.target_ledger_id);
3738:
3739: ELSIF NVL(l_trx_reversal_source, 'N') = 'Y' THEN
3740: --
3741: -- following sets the accounting attributes needed to reverse
3752: ----------------------------------------------------------------
3753: -- 4262811 - update the header statuses to invalid in need be
3754: ----------------------------------------------------------------
3755: --
3756: XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus (p_hdr_idx => hdr_idx);
3757:
3758:
3759: -----------------------------------------------
3760: -- No accrual reversal for the event class/type
3879: ,p_module => l_log_module);
3880: END IF;
3881:
3882: --
3883: -- set the XLA_AE_JOURNAL_ENTRY_PKG.g_global_status to C_VALID (0)
3884: --
3885: XLA_AE_JOURNAL_ENTRY_PKG.g_global_status := XLA_AE_JOURNAL_ENTRY_PKG.C_VALID;
3886: --
3887: -- set event info as cache for other routines to refer event attributes
3881:
3882: --
3883: -- set the XLA_AE_JOURNAL_ENTRY_PKG.g_global_status to C_VALID (0)
3884: --
3885: XLA_AE_JOURNAL_ENTRY_PKG.g_global_status := XLA_AE_JOURNAL_ENTRY_PKG.C_VALID;
3886: --
3887: -- set event info as cache for other routines to refer event attributes
3888: --
3889:
3889:
3890: IF l_event_id <> NVL(l_previous_event_id, -1) THEN
3891: l_previous_event_id := l_event_id;
3892:
3893: XLA_AE_JOURNAL_ENTRY_PKG.set_event_info
3894: (p_application_id => p_application_id
3895: ,p_primary_ledger_id => p_primary_ledger_id
3896: ,p_base_ledger_id => p_base_ledger_id
3897: ,p_target_ledger_id => p_target_ledger_id
3930: l_acct_reversal_source := SUBSTR(NULL, 1,30);
3931:
3932: IF l_continue_with_lines THEN
3933: IF NVL(l_acct_reversal_source, 'N') NOT IN ('N','Y','B') THEN
3934: xla_ae_journal_entry_pkg.g_global_status := xla_ae_journal_entry_pkg.C_INVALID;
3935:
3936: xla_accounting_err_pkg.build_message
3937: (p_appli_s_name => 'XLA'
3938: ,p_msg_name => 'XLA_AP_INVALID_REVERSAL_OPTION'
3938: ,p_msg_name => 'XLA_AP_INVALID_REVERSAL_OPTION'
3939: ,p_token_1 => 'LINE_NUMBER'
3940: ,p_value_1 => l_array_extract_line_num(Idx)
3941: ,p_token_2 => 'PRODUCT_NAME'
3942: ,p_value_2 => xla_ae_journal_entry_pkg.g_cache_event.application_name
3943: ,p_entity_id => xla_ae_journal_entry_pkg.g_cache_event.entity_id
3944: ,p_event_id => xla_ae_journal_entry_pkg.g_cache_event.event_id
3945: ,p_ledger_id => xla_ae_journal_entry_pkg.g_cache_event.target_ledger_id);
3946:
3939: ,p_token_1 => 'LINE_NUMBER'
3940: ,p_value_1 => l_array_extract_line_num(Idx)
3941: ,p_token_2 => 'PRODUCT_NAME'
3942: ,p_value_2 => xla_ae_journal_entry_pkg.g_cache_event.application_name
3943: ,p_entity_id => xla_ae_journal_entry_pkg.g_cache_event.entity_id
3944: ,p_event_id => xla_ae_journal_entry_pkg.g_cache_event.event_id
3945: ,p_ledger_id => xla_ae_journal_entry_pkg.g_cache_event.target_ledger_id);
3946:
3947: ELSIF NVL(l_acct_reversal_source, 'N') IN ('Y','B') THEN
3940: ,p_value_1 => l_array_extract_line_num(Idx)
3941: ,p_token_2 => 'PRODUCT_NAME'
3942: ,p_value_2 => xla_ae_journal_entry_pkg.g_cache_event.application_name
3943: ,p_entity_id => xla_ae_journal_entry_pkg.g_cache_event.entity_id
3944: ,p_event_id => xla_ae_journal_entry_pkg.g_cache_event.event_id
3945: ,p_ledger_id => xla_ae_journal_entry_pkg.g_cache_event.target_ledger_id);
3946:
3947: ELSIF NVL(l_acct_reversal_source, 'N') IN ('Y','B') THEN
3948: --
3941: ,p_token_2 => 'PRODUCT_NAME'
3942: ,p_value_2 => xla_ae_journal_entry_pkg.g_cache_event.application_name
3943: ,p_entity_id => xla_ae_journal_entry_pkg.g_cache_event.entity_id
3944: ,p_event_id => xla_ae_journal_entry_pkg.g_cache_event.event_id
3945: ,p_ledger_id => xla_ae_journal_entry_pkg.g_cache_event.target_ledger_id);
3946:
3947: ELSIF NVL(l_acct_reversal_source, 'N') IN ('Y','B') THEN
3948: --
3949: -- following sets the accounting attributes needed to reverse
4040:
4041: -- only execute it if calculate g/l flag is yes, and primary or secondary ledger
4042: -- or secondary ledger that has different currency with primary
4043: -- or alc that is calculated by sla
4044: IF (((l_calculate_g_l_flag = 'Y' AND XLA_AE_JOURNAL_ENTRY_PKG.g_cache_ledgers_info.ledger_category_code <> 'ALC') or
4045: (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'))
4046:
4047: -- IF((l_calculate_g_l_flag='Y' or XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.target_ledger_id <>
4048: -- XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.ledger_id)
4041: -- only execute it if calculate g/l flag is yes, and primary or secondary ledger
4042: -- or secondary ledger that has different currency with primary
4043: -- or alc that is calculated by sla
4044: IF (((l_calculate_g_l_flag = 'Y' AND XLA_AE_JOURNAL_ENTRY_PKG.g_cache_ledgers_info.ledger_category_code <> 'ALC') or
4045: (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'))
4046:
4047: -- IF((l_calculate_g_l_flag='Y' or XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.target_ledger_id <>
4048: -- XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.ledger_id)
4049: AND (l_actual_flag = 'A')) THEN
4043: -- or alc that is calculated by sla
4044: IF (((l_calculate_g_l_flag = 'Y' AND XLA_AE_JOURNAL_ENTRY_PKG.g_cache_ledgers_info.ledger_category_code <> 'ALC') or
4045: (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'))
4046:
4047: -- IF((l_calculate_g_l_flag='Y' or XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.target_ledger_id <>
4048: -- XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.ledger_id)
4049: AND (l_actual_flag = 'A')) THEN
4050: XLA_AE_LINES_PKG.CreateGainOrLossLines(
4051: p_event_id => xla_ae_journal_entry_pkg.g_cache_event.event_id
4044: IF (((l_calculate_g_l_flag = 'Y' AND XLA_AE_JOURNAL_ENTRY_PKG.g_cache_ledgers_info.ledger_category_code <> 'ALC') or
4045: (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'))
4046:
4047: -- IF((l_calculate_g_l_flag='Y' or XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.target_ledger_id <>
4048: -- XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.ledger_id)
4049: AND (l_actual_flag = 'A')) THEN
4050: XLA_AE_LINES_PKG.CreateGainOrLossLines(
4051: p_event_id => xla_ae_journal_entry_pkg.g_cache_event.event_id
4052: ,p_application_id => p_application_id
4047: -- IF((l_calculate_g_l_flag='Y' or XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.target_ledger_id <>
4048: -- XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.ledger_id)
4049: AND (l_actual_flag = 'A')) THEN
4050: XLA_AE_LINES_PKG.CreateGainOrLossLines(
4051: p_event_id => xla_ae_journal_entry_pkg.g_cache_event.event_id
4052: ,p_application_id => p_application_id
4053: ,p_amb_context_code => 'DEFAULT'
4054: ,p_entity_code => xla_ae_journal_entry_pkg.g_cache_event.entity_code
4055: ,p_event_class_code => C_EVENT_CLASS_CODE
4050: XLA_AE_LINES_PKG.CreateGainOrLossLines(
4051: p_event_id => xla_ae_journal_entry_pkg.g_cache_event.event_id
4052: ,p_application_id => p_application_id
4053: ,p_amb_context_code => 'DEFAULT'
4054: ,p_entity_code => xla_ae_journal_entry_pkg.g_cache_event.entity_code
4055: ,p_event_class_code => C_EVENT_CLASS_CODE
4056: ,p_event_type_code => C_EVENT_TYPE_CODE
4057:
4058: ,p_gain_ccid => -1
4541:
4542: l_calculate_acctd_flag VARCHAR2(1) :='N';
4543: l_calculate_g_l_flag VARCHAR2(1) :='N';
4544: --
4545: l_array_legal_entity_id XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
4546: l_array_entity_id XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
4547: l_array_entity_code XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L;
4548: l_array_transaction_num XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
4549: l_array_event_id XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
4542: l_calculate_acctd_flag VARCHAR2(1) :='N';
4543: l_calculate_g_l_flag VARCHAR2(1) :='N';
4544: --
4545: l_array_legal_entity_id XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
4546: l_array_entity_id XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
4547: l_array_entity_code XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L;
4548: l_array_transaction_num XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
4549: l_array_event_id XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
4550: l_array_class_code XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L;
4543: l_calculate_g_l_flag VARCHAR2(1) :='N';
4544: --
4545: l_array_legal_entity_id XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
4546: l_array_entity_id XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
4547: l_array_entity_code XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L;
4548: l_array_transaction_num XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
4549: l_array_event_id XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
4550: l_array_class_code XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L;
4551: l_array_event_type XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L;
4544: --
4545: l_array_legal_entity_id XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
4546: l_array_entity_id XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
4547: l_array_entity_code XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L;
4548: l_array_transaction_num XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
4549: l_array_event_id XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
4550: l_array_class_code XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L;
4551: l_array_event_type XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L;
4552: l_array_event_number XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
4545: l_array_legal_entity_id XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
4546: l_array_entity_id XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
4547: l_array_entity_code XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L;
4548: l_array_transaction_num XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
4549: l_array_event_id XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
4550: l_array_class_code XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L;
4551: l_array_event_type XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L;
4552: l_array_event_number XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
4553: l_array_event_date XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
4546: l_array_entity_id XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
4547: l_array_entity_code XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L;
4548: l_array_transaction_num XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
4549: l_array_event_id XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
4550: l_array_class_code XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L;
4551: l_array_event_type XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L;
4552: l_array_event_number XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
4553: l_array_event_date XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
4554: l_array_transaction_date XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
4547: l_array_entity_code XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L;
4548: l_array_transaction_num XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
4549: l_array_event_id XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
4550: l_array_class_code XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L;
4551: l_array_event_type XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L;
4552: l_array_event_number XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
4553: l_array_event_date XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
4554: l_array_transaction_date XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
4555: l_array_reference_num_1 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
4548: l_array_transaction_num XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
4549: l_array_event_id XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
4550: l_array_class_code XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L;
4551: l_array_event_type XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L;
4552: l_array_event_number XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
4553: l_array_event_date XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
4554: l_array_transaction_date XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
4555: l_array_reference_num_1 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
4556: l_array_reference_num_2 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
4549: l_array_event_id XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
4550: l_array_class_code XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L;
4551: l_array_event_type XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L;
4552: l_array_event_number XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
4553: l_array_event_date XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
4554: l_array_transaction_date XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
4555: l_array_reference_num_1 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
4556: l_array_reference_num_2 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
4557: l_array_reference_num_3 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
4550: l_array_class_code XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L;
4551: l_array_event_type XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L;
4552: l_array_event_number XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
4553: l_array_event_date XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
4554: l_array_transaction_date XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
4555: l_array_reference_num_1 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
4556: l_array_reference_num_2 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
4557: l_array_reference_num_3 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
4558: l_array_reference_num_4 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
4551: l_array_event_type XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L;
4552: l_array_event_number XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
4553: l_array_event_date XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
4554: l_array_transaction_date XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
4555: l_array_reference_num_1 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
4556: l_array_reference_num_2 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
4557: l_array_reference_num_3 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
4558: l_array_reference_num_4 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
4559: l_array_reference_char_1 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
4552: l_array_event_number XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
4553: l_array_event_date XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
4554: l_array_transaction_date XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
4555: l_array_reference_num_1 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
4556: l_array_reference_num_2 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
4557: l_array_reference_num_3 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
4558: l_array_reference_num_4 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
4559: l_array_reference_char_1 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
4560: l_array_reference_char_2 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
4553: l_array_event_date XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
4554: l_array_transaction_date XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
4555: l_array_reference_num_1 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
4556: l_array_reference_num_2 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
4557: l_array_reference_num_3 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
4558: l_array_reference_num_4 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
4559: l_array_reference_char_1 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
4560: l_array_reference_char_2 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
4561: l_array_reference_char_3 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
4554: l_array_transaction_date XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
4555: l_array_reference_num_1 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
4556: l_array_reference_num_2 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
4557: l_array_reference_num_3 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
4558: l_array_reference_num_4 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
4559: l_array_reference_char_1 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
4560: l_array_reference_char_2 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
4561: l_array_reference_char_3 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
4562: l_array_reference_char_4 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
4555: l_array_reference_num_1 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
4556: l_array_reference_num_2 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
4557: l_array_reference_num_3 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
4558: l_array_reference_num_4 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
4559: l_array_reference_char_1 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
4560: l_array_reference_char_2 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
4561: l_array_reference_char_3 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
4562: l_array_reference_char_4 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
4563: l_array_reference_date_1 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
4556: l_array_reference_num_2 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
4557: l_array_reference_num_3 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
4558: l_array_reference_num_4 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
4559: l_array_reference_char_1 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
4560: l_array_reference_char_2 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
4561: l_array_reference_char_3 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
4562: l_array_reference_char_4 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
4563: l_array_reference_date_1 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
4564: l_array_reference_date_2 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
4557: l_array_reference_num_3 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
4558: l_array_reference_num_4 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
4559: l_array_reference_char_1 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
4560: l_array_reference_char_2 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
4561: l_array_reference_char_3 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
4562: l_array_reference_char_4 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
4563: l_array_reference_date_1 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
4564: l_array_reference_date_2 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
4565: l_array_reference_date_3 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
4558: l_array_reference_num_4 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
4559: l_array_reference_char_1 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
4560: l_array_reference_char_2 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
4561: l_array_reference_char_3 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
4562: l_array_reference_char_4 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
4563: l_array_reference_date_1 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
4564: l_array_reference_date_2 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
4565: l_array_reference_date_3 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
4566: l_array_reference_date_4 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
4559: l_array_reference_char_1 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
4560: l_array_reference_char_2 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
4561: l_array_reference_char_3 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
4562: l_array_reference_char_4 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
4563: l_array_reference_date_1 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
4564: l_array_reference_date_2 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
4565: l_array_reference_date_3 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
4566: l_array_reference_date_4 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
4567: l_array_event_created_by XLA_AE_JOURNAL_ENTRY_PKG.t_array_V100L;
4560: l_array_reference_char_2 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
4561: l_array_reference_char_3 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
4562: l_array_reference_char_4 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
4563: l_array_reference_date_1 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
4564: l_array_reference_date_2 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
4565: l_array_reference_date_3 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
4566: l_array_reference_date_4 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
4567: l_array_event_created_by XLA_AE_JOURNAL_ENTRY_PKG.t_array_V100L;
4568: l_array_budgetary_control_flag XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L;
4561: l_array_reference_char_3 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
4562: l_array_reference_char_4 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
4563: l_array_reference_date_1 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
4564: l_array_reference_date_2 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
4565: l_array_reference_date_3 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
4566: l_array_reference_date_4 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
4567: l_array_event_created_by XLA_AE_JOURNAL_ENTRY_PKG.t_array_V100L;
4568: l_array_budgetary_control_flag XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L;
4569: l_array_header_events XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num; --added
4562: l_array_reference_char_4 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
4563: l_array_reference_date_1 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
4564: l_array_reference_date_2 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
4565: l_array_reference_date_3 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
4566: l_array_reference_date_4 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
4567: l_array_event_created_by XLA_AE_JOURNAL_ENTRY_PKG.t_array_V100L;
4568: l_array_budgetary_control_flag XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L;
4569: l_array_header_events XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num; --added
4570: l_array_duplicate_checker XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num; --added
4563: l_array_reference_date_1 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
4564: l_array_reference_date_2 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
4565: l_array_reference_date_3 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
4566: l_array_reference_date_4 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
4567: l_array_event_created_by XLA_AE_JOURNAL_ENTRY_PKG.t_array_V100L;
4568: l_array_budgetary_control_flag XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L;
4569: l_array_header_events XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num; --added
4570: l_array_duplicate_checker XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num; --added
4571:
4564: l_array_reference_date_2 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
4565: l_array_reference_date_3 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
4566: l_array_reference_date_4 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
4567: l_array_event_created_by XLA_AE_JOURNAL_ENTRY_PKG.t_array_V100L;
4568: l_array_budgetary_control_flag XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L;
4569: l_array_header_events XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num; --added
4570: l_array_duplicate_checker XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num; --added
4571:
4572: l_event_id NUMBER;
4565: l_array_reference_date_3 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
4566: l_array_reference_date_4 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
4567: l_array_event_created_by XLA_AE_JOURNAL_ENTRY_PKG.t_array_V100L;
4568: l_array_budgetary_control_flag XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L;
4569: l_array_header_events XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num; --added
4570: l_array_duplicate_checker XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num; --added
4571:
4572: l_event_id NUMBER;
4573: l_previous_event_id NUMBER;
4566: l_array_reference_date_4 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
4567: l_array_event_created_by XLA_AE_JOURNAL_ENTRY_PKG.t_array_V100L;
4568: l_array_budgetary_control_flag XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L;
4569: l_array_header_events XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num; --added
4570: l_array_duplicate_checker XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num; --added
4571:
4572: l_event_id NUMBER;
4573: l_previous_event_id NUMBER;
4574: l_first_event_id NUMBER;
4584: l_event_class_name VARCHAR2(80) := 'Lease Revenue';
4585: l_description VARCHAR2(4000);
4586: l_transaction_reversal NUMBER;
4587: l_ae_header_id NUMBER;
4588: l_array_extract_line_num xla_ae_journal_entry_pkg.t_array_Num;
4589: l_log_module VARCHAR2(240);
4590: --
4591: l_acct_reversal_source VARCHAR2(30);
4592: l_trx_reversal_source VARCHAR2(30);
4851:
4852: --
4853: -- set event info as cache for other routines to refer event attributes
4854: --
4855: XLA_AE_JOURNAL_ENTRY_PKG.set_event_info
4856: (p_application_id => p_application_id
4857: ,p_primary_ledger_id => p_primary_ledger_id
4858: ,p_base_ledger_id => p_base_ledger_id
4859: ,p_target_ledger_id => p_target_ledger_id
4884:
4885: --
4886: -- set the status of entry to C_VALID (0)
4887: --
4888: XLA_AE_JOURNAL_ENTRY_PKG.g_global_status := XLA_AE_JOURNAL_ENTRY_PKG.C_VALID;
4889:
4890: --
4891: -- initialize a row for ae header
4892: --
4916: --
4917: -- initilaize the status of ae headers for diffrent balance types
4918: -- the status is initialised to C_NOT_CREATED (2)
4919: --
4920: --g_array_event(l_event_id).array_value_num('actual_je_status') := XLA_AE_JOURNAL_ENTRY_PKG.C_NOT_CREATED;
4921: --g_array_event(l_event_id).array_value_num('budget_je_status') := XLA_AE_JOURNAL_ENTRY_PKG.C_NOT_CREATED;
4922: --g_array_event(l_event_id).array_value_num('encumbrance_je_status') := XLA_AE_JOURNAL_ENTRY_PKG.C_NOT_CREATED;
4923:
4924: --
4917: -- initilaize the status of ae headers for diffrent balance types
4918: -- the status is initialised to C_NOT_CREATED (2)
4919: --
4920: --g_array_event(l_event_id).array_value_num('actual_je_status') := XLA_AE_JOURNAL_ENTRY_PKG.C_NOT_CREATED;
4921: --g_array_event(l_event_id).array_value_num('budget_je_status') := XLA_AE_JOURNAL_ENTRY_PKG.C_NOT_CREATED;
4922: --g_array_event(l_event_id).array_value_num('encumbrance_je_status') := XLA_AE_JOURNAL_ENTRY_PKG.C_NOT_CREATED;
4923:
4924: --
4925: -- call api to validate and store accounting attributes for header
4918: -- the status is initialised to C_NOT_CREATED (2)
4919: --
4920: --g_array_event(l_event_id).array_value_num('actual_je_status') := XLA_AE_JOURNAL_ENTRY_PKG.C_NOT_CREATED;
4921: --g_array_event(l_event_id).array_value_num('budget_je_status') := XLA_AE_JOURNAL_ENTRY_PKG.C_NOT_CREATED;
4922: --g_array_event(l_event_id).array_value_num('encumbrance_je_status') := XLA_AE_JOURNAL_ENTRY_PKG.C_NOT_CREATED;
4923:
4924: --
4925: -- call api to validate and store accounting attributes for header
4926: --
4972: --
4973: l_trx_reversal_source := SUBSTR(NULL, 1,30);
4974:
4975: IF NVL(l_trx_reversal_source, 'N') NOT IN ('N','Y') THEN
4976: xla_ae_journal_entry_pkg.g_global_status := xla_ae_journal_entry_pkg.C_INVALID;
4977:
4978: xla_accounting_err_pkg.build_message
4979: (p_appli_s_name => 'XLA'
4980: ,p_msg_name => 'XLA_AP_INVALID_HDR_ATTR'
4980: ,p_msg_name => 'XLA_AP_INVALID_HDR_ATTR'
4981: ,p_token_1 => 'ACCT_ATTR_NAME'
4982: ,p_value_1 => xla_ae_sources_pkg.GetAccountingSourceName('TRX_ACCT_REVERSAL_OPTION')
4983: ,p_token_2 => 'PRODUCT_NAME'
4984: ,p_value_2 => xla_ae_journal_entry_pkg.g_cache_event.application_name
4985: ,p_entity_id => xla_ae_journal_entry_pkg.g_cache_event.entity_id
4986: ,p_event_id => xla_ae_journal_entry_pkg.g_cache_event.event_id
4987: ,p_ledger_id => xla_ae_journal_entry_pkg.g_cache_event.target_ledger_id);
4988:
4981: ,p_token_1 => 'ACCT_ATTR_NAME'
4982: ,p_value_1 => xla_ae_sources_pkg.GetAccountingSourceName('TRX_ACCT_REVERSAL_OPTION')
4983: ,p_token_2 => 'PRODUCT_NAME'
4984: ,p_value_2 => xla_ae_journal_entry_pkg.g_cache_event.application_name
4985: ,p_entity_id => xla_ae_journal_entry_pkg.g_cache_event.entity_id
4986: ,p_event_id => xla_ae_journal_entry_pkg.g_cache_event.event_id
4987: ,p_ledger_id => xla_ae_journal_entry_pkg.g_cache_event.target_ledger_id);
4988:
4989: ELSIF NVL(l_trx_reversal_source, 'N') = 'Y' THEN
4982: ,p_value_1 => xla_ae_sources_pkg.GetAccountingSourceName('TRX_ACCT_REVERSAL_OPTION')
4983: ,p_token_2 => 'PRODUCT_NAME'
4984: ,p_value_2 => xla_ae_journal_entry_pkg.g_cache_event.application_name
4985: ,p_entity_id => xla_ae_journal_entry_pkg.g_cache_event.entity_id
4986: ,p_event_id => xla_ae_journal_entry_pkg.g_cache_event.event_id
4987: ,p_ledger_id => xla_ae_journal_entry_pkg.g_cache_event.target_ledger_id);
4988:
4989: ELSIF NVL(l_trx_reversal_source, 'N') = 'Y' THEN
4990: --
4983: ,p_token_2 => 'PRODUCT_NAME'
4984: ,p_value_2 => xla_ae_journal_entry_pkg.g_cache_event.application_name
4985: ,p_entity_id => xla_ae_journal_entry_pkg.g_cache_event.entity_id
4986: ,p_event_id => xla_ae_journal_entry_pkg.g_cache_event.event_id
4987: ,p_ledger_id => xla_ae_journal_entry_pkg.g_cache_event.target_ledger_id);
4988:
4989: ELSIF NVL(l_trx_reversal_source, 'N') = 'Y' THEN
4990: --
4991: -- following sets the accounting attributes needed to reverse
5002: ----------------------------------------------------------------
5003: -- 4262811 - update the header statuses to invalid in need be
5004: ----------------------------------------------------------------
5005: --
5006: XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus (p_hdr_idx => hdr_idx);
5007:
5008:
5009: -----------------------------------------------
5010: -- No accrual reversal for the event class/type
5129: ,p_module => l_log_module);
5130: END IF;
5131:
5132: --
5133: -- set the XLA_AE_JOURNAL_ENTRY_PKG.g_global_status to C_VALID (0)
5134: --
5135: XLA_AE_JOURNAL_ENTRY_PKG.g_global_status := XLA_AE_JOURNAL_ENTRY_PKG.C_VALID;
5136: --
5137: -- set event info as cache for other routines to refer event attributes
5131:
5132: --
5133: -- set the XLA_AE_JOURNAL_ENTRY_PKG.g_global_status to C_VALID (0)
5134: --
5135: XLA_AE_JOURNAL_ENTRY_PKG.g_global_status := XLA_AE_JOURNAL_ENTRY_PKG.C_VALID;
5136: --
5137: -- set event info as cache for other routines to refer event attributes
5138: --
5139:
5139:
5140: IF l_event_id <> NVL(l_previous_event_id, -1) THEN
5141: l_previous_event_id := l_event_id;
5142:
5143: XLA_AE_JOURNAL_ENTRY_PKG.set_event_info
5144: (p_application_id => p_application_id
5145: ,p_primary_ledger_id => p_primary_ledger_id
5146: ,p_base_ledger_id => p_base_ledger_id
5147: ,p_target_ledger_id => p_target_ledger_id
5180: l_acct_reversal_source := SUBSTR(NULL, 1,30);
5181:
5182: IF l_continue_with_lines THEN
5183: IF NVL(l_acct_reversal_source, 'N') NOT IN ('N','Y','B') THEN
5184: xla_ae_journal_entry_pkg.g_global_status := xla_ae_journal_entry_pkg.C_INVALID;
5185:
5186: xla_accounting_err_pkg.build_message
5187: (p_appli_s_name => 'XLA'
5188: ,p_msg_name => 'XLA_AP_INVALID_REVERSAL_OPTION'
5188: ,p_msg_name => 'XLA_AP_INVALID_REVERSAL_OPTION'
5189: ,p_token_1 => 'LINE_NUMBER'
5190: ,p_value_1 => l_array_extract_line_num(Idx)
5191: ,p_token_2 => 'PRODUCT_NAME'
5192: ,p_value_2 => xla_ae_journal_entry_pkg.g_cache_event.application_name
5193: ,p_entity_id => xla_ae_journal_entry_pkg.g_cache_event.entity_id
5194: ,p_event_id => xla_ae_journal_entry_pkg.g_cache_event.event_id
5195: ,p_ledger_id => xla_ae_journal_entry_pkg.g_cache_event.target_ledger_id);
5196:
5189: ,p_token_1 => 'LINE_NUMBER'
5190: ,p_value_1 => l_array_extract_line_num(Idx)
5191: ,p_token_2 => 'PRODUCT_NAME'
5192: ,p_value_2 => xla_ae_journal_entry_pkg.g_cache_event.application_name
5193: ,p_entity_id => xla_ae_journal_entry_pkg.g_cache_event.entity_id
5194: ,p_event_id => xla_ae_journal_entry_pkg.g_cache_event.event_id
5195: ,p_ledger_id => xla_ae_journal_entry_pkg.g_cache_event.target_ledger_id);
5196:
5197: ELSIF NVL(l_acct_reversal_source, 'N') IN ('Y','B') THEN
5190: ,p_value_1 => l_array_extract_line_num(Idx)
5191: ,p_token_2 => 'PRODUCT_NAME'
5192: ,p_value_2 => xla_ae_journal_entry_pkg.g_cache_event.application_name
5193: ,p_entity_id => xla_ae_journal_entry_pkg.g_cache_event.entity_id
5194: ,p_event_id => xla_ae_journal_entry_pkg.g_cache_event.event_id
5195: ,p_ledger_id => xla_ae_journal_entry_pkg.g_cache_event.target_ledger_id);
5196:
5197: ELSIF NVL(l_acct_reversal_source, 'N') IN ('Y','B') THEN
5198: --
5191: ,p_token_2 => 'PRODUCT_NAME'
5192: ,p_value_2 => xla_ae_journal_entry_pkg.g_cache_event.application_name
5193: ,p_entity_id => xla_ae_journal_entry_pkg.g_cache_event.entity_id
5194: ,p_event_id => xla_ae_journal_entry_pkg.g_cache_event.event_id
5195: ,p_ledger_id => xla_ae_journal_entry_pkg.g_cache_event.target_ledger_id);
5196:
5197: ELSIF NVL(l_acct_reversal_source, 'N') IN ('Y','B') THEN
5198: --
5199: -- following sets the accounting attributes needed to reverse
5290:
5291: -- only execute it if calculate g/l flag is yes, and primary or secondary ledger
5292: -- or secondary ledger that has different currency with primary
5293: -- or alc that is calculated by sla
5294: IF (((l_calculate_g_l_flag = 'Y' AND XLA_AE_JOURNAL_ENTRY_PKG.g_cache_ledgers_info.ledger_category_code <> 'ALC') or
5295: (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'))
5296:
5297: -- IF((l_calculate_g_l_flag='Y' or XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.target_ledger_id <>
5298: -- XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.ledger_id)
5291: -- only execute it if calculate g/l flag is yes, and primary or secondary ledger
5292: -- or secondary ledger that has different currency with primary
5293: -- or alc that is calculated by sla
5294: IF (((l_calculate_g_l_flag = 'Y' AND XLA_AE_JOURNAL_ENTRY_PKG.g_cache_ledgers_info.ledger_category_code <> 'ALC') or
5295: (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'))
5296:
5297: -- IF((l_calculate_g_l_flag='Y' or XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.target_ledger_id <>
5298: -- XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.ledger_id)
5299: AND (l_actual_flag = 'A')) THEN
5293: -- or alc that is calculated by sla
5294: IF (((l_calculate_g_l_flag = 'Y' AND XLA_AE_JOURNAL_ENTRY_PKG.g_cache_ledgers_info.ledger_category_code <> 'ALC') or
5295: (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'))
5296:
5297: -- IF((l_calculate_g_l_flag='Y' or XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.target_ledger_id <>
5298: -- XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.ledger_id)
5299: AND (l_actual_flag = 'A')) THEN
5300: XLA_AE_LINES_PKG.CreateGainOrLossLines(
5301: p_event_id => xla_ae_journal_entry_pkg.g_cache_event.event_id
5294: IF (((l_calculate_g_l_flag = 'Y' AND XLA_AE_JOURNAL_ENTRY_PKG.g_cache_ledgers_info.ledger_category_code <> 'ALC') or
5295: (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'))
5296:
5297: -- IF((l_calculate_g_l_flag='Y' or XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.target_ledger_id <>
5298: -- XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.ledger_id)
5299: AND (l_actual_flag = 'A')) THEN
5300: XLA_AE_LINES_PKG.CreateGainOrLossLines(
5301: p_event_id => xla_ae_journal_entry_pkg.g_cache_event.event_id
5302: ,p_application_id => p_application_id
5297: -- IF((l_calculate_g_l_flag='Y' or XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.target_ledger_id <>
5298: -- XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.ledger_id)
5299: AND (l_actual_flag = 'A')) THEN
5300: XLA_AE_LINES_PKG.CreateGainOrLossLines(
5301: p_event_id => xla_ae_journal_entry_pkg.g_cache_event.event_id
5302: ,p_application_id => p_application_id
5303: ,p_amb_context_code => 'DEFAULT'
5304: ,p_entity_code => xla_ae_journal_entry_pkg.g_cache_event.entity_code
5305: ,p_event_class_code => C_EVENT_CLASS_CODE
5300: XLA_AE_LINES_PKG.CreateGainOrLossLines(
5301: p_event_id => xla_ae_journal_entry_pkg.g_cache_event.event_id
5302: ,p_application_id => p_application_id
5303: ,p_amb_context_code => 'DEFAULT'
5304: ,p_entity_code => xla_ae_journal_entry_pkg.g_cache_event.entity_code
5305: ,p_event_class_code => C_EVENT_CLASS_CODE
5306: ,p_event_type_code => C_EVENT_TYPE_CODE
5307:
5308: ,p_gain_ccid => -1
5457: ,p_level => C_LEVEL_PROCEDURE
5458: ,p_module => l_log_module);
5459: END IF;
5460:
5461: l_language := xla_ae_journal_entry_pkg.g_cache_ledgers_info.description_language;
5462: l_currency_code := xla_ae_journal_entry_pkg.g_cache_ledgers_info.currency_code;
5463: l_sla_ledger_id := xla_ae_journal_entry_pkg.g_cache_ledgers_info.sla_ledger_id;
5464:
5465: --
5458: ,p_module => l_log_module);
5459: END IF;
5460:
5461: l_language := xla_ae_journal_entry_pkg.g_cache_ledgers_info.description_language;
5462: l_currency_code := xla_ae_journal_entry_pkg.g_cache_ledgers_info.currency_code;
5463: l_sla_ledger_id := xla_ae_journal_entry_pkg.g_cache_ledgers_info.sla_ledger_id;
5464:
5465: --
5466: -- initialize array of lines with NULL
5459: END IF;
5460:
5461: l_language := xla_ae_journal_entry_pkg.g_cache_ledgers_info.description_language;
5462: l_currency_code := xla_ae_journal_entry_pkg.g_cache_ledgers_info.currency_code;
5463: l_sla_ledger_id := xla_ae_journal_entry_pkg.g_cache_ledgers_info.sla_ledger_id;
5464:
5465: --
5466: -- initialize array of lines with NULL
5467: --
5655: ,p_level => C_LEVEL_STATEMENT
5656: ,p_module => l_log_module);
5657: END IF;
5658: --
5659: xla_ae_journal_entry_pkg.SetProductAcctDefinition
5660: (p_product_rule_code => 'PN_LEASE_ACCOUNTING'
5661: ,p_product_rule_type_code => 'S'
5662: ,p_product_rule_version => ''
5663: ,p_product_rule_name => 'Property Manager Normalized Accounting'
5664: ,p_amb_context_code => 'DEFAULT'
5665: );
5666:
5667: l_array_ledgers :=
5668: xla_ae_journal_entry_pkg.GetAlternateCurrencyLedger
5669: (p_base_ledger_id => p_base_ledger_id);
5670:
5671: FOR Idx IN 1 .. l_array_ledgers.COUNT LOOP
5672: l_temp_result :=
5669: (p_base_ledger_id => p_base_ledger_id);
5670:
5671: FOR Idx IN 1 .. l_array_ledgers.COUNT LOOP
5672: l_temp_result :=
5673: XLA_AE_JOURNAL_ENTRY_PKG.GetLedgersInfo
5674: (p_application_id => p_application_id
5675: ,p_base_ledger_id => p_base_ledger_id
5676: ,p_target_ledger_id => l_array_ledgers(Idx)
5677: ,p_primary_ledger_id => p_primary_ledger_id