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_AE_CODE_COMBINATION_PKG dependencies on XLA_AE_JOURNAL_ENTRY_PKG

Line 191: g_array_cache_target_coa xla_ae_journal_entry_pkg.t_array_Num;

187: --g_error_exists BOOLEAN;
188: g_array_combination_id t_array_combination_id;
189: g_array_key_flexfield t_array_key_flexfiled;
190: g_array_appl_short_name t_array_appl_short_name;
191: g_array_cache_target_coa xla_ae_journal_entry_pkg.t_array_Num;
192: g_cache_coa_sla_mapping xla_ae_journal_entry_pkg.t_array_V33L;
193: g_cache_dynamic_inserts xla_ae_journal_entry_pkg.t_array_V1L;
194:
195: --

Line 192: g_cache_coa_sla_mapping xla_ae_journal_entry_pkg.t_array_V33L;

188: g_array_combination_id t_array_combination_id;
189: g_array_key_flexfield t_array_key_flexfiled;
190: g_array_appl_short_name t_array_appl_short_name;
191: g_array_cache_target_coa xla_ae_journal_entry_pkg.t_array_Num;
192: g_cache_coa_sla_mapping xla_ae_journal_entry_pkg.t_array_V33L;
193: g_cache_dynamic_inserts xla_ae_journal_entry_pkg.t_array_V1L;
194:
195: --
196: --=============================================================================

Line 193: g_cache_dynamic_inserts xla_ae_journal_entry_pkg.t_array_V1L;

189: g_array_key_flexfield t_array_key_flexfiled;
190: g_array_appl_short_name t_array_appl_short_name;
191: g_array_cache_target_coa xla_ae_journal_entry_pkg.t_array_Num;
192: g_cache_coa_sla_mapping xla_ae_journal_entry_pkg.t_array_V33L;
193: g_cache_dynamic_inserts xla_ae_journal_entry_pkg.t_array_V1L;
194:
195: --
196: --=============================================================================
197: -- *********** Local Trace Routine **********

Line 628: l_null_coa_sla_mapping xla_ae_journal_entry_pkg.t_array_V33L;

624: +---------------------------------------------------------------*/
625:
626: PROCEDURE refreshGLMappingCache
627: IS
628: l_null_coa_sla_mapping xla_ae_journal_entry_pkg.t_array_V33L;
629: l_null_dynamic_inserts xla_ae_journal_entry_pkg.t_array_V1L;
630: BEGIN
631:
632: g_cache_coa_sla_mapping := l_null_coa_sla_mapping;

Line 629: l_null_dynamic_inserts xla_ae_journal_entry_pkg.t_array_V1L;

625:
626: PROCEDURE refreshGLMappingCache
627: IS
628: l_null_coa_sla_mapping xla_ae_journal_entry_pkg.t_array_V33L;
629: l_null_dynamic_inserts xla_ae_journal_entry_pkg.t_array_V1L;
630: BEGIN
631:
632: g_cache_coa_sla_mapping := l_null_coa_sla_mapping;
633: g_cache_dynamic_inserts := l_null_dynamic_inserts;

Line 661: (p_location => 'xla_ae_journal_entry_pkg.refreshCcidCache');

