eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.XLA_00206_AAD_S_000004_PKG dependencies on XLA_AE_JOURNAL_ENTRY_PKG

Line 24: (array_legal_entity_id XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num

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

Line 25: ,array_entity_id 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

Line 26: ,array_entity_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

Line 27: ,array_transaction_num XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L

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

Line 28: ,array_event_id xla_number_array_type --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

Line 29: ,array_class_code XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L

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

Line 30: ,array_event_type XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L

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

Line 31: ,array_event_number 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

Line 32: ,array_event_date XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date

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

Line 33: ,array_reference_num_1 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

Line 34: ,array_reference_num_2 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num

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

Line 35: ,array_reference_num_3 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num

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

Line 36: ,array_reference_num_4 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
40: ,array_reference_char_4 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L

Line 37: ,array_reference_char_1 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

Line 38: ,array_reference_char_2 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L

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

Line 39: ,array_reference_char_3 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L

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

Line 40: ,array_reference_char_4 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L

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

Line 41: ,array_reference_date_1 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

Line 42: ,array_reference_date_2 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date

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

Line 43: ,array_reference_date_3 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date

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

Line 44: ,array_reference_date_4 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date

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

Line 45: ,array_event_created_by XLA_AE_JOURNAL_ENTRY_PKG.t_array_V100L

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

Line 162: xla_ae_journal_entry_pkg.g_global_status := xla_ae_journal_entry_pkg.C_INVALID;

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'

Line 177: ,p_value_4 => xla_ae_journal_entry_pkg.g_cache_event.application_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: );

Line 178: ,p_entity_id => xla_ae_journal_entry_pkg.g_cache_event.entity_id

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:

Line 179: ,p_event_id => xla_ae_journal_entry_pkg.g_cache_event.event_id

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

Line 180: ,p_ledger_id => xla_ae_journal_entry_pkg.g_cache_event.target_ledger_id

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

Line 270: l_ledger_language := xla_ae_journal_entry_pkg.g_cache_ledgers_info.description_language;

266: ,p_level => C_LEVEL_PROCEDURE
267: ,p_module => l_log_module);
268: END IF;
269:
270: l_ledger_language := xla_ae_journal_entry_pkg.g_cache_ledgers_info.description_language;
271: l_component_type := 'AMB_DESCRIPTION';
272: l_component_code := 'LNS_HEADER_DESCRIPTION';
273: l_component_type_code := 'S';
274: l_component_appl_id := 206;

Line 409: l_ledger_language := xla_ae_journal_entry_pkg.g_cache_ledgers_info.description_language;

405: ,p_level => C_LEVEL_PROCEDURE
406: ,p_module => l_log_module);
407: END IF;
408:
409: l_ledger_language := xla_ae_journal_entry_pkg.g_cache_ledgers_info.description_language;
410: l_component_type := 'AMB_DESCRIPTION';
411: l_component_code := 'LNS_LINE_DESCRIPTION';
412: l_component_type_code := 'S';
413: l_component_appl_id := 206;

Line 546: xla_ae_journal_entry_pkg.g_global_status := xla_ae_journal_entry_pkg.C_INVALID;

542: (p_msg => 'END of AcctDerRule_3(invalid)'
543: ,p_level => C_LEVEL_PROCEDURE
544: ,p_module => l_log_module);
545: END IF;
546: xla_ae_journal_entry_pkg.g_global_status := xla_ae_journal_entry_pkg.C_INVALID;
547: x_value_type_code := null;
548: l_output_value := null;
549: xla_accounting_err_pkg.build_message
550: (p_appli_s_name => 'XLA'

Line 566: ,p_value_3 => xla_ae_journal_entry_pkg.g_cache_pad.pad_session_name

562: 'XLA_OWNER_TYPE'
563: ,l_component_type_code
564: )
565: ,p_token_3 => 'PAD_NAME'
566: ,p_value_3 => xla_ae_journal_entry_pkg.g_cache_pad.pad_session_name
567: ,p_token_4 => 'PAD_OWNER'
568: ,p_value_4 => xla_lookups_pkg.get_meaning(
569: 'XLA_OWNER_TYPE'
570: ,xla_ae_journal_entry_pkg.g_cache_pad.product_rule_type_code

Line 570: ,xla_ae_journal_entry_pkg.g_cache_pad.product_rule_type_code

566: ,p_value_3 => xla_ae_journal_entry_pkg.g_cache_pad.pad_session_name
567: ,p_token_4 => 'PAD_OWNER'
568: ,p_value_4 => xla_lookups_pkg.get_meaning(
569: 'XLA_OWNER_TYPE'
570: ,xla_ae_journal_entry_pkg.g_cache_pad.product_rule_type_code
571: )
572: ,p_entity_id => xla_ae_journal_entry_pkg.g_cache_event.entity_id
573: ,p_event_id => xla_ae_journal_entry_pkg.g_cache_event.event_id
574: ,p_ledger_id => xla_ae_journal_entry_pkg.g_cache_event.target_ledger_id

Line 572: ,p_entity_id => xla_ae_journal_entry_pkg.g_cache_event.entity_id

568: ,p_value_4 => xla_lookups_pkg.get_meaning(
569: 'XLA_OWNER_TYPE'
570: ,xla_ae_journal_entry_pkg.g_cache_pad.product_rule_type_code
571: )
572: ,p_entity_id => xla_ae_journal_entry_pkg.g_cache_event.entity_id
573: ,p_event_id => xla_ae_journal_entry_pkg.g_cache_event.event_id
574: ,p_ledger_id => xla_ae_journal_entry_pkg.g_cache_event.target_ledger_id
575: ,p_ae_header_id => NULL
576: );

Line 573: ,p_event_id => xla_ae_journal_entry_pkg.g_cache_event.event_id

569: 'XLA_OWNER_TYPE'
570: ,xla_ae_journal_entry_pkg.g_cache_pad.product_rule_type_code
571: )
572: ,p_entity_id => xla_ae_journal_entry_pkg.g_cache_event.entity_id
573: ,p_event_id => xla_ae_journal_entry_pkg.g_cache_event.event_id
574: ,p_ledger_id => xla_ae_journal_entry_pkg.g_cache_event.target_ledger_id
575: ,p_ae_header_id => NULL
576: );
577: RETURN l_output_value;

Line 574: ,p_ledger_id => xla_ae_journal_entry_pkg.g_cache_event.target_ledger_id

570: ,xla_ae_journal_entry_pkg.g_cache_pad.product_rule_type_code
571: )
572: ,p_entity_id => xla_ae_journal_entry_pkg.g_cache_event.entity_id
573: ,p_event_id => xla_ae_journal_entry_pkg.g_cache_event.event_id
574: ,p_ledger_id => xla_ae_journal_entry_pkg.g_cache_event.target_ledger_id
575: ,p_ae_header_id => NULL
576: );
577: RETURN l_output_value;
578: EXCEPTION

Line 676: l_gl_dates xla_ae_journal_entry_pkg.t_array_date;

672: l_tmp_amt NUMBER;
673: l_acc_rev_natural_side_code VARCHAR2(1);
674:
675: l_num_entries NUMBER;
676: l_gl_dates xla_ae_journal_entry_pkg.t_array_date;
677: l_accted_amts xla_ae_journal_entry_pkg.t_array_num;
678: l_entered_amts xla_ae_journal_entry_pkg.t_array_num;
679: l_period_names xla_ae_journal_entry_pkg.t_array_V15L;
680: l_recog_line_1 NUMBER;

Line 677: l_accted_amts xla_ae_journal_entry_pkg.t_array_num;

673: l_acc_rev_natural_side_code VARCHAR2(1);
674:
675: l_num_entries NUMBER;
676: l_gl_dates xla_ae_journal_entry_pkg.t_array_date;
677: l_accted_amts xla_ae_journal_entry_pkg.t_array_num;
678: l_entered_amts xla_ae_journal_entry_pkg.t_array_num;
679: l_period_names xla_ae_journal_entry_pkg.t_array_V15L;
680: l_recog_line_1 NUMBER;
681: l_recog_line_2 NUMBER;

Line 678: l_entered_amts xla_ae_journal_entry_pkg.t_array_num;

674:
675: l_num_entries NUMBER;
676: l_gl_dates xla_ae_journal_entry_pkg.t_array_date;
677: l_accted_amts xla_ae_journal_entry_pkg.t_array_num;
678: l_entered_amts xla_ae_journal_entry_pkg.t_array_num;
679: l_period_names xla_ae_journal_entry_pkg.t_array_V15L;
680: l_recog_line_1 NUMBER;
681: l_recog_line_2 NUMBER;
682:

Line 679: l_period_names xla_ae_journal_entry_pkg.t_array_V15L;

675: l_num_entries NUMBER;
676: l_gl_dates xla_ae_journal_entry_pkg.t_array_date;
677: l_accted_amts xla_ae_journal_entry_pkg.t_array_num;
678: l_entered_amts xla_ae_journal_entry_pkg.t_array_num;
679: l_period_names xla_ae_journal_entry_pkg.t_array_V15L;
680: l_recog_line_1 NUMBER;
681: l_recog_line_2 NUMBER;
682:
683: l_bflow_applied_to_amt_idx NUMBER; -- 5132302

Line 685: l_bflow_applied_to_amts xla_ae_journal_entry_pkg.t_array_num; -- 5132302

681: l_recog_line_2 NUMBER;
682:
683: l_bflow_applied_to_amt_idx NUMBER; -- 5132302
684: l_bflow_applied_to_amt NUMBER; -- 5132302
685: l_bflow_applied_to_amts xla_ae_journal_entry_pkg.t_array_num; -- 5132302
686:
687: l_event_id NUMBER; -- To handle MPA header Description: xla_ae_header_pkg.SetHdrDescription
688:
689: --l_rounding_ccy VARCHAR2(15); -- To handle MPA rounding 4262811b

Line 760: IF XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.target_ledger_id = XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.ledger_id OR

756: l_accrual_line_num := NULL; -- 4262811
757: l_tmp_amt := NULL; -- 4262811
758: --
759:
760: IF XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.target_ledger_id = XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.ledger_id OR
761: l_balance_type_code <> 'B' THEN
762: IF NVL(p_source_4,'
763: ') = 'LOAN_PAYABLE' AND
764: NVL(p_source_6,'

Line 850: XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.target_ledger_id;

846: --
847: XLA_AE_LINES_PKG.g_rec_lines.array_balance_type_code(XLA_AE_LINES_PKG.g_LineNumber) := l_balance_type_code;
848:
849: XLA_AE_LINES_PKG.g_rec_lines.array_ledger_id(XLA_AE_LINES_PKG.g_LineNumber) :=
850: XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.target_ledger_id;
851:
852: -- 4955764
853: XLA_AE_LINES_PKG.g_rec_lines.array_gl_date(XLA_AE_LINES_PKG.g_LineNumber) :=
854: XLA_AE_HEADER_PKG.g_rec_header_new.array_gl_date(g_array_event(p_event_id).array_value_num('header_index'));

Line 894: ,p_target_ledger_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.target_ledger_id) IN ('PRIMARY','ALC')

890: l_enc_upg_option := XLA_AE_LINES_PKG.g_rec_lines.array_enc_upg_option(XLA_AE_LINES_PKG.g_LineNumber);
891:
892: IF xla_accounting_cache_pkg.GetValueChar
893: (p_source_code => 'LEDGER_CATEGORY_CODE'
894: ,p_target_ledger_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.target_ledger_id) IN ('PRIMARY','ALC')
895: AND l_bflow_method_code = 'PRIOR_ENTRY'
896: -- AND (l_actual_upg_option = 'Y' OR l_enc_upg_option = 'Y') Bug 4922099
897: AND ( (NVL(l_actual_upg_option, 'N') IN ('Y', 'O')) OR
898: (NVL(l_enc_upg_option, 'N') IN ('Y', 'O'))

Line 1005: ,p_value_4 => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.application_name

1001: p_lookup_type => 'XLA_OWNER_TYPE'
1002: ,p_lookup_code => l_component_type_code
1003: )
1004: ,p_token_4 => 'PRODUCT_NAME'
1005: ,p_value_4 => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.application_name
1006: ,p_entity_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.entity_id
1007: ,p_event_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.event_id
1008: ,p_ledger_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.target_ledger_id
1009: ,p_ae_header_id => NULL

Line 1006: ,p_entity_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.entity_id

1002: ,p_lookup_code => l_component_type_code
1003: )
1004: ,p_token_4 => 'PRODUCT_NAME'
1005: ,p_value_4 => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.application_name
1006: ,p_entity_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.entity_id
1007: ,p_event_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.event_id
1008: ,p_ledger_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.target_ledger_id
1009: ,p_ae_header_id => NULL
1010: );

Line 1007: ,p_event_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.event_id

1003: )
1004: ,p_token_4 => 'PRODUCT_NAME'
1005: ,p_value_4 => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.application_name
1006: ,p_entity_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.entity_id
1007: ,p_event_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.event_id
1008: ,p_ledger_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.target_ledger_id
1009: ,p_ae_header_id => NULL
1010: );
1011:

Line 1008: ,p_ledger_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.target_ledger_id

1004: ,p_token_4 => 'PRODUCT_NAME'
1005: ,p_value_4 => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.application_name
1006: ,p_entity_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.entity_id
1007: ,p_event_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.event_id
1008: ,p_ledger_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.target_ledger_id
1009: ,p_ae_header_id => NULL
1010: );
1011:
1012: IF (C_LEVEL_ERROR>= g_log_level) THEN

Line 1039: XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus

1035: ----------------------------------------------------------------------------------
1036: -- 4219869 Business Flow
1037: -- Update journal entry status -- Need to generate this within IF
1038: ----------------------------------------------------------------------------------
1039: XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
1040: (p_hdr_idx => g_array_event(p_event_id).array_value_num('header_index')
1041: ,p_balance_type_code => l_balance_type_code
1042: );
1043:

Line 1084: IF (XLA_AE_JOURNAL_ENTRY_PKG.g_cache_ledgers_info.ledger_reversal_option = 'SIDE') THEN

1080:
1081: --
1082: -- Depending on the Reversal Method setup, do a switch side or changes sign for the amounts
1083: --
1084: IF (XLA_AE_JOURNAL_ENTRY_PKG.g_cache_ledgers_info.ledger_reversal_option = 'SIDE') THEN
1085: XLA_AE_LINES_PKG.g_rec_lines.array_natural_side_code(XLA_AE_LINES_PKG.g_LineNumber) := l_acc_rev_natural_side_code;
1086: ELSE
1087: ---------------------------------------------------------------------------------------------------
1088: -- 4262811a Switch Sign

Line 1109: XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus

1105:
1106: XLA_AE_LINES_PKG.ValidateCurrentLine;
1107: XLA_AE_LINES_PKG.SetDebitCreditAmounts;
1108:
1109: XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
1110: (p_hdr_idx => g_array_event(p_event_id).array_value_num('acc_rev_header_index')
1111: ,p_balance_type_code => l_balance_type_code);
1112:
1113: END IF;

Line 1231: l_gl_dates xla_ae_journal_entry_pkg.t_array_date;

1227: l_tmp_amt NUMBER;
1228: l_acc_rev_natural_side_code VARCHAR2(1);
1229:
1230: l_num_entries NUMBER;
1231: l_gl_dates xla_ae_journal_entry_pkg.t_array_date;
1232: l_accted_amts xla_ae_journal_entry_pkg.t_array_num;
1233: l_entered_amts xla_ae_journal_entry_pkg.t_array_num;
1234: l_period_names xla_ae_journal_entry_pkg.t_array_V15L;
1235: l_recog_line_1 NUMBER;

Line 1232: l_accted_amts xla_ae_journal_entry_pkg.t_array_num;

1228: l_acc_rev_natural_side_code VARCHAR2(1);
1229:
1230: l_num_entries NUMBER;
1231: l_gl_dates xla_ae_journal_entry_pkg.t_array_date;
1232: l_accted_amts xla_ae_journal_entry_pkg.t_array_num;
1233: l_entered_amts xla_ae_journal_entry_pkg.t_array_num;
1234: l_period_names xla_ae_journal_entry_pkg.t_array_V15L;
1235: l_recog_line_1 NUMBER;
1236: l_recog_line_2 NUMBER;

Line 1233: l_entered_amts xla_ae_journal_entry_pkg.t_array_num;

1229:
1230: l_num_entries NUMBER;
1231: l_gl_dates xla_ae_journal_entry_pkg.t_array_date;
1232: l_accted_amts xla_ae_journal_entry_pkg.t_array_num;
1233: l_entered_amts xla_ae_journal_entry_pkg.t_array_num;
1234: l_period_names xla_ae_journal_entry_pkg.t_array_V15L;
1235: l_recog_line_1 NUMBER;
1236: l_recog_line_2 NUMBER;
1237:

Line 1234: l_period_names xla_ae_journal_entry_pkg.t_array_V15L;

1230: l_num_entries NUMBER;
1231: l_gl_dates xla_ae_journal_entry_pkg.t_array_date;
1232: l_accted_amts xla_ae_journal_entry_pkg.t_array_num;
1233: l_entered_amts xla_ae_journal_entry_pkg.t_array_num;
1234: l_period_names xla_ae_journal_entry_pkg.t_array_V15L;
1235: l_recog_line_1 NUMBER;
1236: l_recog_line_2 NUMBER;
1237:
1238: l_bflow_applied_to_amt_idx NUMBER; -- 5132302

Line 1240: l_bflow_applied_to_amts xla_ae_journal_entry_pkg.t_array_num; -- 5132302

1236: l_recog_line_2 NUMBER;
1237:
1238: l_bflow_applied_to_amt_idx NUMBER; -- 5132302
1239: l_bflow_applied_to_amt NUMBER; -- 5132302
1240: l_bflow_applied_to_amts xla_ae_journal_entry_pkg.t_array_num; -- 5132302
1241:
1242: l_event_id NUMBER; -- To handle MPA header Description: xla_ae_header_pkg.SetHdrDescription
1243:
1244: --l_rounding_ccy VARCHAR2(15); -- To handle MPA rounding 4262811b

Line 1315: IF XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.target_ledger_id = XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.ledger_id OR

