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_000003_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 3203: l_array_legal_entity_id XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;

3199:
3200: l_calculate_acctd_flag VARCHAR2(1) :='Y';
3201: l_calculate_g_l_flag VARCHAR2(1) :='Y';
3202: --
3203: l_array_legal_entity_id XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
3204: l_array_entity_id XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
3205: l_array_entity_code XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L;
3206: l_array_transaction_num XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
3207: l_array_event_id XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;

Line 3204: l_array_entity_id XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;

3200: l_calculate_acctd_flag VARCHAR2(1) :='Y';
3201: l_calculate_g_l_flag VARCHAR2(1) :='Y';
3202: --
3203: l_array_legal_entity_id XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
3204: l_array_entity_id XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
3205: l_array_entity_code XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L;
3206: l_array_transaction_num XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
3207: l_array_event_id XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
3208: l_array_class_code XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L;

Line 3205: l_array_entity_code XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L;

3201: l_calculate_g_l_flag VARCHAR2(1) :='Y';
3202: --
3203: l_array_legal_entity_id XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
3204: l_array_entity_id XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
3205: l_array_entity_code XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L;
3206: l_array_transaction_num XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
3207: l_array_event_id XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
3208: l_array_class_code XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L;
3209: l_array_event_type XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L;

Line 3206: l_array_transaction_num XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;

3202: --
3203: l_array_legal_entity_id XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
3204: l_array_entity_id XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
3205: l_array_entity_code XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L;
3206: l_array_transaction_num XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
3207: l_array_event_id XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
3208: l_array_class_code XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L;
3209: l_array_event_type XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L;
3210: l_array_event_number XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;

Line 3207: l_array_event_id XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;

3203: l_array_legal_entity_id XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
3204: l_array_entity_id XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
3205: l_array_entity_code XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L;
3206: l_array_transaction_num XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
3207: l_array_event_id XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
3208: l_array_class_code XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L;
3209: l_array_event_type XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L;
3210: l_array_event_number XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
3211: l_array_event_date XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;

Line 3208: l_array_class_code XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L;

3204: l_array_entity_id XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
3205: l_array_entity_code XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L;
3206: l_array_transaction_num XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
3207: l_array_event_id XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
3208: l_array_class_code XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L;
3209: l_array_event_type XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L;
3210: l_array_event_number XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
3211: l_array_event_date XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
3212: l_array_transaction_date XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;

Line 3209: l_array_event_type XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L;

3205: l_array_entity_code XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L;
3206: l_array_transaction_num XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
3207: l_array_event_id XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
3208: l_array_class_code XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L;
3209: l_array_event_type XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L;
3210: l_array_event_number XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
3211: l_array_event_date XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
3212: l_array_transaction_date XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
3213: l_array_reference_num_1 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;

Line 3210: l_array_event_number XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;

3206: l_array_transaction_num XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
3207: l_array_event_id XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
3208: l_array_class_code XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L;
3209: l_array_event_type XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L;
3210: l_array_event_number XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
3211: l_array_event_date XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
3212: l_array_transaction_date XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
3213: l_array_reference_num_1 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
3214: l_array_reference_num_2 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;

Line 3211: l_array_event_date XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;

3207: l_array_event_id XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
3208: l_array_class_code XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L;
3209: l_array_event_type XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L;
3210: l_array_event_number XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
3211: l_array_event_date XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
3212: l_array_transaction_date XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
3213: l_array_reference_num_1 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
3214: l_array_reference_num_2 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
3215: l_array_reference_num_3 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;

Line 3212: l_array_transaction_date XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;

3208: l_array_class_code XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L;
3209: l_array_event_type XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L;
3210: l_array_event_number XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
3211: l_array_event_date XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
3212: l_array_transaction_date XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
3213: l_array_reference_num_1 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
3214: l_array_reference_num_2 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
3215: l_array_reference_num_3 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
3216: l_array_reference_num_4 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;

Line 3213: l_array_reference_num_1 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;

3209: l_array_event_type XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L;
3210: l_array_event_number XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
3211: l_array_event_date XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
3212: l_array_transaction_date XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
3213: l_array_reference_num_1 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
3214: l_array_reference_num_2 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
3215: l_array_reference_num_3 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
3216: l_array_reference_num_4 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
3217: l_array_reference_char_1 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;

Line 3214: l_array_reference_num_2 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;

3210: l_array_event_number XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
3211: l_array_event_date XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
3212: l_array_transaction_date XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
3213: l_array_reference_num_1 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
3214: l_array_reference_num_2 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
3215: l_array_reference_num_3 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
3216: l_array_reference_num_4 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
3217: l_array_reference_char_1 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
3218: l_array_reference_char_2 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;

Line 3215: l_array_reference_num_3 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;

3211: l_array_event_date XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
3212: l_array_transaction_date XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
3213: l_array_reference_num_1 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
3214: l_array_reference_num_2 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
3215: l_array_reference_num_3 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
3216: l_array_reference_num_4 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
3217: l_array_reference_char_1 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
3218: l_array_reference_char_2 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
3219: l_array_reference_char_3 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;

Line 3216: l_array_reference_num_4 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;

3212: l_array_transaction_date XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
3213: l_array_reference_num_1 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
3214: l_array_reference_num_2 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
3215: l_array_reference_num_3 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
3216: l_array_reference_num_4 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
3217: l_array_reference_char_1 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
3218: l_array_reference_char_2 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
3219: l_array_reference_char_3 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
3220: l_array_reference_char_4 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;

Line 3217: l_array_reference_char_1 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;

3213: l_array_reference_num_1 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
3214: l_array_reference_num_2 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
3215: l_array_reference_num_3 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
3216: l_array_reference_num_4 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
3217: l_array_reference_char_1 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
3218: l_array_reference_char_2 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
3219: l_array_reference_char_3 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
3220: l_array_reference_char_4 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
3221: l_array_reference_date_1 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;

Line 3218: l_array_reference_char_2 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;

3214: l_array_reference_num_2 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
3215: l_array_reference_num_3 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
3216: l_array_reference_num_4 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
3217: l_array_reference_char_1 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
3218: l_array_reference_char_2 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
3219: l_array_reference_char_3 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
3220: l_array_reference_char_4 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
3221: l_array_reference_date_1 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
3222: l_array_reference_date_2 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;

Line 3219: l_array_reference_char_3 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;

3215: l_array_reference_num_3 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
3216: l_array_reference_num_4 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
3217: l_array_reference_char_1 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
3218: l_array_reference_char_2 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
3219: l_array_reference_char_3 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
3220: l_array_reference_char_4 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
3221: l_array_reference_date_1 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
3222: l_array_reference_date_2 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
3223: l_array_reference_date_3 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;

Line 3220: l_array_reference_char_4 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;

