DBA Data[Home] [Help]

APPS.FV_SLA_UTL_PROCESSING_PKG dependencies on CE_GL_ACCOUNTS_CCID

Line 214: FROM ce_gl_accounts_ccid c,

210: g.chart_of_accounts_id
211: INTO l_bank_rec.cash_bank_account_ccid,
212: l_bank_rec.cash_clearing_ccid,
213: l_coaid
214: FROM ce_gl_accounts_ccid c,
215: gl_code_combinations g
216: WHERE c.bank_acct_use_id = p_bank_acct_use_id
217: AND g.code_combination_id = c.ap_asset_ccid;
218:

Line 225: stack_error (l_procedure_name, 'SELECT_ce_gl_accounts_ccid', p_error_desc);

221: fv_utility.log_mesg('Please setup confirm cash natural account in the Bank Account');
222: fv_utility.log_mesg('Clearing Cash Account field and retry.');
223: p_error_code := c_FAILURE;
224: p_error_desc := 'Confirm Cash has not been setup in the Clearing Cash Account field.';
225: stack_error (l_procedure_name, 'SELECT_ce_gl_accounts_ccid', p_error_desc);
226: trace(C_STATE_LEVEL, l_procedure_name, 'ERROR:SELECT_ce_gl_accounts_ccid:'||p_error_desc);
227: RETURN;
228: END IF;
229: EXCEPTION

Line 226: trace(C_STATE_LEVEL, l_procedure_name, 'ERROR:SELECT_ce_gl_accounts_ccid:'||p_error_desc);

222: fv_utility.log_mesg('Clearing Cash Account field and retry.');
223: p_error_code := c_FAILURE;
224: p_error_desc := 'Confirm Cash has not been setup in the Clearing Cash Account field.';
225: stack_error (l_procedure_name, 'SELECT_ce_gl_accounts_ccid', p_error_desc);
226: trace(C_STATE_LEVEL, l_procedure_name, 'ERROR:SELECT_ce_gl_accounts_ccid:'||p_error_desc);
227: RETURN;
228: END IF;
229: EXCEPTION
230: WHEN NO_DATA_FOUND THEN

Line 238: stack_error (l_procedure_name, 'SELECT_ce_gl_accounts_ccid', p_error_desc);

234: p_error_code := c_FAILURE;
235: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
236: fnd_message.set_token('MESSAGE' , 'System Error :'||SQLERRM);
237: p_error_desc := fnd_message.get;
238: stack_error (l_procedure_name, 'SELECT_ce_gl_accounts_ccid', p_error_desc);
239: trace(C_STATE_LEVEL, l_procedure_name, 'ERROR:SELECT_ce_gl_accounts_ccid:'||p_error_desc);
240: END;
241:
242: IF (p_error_code = c_SUCCESS AND l_coaid IS NOT NULL) THEN

Line 239: trace(C_STATE_LEVEL, l_procedure_name, 'ERROR:SELECT_ce_gl_accounts_ccid:'||p_error_desc);

235: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
236: fnd_message.set_token('MESSAGE' , 'System Error :'||SQLERRM);
237: p_error_desc := fnd_message.get;
238: stack_error (l_procedure_name, 'SELECT_ce_gl_accounts_ccid', p_error_desc);
239: trace(C_STATE_LEVEL, l_procedure_name, 'ERROR:SELECT_ce_gl_accounts_ccid:'||p_error_desc);
240: END;
241:
242: IF (p_error_code = c_SUCCESS AND l_coaid IS NOT NULL) THEN
243: -- Get the GL ACCOUNT segment num and name