358: SELECT f.dit_flag,
359: f.dit_confirm_cash_account
360: INTO l_org_rec.dit_flag,
361: l_org_rec.cash_account
362: FROM fv_operating_units_all f
363: WHERE org_id = p_org_id;
364: EXCEPTION
365: WHEN NO_DATA_FOUND THEN
366: l_org_rec.dit_flag := NULL;
369: p_error_code := c_FAILURE;
370: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
371: fnd_message.set_token('MESSAGE' , 'System Error :'||SQLERRM);
372: p_error_desc := fnd_message.get;
373: stack_error (l_procedure_name, 'SELECT_fv_operating_units_all', p_error_desc);
374: trace(C_STATE_LEVEL, l_procedure_name, 'ERROR:SELECT_fv_operating_units_all:'||p_error_desc);
375: END;
376: IF (p_error_code = c_SUCCESS) THEN
377: g_org_tab(p_org_id) := l_org_rec;
370: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
371: fnd_message.set_token('MESSAGE' , 'System Error :'||SQLERRM);
372: p_error_desc := fnd_message.get;
373: stack_error (l_procedure_name, 'SELECT_fv_operating_units_all', p_error_desc);
374: trace(C_STATE_LEVEL, l_procedure_name, 'ERROR:SELECT_fv_operating_units_all:'||p_error_desc);
375: END;
376: IF (p_error_code = c_SUCCESS) THEN
377: g_org_tab(p_org_id) := l_org_rec;
378: END IF;