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_08901_AAD_S_000002_BC_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 267: l_ledger_language := xla_ae_journal_entry_pkg.g_cache_ledgers_info.description_language;

263: ,p_level => C_LEVEL_PROCEDURE
264: ,p_module => l_log_module);
265: END IF;
266:
267: l_ledger_language := xla_ae_journal_entry_pkg.g_cache_ledgers_info.description_language;
268: l_component_type := 'AMB_DESCRIPTION';
269: l_component_code := 'FV_BE_LINE_DESC';
270: l_component_type_code := 'S';
271: l_component_appl_id := 8901;

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

415: ,p_module => l_log_module);
416:
417: END IF;
418:
419: xla_ae_journal_entry_pkg.g_global_status := xla_ae_journal_entry_pkg.C_INVALID;
420: x_value_combination_id := null;
421: x_value_segment_code := null;
422: x_value_type_code := null;
423: l_output_value := null;

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

437: 'XLA_OWNER_TYPE'
438: ,l_component_type_code
439: )
440: ,p_token_3 => 'PAD_NAME'
441: ,p_value_3 => xla_ae_journal_entry_pkg.g_cache_pad.pad_session_name
442: ,p_token_4 => 'PAD_OWNER'
443: ,p_value_4 => xla_lookups_pkg.get_meaning(
444: 'XLA_OWNER_TYPE'
445: ,xla_ae_journal_entry_pkg.g_cache_pad.product_rule_type_code

Line 445: ,xla_ae_journal_entry_pkg.g_cache_pad.product_rule_type_code

441: ,p_value_3 => xla_ae_journal_entry_pkg.g_cache_pad.pad_session_name
442: ,p_token_4 => 'PAD_OWNER'
443: ,p_value_4 => xla_lookups_pkg.get_meaning(
444: 'XLA_OWNER_TYPE'
445: ,xla_ae_journal_entry_pkg.g_cache_pad.product_rule_type_code
446: )
447: ,p_entity_id => xla_ae_journal_entry_pkg.g_cache_event.entity_id
448: ,p_event_id => xla_ae_journal_entry_pkg.g_cache_event.event_id
449: ,p_ledger_id => xla_ae_journal_entry_pkg.g_cache_event.target_ledger_id

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

443: ,p_value_4 => xla_lookups_pkg.get_meaning(
444: 'XLA_OWNER_TYPE'
445: ,xla_ae_journal_entry_pkg.g_cache_pad.product_rule_type_code
446: )
447: ,p_entity_id => xla_ae_journal_entry_pkg.g_cache_event.entity_id
448: ,p_event_id => xla_ae_journal_entry_pkg.g_cache_event.event_id
449: ,p_ledger_id => xla_ae_journal_entry_pkg.g_cache_event.target_ledger_id
450: ,p_ae_header_id => NULL
451: );

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

444: 'XLA_OWNER_TYPE'
445: ,xla_ae_journal_entry_pkg.g_cache_pad.product_rule_type_code
446: )
447: ,p_entity_id => xla_ae_journal_entry_pkg.g_cache_event.entity_id
448: ,p_event_id => xla_ae_journal_entry_pkg.g_cache_event.event_id
449: ,p_ledger_id => xla_ae_journal_entry_pkg.g_cache_event.target_ledger_id
450: ,p_ae_header_id => NULL
451: );
452: RETURN l_output_value;

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

445: ,xla_ae_journal_entry_pkg.g_cache_pad.product_rule_type_code
446: )
447: ,p_entity_id => xla_ae_journal_entry_pkg.g_cache_event.entity_id
448: ,p_event_id => xla_ae_journal_entry_pkg.g_cache_event.event_id
449: ,p_ledger_id => xla_ae_journal_entry_pkg.g_cache_event.target_ledger_id
450: ,p_ae_header_id => NULL
451: );
452: RETURN l_output_value;
453: EXCEPTION

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

537: ,p_module => l_log_module);
538:
539: END IF;
540:
541: xla_ae_journal_entry_pkg.g_global_status := xla_ae_journal_entry_pkg.C_INVALID;
542: x_value_combination_id := null;
543: x_value_segment_code := null;
544: x_value_type_code := null;
545: l_output_value := null;

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

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

Line 567: ,xla_ae_journal_entry_pkg.g_cache_pad.product_rule_type_code

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

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

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

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

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

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

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

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

689: ,p_module => l_log_module);
690:
691: END IF;
692:
693: xla_ae_journal_entry_pkg.g_global_status := xla_ae_journal_entry_pkg.C_INVALID;
694: x_value_combination_id := null;
695: x_value_segment_code := null;
696: x_value_type_code := null;
697: l_output_value := null;

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

711: 'XLA_OWNER_TYPE'
712: ,l_component_type_code
713: )
714: ,p_token_3 => 'PAD_NAME'
715: ,p_value_3 => xla_ae_journal_entry_pkg.g_cache_pad.pad_session_name
716: ,p_token_4 => 'PAD_OWNER'
717: ,p_value_4 => xla_lookups_pkg.get_meaning(
718: 'XLA_OWNER_TYPE'
719: ,xla_ae_journal_entry_pkg.g_cache_pad.product_rule_type_code

Line 719: ,xla_ae_journal_entry_pkg.g_cache_pad.product_rule_type_code

715: ,p_value_3 => xla_ae_journal_entry_pkg.g_cache_pad.pad_session_name
716: ,p_token_4 => 'PAD_OWNER'
717: ,p_value_4 => xla_lookups_pkg.get_meaning(
718: 'XLA_OWNER_TYPE'
719: ,xla_ae_journal_entry_pkg.g_cache_pad.product_rule_type_code
720: )
721: ,p_entity_id => xla_ae_journal_entry_pkg.g_cache_event.entity_id
722: ,p_event_id => xla_ae_journal_entry_pkg.g_cache_event.event_id
723: ,p_ledger_id => xla_ae_journal_entry_pkg.g_cache_event.target_ledger_id

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

717: ,p_value_4 => xla_lookups_pkg.get_meaning(
718: 'XLA_OWNER_TYPE'
719: ,xla_ae_journal_entry_pkg.g_cache_pad.product_rule_type_code
720: )
721: ,p_entity_id => xla_ae_journal_entry_pkg.g_cache_event.entity_id
722: ,p_event_id => xla_ae_journal_entry_pkg.g_cache_event.event_id
723: ,p_ledger_id => xla_ae_journal_entry_pkg.g_cache_event.target_ledger_id
724: ,p_ae_header_id => NULL
725: );

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

718: 'XLA_OWNER_TYPE'
719: ,xla_ae_journal_entry_pkg.g_cache_pad.product_rule_type_code
720: )
721: ,p_entity_id => xla_ae_journal_entry_pkg.g_cache_event.entity_id
722: ,p_event_id => xla_ae_journal_entry_pkg.g_cache_event.event_id
723: ,p_ledger_id => xla_ae_journal_entry_pkg.g_cache_event.target_ledger_id
724: ,p_ae_header_id => NULL
725: );
726: RETURN l_output_value;

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

719: ,xla_ae_journal_entry_pkg.g_cache_pad.product_rule_type_code
720: )
721: ,p_entity_id => xla_ae_journal_entry_pkg.g_cache_event.entity_id
722: ,p_event_id => xla_ae_journal_entry_pkg.g_cache_event.event_id
723: ,p_ledger_id => xla_ae_journal_entry_pkg.g_cache_event.target_ledger_id
724: ,p_ae_header_id => NULL
725: );
726: RETURN l_output_value;
727: EXCEPTION

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

841: ,p_module => l_log_module);
842:
843: END IF;
844:
845: xla_ae_journal_entry_pkg.g_global_status := xla_ae_journal_entry_pkg.C_INVALID;
846: x_value_combination_id := null;
847: x_value_segment_code := null;
848: x_value_type_code := null;
849: l_output_value := null;

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

863: 'XLA_OWNER_TYPE'
864: ,l_component_type_code
865: )
866: ,p_token_3 => 'PAD_NAME'
867: ,p_value_3 => xla_ae_journal_entry_pkg.g_cache_pad.pad_session_name
868: ,p_token_4 => 'PAD_OWNER'
869: ,p_value_4 => xla_lookups_pkg.get_meaning(
870: 'XLA_OWNER_TYPE'
871: ,xla_ae_journal_entry_pkg.g_cache_pad.product_rule_type_code

Line 871: ,xla_ae_journal_entry_pkg.g_cache_pad.product_rule_type_code

867: ,p_value_3 => xla_ae_journal_entry_pkg.g_cache_pad.pad_session_name
868: ,p_token_4 => 'PAD_OWNER'
869: ,p_value_4 => xla_lookups_pkg.get_meaning(
870: 'XLA_OWNER_TYPE'
871: ,xla_ae_journal_entry_pkg.g_cache_pad.product_rule_type_code
872: )
873: ,p_entity_id => xla_ae_journal_entry_pkg.g_cache_event.entity_id
874: ,p_event_id => xla_ae_journal_entry_pkg.g_cache_event.event_id
875: ,p_ledger_id => xla_ae_journal_entry_pkg.g_cache_event.target_ledger_id

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

869: ,p_value_4 => xla_lookups_pkg.get_meaning(
870: 'XLA_OWNER_TYPE'
871: ,xla_ae_journal_entry_pkg.g_cache_pad.product_rule_type_code
872: )
873: ,p_entity_id => xla_ae_journal_entry_pkg.g_cache_event.entity_id
874: ,p_event_id => xla_ae_journal_entry_pkg.g_cache_event.event_id
875: ,p_ledger_id => xla_ae_journal_entry_pkg.g_cache_event.target_ledger_id
876: ,p_ae_header_id => NULL
877: );

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

870: 'XLA_OWNER_TYPE'
871: ,xla_ae_journal_entry_pkg.g_cache_pad.product_rule_type_code
872: )
873: ,p_entity_id => xla_ae_journal_entry_pkg.g_cache_event.entity_id
874: ,p_event_id => xla_ae_journal_entry_pkg.g_cache_event.event_id
875: ,p_ledger_id => xla_ae_journal_entry_pkg.g_cache_event.target_ledger_id
876: ,p_ae_header_id => NULL
877: );
878: RETURN l_output_value;

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

871: ,xla_ae_journal_entry_pkg.g_cache_pad.product_rule_type_code
872: )
873: ,p_entity_id => xla_ae_journal_entry_pkg.g_cache_event.entity_id
874: ,p_event_id => xla_ae_journal_entry_pkg.g_cache_event.event_id
875: ,p_ledger_id => xla_ae_journal_entry_pkg.g_cache_event.target_ledger_id
876: ,p_ae_header_id => NULL
877: );
878: RETURN l_output_value;
879: EXCEPTION

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

947: (p_msg => 'END of AcctDerRule_6(invalid)'
948: ,p_level => C_LEVEL_PROCEDURE
949: ,p_module => l_log_module);
950: END IF;
951: xla_ae_journal_entry_pkg.g_global_status := xla_ae_journal_entry_pkg.C_INVALID;
952: x_value_type_code := null;
953: l_output_value := null;
954: xla_accounting_err_pkg.build_message
955: (p_appli_s_name => 'XLA'

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

967: 'XLA_OWNER_TYPE'
968: ,l_component_type_code
969: )
970: ,p_token_3 => 'PAD_NAME'
971: ,p_value_3 => xla_ae_journal_entry_pkg.g_cache_pad.pad_session_name
972: ,p_token_4 => 'PAD_OWNER'
973: ,p_value_4 => xla_lookups_pkg.get_meaning(
974: 'XLA_OWNER_TYPE'
975: ,xla_ae_journal_entry_pkg.g_cache_pad.product_rule_type_code

Line 975: ,xla_ae_journal_entry_pkg.g_cache_pad.product_rule_type_code

971: ,p_value_3 => xla_ae_journal_entry_pkg.g_cache_pad.pad_session_name
972: ,p_token_4 => 'PAD_OWNER'
973: ,p_value_4 => xla_lookups_pkg.get_meaning(
974: 'XLA_OWNER_TYPE'
975: ,xla_ae_journal_entry_pkg.g_cache_pad.product_rule_type_code
976: )
977: ,p_entity_id => xla_ae_journal_entry_pkg.g_cache_event.entity_id
978: ,p_event_id => xla_ae_journal_entry_pkg.g_cache_event.event_id
979: ,p_ledger_id => xla_ae_journal_entry_pkg.g_cache_event.target_ledger_id

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

973: ,p_value_4 => xla_lookups_pkg.get_meaning(
974: 'XLA_OWNER_TYPE'
975: ,xla_ae_journal_entry_pkg.g_cache_pad.product_rule_type_code
976: )
977: ,p_entity_id => xla_ae_journal_entry_pkg.g_cache_event.entity_id
978: ,p_event_id => xla_ae_journal_entry_pkg.g_cache_event.event_id
979: ,p_ledger_id => xla_ae_journal_entry_pkg.g_cache_event.target_ledger_id
980: ,p_ae_header_id => NULL
981: );

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

974: 'XLA_OWNER_TYPE'
975: ,xla_ae_journal_entry_pkg.g_cache_pad.product_rule_type_code
976: )
977: ,p_entity_id => xla_ae_journal_entry_pkg.g_cache_event.entity_id
978: ,p_event_id => xla_ae_journal_entry_pkg.g_cache_event.event_id
979: ,p_ledger_id => xla_ae_journal_entry_pkg.g_cache_event.target_ledger_id
980: ,p_ae_header_id => NULL
981: );
982: RETURN l_output_value;

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

975: ,xla_ae_journal_entry_pkg.g_cache_pad.product_rule_type_code
976: )
977: ,p_entity_id => xla_ae_journal_entry_pkg.g_cache_event.entity_id
978: ,p_event_id => xla_ae_journal_entry_pkg.g_cache_event.event_id
979: ,p_ledger_id => xla_ae_journal_entry_pkg.g_cache_event.target_ledger_id
980: ,p_ae_header_id => NULL
981: );
982: RETURN l_output_value;
983: EXCEPTION

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

1051: (p_msg => 'END of AcctDerRule_7(invalid)'
1052: ,p_level => C_LEVEL_PROCEDURE
1053: ,p_module => l_log_module);
1054: END IF;
1055: xla_ae_journal_entry_pkg.g_global_status := xla_ae_journal_entry_pkg.C_INVALID;
1056: x_value_type_code := null;
1057: l_output_value := null;
1058: xla_accounting_err_pkg.build_message
1059: (p_appli_s_name => 'XLA'

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

1071: 'XLA_OWNER_TYPE'
1072: ,l_component_type_code
1073: )
1074: ,p_token_3 => 'PAD_NAME'
1075: ,p_value_3 => xla_ae_journal_entry_pkg.g_cache_pad.pad_session_name
1076: ,p_token_4 => 'PAD_OWNER'
1077: ,p_value_4 => xla_lookups_pkg.get_meaning(
1078: 'XLA_OWNER_TYPE'
1079: ,xla_ae_journal_entry_pkg.g_cache_pad.product_rule_type_code

Line 1079: ,xla_ae_journal_entry_pkg.g_cache_pad.product_rule_type_code

1075: ,p_value_3 => xla_ae_journal_entry_pkg.g_cache_pad.pad_session_name
1076: ,p_token_4 => 'PAD_OWNER'
1077: ,p_value_4 => xla_lookups_pkg.get_meaning(
1078: 'XLA_OWNER_TYPE'
1079: ,xla_ae_journal_entry_pkg.g_cache_pad.product_rule_type_code
1080: )
1081: ,p_entity_id => xla_ae_journal_entry_pkg.g_cache_event.entity_id
1082: ,p_event_id => xla_ae_journal_entry_pkg.g_cache_event.event_id
1083: ,p_ledger_id => xla_ae_journal_entry_pkg.g_cache_event.target_ledger_id

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

1077: ,p_value_4 => xla_lookups_pkg.get_meaning(
1078: 'XLA_OWNER_TYPE'
1079: ,xla_ae_journal_entry_pkg.g_cache_pad.product_rule_type_code
1080: )
1081: ,p_entity_id => xla_ae_journal_entry_pkg.g_cache_event.entity_id
1082: ,p_event_id => xla_ae_journal_entry_pkg.g_cache_event.event_id
1083: ,p_ledger_id => xla_ae_journal_entry_pkg.g_cache_event.target_ledger_id
1084: ,p_ae_header_id => NULL
1085: );

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

1078: 'XLA_OWNER_TYPE'
1079: ,xla_ae_journal_entry_pkg.g_cache_pad.product_rule_type_code
1080: )
1081: ,p_entity_id => xla_ae_journal_entry_pkg.g_cache_event.entity_id
1082: ,p_event_id => xla_ae_journal_entry_pkg.g_cache_event.event_id
1083: ,p_ledger_id => xla_ae_journal_entry_pkg.g_cache_event.target_ledger_id
1084: ,p_ae_header_id => NULL
1085: );
1086: RETURN l_output_value;

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

1079: ,xla_ae_journal_entry_pkg.g_cache_pad.product_rule_type_code
1080: )
1081: ,p_entity_id => xla_ae_journal_entry_pkg.g_cache_event.entity_id
1082: ,p_event_id => xla_ae_journal_entry_pkg.g_cache_event.event_id
1083: ,p_ledger_id => xla_ae_journal_entry_pkg.g_cache_event.target_ledger_id
1084: ,p_ae_header_id => NULL
1085: );
1086: RETURN l_output_value;
1087: EXCEPTION

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

1175: (p_msg => 'END of AcctDerRule_8(invalid)'
1176: ,p_level => C_LEVEL_PROCEDURE
1177: ,p_module => l_log_module);
1178: END IF;
1179: xla_ae_journal_entry_pkg.g_global_status := xla_ae_journal_entry_pkg.C_INVALID;
1180: x_value_type_code := null;
1181: l_output_value := null;
1182: xla_accounting_err_pkg.build_message
1183: (p_appli_s_name => 'XLA'

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

1195: 'XLA_OWNER_TYPE'
1196: ,l_component_type_code
1197: )
1198: ,p_token_3 => 'PAD_NAME'
1199: ,p_value_3 => xla_ae_journal_entry_pkg.g_cache_pad.pad_session_name
1200: ,p_token_4 => 'PAD_OWNER'
1201: ,p_value_4 => xla_lookups_pkg.get_meaning(
1202: 'XLA_OWNER_TYPE'
1203: ,xla_ae_journal_entry_pkg.g_cache_pad.product_rule_type_code

Line 1203: ,xla_ae_journal_entry_pkg.g_cache_pad.product_rule_type_code

1199: ,p_value_3 => xla_ae_journal_entry_pkg.g_cache_pad.pad_session_name
1200: ,p_token_4 => 'PAD_OWNER'
1201: ,p_value_4 => xla_lookups_pkg.get_meaning(
1202: 'XLA_OWNER_TYPE'
1203: ,xla_ae_journal_entry_pkg.g_cache_pad.product_rule_type_code
1204: )
1205: ,p_entity_id => xla_ae_journal_entry_pkg.g_cache_event.entity_id
1206: ,p_event_id => xla_ae_journal_entry_pkg.g_cache_event.event_id
1207: ,p_ledger_id => xla_ae_journal_entry_pkg.g_cache_event.target_ledger_id

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

1201: ,p_value_4 => xla_lookups_pkg.get_meaning(
1202: 'XLA_OWNER_TYPE'
1203: ,xla_ae_journal_entry_pkg.g_cache_pad.product_rule_type_code
1204: )
1205: ,p_entity_id => xla_ae_journal_entry_pkg.g_cache_event.entity_id
1206: ,p_event_id => xla_ae_journal_entry_pkg.g_cache_event.event_id
1207: ,p_ledger_id => xla_ae_journal_entry_pkg.g_cache_event.target_ledger_id
1208: ,p_ae_header_id => NULL
1209: );

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

1202: 'XLA_OWNER_TYPE'
1203: ,xla_ae_journal_entry_pkg.g_cache_pad.product_rule_type_code
1204: )
1205: ,p_entity_id => xla_ae_journal_entry_pkg.g_cache_event.entity_id
1206: ,p_event_id => xla_ae_journal_entry_pkg.g_cache_event.event_id
1207: ,p_ledger_id => xla_ae_journal_entry_pkg.g_cache_event.target_ledger_id
1208: ,p_ae_header_id => NULL
1209: );
1210: RETURN l_output_value;

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

1203: ,xla_ae_journal_entry_pkg.g_cache_pad.product_rule_type_code
1204: )
1205: ,p_entity_id => xla_ae_journal_entry_pkg.g_cache_event.entity_id
1206: ,p_event_id => xla_ae_journal_entry_pkg.g_cache_event.event_id
1207: ,p_ledger_id => xla_ae_journal_entry_pkg.g_cache_event.target_ledger_id
1208: ,p_ae_header_id => NULL
1209: );
1210: RETURN l_output_value;
1211: EXCEPTION

Line 1295: l_gl_dates xla_ae_journal_entry_pkg.t_array_date;

1291: l_tmp_amt NUMBER;
1292: l_acc_rev_natural_side_code VARCHAR2(1);
1293:
1294: l_num_entries NUMBER;
1295: l_gl_dates xla_ae_journal_entry_pkg.t_array_date;
1296: l_accted_amts xla_ae_journal_entry_pkg.t_array_num;
1297: l_entered_amts xla_ae_journal_entry_pkg.t_array_num;
1298: l_period_names xla_ae_journal_entry_pkg.t_array_V15L;
1299: l_recog_line_1 NUMBER;

Line 1296: l_accted_amts xla_ae_journal_entry_pkg.t_array_num;

1292: l_acc_rev_natural_side_code VARCHAR2(1);
1293:
1294: l_num_entries NUMBER;
1295: l_gl_dates xla_ae_journal_entry_pkg.t_array_date;
1296: l_accted_amts xla_ae_journal_entry_pkg.t_array_num;
1297: l_entered_amts xla_ae_journal_entry_pkg.t_array_num;
1298: l_period_names xla_ae_journal_entry_pkg.t_array_V15L;
1299: l_recog_line_1 NUMBER;
1300: l_recog_line_2 NUMBER;

Line 1297: l_entered_amts xla_ae_journal_entry_pkg.t_array_num;

1293:
1294: l_num_entries NUMBER;
1295: l_gl_dates xla_ae_journal_entry_pkg.t_array_date;
1296: l_accted_amts xla_ae_journal_entry_pkg.t_array_num;
1297: l_entered_amts xla_ae_journal_entry_pkg.t_array_num;
1298: l_period_names xla_ae_journal_entry_pkg.t_array_V15L;
1299: l_recog_line_1 NUMBER;
1300: l_recog_line_2 NUMBER;
1301:

Line 1298: l_period_names xla_ae_journal_entry_pkg.t_array_V15L;

1294: l_num_entries NUMBER;
1295: l_gl_dates xla_ae_journal_entry_pkg.t_array_date;
1296: l_accted_amts xla_ae_journal_entry_pkg.t_array_num;
1297: l_entered_amts xla_ae_journal_entry_pkg.t_array_num;
1298: l_period_names xla_ae_journal_entry_pkg.t_array_V15L;
1299: l_recog_line_1 NUMBER;
1300: l_recog_line_2 NUMBER;
1301:
1302: l_bflow_applied_to_amt_idx NUMBER; -- 5132302

Line 1304: l_bflow_applied_to_amts xla_ae_journal_entry_pkg.t_array_num; -- 5132302

1300: l_recog_line_2 NUMBER;
1301:
1302: l_bflow_applied_to_amt_idx NUMBER; -- 5132302
1303: l_bflow_applied_to_amt NUMBER; -- 5132302
1304: l_bflow_applied_to_amts xla_ae_journal_entry_pkg.t_array_num; -- 5132302
1305:
1306: l_event_id NUMBER; -- To handle MPA header Description: xla_ae_header_pkg.SetHdrDescription
1307:
1308: --l_rounding_ccy VARCHAR2(15); -- To handle MPA rounding 4262811b

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

1375: l_accrual_line_num := NULL; -- 4262811
1376: l_tmp_amt := NULL; -- 4262811
1377: --
1378:
1379: IF XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.target_ledger_id = XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.ledger_id OR
1380: l_balance_type_code <> 'B' THEN
1381: IF (p_source_2 >= 1 AND
1382: NVL(p_source_10,'
1383: ') = 'RPR')

Line 1452: XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.target_ledger_id;

1448: --
1449: XLA_AE_LINES_PKG.g_rec_lines.array_balance_type_code(XLA_AE_LINES_PKG.g_LineNumber) := l_balance_type_code;
1450:
1451: XLA_AE_LINES_PKG.g_rec_lines.array_ledger_id(XLA_AE_LINES_PKG.g_LineNumber) :=
1452: XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.target_ledger_id;
1453:
1454: -- 4955764
1455: XLA_AE_LINES_PKG.g_rec_lines.array_gl_date(XLA_AE_LINES_PKG.g_LineNumber) :=
1456: XLA_AE_HEADER_PKG.g_rec_header_new.array_gl_date(g_array_event(p_event_id).array_value_num('header_index'));

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

1488: l_enc_upg_option := XLA_AE_LINES_PKG.g_rec_lines.array_enc_upg_option(XLA_AE_LINES_PKG.g_LineNumber);
1489:
1490: IF xla_accounting_cache_pkg.GetValueChar
1491: (p_source_code => 'LEDGER_CATEGORY_CODE'
1492: ,p_target_ledger_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.target_ledger_id) IN ('PRIMARY','ALC')
1493: AND l_bflow_method_code = 'PRIOR_ENTRY'
1494: -- AND (l_actual_upg_option = 'Y' OR l_enc_upg_option = 'Y') Bug 4922099
1495: AND ( (NVL(l_actual_upg_option, 'N') IN ('Y', 'O')) OR
1496: (NVL(l_enc_upg_option, 'N') IN ('Y', 'O'))

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

1636: p_lookup_type => 'XLA_OWNER_TYPE'
1637: ,p_lookup_code => l_component_type_code
1638: )
1639: ,p_token_4 => 'PRODUCT_NAME'
1640: ,p_value_4 => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.application_name
1641: ,p_entity_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.entity_id
1642: ,p_event_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.event_id
1643: ,p_ledger_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.target_ledger_id
1644: ,p_ae_header_id => NULL

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

1637: ,p_lookup_code => l_component_type_code
1638: )
1639: ,p_token_4 => 'PRODUCT_NAME'
1640: ,p_value_4 => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.application_name
1641: ,p_entity_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.entity_id
1642: ,p_event_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.event_id
1643: ,p_ledger_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.target_ledger_id
1644: ,p_ae_header_id => NULL
1645: );

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

1638: )
1639: ,p_token_4 => 'PRODUCT_NAME'
1640: ,p_value_4 => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.application_name
1641: ,p_entity_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.entity_id
1642: ,p_event_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.event_id
1643: ,p_ledger_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.target_ledger_id
1644: ,p_ae_header_id => NULL
1645: );
1646:

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

1639: ,p_token_4 => 'PRODUCT_NAME'
1640: ,p_value_4 => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.application_name
1641: ,p_entity_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.entity_id
1642: ,p_event_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.event_id
1643: ,p_ledger_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.target_ledger_id
1644: ,p_ae_header_id => NULL
1645: );
1646:
1647: IF (C_LEVEL_ERROR>= g_log_level) THEN

Line 1674: XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus

1670: ----------------------------------------------------------------------------------
1671: -- 4219869 Business Flow
1672: -- Update journal entry status -- Need to generate this within IF
1673: ----------------------------------------------------------------------------------
1674: XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
1675: (p_hdr_idx => g_array_event(p_event_id).array_value_num('header_index')
1676: ,p_balance_type_code => l_balance_type_code
1677: );
1678:

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

1715:
1716: --
1717: -- Depending on the Reversal Method setup, do a switch side or changes sign for the amounts
1718: --
1719: IF (XLA_AE_JOURNAL_ENTRY_PKG.g_cache_ledgers_info.ledger_reversal_option = 'SIDE') THEN
1720: XLA_AE_LINES_PKG.g_rec_lines.array_natural_side_code(XLA_AE_LINES_PKG.g_LineNumber) := l_acc_rev_natural_side_code;
1721: ELSE
1722: ---------------------------------------------------------------------------------------------------
1723: -- 4262811a Switch Sign

Line 1744: XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus

1740:
1741: XLA_AE_LINES_PKG.ValidateCurrentLine;
1742: XLA_AE_LINES_PKG.SetDebitCreditAmounts;
1743:
1744: XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
1745: (p_hdr_idx => g_array_event(p_event_id).array_value_num('acc_rev_header_index')
1746: ,p_balance_type_code => l_balance_type_code);
1747:
1748: END IF;

Line 1852: l_gl_dates xla_ae_journal_entry_pkg.t_array_date;

1848: l_tmp_amt NUMBER;
1849: l_acc_rev_natural_side_code VARCHAR2(1);
1850:
1851: l_num_entries NUMBER;
1852: l_gl_dates xla_ae_journal_entry_pkg.t_array_date;
1853: l_accted_amts xla_ae_journal_entry_pkg.t_array_num;
1854: l_entered_amts xla_ae_journal_entry_pkg.t_array_num;
1855: l_period_names xla_ae_journal_entry_pkg.t_array_V15L;
1856: l_recog_line_1 NUMBER;

Line 1853: l_accted_amts xla_ae_journal_entry_pkg.t_array_num;

1849: l_acc_rev_natural_side_code VARCHAR2(1);
1850:
1851: l_num_entries NUMBER;
1852: l_gl_dates xla_ae_journal_entry_pkg.t_array_date;
1853: l_accted_amts xla_ae_journal_entry_pkg.t_array_num;
1854: l_entered_amts xla_ae_journal_entry_pkg.t_array_num;
1855: l_period_names xla_ae_journal_entry_pkg.t_array_V15L;
1856: l_recog_line_1 NUMBER;
1857: l_recog_line_2 NUMBER;

Line 1854: l_entered_amts xla_ae_journal_entry_pkg.t_array_num;

1850:
1851: l_num_entries NUMBER;
1852: l_gl_dates xla_ae_journal_entry_pkg.t_array_date;
1853: l_accted_amts xla_ae_journal_entry_pkg.t_array_num;
1854: l_entered_amts xla_ae_journal_entry_pkg.t_array_num;
1855: l_period_names xla_ae_journal_entry_pkg.t_array_V15L;
1856: l_recog_line_1 NUMBER;
1857: l_recog_line_2 NUMBER;
1858:

Line 1855: l_period_names xla_ae_journal_entry_pkg.t_array_V15L;

1851: l_num_entries NUMBER;
1852: l_gl_dates xla_ae_journal_entry_pkg.t_array_date;
1853: l_accted_amts xla_ae_journal_entry_pkg.t_array_num;
1854: l_entered_amts xla_ae_journal_entry_pkg.t_array_num;
1855: l_period_names xla_ae_journal_entry_pkg.t_array_V15L;
1856: l_recog_line_1 NUMBER;
1857: l_recog_line_2 NUMBER;
1858:
1859: l_bflow_applied_to_amt_idx NUMBER; -- 5132302

Line 1861: l_bflow_applied_to_amts xla_ae_journal_entry_pkg.t_array_num; -- 5132302

1857: l_recog_line_2 NUMBER;
1858:
1859: l_bflow_applied_to_amt_idx NUMBER; -- 5132302
1860: l_bflow_applied_to_amt NUMBER; -- 5132302
1861: l_bflow_applied_to_amts xla_ae_journal_entry_pkg.t_array_num; -- 5132302
1862:
1863: l_event_id NUMBER; -- To handle MPA header Description: xla_ae_header_pkg.SetHdrDescription
1864:
1865: --l_rounding_ccy VARCHAR2(15); -- To handle MPA rounding 4262811b

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

1932: l_accrual_line_num := NULL; -- 4262811
1933: l_tmp_amt := NULL; -- 4262811
1934: --
1935:
1936: IF XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.target_ledger_id = XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.ledger_id OR
1937: l_balance_type_code <> 'B' THEN
1938: IF (p_source_2 >= 1 AND
1939: NVL(p_source_10,'
1940: ') = 'RPR')

Line 2009: XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.target_ledger_id;

2005: --
2006: XLA_AE_LINES_PKG.g_rec_lines.array_balance_type_code(XLA_AE_LINES_PKG.g_LineNumber) := l_balance_type_code;
2007:
2008: XLA_AE_LINES_PKG.g_rec_lines.array_ledger_id(XLA_AE_LINES_PKG.g_LineNumber) :=
2009: XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.target_ledger_id;
2010:
2011: -- 4955764
2012: XLA_AE_LINES_PKG.g_rec_lines.array_gl_date(XLA_AE_LINES_PKG.g_LineNumber) :=
2013: XLA_AE_HEADER_PKG.g_rec_header_new.array_gl_date(g_array_event(p_event_id).array_value_num('header_index'));

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

2045: l_enc_upg_option := XLA_AE_LINES_PKG.g_rec_lines.array_enc_upg_option(XLA_AE_LINES_PKG.g_LineNumber);
2046:
2047: IF xla_accounting_cache_pkg.GetValueChar
2048: (p_source_code => 'LEDGER_CATEGORY_CODE'
2049: ,p_target_ledger_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.target_ledger_id) IN ('PRIMARY','ALC')
2050: AND l_bflow_method_code = 'PRIOR_ENTRY'
2051: -- AND (l_actual_upg_option = 'Y' OR l_enc_upg_option = 'Y') Bug 4922099
2052: AND ( (NVL(l_actual_upg_option, 'N') IN ('Y', 'O')) OR
2053: (NVL(l_enc_upg_option, 'N') IN ('Y', 'O'))

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

2193: p_lookup_type => 'XLA_OWNER_TYPE'
2194: ,p_lookup_code => l_component_type_code
2195: )
2196: ,p_token_4 => 'PRODUCT_NAME'
2197: ,p_value_4 => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.application_name
2198: ,p_entity_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.entity_id
2199: ,p_event_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.event_id
2200: ,p_ledger_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.target_ledger_id
2201: ,p_ae_header_id => NULL

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

2194: ,p_lookup_code => l_component_type_code
2195: )
2196: ,p_token_4 => 'PRODUCT_NAME'
2197: ,p_value_4 => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.application_name
2198: ,p_entity_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.entity_id
2199: ,p_event_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.event_id
2200: ,p_ledger_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.target_ledger_id
2201: ,p_ae_header_id => NULL
2202: );

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

2195: )
2196: ,p_token_4 => 'PRODUCT_NAME'
2197: ,p_value_4 => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.application_name
2198: ,p_entity_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.entity_id
2199: ,p_event_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.event_id
2200: ,p_ledger_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.target_ledger_id
2201: ,p_ae_header_id => NULL
2202: );
2203:

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

2196: ,p_token_4 => 'PRODUCT_NAME'
2197: ,p_value_4 => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.application_name
2198: ,p_entity_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.entity_id
2199: ,p_event_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.event_id
2200: ,p_ledger_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.target_ledger_id
2201: ,p_ae_header_id => NULL
2202: );
2203:
2204: IF (C_LEVEL_ERROR>= g_log_level) THEN

Line 2231: XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus

2227: ----------------------------------------------------------------------------------
2228: -- 4219869 Business Flow
2229: -- Update journal entry status -- Need to generate this within IF
2230: ----------------------------------------------------------------------------------
2231: XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
2232: (p_hdr_idx => g_array_event(p_event_id).array_value_num('header_index')
2233: ,p_balance_type_code => l_balance_type_code
2234: );
2235:

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

2272:
2273: --
2274: -- Depending on the Reversal Method setup, do a switch side or changes sign for the amounts
2275: --
2276: IF (XLA_AE_JOURNAL_ENTRY_PKG.g_cache_ledgers_info.ledger_reversal_option = 'SIDE') THEN
2277: XLA_AE_LINES_PKG.g_rec_lines.array_natural_side_code(XLA_AE_LINES_PKG.g_LineNumber) := l_acc_rev_natural_side_code;
2278: ELSE
2279: ---------------------------------------------------------------------------------------------------
2280: -- 4262811a Switch Sign

Line 2301: XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus

2297:
2298: XLA_AE_LINES_PKG.ValidateCurrentLine;
2299: XLA_AE_LINES_PKG.SetDebitCreditAmounts;
2300:
2301: XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
2302: (p_hdr_idx => g_array_event(p_event_id).array_value_num('acc_rev_header_index')
2303: ,p_balance_type_code => l_balance_type_code);
2304:
2305: END IF;

Line 2409: l_gl_dates xla_ae_journal_entry_pkg.t_array_date;

2405: l_tmp_amt NUMBER;
2406: l_acc_rev_natural_side_code VARCHAR2(1);
2407:
2408: l_num_entries NUMBER;
2409: l_gl_dates xla_ae_journal_entry_pkg.t_array_date;
2410: l_accted_amts xla_ae_journal_entry_pkg.t_array_num;
2411: l_entered_amts xla_ae_journal_entry_pkg.t_array_num;
2412: l_period_names xla_ae_journal_entry_pkg.t_array_V15L;
2413: l_recog_line_1 NUMBER;

Line 2410: l_accted_amts xla_ae_journal_entry_pkg.t_array_num;

2406: l_acc_rev_natural_side_code VARCHAR2(1);
2407:
2408: l_num_entries NUMBER;
2409: l_gl_dates xla_ae_journal_entry_pkg.t_array_date;
2410: l_accted_amts xla_ae_journal_entry_pkg.t_array_num;
2411: l_entered_amts xla_ae_journal_entry_pkg.t_array_num;
2412: l_period_names xla_ae_journal_entry_pkg.t_array_V15L;
2413: l_recog_line_1 NUMBER;
2414: l_recog_line_2 NUMBER;

Line 2411: l_entered_amts xla_ae_journal_entry_pkg.t_array_num;

2407:
2408: l_num_entries NUMBER;
2409: l_gl_dates xla_ae_journal_entry_pkg.t_array_date;
2410: l_accted_amts xla_ae_journal_entry_pkg.t_array_num;
2411: l_entered_amts xla_ae_journal_entry_pkg.t_array_num;
2412: l_period_names xla_ae_journal_entry_pkg.t_array_V15L;
2413: l_recog_line_1 NUMBER;
2414: l_recog_line_2 NUMBER;
2415:

Line 2412: l_period_names xla_ae_journal_entry_pkg.t_array_V15L;

2408: l_num_entries NUMBER;
2409: l_gl_dates xla_ae_journal_entry_pkg.t_array_date;
2410: l_accted_amts xla_ae_journal_entry_pkg.t_array_num;
2411: l_entered_amts xla_ae_journal_entry_pkg.t_array_num;
2412: l_period_names xla_ae_journal_entry_pkg.t_array_V15L;
2413: l_recog_line_1 NUMBER;
2414: l_recog_line_2 NUMBER;
2415:
2416: l_bflow_applied_to_amt_idx NUMBER; -- 5132302

Line 2418: l_bflow_applied_to_amts xla_ae_journal_entry_pkg.t_array_num; -- 5132302

2414: l_recog_line_2 NUMBER;
2415:
2416: l_bflow_applied_to_amt_idx NUMBER; -- 5132302
2417: l_bflow_applied_to_amt NUMBER; -- 5132302
2418: l_bflow_applied_to_amts xla_ae_journal_entry_pkg.t_array_num; -- 5132302
2419:
2420: l_event_id NUMBER; -- To handle MPA header Description: xla_ae_header_pkg.SetHdrDescription
2421:
2422: --l_rounding_ccy VARCHAR2(15); -- To handle MPA rounding 4262811b

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

2489: l_accrual_line_num := NULL; -- 4262811
2490: l_tmp_amt := NULL; -- 4262811
2491: --
2492:
2493: IF XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.target_ledger_id = XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.ledger_id OR
2494: l_balance_type_code <> 'B' THEN
2495: IF (p_source_2 >= 1 AND
2496: NVL(p_source_10,'
2497: ') = 'RPR')

Line 2566: XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.target_ledger_id;

2562: --
2563: XLA_AE_LINES_PKG.g_rec_lines.array_balance_type_code(XLA_AE_LINES_PKG.g_LineNumber) := l_balance_type_code;
2564:
2565: XLA_AE_LINES_PKG.g_rec_lines.array_ledger_id(XLA_AE_LINES_PKG.g_LineNumber) :=
2566: XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.target_ledger_id;
2567:
2568: -- 4955764
2569: XLA_AE_LINES_PKG.g_rec_lines.array_gl_date(XLA_AE_LINES_PKG.g_LineNumber) :=
2570: XLA_AE_HEADER_PKG.g_rec_header_new.array_gl_date(g_array_event(p_event_id).array_value_num('header_index'));

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

2602: l_enc_upg_option := XLA_AE_LINES_PKG.g_rec_lines.array_enc_upg_option(XLA_AE_LINES_PKG.g_LineNumber);
2603:
2604: IF xla_accounting_cache_pkg.GetValueChar
2605: (p_source_code => 'LEDGER_CATEGORY_CODE'
2606: ,p_target_ledger_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.target_ledger_id) IN ('PRIMARY','ALC')
2607: AND l_bflow_method_code = 'PRIOR_ENTRY'
2608: -- AND (l_actual_upg_option = 'Y' OR l_enc_upg_option = 'Y') Bug 4922099
2609: AND ( (NVL(l_actual_upg_option, 'N') IN ('Y', 'O')) OR
2610: (NVL(l_enc_upg_option, 'N') IN ('Y', 'O'))

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

2750: p_lookup_type => 'XLA_OWNER_TYPE'
2751: ,p_lookup_code => l_component_type_code
2752: )
2753: ,p_token_4 => 'PRODUCT_NAME'
2754: ,p_value_4 => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.application_name
2755: ,p_entity_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.entity_id
2756: ,p_event_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.event_id
2757: ,p_ledger_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.target_ledger_id
2758: ,p_ae_header_id => NULL

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

2751: ,p_lookup_code => l_component_type_code
2752: )
2753: ,p_token_4 => 'PRODUCT_NAME'
2754: ,p_value_4 => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.application_name
2755: ,p_entity_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.entity_id
2756: ,p_event_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.event_id
2757: ,p_ledger_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.target_ledger_id
2758: ,p_ae_header_id => NULL
2759: );

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

2752: )
2753: ,p_token_4 => 'PRODUCT_NAME'
2754: ,p_value_4 => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.application_name
2755: ,p_entity_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.entity_id
2756: ,p_event_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.event_id
2757: ,p_ledger_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.target_ledger_id
2758: ,p_ae_header_id => NULL
2759: );
2760:

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

2753: ,p_token_4 => 'PRODUCT_NAME'
2754: ,p_value_4 => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.application_name
2755: ,p_entity_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.entity_id
2756: ,p_event_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.event_id
2757: ,p_ledger_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.target_ledger_id
2758: ,p_ae_header_id => NULL
2759: );
2760:
2761: IF (C_LEVEL_ERROR>= g_log_level) THEN

Line 2788: XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus

2784: ----------------------------------------------------------------------------------
2785: -- 4219869 Business Flow
2786: -- Update journal entry status -- Need to generate this within IF
2787: ----------------------------------------------------------------------------------
2788: XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
2789: (p_hdr_idx => g_array_event(p_event_id).array_value_num('header_index')
2790: ,p_balance_type_code => l_balance_type_code
2791: );
2792:

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

2829:
2830: --
2831: -- Depending on the Reversal Method setup, do a switch side or changes sign for the amounts
2832: --
2833: IF (XLA_AE_JOURNAL_ENTRY_PKG.g_cache_ledgers_info.ledger_reversal_option = 'SIDE') THEN
2834: XLA_AE_LINES_PKG.g_rec_lines.array_natural_side_code(XLA_AE_LINES_PKG.g_LineNumber) := l_acc_rev_natural_side_code;
2835: ELSE
2836: ---------------------------------------------------------------------------------------------------
2837: -- 4262811a Switch Sign

Line 2858: XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus

2854:
2855: XLA_AE_LINES_PKG.ValidateCurrentLine;
2856: XLA_AE_LINES_PKG.SetDebitCreditAmounts;
2857:
2858: XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
2859: (p_hdr_idx => g_array_event(p_event_id).array_value_num('acc_rev_header_index')
2860: ,p_balance_type_code => l_balance_type_code);
2861:
2862: END IF;

Line 2966: l_gl_dates xla_ae_journal_entry_pkg.t_array_date;

2962: l_tmp_amt NUMBER;
2963: l_acc_rev_natural_side_code VARCHAR2(1);
2964:
2965: l_num_entries NUMBER;
2966: l_gl_dates xla_ae_journal_entry_pkg.t_array_date;
2967: l_accted_amts xla_ae_journal_entry_pkg.t_array_num;
2968: l_entered_amts xla_ae_journal_entry_pkg.t_array_num;
2969: l_period_names xla_ae_journal_entry_pkg.t_array_V15L;
2970: l_recog_line_1 NUMBER;

Line 2967: l_accted_amts xla_ae_journal_entry_pkg.t_array_num;

2963: l_acc_rev_natural_side_code VARCHAR2(1);
2964:
2965: l_num_entries NUMBER;
2966: l_gl_dates xla_ae_journal_entry_pkg.t_array_date;
2967: l_accted_amts xla_ae_journal_entry_pkg.t_array_num;
2968: l_entered_amts xla_ae_journal_entry_pkg.t_array_num;
2969: l_period_names xla_ae_journal_entry_pkg.t_array_V15L;
2970: l_recog_line_1 NUMBER;
2971: l_recog_line_2 NUMBER;