1311: l_accrual_line_num := NULL; -- 4262811
1312: l_tmp_amt := NULL; -- 4262811
1313: --
1314:
1315: IF XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.target_ledger_id = XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.ledger_id OR
1316: l_balance_type_code <> 'B' THEN
1317: IF NVL(p_source_4,'
1318: ') = 'LOAN_RECEIVABLE' AND
1319: NVL(p_source_6,'

Line 1405: XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.target_ledger_id;

1401: --
1402: XLA_AE_LINES_PKG.g_rec_lines.array_balance_type_code(XLA_AE_LINES_PKG.g_LineNumber) := l_balance_type_code;
1403:
1404: XLA_AE_LINES_PKG.g_rec_lines.array_ledger_id(XLA_AE_LINES_PKG.g_LineNumber) :=
1405: XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.target_ledger_id;
1406:
1407: -- 4955764
1408: XLA_AE_LINES_PKG.g_rec_lines.array_gl_date(XLA_AE_LINES_PKG.g_LineNumber) :=
1409: XLA_AE_HEADER_PKG.g_rec_header_new.array_gl_date(g_array_event(p_event_id).array_value_num('header_index'));

Line 1449: ,p_target_ledger_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.target_ledger_id) IN ('PRIMARY','ALC')

1445: l_enc_upg_option := XLA_AE_LINES_PKG.g_rec_lines.array_enc_upg_option(XLA_AE_LINES_PKG.g_LineNumber);
1446:
1447: IF xla_accounting_cache_pkg.GetValueChar
1448: (p_source_code => 'LEDGER_CATEGORY_CODE'
1449: ,p_target_ledger_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.target_ledger_id) IN ('PRIMARY','ALC')
1450: AND l_bflow_method_code = 'PRIOR_ENTRY'
1451: -- AND (l_actual_upg_option = 'Y' OR l_enc_upg_option = 'Y') Bug 4922099
1452: AND ( (NVL(l_actual_upg_option, 'N') IN ('Y', 'O')) OR
1453: (NVL(l_enc_upg_option, 'N') IN ('Y', 'O'))

Line 1560: ,p_value_4 => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.application_name

1556: p_lookup_type => 'XLA_OWNER_TYPE'
1557: ,p_lookup_code => l_component_type_code
1558: )
1559: ,p_token_4 => 'PRODUCT_NAME'
1560: ,p_value_4 => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.application_name
1561: ,p_entity_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.entity_id
1562: ,p_event_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.event_id
1563: ,p_ledger_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.target_ledger_id
1564: ,p_ae_header_id => NULL

Line 1561: ,p_entity_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.entity_id

1557: ,p_lookup_code => l_component_type_code
1558: )
1559: ,p_token_4 => 'PRODUCT_NAME'
1560: ,p_value_4 => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.application_name
1561: ,p_entity_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.entity_id
1562: ,p_event_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.event_id
1563: ,p_ledger_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.target_ledger_id
1564: ,p_ae_header_id => NULL
1565: );

Line 1562: ,p_event_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.event_id

1558: )
1559: ,p_token_4 => 'PRODUCT_NAME'
1560: ,p_value_4 => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.application_name
1561: ,p_entity_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.entity_id
1562: ,p_event_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.event_id
1563: ,p_ledger_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.target_ledger_id
1564: ,p_ae_header_id => NULL
1565: );
1566:

Line 1563: ,p_ledger_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.target_ledger_id

1559: ,p_token_4 => 'PRODUCT_NAME'
1560: ,p_value_4 => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.application_name
1561: ,p_entity_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.entity_id
1562: ,p_event_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.event_id
1563: ,p_ledger_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.target_ledger_id
1564: ,p_ae_header_id => NULL
1565: );
1566:
1567: IF (C_LEVEL_ERROR>= g_log_level) THEN

Line 1594: XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus

1590: ----------------------------------------------------------------------------------
1591: -- 4219869 Business Flow
1592: -- Update journal entry status -- Need to generate this within IF
1593: ----------------------------------------------------------------------------------
1594: XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
1595: (p_hdr_idx => g_array_event(p_event_id).array_value_num('header_index')
1596: ,p_balance_type_code => l_balance_type_code
1597: );
1598:

Line 1639: IF (XLA_AE_JOURNAL_ENTRY_PKG.g_cache_ledgers_info.ledger_reversal_option = 'SIDE') THEN

1635:
1636: --
1637: -- Depending on the Reversal Method setup, do a switch side or changes sign for the amounts
1638: --
1639: IF (XLA_AE_JOURNAL_ENTRY_PKG.g_cache_ledgers_info.ledger_reversal_option = 'SIDE') THEN
1640: XLA_AE_LINES_PKG.g_rec_lines.array_natural_side_code(XLA_AE_LINES_PKG.g_LineNumber) := l_acc_rev_natural_side_code;
1641: ELSE
1642: ---------------------------------------------------------------------------------------------------
1643: -- 4262811a Switch Sign

Line 1664: XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus

1660:
1661: XLA_AE_LINES_PKG.ValidateCurrentLine;
1662: XLA_AE_LINES_PKG.SetDebitCreditAmounts;
1663:
1664: XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
1665: (p_hdr_idx => g_array_event(p_event_id).array_value_num('acc_rev_header_index')
1666: ,p_balance_type_code => l_balance_type_code);
1667:
1668: END IF;

Line 1778: l_gl_dates xla_ae_journal_entry_pkg.t_array_date;

1774: l_tmp_amt NUMBER;
1775: l_acc_rev_natural_side_code VARCHAR2(1);
1776:
1777: l_num_entries NUMBER;
1778: l_gl_dates xla_ae_journal_entry_pkg.t_array_date;
1779: l_accted_amts xla_ae_journal_entry_pkg.t_array_num;
1780: l_entered_amts xla_ae_journal_entry_pkg.t_array_num;
1781: l_period_names xla_ae_journal_entry_pkg.t_array_V15L;
1782: l_recog_line_1 NUMBER;

Line 1779: l_accted_amts xla_ae_journal_entry_pkg.t_array_num;

1775: l_acc_rev_natural_side_code VARCHAR2(1);
1776:
1777: l_num_entries NUMBER;
1778: l_gl_dates xla_ae_journal_entry_pkg.t_array_date;
1779: l_accted_amts xla_ae_journal_entry_pkg.t_array_num;
1780: l_entered_amts xla_ae_journal_entry_pkg.t_array_num;
1781: l_period_names xla_ae_journal_entry_pkg.t_array_V15L;
1782: l_recog_line_1 NUMBER;
1783: l_recog_line_2 NUMBER;

Line 1780: l_entered_amts xla_ae_journal_entry_pkg.t_array_num;

1776:
1777: l_num_entries NUMBER;
1778: l_gl_dates xla_ae_journal_entry_pkg.t_array_date;
1779: l_accted_amts xla_ae_journal_entry_pkg.t_array_num;
1780: l_entered_amts xla_ae_journal_entry_pkg.t_array_num;
1781: l_period_names xla_ae_journal_entry_pkg.t_array_V15L;
1782: l_recog_line_1 NUMBER;
1783: l_recog_line_2 NUMBER;
1784:

Line 1781: l_period_names xla_ae_journal_entry_pkg.t_array_V15L;

1777: l_num_entries NUMBER;
1778: l_gl_dates xla_ae_journal_entry_pkg.t_array_date;
1779: l_accted_amts xla_ae_journal_entry_pkg.t_array_num;
1780: l_entered_amts xla_ae_journal_entry_pkg.t_array_num;
1781: l_period_names xla_ae_journal_entry_pkg.t_array_V15L;
1782: l_recog_line_1 NUMBER;
1783: l_recog_line_2 NUMBER;
1784:
1785: l_bflow_applied_to_amt_idx NUMBER; -- 5132302

Line 1787: l_bflow_applied_to_amts xla_ae_journal_entry_pkg.t_array_num; -- 5132302

1783: l_recog_line_2 NUMBER;
1784:
1785: l_bflow_applied_to_amt_idx NUMBER; -- 5132302
1786: l_bflow_applied_to_amt NUMBER; -- 5132302
1787: l_bflow_applied_to_amts xla_ae_journal_entry_pkg.t_array_num; -- 5132302
1788:
1789: l_event_id NUMBER; -- To handle MPA header Description: xla_ae_header_pkg.SetHdrDescription
1790:
1791: --l_rounding_ccy VARCHAR2(15); -- To handle MPA rounding 4262811b

Line 1862: IF XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.target_ledger_id = XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.ledger_id OR

1858: l_accrual_line_num := NULL; -- 4262811
1859: l_tmp_amt := NULL; -- 4262811
1860: --
1861:
1862: IF XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.target_ledger_id = XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.ledger_id OR
1863: l_balance_type_code <> 'B' THEN
1864: IF NVL(p_source_4,'
1865: ') = 'LOAN_CLEARING' AND
1866: NVL(p_source_6,'

Line 1944: XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.target_ledger_id;

1940: --
1941: XLA_AE_LINES_PKG.g_rec_lines.array_balance_type_code(XLA_AE_LINES_PKG.g_LineNumber) := l_balance_type_code;
1942:
1943: XLA_AE_LINES_PKG.g_rec_lines.array_ledger_id(XLA_AE_LINES_PKG.g_LineNumber) :=
1944: XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.target_ledger_id;
1945:
1946: -- 4955764
1947: XLA_AE_LINES_PKG.g_rec_lines.array_gl_date(XLA_AE_LINES_PKG.g_LineNumber) :=
1948: XLA_AE_HEADER_PKG.g_rec_header_new.array_gl_date(g_array_event(p_event_id).array_value_num('header_index'));

Line 1988: ,p_target_ledger_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.target_ledger_id) IN ('PRIMARY','ALC')

1984: l_enc_upg_option := XLA_AE_LINES_PKG.g_rec_lines.array_enc_upg_option(XLA_AE_LINES_PKG.g_LineNumber);
1985:
1986: IF xla_accounting_cache_pkg.GetValueChar
1987: (p_source_code => 'LEDGER_CATEGORY_CODE'
1988: ,p_target_ledger_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.target_ledger_id) IN ('PRIMARY','ALC')
1989: AND l_bflow_method_code = 'PRIOR_ENTRY'
1990: -- AND (l_actual_upg_option = 'Y' OR l_enc_upg_option = 'Y') Bug 4922099
1991: AND ( (NVL(l_actual_upg_option, 'N') IN ('Y', 'O')) OR
1992: (NVL(l_enc_upg_option, 'N') IN ('Y', 'O'))

Line 2099: ,p_value_4 => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.application_name

2095: p_lookup_type => 'XLA_OWNER_TYPE'
2096: ,p_lookup_code => l_component_type_code
2097: )
2098: ,p_token_4 => 'PRODUCT_NAME'
2099: ,p_value_4 => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.application_name
2100: ,p_entity_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.entity_id
2101: ,p_event_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.event_id
2102: ,p_ledger_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.target_ledger_id
2103: ,p_ae_header_id => NULL

Line 2100: ,p_entity_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.entity_id

2096: ,p_lookup_code => l_component_type_code
2097: )
2098: ,p_token_4 => 'PRODUCT_NAME'
2099: ,p_value_4 => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.application_name
2100: ,p_entity_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.entity_id
2101: ,p_event_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.event_id
2102: ,p_ledger_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.target_ledger_id
2103: ,p_ae_header_id => NULL
2104: );

Line 2101: ,p_event_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.event_id

2097: )
2098: ,p_token_4 => 'PRODUCT_NAME'
2099: ,p_value_4 => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.application_name
2100: ,p_entity_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.entity_id
2101: ,p_event_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.event_id
2102: ,p_ledger_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.target_ledger_id
2103: ,p_ae_header_id => NULL
2104: );
2105:

Line 2102: ,p_ledger_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.target_ledger_id

2098: ,p_token_4 => 'PRODUCT_NAME'
2099: ,p_value_4 => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.application_name
2100: ,p_entity_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.entity_id
2101: ,p_event_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.event_id
2102: ,p_ledger_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.target_ledger_id
2103: ,p_ae_header_id => NULL
2104: );
2105:
2106: IF (C_LEVEL_ERROR>= g_log_level) THEN

Line 2133: XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus

2129: ----------------------------------------------------------------------------------
2130: -- 4219869 Business Flow
2131: -- Update journal entry status -- Need to generate this within IF
2132: ----------------------------------------------------------------------------------
2133: XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
2134: (p_hdr_idx => g_array_event(p_event_id).array_value_num('header_index')
2135: ,p_balance_type_code => l_balance_type_code
2136: );
2137:

Line 2178: IF (XLA_AE_JOURNAL_ENTRY_PKG.g_cache_ledgers_info.ledger_reversal_option = 'SIDE') THEN

2174:
2175: --
2176: -- Depending on the Reversal Method setup, do a switch side or changes sign for the amounts
2177: --
2178: IF (XLA_AE_JOURNAL_ENTRY_PKG.g_cache_ledgers_info.ledger_reversal_option = 'SIDE') THEN
2179: XLA_AE_LINES_PKG.g_rec_lines.array_natural_side_code(XLA_AE_LINES_PKG.g_LineNumber) := l_acc_rev_natural_side_code;
2180: ELSE
2181: ---------------------------------------------------------------------------------------------------
2182: -- 4262811a Switch Sign

Line 2203: XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus

2199:
2200: XLA_AE_LINES_PKG.ValidateCurrentLine;
2201: XLA_AE_LINES_PKG.SetDebitCreditAmounts;
2202:
2203: XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
2204: (p_hdr_idx => g_array_event(p_event_id).array_value_num('acc_rev_header_index')
2205: ,p_balance_type_code => l_balance_type_code);
2206:
2207: END IF;

Line 2317: l_gl_dates xla_ae_journal_entry_pkg.t_array_date;

2313: l_tmp_amt NUMBER;
2314: l_acc_rev_natural_side_code VARCHAR2(1);
2315:
2316: l_num_entries NUMBER;
2317: l_gl_dates xla_ae_journal_entry_pkg.t_array_date;
2318: l_accted_amts xla_ae_journal_entry_pkg.t_array_num;
2319: l_entered_amts xla_ae_journal_entry_pkg.t_array_num;
2320: l_period_names xla_ae_journal_entry_pkg.t_array_V15L;
2321: l_recog_line_1 NUMBER;

Line 2318: l_accted_amts xla_ae_journal_entry_pkg.t_array_num;

2314: l_acc_rev_natural_side_code VARCHAR2(1);
2315:
2316: l_num_entries NUMBER;
2317: l_gl_dates xla_ae_journal_entry_pkg.t_array_date;
2318: l_accted_amts xla_ae_journal_entry_pkg.t_array_num;
2319: l_entered_amts xla_ae_journal_entry_pkg.t_array_num;
2320: l_period_names xla_ae_journal_entry_pkg.t_array_V15L;
2321: l_recog_line_1 NUMBER;
2322: l_recog_line_2 NUMBER;

Line 2319: l_entered_amts xla_ae_journal_entry_pkg.t_array_num;

2315:
2316: l_num_entries NUMBER;
2317: l_gl_dates xla_ae_journal_entry_pkg.t_array_date;
2318: l_accted_amts xla_ae_journal_entry_pkg.t_array_num;
2319: l_entered_amts xla_ae_journal_entry_pkg.t_array_num;
2320: l_period_names xla_ae_journal_entry_pkg.t_array_V15L;
2321: l_recog_line_1 NUMBER;
2322: l_recog_line_2 NUMBER;
2323:

Line 2320: l_period_names xla_ae_journal_entry_pkg.t_array_V15L;

2316: l_num_entries NUMBER;
2317: l_gl_dates xla_ae_journal_entry_pkg.t_array_date;
2318: l_accted_amts xla_ae_journal_entry_pkg.t_array_num;
2319: l_entered_amts xla_ae_journal_entry_pkg.t_array_num;
2320: l_period_names xla_ae_journal_entry_pkg.t_array_V15L;
2321: l_recog_line_1 NUMBER;
2322: l_recog_line_2 NUMBER;
2323:
2324: l_bflow_applied_to_amt_idx NUMBER; -- 5132302

Line 2326: l_bflow_applied_to_amts xla_ae_journal_entry_pkg.t_array_num; -- 5132302

2322: l_recog_line_2 NUMBER;
2323:
2324: l_bflow_applied_to_amt_idx NUMBER; -- 5132302
2325: l_bflow_applied_to_amt NUMBER; -- 5132302
2326: l_bflow_applied_to_amts xla_ae_journal_entry_pkg.t_array_num; -- 5132302
2327:
2328: l_event_id NUMBER; -- To handle MPA header Description: xla_ae_header_pkg.SetHdrDescription
2329:
2330: --l_rounding_ccy VARCHAR2(15); -- To handle MPA rounding 4262811b

Line 2401: IF XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.target_ledger_id = XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.ledger_id OR

2397: l_accrual_line_num := NULL; -- 4262811
2398: l_tmp_amt := NULL; -- 4262811
2399: --
2400:
2401: IF XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.target_ledger_id = XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.ledger_id OR
2402: l_balance_type_code <> 'B' THEN
2403: IF NVL(p_source_4,'
2404: ') = 'LOAN_RECEIVABLE' AND
2405: NVL(p_source_6,'

Line 2483: XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.target_ledger_id;

2479: --
2480: XLA_AE_LINES_PKG.g_rec_lines.array_balance_type_code(XLA_AE_LINES_PKG.g_LineNumber) := l_balance_type_code;
2481:
2482: XLA_AE_LINES_PKG.g_rec_lines.array_ledger_id(XLA_AE_LINES_PKG.g_LineNumber) :=
2483: XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.target_ledger_id;
2484:
2485: -- 4955764
2486: XLA_AE_LINES_PKG.g_rec_lines.array_gl_date(XLA_AE_LINES_PKG.g_LineNumber) :=
2487: XLA_AE_HEADER_PKG.g_rec_header_new.array_gl_date(g_array_event(p_event_id).array_value_num('header_index'));

Line 2527: ,p_target_ledger_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.target_ledger_id) IN ('PRIMARY','ALC')

2523: l_enc_upg_option := XLA_AE_LINES_PKG.g_rec_lines.array_enc_upg_option(XLA_AE_LINES_PKG.g_LineNumber);
2524:
2525: IF xla_accounting_cache_pkg.GetValueChar
2526: (p_source_code => 'LEDGER_CATEGORY_CODE'
2527: ,p_target_ledger_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.target_ledger_id) IN ('PRIMARY','ALC')
2528: AND l_bflow_method_code = 'PRIOR_ENTRY'
2529: -- AND (l_actual_upg_option = 'Y' OR l_enc_upg_option = 'Y') Bug 4922099
2530: AND ( (NVL(l_actual_upg_option, 'N') IN ('Y', 'O')) OR
2531: (NVL(l_enc_upg_option, 'N') IN ('Y', 'O'))

Line 2638: ,p_value_4 => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.application_name

2634: p_lookup_type => 'XLA_OWNER_TYPE'
2635: ,p_lookup_code => l_component_type_code
2636: )
2637: ,p_token_4 => 'PRODUCT_NAME'
2638: ,p_value_4 => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.application_name
2639: ,p_entity_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.entity_id
2640: ,p_event_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.event_id
2641: ,p_ledger_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.target_ledger_id
2642: ,p_ae_header_id => NULL

Line 2639: ,p_entity_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.entity_id

2635: ,p_lookup_code => l_component_type_code
2636: )
2637: ,p_token_4 => 'PRODUCT_NAME'
2638: ,p_value_4 => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.application_name
2639: ,p_entity_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.entity_id
2640: ,p_event_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.event_id
2641: ,p_ledger_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.target_ledger_id
2642: ,p_ae_header_id => NULL
2643: );

Line 2640: ,p_event_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.event_id

2636: )
2637: ,p_token_4 => 'PRODUCT_NAME'
2638: ,p_value_4 => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.application_name
2639: ,p_entity_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.entity_id
2640: ,p_event_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.event_id
2641: ,p_ledger_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.target_ledger_id
2642: ,p_ae_header_id => NULL
2643: );
2644:

Line 2641: ,p_ledger_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.target_ledger_id

2637: ,p_token_4 => 'PRODUCT_NAME'
2638: ,p_value_4 => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.application_name
2639: ,p_entity_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.entity_id
2640: ,p_event_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.event_id
2641: ,p_ledger_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.target_ledger_id
2642: ,p_ae_header_id => NULL
2643: );
2644:
2645: IF (C_LEVEL_ERROR>= g_log_level) THEN