657: WHEN xla_exceptions_pkg.application_exception THEN
658: RAISE;
659: WHEN OTHERS THEN
660: xla_exceptions_pkg.raise_message
661: (p_location => 'xla_ae_journal_entry_pkg.refreshCcidCache');
662: END refreshCcidCache;
663:
664: /*------------------------------------------------------------------+
665: | |

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

1542: EXCEPTION
1543:
1544: WHEN invalid_key_combination_id THEN
1545:
1546: xla_ae_journal_entry_pkg.g_global_status := xla_ae_journal_entry_pkg.C_INVALID;
1547: g_array_combination_id(l_position).combination_id := p_combination_id ;
1548: g_array_combination_id(l_position).id_flex_num := nvl(p_id_flex_num,l_id_flex_num);
1549: g_array_combination_id(l_position).flexfield_application_id := p_flex_application_id ;
1550: g_array_combination_id(l_position).id_flex_code := p_id_flex_code ;

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

1567: ,p_token_1 => 'ACCOUNT_VALUE'
1568: ,p_value_1 => l_ConcatKey
1569: ,p_token_2 => 'MESSAGE'
1570: ,p_value_2 => l_message
1571: ,p_entity_id => xla_ae_journal_entry_pkg.g_cache_event.entity_id
1572: ,p_event_id => xla_ae_journal_entry_pkg.g_cache_event.event_id
1573: ,p_ledger_id => xla_ae_journal_entry_pkg.g_cache_event.target_ledger_id);
1574:
1575: IF (C_LEVEL_ERROR >= g_log_level) THEN

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

1568: ,p_value_1 => l_ConcatKey
1569: ,p_token_2 => 'MESSAGE'
1570: ,p_value_2 => l_message
1571: ,p_entity_id => xla_ae_journal_entry_pkg.g_cache_event.entity_id
1572: ,p_event_id => xla_ae_journal_entry_pkg.g_cache_event.event_id
1573: ,p_ledger_id => xla_ae_journal_entry_pkg.g_cache_event.target_ledger_id);
1574:
1575: IF (C_LEVEL_ERROR >= g_log_level) THEN
1576: trace

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

1569: ,p_token_2 => 'MESSAGE'
1570: ,p_value_2 => l_message
1571: ,p_entity_id => xla_ae_journal_entry_pkg.g_cache_event.entity_id
1572: ,p_event_id => xla_ae_journal_entry_pkg.g_cache_event.event_id
1573: ,p_ledger_id => xla_ae_journal_entry_pkg.g_cache_event.target_ledger_id);
1574:
1575: IF (C_LEVEL_ERROR >= g_log_level) THEN
1576: trace
1577: (p_msg => 'ERROR: XLA_AP_INVALID_AOL_CCID'

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

1821: END IF;
1822: RETURN l_segment_code;
1823: EXCEPTION
1824: WHEN invalid_segment_qualifier THEN
1825: xla_ae_journal_entry_pkg.g_global_status:= xla_ae_journal_entry_pkg.C_INVALID;
1826:
1827: /*
1828: l_segment_name := xla_lookups_pkg.get_meaning(
1829: 'XLA_FLEXFIELD_SEGMENTS_QUAL'

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

1874: ,p_token_5 => 'COMPONENT_NAME'
1875: ,p_value_5 => l_name
1876: ,p_token_6 => 'OWNER'
1877: ,p_value_6 => l_owner
1878: ,p_entity_id => xla_ae_journal_entry_pkg.g_cache_event.entity_id
1879: ,p_event_id => xla_ae_journal_entry_pkg.g_cache_event.event_id
1880: ,p_ledger_id => xla_ae_journal_entry_pkg.g_cache_event.target_ledger_id
1881: ,p_ae_header_id => NULL
1882: );

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

1875: ,p_value_5 => l_name
1876: ,p_token_6 => 'OWNER'
1877: ,p_value_6 => l_owner
1878: ,p_entity_id => xla_ae_journal_entry_pkg.g_cache_event.entity_id
1879: ,p_event_id => xla_ae_journal_entry_pkg.g_cache_event.event_id
1880: ,p_ledger_id => xla_ae_journal_entry_pkg.g_cache_event.target_ledger_id
1881: ,p_ae_header_id => NULL
1882: );
1883: IF (C_LEVEL_ERROR >= g_log_level) THEN

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

1876: ,p_token_6 => 'OWNER'
1877: ,p_value_6 => l_owner
1878: ,p_entity_id => xla_ae_journal_entry_pkg.g_cache_event.entity_id
1879: ,p_event_id => xla_ae_journal_entry_pkg.g_cache_event.event_id
1880: ,p_ledger_id => xla_ae_journal_entry_pkg.g_cache_event.target_ledger_id
1881: ,p_ae_header_id => NULL
1882: );
1883: IF (C_LEVEL_ERROR >= g_log_level) THEN
1884: trace

Line 1962: l_id_flex_num := xla_ae_journal_entry_pkg.g_cache_ledgers_info.source_coa_id;

1958:
1959: END IF;
1960:
1961: IF p_flex_application_id = 101 and p_id_flex_code ='GL#' THEN
1962: l_id_flex_num := xla_ae_journal_entry_pkg.g_cache_ledgers_info.source_coa_id;
1963: ELSE
1964: l_id_flex_num := NULL;
1965: END IF;
1966:

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

2094: END IF;
2095: RETURN l_segment_value;
2096: EXCEPTION
2097: WHEN invalid_segment THEN
2098: xla_ae_journal_entry_pkg.g_global_status := xla_ae_journal_entry_pkg.C_INVALID;
2099:
2100: l_key_flexfield_name := get_flex_structure_name(
2101: p_flex_application_id,
2102: p_id_flex_code,

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

2136: ,p_token_5 => 'COMPONENT_NAME'
2137: ,p_value_5 => l_name
2138: ,p_token_6 => 'OWNER'
2139: ,p_value_6 => l_owner
2140: ,p_entity_id => xla_ae_journal_entry_pkg.g_cache_event.entity_id
2141: ,p_event_id => xla_ae_journal_entry_pkg.g_cache_event.event_id
2142: ,p_ledger_id => xla_ae_journal_entry_pkg.g_cache_event.target_ledger_id
2143: ,p_ae_header_id => NULL
2144: );

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

2137: ,p_value_5 => l_name
2138: ,p_token_6 => 'OWNER'
2139: ,p_value_6 => l_owner
2140: ,p_entity_id => xla_ae_journal_entry_pkg.g_cache_event.entity_id
2141: ,p_event_id => xla_ae_journal_entry_pkg.g_cache_event.event_id
2142: ,p_ledger_id => xla_ae_journal_entry_pkg.g_cache_event.target_ledger_id
2143: ,p_ae_header_id => NULL
2144: );
2145:

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

2138: ,p_token_6 => 'OWNER'
2139: ,p_value_6 => l_owner
2140: ,p_entity_id => xla_ae_journal_entry_pkg.g_cache_event.entity_id
2141: ,p_event_id => xla_ae_journal_entry_pkg.g_cache_event.event_id
2142: ,p_ledger_id => xla_ae_journal_entry_pkg.g_cache_event.target_ledger_id
2143: ,p_ae_header_id => NULL
2144: );
2145:
2146: IF (C_LEVEL_ERROR >= g_log_level) THEN

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

2151:
2152: END IF;
2153: RETURN NULL;
2154: WHEN null_key_combination_id THEN
2155: xla_ae_journal_entry_pkg.g_global_status := xla_ae_journal_entry_pkg.C_INVALID;
2156:
2157: l_type := xla_lookups_pkg.get_meaning(
2158: 'XLA_AMB_COMPONENT_TYPE'
2159: , p_component_type

Line 2197: ,p_value_5 => xla_ae_journal_entry_pkg.g_cache_event.application_name

2193: ,p_value_3 => l_name
2194: ,p_token_4 => 'OWNER'
2195: ,p_value_4 => l_owner
2196: ,p_token_5 => 'PRODUCT_NAME'
2197: ,p_value_5 => 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 --p_ae_header_id

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

2194: ,p_token_4 => 'OWNER'
2195: ,p_value_4 => l_owner
2196: ,p_token_5 => 'PRODUCT_NAME'
2197: ,p_value_5 => 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 --p_ae_header_id
2202: );

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

2195: ,p_value_4 => l_owner
2196: ,p_token_5 => 'PRODUCT_NAME'
2197: ,p_value_5 => 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 --p_ae_header_id
2202: );
2203:

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

2196: ,p_token_5 => 'PRODUCT_NAME'
2197: ,p_value_5 => 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 --p_ae_header_id
2202: );
2203:
2204: IF (C_LEVEL_ERROR >= g_log_level) THEN

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

2208: ,p_module => l_log_module);
2209: END IF;
2210: RETURN NULL;
2211: WHEN invalid_key_combination_id THEN
2212: xla_ae_journal_entry_pkg.g_global_status := xla_ae_journal_entry_pkg.C_INVALID;
2213: l_type := xla_lookups_pkg.get_meaning(
2214: 'XLA_AMB_COMPONENT_TYPE'
2215: , p_component_type
2216: );

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

2257: ,p_token_4 => 'COMPONENT_NAME'
2258: ,p_value_4 => l_name
2259: ,p_token_5 => 'OWNER'
2260: ,p_value_5 => l_owner
2261: ,p_entity_id => xla_ae_journal_entry_pkg.g_cache_event.entity_id
2262: ,p_event_id => xla_ae_journal_entry_pkg.g_cache_event.event_id
2263: ,p_ledger_id => xla_ae_journal_entry_pkg.g_cache_event.target_ledger_id
2264: ,p_ae_header_id => NULL --p_ae_header_id
2265: );

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

2258: ,p_value_4 => l_name
2259: ,p_token_5 => 'OWNER'
2260: ,p_value_5 => l_owner
2261: ,p_entity_id => xla_ae_journal_entry_pkg.g_cache_event.entity_id
2262: ,p_event_id => xla_ae_journal_entry_pkg.g_cache_event.event_id
2263: ,p_ledger_id => xla_ae_journal_entry_pkg.g_cache_event.target_ledger_id
2264: ,p_ae_header_id => NULL --p_ae_header_id
2265: );
2266:

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

2259: ,p_token_5 => 'OWNER'
2260: ,p_value_5 => l_owner
2261: ,p_entity_id => xla_ae_journal_entry_pkg.g_cache_event.entity_id
2262: ,p_event_id => xla_ae_journal_entry_pkg.g_cache_event.event_id
2263: ,p_ledger_id => xla_ae_journal_entry_pkg.g_cache_event.target_ledger_id
2264: ,p_ae_header_id => NULL --p_ae_header_id
2265: );
2266:
2267: IF (C_LEVEL_ERROR >= g_log_level) THEN

Line 2335: l_id_flex_num := xla_ae_journal_entry_pkg.g_cache_ledgers_info.source_coa_id;

2331: END IF;
2332:
2333: l_segment_description:= NULL;
2334: IF p_flex_application_id = 101 and p_id_flex_code ='GL#' THEN
2335: l_id_flex_num := xla_ae_journal_entry_pkg.g_cache_ledgers_info.source_coa_id;
2336: ELSE
2337: l_id_flex_num := NULL;
2338: END IF;
2339: l_desc_language := xla_ae_journal_entry_pkg.g_cache_ledgers_info.description_language;

Line 2339: l_desc_language := xla_ae_journal_entry_pkg.g_cache_ledgers_info.description_language;

2335: l_id_flex_num := xla_ae_journal_entry_pkg.g_cache_ledgers_info.source_coa_id;
2336: ELSE
2337: l_id_flex_num := NULL;
2338: END IF;
2339: l_desc_language := xla_ae_journal_entry_pkg.g_cache_ledgers_info.description_language;
2340:
2341: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
2342: trace
2343: (p_msg => 'p_flex_application_id = '||p_flex_application_id

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

2593: AND hdr.ledger_id IS NOT NULL
2594: )
2595: LOOP
2596:
2597: xla_ae_journal_entry_pkg.g_global_status := xla_ae_journal_entry_pkg.C_INVALID;
2598: xla_accounting_err_pkg.build_message
2599: (p_appli_s_name => p_appli_s_name
2600: ,p_msg_name => p_msg_name
2601: ,p_token_1 => p_token_1

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

3054: combination_id => l_Ccid) = FALSE
3055: THEN
3056:
3057: g_error_exists := TRUE;
3058: xla_ae_journal_entry_pkg.g_global_status := xla_ae_journal_entry_pkg.C_INVALID;
3059:
3060: IF (C_LEVEL_PROCEDURE >= g_log_level) THEN
3061:
3062: trace

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

3216:
3217: --logging the errors
3218: IF ( l_count> 0 ) THEN
3219:
3220: xla_ae_journal_entry_pkg.g_global_status := xla_ae_journal_entry_pkg.C_INVALID;
3221:
3222: FOR error_rec IN (
3223: SELECT event_id
3224: ,entity_id

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

3262: AND hdr.ledger_id IS NOT NULL
3263: )
3264: )
3265: LOOP
3266: xla_ae_journal_entry_pkg.g_global_status := xla_ae_journal_entry_pkg.C_INVALID;
3267: xla_accounting_err_pkg.build_message
3268: (p_appli_s_name => 'XLA'
3269: ,p_msg_name => 'XLA_AP_CCID_NOT_EXISTS'
3270: ,p_token_1 => 'CODE_COMBINATION_ID'

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

4963: WHERE code_combination_id = error_rec.from_ccid;
4964: */ --commented per bug 8687228
4965:
4966:
4967: xla_ae_journal_entry_pkg.g_global_status := xla_ae_journal_entry_pkg.C_INVALID;
4968: l_message := SUBSTR(error_rec.error_code,1,1000);
4969: xla_accounting_err_pkg.build_message
4970: (p_appli_s_name => 'XLA'
4971: ,p_msg_name => 'XLA_AP_GL_INVALID_COA_MAPPING'

Line 5061: l_array_event_id xla_ae_journal_entry_pkg.t_array_Num;

5057: l_count NUMBER;
5058: l_rowcount NUMBER;
5059: l_error BOOLEAN;
5060: l_gl_error_code VARCHAR2(1000);
5061: l_array_event_id xla_ae_journal_entry_pkg.t_array_Num;
5062: l_array_entity_id xla_ae_journal_entry_pkg.t_array_Num;
5063: l_array_ledger_id xla_ae_journal_entry_pkg.t_array_Num;
5064: l_log_module VARCHAR2(240);
5065: BEGIN

Line 5062: l_array_entity_id xla_ae_journal_entry_pkg.t_array_Num;

5058: l_rowcount NUMBER;
5059: l_error BOOLEAN;
5060: l_gl_error_code VARCHAR2(1000);
5061: l_array_event_id xla_ae_journal_entry_pkg.t_array_Num;
5062: l_array_entity_id xla_ae_journal_entry_pkg.t_array_Num;
5063: l_array_ledger_id xla_ae_journal_entry_pkg.t_array_Num;
5064: l_log_module VARCHAR2(240);
5065: BEGIN
5066: IF g_log_enabled THEN

Line 5063: l_array_ledger_id xla_ae_journal_entry_pkg.t_array_Num;

5059: l_error BOOLEAN;
5060: l_gl_error_code VARCHAR2(1000);
5061: l_array_event_id xla_ae_journal_entry_pkg.t_array_Num;
5062: l_array_entity_id xla_ae_journal_entry_pkg.t_array_Num;
5063: l_array_ledger_id xla_ae_journal_entry_pkg.t_array_Num;
5064: l_log_module VARCHAR2(240);
5065: BEGIN
5066: IF g_log_enabled THEN
5067: l_log_module := C_DEFAULT_MODULE||'.map_segment_qualifier';

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

5185:
5186: FOR Idx IN l_array_event_id.FIRST .. l_array_event_id.LAST LOOP
5187:
5188: IF l_array_event_id.EXISTS(Idx) THEN
5189: xla_ae_journal_entry_pkg.g_global_status := xla_ae_journal_entry_pkg.C_INVALID;
5190: xla_accounting_err_pkg.build_message
5191: (p_appli_s_name => 'XLA'
5192: ,p_msg_name => 'XLA_AP_GL_INV_QUAL_MAPPING'
5193: ,p_token_1 => 'GL_COA_MAPPING_NAME'

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

5242:
5243: FOR Idx IN l_array_event_id.FIRST .. l_array_event_id.LAST LOOP
5244:
5245: IF l_array_event_id.EXISTS(Idx) THEN
5246: xla_ae_journal_entry_pkg.g_global_status := xla_ae_journal_entry_pkg.C_INVALID;
5247: xla_accounting_err_pkg.build_message
5248: (p_appli_s_name => 'XLA'
5249: ,p_msg_name => 'XLA_AP_GL_INV_QUAL_MAPPING'
5250: ,p_token_1 => 'GL_COA_MAPPING_NAME'

Line 5619: l_array_je_ids xla_ae_journal_entry_pkg.t_array_Num;

5615: IS
5616: --
5617: --
5618: l_ccid_created NUMBER;
5619: l_array_je_ids xla_ae_journal_entry_pkg.t_array_Num;
5620: l_array_event_ids xla_ae_journal_entry_pkg.t_array_Num;
5621: l_array_event_status xla_ae_journal_entry_pkg.t_array_V1L;
5622: l_cache_array_target_coa xla_ae_journal_entry_pkg.t_array_Num;
5623: l_log_module VARCHAR2(240);

Line 5620: l_array_event_ids xla_ae_journal_entry_pkg.t_array_Num;

5616: --
5617: --
5618: l_ccid_created NUMBER;
5619: l_array_je_ids xla_ae_journal_entry_pkg.t_array_Num;
5620: l_array_event_ids xla_ae_journal_entry_pkg.t_array_Num;
5621: l_array_event_status xla_ae_journal_entry_pkg.t_array_V1L;
5622: l_cache_array_target_coa xla_ae_journal_entry_pkg.t_array_Num;
5623: l_log_module VARCHAR2(240);
5624: --

Line 5621: l_array_event_status xla_ae_journal_entry_pkg.t_array_V1L;

5617: --
5618: l_ccid_created NUMBER;
5619: l_array_je_ids xla_ae_journal_entry_pkg.t_array_Num;
5620: l_array_event_ids xla_ae_journal_entry_pkg.t_array_Num;
5621: l_array_event_status xla_ae_journal_entry_pkg.t_array_V1L;
5622: l_cache_array_target_coa xla_ae_journal_entry_pkg.t_array_Num;
5623: l_log_module VARCHAR2(240);
5624: --
5625: BEGIN

Line 5622: l_cache_array_target_coa xla_ae_journal_entry_pkg.t_array_Num;

5618: l_ccid_created NUMBER;
5619: l_array_je_ids xla_ae_journal_entry_pkg.t_array_Num;
5620: l_array_event_ids xla_ae_journal_entry_pkg.t_array_Num;
5621: l_array_event_status xla_ae_journal_entry_pkg.t_array_V1L;
5622: l_cache_array_target_coa xla_ae_journal_entry_pkg.t_array_Num;
5623: l_log_module VARCHAR2(240);
5624: --
5625: BEGIN
5626: --

Line 5652: SET xahg.accounting_entry_status_code = xla_ae_journal_entry_pkg.C_INVALID

5648: -- commented bug 13023651
5649: /*IF l_ccid_created > 0 THEN
5650:
5651: UPDATE xla_ae_headers_gt xahg
5652: SET xahg.accounting_entry_status_code = xla_ae_journal_entry_pkg.C_INVALID
5653: WHERE xahg.ae_header_id IN (SELECT xalg.ae_header_id
5654: FROM xla_ae_lines_gt xalg
5655: WHERE xalg.balance_type_code <> 'X'
5656: AND (xalg.code_combination_status_code <> C_CREATED

Line 5664: AND xahg.accounting_entry_status_code <> xla_ae_journal_entry_pkg.C_INVALID

5660: OR xalg.alt_ccid_status_code <> C_CREATED)
5661: AND xalg.gain_or_loss_flag = 'Y' and xalg.calculate_g_l_amts_flag = 'Y'))
5662: */
5663: /* )
5664: AND xahg.accounting_entry_status_code <> xla_ae_journal_entry_pkg.C_INVALID
5665: ; */
5666:
5667: -- added bug 13023651 modified Update such that journal entries which are unable to derive ccid would be marked in error,related entries should not be marked as invalid.
5668: IF l_ccid_created > 0 THEN

Line 5671: SET xahg.accounting_entry_status_code = xla_ae_journal_entry_pkg.C_INVALID

5667: -- added bug 13023651 modified Update such that journal entries which are unable to derive ccid would be marked in error,related entries should not be marked as invalid.
5668: IF l_ccid_created > 0 THEN
5669:
5670: UPDATE xla_ae_headers_gt xahg
5671: SET xahg.accounting_entry_status_code = xla_ae_journal_entry_pkg.C_INVALID
5672: WHERE (xahg.ae_header_id , NVL(xahg.header_num,0) , xahg.balance_type_code , xahg.ledger_id ) IN (
5673: SELECT xalg.ae_header_id , NVL(xalg.header_num, 0) , xalg.balance_type_code , xalg.ledger_id
5674: FROM xla_ae_lines_gt xalg
5675: WHERE xalg.balance_type_code <> 'X'

Line 5679: AND xahg.accounting_entry_status_code <> xla_ae_journal_entry_pkg.C_INVALID

5675: WHERE xalg.balance_type_code <> 'X'
5676: AND (xalg.code_combination_status_code <> C_CREATED
5677: OR xalg.code_combination_id = -1) and (nvl(xalg.gain_or_loss_flag,'N') = 'N' or nvl (xalg.calculate_g_l_amts_flag,'N') = 'N')
5678: )
5679: AND xahg.accounting_entry_status_code <> xla_ae_journal_entry_pkg.C_INVALID
5680: ;
5681: -- end bug 13023651
5682: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
5683: