[Home] [Help]
165: THEN
166: BEGIN
167: SELECT gcc.reference3
168: INTO l_qualifier_value
169: FROM gl_code_combinations gcc
170: WHERE gcc.code_combination_id = p_code_combination_id;
171: EXCEPTION
172: WHEN NO_DATA_FOUND THEN
173: IF (C_LEVEL_EXCEPTION >= g_log_level) THEN
174: trace
175: ( p_module => l_log_module
176: ,p_msg => 'EXCEPTION: ' ||
177: 'Code combination id '||p_code_combination_id ||
178: ' not found. in the table gl_code_combinations'
179: ,p_level => C_LEVEL_EXCEPTION
180: );
181: END IF;
182: xla_exceptions_pkg.raise_message
183: ('XLA'
184: ,'XLA_COMMON_ERROR'
185: ,'ERROR'
186: ,'Code combination id '||p_code_combination_id || ' not found.'
187: || ' in the table gl_code_combinations'
188: ,'LOCATION'
189: ,'xla_control_accounts_pkg.is_control_account');
190: WHEN OTHERS THEN
191: xla_exceptions_pkg.raise_message
366: FROM xla_ae_headers aeh
367: ,gl_ledgers xgl
368: ,xla_subledgers xsb
369: ,xla_ae_lines ael
370: ,gl_code_combinations gcc
371: WHERE aeh.ae_header_id = p_ae_header_id
372: AND aeh.application_id = p_application_id
373: AND aeh.balance_type_code = 'A'
374: AND aeh.accounting_entry_status_code IN ('D', 'F')
394: FROM xla_ae_headers aeh
395: ,gl_ledgers xgl
396: ,xla_subledgers xsb
397: ,xla_ae_lines ael
398: ,gl_code_combinations gcc
399: WHERE aeh.ae_header_id = p_ae_header_id
400: AND aeh.application_id = p_application_id
401: AND aeh.balance_type_code = 'A'
402: AND aeh.accounting_entry_status_code IN ('D', 'F')
497: FROM xla_ae_headers aeh
498: ,gl_ledgers xgl
499: ,xla_subledgers xsb
500: ,xla_ae_lines ael
501: ,gl_code_combinations gcc
502: WHERE aeh.event_id = p_event_id
503: AND aeh.entity_id = p_entity_id
504: AND aeh.application_id = p_application_id
505: AND aeh.balance_type_code = 'A'