[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
365: FROM xla_ae_headers aeh
366: ,gl_ledgers xgl
367: ,xla_subledgers xsb
368: ,xla_ae_lines ael
369: ,gl_code_combinations gcc
370: WHERE aeh.ae_header_id = p_ae_header_id
371: AND aeh.application_id = p_application_id
372: AND aeh.balance_type_code = 'A'
373: AND aeh.accounting_entry_status_code IN ('D', 'F')
393: FROM xla_ae_headers aeh
394: ,gl_ledgers xgl
395: ,xla_subledgers xsb
396: ,xla_ae_lines ael
397: ,gl_code_combinations gcc
398: WHERE aeh.ae_header_id = p_ae_header_id
399: AND aeh.application_id = p_application_id
400: AND aeh.balance_type_code = 'A'
401: AND aeh.accounting_entry_status_code IN ('D', 'F')
496: FROM xla_ae_headers aeh
497: ,gl_ledgers xgl
498: ,xla_subledgers xsb
499: ,xla_ae_lines ael
500: ,gl_code_combinations gcc
501: WHERE aeh.event_id = p_event_id
502: AND aeh.entity_id = p_entity_id
503: AND aeh.application_id = p_application_id
504: AND aeh.balance_type_code = 'A'