Line 2672: XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus

2668: ----------------------------------------------------------------------------------
2669: -- 4219869 Business Flow
2670: -- Update journal entry status -- Need to generate this within IF
2671: ----------------------------------------------------------------------------------
2672: XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
2673: (p_hdr_idx => g_array_event(p_event_id).array_value_num('header_index')
2674: ,p_balance_type_code => l_balance_type_code
2675: );
2676:

Line 2717: IF (XLA_AE_JOURNAL_ENTRY_PKG.g_cache_ledgers_info.ledger_reversal_option = 'SIDE') THEN

2713:
2714: --
2715: -- Depending on the Reversal Method setup, do a switch side or changes sign for the amounts
2716: --
2717: IF (XLA_AE_JOURNAL_ENTRY_PKG.g_cache_ledgers_info.ledger_reversal_option = 'SIDE') THEN
2718: XLA_AE_LINES_PKG.g_rec_lines.array_natural_side_code(XLA_AE_LINES_PKG.g_LineNumber) := l_acc_rev_natural_side_code;
2719: ELSE
2720: ---------------------------------------------------------------------------------------------------
2721: -- 4262811a Switch Sign

Line 2742: XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus

2738:
2739: XLA_AE_LINES_PKG.ValidateCurrentLine;
2740: XLA_AE_LINES_PKG.SetDebitCreditAmounts;
2741:
2742: XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
2743: (p_hdr_idx => g_array_event(p_event_id).array_value_num('acc_rev_header_index')
2744: ,p_balance_type_code => l_balance_type_code);
2745:
2746: END IF;

Line 3003: l_array_legal_entity_id XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;

2999:
3000: l_calculate_acctd_flag VARCHAR2(1) :='Y';
3001: l_calculate_g_l_flag VARCHAR2(1) :='Y';
3002: --
3003: l_array_legal_entity_id XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
3004: l_array_entity_id XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
3005: l_array_entity_code XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L;
3006: l_array_transaction_num XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
3007: l_array_event_id XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;

Line 3004: l_array_entity_id XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;

3000: l_calculate_acctd_flag VARCHAR2(1) :='Y';
3001: l_calculate_g_l_flag VARCHAR2(1) :='Y';
3002: --
3003: l_array_legal_entity_id XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
3004: l_array_entity_id XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
3005: l_array_entity_code XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L;
3006: l_array_transaction_num XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
3007: l_array_event_id XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
3008: l_array_class_code XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L;

Line 3005: l_array_entity_code XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L;

3001: l_calculate_g_l_flag VARCHAR2(1) :='Y';
3002: --
3003: l_array_legal_entity_id XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
3004: l_array_entity_id XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
3005: l_array_entity_code XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L;
3006: l_array_transaction_num XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
3007: l_array_event_id XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
3008: l_array_class_code XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L;
3009: l_array_event_type XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L;

Line 3006: l_array_transaction_num XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;

3002: --
3003: l_array_legal_entity_id XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
3004: l_array_entity_id XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
3005: l_array_entity_code XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L;
3006: l_array_transaction_num XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
3007: l_array_event_id XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
3008: l_array_class_code XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L;
3009: l_array_event_type XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L;
3010: l_array_event_number XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;

Line 3007: l_array_event_id XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;

3003: l_array_legal_entity_id XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
3004: l_array_entity_id XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
3005: l_array_entity_code XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L;
3006: l_array_transaction_num XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
3007: l_array_event_id XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
3008: l_array_class_code XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L;
3009: l_array_event_type XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L;
3010: l_array_event_number XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
3011: l_array_event_date XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;

Line 3008: l_array_class_code XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L;

3004: l_array_entity_id XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
3005: l_array_entity_code XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L;
3006: l_array_transaction_num XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
3007: l_array_event_id XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
3008: l_array_class_code XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L;
3009: l_array_event_type XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L;
3010: l_array_event_number XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
3011: l_array_event_date XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
3012: l_array_transaction_date XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;

Line 3009: l_array_event_type XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L;

3005: l_array_entity_code XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L;
3006: l_array_transaction_num XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
3007: l_array_event_id XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
3008: l_array_class_code XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L;
3009: l_array_event_type XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L;
3010: l_array_event_number XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
3011: l_array_event_date XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
3012: l_array_transaction_date XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
3013: l_array_reference_num_1 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;

Line 3010: l_array_event_number XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;

3006: l_array_transaction_num XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
3007: l_array_event_id XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
3008: l_array_class_code XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L;
3009: l_array_event_type XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L;
3010: l_array_event_number XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
3011: l_array_event_date XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
3012: l_array_transaction_date XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
3013: l_array_reference_num_1 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
3014: l_array_reference_num_2 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;

Line 3011: l_array_event_date XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;

3007: l_array_event_id XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
3008: l_array_class_code XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L;
3009: l_array_event_type XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L;
3010: l_array_event_number XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
3011: l_array_event_date XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
3012: l_array_transaction_date XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
3013: l_array_reference_num_1 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
3014: l_array_reference_num_2 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
3015: l_array_reference_num_3 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;

Line 3012: l_array_transaction_date XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;

3008: l_array_class_code XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L;
3009: l_array_event_type XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L;
3010: l_array_event_number XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
3011: l_array_event_date XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
3012: l_array_transaction_date XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
3013: l_array_reference_num_1 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
3014: l_array_reference_num_2 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
3015: l_array_reference_num_3 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
3016: l_array_reference_num_4 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;

Line 3013: l_array_reference_num_1 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;

3009: l_array_event_type XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L;
3010: l_array_event_number XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
3011: l_array_event_date XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
3012: l_array_transaction_date XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
3013: l_array_reference_num_1 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
3014: l_array_reference_num_2 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
3015: l_array_reference_num_3 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
3016: l_array_reference_num_4 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
3017: l_array_reference_char_1 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;

Line 3014: l_array_reference_num_2 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;

3010: l_array_event_number XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
3011: l_array_event_date XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
3012: l_array_transaction_date XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
3013: l_array_reference_num_1 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
3014: l_array_reference_num_2 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
3015: l_array_reference_num_3 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
3016: l_array_reference_num_4 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
3017: l_array_reference_char_1 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
3018: l_array_reference_char_2 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;

Line 3015: l_array_reference_num_3 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;

3011: l_array_event_date XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
3012: l_array_transaction_date XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
3013: l_array_reference_num_1 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
3014: l_array_reference_num_2 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
3015: l_array_reference_num_3 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
3016: l_array_reference_num_4 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
3017: l_array_reference_char_1 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
3018: l_array_reference_char_2 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
3019: l_array_reference_char_3 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;

Line 3016: l_array_reference_num_4 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;

3012: l_array_transaction_date XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
3013: l_array_reference_num_1 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
3014: l_array_reference_num_2 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
3015: l_array_reference_num_3 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
3016: l_array_reference_num_4 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
3017: l_array_reference_char_1 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
3018: l_array_reference_char_2 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
3019: l_array_reference_char_3 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
3020: l_array_reference_char_4 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;

Line 3017: l_array_reference_char_1 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;

3013: l_array_reference_num_1 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
3014: l_array_reference_num_2 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
3015: l_array_reference_num_3 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
3016: l_array_reference_num_4 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
3017: l_array_reference_char_1 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
3018: l_array_reference_char_2 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
3019: l_array_reference_char_3 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
3020: l_array_reference_char_4 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
3021: l_array_reference_date_1 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;

Line 3018: l_array_reference_char_2 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;

3014: l_array_reference_num_2 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
3015: l_array_reference_num_3 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
3016: l_array_reference_num_4 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
3017: l_array_reference_char_1 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
3018: l_array_reference_char_2 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
3019: l_array_reference_char_3 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
3020: l_array_reference_char_4 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
3021: l_array_reference_date_1 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
3022: l_array_reference_date_2 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;

Line 3019: l_array_reference_char_3 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;

3015: l_array_reference_num_3 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
3016: l_array_reference_num_4 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
3017: l_array_reference_char_1 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
3018: l_array_reference_char_2 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
3019: l_array_reference_char_3 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
3020: l_array_reference_char_4 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
3021: l_array_reference_date_1 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
3022: l_array_reference_date_2 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
3023: l_array_reference_date_3 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;

Line 3020: l_array_reference_char_4 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;

3016: l_array_reference_num_4 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
3017: l_array_reference_char_1 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
3018: l_array_reference_char_2 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
3019: l_array_reference_char_3 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
3020: l_array_reference_char_4 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
3021: l_array_reference_date_1 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
3022: l_array_reference_date_2 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
3023: l_array_reference_date_3 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
3024: l_array_reference_date_4 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;

Line 3021: l_array_reference_date_1 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;

3017: l_array_reference_char_1 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
3018: l_array_reference_char_2 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
3019: l_array_reference_char_3 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
3020: l_array_reference_char_4 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
3021: l_array_reference_date_1 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
3022: l_array_reference_date_2 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
3023: l_array_reference_date_3 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
3024: l_array_reference_date_4 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
3025: l_array_event_created_by XLA_AE_JOURNAL_ENTRY_PKG.t_array_V100L;

Line 3022: l_array_reference_date_2 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;

3018: l_array_reference_char_2 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
3019: l_array_reference_char_3 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
3020: l_array_reference_char_4 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
3021: l_array_reference_date_1 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
3022: l_array_reference_date_2 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
3023: l_array_reference_date_3 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
3024: l_array_reference_date_4 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
3025: l_array_event_created_by XLA_AE_JOURNAL_ENTRY_PKG.t_array_V100L;
3026: l_array_budgetary_control_flag XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L;

Line 3023: l_array_reference_date_3 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;

3019: l_array_reference_char_3 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
3020: l_array_reference_char_4 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
3021: l_array_reference_date_1 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
3022: l_array_reference_date_2 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
3023: l_array_reference_date_3 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
3024: l_array_reference_date_4 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
3025: l_array_event_created_by XLA_AE_JOURNAL_ENTRY_PKG.t_array_V100L;
3026: l_array_budgetary_control_flag XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L;
3027:

Line 3024: l_array_reference_date_4 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;

3020: l_array_reference_char_4 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
3021: l_array_reference_date_1 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
3022: l_array_reference_date_2 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
3023: l_array_reference_date_3 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
3024: l_array_reference_date_4 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
3025: l_array_event_created_by XLA_AE_JOURNAL_ENTRY_PKG.t_array_V100L;
3026: l_array_budgetary_control_flag XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L;
3027:
3028: l_event_id NUMBER;

Line 3025: l_array_event_created_by XLA_AE_JOURNAL_ENTRY_PKG.t_array_V100L;

3021: l_array_reference_date_1 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
3022: l_array_reference_date_2 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
3023: l_array_reference_date_3 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
3024: l_array_reference_date_4 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
3025: l_array_event_created_by XLA_AE_JOURNAL_ENTRY_PKG.t_array_V100L;
3026: l_array_budgetary_control_flag XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L;
3027:
3028: l_event_id NUMBER;
3029: l_previous_event_id NUMBER;

Line 3026: l_array_budgetary_control_flag XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L;

3022: l_array_reference_date_2 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
3023: l_array_reference_date_3 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
3024: l_array_reference_date_4 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
3025: l_array_event_created_by XLA_AE_JOURNAL_ENTRY_PKG.t_array_V100L;
3026: l_array_budgetary_control_flag XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L;
3027:
3028: l_event_id NUMBER;
3029: l_previous_event_id NUMBER;
3030: l_first_event_id NUMBER;

Line 3044: l_array_extract_line_num xla_ae_journal_entry_pkg.t_array_Num;

3040: l_event_class_name VARCHAR2(80) := 'Direct Loan';
3041: l_description VARCHAR2(4000);
3042: l_transaction_reversal NUMBER;
3043: l_ae_header_id NUMBER;
3044: l_array_extract_line_num xla_ae_journal_entry_pkg.t_array_Num;
3045: l_log_module VARCHAR2(240);
3046: --
3047: l_acct_reversal_source VARCHAR2(30);
3048: l_trx_reversal_source VARCHAR2(30);

Line 3276: XLA_AE_JOURNAL_ENTRY_PKG.set_event_info

3272:
3273: --
3274: -- set event info as cache for other routines to refer event attributes
3275: --
3276: XLA_AE_JOURNAL_ENTRY_PKG.set_event_info
3277: (p_application_id => p_application_id
3278: ,p_primary_ledger_id => p_primary_ledger_id
3279: ,p_base_ledger_id => p_base_ledger_id
3280: ,p_target_ledger_id => p_target_ledger_id

Line 3309: XLA_AE_JOURNAL_ENTRY_PKG.g_global_status := XLA_AE_JOURNAL_ENTRY_PKG.C_VALID;

3305:
3306: --
3307: -- set the status of entry to C_VALID (0)
3308: --
3309: XLA_AE_JOURNAL_ENTRY_PKG.g_global_status := XLA_AE_JOURNAL_ENTRY_PKG.C_VALID;
3310:
3311: --
3312: -- initialize a row for ae header
3313: --

Line 3338: --g_array_event(l_event_id).array_value_num('actual_je_status') := XLA_AE_JOURNAL_ENTRY_PKG.C_NOT_CREATED;

3334: --
3335: -- initilaize the status of ae headers for diffrent balance types
3336: -- the status is initialised to C_NOT_CREATED (2)
3337: --
3338: --g_array_event(l_event_id).array_value_num('actual_je_status') := XLA_AE_JOURNAL_ENTRY_PKG.C_NOT_CREATED;
3339: --g_array_event(l_event_id).array_value_num('budget_je_status') := XLA_AE_JOURNAL_ENTRY_PKG.C_NOT_CREATED;
3340: --g_array_event(l_event_id).array_value_num('encumbrance_je_status') := XLA_AE_JOURNAL_ENTRY_PKG.C_NOT_CREATED;
3341:
3342: --

Line 3339: --g_array_event(l_event_id).array_value_num('budget_je_status') := XLA_AE_JOURNAL_ENTRY_PKG.C_NOT_CREATED;

3335: -- initilaize the status of ae headers for diffrent balance types
3336: -- the status is initialised to C_NOT_CREATED (2)
3337: --
3338: --g_array_event(l_event_id).array_value_num('actual_je_status') := XLA_AE_JOURNAL_ENTRY_PKG.C_NOT_CREATED;
3339: --g_array_event(l_event_id).array_value_num('budget_je_status') := XLA_AE_JOURNAL_ENTRY_PKG.C_NOT_CREATED;
3340: --g_array_event(l_event_id).array_value_num('encumbrance_je_status') := XLA_AE_JOURNAL_ENTRY_PKG.C_NOT_CREATED;
3341:
3342: --
3343: -- call api to validate and store accounting attributes for header

Line 3340: --g_array_event(l_event_id).array_value_num('encumbrance_je_status') := XLA_AE_JOURNAL_ENTRY_PKG.C_NOT_CREATED;

3336: -- the status is initialised to C_NOT_CREATED (2)
3337: --
3338: --g_array_event(l_event_id).array_value_num('actual_je_status') := XLA_AE_JOURNAL_ENTRY_PKG.C_NOT_CREATED;
3339: --g_array_event(l_event_id).array_value_num('budget_je_status') := XLA_AE_JOURNAL_ENTRY_PKG.C_NOT_CREATED;
3340: --g_array_event(l_event_id).array_value_num('encumbrance_je_status') := XLA_AE_JOURNAL_ENTRY_PKG.C_NOT_CREATED;
3341:
3342: --
3343: -- call api to validate and store accounting attributes for header
3344: --

Line 3386: xla_ae_journal_entry_pkg.g_global_status := xla_ae_journal_entry_pkg.C_INVALID;

3382: --
3383: l_trx_reversal_source := SUBSTR(NULL, 1,30);
3384:
3385: IF NVL(l_trx_reversal_source, 'N') NOT IN ('N','Y') THEN
3386: xla_ae_journal_entry_pkg.g_global_status := xla_ae_journal_entry_pkg.C_INVALID;
3387:
3388: xla_accounting_err_pkg.build_message
3389: (p_appli_s_name => 'XLA'
3390: ,p_msg_name => 'XLA_AP_INVALID_HDR_ATTR'

Line 3394: ,p_value_2 => xla_ae_journal_entry_pkg.g_cache_event.application_name

3390: ,p_msg_name => 'XLA_AP_INVALID_HDR_ATTR'
3391: ,p_token_1 => 'ACCT_ATTR_NAME'
3392: ,p_value_1 => xla_ae_sources_pkg.GetAccountingSourceName('TRX_ACCT_REVERSAL_OPTION')
3393: ,p_token_2 => 'PRODUCT_NAME'
3394: ,p_value_2 => xla_ae_journal_entry_pkg.g_cache_event.application_name
3395: ,p_entity_id => xla_ae_journal_entry_pkg.g_cache_event.entity_id
3396: ,p_event_id => xla_ae_journal_entry_pkg.g_cache_event.event_id
3397: ,p_ledger_id => xla_ae_journal_entry_pkg.g_cache_event.target_ledger_id);
3398:

Line 3395: ,p_entity_id => xla_ae_journal_entry_pkg.g_cache_event.entity_id

3391: ,p_token_1 => 'ACCT_ATTR_NAME'
3392: ,p_value_1 => xla_ae_sources_pkg.GetAccountingSourceName('TRX_ACCT_REVERSAL_OPTION')
3393: ,p_token_2 => 'PRODUCT_NAME'
3394: ,p_value_2 => xla_ae_journal_entry_pkg.g_cache_event.application_name
3395: ,p_entity_id => xla_ae_journal_entry_pkg.g_cache_event.entity_id
3396: ,p_event_id => xla_ae_journal_entry_pkg.g_cache_event.event_id
3397: ,p_ledger_id => xla_ae_journal_entry_pkg.g_cache_event.target_ledger_id);
3398:
3399: ELSIF NVL(l_trx_reversal_source, 'N') = 'Y' THEN

Line 3396: ,p_event_id => xla_ae_journal_entry_pkg.g_cache_event.event_id

3392: ,p_value_1 => xla_ae_sources_pkg.GetAccountingSourceName('TRX_ACCT_REVERSAL_OPTION')
3393: ,p_token_2 => 'PRODUCT_NAME'
3394: ,p_value_2 => xla_ae_journal_entry_pkg.g_cache_event.application_name
3395: ,p_entity_id => xla_ae_journal_entry_pkg.g_cache_event.entity_id
3396: ,p_event_id => xla_ae_journal_entry_pkg.g_cache_event.event_id
3397: ,p_ledger_id => xla_ae_journal_entry_pkg.g_cache_event.target_ledger_id);
3398:
3399: ELSIF NVL(l_trx_reversal_source, 'N') = 'Y' THEN
3400: --

Line 3397: ,p_ledger_id => xla_ae_journal_entry_pkg.g_cache_event.target_ledger_id);

3393: ,p_token_2 => 'PRODUCT_NAME'
3394: ,p_value_2 => xla_ae_journal_entry_pkg.g_cache_event.application_name
3395: ,p_entity_id => xla_ae_journal_entry_pkg.g_cache_event.entity_id
3396: ,p_event_id => xla_ae_journal_entry_pkg.g_cache_event.event_id
3397: ,p_ledger_id => xla_ae_journal_entry_pkg.g_cache_event.target_ledger_id);
3398:
3399: ELSIF NVL(l_trx_reversal_source, 'N') = 'Y' THEN
3400: --
3401: -- following sets the accounting attributes needed to reverse

