[Home] [Help]
232: ;
233:
234: CURSOR c_account(p_coa_id INTEGER, p_code_combination_id INTEGER) IS
235: SELECT fnd_flex_ext.get_segs('SQLGL', 'GL#', p_coa_id, p_code_combination_id)
236: FROM dual;
237:
238: CURSOR c_errors IS
239: SELECT entity_id
240: ,event_id
3931:
3932: -- Check if the balancing segment value is valid for the ledger
3933: SELECT fnd_flex_ext.get_segs('SQLGL', 'GL#', l_err.ccid_coa_id, l_err.code_combination_id)
3934: INTO l_account
3935: FROM dual;
3936:
3937: -- 4262811---------------------------------------------------------------------------------
3938: IF g_caller = C_CALLER_MPA_PROGRAM THEN
3939: g_message_name := 'XLA_MA_INVALID_BAL_SEG';
4057:
4058: -- Check if the management segment value is valid for the ledger
4059: SELECT fnd_flex_ext.get_segs('SQLGL', 'GL#', l_err.ccid_coa_id, l_err.code_combination_id)
4060: INTO l_account
4061: FROM dual;
4062:
4063: OPEN c_coa_structure_name(l_err.ccid_coa_id);
4064: FETCH c_coa_structure_name INTO l_coa_structure_name;
4065: CLOSE c_coa_structure_name;
4693: WHERE error_flag = 'Y';
4694:
4695: CURSOR c_account(p_coa_id INTEGER, p_code_combination_id INTEGER) IS
4696: SELECT fnd_flex_ext.get_segs('SQLGL', 'GL#', p_coa_id, p_code_combination_id)
4697: FROM dual;
4698:
4699: CURSOR c_je_source_name(l_lookup_code VARCHAR2) IS
4700: SELECT meaning
4701: FROM fnd_lookups
4768: END IF;
4769:
4770: SELECT DECODE(l_ccid_substituted_flag,'Y',l_err.SUBSTITUTED_CCID,l_err.code_combination_id)
4771: INTO l_ccid
4772: FROM DUAL ;
4773:
4774: -- Bug 7541615 - Removed the validation on currency conversion information
4775: IF (g_ledger_currency_code <> l_err.entered_currency_code) THEN
4776: IF (l_err.currency_conversion_type = 'User' AND
6767: NVL(l_ref3,'N') NOT IN ( 'N','R') ) THEN
6768:
6769: SELECT fnd_flex_ext.get_segs('SQLGL', 'GL#', g_ledger_coa_id, l_rounding_ccid)
6770: INTO l_account
6771: FROM dual;
6772:
6773: xla_accounting_err_pkg.build_message(
6774: p_appli_s_name => 'XLA'
6775: ,p_msg_name => 'XLA_AP_ROUNDING_CONT_ACCT'
7113: ,p_accounting_batch_id => NULL);
7114: ELSIF (l_err.error_code = 'FUN_INTRA_CC_NOT_VALID') THEN
7115: SELECT fnd_flex_ext.get_segs('SQLGL', 'GL#', g_ledger_coa_id, l_err.ccid)
7116: INTO l_account
7117: FROM dual;
7118:
7119: xla_accounting_err_pkg.build_message(
7120: p_appli_s_name => 'XLA'
7121: ,p_msg_name => 'XLA_INTRA_CC_NOT_VALID'
7139: ,p_accounting_batch_id => NULL);
7140: ELSIF (l_err.error_code = 'FUN_INTRA_CC_NOT_ACTIVE') THEN
7141: SELECT fnd_flex_ext.get_segs('SQLGL', 'GL#', g_ledger_coa_id, l_err.ccid)
7142: INTO l_account
7143: FROM dual;
7144:
7145: xla_accounting_err_pkg.build_message(
7146: p_appli_s_name => 'XLA'
7147: ,p_msg_name => 'XLA_INTRA_CC_NOT_ACTIVE'