Line 2968: l_entered_amts xla_ae_journal_entry_pkg.t_array_num;

2964:
2965: l_num_entries NUMBER;
2966: l_gl_dates xla_ae_journal_entry_pkg.t_array_date;
2967: l_accted_amts xla_ae_journal_entry_pkg.t_array_num;
2968: l_entered_amts xla_ae_journal_entry_pkg.t_array_num;
2969: l_period_names xla_ae_journal_entry_pkg.t_array_V15L;
2970: l_recog_line_1 NUMBER;
2971: l_recog_line_2 NUMBER;
2972:

Line 2969: l_period_names xla_ae_journal_entry_pkg.t_array_V15L;

2965: l_num_entries NUMBER;
2966: l_gl_dates xla_ae_journal_entry_pkg.t_array_date;
2967: l_accted_amts xla_ae_journal_entry_pkg.t_array_num;
2968: l_entered_amts xla_ae_journal_entry_pkg.t_array_num;
2969: l_period_names xla_ae_journal_entry_pkg.t_array_V15L;
2970: l_recog_line_1 NUMBER;
2971: l_recog_line_2 NUMBER;
2972:
2973: l_bflow_applied_to_amt_idx NUMBER; -- 5132302

Line 2975: l_bflow_applied_to_amts xla_ae_journal_entry_pkg.t_array_num; -- 5132302

2971: l_recog_line_2 NUMBER;
2972:
2973: l_bflow_applied_to_amt_idx NUMBER; -- 5132302
2974: l_bflow_applied_to_amt NUMBER; -- 5132302
2975: l_bflow_applied_to_amts xla_ae_journal_entry_pkg.t_array_num; -- 5132302
2976:
2977: l_event_id NUMBER; -- To handle MPA header Description: xla_ae_header_pkg.SetHdrDescription
2978:
2979: --l_rounding_ccy VARCHAR2(15); -- To handle MPA rounding 4262811b

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

3046: l_accrual_line_num := NULL; -- 4262811
3047: l_tmp_amt := NULL; -- 4262811
3048: --
3049:
3050: IF XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.target_ledger_id = XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.ledger_id OR
3051: l_balance_type_code <> 'B' THEN
3052: IF (p_source_2 >= 1 AND
3053: NVL(p_source_10,'
3054: ') = 'RPR')

Line 3123: XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.target_ledger_id;

3119: --
3120: XLA_AE_LINES_PKG.g_rec_lines.array_balance_type_code(XLA_AE_LINES_PKG.g_LineNumber) := l_balance_type_code;
3121:
3122: XLA_AE_LINES_PKG.g_rec_lines.array_ledger_id(XLA_AE_LINES_PKG.g_LineNumber) :=
3123: XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.target_ledger_id;
3124:
3125: -- 4955764
3126: XLA_AE_LINES_PKG.g_rec_lines.array_gl_date(XLA_AE_LINES_PKG.g_LineNumber) :=
3127: XLA_AE_HEADER_PKG.g_rec_header_new.array_gl_date(g_array_event(p_event_id).array_value_num('header_index'));

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

3159: l_enc_upg_option := XLA_AE_LINES_PKG.g_rec_lines.array_enc_upg_option(XLA_AE_LINES_PKG.g_LineNumber);
3160:
3161: IF xla_accounting_cache_pkg.GetValueChar
3162: (p_source_code => 'LEDGER_CATEGORY_CODE'
3163: ,p_target_ledger_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.target_ledger_id) IN ('PRIMARY','ALC')
3164: AND l_bflow_method_code = 'PRIOR_ENTRY'
3165: -- AND (l_actual_upg_option = 'Y' OR l_enc_upg_option = 'Y') Bug 4922099
3166: AND ( (NVL(l_actual_upg_option, 'N') IN ('Y', 'O')) OR
3167: (NVL(l_enc_upg_option, 'N') IN ('Y', 'O'))

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

3307: p_lookup_type => 'XLA_OWNER_TYPE'
3308: ,p_lookup_code => l_component_type_code
3309: )
3310: ,p_token_4 => 'PRODUCT_NAME'
3311: ,p_value_4 => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.application_name
3312: ,p_entity_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.entity_id
3313: ,p_event_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.event_id
3314: ,p_ledger_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.target_ledger_id
3315: ,p_ae_header_id => NULL

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

3308: ,p_lookup_code => l_component_type_code
3309: )
3310: ,p_token_4 => 'PRODUCT_NAME'
3311: ,p_value_4 => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.application_name
3312: ,p_entity_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.entity_id
3313: ,p_event_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.event_id
3314: ,p_ledger_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.target_ledger_id
3315: ,p_ae_header_id => NULL
3316: );

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

3309: )
3310: ,p_token_4 => 'PRODUCT_NAME'
3311: ,p_value_4 => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.application_name
3312: ,p_entity_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.entity_id
3313: ,p_event_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.event_id
3314: ,p_ledger_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.target_ledger_id
3315: ,p_ae_header_id => NULL
3316: );
3317:

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

3310: ,p_token_4 => 'PRODUCT_NAME'
3311: ,p_value_4 => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.application_name
3312: ,p_entity_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.entity_id
3313: ,p_event_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.event_id
3314: ,p_ledger_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.target_ledger_id
3315: ,p_ae_header_id => NULL
3316: );
3317:
3318: IF (C_LEVEL_ERROR>= g_log_level) THEN

Line 3345: XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus

3341: ----------------------------------------------------------------------------------
3342: -- 4219869 Business Flow
3343: -- Update journal entry status -- Need to generate this within IF
3344: ----------------------------------------------------------------------------------
3345: XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
3346: (p_hdr_idx => g_array_event(p_event_id).array_value_num('header_index')
3347: ,p_balance_type_code => l_balance_type_code
3348: );
3349:

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

3386:
3387: --
3388: -- Depending on the Reversal Method setup, do a switch side or changes sign for the amounts
3389: --
3390: IF (XLA_AE_JOURNAL_ENTRY_PKG.g_cache_ledgers_info.ledger_reversal_option = 'SIDE') THEN
3391: XLA_AE_LINES_PKG.g_rec_lines.array_natural_side_code(XLA_AE_LINES_PKG.g_LineNumber) := l_acc_rev_natural_side_code;
3392: ELSE
3393: ---------------------------------------------------------------------------------------------------
3394: -- 4262811a Switch Sign

Line 3415: XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus

3411:
3412: XLA_AE_LINES_PKG.ValidateCurrentLine;
3413: XLA_AE_LINES_PKG.SetDebitCreditAmounts;
3414:
3415: XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
3416: (p_hdr_idx => g_array_event(p_event_id).array_value_num('acc_rev_header_index')
3417: ,p_balance_type_code => l_balance_type_code);
3418:
3419: END IF;

Line 3529: l_gl_dates xla_ae_journal_entry_pkg.t_array_date;

3525: l_tmp_amt NUMBER;
3526: l_acc_rev_natural_side_code VARCHAR2(1);
3527:
3528: l_num_entries NUMBER;
3529: l_gl_dates xla_ae_journal_entry_pkg.t_array_date;
3530: l_accted_amts xla_ae_journal_entry_pkg.t_array_num;
3531: l_entered_amts xla_ae_journal_entry_pkg.t_array_num;
3532: l_period_names xla_ae_journal_entry_pkg.t_array_V15L;
3533: l_recog_line_1 NUMBER;

Line 3530: l_accted_amts xla_ae_journal_entry_pkg.t_array_num;

3526: l_acc_rev_natural_side_code VARCHAR2(1);
3527:
3528: l_num_entries NUMBER;
3529: l_gl_dates xla_ae_journal_entry_pkg.t_array_date;
3530: l_accted_amts xla_ae_journal_entry_pkg.t_array_num;
3531: l_entered_amts xla_ae_journal_entry_pkg.t_array_num;
3532: l_period_names xla_ae_journal_entry_pkg.t_array_V15L;
3533: l_recog_line_1 NUMBER;
3534: l_recog_line_2 NUMBER;

Line 3531: l_entered_amts xla_ae_journal_entry_pkg.t_array_num;

3527:
3528: l_num_entries NUMBER;
3529: l_gl_dates xla_ae_journal_entry_pkg.t_array_date;
3530: l_accted_amts xla_ae_journal_entry_pkg.t_array_num;
3531: l_entered_amts xla_ae_journal_entry_pkg.t_array_num;
3532: l_period_names xla_ae_journal_entry_pkg.t_array_V15L;
3533: l_recog_line_1 NUMBER;
3534: l_recog_line_2 NUMBER;
3535:

Line 3532: l_period_names xla_ae_journal_entry_pkg.t_array_V15L;

3528: l_num_entries NUMBER;
3529: l_gl_dates xla_ae_journal_entry_pkg.t_array_date;
3530: l_accted_amts xla_ae_journal_entry_pkg.t_array_num;
3531: l_entered_amts xla_ae_journal_entry_pkg.t_array_num;
3532: l_period_names xla_ae_journal_entry_pkg.t_array_V15L;
3533: l_recog_line_1 NUMBER;
3534: l_recog_line_2 NUMBER;
3535:
3536: l_bflow_applied_to_amt_idx NUMBER; -- 5132302

Line 3538: l_bflow_applied_to_amts xla_ae_journal_entry_pkg.t_array_num; -- 5132302

3534: l_recog_line_2 NUMBER;
3535:
3536: l_bflow_applied_to_amt_idx NUMBER; -- 5132302
3537: l_bflow_applied_to_amt NUMBER; -- 5132302
3538: l_bflow_applied_to_amts xla_ae_journal_entry_pkg.t_array_num; -- 5132302
3539:
3540: l_event_id NUMBER; -- To handle MPA header Description: xla_ae_header_pkg.SetHdrDescription
3541:
3542: --l_rounding_ccy VARCHAR2(15); -- To handle MPA rounding 4262811b

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

3609: l_accrual_line_num := NULL; -- 4262811
3610: l_tmp_amt := NULL; -- 4262811
3611: --
3612:
3613: IF XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.target_ledger_id = XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.ledger_id OR
3614: l_balance_type_code <> 'B' THEN
3615: IF (p_source_2 >= 1 AND
3616: NVL(p_source_10,'
3617: ') <> 'RPR')

Line 3686: XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.target_ledger_id;

3682: --
3683: XLA_AE_LINES_PKG.g_rec_lines.array_balance_type_code(XLA_AE_LINES_PKG.g_LineNumber) := l_balance_type_code;
3684:
3685: XLA_AE_LINES_PKG.g_rec_lines.array_ledger_id(XLA_AE_LINES_PKG.g_LineNumber) :=
3686: XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.target_ledger_id;
3687:
3688: -- 4955764
3689: XLA_AE_LINES_PKG.g_rec_lines.array_gl_date(XLA_AE_LINES_PKG.g_LineNumber) :=
3690: XLA_AE_HEADER_PKG.g_rec_header_new.array_gl_date(g_array_event(p_event_id).array_value_num('header_index'));

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

3722: l_enc_upg_option := XLA_AE_LINES_PKG.g_rec_lines.array_enc_upg_option(XLA_AE_LINES_PKG.g_LineNumber);
3723:
3724: IF xla_accounting_cache_pkg.GetValueChar
3725: (p_source_code => 'LEDGER_CATEGORY_CODE'
3726: ,p_target_ledger_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.target_ledger_id) IN ('PRIMARY','ALC')
3727: AND l_bflow_method_code = 'PRIOR_ENTRY'
3728: -- AND (l_actual_upg_option = 'Y' OR l_enc_upg_option = 'Y') Bug 4922099
3729: AND ( (NVL(l_actual_upg_option, 'N') IN ('Y', 'O')) OR
3730: (NVL(l_enc_upg_option, 'N') IN ('Y', 'O'))

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

3874: p_lookup_type => 'XLA_OWNER_TYPE'
3875: ,p_lookup_code => l_component_type_code
3876: )
3877: ,p_token_4 => 'PRODUCT_NAME'
3878: ,p_value_4 => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.application_name
3879: ,p_entity_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.entity_id
3880: ,p_event_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.event_id
3881: ,p_ledger_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.target_ledger_id
3882: ,p_ae_header_id => NULL

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

3875: ,p_lookup_code => l_component_type_code
3876: )
3877: ,p_token_4 => 'PRODUCT_NAME'
3878: ,p_value_4 => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.application_name
3879: ,p_entity_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.entity_id
3880: ,p_event_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.event_id
3881: ,p_ledger_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.target_ledger_id
3882: ,p_ae_header_id => NULL
3883: );

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

3876: )
3877: ,p_token_4 => 'PRODUCT_NAME'
3878: ,p_value_4 => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.application_name
3879: ,p_entity_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.entity_id
3880: ,p_event_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.event_id
3881: ,p_ledger_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.target_ledger_id
3882: ,p_ae_header_id => NULL
3883: );
3884:

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

3877: ,p_token_4 => 'PRODUCT_NAME'
3878: ,p_value_4 => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.application_name
3879: ,p_entity_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.entity_id
3880: ,p_event_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.event_id
3881: ,p_ledger_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.target_ledger_id
3882: ,p_ae_header_id => NULL
3883: );
3884:
3885: IF (C_LEVEL_ERROR>= g_log_level) THEN

Line 3912: XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus

3908: ----------------------------------------------------------------------------------
3909: -- 4219869 Business Flow
3910: -- Update journal entry status -- Need to generate this within IF
3911: ----------------------------------------------------------------------------------
3912: XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
3913: (p_hdr_idx => g_array_event(p_event_id).array_value_num('header_index')
3914: ,p_balance_type_code => l_balance_type_code
3915: );
3916:

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

3953:
3954: --
3955: -- Depending on the Reversal Method setup, do a switch side or changes sign for the amounts
3956: --
3957: IF (XLA_AE_JOURNAL_ENTRY_PKG.g_cache_ledgers_info.ledger_reversal_option = 'SIDE') THEN
3958: XLA_AE_LINES_PKG.g_rec_lines.array_natural_side_code(XLA_AE_LINES_PKG.g_LineNumber) := l_acc_rev_natural_side_code;
3959: ELSE
3960: ---------------------------------------------------------------------------------------------------
3961: -- 4262811a Switch Sign

Line 3982: XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus

3978:
3979: XLA_AE_LINES_PKG.ValidateCurrentLine;
3980: XLA_AE_LINES_PKG.SetDebitCreditAmounts;
3981:
3982: XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
3983: (p_hdr_idx => g_array_event(p_event_id).array_value_num('acc_rev_header_index')
3984: ,p_balance_type_code => l_balance_type_code);
3985:
3986: END IF;

Line 4096: l_gl_dates xla_ae_journal_entry_pkg.t_array_date;

4092: l_tmp_amt NUMBER;
4093: l_acc_rev_natural_side_code VARCHAR2(1);
4094:
4095: l_num_entries NUMBER;
4096: l_gl_dates xla_ae_journal_entry_pkg.t_array_date;
4097: l_accted_amts xla_ae_journal_entry_pkg.t_array_num;
4098: l_entered_amts xla_ae_journal_entry_pkg.t_array_num;
4099: l_period_names xla_ae_journal_entry_pkg.t_array_V15L;
4100: l_recog_line_1 NUMBER;

