216: WHERE c.bank_acct_use_id = p_bank_acct_use_id
217: AND g.code_combination_id = c.ap_asset_ccid;
218:
219: IF l_bank_rec.cash_clearing_ccid IS NULL THEN
220: fv_utility.log_mesg('Confirm cash account has not been setup !');
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.';
217: AND g.code_combination_id = c.ap_asset_ccid;
218:
219: IF l_bank_rec.cash_clearing_ccid IS NULL THEN
220: fv_utility.log_mesg('Confirm cash account has not been setup !');
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);
218:
219: IF l_bank_rec.cash_clearing_ccid IS NULL THEN
220: fv_utility.log_mesg('Confirm cash account has not been setup !');
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);