3216: l_array_reference_num_4 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
3217: l_array_reference_char_1 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
3218: l_array_reference_char_2 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
3219: l_array_reference_char_3 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
3220: l_array_reference_char_4 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
3221: l_array_reference_date_1 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
3222: l_array_reference_date_2 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
3223: l_array_reference_date_3 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
3224: l_array_reference_date_4 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;

Line 3221: l_array_reference_date_1 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;

3217: l_array_reference_char_1 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
3218: l_array_reference_char_2 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
3219: l_array_reference_char_3 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
3220: l_array_reference_char_4 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
3221: l_array_reference_date_1 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
3222: l_array_reference_date_2 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
3223: l_array_reference_date_3 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
3224: l_array_reference_date_4 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
3225: l_array_event_created_by XLA_AE_JOURNAL_ENTRY_PKG.t_array_V100L;

Line 3222: l_array_reference_date_2 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;

3218: l_array_reference_char_2 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
3219: l_array_reference_char_3 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
3220: l_array_reference_char_4 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
3221: l_array_reference_date_1 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
3222: l_array_reference_date_2 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
3223: l_array_reference_date_3 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
3224: l_array_reference_date_4 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
3225: l_array_event_created_by XLA_AE_JOURNAL_ENTRY_PKG.t_array_V100L;
3226: l_array_budgetary_control_flag XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L;

Line 3223: l_array_reference_date_3 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;

3219: l_array_reference_char_3 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
3220: l_array_reference_char_4 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
3221: l_array_reference_date_1 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
3222: l_array_reference_date_2 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
3223: l_array_reference_date_3 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
3224: l_array_reference_date_4 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
3225: l_array_event_created_by XLA_AE_JOURNAL_ENTRY_PKG.t_array_V100L;
3226: l_array_budgetary_control_flag XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L;
3227:

Line 3224: l_array_reference_date_4 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;

3220: l_array_reference_char_4 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
3221: l_array_reference_date_1 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
3222: l_array_reference_date_2 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
3223: l_array_reference_date_3 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
3224: l_array_reference_date_4 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
3225: l_array_event_created_by XLA_AE_JOURNAL_ENTRY_PKG.t_array_V100L;
3226: l_array_budgetary_control_flag XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L;
3227:
3228: l_event_id NUMBER;

Line 3225: l_array_event_created_by XLA_AE_JOURNAL_ENTRY_PKG.t_array_V100L;

3221: l_array_reference_date_1 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
3222: l_array_reference_date_2 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
3223: l_array_reference_date_3 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
3224: l_array_reference_date_4 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
3225: l_array_event_created_by XLA_AE_JOURNAL_ENTRY_PKG.t_array_V100L;
3226: l_array_budgetary_control_flag XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L;
3227:
3228: l_event_id NUMBER;
3229: l_previous_event_id NUMBER;

Line 3226: l_array_budgetary_control_flag XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L;

3222: l_array_reference_date_2 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
3223: l_array_reference_date_3 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
3224: l_array_reference_date_4 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
3225: l_array_event_created_by XLA_AE_JOURNAL_ENTRY_PKG.t_array_V100L;
3226: l_array_budgetary_control_flag XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L;
3227:
3228: l_event_id NUMBER;
3229: l_previous_event_id NUMBER;
3230: l_first_event_id NUMBER;

Line 3244: l_array_extract_line_num xla_ae_journal_entry_pkg.t_array_Num;

3240: l_event_class_name VARCHAR2(80) := 'Direct Loan';
3241: l_description VARCHAR2(4000);
3242: l_transaction_reversal NUMBER;
3243: l_ae_header_id NUMBER;
3244: l_array_extract_line_num xla_ae_journal_entry_pkg.t_array_Num;
3245: l_log_module VARCHAR2(240);
3246: --
3247: l_acct_reversal_source VARCHAR2(30);
3248: l_trx_reversal_source VARCHAR2(30);

Line 3568: XLA_AE_JOURNAL_ENTRY_PKG.set_event_info

3564:
3565: --
3566: -- set event info as cache for other routines to refer event attributes
3567: --
3568: XLA_AE_JOURNAL_ENTRY_PKG.set_event_info
3569: (p_application_id => p_application_id
3570: ,p_primary_ledger_id => p_primary_ledger_id
3571: ,p_base_ledger_id => p_base_ledger_id
3572: ,p_target_ledger_id => p_target_ledger_id

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

3597:
3598: --
3599: -- set the status of entry to C_VALID (0)
3600: --
3601: XLA_AE_JOURNAL_ENTRY_PKG.g_global_status := XLA_AE_JOURNAL_ENTRY_PKG.C_VALID;
3602:
3603: --
3604: -- initialize a row for ae header
3605: --

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

3633: --
3634: -- initilaize the status of ae headers for diffrent balance types
3635: -- the status is initialised to C_NOT_CREATED (2)
3636: --
3637: --g_array_event(l_event_id).array_value_num('actual_je_status') := XLA_AE_JOURNAL_ENTRY_PKG.C_NOT_CREATED;
3638: --g_array_event(l_event_id).array_value_num('budget_je_status') := XLA_AE_JOURNAL_ENTRY_PKG.C_NOT_CREATED;
3639: --g_array_event(l_event_id).array_value_num('encumbrance_je_status') := XLA_AE_JOURNAL_ENTRY_PKG.C_NOT_CREATED;
3640:
3641: --

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

3634: -- initilaize the status of ae headers for diffrent balance types
3635: -- the status is initialised to C_NOT_CREATED (2)
3636: --
3637: --g_array_event(l_event_id).array_value_num('actual_je_status') := XLA_AE_JOURNAL_ENTRY_PKG.C_NOT_CREATED;
3638: --g_array_event(l_event_id).array_value_num('budget_je_status') := XLA_AE_JOURNAL_ENTRY_PKG.C_NOT_CREATED;
3639: --g_array_event(l_event_id).array_value_num('encumbrance_je_status') := XLA_AE_JOURNAL_ENTRY_PKG.C_NOT_CREATED;
3640:
3641: --
3642: -- call api to validate and store accounting attributes for header

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

3635: -- the status is initialised to C_NOT_CREATED (2)
3636: --
3637: --g_array_event(l_event_id).array_value_num('actual_je_status') := XLA_AE_JOURNAL_ENTRY_PKG.C_NOT_CREATED;
3638: --g_array_event(l_event_id).array_value_num('budget_je_status') := XLA_AE_JOURNAL_ENTRY_PKG.C_NOT_CREATED;
3639: --g_array_event(l_event_id).array_value_num('encumbrance_je_status') := XLA_AE_JOURNAL_ENTRY_PKG.C_NOT_CREATED;
3640:
3641: --
3642: -- call api to validate and store accounting attributes for header
3643: --

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

3681: --
3682: l_trx_reversal_source := SUBSTR(NULL, 1,30);
3683:
3684: IF NVL(l_trx_reversal_source, 'N') NOT IN ('N','Y') THEN
3685: xla_ae_journal_entry_pkg.g_global_status := xla_ae_journal_entry_pkg.C_INVALID;
3686:
3687: xla_accounting_err_pkg.build_message
3688: (p_appli_s_name => 'XLA'
3689: ,p_msg_name => 'XLA_AP_INVALID_HDR_ATTR'

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

3689: ,p_msg_name => 'XLA_AP_INVALID_HDR_ATTR'
3690: ,p_token_1 => 'ACCT_ATTR_NAME'
3691: ,p_value_1 => xla_ae_sources_pkg.GetAccountingSourceName('TRX_ACCT_REVERSAL_OPTION')
3692: ,p_token_2 => 'PRODUCT_NAME'
3693: ,p_value_2 => xla_ae_journal_entry_pkg.g_cache_event.application_name
3694: ,p_entity_id => xla_ae_journal_entry_pkg.g_cache_event.entity_id
3695: ,p_event_id => xla_ae_journal_entry_pkg.g_cache_event.event_id
3696: ,p_ledger_id => xla_ae_journal_entry_pkg.g_cache_event.target_ledger_id);
3697:

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

3690: ,p_token_1 => 'ACCT_ATTR_NAME'
3691: ,p_value_1 => xla_ae_sources_pkg.GetAccountingSourceName('TRX_ACCT_REVERSAL_OPTION')
3692: ,p_token_2 => 'PRODUCT_NAME'
3693: ,p_value_2 => xla_ae_journal_entry_pkg.g_cache_event.application_name
3694: ,p_entity_id => xla_ae_journal_entry_pkg.g_cache_event.entity_id
3695: ,p_event_id => xla_ae_journal_entry_pkg.g_cache_event.event_id
3696: ,p_ledger_id => xla_ae_journal_entry_pkg.g_cache_event.target_ledger_id);
3697:
3698: ELSIF NVL(l_trx_reversal_source, 'N') = 'Y' THEN

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

3691: ,p_value_1 => xla_ae_sources_pkg.GetAccountingSourceName('TRX_ACCT_REVERSAL_OPTION')
3692: ,p_token_2 => 'PRODUCT_NAME'
3693: ,p_value_2 => xla_ae_journal_entry_pkg.g_cache_event.application_name
3694: ,p_entity_id => xla_ae_journal_entry_pkg.g_cache_event.entity_id
3695: ,p_event_id => xla_ae_journal_entry_pkg.g_cache_event.event_id
3696: ,p_ledger_id => xla_ae_journal_entry_pkg.g_cache_event.target_ledger_id);
3697:
3698: ELSIF NVL(l_trx_reversal_source, 'N') = 'Y' THEN
3699: --

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

3692: ,p_token_2 => 'PRODUCT_NAME'
3693: ,p_value_2 => xla_ae_journal_entry_pkg.g_cache_event.application_name
3694: ,p_entity_id => xla_ae_journal_entry_pkg.g_cache_event.entity_id
3695: ,p_event_id => xla_ae_journal_entry_pkg.g_cache_event.event_id
3696: ,p_ledger_id => xla_ae_journal_entry_pkg.g_cache_event.target_ledger_id);
3697:
3698: ELSIF NVL(l_trx_reversal_source, 'N') = 'Y' THEN
3699: --
3700: -- following sets the accounting attributes needed to reverse

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

3711: ----------------------------------------------------------------
3712: -- 4262811 - update the header statuses to invalid in need be
3713: ----------------------------------------------------------------
3714: --
3715: XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus (p_hdr_idx => hdr_idx);
3716:
3717:
3718: -----------------------------------------------
3719: -- No accrual reversal for the event class/type

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

3843: ,p_module => l_log_module);
3844: END IF;
3845:
3846: --
3847: -- set the XLA_AE_JOURNAL_ENTRY_PKG.g_global_status to C_VALID (0)
3848: --
3849: XLA_AE_JOURNAL_ENTRY_PKG.g_global_status := XLA_AE_JOURNAL_ENTRY_PKG.C_VALID;
3850: --
3851: -- set event info as cache for other routines to refer event attributes

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

3845:
3846: --
3847: -- set the XLA_AE_JOURNAL_ENTRY_PKG.g_global_status to C_VALID (0)
3848: --
3849: XLA_AE_JOURNAL_ENTRY_PKG.g_global_status := XLA_AE_JOURNAL_ENTRY_PKG.C_VALID;
3850: --
3851: -- set event info as cache for other routines to refer event attributes
3852: --
3853:

Line 3857: XLA_AE_JOURNAL_ENTRY_PKG.set_event_info

3853:
3854: IF l_event_id <> NVL(l_previous_event_id, -1) THEN
3855: l_previous_event_id := l_event_id;
3856:
3857: XLA_AE_JOURNAL_ENTRY_PKG.set_event_info
3858: (p_application_id => p_application_id
3859: ,p_primary_ledger_id => p_primary_ledger_id
3860: ,p_base_ledger_id => p_base_ledger_id
3861: ,p_target_ledger_id => p_target_ledger_id

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

3894: l_acct_reversal_source := SUBSTR(NULL, 1,30);
3895:
3896: IF l_continue_with_lines THEN
3897: IF NVL(l_acct_reversal_source, 'N') NOT IN ('N','Y','B') THEN
3898: xla_ae_journal_entry_pkg.g_global_status := xla_ae_journal_entry_pkg.C_INVALID;
3899:
3900: xla_accounting_err_pkg.build_message
3901: (p_appli_s_name => 'XLA'
3902: ,p_msg_name => 'XLA_AP_INVALID_REVERSAL_OPTION'

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

3902: ,p_msg_name => 'XLA_AP_INVALID_REVERSAL_OPTION'
3903: ,p_token_1 => 'LINE_NUMBER'
3904: ,p_value_1 => l_array_extract_line_num(Idx)
3905: ,p_token_2 => 'PRODUCT_NAME'
3906: ,p_value_2 => xla_ae_journal_entry_pkg.g_cache_event.application_name
3907: ,p_entity_id => xla_ae_journal_entry_pkg.g_cache_event.entity_id
3908: ,p_event_id => xla_ae_journal_entry_pkg.g_cache_event.event_id
3909: ,p_ledger_id => xla_ae_journal_entry_pkg.g_cache_event.target_ledger_id);
3910:

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

3903: ,p_token_1 => 'LINE_NUMBER'
3904: ,p_value_1 => l_array_extract_line_num(Idx)
3905: ,p_token_2 => 'PRODUCT_NAME'
3906: ,p_value_2 => xla_ae_journal_entry_pkg.g_cache_event.application_name
3907: ,p_entity_id => xla_ae_journal_entry_pkg.g_cache_event.entity_id
3908: ,p_event_id => xla_ae_journal_entry_pkg.g_cache_event.event_id
3909: ,p_ledger_id => xla_ae_journal_entry_pkg.g_cache_event.target_ledger_id);
3910:
3911: ELSIF NVL(l_acct_reversal_source, 'N') IN ('Y','B') THEN

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