Line 3416: XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus (p_hdr_idx => hdr_idx);

3412: ----------------------------------------------------------------
3413: -- 4262811 - update the header statuses to invalid in need be
3414: ----------------------------------------------------------------
3415: --
3416: XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus (p_hdr_idx => hdr_idx);
3417:
3418:
3419: -----------------------------------------------
3420: -- No accrual reversal for the event class/type

Line 3535: -- set the XLA_AE_JOURNAL_ENTRY_PKG.g_global_status to C_VALID (0)

3531: ,p_module => l_log_module);
3532: END IF;
3533:
3534: --
3535: -- set the XLA_AE_JOURNAL_ENTRY_PKG.g_global_status to C_VALID (0)
3536: --
3537: XLA_AE_JOURNAL_ENTRY_PKG.g_global_status := XLA_AE_JOURNAL_ENTRY_PKG.C_VALID;
3538: --
3539: -- set event info as cache for other routines to refer event attributes

Line 3537: XLA_AE_JOURNAL_ENTRY_PKG.g_global_status := XLA_AE_JOURNAL_ENTRY_PKG.C_VALID;

3533:
3534: --
3535: -- set the XLA_AE_JOURNAL_ENTRY_PKG.g_global_status to C_VALID (0)
3536: --
3537: XLA_AE_JOURNAL_ENTRY_PKG.g_global_status := XLA_AE_JOURNAL_ENTRY_PKG.C_VALID;
3538: --
3539: -- set event info as cache for other routines to refer event attributes
3540: --
3541:

Line 3545: XLA_AE_JOURNAL_ENTRY_PKG.set_event_info

3541:
3542: IF l_event_id <> NVL(l_previous_event_id, -1) THEN
3543: l_previous_event_id := l_event_id;
3544:
3545: XLA_AE_JOURNAL_ENTRY_PKG.set_event_info
3546: (p_application_id => p_application_id
3547: ,p_primary_ledger_id => p_primary_ledger_id
3548: ,p_base_ledger_id => p_base_ledger_id
3549: ,p_target_ledger_id => p_target_ledger_id

Line 3586: xla_ae_journal_entry_pkg.g_global_status := xla_ae_journal_entry_pkg.C_INVALID;

3582: l_acct_reversal_source := SUBSTR(NULL, 1,30);
3583:
3584: IF l_continue_with_lines THEN
3585: IF NVL(l_acct_reversal_source, 'N') NOT IN ('N','Y','B') THEN
3586: xla_ae_journal_entry_pkg.g_global_status := xla_ae_journal_entry_pkg.C_INVALID;
3587:
3588: xla_accounting_err_pkg.build_message
3589: (p_appli_s_name => 'XLA'
3590: ,p_msg_name => 'XLA_AP_INVALID_REVERSAL_OPTION'

Line 3594: ,p_value_2 => xla_ae_journal_entry_pkg.g_cache_event.application_name

3590: ,p_msg_name => 'XLA_AP_INVALID_REVERSAL_OPTION'
3591: ,p_token_1 => 'LINE_NUMBER'
3592: ,p_value_1 => l_array_extract_line_num(Idx)
3593: ,p_token_2 => 'PRODUCT_NAME'
3594: ,p_value_2 => xla_ae_journal_entry_pkg.g_cache_event.application_name
3595: ,p_entity_id => xla_ae_journal_entry_pkg.g_cache_event.entity_id
3596: ,p_event_id => xla_ae_journal_entry_pkg.g_cache_event.event_id
3597: ,p_ledger_id => xla_ae_journal_entry_pkg.g_cache_event.target_ledger_id);
3598:

Line 3595: ,p_entity_id => xla_ae_journal_entry_pkg.g_cache_event.entity_id

3591: ,p_token_1 => 'LINE_NUMBER'
3592: ,p_value_1 => l_array_extract_line_num(Idx)
3593: ,p_token_2 => 'PRODUCT_NAME'
3594: ,p_value_2 => xla_ae_journal_entry_pkg.g_cache_event.application_name
3595: ,p_entity_id => xla_ae_journal_entry_pkg.g_cache_event.entity_id
3596: ,p_event_id => xla_ae_journal_entry_pkg.g_cache_event.event_id
3597: ,p_ledger_id => xla_ae_journal_entry_pkg.g_cache_event.target_ledger_id);
3598:
3599: ELSIF NVL(l_acct_reversal_source, 'N') IN ('Y','B') THEN

Line 3596: ,p_event_id => xla_ae_journal_entry_pkg.g_cache_event.event_id

3592: ,p_value_1 => l_array_extract_line_num(Idx)
3593: ,p_token_2 => 'PRODUCT_NAME'
3594: ,p_value_2 => xla_ae_journal_entry_pkg.g_cache_event.application_name
3595: ,p_entity_id => xla_ae_journal_entry_pkg.g_cache_event.entity_id
3596: ,p_event_id => xla_ae_journal_entry_pkg.g_cache_event.event_id
3597: ,p_ledger_id => xla_ae_journal_entry_pkg.g_cache_event.target_ledger_id);
3598:
3599: ELSIF NVL(l_acct_reversal_source, 'N') IN ('Y','B') THEN
3600: --

Line 3597: ,p_ledger_id => xla_ae_journal_entry_pkg.g_cache_event.target_ledger_id);

3593: ,p_token_2 => 'PRODUCT_NAME'
3594: ,p_value_2 => xla_ae_journal_entry_pkg.g_cache_event.application_name
3595: ,p_entity_id => xla_ae_journal_entry_pkg.g_cache_event.entity_id
3596: ,p_event_id => xla_ae_journal_entry_pkg.g_cache_event.event_id
3597: ,p_ledger_id => xla_ae_journal_entry_pkg.g_cache_event.target_ledger_id);
3598:
3599: ELSIF NVL(l_acct_reversal_source, 'N') IN ('Y','B') THEN
3600: --
3601: -- following sets the accounting attributes needed to reverse