Line 4097: l_accted_amts xla_ae_journal_entry_pkg.t_array_num;

4093: l_acc_rev_natural_side_code VARCHAR2(1);
4094:
4095: l_num_entries NUMBER;
4096: l_gl_dates xla_ae_journal_entry_pkg.t_array_date;
4097: l_accted_amts xla_ae_journal_entry_pkg.t_array_num;
4098: l_entered_amts xla_ae_journal_entry_pkg.t_array_num;
4099: l_period_names xla_ae_journal_entry_pkg.t_array_V15L;
4100: l_recog_line_1 NUMBER;
4101: l_recog_line_2 NUMBER;

Line 4098: l_entered_amts xla_ae_journal_entry_pkg.t_array_num;

4094:
4095: l_num_entries NUMBER;
4096: l_gl_dates xla_ae_journal_entry_pkg.t_array_date;
4097: l_accted_amts xla_ae_journal_entry_pkg.t_array_num;
4098: l_entered_amts xla_ae_journal_entry_pkg.t_array_num;
4099: l_period_names xla_ae_journal_entry_pkg.t_array_V15L;
4100: l_recog_line_1 NUMBER;
4101: l_recog_line_2 NUMBER;
4102:

Line 4099: l_period_names xla_ae_journal_entry_pkg.t_array_V15L;

4095: l_num_entries NUMBER;
4096: l_gl_dates xla_ae_journal_entry_pkg.t_array_date;
4097: l_accted_amts xla_ae_journal_entry_pkg.t_array_num;
4098: l_entered_amts xla_ae_journal_entry_pkg.t_array_num;
4099: l_period_names xla_ae_journal_entry_pkg.t_array_V15L;
4100: l_recog_line_1 NUMBER;
4101: l_recog_line_2 NUMBER;
4102:
4103: l_bflow_applied_to_amt_idx NUMBER; -- 5132302

Line 4105: l_bflow_applied_to_amts xla_ae_journal_entry_pkg.t_array_num; -- 5132302

4101: l_recog_line_2 NUMBER;
4102:
4103: l_bflow_applied_to_amt_idx NUMBER; -- 5132302
4104: l_bflow_applied_to_amt NUMBER; -- 5132302
4105: l_bflow_applied_to_amts xla_ae_journal_entry_pkg.t_array_num; -- 5132302
4106:
4107: l_event_id NUMBER; -- To handle MPA header Description: xla_ae_header_pkg.SetHdrDescription
4108:
4109: --l_rounding_ccy VARCHAR2(15); -- To handle MPA rounding 4262811b

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

4176: l_accrual_line_num := NULL; -- 4262811
4177: l_tmp_amt := NULL; -- 4262811
4178: --
4179:
4180: IF XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.target_ledger_id = XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.ledger_id OR
4181: l_balance_type_code <> 'B' THEN
4182: IF (p_source_2 >= 1 AND
4183: NVL(p_source_10,'
4184: ') <> 'RPR')

Line 4253: XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.target_ledger_id;

4249: --
4250: XLA_AE_LINES_PKG.g_rec_lines.array_balance_type_code(XLA_AE_LINES_PKG.g_LineNumber) := l_balance_type_code;
4251:
4252: XLA_AE_LINES_PKG.g_rec_lines.array_ledger_id(XLA_AE_LINES_PKG.g_LineNumber) :=
4253: XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.target_ledger_id;
4254:
4255: -- 4955764
4256: XLA_AE_LINES_PKG.g_rec_lines.array_gl_date(XLA_AE_LINES_PKG.g_LineNumber) :=
4257: XLA_AE_HEADER_PKG.g_rec_header_new.array_gl_date(g_array_event(p_event_id).array_value_num('header_index'));

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

4289: l_enc_upg_option := XLA_AE_LINES_PKG.g_rec_lines.array_enc_upg_option(XLA_AE_LINES_PKG.g_LineNumber);
4290:
4291: IF xla_accounting_cache_pkg.GetValueChar
4292: (p_source_code => 'LEDGER_CATEGORY_CODE'
4293: ,p_target_ledger_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.target_ledger_id) IN ('PRIMARY','ALC')
4294: AND l_bflow_method_code = 'PRIOR_ENTRY'
4295: -- AND (l_actual_upg_option = 'Y' OR l_enc_upg_option = 'Y') Bug 4922099
4296: AND ( (NVL(l_actual_upg_option, 'N') IN ('Y', 'O')) OR
4297: (NVL(l_enc_upg_option, 'N') IN ('Y', 'O'))

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

4441: p_lookup_type => 'XLA_OWNER_TYPE'
4442: ,p_lookup_code => l_component_type_code
4443: )
4444: ,p_token_4 => 'PRODUCT_NAME'
4445: ,p_value_4 => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.application_name
4446: ,p_entity_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.entity_id
4447: ,p_event_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.event_id
4448: ,p_ledger_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.target_ledger_id
4449: ,p_ae_header_id => NULL

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

4442: ,p_lookup_code => l_component_type_code
4443: )
4444: ,p_token_4 => 'PRODUCT_NAME'
4445: ,p_value_4 => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.application_name
4446: ,p_entity_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.entity_id
4447: ,p_event_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.event_id
4448: ,p_ledger_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.target_ledger_id
4449: ,p_ae_header_id => NULL
4450: );

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

4443: )
4444: ,p_token_4 => 'PRODUCT_NAME'
4445: ,p_value_4 => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.application_name
4446: ,p_entity_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.entity_id
4447: ,p_event_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.event_id
4448: ,p_ledger_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.target_ledger_id
4449: ,p_ae_header_id => NULL
4450: );
4451:

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

4444: ,p_token_4 => 'PRODUCT_NAME'
4445: ,p_value_4 => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.application_name
4446: ,p_entity_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.entity_id
4447: ,p_event_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.event_id
4448: ,p_ledger_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.target_ledger_id
4449: ,p_ae_header_id => NULL
4450: );
4451:
4452: IF (C_LEVEL_ERROR>= g_log_level) THEN

Line 4479: XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus

4475: ----------------------------------------------------------------------------------
4476: -- 4219869 Business Flow
4477: -- Update journal entry status -- Need to generate this within IF
4478: ----------------------------------------------------------------------------------
4479: XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
4480: (p_hdr_idx => g_array_event(p_event_id).array_value_num('header_index')
4481: ,p_balance_type_code => l_balance_type_code
4482: );
4483:

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

4520:
4521: --
4522: -- Depending on the Reversal Method setup, do a switch side or changes sign for the amounts
4523: --
4524: IF (XLA_AE_JOURNAL_ENTRY_PKG.g_cache_ledgers_info.ledger_reversal_option = 'SIDE') THEN
4525: XLA_AE_LINES_PKG.g_rec_lines.array_natural_side_code(XLA_AE_LINES_PKG.g_LineNumber) := l_acc_rev_natural_side_code;
4526: ELSE
4527: ---------------------------------------------------------------------------------------------------
4528: -- 4262811a Switch Sign

Line 4549: XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus

4545:
4546: XLA_AE_LINES_PKG.ValidateCurrentLine;
4547: XLA_AE_LINES_PKG.SetDebitCreditAmounts;
4548:
4549: XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
4550: (p_hdr_idx => g_array_event(p_event_id).array_value_num('acc_rev_header_index')
4551: ,p_balance_type_code => l_balance_type_code);
4552:
4553: END IF;

Line 4942: l_array_legal_entity_id XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;

4938:
4939: l_calculate_acctd_flag VARCHAR2(1) :='N';
4940: l_calculate_g_l_flag VARCHAR2(1) :='N';
4941: --
4942: l_array_legal_entity_id XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
4943: l_array_entity_id XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
4944: l_array_entity_code XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L;
4945: l_array_transaction_num XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
4946: l_array_event_id XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;

Line 4943: l_array_entity_id XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;

4939: l_calculate_acctd_flag VARCHAR2(1) :='N';
4940: l_calculate_g_l_flag VARCHAR2(1) :='N';
4941: --
4942: l_array_legal_entity_id XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
4943: l_array_entity_id XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
4944: l_array_entity_code XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L;
4945: l_array_transaction_num XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
4946: l_array_event_id XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
4947: l_array_class_code XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L;

Line 4944: l_array_entity_code XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L;

4940: l_calculate_g_l_flag VARCHAR2(1) :='N';
4941: --
4942: l_array_legal_entity_id XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
4943: l_array_entity_id XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
4944: l_array_entity_code XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L;
4945: l_array_transaction_num XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
4946: l_array_event_id XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
4947: l_array_class_code XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L;
4948: l_array_event_type XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L;

Line 4945: l_array_transaction_num XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;

4941: --
4942: l_array_legal_entity_id XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
4943: l_array_entity_id XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
4944: l_array_entity_code XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L;
4945: l_array_transaction_num XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
4946: l_array_event_id XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
4947: l_array_class_code XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L;
4948: l_array_event_type XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L;
4949: l_array_event_number XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;

Line 4946: l_array_event_id XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;

4942: l_array_legal_entity_id XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
4943: l_array_entity_id XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
4944: l_array_entity_code XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L;
4945: l_array_transaction_num XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
4946: l_array_event_id XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
4947: l_array_class_code XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L;
4948: l_array_event_type XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L;
4949: l_array_event_number XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
4950: l_array_event_date XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;

Line 4947: l_array_class_code XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L;

4943: l_array_entity_id XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
4944: l_array_entity_code XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L;
4945: l_array_transaction_num XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
4946: l_array_event_id XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
4947: l_array_class_code XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L;
4948: l_array_event_type XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L;
4949: l_array_event_number XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
4950: l_array_event_date XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
4951: l_array_transaction_date XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;

Line 4948: l_array_event_type XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L;

4944: l_array_entity_code XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L;
4945: l_array_transaction_num XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
4946: l_array_event_id XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
4947: l_array_class_code XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L;
4948: l_array_event_type XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L;
4949: l_array_event_number XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
4950: l_array_event_date XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
4951: l_array_transaction_date XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
4952: l_array_reference_num_1 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;

Line 4949: l_array_event_number XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;

4945: l_array_transaction_num XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
4946: l_array_event_id XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
4947: l_array_class_code XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L;
4948: l_array_event_type XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L;
4949: l_array_event_number XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
4950: l_array_event_date XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
4951: l_array_transaction_date XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
4952: l_array_reference_num_1 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
4953: l_array_reference_num_2 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;

Line 4950: l_array_event_date XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;

4946: l_array_event_id XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
4947: l_array_class_code XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L;
4948: l_array_event_type XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L;
4949: l_array_event_number XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
4950: l_array_event_date XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
4951: l_array_transaction_date XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
4952: l_array_reference_num_1 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
4953: l_array_reference_num_2 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
4954: l_array_reference_num_3 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;

Line 4951: l_array_transaction_date XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;

4947: l_array_class_code XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L;
4948: l_array_event_type XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L;
4949: l_array_event_number XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
4950: l_array_event_date XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
4951: l_array_transaction_date XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
4952: l_array_reference_num_1 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
4953: l_array_reference_num_2 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
4954: l_array_reference_num_3 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
4955: l_array_reference_num_4 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;

Line 4952: l_array_reference_num_1 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;

4948: l_array_event_type XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L;
4949: l_array_event_number XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
4950: l_array_event_date XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
4951: l_array_transaction_date XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
4952: l_array_reference_num_1 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
4953: l_array_reference_num_2 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
4954: l_array_reference_num_3 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
4955: l_array_reference_num_4 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
4956: l_array_reference_char_1 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;

Line 4953: l_array_reference_num_2 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;

4949: l_array_event_number XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
4950: l_array_event_date XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
4951: l_array_transaction_date XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
4952: l_array_reference_num_1 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
4953: l_array_reference_num_2 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
4954: l_array_reference_num_3 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
4955: l_array_reference_num_4 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
4956: l_array_reference_char_1 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
4957: l_array_reference_char_2 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;

Line 4954: l_array_reference_num_3 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;

4950: l_array_event_date XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
4951: l_array_transaction_date XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
4952: l_array_reference_num_1 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
4953: l_array_reference_num_2 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
4954: l_array_reference_num_3 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
4955: l_array_reference_num_4 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
4956: l_array_reference_char_1 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
4957: l_array_reference_char_2 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
4958: l_array_reference_char_3 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;

Line 4955: l_array_reference_num_4 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;

4951: l_array_transaction_date XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
4952: l_array_reference_num_1 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
4953: l_array_reference_num_2 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
4954: l_array_reference_num_3 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
4955: l_array_reference_num_4 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
4956: l_array_reference_char_1 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
4957: l_array_reference_char_2 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
4958: l_array_reference_char_3 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
4959: l_array_reference_char_4 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;

Line 4956: l_array_reference_char_1 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;

4952: l_array_reference_num_1 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
4953: l_array_reference_num_2 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
4954: l_array_reference_num_3 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
4955: l_array_reference_num_4 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
4956: l_array_reference_char_1 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
4957: l_array_reference_char_2 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
4958: l_array_reference_char_3 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
4959: l_array_reference_char_4 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
4960: l_array_reference_date_1 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;

Line 4957: l_array_reference_char_2 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;

4953: l_array_reference_num_2 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
4954: l_array_reference_num_3 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
4955: l_array_reference_num_4 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
4956: l_array_reference_char_1 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
4957: l_array_reference_char_2 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
4958: l_array_reference_char_3 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
4959: l_array_reference_char_4 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
4960: l_array_reference_date_1 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
4961: l_array_reference_date_2 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;

Line 4958: l_array_reference_char_3 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;

4954: l_array_reference_num_3 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
4955: l_array_reference_num_4 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
4956: l_array_reference_char_1 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
4957: l_array_reference_char_2 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
4958: l_array_reference_char_3 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
4959: l_array_reference_char_4 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
4960: l_array_reference_date_1 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
4961: l_array_reference_date_2 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
4962: l_array_reference_date_3 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;

Line 4959: l_array_reference_char_4 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;

4955: l_array_reference_num_4 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
4956: l_array_reference_char_1 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
4957: l_array_reference_char_2 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
4958: l_array_reference_char_3 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
4959: l_array_reference_char_4 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
4960: l_array_reference_date_1 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
4961: l_array_reference_date_2 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
4962: l_array_reference_date_3 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
4963: l_array_reference_date_4 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;

Line 4960: l_array_reference_date_1 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;

4956: l_array_reference_char_1 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
4957: l_array_reference_char_2 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
4958: l_array_reference_char_3 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
4959: l_array_reference_char_4 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
4960: l_array_reference_date_1 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
4961: l_array_reference_date_2 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
4962: l_array_reference_date_3 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
4963: l_array_reference_date_4 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
4964: l_array_event_created_by XLA_AE_JOURNAL_ENTRY_PKG.t_array_V100L;

Line 4961: l_array_reference_date_2 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;

4957: l_array_reference_char_2 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
4958: l_array_reference_char_3 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
4959: l_array_reference_char_4 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
4960: l_array_reference_date_1 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
4961: l_array_reference_date_2 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
4962: l_array_reference_date_3 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
4963: l_array_reference_date_4 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
4964: l_array_event_created_by XLA_AE_JOURNAL_ENTRY_PKG.t_array_V100L;
4965: l_array_budgetary_control_flag XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L;

Line 4962: l_array_reference_date_3 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;

4958: l_array_reference_char_3 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
4959: l_array_reference_char_4 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
4960: l_array_reference_date_1 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
4961: l_array_reference_date_2 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
4962: l_array_reference_date_3 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
4963: l_array_reference_date_4 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
4964: l_array_event_created_by XLA_AE_JOURNAL_ENTRY_PKG.t_array_V100L;
4965: l_array_budgetary_control_flag XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L;
4966:

Line 4963: l_array_reference_date_4 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;

4959: l_array_reference_char_4 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
4960: l_array_reference_date_1 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
4961: l_array_reference_date_2 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
4962: l_array_reference_date_3 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
4963: l_array_reference_date_4 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
4964: l_array_event_created_by XLA_AE_JOURNAL_ENTRY_PKG.t_array_V100L;
4965: l_array_budgetary_control_flag XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L;
4966:
4967: l_event_id NUMBER;

Line 4964: l_array_event_created_by XLA_AE_JOURNAL_ENTRY_PKG.t_array_V100L;

4960: l_array_reference_date_1 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
4961: l_array_reference_date_2 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
4962: l_array_reference_date_3 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
4963: l_array_reference_date_4 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
4964: l_array_event_created_by XLA_AE_JOURNAL_ENTRY_PKG.t_array_V100L;
4965: l_array_budgetary_control_flag XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L;
4966:
4967: l_event_id NUMBER;
4968: l_previous_event_id NUMBER;

Line 4965: l_array_budgetary_control_flag XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L;

4961: l_array_reference_date_2 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
4962: l_array_reference_date_3 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
4963: l_array_reference_date_4 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
4964: l_array_event_created_by XLA_AE_JOURNAL_ENTRY_PKG.t_array_V100L;
4965: l_array_budgetary_control_flag XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L;
4966:
4967: l_event_id NUMBER;
4968: l_previous_event_id NUMBER;
4969: l_first_event_id NUMBER;

Line 4983: l_array_extract_line_num xla_ae_journal_entry_pkg.t_array_Num;

4979: l_event_class_name VARCHAR2(80) := 'Budget Execution Transactions';
4980: l_description VARCHAR2(4000);
4981: l_transaction_reversal NUMBER;
4982: l_ae_header_id NUMBER;
4983: l_array_extract_line_num xla_ae_journal_entry_pkg.t_array_Num;
4984: l_log_module VARCHAR2(240);
4985: --
4986: l_acct_reversal_source VARCHAR2(30);
4987: l_trx_reversal_source VARCHAR2(30);

Line 5241: XLA_AE_JOURNAL_ENTRY_PKG.set_event_info

5237:
5238: --
5239: -- set event info as cache for other routines to refer event attributes
5240: --
5241: XLA_AE_JOURNAL_ENTRY_PKG.set_event_info
5242: (p_application_id => p_application_id
5243: ,p_primary_ledger_id => p_primary_ledger_id
5244: ,p_base_ledger_id => p_base_ledger_id
5245: ,p_target_ledger_id => p_target_ledger_id

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

5270:
5271: --
5272: -- set the status of entry to C_VALID (0)
5273: --
5274: XLA_AE_JOURNAL_ENTRY_PKG.g_global_status := XLA_AE_JOURNAL_ENTRY_PKG.C_VALID;
5275:
5276: --
5277: -- initialize a row for ae header
5278: --

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

5301: --
5302: -- initilaize the status of ae headers for diffrent balance types
5303: -- the status is initialised to C_NOT_CREATED (2)
5304: --
5305: --g_array_event(l_event_id).array_value_num('actual_je_status') := XLA_AE_JOURNAL_ENTRY_PKG.C_NOT_CREATED;
5306: --g_array_event(l_event_id).array_value_num('budget_je_status') := XLA_AE_JOURNAL_ENTRY_PKG.C_NOT_CREATED;
5307: --g_array_event(l_event_id).array_value_num('encumbrance_je_status') := XLA_AE_JOURNAL_ENTRY_PKG.C_NOT_CREATED;
5308:
5309: --

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

5302: -- initilaize the status of ae headers for diffrent balance types
5303: -- the status is initialised to C_NOT_CREATED (2)
5304: --
5305: --g_array_event(l_event_id).array_value_num('actual_je_status') := XLA_AE_JOURNAL_ENTRY_PKG.C_NOT_CREATED;
5306: --g_array_event(l_event_id).array_value_num('budget_je_status') := XLA_AE_JOURNAL_ENTRY_PKG.C_NOT_CREATED;
5307: --g_array_event(l_event_id).array_value_num('encumbrance_je_status') := XLA_AE_JOURNAL_ENTRY_PKG.C_NOT_CREATED;
5308:
5309: --
5310: -- call api to validate and store accounting attributes for header

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

5303: -- the status is initialised to C_NOT_CREATED (2)
5304: --
5305: --g_array_event(l_event_id).array_value_num('actual_je_status') := XLA_AE_JOURNAL_ENTRY_PKG.C_NOT_CREATED;
5306: --g_array_event(l_event_id).array_value_num('budget_je_status') := XLA_AE_JOURNAL_ENTRY_PKG.C_NOT_CREATED;
5307: --g_array_event(l_event_id).array_value_num('encumbrance_je_status') := XLA_AE_JOURNAL_ENTRY_PKG.C_NOT_CREATED;
5308:
5309: --
5310: -- call api to validate and store accounting attributes for header
5311: --

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

5337: --
5338: l_trx_reversal_source := SUBSTR(NULL, 1,30);
5339:
5340: IF NVL(l_trx_reversal_source, 'N') NOT IN ('N','Y') THEN
5341: xla_ae_journal_entry_pkg.g_global_status := xla_ae_journal_entry_pkg.C_INVALID;
5342:
5343: xla_accounting_err_pkg.build_message
5344: (p_appli_s_name => 'XLA'
5345: ,p_msg_name => 'XLA_AP_INVALID_HDR_ATTR'

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

5345: ,p_msg_name => 'XLA_AP_INVALID_HDR_ATTR'
5346: ,p_token_1 => 'ACCT_ATTR_NAME'
5347: ,p_value_1 => xla_ae_sources_pkg.GetAccountingSourceName('TRX_ACCT_REVERSAL_OPTION')
5348: ,p_token_2 => 'PRODUCT_NAME'
5349: ,p_value_2 => xla_ae_journal_entry_pkg.g_cache_event.application_name
5350: ,p_entity_id => xla_ae_journal_entry_pkg.g_cache_event.entity_id
5351: ,p_event_id => xla_ae_journal_entry_pkg.g_cache_event.event_id
5352: ,p_ledger_id => xla_ae_journal_entry_pkg.g_cache_event.target_ledger_id);
5353:

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

5346: ,p_token_1 => 'ACCT_ATTR_NAME'
5347: ,p_value_1 => xla_ae_sources_pkg.GetAccountingSourceName('TRX_ACCT_REVERSAL_OPTION')
5348: ,p_token_2 => 'PRODUCT_NAME'
5349: ,p_value_2 => xla_ae_journal_entry_pkg.g_cache_event.application_name
5350: ,p_entity_id => xla_ae_journal_entry_pkg.g_cache_event.entity_id
5351: ,p_event_id => xla_ae_journal_entry_pkg.g_cache_event.event_id
5352: ,p_ledger_id => xla_ae_journal_entry_pkg.g_cache_event.target_ledger_id);
5353:
5354: ELSIF NVL(l_trx_reversal_source, 'N') = 'Y' THEN

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

5347: ,p_value_1 => xla_ae_sources_pkg.GetAccountingSourceName('TRX_ACCT_REVERSAL_OPTION')
5348: ,p_token_2 => 'PRODUCT_NAME'
5349: ,p_value_2 => xla_ae_journal_entry_pkg.g_cache_event.application_name
5350: ,p_entity_id => xla_ae_journal_entry_pkg.g_cache_event.entity_id
5351: ,p_event_id => xla_ae_journal_entry_pkg.g_cache_event.event_id
5352: ,p_ledger_id => xla_ae_journal_entry_pkg.g_cache_event.target_ledger_id);
5353:
5354: ELSIF NVL(l_trx_reversal_source, 'N') = 'Y' THEN
5355: --

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

5348: ,p_token_2 => 'PRODUCT_NAME'
5349: ,p_value_2 => xla_ae_journal_entry_pkg.g_cache_event.application_name
5350: ,p_entity_id => xla_ae_journal_entry_pkg.g_cache_event.entity_id
5351: ,p_event_id => xla_ae_journal_entry_pkg.g_cache_event.event_id
5352: ,p_ledger_id => xla_ae_journal_entry_pkg.g_cache_event.target_ledger_id);
5353:
5354: ELSIF NVL(l_trx_reversal_source, 'N') = 'Y' THEN
5355: --
5356: -- following sets the accounting attributes needed to reverse

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

5367: ----------------------------------------------------------------
5368: -- 4262811 - update the header statuses to invalid in need be
5369: ----------------------------------------------------------------
5370: --
5371: XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus (p_hdr_idx => hdr_idx);
5372:
5373:
5374: -----------------------------------------------
5375: -- No accrual reversal for the event class/type

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

5493: ,p_module => l_log_module);
5494: END IF;
5495:
5496: --
5497: -- set the XLA_AE_JOURNAL_ENTRY_PKG.g_global_status to C_VALID (0)
5498: --
5499: XLA_AE_JOURNAL_ENTRY_PKG.g_global_status := XLA_AE_JOURNAL_ENTRY_PKG.C_VALID;
5500: --
5501: -- set event info as cache for other routines to refer event attributes

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

5495:
5496: --
5497: -- set the XLA_AE_JOURNAL_ENTRY_PKG.g_global_status to C_VALID (0)
5498: --
5499: XLA_AE_JOURNAL_ENTRY_PKG.g_global_status := XLA_AE_JOURNAL_ENTRY_PKG.C_VALID;
5500: --
5501: -- set event info as cache for other routines to refer event attributes
5502: --
5503:

Line 5507: XLA_AE_JOURNAL_ENTRY_PKG.set_event_info

5503:
5504: IF l_event_id <> NVL(l_previous_event_id, -1) THEN
5505: l_previous_event_id := l_event_id;
5506:
5507: XLA_AE_JOURNAL_ENTRY_PKG.set_event_info
5508: (p_application_id => p_application_id
5509: ,p_primary_ledger_id => p_primary_ledger_id
5510: ,p_base_ledger_id => p_base_ledger_id
5511: ,p_target_ledger_id => p_target_ledger_id

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

5544: l_acct_reversal_source := SUBSTR(NULL, 1,30);
5545:
5546: IF l_continue_with_lines THEN
5547: IF NVL(l_acct_reversal_source, 'N') NOT IN ('N','Y','B') THEN
5548: xla_ae_journal_entry_pkg.g_global_status := xla_ae_journal_entry_pkg.C_INVALID;
5549:
5550: xla_accounting_err_pkg.build_message
5551: (p_appli_s_name => 'XLA'
5552: ,p_msg_name => 'XLA_AP_INVALID_REVERSAL_OPTION'

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

5552: ,p_msg_name => 'XLA_AP_INVALID_REVERSAL_OPTION'
5553: ,p_token_1 => 'LINE_NUMBER'
5554: ,p_value_1 => l_array_extract_line_num(Idx)
5555: ,p_token_2 => 'PRODUCT_NAME'
5556: ,p_value_2 => xla_ae_journal_entry_pkg.g_cache_event.application_name
5557: ,p_entity_id => xla_ae_journal_entry_pkg.g_cache_event.entity_id
5558: ,p_event_id => xla_ae_journal_entry_pkg.g_cache_event.event_id
5559: ,p_ledger_id => xla_ae_journal_entry_pkg.g_cache_event.target_ledger_id);
5560:

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

5553: ,p_token_1 => 'LINE_NUMBER'
5554: ,p_value_1 => l_array_extract_line_num(Idx)
5555: ,p_token_2 => 'PRODUCT_NAME'
5556: ,p_value_2 => xla_ae_journal_entry_pkg.g_cache_event.application_name
5557: ,p_entity_id => xla_ae_journal_entry_pkg.g_cache_event.entity_id
5558: ,p_event_id => xla_ae_journal_entry_pkg.g_cache_event.event_id
5559: ,p_ledger_id => xla_ae_journal_entry_pkg.g_cache_event.target_ledger_id);
5560:
5561: ELSIF NVL(l_acct_reversal_source, 'N') IN ('Y','B') THEN

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

5554: ,p_value_1 => l_array_extract_line_num(Idx)
5555: ,p_token_2 => 'PRODUCT_NAME'
5556: ,p_value_2 => xla_ae_journal_entry_pkg.g_cache_event.application_name
5557: ,p_entity_id => xla_ae_journal_entry_pkg.g_cache_event.entity_id
5558: ,p_event_id => xla_ae_journal_entry_pkg.g_cache_event.event_id
5559: ,p_ledger_id => xla_ae_journal_entry_pkg.g_cache_event.target_ledger_id);
5560:
5561: ELSIF NVL(l_acct_reversal_source, 'N') IN ('Y','B') THEN
5562: --

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

5555: ,p_token_2 => 'PRODUCT_NAME'
5556: ,p_value_2 => xla_ae_journal_entry_pkg.g_cache_event.application_name
5557: ,p_entity_id => xla_ae_journal_entry_pkg.g_cache_event.entity_id
5558: ,p_event_id => xla_ae_journal_entry_pkg.g_cache_event.event_id
5559: ,p_ledger_id => xla_ae_journal_entry_pkg.g_cache_event.target_ledger_id);
5560:
5561: ELSIF NVL(l_acct_reversal_source, 'N') IN ('Y','B') THEN
5562: --
5563: -- following sets the accounting attributes needed to reverse

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