3904: ,p_value_1 => l_array_extract_line_num(Idx)
3905: ,p_token_2 => 'PRODUCT_NAME'
3906: ,p_value_2 => xla_ae_journal_entry_pkg.g_cache_event.application_name
3907: ,p_entity_id => xla_ae_journal_entry_pkg.g_cache_event.entity_id
3908: ,p_event_id => xla_ae_journal_entry_pkg.g_cache_event.event_id
3909: ,p_ledger_id => xla_ae_journal_entry_pkg.g_cache_event.target_ledger_id);
3910:
3911: ELSIF NVL(l_acct_reversal_source, 'N') IN ('Y','B') THEN
3912: --

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

3905: ,p_token_2 => 'PRODUCT_NAME'
3906: ,p_value_2 => xla_ae_journal_entry_pkg.g_cache_event.application_name
3907: ,p_entity_id => xla_ae_journal_entry_pkg.g_cache_event.entity_id
3908: ,p_event_id => xla_ae_journal_entry_pkg.g_cache_event.event_id
3909: ,p_ledger_id => xla_ae_journal_entry_pkg.g_cache_event.target_ledger_id);
3910:
3911: ELSIF NVL(l_acct_reversal_source, 'N') IN ('Y','B') THEN
3912: --
3913: -- following sets the accounting attributes needed to reverse

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