Line 3628: IF (((l_calculate_g_l_flag = 'Y' AND XLA_AE_JOURNAL_ENTRY_PKG.g_cache_ledgers_info.ledger_category_code <> 'ALC') or

3624: l_actual_flag := NULL; l_actual_gain_loss_ref := '#####';
3625: -- only execute it if calculate g/l flag is yes, and primary or secondary ledger
3626: -- or secondary ledger that has different currency with primary
3627: -- or alc that is calculated by sla
3628: IF (((l_calculate_g_l_flag = 'Y' AND XLA_AE_JOURNAL_ENTRY_PKG.g_cache_ledgers_info.ledger_category_code <> 'ALC') or
3629: (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'))
3630:
3631: -- IF((l_calculate_g_l_flag='Y' or XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.target_ledger_id <>
3632: -- XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.ledger_id)

Line 3629: (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'))

3625: -- only execute it if calculate g/l flag is yes, and primary or secondary ledger
3626: -- or secondary ledger that has different currency with primary
3627: -- or alc that is calculated by sla
3628: IF (((l_calculate_g_l_flag = 'Y' AND XLA_AE_JOURNAL_ENTRY_PKG.g_cache_ledgers_info.ledger_category_code <> 'ALC') or
3629: (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'))
3630:
3631: -- IF((l_calculate_g_l_flag='Y' or XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.target_ledger_id <>
3632: -- XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.ledger_id)
3633: AND (l_actual_flag = 'A')) THEN

Line 3631: -- IF((l_calculate_g_l_flag='Y' or XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.target_ledger_id <>

3627: -- or alc that is calculated by sla
3628: IF (((l_calculate_g_l_flag = 'Y' AND XLA_AE_JOURNAL_ENTRY_PKG.g_cache_ledgers_info.ledger_category_code <> 'ALC') or
3629: (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'))
3630:
3631: -- IF((l_calculate_g_l_flag='Y' or XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.target_ledger_id <>
3632: -- XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.ledger_id)
3633: AND (l_actual_flag = 'A')) THEN
3634: XLA_AE_LINES_PKG.CreateGainOrLossLines(
3635: p_event_id => xla_ae_journal_entry_pkg.g_cache_event.event_id

Line 3632: -- XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.ledger_id)

3628: IF (((l_calculate_g_l_flag = 'Y' AND XLA_AE_JOURNAL_ENTRY_PKG.g_cache_ledgers_info.ledger_category_code <> 'ALC') or
3629: (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'))
3630:
3631: -- IF((l_calculate_g_l_flag='Y' or XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.target_ledger_id <>
3632: -- XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.ledger_id)
3633: AND (l_actual_flag = 'A')) THEN
3634: XLA_AE_LINES_PKG.CreateGainOrLossLines(
3635: p_event_id => xla_ae_journal_entry_pkg.g_cache_event.event_id
3636: ,p_application_id => p_application_id

Line 3635: p_event_id => xla_ae_journal_entry_pkg.g_cache_event.event_id

3631: -- IF((l_calculate_g_l_flag='Y' or XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.target_ledger_id <>
3632: -- XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.ledger_id)
3633: AND (l_actual_flag = 'A')) THEN
3634: XLA_AE_LINES_PKG.CreateGainOrLossLines(
3635: p_event_id => xla_ae_journal_entry_pkg.g_cache_event.event_id
3636: ,p_application_id => p_application_id
3637: ,p_amb_context_code => 'DEFAULT'
3638: ,p_entity_code => xla_ae_journal_entry_pkg.g_cache_event.entity_code
3639: ,p_event_class_code => C_EVENT_CLASS_CODE

Line 3638: ,p_entity_code => xla_ae_journal_entry_pkg.g_cache_event.entity_code

3634: XLA_AE_LINES_PKG.CreateGainOrLossLines(
3635: p_event_id => xla_ae_journal_entry_pkg.g_cache_event.event_id
3636: ,p_application_id => p_application_id
3637: ,p_amb_context_code => 'DEFAULT'
3638: ,p_entity_code => xla_ae_journal_entry_pkg.g_cache_event.entity_code
3639: ,p_event_class_code => C_EVENT_CLASS_CODE
3640: ,p_event_type_code => C_EVENT_TYPE_CODE
3641:
3642: ,p_gain_ccid => -1

Line 4151: l_array_legal_entity_id XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;

4147:
4148: l_calculate_acctd_flag VARCHAR2(1) :='Y';
4149: l_calculate_g_l_flag VARCHAR2(1) :='Y';
4150: --
4151: l_array_legal_entity_id XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
4152: l_array_entity_id XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
4153: l_array_entity_code XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L;
4154: l_array_transaction_num XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
4155: l_array_event_id XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;

Line 4152: l_array_entity_id XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;

4148: l_calculate_acctd_flag VARCHAR2(1) :='Y';
4149: l_calculate_g_l_flag VARCHAR2(1) :='Y';
4150: --
4151: l_array_legal_entity_id XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
4152: l_array_entity_id XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
4153: l_array_entity_code XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L;
4154: l_array_transaction_num XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
4155: l_array_event_id XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
4156: l_array_class_code XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L;

Line 4153: l_array_entity_code XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L;

4149: l_calculate_g_l_flag VARCHAR2(1) :='Y';
4150: --
4151: l_array_legal_entity_id XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
4152: l_array_entity_id XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
4153: l_array_entity_code XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L;
4154: l_array_transaction_num XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
4155: l_array_event_id XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
4156: l_array_class_code XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L;
4157: l_array_event_type XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L;

Line 4154: l_array_transaction_num XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;

4150: --
4151: l_array_legal_entity_id XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
4152: l_array_entity_id XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
4153: l_array_entity_code XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L;
4154: l_array_transaction_num XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
4155: l_array_event_id XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
4156: l_array_class_code XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L;
4157: l_array_event_type XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L;
4158: l_array_event_number XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;

Line 4155: l_array_event_id XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;

4151: l_array_legal_entity_id XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
4152: l_array_entity_id XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
4153: l_array_entity_code XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L;
4154: l_array_transaction_num XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
4155: l_array_event_id XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
4156: l_array_class_code XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L;
4157: l_array_event_type XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L;
4158: l_array_event_number XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
4159: l_array_event_date XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;

Line 4156: l_array_class_code XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L;

4152: l_array_entity_id XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
4153: l_array_entity_code XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L;
4154: l_array_transaction_num XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
4155: l_array_event_id XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
4156: l_array_class_code XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L;
4157: l_array_event_type XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L;
4158: l_array_event_number XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
4159: l_array_event_date XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
4160: l_array_transaction_date XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;

Line 4157: l_array_event_type XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L;

4153: l_array_entity_code XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L;
4154: l_array_transaction_num XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
4155: l_array_event_id XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
4156: l_array_class_code XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L;
4157: l_array_event_type XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L;
4158: l_array_event_number XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
4159: l_array_event_date XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
4160: l_array_transaction_date XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
4161: l_array_reference_num_1 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;

Line 4158: l_array_event_number XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;

4154: l_array_transaction_num XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
4155: l_array_event_id XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
4156: l_array_class_code XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L;
4157: l_array_event_type XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L;
4158: l_array_event_number XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
4159: l_array_event_date XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
4160: l_array_transaction_date XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
4161: l_array_reference_num_1 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
4162: l_array_reference_num_2 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;

Line 4159: l_array_event_date XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;

4155: l_array_event_id XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
4156: l_array_class_code XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L;
4157: l_array_event_type XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L;
4158: l_array_event_number XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
4159: l_array_event_date XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
4160: l_array_transaction_date XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
4161: l_array_reference_num_1 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
4162: l_array_reference_num_2 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
4163: l_array_reference_num_3 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;

Line 4160: l_array_transaction_date XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;

4156: l_array_class_code XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L;
4157: l_array_event_type XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L;
4158: l_array_event_number XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
4159: l_array_event_date XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
4160: l_array_transaction_date XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
4161: l_array_reference_num_1 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
4162: l_array_reference_num_2 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
4163: l_array_reference_num_3 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
4164: l_array_reference_num_4 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;

Line 4161: l_array_reference_num_1 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;

4157: l_array_event_type XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L;
4158: l_array_event_number XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
4159: l_array_event_date XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
4160: l_array_transaction_date XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
4161: l_array_reference_num_1 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
4162: l_array_reference_num_2 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
4163: l_array_reference_num_3 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
4164: l_array_reference_num_4 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
4165: l_array_reference_char_1 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;

Line 4162: l_array_reference_num_2 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;

4158: l_array_event_number XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
4159: l_array_event_date XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
4160: l_array_transaction_date XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
4161: l_array_reference_num_1 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
4162: l_array_reference_num_2 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
4163: l_array_reference_num_3 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
4164: l_array_reference_num_4 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
4165: l_array_reference_char_1 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
4166: l_array_reference_char_2 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;

Line 4163: l_array_reference_num_3 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;

4159: l_array_event_date XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
4160: l_array_transaction_date XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
4161: l_array_reference_num_1 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
4162: l_array_reference_num_2 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
4163: l_array_reference_num_3 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
4164: l_array_reference_num_4 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
4165: l_array_reference_char_1 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
4166: l_array_reference_char_2 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
4167: l_array_reference_char_3 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;

Line 4164: l_array_reference_num_4 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;

4160: l_array_transaction_date XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
4161: l_array_reference_num_1 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
4162: l_array_reference_num_2 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
4163: l_array_reference_num_3 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
4164: l_array_reference_num_4 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
4165: l_array_reference_char_1 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
4166: l_array_reference_char_2 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
4167: l_array_reference_char_3 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
4168: l_array_reference_char_4 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;

Line 4165: l_array_reference_char_1 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;

4161: l_array_reference_num_1 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
4162: l_array_reference_num_2 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
4163: l_array_reference_num_3 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
4164: l_array_reference_num_4 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
4165: l_array_reference_char_1 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
4166: l_array_reference_char_2 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
4167: l_array_reference_char_3 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
4168: l_array_reference_char_4 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
4169: l_array_reference_date_1 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;

Line 4166: l_array_reference_char_2 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;

4162: l_array_reference_num_2 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
4163: l_array_reference_num_3 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
4164: l_array_reference_num_4 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
4165: l_array_reference_char_1 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
4166: l_array_reference_char_2 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
4167: l_array_reference_char_3 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
4168: l_array_reference_char_4 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
4169: l_array_reference_date_1 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
4170: l_array_reference_date_2 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;

Line 4167: l_array_reference_char_3 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;

4163: l_array_reference_num_3 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
4164: l_array_reference_num_4 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
4165: l_array_reference_char_1 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
4166: l_array_reference_char_2 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
4167: l_array_reference_char_3 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
4168: l_array_reference_char_4 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
4169: l_array_reference_date_1 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
4170: l_array_reference_date_2 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
4171: l_array_reference_date_3 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;

Line 4168: l_array_reference_char_4 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;

4164: l_array_reference_num_4 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
4165: l_array_reference_char_1 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
4166: l_array_reference_char_2 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
4167: l_array_reference_char_3 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
4168: l_array_reference_char_4 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
4169: l_array_reference_date_1 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
4170: l_array_reference_date_2 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
4171: l_array_reference_date_3 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
4172: l_array_reference_date_4 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;

Line 4169: l_array_reference_date_1 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;

4165: l_array_reference_char_1 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
4166: l_array_reference_char_2 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
4167: l_array_reference_char_3 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
4168: l_array_reference_char_4 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
4169: l_array_reference_date_1 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
4170: l_array_reference_date_2 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
4171: l_array_reference_date_3 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
4172: l_array_reference_date_4 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
4173: l_array_event_created_by XLA_AE_JOURNAL_ENTRY_PKG.t_array_V100L;

Line 4170: l_array_reference_date_2 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;

4166: l_array_reference_char_2 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
4167: l_array_reference_char_3 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
4168: l_array_reference_char_4 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
4169: l_array_reference_date_1 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
4170: l_array_reference_date_2 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
4171: l_array_reference_date_3 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
4172: l_array_reference_date_4 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
4173: l_array_event_created_by XLA_AE_JOURNAL_ENTRY_PKG.t_array_V100L;
4174: l_array_budgetary_control_flag XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L;

Line 4171: l_array_reference_date_3 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;

4167: l_array_reference_char_3 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
4168: l_array_reference_char_4 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
4169: l_array_reference_date_1 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
4170: l_array_reference_date_2 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
4171: l_array_reference_date_3 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
4172: l_array_reference_date_4 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
4173: l_array_event_created_by XLA_AE_JOURNAL_ENTRY_PKG.t_array_V100L;
4174: l_array_budgetary_control_flag XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L;
4175:

Line 4172: l_array_reference_date_4 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;

4168: l_array_reference_char_4 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
4169: l_array_reference_date_1 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
4170: l_array_reference_date_2 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
4171: l_array_reference_date_3 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
4172: l_array_reference_date_4 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
4173: l_array_event_created_by XLA_AE_JOURNAL_ENTRY_PKG.t_array_V100L;
4174: l_array_budgetary_control_flag XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L;
4175:
4176: l_event_id NUMBER;

Line 4173: l_array_event_created_by XLA_AE_JOURNAL_ENTRY_PKG.t_array_V100L;

4169: l_array_reference_date_1 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
4170: l_array_reference_date_2 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
4171: l_array_reference_date_3 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
4172: l_array_reference_date_4 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
4173: l_array_event_created_by XLA_AE_JOURNAL_ENTRY_PKG.t_array_V100L;
4174: l_array_budgetary_control_flag XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L;
4175:
4176: l_event_id NUMBER;
4177: l_previous_event_id NUMBER;

Line 4174: l_array_budgetary_control_flag XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L;

4170: l_array_reference_date_2 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
4171: l_array_reference_date_3 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
4172: l_array_reference_date_4 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
4173: l_array_event_created_by XLA_AE_JOURNAL_ENTRY_PKG.t_array_V100L;
4174: l_array_budgetary_control_flag XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L;
4175:
4176: l_event_id NUMBER;
4177: l_previous_event_id NUMBER;
4178: l_first_event_id NUMBER;

Line 4192: l_array_extract_line_num xla_ae_journal_entry_pkg.t_array_Num;

4188: l_event_class_name VARCHAR2(80) := 'Direct Loan';
4189: l_description VARCHAR2(4000);
4190: l_transaction_reversal NUMBER;
4191: l_ae_header_id NUMBER;
4192: l_array_extract_line_num xla_ae_journal_entry_pkg.t_array_Num;
4193: l_log_module VARCHAR2(240);
4194: --
4195: l_acct_reversal_source VARCHAR2(30);
4196: l_trx_reversal_source VARCHAR2(30);

Line 4517: XLA_AE_JOURNAL_ENTRY_PKG.set_event_info

4513:
4514: --
4515: -- set event info as cache for other routines to refer event attributes
4516: --
4517: XLA_AE_JOURNAL_ENTRY_PKG.set_event_info
4518: (p_application_id => p_application_id
4519: ,p_primary_ledger_id => p_primary_ledger_id
4520: ,p_base_ledger_id => p_base_ledger_id
4521: ,p_target_ledger_id => p_target_ledger_id

Line 4550: XLA_AE_JOURNAL_ENTRY_PKG.g_global_status := XLA_AE_JOURNAL_ENTRY_PKG.C_VALID;

4546:
4547: --
4548: -- set the status of entry to C_VALID (0)
4549: --
4550: XLA_AE_JOURNAL_ENTRY_PKG.g_global_status := XLA_AE_JOURNAL_ENTRY_PKG.C_VALID;
4551:
4552: --
4553: -- initialize a row for ae header
4554: --

Line 4586: --g_array_event(l_event_id).array_value_num('actual_je_status') := XLA_AE_JOURNAL_ENTRY_PKG.C_NOT_CREATED;

4582: --
4583: -- initilaize the status of ae headers for diffrent balance types
4584: -- the status is initialised to C_NOT_CREATED (2)
4585: --
4586: --g_array_event(l_event_id).array_value_num('actual_je_status') := XLA_AE_JOURNAL_ENTRY_PKG.C_NOT_CREATED;
4587: --g_array_event(l_event_id).array_value_num('budget_je_status') := XLA_AE_JOURNAL_ENTRY_PKG.C_NOT_CREATED;
4588: --g_array_event(l_event_id).array_value_num('encumbrance_je_status') := XLA_AE_JOURNAL_ENTRY_PKG.C_NOT_CREATED;
4589:
4590: --

Line 4587: --g_array_event(l_event_id).array_value_num('budget_je_status') := XLA_AE_JOURNAL_ENTRY_PKG.C_NOT_CREATED;

4583: -- initilaize the status of ae headers for diffrent balance types
4584: -- the status is initialised to C_NOT_CREATED (2)
4585: --
4586: --g_array_event(l_event_id).array_value_num('actual_je_status') := XLA_AE_JOURNAL_ENTRY_PKG.C_NOT_CREATED;
4587: --g_array_event(l_event_id).array_value_num('budget_je_status') := XLA_AE_JOURNAL_ENTRY_PKG.C_NOT_CREATED;
4588: --g_array_event(l_event_id).array_value_num('encumbrance_je_status') := XLA_AE_JOURNAL_ENTRY_PKG.C_NOT_CREATED;
4589:
4590: --
4591: -- call api to validate and store accounting attributes for header

Line 4588: --g_array_event(l_event_id).array_value_num('encumbrance_je_status') := XLA_AE_JOURNAL_ENTRY_PKG.C_NOT_CREATED;

4584: -- the status is initialised to C_NOT_CREATED (2)
4585: --
4586: --g_array_event(l_event_id).array_value_num('actual_je_status') := XLA_AE_JOURNAL_ENTRY_PKG.C_NOT_CREATED;
4587: --g_array_event(l_event_id).array_value_num('budget_je_status') := XLA_AE_JOURNAL_ENTRY_PKG.C_NOT_CREATED;
4588: --g_array_event(l_event_id).array_value_num('encumbrance_je_status') := XLA_AE_JOURNAL_ENTRY_PKG.C_NOT_CREATED;
4589:
4590: --
4591: -- call api to validate and store accounting attributes for header
4592: --

Line 4634: xla_ae_journal_entry_pkg.g_global_status := xla_ae_journal_entry_pkg.C_INVALID;

4630: --
4631: l_trx_reversal_source := SUBSTR(NULL, 1,30);
4632:
4633: IF NVL(l_trx_reversal_source, 'N') NOT IN ('N','Y') THEN
4634: xla_ae_journal_entry_pkg.g_global_status := xla_ae_journal_entry_pkg.C_INVALID;
4635:
4636: xla_accounting_err_pkg.build_message
4637: (p_appli_s_name => 'XLA'
4638: ,p_msg_name => 'XLA_AP_INVALID_HDR_ATTR'

Line 4642: ,p_value_2 => xla_ae_journal_entry_pkg.g_cache_event.application_name

4638: ,p_msg_name => 'XLA_AP_INVALID_HDR_ATTR'
4639: ,p_token_1 => 'ACCT_ATTR_NAME'
4640: ,p_value_1 => xla_ae_sources_pkg.GetAccountingSourceName('TRX_ACCT_REVERSAL_OPTION')
4641: ,p_token_2 => 'PRODUCT_NAME'
4642: ,p_value_2 => xla_ae_journal_entry_pkg.g_cache_event.application_name
4643: ,p_entity_id => xla_ae_journal_entry_pkg.g_cache_event.entity_id
4644: ,p_event_id => xla_ae_journal_entry_pkg.g_cache_event.event_id
4645: ,p_ledger_id => xla_ae_journal_entry_pkg.g_cache_event.target_ledger_id);
4646:

Line 4643: ,p_entity_id => xla_ae_journal_entry_pkg.g_cache_event.entity_id

4639: ,p_token_1 => 'ACCT_ATTR_NAME'
4640: ,p_value_1 => xla_ae_sources_pkg.GetAccountingSourceName('TRX_ACCT_REVERSAL_OPTION')
4641: ,p_token_2 => 'PRODUCT_NAME'
4642: ,p_value_2 => xla_ae_journal_entry_pkg.g_cache_event.application_name
4643: ,p_entity_id => xla_ae_journal_entry_pkg.g_cache_event.entity_id
4644: ,p_event_id => xla_ae_journal_entry_pkg.g_cache_event.event_id
4645: ,p_ledger_id => xla_ae_journal_entry_pkg.g_cache_event.target_ledger_id);
4646:
4647: ELSIF NVL(l_trx_reversal_source, 'N') = 'Y' THEN

Line 4644: ,p_event_id => xla_ae_journal_entry_pkg.g_cache_event.event_id

4640: ,p_value_1 => xla_ae_sources_pkg.GetAccountingSourceName('TRX_ACCT_REVERSAL_OPTION')
4641: ,p_token_2 => 'PRODUCT_NAME'
4642: ,p_value_2 => xla_ae_journal_entry_pkg.g_cache_event.application_name
4643: ,p_entity_id => xla_ae_journal_entry_pkg.g_cache_event.entity_id
4644: ,p_event_id => xla_ae_journal_entry_pkg.g_cache_event.event_id
4645: ,p_ledger_id => xla_ae_journal_entry_pkg.g_cache_event.target_ledger_id);
4646:
4647: ELSIF NVL(l_trx_reversal_source, 'N') = 'Y' THEN
4648: --

Line 4645: ,p_ledger_id => xla_ae_journal_entry_pkg.g_cache_event.target_ledger_id);

4641: ,p_token_2 => 'PRODUCT_NAME'
4642: ,p_value_2 => xla_ae_journal_entry_pkg.g_cache_event.application_name
4643: ,p_entity_id => xla_ae_journal_entry_pkg.g_cache_event.entity_id
4644: ,p_event_id => xla_ae_journal_entry_pkg.g_cache_event.event_id
4645: ,p_ledger_id => xla_ae_journal_entry_pkg.g_cache_event.target_ledger_id);
4646:
4647: ELSIF NVL(l_trx_reversal_source, 'N') = 'Y' THEN
4648: --
4649: -- following sets the accounting attributes needed to reverse

Line 4664: XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus (p_hdr_idx => hdr_idx);

4660: ----------------------------------------------------------------
4661: -- 4262811 - update the header statuses to invalid in need be
4662: ----------------------------------------------------------------
4663: --
4664: XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus (p_hdr_idx => hdr_idx);
4665:
4666:
4667: -----------------------------------------------
4668: -- No accrual reversal for the event class/type

Line 4796: -- set the XLA_AE_JOURNAL_ENTRY_PKG.g_global_status to C_VALID (0)

4792: ,p_module => l_log_module);
4793: END IF;
4794:
4795: --
4796: -- set the XLA_AE_JOURNAL_ENTRY_PKG.g_global_status to C_VALID (0)
4797: --
4798: XLA_AE_JOURNAL_ENTRY_PKG.g_global_status := XLA_AE_JOURNAL_ENTRY_PKG.C_VALID;
4799: --
4800: -- set event info as cache for other routines to refer event attributes

Line 4798: XLA_AE_JOURNAL_ENTRY_PKG.g_global_status := XLA_AE_JOURNAL_ENTRY_PKG.C_VALID;

4794:
4795: --
4796: -- set the XLA_AE_JOURNAL_ENTRY_PKG.g_global_status to C_VALID (0)
4797: --
4798: XLA_AE_JOURNAL_ENTRY_PKG.g_global_status := XLA_AE_JOURNAL_ENTRY_PKG.C_VALID;
4799: --
4800: -- set event info as cache for other routines to refer event attributes
4801: --
4802:

Line 4806: XLA_AE_JOURNAL_ENTRY_PKG.set_event_info

4802:
4803: IF l_event_id <> NVL(l_previous_event_id, -1) THEN
4804: l_previous_event_id := l_event_id;
4805:
4806: XLA_AE_JOURNAL_ENTRY_PKG.set_event_info
4807: (p_application_id => p_application_id
4808: ,p_primary_ledger_id => p_primary_ledger_id
4809: ,p_base_ledger_id => p_base_ledger_id
4810: ,p_target_ledger_id => p_target_ledger_id

Line 4847: xla_ae_journal_entry_pkg.g_global_status := xla_ae_journal_entry_pkg.C_INVALID;

4843: l_acct_reversal_source := SUBSTR(NULL, 1,30);
4844:
4845: IF l_continue_with_lines THEN
4846: IF NVL(l_acct_reversal_source, 'N') NOT IN ('N','Y','B') THEN
4847: xla_ae_journal_entry_pkg.g_global_status := xla_ae_journal_entry_pkg.C_INVALID;
4848:
4849: xla_accounting_err_pkg.build_message
4850: (p_appli_s_name => 'XLA'
4851: ,p_msg_name => 'XLA_AP_INVALID_REVERSAL_OPTION'

Line 4855: ,p_value_2 => xla_ae_journal_entry_pkg.g_cache_event.application_name

4851: ,p_msg_name => 'XLA_AP_INVALID_REVERSAL_OPTION'
4852: ,p_token_1 => 'LINE_NUMBER'
4853: ,p_value_1 => l_array_extract_line_num(Idx)
4854: ,p_token_2 => 'PRODUCT_NAME'
4855: ,p_value_2 => xla_ae_journal_entry_pkg.g_cache_event.application_name
4856: ,p_entity_id => xla_ae_journal_entry_pkg.g_cache_event.entity_id
4857: ,p_event_id => xla_ae_journal_entry_pkg.g_cache_event.event_id
4858: ,p_ledger_id => xla_ae_journal_entry_pkg.g_cache_event.target_ledger_id);
4859:

Line 4856: ,p_entity_id => xla_ae_journal_entry_pkg.g_cache_event.entity_id

4852: ,p_token_1 => 'LINE_NUMBER'
4853: ,p_value_1 => l_array_extract_line_num(Idx)
4854: ,p_token_2 => 'PRODUCT_NAME'
4855: ,p_value_2 => xla_ae_journal_entry_pkg.g_cache_event.application_name
4856: ,p_entity_id => xla_ae_journal_entry_pkg.g_cache_event.entity_id
4857: ,p_event_id => xla_ae_journal_entry_pkg.g_cache_event.event_id
4858: ,p_ledger_id => xla_ae_journal_entry_pkg.g_cache_event.target_ledger_id);
4859:
4860: ELSIF NVL(l_acct_reversal_source, 'N') IN ('Y','B') THEN

Line 4857: ,p_event_id => xla_ae_journal_entry_pkg.g_cache_event.event_id

4853: ,p_value_1 => l_array_extract_line_num(Idx)
4854: ,p_token_2 => 'PRODUCT_NAME'
4855: ,p_value_2 => xla_ae_journal_entry_pkg.g_cache_event.application_name
4856: ,p_entity_id => xla_ae_journal_entry_pkg.g_cache_event.entity_id
4857: ,p_event_id => xla_ae_journal_entry_pkg.g_cache_event.event_id
4858: ,p_ledger_id => xla_ae_journal_entry_pkg.g_cache_event.target_ledger_id);
4859:
4860: ELSIF NVL(l_acct_reversal_source, 'N') IN ('Y','B') THEN
4861: --

Line 4858: ,p_ledger_id => xla_ae_journal_entry_pkg.g_cache_event.target_ledger_id);

4854: ,p_token_2 => 'PRODUCT_NAME'
4855: ,p_value_2 => xla_ae_journal_entry_pkg.g_cache_event.application_name
4856: ,p_entity_id => xla_ae_journal_entry_pkg.g_cache_event.entity_id
4857: ,p_event_id => xla_ae_journal_entry_pkg.g_cache_event.event_id
4858: ,p_ledger_id => xla_ae_journal_entry_pkg.g_cache_event.target_ledger_id);
4859:
4860: ELSIF NVL(l_acct_reversal_source, 'N') IN ('Y','B') THEN
4861: --
4862: -- following sets the accounting attributes needed to reverse

Line 4965: IF (((l_calculate_g_l_flag = 'Y' AND XLA_AE_JOURNAL_ENTRY_PKG.g_cache_ledgers_info.ledger_category_code <> 'ALC') or

4961:
4962: -- only execute it if calculate g/l flag is yes, and primary or secondary ledger
4963: -- or secondary ledger that has different currency with primary
4964: -- or alc that is calculated by sla
4965: IF (((l_calculate_g_l_flag = 'Y' AND XLA_AE_JOURNAL_ENTRY_PKG.g_cache_ledgers_info.ledger_category_code <> 'ALC') or
4966: (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'))
4967:
4968: -- IF((l_calculate_g_l_flag='Y' or XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.target_ledger_id <>
4969: -- XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.ledger_id)

Line 4966: (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'))

4962: -- only execute it if calculate g/l flag is yes, and primary or secondary ledger
4963: -- or secondary ledger that has different currency with primary
4964: -- or alc that is calculated by sla
4965: IF (((l_calculate_g_l_flag = 'Y' AND XLA_AE_JOURNAL_ENTRY_PKG.g_cache_ledgers_info.ledger_category_code <> 'ALC') or
4966: (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'))
4967:
4968: -- IF((l_calculate_g_l_flag='Y' or XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.target_ledger_id <>
4969: -- XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.ledger_id)
4970: AND (l_actual_flag = 'A')) THEN

Line 4968: -- IF((l_calculate_g_l_flag='Y' or XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.target_ledger_id <>

4964: -- or alc that is calculated by sla
4965: IF (((l_calculate_g_l_flag = 'Y' AND XLA_AE_JOURNAL_ENTRY_PKG.g_cache_ledgers_info.ledger_category_code <> 'ALC') or
4966: (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'))
4967:
4968: -- IF((l_calculate_g_l_flag='Y' or XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.target_ledger_id <>
4969: -- XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.ledger_id)
4970: AND (l_actual_flag = 'A')) THEN
4971: XLA_AE_LINES_PKG.CreateGainOrLossLines(
4972: p_event_id => xla_ae_journal_entry_pkg.g_cache_event.event_id

Line 4969: -- XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.ledger_id)

4965: IF (((l_calculate_g_l_flag = 'Y' AND XLA_AE_JOURNAL_ENTRY_PKG.g_cache_ledgers_info.ledger_category_code <> 'ALC') or
4966: (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'))
4967:
4968: -- IF((l_calculate_g_l_flag='Y' or XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.target_ledger_id <>
4969: -- XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.ledger_id)
4970: AND (l_actual_flag = 'A')) THEN
4971: XLA_AE_LINES_PKG.CreateGainOrLossLines(
4972: p_event_id => xla_ae_journal_entry_pkg.g_cache_event.event_id
4973: ,p_application_id => p_application_id

Line 4972: p_event_id => xla_ae_journal_entry_pkg.g_cache_event.event_id

4968: -- IF((l_calculate_g_l_flag='Y' or XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.target_ledger_id <>
4969: -- XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.ledger_id)
4970: AND (l_actual_flag = 'A')) THEN
4971: XLA_AE_LINES_PKG.CreateGainOrLossLines(
4972: p_event_id => xla_ae_journal_entry_pkg.g_cache_event.event_id
4973: ,p_application_id => p_application_id
4974: ,p_amb_context_code => 'DEFAULT'
4975: ,p_entity_code => xla_ae_journal_entry_pkg.g_cache_event.entity_code
4976: ,p_event_class_code => C_EVENT_CLASS_CODE

Line 4975: ,p_entity_code => xla_ae_journal_entry_pkg.g_cache_event.entity_code

4971: XLA_AE_LINES_PKG.CreateGainOrLossLines(
4972: p_event_id => xla_ae_journal_entry_pkg.g_cache_event.event_id
4973: ,p_application_id => p_application_id
4974: ,p_amb_context_code => 'DEFAULT'
4975: ,p_entity_code => xla_ae_journal_entry_pkg.g_cache_event.entity_code
4976: ,p_event_class_code => C_EVENT_CLASS_CODE
4977: ,p_event_type_code => C_EVENT_TYPE_CODE
4978:
4979: ,p_gain_ccid => -1

Line 5462: l_array_legal_entity_id XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;

5458:
5459: l_calculate_acctd_flag VARCHAR2(1) :='Y';
5460: l_calculate_g_l_flag VARCHAR2(1) :='Y';
5461: --
5462: l_array_legal_entity_id XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
5463: l_array_entity_id XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
5464: l_array_entity_code XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L;
5465: l_array_transaction_num XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
5466: l_array_event_id XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;

Line 5463: l_array_entity_id XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;

5459: l_calculate_acctd_flag VARCHAR2(1) :='Y';
5460: l_calculate_g_l_flag VARCHAR2(1) :='Y';
5461: --
5462: l_array_legal_entity_id XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
5463: l_array_entity_id XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
5464: l_array_entity_code XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L;
5465: l_array_transaction_num XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
5466: l_array_event_id XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
5467: l_array_class_code XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L;

Line 5464: l_array_entity_code XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L;

5460: l_calculate_g_l_flag VARCHAR2(1) :='Y';
5461: --
5462: l_array_legal_entity_id XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
5463: l_array_entity_id XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
5464: l_array_entity_code XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L;
5465: l_array_transaction_num XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
5466: l_array_event_id XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
5467: l_array_class_code XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L;
5468: l_array_event_type XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L;

Line 5465: l_array_transaction_num XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;

5461: --
5462: l_array_legal_entity_id XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
5463: l_array_entity_id XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
5464: l_array_entity_code XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L;
5465: l_array_transaction_num XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
5466: l_array_event_id XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
5467: l_array_class_code XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L;
5468: l_array_event_type XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L;
5469: l_array_event_number XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;

Line 5466: l_array_event_id XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;

5462: l_array_legal_entity_id XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
5463: l_array_entity_id XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
5464: l_array_entity_code XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L;
5465: l_array_transaction_num XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
5466: l_array_event_id XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
5467: l_array_class_code XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L;
5468: l_array_event_type XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L;
5469: l_array_event_number XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
5470: l_array_event_date XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;

Line 5467: l_array_class_code XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L;

5463: l_array_entity_id XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
5464: l_array_entity_code XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L;
5465: l_array_transaction_num XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
5466: l_array_event_id XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
5467: l_array_class_code XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L;
5468: l_array_event_type XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L;
5469: l_array_event_number XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
5470: l_array_event_date XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
5471: l_array_transaction_date XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;

Line 5468: l_array_event_type XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L;

5464: l_array_entity_code XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L;
5465: l_array_transaction_num XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
5466: l_array_event_id XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
5467: l_array_class_code XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L;
5468: l_array_event_type XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L;
5469: l_array_event_number XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
5470: l_array_event_date XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
5471: l_array_transaction_date XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
5472: l_array_reference_num_1 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;

Line 5469: l_array_event_number XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;

5465: l_array_transaction_num XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
5466: l_array_event_id XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
5467: l_array_class_code XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L;
5468: l_array_event_type XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L;
5469: l_array_event_number XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
5470: l_array_event_date XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
5471: l_array_transaction_date XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
5472: l_array_reference_num_1 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
5473: l_array_reference_num_2 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;

Line 5470: l_array_event_date XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;

5466: l_array_event_id XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
5467: l_array_class_code XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L;
5468: l_array_event_type XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L;
5469: l_array_event_number XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
5470: l_array_event_date XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
5471: l_array_transaction_date XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
5472: l_array_reference_num_1 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
5473: l_array_reference_num_2 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
5474: l_array_reference_num_3 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;

Line 5471: l_array_transaction_date XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;

5467: l_array_class_code XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L;
5468: l_array_event_type XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L;
5469: l_array_event_number XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
5470: l_array_event_date XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
5471: l_array_transaction_date XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
5472: l_array_reference_num_1 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
5473: l_array_reference_num_2 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
5474: l_array_reference_num_3 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
5475: l_array_reference_num_4 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;

Line 5472: l_array_reference_num_1 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;

5468: l_array_event_type XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L;
5469: l_array_event_number XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
5470: l_array_event_date XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
5471: l_array_transaction_date XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
5472: l_array_reference_num_1 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
5473: l_array_reference_num_2 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
5474: l_array_reference_num_3 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
5475: l_array_reference_num_4 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
5476: l_array_reference_char_1 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;

Line 5473: l_array_reference_num_2 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;

5469: l_array_event_number XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
5470: l_array_event_date XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
5471: l_array_transaction_date XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
5472: l_array_reference_num_1 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
5473: l_array_reference_num_2 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
5474: l_array_reference_num_3 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
5475: l_array_reference_num_4 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
5476: l_array_reference_char_1 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
5477: l_array_reference_char_2 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;

Line 5474: l_array_reference_num_3 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;

5470: l_array_event_date XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
5471: l_array_transaction_date XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
5472: l_array_reference_num_1 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
5473: l_array_reference_num_2 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
5474: l_array_reference_num_3 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
5475: l_array_reference_num_4 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
5476: l_array_reference_char_1 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
5477: l_array_reference_char_2 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
5478: l_array_reference_char_3 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;

Line 5475: l_array_reference_num_4 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;

5471: l_array_transaction_date XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
5472: l_array_reference_num_1 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
5473: l_array_reference_num_2 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
5474: l_array_reference_num_3 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
5475: l_array_reference_num_4 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
5476: l_array_reference_char_1 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
5477: l_array_reference_char_2 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
5478: l_array_reference_char_3 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
5479: l_array_reference_char_4 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;

Line 5476: l_array_reference_char_1 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;

5472: l_array_reference_num_1 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
5473: l_array_reference_num_2 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
5474: l_array_reference_num_3 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
5475: l_array_reference_num_4 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
5476: l_array_reference_char_1 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
5477: l_array_reference_char_2 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
5478: l_array_reference_char_3 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
5479: l_array_reference_char_4 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
5480: l_array_reference_date_1 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;

Line 5477: l_array_reference_char_2 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;

5473: l_array_reference_num_2 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
5474: l_array_reference_num_3 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
5475: l_array_reference_num_4 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
5476: l_array_reference_char_1 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
5477: l_array_reference_char_2 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
5478: l_array_reference_char_3 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
5479: l_array_reference_char_4 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
5480: l_array_reference_date_1 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
5481: l_array_reference_date_2 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;

Line 5478: l_array_reference_char_3 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;

5474: l_array_reference_num_3 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
5475: l_array_reference_num_4 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
5476: l_array_reference_char_1 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
5477: l_array_reference_char_2 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
5478: l_array_reference_char_3 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
5479: l_array_reference_char_4 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
5480: l_array_reference_date_1 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
5481: l_array_reference_date_2 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
5482: l_array_reference_date_3 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;

Line 5479: l_array_reference_char_4 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;

5475: l_array_reference_num_4 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
5476: l_array_reference_char_1 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
5477: l_array_reference_char_2 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
5478: l_array_reference_char_3 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
5479: l_array_reference_char_4 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
5480: l_array_reference_date_1 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
5481: l_array_reference_date_2 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
5482: l_array_reference_date_3 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
5483: l_array_reference_date_4 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;

Line 5480: l_array_reference_date_1 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;

5476: l_array_reference_char_1 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
5477: l_array_reference_char_2 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
5478: l_array_reference_char_3 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
5479: l_array_reference_char_4 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
5480: l_array_reference_date_1 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
5481: l_array_reference_date_2 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
5482: l_array_reference_date_3 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
5483: l_array_reference_date_4 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
5484: l_array_event_created_by XLA_AE_JOURNAL_ENTRY_PKG.t_array_V100L;

Line 5481: l_array_reference_date_2 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;

5477: l_array_reference_char_2 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
5478: l_array_reference_char_3 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
5479: l_array_reference_char_4 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
5480: l_array_reference_date_1 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
5481: l_array_reference_date_2 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
5482: l_array_reference_date_3 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
5483: l_array_reference_date_4 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
5484: l_array_event_created_by XLA_AE_JOURNAL_ENTRY_PKG.t_array_V100L;
5485: l_array_budgetary_control_flag XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L;

Line 5482: l_array_reference_date_3 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;

5478: l_array_reference_char_3 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
5479: l_array_reference_char_4 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
5480: l_array_reference_date_1 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
5481: l_array_reference_date_2 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
5482: l_array_reference_date_3 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
5483: l_array_reference_date_4 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
5484: l_array_event_created_by XLA_AE_JOURNAL_ENTRY_PKG.t_array_V100L;
5485: l_array_budgetary_control_flag XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L;
5486:

Line 5483: l_array_reference_date_4 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;

5479: l_array_reference_char_4 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
5480: l_array_reference_date_1 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
5481: l_array_reference_date_2 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
5482: l_array_reference_date_3 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
5483: l_array_reference_date_4 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
5484: l_array_event_created_by XLA_AE_JOURNAL_ENTRY_PKG.t_array_V100L;
5485: l_array_budgetary_control_flag XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L;
5486:
5487: l_event_id NUMBER;

Line 5484: l_array_event_created_by XLA_AE_JOURNAL_ENTRY_PKG.t_array_V100L;

5480: l_array_reference_date_1 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
5481: l_array_reference_date_2 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
5482: l_array_reference_date_3 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
5483: l_array_reference_date_4 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
5484: l_array_event_created_by XLA_AE_JOURNAL_ENTRY_PKG.t_array_V100L;
5485: l_array_budgetary_control_flag XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L;
5486:
5487: l_event_id NUMBER;
5488: l_previous_event_id NUMBER;

Line 5485: l_array_budgetary_control_flag XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L;

5481: l_array_reference_date_2 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
5482: l_array_reference_date_3 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
5483: l_array_reference_date_4 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
5484: l_array_event_created_by XLA_AE_JOURNAL_ENTRY_PKG.t_array_V100L;
5485: l_array_budgetary_control_flag XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L;
5486:
5487: l_event_id NUMBER;
5488: l_previous_event_id NUMBER;
5489: l_first_event_id NUMBER;

Line 5503: l_array_extract_line_num xla_ae_journal_entry_pkg.t_array_Num;

5499: l_event_class_name VARCHAR2(80) := 'ERS Loans';
5500: l_description VARCHAR2(4000);
5501: l_transaction_reversal NUMBER;
5502: l_ae_header_id NUMBER;
5503: l_array_extract_line_num xla_ae_journal_entry_pkg.t_array_Num;
5504: l_log_module VARCHAR2(240);
5505: --
5506: l_acct_reversal_source VARCHAR2(30);
5507: l_trx_reversal_source VARCHAR2(30);

Line 5804: XLA_AE_JOURNAL_ENTRY_PKG.set_event_info

5800:
5801: --
5802: -- set event info as cache for other routines to refer event attributes
5803: --
5804: XLA_AE_JOURNAL_ENTRY_PKG.set_event_info
5805: (p_application_id => p_application_id
5806: ,p_primary_ledger_id => p_primary_ledger_id
5807: ,p_base_ledger_id => p_base_ledger_id
5808: ,p_target_ledger_id => p_target_ledger_id

Line 5837: XLA_AE_JOURNAL_ENTRY_PKG.g_global_status := XLA_AE_JOURNAL_ENTRY_PKG.C_VALID;

5833:
5834: --
5835: -- set the status of entry to C_VALID (0)
5836: --
5837: XLA_AE_JOURNAL_ENTRY_PKG.g_global_status := XLA_AE_JOURNAL_ENTRY_PKG.C_VALID;
5838:
5839: --
5840: -- initialize a row for ae header
5841: --

Line 5873: --g_array_event(l_event_id).array_value_num('actual_je_status') := XLA_AE_JOURNAL_ENTRY_PKG.C_NOT_CREATED;

5869: --
5870: -- initilaize the status of ae headers for diffrent balance types
5871: -- the status is initialised to C_NOT_CREATED (2)
5872: --
5873: --g_array_event(l_event_id).array_value_num('actual_je_status') := XLA_AE_JOURNAL_ENTRY_PKG.C_NOT_CREATED;
5874: --g_array_event(l_event_id).array_value_num('budget_je_status') := XLA_AE_JOURNAL_ENTRY_PKG.C_NOT_CREATED;
5875: --g_array_event(l_event_id).array_value_num('encumbrance_je_status') := XLA_AE_JOURNAL_ENTRY_PKG.C_NOT_CREATED;
5876:
5877: --

Line 5874: --g_array_event(l_event_id).array_value_num('budget_je_status') := XLA_AE_JOURNAL_ENTRY_PKG.C_NOT_CREATED;

5870: -- initilaize the status of ae headers for diffrent balance types
5871: -- the status is initialised to C_NOT_CREATED (2)
5872: --
5873: --g_array_event(l_event_id).array_value_num('actual_je_status') := XLA_AE_JOURNAL_ENTRY_PKG.C_NOT_CREATED;
5874: --g_array_event(l_event_id).array_value_num('budget_je_status') := XLA_AE_JOURNAL_ENTRY_PKG.C_NOT_CREATED;
5875: --g_array_event(l_event_id).array_value_num('encumbrance_je_status') := XLA_AE_JOURNAL_ENTRY_PKG.C_NOT_CREATED;
5876:
5877: --
5878: -- call api to validate and store accounting attributes for header

Line 5875: --g_array_event(l_event_id).array_value_num('encumbrance_je_status') := XLA_AE_JOURNAL_ENTRY_PKG.C_NOT_CREATED;

5871: -- the status is initialised to C_NOT_CREATED (2)
5872: --
5873: --g_array_event(l_event_id).array_value_num('actual_je_status') := XLA_AE_JOURNAL_ENTRY_PKG.C_NOT_CREATED;
5874: --g_array_event(l_event_id).array_value_num('budget_je_status') := XLA_AE_JOURNAL_ENTRY_PKG.C_NOT_CREATED;
5875: --g_array_event(l_event_id).array_value_num('encumbrance_je_status') := XLA_AE_JOURNAL_ENTRY_PKG.C_NOT_CREATED;
5876:
5877: --
5878: -- call api to validate and store accounting attributes for header
5879: --

Line 5921: xla_ae_journal_entry_pkg.g_global_status := xla_ae_journal_entry_pkg.C_INVALID;

5917: --
5918: l_trx_reversal_source := SUBSTR(NULL, 1,30);
5919:
5920: IF NVL(l_trx_reversal_source, 'N') NOT IN ('N','Y') THEN
5921: xla_ae_journal_entry_pkg.g_global_status := xla_ae_journal_entry_pkg.C_INVALID;
5922:
5923: xla_accounting_err_pkg.build_message
5924: (p_appli_s_name => 'XLA'
5925: ,p_msg_name => 'XLA_AP_INVALID_HDR_ATTR'

Line 5929: ,p_value_2 => xla_ae_journal_entry_pkg.g_cache_event.application_name

5925: ,p_msg_name => 'XLA_AP_INVALID_HDR_ATTR'
5926: ,p_token_1 => 'ACCT_ATTR_NAME'
5927: ,p_value_1 => xla_ae_sources_pkg.GetAccountingSourceName('TRX_ACCT_REVERSAL_OPTION')
5928: ,p_token_2 => 'PRODUCT_NAME'
5929: ,p_value_2 => xla_ae_journal_entry_pkg.g_cache_event.application_name
5930: ,p_entity_id => xla_ae_journal_entry_pkg.g_cache_event.entity_id
5931: ,p_event_id => xla_ae_journal_entry_pkg.g_cache_event.event_id
5932: ,p_ledger_id => xla_ae_journal_entry_pkg.g_cache_event.target_ledger_id);
5933:

Line 5930: ,p_entity_id => xla_ae_journal_entry_pkg.g_cache_event.entity_id

5926: ,p_token_1 => 'ACCT_ATTR_NAME'
5927: ,p_value_1 => xla_ae_sources_pkg.GetAccountingSourceName('TRX_ACCT_REVERSAL_OPTION')
5928: ,p_token_2 => 'PRODUCT_NAME'
5929: ,p_value_2 => xla_ae_journal_entry_pkg.g_cache_event.application_name
5930: ,p_entity_id => xla_ae_journal_entry_pkg.g_cache_event.entity_id
5931: ,p_event_id => xla_ae_journal_entry_pkg.g_cache_event.event_id
5932: ,p_ledger_id => xla_ae_journal_entry_pkg.g_cache_event.target_ledger_id);
5933:
5934: ELSIF NVL(l_trx_reversal_source, 'N') = 'Y' THEN

Line 5931: ,p_event_id => xla_ae_journal_entry_pkg.g_cache_event.event_id

5927: ,p_value_1 => xla_ae_sources_pkg.GetAccountingSourceName('TRX_ACCT_REVERSAL_OPTION')
5928: ,p_token_2 => 'PRODUCT_NAME'
5929: ,p_value_2 => xla_ae_journal_entry_pkg.g_cache_event.application_name
5930: ,p_entity_id => xla_ae_journal_entry_pkg.g_cache_event.entity_id
5931: ,p_event_id => xla_ae_journal_entry_pkg.g_cache_event.event_id
5932: ,p_ledger_id => xla_ae_journal_entry_pkg.g_cache_event.target_ledger_id);
5933:
5934: ELSIF NVL(l_trx_reversal_source, 'N') = 'Y' THEN
5935: --

Line 5932: ,p_ledger_id => xla_ae_journal_entry_pkg.g_cache_event.target_ledger_id);

5928: ,p_token_2 => 'PRODUCT_NAME'
5929: ,p_value_2 => xla_ae_journal_entry_pkg.g_cache_event.application_name
5930: ,p_entity_id => xla_ae_journal_entry_pkg.g_cache_event.entity_id
5931: ,p_event_id => xla_ae_journal_entry_pkg.g_cache_event.event_id
5932: ,p_ledger_id => xla_ae_journal_entry_pkg.g_cache_event.target_ledger_id);
5933:
5934: ELSIF NVL(l_trx_reversal_source, 'N') = 'Y' THEN
5935: --
5936: -- following sets the accounting attributes needed to reverse

Line 5951: XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus (p_hdr_idx => hdr_idx);

5947: ----------------------------------------------------------------
5948: -- 4262811 - update the header statuses to invalid in need be
5949: ----------------------------------------------------------------
5950: --
5951: XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus (p_hdr_idx => hdr_idx);
5952:
5953:
5954: -----------------------------------------------
5955: -- No accrual reversal for the event class/type

Line 6078: -- set the XLA_AE_JOURNAL_ENTRY_PKG.g_global_status to C_VALID (0)

6074: ,p_module => l_log_module);
6075: END IF;
6076:
6077: --
6078: -- set the XLA_AE_JOURNAL_ENTRY_PKG.g_global_status to C_VALID (0)
6079: --
6080: XLA_AE_JOURNAL_ENTRY_PKG.g_global_status := XLA_AE_JOURNAL_ENTRY_PKG.C_VALID;
6081: --
6082: -- set event info as cache for other routines to refer event attributes

Line 6080: XLA_AE_JOURNAL_ENTRY_PKG.g_global_status := XLA_AE_JOURNAL_ENTRY_PKG.C_VALID;

6076:
6077: --
6078: -- set the XLA_AE_JOURNAL_ENTRY_PKG.g_global_status to C_VALID (0)
6079: --
6080: XLA_AE_JOURNAL_ENTRY_PKG.g_global_status := XLA_AE_JOURNAL_ENTRY_PKG.C_VALID;
6081: --
6082: -- set event info as cache for other routines to refer event attributes
6083: --
6084:

Line 6088: XLA_AE_JOURNAL_ENTRY_PKG.set_event_info

6084:
6085: IF l_event_id <> NVL(l_previous_event_id, -1) THEN
6086: l_previous_event_id := l_event_id;
6087:
6088: XLA_AE_JOURNAL_ENTRY_PKG.set_event_info
6089: (p_application_id => p_application_id
6090: ,p_primary_ledger_id => p_primary_ledger_id
6091: ,p_base_ledger_id => p_base_ledger_id
6092: ,p_target_ledger_id => p_target_ledger_id

Line 6129: xla_ae_journal_entry_pkg.g_global_status := xla_ae_journal_entry_pkg.C_INVALID;

6125: l_acct_reversal_source := SUBSTR(NULL, 1,30);
6126:
6127: IF l_continue_with_lines THEN
6128: IF NVL(l_acct_reversal_source, 'N') NOT IN ('N','Y','B') THEN
6129: xla_ae_journal_entry_pkg.g_global_status := xla_ae_journal_entry_pkg.C_INVALID;
6130:
6131: xla_accounting_err_pkg.build_message
6132: (p_appli_s_name => 'XLA'
6133: ,p_msg_name => 'XLA_AP_INVALID_REVERSAL_OPTION'

Line 6137: ,p_value_2 => xla_ae_journal_entry_pkg.g_cache_event.application_name

6133: ,p_msg_name => 'XLA_AP_INVALID_REVERSAL_OPTION'
6134: ,p_token_1 => 'LINE_NUMBER'
6135: ,p_value_1 => l_array_extract_line_num(Idx)
6136: ,p_token_2 => 'PRODUCT_NAME'
6137: ,p_value_2 => xla_ae_journal_entry_pkg.g_cache_event.application_name
6138: ,p_entity_id => xla_ae_journal_entry_pkg.g_cache_event.entity_id
6139: ,p_event_id => xla_ae_journal_entry_pkg.g_cache_event.event_id
6140: ,p_ledger_id => xla_ae_journal_entry_pkg.g_cache_event.target_ledger_id);
6141:

Line 6138: ,p_entity_id => xla_ae_journal_entry_pkg.g_cache_event.entity_id

6134: ,p_token_1 => 'LINE_NUMBER'
6135: ,p_value_1 => l_array_extract_line_num(Idx)
6136: ,p_token_2 => 'PRODUCT_NAME'
6137: ,p_value_2 => xla_ae_journal_entry_pkg.g_cache_event.application_name
6138: ,p_entity_id => xla_ae_journal_entry_pkg.g_cache_event.entity_id
6139: ,p_event_id => xla_ae_journal_entry_pkg.g_cache_event.event_id
6140: ,p_ledger_id => xla_ae_journal_entry_pkg.g_cache_event.target_ledger_id);
6141:
6142: ELSIF NVL(l_acct_reversal_source, 'N') IN ('Y','B') THEN

Line 6139: ,p_event_id => xla_ae_journal_entry_pkg.g_cache_event.event_id

6135: ,p_value_1 => l_array_extract_line_num(Idx)
6136: ,p_token_2 => 'PRODUCT_NAME'
6137: ,p_value_2 => xla_ae_journal_entry_pkg.g_cache_event.application_name
6138: ,p_entity_id => xla_ae_journal_entry_pkg.g_cache_event.entity_id
6139: ,p_event_id => xla_ae_journal_entry_pkg.g_cache_event.event_id
6140: ,p_ledger_id => xla_ae_journal_entry_pkg.g_cache_event.target_ledger_id);
6141:
6142: ELSIF NVL(l_acct_reversal_source, 'N') IN ('Y','B') THEN
6143: --

Line 6140: ,p_ledger_id => xla_ae_journal_entry_pkg.g_cache_event.target_ledger_id);

6136: ,p_token_2 => 'PRODUCT_NAME'
6137: ,p_value_2 => xla_ae_journal_entry_pkg.g_cache_event.application_name
6138: ,p_entity_id => xla_ae_journal_entry_pkg.g_cache_event.entity_id
6139: ,p_event_id => xla_ae_journal_entry_pkg.g_cache_event.event_id
6140: ,p_ledger_id => xla_ae_journal_entry_pkg.g_cache_event.target_ledger_id);
6141:
6142: ELSIF NVL(l_acct_reversal_source, 'N') IN ('Y','B') THEN
6143: --
6144: -- following sets the accounting attributes needed to reverse

Line 6237: IF (((l_calculate_g_l_flag = 'Y' AND XLA_AE_JOURNAL_ENTRY_PKG.g_cache_ledgers_info.ledger_category_code <> 'ALC') or

6233:
6234: -- only execute it if calculate g/l flag is yes, and primary or secondary ledger
6235: -- or secondary ledger that has different currency with primary
6236: -- or alc that is calculated by sla
6237: IF (((l_calculate_g_l_flag = 'Y' AND XLA_AE_JOURNAL_ENTRY_PKG.g_cache_ledgers_info.ledger_category_code <> 'ALC') or
6238: (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'))
6239:
6240: -- IF((l_calculate_g_l_flag='Y' or XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.target_ledger_id <>
6241: -- XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.ledger_id)

Line 6238: (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'))

6234: -- only execute it if calculate g/l flag is yes, and primary or secondary ledger
6235: -- or secondary ledger that has different currency with primary
6236: -- or alc that is calculated by sla
6237: IF (((l_calculate_g_l_flag = 'Y' AND XLA_AE_JOURNAL_ENTRY_PKG.g_cache_ledgers_info.ledger_category_code <> 'ALC') or
6238: (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'))
6239:
6240: -- IF((l_calculate_g_l_flag='Y' or XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.target_ledger_id <>
6241: -- XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.ledger_id)
6242: AND (l_actual_flag = 'A')) THEN

Line 6240: -- IF((l_calculate_g_l_flag='Y' or XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.target_ledger_id <>

6236: -- or alc that is calculated by sla
6237: IF (((l_calculate_g_l_flag = 'Y' AND XLA_AE_JOURNAL_ENTRY_PKG.g_cache_ledgers_info.ledger_category_code <> 'ALC') or
6238: (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'))
6239:
6240: -- IF((l_calculate_g_l_flag='Y' or XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.target_ledger_id <>
6241: -- XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.ledger_id)
6242: AND (l_actual_flag = 'A')) THEN
6243: XLA_AE_LINES_PKG.CreateGainOrLossLines(
6244: p_event_id => xla_ae_journal_entry_pkg.g_cache_event.event_id

Line 6241: -- XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.ledger_id)

6237: IF (((l_calculate_g_l_flag = 'Y' AND XLA_AE_JOURNAL_ENTRY_PKG.g_cache_ledgers_info.ledger_category_code <> 'ALC') or
6238: (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'))
6239:
6240: -- IF((l_calculate_g_l_flag='Y' or XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.target_ledger_id <>
6241: -- XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.ledger_id)
6242: AND (l_actual_flag = 'A')) THEN
6243: XLA_AE_LINES_PKG.CreateGainOrLossLines(
6244: p_event_id => xla_ae_journal_entry_pkg.g_cache_event.event_id
6245: ,p_application_id => p_application_id

Line 6244: p_event_id => xla_ae_journal_entry_pkg.g_cache_event.event_id

6240: -- IF((l_calculate_g_l_flag='Y' or XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.target_ledger_id <>
6241: -- XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.ledger_id)
6242: AND (l_actual_flag = 'A')) THEN
6243: XLA_AE_LINES_PKG.CreateGainOrLossLines(
6244: p_event_id => xla_ae_journal_entry_pkg.g_cache_event.event_id
6245: ,p_application_id => p_application_id
6246: ,p_amb_context_code => 'DEFAULT'
6247: ,p_entity_code => xla_ae_journal_entry_pkg.g_cache_event.entity_code
6248: ,p_event_class_code => C_EVENT_CLASS_CODE

Line 6247: ,p_entity_code => xla_ae_journal_entry_pkg.g_cache_event.entity_code

6243: XLA_AE_LINES_PKG.CreateGainOrLossLines(
6244: p_event_id => xla_ae_journal_entry_pkg.g_cache_event.event_id
6245: ,p_application_id => p_application_id
6246: ,p_amb_context_code => 'DEFAULT'
6247: ,p_entity_code => xla_ae_journal_entry_pkg.g_cache_event.entity_code
6248: ,p_event_class_code => C_EVENT_CLASS_CODE
6249: ,p_event_type_code => C_EVENT_TYPE_CODE
6250:
6251: ,p_gain_ccid => -1

Line 6561: l_array_legal_entity_id XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;

6557:
6558: l_calculate_acctd_flag VARCHAR2(1) :='Y';
6559: l_calculate_g_l_flag VARCHAR2(1) :='Y';
6560: --
6561: l_array_legal_entity_id XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
6562: l_array_entity_id XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
6563: l_array_entity_code XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L;
6564: l_array_transaction_num XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
6565: l_array_event_id XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;

Line 6562: l_array_entity_id XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;

6558: l_calculate_acctd_flag VARCHAR2(1) :='Y';
6559: l_calculate_g_l_flag VARCHAR2(1) :='Y';
6560: --
6561: l_array_legal_entity_id XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
6562: l_array_entity_id XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
6563: l_array_entity_code XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L;
6564: l_array_transaction_num XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
6565: l_array_event_id XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
6566: l_array_class_code XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L;

Line 6563: l_array_entity_code XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L;

6559: l_calculate_g_l_flag VARCHAR2(1) :='Y';
6560: --
6561: l_array_legal_entity_id XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
6562: l_array_entity_id XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
6563: l_array_entity_code XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L;
6564: l_array_transaction_num XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
6565: l_array_event_id XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
6566: l_array_class_code XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L;
6567: l_array_event_type XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L;

Line 6564: l_array_transaction_num XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;

6560: --
6561: l_array_legal_entity_id XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
6562: l_array_entity_id XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
6563: l_array_entity_code XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L;
6564: l_array_transaction_num XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
6565: l_array_event_id XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
6566: l_array_class_code XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L;
6567: l_array_event_type XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L;
6568: l_array_event_number XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;

Line 6565: l_array_event_id XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;

6561: l_array_legal_entity_id XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
6562: l_array_entity_id XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
6563: l_array_entity_code XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L;
6564: l_array_transaction_num XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
6565: l_array_event_id XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
6566: l_array_class_code XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L;
6567: l_array_event_type XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L;
6568: l_array_event_number XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
6569: l_array_event_date XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;

Line 6566: l_array_class_code XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L;

6562: l_array_entity_id XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
6563: l_array_entity_code XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L;
6564: l_array_transaction_num XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
6565: l_array_event_id XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
6566: l_array_class_code XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L;
6567: l_array_event_type XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L;
6568: l_array_event_number XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
6569: l_array_event_date XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
6570: l_array_transaction_date XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;

Line 6567: l_array_event_type XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L;

6563: l_array_entity_code XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L;
6564: l_array_transaction_num XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
6565: l_array_event_id XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
6566: l_array_class_code XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L;
6567: l_array_event_type XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L;
6568: l_array_event_number XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
6569: l_array_event_date XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
6570: l_array_transaction_date XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
6571: l_array_reference_num_1 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;

Line 6568: l_array_event_number XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;

6564: l_array_transaction_num XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
6565: l_array_event_id XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
6566: l_array_class_code XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L;
6567: l_array_event_type XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L;
6568: l_array_event_number XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
6569: l_array_event_date XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
6570: l_array_transaction_date XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
6571: l_array_reference_num_1 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
6572: l_array_reference_num_2 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;

Line 6569: l_array_event_date XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;

6565: l_array_event_id XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
6566: l_array_class_code XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L;
6567: l_array_event_type XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L;
6568: l_array_event_number XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
6569: l_array_event_date XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
6570: l_array_transaction_date XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
6571: l_array_reference_num_1 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
6572: l_array_reference_num_2 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
6573: l_array_reference_num_3 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;

Line 6570: l_array_transaction_date XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;

6566: l_array_class_code XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L;
6567: l_array_event_type XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L;
6568: l_array_event_number XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
6569: l_array_event_date XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
6570: l_array_transaction_date XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
6571: l_array_reference_num_1 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
6572: l_array_reference_num_2 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
6573: l_array_reference_num_3 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
6574: l_array_reference_num_4 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;

Line 6571: l_array_reference_num_1 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;

6567: l_array_event_type XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L;
6568: l_array_event_number XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
6569: l_array_event_date XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
6570: l_array_transaction_date XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
6571: l_array_reference_num_1 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
6572: l_array_reference_num_2 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
6573: l_array_reference_num_3 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
6574: l_array_reference_num_4 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
6575: l_array_reference_char_1 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;

Line 6572: l_array_reference_num_2 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;

6568: l_array_event_number XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
6569: l_array_event_date XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
6570: l_array_transaction_date XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
6571: l_array_reference_num_1 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
6572: l_array_reference_num_2 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
6573: l_array_reference_num_3 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
6574: l_array_reference_num_4 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
6575: l_array_reference_char_1 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
6576: l_array_reference_char_2 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;

Line 6573: l_array_reference_num_3 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;

6569: l_array_event_date XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
6570: l_array_transaction_date XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
6571: l_array_reference_num_1 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
6572: l_array_reference_num_2 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
6573: l_array_reference_num_3 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
6574: l_array_reference_num_4 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
6575: l_array_reference_char_1 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
6576: l_array_reference_char_2 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
6577: l_array_reference_char_3 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;

Line 6574: l_array_reference_num_4 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;

6570: l_array_transaction_date XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
6571: l_array_reference_num_1 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
6572: l_array_reference_num_2 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
6573: l_array_reference_num_3 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
6574: l_array_reference_num_4 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
6575: l_array_reference_char_1 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
6576: l_array_reference_char_2 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
6577: l_array_reference_char_3 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
6578: l_array_reference_char_4 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;

Line 6575: l_array_reference_char_1 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;

6571: l_array_reference_num_1 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
6572: l_array_reference_num_2 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
6573: l_array_reference_num_3 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
6574: l_array_reference_num_4 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
6575: l_array_reference_char_1 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
6576: l_array_reference_char_2 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
6577: l_array_reference_char_3 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
6578: l_array_reference_char_4 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
6579: l_array_reference_date_1 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;

Line 6576: l_array_reference_char_2 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;

6572: l_array_reference_num_2 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
6573: l_array_reference_num_3 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
6574: l_array_reference_num_4 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
6575: l_array_reference_char_1 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
6576: l_array_reference_char_2 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
6577: l_array_reference_char_3 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
6578: l_array_reference_char_4 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
6579: l_array_reference_date_1 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
6580: l_array_reference_date_2 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;

Line 6577: l_array_reference_char_3 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;

6573: l_array_reference_num_3 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
6574: l_array_reference_num_4 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
6575: l_array_reference_char_1 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
6576: l_array_reference_char_2 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
6577: l_array_reference_char_3 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
6578: l_array_reference_char_4 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
6579: l_array_reference_date_1 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
6580: l_array_reference_date_2 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
6581: l_array_reference_date_3 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;

Line 6578: l_array_reference_char_4 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;

6574: l_array_reference_num_4 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
6575: l_array_reference_char_1 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
6576: l_array_reference_char_2 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
6577: l_array_reference_char_3 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
6578: l_array_reference_char_4 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
6579: l_array_reference_date_1 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
6580: l_array_reference_date_2 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
6581: l_array_reference_date_3 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
6582: l_array_reference_date_4 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;

Line 6579: l_array_reference_date_1 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;

6575: l_array_reference_char_1 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
6576: l_array_reference_char_2 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
6577: l_array_reference_char_3 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
6578: l_array_reference_char_4 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
6579: l_array_reference_date_1 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
6580: l_array_reference_date_2 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
6581: l_array_reference_date_3 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
6582: l_array_reference_date_4 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
6583: l_array_event_created_by XLA_AE_JOURNAL_ENTRY_PKG.t_array_V100L;

Line 6580: l_array_reference_date_2 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;

6576: l_array_reference_char_2 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
6577: l_array_reference_char_3 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
6578: l_array_reference_char_4 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
6579: l_array_reference_date_1 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
6580: l_array_reference_date_2 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
6581: l_array_reference_date_3 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
6582: l_array_reference_date_4 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
6583: l_array_event_created_by XLA_AE_JOURNAL_ENTRY_PKG.t_array_V100L;
6584: l_array_budgetary_control_flag XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L;

Line 6581: l_array_reference_date_3 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;

6577: l_array_reference_char_3 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
6578: l_array_reference_char_4 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
6579: l_array_reference_date_1 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
6580: l_array_reference_date_2 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
6581: l_array_reference_date_3 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
6582: l_array_reference_date_4 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
6583: l_array_event_created_by XLA_AE_JOURNAL_ENTRY_PKG.t_array_V100L;
6584: l_array_budgetary_control_flag XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L;
6585:

Line 6582: l_array_reference_date_4 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;

6578: l_array_reference_char_4 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
6579: l_array_reference_date_1 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
6580: l_array_reference_date_2 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
6581: l_array_reference_date_3 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
6582: l_array_reference_date_4 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
6583: l_array_event_created_by XLA_AE_JOURNAL_ENTRY_PKG.t_array_V100L;
6584: l_array_budgetary_control_flag XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L;
6585:
6586: l_event_id NUMBER;

Line 6583: l_array_event_created_by XLA_AE_JOURNAL_ENTRY_PKG.t_array_V100L;

6579: l_array_reference_date_1 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
6580: l_array_reference_date_2 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
6581: l_array_reference_date_3 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
6582: l_array_reference_date_4 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
6583: l_array_event_created_by XLA_AE_JOURNAL_ENTRY_PKG.t_array_V100L;
6584: l_array_budgetary_control_flag XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L;
6585:
6586: l_event_id NUMBER;
6587: l_previous_event_id NUMBER;

Line 6584: l_array_budgetary_control_flag XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L;

6580: l_array_reference_date_2 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
6581: l_array_reference_date_3 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
6582: l_array_reference_date_4 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
6583: l_array_event_created_by XLA_AE_JOURNAL_ENTRY_PKG.t_array_V100L;
6584: l_array_budgetary_control_flag XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L;
6585:
6586: l_event_id NUMBER;
6587: l_previous_event_id NUMBER;
6588: l_first_event_id NUMBER;

Line 6602: l_array_extract_line_num xla_ae_journal_entry_pkg.t_array_Num;

6598: l_event_class_name VARCHAR2(80) := 'Direct Loan';
6599: l_description VARCHAR2(4000);
6600: l_transaction_reversal NUMBER;
6601: l_ae_header_id NUMBER;
6602: l_array_extract_line_num xla_ae_journal_entry_pkg.t_array_Num;
6603: l_log_module VARCHAR2(240);
6604: --
6605: l_acct_reversal_source VARCHAR2(30);
6606: l_trx_reversal_source VARCHAR2(30);

Line 6834: XLA_AE_JOURNAL_ENTRY_PKG.set_event_info

6830:
6831: --
6832: -- set event info as cache for other routines to refer event attributes
6833: --
6834: XLA_AE_JOURNAL_ENTRY_PKG.set_event_info
6835: (p_application_id => p_application_id
6836: ,p_primary_ledger_id => p_primary_ledger_id
6837: ,p_base_ledger_id => p_base_ledger_id
6838: ,p_target_ledger_id => p_target_ledger_id

Line 6867: XLA_AE_JOURNAL_ENTRY_PKG.g_global_status := XLA_AE_JOURNAL_ENTRY_PKG.C_VALID;

6863:
6864: --
6865: -- set the status of entry to C_VALID (0)
6866: --
6867: XLA_AE_JOURNAL_ENTRY_PKG.g_global_status := XLA_AE_JOURNAL_ENTRY_PKG.C_VALID;
6868:
6869: --
6870: -- initialize a row for ae header
6871: --

Line 6896: --g_array_event(l_event_id).array_value_num('actual_je_status') := XLA_AE_JOURNAL_ENTRY_PKG.C_NOT_CREATED;

6892: --
6893: -- initilaize the status of ae headers for diffrent balance types
6894: -- the status is initialised to C_NOT_CREATED (2)
6895: --
6896: --g_array_event(l_event_id).array_value_num('actual_je_status') := XLA_AE_JOURNAL_ENTRY_PKG.C_NOT_CREATED;
6897: --g_array_event(l_event_id).array_value_num('budget_je_status') := XLA_AE_JOURNAL_ENTRY_PKG.C_NOT_CREATED;
6898: --g_array_event(l_event_id).array_value_num('encumbrance_je_status') := XLA_AE_JOURNAL_ENTRY_PKG.C_NOT_CREATED;
6899:
6900: --

Line 6897: --g_array_event(l_event_id).array_value_num('budget_je_status') := XLA_AE_JOURNAL_ENTRY_PKG.C_NOT_CREATED;

6893: -- initilaize the status of ae headers for diffrent balance types
6894: -- the status is initialised to C_NOT_CREATED (2)
6895: --
6896: --g_array_event(l_event_id).array_value_num('actual_je_status') := XLA_AE_JOURNAL_ENTRY_PKG.C_NOT_CREATED;
6897: --g_array_event(l_event_id).array_value_num('budget_je_status') := XLA_AE_JOURNAL_ENTRY_PKG.C_NOT_CREATED;
6898: --g_array_event(l_event_id).array_value_num('encumbrance_je_status') := XLA_AE_JOURNAL_ENTRY_PKG.C_NOT_CREATED;
6899:
6900: --
6901: -- call api to validate and store accounting attributes for header

Line 6898: --g_array_event(l_event_id).array_value_num('encumbrance_je_status') := XLA_AE_JOURNAL_ENTRY_PKG.C_NOT_CREATED;

6894: -- the status is initialised to C_NOT_CREATED (2)
6895: --
6896: --g_array_event(l_event_id).array_value_num('actual_je_status') := XLA_AE_JOURNAL_ENTRY_PKG.C_NOT_CREATED;
6897: --g_array_event(l_event_id).array_value_num('budget_je_status') := XLA_AE_JOURNAL_ENTRY_PKG.C_NOT_CREATED;
6898: --g_array_event(l_event_id).array_value_num('encumbrance_je_status') := XLA_AE_JOURNAL_ENTRY_PKG.C_NOT_CREATED;
6899:
6900: --
6901: -- call api to validate and store accounting attributes for header
6902: --

Line 6944: xla_ae_journal_entry_pkg.g_global_status := xla_ae_journal_entry_pkg.C_INVALID;

6940: --
6941: l_trx_reversal_source := SUBSTR(NULL, 1,30);
6942:
6943: IF NVL(l_trx_reversal_source, 'N') NOT IN ('N','Y') THEN
6944: xla_ae_journal_entry_pkg.g_global_status := xla_ae_journal_entry_pkg.C_INVALID;
6945:
6946: xla_accounting_err_pkg.build_message
6947: (p_appli_s_name => 'XLA'
6948: ,p_msg_name => 'XLA_AP_INVALID_HDR_ATTR'

Line 6952: ,p_value_2 => xla_ae_journal_entry_pkg.g_cache_event.application_name

6948: ,p_msg_name => 'XLA_AP_INVALID_HDR_ATTR'
6949: ,p_token_1 => 'ACCT_ATTR_NAME'
6950: ,p_value_1 => xla_ae_sources_pkg.GetAccountingSourceName('TRX_ACCT_REVERSAL_OPTION')
6951: ,p_token_2 => 'PRODUCT_NAME'
6952: ,p_value_2 => xla_ae_journal_entry_pkg.g_cache_event.application_name
6953: ,p_entity_id => xla_ae_journal_entry_pkg.g_cache_event.entity_id
6954: ,p_event_id => xla_ae_journal_entry_pkg.g_cache_event.event_id
6955: ,p_ledger_id => xla_ae_journal_entry_pkg.g_cache_event.target_ledger_id);
6956:

Line 6953: ,p_entity_id => xla_ae_journal_entry_pkg.g_cache_event.entity_id

6949: ,p_token_1 => 'ACCT_ATTR_NAME'
6950: ,p_value_1 => xla_ae_sources_pkg.GetAccountingSourceName('TRX_ACCT_REVERSAL_OPTION')
6951: ,p_token_2 => 'PRODUCT_NAME'
6952: ,p_value_2 => xla_ae_journal_entry_pkg.g_cache_event.application_name
6953: ,p_entity_id => xla_ae_journal_entry_pkg.g_cache_event.entity_id
6954: ,p_event_id => xla_ae_journal_entry_pkg.g_cache_event.event_id
6955: ,p_ledger_id => xla_ae_journal_entry_pkg.g_cache_event.target_ledger_id);
6956:
6957: ELSIF NVL(l_trx_reversal_source, 'N') = 'Y' THEN

Line 6954: ,p_event_id => xla_ae_journal_entry_pkg.g_cache_event.event_id

6950: ,p_value_1 => xla_ae_sources_pkg.GetAccountingSourceName('TRX_ACCT_REVERSAL_OPTION')
6951: ,p_token_2 => 'PRODUCT_NAME'
6952: ,p_value_2 => xla_ae_journal_entry_pkg.g_cache_event.application_name
6953: ,p_entity_id => xla_ae_journal_entry_pkg.g_cache_event.entity_id
6954: ,p_event_id => xla_ae_journal_entry_pkg.g_cache_event.event_id
6955: ,p_ledger_id => xla_ae_journal_entry_pkg.g_cache_event.target_ledger_id);
6956:
6957: ELSIF NVL(l_trx_reversal_source, 'N') = 'Y' THEN
6958: --

Line 6955: ,p_ledger_id => xla_ae_journal_entry_pkg.g_cache_event.target_ledger_id);

6951: ,p_token_2 => 'PRODUCT_NAME'
6952: ,p_value_2 => xla_ae_journal_entry_pkg.g_cache_event.application_name
6953: ,p_entity_id => xla_ae_journal_entry_pkg.g_cache_event.entity_id
6954: ,p_event_id => xla_ae_journal_entry_pkg.g_cache_event.event_id
6955: ,p_ledger_id => xla_ae_journal_entry_pkg.g_cache_event.target_ledger_id);
6956:
6957: ELSIF NVL(l_trx_reversal_source, 'N') = 'Y' THEN
6958: --
6959: -- following sets the accounting attributes needed to reverse

Line 6974: XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus (p_hdr_idx => hdr_idx);

6970: ----------------------------------------------------------------
6971: -- 4262811 - update the header statuses to invalid in need be
6972: ----------------------------------------------------------------
6973: --
6974: XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus (p_hdr_idx => hdr_idx);
6975:
6976:
6977: -----------------------------------------------
6978: -- No accrual reversal for the event class/type

Line 7093: -- set the XLA_AE_JOURNAL_ENTRY_PKG.g_global_status to C_VALID (0)

7089: ,p_module => l_log_module);
7090: END IF;
7091:
7092: --
7093: -- set the XLA_AE_JOURNAL_ENTRY_PKG.g_global_status to C_VALID (0)
7094: --
7095: XLA_AE_JOURNAL_ENTRY_PKG.g_global_status := XLA_AE_JOURNAL_ENTRY_PKG.C_VALID;
7096: --
7097: -- set event info as cache for other routines to refer event attributes

Line 7095: XLA_AE_JOURNAL_ENTRY_PKG.g_global_status := XLA_AE_JOURNAL_ENTRY_PKG.C_VALID;

7091:
7092: --
7093: -- set the XLA_AE_JOURNAL_ENTRY_PKG.g_global_status to C_VALID (0)
7094: --
7095: XLA_AE_JOURNAL_ENTRY_PKG.g_global_status := XLA_AE_JOURNAL_ENTRY_PKG.C_VALID;
7096: --
7097: -- set event info as cache for other routines to refer event attributes
7098: --
7099:

Line 7103: XLA_AE_JOURNAL_ENTRY_PKG.set_event_info

7099:
7100: IF l_event_id <> NVL(l_previous_event_id, -1) THEN
7101: l_previous_event_id := l_event_id;
7102:
7103: XLA_AE_JOURNAL_ENTRY_PKG.set_event_info
7104: (p_application_id => p_application_id
7105: ,p_primary_ledger_id => p_primary_ledger_id
7106: ,p_base_ledger_id => p_base_ledger_id
7107: ,p_target_ledger_id => p_target_ledger_id

Line 7144: xla_ae_journal_entry_pkg.g_global_status := xla_ae_journal_entry_pkg.C_INVALID;

7140: l_acct_reversal_source := SUBSTR(NULL, 1,30);
7141:
7142: IF l_continue_with_lines THEN
7143: IF NVL(l_acct_reversal_source, 'N') NOT IN ('N','Y','B') THEN
7144: xla_ae_journal_entry_pkg.g_global_status := xla_ae_journal_entry_pkg.C_INVALID;
7145:
7146: xla_accounting_err_pkg.build_message
7147: (p_appli_s_name => 'XLA'
7148: ,p_msg_name => 'XLA_AP_INVALID_REVERSAL_OPTION'

Line 7152: ,p_value_2 => xla_ae_journal_entry_pkg.g_cache_event.application_name

7148: ,p_msg_name => 'XLA_AP_INVALID_REVERSAL_OPTION'
7149: ,p_token_1 => 'LINE_NUMBER'
7150: ,p_value_1 => l_array_extract_line_num(Idx)
7151: ,p_token_2 => 'PRODUCT_NAME'
7152: ,p_value_2 => xla_ae_journal_entry_pkg.g_cache_event.application_name
7153: ,p_entity_id => xla_ae_journal_entry_pkg.g_cache_event.entity_id
7154: ,p_event_id => xla_ae_journal_entry_pkg.g_cache_event.event_id
7155: ,p_ledger_id => xla_ae_journal_entry_pkg.g_cache_event.target_ledger_id);
7156:

Line 7153: ,p_entity_id => xla_ae_journal_entry_pkg.g_cache_event.entity_id

7149: ,p_token_1 => 'LINE_NUMBER'
7150: ,p_value_1 => l_array_extract_line_num(Idx)
7151: ,p_token_2 => 'PRODUCT_NAME'
7152: ,p_value_2 => xla_ae_journal_entry_pkg.g_cache_event.application_name
7153: ,p_entity_id => xla_ae_journal_entry_pkg.g_cache_event.entity_id
7154: ,p_event_id => xla_ae_journal_entry_pkg.g_cache_event.event_id
7155: ,p_ledger_id => xla_ae_journal_entry_pkg.g_cache_event.target_ledger_id);
7156:
7157: ELSIF NVL(l_acct_reversal_source, 'N') IN ('Y','B') THEN

Line 7154: ,p_event_id => xla_ae_journal_entry_pkg.g_cache_event.event_id

7150: ,p_value_1 => l_array_extract_line_num(Idx)
7151: ,p_token_2 => 'PRODUCT_NAME'
7152: ,p_value_2 => xla_ae_journal_entry_pkg.g_cache_event.application_name
7153: ,p_entity_id => xla_ae_journal_entry_pkg.g_cache_event.entity_id
7154: ,p_event_id => xla_ae_journal_entry_pkg.g_cache_event.event_id
7155: ,p_ledger_id => xla_ae_journal_entry_pkg.g_cache_event.target_ledger_id);
7156:
7157: ELSIF NVL(l_acct_reversal_source, 'N') IN ('Y','B') THEN
7158: --

Line 7155: ,p_ledger_id => xla_ae_journal_entry_pkg.g_cache_event.target_ledger_id);

7151: ,p_token_2 => 'PRODUCT_NAME'
7152: ,p_value_2 => xla_ae_journal_entry_pkg.g_cache_event.application_name
7153: ,p_entity_id => xla_ae_journal_entry_pkg.g_cache_event.entity_id
7154: ,p_event_id => xla_ae_journal_entry_pkg.g_cache_event.event_id
7155: ,p_ledger_id => xla_ae_journal_entry_pkg.g_cache_event.target_ledger_id);
7156:
7157: ELSIF NVL(l_acct_reversal_source, 'N') IN ('Y','B') THEN
7158: --
7159: -- following sets the accounting attributes needed to reverse

Line 7186: IF (((l_calculate_g_l_flag = 'Y' AND XLA_AE_JOURNAL_ENTRY_PKG.g_cache_ledgers_info.ledger_category_code <> 'ALC') or

7182: l_actual_flag := NULL; l_actual_gain_loss_ref := '#####';
7183: -- only execute it if calculate g/l flag is yes, and primary or secondary ledger
7184: -- or secondary ledger that has different currency with primary
7185: -- or alc that is calculated by sla
7186: IF (((l_calculate_g_l_flag = 'Y' AND XLA_AE_JOURNAL_ENTRY_PKG.g_cache_ledgers_info.ledger_category_code <> 'ALC') or
7187: (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'))
7188:
7189: -- IF((l_calculate_g_l_flag='Y' or XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.target_ledger_id <>
7190: -- XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.ledger_id)

Line 7187: (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'))

7183: -- only execute it if calculate g/l flag is yes, and primary or secondary ledger
7184: -- or secondary ledger that has different currency with primary
7185: -- or alc that is calculated by sla
7186: IF (((l_calculate_g_l_flag = 'Y' AND XLA_AE_JOURNAL_ENTRY_PKG.g_cache_ledgers_info.ledger_category_code <> 'ALC') or
7187: (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'))
7188:
7189: -- IF((l_calculate_g_l_flag='Y' or XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.target_ledger_id <>
7190: -- XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.ledger_id)
7191: AND (l_actual_flag = 'A')) THEN

Line 7189: -- IF((l_calculate_g_l_flag='Y' or XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.target_ledger_id <>

7185: -- or alc that is calculated by sla
7186: IF (((l_calculate_g_l_flag = 'Y' AND XLA_AE_JOURNAL_ENTRY_PKG.g_cache_ledgers_info.ledger_category_code <> 'ALC') or
7187: (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'))
7188:
7189: -- IF((l_calculate_g_l_flag='Y' or XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.target_ledger_id <>
7190: -- XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.ledger_id)
7191: AND (l_actual_flag = 'A')) THEN
7192: XLA_AE_LINES_PKG.CreateGainOrLossLines(
7193: p_event_id => xla_ae_journal_entry_pkg.g_cache_event.event_id

Line 7190: -- XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.ledger_id)

7186: IF (((l_calculate_g_l_flag = 'Y' AND XLA_AE_JOURNAL_ENTRY_PKG.g_cache_ledgers_info.ledger_category_code <> 'ALC') or
7187: (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'))
7188:
7189: -- IF((l_calculate_g_l_flag='Y' or XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.target_ledger_id <>
7190: -- XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.ledger_id)
7191: AND (l_actual_flag = 'A')) THEN
7192: XLA_AE_LINES_PKG.CreateGainOrLossLines(
7193: p_event_id => xla_ae_journal_entry_pkg.g_cache_event.event_id
7194: ,p_application_id => p_application_id

Line 7193: p_event_id => xla_ae_journal_entry_pkg.g_cache_event.event_id

7189: -- IF((l_calculate_g_l_flag='Y' or XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.target_ledger_id <>
7190: -- XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.ledger_id)
7191: AND (l_actual_flag = 'A')) THEN
7192: XLA_AE_LINES_PKG.CreateGainOrLossLines(
7193: p_event_id => xla_ae_journal_entry_pkg.g_cache_event.event_id
7194: ,p_application_id => p_application_id
7195: ,p_amb_context_code => 'DEFAULT'
7196: ,p_entity_code => xla_ae_journal_entry_pkg.g_cache_event.entity_code
7197: ,p_event_class_code => C_EVENT_CLASS_CODE

Line 7196: ,p_entity_code => xla_ae_journal_entry_pkg.g_cache_event.entity_code

7192: XLA_AE_LINES_PKG.CreateGainOrLossLines(
7193: p_event_id => xla_ae_journal_entry_pkg.g_cache_event.event_id
7194: ,p_application_id => p_application_id
7195: ,p_amb_context_code => 'DEFAULT'
7196: ,p_entity_code => xla_ae_journal_entry_pkg.g_cache_event.entity_code
7197: ,p_event_class_code => C_EVENT_CLASS_CODE
7198: ,p_event_type_code => C_EVENT_TYPE_CODE
7199:
7200: ,p_gain_ccid => -1

Line 7318: l_language := xla_ae_journal_entry_pkg.g_cache_ledgers_info.description_language;

7314: ,p_level => C_LEVEL_PROCEDURE
7315: ,p_module => l_log_module);
7316: END IF;
7317:
7318: l_language := xla_ae_journal_entry_pkg.g_cache_ledgers_info.description_language;
7319: l_currency_code := xla_ae_journal_entry_pkg.g_cache_ledgers_info.currency_code;
7320: l_sla_ledger_id := xla_ae_journal_entry_pkg.g_cache_ledgers_info.sla_ledger_id;
7321:
7322: --

Line 7319: l_currency_code := xla_ae_journal_entry_pkg.g_cache_ledgers_info.currency_code;

7315: ,p_module => l_log_module);
7316: END IF;
7317:
7318: l_language := xla_ae_journal_entry_pkg.g_cache_ledgers_info.description_language;
7319: l_currency_code := xla_ae_journal_entry_pkg.g_cache_ledgers_info.currency_code;
7320: l_sla_ledger_id := xla_ae_journal_entry_pkg.g_cache_ledgers_info.sla_ledger_id;
7321:
7322: --
7323: -- initialize array of lines with NULL

Line 7320: l_sla_ledger_id := xla_ae_journal_entry_pkg.g_cache_ledgers_info.sla_ledger_id;

7316: END IF;
7317:
7318: l_language := xla_ae_journal_entry_pkg.g_cache_ledgers_info.description_language;
7319: l_currency_code := xla_ae_journal_entry_pkg.g_cache_ledgers_info.currency_code;
7320: l_sla_ledger_id := xla_ae_journal_entry_pkg.g_cache_ledgers_info.sla_ledger_id;
7321:
7322: --
7323: -- initialize array of lines with NULL
7324: --

Line 7584: xla_ae_journal_entry_pkg.SetProductAcctDefinition

7580: ,p_level => C_LEVEL_STATEMENT
7581: ,p_module => l_log_module);
7582: END IF;
7583: --
7584: xla_ae_journal_entry_pkg.SetProductAcctDefinition
7585: (p_product_rule_code => 'LNS_US_FEDERAL'
7586: ,p_product_rule_type_code => 'S'
7587: ,p_product_rule_version => ''
7588: ,p_product_rule_name => 'Loans US Federal'

Line 7593: xla_ae_journal_entry_pkg.GetAlternateCurrencyLedger

7589: ,p_amb_context_code => 'DEFAULT'
7590: );
7591:
7592: l_array_ledgers :=
7593: xla_ae_journal_entry_pkg.GetAlternateCurrencyLedger
7594: (p_base_ledger_id => p_base_ledger_id);
7595:
7596: FOR Idx IN 1 .. l_array_ledgers.COUNT LOOP
7597: l_temp_result :=

Line 7598: XLA_AE_JOURNAL_ENTRY_PKG.GetLedgersInfo

7594: (p_base_ledger_id => p_base_ledger_id);
7595:
7596: FOR Idx IN 1 .. l_array_ledgers.COUNT LOOP
7597: l_temp_result :=
7598: XLA_AE_JOURNAL_ENTRY_PKG.GetLedgersInfo
7599: (p_application_id => p_application_id
7600: ,p_base_ledger_id => p_base_ledger_id
7601: ,p_target_ledger_id => l_array_ledgers(Idx)
7602: ,p_primary_ledger_id => p_primary_ledger_id