5648:
5649: -- only execute it if calculate g/l flag is yes, and primary or secondary ledger
5650: -- or secondary ledger that has different currency with primary
5651: -- or alc that is calculated by sla
5652: IF (((l_calculate_g_l_flag = 'Y' AND XLA_AE_JOURNAL_ENTRY_PKG.g_cache_ledgers_info.ledger_category_code <> 'ALC') or
5653: (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'))
5654:
5655: -- IF((l_calculate_g_l_flag='Y' or XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.target_ledger_id <>
5656: -- XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.ledger_id)

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

5649: -- only execute it if calculate g/l flag is yes, and primary or secondary ledger
5650: -- or secondary ledger that has different currency with primary
5651: -- or alc that is calculated by sla
5652: IF (((l_calculate_g_l_flag = 'Y' AND XLA_AE_JOURNAL_ENTRY_PKG.g_cache_ledgers_info.ledger_category_code <> 'ALC') or
5653: (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'))
5654:
5655: -- IF((l_calculate_g_l_flag='Y' or XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.target_ledger_id <>
5656: -- XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.ledger_id)
5657: AND (l_actual_flag = 'A')) THEN

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

5651: -- or alc that is calculated by sla
5652: IF (((l_calculate_g_l_flag = 'Y' AND XLA_AE_JOURNAL_ENTRY_PKG.g_cache_ledgers_info.ledger_category_code <> 'ALC') or
5653: (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'))
5654:
5655: -- IF((l_calculate_g_l_flag='Y' or XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.target_ledger_id <>
5656: -- XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.ledger_id)
5657: AND (l_actual_flag = 'A')) THEN
5658: XLA_AE_LINES_PKG.CreateGainOrLossLines(
5659: p_event_id => xla_ae_journal_entry_pkg.g_cache_event.event_id

Line 5656: -- XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.ledger_id)

5652: IF (((l_calculate_g_l_flag = 'Y' AND XLA_AE_JOURNAL_ENTRY_PKG.g_cache_ledgers_info.ledger_category_code <> 'ALC') or
5653: (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'))
5654:
5655: -- IF((l_calculate_g_l_flag='Y' or XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.target_ledger_id <>
5656: -- XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.ledger_id)
5657: AND (l_actual_flag = 'A')) THEN
5658: XLA_AE_LINES_PKG.CreateGainOrLossLines(
5659: p_event_id => xla_ae_journal_entry_pkg.g_cache_event.event_id
5660: ,p_application_id => p_application_id

Line 5659: p_event_id => xla_ae_journal_entry_pkg.g_cache_event.event_id

5655: -- IF((l_calculate_g_l_flag='Y' or XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.target_ledger_id <>
5656: -- XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.ledger_id)
5657: AND (l_actual_flag = 'A')) THEN
5658: XLA_AE_LINES_PKG.CreateGainOrLossLines(
5659: p_event_id => xla_ae_journal_entry_pkg.g_cache_event.event_id
5660: ,p_application_id => p_application_id
5661: ,p_amb_context_code => 'DEFAULT'
5662: ,p_entity_code => xla_ae_journal_entry_pkg.g_cache_event.entity_code
5663: ,p_event_class_code => C_EVENT_CLASS_CODE

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

5658: XLA_AE_LINES_PKG.CreateGainOrLossLines(
5659: p_event_id => xla_ae_journal_entry_pkg.g_cache_event.event_id
5660: ,p_application_id => p_application_id
5661: ,p_amb_context_code => 'DEFAULT'
5662: ,p_entity_code => xla_ae_journal_entry_pkg.g_cache_event.entity_code
5663: ,p_event_class_code => C_EVENT_CLASS_CODE
5664: ,p_event_type_code => C_EVENT_TYPE_CODE
5665:
5666: ,p_gain_ccid => -1

Line 6103: l_array_legal_entity_id XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;

6099:
6100: l_calculate_acctd_flag VARCHAR2(1) :='N';
6101: l_calculate_g_l_flag VARCHAR2(1) :='N';
6102: --
6103: l_array_legal_entity_id XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
6104: l_array_entity_id XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
6105: l_array_entity_code XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L;
6106: l_array_transaction_num XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
6107: l_array_event_id XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;

Line 6104: l_array_entity_id XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;

6100: l_calculate_acctd_flag VARCHAR2(1) :='N';
6101: l_calculate_g_l_flag VARCHAR2(1) :='N';
6102: --
6103: l_array_legal_entity_id XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
6104: l_array_entity_id XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
6105: l_array_entity_code XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L;
6106: l_array_transaction_num XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
6107: l_array_event_id XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
6108: l_array_class_code XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L;

Line 6105: l_array_entity_code XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L;

6101: l_calculate_g_l_flag VARCHAR2(1) :='N';
6102: --
6103: l_array_legal_entity_id XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
6104: l_array_entity_id XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
6105: l_array_entity_code XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L;
6106: l_array_transaction_num XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
6107: l_array_event_id XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
6108: l_array_class_code XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L;
6109: l_array_event_type XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L;

Line 6106: l_array_transaction_num XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;

6102: --
6103: l_array_legal_entity_id XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
6104: l_array_entity_id XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
6105: l_array_entity_code XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L;
6106: l_array_transaction_num XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
6107: l_array_event_id XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
6108: l_array_class_code XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L;
6109: l_array_event_type XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L;
6110: l_array_event_number XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;

Line 6107: l_array_event_id XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;

6103: l_array_legal_entity_id XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
6104: l_array_entity_id XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
6105: l_array_entity_code XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L;
6106: l_array_transaction_num XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
6107: l_array_event_id XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
6108: l_array_class_code XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L;
6109: l_array_event_type XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L;
6110: l_array_event_number XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
6111: l_array_event_date XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;

Line 6108: l_array_class_code XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L;

6104: l_array_entity_id XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
6105: l_array_entity_code XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L;
6106: l_array_transaction_num XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
6107: l_array_event_id XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
6108: l_array_class_code XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L;
6109: l_array_event_type XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L;
6110: l_array_event_number XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
6111: l_array_event_date XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
6112: l_array_transaction_date XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;

Line 6109: l_array_event_type XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L;

6105: l_array_entity_code XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L;
6106: l_array_transaction_num XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
6107: l_array_event_id XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
6108: l_array_class_code XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L;
6109: l_array_event_type XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L;
6110: l_array_event_number XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
6111: l_array_event_date XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
6112: l_array_transaction_date XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
6113: l_array_reference_num_1 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;

Line 6110: l_array_event_number XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;

6106: l_array_transaction_num XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
6107: l_array_event_id XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
6108: l_array_class_code XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L;
6109: l_array_event_type XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L;
6110: l_array_event_number XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
6111: l_array_event_date XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
6112: l_array_transaction_date XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
6113: l_array_reference_num_1 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
6114: l_array_reference_num_2 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;

Line 6111: l_array_event_date XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;

6107: l_array_event_id XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
6108: l_array_class_code XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L;
6109: l_array_event_type XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L;
6110: l_array_event_number XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
6111: l_array_event_date XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
6112: l_array_transaction_date XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
6113: l_array_reference_num_1 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
6114: l_array_reference_num_2 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
6115: l_array_reference_num_3 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;

Line 6112: l_array_transaction_date XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;

6108: l_array_class_code XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L;
6109: l_array_event_type XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L;
6110: l_array_event_number XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
6111: l_array_event_date XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
6112: l_array_transaction_date XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
6113: l_array_reference_num_1 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
6114: l_array_reference_num_2 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
6115: l_array_reference_num_3 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
6116: l_array_reference_num_4 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;

Line 6113: l_array_reference_num_1 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;

6109: l_array_event_type XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L;
6110: l_array_event_number XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
6111: l_array_event_date XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
6112: l_array_transaction_date XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
6113: l_array_reference_num_1 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
6114: l_array_reference_num_2 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
6115: l_array_reference_num_3 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
6116: l_array_reference_num_4 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
6117: l_array_reference_char_1 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;

Line 6114: l_array_reference_num_2 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;

6110: l_array_event_number XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
6111: l_array_event_date XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
6112: l_array_transaction_date XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
6113: l_array_reference_num_1 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
6114: l_array_reference_num_2 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
6115: l_array_reference_num_3 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
6116: l_array_reference_num_4 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
6117: l_array_reference_char_1 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
6118: l_array_reference_char_2 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;

Line 6115: l_array_reference_num_3 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;

6111: l_array_event_date XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
6112: l_array_transaction_date XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
6113: l_array_reference_num_1 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
6114: l_array_reference_num_2 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
6115: l_array_reference_num_3 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
6116: l_array_reference_num_4 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
6117: l_array_reference_char_1 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
6118: l_array_reference_char_2 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
6119: l_array_reference_char_3 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;

Line 6116: l_array_reference_num_4 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;

6112: l_array_transaction_date XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
6113: l_array_reference_num_1 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
6114: l_array_reference_num_2 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
6115: l_array_reference_num_3 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
6116: l_array_reference_num_4 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
6117: l_array_reference_char_1 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
6118: l_array_reference_char_2 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
6119: l_array_reference_char_3 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
6120: l_array_reference_char_4 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;

Line 6117: l_array_reference_char_1 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;

6113: l_array_reference_num_1 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
6114: l_array_reference_num_2 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
6115: l_array_reference_num_3 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
6116: l_array_reference_num_4 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
6117: l_array_reference_char_1 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
6118: l_array_reference_char_2 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
6119: l_array_reference_char_3 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
6120: l_array_reference_char_4 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
6121: l_array_reference_date_1 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;

Line 6118: l_array_reference_char_2 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;

6114: l_array_reference_num_2 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
6115: l_array_reference_num_3 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
6116: l_array_reference_num_4 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
6117: l_array_reference_char_1 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
6118: l_array_reference_char_2 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
6119: l_array_reference_char_3 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
6120: l_array_reference_char_4 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
6121: l_array_reference_date_1 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
6122: l_array_reference_date_2 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;

Line 6119: l_array_reference_char_3 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;

6115: l_array_reference_num_3 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
6116: l_array_reference_num_4 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
6117: l_array_reference_char_1 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
6118: l_array_reference_char_2 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
6119: l_array_reference_char_3 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
6120: l_array_reference_char_4 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
6121: l_array_reference_date_1 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
6122: l_array_reference_date_2 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
6123: l_array_reference_date_3 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;

Line 6120: l_array_reference_char_4 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;

6116: l_array_reference_num_4 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
6117: l_array_reference_char_1 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
6118: l_array_reference_char_2 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
6119: l_array_reference_char_3 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
6120: l_array_reference_char_4 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
6121: l_array_reference_date_1 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
6122: l_array_reference_date_2 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
6123: l_array_reference_date_3 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
6124: l_array_reference_date_4 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;

Line 6121: l_array_reference_date_1 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;

6117: l_array_reference_char_1 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
6118: l_array_reference_char_2 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
6119: l_array_reference_char_3 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
6120: l_array_reference_char_4 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
6121: l_array_reference_date_1 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
6122: l_array_reference_date_2 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
6123: l_array_reference_date_3 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
6124: l_array_reference_date_4 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
6125: l_array_event_created_by XLA_AE_JOURNAL_ENTRY_PKG.t_array_V100L;

Line 6122: l_array_reference_date_2 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;

6118: l_array_reference_char_2 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
6119: l_array_reference_char_3 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
6120: l_array_reference_char_4 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
6121: l_array_reference_date_1 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
6122: l_array_reference_date_2 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
6123: l_array_reference_date_3 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
6124: l_array_reference_date_4 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
6125: l_array_event_created_by XLA_AE_JOURNAL_ENTRY_PKG.t_array_V100L;
6126: l_array_budgetary_control_flag XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L;

Line 6123: l_array_reference_date_3 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;

6119: l_array_reference_char_3 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
6120: l_array_reference_char_4 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
6121: l_array_reference_date_1 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
6122: l_array_reference_date_2 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
6123: l_array_reference_date_3 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
6124: l_array_reference_date_4 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
6125: l_array_event_created_by XLA_AE_JOURNAL_ENTRY_PKG.t_array_V100L;
6126: l_array_budgetary_control_flag XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L;
6127:

Line 6124: l_array_reference_date_4 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;

6120: l_array_reference_char_4 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
6121: l_array_reference_date_1 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
6122: l_array_reference_date_2 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
6123: l_array_reference_date_3 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
6124: l_array_reference_date_4 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
6125: l_array_event_created_by XLA_AE_JOURNAL_ENTRY_PKG.t_array_V100L;
6126: l_array_budgetary_control_flag XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L;
6127:
6128: l_event_id NUMBER;

Line 6125: l_array_event_created_by XLA_AE_JOURNAL_ENTRY_PKG.t_array_V100L;

6121: l_array_reference_date_1 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
6122: l_array_reference_date_2 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
6123: l_array_reference_date_3 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
6124: l_array_reference_date_4 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
6125: l_array_event_created_by XLA_AE_JOURNAL_ENTRY_PKG.t_array_V100L;
6126: l_array_budgetary_control_flag XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L;
6127:
6128: l_event_id NUMBER;
6129: l_previous_event_id NUMBER;

Line 6126: l_array_budgetary_control_flag XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L;

6122: l_array_reference_date_2 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
6123: l_array_reference_date_3 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
6124: l_array_reference_date_4 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
6125: l_array_event_created_by XLA_AE_JOURNAL_ENTRY_PKG.t_array_V100L;
6126: l_array_budgetary_control_flag XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L;
6127:
6128: l_event_id NUMBER;
6129: l_previous_event_id NUMBER;
6130: l_first_event_id NUMBER;

Line 6144: l_array_extract_line_num xla_ae_journal_entry_pkg.t_array_Num;

6140: l_event_class_name VARCHAR2(80) := 'Reprogram Budget Execution Transactions';
6141: l_description VARCHAR2(4000);
6142: l_transaction_reversal NUMBER;
6143: l_ae_header_id NUMBER;
6144: l_array_extract_line_num xla_ae_journal_entry_pkg.t_array_Num;
6145: l_log_module VARCHAR2(240);
6146: --
6147: l_acct_reversal_source VARCHAR2(30);
6148: l_trx_reversal_source VARCHAR2(30);

Line 6398: XLA_AE_JOURNAL_ENTRY_PKG.set_event_info

6394:
6395: --
6396: -- set event info as cache for other routines to refer event attributes
6397: --
6398: XLA_AE_JOURNAL_ENTRY_PKG.set_event_info
6399: (p_application_id => p_application_id
6400: ,p_primary_ledger_id => p_primary_ledger_id
6401: ,p_base_ledger_id => p_base_ledger_id
6402: ,p_target_ledger_id => p_target_ledger_id

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

6427:
6428: --
6429: -- set the status of entry to C_VALID (0)
6430: --
6431: XLA_AE_JOURNAL_ENTRY_PKG.g_global_status := XLA_AE_JOURNAL_ENTRY_PKG.C_VALID;
6432:
6433: --
6434: -- initialize a row for ae header
6435: --

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

6457: --
6458: -- initilaize the status of ae headers for diffrent balance types
6459: -- the status is initialised to C_NOT_CREATED (2)
6460: --
6461: --g_array_event(l_event_id).array_value_num('actual_je_status') := XLA_AE_JOURNAL_ENTRY_PKG.C_NOT_CREATED;
6462: --g_array_event(l_event_id).array_value_num('budget_je_status') := XLA_AE_JOURNAL_ENTRY_PKG.C_NOT_CREATED;
6463: --g_array_event(l_event_id).array_value_num('encumbrance_je_status') := XLA_AE_JOURNAL_ENTRY_PKG.C_NOT_CREATED;
6464:
6465: --

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

6458: -- initilaize the status of ae headers for diffrent balance types
6459: -- the status is initialised to C_NOT_CREATED (2)
6460: --
6461: --g_array_event(l_event_id).array_value_num('actual_je_status') := XLA_AE_JOURNAL_ENTRY_PKG.C_NOT_CREATED;
6462: --g_array_event(l_event_id).array_value_num('budget_je_status') := XLA_AE_JOURNAL_ENTRY_PKG.C_NOT_CREATED;
6463: --g_array_event(l_event_id).array_value_num('encumbrance_je_status') := XLA_AE_JOURNAL_ENTRY_PKG.C_NOT_CREATED;
6464:
6465: --
6466: -- call api to validate and store accounting attributes for header

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

6459: -- the status is initialised to C_NOT_CREATED (2)
6460: --
6461: --g_array_event(l_event_id).array_value_num('actual_je_status') := XLA_AE_JOURNAL_ENTRY_PKG.C_NOT_CREATED;
6462: --g_array_event(l_event_id).array_value_num('budget_je_status') := XLA_AE_JOURNAL_ENTRY_PKG.C_NOT_CREATED;
6463: --g_array_event(l_event_id).array_value_num('encumbrance_je_status') := XLA_AE_JOURNAL_ENTRY_PKG.C_NOT_CREATED;
6464:
6465: --
6466: -- call api to validate and store accounting attributes for header
6467: --

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

6493: --
6494: l_trx_reversal_source := SUBSTR(NULL, 1,30);
6495:
6496: IF NVL(l_trx_reversal_source, 'N') NOT IN ('N','Y') THEN
6497: xla_ae_journal_entry_pkg.g_global_status := xla_ae_journal_entry_pkg.C_INVALID;
6498:
6499: xla_accounting_err_pkg.build_message
6500: (p_appli_s_name => 'XLA'
6501: ,p_msg_name => 'XLA_AP_INVALID_HDR_ATTR'

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

6501: ,p_msg_name => 'XLA_AP_INVALID_HDR_ATTR'
6502: ,p_token_1 => 'ACCT_ATTR_NAME'
6503: ,p_value_1 => xla_ae_sources_pkg.GetAccountingSourceName('TRX_ACCT_REVERSAL_OPTION')
6504: ,p_token_2 => 'PRODUCT_NAME'
6505: ,p_value_2 => xla_ae_journal_entry_pkg.g_cache_event.application_name
6506: ,p_entity_id => xla_ae_journal_entry_pkg.g_cache_event.entity_id
6507: ,p_event_id => xla_ae_journal_entry_pkg.g_cache_event.event_id
6508: ,p_ledger_id => xla_ae_journal_entry_pkg.g_cache_event.target_ledger_id);
6509:

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

6502: ,p_token_1 => 'ACCT_ATTR_NAME'
6503: ,p_value_1 => xla_ae_sources_pkg.GetAccountingSourceName('TRX_ACCT_REVERSAL_OPTION')
6504: ,p_token_2 => 'PRODUCT_NAME'
6505: ,p_value_2 => xla_ae_journal_entry_pkg.g_cache_event.application_name
6506: ,p_entity_id => xla_ae_journal_entry_pkg.g_cache_event.entity_id
6507: ,p_event_id => xla_ae_journal_entry_pkg.g_cache_event.event_id
6508: ,p_ledger_id => xla_ae_journal_entry_pkg.g_cache_event.target_ledger_id);
6509:
6510: ELSIF NVL(l_trx_reversal_source, 'N') = 'Y' THEN

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

6503: ,p_value_1 => xla_ae_sources_pkg.GetAccountingSourceName('TRX_ACCT_REVERSAL_OPTION')
6504: ,p_token_2 => 'PRODUCT_NAME'
6505: ,p_value_2 => xla_ae_journal_entry_pkg.g_cache_event.application_name
6506: ,p_entity_id => xla_ae_journal_entry_pkg.g_cache_event.entity_id
6507: ,p_event_id => xla_ae_journal_entry_pkg.g_cache_event.event_id
6508: ,p_ledger_id => xla_ae_journal_entry_pkg.g_cache_event.target_ledger_id);
6509:
6510: ELSIF NVL(l_trx_reversal_source, 'N') = 'Y' THEN
6511: --

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

6504: ,p_token_2 => 'PRODUCT_NAME'
6505: ,p_value_2 => xla_ae_journal_entry_pkg.g_cache_event.application_name
6506: ,p_entity_id => xla_ae_journal_entry_pkg.g_cache_event.entity_id
6507: ,p_event_id => xla_ae_journal_entry_pkg.g_cache_event.event_id
6508: ,p_ledger_id => xla_ae_journal_entry_pkg.g_cache_event.target_ledger_id);
6509:
6510: ELSIF NVL(l_trx_reversal_source, 'N') = 'Y' THEN
6511: --
6512: -- following sets the accounting attributes needed to reverse

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

6523: ----------------------------------------------------------------
6524: -- 4262811 - update the header statuses to invalid in need be
6525: ----------------------------------------------------------------
6526: --
6527: XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus (p_hdr_idx => hdr_idx);
6528:
6529:
6530: -----------------------------------------------
6531: -- No accrual reversal for the event class/type

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

6649: ,p_module => l_log_module);
6650: END IF;
6651:
6652: --
6653: -- set the XLA_AE_JOURNAL_ENTRY_PKG.g_global_status to C_VALID (0)
6654: --
6655: XLA_AE_JOURNAL_ENTRY_PKG.g_global_status := XLA_AE_JOURNAL_ENTRY_PKG.C_VALID;
6656: --
6657: -- set event info as cache for other routines to refer event attributes

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

6651:
6652: --
6653: -- set the XLA_AE_JOURNAL_ENTRY_PKG.g_global_status to C_VALID (0)
6654: --
6655: XLA_AE_JOURNAL_ENTRY_PKG.g_global_status := XLA_AE_JOURNAL_ENTRY_PKG.C_VALID;
6656: --
6657: -- set event info as cache for other routines to refer event attributes
6658: --
6659:

Line 6663: XLA_AE_JOURNAL_ENTRY_PKG.set_event_info

6659:
6660: IF l_event_id <> NVL(l_previous_event_id, -1) THEN
6661: l_previous_event_id := l_event_id;
6662:
6663: XLA_AE_JOURNAL_ENTRY_PKG.set_event_info
6664: (p_application_id => p_application_id
6665: ,p_primary_ledger_id => p_primary_ledger_id
6666: ,p_base_ledger_id => p_base_ledger_id
6667: ,p_target_ledger_id => p_target_ledger_id

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

6700: l_acct_reversal_source := SUBSTR(NULL, 1,30);
6701:
6702: IF l_continue_with_lines THEN
6703: IF NVL(l_acct_reversal_source, 'N') NOT IN ('N','Y','B') THEN
6704: xla_ae_journal_entry_pkg.g_global_status := xla_ae_journal_entry_pkg.C_INVALID;
6705:
6706: xla_accounting_err_pkg.build_message
6707: (p_appli_s_name => 'XLA'
6708: ,p_msg_name => 'XLA_AP_INVALID_REVERSAL_OPTION'

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

6708: ,p_msg_name => 'XLA_AP_INVALID_REVERSAL_OPTION'
6709: ,p_token_1 => 'LINE_NUMBER'
6710: ,p_value_1 => l_array_extract_line_num(Idx)
6711: ,p_token_2 => 'PRODUCT_NAME'
6712: ,p_value_2 => xla_ae_journal_entry_pkg.g_cache_event.application_name
6713: ,p_entity_id => xla_ae_journal_entry_pkg.g_cache_event.entity_id
6714: ,p_event_id => xla_ae_journal_entry_pkg.g_cache_event.event_id
6715: ,p_ledger_id => xla_ae_journal_entry_pkg.g_cache_event.target_ledger_id);
6716:

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

6709: ,p_token_1 => 'LINE_NUMBER'
6710: ,p_value_1 => l_array_extract_line_num(Idx)
6711: ,p_token_2 => 'PRODUCT_NAME'
6712: ,p_value_2 => xla_ae_journal_entry_pkg.g_cache_event.application_name
6713: ,p_entity_id => xla_ae_journal_entry_pkg.g_cache_event.entity_id
6714: ,p_event_id => xla_ae_journal_entry_pkg.g_cache_event.event_id
6715: ,p_ledger_id => xla_ae_journal_entry_pkg.g_cache_event.target_ledger_id);
6716:
6717: ELSIF NVL(l_acct_reversal_source, 'N') IN ('Y','B') THEN

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

6710: ,p_value_1 => l_array_extract_line_num(Idx)
6711: ,p_token_2 => 'PRODUCT_NAME'
6712: ,p_value_2 => xla_ae_journal_entry_pkg.g_cache_event.application_name
6713: ,p_entity_id => xla_ae_journal_entry_pkg.g_cache_event.entity_id
6714: ,p_event_id => xla_ae_journal_entry_pkg.g_cache_event.event_id
6715: ,p_ledger_id => xla_ae_journal_entry_pkg.g_cache_event.target_ledger_id);
6716:
6717: ELSIF NVL(l_acct_reversal_source, 'N') IN ('Y','B') THEN
6718: --

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

6711: ,p_token_2 => 'PRODUCT_NAME'
6712: ,p_value_2 => xla_ae_journal_entry_pkg.g_cache_event.application_name
6713: ,p_entity_id => xla_ae_journal_entry_pkg.g_cache_event.entity_id
6714: ,p_event_id => xla_ae_journal_entry_pkg.g_cache_event.event_id
6715: ,p_ledger_id => xla_ae_journal_entry_pkg.g_cache_event.target_ledger_id);
6716:
6717: ELSIF NVL(l_acct_reversal_source, 'N') IN ('Y','B') THEN
6718: --
6719: -- following sets the accounting attributes needed to reverse

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

6854:
6855: -- only execute it if calculate g/l flag is yes, and primary or secondary ledger
6856: -- or secondary ledger that has different currency with primary
6857: -- or alc that is calculated by sla
6858: IF (((l_calculate_g_l_flag = 'Y' AND XLA_AE_JOURNAL_ENTRY_PKG.g_cache_ledgers_info.ledger_category_code <> 'ALC') or
6859: (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'))
6860:
6861: -- IF((l_calculate_g_l_flag='Y' or XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.target_ledger_id <>
6862: -- XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.ledger_id)

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

6855: -- only execute it if calculate g/l flag is yes, and primary or secondary ledger
6856: -- or secondary ledger that has different currency with primary
6857: -- or alc that is calculated by sla
6858: IF (((l_calculate_g_l_flag = 'Y' AND XLA_AE_JOURNAL_ENTRY_PKG.g_cache_ledgers_info.ledger_category_code <> 'ALC') or
6859: (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'))
6860:
6861: -- IF((l_calculate_g_l_flag='Y' or XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.target_ledger_id <>
6862: -- XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.ledger_id)
6863: AND (l_actual_flag = 'A')) THEN

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

6857: -- or alc that is calculated by sla
6858: IF (((l_calculate_g_l_flag = 'Y' AND XLA_AE_JOURNAL_ENTRY_PKG.g_cache_ledgers_info.ledger_category_code <> 'ALC') or
6859: (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'))
6860:
6861: -- IF((l_calculate_g_l_flag='Y' or XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.target_ledger_id <>
6862: -- XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.ledger_id)
6863: AND (l_actual_flag = 'A')) THEN
6864: XLA_AE_LINES_PKG.CreateGainOrLossLines(
6865: p_event_id => xla_ae_journal_entry_pkg.g_cache_event.event_id

Line 6862: -- XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.ledger_id)

6858: IF (((l_calculate_g_l_flag = 'Y' AND XLA_AE_JOURNAL_ENTRY_PKG.g_cache_ledgers_info.ledger_category_code <> 'ALC') or
6859: (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'))
6860:
6861: -- IF((l_calculate_g_l_flag='Y' or XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.target_ledger_id <>
6862: -- XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.ledger_id)
6863: AND (l_actual_flag = 'A')) THEN
6864: XLA_AE_LINES_PKG.CreateGainOrLossLines(
6865: p_event_id => xla_ae_journal_entry_pkg.g_cache_event.event_id
6866: ,p_application_id => p_application_id

Line 6865: p_event_id => xla_ae_journal_entry_pkg.g_cache_event.event_id

6861: -- IF((l_calculate_g_l_flag='Y' or XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.target_ledger_id <>
6862: -- XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.ledger_id)
6863: AND (l_actual_flag = 'A')) THEN
6864: XLA_AE_LINES_PKG.CreateGainOrLossLines(
6865: p_event_id => xla_ae_journal_entry_pkg.g_cache_event.event_id
6866: ,p_application_id => p_application_id
6867: ,p_amb_context_code => 'DEFAULT'
6868: ,p_entity_code => xla_ae_journal_entry_pkg.g_cache_event.entity_code
6869: ,p_event_class_code => C_EVENT_CLASS_CODE

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

6864: XLA_AE_LINES_PKG.CreateGainOrLossLines(
6865: p_event_id => xla_ae_journal_entry_pkg.g_cache_event.event_id
6866: ,p_application_id => p_application_id
6867: ,p_amb_context_code => 'DEFAULT'
6868: ,p_entity_code => xla_ae_journal_entry_pkg.g_cache_event.entity_code
6869: ,p_event_class_code => C_EVENT_CLASS_CODE
6870: ,p_event_type_code => C_EVENT_TYPE_CODE
6871:
6872: ,p_gain_ccid => -1

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

6986: ,p_level => C_LEVEL_PROCEDURE
6987: ,p_module => l_log_module);
6988: END IF;
6989:
6990: l_language := xla_ae_journal_entry_pkg.g_cache_ledgers_info.description_language;
6991: l_currency_code := xla_ae_journal_entry_pkg.g_cache_ledgers_info.currency_code;
6992: l_sla_ledger_id := xla_ae_journal_entry_pkg.g_cache_ledgers_info.sla_ledger_id;
6993:
6994: --

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

6987: ,p_module => l_log_module);
6988: END IF;
6989:
6990: l_language := xla_ae_journal_entry_pkg.g_cache_ledgers_info.description_language;
6991: l_currency_code := xla_ae_journal_entry_pkg.g_cache_ledgers_info.currency_code;
6992: l_sla_ledger_id := xla_ae_journal_entry_pkg.g_cache_ledgers_info.sla_ledger_id;
6993:
6994: --
6995: -- initialize array of lines with NULL

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

6988: END IF;
6989:
6990: l_language := xla_ae_journal_entry_pkg.g_cache_ledgers_info.description_language;
6991: l_currency_code := xla_ae_journal_entry_pkg.g_cache_ledgers_info.currency_code;
6992: l_sla_ledger_id := xla_ae_journal_entry_pkg.g_cache_ledgers_info.sla_ledger_id;
6993:
6994: --
6995: -- initialize array of lines with NULL
6996: --

Line 7188: xla_ae_journal_entry_pkg.SetProductAcctDefinition

7184: ,p_level => C_LEVEL_STATEMENT
7185: ,p_module => l_log_module);
7186: END IF;
7187: --
7188: xla_ae_journal_entry_pkg.SetProductAcctDefinition
7189: (p_product_rule_code => 'FV_STANDARD_AAD'
7190: ,p_product_rule_type_code => 'S'
7191: ,p_product_rule_version => ''
7192: ,p_product_rule_name => 'Federal Financials AAD'

Line 7197: xla_ae_journal_entry_pkg.GetAlternateCurrencyLedger

7193: ,p_amb_context_code => 'DEFAULT'
7194: );
7195:
7196: l_array_ledgers :=
7197: xla_ae_journal_entry_pkg.GetAlternateCurrencyLedger
7198: (p_base_ledger_id => p_base_ledger_id);
7199:
7200: FOR Idx IN 1 .. l_array_ledgers.COUNT LOOP
7201: l_temp_result :=

Line 7202: XLA_AE_JOURNAL_ENTRY_PKG.GetLedgersInfo

7198: (p_base_ledger_id => p_base_ledger_id);
7199:
7200: FOR Idx IN 1 .. l_array_ledgers.COUNT LOOP
7201: l_temp_result :=
7202: XLA_AE_JOURNAL_ENTRY_PKG.GetLedgersInfo
7203: (p_application_id => p_application_id
7204: ,p_base_ledger_id => p_base_ledger_id
7205: ,p_target_ledger_id => l_array_ledgers(Idx)
7206: ,p_primary_ledger_id => p_primary_ledger_id