4012:
4013: -- only execute it if calculate g/l flag is yes, and primary or secondary ledger
4014: -- or secondary ledger that has different currency with primary
4015: -- or alc that is calculated by sla
4016: IF (((l_calculate_g_l_flag = 'Y' AND XLA_AE_JOURNAL_ENTRY_PKG.g_cache_ledgers_info.ledger_category_code <> 'ALC') or
4017: (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'))
4018:
4019: -- IF((l_calculate_g_l_flag='Y' or XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.target_ledger_id <>
4020: -- XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.ledger_id)

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

4013: -- only execute it if calculate g/l flag is yes, and primary or secondary ledger
4014: -- or secondary ledger that has different currency with primary
4015: -- or alc that is calculated by sla
4016: IF (((l_calculate_g_l_flag = 'Y' AND XLA_AE_JOURNAL_ENTRY_PKG.g_cache_ledgers_info.ledger_category_code <> 'ALC') or
4017: (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'))
4018:
4019: -- IF((l_calculate_g_l_flag='Y' or XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.target_ledger_id <>
4020: -- XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.ledger_id)
4021: AND (l_actual_flag = 'A')) THEN

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

4015: -- or alc that is calculated by sla
4016: IF (((l_calculate_g_l_flag = 'Y' AND XLA_AE_JOURNAL_ENTRY_PKG.g_cache_ledgers_info.ledger_category_code <> 'ALC') or
4017: (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'))
4018:
4019: -- IF((l_calculate_g_l_flag='Y' or XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.target_ledger_id <>
4020: -- XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.ledger_id)
4021: AND (l_actual_flag = 'A')) THEN
4022: XLA_AE_LINES_PKG.CreateGainOrLossLines(
4023: p_event_id => xla_ae_journal_entry_pkg.g_cache_event.event_id

Line 4020: -- XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.ledger_id)

4016: IF (((l_calculate_g_l_flag = 'Y' AND XLA_AE_JOURNAL_ENTRY_PKG.g_cache_ledgers_info.ledger_category_code <> 'ALC') or
4017: (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'))
4018:
4019: -- IF((l_calculate_g_l_flag='Y' or XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.target_ledger_id <>
4020: -- XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.ledger_id)
4021: AND (l_actual_flag = 'A')) THEN
4022: XLA_AE_LINES_PKG.CreateGainOrLossLines(
4023: p_event_id => xla_ae_journal_entry_pkg.g_cache_event.event_id
4024: ,p_application_id => p_application_id

Line 4023: p_event_id => xla_ae_journal_entry_pkg.g_cache_event.event_id

4019: -- IF((l_calculate_g_l_flag='Y' or XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.target_ledger_id <>
4020: -- XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.ledger_id)
4021: AND (l_actual_flag = 'A')) THEN
4022: XLA_AE_LINES_PKG.CreateGainOrLossLines(
4023: p_event_id => xla_ae_journal_entry_pkg.g_cache_event.event_id
4024: ,p_application_id => p_application_id
4025: ,p_amb_context_code => 'DEFAULT'
4026: ,p_entity_code => xla_ae_journal_entry_pkg.g_cache_event.entity_code
4027: ,p_event_class_code => C_EVENT_CLASS_CODE

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

4022: XLA_AE_LINES_PKG.CreateGainOrLossLines(
4023: p_event_id => xla_ae_journal_entry_pkg.g_cache_event.event_id
4024: ,p_application_id => p_application_id
4025: ,p_amb_context_code => 'DEFAULT'
4026: ,p_entity_code => xla_ae_journal_entry_pkg.g_cache_event.entity_code
4027: ,p_event_class_code => C_EVENT_CLASS_CODE
4028: ,p_event_type_code => C_EVENT_TYPE_CODE
4029:
4030: ,p_gain_ccid => -1

Line 4513: l_array_legal_entity_id XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;

4509:
4510: l_calculate_acctd_flag VARCHAR2(1) :='Y';
4511: l_calculate_g_l_flag VARCHAR2(1) :='Y';
4512: --
4513: l_array_legal_entity_id XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
4514: l_array_entity_id XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
4515: l_array_entity_code XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L;
4516: l_array_transaction_num XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
4517: l_array_event_id XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;

Line 4514: l_array_entity_id XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;

4510: l_calculate_acctd_flag VARCHAR2(1) :='Y';
4511: l_calculate_g_l_flag VARCHAR2(1) :='Y';
4512: --
4513: l_array_legal_entity_id XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
4514: l_array_entity_id XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
4515: l_array_entity_code XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L;
4516: l_array_transaction_num XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
4517: l_array_event_id XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
4518: l_array_class_code XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L;

Line 4515: l_array_entity_code XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L;

4511: l_calculate_g_l_flag VARCHAR2(1) :='Y';
4512: --
4513: l_array_legal_entity_id XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
4514: l_array_entity_id XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
4515: l_array_entity_code XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L;
4516: l_array_transaction_num XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
4517: l_array_event_id XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
4518: l_array_class_code XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L;
4519: l_array_event_type XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L;

Line 4516: l_array_transaction_num XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;

4512: --
4513: l_array_legal_entity_id XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
4514: l_array_entity_id XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
4515: l_array_entity_code XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L;
4516: l_array_transaction_num XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
4517: l_array_event_id XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
4518: l_array_class_code XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L;
4519: l_array_event_type XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L;
4520: l_array_event_number XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;

Line 4517: l_array_event_id XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;

4513: l_array_legal_entity_id XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
4514: l_array_entity_id XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
4515: l_array_entity_code XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L;
4516: l_array_transaction_num XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
4517: l_array_event_id XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
4518: l_array_class_code XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L;
4519: l_array_event_type XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L;
4520: l_array_event_number XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
4521: l_array_event_date XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;

Line 4518: l_array_class_code XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L;

4514: l_array_entity_id XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
4515: l_array_entity_code XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L;
4516: l_array_transaction_num XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
4517: l_array_event_id XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
4518: l_array_class_code XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L;
4519: l_array_event_type XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L;
4520: l_array_event_number XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
4521: l_array_event_date XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
4522: l_array_transaction_date XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;

Line 4519: l_array_event_type XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L;

4515: l_array_entity_code XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L;
4516: l_array_transaction_num XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
4517: l_array_event_id XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
4518: l_array_class_code XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L;
4519: l_array_event_type XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L;
4520: l_array_event_number XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
4521: l_array_event_date XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
4522: l_array_transaction_date XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
4523: l_array_reference_num_1 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;

Line 4520: l_array_event_number XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;

4516: l_array_transaction_num XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
4517: l_array_event_id XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
4518: l_array_class_code XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L;
4519: l_array_event_type XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L;
4520: l_array_event_number XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
4521: l_array_event_date XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
4522: l_array_transaction_date XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
4523: l_array_reference_num_1 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
4524: l_array_reference_num_2 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;

Line 4521: l_array_event_date XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;

4517: l_array_event_id XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
4518: l_array_class_code XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L;
4519: l_array_event_type XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L;
4520: l_array_event_number XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
4521: l_array_event_date XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
4522: l_array_transaction_date XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
4523: l_array_reference_num_1 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
4524: l_array_reference_num_2 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
4525: l_array_reference_num_3 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;

Line 4522: l_array_transaction_date XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;

4518: l_array_class_code XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L;
4519: l_array_event_type XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L;
4520: l_array_event_number XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
4521: l_array_event_date XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
4522: l_array_transaction_date XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
4523: l_array_reference_num_1 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
4524: l_array_reference_num_2 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
4525: l_array_reference_num_3 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
4526: l_array_reference_num_4 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;

Line 4523: l_array_reference_num_1 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;

4519: l_array_event_type XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L;
4520: l_array_event_number XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
4521: l_array_event_date XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
4522: l_array_transaction_date XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
4523: l_array_reference_num_1 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
4524: l_array_reference_num_2 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
4525: l_array_reference_num_3 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
4526: l_array_reference_num_4 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
4527: l_array_reference_char_1 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;

Line 4524: l_array_reference_num_2 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;

4520: l_array_event_number XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
4521: l_array_event_date XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
4522: l_array_transaction_date XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
4523: l_array_reference_num_1 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
4524: l_array_reference_num_2 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
4525: l_array_reference_num_3 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
4526: l_array_reference_num_4 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
4527: l_array_reference_char_1 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
4528: l_array_reference_char_2 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;

Line 4525: l_array_reference_num_3 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;

4521: l_array_event_date XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
4522: l_array_transaction_date XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
4523: l_array_reference_num_1 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
4524: l_array_reference_num_2 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
4525: l_array_reference_num_3 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
4526: l_array_reference_num_4 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
4527: l_array_reference_char_1 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
4528: l_array_reference_char_2 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
4529: l_array_reference_char_3 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;

Line 4526: l_array_reference_num_4 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;

4522: l_array_transaction_date XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
4523: l_array_reference_num_1 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
4524: l_array_reference_num_2 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
4525: l_array_reference_num_3 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
4526: l_array_reference_num_4 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
4527: l_array_reference_char_1 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
4528: l_array_reference_char_2 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
4529: l_array_reference_char_3 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
4530: l_array_reference_char_4 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;

Line 4527: l_array_reference_char_1 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;

4523: l_array_reference_num_1 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
4524: l_array_reference_num_2 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
4525: l_array_reference_num_3 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
4526: l_array_reference_num_4 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
4527: l_array_reference_char_1 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
4528: l_array_reference_char_2 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
4529: l_array_reference_char_3 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
4530: l_array_reference_char_4 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
4531: l_array_reference_date_1 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;

Line 4528: l_array_reference_char_2 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;

4524: l_array_reference_num_2 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
4525: l_array_reference_num_3 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
4526: l_array_reference_num_4 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
4527: l_array_reference_char_1 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
4528: l_array_reference_char_2 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
4529: l_array_reference_char_3 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
4530: l_array_reference_char_4 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
4531: l_array_reference_date_1 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
4532: l_array_reference_date_2 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;

Line 4529: l_array_reference_char_3 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;

4525: l_array_reference_num_3 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
4526: l_array_reference_num_4 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
4527: l_array_reference_char_1 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
4528: l_array_reference_char_2 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
4529: l_array_reference_char_3 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
4530: l_array_reference_char_4 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
4531: l_array_reference_date_1 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
4532: l_array_reference_date_2 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
4533: l_array_reference_date_3 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;

Line 4530: l_array_reference_char_4 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;

4526: l_array_reference_num_4 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
4527: l_array_reference_char_1 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
4528: l_array_reference_char_2 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
4529: l_array_reference_char_3 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
4530: l_array_reference_char_4 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
4531: l_array_reference_date_1 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
4532: l_array_reference_date_2 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
4533: l_array_reference_date_3 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
4534: l_array_reference_date_4 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;

Line 4531: l_array_reference_date_1 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;

4527: l_array_reference_char_1 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
4528: l_array_reference_char_2 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
4529: l_array_reference_char_3 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
4530: l_array_reference_char_4 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
4531: l_array_reference_date_1 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
4532: l_array_reference_date_2 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
4533: l_array_reference_date_3 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
4534: l_array_reference_date_4 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
4535: l_array_event_created_by XLA_AE_JOURNAL_ENTRY_PKG.t_array_V100L;

Line 4532: l_array_reference_date_2 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;

4528: l_array_reference_char_2 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
4529: l_array_reference_char_3 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
4530: l_array_reference_char_4 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
4531: l_array_reference_date_1 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
4532: l_array_reference_date_2 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
4533: l_array_reference_date_3 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
4534: l_array_reference_date_4 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
4535: l_array_event_created_by XLA_AE_JOURNAL_ENTRY_PKG.t_array_V100L;
4536: l_array_budgetary_control_flag XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L;

Line 4533: l_array_reference_date_3 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;

4529: l_array_reference_char_3 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
4530: l_array_reference_char_4 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
4531: l_array_reference_date_1 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
4532: l_array_reference_date_2 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
4533: l_array_reference_date_3 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
4534: l_array_reference_date_4 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
4535: l_array_event_created_by XLA_AE_JOURNAL_ENTRY_PKG.t_array_V100L;
4536: l_array_budgetary_control_flag XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L;
4537:

Line 4534: l_array_reference_date_4 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;

4530: l_array_reference_char_4 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
4531: l_array_reference_date_1 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
4532: l_array_reference_date_2 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
4533: l_array_reference_date_3 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
4534: l_array_reference_date_4 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
4535: l_array_event_created_by XLA_AE_JOURNAL_ENTRY_PKG.t_array_V100L;
4536: l_array_budgetary_control_flag XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L;
4537:
4538: l_event_id NUMBER;

Line 4535: l_array_event_created_by XLA_AE_JOURNAL_ENTRY_PKG.t_array_V100L;

4531: l_array_reference_date_1 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
4532: l_array_reference_date_2 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
4533: l_array_reference_date_3 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
4534: l_array_reference_date_4 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
4535: l_array_event_created_by XLA_AE_JOURNAL_ENTRY_PKG.t_array_V100L;
4536: l_array_budgetary_control_flag XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L;
4537:
4538: l_event_id NUMBER;
4539: l_previous_event_id NUMBER;

Line 4536: l_array_budgetary_control_flag XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L;

4532: l_array_reference_date_2 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
4533: l_array_reference_date_3 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
4534: l_array_reference_date_4 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
4535: l_array_event_created_by XLA_AE_JOURNAL_ENTRY_PKG.t_array_V100L;
4536: l_array_budgetary_control_flag XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L;
4537:
4538: l_event_id NUMBER;
4539: l_previous_event_id NUMBER;
4540: l_first_event_id NUMBER;

Line 4554: l_array_extract_line_num xla_ae_journal_entry_pkg.t_array_Num;

4550: l_event_class_name VARCHAR2(80) := 'ERS Loans';
4551: l_description VARCHAR2(4000);
4552: l_transaction_reversal NUMBER;
4553: l_ae_header_id NUMBER;
4554: l_array_extract_line_num xla_ae_journal_entry_pkg.t_array_Num;
4555: l_log_module VARCHAR2(240);
4556: --
4557: l_acct_reversal_source VARCHAR2(30);
4558: l_trx_reversal_source VARCHAR2(30);

Line 4855: XLA_AE_JOURNAL_ENTRY_PKG.set_event_info

4851:
4852: --
4853: -- set event info as cache for other routines to refer event attributes
4854: --
4855: XLA_AE_JOURNAL_ENTRY_PKG.set_event_info
4856: (p_application_id => p_application_id
4857: ,p_primary_ledger_id => p_primary_ledger_id
4858: ,p_base_ledger_id => p_base_ledger_id
4859: ,p_target_ledger_id => p_target_ledger_id

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

4884:
4885: --
4886: -- set the status of entry to C_VALID (0)
4887: --
4888: XLA_AE_JOURNAL_ENTRY_PKG.g_global_status := XLA_AE_JOURNAL_ENTRY_PKG.C_VALID;
4889:
4890: --
4891: -- initialize a row for ae header
4892: --

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

4920: --
4921: -- initilaize the status of ae headers for diffrent balance types
4922: -- the status is initialised to C_NOT_CREATED (2)
4923: --
4924: --g_array_event(l_event_id).array_value_num('actual_je_status') := XLA_AE_JOURNAL_ENTRY_PKG.C_NOT_CREATED;
4925: --g_array_event(l_event_id).array_value_num('budget_je_status') := XLA_AE_JOURNAL_ENTRY_PKG.C_NOT_CREATED;
4926: --g_array_event(l_event_id).array_value_num('encumbrance_je_status') := XLA_AE_JOURNAL_ENTRY_PKG.C_NOT_CREATED;
4927:
4928: --

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

4921: -- initilaize the status of ae headers for diffrent balance types
4922: -- the status is initialised to C_NOT_CREATED (2)
4923: --
4924: --g_array_event(l_event_id).array_value_num('actual_je_status') := XLA_AE_JOURNAL_ENTRY_PKG.C_NOT_CREATED;
4925: --g_array_event(l_event_id).array_value_num('budget_je_status') := XLA_AE_JOURNAL_ENTRY_PKG.C_NOT_CREATED;
4926: --g_array_event(l_event_id).array_value_num('encumbrance_je_status') := XLA_AE_JOURNAL_ENTRY_PKG.C_NOT_CREATED;
4927:
4928: --
4929: -- call api to validate and store accounting attributes for header

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

4922: -- the status is initialised to C_NOT_CREATED (2)
4923: --
4924: --g_array_event(l_event_id).array_value_num('actual_je_status') := XLA_AE_JOURNAL_ENTRY_PKG.C_NOT_CREATED;
4925: --g_array_event(l_event_id).array_value_num('budget_je_status') := XLA_AE_JOURNAL_ENTRY_PKG.C_NOT_CREATED;
4926: --g_array_event(l_event_id).array_value_num('encumbrance_je_status') := XLA_AE_JOURNAL_ENTRY_PKG.C_NOT_CREATED;
4927:
4928: --
4929: -- call api to validate and store accounting attributes for header
4930: --

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

4968: --
4969: l_trx_reversal_source := SUBSTR(NULL, 1,30);
4970:
4971: IF NVL(l_trx_reversal_source, 'N') NOT IN ('N','Y') THEN
4972: xla_ae_journal_entry_pkg.g_global_status := xla_ae_journal_entry_pkg.C_INVALID;
4973:
4974: xla_accounting_err_pkg.build_message
4975: (p_appli_s_name => 'XLA'
4976: ,p_msg_name => 'XLA_AP_INVALID_HDR_ATTR'

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

4976: ,p_msg_name => 'XLA_AP_INVALID_HDR_ATTR'
4977: ,p_token_1 => 'ACCT_ATTR_NAME'
4978: ,p_value_1 => xla_ae_sources_pkg.GetAccountingSourceName('TRX_ACCT_REVERSAL_OPTION')
4979: ,p_token_2 => 'PRODUCT_NAME'
4980: ,p_value_2 => xla_ae_journal_entry_pkg.g_cache_event.application_name
4981: ,p_entity_id => xla_ae_journal_entry_pkg.g_cache_event.entity_id
4982: ,p_event_id => xla_ae_journal_entry_pkg.g_cache_event.event_id
4983: ,p_ledger_id => xla_ae_journal_entry_pkg.g_cache_event.target_ledger_id);
4984:

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

4977: ,p_token_1 => 'ACCT_ATTR_NAME'
4978: ,p_value_1 => xla_ae_sources_pkg.GetAccountingSourceName('TRX_ACCT_REVERSAL_OPTION')
4979: ,p_token_2 => 'PRODUCT_NAME'
4980: ,p_value_2 => xla_ae_journal_entry_pkg.g_cache_event.application_name
4981: ,p_entity_id => xla_ae_journal_entry_pkg.g_cache_event.entity_id
4982: ,p_event_id => xla_ae_journal_entry_pkg.g_cache_event.event_id
4983: ,p_ledger_id => xla_ae_journal_entry_pkg.g_cache_event.target_ledger_id);
4984:
4985: ELSIF NVL(l_trx_reversal_source, 'N') = 'Y' THEN

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

4978: ,p_value_1 => xla_ae_sources_pkg.GetAccountingSourceName('TRX_ACCT_REVERSAL_OPTION')
4979: ,p_token_2 => 'PRODUCT_NAME'
4980: ,p_value_2 => xla_ae_journal_entry_pkg.g_cache_event.application_name
4981: ,p_entity_id => xla_ae_journal_entry_pkg.g_cache_event.entity_id
4982: ,p_event_id => xla_ae_journal_entry_pkg.g_cache_event.event_id
4983: ,p_ledger_id => xla_ae_journal_entry_pkg.g_cache_event.target_ledger_id);
4984:
4985: ELSIF NVL(l_trx_reversal_source, 'N') = 'Y' THEN
4986: --

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

4979: ,p_token_2 => 'PRODUCT_NAME'
4980: ,p_value_2 => xla_ae_journal_entry_pkg.g_cache_event.application_name
4981: ,p_entity_id => xla_ae_journal_entry_pkg.g_cache_event.entity_id
4982: ,p_event_id => xla_ae_journal_entry_pkg.g_cache_event.event_id
4983: ,p_ledger_id => xla_ae_journal_entry_pkg.g_cache_event.target_ledger_id);
4984:
4985: ELSIF NVL(l_trx_reversal_source, 'N') = 'Y' THEN
4986: --
4987: -- following sets the accounting attributes needed to reverse

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

4998: ----------------------------------------------------------------
4999: -- 4262811 - update the header statuses to invalid in need be
5000: ----------------------------------------------------------------
5001: --
5002: XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus (p_hdr_idx => hdr_idx);
5003:
5004:
5005: -----------------------------------------------
5006: -- No accrual reversal for the event class/type

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

5125: ,p_module => l_log_module);
5126: END IF;
5127:
5128: --
5129: -- set the XLA_AE_JOURNAL_ENTRY_PKG.g_global_status to C_VALID (0)
5130: --
5131: XLA_AE_JOURNAL_ENTRY_PKG.g_global_status := XLA_AE_JOURNAL_ENTRY_PKG.C_VALID;
5132: --
5133: -- set event info as cache for other routines to refer event attributes

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

5127:
5128: --
5129: -- set the XLA_AE_JOURNAL_ENTRY_PKG.g_global_status to C_VALID (0)
5130: --
5131: XLA_AE_JOURNAL_ENTRY_PKG.g_global_status := XLA_AE_JOURNAL_ENTRY_PKG.C_VALID;
5132: --
5133: -- set event info as cache for other routines to refer event attributes
5134: --
5135:

Line 5139: XLA_AE_JOURNAL_ENTRY_PKG.set_event_info

5135:
5136: IF l_event_id <> NVL(l_previous_event_id, -1) THEN
5137: l_previous_event_id := l_event_id;
5138:
5139: XLA_AE_JOURNAL_ENTRY_PKG.set_event_info
5140: (p_application_id => p_application_id
5141: ,p_primary_ledger_id => p_primary_ledger_id
5142: ,p_base_ledger_id => p_base_ledger_id
5143: ,p_target_ledger_id => p_target_ledger_id

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

5176: l_acct_reversal_source := SUBSTR(NULL, 1,30);
5177:
5178: IF l_continue_with_lines THEN
5179: IF NVL(l_acct_reversal_source, 'N') NOT IN ('N','Y','B') THEN
5180: xla_ae_journal_entry_pkg.g_global_status := xla_ae_journal_entry_pkg.C_INVALID;
5181:
5182: xla_accounting_err_pkg.build_message
5183: (p_appli_s_name => 'XLA'
5184: ,p_msg_name => 'XLA_AP_INVALID_REVERSAL_OPTION'

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

5184: ,p_msg_name => 'XLA_AP_INVALID_REVERSAL_OPTION'
5185: ,p_token_1 => 'LINE_NUMBER'
5186: ,p_value_1 => l_array_extract_line_num(Idx)
5187: ,p_token_2 => 'PRODUCT_NAME'
5188: ,p_value_2 => xla_ae_journal_entry_pkg.g_cache_event.application_name
5189: ,p_entity_id => xla_ae_journal_entry_pkg.g_cache_event.entity_id
5190: ,p_event_id => xla_ae_journal_entry_pkg.g_cache_event.event_id
5191: ,p_ledger_id => xla_ae_journal_entry_pkg.g_cache_event.target_ledger_id);
5192:

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

5185: ,p_token_1 => 'LINE_NUMBER'
5186: ,p_value_1 => l_array_extract_line_num(Idx)
5187: ,p_token_2 => 'PRODUCT_NAME'
5188: ,p_value_2 => xla_ae_journal_entry_pkg.g_cache_event.application_name
5189: ,p_entity_id => xla_ae_journal_entry_pkg.g_cache_event.entity_id
5190: ,p_event_id => xla_ae_journal_entry_pkg.g_cache_event.event_id
5191: ,p_ledger_id => xla_ae_journal_entry_pkg.g_cache_event.target_ledger_id);
5192:
5193: ELSIF NVL(l_acct_reversal_source, 'N') IN ('Y','B') THEN

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

5186: ,p_value_1 => l_array_extract_line_num(Idx)
5187: ,p_token_2 => 'PRODUCT_NAME'
5188: ,p_value_2 => xla_ae_journal_entry_pkg.g_cache_event.application_name
5189: ,p_entity_id => xla_ae_journal_entry_pkg.g_cache_event.entity_id
5190: ,p_event_id => xla_ae_journal_entry_pkg.g_cache_event.event_id
5191: ,p_ledger_id => xla_ae_journal_entry_pkg.g_cache_event.target_ledger_id);
5192:
5193: ELSIF NVL(l_acct_reversal_source, 'N') IN ('Y','B') THEN
5194: --

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

5187: ,p_token_2 => 'PRODUCT_NAME'
5188: ,p_value_2 => xla_ae_journal_entry_pkg.g_cache_event.application_name
5189: ,p_entity_id => xla_ae_journal_entry_pkg.g_cache_event.entity_id
5190: ,p_event_id => xla_ae_journal_entry_pkg.g_cache_event.event_id
5191: ,p_ledger_id => xla_ae_journal_entry_pkg.g_cache_event.target_ledger_id);
5192:
5193: ELSIF NVL(l_acct_reversal_source, 'N') IN ('Y','B') THEN
5194: --
5195: -- following sets the accounting attributes needed to reverse

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

5284:
5285: -- only execute it if calculate g/l flag is yes, and primary or secondary ledger
5286: -- or secondary ledger that has different currency with primary
5287: -- or alc that is calculated by sla
5288: IF (((l_calculate_g_l_flag = 'Y' AND XLA_AE_JOURNAL_ENTRY_PKG.g_cache_ledgers_info.ledger_category_code <> 'ALC') or
5289: (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'))
5290:
5291: -- IF((l_calculate_g_l_flag='Y' or XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.target_ledger_id <>
5292: -- XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.ledger_id)

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

5285: -- only execute it if calculate g/l flag is yes, and primary or secondary ledger
5286: -- or secondary ledger that has different currency with primary
5287: -- or alc that is calculated by sla
5288: IF (((l_calculate_g_l_flag = 'Y' AND XLA_AE_JOURNAL_ENTRY_PKG.g_cache_ledgers_info.ledger_category_code <> 'ALC') or
5289: (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'))
5290:
5291: -- IF((l_calculate_g_l_flag='Y' or XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.target_ledger_id <>
5292: -- XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.ledger_id)
5293: AND (l_actual_flag = 'A')) THEN

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

5287: -- or alc that is calculated by sla
5288: IF (((l_calculate_g_l_flag = 'Y' AND XLA_AE_JOURNAL_ENTRY_PKG.g_cache_ledgers_info.ledger_category_code <> 'ALC') or
5289: (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'))
5290:
5291: -- IF((l_calculate_g_l_flag='Y' or XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.target_ledger_id <>
5292: -- XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.ledger_id)
5293: AND (l_actual_flag = 'A')) THEN
5294: XLA_AE_LINES_PKG.CreateGainOrLossLines(
5295: p_event_id => xla_ae_journal_entry_pkg.g_cache_event.event_id

Line 5292: -- XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.ledger_id)

5288: IF (((l_calculate_g_l_flag = 'Y' AND XLA_AE_JOURNAL_ENTRY_PKG.g_cache_ledgers_info.ledger_category_code <> 'ALC') or
5289: (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'))
5290:
5291: -- IF((l_calculate_g_l_flag='Y' or XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.target_ledger_id <>
5292: -- XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.ledger_id)
5293: AND (l_actual_flag = 'A')) THEN
5294: XLA_AE_LINES_PKG.CreateGainOrLossLines(
5295: p_event_id => xla_ae_journal_entry_pkg.g_cache_event.event_id
5296: ,p_application_id => p_application_id

Line 5295: p_event_id => xla_ae_journal_entry_pkg.g_cache_event.event_id

5291: -- IF((l_calculate_g_l_flag='Y' or XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.target_ledger_id <>
5292: -- XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.ledger_id)
5293: AND (l_actual_flag = 'A')) THEN
5294: XLA_AE_LINES_PKG.CreateGainOrLossLines(
5295: p_event_id => xla_ae_journal_entry_pkg.g_cache_event.event_id
5296: ,p_application_id => p_application_id
5297: ,p_amb_context_code => 'DEFAULT'
5298: ,p_entity_code => xla_ae_journal_entry_pkg.g_cache_event.entity_code
5299: ,p_event_class_code => C_EVENT_CLASS_CODE

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

5294: XLA_AE_LINES_PKG.CreateGainOrLossLines(
5295: p_event_id => xla_ae_journal_entry_pkg.g_cache_event.event_id
5296: ,p_application_id => p_application_id
5297: ,p_amb_context_code => 'DEFAULT'
5298: ,p_entity_code => xla_ae_journal_entry_pkg.g_cache_event.entity_code
5299: ,p_event_class_code => C_EVENT_CLASS_CODE
5300: ,p_event_type_code => C_EVENT_TYPE_CODE
5301:
5302: ,p_gain_ccid => -1

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

5416: ,p_level => C_LEVEL_PROCEDURE
5417: ,p_module => l_log_module);
5418: END IF;
5419:
5420: l_language := xla_ae_journal_entry_pkg.g_cache_ledgers_info.description_language;
5421: l_currency_code := xla_ae_journal_entry_pkg.g_cache_ledgers_info.currency_code;
5422: l_sla_ledger_id := xla_ae_journal_entry_pkg.g_cache_ledgers_info.sla_ledger_id;
5423:
5424: --

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

5417: ,p_module => l_log_module);
5418: END IF;
5419:
5420: l_language := xla_ae_journal_entry_pkg.g_cache_ledgers_info.description_language;
5421: l_currency_code := xla_ae_journal_entry_pkg.g_cache_ledgers_info.currency_code;
5422: l_sla_ledger_id := xla_ae_journal_entry_pkg.g_cache_ledgers_info.sla_ledger_id;
5423:
5424: --
5425: -- initialize array of lines with NULL

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

5418: END IF;
5419:
5420: l_language := xla_ae_journal_entry_pkg.g_cache_ledgers_info.description_language;
5421: l_currency_code := xla_ae_journal_entry_pkg.g_cache_ledgers_info.currency_code;
5422: l_sla_ledger_id := xla_ae_journal_entry_pkg.g_cache_ledgers_info.sla_ledger_id;
5423:
5424: --
5425: -- initialize array of lines with NULL
5426: --

Line 5618: xla_ae_journal_entry_pkg.SetProductAcctDefinition

5614: ,p_level => C_LEVEL_STATEMENT
5615: ,p_module => l_log_module);
5616: END IF;
5617: --
5618: xla_ae_journal_entry_pkg.SetProductAcctDefinition
5619: (p_product_rule_code => 'LNS_STANDARD_ACCRUAL'
5620: ,p_product_rule_type_code => 'S'
5621: ,p_product_rule_version => ''
5622: ,p_product_rule_name => 'Loans Standard Accrual'

Line 5627: xla_ae_journal_entry_pkg.GetAlternateCurrencyLedger

5623: ,p_amb_context_code => 'DEFAULT'
5624: );
5625:
5626: l_array_ledgers :=
5627: xla_ae_journal_entry_pkg.GetAlternateCurrencyLedger
5628: (p_base_ledger_id => p_base_ledger_id);
5629:
5630: FOR Idx IN 1 .. l_array_ledgers.COUNT LOOP
5631: l_temp_result :=

Line 5632: XLA_AE_JOURNAL_ENTRY_PKG.GetLedgersInfo

5628: (p_base_ledger_id => p_base_ledger_id);
5629:
5630: FOR Idx IN 1 .. l_array_ledgers.COUNT LOOP
5631: l_temp_result :=
5632: XLA_AE_JOURNAL_ENTRY_PKG.GetLedgersInfo
5633: (p_application_id => p_application_id
5634: ,p_base_ledger_id => p_base_ledger_id
5635: ,p_target_ledger_id => l_array_ledgers(Idx)
5636: ,p_primary_ledger_id => p_primary_ledger_id